From the course: Learning Oracle Database 12c
Join today to access over 25,300 courses taught by industry experts.
Manage TEMP tablespaces - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Manage TEMP tablespaces
- [Instructor] Let's talk about Oracle Temporary Tablespaces. Remember that temporary tablespaces contain temporary segments, in other words, those needed by an individual query or several users, and they go away after the query is done or the DML has been committed. You can have several different temporary tablespaces active at the same time. You might have a couple tablespaces for the ETL users, one general and another temporary tablespace for the report users. This helps isolate the disk space. It makes sure that a given user or set of users will have the temporary tablespace they need to get their job done. Ideally you wouldn't need temporary tablespaces. Even with terabyte memory footprints in your servers, you still might exceed that space allocation in real memory, so if it won't fit in the SGA or PGA, it will often overflow to the temporary tablespace, and perform sorts, merges, order by, and so forth. When you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.