1 Reply Latest reply on May 15, 2012 5:08 PM by damorgan

    Change values from SYS.SYSTEMSTATS table

      How to change the values in those columns,what are the maximum value i can include.What are the benefits i improve increasing those values


        • 1. Re: Change values from SYS.SYSTEMSTATS table
          I have no idea where you are looking.
          SQL*Plus: Release - Production on Tue May 15 10:06:14 2012
          Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
          Connected to:
          Oracle Database 11g Enterprise Edition Release - Production
          With the Partitioning, Oracle Label Security, OLAP, Data Mining,
          Oracle Database Vault and Real Application Testing options
          orabase> select owner, object_type
            2  from dba_objects
            3  where object_name = 'SYSTEMSTATS';
          no rows selected
          but if you alter the contents of any object owned by SYS ... without written permission to do so from Oracle support ... do not expect Oracle to do more than refuse to provide you with support. Something that will likely make your employer rather unhappy.