After speaking about mutex waits last year, this time DOAG accepted my lecture “Oracle Architektur – nicht nur für Einsteiger” about Oracle Database basic architecture for this year’s DOAG Konferenz 2013 in Nürnberg. It will be the first lesson in a brand-new stream of the conference: The so-called “Einsteigerpaket” (beginners package) allows […]
Tag: undo
Oracle: Change (default) TEMP and UNDO tablespace to bigfile tablespaces
That’s how to change the Oracle Database’s TEMP and UNDO tablespaces to bigfile (as possible in 10g and above). It’s something I usually do for every DB I install. create bigfile temporary tablespace TEMP1 tempfile \ size 10G autoextend on next 1G maxsize 20G; create bigfile undo tablespace UNDO1 datafile \ size 10G autoextend on […]