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 ;

Continue reading

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;

Continue reading

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;

Continue reading