-
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: February 2017
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