Month: December 2017

Oracle RAC crsctl syntax 12c

crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion $crsctl query crs softwareversion [node_name] #crsctl start crs #crsctl stop crs (or) #/etc/init.d/init.crs start #/etc/init.d/init.crs stop #crsctl enable crs #crsctl disable crs (or) #/etc/init.d/init.crs enable #/etc/init.d/init.crs disable $crsctl check crs $crsctl check cluster [-node node_name] …

Oracle RAC crsctl syntax 12c Read More »

Oracle 12c show shared pool used

— 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 v$parameter.name=’shared_pool_size’ and v$sgastat.pool=’shared pool’; — Regardless of the value of shared_pool_size the following — query shows the breakdown of shared pool select sum(ksmchsiz) Bytes, ksmchcls Status from x$ksmsp group by ksmchcls; BYTES STATUS ———- ——– …

Oracle 12c show shared pool used Read More »