Метки

11g

• Bug 15931756 - ORA-4031 Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds)
• Bug 4991675 - Diagnostic event improve diagnosability of data dictionary invalidation issues
• DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• Event 10309: Trigger Debug event
• Event 10384 level 16384: force parallel queries to run as serial
• Event 10505: CBO enable dynamic sampling dump to table
• Function-Based index changed its definition after a rebuild
• JPPD bypassed View has non-standard group by
• Join elimination not performed in the presence of virtual columns on parent table
• ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
• Reclaim unused space from MLOG$ segments after materialized view refresh
• Session cursor cache count statistics incorrect with parallel queries
• Suspending user session on specific enqueue

12c

• 12c: PX Auto DOP without IO Calibration
• APEX WWV_FLOW_SECURITY.GET_OWNER_OF_CALLING_CODE and 12.2
• Asynchronous Global Index Maintenance and Recycle Bin
• Asynchronous Global Index Maintenance effects
• Bitmap Conversion to ROWIDs with Global Indexes
• Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present
• Bug 26588069 - Wrong Result (Duplicate Rows Produced) Using Group By After Upgrading To 12.2.0.1
• Bug 4991675 - Diagnostic event improve diagnosability of data dictionary invalidation issues
• Concatenation and filter subqueries oddity
• DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• Edition-based redefinition: adjunct schemas
• Incorrect handling of unused columns during GoldenGate initial load using Direct Bulk Load to SQL*Loader
• Index full scan min/max scans returning wrong results on partitioned tables
• JPPD bypassed View has non-standard group by
• OR Expansion and Virtual Columns
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• ORA-3180 on Active Data Guard standby database
• ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
• PL/SQL Create or Replace Optimization
• SQL*Plus 12.2 and searching path of login.sql
• SQL92_SECURITY and ORA-01031
• SYS and Extended Data Types
• Session spending its time IN_CURSOR_CLOSE
• Temporary LOBs
• That Old Restart Problem Strikes Back: Setting the Stage
• Too many parse errors warning в 23ai
• V$SQL_PLAN_MONITOR.STARTS is higher than expected due to NLJ batching/Prefetching
• opatch and libpicl on Solaris SPARC

18c

• CURSOR Expressions Return Wrong Results in 18c/19c
• Concatenation and filter subqueries oddity
• Creating RAC Physical Standby for Single Instance Primary
• Determining Oracle Database Edition
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• OPATCHAUTO-72043 and JCE
• OR Expansion and Virtual Columns
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• SYS and Extended Data Types

19c

• Bitmap Conversion to ROWIDs with Global Indexes
• Bug 30324180 SQL Macro should be backported to 19.5
• CURSOR Expressions Return Wrong Results in 18c/19c
• Concatenation and filter subqueries oddity
• Create Standby Skip Pluggable Database
• Creating RAC Physical Standby for Single Instance Primary
• Creating a Table for Exchange and Copying Indexes
• Determining Oracle Database Edition
• Diagnosing Cluster Verification Utility (CVU) Errors
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• How to Send Messages to AWS SQS from PL/SQL Using UTL_HTTP
• Lateral views and filter predicate pushdown
• Making DBMS_SCHEDULER.CREATE_JOB Transactional
• Mythbusters: VARRAY faster than CLOB
• OR Expansion and Virtual Columns: Changes in 19c
• ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• ORA-04036 Troubleshooting: Error Stack Based Approach
• ORA-600 [kglobpg_is_pkp] During Rolling RU 19.7 Apply
• ORA-7445 kpdbfSourceFileSearch with NFSv3 without noac option
• Patching Oracle Grid Infrastructure Standalone Environment Using opatchauto Out of Place (OOP) Patching
• Pluggable Database not Opened on all RAC Instances Following Switchover
• Reading Amazon S3 Data from Oracle on non-OCI Environment
• SU bypassed: More than 1 column in connect condition
• SYS and Extended Data Types
• Secure Use of Runtime.exec Functionality in Oracle Database
• Session spending its time IN_CURSOR_CLOSE
• Starting Oracle Database on Demand Using Socket Activation
• Strict Redaction Semantics
• That Old Restart Problem Strikes Back: Setting the Stage
• Tracing Library Cache Locks Using _kgl_debug
• Tracing SQL Macro Expansion
• Updating non Key-Preserved Table
• Using LogMiner to Identify Redo Tag for Transactions
• Using SEHA Features in EE
• Using credentials with database links in 21c
• V$DB_PIPES: Unveiling the Truth of Oracle Hash Value
• Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
• X$ tables: starting address
• X$MESSAGES hidden columns
• srvctl config database OSDBA and OSOPER groups not defined

