DBCollect/Considerations: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:DBCollect") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Category:DBCollect]] | [[Category:DBCollect]] | ||
= 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 (<code>--tasks</code> 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 <code>--tempdir</code> | |||
Revision as of 11:37, 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