Oracle DBA Tutorial 5 - How to check tablespace size in Oracle database

preview_player
Показать описание
*****************************************************************************************
* How to check tablespace size in Oracle database *
*****************************************************************************************

Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba)
2. run the below commands.

For setting the tablespae colum format.
SQL⇒ col TABLESPACE_NAME format a20

for set the lines.
SQL⇒ set lines 900

Now copy the below code and paste in oracle cmd.
SQL⇒

The above command give you the list of tablespace with size details like allcated, used, free and Percentages also.

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be avilable in our website.
Link will be available in description.

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags
Рекомендации по теме
join shbcf.ru