• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

query and store procedure performance on Oracle database server

HI All,

Can anyone help how can i check the performance of store procedure on oracle server like sql profiler and can i see the graph how much time it is taking on each steps on stored procedure on oracle database server please.
0
romeiovasu
Asked:
romeiovasu
2 Solutions
 
Richard OlutolaConsultantCommented:
You may use Grid/Database Control, SQL Developer, Toad... No doubt there are more. Alternatively, you could check dynamic views to examine the status of running statements/scripts.
0
 
Wasim Akram ShaikCommented:
There is dbms_profiler for measuring the time taken and execution sequence at each step of code inside the procedure
 Refer to this link for sample illustration
http://www.oracle-base.com/articles/9i/dbms_profiler.php
0
 
romeiovasuAuthor Commented:
how to check on Toad.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now