Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2

Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ] Oracle Server - Standard Edition ...

What is The Maximum Datafile Size Limit In Oracle Database 10gR2

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 Information in this document applies to any platform. Goal:...

ORA-1653 unable to extend table %s.%s by # in tablespace %s

Applies to: All Oracle versions Information in this document applies to any platform. Cause: The reason for " ORA-1653 unable to...

ORA-01034 : ORACLE not available. ORA-27101 : shared memory realm does not exist

Applies to: All Oracle versions Information in this document applies to any platform. Cause: The main reason for this error is your d...

How to Shrink the datafile of Undo Tablespace

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 Oracle Server - Standard Edition - Version: 9.2.0.7 to 11....

How to Shrink the datafile of Temporary Tablespace

Applies to: Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.6 Information in this document applies to any platform. Go...

Relation between MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET

Applies to: Database Management Software Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.3 - Release: 11.1 to 11.2 Info...

ORA-09817: Write to audit file failed No space left on device

Applies to: Database Management Software Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1 This problem can occur on any pla...

9 Steps to Identify and Remove Table Fragmentation

In Oracle schema there are tables which has huge difference in actual size ( size from User_segments ) and expected size from user_tables ...

OBSOLETE BACKUPSET ARE NOT DELETED FROM THE FRA AUTOMATICALLY

Before reading this bug. I will recommend following: If backups are not deleted from FRA even after crossing retention policy and you hav...

Relation between RMAN retention period and control_file_record_keep_time

In this Document Purpose Scope and Application Relation between RMAN retention period and control_file_record_keep_time Applies to: Or...

ORA-07445: exception encountered: core dump [pi_jaro_winkler_int()+409]

ORA-07445: exception encountered: core dump [pi_jaro_winkler_int()+409] we use PL/SQL (DBMS Packages) TL_MATCH.JARO_WINKLER_SIMILARITY to...

Resolve default database security violations

When I configure OEM Database Control for my database.Below privileges are assigned to Public. it is a database security violations. These ...

Flash Recovery area - Space management Warning and Alerts

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2 Information in this document appli...

Initialization Parameters required for Flash Recovery Area

To enable the Flash Recovery Area, you must set the two initialization parameters: DB_RECOVERY_FILE_DEST_SIZE : It is the disk limit, whi...

How Can Temporary Segment Usage Be Monitored Over Time ?

Applies to: Oracle Server - Enterprise Edition - Version: 9.2 and above Goal: Suggest a method by which temporary segment usage be mo...