OraFAQ Forum: Performance Tuning » Execution stats shown on Toad

Home » RDBMS Server » Performance Tuning » Execution stats shown on Toad

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

Execution stats shown on Toad [message #65847]

Tue, 11 January 2005 22:12

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Hello,
When i run up Toad, select Tuning and look up the Execution Stats for some SQL that was running there's four values i'm not sure about? :-
Persistent memory 1424
Sharable memory 13828
Runtime memory 2180
Users opening 0
What do the figures mean (does 2180 mean milliseconds)?
Thanks.

Report message to a moderator

Re: Execution stats shown on Toad [message #65848 is a reply to message #65847]

Wed, 12 January 2005 00:03

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

As per the Oracle Reference Guide (description of V$SQL):

SHARABLE_MEM - Amount of shared memory used by the child cursor (in bytes)

PERSISTENT_MEM - Fixed amount of memory used for the lifetime of the child cursor (in bytes)

RUNTIME_MEM - Fixed amount of memory required during the execution of the child cursor

USERS_OPENING - Number of users executing the statement

Best regards.

Frank

Report message to a moderator

Re: Execution stats shown on Toad [message #65849 is a reply to message #65848]

Wed, 12 January 2005 02:26

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Hello Frank, thanks very much for your reply.

Report message to a moderator

Previous Topic:	Tune SGA urgent
Next Topic:	experience on solid state disks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 10:45:14 CDT 2025