Oracle Locked Mode
By admin on Dec 7, 2007 in side note
Oracle Locked Mode,
nl_mode(1) NuLl
ss_mode(2) Sub Shared
sx_mode(3) Sub eXclusive Row Exclusive Mode
s_mode(4) Sub eXclusive Row Exclusive Mode, Intended Exclusive
ssx_mode(5) Shared Share Row Exclusive Mode
x_mode (6) eXclusive
ANALYZE TABLE tablename COMPUTE|ESTIMATE|DELETE STATISTICS ptnOption options
ANALYZE INDEX indexname COMPUTE|ESTIMATE|DELETE STATISTICS ptnOption options
ANALYZE CLUSTER clustername COMPUTE|ESTIMATE|DELETE STATISTICS options
ptnOption
PARTITION (partion)
SUBPARTITION (subpartition)
options
VALIDATE STRUCTURE [CASCADE] [INTO tablename]
LIST CHAINED ROWS [INTO tablename]
COMPUTE|ESTIMATE STATISTICS FOR TABLE
COMPUTE|ESTIMATE STATISTICS FOR ALL COLUMNS
COMPUTE|ESTIMATE STATISTICS FOR ALL INDEXED COLUMNS
COMPUTE|ESTIMATE STATISTICS FOR COLUMNS [SIZE int] column [SIZE int]
When Estimating statistics you can optionally
specify
… ESTIMATE STATISTICS SAMPLE n ROWS
… ESTIMATE STATISTICS SAMPLE n PERCENT
Post a Comment