RE: lock type of analyze
- From: raja rao <raja4list@xxxxxxxxx>
- To: Meenakshi.Aggarwal@xxxxxxxxxxxxx
- Date: Sat, 6 Aug 2005 07:32:46 -0700 (PDT)
Do we have ONLINE option (and for dbms_stats too ?)
and what mekes the difference if I use ONLINE option.
"Aggarwal, Meenakshi" <Meenakshi.Aggarwal@xxxxxxxxxxxxx> wrote:
I guess analyze table compute statistics applies some kind of lock on the table
unless used with online option.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of raja rao
Sent: Thursday, August 04, 2005 12:52 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: lock type of analyze
HI All,
Does the analyze table compute statistics (or dbms_stats) statement lock the
table
in anymode
Thanks,
Raj
---------------------------------
Start your day with Yahoo! - make it your home page
---------------------------------
Yahoo! Mail
Stay connected, organized, and protected. Take the tour
Other related posts:
