Hi List.
does anybody know what the OPTIMIZER_MODE = NONE
mean in v$sqlarea view ?
I've found this document Doc ID: 48131.996 in
metalink, but it seems that I don't have access to it.
The problem I'm facing here is that I am getting this
information when analyzing v$sqlarea. What I'm trying
to
find out is why suddenly at sequence 5 disk_reads=0
and buffer_gets=0.
SEQ Address hash_value OPT_MOD FIRST_LOAD_TIME
Disk_reads Buff_gets Invalidations loads
-------------------------------------------------------------------------------------------------------------------------------------------------------------
1 C�� 1069627 NONE 2002-08-28/14:23:58 0
0 0 1
2 C�� 1069627 CHOOSE 2002-08-28/14:23:58 10
166 0 2
3 C�� 1069627 CHOOSE 2002-08-28/14:23:58 14
177 0 2
4 C�� 1069627 CHOOSE 2002-08-28/14:23:58 14
177 0 2
5 C�� 1069627 NONE 2002-08-28/14:23:58 0
0 0 2
6 C�� 1069627 CHOOSE 2002-08-28/16:16:13 10
246 0 2
The Seq value represents occurrences taken at
different moments along a day.
Seq 1 was taken at 9 am in the morning, seq 2 at 9:30
, and so on...
TIA
_______________________________________________________________
Yahoo! Messenger
Nueva versi�n: Webcam, voz, y mucho m�s �Gratis!
Desc�rgalo ya desde http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
