Home » RDBMS Server » Server Administration » To find which session has high usage for a specific database (oracle 10g)
To find which session has high usage for a specific database [message #349124] Fri, 19 September 2008 00:11 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
query v$session
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 Go to previous messageGo to next message
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,
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
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 Go to previous messageGo to next message
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,


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 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do they properly disconnect?

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which kind of shutdown/startup do you make?

Regards
Michel
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 Go to previous messageGo to next message
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,
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member

It means i am rebooting the machine itself

Thanks,
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 Go to previous message
Michel Cadot
Messages: 68704
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:
  


Current Time: Sat Nov 02 12:20:08 CDT 2024