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 | 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

mystery performance issue with background process

recently I’ve got someĀ serious Performance issues on an 11.2 database. The mystery: Neither the AWR nor the ADDM report showed any obviously problems, but the linux system showed a very high load. So i tried to get some Kind of … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment