Archive for the ‘Uncategorized’ Category

Oracle 12c – Interactive Quick Reference

April 3, 2014 Leave a comment
Oracle 12c Architecture

Oracle 12c Architecture

Categories: Uncategorized

Interactive Report Filter – URL Parameters

August 21, 2013 Leave a comment


EQ = Equals
LT = Less than
LTE = Less then or equal to
GT = Greater Than
GTE = Greater than or equal to
LIKE = SQL Like operator
N = Null
NN = Not Null


Oracle Apex

August 12, 2013 Leave a comment
Categories: Uncategorized

Install APEX 4.2

August 5, 2013 Leave a comment
Categories: Uncategorized

Active Connections to Oracle Database

May 3, 2012 Leave a comment

V$SESSION displays session information for each current session.

substr(a.spid,1,9) pid,
substr(b.sid,1,5) sid,
substr(b.serial#,1,5) ser#,
substr(b.machine,1,6) box,
substr(b.username,1,10) username,
— b.server,
substr(b.osuser,1,8) os_user,
substr(b.program,1,30) program
from v$session b, v$process a
b.paddr = a.addr
and type=’USER’
order by spid;


Categories: General, Uncategorized

Materialized View Refresh

February 13, 2012 Leave a comment

Check refresh mode, refresh method and last refresh time from USER_MVIEWS:

SELECT mview_name, refresh_mode, refresh_method,
 last_refresh_type, last_refresh_date
 FROM user_mviews;

Change of refresh behaviour in 10g

Upgrading from Oracle 9i to Oracle 10g will change the MV refresh behaviour. Oracle 10g will use the DELETE command to remove rows and a normal INSERT to repopulate it. In Oracle 9i and earlier releases, Oracle did a TRUNCATE and INSERT /*+APPEND*/, which is more efficient, but had the side effect that users will see no rows while the refresh is taking place.

If you prefer the older truncate/append behaviour, change the refresh method to set atomic_refresh = false. Here is an example:

 -- use this with 10g/11g to return to truncate/append behavior
 dbms_mview.refresh('MY_TEST_MV', method=>'C', atomic_refresh=>false);


Atomic_refresh parameter is to allow either all of the tasks of a transaction are performed or none of them (Atomicity). If set to TRUE, then all refreshes are done in one transaction. If set to FALSE, then the refresh of each specified materialized view is done in a separate transaction.If set to FALSE, Oracle can optimize refresh by using parallel DML and truncate DDL on a materialized views.

If you set that to FALSE, it’ll do a truncate + insert /*+ append */ on a FULL refresh.

When atomic_refresh=>true, Oracle performs deleting from MView table.
When atomic_refresh=>false, Oracle truncates the MView table.

Atomic refresh does a

a) truncate (data disappears right away, poof)
b) insert /*+ APPEND */ – direct path load, which maintains indexes
c) commits (data reappears)

The indexes won’t/don’t go unusable, but the materialized view “disappears” for the duration of the refresh.

Source / Reference Links:

CakePHP Tutorial

November 10, 2011 Leave a comment

So far CodeIgniter was the only PHP development  frame work I had tasted. Now I’m moving onto CakePHP!

1. CakePHP from scratch – making a small application in cakephp

2. CakePHP from scratch – Data validation, routes and more

Categories: Uncategorized