Bugun sqlleri izlemek icin TKPROF yetmedigi ve daha detaya girlmesi gerektigi durumlarda ne yapmamiz gerektigi hakkinda fikirlerimi sizlerle paylasmak istedim.

Trace analyzer sayesinde daha detayli bir performans analizine ulasabiliriz.PLSQLdende kullanabiliriz.
9i,10g,11g versiyonlarinda kullanmamiz mumkundur. Platform olarakda windows linux ve unix ortamlarinda kullanabiliriz.
TKPROF gore cok daha fazla detay gorebiliriz install edilmesi gereken bir sqller toplulugudur.

Input olarak
• Trace(s) generated by event 10046 level 1, 4, 8 or 12
• Located in UDUMP or a designated server directory
• Unlimited size
• To analyze one Trace
• Provide name of trace file
• To analyze multiple Traces
• Create a control file with names of the traces
• Provide name of control file
• Output
• Comprehensive report with performance analysis details
• HTML and Text formats

alıp output olarakda
HTML ve TEXT rapor cikarabiliriz.

output olarak alinacak raporlar

Glossary of Terms Used
• Response Time Summary
• Overall Time and Totals
• Non-Recursive Time and Totals
• Recursive Time and Totals
• Top SQL
• Non-Recursive SQL
• SQL Genealogy
• Individual SQL ,Overall Segment I/O Wait Summary
• Hot I/O Blocks
• Gaps in Trace
• ORA errors in Trace
• Transactions Summary
• Non-default Initialization Parameters
• Trace Header
• Tool Execution Environment
• Tool Configuration Parameters
ana basliklarinda yer alabilir.

Her sql icin

For each SQL
Zamanlama bilgisi,toplam bilgileri bind bilgileri,source plan,explain plan,tablo ve index bilgileri,segment IO bilgileri yer alan bazı onamli bilgilerdir.

Metalinkten 224270.1:1 download edip surecimize baslayabiliriz.
SQL Trace 10046 level 1, 4, 8 or 12 alinir

sqlplus hr/hr
SQL> start trcanlzr.sql [name of your trace file]
SQL> start trcanlzr.sql largesql.trc <== your trace file
SQL> start trcanlzr.sql control_file.txt <== your text file

html ve text rapor olusturur.

paket icinde yeralan sql acilimi

Create Script – tacreate.sql
• Drop – tadrop.sql
• Create User – tacusr.sql
• Create Schema Objects – tacobj.sql
• Create PL/SQL Packages – tacpkg.sql
• Views – tacvw.sql
• Global – trca$g
• Parse – trca$p
• Transform – trca$t
• Invokers Rights – trca$i
• HTML Report – trca$r
• Text Report – trca$x

About oracledocuments

Zekeriya Beşiroğlu, It joined the Bilginc IT Academy in July 2000. In the meantime, the Oracle Education, Oracle Data Base Management System and Oracle Internet Technologies, Oracle development technologies such as the training of Oracle products is responsible for training as consultants. During this task, since 1 April 2008 with 293 Oracle training in total, in 2150 Oracle customers successfully submitted. Oracle 10g New York in November 2002 have received training and education in Turkey was the first time the consultants. 20 April 2008 on education in Turkey 11g is the first who was a consultant. Oracle Real Application Cluster Expert advisor is certified is the first . Http:// and Http:// owner and manager of the site. Its own has more than one hundred articles. In addition, creation and improvement of training materials are also related to work. Oracle products are used, database management and reporting Academy eruditely It also is working on. From the date of 1 January 2009 will continue to work as the Technical Director
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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