October 14, 2015

Monitoring TEMP Tablespace Usage

 -- The following query will return all users and their SIDs which are doing a sort  
 SELECT  b.tablespace, b.segfile#, b.segblk#, b.blocks, a.sid, a.serial#,   
      a.username, a.osuser, a.status  
 FROM   v$session a,v$sort_usage b  
 WHERE  a.saddr = b.session_addr  
 ORDER BY b.tablespace, b.segfile#, b.segblk#, b.blocks;  

October 8, 2015

Oracle iLOM fault management shell

Enter into iLOM fault management shell using below command
 -- Login to ILOM CLI  
 ssh root@ilom_ip_address_of_the_host  
 -- OR, from the host operating system (provided that ipmitool is configured)  
 # ipmitool sunoem cli  
 -- Start the faultmgmt shell  
 -> start /SP/faultmgmt/shell  
 Are you sure you want to start /SP/faultmgmt/shell(y/n)? y  

October 5, 2015

ADRCI: Create Incident Package

Below is just an example on how to use ADRCI to collect incident packages for Oracle Database Diagnosis.

October 1, 2015

Oracle Exadata Documentation

Till today, I saw a lot of people wonders and look for Exadata documentation.

Exadata documentation is publicly available for sometimes and available here: Oracle Exadata Database Machine Documentation