Home » RDBMS Server » Server Administration » Session Memory Usage
Session Memory Usage [message #272249] Thu, 04 October 2007 05:42 Go to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
How can we calculate that what memory is used by session to session e.g.

USERNAME Memory_used
SCOTT 3MB
SYSTEM 4MB
CTXSYS 5MB
DBSNMP 7MB
TEST 5MB
.
.
..

tell me its query because I want to use in on SQL Prompt.

[mod-edit] illiterate IM speak removed.

[Updated on: Thu, 04 October 2007 07:43] by Moderator

Report message to a moderator

Re: Session Memory Usage [message #272254 is a reply to message #272249] Thu, 04 October 2007 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sesstat

Regards
Michel
Re: Session Memory Usage [message #272259 is a reply to message #272254] Thu, 04 October 2007 06:01 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
Yes.
But if send me the exact query .......

[mod-edit] removed illiterate IM speak.

[Updated on: Thu, 04 October 2007 07:44] by Moderator

Report message to a moderator

Re: Session Memory Usage [message #272266 is a reply to message #272259] Thu, 04 October 2007 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But if you checked by yourself you'd learn more instead of always waiting for someone to make it for you.

Regards
Michel
Re: Session Memory Usage [message #272739 is a reply to message #272249] Sat, 06 October 2007 22:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

query from v$sesstat and v$session
Re: Session Memory Usage [message #273244 is a reply to message #272739] Tue, 09 October 2007 12:39 Go to previous message
OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico
Junior Member
You'll need to isolate the stat for memory usage, query also V$STATNAME.

Regards

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:39] by Moderator

Report message to a moderator

Previous Topic: size of segments
Next Topic: Why do they know about the space of leaf block?
Goto Forum:
  


Current Time: Sat Dec 10 10:37:52 CST 2016

Total time taken to generate the page: 0.23930 seconds