I usually create a small table with two columns, step and time_stamp, and then at the beginning of each major step, I insert into the table, a step value (1, 1a, etc) and sysdate. then I can start the procedure and log on in another session and "watch" it. I just did this for a procedure that was taking over 6 hours to run. I found where it was spending the time, and then fixed the problem (missing index) and re-ran it. it now ran in 16 minutes!
michael smith

-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x46159052.[Email address protected]
Sent: Friday, July 29, 2005 2:35 PM
To: LazyDBA Discussion
Subject: [***SPAM***] - RE: Need Help - Number of numbers in MIME From
exceeds maximum threshold



This is the procedure/package I'm referring to. You can look it up and
see how it works:

DBMS_APPLICATION_INFO

I can start you off with this article:

http://www.databasejournal.com/features/oracle/article.php/3441191


-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x61672059.[Email address protected]
Sent: Friday, July 29, 2005 3:27 PM
To: LazyDBA Discussion
Subject: RE: Need Help

You won't see dbms_output.put_line while the stored procedure is
executing in sqlplus, (which is where it would display) -- until the
procedure is finished. Then you will see all of the lines basically at
once, but since the program is over it probably is not going to be of
much use in this case.

There is a set_application_info procedure that you can use to update the
v$session table and you can then monitor that table.

If I come across the exact spelling, or more details before someone else
I'll let you know.

-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x89858356.[Email address protected]
Sent: Friday, July 29, 2005 3:21 PM
To: LazyDBA Discussion
Subject: RE: Need Help


I guess you could use dbms_output.putline before you execute each
update. I think if you just look at the current SQL in EM or the data
dictionary, you will get only variables (so you wouldn't know the exact
row), but I could be wrong.


-----Original Message-----
From: Dibyendu Bhattacharya (dibyendu)
[mailto:oracledba-ezmlmshield-x18168339.[Email address protected]
Sent: Friday, July 29, 2005 2:18 PM
To: LazyDBA Discussion
Subject: RE: Need Help


Hi , Thanks ..

In Oracle Stored procedure , how to see which line is currently
executing ?

I have a SP that does multiple stuff and I want to see which part of SP
is presently executing by Oracle ..

Please Help

Dibyendu

-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x90442862.[Email address protected]
Sent: Friday, July 29, 2005 2:40 PM
To: LazyDBA Discussion
Subject: RE: Need Help

Update X
Set owner = 'oracle'
Where owner = 'sql'
And rownum < 10001

-----Original Message-----
From: Dibyendu Bhattacharya (dibyendu)
[mailto:oracledba-ezmlmshield-x40323122.[Email address protected]
Sent: Friday, July 29, 2005 12:54 PM
To: LazyDBA Discussion
Subject: Need Help
Importance: Low

Hi ,
I am new to Oracle , I need one help in writing a query ..

I have a table say X , which has 3 columns .. messageKey , owner , and
type

Now , the table has many rows(milions) , where majority of the owner is
say "sql"

Now , I want to write a query , to change the owner to "oracle" to first
10000 rows where owner is sql

Dibyendu


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page