-
Recent Posts
- Oracle Dataguard in 5 Minutes
- fast provisioning with snapshot clones
- Performance drilldown
- recover standby database
- auditing – what the hell is going on in my database
- how to use SQL tuning advisor with SQL*Plus
- alter table … shrink space – and its progress
- ORA-01652: Who is using the temp tablespace?
- mystery performance issue with background process
Meta
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
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
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
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