Results 1 to 2 of 2

Thread: Query tuning

  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Unanswered: Query tuning

    Hi friends,

    I cant "set autot on", it shows plustrace role is enabled...then how can i view the explain plan in sqlplus

  2. #2
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    Quote Originally Posted by sumathiwhale View Post
    then how can i view the explain plan in sqlplus
    Use EXPLAIN PLAN

    http://docs.oracle.com/cd/E11882_01/...0.htm#i2061796

Posting Permissions

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