All posts

  1. Home
  2. All posts
    3. (
  3. Page 15
    4. )
by Team Ajara

ORA-19870: error while restoring CDB backup piece.

ORA-19870: error while restoring backup piece.ORA-19507, ORA-27029 We received above mentioned errors while restoring a tape backup from prod environment to non-prod env. As soon as the restoration starts ,
by Team Ajara

Script to get CPU intensive queries in oracle

Script to get CPU intensive queries in oracle.     Query to get the SQL details that take more than 5 minutes ========================================================= SELECT sql_id, child_number, executions, elapsed_time, cpu_time, buffer_gets,
by Team Ajara

How to create new filesystem on ODA server

How to create new filesystem on ODA server?.   Creating ext4 Filesystem on Oracle Database Appliance(ODA) To create new filesystem and mount we need root credentials. Connect as a root
by Team Ajara

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
by Team Ajara

df command on Unix and Linux

df command on Unix and Linux df -k –> to get the o/p in KiloBytes (works on Linux n Solaris) df -h –> to get the o/p in GigaBytes (works
by Team Ajara

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
by Team Ajara

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