![](https://www.pythian.com/hubfs/Imported_Blog_Media/OEM-graph-2.png)
After migrating a 10g database to 11g, I asked the Application team to start their tests in order to validate that everything was working as expected. I decided to keep an eye on OEM’s Top Activity page while they were running the most mportant job. I already knew what kind of "colors" I would find because I had checked its behavior in the former version. Suddenly, a strange kind of wait appeared on my screen: it was my first encounter with Backup Restore Throttle Speed.
![OEM graph 2](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
Since the job was using a log table to keep track of its execution, I was able to match the wait time with this function pretty quickly. This code was inside the function’s DDL:Sleep (l_master_rec.QY_FIRST_WAIT_MIN * 60);
Finally I found the reason for this wait (and the explanation for its backup/restore related name): DBMS_BACKUP_RESTORE.SLEEP. As described in MOS note "How to Suspend Code Execution In a PL/SQL Application (Doc ID 1296382.1)”, the package was used to pause job's execution while waiting for another task to be finished. Lastly, it's worth noting that OEM did not graph this wait on the 10g database but it was always there.for i in 1 .. trunc( seconds_to_sleep/600 ) loop sys.DBMS_BACKUP_RESTORE.SLEEP( 600 ); end loop; sys.DBMS_BACKUP_RESTORE.SLEEP( seconds_to_sleep-trunc(seconds_to_sleep/ 600)*600 );
Share this
You May Also Like
These Related Stories
Empowering Your Workforce with Oracle HCM Self-Service Modules
![](https://www.pythian.com/hubfs/Empowering%20Your%20Workforce%20with%20Oracle%20HCM%20Self-Service%20Modules-jpeg.jpeg)
Empowering Your Workforce with Oracle HCM Self-Service Modules
Nov 27, 2023
3
min read
How to Work Remotely: Creating a Work-From-Home Game Plan
![](https://www.pythian.com/hubfs/Imported_Blog_Media/how-to-work-remotely-creating-a-work-from-home-game-plan.jpg)
How to Work Remotely: Creating a Work-From-Home Game Plan
May 5, 2020
3
min read
EBS DBA: WF Mailer Override Address and Cloning: How to
EBS DBA: WF Mailer Override Address and Cloning: How to
Nov 19, 2010
1
min read
No Comments Yet
Let us know what you think