Thursday, April 25, 2013

Oracle : SQL to find in Top Activity in EM

The following SQL from default schema is useful to create TOP activity in Server,

select * from sh.sales,sh.customers, sh.channels

Note: Only for testing server :)
It was helpful to find it in Enterprise Manager.


Tuesday, April 23, 2013

Oracle: To Know Current System Change No.

 To Know Current System Change No. :
 select Current_scn from v$database;

Monday, April 22, 2013

Oracle: How to lock a table with select command

How to lock a table with select command:
SQL: select * from scott.dept for update;

Remember to Rollback when you want to unlock later :)

Oracle: Best Practice for TABLES & INDEXES Tablespace

Tip of the day: Best Practice (for realtime):

Create tablespaces for TABLES, and separate tablespaces

for INDEXES for better performance and management.