Unable to save or run scenarios

When a new test is being saved, it fails indicating only unable to save the test, or when a scenario previously created is being tried to be used the workload tab doesn’t work.

The w3wp log shows the below error

ORA-01653: unable to extend table MI_LRDB.SCHEDULERS by 8 in tablespace USERS

Failed to allocate an extent for table segment in tablespace.

This error does not necessarily indicate whether or not you have enough space in the tablespace, it merely indicates that Oracle could not find a large enough area of free contiguous space in which to fit the next extent.

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated, velow few possible ways to fix this.

Manually Coalesce Adjacent Free Extents

ALTER TABLESPACE COALESCE;

The extents must be adjacent to each other for this to work.

– Add a Datafile:

ALTER TABLESPACE ADD DATAFILE ” SIZE ;

– Resize the Datafile:

ALTER DATABASE DATAFILE ” RESIZE ;

– Enable autoextend:

ALTER DATABASE DATAFILE ?? AUTOEXTEND ON MAXSIZE UNLIMITED;

– Defragment the Tablespace:

– Lower "next_extent" and/or "pct_increase" size:

ALTER STORAGE ( next pctincrease );

– If the tablespace is being used as a temporary tablespace, temporary segments may be still holding the space.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s