OT: SAP stats; Was: "snapshot too old" and undo_retention
- From: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>
- To: "Roger Xu" <roger_xu@xxxxxxxxxxx>, "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2005 11:42:02 -0400
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@xxxxxxxxxxx]
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@xxxxxxxxxxxxxxxx]
It's not in DBSTATC.
It's in the init<SID>.sap file (the stats_sample_size parameter).
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
- » OT: SAP stats; Was: "snapshot too old" and undo_retention
