| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 9.0.1.0.0 and the indexes ...
run
switch on tracing or follow the explain plan in the instance manager for
the named sessions
exec dbms_system.set_sql_trace_in_session (sid#, serial#, true);
sid# and serial# can be obtained from v$session
or switch tracing on instancewide
switch it off by setting false
did you stat packs? or analyzed the schema ?
forcing indexes can be done using select /* hints here write the index'
name */ from ... where ...
but it is no highly recommended
-- Posted via http://dbforums.comReceived on Mon Jun 16 2003 - 06:32:49 CDT
 |
 |