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
Greeting
Diego Cutrone
|