RSS Feed for This PostCurrent Article

Oracle Locked Mode

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


Trackback URL


Sorry, comments for this entry are closed at this time.