Hi Deepak,

ALTER SYSTEM ENABLE RESTRICTED SESSION will do the same thing, but this
command can be used after shutting down the DB and startup mount. But
the QUIESCE can be fired in a 24X7 running DB, it will not disconnect
any users who are already connected rather it will not allow them to
fire any DDL/DML statements.

Hope this answers your query.

Regards,
Rahul Dutta

-----Original Message-----
From: Deepak Panda
[mailto:oracledba-ezmlmshield-x76370512.[Email address protected]
Sent: Monday, June 20, 2005 6:12 PM
To: LazyDBA Discussion
Subject: Re: ALTER SYSTEM QUIESCE RESTRICTED

Hi Rahul,

Thanks for your nice explanation, but what I am interested in knowing is
whether

ALTER SYSTEM ENABLE RESTICTED SESSION;

will not do the same thing?

Regards,

Deepak
----- Original Message -----
From: "Rahul Dutta " <[Email address protected]
To: <[Email address protected]
Sent: Monday, June 20, 2005 4:38 PM
Subject: RE: ALTER SYSTEM QUIESCE RESTRICTED


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address
as
normal
> **Anything below this line is the original email text
>
>
> Hi Deepak,
>
> This is a new feature in Oracle 9i, that allows the database
> administrator to put the system into a quiesced state: non-DBA
> transactions, queries, or PL/SQL statements are blocked from starting.
>
> Without this feature, the DBA has to shutdown the database and reopen
it
> in restricted mode in many cases, which is a serious restriction for
> 24x7 systems. The quiesce database feature lessens such a restriction
> by providing database administrators the ability to perform these
> actions safely without shutting down database. When a DBA issues a
> command to quiesce the database, all current user transactions and
> queries complete, releasing locks and other resources, although the
> users remain connected. At this point, the database becomes quiesced
and
> the DBA can perform administrative tasks without interference.
>
> Hope this helps
>
> Regards,
> Rahul Dutta
>
>
> -----Original Message-----
> From: Deepak Panda
> [Email address protected]
> Sent: Monday, June 20, 2005 3:31 PM
> To: LazyDBA Discussion
> Subject: ALTER SYSTEM QUIESCE RESTRICTED
>
> Hi All,
>
> What is the basic difference between the following two...
>
> 1> ALTER SYSTEM QUIESCE RESTRICTED;
>
> 2> ALTER SYSTEM ENABLE RESTRICTED SESSION;
>
> Regards,
>
> Deepak
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page