HelloDBA [中文]
Search Internet Search HelloDBA
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle  acoug  acoug 

 

        Oracle 12.2 SQL Parsing bug

 

Oracle 12.2 parsing SQL will raise ORA-03113 error under special conditions.
[Read]

 

 

New Articles

 

 

  • Oracle 12.2 SQL Parsing bug
  • Oracle 12c new SQL Hints
  • Flashback Snapshot of Schema
  • Consistent Gets may not tell the truth
  • Oracle 12c Hybrid Histogram
  • Oracle 12c TOP-N Frequency Histogram
  • Rescue data in the worst situation (2)
  • Rescue data in the worst situation (1)
  • Understand Buffer Cache in further --- Build up queryable Buffer Cache Chain data
  • Oracle SQL Hints --- Contents
  • Oracle SQL Hints --- Other Hints
  • Oracle SQL Hints --- Model Query And Partition Hints
  • Oracle SQL Hints --- Distributed Query And Parallel Query Hints
  • Oracle SQL Hints --- Hierarchy Query And XML Query Hints
  • Oracle SQL Hints --- Run Time And Data Maniplulation Hints
  • Oracle SQL Hints --- Statistics Data And Optimizer Hints
  • Oracle SQL Hints --- Quert Transformation Hints
  • Oracle SQL Hints --- Outline Data Hints
  • Oracle SQL Hints --- Join Hints
  • Oracle SQL Hints --- Access Path Hints
  • Oracle SQL Hints --- Abstraction
  • Coming Soon ...
  • Recover Truncated Data utilizing PLSQL
  • Oracle 11g Direct IO Auto Tune
  • Test Around Small Table Threshold
  • Oracle Sorting Algorithm
  • Approximate NDV based on hash algorithm in Oracle 11g
  • Distinct Aggregate Transformation
  • NULL or NOT NULL --- NOT NULL constraint impacts on execution plan and performance
  • Current Mode and Consistent Gets (2)
  • Current Mode and Consistent Gets
  • Select For Update and performance
  • Look Oracle from inside (tracing internal calls) --- Latches
  • Look Oracle from inside (tracing internal calls) --- Lock (Enqueue)
  • Look Oracle from inside (tracing internal calls) --- Logical IOs
  • Look Oracle from inside (tracing internal calls) --- Execution Plan
  • Query Execution Call Stack Trace
  • Execution Plan process analysis
  • SQL Rolling Invalidation
  • Bloom Filter
  • All about oracle sorting
  • TIPS: Build OUTLINE agilely
  • Adjusted MBRC formual in CBO
  • CBO Cost estimation
  • NULL IS NOT NULL in execution plan
  • CBO Statistics data gathering and internal arithmetic analysis -- Sampling
  • CBO Statistics data gathering and internal arithmetic analysis -- Calculating NDV and Density
  • CBO Statistics data gathering and internal arithmetic analysis -- Converting to endpoint value
  • CBO Statistics data gathering and internal arithmetic analysis -- Frequency or Height Balanaced?
  • CBO Statistics data gathering and internal arithmetic analysis -- when will gather histogram data
  • TIPS: How to get physical size of objects
  • [En] Oracle Row Shipping
  • Oracle Redo Strand
  • HowTo: Trace the statistics data gathtering
  • Oracle In Memory Undo
  • Secret of oracle logical IO: Index Scan
  • Secret of oracle logic IO: Sorting
  • Secret of oracle logic IO: Current Mode
  • Secret of oracle logic IO: Consistent Gets
  • Secret of oracle logic IO: Full Table Scan: Part 3
  • Secret of oracle logic IO: Full Table Scan: Part 2
  • Secret of oracle logic IO: Full Table Scan: Part 1
  • Transaction Enqueue analysis --- Other Contentions
  • Transaction Enqueue analysis --- Foreign Key
  • Transaction Enqueue analysis --- Bitmap Index Mantanence
  • Transaction Enqueue analysis --- Unique Constraint
  • Transaction Enqueue analysis --- Index Contention
  • Transaction Enqueue analysis --- ITL Contention
  • B*Tree Index block split --- Wait Events
  • B*Tree Index block split --- Block Allocation
  • B*Tree Index block split --- Split Transaction
  • B*Tree Index block split --- Storage Parameters
  • B*Tree Index block split --- Tree Growth
  • B*Tree Index block split --- How to split
  • Build "High" index in 10g
  • Q&A: Why there is not value peeked in 10053 trace file.
  • Transaction Enqueue analysis --- Row Lock
  • 11g new feature --- more flexible partition strategy
  • Row Movement impact
  • Q&A: Relationship between Table and Segment
  • 11g new feature --- Index Invisible
  • TIPS: ROWID Convertion
  • TIPS: Get lock wait in RAC
  • Full Table Scan cost formula cracking(1)
  • Full Table Scan cost formula cracking(2)
  • Full Table Scan cost formula cracking(3)
  • Full Table Scan cost formula cracking(4)
  • Full Table Scan cost formula cracking(5)
  • Full Table Scan cost formula cracking(6)
  • Q&A --- Multiple Buffer Cache
  • Consistent Reads And Buffer Cache
  • Performance trap of ROWNUM
  • analysis parallel process via Parallel Trace
  • Parallel your SQL --- Huge data update performance tuning
  • Oracle IO analysis(1)
  • Oracle IO analysis(2)
  • Oracle IO analysis(3)
  • Oracle IO analysis(4)
  • Oracle IO analysis(5)
  • Oracle IO analysis(6)
  • Oracle IO analysis(7)
  • Oracle IO analysis(8)
  • Oracle IO analysis(9)
  • Oracle IO analysis(10)
  • New hint in Oracle 10gR2 --- opt_param
  • Oracle SCN explanation
  • Tips of Oracle ROWNUM
  • Merge Join Cartesian in Execution Plan
  • How to capture the long operations
  • How to monitor the index usage
  • Capture top SQLs and their execution plans using statspack
  • Oracle bug --- zero date
  • Oracle 11g New features
  • Oracle Memory Management analysis(1)
  • Oracle Memory Management analysis(2)
  • Oracle Memory Management analysis(3)
  • Oracle Memory Management analysis(4)
  • Oracle Memory Management analysis(51)
  • Oracle Memory Management analysis(6)
  • Oracle Memory Management analysis(7)
  • Oracle Memory Management analysis(8)
  • Oracle Memory Management analysis(9)
  • Oracle Memory Management analysis(10)
  • Oracle Memory Management analysis(11)
  • Oracle Memory Management analysis(12)
  • When will bind variable peeking draw back performance?
  • How to calculate Cardinality in execution plan
  • Transaction Lock
  • Build personal desktop search engine utilizing Ultra Search
  • Install and configure ultra search
  • Dual table tuning
  • Testing cases and analys about operations on data block in transaction(1)
  • Testing cases and analys about operations on data block in transaction(2)
  • Testing cases and analys about operations on data block in transaction(3)
  • Study Oracle temporary table cache
  • Oracle streams replication between Oracle and SQL Server(1)
  • Oracle streams replication between Oracle and SQL Server(2)
  • Build logic stand by database
  • Create a trigger to monitor table
  • Configure load balance and failover in RAC
  • Oracle Hints(1)
  • Oracle Hints(2)
  • Oracle Hints(3)
  • Oracle Hints(4)
  • Oracle Hints(5)
  • Oracle Hash Join
  • Comparation of Normal Table Temporary Table and Table function
  • Rewrite SQL
  • Oracle 10g New feature --- Regular Expression
  • Oracle 10g New feature --- Code Wrap
  • Oracle 10g New feature --- Chooseful Compile
  • Oracle 10G New feature --- ADDM and SQL Tuning Advisor
  • Oracle 10G New feature --- Materialized View
  • Oracle 10G New feature --- Tablespace Management
  • Oracle 10G New feature --- Flashback
  • Oracle 10G New feature --- Connect By clause enhancement
  • Oracle 10G New feature --- RMAN
  • Oracle 10G New feature --- SQL*Plus
  • Oracle 10G New feature --- AWR
  • Oracle 10G New feature --- Audit
  • Oracle 10G New feature --- Waits
  • Oracle10g ADDM Guideline(1)
  • Oracle10g ADDM Guideline(2)
  • Oracle10g ADDM Guideline(3)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (1)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (2)
  • Tune SQL via Oracle 10g SQL Tuning Advisor (STA) (3)
  • Skip Scan Index
  • Configure Rotating in hacmp5.2
  • Oracle XML DB
  • How to identify lock type
  • ORA-01555 analysis(1)
  • ORA-01555 analysis(2)
  • ORA-01555 analysis(3)
  • Data Segment Compression
  •  


     

    Top

    Copyright ©2005, HelloDBA.Com All reseverd.

    Declaration
    by fuyuncat