Tips for Oracle DBA
Oracle Database Administration, How To, Daily DBA jobs, Oracle Error Cause and Action
Oracle DBA, How To, Error, Cause and Action
(Move to ...)
Back To Menu
▼
Menu
›
Oracle Database Administration Undo Data Management Changing Database To Archive Log Mode Making Oracle Database Autostart Find Cause And...
Tablespaces in multitenancy
›
Note: In a non-CDB, all the tablespaces belong to one database. In the CDB, one set of tablespaces belong to the root container, and each P...
Using glogin.sql to have friendly and nice SQLPLUS multitenancy environment
›
When we are working at multitenancy it is good to have glogin configured to show container info. I am having following glogin.sql. You can f...
Cost Based Optimizer (CBO) Parameters Setting
›
The parameter that control the optimizer behaviors are: CURSOR_SHARING determines what kind of SQL statements can shared the same cursors. T...
SQL Tuning Tools
›
Several tuning tools to detect and rectify SQL errors and performance issue Automatic Database Diagnostic Monitor The Automatic Database Dia...
›
Home
View web version