|
|
Hi Erman,
We have DBCS DB system with 1CDB with 1PDB in OCI
version 19.28
ASM single node
Unfortunately, We have provisioned DB instance with 8 TB storage but the actual we need is 1TB.
Space is wasted in this case, you can see each disk usage in below output. We want to reduce the size to 1TB from 8TB.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PRODDB1 READ WRITE NO
SQL> alter session set container=PRODDB1;
Session altered.
NAME STATE TYPE SIZE_GB AVAILABLE_GB USED%
------------------------------ ----------- ------ ---------- ------------ ----------
DATA CONNECTED EXTERN 8192 7909.79 3.44
RECO CONNECTED EXTERN 2048 2022.33 1.25
Disk Group Disk Name SIZE_GB AVAILABLE_GB USED%
------------------------------ ------------------------------ ---------- ------------ ----------
DATA DATA_0000 1024 988.68 3.45
DATA DATA_0001 1024 988.75 3.44
DATA DATA_0002 1024 988.75 3.44
DATA DATA_0003 1024 988.71 3.45
DATA DATA_0004 1024 988.72 3.45
DATA DATA_0005 1024 988.73 3.44
DATA DATA_0006 1024 988.75 3.44
DATA DATA_0007 1024 988.71 3.45
RECO RECODISK1 512 505.52 1.27
RECO RECODISK2 512 505.57 1.26
RECO RECODISK3 512 505.63 1.25
RECO RECODISK4 512 505.62 1.25
12 rows selected.
SQL> SELECT ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS total_size_gb
FROM dba_data_files; 2
TOTAL_SIZE_GB
-------------
240.28
SQL> SELECT ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS used_size_gb
FROM dba_segments; 2
USED_SIZE_GB
------------
181.88
SQL>
What action plan to follow in our case. Can you please guide us.
Thank You,
SG
|
Locked
