Oracle
Time ago I’ve added two Items: DBFileSize DBSize Those two items are calculated with those following query DBSize SELECT sum( NVL(a.bytes/1024/1024/10 – NVL(f.bytes/1024/1024/10, 0), 0)) retvalue FROM sys.dba_tablespaces d, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, sum(bytes) bytes FROM dba_free_space GROUP BY tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name [...]
Orabbix 1.0.4 is out about this release: Improved dynamic rebuild of databaselist Correct a critical bug in some case can Orabbix send wrong values now send always right values Correct template to easy import more news are coming stay tuned! you can download here Orabbix
Orabbix 1.0.3 is out On this release i’ve added: one items dbsize that shows the size of database in MB one item for db files size that graphs the size of files in MB added more log information on error correct archivelog query to run on every databases added a default value for uptime when [...]
I was working on an integration between Orabbix and Rman catalog, in the next release you will see this integration and how it’s work. Anyway all my backup with rman was used to have this problem: RMAN-08137: WARNING: archive log not deleted as it is still needed This is not really a “problem” it’s just [...]
Continue reading about Rman backup archive log finally work like a charm!
What Orabbix actually keep under his control: DBVersion (and relative validity of package) Archive ( archive log production with relative trend) EventWaits (monitor Files I/O,single block read, multiblock read, direct path read,SQLNet messages, Controlfile I/O,LogWrite) HitRatio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body) Logical I/O (monitor Logical I/O values of : Current Read, Consistent Read, [...]
sending...
