I am updating table in a loop reading the records into a cursor. I can track the progress of this program using DBMS_APPLICATION_INFO. I can find out how much time is getting elapsed to insert every 10000 records.
Now I am modifying the update to use bulk update and I am not able to use this package to effectively track the progress..
I want to know how time is getting elapsed to insert every 10000 records..Is there a way to do this..
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…