HomeФильмы и анимацияRelated VideosMore From: DBA Genesis

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

168 ratings | 15572 views
https://dbagenesis.com/p/oracle-11g-advanced-dba Oracle tablespace administration - Learn how to work on tablespaces in real-time. - Tablespace management tasks - Tablespace utilization - Add space to tablespace - Add new tablespace - Tablespace best practices - Drop tablespace A tablespace is constructed by Oracle from one or more operating system files through the use of the CREATE TABLESPACE command. Every Oracle database consists of at least one tablespace, called SYSTEM.
Html code for embedding videos on your blog
Text Comments (19)
yassir07 (3 months ago)
intersting Course.. could any one provide me the query for Checking-tablespace-utilization ?
Vinayak Budapanahalli (1 year ago)
Could you share the commands.txt file with us, if no concerns
shubham gupta (1 year ago)
your way of explaining things is awesome... really benefited a lot from all courses that i took from you.. thanx a tonn for your support and help :)
khempes khempes (1 year ago)
Hi where can we get the script ? Thank you
Shubham Jain (3 months ago)
+DBA Genesis Hi Genesis, I am not found any script on that URL it just open the dbagenesis home page KIndly provide the scripts related to tablespaces
DBA Genesis (1 year ago)
ORACLEGENESIS is not DBA Genesis. Please follow below link: https://dbagenesis.com/blog/528688/how-to-check-tablespace-utilization-in-oracle
Yash S (1 year ago)
same here cannot open any links or any web page
Nagarjuna Mekala (1 year ago)
Hi Genesis, I can't open the links of oraclegenesis.com sites, getting "ssl connection not establishing" error. Please try to resolve this issue.  Thanks.
Nagarjuna Mekala (1 year ago)
for some reason I can't access to your blog. and also to above link. Getting error like "SSL handshake failed" Can you help me to get into your blog?
iExpert DBA (1 year ago)
You are very good Please more videos
Vivek (1 year ago)
why system and sysaux tablespace must have 1.5 GB free space ?
DBA Genesis (1 year ago)
You can keep as low free space as possible. It is a recommendation if keep at least 1.5 GB free, you see a performance improvement as your database won't fight under low free space (on system and sysaux). Also, when you perform database upgrades, your system and sysaux will grow as new base tables get introduce. Oracle pre-upgrade utility itself will tell you to keep free space above 1GB in both. To maintain a good health, its good to keep 1.5 GB free.
veera reddy (1 year ago)
Explanation is very good. I learn more things based on this videos. May be we are looking for more videos.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.