UP
Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
sys.x$unified_audit_trail takes more than an hour to complete while running gather_fixed_object_stats
07/11/17
12:44
Avatar
JoeClark
Membre
Members
Forum Posts: 66
Member Since:
27/09/17
sp_UserOfflineSmall Offline

Hi
I'm facing a situation where running the gather_fixed_object_stats takes too long to complete.
While other tables are done almost immediatedly sys.x$unified_audit_trail takes 1hour 18 minutes to complete.
The environment is 12.1.0.2 Oracle Linux.
Any idea why it takes so long and what can be done to make it run faster?
I didn't find the right solution from the Internet.

References:
https://community.oracle.com/thread/4095712

Best Whiteboard Animation

Forum Timezone: UTC 2

Most Users Ever Online: 70

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Ignius: 374

Bandana: 345

Pnj: 248

Dunpeal: 211

KhaBumm: 156

Sylarnash - AMMO: 145

Member Stats:

Guest Posters: 20

Members: 1972

Moderators: 0

Admins: 9

Forum Stats:

Groups: 2

Forums: 8

Topics: 599

Posts: 4736

Newest Members:

IshaiSlateodocrib, BettyEvila, johnnySic, Francisspasp, Jameschona, MeighEmpar

Administrators: JDW: 74, nikosh: 2, julia: 11, Jean-Baptiste: 0, Lévan: 9, IZI: 1, ywb: 0, Brennos: 490, Le0ben: 549