OT: SAP stats; Was: "snapshot too old" and undo

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Thu, 6 Oct 2005 11:42:02 -0400
Message-ID: <96FB7D6574516C45922A76B354B684FD45A5F9@USHQEXVS.polanet.polaroid.com>

The table DBSTATC does indeed hold the default values used by brconnect for analysis method and sample size in fields AMETH and OPTIO, respectively.
These values can be overridden in the parameter file (initSID.sap) or in the
brconnect command line. Download the BRtools utility guide to get a full
complement parameter file and command line options.

From your question, it appears that you are not too familiar with the SAPgui
transactions which would provide these answers. I strongly suggest you experiment with DB20, DB21, SE12, DB13, DB02 and others on a development/test system. Help -> Technical Infomation also provides a lot
of "under-the-hood" details. SQL has it's place, but with a complex application
like SAP, the gui presents a much more readable view.

Regards,
Mike

From: Roger Xu [mailto:roger_xu_at_dp7uptx.com] Subject: RE: "snapshot too old" and undo_retention

I do not find it in initSID.sap. What is the default? Thanks.

From: Khemmanivanh, Somckit
[mailto:somckit.khemmanivanh_at_weyerhaeuser.com]

It's not in DBSTATC.

It's in the init<SID>.sap file (the stats_sample_size parameter).

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu

We are on SAP 4.6C. Which field in table DBSTATC is for sample size?

SQL> select * from sapr3.DBSTATC where DBOBJ = 'BSIS';

DBOBJ                DO OBJOW                DBTYP      VW A OBJEC

AEDAT

-------------------- -- -------------------- ---------- -- - ----------
--------
     SIGNI AMET OPTIO T H TDDAT    DURAT  P
---------- ---- ----- - - -------- ------ -
BSIS                 01 SAPR3                ORACLE     A  A D_FA
19990219
         2 C            X          000000

-- 
This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.



--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 06 2005 - 10:46:47 CDT

OT: SAP stats; Was: "snapshot too old" and undo_retention