21c

• ASM disk group fails to mount with ORA-15017 ORA-15066 errors offlining disk "RACQ$LUN3" in group "DATA" may result in a data loss
• How to trace specific SQL statement executed by certain user
• Setting database session to read only in 21c
• Using credentials with database links in 21c
• Virtual X$ tables
• X$ tables: reading X$KQFCO from Oracle binary
• X$ tables: reading X$KQFTA from Oracle binary
• X$ tables: table-level callbacks and column definitions (without parsing)

23ai

• Too many parse errors warning в 23ai
• Установка Oracle Database 23.5 for Engineered Systems на не-Exadata

9i

• Function-Based index changed its definition after a rebuild

ASM

• ASM disk group fails to mount with ORA-15017 ORA-15066 errors offlining disk "RACQ$LUN3" in group "DATA" may result in a data loss

Bug

• Bug 15931756 - ORA-4031 Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds)
• Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present
• Bug 26588069 - Wrong Result (Duplicate Rows Produced) Using Group By After Upgrading To 12.2.0.1
• CURSOR Expressions Return Wrong Results in 18c/19c
• DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
• Function-Based index changed its definition after a rebuild
• Incorrect handling of unused columns during GoldenGate initial load using Direct Bulk Load to SQL*Loader
• Index full scan min/max scans returning wrong results on partitioned tables
• Join elimination not performed in the presence of virtual columns on parent table
• ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
• SU bypassed: More than 1 column in connect condition
• Session cursor cache count statistics incorrect with parallel queries
• Session spending its time IN_CURSOR_CLOSE
• Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

Clusterware

• CHA Alert CHA_DBWR_CKPT_IO_COMPLETE in OEM
• Diagnosing Cluster Verification Utility (CVU) Errors
• Using SEHA Features in EE
• gridSetup.sh executeConfigTools fails with PRVG-13606 : chrony daemon is not synchronized with any external time source

Code symbol

• ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• PL/SQL Create or Replace Optimization
• Reclaim unused space from MLOG$ segments after materialized view refresh
• Session spending its time IN_CURSOR_CLOSE
• Suspending user session on specific enqueue
• Temporary LOBs
• That Old Restart Problem Strikes Back: Triggers to the Rescue
• Tracing Library Cache Locks Using _kgl_debug
• Tracing SQL Macro Expansion
• Unwrapping PL/SQL: Using Custom Wrap Tables
• Unwrapping PL/SQL: a Systematic Approach
• V$DB_PIPES: Unveiling the Truth of Oracle Hash Value
• Virtual X$ tables
• X$ tables: reading X$KQFCO from Oracle binary
• X$ tables: reading X$KQFTA from Oracle binary
• X$ tables: starting address
• X$ tables: table-level callbacks and column definitions (without parsing)
• X$MESSAGES hidden columns
• Установка Oracle Database 23.5 for Engineered Systems на не-Exadata

Data Guard

• Create Standby Skip Pluggable Database
• Creating RAC Physical Standby for Single Instance Primary
• ORA-3180 on Active Data Guard standby database
• Pluggable Database not Opened on all RAC Instances Following Switchover

Diagnostic event

• APEX WWV_FLOW_SECURITY.GET_OWNER_OF_CALLING_CODE and 12.2
• Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present
• Creating a Table for Exchange and Copying Indexes
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• Edition-based redefinition: adjunct schemas
• Event 10309: Trigger Debug event
• Event 10384 level 16384: force parallel queries to run as serial
• Event 10505: CBO enable dynamic sampling dump to table
• How to trace specific SQL statement executed by certain user
• OR Expansion and Virtual Columns
• OR Expansion and Virtual Columns: Changes in 19c
• ORA-04036 Troubleshooting: Error Stack Based Approach
• PL/SQL Create or Replace Optimization
• Reclaim unused space from MLOG$ segments after materialized view refresh
• SU bypassed: More than 1 column in connect condition
• Session spending its time IN_CURSOR_CLOSE
• Strict Redaction Semantics
• Suspending user session on specific enqueue
• Temporary LOBs
• That Old Restart Problem Strikes Back: Getting What You Pay for
• That Old Restart Problem Strikes Back: Setting the Stage
• That Old Restart Problem Strikes Back: Triggers to the Rescue
• Tracing SQL Macro Expansion
• Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
• c3p0 PROBABLYNOT connection test query

