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

Question
9
Views
0
Comments
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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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