I know it is not usual, but because ASCII version of the note looked very ugly, I decided to attach HTML. You can start with stoning as soon as I say "Jehova". On 2003.07.31 17:44, [EMAIL PROTECTED] wrote:
What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle 9i. What is the unit for it? Strangely, the Oracle 9i "Server Reference" manual seems to have missed this altogether.
I executed a query, the execution time of which was approximately 9 seconds. But when I look up v$sqlarea, the elapsed time is shown as 820802.
Thanks Raj
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Mladen Gogala Oracle DBA
Bookmark | Go to End |
"V$SQL" Reference Note
- The information here contains the view description from the Oracle9i documentation along with any additional Support / Historical Notes related to this view.
- Earlier versions of Oracle may not include all columns. to see Documentation references for this view
Oracle9i Information
-
This view lists statistics on shared SQL area without the
GROUP BY
clause and contains one row for each child of the original SQL text entered.
Support and Historical Notes for "V$SQL"
View Definition:
Use the following SQL to see the view definition of the related GV$ view:
SELECT view_definition FROM v$fixed_view_definition
WHERE view_name='GV$SQL';
Useful Join Columns:
( ADDRESS,HASH_VALUE ) - Join to <View:V$SQLTEXT> . ( ADDRESS,HASH_VALUE )
Support Notes:
This view shows one row for each version of each SQL statement.
See <View:V$SQLAREA>
for an aggregated view which groups all versions
of the same SQL statement together.
When monitoring performance it can be beneficial to use this view
rather then V$SQLAREA if looking at only a subset of statements in the
shared pool.
Known Issues:
Articles:
.