Pages

▼
Monday, March 16, 2015

PL/SQL example for Procedure with PRAGMA AUTONOMOUS_TRANSACTION

›
=========================================== General =========================================== Example of   PRAGMA AUTONOMOUS_TRANSACTI...
Sunday, March 15, 2015

Archive log files grow very fast

›
What can cause Archive logs to grow fast? ===================== General ===================== Log Writer Process (LGWR) Redo Log Conte...
Wednesday, February 25, 2015

Oracle Shared Server (MTS) vs Dedicated mode

›
============================ General ============================ The Server can be configured to run at  Dedicated or  Shared  mode, Th...
5 comments:
Thursday, February 12, 2015

Useful DBA SQLs. Compile and Recompile Objects.

›
======================= Compile Invalid Objects. ======================= ======================= Packages ======================= AL...
1 comment:
Sunday, January 18, 2015

Oracle VPD - Virtual Personal Database by Example

›
============================== General ============================== This is a short example of implementation of Oracle VPD - Virtual P...
1 comment:
Saturday, January 10, 2015

Mount, Nomount, Restricted and Open

›
============================= Mount, Nomount, Restricted and Open  ============================= NOMOUNT Oracle reads initialization fi...
Thursday, January 8, 2015

Oracle memory structures by example

›
==================== Oracle AAM ==================== Was introduced in Oracle 11. Oracle Reference for ASMM The simplest way to ma...