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”.
Everyone has a pattern or writing style when it come to SQL I’ve noticed. Some people use uppercase for keywords other people don’t, some start a column on a new line others don’t, people format differently, leaving commas at the end of the line vs at the beginning and many more niche ways people write.
Services or Service names in Oracle specify one or more names that clients can use to connect to an Oracle Database. It is a logical representation of a database. When an instance starts, it registers itself with the listener using one or more service names. They are a good way of separating various application connections
Introduction As an IT professional, especially one working closely with data, surely, almost definitely, you have been asked a question from the users along the lines of “Can we know what the value was of col1 in the table t1 at 25:00 on Thursday, the 30th of February 8000 years ago?” (Silly, but that’s really
Flashback Data Archive: Recreating History, After The Fact Read More »
Background Story time When I just started working as a DBA, the Senior Database Administrator was taking me through the environment and how everything was set up, including all the servers, databases, applications, and more. He was talking about one of the purchased applications that runs in production, and then explained that the vendor had
BACKGROUND Working in IT is one of those things: you love it, but sometimes it can annoy the hell out of you, and that 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 would make everyone wanna read this blog post; however, this one stood out to me, and I never
“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
