Oracle DB Performance Issue n solution with sqltrpt

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

Disable Oracle database on RAC nodes

Disable Oracle database on RAC nodes One database with two instances were there  on two nodes in the full RACK Exadata(8 compute nodes). Want to disable the database as per

Reboot of Exadata Cell Nodes in Non-Rolling

Reboot of Exadata Cell Nodes in Non-Rolling High Level Steps: a) Increase Disk Repair Time in ASM, to avoid disks drop from ASM b) Execute All commands as root user

one-off patch on Exadata machine

one-off patch on Exadata machine. Path # 18110491 This patch is RAC Rolling Installable. https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=244241.1 This patch is Data Guard Standby-First Installable https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1265700.1 connect to exadata node1: shut down all

Pre checks for QFSDP on Exadata Environment

Pre checks for QFSDP on Exadata Environment.   What is QFSDP in Exadata? QFSDP is short form for QUARTERLY FULL STACK DOWNLOAD PATCH in Exadata environment. Quarterly full stack download

High CPU utilization on Exadata compute node 

High CPU utilization on Exadata compute node. Load Average  Load average can be verified by using  uptime  and top commands. With -c option  by using  top command ,we will get

Steps for replacing motherboard in Exadata

Steps for replacing motherboard in Exadata This activity is to perform on cellnode and it is considered as FRU replacement. Need to work with  Field Engineer  to complete this activity.