You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SM/ADVISOR Occupies almost all Storage on Always Free ATP DB

edited Apr 16, 2022 7:54AM in Autonomous Database

Content

I have created a free tier ATP database some time ago. Recently, I note that almost all space (out of the 20GB available) were occupied by Oracle automated jobs, esp SM/ADVISOR. The largest segments were SYS objects. Since the ADMIN user is not a DBA user and cannot admin (actually cannot even select) the tables, is there any means to free the space? Or it is unable to add data anymore?

The 3 largest LOBs belong to following tables:

  • SQLOBJ$PLAN
  • WRI$_ADV_OBJECTS
  • WRI$_SQLSET_PLAN_LINES

Since ATP is billed by storage, Oracle should allow user to control the space used by those automate jobs.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!