| 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.
|
|
|
|
| Re: Execution stats shown on Toad [message #65848 is a reply to message #65847] |
Wed, 12 January 2005 00:03  |
Frank Naude
Messages: 4587
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
