Author: Biju

www.bijoos.com
Posted on

Time Flies!

Just thought that I have not updated the blog for sometime, but did not realize it is almost 10 months since the last update… Time really flies…

Oracle Openworld is here, though this is my sixth or seventh OOW at SFO, 2012 is the first OOW where I am part of the event outside of participation…

Will be presenting on Thu 10/4 – EBS performance improvement tips… I know it is the last day of the conference and many may not stay back to attend the afternoon sessions in particular… If you are around and you are supporting an Oracle EBS instance [11i or R12], I think you would learn a thing or two from this presentation. As the title of the presentation “Improving Performance of E-Business Suite Application – Practical Tips from a DBA’s Diary…” says, the presentation is full of proven tips and techniques. If you happen to attend, please provide me feedback…

I will be at the Oracle Certification Lounge on Wed 10/3 at 1PM for a meet the author session. If you have any certification related questions or need guidance, don’t forget to stop by… you may also discuss the contents of  my 11g OCA certification exam study guide, and how it can help you get certified…

Also, I will be available most of the Exhibition hall hours at the OneNeck booth [415 Moscone South]… Stop by to say hello, or if you need to have a quick chat on architecture, tuning,  upgrades, administration or any topic related to EBS system administration or Oracle administration… No Exadata or EM12c yet 🙁

Have a great day!

Posted on

Sequences Nearing Limit

Happy New Year 2012! 

During the holidays we hit a production issue on the EBS instance. It was one of the Sequences reaching the maximum limit, but took a lot of time for our admins and Oracle support to figure out where the issue was… If we had the following SQL as part of the monitoring jobs, could have avoided the issue altogether…

This was added to monitoring tool immediately… 🙂

SELECT sequence_owner,
sequence_name,
last_number,
max_value,
cache_size
FROM dba_sequences
WHERE last_number > max_value - CASE
WHEN max_value > 50000 THEN 10000
ELSE 200
END
AND cycle_flag = 'N'
AND max_value != -1;