Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow 'alter tablespace begin backup'
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<brt18i$koq$1$8302bc10_at_news.demon.co.uk>...
> There are two possible waits with setting a
> tablespace into backup mode. The first
> is that it can't be done until all current
> transactions on the database have completed
> (although new ones can start).
Are you sure about this? It would be very difficult to make hot backups if any long running transaction could block 'begin backup'.
I just tried in 8.1.7:
- in session1 started a transaction (deleted a record from a table)
- in session2 'alter tablespace begin backup' and it worked straight
away.
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
Regards,
Igor
Received on Thu Dec 18 2003 - 20:58:12 CST