alter system quiesce restricted never finishes
- From: "Lyall Barbour" <lyallbarbour@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Nov 2012 12:04:19 -0500
Hello everyone,
We are trying to get some End-Of-Month procedures automated for our accouting
application on Oracle. We'd like to Quiesce the 10.2.0.5 database and have an
AS SYSDBA login do the procedures. We've tested quiescing an empty 10g
database, and it works fine with the Default Resource Manager settings. It
seems to work with Grid's 12c Agent turned on for that database's host also. If
someone is logged into the application, though, the ALTER SYSTEM statement
never finishes (or, at least takes longer then 1 hour and 20 minutes when i
came back from lunch) The logged in user does not have to be doing anything,
just have the application up. I've looked at what Cursors that user has open
and the only "transaction" i can see is Auditing insertion into sys.AUD$
I've went through Google and Metalink, and have queried v$blocking_quiesce and
v$lock views (found that in Metalink) but even with nothing coming back from
those queries, the command never finishes if someone is simply logged into the
Forms application.
Can a database be quiesced if Auditing is turned on? Anybody know what i'm
doing wrong?
Thanks,
Lyall Barbour
--
//www.freelists.org/webpage/oracle-l
Other related posts:
