• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

stop 10G Automatic Statistics Generation process manually

Hello everybody,

Does anyo one know how to stop 10G Automatic Statistics Generation process manually(not using EGC)?

thanks,
Mia
0
milanushka
Asked:
milanushka
  • 3
  • 2
1 Solution
 
rbrookerCommented:
Hi,

set the parameter STATISTICS_LEVEL to basic in your pfile / spfile.
looking on the net however, this stops a heap of other oracle 10g features.
here is some more information about it : http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams208.htm

good luck.

:)
0
 
milanushkaAuthor Commented:

After setting statistics_level to BASICmy db wouldn't start with error

Cannot set sga_target with statistics_level=BASIC

No luck:(
0
 
rbrookerCommented:
Hi,

Do you have automatic SGA sizing turned on?  This is one of the "features" of oracle 10g that is affected by disabling automatic stats.

----- FROM ORACLE WEBSITE -----
Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:

Automatic Workload Repository (AWR) Snapshots
Automatic Database Diagnostic Monitor (ADDM)
All server-generated alerts
AUTOMATIC SGA MEMORY MANAGEMENT  <---- this would be affecting you starting up the database.
Automatic optimizer statistics collection
Object level statistics
End to End Application Tracing (V$CLIENT_STATS)
Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
Service level statistics
Buffer cache advisory
MTTR advisory
Shared pool sizing advisory
Segment level statistics
PGA Target advisory
Timed statistics
Monitoring of statistics
----- -----

me? i would turn automatic stats back on.

:)
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
milanushkaAuthor Commented:

 I agree that auto stats should be on. If I could just stop auto schema analysis, I would be in business

Thanks,
Mia
0
 
rbrookerCommented:
have found the answer in the mean time ...

sqlplus /nolog
connect / as sysdba;

EXECUTE DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');

commit;
exit;

:\
0
 
Computer101Commented:
PAQed with points refunded (50)

Computer101
EE Admin
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now