OraFAQ Forum: Unix » Oracle memory usage in Unix

Home » Infrastructure » Unix » Oracle memory usage in Unix

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle memory usage in Unix [message #367007]

Fri, 12 May 2000 12:25

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?

Report message to a moderator

Re: Oracle memory usage in Unix [message #367009 is a reply to message #367007]

Mon, 22 May 2000 13:05

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.

Report message to a moderator

Re: Oracle memory usage in Unix [message #367014 is a reply to message #367009]

Tue, 20 June 2000 16:18

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.

Report message to a moderator

Re: Oracle memory usage in Unix [message #367016 is a reply to message #367009]

Thu, 22 June 2000 05:17

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.

Report message to a moderator

Re: Oracle memory usage in Unix [message #367032 is a reply to message #367009]

Wed, 16 August 2000 08:09

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:01:15 CST 2024