Performance analysis of package [message #299226] |
Sun, 10 February 2008 23:19  |
catchme_lenin
Messages: 35 Registered: January 2008 Location: Dubai
|
Member |
|
|
Hi Guruji,
I have modified a package. Changed the approaches of the sql queries. It performs well.
1. Earlier the package was taking approximately 1 hr and 30 minutes. Now it is taking only 20 mts.
2. Earlier it was comparing more than 10 million records. After the 'WHERE' clause changes, it is now comparing only 5000 records. (I checked it by using count(*)).
Now, I need to take a comparitive statistics on both earlier package and modified package. Like time taken, query hitting records/rows, performance,etc. What to do and how to do? Is the 'Statistics' in the Pl/Sql Developer tool, useful one?
Thanx in advance.
-Lenin.
|
|
|
|
|