Hier staat een database mapper script
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba_tablespaces t, dba_data_files d where t.tablespace_name = d.tablespace_name group by t.tablespace_name;
select tablespace_name, file_id, file_name, round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;
select segment_name, tablespace_name, r.status, (initial_extent/1024) InitialExtent, (next_extent/1024) NextExtent, max_extents, v.curext CurExtent From dba_rollback_segs r, v$rollstat v Where r.segment_id = v.usn(+) order by segment_name ;
select name from v$controlfile;
select member from v$logfile;
select owner, object_type, status, count(*) count# from all_objects group by owner, object_type, status;
Select version FROM Product_component_version Where SUBSTR(PRODUCT,1,6)='Oracle';
Select Created, Log_Mode, Log_Mode From V$Database;
select tablespace_name,sum(bytes/(1024*1024)) from dba_free_space where tablespace_name = dba_free_space.tablespace_name group by tablespace_name;
select tablespace_name,sum(bytes/(1024*1024)) from dba_free_space where tablespace_name = dba_free_space.tablespace_name and file_id = dba_free_space.file_id group by tablespace_name, file_id; |