DBA Catalog

With this script you can monitor tablespaces sizes in oracle database. This script returns next columns: Tablespace - tablespace name Size M...

When there is some simple query which is using just is null criteria on big table, oracle cost based optimizer making table access full, so ...

 Hello, Today we faced below error when quering dba_jobs: SQL> select * from dba_jobs where job=4474623; select * from dba_jobs where jo...

Automatic database maintenance tasks is used by oracle for tunning SQL queries, gather stale or non existing statistics on objects and space...

Sometimes we are not getting alerts from OEM(Oracle Enterprise Manager) and if we try to check some metric values it is throwing error: ORA...