본문 바로가기

Database/Administration9

Oracle Database Release 20c New Features V0.1 오라클 공식 Document 리스트 에서는 20C 는 나타나지 않고 있습니다. 문서 링크는 아직 남아 있으며 공식 릴리즈 문서등에서는 19c 에서 21c 버전을 정식으로 사용 하는것으로 확인됩니다. 21c 는 2020년 12월 8일 부터 일부리전에서 ( Ashburn (IAD), Phoenix (PHX), Frankfurt (FRA) and London (LHR) regions) 에서 Free tier 클라우드에서 사용가능 하다고 하네요. (2021-01-05 내용추가) - Oracle Blog 참조 blogs.oracle.com/database/introducing-oracle-database-21c - Oracle 21c 의 공식문서 link - docs.oracle.com/en/database/or.. 2020. 3. 19.
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 18c New Features Application DevelopmentAvailabilityBig Data and Data WarehousingDatabase OverallDiagnosabilityPerformanceRAC and GridSecurity 2018. 5. 24.
Oracle Database 12c R2 New Features Application DevelopmentAvailabilityBig Data and Data WarehousingCompression and ArchivingDatabase Lifecycle ManagementDatabase OverallDiagnosabilityExadataManageabilityMiscellaneousPerformancePublic CloudRAC and GridSecuritySpatial and GraphWindows 2018. 5. 24.
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.