Step into my daily life as a DBA from routine tasks to the awkward gotchas to all of the really cool things that make the oracle database “AMAZING”.
BACKGROUND Working in IT is one of those things, you love it but sometimes it can annoy the hell out of you and this is extremely frustrating. You wake up in the morning, come to work, have plans of what you’re going to do and then… All hell breaks loose. It can be exciting and […]
The ORA-01017 invalid username/password; logon denied Read More »
I was attempting to do some work on one of the databases on a sandbox environment that had been shutdown for a few weeks; so I log on to the server, set my environment, connect as sys, issue the startup command and… I get the ORA-03113: end of file on communication channel! This was somewhat
Are you a database administrator grappling with performance issues? Don’t panic just yet! Discover essential strategies to troubleshoot and enhance your database performance. From identifying problematic SQL to understanding cardinality and execution plans, this guide offers practical insights drawn from real-world experience. Learn how to optimize your queries, leverage Oracle’s powerful tuning tools, and understand the critical role of database design in performance tuning. Whether you’re facing slow queries or just want to improve efficiency, this post is your roadmap to a faster, more responsive database. Dive in and transform your approach to performance tuning!
“If you have knowledge, let others light their candles in it.”Margaret Fuller. Ah yes, nothing like a good quote to make a point. Before writing this I actually went looking around for a cool attention grabbing headline that will make everyone wanna read this blog post however This one stood out to me and I
“I can’t connect to the database. Can you please check if it’s shutdown and start it up please, Thanks” I was asked by a savvy developer once upon a time, and when I did ” Start the database” I asked them to try connecting again and they could. I then replied the database was never
