SQL> Set autotrace on; SP2-0613: Unable to verify Plan_Table format or entity SP2-0611: Error when enabling Explain report
Execute UTLXPLAN.SQL under $ oracle_home / rdbms / admin
SQL> @f: /oracle/ora92/rdbms/admin/utlxplan.sql
The table has been created.
SQL> SET Autotrace On; SQL> SELECT * FROM V $ Instance;
Instance_number instance_name ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------- Version Startup_ti STATUS PAR THREAD # archive log_switch _-------------------------------------- --- - ------------------------- logins shu database_status instance_role activ_st ---------- ---------- ---------------------------- --------- 1 ncdbpxkjc039.2.0.5.0 14- March -05 Open no 1 startedallowed no active primary_instance normal
Execution Plan ------------------------------------------------ ---------- 0 Select Statement Optimizer = choose 1 0 Nested Loops 2 1 Nested Loops 3 2 fixed table (full) of 'x $ quiesce' 4 2 fixed table (full) of 'x $ kVIT' 5 1 Fixed Table (Full) of 'x $ ksuxsinst'
Statistics --------------------------------------------------- -------- 0 Recursive Calls 0 DB Block Gets 0 Consistent Gets 0 Physical Reads 0 Redo Size 1295 BYTES SENT VIA SQL * NET To Client 503 BYtes Received Via SQL * Net from Client 2 SQL * Net RoundTrips To / From Client 0 Sorts (Memory) 0 Sorts (Disk) 1 ROWS Processed
