Publisher review:OraRep is an Oracle report generator, used to create reports about your database activity statistics. OraRep is an Oracle Report Generator, used to create reports about your database activity statistics in a nice, human readable format - which in this case is HTML.
The generated report provides you with information on the physical database design (tablespaces, datafiles, memory), users and their privileges (such as e.g. quotas and profiles), statistical values on your databases efficiency and more. It is highly configurable concerning the report elements you need.
Due to its modular design, only the needed code (depending on the options you chose in the config file) will be build and executed, to save your database from unnecessary load.
OraRep reads its data out of several system views, such as the V$ and DBA_ views. These data are either presented as-is in a table (e.g. to list up all tablespaces together with their data files and sizes), or set in relation to other values to form indicators (such as "percent disk sorts") for performance analysis.
Together with these data, OraRep gives some descriptions on their meaning as well as ideas what they may point to or what actions are required from the DBA in order to bring the instance to a more efficient state. For some issues, even code pieces for possible required actions are given.
OraRep 0.3.5 is a Perl script for Database Tools scripts design by IzzySoft.
It runs on following operating system: Linux / Mac OS / Solaris.
Operating system:Linux / Mac OS / Solaris