OraFAQ Forum: Server Administration » To find which session has high usage for a specific database

Home » RDBMS Server » Server Administration » To find which session has high usage for a specific database (oracle 10g)

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

To find which session has high usage for a specific database [message #349124]

Fri, 19 September 2008 00:11

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi guys,
Is there is any possible to find out that which session connected to the database either as JDBC or through oracle process a high usage individually , if its possible can anyone pls guide for the above said

Thanks in advance

Report message to a moderator

Re: To find which session has high usage for a specific database [message #349125 is a reply to message #349124]

Fri, 19 September 2008 00:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

query v$session

Report message to a moderator

Re: To find which session has high usage for a specific database [message #349469 is a reply to message #349125]

Mon, 22 September 2008 00:22

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

hi,

select * from v$session

The above query gives the number of users which have been logged in
but i need from these users which connection has been taken high memory usage individually ,why because in our local DB the memory always gets overlimited , I think so some connections either JDBC or through oracle uses more memory so i need to find it, can any one pls guide over this

Thanks,

Report message to a moderator

Re: To find which session has high usage for a specific database [message #349487 is a reply to message #349469]

Mon, 22 September 2008 01:26

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

v$sesstat search for statistics 'session pga memory%' (name in v$statname).

Regards
Michel

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350738 is a reply to message #349487]

Fri, 26 September 2008 01:46

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
In our local db the oracle consumes more CPU usage it shows about 95% of the usage,
As of previous messages i think so some users connected to the database consumes more memory due to this the DB gets very slow and all the process have heen hanged out ,

Our system requirement,
RAM -6GB ,hard disk -450,and its a linux4.5 machine
once i restart and saw the memory usage it shows 5GB free and once the users starts to connect frequently the memory gets reduced to Zero(0),this happens onces when the oracle process starts
so what could be the reason for this ,whether OS problem or problem happens on oracle connections ,i could not able to find from which side the issue arises ,is there any way to find if means can anyone help on this

Thanks,

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350745 is a reply to message #350738]

Fri, 26 September 2008 02:14

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do they properly disconnect?

Regards
Michel

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350748 is a reply to message #350745]

Fri, 26 September 2008 02:21

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,

But after restarting the db all the process will be stopped know , I could able to see it even after restarting

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350752 is a reply to message #350748]

Fri, 26 September 2008 02:29

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which kind of shutdown/startup do you make?

Regards
Michel

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350762 is a reply to message #350752]

Fri, 26 September 2008 04:39

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Simply i have rebooted it , but even when they start the application server connected to oracle backend some user process more memory

Thanks,

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350772 is a reply to message #350762]

Fri, 26 September 2008 05:27

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What did you exactly do?

Quote:

But after restarting the db all the process will be stopped know , I could able to see it even after restarting

Quote:

Simply i have rebooted it

What is "it"? db or server?
If db, what is reboot db? I only know "shutdown" and "startup", "reboot" is not an Oracle command.

Regards
Michel

[Updated on: Fri, 26 September 2008 05:27]

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350790 is a reply to message #350772]

Fri, 26 September 2008 06:28

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

It means i am rebooting the machine itself

Thanks,

Report message to a moderator

Re: To find which session has high usage for a specific database [message #350797 is a reply to message #350790]

Fri, 26 September 2008 06:50

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How could you see the process after you restart? A process can't survive to a reboot.

Regards
Michel

[Updated on: Fri, 26 September 2008 06:51]

Report message to a moderator

Previous Topic:	what is clod storage
Next Topic:	reg database UPGRADE...!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 01:21:46 CDT 2024