Oracle RAC Resource utilization check Script
SELECT gv_i.INST_ID ,gv_i.INSTANCE_NAME ,gv_i.HOST_NAME ,gv_i.VERSION ,gv_i.STARTUP_TIME ,gv_i.STATUS ,gv_rl.RESOURCE_NAME ,gv_rl.CURRENT_UTILIZATION ,gv_rl.MAX_UTILIZATION ,gv_rl.INITIAL_ALLOCATION ,gv_rl.LIMIT_VALUE ,ROUND((gv_rl.MAX_UTILIZATION / gv_rl.LIMIT_VALUE) * 100, 2) AS "MAX(%)" ,ROUND((gv_rl.CURRENT_UTILIZATION / gv_rl.LIMIT_VALUE) * 100, 2) AS "CURRENT(%)" FROM gv$resource_limit gv_..
2019. 6. 21.
ORACLE RAC LOCK Check Scripts
오라클 데이터베이스 RAC Global Lock Scripts * 2018-04 최초생성 * 2018-05 Lock Type 추가 SELECT GV_S.INST_ID, GV_S.SID AS GV_SESSION_ID, GLS.SID AS GV_LOCK_SID, GV_S.INST_ID AS GV_SESSION_ID, GV_S.SERIAL#, LPAD(' ', (LEVEL - 1) * 4, ' ') || DECODE(LEVEL, 1, '', 'L-->') || GV_S.USERNAME AS USERNAME, GV_S.STATUS, GV_S.PROCESS, GV_S.SCHEMANAME, GV_S.OSUSER, GV_S.PROCESS, GV_S.MACHINE, GV_S.TERMINAL, GV_S.PROGRAM, ..
2018. 8. 9.
Oracle Database 12c R1(12.1.0.2) New Features
Section 1.1, "Advanced Index Compression"Section 1.2, "Approximate Count Distinct"Section 1.3, "Attribute Clustering"Section 1.4, "Automatic Big Table Caching"Section 1.5, "FDA Support for CDBs"Section 1.6, "Full Database Caching"Section 1.7, "In-Memory Aggregation"Section 1.8, "In-Memory Column Store"Section 1.9, "JSON Support"Section 1.10, "New FIPS 140 Parameter for Encryption"Section 1.11, "..
2018. 5. 24.