What Enterprise IT Leaders Are Really Saying About AI
Enterprise AI has reached an interesting inflection point.
How much memory does an Oracle instance actually use? How much does each individual database connection consume? ...
Why this article? First of all, because I had fun digging in the code. Then, I was reading a lot about the improvements ...
Ruby's ActiveRecord provides a very robust means of manipulating database table structures especially in the context of ...
Background: Automatic degree of parallelism, or Auto DOP, is a new feature in 11gR2 that promises to help manage ...
Today I want to show what kind of IO performance we can get from Oracle Database Appliance (ODA). In this part, I will ...
After an in place upgrade of SQL server 2005 to SQL server 2008 R2 , I tried to open SQL errorlog from Management> ...
Quick Update This is just a quick post to share my first 3.1.1 Oracle VM Manager (OVMM) troubleshooting experience. ...
The biggest objection to Oracle Database Appliance (ODA) we hear from customers is about 4TB usable space limit ...
It’s a common but startling sight for any DBA: you look at your database statistics and realize your indexes are ...
A common scenario in the life of a DBA on a linux server looks something like this: From: Sue-the-sysadamin To:the-dba ...
Using pt-query-digest is an excellent way to perform a SQL review. However, sometimes you don't have access to the ...
Investigating the MySQL PASSWORD() Hashing Algorithm Recently we had a question from a customer: what is the hashing ...
Context A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user ...
Those of you who have seen me present about GoldenGate will know that I recommend using a heartbeat table to monitor ...
Backstory Where: Meeting room, Pythian office, Sydney, Australia. When: Afternoon, after lunch time. What: Discussion ...
Introduction I’ve started putting together some information about the Oracle Database Appliance in question-and-answer ...
I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error ...
After completing your Oracle VM and Oracle VM Manager installation, you are ready to start your friendship with Oracle ...
If you do any performance tuning, and everyone does, then you’ll come to a point where you want to know if your tables ...
Update Jan-2014: I’ve added a note on disabling triggers in Oracle 11.2.0.4 Introduction I recently blogged about an ...
It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors ...
Previous References ALL Pythian blog posts with Post Tag #SLOB My First Experience Running SLOB – Status Update 1 – or ...
I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging activity spikes on one of ...
Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by ...
TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or ...
I was recently puzzled by the question: “Which query will be faster?” SELECT * FROM table WHERE pk = x OR pk = x1 OR pk ...
Its all started from the question on communities.oracle.com An “enhancement” in 11.2 prevents RMAN duplicating non ...
Introduction Hello everyone ! For my first time posting here on the Pythian Blog, I would like to share some of my ...
It’s always interesting to dig into the spec sheets for Exadata hardware, especially when those "minor" details like ...
Introduction Hot on the heels of 11.2.0.3 coming out for Exadata, there’s yet another Exadata patch schedule out: the ...