Free views, likes and subscribers at YouTube. Now!
Get Free YouTube Subscribers, Views and Likes

How to work with Tablespaces in Real-Time? Tablespace Administration

Follow
DBA Genesis

A #tablespace is an allocation of space in an #Oracle #database where schema objects are stored. Watch this video to understand how to #administer tablespaces inside oracle database.

00:00 Tablespace Best Practices
05:58 Tablespace Utilization
10:50 Tablespace Threshold
15:07 Tablespace Alert Mechanism
17:13 Utilization Report
30:23 Temp Tablespaces Handling
37:09 Find Datafiles of a Tablespace
38:15 Extend Datafile
44:04 Add Datafile
46:37 Reclaiming space from Datafile
52:34 Drop a Datafile
53:54 Drop Tablespace
59:04 Drop an empty Datafile

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis  

posted by Hathawaybn