guruprakash asked this 7 years ago

What is the purpose of MONITORING keyword in CREATE TABLE sql statement

What does the MONITORING keyword do in a CREATE TABLE statement?


Binoy 7 years ago
1 like

That turns on statistics collection. This was deprecated from 11g because statistics are collected automatically. So from 11g, MONITORING and NOMONITORING keywords are ignored.