DBCollect/Considerations

From Dirty Cache Wiki
< DBCollect
Revision as of 11:37, 10 October 2024 by Bart (talk | contribs)
Jump to navigation Jump to search


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
Retrieved from "https://wiki.dirty-cache.com/index.php?title=DBCollect/Considerations&oldid=355"