Run P6 db scripts that set table statistics (orpm_stats_gather.sql)
These scripts can be found at
/database/scripts/common/aux_script
They adjust statistics to be off for certain dynamic tables
[oracle@App1 software]$
cd P6_R151/p6suite/database/scripts/common/aux_script/
[oracle@App1 aux_script]$ ls
orpm_stats_gather_b.sql orpm_stats_gather_c.sql orpm_stats_gather.sql
[oracle@App1 aux_script]$
sqlplus admuser/*********
SQL*Plus: Release 12.1.0.1.0 Production on Sat Aug 22 16:33:32 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Sat Aug 22 2015 16:29:23 +07:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
@orpm_stats_gather.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Saving stats in PM_8X_STATS StatId=BACKUP_PRE_201508221633
PL/SQL procedure successfully completed.
Default collecting for ACCOUNT 1 of 361
Default collecting for ACTIVITYCODEHIERARCHY 2 of 361
Default collecting for ACTIVITYCODETYPESECURITY 3 of 361
Default collecting for ACTIVITYSPREAD 4 of 361
Default collecting for ACTVCODE 5 of 361
Default collecting for ACTVCODEX 6 of 361
Default collecting for ACTVTYPE 7 of 361
Default collecting for ADDTASKPROC 8 of 361
Default collecting for ADDTASKPROCX 9 of 361
Default collecting for ADMIN_CONFIG 10 of 361
Default collecting for ALERT 11 of 361
Default collecting for ALERTPARAM 12 of 361
Default collecting for ATTR_MASTER 13 of 361
Default collecting for BASETYPE 14 of 361
Default collecting for BGPLOG 15 of 361
Default collecting for BRE_REGISTRY 16 of 361
Default collecting for BUDGCHNG 17 of 361
Default collecting for BUDGCHNGX 18 of 361
Default collecting for CALENDAR 19 of 361
Default collecting for CALENDARX 20 of 361
Default collecting for CBS 21 of 361
Default collecting for CHGHEAD 22 of 361
Default collecting for CHGTASK 23 of 361
Default collecting for CHGTASKACTV 24 of 361
Default collecting for CHGTASKACTVX 25 of 361
Default collecting for CHGTASKMEMO 26 of 361
Default collecting for CHGTASKMEMOX 27 of 361
Default collecting for CHGTASKPROC 28 of 361
Default collecting for CHGTASKPROCX 29 of 361
Default collecting for CHGTASKX 30 of 361
Default collecting for CHGTRSRC 31 of 361
Default collecting for CHGTRSRCX 32 of 361
Default collecting for CHGUDFVALUE 33 of 361
Default collecting for CHGUDFVALUEX 34 of 361
Default collecting for COSTACCOUNTHIERARCHY 35 of 361
Default collecting for COSTSECURITY 36 of 361
Default collecting for COSTTYPE 37 of 361
Default collecting for CURRTYPE 38 of 361
Default collecting for CURRTYPEX 39 of 361
Default collecting for DASHBOARD 40 of 361
Default collecting for DASHUSER 41 of 361
Default collecting for DELTASKPROC 42 of 361
Default collecting for DELTASKPROCX 43 of 361
Default collecting for DISCUSSION 44 of 361
Default collecting for DISCUSSION_READ 45 of 361
Default collecting for DLTACCT 46 of 361
Default collecting for DLTACTV 47 of 361
Default collecting for DLTOBS 48 of 361
Default collecting for DLTROLE 49 of 361
Default collecting for DLTRSRC 50 of 361
Default collecting for DLTRSRL 51 of 361
Default collecting for DLTUSER 52 of 361
Default collecting for DM_ATTR 53 of 361
Default collecting for DOC 54 of 361
Default collecting for DOCCATG 55 of 361
Default collecting for DOCREVIEW 56 of 361
Default collecting for DOCREVIEWTASK 57 of 361
Default collecting for DOCSTAT 58 of 361
Default collecting for DOCUMENT 59 of 361
Default collecting for DOCUMENTX 60 of 361
Default collecting for DOC_FOLDER 61 of 361
Default collecting for DOC_RECENT 62 of 361
Default collecting for DOC_VERSION 63 of 361
Default collecting for DR$DOCVER_DOCDATA_QSI$I 64 of 361
Default collecting for DR$DOCVER_DOCDATA_QSI$K 65 of 361
Default collecting for DR$DOCVER_DOCDATA_QSI$N 66 of 361
Default collecting for DR$DOCVER_DOCDATA_QSI$R 67 of 361
Default collecting for EPSHIERARCHY 68 of 361
Default collecting for EPSSPREAD 69 of 361
Default collecting for EXPPROJ 70 of 361
Default collecting for EXTAPP 71 of 361
Default collecting for FACTOR 72 of 361
Default collecting for FACTVAL 73 of 361
Default collecting for FILTPROP 74 of 361
Default collecting for FINDATES 75 of 361
Default collecting for FORMCATG 76 of 361
Default collecting for FORMPROJ 77 of 361
Default collecting for FORMTMPL 78 of 361
Default collecting for FUNDSRC 79 of 361
Default collecting for GATEWAYDEPLOYMENT 80 of 361
Default collecting for GATEWAYPROVIDER 81 of 361
Default collecting for GATEWAYSYNCACTION 82 of 361
Default collecting for GCHANGE 83 of 361
Default collecting for GLOBALSECURITY 84 of 361
Default collecting for HQDATA 85 of 361
Default collecting for HQUERY 86 of 361
Default collecting for ISSUHIST 87 of 361
Default collecting for ITERATION 88 of 361
Default collecting for ITERTASK 89 of 361
Default collecting for ITERTEAM 90 of 361
Default collecting for JOBLOG 91 of 361
Default collecting for JOBRPT 92 of 361
Default collecting for JOBSET 93 of 361
Default collecting for JOBSVC 94 of 361
Default collecting for LOCATION 95 of 361
Default collecting for MANAGEMENT_REQUEST 96 of 361
Default collecting for MAPPING_CENTER_STAFF 97 of 361
Default collecting for MDRT_17416$ 98 of 361
Default collecting for MDRT_1741D$ 99 of 361
Default collecting for MDXT_17416$ 100 of 361
Default collecting for MDXT_17416$_BKTS 101 of 361
Default collecting for MDXT_17416$_MBR 102 of 361
Default collecting for MDXT_1741D$ 103 of 361
Default collecting for MDXT_1741D$_BKTS 104 of 361
Default collecting for MDXT_1741D$_MBR 105 of 361
Default collecting for MD_ADDITIONAL_PROPERTIES 106 of 361
Default collecting for MD_APPLICATIONFILES 107 of 361
Default collecting for MD_APPLICATIONS 108 of 361
Default collecting for MD_CATALOGS 109 of 361
Default collecting for MD_CODE_REGEX 110 of 361
Default collecting for MD_COLUMNS 111 of 361
Default collecting for MD_CONNECTIONS 112 of 361
Default collecting for MD_CONSTRAINTS 113 of 361
Default collecting for MD_CONSTRAINT_DETAILS 114 of 361
Default collecting for MD_DERIVATIVES 115 of 361
Default collecting for MD_FILE_ARTIFACTS 116 of 361
Default collecting for MD_GROUPS 117 of 361
Default collecting for MD_GROUP_MEMBERS 118 of 361
Default collecting for MD_GROUP_PRIVILEGES 119 of 361
Default collecting for MD_INDEXES 120 of 361
Default collecting for MD_INDEX_DETAILS 121 of 361
Default collecting for MD_MIGR_DEPENDENCY 122 of 361
Default collecting for MD_MIGR_PARAMETER 123 of 361
Default collecting for MD_MIGR_WEAKDEP 124 of 361
Default collecting for MD_NUMROW$SOURCE 125 of 361
Default collecting for MD_NUMROW$TARGET 126 of 361
Default collecting for MD_OTHER_OBJECTS 127 of 361
Default collecting for MD_PACKAGES 128 of 361
Default collecting for MD_PARTITIONS 129 of 361
Default collecting for MD_PRIVILEGES 130 of 361
Default collecting for MD_PROJECTS 131 of 361
Default collecting for MD_REGISTRY 132 of 361
Default collecting for MD_REPOVERSIONS 133 of 361
Default collecting for MD_SCHEMAS 134 of 361
Default collecting for MD_SEQUENCES 135 of 361
Default collecting for MD_STORED_PROGRAMS 136 of 361
Default collecting for MD_SYNONYMS 137 of 361
Default collecting for MD_TABLES 138 of 361
Default collecting for MD_TABLESPACES 139 of 361
Default collecting for MD_TRIGGERS 140 of 361
Default collecting for MD_USERS 141 of 361
Default collecting for MD_USER_DEFINED_DATA_TYPES 142 of 361
Default collecting for MD_USER_PRIVILEGES 143 of 361
Default collecting for MD_VIEWS 144 of 361
Default collecting for MEMOTYPE 145 of 361
Default collecting for MIGRLOG 146 of 361
Default collecting for MIGR_DATATYPE_TRANSFORM_MAP 147 of 361
Default collecting for MIGR_DATATYPE_TRANSFORM_RULE 148 of 361
Default collecting for MIGR_GENERATION_ORDER 149 of 361
Default collecting for MTXSCRTYP 150 of 361
Default collecting for NEXTKEY 151 of 361
Default collecting for NONWORK 152 of 361
Default collecting for NOTE 153 of 361
Default collecting for OBS 154 of 361
Default collecting for OBSPROJ 155 of 361
Default collecting for PCATTYPE 156 of 361
Default collecting for PCATUSER 157 of 361
Default collecting for PCATUSERX 158 of 361
Default collecting for PCATVAL 159 of 361
Default collecting for PCATVALX 160 of 361
Default collecting for PC_KEY_XREF 161 of 361
Default collecting for PC_PROCESS_STAT 162 of 361
Default collecting for PFOLIO 163 of 361
Default collecting for PFOLIOX 164 of 361
Default collecting for PHASE 165 of 361
Default collecting for PLPROJREF 166 of 361
Default collecting for POBS 167 of 361
Default collecting for PREFER 168 of 361
Default collecting for PRMAUDIT 169 of 361
Default collecting for PRMQUEUE 170 of 361
Default collecting for PROCGROUP 171 of 361
Default collecting for PROCITEM 172 of 361
Default collecting for PROFILE 173 of 361
Default collecting for PROFPRIV 174 of 361
Default collecting for PROFPRIVX 175 of 361
Default collecting for PROJCOST 176 of 361
Default collecting for PROJCOSTX 177 of 361
Default collecting for PROJDEPLMENT 178 of 361
Default collecting for PROJECT 179 of 361
Default collecting for PROJECTCODEHIERARCHY 180 of 361
Default collecting for PROJECTCOSTCBSSPREAD 181 of 361
Default collecting for PROJECTSECURITY 182 of 361
Default collecting for PROJECTSPREAD 183 of 361
Default collecting for PROJECTX 184 of 361
Default collecting for PROJEST 185 of 361
Default collecting for PROJFUND 186 of 361
Default collecting for PROJFUNDX 187 of 361
Default collecting for PROJISSU 188 of 361
Default collecting for PROJISSUX 189 of 361
Default collecting for PROJPCAT 190 of 361
Default collecting for PROJPCATX 191 of 361
Default collecting for PROJPROP 192 of 361
Default collecting for PROJRISK 193 of 361
Default collecting for PROJSET 194 of 361
Default collecting for PROJTHRS 195 of 361
Default collecting for PROJWBS 196 of 361
Default collecting for PROJWBSX 197 of 361
Default collecting for PROJWSRPT 198 of 361
Default collecting for PRPFOLIO 199 of 361
Default collecting for PUBUSER 200 of 361
Default collecting for QUERYLIB 201 of 361
Default collecting for RCATTYPE 202 of 361
Default collecting for RCATVAL 203 of 361
Default collecting for RCATVALX 204 of 361
Default collecting for REITTYPE 205 of 361
Default collecting for RELEASE 206 of 361
Default collecting for RELITEMS 207 of 361
Default collecting for RELITER 208 of 361
Default collecting for RELPROJ 209 of 361
Default collecting for REPORTDATE 210 of 361
Default collecting for REPORTTIME 211 of 361
Default collecting for RESOURCEASSIGNMENTCBSSPREAD 212 of 361
Default collecting for RESOURCEASSIGNMENTSPREAD 213 of 361
Default collecting for RESOURCECODEHIERARCHY 214 of 361
Default collecting for RESOURCEHIERARCHY 215 of 361
Default collecting for RESOURCELIMIT 216 of 361
Default collecting for RFOLIO 217 of 361
Default collecting for RFOLIOX 218 of 361
Default collecting for RISK 219 of 361
Default collecting for RISKCTRL 220 of 361
Default collecting for RISKIMPACT 221 of 361
Default collecting for RISKMIT 222 of 361
Default collecting for RISKMITIMP 223 of 361
Default collecting for RISKMITX 224 of 361
Default collecting for RISKMTXSCR 225 of 361
Default collecting for RISKRSPPLN 226 of 361
Default collecting for RISKRSPPLNX 227 of 361
Default collecting for RISKSCRMTX 228 of 361
Default collecting for RISKSCRTHR 229 of 361
Default collecting for RISKSCRTYP 230 of 361
Default collecting for RISKTYPE 231 of 361
Default collecting for RISKX 232 of 361
Default collecting for RLFOLIO 233 of 361
Default collecting for RLFOLIOX 234 of 361
Default collecting for ROLELIMIT 235 of 361
Default collecting for ROLERATE 236 of 361
Default collecting for ROLERATEX 237 of 361
Default collecting for ROLES 238 of 361
Default collecting for ROLFOLIO 239 of 361
Default collecting for RPT 240 of 361
Default collecting for RPTBATCH 241 of 361
Default collecting for RPTGROUP 242 of 361
Default collecting for RPTLIST 243 of 361
Default collecting for RSRC 244 of 361
Default collecting for RSRCANDASH 245 of 361
Default collecting for RSRCANVIEW 246 of 361
Default collecting for RSRCCURV 247 of 361
Default collecting for RSRCCURVX 248 of 361
Default collecting for RSRCHOUR 249 of 361
Default collecting for RSRCHOURX 250 of 361
Default collecting for RSRCLOC 251 of 361
Default collecting for RSRCPROP 252 of 361
Default collecting for RSRCRATE 253 of 361
Default collecting for RSRCRATEX 254 of 361
Default collecting for RSRCRCAT 255 of 361
Default collecting for RSRCRCATX 256 of 361
Default collecting for RSRCROLE 257 of 361
Default collecting for RSRCROLEX 258 of 361
Default collecting for RSRCSEC 259 of 361
Default collecting for RSRCSECX 260 of 361
Default collecting for RSRCX 261 of 361
Default collecting for RSRFOLIO 262 of 361
Default collecting for SCENARIO 263 of 361
Default collecting for SCENPROJ 264 of 361
Default collecting for SCENROLE 265 of 361
Default collecting for SCENUSER 266 of 361
Default collecting for SETTINGS 267 of 361
Default collecting for SHIFT 268 of 361
Default collecting for SHIFTPER 269 of 361
Default collecting for SNAPGROUP 270 of 361
Default collecting for SNAPPROJ 271 of 361
Default collecting for SNAPSHOT 272 of 361
Default collecting for SPIDMAP 273 of 361
Default collecting for STAFF_DOINGBY 274 of 361
Default collecting for STAGE_MIGRLOG 275 of 361
Default collecting for SUMPROJCOST 276 of 361
Default collecting for SUMTASK 277 of 361
Default collecting for SUMTASKSPREAD 278 of 361
Default collecting for SUMTRSRC 279 of 361
Default collecting for TASK 280 of 361
Default collecting for TASKACTV 281 of 361
Default collecting for TASKACTVX 282 of 361
Default collecting for TASKCBSX 283 of 361
Default collecting for TASKDOC 284 of 361
Default collecting for TASKDOCX 285 of 361
Default collecting for TASKFDBK 286 of 361
Default collecting for TASKFIN 287 of 361
Default collecting for TASKFINX 288 of 361
Default collecting for TASKMEMO 289 of 361
Default collecting for TASKMEMOX 290 of 361
Default collecting for TASKNOTE 291 of 361
Default collecting for TASKPRED 292 of 361
Default collecting for TASKPREDX 293 of 361
Default collecting for TASKPROC 294 of 361
Default collecting for TASKPROCX 295 of 361
Default collecting for TASKRISK 296 of 361
Default collecting for TASKRISKX 297 of 361
Default collecting for TASKRSRC 298 of 361
Default collecting for TASKRSRCX 299 of 361
Default collecting for TASKSUM 300 of 361
Default collecting for TASKSUMFIN 301 of 361
Default collecting for TASKUSER 302 of 361
Default collecting for TASKWKSP 303 of 361
Default collecting for TASKX 304 of 361
Default collecting for TEMPKEYS 305 of 361
Default collecting for THRSPARM 306 of 361
Default collecting for TIMESHT 307 of 361
Default collecting for TIMESHTX 308 of 361
Default collecting for TMPLCATG 309 of 361
Default collecting for TPROJMAP 310 of 361
Default collecting for TRAKVIEW 311 of 361
Default collecting for TRSRCFIN 312 of 361
Default collecting for TRSRCFINX 313 of 361
Default collecting for TRSRCSUM 314 of 361
Default collecting for TRSRCSUMFN 315 of 361
Default collecting for TSAUDIT 316 of 361
Default collecting for TSDATES 317 of 361
Default collecting for TSDELEGATE 318 of 361
Default collecting for UACCESS 319 of 361
Default collecting for UDFCODE 320 of 361
Default collecting for UDFCODEX 321 of 361
Default collecting for UDFTYPE 322 of 361
Default collecting for UDFVALUE 323 of 361
Default collecting for UDFVALUEX 324 of 361
Default collecting for UEVNTREG 325 of 361
Default collecting for UMEASURE 326 of 361
Default collecting for USERCOL 327 of 361
Default collecting for USERDATA 328 of 361
Default collecting for USERENG 329 of 361
Default collecting for USEROBS 330 of 361
Default collecting for USEROBSX 331 of 361
Default collecting for USEROPEN 332 of 361
Default collecting for USERS 333 of 361
Default collecting for USERSET 334 of 361
Default collecting for USERSX 335 of 361
Default collecting for USERWKSP 336 of 361
Default collecting for USESSAUD 337 of 361
Default collecting for USROPNVAL 338 of 361
Default collecting for VIEWPREF 339 of 361
Default collecting for VIEWPROP 340 of 361
Default collecting for VWPREFDASH 341 of 361
Default collecting for VWPREFDATA 342 of 361
Default collecting for VWPREFUSER 343 of 361
Default collecting for WBRSCAT 344 of 361
Default collecting for WBSBUDG 345 of 361
Default collecting for WBSBUDGX 346 of 361
Default collecting for WBSHIERARCHY 347 of 361
Default collecting for WBSMEMO 348 of 361
Default collecting for WBSMEMOX 349 of 361
Default collecting for WBSRSRC 350 of 361
Default collecting for WBSRSRCX 351 of 361
Default collecting for WBSRSRC_QTY 352 of 361
Default collecting for WBSRSRC_QTYX 353 of 361
Default collecting for WBSSPREAD 354 of 361
Default collecting for WBSSTEP 355 of 361
Default collecting for WBSSTEPX 356 of 361
Default collecting for WKFLTMPL 357 of 361
Default collecting for WKFLUSER 358 of 361
Default collecting for WORKFLOW 359 of 361
Default collecting for WORKSPACE 360 of 361
Default collecting for WRK_LOG_RESULTS 361 of 361
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL>
