Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

explain tkprof?

Answer Posted / sikdar

TKPROf is one of the most useful utilities available to
DBAs for diagnosing performance issues. It essentially
formats a trace file into a more readable format for
performance analysis. The DBA can then identify and
resolve performance issues such as poor SQL, indexing, and
wait events.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how one can iterate through items and records in a specified block?

1122


What is a user exit program in oracle reports?

1027


What do you understand by oracle forms?

1038


What do you understand by lov?

1034


Why oracle forms required?

1038


if u want to delete all these detail block etc what will happen in form

1984


In what situation u create the BPA.

2210


difference between global n context sensitive segments?

2669


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2997


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2133


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1156


how do u place it in required folder

1930


What do you understand by lov and how can it be used?

1084


what are bind variables?

1085


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2214