Enterprise Manager Generic (MOSC)

MOSC Banner

Script size too big for job system

edited Oct 25, 2010 4:57AM in Enterprise Manager Generic (MOSC) 5 commentsAnswered
I am trying to schedule a job through Grid Control that collects optimizer statistics for a number of schemas on a database, but when I try to submit the job I get the error "The size of the PL SQL Script is greater than the limit set by the Job System. Copy the PL SQL Sript and execute it directly on the target, or reduce the number of objects to be analyzed.".

I've trimmed the number of shchemas down a few times but I still get that error.  Is there a way that I can increase the script limit on the job system?  After trimming down so much I will have to create a whole bunch of jobs to cover all the schemas I wanted to have analyzed so I'd rather still have them as one large script if possible.

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