DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: log select statements

  1. 02-26-2003, 07:58 AM #1
    tosahil
    tosahil is offline Junior Member
    Join Date
    Feb 2003
    Posts
    14

    log select statements

    I want to create list of all SQL statements[including select] issued by one user. This is an application user and used to issue hell lot of statements.

    I cant enable TRACE as it will be a big overload.

    Is there any better way to do?

    Thanks in advance.

    Sahil Patel
    Reply With Quote Reply With Quote
  2. 02-28-2003, 07:10 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    well it will be a big overload ..Hmm nope the answer is not at all.You enable tracing only for the duration of the problem when you suspect that the user is issuing those statements..

    You should seriously check out sys.dbms_SYSTEM.set_sql_trace_in_sessio
    only for that duration and turn it off

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width