Oracle RAC crsctl syntax 12c
crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion […]
crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion […]
— shared_pool_size must be non-zero select to_number(v$parameter.value) “value”, v$sgastat.bytes “bytes”, (v$sgastat.bytes/v$parameter.value)*100 “Percent Free” from v$sgastat, v$parameter where v$sgastat.name=’free memory’ and
http://www.oracle.com/technetwork/database/performance/opt-storage-conf-130048.pdf
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is