Pages

Oracle Database


--Nikhil Tatineni-- Oracle Database -- 

Parameterfile Management

Controlfile Management 

Redo Logfile Management 

Tablespace creation and Management

Tablespace Management Oracle 

Temporary Tablespace  Management and Oracle Database 

Procedure to flush SQL_ID from Shared Pool : Oracle 12c 

Plan Hash Values for a Given SQLID Over Given Period & Historical Plans from the AWR 

INDEX ORGANIZED TABLES: IOT

DBMS_METADATA.GET_DDL To extract Index DDL

12c: Upgrading OPatch Version 

12c: Upgrading Oracle Multitenant database

12c: New Notation for Oracle Patching Number

12c: In Memory Column Store

12c: Heat Map and Automatic Data Optimization (ADO).

12c: In-database archiving

12c: parameter: temp_undo_enabled

12c: Trigger to open all pdbs after cdb reboot

12c: Clone pluggable database using existing Pluggable database

12c: open & close Pluggable databases

12c: Rename PDB’S from CDB Root 

12c: Creating Service on Pluggable Database using DBMS_SERVICE

Monitoring Oracle Database Tablespace and datafiles
http://www.databaseinmemory.com/2016/05/tablespace-management.html

Create IPS Package: ADRCI

Oracle Histograms

SQLPLAN Baselines

BAD SQL on database? No Problem ..!!

cardinality & Cardinality Feedback !

kill blocking session on object

Changing Execution Plan of SQL Statements 

Oracle Database checkpoint Tuning

Matching PID to SID & SID to PID & SQL_TEXT using SID

--Database Errors--
>
ORA-00265: Instance Recovery Required

ORA-24324, ORA-24323, ORA-01090

ARCH: Error 19809

--Nikhil Tatineni-- Oracle Database --