Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Unanswered: tkprof convert it partially

    Hi,


    I am trying to convert the trace file into readable format. i am using the tkprof utility...it seems to me that its not converting full file.
    for example . i have trace file which is 782mb when i converted it into the txt file by using tkprof its convert it partially...Please suggest.

    [oracle@rac2-pub trace]$ tkprof comdb2_ora_22538.trc comdb2_ora_22538.txt
    [oracle@rac2-pub trace]$ ls -ltrh | grep comdb2_ora_22538.txt
    -rw-r--r-- 1 oracle oinstall 1.2K Jul 1 14:24 comdb2_ora_22538.txt

    [oracle@rac2-pub trace]$ ls -ltrh | grep comdb2_ora_22538.trc
    -rw-r----- 1 oracle asmadmin 782M Jun 30 09:23 comdb2_ora_22538.trc


    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    PL/SQL Release 11.2.0.2.0 - Production
    "CORE 11.2.0.2.0 Production"
    TNS for Linux: Version 11.2.0.2.0 - Production
    NLSRTL Version 11.2.0.2.0 - Production

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what is content of comdb2_ora_22538.txt?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    i am trying to find out why its generating very large trace files....

    and after converting in txt file it just shows partial header information.....

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    One can trace any session. in order for TKPROF to provide meaningful results the SQL must start after tracing has begun & complete before tracing is terminated.

    A complete SQL statement (start to finish) must exist within trace file for TKPROF to be able to accurately what occurred when it ran.

    You have said NOTHING regarding what is initiating the trace file or why they even exist.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    Thanks... i was just picking the traces from trace file location and try to tkprof to see what is causing....

    cd /u01/app/oracle/diag/rdbms/comdb/comdb1/trace

    the system was generating a traces which is GBs and MBs last night. there was no space left in the /u01. which caused the node2 to be down this morning...how to figure out these situations...how to resolve these issues. from where i have to start...Please suggest...thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    trace files do NOT spontaneously start appearing.
    some overt command was issued to start this changed behavior.

    Somebody who has DBA access start this & you need to find out who, why & what was done.

    >tkprof comdb2_ora_22538.trc

    22538 is the OS Process ID (PID) that is generating this file.
    You can use OS PID to determine which Oracle Session ID (SID)
    Once you SID you ca see what SQL is being traced.
    Last edited by anacedent; 07-01-14 at 23:35.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    this will help. Thanks

  8. #8
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    hello anacedent...is there a query to find out trace is enabled on this session or programe...Please advise...

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >is there a query to find out trace is enabled on this session or programe...Please advise...

    http://hoopercharles.wordpress.com/2...-what-you-get/
    Last edited by anacedent; 07-02-14 at 16:24.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> select sql_trace, count(*) from v$session group by sql_trace order by 1;
    
    SQL_TRAC   COUNT(*)
    -------- ----------
    DISABLED         30
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •