Database

Kiểm tra dung lượng Tablespace đã sử dụng bao nhiêu %

Kiểm tra dung lượng Tablespace đã sử dụng bao nhiêu % được cấp phát và...

Thông tin dung lượng của Tablespace

Thông tin dung lượng của Tablespace: SELECT df.tablespace_name, df.total_space_mb, NVL(fs.free_space_mb, 0) AS free_space_mb, df.total_space_mb -...

Get info 10 Largest Objects in Database

Get info 10 Largest Objects in Database SELECT * FROM (select SEGMENT_NAME, SEGMENT_TYPE,BYTES/1024/1024/1024 GB,TABLESPACE_NAME from...

Get info % CPU usage by Session

Get info % CPU usage by Session select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss,...

Get infomation of oracle database redo logs and switches per day

Get infomation of oracle database redo logs and switches per day select trunc(completion_time) rundate,count(*) logswitch,round((sum(blocks*block_size)/1024/1024))...

Get all Schema size Oracle database

select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner;...

Get info table with FRAGMENTED Oracle database

Get info table with FRAGMENTED_SPACE Oracle database: select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),0) "TOTAL_SIZE", round((num_rows*avg_row_len /1024/1024),0) "ACTUAL_SIZE", round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),0) "FRAGMENTED_SPACE"...

Get info Tablespace usage Oracle database

Get info Tablespace usage Oracle database: With out: SYS, SYSTEM….’SYS’,’SYSTEM’,’FDBA’,’PERFSTAT’,’DBMON’ select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),0) "TOTAL_SIZE", round((num_rows*avg_row_len /1024/1024),0)...

Get table size Oracle database

Get table size: Nhập thông tin vào là chữ HOA nhé. select segment_name,TABLESPACE_NAME ,segment_type, bytes/1024/1024/1024...

Find session with high DISK IO

Find session with high DISK IO select p.spid, s.sid,s.process cli_process, s.status,t.disk_reads, s.last_call_et/3600 last_call_et_Hrs, s.action,s.program,lpad(t.sql_text,30) "Last...

Find Inactive sessions with HIGH DISK IO

select p.spid,s.username, s.sid,s.status,t.disk_reads, s.last_call_et/3600 last_call_et_Hrs, s.action,s.program,s.machine cli_mach,s.process cli_process,lpad(t.sql_text,30) "Last SQL" from gv$session s, gv$sqlarea t,v$process...

Get the size of Oracle database

select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files...