Pages

▼
Saturday, May 17, 2025

Root Cause Analysis for High Server Load on Oracle 19c Gold Tier Database

›
## Introduction This document provides a comprehensive guide for performing root cause analysis (RCA) on a Solaris-based server running Orac...
Thursday, April 24, 2025

longops.sql

›
  rem LONGOPS.SQL rem Long Running Statements rem Helmut Pfau, Oracle Deutschland GmbH set linesize 120 col opname format a20 col target for...

Planning relatede document from oracle for troubleshooting

›
  Script for Getting Correct Request IDs and their Corresponding Logs for Plan and Collection Run (Doc ID 262276.1) REQUESTS.sql Script for ...
Thursday, April 10, 2025

csv

›
 Prompt Title,Category,Purpose,Prompt (for LLM) Shift Handover Email,Email Communication,Summarize Oracle Apps DBA shift activity,"Writ...
Thursday, March 20, 2025

in

›
#!/bin/bash # Set the environment cd $HOME source Ebsapps.env run # Define variables REPORT_FILE="objects_report_$(date +%Y%m%d_%H%M%...
Tuesday, November 5, 2024

Tasks

›
Category,Prompt Incident Management,"Monitor incident queue and prioritize issues based on impact and urgency." Incident Managemen...
Friday, August 16, 2024

vb

›
' VBScript to convert a text file to a CSV file ' Create a FileSystemObject to handle the file operations Set objFSO = CreateObject(...
Sunday, October 15, 2023

directories

›
 SELECT      DIRECTORY_PATH,      LISTAGG(DIRECTORY_NAME, ', ') WITHIN GROUP (ORDER BY DIRECTORY_NAME) AS DIRECTORY_NAMES,     COUNT...