7 Replies Latest reply on Jan 11, 2017 2:42 AM by Beauty_and_dBest

    Gather schema statistics

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      OL6

      11gR2

       

       

      I run weekly the following  gather schema statistics to improve performance of our programs:

      But I can see there are tables with null "lat_analyzed" column?

      Please help...

       

      Kind regards,

      jc

       

      spool gather

      exec dbms_stats.gather_schema_stats('JSBI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AD_MONITOR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AHL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AK',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ALR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AMS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AMV',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ANONYMOUS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('APPLSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('APPLSYSPUB',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('APPQOSSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('APPS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('APPS_NE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AST',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AX',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AZ',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BEN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BIC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BIM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BIS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BNE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('BOM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CCT',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CLN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CMI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CRP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSD',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CSR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CTXSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CUA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CUG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('CZ',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DBSNMP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DDR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DIP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DNA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DOM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('DPP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('EAM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('EC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ECX',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('EDR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('EGO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('EM_MONITOR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ENG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ENI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FLM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FPA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FRM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FTE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FUN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('FV',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GHG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMD',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GME',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GML',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GMS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('GR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('HR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('HRI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('HXC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('HXT',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IBC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IBE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IBU',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IBW',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IBY',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ICX',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEB',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IES',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEU',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IEX',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IGC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IGI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IMC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('INL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('INV',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IPA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IPM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ITG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('IZU',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JMF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JSCUS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JTF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('JTM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('LNS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MDDATA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MDSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MFG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MGDSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MRP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MSC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MSD',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MSO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MSR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MTH',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('MWA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ODM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ODM_MTR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OGG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OKC',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OKE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OKL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OKS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OKX',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OLAPSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ONT',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OPI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ORACLE_OCM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ORDDATA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ORDPLUGINS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ORDSYS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OSM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OTA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OUTLN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('OZF',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PJI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PJM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PMI',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('POM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PON',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('POS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PRP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PSA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PSP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('PV',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('QA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('QOT',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('QP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('QPR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('QRM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('RG',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('RLM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('RRS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SCOTT',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SI_INFORMTN_SCHEMA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SPATIAL_CSW_ADMIN_USR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SPATIAL_WFS_ADMIN_USR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SSOSDK',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SSP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('SYSTEM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('VEA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('WIP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('WMS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('WPS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('WSH',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('WSM',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XDB',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XDO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XDP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XLA',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XLE',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XNB',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XNP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XS$NULL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('XTR',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('YMS',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ZX',CASCADE=>TRUE);

      exit;

       

       

      SQL> select owner,trunc(last_analyzed), count(*) from dba_tables group by owner,trunc(last_analyzed) order by 1;

       

      OWNER                          TRUNC(LAST_ANALYZE   COUNT(*)

      ------------------------------ ------------------ ----------

      AHL                            07-JAN-17                 206

      AHL                                                       13

      AK                             07-JAN-17                  58

      AK                                                         1

      ALR                            07-JAN-17                  32

      AMS                            04-JAN-17                   1

      AMS                            07-JAN-17                 334

      AMS                                                       13

      AMV                            04-JAN-07                   8

      AMV                            07-JAN-17                  34

      AP                             04-JAN-17                   2

      AP                             07-JAN-17                 283

      AP                                                        42

      APPLSYS                        07-JAN-17                 984

      APPLSYS                                                   16

      APPQOSSYS                      07-JAN-17                   4

      APPS                           04-JAN-17                  43

      APPS                           07-JAN-17                 321

      APPS                                                      77

      AR                             27-OCT-04                   4

      AR                             07-JAN-17                 593

      AR                                                       112

      ASF                            07-JAN-17                   2

      ASG                            07-JAN-17                  60

      ASL                            07-JAN-17                  16

      ASL                                                        8

      ASO                            07-JAN-17                  52

      ASO                                                        3

      ASP                            07-JAN-17                   2

      AST                            07-JAN-17                  10

      AX                             07-JAN-17                  48

      AZ                             07-JAN-17                  36

      AZ                                                         4

      BEN                            07-JAN-17                 530

      BIC                            07-JAN-17                  15

      BIC                                                       11

      BIM                            04-JAN-17                  65

      BIM                            07-JAN-17                 215

      BIM                                                       24

      BIS                            04-JAN-17                   3

      BIS                            07-JAN-17                  23

      BIS                                                        2

      BNE                            07-JAN-17                  77

      BOM                            04-JAN-17                   7

      BOM                            07-JAN-17                 280

      BOM                                                       62

      CCT                            07-JAN-17                  96

      CE                             07-JAN-17                 115

      CE                                                         7

      CLN                            07-JAN-17                  28

      CMI                            07-JAN-17                  34

      CMI                                                        8

      CN                             04-JAN-17                   3

      CN                             07-JAN-17                 186

      CN                                                         6

      CRP                            07-JAN-17                  11

      CS                             23-OCT-07                   8

      CS                             02-APR-09                   4

      CS                             07-JAN-17                 288

      CS                                                        11

      CSC                            07-JAN-17                  29

      CSC                                                        2

      CSD                            04-JAN-17                   5

      CSD                            07-JAN-17                  98

      CSD                                                        1

      CSF                            07-JAN-17                 288

      CSF                                                        2

      CSI                            07-JAN-17                  97

      CSI                                                        4

      CSL                            07-JAN-17                  64

      CSM                            07-JAN-17                 232

      CSP                            04-JAN-17                   1

      CSP                            07-JAN-17                  63

      CSP                                                        5

      CSR                            07-JAN-17                  11

      CTXSYS                         07-JAN-17                  52

      CUG                            07-JAN-17                  13

      CZ                             07-JAN-17                 147

      DBSNMP                         07-JAN-17                  24

      DBSNMP                                                     3

      DDR                            04-JAN-17                  49

      DDR                            07-JAN-17                 248

      DOM                            07-JAN-17                   8

      DPP                            07-JAN-17                  20

      DPP                                                        3

      EAM                            07-JAN-17                 101

      EAM                                                       25

      EC                             07-JAN-17                  83

      ECX                            07-JAN-17                  35

      EDR                            07-JAN-17                  33

      EDR                                                        2

      EGO                            07-JAN-17                 165

      EGO                                                        1

      ENG                            04-JAN-17                   4

      ENG                            07-JAN-17                  87

      ENG                                                        2

      ENI                            04-JAN-07                   4

      ENI                            07-JAN-17                   8

      FA                             07-JAN-17                 207

      FA                                                        15

      FLM                            07-JAN-17                  33

      FPA                            07-JAN-17                   4

      FRM                            07-JAN-17                  33

      FTE                            07-JAN-17                  63

      FTE                                                        5

      FUN                            07-JAN-17                  68

      FUN                                                       11

      FV                             07-JAN-17                 212

      FV                                                         6

      GHG                            07-JAN-17                  25

      GHG                                                        2

      GL                             06-JAN-17                   1

      GL                             07-JAN-17                 815

      GL                                                       106

      GMA                            04-JAN-17                   1

      GMA                            07-JAN-17                  45

      GMD                            07-JAN-17                 176

      GMD                                                       23

      GME                            07-JAN-17                  66

      GME                                                        7

      GMF                            07-JAN-17                 134

      GMF                                                       14

      GMI                            04-JAN-17                   1

      GMI                            07-JAN-17                  95

      GML                            07-JAN-17                 163

      GML                                                        1

      GMO                            07-JAN-17                  56

      GMO                                                       12

      GMP                            04-JAN-17                   2

      GMP                            07-JAN-17                  87

      GMP                                                        4

      GMS                            07-JAN-17                  53

      GMS                                                        1

      GR                             07-JAN-17                 132

      GR                                                         1

      HR                             04-JAN-07                  19

      HR                             07-JAN-17                1319

      HR                                                        11

      HRI                            07-JAN-17                 109

      HRI                                                        1

      HXC                            07-JAN-17                 140

      HXC                                                        9

      HXT                            07-JAN-17                  40

      IA                             07-JAN-17                   4

      IBC                            04-JAN-07                   4

      IBC                            07-JAN-17                  31

      IBE                            07-JAN-17                  41

      IBE                                                        1

      IBU                            07-JAN-17                   7

      IBW                            04-JAN-17                   4

      IBW                            07-JAN-17                  14

      IBW                                                        1

      IBY                            07-JAN-17                 176

      IBY                                                       11

      ICX                            04-JAN-07                   4

      ICX                            07-JAN-17                 183

      ICX                                                        5

      IEB                            07-JAN-17                  22

      IEC                            07-JAN-17                 107

      IEM                            07-JAN-17                  88

      IEM                                                        4

      IEO                            07-JAN-17                  47

      IES                            07-JAN-17                  48

      IEU                            07-JAN-17                  54

      IEX                            07-JAN-17                  83

      IGC                            07-JAN-17                  84

      IGC                                                        3

      IGI                            07-JAN-17                 253

      IGI                                                        2

      IMC                            07-JAN-17                  22

      INL                            07-JAN-17                  33

      INV                            04-JAN-17                   1

      INV                            07-JAN-17                 264

      INV                                                       37

      IPA                            07-JAN-17                  16

      ITG                            07-JAN-17                   5

      JA                             07-JAN-17                 300

      JA                                                        22

      JE                             07-JAN-17                  41

      JE                                                         3

      JG                             07-JAN-17                  20

      JG                                                         5

      JL                             07-JAN-17                 116

      JL                                                         3

      JMF                            07-JAN-17                  15

      JMF                                                       14

      JSBI                           07-JAN-17                  24

      JSCUS                          07-JAN-17                 165

      JTF                            27-OCT-04                   4

      JTF                            04-JAN-07                  20

      JTF                            04-JAN-17                  18

      JTF                            07-JAN-17                 617

      JTF                                                        6

      JTM                            07-JAN-17                 101

      LNS                            07-JAN-17                  51

      LNS                                                        3

      MDSYS                          07-JAN-17                 124

      MDSYS                                                     16

      MGDSYS                         07-JAN-17                   3

      MRP                            07-JAN-17                 162

      MRP                                                        1

      MSC                            07-JAN-17                 563

      MSC                                                      583

      MSD                            07-JAN-17                 151

      MSD                                                        8

      MTH                            04-JAN-17                  39

      MTH                            07-JAN-17                 236

      MTH                                                        1

      MWA                            07-JAN-17                   1

      ODM                            07-JAN-17                  25

      ODM_MTR                        07-JAN-17                  12

      OE                             07-JAN-17                 109

      OGG                            07-JAN-17                   2

      OKC                            23-OCT-07                   8

      OKC                            07-JAN-17                 313

      OKC                                                       26

      OKE                            07-JAN-17                  82

      OKL                            07-JAN-17                 416

      OKL                                                        6

      OKS                            07-JAN-17                 117

      OKS                                                        8

      OLAPSYS                        07-JAN-17                 114

      OLAPSYS                                                   12

      ONT                            07-JAN-17                 152

      ONT                                                       18

      OPI                            04-JAN-17                  18

      OPI                            07-JAN-17                  36

      ORDDATA                        07-JAN-17                  54

      ORDDATA                                                   19

      ORDSYS                         07-JAN-17                  58

      ORDSYS                                                    16

      OSM                            07-JAN-17                 215

      OTA                            07-JAN-17                 129

      OTA                                                        4

      OUTLN                          07-JAN-17                   3

      OZF                            07-JAN-17                 194

      OZF                                                        9

      PA                             04-JAN-07                   1

      PA                             07-JAN-17                 647

      PA                                                       131

      PJI                            07-JAN-17                 110

      PJI                                                       21

      PJM                            07-JAN-17                  29

      PMI                            07-JAN-17                   8

      PN                             07-JAN-17                 137

      PO                             04-JAN-07                  13

      PO                             04-JAN-17                   1

      PO                             07-JAN-17                 294

      PO                                                        14

      PON                            07-JAN-17                 126

      POS                            07-JAN-17                  53

      POS                                                       11

      PRP                            07-JAN-17                  35

      PSA                            07-JAN-17                  28

      PSA                                                        4

      PSP                            07-JAN-17                 122

      PSP                                                        2

      PV                             07-JAN-17                  88

      QA                             07-JAN-17                  66

      QA                                                         5

      QP                             07-JAN-17                 107

      QP                                                        18

      QPR                            07-JAN-17                  76

      QRM                            07-JAN-17                  13

      RG                             07-JAN-17                  43

      RLM                            07-JAN-17                  14

      RLM                                                        3

      RRS                            04-JAN-17                   2

      RRS                            07-JAN-17                  44

      RRS                                                        1

      SCOTT                          07-JAN-17                   3

      SCOTT                                                      2

      SSOSDK                         07-JAN-17                   2

      SSP                            07-JAN-17                   6

      SYS                            30-MAR-04                   1

      SYS                            04-SEP-14                 872

      SYS                            17-DEC-15                 114

      SYS                            08-APR-16                   6

      SYS                            14-APR-16                  17

      SYS                            22-APR-16                   2

      SYS                            09-JAN-17                   1

      SYS                                                       59

      SYSTEM                         07-JAN-17                 199

      SYSTEM                                                    11

      VEA                            07-JAN-17                  12

      WIP                            07-JAN-17                 113

      WIP                                                       10

      WMS                            07-JAN-17                 124

      WMS                                                       30

      WPS                            07-JAN-17                   1

      WSH                            07-JAN-17                 114

      WSH                                                        9

      WSM                            07-JAN-17                  47

      WSM                                                        1

      XDB                            07-JAN-17                  30

      XDB                                                        1

      XDO                            07-JAN-17                  27

      XDO                                                        1

      XDP                            07-JAN-17                  78

      XLA                            07-JAN-17                 144

      XLA                                                       34

      XLE                            07-JAN-17                  22

      XNB                            07-JAN-17                   4

      XNP                            07-JAN-17                  51

      XTR                            07-JAN-17                 215

      XTR                                                        1

      YMS                            07-JAN-17                   6

      ZX                             07-JAN-17                 104

      ZX                                                        29

       

      309 rows selected.

        • 1. Re: Gather schema statistics
          Gbenga Ajakaye

          When last_analyzed = null it means that table statistics hasn't been gathered yet. ...

          • 2. Re: Gather schema statistics
            Beauty_and_dBest

            151 vs 8 means two tables?

             

            SQL>  select table_name from dba_tables where owner='MSC' and last_analyzed is  null order by 1;

             

             

            TABLE_NAME

            ------------------------------

            MSC_ALLOC_HIERARCHY_TEMP

            MSC_ALLOC_TEMP

            MSC_ANALYSIS_QUERY

            MSC_ATP_DETAIL_PEG_TEMP

            MSC_ATP_PEG_TEMP

            MSC_ATP_SD_DETAILS_TEMP

            MSC_ATP_SOURCES_TEMP

            MSC_CAPACITY_PLANS

            MSC_DRP_HORI_PLANS

            MSC_FORM_QUERY

            MSC_GANTT_DTL_QUERY

            MSC_GANTT_QUERY

            MSC_HUB_QUERY

            MSC_HZ_UI_HEADERS

            MSC_HZ_UI_LINES

            MSC_INT_10_E_SNO

            MSC_INT_10_TV

            MSC_INT_10_TV_SNO

            MSC_INT_11_E_SNO

            MSC_INT_11_TV

            MSC_INT_11_TV_SNO

            MSC_INT_12_E

            MSC_INT_12_E_SNO

            MSC_INT_12_TV_SNO

            MSC_INT_13_E

            MSC_INT_13_E_SNO

            MSC_INT_13_TV_SNO

            MSC_INT_14_E_SNO

            MSC_INT_14_TV_SNO

            MSC_INT_15_E_SNO

            MSC_INT_15_TV_SNO

            MSC_INT_16_E_SNO

            MSC_INT_16_TV_SNO

            MSC_INT_17_E_SNO

            MSC_INT_18_E_SNO

            MSC_INT_18_TV_SNO

            MSC_INT_19_E_SNO

            MSC_INT_19_TV_SNO

            MSC_INT_1_E

            MSC_INT_20_E_SNO

            MSC_INT_20_TV_SNO

            MSC_INT_21_TV_SNO

            MSC_INT_22_E_SNO

            MSC_INT_22_TV_SNO

            MSC_INT_23_TV_SNO

            MSC_INT_24_E_SNO

            MSC_INT_24_MEM_SNO

            MSC_INT_25_E_SNO

            MSC_INT_25_TV_SNO

            MSC_INT_26_E_SNO

            MSC_INT_26_MEM_SNO

            MSC_INT_26_TV_SNO

            MSC_INT_27_E_PLAN

            MSC_INT_27_E_SNO

            MSC_INT_27_TV_SNO

            MSC_INT_28_MEM_SNO

            MSC_INT_28_TV_PLAN

            MSC_INT_28_TV_SNO

            MSC_INT_29_E_PLAN

            MSC_INT_29_E_SNO

            MSC_INT_29_TV_SNO

            MSC_INT_2_E

            MSC_INT_30_E_PLAN

            MSC_INT_30_TV_PLAN

            MSC_INT_30_TV_SNO

            MSC_INT_31_E_PLAN

            MSC_INT_31_E_SNO

            MSC_INT_32_E_PLAN

            MSC_INT_32_TV_PLAN

            MSC_INT_32_TV_SNO

            MSC_INT_33_E_PLAN

            MSC_INT_33_E_SNO

            MSC_INT_34_E_PLAN

            MSC_INT_34_TV_PLAN

            MSC_INT_34_TV_SNO

            MSC_INT_35_E_PLAN

            MSC_INT_35_MEM_SNO

            MSC_INT_36_E_PLAN

            MSC_INT_36_E_SNO

            MSC_INT_36_TV_PLAN

            MSC_INT_37_E_PLAN

            MSC_INT_37_TV_SNO

            MSC_INT_38_E_PLAN

            MSC_INT_39_E_PLAN

            MSC_INT_39_TV_PLAN

            MSC_INT_3_TV

            MSC_INT_40_E_PLAN

            MSC_INT_41_E_PLAN

            MSC_INT_42_E_PLAN

            MSC_INT_43_E_PLAN

            MSC_INT_43_TV_PLAN

            MSC_INT_44_E_PLAN

            MSC_INT_45_E_PLAN

            MSC_INT_46_E_PLAN

            MSC_INT_47_E_PLAN

            MSC_INT_48_E_PLAN

            MSC_INT_49_E_PLAN

            MSC_INT_4_E

            MSC_INT_50_E_PLAN

            MSC_INT_5_E

            MSC_INT_5_TV

            MSC_INT_6_E

            MSC_INT_6_TV

            MSC_INT_7_TV

            MSC_INT_7_TV_SNO

            MSC_INT_8_E

            MSC_INT_8_E_SNO

            MSC_INT_8_TV

            MSC_INT_9_E

            MSC_INT_9_TV

            MSC_INT_9_TV_SNO

            MSC_INT_ACTUAL_RESOURCE_PLAN

            MSC_INT_ACTUAL_RES_HRS

            MSC_INT_ALL_DEMAND_ITEM

            MSC_INT_ALL_ITEM

            MSC_INT_ALL_SUPPLY_ITEM

            MSC_INT_ALT_RES

            MSC_INT_APCC_ITEM_SOURCE

            MSC_INT_APCC_ORG_DETAIL

            MSC_INT_ASCP_DEMANDS

            MSC_INT_ASCP_DEPENDENT_DEMAND

            MSC_INT_ASCP_END_ITEM

            MSC_INT_ASCP_EXCEPTION_DETAILS

            MSC_INT_ASCP_EXPORT_BUCKETS

            MSC_INT_ASCP_INVENTORY

            MSC_INT_ASCP_KPI

            MSC_INT_ASCP_LABOUR_UTIL

            MSC_INT_ASCP_MACHINE_UTIL

            MSC_INT_ASCP_MFG_PLAN_LABOUR

            MSC_INT_ASCP_MFG_PLAN_MACHINE

            MSC_INT_ASCP_PRODCOST_KPI

            MSC_INT_ASCP_SUPPLY

            MSC_INT_ASCP_SUPPLY_ITEM

            MSC_INT_ASCP_TOTALPRODCOST

            MSC_INT_ASCP_TRANSPCOST_KPI

            MSC_INT_ASCP_TRANSPORTATION

            MSC_INT_ASCP_TRANSPORTATION0

            MSC_INT_ASSET

            MSC_INT_ASSIGNED_ATTRIBUTE

            MSC_INT_ATTRIBUTE_VALUE

            MSC_INT_BEGINNING_INVENTORY

            MSC_INT_BOR_RES_NAME

            MSC_INT_BRANCH

            MSC_INT_BRANCH_GROUP

            MSC_INT_BRANCH_GROUP_MEM

            MSC_INT_BRANCH_OPERATION

            MSC_INT_BRANCH_OPERATION_SET

            MSC_INT_BRANCH_OPERATION_SNO

            MSC_INT_BRANCH_OPERATION_TV

            MSC_INT_BRANCH_ROUTING

            MSC_INT_BRANCH_ROUTING_SNO

            MSC_INT_BRANCH_ROUTING_TV

            MSC_INT_BRANCH_ROUTING_TV_SNO

            MSC_INT_BRANCH_SNO

            MSC_INT_CALENDAR

            MSC_INT_CALENDAR_SNO

            MSC_INT_CALENDAR_TV

            MSC_INT_CALENDAR_TV_SNO

            MSC_INT_CFC_SCENARIO_DETAILS

            MSC_INT_CHANGEOVER_PATTERN

            MSC_INT_CHANGEOVER_PATTERN_SNO

            MSC_INT_CMRO_OP_REL

            MSC_INT_CMRO_RES_REQS

            MSC_INT_COMPONENT_ITEM

            MSC_INT_CONSUMED_ITEM_BOM

            MSC_INT_CONSUMED_ITEM_BOM_SNO

            MSC_INT_CONSUMED_ITEM_BOM_TV

            MSC_INT_CONSUMED_ITEM_SET

            MSC_INT_CONSUMED_ITEM_SET_SNO

            MSC_INT_CREW

            MSC_INT_CREW_SNO

            MSC_INT_CREW_TV

            MSC_INT_CREW_TV_SNO

            MSC_INT_CUSTOMER

            MSC_INT_CUSTOMER_GROUP

            MSC_INT_CUSTOMER_GROUP_MEM

            MSC_INT_CUSTOMER_GROUP_MEM_SNO

            MSC_INT_CUSTOMER_GROUP_SNO

            MSC_INT_CUSTOMER_SNO

            MSC_INT_CUST_ITEM_TR_MODE

            MSC_INT_CUST_ITEM_TR_MODE_SNO

            MSC_INT_CUST_ITEM_TR_MODE_TV

            MSC_INT_CUST_TR_MODE

            MSC_INT_CUST_TR_MODE_SNO

            MSC_INT_CUST_TR_MODE_TV

            MSC_INT_CUST_TR_MODE_TV_SNO

            MSC_INT_END_ITEM

            MSC_INT_ENTERPRISE_FORECAST

            MSC_INT_ENT_FCST_DETAIL

            MSC_INT_ENT_FCST_DETAIL_SNO

            MSC_INT_ENT_FCST_DETAIL_TV

            MSC_INT_ENT_FCST_DETAIL_TV_SNO

            MSC_INT_EQUIPMENT

            MSC_INT_FIXED_PRODUCTION_SNO

            MSC_INT_IMPLEMENTING_RES

            MSC_INT_IMPLEMENTING_RESOURCE

            MSC_INT_IMPLEMENTING_RES_SNO

            MSC_INT_IMPLEMENTING_RES_TV

            MSC_INT_IMPL_RES

            MSC_INT_INVENTORY_POLICY

            MSC_INT_INVENTORY_POLICY_SNO

            MSC_INT_INVENTORY_POLICY_TV

            MSC_INT_INV_SAFE_TAR

            MSC_INT_INV_SAFE_TAR_DETAIL

            MSC_INT_INV_SAFE_TAR_DETAIL_TV

            MSC_INT_INV_SAFE_TAR_SNO

            MSC_INT_ITEM

            MSC_INT_ITEM_BRANCH

            MSC_INT_ITEM_BRANCH0

            MSC_INT_ITEM_BRANCH_SNO

            MSC_INT_ITEM_BRANCH_TV

            MSC_INT_ITEM_BRANCH_TV_SNO

            MSC_INT_ITEM_GROUP

            MSC_INT_ITEM_GROUP_MEM

            MSC_INT_ITEM_GROUP_MEM_SNO

            MSC_INT_ITEM_GROUP_SNO

            MSC_INT_ITEM_PRICE

            MSC_INT_ITEM_PRICE_SNO

            MSC_INT_ITEM_PRICE_TV

            MSC_INT_ITEM_PRICE_TV_SNO

            MSC_INT_ITEM_SNO

            MSC_INT_ITEM_STORAGE

            MSC_INT_ITEM_STORAGE_SNO

            MSC_INT_ITEM_STORAGE_TV

            MSC_INT_ITEM_STORAGE_TV_SNO

            MSC_INT_ITEM_TRANSPORT_MODE

            MSC_INT_ITEM_TRAVEL_DISTANCE

            MSC_INT_ITEM_UOM

            MSC_INT_ITEM_UOM_SNO

            MSC_INT_JOB_ALT_RES

            MSC_INT_LANE

            MSC_INT_LANE_SNO

            MSC_INT_MACHINE

            MSC_INT_MACHINE_SNO

            MSC_INT_MACHINE_TV

            MSC_INT_MACHINE_TV_SNO

            MSC_INT_MACH_ATTRIBUTE

            MSC_INT_NEXT_WORK_ORDER

            MSC_INT_OPERATION

            MSC_INT_OPERATION_BOR

            MSC_INT_OPERATION_BOR_SNO

            MSC_INT_OPERATION_BOR_TV

            MSC_INT_OPERATION_BOR_TV_SNO

            MSC_INT_OPERATION_GROUP

            MSC_INT_OPERATION_GROUP_MEM

            MSC_INT_OPERATION_GROUP_SNO

            MSC_INT_OPERATION_SET

            MSC_INT_OPERATION_SET_MEM

            MSC_INT_OPERATION_SET_MEM_SNO

            MSC_INT_OPERATION_SET_SNO

            MSC_INT_OPERATION_SNO

            MSC_INT_OSFM_PATH

            MSC_INT_PEGGED_WORK_ORDER_PLAN

            MSC_INT_PRODUCED_ITEM

            MSC_INT_PRODUCED_ITEM_BOM

            MSC_INT_PRODUCED_ITEM_BOM_SNO

            MSC_INT_PRODUCED_ITEM_BOM_TV

            MSC_INT_PRODUCED_ITEM_SNO

            MSC_INT_PS_ALL_ITEM

            MSC_INT_PS_DEMAND_ITEM

            MSC_INT_PS_END_ITEM

            MSC_INT_PS_SUPPLY_ITEM

            MSC_INT_PURCHASE_ORDER

            MSC_INT_PURCHASE_ORDER_DETAIL

            MSC_INT_PURCHASE_ORDER_SNO

            MSC_INT_RESERVATION

            MSC_INT_RESOURCE_ATTRIBUTE

            MSC_INT_RESOURCE_GROUP

            MSC_INT_RESOURCE_GROUP_MEM

            MSC_INT_RESOURCE_GROUP_MEM_SNO

            MSC_INT_RESOURCE_GROUP_SNO

            MSC_INT_RESOURCE_PLAN

            MSC_INT_RESOURCE_RELATIONSHIP

            MSC_INT_RESOURCE_SCHEDULE_PLAN

            MSC_INT_RESOURCE_SET

            MSC_INT_RESOURCE_SET_SNO

            MSC_INT_RES_INTERMEDIATE

            MSC_INT_ROUTING

            MSC_INT_ROUTING_SNO

            MSC_INT_SALES_ORDER

            MSC_INT_SALES_ORDER_DETAIL

            MSC_INT_SALES_SNO

            MSC_INT_SALES_TV_SNO

            MSC_INT_SATISFIED_DEMAND_PLAN

            MSC_INT_SCHEDULE_BOR_PLAN

            MSC_INT_SCHEDULE_MILESTONE

            MSC_INT_SHIFT_CALENDAR

            MSC_INT_SOURCE1

            MSC_INT_SOURCE2

            MSC_INT_SOURCE_ITEM_PLAN

            MSC_INT_SRC_RECOMMEND_DETAIL

            MSC_INT_STANDARD_UOM

            MSC_INT_STANDARD_UOM_SNO

            MSC_INT_STORAGE

            MSC_INT_STORAGE_SNO

            MSC_INT_STORAGE_TV

            MSC_INT_STORAGE_TV_SNO

            MSC_INT_SUB_COMPONENT_ITEM

            MSC_INT_SUPPLIER

            MSC_INT_SUPPLIER_GROUP

            MSC_INT_SUPPLIER_GROUP_MEM

            MSC_INT_SUPPLIER_GROUP_MEM_SNO

            MSC_INT_SUPPLIER_GROUP_SNO

            MSC_INT_SUPPLIER_ITEM

            MSC_INT_SUPPLIER_ITEM_BRANCH

            MSC_INT_SUPPLIER_ITEM_SNO

            MSC_INT_SUPPLIER_ITEM_TV

            MSC_INT_SUPPLIER_ITEM_TV_SNO

            MSC_INT_SUPPLIER_SNO

            MSC_INT_TEMPORAL_RELATION

            MSC_INT_TEMPORAL_RELATION_SNO

            MSC_INT_TOOL

            MSC_INT_TOOL_SNO

            MSC_INT_TOOL_TV

            MSC_INT_TOOL_TV_SNO

            MSC_INT_TRANSFER_ORDER

            MSC_INT_TRANSFER_ORDER_DETAIL

            MSC_INT_TRANSFER_ORDER_IN

            MSC_INT_TRANSFER_ORDER_OUT

            MSC_INT_TRANSFER_ORDER_SNO

            MSC_INT_TRANSPORT_MODE

            MSC_INT_TRANSPORT_MODE_SNO

            MSC_INT_TRANSPORT_MODE_TV

            MSC_INT_TRANSPORT_MODE_TV_SNO

            MSC_INT_VISIT

            MSC_INT_WORK_ORDER

            MSC_INT_WORK_ORDER_BOR

            MSC_INT_WORK_ORDER_IMP_RES

            MSC_INT_WORK_ORDER_OPERATION

            MSC_INT_WO_CMRO_CONFIG

            MSC_INT_WO_CONSUMED_ITEM_BOM

            MSC_INT_WO_OPERATION_SET

            MSC_INT_WO_PRODUCED_ITEM_BOM

            MSC_INT_WO_TEMPORAL_REL

            MSC_ITG_10_E_SNO

            MSC_ITG_11_TV_SNO

            MSC_ITG_12_E_SNO

            MSC_ITG_13_TV_SNO

            MSC_ITG_14_E_SNO

            MSC_ITG_15_E_SNO

            MSC_ITG_16_TV_SNO

            MSC_ITG_17_E_SNO

            MSC_ITG_18_TV_SNO

            MSC_ITG_19_TV_SNO

            MSC_ITG_1_E

            MSC_ITG_20_TV_SNO

            MSC_ITG_21_TV_SNO

            MSC_ITG_22_E_SNO

            MSC_ITG_23_TV_SNO

            MSC_ITG_24_MEM_SNO

            MSC_ITG_25_E_SNO

            MSC_ITG_26_TV_SNO

            MSC_ITG_27_E_PLAN

            MSC_ITG_28_TV_PLAN

            MSC_ITG_29_E_PLAN

            MSC_ITG_2_E

            MSC_ITG_30_E_PLAN

            MSC_ITG_31_E_PLAN

            MSC_ITG_32_TV_PLAN

            MSC_ITG_33_E_PLAN

            MSC_ITG_34_E_PLAN

            MSC_ITG_35_E_PLAN

            MSC_ITG_36_E_PLAN

            MSC_ITG_37_E_PLAN

            MSC_ITG_38_E_PLAN

            MSC_ITG_39_E_PLAN

            MSC_ITG_3_TV

            MSC_ITG_4_E

            MSC_ITG_5_TV

            MSC_ITG_6_TV

            MSC_ITG_7_TV_SNO

            MSC_ITG_8_E_SNO

            MSC_ITG_9_TV_SNO

            MSC_ITG_ACTUAL_RESOURCE_PLAN

            MSC_ITG_ACTUAL_RES_HRS

            MSC_ITG_ALT_RES

            MSC_ITG_ASCP_END_ITEM

            MSC_ITG_ASCP_SUPPLY_ITEM

            MSC_ITG_ASSET

            MSC_ITG_ASSIGNED_ATTRIBUTE

            MSC_ITG_ATTRIBUTE_VALUE

            MSC_ITG_BEGINNING_INVENTORY

            MSC_ITG_BOR_RES_NAME

            MSC_ITG_BRANCH

            MSC_ITG_BRANCH_GROUP

            MSC_ITG_BRANCH_GROUP_MEM

            MSC_ITG_BRANCH_OPERATION

            MSC_ITG_BRANCH_OPERATION_SET

            MSC_ITG_BRANCH_OPERATION_SNO

            MSC_ITG_BRANCH_OPERATION_TV

            MSC_ITG_BRANCH_ROUTING

            MSC_ITG_BRANCH_ROUTING_SNO

            MSC_ITG_BRANCH_ROUTING_TV

            MSC_ITG_BRANCH_ROUTING_TV_SNO

            MSC_ITG_BRANCH_SNO

            MSC_ITG_CALENDAR

            MSC_ITG_CALENDAR_SNO

            MSC_ITG_CALENDAR_TV

            MSC_ITG_CALENDAR_TV_SNO

            MSC_ITG_CFC_SCENARIO_DETAILS

            MSC_ITG_CHANGEOVER_PATTERN

            MSC_ITG_CHANGEOVER_PATTERN_SNO

            MSC_ITG_CMRO_OP_REL

            MSC_ITG_CMRO_RES_REQS

            MSC_ITG_COMPONENT_ITEM

            MSC_ITG_CONSUMED_ITEM_BOM

            MSC_ITG_CONSUMED_ITEM_BOM_SNO

            MSC_ITG_CONSUMED_ITEM_BOM_TV

            MSC_ITG_CONSUMED_ITEM_SET

            MSC_ITG_CONSUMED_ITEM_SET_SNO

            MSC_ITG_CREW

            MSC_ITG_CREW_SNO

            MSC_ITG_CREW_TV

            MSC_ITG_CREW_TV_SNO

            MSC_ITG_CUSTOMER

            MSC_ITG_CUSTOMER_GROUP

            MSC_ITG_CUSTOMER_GROUP_MEM

            MSC_ITG_CUSTOMER_GROUP_MEM_SNO

            MSC_ITG_CUSTOMER_GROUP_SNO

            MSC_ITG_CUSTOMER_SNO

            MSC_ITG_CUST_ITEM_TR_MODE

            MSC_ITG_CUST_ITEM_TR_MODE_SNO

            MSC_ITG_CUST_ITEM_TR_MODE_TV

            MSC_ITG_CUST_TR_MODE

            MSC_ITG_CUST_TR_MODE_SNO

            MSC_ITG_CUST_TR_MODE_TV

            MSC_ITG_CUST_TR_MODE_TV_SNO

            MSC_ITG_END_ITEM

            MSC_ITG_ENTERPRISE_FORECAST

            MSC_ITG_ENT_FCST_DETAIL

            MSC_ITG_ENT_FCST_DETAIL_SNO

            MSC_ITG_ENT_FCST_DETAIL_TV

            MSC_ITG_ENT_FCST_DETAIL_TV_SNO

            MSC_ITG_EQUIPMENT

            MSC_ITG_FIXED_PRODUCTION_SNO

            MSC_ITG_IMPLEMENTING_RES

            MSC_ITG_IMPLEMENTING_RES_SNO

            MSC_ITG_IMPLEMENTING_RES_TV

            MSC_ITG_IMPL_RES

            MSC_ITG_INVENTORY_POLICY

            MSC_ITG_INVENTORY_POLICY_SNO

            MSC_ITG_INVENTORY_POLICY_TV

            MSC_ITG_INV_SAFE_TAR

            MSC_ITG_INV_SAFE_TAR_DETAIL

            MSC_ITG_INV_SAFE_TAR_DETAIL_TV

            MSC_ITG_INV_SAFE_TAR_SNO

            MSC_ITG_ITEM

            MSC_ITG_ITEM_BRANCH

            MSC_ITG_ITEM_BRANCH_SNO

            MSC_ITG_ITEM_BRANCH_TV

            MSC_ITG_ITEM_BRANCH_TV_SNO

            MSC_ITG_ITEM_GROUP

            MSC_ITG_ITEM_GROUP_MEM

            MSC_ITG_ITEM_GROUP_MEM_SNO

            MSC_ITG_ITEM_GROUP_SNO

            MSC_ITG_ITEM_PRICE

            MSC_ITG_ITEM_PRICE_SNO

            MSC_ITG_ITEM_PRICE_TV

            MSC_ITG_ITEM_PRICE_TV_SNO

            MSC_ITG_ITEM_SNO

            MSC_ITG_ITEM_STORAGE

            MSC_ITG_ITEM_STORAGE_SNO

            MSC_ITG_ITEM_STORAGE_TV

            MSC_ITG_ITEM_STORAGE_TV_SNO

            MSC_ITG_ITEM_TRANSPORT_MODE

            MSC_ITG_ITEM_UOM

            MSC_ITG_ITEM_UOM_SNO

            MSC_ITG_JOB_ALT_RES

            MSC_ITG_LANE

            MSC_ITG_LANE_SNO

            MSC_ITG_MACHINE

            MSC_ITG_MACHINE_SNO

            MSC_ITG_MACHINE_TV

            MSC_ITG_MACHINE_TV_SNO

            MSC_ITG_MACH_ATTRIBUTE

            MSC_ITG_NEXT_WORK_ORDER

            MSC_ITG_OPERATION

            MSC_ITG_OPERATION_BOR

            MSC_ITG_OPERATION_BOR_SNO

            MSC_ITG_OPERATION_BOR_TV

            MSC_ITG_OPERATION_BOR_TV_SNO

            MSC_ITG_OPERATION_GROUP

            MSC_ITG_OPERATION_GROUP_MEM

            MSC_ITG_OPERATION_GROUP_SNO

            MSC_ITG_OPERATION_SET

            MSC_ITG_OPERATION_SET_MEM

            MSC_ITG_OPERATION_SET_MEM_SNO

            MSC_ITG_OPERATION_SET_SNO

            MSC_ITG_OPERATION_SNO

            MSC_ITG_OSFM_PATH

            MSC_ITG_PEGGED_WORK_ORDER_PLAN

            MSC_ITG_PRODUCED_ITEM

            MSC_ITG_PRODUCED_ITEM_BOM

            MSC_ITG_PRODUCED_ITEM_BOM_SNO

            MSC_ITG_PRODUCED_ITEM_BOM_TV

            MSC_ITG_PRODUCED_ITEM_SNO

            MSC_ITG_PS_ALL_ITEM

            MSC_ITG_PS_DEMAND_ITEM

            MSC_ITG_PS_END_ITEM

            MSC_ITG_PS_SUPPLY_ITEM

            MSC_ITG_PURCHASE_ORDER

            MSC_ITG_PURCHASE_ORDER_DETAIL

            MSC_ITG_PURCHASE_ORDER_SNO

            MSC_ITG_RESERVATION

            MSC_ITG_RESOURCE_ATTRIBUTE

            MSC_ITG_RESOURCE_GROUP

            MSC_ITG_RESOURCE_GROUP_MEM

            MSC_ITG_RESOURCE_GROUP_MEM_SNO

            MSC_ITG_RESOURCE_GROUP_SNO

            MSC_ITG_RESOURCE_PLAN

            MSC_ITG_RESOURCE_SCHEDULE_PLAN

            MSC_ITG_RESOURCE_SET

            MSC_ITG_RESOURCE_SET_SNO

            MSC_ITG_RES_INTERMEDIATE

            MSC_ITG_ROUTING

            MSC_ITG_ROUTING_SNO

            MSC_ITG_SALES_ORDER

            MSC_ITG_SALES_ORDER_DETAIL

            MSC_ITG_SALES_SNO

            MSC_ITG_SALES_TV_SNO

            MSC_ITG_SATISFIED_DEMAND_PLAN

            MSC_ITG_SCHEDULE_BOR_PLAN

            MSC_ITG_SCHEDULE_MILESTONE

            MSC_ITG_SHIFT_CALENDAR

            MSC_ITG_SOURCE_ITEM_PLAN

            MSC_ITG_STANDARD_UOM

            MSC_ITG_STANDARD_UOM_SNO

            MSC_ITG_STORAGE

            MSC_ITG_STORAGE_SNO

            MSC_ITG_STORAGE_TV

            MSC_ITG_STORAGE_TV_SNO

            MSC_ITG_SUB_COMPONENT_ITEM

            MSC_ITG_SUPPLIER

            MSC_ITG_SUPPLIER_GROUP

            MSC_ITG_SUPPLIER_GROUP_MEM

            MSC_ITG_SUPPLIER_GROUP_MEM_SNO

            MSC_ITG_SUPPLIER_GROUP_SNO

            MSC_ITG_SUPPLIER_ITEM

            MSC_ITG_SUPPLIER_ITEM_BRANCH

            MSC_ITG_SUPPLIER_ITEM_SNO

            MSC_ITG_SUPPLIER_ITEM_TV

            MSC_ITG_SUPPLIER_ITEM_TV_SNO

            MSC_ITG_SUPPLIER_SNO

            MSC_ITG_TEMPORAL_RELATION

            MSC_ITG_TEMPORAL_RELATION_SNO

            MSC_ITG_TOOL

            MSC_ITG_TOOL_SNO

            MSC_ITG_TOOL_TV

            MSC_ITG_TOOL_TV_SNO

            MSC_ITG_TRANSFER_ORDER

            MSC_ITG_TRANSFER_ORDER_DETAIL

            MSC_ITG_TRANSFER_ORDER_IN

            MSC_ITG_TRANSFER_ORDER_OUT

            MSC_ITG_TRANSFER_ORDER_SNO

            MSC_ITG_TRANSPORT_MODE

            MSC_ITG_TRANSPORT_MODE_SNO

            MSC_ITG_TRANSPORT_MODE_TV

            MSC_ITG_TRANSPORT_MODE_TV_SNO

            MSC_ITG_VISIT

            MSC_ITG_WORK_ORDER

            MSC_ITG_WORK_ORDER_BOR

            MSC_ITG_WORK_ORDER_IMP_RES

            MSC_ITG_WORK_ORDER_OPERATION

            MSC_ITG_WO_CMRO_CONFIG

            MSC_ITG_WO_CONSUMED_ITEM_BOM

            MSC_ITG_WO_OPERATION_SET

            MSC_ITG_WO_PRODUCED_ITEM_BOM

            MSC_ITG_WO_TEMPORAL_REL

            MSC_LOAD_BUCKETS_TEMP

            MSC_MATERIAL_PLANS

            MSC_NEC_EXC_DTL_TEMP

            MSC_OE_DATA_TEMP

            MSC_PLANNING_ORGS

            MSC_SHIP_SET_TEMP

            MSC_SOURCING_TRANSACTIONS

            MSC_SUPPLIER_PLANS

            MSC_TEMP_REGION_LOCATIONS

            MSC_TEMP_SALES_ORDERS

            MSC_VMI_GRAPH

            MSC_VMI_UI_GRAPH

            MSC_X_ITEM_ORGS_GTT

            MSC_X_ITEM_SITES_GTT

            MSC_X_ITEM_SUPPLIERS_GTT

             

            583 rows selected.

             

              1* select table_name from dba_tables where owner='MSC' and last_analyzed is not null order by 1;

             

             

            TABLE_NAME

            ------------------------------

            MSC_ABC_CLASSES

            MSC_ACTIVITY_PARAMETERS

            MSC_ALLOCATIONS

            MSC_ALLOCATION_ASSIGNMENTS

            MSC_ALLOCATION_BUCKETS

            MSC_ALLOCATION_DETAILS

            MSC_ALLOCATION_LINES

            MSC_ALLOCATION_RULES

            MSC_ALLOC_DEMANDS

            MSC_ALLOC_RULE_TIME_PHASES

            MSC_ALLOC_SUPPLIES

            MSC_AMONG_VALUES

            MSC_ANALYSIS_AGGREGATE

            MSC_ANALYZE_PREFERENCE

            MSC_ANSWERS

            MSC_APCC_CONFIG

            MSC_APCC_CUSTOM_HIER

            MSC_APCC_CUSTOM_MEASURES

            MSC_APCC_ITEM_D

            MSC_APCC_ITEM_D_BAK

            MSC_APCC_PEG_ITEM_D

            MSC_APCC_UPLOAD

            MSC_APCC_UPLOAD_DETAIL

            MSC_APCC_WORKERS

            MSC_APPS_INSTANCES

            MSC_APPS_INSTANCE_NODES

            MSC_ASL_AUTH_DETAILS

            MSC_ASSIGNMENT_SETS

            MSC_ATP_PARAMETERS

            MSC_ATP_PEGGING

            MSC_ATP_RULES

            MSC_ATP_SRC_PROFILE_TEMP

            MSC_ATP_SUMMARY_RES

            MSC_ATP_SUMMARY_SD

            MSC_ATP_SUMMARY_SO

            MSC_ATP_SUMMARY_SUP

            MSC_AVAILABLE_TO_PROMISE

            MSC_BILL_OF_RESOURCES

            MSC_BIS_BUSINESS_PLANS

            MSC_BIS_INV_CAT_MV_TAB

            MSC_BIS_INV_DATE_MV_TAB

            MSC_BIS_INV_DETAIL

            MSC_BIS_ORG_DETAIL

            MSC_BIS_PERFORMANCE_MEASURES

            MSC_BIS_PERIODS

            MSC_BIS_PLAN_SUMMARY_KPI

            MSC_BIS_RES_DATE_MV_TAB

            MSC_BIS_RES_INST_SUMMARY

            MSC_BIS_RES_SUMMARY

            MSC_BIS_SUPPLIER_SUMMARY

            MSC_BIS_TARGETS

            MSC_BIS_TARGET_LEVELS

            MSC_BOD_SO_SR_LEVELS

            MSC_BOMS

            MSC_BOM_BOD_INTERFACE

            MSC_BOM_COMPONENTS

            MSC_BOM_TEMP

            MSC_BOR_REQUIREMENTS

            MSC_BUDGETS_F

            MSC_CALENDARS

            MSC_CALENDAR_ASSIGNMENTS

            MSC_CALENDAR_DATES

            MSC_CALENDAR_EXCEPTIONS

            MSC_CALENDAR_MONTHS

            MSC_CALENDAR_SHIFTS

            MSC_CAL_WEEK_START_DATES

            MSC_CAL_YEAR_START_DATES

            MSC_CARRIER_SERVICES

            MSC_CATEGORY_SETS

            MSC_CATEGORY_SET_ID_LID

            MSC_COLL_PARAMETERS

            MSC_COMPANIES

            MSC_COMPANY_ID_LID

            MSC_COMPANY_RELATIONSHIPS

            MSC_COMPANY_SITES

            MSC_COMPANY_SITE_ID_LID

            MSC_COMPANY_USERS

            MSC_COMPONENT_SUBSTITUTES

            MSC_COSTS_F

            MSC_CP_PLAN_BUCKETS

            MSC_CRITERIA

            MSC_CRITICAL_PATHS

            MSC_CTO_BOM

            MSC_CTO_SOURCES

            MSC_CURRENCY_CONVERSIONS

            MSC_CUST_SUP_F

            MSC_CUST_SUP_ODS_F

            MSC_DELIVERY_DETAILS

            MSC_DEMANDS

            MSC_DEMANDS_CUM_F

            MSC_DEMANDS_F

            MSC_DEMAND_CLASSES

            MSC_DEMAND_MV_TAB

            MSC_DEMANTRA_F

            MSC_DEMANTRA_ODS_F

            MSC_DEPARTMENT_RESOURCES

            MSC_DEPT_RES_INSTANCES

            MSC_DERIVED_ORDER_TYPES

            MSC_DESIGNATORS

            MSC_DMD_SCN_METRICS

            MSC_DOC_ATTACHMENTS

            MSC_DRP_ALLOC_RECEIPT_RULES

            MSC_DRP_ALLOC_RULES

            MSC_DRP_ALLOC_RULE_DATES

            MSC_DRP_DMD_PRI_RULES

            MSC_DRP_ITEM_ALLOCATIONS

            MSC_DRP_PRI_RULES_CALC

            MSC_DRP_PRI_RULES_SPECIFIED

            MSC_EAM_ACT_ASSOCIATIONS

            MSC_EAM_ASSET_EQUIP_DTLS

            MSC_ERRORS

            MSC_EXCEPTIONS_F

            MSC_EXCEPTION_DETAILS

            MSC_EXCEPTION_GROUPS

            MSC_EXCEPTION_PREFERENCES

            MSC_EXCEPTION_THRESHOLDS

            MSC_EXCEPTION_THRESHOLD_VALUES

            MSC_EXCEP_THRESHOLDS

            MSC_EXCP_GRP_CATEGORIES

            MSC_EXCP_GRP_ORGS

            MSC_EXC_DETAILS_ALL

            MSC_EXPLODED_COMP_TEMP

            MSC_FCST_PARAMETER_KEYS

            MSC_FCST_PARAMETER_VALUES

            MSC_FCTI_HEADERS_INTERFACE

            MSC_FCTI_LINES_INTERFACE

            MSC_FILES

            MSC_FLATFILE_SCHEMA

            MSC_FOLDER_COLUMNS

            MSC_FORECAST_RULES

            MSC_FORECAST_UPDATES

            MSC_FULL_PEGGING

            MSC_GROUPS

            MSC_GROUP_COMPANIES

            MSC_GROUP_IDS

            MSC_HP_COL_DTLS

            MSC_HP_MEASURES

            MSC_HP_ROW_DTLS

            MSC_HP_UPDATES

            MSC_IB_CONTRACTS_TEMP

            MSC_INSTANCE_ORGS

            MSC_INST_PARTITIONS

            MSC_INTERORG_SHIP_METHODS

            MSC_INT_COLUMN_MAP

            MSC_INT_MODEL_NAVIGATION

            MSC_INT_OITABLE_CREATE

            MSC_INT_PACKAGES

            MSC_INT_PLAN_OUTPUT_SCHEDULE

            MSC_INT_PUBLISH_DATA

            MSC_INT_REFRESH_DATA

            MSC_INT_SQL_EXTRACT

            MSC_INT_SUPPORTED_API

            MSC_INT_TABLE_MAP

            MSC_INVENTORY_BUDGETS

            MSC_INVENTORY_BUDGET_VALUES

            MSC_INVENTORY_LEVELS

            MSC_ITEMS

            MSC_ITEMS_F

            MSC_ITEM_ATTRIBUTES

            MSC_ITEM_CATEGORIES

            MSC_ITEM_CUSTOMERS

            MSC_ITEM_EXCEPTIONS

            MSC_ITEM_FAILURE_RATES

            MSC_ITEM_FCST_BOD_SR_LEVELS

            MSC_ITEM_FCST_SR_LEVELS

            MSC_ITEM_ID_LID

            MSC_ITEM_INVENTORY_F

            MSC_ITEM_ORDERS_F

            MSC_ITEM_SIMULATION_SETS

            MSC_ITEM_SOURCING

            MSC_ITEM_SO_SR_LEVELS

            MSC_ITEM_SUBSTITUTES

            MSC_ITEM_SUPPLIERS

            MSC_ITEM_TYPE_DEFINITIONS

            MSC_ITEM_WIPS_F

            MSC_ITG_COLUMN_MAP

            MSC_ITG_MODEL_NAVIGATION

            MSC_ITG_OITABLE_CREATE

            MSC_ITG_PACKAGES

            MSC_ITG_PLAN_OUTPUT_SCHEDULE

            MSC_ITG_PUBLISH_DATA

            MSC_ITG_REFRESH_DATA

            MSC_ITG_SQL_EXTRACT

            MSC_ITG_SUPPORTED_API

            MSC_ITG_TABLE_MAP

            MSC_JOB_OPERATIONS

            MSC_JOB_OPERATION_NETWORKS

            MSC_JOB_OP_RESOURCES

            MSC_JOB_OP_RES_INSTANCES

            MSC_JOB_REQUIREMENT_OPS

            MSC_LATE_ORDER_MV_TAB

            MSC_LOCAL_ID_DEMAND

            MSC_LOCAL_ID_ITEM

            MSC_LOCAL_ID_MISC

            MSC_LOCAL_ID_SETUP

            MSC_LOCAL_ID_SUPPLY

            MSC_LOCATION_ASSOCIATIONS

            MSC_LONG_TEXT

            MSC_MATL_PLAN_DATA

            MSC_MTH_OPEN_SALES_ORDERS_F

            MSC_NEC_COMPARE_PLANS

            MSC_NEC_EXC_DTL_COMPARE

            MSC_NETCHANGE_REPLAN_ITEMS

            MSC_NET_CHANGE_CRITERIA

            MSC_NET_RESOURCE_AVAIL

            MSC_NET_RES_INST_AVAIL

            MSC_ONLINE_REPLAN_ITEMS

            MSC_OPERATION_COMPONENTS

            MSC_OPERATION_NETWORKS

            MSC_OPERATION_RESOURCES

            MSC_OPERATION_RESOURCE_SEQS

            MSC_ORG_ACCESS

            MSC_ORG_AGGR_IBUC

            MSC_ORP_MASS_UPDATE_COLUMNS_B

            MSC_ORP_MASS_UPDATE_COLUMNS_TL

            MSC_ORP_MATERIAL_PLANS

            MSC_ORP_RESOURCE_PLANS

            MSC_ORP_UI_LAYOUT_PREFERENCES

            MSC_OUTBOUND_ENTRIES

            MSC_PARAMETERS

            MSC_PARTNER_CONTACTS

            MSC_PART_DEMANDS

            MSC_PART_PEGGING

            MSC_PART_SUPPLIES

            MSC_PDR_PARAMETERS

            MSC_PDR_PARAMETERS_NEW

            MSC_PERIOD_START_DATES

            MSC_PERSONAL_QUERIES

            MSC_PLANNERS

            MSC_PLANNING_PROCESS

            MSC_PLANNING_PROC_ACTIVITIES

            MSC_PLANS

            MSC_PLANS_OTHER

            MSC_PLAN_BUCKETS

            MSC_PLAN_CATEGORIES

            MSC_PLAN_CONSTRAINTS

            MSC_PLAN_EXCP_TYPES

            MSC_PLAN_ORDER_TYPES

            MSC_PLAN_ORGANIZATIONS

            MSC_PLAN_ORG_KPIS

            MSC_PLAN_ORG_STATUS

            MSC_PLAN_PARTITIONS

            MSC_PLAN_PROFILES

            MSC_PLAN_QUERIES

            MSC_PLAN_REFRESHES

            MSC_PLAN_RUNS

            MSC_PLAN_SCHEDULES

            MSC_PO_RECEIPTS

            MSC_PO_REQUISITIONS_INTERFACE

            MSC_PO_RESCHEDULE_INTERFACE

            MSC_PQ_RESULTS

            MSC_PQ_TYPES

            MSC_PQ_TYPES_CRITERIA

            MSC_PROCESS_EFFECTIVITY

            MSC_PROCESS_FLOWS

            MSC_PROCESS_FLOW_ACTIVITIES

            MSC_PROCESS_INSTANCES

            MSC_PROC_INST_ACT_PARAMS

            MSC_PROFILES

            MSC_PROJECTS

            MSC_PROJECT_TASKS

            MSC_PURCHASE_ORDER_INTERFACE

            MSC_QUERY

            MSC_QUESTIONS_B

            MSC_QUESTIONS_TL

            MSC_REGIONS

            MSC_REGIONS_TEMP

            MSC_REGION_ITEM_ATTRIBUTES

            MSC_REGION_LOCATIONS

            MSC_REGION_SITES

            MSC_RELATED_EXCEPTIONS

            MSC_REPETITIVE_PERIODS

            MSC_RESERVATIONS

            MSC_RESOURCES_CUM_F

            MSC_RESOURCES_F

            MSC_RESOURCE_BATCHES

            MSC_RESOURCE_CHANGES

            MSC_RESOURCE_CHARGES

            MSC_RESOURCE_GROUPS

            MSC_RESOURCE_INSTANCE_REQS

            MSC_RESOURCE_PARAMETERS

            MSC_RESOURCE_RELATIONSHIPS

            MSC_RESOURCE_REQUIREMENTS

            MSC_RESOURCE_SETUPS

            MSC_RESOURCE_SHIFTS

            MSC_RES_ALLOC_PRIORITES

            MSC_RES_INSTANCE_CHANGES

            MSC_RES_PLAN_DATA

            MSC_RES_PLAN_UPDATES

            MSC_ROUTINGS

            MSC_ROUTING_OPERATIONS

            MSC_RP_CALENDAR_DATES

            MSC_RP_CTB_DONOR_COMPONENTS

            MSC_RP_CTB_ORDER_COMPONENTS

            MSC_RP_DEMAND_UPDATES

            MSC_RP_FAVORITES

            MSC_RP_FAVORITE_LISTS

            MSC_RP_ITEM_UPDATES

            MSC_RP_KPI

            MSC_RP_PLAN_ACCESS

            MSC_RP_RELEASED_ORDERS

            MSC_RP_RELEASE_RESULTS

            MSC_RP_RELEASE_STATUS

            MSC_RP_SELECTION_CRITERIA

            MSC_RP_SIMULATION_SETS

            MSC_RP_USER_METRICS

            MSC_RP_USER_METRIC_LAYOUT

            MSC_SAFETY_STOCKS

            MSC_SALES_ORDERS

            MSC_SALES_ORDER_INTERFACE

            MSC_SALES_ORDER_ITEMS

            MSC_SCENARIOS

            MSC_SCENARIO_ACTIVITIES

            MSC_SCENARIO_PLANS

            MSC_SCENARIO_SETS

            MSC_SCENARIO_SET_DETAILS

            MSC_SCENARIO_USERS

            MSC_SCHEDULING_RULES

            MSC_SECURITY_RULES

            MSC_SEGMENT_ALLOCATIONS

            MSC_SELECTED_EXCEPTIONS

            MSC_SELECTION_CRITERIA

            MSC_SEQUENCE_DEPENDENT_SETUPS

            MSC_SERIAL_NUMBERS

            MSC_SERVICE_LEVELS

            MSC_SERVICE_LEVEL_SETS

            MSC_SETUP_TRANSITIONS

            MSC_SHIFT_DATES

            MSC_SHIFT_EXCEPTIONS

            MSC_SHIFT_TIMES

            MSC_SHIPMENTS

            MSC_SHORT_TEXT

            MSC_SIMULATION_SETS

            MSC_SINGLE_LVL_PEG

            MSC_SNAPSHOT_TASKS

            MSC_SOLVER_GROUPS

            MSC_SOL_GRP_RES

            MSC_SORT_DATA

            MSC_SOURCING_HISTORY

            MSC_SOURCING_RULES

            MSC_SO_RELEASE_INTERFACE

            MSC_SQLLOAD_PARAMETERS

            MSC_SRP_GROUPS

            MSC_SRP_ITEM_EXCEPTIONS

            MSC_SRP_USER_GROUPS

            MSC_SR_ASSIGNMENTS

            MSC_SR_LOOKUPS

            MSC_SR_RECEIPT_ORG

            MSC_SR_SOURCE_ORG

            MSC_SR_ZN_AGGR_IBUC

            MSC_STD_OP_RESOURCES

            MSC_STORE_RESOURCE_REQS

            MSC_STORE_SUPPLIES

            MSC_ST_ABC_CLASSES

            MSC_ST_APCC_HIER

            MSC_ST_APCC_HIER_DEF

            MSC_ST_APPS_INSTANCES

            MSC_ST_ASSIGNMENT_SETS

            MSC_ST_ATP_RULES

            MSC_ST_BILL_OF_RESOURCES

            MSC_ST_BIS_BUSINESS_PLANS

            MSC_ST_BIS_PERIODS

            MSC_ST_BIS_PFMC_MEASURES

            MSC_ST_BIS_TARGETS

            MSC_ST_BIS_TARGET_LEVELS

            MSC_ST_BOMS

            MSC_ST_BOM_COMPONENTS

            MSC_ST_BOR_REQUIREMENTS

            MSC_ST_BUDGETS_F

            MSC_ST_CALENDARS

            MSC_ST_CALENDAR_ASSIGNMENTS

            MSC_ST_CALENDAR_DATES

            MSC_ST_CALENDAR_EXCEPTIONS

            MSC_ST_CALENDAR_MONTHS

            MSC_ST_CALENDAR_SHIFTS

            MSC_ST_CAL_WEEK_START_DATES

            MSC_ST_CAL_YEAR_START_DATES

            MSC_ST_CARRIER_SERVICES

            MSC_ST_CATEGORY_SETS

            MSC_ST_COMPANY_USERS

            MSC_ST_COMPONENT_SUBSTITUTES

            MSC_ST_COSTS_F

            MSC_ST_CO_PRODUCTS

            MSC_ST_CURRENCY_CONVERSIONS

            MSC_ST_CUST_SUP_F

            MSC_ST_CUST_SUP_ODS_F

            MSC_ST_DELIVERY_DETAILS

            MSC_ST_DEMANDS

            MSC_ST_DEMANDS_CUM_F

            MSC_ST_DEMANDS_F

            MSC_ST_DEMAND_CLASSES

            MSC_ST_DEMANTRA_F

            MSC_ST_DEMANTRA_ODS_F

            MSC_ST_DEPARTMENT_RESOURCES

            MSC_ST_DEPT_RES_INSTANCES

            MSC_ST_DESIGNATORS

            MSC_ST_DOC_ATTACHMENTS

            MSC_ST_EAM_ACT_ASSOCIATIONS

            MSC_ST_EAM_ASSET_EQUIP_DTLS

            MSC_ST_EXCEPTIONS_F

            MSC_ST_GROUPS

            MSC_ST_GROUP_COMPANIES

            MSC_ST_INTERORG_SHIP_METHODS

            MSC_ST_ITEMS_F

            MSC_ST_ITEM_ATTRIBUTES

            MSC_ST_ITEM_CATEGORIES

            MSC_ST_ITEM_CUSTOMERS

            MSC_ST_ITEM_INVENTORY_F

            MSC_ST_ITEM_ORDERS_F

            MSC_ST_ITEM_SOURCING

            MSC_ST_ITEM_SUBSTITUTES

            MSC_ST_ITEM_SUPPLIERS

            MSC_ST_ITEM_WIPS_F

            MSC_ST_JOB_OPERATIONS

            MSC_ST_JOB_OPERATION_NETWORKS

            MSC_ST_JOB_OP_RESOURCES

            MSC_ST_JOB_OP_RES_INSTANCES

            MSC_ST_JOB_REQUIREMENT_OPS

            MSC_ST_LOCATION_ASSOCIATIONS

            MSC_ST_LONG_TEXT

            MSC_ST_NET_RESOURCE_AVAIL

            MSC_ST_NET_RES_INST_AVAIL

            MSC_ST_OPEN_PAYBACKS

            MSC_ST_OPERATION_COMPONENTS

            MSC_ST_OPERATION_NETWORKS

            MSC_ST_OPERATION_RESOURCES

            MSC_ST_OPERATION_RESOURCE_SEQS

            MSC_ST_PARAMETERS

            MSC_ST_PARTNER_CONTACTS

            MSC_ST_PERIOD_START_DATES

            MSC_ST_PLANNERS

            MSC_ST_PRICE_LIST

            MSC_ST_PROCESS_EFFECTIVITY

            MSC_ST_PROFILES

            MSC_ST_PROJECTS

            MSC_ST_PROJECT_TASKS

            MSC_ST_REGIONS

            MSC_ST_REGION_LOCATIONS

            MSC_ST_REGION_SITES

            MSC_ST_RESERVATIONS

            MSC_ST_RESOURCES_CUM_F

            MSC_ST_RESOURCES_F

            MSC_ST_RESOURCE_CHANGES

            MSC_ST_RESOURCE_CHARGES

            MSC_ST_RESOURCE_GROUPS

            MSC_ST_RESOURCE_INSTANCE_REQS

            MSC_ST_RESOURCE_REQUIREMENTS

            MSC_ST_RESOURCE_SETUPS

            MSC_ST_RESOURCE_SHIFTS

            MSC_ST_RES_INSTANCE_CHANGES

            MSC_ST_ROUTINGS

            MSC_ST_ROUTING_OPERATIONS

            MSC_ST_SAFETY_STOCKS

            MSC_ST_SALES_ORDERS

            MSC_ST_SERIAL_NUMBERS

            MSC_ST_SETUP_TRANSITIONS

            MSC_ST_SHIFT_DATES

            MSC_ST_SHIFT_EXCEPTIONS

            MSC_ST_SHIFT_TIMES

            MSC_ST_SHORT_TEXT

            MSC_ST_SIMULATION_SETS

            MSC_ST_SOURCING_HISTORY

            MSC_ST_SOURCING_RULES

            MSC_ST_SR_ASSIGNMENTS

            MSC_ST_SR_LOOKUPS

            MSC_ST_SR_RECEIPT_ORG

            MSC_ST_SR_SOURCE_ORG

            MSC_ST_STD_OP_RESOURCES

            MSC_ST_SUB_INVENTORIES

            MSC_ST_SUPPLIERS_F

            MSC_ST_SUPPLIER_CAPACITIES

            MSC_ST_SUPPLIER_FLEX_FENCES

            MSC_ST_SUPPLIES

            MSC_ST_SUPPLIES_F

            MSC_ST_SYSTEM_ITEMS

            MSC_ST_TRADING_PARTNERS

            MSC_ST_TRADING_PARTNER_SITES

            MSC_ST_TRIPS

            MSC_ST_TRIP_STOPS

            MSC_ST_UNITS_OF_MEASURE

            MSC_ST_UNIT_NUMBERS

            MSC_ST_UOM_CLASS_CONVERSIONS

            MSC_ST_UOM_CONVERSIONS

            MSC_ST_VISITS

            MSC_ST_WAREHOUSE_F

            MSC_ST_WORKDAY_PATTERNS

            MSC_ST_WORK_BREAKDOWN_STRUCT

            MSC_ST_WO_ATTRIBUTES

            MSC_ST_WO_MILESTONES

            MSC_ST_WO_OPERATION_REL

            MSC_ST_WO_SUB_COMP

            MSC_ST_WO_TASK_HIERARCHY

            MSC_ST_ZN_AGGR_IBUC

            MSC_ST_ZONE_REGIONS

            MSC_SUBSET_DESIGNATORS

            MSC_SUBSET_DESIG_DTLS

            MSC_SUB_INVENTORIES

            MSC_SUPDEM_HDRS_INTERFACE

            MSC_SUPDEM_LINES_INTERFACE

            MSC_SUPPLIERS_F

            MSC_SUPPLIER_CAPACITIES

            MSC_SUPPLIER_FLEX_FENCES

            MSC_SUPPLIER_LT_OUTCOMES

            MSC_SUPPLIER_REQUIREMENTS

            MSC_SUPPLIES

            MSC_SUPPLIES_F

            MSC_SUPPLY_PRIORITIES

            MSC_SUP_DEM_ENTRIES

            MSC_SUP_DEM_HISTORY

            MSC_SUP_HEADERS_INTERFACE

            MSC_SUP_LINES_INTERFACE

            MSC_SYSTEM_ITEMS

            MSC_TEMP_ALLOC_DEMANDS

            MSC_TEMP_ALLOC_SUPPLIES

            MSC_TEMP_SUMM_RES

            MSC_TEMP_SUMM_SD

            MSC_TEMP_SUMM_SO

            MSC_TEMP_SUMM_SUP

            MSC_TP_ID_LID

            MSC_TP_SITE_ID_LID

            MSC_TRADING_PARTNERS

            MSC_TRADING_PARTNER_MAPS

            MSC_TRADING_PARTNER_SITES

            MSC_TRANSLATED_MESSAGE

            MSC_TRANSPORTATION_UPDATES

            MSC_TRIPS

            MSC_TRIP_STOPS

            MSC_UNDO_DETAILS

            MSC_UNDO_SUMMARY

            MSC_UNITS_OF_MEASURE

            MSC_UNIT_NUMBERS

            MSC_UOM_CLASS_CONVERSIONS

            MSC_UOM_CONVERSIONS

            MSC_USER_ACTIONS

            MSC_USER_ADV_EXPRESSIONS

            MSC_USER_EXCEPTIONS

            MSC_USER_EXCEPTION_COMPONENTS

            MSC_USER_EXCEPTION_NTFS

            MSC_USER_NOTES

            MSC_USER_PREFERENCES

            MSC_USER_PREFERENCE_KEYS

            MSC_USER_PREFERENCE_VALUES

            MSC_VISITS

            MSC_VMI_TEMP

            MSC_WAREHOUSE_CAPACITIES

            MSC_WAREHOUSE_F

            MSC_WEB_SERVICES

            MSC_WHSE_REQUIREMENTS

            MSC_WIP_JOB_DTLS_INTERFACE

            MSC_WIP_JOB_SCHEDULE_INTERFACE

            MSC_WORKBENCH_DISPLAY_OPTIONS

            MSC_WORKDAY_PATTERNS

            MSC_WORKLIST_GROUPBY

            MSC_WORK_BREAKDOWN_STRUCT

            MSC_WO_ATTRIBUTES

            MSC_WO_MILESTONES

            MSC_WO_OPERATION_REL

            MSC_WO_SUB_COMP

            MSC_WO_TASK_HIERARCHY

            MSC_WRK_ORD_BD_STRUCTURE

            MSC_X_EXCEPTION_DETAILS

            MSC_X_SECURITY_RULES

            MSC_ZONE_REGIONS

             

            563 rows selected.

            • 3. Re: Gather schema statistics
              mdtaylor

              Hi jc,

               

              First thing is you should be using fnd_stats, not dbms_stats to gather stats for EBS databases.  Submit the concurrent request for ALL schemas in GATHER mode.

               

              Second, you will have null last_analyzed for global temporary tables, usually ending with the name TEMP or TMP.

               

              Regards,

              Michael

              • 4. Re: Gather schema statistics
                Gbenga Ajakaye

                I see, those are different tables, base on the values.

                • 5. Re: Gather schema statistics
                  Beauty_and_dBest

                  Thanks Micheal and everyone 

                   

                  What is the syntax for GATHER mode?

                   

                   

                  Kind regards,

                  • 6. Re: Gather schema statistics
                    mdtaylor

                    For Apps schemas, please schedule Gather Schema Statistics concurrent request and accept the default mode of GATHER.

                     

                    Long run times are mostly due to the slow storage performance and will need to fix that on priority.

                    • 7. Re: Gather schema statistics
                      Beauty_and_dBest

                      Thanks Michael