Showing posts with label THEORY. Show all posts
Showing posts with label THEORY. Show all posts
Tuesday, July 3, 2012

Explain Plan Definitation

›
Operation Option Description AND-EQUAL Thes step will have two or more child steps each of which returns a set of ROWID's.The AND...
Friday, April 27, 2012

Analyze Process and Lock

›
Analyze table estimate or compute statistics will acquire an exclusive lock on the library cache object, preventing any ddl changes, howeve...
Tuesday, April 17, 2012

Difference Oracle on Windows & Unix

›
Advantages of Oracle UNIX: Significant performance improvement Provides High Availability Contains in-depth system utilities and open-source...
Thursday, March 29, 2012

Oracle Parallel Execution

›
1. What is Oracle Parallel Execution? Parallel Execution allows Oracle to perform specific database actions in parallel. 2. Which sub types ...
Thursday, December 29, 2011

Database Hardening

›
Following are the general guidelines used for DB hardening: Complete server hardening checklist. Ideally, run on latest supported version (...
Wednesday, April 6, 2011

Constraint stats ORA-02298

›
Alter table CEXIST DISABLE constraint CEXISTBROKBOOK; alter table CEXIST disable constraint CEXISTBOOK; alter table CEXIST ENABLE constraint...
Monday, March 14, 2011

Oracle Database Incarnation, Open Resetlogs , SCN

›
Q. What happens when you run ALTER DATABASE OPEN RESETLOGS ? The current online redo logs are archived, the log sequence number is reset t...