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

Показать описание
*****************************************************************************************
* 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
* 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