Undocumented onstat options

Onstat -T - dumps tablespace headers (sysptnhdr) information

Onstat -K - locks plus waiters (adds a column, same, to -k output)

Onstat -g dsc - display data distribution cache

Onstat -g prc - display stored procedure cache

Onstat -g amx - display ALL mutexes

Previous slide

Next slide

Back to first slide

View graphic version