mahioracle

############################################################        DB QUERIES          ####################################################################### =================QUERY FOR TOTAL 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 ) +( SELECT SUM(BYTES)/1024/1024/1024 REDO_SIZE FROM SYS.V_$LOG ) +( SELECT SUM(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 CONTROLFILE_SIZE FROM V$CONTROLFILE) "SIZE IN GB" FROM DUAL; =================INDIVIDUALLY CHECKING ALL THE DATABASE FILES AS WELL AS NON-DATABASE  FILES: SET LINES 100 PAGES 999 COL NAME FORMAT A50 SELECT NAME, BYTES FROM (SELECT NAME, BYTES FROM V$DATAFILE UNION ALL SELECT NAME, BYTES FROM V$TEMPFILE UNION ALL SELECT LF.MEMBER "NAME", L.BYTES FROM V$LOGFILE LF , V$LOG L WHERE LF.GROUP# = L.GROUP# UNION ALL SELECT NAME, 0 FROM V$CONTROLFIL...

Installed by default, the database comes with three preconfigured Automatic Maintenance Tasks, called clients. First, the collection of optimizer statistics (Optimizer Statistics Collection), the Segment Advisor (Space Advisor) and the automatic SQL tuning (SQL Tuning Advisor). a. Status First, the query for the current state of the database in DBA_AUTOTASK_CLIENTS. Only in Enterprise Edition is the SQL Tuning Advisor ENABLED. SQL> select client_name, status, attributes from dba_autotask_client; CLIENT_NAME                        STATUS   ATTRIBUTES ---------------------------------  -------  ---------------------------------------- auto optimizer stats collection    ENABLED  ON BY DEFAULT , VOLATILE, SAFE TO KILL auto space advisor               ...