DBCollect/Considerations

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 (--tasks option)
• 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