EBR

• DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
• Edition-based redefinition: adjunct schemas

Exadata

• Установка Oracle Database 23.5 for Engineered Systems на не-Exadata

GoldenGate

• A lot of log.* files in dirbdb directory
• Excluding DDL in Integrated Extract using DBMS_STREAMS_ADM.SET_TAG
• Incorrect handling of unused columns during GoldenGate initial load using Direct Bulk Load to SQL*Loader
• Oracle to PostgreSQL Replication: Numbers Truncated to 6 Decimal Places

Indexing

• Asynchronous Global Index Maintenance and Recycle Bin
• Asynchronous Global Index Maintenance effects
• Bitmap Conversion to ROWIDs with Global Indexes
• Creating a Table for Exchange and Copying Indexes
• Function-Based index changed its definition after a rebuild
• Index full scan min/max scans returning wrong results on partitioned tables

Initialization parameter

• 12c: PX Auto DOP without IO Calibration
• Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present
• Bug 4991675 - Diagnostic event improve diagnosability of data dictionary invalidation issues
• Create Standby Skip Pluggable Database
• Index full scan min/max scans returning wrong results on partitioned tables
• Lateral views and filter predicate pushdown
• ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory
• ORA-3180 on Active Data Guard standby database
• ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
• Reclaim unused space from MLOG$ segments after materialized view refresh
• SQL92_SECURITY and ORA-01031
• SYS and Extended Data Types
• Session spending its time IN_CURSOR_CLOSE
• Setting database session to read only in 21c
• Strict Redaction Semantics
• That Old Restart Problem Strikes Back: Setting the Stage
• Too many parse errors warning в 23ai
• Tracing Library Cache Locks Using _kgl_debug
• V$SQL_PLAN_MONITOR.STARTS is higher than expected due to NLJ batching/Prefetching
• Установка Oracle Database 23.5 for Engineered Systems на не-Exadata

LOB

• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• Mythbusters: VARRAY faster than CLOB
• SYS and Extended Data Types
• Session spending its time IN_CURSOR_CLOSE
• Temporary LOBs
• Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

OEM

• CHA Alert CHA_DBWR_CKPT_IO_COMPLETE in OEM
• EM 12.1.0.4 Installing recommended plugins and patches
• OEM Target Version not updated after applying RU patch

OERR

• APEX WWV_FLOW_SECURITY.GET_OWNER_OF_CALLING_CODE and 12.2
• ASM disk group fails to mount with ORA-15017 ORA-15066 errors offlining disk "RACQ$LUN3" in group "DATA" may result in a data loss
• Asynchronous Global Index Maintenance and Recycle Bin
• Bug 15931756 - ORA-4031 Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds)
• Diagnosing Cluster Verification Utility (CVU) Errors
• Incorrect handling of unused columns during GoldenGate initial load using Direct Bulk Load to SQL*Loader
• ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• ORA-04036 Troubleshooting: Error Stack Based Approach
• ORA-3180 on Active Data Guard standby database
• ORA-600 [kglobpg_is_pkp] During Rolling RU 19.7 Apply
• ORA-7445 kpdbfSourceFileSearch with NFSv3 without noac option
• ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
• PL/SQL Create or Replace Optimization
• Pluggable Database not Opened on all RAC Instances Following Switchover
• Reading Amazon S3 Data from Oracle on non-OCI Environment
• SQL92_SECURITY and ORA-01031
• SYS and Extended Data Types
• Setting database session to read only in 21c
• Starting Oracle Database on Demand Using Socket Activation
• Strict Redaction Semantics
• That Old Restart Problem Strikes Back: Getting What You Pay for
• That Old Restart Problem Strikes Back: Setting the Stage
• That Old Restart Problem Strikes Back: Triggers to the Rescue
• Too many parse errors warning в 23ai
• Tracing SQL Macro Expansion
• Updating non Key-Preserved Table
• Using credentials with database links in 21c
• Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
• opatch and libpicl on Solaris SPARC
• Установка Oracle Database 23.5 for Engineered Systems на не-Exadata

