login as: oraprod oraprod@192.168.3.8's password: Last login: Mon May 12 04:50:10 2008 from trainee1.parazelsus.pk [oraprod@dbprod ~]$ sqlplus scott/tiger SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 13 23:44:24 2008 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> conn sys/sys as sysdba Connected. SQL> grant alter session to scott 2 / Grant succeeded. SQL> conn scott/tiger Connected. SQL> set linesize 1000 SQL> alter session set sql_trace=true 2 / Session altered. SQL> select * from emp 2 / EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ------------------------------ --------------------------- ---------- --------------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 12-JAN-83 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 14 rows selected. SQL> alter session set sql_trace=false 2 / Session altered. SQL> disconnect Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> exit [oraprod@dbprod ~]$ cd /orahome/PROD/db/tech_st/10.2.0/admin/PROD_dbprod/udump [oraprod@dbprod udump]$ ls -lrt total 8928 . . . . -rw-r--r-- 1 oraprod dba 845 Apr 15 17:53 prod_ora_4267.trc -rw-r----- 1 oraprod dba 689 Apr 15 19:54 prod_ora_28473.trc -rw-r--r-- 1 oraprod dba 718 Apr 15 19:54 prod_ora_28499.trc -rw-r--r-- 1 oraprod dba 827 Apr 15 21:55 prod_ora_30662.trc -rw-r--r-- 1 oraprod dba 4471139 Apr 16 22:51 prod_ora_24132.trc -rw-r--r-- 1 oraprod dba 718 Apr 16 22:51 prod_ora_24610.trc -rw-r----- 1 oraprod dba 661 Apr 16 22:51 prod_ora_24586.trc -rw-r--r-- 1 oraprod dba 986 Apr 16 22:52 prod_ora_24612.trc -rw-r----- 1 oraprod dba 659 Apr 17 10:51 prod_ora_2315.trc -rw-r--r-- 1 oraprod dba 716 Apr 17 10:51 prod_ora_2339.trc -rw-r--r-- 1 oraprod dba 782 Apr 17 10:51 prod_ora_2341.trc -rw-r--r-- 1 oraprod dba 845 Apr 17 14:19 prod_ora_6153.trc -rw-r----- 1 oraprod dba 661 May 8 07:13 prod_ora_27379.trc -rw-r--r-- 1 oraprod dba 718 May 8 07:13 prod_ora_27403.trc -rw-r--r-- 1 oraprod dba 784 May 8 07:13 prod_ora_27405.trc -rw-r--r-- 1 oraprod dba 27354 May 13 23:46 prod_ora_4613.trc [oraprod@dbprod udump]$ tkprof prod_ora_4613.trc prod_ora_4613.txt explain=scott/tiger sys=no TKPROF: Release 10.2.0.2.0 - Production on Tue May 13 23:48:25 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. [oraprod@dbprod udump]$ ls -lrt total 8936 . . . . -rw-r----- 1 oraprod dba 661 Apr 16 22:51 prod_ora_24586.trc -rw-r--r-- 1 oraprod dba 986 Apr 16 22:52 prod_ora_24612.trc -rw-r----- 1 oraprod dba 659 Apr 17 10:51 prod_ora_2315.trc -rw-r--r-- 1 oraprod dba 716 Apr 17 10:51 prod_ora_2339.trc -rw-r--r-- 1 oraprod dba 782 Apr 17 10:51 prod_ora_2341.trc -rw-r--r-- 1 oraprod dba 845 Apr 17 14:19 prod_ora_6153.trc -rw-r----- 1 oraprod dba 661 May 8 07:13 prod_ora_27379.trc -rw-r--r-- 1 oraprod dba 718 May 8 07:13 prod_ora_27403.trc -rw-r--r-- 1 oraprod dba 784 May 8 07:13 prod_ora_27405.trc -rw-r--r-- 1 oraprod dba 27354 May 13 23:46 prod_ora_4613.trc -rw-r--r-- 1 oraprod dba 7245 May 13 23:48 prod_ora_4613.txt [oraprod@dbprod udump]$ vi prod_ora_4613.txt
Wednesday, May 14, 2008
How to run trace?
Subscribe to:
Post Comments (Atom)
2 comments:
how to recover a table of a user using rman???????/
how to take backup of a user using rman???
Post a Comment