Home » Infrastructure » Unix » Oracle memory usage in Unix
Oracle memory usage in Unix [message #367007] Fri, 12 May 2000 12:25 Go to next message
dshore
Messages: 4
Registered: May 2000
Junior Member
I am looking for some Unix command that will show memory usage. I have an HP9000 running UX 10.20 Oracle 7.3.4.4.1. I've tried glanceplus but I can't get the detail I want. I look at the output given when I start my Oracle instances displaying SGA sizes. I can't find anything on the Unix side that shows me how much memory each Oracle instance is using and what processes are using what memory.
Can anyone help me out?
Re: Oracle memory usage in Unix [message #367009 is a reply to message #367007] Mon, 22 May 2000 13:05 Go to previous messageGo to next message
MarkJ
Messages: 17
Registered: July 1999
Junior Member
why not just go into sqlplus and type "show sga"? is that too summary for your reporting needs? let me know.
Re: Oracle memory usage in Unix [message #367014 is a reply to message #367009] Tue, 20 June 2000 16:18 Go to previous messageGo to next message
dshore
Messages: 4
Registered: May 2000
Junior Member
Since I have more than one Oracle instance I was hoping to get some kind of Unix command or application that would show me how much memory I have on my machine and how much each instance is using.
Re: Oracle memory usage in Unix [message #367016 is a reply to message #367009] Thu, 22 June 2000 05:17 Go to previous messageGo to next message
Pete Shaw
Messages: 4
Registered: June 2000
Junior Member
I not sure if this is what you are looking for but the 'ipcs -mb' command will show the shared memory segments that Oracle is using for each instance and the following command lists all processes (background and user, with their sizes) for each instance..
ps -ef -o user,rss,args|grep oracle|pg

hope this helps.

Pete.
Re: Oracle memory usage in Unix [message #367032 is a reply to message #367009] Wed, 16 August 2000 08:09 Go to previous message
Dennis Corning
Messages: 1
Registered: August 2000
Junior Member
We offer a solution to answer your questions plus more.

Please e-mail me and I will have the appropriate person contact you.

Regards,

Dennis
Previous Topic: Getting Oracle 8.x on Solaris to send e-mails via MS Exhange
Next Topic: Sql plus doesn't start up
Goto Forum:
  


Current Time: Fri Mar 29 04:05:39 CDT 2024