본문 바로가기

Oracle Database9

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.
Oracle Database 12c R1(12.10.1) New Features Application DevelopmentBusiness Intelligence and Data WarehousingCompression and ArchivingDatabase OverallHigh AvailabilityManageabilityPerformanceOracle RAC and Grid InfrastructureSecuritySpatial and GraphUnstructured DataUpgradesWindows 2018. 5. 24.
Oracle Database 11g New Features Application DevelopmentAvailabilityDatabase OverallBusiness Intelligence and Data WarehousingClusteringContent Management ServicesFault DiagnosabilityInformation IntegrationLocation Services and Specialty DataManageabilityPerformanceSecurityWindows 2018. 5. 24.