2f.78. Buckets - Approx Totals (OCI360_BUCKETS)

#	NAME	APPROX_SIZE_GB	APPROX_COUNT
1	oci360	1.490502134896814823	166
2	oci360_bucket	.0157385608181357384	163
3	pnb_bucket	.0403500264510512352	232
#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 ETAG                                                                                         VARCHAR2(64)
 NAME                                                                                         VARCHAR2(16)
 NAMESPACE                                                                                    VARCHAR2(16)
 CREATED_BY                                                                                   VARCHAR2(128)
 KMS_KEY_ID                                                                                   VARCHAR2(4)
 VERSIONING                                                                                   VARCHAR2(8)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 IS_READ_ONLY                                                                                 VARCHAR2(8)
 STORAGE_TIER                                                                                 VARCHAR2(8)
 TIME_CREATED                                                                                 VARCHAR2(32)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 APPROXIMATE_SIZE                                                                             NUMBER
 APPROXIMATE_COUNT                                                                            NUMBER
 PUBLIC_ACCESS_TYPE                                                                           VARCHAR2(16)
 REPLICATION_ENABLED                                                                          VARCHAR2(8)
 OBJECT_EVENTS_ENABLED                                                                        VARCHAR2(8)
 OBJECT_LIFECYCLE_POLICY_ETAG                                                                 VARCHAR2(4)


select t.NAME,
       t."APPROXIMATE_SIZE"/POWER(1024,3) "APPROX_SIZE_GB",
       t."APPROXIMATE_COUNT" "APPROX_COUNT"
from   OCI360_BUCKETS t;


3 rows selected.