This content has been marked as final. Show 7 replies
this is a known bug in 11.2 XE. It concerns the database job that would regularly update your tables statistics to ensure the optimizer will always get a good execution plan for queries. Whether you need it or not depends on how you use your database. But it certainly won't harm to fix the issue. To do so, you can run the follwing command sequence
I integrated this snippet in my personal "post-install" script, among with some other adjustments for OS-specific settings, database parameters and the fix for the mixed up datafiles (sysaux and undo).
cd $ORACLE_HOME/rdbms/admin sqlplus / as sysdba @catnsnmp @catsnmp shutdown immediate; startup; exit
Thanks Udo for your reply,
in the process of a scripting installation i do a shutdown and startup.
Is there a listing and explanation of all scheduler jobs?
Sure, you can query the corresponding dba-view dba_scheduler_jobs to get an overview.
For just knowing what's there, you can run
You'll see a short description for most predefined jobs in the comments section. If you want to know more, I recommend "RTFM" or your preferred search engine on the job name.
SELECT job_name, comments FROM dba_scheduler_jobs ORDER BY job_name;
Thanks, i know that.
I would like to have 'RTFM', where can i find?
To be honest, there is no "all in one" view from Oracle directly. You either have to start with third-party sources (e. g. [url http://www.asktherealtom.ch/?p=147]Oracle 11g Default Jobs) or go through the docs based on their topic.
For the latter, a good start would be the Oracle Database Administration Guide, e. g. in Part IV on [url http://docs.oracle.com/cd/E18283_01/server.112/e17120/part6.htm#i996746]Database Resource Management and Task Scheduling. Then, there is the documentation for the [url http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#CHDEBFCH]DRA (Data Recovery Advisor). And so on. I'm not sure a "everyday" XE-dba would want to dig deeper into that area, unless you have an actual call for it.
Yes, it's missing in the windows-version also.