Oracle Database

--Nikhil Tatineni-- Oracle Database -- 

Parameterfile Management

http://www.databaseinmemory.com/2016/06/oracle-parameter-file-and-server.html

Controlfile Management 

http://www.databaseinmemory.com/2016/06/control-file-management.html

Redo Logfile Management 

http://www.databaseinmemory.com/2016/06/oracle-redo-log-file-management.html

Tablespace creation and Management

http://www.databaseinmemory.com/2016/05/tablespace-management.html

Tablespace Management Oracle 

http://www.databaseinmemory.com/2016/06/tablespace-management-oracle.html

Temporary Tablespace  Management and Oracle Database 

http://www.databaseinmemory.com/2016/03/monitor-and-manage-oracle-temporary.html

Procedure to flush SQL_ID from Shared Pool : Oracle 12c 

http://www.databaseinmemory.com/2016/03/procedure-to-flush-sqlid-from-shared.html

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

http://www.databaseinmemory.com/2016/03/plan-hash-values-for-given-sqlid-over.html

INDEX ORGANIZED TABLES: IOT

http://www.databaseinmemory.com/2015/03/index-organized-tables-iot.html

DBMS_METADATA.GET_DDL To extract Index DDL

http://www.databaseinmemory.com/2015/11/dbmsmetadatagetddl-to-extract-index-ddl.html

12c: Upgrading OPatch Version 

http://www.databaseinmemory.com/2016/02/12c-upgrading-opatch-version.html

12c: Upgrading Oracle Multitenant database

http://www.databaseinmemory.com/2016/02/12c-upgrading-oracle-multitenant.html

12c: New Notation for Oracle Patching Number

http://www.databaseinmemory.com/2016/02/12c-new-notation-for-patching-number.html

12c: In Memory Column Store

http://www.databaseinmemory.com/2015/11/12c-in-memory-column-store.html

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

http://www.databaseinmemory.com/2015/11/12c-heat-map-and-automatic-data.html

12c: In-database archiving

http://www.databaseinmemory.com/2015/11/12c-in-database-archiving.html

12c: parameter: temp_undo_enabled

http://www.databaseinmemory.com/2015/12/12c-parameter-tempundoenabled.html

12c: Trigger to open all pdbs after cdb reboot

http://www.databaseinmemory.com/2016/02/12c-trigger-to-open-all-pdbs-after-cdb.html

12c: Clone pluggable database using existing Pluggable database

http://www.databaseinmemory.com/2016/02/12c-clone-pluggable-databases-using.html

12c: open & close Pluggable databases

http://www.databaseinmemory.com/2016/02/12c-open-close-pluggable-databases.html

12c: Rename PDB’S from CDB Root 

http://www.databaseinmemory.com/2016/02/12c-rename-pdbs-from-cdb-root.html

12c: Creating Service on Pluggable Database using DBMS_SERVICE

http://www.databaseinmemory.com/2016/02/12c-creating-service-on-pdb.html

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

Create IPS Package: ADRCI

http://www.databaseinmemory.com/2015/03/create-ips-package-adrci.html

Oracle Histograms

http://www.databaseinmemory.com/2015/11/histograms.html

SQLPLAN Baselines

http://www.databaseinmemory.com/2015/03/sql-plan-baselines-are-new-feature-in.html

BAD SQL on database? No Problem ..!!

http://www.databaseinmemory.com/2015/03/sql-tuning.html

cardinality & Cardinality Feedback !

http://www.databaseinmemory.com/2015/03/cardinality-cardinality-feedback.html

kill blocking session on object

http://www.databaseinmemory.com/2015/11/kill-blocking-session-on-object.html

Changing Execution Plan of SQL Statements 

http://www.databaseinmemory.com/2016/02/to-change-execution-plan-of-sql.html

Oracle Database checkpoint Tuning

http://www.databaseinmemory.com/2016/02/oracle-database-checkpoint-tuning.html

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

http://www.databaseinmemory.com/2015/11/matching-pid-to-sid-sid-to-pid-sqltext.html

--Database Errors--

>

ORA-00265: Instance Recovery Required

http://www.databaseinmemory.com/2016/03/ora-00265instance-recovery-required.html

ORA-24324, ORA-24323, ORA-01090

http://www.databaseinmemory.com/2017/01/ora-24324-ora-24323-ora-01090.html

ARCH: Error 19809

http://www.databaseinmemory.com/2017/01/arch-error-19809.html

--Nikhil Tatineni-- Oracle Database --