SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement.…

When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.…

CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded We do not have to recreate…

Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways to terminate an RMAN command in the middle of execution:…

During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location can be an ASM disk group, cluster file system file,…

SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL> select object_name, object_type from dba_objects where owner = 'SYS' and…