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…)
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…)