OPatch

• OPATCHAUTO-72043 and JCE
• ORA-600 [kglobpg_is_pkp] During Rolling RU 19.7 Apply
• Patching Oracle Grid Infrastructure Standalone Environment Using opatchauto Out of Place (OOP) Patching
• Patching with OPatch Failed with Undefined Reference to __libc_csu_fini __libc_csu_init due to Wrong Libc Library
• opatch and libpicl on Solaris SPARC

OS

• Determining Oracle Database Edition
• Finding cause of kernel: blk_update_request: I/O error, dev fd0, sector 0
• ORA-7445 kpdbfSourceFileSearch with NFSv3 without noac option
• Secure Use of Runtime.exec Functionality in Oracle Database
• Starting Oracle Database on Demand Using Socket Activation
• Suspending user session on specific enqueue
• gridSetup.sh executeConfigTools fails with PRVG-13606 : chrony daemon is not synchronized with any external time source
• opatch and libpicl on Solaris SPARC
• srvctl config database OSDBA and OSOPER groups not defined
• wget one liners to download data from *.oracle.com without human intervention

PL/SQL

• APEX WWV_FLOW_SECURITY.GET_OWNER_OF_CALLING_CODE and 12.2
• Bug 30324180 SQL Macro should be backported to 19.5
• Event 10309: Trigger Debug event
• How to Send Messages to AWS SQS from PL/SQL Using UTL_HTTP
• Making DBMS_SCHEDULER.CREATE_JOB Transactional
• ORA-01031 select V$RESTORE_POINT in PL/SQL
• PL/SQL Create or Replace Optimization
• Reading Amazon S3 Data from Oracle on non-OCI Environment
• SQL92_SECURITY and ORA-01031
• Tracing SQL Macro Expansion
• Unwrapping PL/SQL: Using Custom Wrap Tables
• Unwrapping PL/SQL: a Systematic Approach

PX

• 12c: PX Auto DOP without IO Calibration
• Event 10384 level 16384: force parallel queries to run as serial
• Session cursor cache count statistics incorrect with parallel queries

Performance

• Asynchronous Global Index Maintenance effects
• Bitmap Conversion to ROWIDs with Global Indexes
• Concatenation and filter subqueries oddity
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• Event 10505: CBO enable dynamic sampling dump to table
• JPPD bypassed View has non-standard group by
• Lateral views and filter predicate pushdown
• Mythbusters: VARRAY faster than CLOB
• OR Expansion and Virtual Columns
• OR Expansion and Virtual Columns: Changes in 19c
• Reclaim unused space from MLOG$ segments after materialized view refresh
• SU bypassed: More than 1 column in connect condition
• Session spending its time IN_CURSOR_CLOSE
• Temporary LOBs
• That Old Restart Problem Strikes Back: Getting What You Pay for
• That Old Restart Problem Strikes Back: Setting the Stage
• That Old Restart Problem Strikes Back: Triggers to the Rescue
• c3p0 PROBABLYNOT connection test query

RAC

• CHA Alert CHA_DBWR_CKPT_IO_COMPLETE in OEM
• Creating RAC Physical Standby for Single Instance Primary
• Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
• ORA-600 [kglobpg_is_pkp] During Rolling RU 19.7 Apply
• Pluggable Database not Opened on all RAC Instances Following Switchover

RMAN

• A case for DATAFILECOPY FORMAT
• Create Standby Skip Pluggable Database

SQL

• Computing ORA_HASH
• Reading Amazon S3 Data from Oracle on non-OCI Environment

SQL*Plus

• SQL*Plus 12.2 and searching path of login.sql

X$

• ORA-04036 Troubleshooting: Error Stack Based Approach
• Suspending user session on specific enqueue
• Using LogMiner to Identify Redo Tag for Transactions
• V$DB_PIPES: Unveiling the Truth of Oracle Hash Value
• Virtual X$ tables
• X$ tables: reading X$KQFCO from Oracle binary
• X$ tables: reading X$KQFTA from Oracle binary
• X$ tables: starting address
• X$ tables: table-level callbacks and column definitions (without parsing)
• X$MESSAGES hidden columns