Question
What is the maximum number of partitions you ever had in a partitioned table?
Less than 100
Between 100 and 500
Between 500 and 1000
Between 1000 and 2000
More than 2000
I never used partitioning
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 M. Cadot 147200
2 F. Pachot 129700
3 B. Vroman 77300
4 A. Kavsek 60850
5 P. Wisse 52600
6 T. Boles 51950
7 Z. Hudec 41200
8 A. Chavan 26200
9 A. Deledda 23000
10 V. Swamy 17125
About
DBA-Village
Site Statistics
Ever registered41916
Total active users26385
Act. users last 24h104
Act. users last hour4
Hits last week5303
Hits last month21663
Go up

Where to look about procedure progress
Next thread: get all
Prev thread: Handling ORA-01555: in a procedure

Message Score Author Date
I have one procedure that is taking so much of tim...... sandesh deshmukh Mar 11, 2010
Hi, If you are using TOAD and have DBA role you...... kishore pagadala Mar 11, 2010
1 ) Trace the session 2) simultaneously find the...... Umesh Sharma Mar 11, 2010
Hi, Query the view v$session_longops, it may he...... Pierre Rabau Mar 12, 2010
Hello, if you can edit the code of the procedur...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Mar 12, 2010

Follow up by mail Click here

Subject: Where to look about procedure progress
Author: sandesh deshmukh, India
Date: Mar 11, 2010, 182 days ago
Message: I have one procedure that is taking so much of time to get execute,So could anyody guide how can i monitor the performance of the procedure while procedure is still running?
Where can i look for to get information about the progress of the procedure?

Thanks in advance.


Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Where to look about procedure progress
Author: kishore pagadala, India
Date: Mar 11, 2010, 182 days ago
Message: Hi,

If you are using TOAD and have DBA role you can check the current progress in TOAD -> Database-> Monitor -> Session Browser.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Where to look about procedure progress
Author: Umesh Sharma, India
Date: Mar 11, 2010, 182 days ago
Message: 1 ) Trace the session
2) simultaneously find the current query running in the procedure
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Where to look about procedure progress
Author: Pierre Rabau, France
Date: Mar 12, 2010, 181 days ago
Message: Hi,

Query the view v$session_longops, it may help you.

Regards

Pierre
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Where to look about procedure progress
Author: Bruno Vroman, Belgium
Date: Mar 12, 2010, 181 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello,

if you can edit the code of the procedure, it might be useful to insert some calls to
   DBMS_APPLICATION_INFO.SET_CLIENT_INFO( ... )
(the "message" can be simple like 'I am here', but it might be more complex, like 'step ' || l_i1 || ' out of ' || l_i2 || ' started at ' || to_char( sysdate, 'DD-MON-YY HH24:MI:SS' ) or anything that suits your needs.
(good practice: do not forget to "reset" the message at the end of the procedure).

Then when the procedure is run in a session, you can query
SELECT client_info FROM v$session WHERE sid = ...
(or more simply: SELECT DISTINCT client_info FROM v$session)

HTH,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here