Index of blogs
- Is plan_hash_value final say?
- Shared pool free lists and durations
- ORA-4031 and shared pool durations
- RAC, parallel query and udpsnoop.d
- Resolving corruption with file_hdrs dump
- Library cache locks and pins
- Collaborate 2009 preentation
- DOUG 2009 Why does optimizer hate my SQL?
- Dynamic plan table, x$kqlfxpl and library cache latch contention
- System state dump analysis: Nocache, sequences and RAC
- High global cache waits on tab$
- RMOUG Training days 2009
- A stroll through shared pool heaps
- Lock table followed by ddl
- Cardinality feedback to resolve latch contention
- Correlation, nocorrelation and extended stats
- Log file synch tuning #2
- Performance tuning hugepages and linux
- Presentations at SIOUG and DOUG
- Performance issue: High Kernel mode CPU Usage
- How to find objects creating nologging changes
- Import performance: Does import of date column resorts to single row inserts, like lob columns?
- Tuning latch contention: Cache buffers chain latches
- Tuning ‘log file sync’ wait events
- Resolving HW enqueue contention
- How to tune SQL statements scientifically
- Correlation between column predicates
- Resolving HW enqueue contention
- Hotsos 2008 is over
- Transforming from list to a set of rows
- Log group switch sequence
Fasi Mohammed said
do u have anything related to debugging of ORA-600 errors.
Riyaj Shamsudeen said
Hello Fasi
Not exactly. Here is my approach to approach ORA-600 error:
1. Check the second argument and search in ML with OERI here.
2. Review stack trace from the ORA-600 trace file, understand which part of code is causing ORA-600 error. Search those function calls (you will have to exclude few top level function calls since they are dump routine , usually starts with ksp..
With these two steps, you will have better idea, whether this is a known bug or new bug. Of course, you might have to work with support as ORA-600 errors are exceptions and no general solution is available.
Cheers
Riyaj
Mohammad Rasheeduddin said
Dear Sir,
Please help me out by providing list of parameters with the following criteria?
Parameters that are new in 11g with the default behavior different from 10g
For Ex.
deferred_segment_creation is a new parameter in 11g. By adding this parameter to 11g and setting the default value to TRUE, oracle has changed the behavior of the segment creation w.r.t 10g.
Parameters that exists in 10g, but the default behavior has changed in 11g
Need your help.
PVN said
Do you have any thing on encrypted tablespcase or encrypted column?