ITPub博客

ALTER INDEX INDEX NAME UNUSABLE;

Select * into new_table from old_table

SELECT s.sid, S.BLOCKING_SESSION, S.FINAL_BLOCKING_SESSION  FROM v$session s  WHERE s.blocking_session IS NULL AND exists( select 1 from v$session s2 where S2.BLOCKING_SESSION =...

 http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm  MERGE INTO  bonuses D   USING  (SELECT employee_id, salary, department_id FRO...

create table [tablename] asselect * from [another_TableName]

please refer to this following article, http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42dba-1566567.html How to find locked objects:1. Get row lock inf...

please refer to the following article. http://www.oraclerecipes.com/monitoring/find-blocking-sessions/  

1. see if AWR is enabled show parameter statistics_level 2. modify interval and retention exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(retention=>43200, interv...

emctl start dbconsole emctl stop dbconsole emctl status dbconsole

emca is used to configure enterprise manager.Please refer to http://space.itpub.net/20943428/viewspace-628782 to set up enterprise manager.You will pe...