Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

query and store procedure performance on Oracle database server

Posted on 2014-10-11
3
261 Views
Last Modified: 2014-12-08
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
Comment
Question by:romeiovasu
3 Comments
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 250 total points
ID: 40375336
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
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 250 total points
ID: 40375378
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
 

Author Comment

by:romeiovasu
ID: 40376786
how to check on Toad.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question