OraFAQ Forum: Server Administration » Session Memory Usage

Home » RDBMS Server » Server Administration » Session Memory Usage

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

Session Memory Usage [message #272249]

Thu, 04 October 2007 05:42

smunir362
Messages: 310
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

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

Senior Member
Account Moderator

v$sesstat

Regards
Michel

Report message to a moderator

Re: Session Memory Usage [message #272259 is a reply to message #272254]

Thu, 04 October 2007 06:01

smunir362
Messages: 310
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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Session Memory Usage [message #272739 is a reply to message #272249]

Sat, 06 October 2007 22:54

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

query from v$sesstat and v$session

Report message to a moderator

Re: Session Memory Usage [message #273244 is a reply to message #272739]

Tue, 09 October 2007 12:39

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:24:00 CDT 2024