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.

 

 

Oracle: To Know Current System Change No.

 To Know Current System Change No. :

 

 select Current_scn from v$database;

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.