Database Administrator

Select /*+ ORDERED */ substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)      "ORIGIN", substr(g.K2GTITID_ORA,1,35)...

select * from dba_hist_wr_control; BEGIN DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings( retention => 66240, -- = 46 D...

Making Idle Session SNIPED: An idle session can be setup to become sniped after x minutes by setting the initialization parameter resource_l...

-------------------Sniped idle session-------------- SELECT DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ...

Prerequisites SQL> @ORACLE_HOME\rdbms\admin\utlxplan.sql This creates the PLAN_TABLE for the user executing the script. ---------- Settin...

Cost Based Optimizer (CBO) and Database Statistics The mechanisms and issues relating to maintenance of internal statistics are explained be...

SQL> @ORACLE_HOME\rdbms\admin\utlxplan.sql This creates the PLAN_TABLE for the user executing the script. Run EXPLAIN PLAN for the query ...

To start a SQL trace for the current session, execute: ALTER SESSION SET sql_trace = true; ALTER SESSION SET sql_trace = true; or DBMS_SYSTE...

SELECT SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name , rows_processed , ROUND( (sysdate-TO_DATE(first_load_time,...

select segment_name table_name, sum(bytes)/(1024*1024) table_size_meg from user_extents where segment_type='TABLE' an...

select sum(space_used_delta) / 1024 / 1024 "Space used (M)", sum(c.bytes) / 1024 / 1024 "Total Schema Size (M)", round(s...

Step : 1 Calculate total Size of tablespace select sum(bytes)/1024/1024 "TOTAL SIZE (MB)" from dba_Data_files Step : 2 Calculate F...

select username,osuser,machine,blocking_session from v$session where username='LDBO'; select username,os_username,to_char(timestamp,...