Author Archives: Benjamin
Oracle Dataguard in 5 Minutes
ok, although I wrote that there are plenty of websites and blogs describing how to create a dataguard standby, I’m doing one on my own… specially because my colleague asked me to write them a manual, so I decided to … Continue reading
fast provisioning with snapshot clones
Every DBA know’s the situations, where your boss / customer ask you to copy fresh data into the test database… since this blog is about oracle databases, we are solving this issue usually either with “datapump” or “rman duplicate” – … Continue reading
Performance drilldown
well, every dba might now these kind of phone calls, where a user is complaining about poor performance of the database… but if you ask questions like when or what part of the application is slow, you don’t get useful … Continue reading
recover standby database
well, oracle dataguard in general is rock solid (if configured well – but you will find a lot of guides in the internet how to do so)… but as always, sometimes something is not working as it should and the … Continue reading
auditing – what the hell is going on in my database
When I came into the office today, a colleague of mine was already waiting for me – one of our daily datapump exports has failed again. When looking into the log, I found this error message: ok, this shouldn’t happen … Continue reading
how to use SQL tuning advisor with SQL*Plus
because I’ve worked on a lot of environments where I only have ssh access, i cannot use graphical tools like Toad or SQL Developer… so I have to find a suitable way to tune sql statements with sql*plus… I’m just … Continue reading
creating a blog the nerd way – Part 2
part 1 is here… ok, now we have a clustered mysql (or better mariaDB) database running, next step is to setup the blog itself… Web Server to serve the blog, we have to install the webserver first – i decided … Continue reading
creating a blog the nerd way – Part 1
as you may already mentioned, I’ve got a blog (hey, you are here ^^)… creating a blog sounds very easy today – there are lots of websites offering free blogs, you just have to choose. But if you are a … Continue reading
alter table … shrink space – and its progress
well, there are a lot of good tutorials regarding when and how to use the “alter table … shrink space” command – and don’t panic, I won’t do another one 😉 just a few words to mechanism behind: the shrink … Continue reading
ORA-01652: Who is using the temp tablespace?
if you are getting the error “ORA-01652: unable to extend temp segment by 128 in tablespace TEMP” you could just increase the temp tablespace, i.e. by adding an additional tempfile… the smarter way would be to check who is consuming … Continue reading