DBCollect/Usage: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
# Limit dbcollect to use only 2 tasks (CPUs) for AWR generation (default = 50% of CPUs, with a maximum of 8) | # Limit dbcollect to use only 2 tasks (CPUs) for AWR generation (default = 50% of CPUs, with a maximum of 8) | ||
dbcollect --tasks 2 | dbcollect --tasks 2 | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 42: | Line 41: | ||
# If the problem databases are not important, try excluding them: | # If the problem databases are not important, try excluding them: | ||
dbcollect --exclude inst1,inst2 | dbcollect --exclude inst1,inst2 | ||
</syntaxhighlight> | |||
</ | == Oracle RAC == | ||
On RAC, {{dbcollect}} will generate AWR reports for ''all'' instances on all nodes. This means if you run {{dbcollect}} on all RAC nodes (which is recommended) then all AWR reports will be generated multiple times (2 times for a 2-node cluster). To avoid this, run with the <code>--no-rac</code> option. This will cause AWR reports ONLY to be generated for the actual node, and saves on diskspace and resource overhead. | |||
== Oracle Data Guard == | |||
Revision as of 12:20, 10 October 2024
Usage
Short summary
If dbcollect is installed correctly:
# Simply run dbcollect
dbcollect
# Error: Zipfile already exists
# Overwrite previous zipfile
dbcollect --overwrite
# Error: No AWR or Statspack detected
# If you are sure the system is licensed with Diagnostics Pack
dbcollect --overwrite --force-awr
# If you want to retrieve more than 10 days worth of AWR files:
dbcollect --days 20
# Limit dbcollect to use only 2 tasks (CPUs) for AWR generation (default = 50% of CPUs, with a maximum of 8)
dbcollect --tasks 2
Resolve AWR reporting issues
dbcollect checks for prior AWR usage to make sure it will not trigger Oracle license violations ( More info)
If you get Error [DBC-E021] No AWR or Statspack detected:
# If you are sure you have Diagnostics Pack license:
dbcollect --force-awr
# If you want to ignore databases without AWR usage:
dbcollect --ignore-awr
# If the problem databases are not important, try excluding them:
dbcollect --exclude inst1,inst2
Oracle RAC
On RAC, dbcollect will generate AWR reports for all instances on all nodes. This means if you run dbcollect on all RAC nodes (which is recommended) then all AWR reports will be generated multiple times (2 times for a 2-node cluster). To avoid this, run with the --no-rac option. This will cause AWR reports ONLY to be generated for the actual node, and saves on diskspace and resource overhead.