Questions to ask application user for better understanding of the Performance Issue. There are is no step by step process to fix the performance issues. But if we have some
Pinning the plan hash value in Oracle Database to resolve performance issue. Overview of the issue Query was running slow in Datawarehouse database .Resolved by creating sqlprofile using coe_xfr_sql_profile.sql script.
Oracle Query Performance issue and solved by accepting sql profile. Overview of the issue Oracle Query from application running was slower than the previous execution. DB version is 12.1.0.2.0
Checklists for Oracle Database change requests(CRs). Pre-Implementation Checks 1) OS/Database/schema valid Backups to be taken before the activity Check if OS/Database/schema valid Backups have been taken (Y / N)
Flashback RAC database to restore point. While doing flashback RAC DB we will start one instance in mount and another instance will be in shutdown state. High Level Steps 1)select
Adding new Disks in ASM DiskGroup Get the LUN #/ name from the Unix/storage team,and follow the below steps. Step 1 :List the mapper details # cd /dev/mapper/ #
Command Prompts in Unix and Linux Operating systems. Command Prompt is a built-in feature in computers that allows users to interact with their operating system through a command-line interface.
Shutdown and Startup of Exadata CellNode in Rolling High Level Steps: a) Increase Disk Repair Time in ASM, to avoid disks drop from ASM b) Execute All commands as
How to invoke GUI by using MobaXterm. To install Oracle database/Client software or configurations by using tools in GUI mode on Linux or Unix systems , we need Xwindows software
Database Migration steps from windows 2003 to Exadata DB Server : Steps @(windows) Source server: 1.Connect to the database Cmd>set oracle_sid=<sidname> Cmd>sqlplus sys as sysdba Password:<password>
