Oracle_Dba

Hi  To unistall 11g Client from Windown 7. open CMD with ADMIN priviledge then navigate to C:\app\product\11.2.0\client_1\deinstall>deinstall.bat Sit relaxed and below will be the O/p and the Un installation will complete. Checking for required files and bootstrapping ... Please wait ... 14 File(s) copied 792 File(s) copied         1 file(s) copied.         1 file(s) copied. Location of logs C:\Users\svc-OR~1\AppData\Local\Temp\OraDeinstall2012-06-29_0-2 2-49\logs\ ############ ORACLE DEINSTALL & DECONFIG TOOL START ############ ######################## CHECK OPERATION START ######################## Install check configuration START Checking for existence of the Oracle home location C:\app\product\ 11.2.0\client_1 Oracle Home type selected for de-install is: CLIENT Oracle Base selected for de-install is: C:\app\ghufran Checking for existence of central inventory location C:\Program Files (x86)\Orac le\Inventory Install check configuration END Checking Windows and .NET pro

There is two way for achieving it. A. 1. set autotrace traceonly   then run the SQL SCRIPT 2. set autotrace on 3. set autotrace off (to Turn Tracing off) B . EXPLAIN PLAN FOR and the sql script Then you have to query PLAN_TABLE SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());