0

Our Oracle server continues with out of memory problem, and we don't have an Oracle DBA in our team. Is there any Oracle monitor tool or ways to find the reason?

We have a lot of stored procedure running by Oracle jobs, we thought may be the reason but not very sure about it.

Oracle run in Red hat Linux.When it is out of memory. Enter free -m, it can seen there is almost nothing left in free space and or has been used.

enter image description here

I mean out of memory is that when i try to shutdown oracle, it return Out of memroy as shown below.

enter image description here

Any idea?

Improve this question
8
  • What do you mean by "out of memory" problem? Are you getting (a) certain error(s), and if so, which one(s)? Which OS? Do you have access to the server at OS level, or just via Oracle sessions? You'll need to add more information -- as it stands this question runs the risk of being closed as "Unclear what you are asking".
    – Colin 't Hart
    Commented Aug 25, 2014 at 10:57
  • Our server is linux.
    – snow8261
    Commented Aug 26, 2014 at 1:47
  • 3
    You received the above error, because you connected to "nothing" (Connected to idle instance.), and not to the database. Set the environment variables (especially ORACLE_SID) properly. For understanding the output of free -m, I recommend this site: linuxatemyram.com . That alone is not a problem. So what is your ACTUAL problem? Is the application/database slow? Do you encounter any errors in the application? Does the database crash any time?
    – Balazs Papp
    Commented Aug 26, 2014 at 11:08
  • Your free -m is showing 2.4Gb free. Do you understand @Balazs's comment above? Read this too, and consider employing an Oracle DBA.
    – Jack Douglas
    Commented Aug 26, 2014 at 12:45
  • @BalazsPapp At that moment,the server is very very slow and our application is already dead.I have to kill oracle process,and then became fast.
    – snow8261
    Commented Aug 26, 2014 at 13:00

3 Answers 3

Reset to default
1

Depending on what you mean by "Oracle Server", if you are trying to monitor physical (or virtual) server level statistics, you can make use of OSWatcher.

http://docs.oracle.com/cd/E37670_01/E37355/html/ol_oswatcher_diag.html

Note that this is really just a wrapper of stuff that should be available on any *nix type server. It will format outputs and produce readable graphs for you.

If you're actually saying that your Oracle Database instance(s) is/are running out of memory, then I highly recommend statspack and an independent Enterprise Manager solution, for ease of use especially since you state that you don't currently have a DBA on your team. Your comment above doesn't provide enough context for me to start troubleshooting that type of issue.

Improve this answer
1
  • is statspack same as awr?
    – snow8261
    Commented Aug 26, 2014 at 2:16
0

if you have oracle Diagnostic and/or Tuning pack you can use some of these advisors, eg. by Oracle Enterprise Manager:

Diagnostics Pack: Performance (tab) ADDM

Tuning Pack: SQL Access Advisor SQL Tuning Advisor

You can check this by running:

show parameter CONTROL_MANAGEMENT_PACK_ACCESS;

Some useful summary of advisors: http://www.dba-oracle.com/t_advanced_advisor_central_addm.htm

Improve this answer
1
  • 1
    NB Both the Diagnostics Pack and Tuning Pack require licenses to use them. If your team doesn't have a DBA, it's highly likely your organisation doesn't have licenses for these packs either.
    – Colin 't Hart
    Commented Aug 26, 2014 at 12:12
-2

You have to increase the RAM size and the increase the SGA parameters.

I would suggest you to go through OTN: https://community.oracle.com/thread/2324835?tstart=0

Improve this answer
1
  • 1
    Please explain how you get to that conclusion from the information provided. I'm not saying you're wrong, but as it is this is basically a comment, not an answer.
    – Colin 't Hart
    Commented Aug 26, 2014 at 11:15

Not the answer you're looking for? Browse other questions tagged or ask your own question.