Posts Categorized: Technical Blog
Pythian is pleased to announce the new Flash Cache Query Tool for Oracle Exadata, developed by our Senior Consultant, and Oracle ACE, Christo Kutrovsky. This tool will be most valuable for Exadata DBAs and Exadata Architects that are trying to understand if the Oracle Exadata Flash Cache is used as envisioned.
Unfortunately, there is no easy way to monitor what’s in the Smart Flash Cache. Oracle only provided a “list flashcachecontent” command in the cellcli tool, it has no summarization options, and only displays object numbers. So I wrote this handy tool which lets you query the cell flash content on all cells, similarly, you can query the buffer cache (db_cache) contents in v$bh.
My presentation was on an Oracle Exadata implementation that we carried out and that I support on an ongoing basis. The presentation went well and everyone seemed to enjoy it, there were plenty of questions afterwards. We even managed to start a room discussion on columnar compression. The last presentation of the day was from Stewart Bryson on Agile DW with Exadata and OBIEE. All in all, an excellent day which was well run by UKOUG.
I saw an Interesting question on preventing human error posted on the DBA Managers Forum discussions today. I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too, so here we go…
In this blog post, I will cover 3 basic types of MySQL backups for stand-alone database systems. I will not be covering fancy GUI applications, or really complicated processes – just the basic concepts – which is what I think System Administrators (ie – non DBA’s) need to know to have a good/valid backup.
COLLABORATE … the ultimate yearly destination for knowledge transfer between peers … what a vehicle. I have missed one year of the IOUG show in the past 21 offerings. There is no better place to be in the spring of each calendar year … see you there.
Welcome to my first blog post in this series on database consolidation tips. Let’s get down to business…
Join Pythian’s Marc Fielding for this free webinar on Tuesday April 5, at 1pm ET with Miro Consulting to learn about the significant business and performance advantages of Oracle Exadata including reduced costs, shorter deployment time, superior performance, increased functionality and streamlined support based on real-life experience. This session will lend valuable insight as you begin your Oracle Exadata implementation project.
I’ve just published Oracle Database 11g Express Edition Amazon EC2 image (AMI) but most of you have never used Amazon EC2… Not until now! This is a guide to walk you thorough the process of getting your very first EC2 instance up and running. Buckle up — it’s going to be awesome!
That’s right folks! Playing with latest beta of free Oracle Database 11g Express Edition couldn’t be any easier than that. If you are using Amazon EC2, you can have a fully working image with 64 bit Oracle Linux and Oracle 11g XE database running in a matter of few clicks and a minute to get the instance to boot.