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

Posted in Uncategorized | Tagged , | Leave a comment

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

Posted in Uncategorized | Tagged , , , , | Leave a comment

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

Posted in Uncategorized | Tagged , | Leave a comment

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

Posted in Uncategorized | Tagged , | Leave a comment

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

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | 1 Comment

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

Posted in Uncategorized | Tagged | Leave a comment

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

Posted in Uncategorized | Tagged | Leave a comment