|
| Name | Objects per user overview |
| Rating |  |
| Created On | 28-NOV-06 |
| Category | Reports |
| Database Version | 9.2 |
| Description | SELECT owner,
SUM("SYNONYM") AS "SYNONYM",
SUM("TABLE") AS "TABLE",
SUM("T-PART.") AS "T-PART.",
SUM("INDEX") AS "INDEX",
SUM("I-PART.") AS "I-PART.",
SUM("VIEW") AS "VIEW",
SUM("TRIGGER") AS "TRIGGER",
SUM("PACKAGE") AS "PACKAGE",
SUM("PROCEDURE") AS "PROCEDURE",
SUM("FUNCTION") AS "FUNCTION",
SUM("TYPE") AS "TYPE",
SUM("CLUSTER") AS "CLUSTER",
SUM("CONSUMER GROUP") AS "CONSUMER GROUP",
SUM("DB LINK") AS "DB LINK",
SUM("DIRECTORY") AS "DIRECTORY",
SUM("LOB") AS "LOB",
SUM("QUEUE") AS "QUEUE",
SUM("RESOURCE PLAN") AS "RESOURCE PLAN"
FROM (SELECT owner,
decode(object_type, 'SYNONYM', 1, 0) AS "SYNONYM",
decode(object_type, 'TABLE', 1, 0) AS "TABLE",
decode(object_type, 'TABLE PARTITION', 1, 0) AS "T-PART.",
decode(object_type, 'INDEX', 1, 0) AS "INDEX",
decode(object_type, 'INDEX PARTITION', 1, 0) AS "I-PART.",
decode(object_type, 'VIEW', 1, 0) AS "VIEW",
decode(object_type, 'TRIGGER', 1, 0) AS "TRIGGER",
decode(object_type, 'TYPE', 1, 0) AS "TYPE",
decode(object_type, 'PACKAGE', 1, 0) AS "PACKAGE",
decode(object_type, 'PROCEDURE', 1, 0) AS "PROCEDURE",
decode(object_type, 'FUNCTION', 1, 0) AS "FUNCTION",
decode(object_type, 'CLUSTER', 1, 0) AS "CLUSTER",
decode(object_type, 'CONSUMER GROUP', 1, 0) AS "CONSUMER GROUP",
decode(object_type, 'DATABASE LINK', 1, 0) AS "DB LINK",
decode(object_type, 'DIRECTORY', 1, 0) AS "DIRECTORY",
decode(object_type, 'LOB', 1, 0) AS "LOB",
decode(object_type, 'QUEUE', 1, 0) AS "QUEUE",
decode(object_type, 'RESOURCE PLAN', 1, 0) AS "RESOURCE PLAN"
FROM DBA_OBJECTS o)
GROUP BY owner
ORDER BY decode(owner, 'PUBLIC', 1, 'SYS', 2, 'SYSTEM', 3, 0), 1; |
|
|
|
|
| Thanks. | 17-DEC-2007 09:31PM
|
|
|
|