1;M;Tables within Database;Select distinct owner from all_tables;Owner;1200;
2;M;Views within Database;Select distinct owner from all_views;Owner;1200;
3;M;Synonyms within Database;Select distinct owner from all_synonyms;Owner;1200;
4;M;Indexes within Database;Select distinct owner from all_indexes;Owner;1200;
5;M;Triggers within Database;Select distinct owner from all_triggers;Owner;1200;
6;M;Functions within Database;select Distinct OWNER From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'FUNCTION' order by 1;Owner;1200;
9;M;Procedures within Database;select Distinct OWNER From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'PROCEDURE' order by 1;Owner;1200;
10;M;Tables within Owner;Select a.table_name, substr(comments,1,200) from all_tables a, all_tab_comments b where a.owner = ? and a.owner=b.owner and a.table_name = b.table_name order by 1;Table;3135;Description;5655;
11;M;Views within Owner;Select view_name, comments from all_views a, all_tab_comments b where a.owner = ? and a.owner=b.owner and a.view_name = b.table_name order by 1;View;3600;Description;12000;
12;M;Synonyms within Owner;Select synonym_name from all_synonyms where owner = ? order by 1;Synonym;3945;
13;M;Indexes within Owner;Select index_name from all_indexes where owner = ? order by 1;Index;3000;
14;M;Triggers within Owner;Select trigger_name, Status from all_triggers where owner=?;Trigger;1470;Status;900;
15;M;Tablespaces within Database;Select TABLESPACE_NAME, STATUS from SYS.USER_TABLESPACES;Tablespace;2130;Status;720;
16;U;Users within Database;Select USERNAME from SYS.ALL_USERS ORDER BY 1;User Name;1200;
17;R;Roles within Database;Select ROLE from SYS.DBA_ROLES ORDER BY 1;Role;3210;
18;M;Packages within Database;select Distinct OWNER From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'PACKAGE' order by 1;Owner;1500;
19;M;Procedures within Owner;select OBJECT_NAME, STATUS From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'PROCEDURE' And OWNER = ?;Procedure;1275;Status;1770;
20;C;Column list for;SELECT a.column_name, data_type, decode(data_type,'NUMBER',data_precision,data_length), data_scale, NULLable, comments, column_id, data_default FROM all_tab_columns a, all_col_comments b WHERE a.owner=b.owner and a.table_name = b.table_name and a.column_name = b.column_name and a.owner = ? and a.TABle_name=? order by column_id;Name;1200;Type;1050;Length;645;Scale;500;Nulls;500;Desc;3600;Default;615;
21;M;Columns in index;Select a.table_OWNER,a.table_NAME,a.uniqueness, b.COLUMN_POSITION,b.COLUMN_NAME from SYS.ALL_INDEXES A,SYS.ALL_IND_COLUMNS b WHERE a.oWNER =b.INDEX_OWNER AND a.INDEX_NAME=b.INDEX_NAME and a.owner=? and a.index_name=?;Owner;1200;Table Name;2500;Type;800;Pos;800;Column;1500;
22;S;Details of index;Select * from sys.all_indexes where owner=? and index_name=?;Column;2000;Value;3000;
23;S;Details of trigger;Select OWNER,TRIGGER_NAME,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OWNER,TABLE_NAME,REFERENCING_NAMES,substr(WHEN_CLAUSE,1,200) as WHEN_CLAUSE,STATUS,substr(DESCRIPTION,1,200) as DESCRIPTION,TRIGGER_BODY from SYS.ALL_TRIGGERS where owner=? and trigger_name=?;Column;2000;Value;4000;
24;S;Details of table;Select * from sys.all_tables where owner=? and table_name=?;Column;3030;Value;1905;
25;S;Status of;Select CREATED,LAST_DDL_TIME,TIMESTAMP,STATUS from SYS.ALL_OBJECTS WHERE OWNER=? and OBJECT_NAME=?;Column;1560;Value;1875;
26;T;Details of view;Select * from sys.all_views where owner=? and view_name=?;Column;2000;Value;5730;
27;M;Objects Referencing;Select OWNER,NAME,TYPE from SYS.ALL_DEPENDENCIES WHERE REFERENCED_OWNER= ? AND REFERENCED_NAME =?;Creator;645;Name;2610;Type;540;
28;M;Objects in View;Select REFERENCED_OWNER,REFERENCED_NAME,REFERENCED_TYPE, REFERENCED_LINK_NAME from SYS.ALL_DEPENDENCIES WHERE OWNER=? AND NAME=?;Owner;1200;Name;2500;Type;800;Link Name;1000;
29;M;Indexes on Table;Select a.OWNER,a.INDEX_NAME,a.uniqueness, b.COLUMN_POSITION,b.COLUMN_NAME from SYS.ALL_INDEXES A,SYS.ALL_IND_COLUMNS b WHERE a.oWNER =b.INDEX_OWNER AND a.INDEX_NAME=b.INDEX_NAME and a.table_owner=? and a.table_name=?;Owner;1200;Name;2500;Type;1200;Col Pos;700;Column;2000;
30;M;Definition of synonym;Select table_owner, table_name, db_link from sys.all_synonyms where owner=? and synonym_name=?;Tab Owner;1200;Tab Name;2500;DB Link;1000;
31;M;Columns used by trigger;Select TABLE_OWNER, TABLE_NAME, COLUMN_NAME,COLUMN_LIST,COLUMN_USAGE from SYS.ALL_TRIGGER_COLS where trigger_owner=? and trigger_name=?;Owner;1200;Table Name;2000;Column;2500;Col List;800;Col Usage;1200;
32;X;Text for procedure;select TEXT From SYS.ALL_SOURCE Where TYPE = 'PROCEDURE' And OWNER = ? And NAME = ? order by line;Text;6900;
33;S;Details of procedure;Select * from SYS.ALL_OBJECTS where object_type='PROCEDURE' and owner=? and object_name=?;Column;1560;Value;1785;
34;D;Contents of;x;Name;1500;
35;M;Trigger on table;Select owner,TRIGGER_NAME,TRIGGERING_EVENT from SYS.ALL_TRIGGERS WHERE TABLE_OWNER=? AND TABLE_NAME=?;Owner;1200;Trigger Name;2500;Event;1500;
36;M;Privileges on;Select distinct GRANTEE, PRIVILEGE, GRANTABLE, GRANTOR from SYS.ALL_TAB_PRIVS WHERE TABLE_SCHEMA=? AND TABLE_NAME=?;User;435;Privilege;720;Grantable;800;Granted by;930;
37;M;All privileges on;Select distinct GRANTEE, PRIVILEGE, GRANTABLE, GRANTOR from SYS.DBA_TAB_PRIVS WHERE owner=? AND TABLE_NAME=?;User;960;Privilege;720;Grantable;800;Granted by;930;
38;M;Packages within Owner;select OBJECT_NAME, STATUS From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'PACKAGE' And OWNER = ?;Package;780;Status;585;
39;M;Column Sizing for;Select COLUMN_NAME, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE, trunc(DENSITY,5) from SYS.ALL_TAB_COLUMNS WHERE owner = ? and TABle_name=? order by column_id;Column;1800;Distinct;1080;Low Value;900;High Value;930;Density;800;
40;M;Tables within Tablespace;Select OWNER,TABLE_NAME,BLOCKS,NUM_ROWS,INITIAL_EXTENT,NEXT_EXTENT from SYS.ALL_TABLES WHERE TABLESPACE_NAME=? ORDER BY BLOCKS desc;Tab Owner;1200;Tab Name;2610;Blocks;630;Rows;645;First Extent;930;Next Extent;1000;
41;S;Details of Tablespace;Select * from SYS.USER_TABLESPACES where tablespace_name=?;Column;2000;Value;3000;
42;M;Primary key on;Select a.owner, a.CONSTRAINT_NAME, b.COLUMN_NAME, b.position, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS B WHERE A.OWNER=B.OWNER AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME AND a.OWNER=? AND a.TABLE_NAME=? AND CONSTRAINT_TYPE='P' order by position;Index Owner;1200;Index Name;2940;Column Name;1800;Seq;500;Status;1000;
43;M;Referenced tables on;Select c.owner,c.table_name, a.constraint_name, b.COLUMN_NAME,d.column_name,b.position, a.delete_rule, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS B, SYS.ALL_CONSTRAINTS C,SYS.ALL_CONS_COLUMNS D WHERE A.OWNER = B.OWNER AND A.CONSTRAINT_NAME=B.constraint_NAME AND a.r_owner=c.owner and a.r_constraint_name=c.constraint_name and c.OWNER = d.OWNER AND C.CONSTRAINT_NAME=d.constraint_NAME and b.position=d.position and a.OWNER=? AND a.TABLE_NAME=? AND a.CONSTRAINT_TYPE='R' order by 1,2,3,6;Owner;600;Referenced Table;1545;Constraint;840;Col (FK);660;PK in Ref Tab;1200;Seq;390;Delete Rule;1005;Status;585;
44;M;Unique columns for;Select b.COLUMN_NAME, a.CONSTRAINT_NAME, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS B WHERE A.OWNER=B.OWNER AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME AND a.OWNER=? AND a.TABLE_NAME=? AND CONSTRAINT_TYPE='U' order by COLUMN_name;Column Name;1800;Constraint Name;2000;Status;1000;
45;A;Table access grid for;Select TABLE_SCHEMA,TABLE_NAME,PRIVILEGE,GRANTABLE from SYS.ALL_TAB_PRIVS WHERE GRANTEE=? order by 1,2,3;Schema;705;Name;540;Select;585;Update;630;Insert;510;Delete;600;Alter;405;Index;510;References;990;
46;M;Users granted to Role;Select GRANTEE, DEFAULT_ROLE, ADMIN_OPTION from SYS.DBA_ROLE_PRIVS WHERE GRANTED_ROLE=?;User Name;1095;Default Role;1065;Admin Option;1140;
47;M;System privileges for;Select PRIVILEGE,ADMIN_OPTION from SYS.DBA_SYS_PRIVS WHERE GRANTEE=?;Privilege;2355;Admin Option;1140;
48;M;Roles for User;Select GRANTED_ROLE,DEFAULT_ROLE,ADMIN_OPTION from SYS.DBA_ROLE_PRIVS WHERE GRANTEE=?;Role Name;1200;Default Role;1065;Admin Option;1140;
49;B;Table authorities for;Select TABLE_SCHEMA,TABLE_NAME,PRIVILEGE,GRANTABLE,GRANTOR from SYS.ALL_TAB_PRIVS WHERE GRANTEE=? order by 1,2,3;Schema;705;Name;540;Privilege;720;Grantable;800;Grantor;630;
50;W;View Definition;Select TEXT from SYS.ALL_VIEWS WHERE OWNER=? and VIEW_NAME=?;View Text;6960;
51;V;View Definition;Select TEXT from SYS.ALL_VIEWS WHERE OWNER=? and VIEW_NAME=?;View;2505;
52;T;Text of trigger;Select TRIGGER_BODY from SYS.ALL_TRIGGERS where owner=? and trigger_name=?;Trigger Text;5640;
53;M;All constraints on;Select CONSTRAINT_NAME, CONSTRAINT_TYPE, SEARCH_CONDITION, STATUS, R_OWNER, R_CONSTRAINT_NAME from SYS.ALL_CONSTRAINTS WHERE OWNER=? and tABLE_NAME=?;Constraint;1200;Type;500;Condition;2800;Status;1000;R-Owner;800;R-Name;1800;
54;M;Dependent Tables for;Select c.owner,c.table_name, c.constraint_name, b.COLUMN_NAME,d.column_name,b.position, c.delete_rule, c.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS B, SYS.ALL_CONSTRAINTS C,SYS.ALL_CONS_COLUMNS D WHERE A.OWNER = B.OWNER AND A.CONSTRAINT_NAME=B.constraint_NAME AND a.owner=c.r_owner and a.constraint_name=c.r_constraint_name and c.OWNER = d.OWNER AND C.CONSTRAINT_NAME=d.constraint_NAME and b.position=d.position and a.OWNER=? AND a.TABLE_NAME=? AND a.CONSTRAINT_TYPE='P' order by 1,2,3,6;Owner;600;Dependent Table;1500;Constraint;840;Col (PK);690;FK in Dep Tab;1245;Seq;390;Delete Rule;1005;Status;585;;390;
55;S;Details of package;Select * from SYS.ALL_OBJECTS where object_type='PACKAGE' and owner=? and object_name=?;Column;1560;Value;1785;
56;X;Text of package;select TEXT From SYS.ALL_SOURCE Where TYPE = 'PACKAGE' And OWNER = ? And NAME = ? order by line;Text;5220;
57;F;Column list for;SELECT a.column_name, data_type, decode(data_type,'NUMBER',data_precision,data_length), data_scale, NULLable, comments, data_default, column_id FROM all_tab_columns a, all_col_comments b, all_synonyms c WHERE a.owner=b.owner and a.table_name = b.table_name and a.column_name = b.column_name and a.owner = c.table_owner and a.TABle_name=c.table_name and c.owner=? and c.synonym_name=? order by column_id;Name;1095;Type;1000;Length;650;Scale;500;Nulls;500;Desc;1830;Default;615;
58;Q;View Definition;Select TEXT from SYS.ALL_VIEWS WHERE OWNER=? and VIEW_NAME=?;View;4095;
59;M;Objects Referencing Procedure;Select OWNER, NAME,TYPE from ALL_DEPENDENCIES WHERE REFERENCED_TYPE = 'PROCEDURE' and REFERENCED_OWNER =? AND REFERENCED_NAME = ?;Owner;1200;Name;2000;Type;1500;
60;M;Objects Referenced by Procedure;Select REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE from ALL_DEPENDENCIES WHERE TYPE = 'PROCEDURE' and OWNER =? AND NAME = ?;Owner;1200;Name;2000;Type;1500;
61;M;Objects Referenced by Package;Select REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE from ALL_DEPENDENCIES WHERE TYPE = 'PACKAGE' and OWNER =? AND NAME = ?;Owner;1200;Name;2000;Type;1500;
62;M;Objects Referenced by Package;Select OWNER, NAME,TYPE from ALL_DEPENDENCIES WHERE REFERENCED_TYPE = 'PACKAGE' and REFERENCED_OWNER =? AND REFERENCED_NAME = ?;Owner;1200;Name;2000;Type;1500;
63;X;Text of package body;select TEXT From SYS.ALL_SOURCE Where TYPE = 'PACKAGE BODY' And OWNER = ? And NAME = ? order by line;Text;6900;
64;M;Compilation errors for Procedure;select LINE, POSITION, TEXT from all_errors where type='PROCEDURE' and owner=? and name = ? order by sequence;Line;800;Position;800;Text;5000;
65;M;Compilation errors for Procedure;select LINE, POSITION, TEXT from all_errors where type='PACKAGE' or type ='PACKAGE BODY' and owner=? and name = ? order by sequence;Line;800;Position;800;Text;5000;
66;M;Functions within Owner;select OBJECT_NAME, STATUS From SYS.ALL_OBJECTS Where OBJECT_TYPE = 'FUNCTION' And OWNER = ?;Function;1965;Status;750;
67;S;Details of Function;Select * from SYS.ALL_OBJECTS where object_type='FUNCTION' and owner=? and object_name=?;Column;1560;Value;1785;
68;X;Text of Function;select TEXT From SYS.ALL_SOURCE Where TYPE = 'FUNCTION' And OWNER = ? And NAME = ? order by line;Text;5220;
69;M;Objects Referenced by Function;Select REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE from ALL_DEPENDENCIES WHERE TYPE = 'FUNCTION' and OWNER =? AND NAME = ?;Owner;1200;Name;2000;Type;1500;
70;M;Objects Referenced by Function;Select OWNER, NAME,TYPE from ALL_DEPENDENCIES WHERE REFERENCED_TYPE = 'FUNCTION' and REFERENCED_OWNER =? AND REFERENCED_NAME = ?;Owner;1200;Name;2000;Type;1500;
71;M;Compilation errors for Function;select LINE, POSITION, TEXT from all_errors where type='FUNCTION' and owner=? and name = ? order by sequence;Line;800;Position;800;Text;5000;
72;M;Objects Referenced by Trigger;Select REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE from ALL_DEPENDENCIES WHERE TYPE = 'TRIGGER' and OWNER =? AND NAME = ?;Owner;1200;Name;2000;Type;1500;
73;M;Objects Referenced by Trigger;Select OWNER, NAME,TYPE from ALL_DEPENDENCIES WHERE REFERENCED_TYPE = 'TRIGGER' and REFERENCED_OWNER =? AND REFERENCED_NAME = ?;Owner;1200;Name;2000;Type;1500;
74;M;Compilation errors for Trigger;select LINE, POSITION, TEXT from all_errors where type='TRIGGER' and owner=? and name = ? order by sequence;Line;800;Position;800;Text;5000;
75;O;Parameters for procedure;B;Parm;1500;Mode;800;Type;1000;Nulls;800;
76;M;Quotas for Tablespace;Select USERNAME, BLOCKS, MAX_BLOCKS from DBA_TS_QUOTAs WHERE TABLESPACE_NAME =?;User;1000;Blocks Used;1000;Max Blocks;1000;
77;M;Tables Sizing within Owner;SELECT TABLE_NAME, NUM_ROWS, BLOCKS, decode(blocks,0,'',trunc(num_rows/blocks)), TABLESPACE_NAME, trunc(LAST_ANALYZED) FROM ALL_TABLES WHERE OWNER = ? ORDER BY 3 DESC, 1;Table;2880;Rows;645;Blocks;630;Rows/Block;1065;Tablespace;1005;Analyzed;1095;
78;M;Tablespace Quotas;Select TABLESPACE_NAME,BLOCKS, MAX_BLOCKS from DBA_TS_QUOTAs WHERE USERNAME =?;Tablespace;2000;Used Blocks;1200;Max Blocks;1200;
79;M;Table Status within Owner;SELECT tab.TABLE_NAME, obj.STATUS, tab.BACKED_UP, tab.LOGGING FROM ALL_TABLES tab, ALL_OBJECTS obj WHERE tab.OWNER=obj.OWNER AND tab.TABLE_NAME=obj.OBJECT_NAME AND tab.OWNER = ? ORDER BY 1;Table;3135;Status;600;Backed Up;975;Logging;690;
80;M;Table Status within Owner;SELECT v.VIEW_NAME, o.STATUS FROM SYS.ALL_VIEWS v, ALL_OBJECTS o WHERE v.OWNER=o.OWNER AND v.VIEW_NAME=o.OBJECT_NAME AND v.OWNER = ?;Table;2220;Status;600;
81;M;Synonym on ;Select owner, synonym_name, db_link from sys.all_synonyms where table_owner=? and table_name=?;Owner;1200;Synonym;2500;
82;M;Tables within Tablespace;Select OWNER,INDEX_NAME,leaf_BLOCKS,distinct_keys,INITIAL_EXTENT,NEXT_EXTENT from SYS.ALL_INDEXES WHERE TABLESPACE_NAME=? ORDER BY LEAF_BLOCKS desc;Ind Owner;1200;Ind Name;2500;Leaf Blocks;1000;Distinct Keys;1000;First Extent;800;Next Extent;800;
83;M;Files comprising Tablespace;Select FNAME, BLOCKS from SYSTEM.SYSFILES WHERE TSNAME=?;File;4000;Blocks;1000;
