All public logs

Combined display of all available logs of Dirty Cache Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 10:48, 9 December 2024 Bart talk contribs created page DBCollect/FAQ (Created page with "Category:DBCollect = Frequently Asked Questions = * Why can't we just send some AWR reports? AWR reports are great but have a few problems and limitations for our purpose: ** AWR only provides performance and limited configuration metrics. There is no database size/config information such as sizes of tablespaces, redo logs, temp files, segments, ASM disks/diskgroups, archive/flashback/bct files ** No OS configuration or hardware information (such as CPU type & mod...")
• 10:34, 9 December 2024 Bart talk contribs created page DBCollect/Credentials File (Created page with "Category:DBCollect = Using a credentials file = Some customers asked for a way to run {{dbcollect}} without <code>oracle</code>, or <code>sysdba</code> (OPS$ connection) privileges. Using <code>OPS$</code> connections as <code>sysdba</code> user has the huge advantage that the user does not have to enter any passwords for connecting to the databases, as SQL*Plus will connect as sysdba with OS privileges. The user (usually <code>oracle</code>) needs <code>dba</code...")
• 10:01, 9 December 2024 Bart talk contribs created page DBCollect/Troubleshooting (Created page with "Category:DBCollect = DBCollect Troubleshooting = == Tips == * Debug : If something fails, run dbcollect with the <code>-D</code> (debug) option. This will show the content of exception debug messages and print the full dbcollect.log logfile when finished.")
• 09:58, 9 December 2024 Bart talk contribs moved page DBCollect/Manual to DBCollect/Manuals without leaving a redirect (Misspelled title)
• 09:55, 9 December 2024 Bart talk contribs created page DBCollect/Manual (Created page with "Category:Tools Category:DBCollect = DBCollect Manuals = # DBCollect Overview # DBCollect Considerations # DBCollect Security and safety # DBCollect Installation # DBCollect Usage # DBCollect Command-line options") Tag: Visual edit: Switched
• 09:54, 20 November 2024 Bart talk contribs created page Template:PageBreak (Created page with "<div style="page-break-after: always;"></div>")
• 14:59, 5 November 2024 Bart talk contribs created page DBCollect/Build (Created page with "Category:Tools Category:DBCollect = Building DBCollect from Git repo =")
• 14:40, 5 November 2024 Bart talk contribs created page DBC:Errors/Executing (Created page with "Category:DBCollect")
• 14:30, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E041 (Created page with "Category:DBCollect {{error|[DBC-E041] <sid>: SQLPlus query failed, returncode=<rc> (see logfile)}} An SQL query used to retrieve metadata failed for some reason (logfile <code>dbcollect.log</code> should show more details) Solution: Diagnose the error or send the output of the logfile. {{PrevNext|DBC:Errors/DBC-E040|DBC:Errors/DBC-E041}}")
• 14:26, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E040 (Created page with "Category:DBCollect {{error|[DBC-E040] <sid>: [%s] Cannot execute AWR generation procedure [ORA-???:<message>]}} Creating AWR reports failed with the given Oracle message. More debug info should be in the <code>dbcollect.log</code> file. The most likely cause is not having <code>EXECUTE</code> privileges on the <code>DBMS_WORKLOAD_REPOSITORY</code> procedures. Solution: <code>GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user></code> {{PrevNext|DBC:Errors/DBC-E03...")
• 14:22, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E039 (Created page with "Category:DBCollect {{error|[DBC-E039] <sid>: Incomplete set of workload reports (failed workers)}} Some worker processes failed (either due to timeouts or due to AWR generation issues. Solution: If there are timeout messages, diagnose AWR timeouts. For other errors, please provide the logfile. {{PrevNext|DBC:Errors/DBC-E038|DBC:Errors/DBC-E040}}")
• 14:17, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E038 (Created page with "Category:DBCollect {{error|[DBC-E038] <sid>: Insufficient privileges on V$ tables (ORA-???:<Oracle message>)}} The connection to instance <sid> failed because the user has no privileges to read <code>V$<code> or <code>DBA_*</code> tables. Solution: Grant <code>SELECT ANY DICTIONARY</code> to the user listed in the credentials file {{PrevNext|DBC:Errors/DBC-E037|DBC:Errors/DBC-E039}}")
• 14:16, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E037 (Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Insufficient privileges (ORA-???:<Oracle message>)}} The connection to instance <sid> failed because the user has no <code>CREATE SESSION</code> privileges Solution: Grant <code>CREATE SESSION</code> to the user listed in the credentials file {{PrevNext|DBC:Errors/DBC-E036|DBC:Errors/DBC-E038}}")
• 14:13, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E036 (Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: TNS connection issue (ORA-???:<Oracle message>)}} An SQL*Plus error occured related to TNS networking - the <code>dbcollect.log</code> file should show the full output of the error message Solution: Diagnose the connection problem (try manually connecting using SQL*Plus and the given connect url from the credentials file) {{PrevNext|DBC:Errors/DBC-E035|DBC:Errors/DBC-E037}}")
• 14:11, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E035 (Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Unknown Oracle error, see logfile (ORA-???:<Oracle message>)}} An unknown SQL*Plus error occured - the <code>dbcollect.log</code> file should show the full output of the error message Solution: Unknown, please provide the contents of the logfile {{PrevNext|DBC:Errors/DBC-E034|DBC:Errors/DBC-E036}}")
• 14:09, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E034 (Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Invalid credentials provided (ORA-???:<Oracle message>)}} Invalid username/password provided in the credentials file for the given instance Solution: Update the entry to the credentials file {{PrevNext|DBC:Errors/DBC-E033|DBC:Errors/DBC-E035}}")
• 14:07, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E033 (Created page with "Category:DBCollect {{error|[DBC-E033] <sid>: Instance not available (ORA-???:<Oracle message>)}} The instance <sid> is not in OPEN mode, so {{dbcollect}} cannot connect to it using TNS connection string. The instance may be in MOUNTED mode (Standby database) or in STARTED mode. Solution: * Skip the instance using an <code>N</code> in the 2nd field of the credentials file. * Open the database (if it should be opened) * Run {{dbcollect}} as oracle user without cred...")
• 14:03, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E032 (Created page with "Category:DBCollect {{error|[DBC-E032] Cannot read credentials file <file>}} A running Oracle instance has been detected, a credentials file is specified but it cannot be read by {{dbcollect}} Solution: Check permissions of the credentials file. The user {{dbcollect}} runs as, may not have access. {{PrevNext|DBC:Errors/DBC-E031|DBC:Errors/DBC-E033}}")
• 14:02, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E031 (Created page with "Category:DBCollect {{error|[DBC-E031] <sid>: No valid ORACLE_HOME provided (try --orahome)}} A running Oracle instance has been detected, but no ORACLE_HOME is detected to use with the instance. Potential cause: No entry in <code>/etc/oratab</code> or the permissions do not allow the user to read this file. Solution: Verify contents and permissions of the <code>oratab</code> file. {{PrevNext|DBC:Errors/DBC-E030|DBC:Errors/DBC-E032}}")
• 14:00, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E030 (Created page with "Category:DBCollect {{error|[DBC-E030] <sid>: Timeout connecting to instance}} {{dbcollect}} could not connect with the instance <sid> within the given timeout (currently 2 seconds). Solution: Figure out why connecting using SQL*Plus takes so long {{PrevNext|DBC:Errors/DBC-E029|DBC:Errors/DBC-E031}}")
• 13:58, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E029 (Created page with "Category:DBCollect {{error|[DBC-E029] <sid>: No credentials provided)}} A running Oracle instance has been detected, a credentials file is specified but it has no entry for the given instance. Solution: Add an entry to the credentials file {{PrevNext|DBC:Errors/DBC-E028|DBC:Errors/DBC-E030}}")
• 13:53, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E028 (Created page with "Category:DBCollect {{error|"[DBC-E028] Cannot obtain oracle base directory (<file>)}} The orabasetab file cannot be opened. Solution: Check the permissions on this file {{PrevNext|DBC:Errors/DBC-E027|DBC:Errors/DBC-E029}}")
• 13:50, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E027 (Created page with "Category:DBCollect {{error| [DBC-E027] <sid>: No valid connection (check credentials?) }} {{dbcollect}} could not make a valid connection to Oracle instance <sid>. Solution: Try again with different credentials (if using a credentials file) or specify an alternative ORACLE_HOME using <code>--orahome</code> {{PrevNext|DBC:Errors/DBC-E026|DBC:Errors/DBC-E028}}")
• 13:47, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E026 (Created page with "Category:DBCollect {{error|[DBC-E026] <sid>: Parsing instance info failed}} Retrieving metadata for instance <sid> failed. Solution: Unknown, submit the logfile for debugging. {{PrevNext|DBC:Errors/DBC-E025|DBC:Errors/DBC-E027}}")
• 13:45, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-E025 (Created page with "Category:DBCollect {{error|Not a valid NMON file: <file>}} The file listed is not a valid NMON file. Solution: Unknown, submit the logfile for debugging. {{PrevNext|DBC:Errors/DBC-E024|DBC:Errors/DBC-E026}}")
• 13:41, 5 November 2024 Bart talk contribs moved page DBC:Errors/W009 to DBC:Errors/DBC-W009 without leaving a redirect
• 13:40, 5 November 2024 Bart talk contribs moved page DBC:Errors/W008 to DBC:Errors/DBC-W008 without leaving a redirect
• 13:38, 5 November 2024 Bart talk contribs created page DBC:Errors/W009 (Created page with "Category:DBCollect {{ error | [DBC-W009] sysstat timer not active, not collecting OS performance data }} The sysstat timer is not enabled. Sysstat is used to retrieve OS performance statistics. Solution: Enable the sysstat timer. <syntaxhighlight lang=bash> # as root # Enable (newer, systemctl based distro's): systemctl enable --now sysstat-collect.timer </syntaxhighlight> {{PrevNext|DBC:Errors/W007|DBC:Errors}}")
• 13:35, 5 November 2024 Bart talk contribs created page DBC:Errors/W008 (Created page with "Category:DBCollect {{ error | [DBC-W008] sysstat not installed, not collecting OS performance data }} The sysstat RPM package is not installed. Sysstat is used to retrieve OS performance statistics. Solution: install (and enable where needed) the sysstat package. <syntaxhighlight lang=bash> # as root yum install -y sysstat # or (newer RHEL and compatibles) dnf install -y sysstat # or (SuSE) zypper in sysstat # Enable (newer, systemctl based distro's): systemctl e...")
• 13:27, 5 November 2024 Bart talk contribs created page DBC:Errors/DBC-W007 (Created page with "Category:DBCollect {{ error | [DBC-W007] Skipping %s: disabled in credentials file }} A detected instance is not processed because a credentials file is used and the "enabled" field in the credentials file is set to "N". This is needed to avoid trying to connect to a MOUNTED (Standby DB instance) or STARTED instance, resulting in all kinds of errors. {{PrevNext|DBC:Errors/W006|DBC:Errors}}")
• 15:56, 10 October 2024 Bart talk contribs created page DBCollect/Security (Created page with "Category:DBCollect = dbcollect safety, security and confidentiality = == Purpose == The purpose of {{dbcollect}} is to provide an easy, standardized, automated way to collect (Oracle) database workload and configuration information, as well as Unix/Linux performance and configuration statistics. The collected data is used for: * Database platform sizings * Performance analysis and troubleshooting * Calculation of possible TCO reduction / system efficiency * Insi...")
• 15:20, 10 October 2024 Bart talk contribs created page Template:PrevNext (Created page with "<noinclude> This template makes it easy to include Previous and Next links, with arrows (like the ones below).<br> Simply include <nowiki>{{PrevNext|Name of previous Page|Name of Next Page}}</nowiki> where you want to see these links.<br> For more information on templates see w:Help:Template ==See also== *Template:Next *Template:Prev ---- </noinclude> <div class="navigation" style="float:right;"><span class="arrowprev">link={{{1}}}</spa...")
• 15:19, 10 October 2024 Bart talk contribs created page Template:Next (Created page with "<noinclude> This template makes it easy to include Next link, with arrow (like the one below).<br> Simply include <nowiki>{{Next|Name of Next Page}}</nowiki> where you want to see this link.<br> For more information on templates see w:Help:Template This template is based on Template:clickpic which can be used for similar effects. ==See also== *Template:PrevNext *Template:Prev ---- </noinclude> <div class="navigation arrownext" style="float:right;">File...")
• 15:18, 10 October 2024 Bart talk contribs created page File:Next.png
• 15:18, 10 October 2024 Bart talk contribs uploaded File:Next.png
• 15:17, 10 October 2024 Bart talk contribs created page File:Previous.png
• 15:17, 10 October 2024 Bart talk contribs uploaded File:Previous.png
• 15:13, 10 October 2024 Bart talk contribs created page Template:Prev (Created page with "<noinclude> This template makes it easy to include Previous links, with arrows (like the one below).<br> Simply include <nowiki>{{Prev|Name of previous Page}}</nowiki> where you want to see the links.<br> For more information on templates see w:Help:Template ==See also== *Template:PrevNext *Template:Next ---- Prev </noinclude> <div class="navigation arrowprev" style="float:right;">File:Previous.png|li...")
• 14:59, 10 October 2024 Bart talk contribs created page File:Dbcollect-logo.png
• 14:59, 10 October 2024 Bart talk contribs uploaded File:Dbcollect-logo.png
• 14:51, 10 October 2024 Bart talk contribs created page File:Quote measurement.png
• 14:51, 10 October 2024 Bart talk contribs uploaded File:Quote measurement.png
• 14:16, 10 October 2024 Bart talk contribs created page DBC:Errors/DBC-E024 (Created page with " {{ error | [DBC-E024] NMON directory not found <path> }}")
• 12:17, 10 October 2024 Bart talk contribs created page DBCollect/Options (Created page with "Category:DBCollect = Explanation of all options = == help == <code>--help</code> or <code>-h</code> Shows usage (list of all arguments) == version == <code>-V | --version</code> Shows detailed version, build and copyright details == debug == <code>-D | --debug</code> enables debugging. This will result in more logging (sometimes dumping unhandled Python exceptions and traces. Even without this option, debug info is written to the {{dbcollect}} logfile for...")
• 11:31, 10 October 2024 Bart talk contribs created page DBCollect/Considerations (Created page with "Category:DBCollect")
• 09:30, 30 July 2024 Bart talk contribs created page Category:Postgres (Created blank page)
• 09:30, 30 July 2024 Bart talk contribs created page PyPGIO (Created page with "Category:Tools Category:Postgres = Overview = [https://github.com/bsjerps/pypgio PyPGIO] is a Python based I/O generator for PostgreSQL databases. The only purpose is to drive (a lot of) I/O from a Postgres database without requiring a lot of CPU resources. It is based on, and uses some code from PGIO by Kevin Closson, see [https://github.com/therealkevinc/pgio PGIO] for more details.")
• 11:19, 13 June 2024 Bart talk contribs created page AWR Performance (Created page with "Category:DBCollect {{stub}} = Overview = Sometimes, generating AWR reports can be very slow. This article lists some potential remedies. * Solution 1 <syntaxhighlight lang=sql> alter session set "_push_join_predicate"=false; OR alter session set "_optimizer_push_pred_cost_based" = false; </syntaxhighlight>")
• 14:23, 28 May 2024 Bart talk contribs created page Template:Dbinfo (Created page with " ''dbinfo''")
• 14:22, 28 May 2024 Bart talk contribs created page DBCollect/DBInfo (Created page with " = Overview = {{dbinfo}}")