sqltrace

I am using oracle 11g in linux

my tkprof is not working

I already did
alter session set sql_trace on ;

rw-r----- 1 oracle oinstall   124 Sep 27 10:42 post_ora_3411.trm
-rw-r----- 1 oracle oinstall  2705 Sep 27 10:42 post_ora_3411.trc
[oracle@newmac trace]$ gedit post_ora_3411.trc
[oracle@newmac trace]$ pwd
/oracle/app/oracle/diag/rdbms/post/post/trace
[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_3411.trc /home/oracle/Desktop/new.txt
bash: tkprof: command not found
[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_3411.trc /home/oracle/Desktop/new.txt
bash: tkprof: command not found
[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_3411.trc /home/oracle/Desktop/new.txt
bash: tkprof: command not found
[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_3411.trc /home/oracle/Desktop/new.txt
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>bash: tkprof: command not found

This goes to your previous questions about PATH.

Is your PATH set up properly?

is tkprof in $ORACLE_HOME/bin?

ls -al $ORACLE_HOME/bin/tkprof
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jcob_lAuthor Commented:
Fine ,

It is resolved..


[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_3411.trc /home/oracle/Desktop/new.txt

TKPROF: Release 11.2.0.1.0 - Development on Fri Sep 27 11:41:25 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


[oracle@newmac trace]$ tkprof /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_3411.trc /home/oracle/Desktop/new1.txt

TKPROF: Release 11.2.0.1.0 - Development on Fri Sep 27 11:41:43 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


[oracle@newmac trace]$



new1.txt



TKPROF: Release 11.2.0.1.0 - Development on Fri Sep 27 11:41:43 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Trace file: /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_3411.trc
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************

SQL ID: 4tk6t8tfsfqbf
Plan Hash: 0
alter session set sql_trace=true


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.04          0          0          0           0
Execute      2      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.04          0          0          0           0

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
********************************************************************************

SQL ID: ggqns3c1jz86c
Plan Hash: 3956160932
select *
from
 scott.emp


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.24          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0          8          0          14
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.00       0.24          0          8          0          14

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS

Rows     Row Source Operation
-------  ---------------------------------------------------
     14  TABLE ACCESS FULL EMP (cr=8 pr=0 pw=0 time=0 us cost=3 size=532 card=14)

********************************************************************************

SQL ID: aam2chsgpj7mb
Plan Hash: 0
alter session set sql_trace=false


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.00          0          0          0           0

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS



********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        3      0.00       0.29          0          0          0           0
Execute      4      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0          8          0          14
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        9      0.00       0.29          0          8          0          14

Misses in library cache during parse: 3
Misses in library cache during execute: 1


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        0      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0

    4  user  SQL statements in session.
    0  internal SQL statements in session.
    4  SQL statements in session.
********************************************************************************
Trace file: /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_3411.trc
Trace file compatibility: 11.1.0.7
Sort options: default

       1  session in tracefile.
       4  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       4  SQL statements in trace file.
       3  unique SQL statements in trace file.
      57  lines in trace file.
     163  elapsed seconds in trace file.
0
jcob_lAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.