When tablespace full in schema, you need to resize tablespace. This query will resize tablespace (resize to 20 Gb) :
Query Alter
alter database datafile ‘+DATA/DIARYCODING/DATAFILE /diarycoding.305.978198771’ resize 20G ;
When tablespace full in schema, you need to resize tablespace. This query will resize tablespace (resize to 20 Gb) :
Query Alter
alter database datafile ‘+DATA/DIARYCODING/DATAFILE /diarycoding.305.978198771’ resize 20G ;
For good performance in oracle need tunning your database. Can use Gather your schema database for the example :
Gather Schema :
BEGIN SYS.DBMS_STATS.GATHER_SCHEMA_STATS ( OwnName => 'DIARYCODING_DB' ,Granularity => 'DEFAULT' ,Options => 'GATHER' ,Gather_Temp => FALSE ,Estimate_Percent => 0 ,Degree => 4 ,Cascade => FALSE ,No_Invalidate => FALSE); END;
For good performance in oracle need tunning your database. Can use Build Table for the example :
Build Table :
BEGIN SYS.DBMS_STATS.GATHER_TABLE_STATS ( OwnName => 'DIARYCODING_DB' ,TabName => 'TRANSACTION' ,Estimate_Percent => 0 ,Degree => 4 ,Cascade => FALSE ,No_Invalidate => FALSE); END;