15 Nisan 2013 Pazartesi

DB HEALTH CHECK CONTROLS 3- MONTHLY


Monthly controls and actions according to controls provide healthy databases and management facilities. So i strongly recommend monthly control for all junior dba's becoming senior dba.

  1. Check the undo segment size for last month. You could find check undo tablespace size sql from metalink.
  2. Check max undo segment size for last month.
  3. Check the dba objects which are owned by schema accounts but created at SYSTEM or SYSAUX or USERS tablespace.
  4. Check the average connection count per user monthly
  5. Check the database size and compare it previous size
  6. Check tablespace status
  7. Check index and constraints status, contact the software developer for dropping disabled indexes or constraints
  8. Check the datafiles autoextensible and If they are auto extend then disable it.  
  9. Check the analyze objects or GATHER_STAT JOBS status ( at night)
  10. Check the default or temporary tablespace for each user

DB HEALTH CHECK CONTROLS 2- WEEKLY


Dba can check all test and development databases weekly.  These controls enclose open source databases, some commands oracle databases.

  1. Objects  fragmentation
  2. Size of tables and indexes
  3. Check for block corruption
  4. Disk usages
  5. Tablespace usages
  6. Check the cpu ratio
  7. Check open cursor not reaching the max limit
  8. Check the alert log and litener log
  9. Check the dba_jobs
  10. Check the crontab
  11. Check expired/locked  accounts


12 Nisan 2013 Cuma

New Database Features in Enterprise Manager Console 12 Cloud


 Oracle 12c Enterprise Manager Console installed on 11g release 2 database.Some new features tested and explained in turkish.

At step 27 shows Oracle still supporting STREAMS with new features !
 
 

4 Mayıs 2012 Cuma

Mysql 5.0.67 Security Gaps


9 Ocak 2008 Çarşamba

NEGATIVE Tablespace Size

One day..
Enterprise Manager Console also another monitor tools shows Data and index tablespace size's are negative. You can add another datafile or move another tablespace your tables or indexes.There is no change. So what must you do ?

SQL> Purge Dba_recyclebin;

Note: Check out your recyclebin BIN$ objects if it has neccessary one.