Home » 2013 » November

Monthly Archives: November 2013

Advertisements

Oracle 11g Extended Statistics for SAP Tables


Extended Statistics is an attempt to fix one of the flaws in CBO–values of different columns are not correlated.

Let us take an example of two columns in a table. One of the column contain department code and the other contains employee name. Let us assume that there are 10 departments and 3000 employees in our example. In a real life scenario, all the employees do not belong to all the departments, but CBO assumes that is the case and hence it assumes that there are 3000*10 = 30000 combinations of employee name and department code that exist. In reality, it can be between 3000 and 30000 (assuming employee belongs to at least one department and can clock for multiple departments).
(more…)

Advertisements

Brief Description of SAP Executable


Here is a list of SAP executables that you may find on your SAP systems. If you know of SAP exe files missing in from list, please leave a comment:

R3check                     This is a tool that can check Cluster-Tables for errors.
R3ldctl                        The tool for exporting all table structures to the file system during an OS/DB-Migration.
R3load                        The table import & export tool of SAP during Installation, Upgrade and Migration.
R3szchk                     The tool for determine the sizes of the different tables in the target database during the import in an OS/DB-Migration.
R3ta                             Split large tables for export and import
R3trans                      This is the tool, that does the real work for tp. tp controls the import and export of changes and r3trans does them using scripts, that were generated from tp.
R3trans_164-20000978.SAR     R3trans_164-20000978.SAR’ is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR                         SAP Compression and Archiving program (more…)