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

    Change values from SYS.SYSTEMSTATS table

    927253
      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

      LOCK_TIMEOUTS

      LOCK_GRANTS_WAIT
        • 1. Re: Change values from SYS.SYSTEMSTATS table
          damorgan
          I have no idea where you are looking.
          SQL*Plus: Release 10.2.0.2.0 - 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 11.2.0.2.0 - 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.