Home » RDBMS Server » Performance Tuning » Execution stats shown on Toad
Execution stats shown on Toad [message #65847] Tue, 11 January 2005 22:12 Go to next message
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.
Re: Execution stats shown on Toad [message #65848 is a reply to message #65847] Wed, 12 January 2005 00:03 Go to previous messageGo to next message
Frank Naude
Messages: 4565
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
Re: Execution stats shown on Toad [message #65849 is a reply to message #65848] Wed, 12 January 2005 02:26 Go to previous message
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
Member
Hello Frank, thanks very much for your reply.
Previous Topic: Tune SGA urgent
Next Topic: experience on solid state disks
Goto Forum:
  


Current Time: Tue Sep 29 07:06:32 CDT 2020