DBCollect/Considerations: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
* The generated ZIP file can be several 100 MB up to several GB if there are lots of databases | * The generated ZIP file can be several 100 MB up to several GB if there are lots of databases | ||
* Make sure there is enough space in /tmp or change tmpdir with <code>--tempdir</code> | * Make sure there is enough space in /tmp or change tmpdir with <code>--tempdir</code> | ||
== Safety and security == | |||
* 100% open source (Python distribution package can be inspected) | |||
* Does NOT run as root (even if it is executed as root) | |||
* Does NOT make network connections (exception is ‘--update’) | |||
* Runs as the Oracle user (usually ‘oracle’) or ‘nobody’ | |||
* Does not modify any database or OS data | |||
* Only performs SELECT statements | |||
* Only picks up DB and system metadata (no application data, passwords, etc) | |||
* Data can be inspected with regular UNZIP | |||
Revision as of 11:38, 10 October 2024
Things to consider
Running time
- Anywhere from few minutes (small system) to many hours (system with lots of databases)
- Overhead: by default, restricted to 8 parallel tasks (CPUs) – can be increased or lowered (
--tasksoption) - Oracle RAC is known to sometimes run very long to generate AWRs
- dbcollect retrieves performance data already available on the system (AWR/Statspack, SYSSTAT)
File size
- The generated ZIP file can be several 100 MB up to several GB if there are lots of databases
- Make sure there is enough space in /tmp or change tmpdir with
--tempdir
Safety and security
- 100% open source (Python distribution package can be inspected)
- Does NOT run as root (even if it is executed as root)
- Does NOT make network connections (exception is ‘--update’)
- Runs as the Oracle user (usually ‘oracle’) or ‘nobody’
- Does not modify any database or OS data
- Only performs SELECT statements
- Only picks up DB and system metadata (no application data, passwords, etc)
- Data can be inspected with regular UNZIP