Tag Archives: oracle

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

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