Database Tuning (MOSC)

MOSC Banner

MOVING A SYSTEM TABLE TO ANOTHER TABLESPACE

Per the below AWR report is it advisable to move a System table to another tablespace belonging to a different schema?

Consider using ORACLE's recommended solution of automatic segment space
      management in a locally managed tablespace for the tablespace "SYSTEM"
      containing the TABLE "SYS.DBMS_LOCK_ALLOCATED" with object ID 16501.
      Alternatively, you can move this object to a different tablespace that
      is locally managed with automatic segment space management.
      Related Object
         Database object with ID 16501.


https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=197227736769715&id=1065384.1&_afrWindowMode=0&_adf.ctrl-state=zltpgmd8b_273

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center