Results 1 to 3 of 3

Thread: Trace in Oracle

  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Unanswered: Trace in Oracle

    Hi

    I wanted to know what the trace feature that is available in Oracle, really is.
    Any links or leads which explains the use and the use-how would be sufficient.

    Thanx and Regards
    Aruneesh

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    You asked for some links.... there's about 175,000 on here...

    http://www.google.com/search?hl=en&i...q=oracle+trace

    Hth
    Bill

  3. #3
    Join Date
    Sep 2003
    Location
    Chennai
    Posts
    2
    Trace Function in oracle is a dba's option from which u can find out the number of physical read happening when u run the query and also u can find out the indexes what it is using for fetching the Row

    set autotrace on

Posting Permissions

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