-
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
Monthly Archives: July 2017
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