Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check if data is being inserted into table?

user1980Nov 26 2009 — edited Nov 26 2009
Oracle 10.2.0.1.0

I have a long running transaction, an insert based on select running from SQLPLUS. It is running for more than 2 hours as the volume of data is extremely high ( more than 2 million records ).

How do I check:

1) The volume of data that is already inserted?.

This is to make sure the session is not "hung", but is actually inserting records into the table.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2009
Added on Nov 26 2009
#general-database-discussions
8 comments
7,559 views