DB명세서 작성 쿼리

 

 

.

.

.

.

 

1. HIDDEN PARAMETERS

 

SELECT KSPPINM NAME,

               KSPPSTVL VALUE,

               KSPPSTDF IS_DEFAULT,

               DECODE(BITAND(KSPPIFLG / 256,1),1,'TRUE','FALSE') SES_MODIFIABLE,

               DECODE(BITAND(KSPPIFLG / 65536,3),1,'immediate','2','deferred','3','immediate','false') SYS_MODIFIABLE,

               KSPPDESC DESCRIPTION

FROM SYS.VW_X$KSPPI I, SYS.VW_X$KSPPCV V

WHERE I.INDX = V.INDX

ORDER BY 1;

 

 

 

2. DBA_TABLES

 

SELECT * FROM DBA_TABLES ORDER BY 1,2,3;

 

3. DBA_OBJECTS

 

SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_TYPE,STATUS, FROM DBA_OBJECTS ORDER BY 1,2,3;

 

 

4. DBA_SEQUENCES

 

SELECT COUNT(1) FROM DBA_SEQUENCES WHERE ORDER_FLAG ='Y' ;

SELECT COUNT(1) FROM DBA_SEQUENCES WHERE ORDER_FLAG ='N' ;

 

 

5. DBA_JOBS;

 

SELECT * FROM DBA_JOBS;

 

SELECT OWNER

               , JOB_NAME

               , JOB_ACTION

               , REPEAT_INTERVAL

               , JOB_CLASS

               , ENABLED

FROM DBA_SCHEDULER_JOBS WHERE OWNER NOT IN ('SYS','ORACLE_OCM','EXFSYS') ;

 

 

6. PRIVS

 

SELECT * FROM DBA_TAB_PRIVS;

 

SELECT * FROM DBA_SYS_PRIVS;

 

SELECT * FROM DBA_ROLE_PRIVS;