Require help in understanding exporting and importing statistics.

10-11  Source: Network gathering  Views:1 

Advertisement
Hi all,
I am bit new to this statistics.
Can anyone please explain me in detail about these commands.
1) exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MRP' , tabname => 'MRP_ATP_DETAILS_TEMP', estimate_percent => 100 ,cascade => TRUE);
2) exec DBMS_STATS.CREATE_STAT_TABLE ( ownname => 'MRP', stattab => 'MRP_ATP_3');
3) exec DBMS_STATS.EXPORT_TABLE_STATS ( ownname => 'MRP', stattab => 'MRP_ATP_3', tabname => 'MRP_ATP_DETAILS_TEMP',statid => 'MRP27jan14');
4) exec DBMS_STATS.IMPORT_TABLE_STATS ( ownname => 'MRP', stattab => 'MRP_ATP_3', tabname => 'MRP_ATP_DETAILS_TEMP');
I understand that these commands are used to export and import table statistics.
But please anyone help me in understanding this indetail.
Thanks in advance.
Regards,
Shiva.
Shiva,
Please post the details of the application release, database version and OS.
Please see (FAQ: Statistics Gathering Frequently Asked Questions (Doc ID 1501712.1) -- What is the difference between DBMS_STATS and FND_STATS).
For exporting/importing statistics summary of FND_STATS Subprograms can be found in (Doc ID 122371.1)
http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_details?c_name=FND_STATS&c_owner=APPS&c_type=PACKAGE&c_detail_type=source
http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_details?c_name=FND_STATS&c_owner=APPS&c_type=PACKAGE%20BODY&c_detail_type=source
Thanks,
Hussein
Related articles
  • Require help in understanding exporting and importing statistics. 10-11

    Hi all, I am bit new to this statistics. Can anyone please explain me in detail about these commands. 1) exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MRP' , tabname => 'MRP_ATP_DETAILS_TEMP', estimate_percent => 100 ,cascade => TRUE); 2) ex

  • Exporting and Importing Statistics for Schema objects. 10-11

    Hello All, I am trying to gather stats for optimization using, gather_schema_stats for all objects under schema. The manual what i am reading says it covers both Tables and Indexes and we can also include the all partions too. For the safety reasons

  • Export and Import of Portal Database - Help Required 10-11

    Hi,   We have a NW04 production portal running on AIX clustered environment (HACMP). We are building another landscape for which i need to export the current portal and import onto new portal which is already clustered (HACMP). Can someone point docu

  • Use of export and import in oo abap 10-11

    Hello experts, We are new to oo abap and using process controlled workflow for BRF. There are 3 methods which we are using. /SAPSRM/IF_EX_WF_RESP_RESOLVERGET_AREA_TO_ITEM_MAP, /SAPSRM/IF_WF_AREAGET_RESPONSIBLE_APPROVERS and /SAPSRM/IF_EX_WF_RESP_RESO

  • Export and Import of Application problem 10-11

    Hi, I had my application developed in Windows environment. First time i had full application export and import on Solaris box. The application was successfully installed on Solaris box and i could login into application. The login process was working

  • Export and import XMLType table 10-11

    Hi , I want to export one table which contain xmltype column form oracle 11.2.0.1.0 and import into 11.2.0.2.0 version. I got following errors when i export the table , when i tried with exp and imp utility EXP-00107: Feature (BINARY XML) of column Z

  • Issue Migrating Character Data Using a Full Export and Import 11-30

    Hi There; I have a database in my local machine that doesn't support Turkish characters. My NLS_CHARACTERSET is WE8ISO8859P1, It must be changed to WE8ISO8859P9 , since it supports full Turkish characters. I would like to migrate character data using

  • I am using Iphoto 11 ver 9.4.3 on mac using oxs 10.8.5 i want to export calendar projects to an external hard drive. what is the easiest way to do this? i have tried export and import but it didn't seem to work. 10-11

    I am using Iphoto 11 ver 9.4.3 on mac using oxs 10.8.5 i want to export calendar projects to an external hard drive. my goal is to store them in an external hard drive so it doesn't use up memory on the mac hard drive. is it possible to copy the spec

  • Language Problem while exporting and importing data 10-11

    hi, I have Oracle version 8.1.7.0.0 installed on one server and 9.2.0.1.0 installed on new server. I'm copying and pasting my version info from SQL*Plus: SQL*Plus: Release 8.1.7.0.0 - Production on Mon Aug 22 10:46:31 2005 (c) Copyright 2000 Oracle C

  • Exporting and Importing Destination Controls Error 10-11

    When I export table within destination control and import the table to another Ironport again within destination control I receive error - "Wrong format of the destination config file: ip_sort_pref is required for the global settings." We are up

  • How to export and import dependent tables from 2 different schema 10-11

    I have a setup where schema1 has table 1 and schema 2 has table2. And table 1 from schema1 depends upon table 2 from schema 2. I would like to export and import these tables only and not any other tables from these 2 schemas with all information like

  • Steps to export and import oracle 10g databse from AIX to AIX and LINUX 10-11

    Hi, I need the steps to export the oracle 10g database from AIX server to AIX server and LINUX server. Please give me all the steps as this is my first exort an import activity. thanks,For 10g there exist two ways to do so. 1) Regular exp/imp. 2) Dat

  • Internal table export and import in ECC 5.0 version 10-11

    Hi friends, I am trying to export and import internal table from one program to other program. The below… export and import commands are not working when I run the program in background (using SUBMIT zxxxx via JOB name NUMBER number…..) EXPORT ITAB T

  • Export and import the windows phone contacts as .vcf file to the application 10-11

    Hi, I need to export the windows phone contacts as .vcf file and import it to my windows phone application. I'm unable to import the full details of a contact. Is there any sample code to export and import phone contacts programmatically. Please help

  • Client Export and Import 10-11

    Hi, I am having one doubt regarding Client export and import In my organization we are having three system landscape, but the Quality and Production server(In Process) Development box is ready to use, and we are having another sand server in differen

  • Export and Import of Configuration Data 10-11

    Hi All, I have created a number of custom properties, structures, groups, renderers, layout sets etc and would like to move them from Dev to Test system. I have found the following in the help doco: "Export and Import of Configuration Data" http

  • Export and import of data not table and data ???? 10-11

    hii brothers and sister plz i have a a quetion about Export and import of data in oracle forms i have created 02 boutons one for export his trigger like this : eclare alrt number; v_directory varchar2(200) := 'c:\backup'; --- that if the C Drive not

  • Export and Import of Access DB tables in Apex 10-11

    Hi, i need help. I wanna export an MSACCESS DB Table into an ORACLE DB 10g2. but every time i get an error course my ODBC driver which isnt compatible to my tns service name. what could i do? i only want to export a table..not the whole database. if

  • View and Edit properties pages are not woriking after export and import in sharepoint2013 10-11

    Hi, After performing Export and Import in SharePoint 2013 for a subsite, metadata is missing in document library. 404 error triggers on  clicking both View-properties of an item and /Forms/DisplayDocument.aspx. Please help me in this. Regards, Guruda

  • Calling Oracle Export and Import in java 10-11

    Hi, I am trying to call oracle export and import utilites in my java application, can anyone help me that how can i do this, plz consider the case as this is a part of my project.. Regards AshishYou should just be able to call the "imp" and &quo