Thursday, April 25, 2013

Oracle : SQL to find in Top Activity in EM

Hello,
 
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.