jump to navigation

Autotrace in SQLPLUS April 20, 2006

Posted by indooracle in Tutorial, Uncategorized.
trackback

From Thomas Kyte about autotrace:
Here is what I like to do to get autotrace working:

  • cd $oracle_home/rdbms/admin
  • log into sqlplus as system
  • run SQL> @utlxplan
  • run SQL> create public synonym plan_table for plan_table
  • run SQL> grant all on plan_table to public
  • exit sqlplus and cd $oracle_home/sqlplus/admin
  • log into sqlplus as SYS
  • run SQL> @plustrce
  • run SQL> grant plustrace to public

You can replace public with some user if you want. by making it public, you let anyone trace using sqlplus (not a bad thing in my opinion).

About Autotrace
You can automatically get a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is generated after successful SQL DML (that is, SELECT, DELETE, UPDATE and INSERT) statements. It is useful for monitoring and tuning the performance of these statements. For complete articles please take a look at http://asktom.oracle.com/.

Comments»

1. fajar - March 6, 2007

mohon bantuan, saya ingin belajar oracle sebaiknya mulai dari mana ? buku oracle versi indonesia ada ga ya ? btw ada yang punya cd interaktif nya ga, klo ada boleh minta ?
thanks before

2. Wong Edaan - July 11, 2012

mau tanya kepada semua nya, ada yang mengetahui / bisa mentrace , bahwa seorang user yang sedang connect ke database oracle10g, menggunakan software toad ?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: