activeautopatch
autopatch 时间:2021-03-23 阅读:()
NumbersandSymbols-parameter,usingtogetquickhelp,177$,forcheckingareturncodeafteraUNIXcommandisexecuted,56$APPL_TOP/.
envenvironmentfile,codeshowingsettingsofthevaluesin,11510gGridControlDiagnosticsPack,trendanalysisformetricsthatarecollectedasfeatureof,62AActiveSessionHistory(ASH)usingwithOracle10g,104–105viewinginformationcollectedby,104ADAdministration(adadmin)utilitytheGenerateApplicationsFilessubmenu,153mainmenu,153forperformingmostpost-patchingrequirements,152–154usingtoregenerateforms,libraries,andmenus,166–167usingtorelinkapplicationexecutables,164ADConfiguration.
Seealsoconfigurationforautomatingconfigurationofapplicationanddatabasetiers,11executing,18–19MetalinkNoteforinformationaboutenabling,11preservationofcustomizationtagswhenusingtheutility,21using,18–22ADControlusingnoninteractivelytoexpeditepatchproblemresolution,151usingtomanagepatchworkers,150–151ADControllermenu,exampleof,150ADMergeutility,usingtoapplyagroupoflargepatches,147–148ADPatchutilitydisablinganypasswordconstraintsbeforeexecuting,143usingtoapplyapplicationpatches,142–145ADPatchWorkerfailures,commonerrormessagesandresolutions,151–152ADRelink,usingtorelinkADexecutables,163–164adadminutilityforperformingmostpost-patchingrequirements,152–154recompilinginvalidobjectswith,193adconfig.
shlocationofandallitssupportingscripts,18locationofbackupfiles,20restoringconfigurationfilesfromthebackupofarun,20reviewingtheexecutionchanges,19–20reviewingthelogfiles,19adctrlmenuoption,executing,150219IndexADDM.
SeeAutomaticDatabaseDiagnosticMonitoring(ADDM)processadidentcommand,identifyingtheversionofapplicationfileswith,169adjkeycommand,recreatingtheidentity.
objfilewith,30ADJVAPRG,CLASSPATH,AFJVAPRG,andAF_CLASSPATH,checkingtodeterminetheJDKversionusedbyapplicationcomponents,174AdminNodeascomponentofE-BusinessSuite,2,4configurationof,12,29–32optionsforcreatinganewcustomparameterfor,21–22usedtoexecuteadministrativetasks,4admrgpchutility,tableofoptions,148adovars.
envapplicationconfigurationfiledirectorylocationof,29usingcustomizationsbyediting,21adpatchoptions,tableofcommonlyused,143adpatchutilitydisablinganypasswordconstraintsbeforeexecuting,143namingyourAutoPatchdrivefile,144questionsusermustrespondtowhenstarted,144runningtoapplythehrglobaldriver,147usingtoapplyapplicationpatches,142–145usingtoapplypatches,142adphrept.
sqlgeneratingapatchreportforaninstancewith,136–137tableofparametersfor,136–137adrelink.
sh,tableofdescriptionandvaluesforwith,164advancedarchitecture,forOracleApplications,5–9Alapati,Sam,ExpertOracleDatabase10gAdministrationby,215alertlogfile.
SeedatabasealertlogfileAOL/JTesttooltestmenuoptionsanddiagnosticsmenu,77fortroubleshootingiASconfiguration,76–77Apache.
SeealsoOracleApplicationServerApacheavailability,monitoringandtroubleshooting,75Apacheconfigurationfiles,functionof,22–23Apachelogfiles,monitoringforpotentialerrormessages,74–75Apachemonitoring,tokeepyourWebNoderunningefficiently,51ApacheServermonitoringandtroubleshooting,74–78obtainingversionandrolluppatchinformation,171scriptforschedulingtheApacheServerbounce,196stepsforenablingadditionallogging,74stoppingandrestarting,196Apachetuning,116–117APPL_TOPdirectorycontentsof,7–8specifyingtypefornodecontextfileconfiguration,17–18INDEX220applicationconfigurationfiles,addingcustomizationsto,20–22applicationcontextfileadditionalmiscellaneousparametersin,48–49coverageof,11editing,13–15locatingandcreating,13modifying,13–15applicationenvironmentfilesbasicconfigurationparametersforConcurrentProcessingNodefoundin,27–28usedfordefiningenvironmentvariables,29–30applicationexecutablesrelinking,163–165usingadadmintorelink,165applicationfiles,identifyingversionsof,169–170applicationinstanceclones,usedfordevelopmentandtestingpurposes,198ApplicationModule(AM)PoolMonitor,monitoringtheJVMconnectionpoolwith,78applicationpasswordverification,foraddingsecuritytoapplicationuserpasswords,46–47ApplicationTier,performancetuning,113–119ApplicationTierFilesystem,recommendationtoinvestigateimplementingformultiple-nodeinstallation,7–8applicationuserchangingpasswordfor,161defined,160applicationXMLfile.
SeeapplicationcontextfileApplicationsPackforEnterpriseManager10g,ConcurrentManagerreportsavailablewith,84AppliedPatchesfunctionality,searchesallowedby,139appsweb_$CONTEXT_NAME.
cfgfile,tableofkeyparametersin,25–26apps.
zipfile,retrievingversioninformationforaJavaclassfrom,175[ARGS]parameteroptions,forojspCompile.
pl,168AS.
SeeOracleApplicationServerASH.
SeeActiveSessionHistory(ASH)ASHDUMPevent,fordownloadingtheASHbuffercontentstoatracefile,105autoload.
classesparameter,disablinginthezone.
propertiesfile,118AutomaticDatabaseDiagnosticMonitoring(ADDM)processforcollectingsystemperformancedata,99foridentifyingissuesrelatedtodataaccessbysessions,104–105tableofcommonviews,108usingwithOracle10g,107–108AutomaticWorkloadRepository(AWR)providedwithOracle10gforidentifyingdatabaseperformanceissues,99tableofcommonviews,105usingwithOracle10g,105–106AutoPatchlog,choosingafilenamefor,144AWRsnapshots,codeforgeneratingeachsnapshotbeforerunningSAAmanually,125awrrpt.
sqlscript,runningtogenerateaperformancereport,106INDEX221Finditfasterathttp://superindex.
apress.
com/Bbde_chk_cbo.
sqlscript,MetaLinkNoteregarding,40bde_rebuild.
sqlscript,forrebuildingindexes,195–196blockingsessions,identifying,68books,recommendedforApplicationsDBAs,214–216bugcodes,tableofforServiceRequests,210–211bug_numbertable,queryingtoseeifaspecificpatchhasbeenapplied,138Burleson,Donald,UnixforOracleDBAsPocketReferenceby,215Cc(copy)patchdriver,functionof,142cancelqueryfeature,tableofenvironmentvariablesusedtotune,115certificationmatrix,forinformationaboutproductavailabilityandcertification,203–204chmodcommandforchangingthepermissionsofaUNIXfile,179tableofparametersfor,179–180chowncommandtableofparametersfor,178usingtochangeownershipofaUNIXfile,178–179CLASSPATHandAF_CLASSPATH,JARfilesthatmustbeincludedinboth,174–175CLASSPATHvariable,codeexampleofthevalueof,30ClientascomponentoftheE-BusinessSuite,1–4functionof,3ClientSystemAnalyzertool,usertuningwith,120clonewizards,availableforcloning,198cloningexampleofaportionoftheCloneStatusscreen,198wizardsavailablefor,198cloningcleanup,MetaLinkNotedescribingtheprocess,199codeexampleforaccessingtheAOL/JTest,76foraddingadatafiletothetablespace,70foraddingentriestoorremovingentriesfromthecrontab,188foraddingtheOpatchdirectorytothePATH,155foralertingApplicationsDBAofhighactivesessions,63foralertingyoutoprofilechangeswithinaspecifiedthreshold,91foralteringadatafiletoautomaticallyextendthetablespace,70foralteringadatafiletoextendthetablespacetoagivensize,70forapplyingthedatabaseinterimpatchfixafteropatchissetup,155associatingtheSQLworkloadwiththetuningtaskandexecutingthetuningtask,126ofbasicsyntaxofchmodcommand,179basicsyntaxofchowncommand,178forcallingadautocfg.
shfromtheapplicationtier,19forchangingpermissionsofaUNIXfile,180–181forchangingtheAPPLSYSandAPPSpassword,162INDEX222forcheckingfreespaceavailableforeachobject'snextevent,69–70forcheckingserveravailability,84–85ofcompilingalldeltaJSPpages,168ofcompilingallJSPsthatstartwiththestringjtf,168forconvertingtheOracle9idatabasetoanspfile,35forcreatingabaselinefromsnapshot_id1andsnapshot_id2,106forcreatinganaliasforFNDFS_nodename,29forcreatinganSQLworkloadtoholdtheSTS,126forcreatinganSTSbeforerunningSAAmanually,125forcreatingascriptoftherecommendationsfromSAA,126forcreatingatuningtaskfortheSAA,126fordeterminingwhenanobjectwaslastanalyzed,192fordisablingtheautoload.
classesparameterinzone.
propertiesfile,118forenablingadditionalApachelogging,74forenablinganoptionwithadpatch,143ofexcerptforservicingconnectionrequests,41ofexcerptfromthelistener.
orafilefortheVISinstance,29excerptfromtnsnames.
orafileforconnectingtotheVISservicename,41executingasortcommandalongwiththeUNIXducommand,183forexecutingtheADConfigurationutility,19ofexecutingtheAWRperformancereport,106forexecutingtherecompile_invalids.
shscript,192–193forexecutingthescriptforrotatinglogfiles,194executingtkprofastheinstanceownerwithwritepermissions,123offorcecompilingallJSPpageswithparallelexecutionof10,168toforcerelinkallADexecutables,164toforcerelinktheadadminandadpatchmodules,164toforcerelinktheadadminmodule,164forgatheringstatisticsforallobjectsintheGLschema,190forgeneratingaStatspackreport,102forgeneratingAWRsnapshotsbeforerunningSAAmanually,125foridentifyingblockingsessions,68foridentifyinghighCPUconsumingsessions,64foridentifyingnumberofsessionsinanactivestate,62forincreasingtheJVMheapsizeparameterinjserve.
propertiesfile,118forincreasingthemaximumnumberofextentsallowed,73forlimitingthequeriesloadedintotheSTS,125tolistalltheprintjobsforaspecificUNIXprintqueue,186forlistingthecrontabentriesforauser,188INDEX223Finditfasterathttp://superindex.
apress.
com/forlookingupthemanpagesfordf,177formodifyinginitializationparameterswhenusinganspfile,35formonitoringCPUusing,85–86formonitoringdatabaseavailability,59–60,59–60formonitoringdatafilesneartheirmaximumnumberofextents,71–72formonitoringforApacheavailability,75formonitoringforFormsdumpfiles,80formonitoringlongrunningsessions,66–67formonitoringobjectsclosetotheirmaximumnumberofextents,72–73formonitoringpendingconcurrentrequests,81–82ofamonitoringscriptusingtemplateone,53ofamonitoringscriptusingtemplatethree,54ofamonitoringscriptusingtemplatetwo,54formonitoringserverfilesystemusage,86–87formonitoringservermemoryutilization,86formonitoringsessionsidleforauser-determinedamountoftime,61–62forobtainingadefaultsnapshotofthedatabase,100forobtainingdatabasecomponentinstallationsandversions,176forobtainingthedatabasesessionID,82–83forobtainingversionandrolluppatchinformation,171forobtainingversioninformationfromtheFormsNode,171–172ofparametersettingstoreduceJServlogging,117passwordfunctionthatcheckspasswordsforaspecialcharacter,47–48forqueryingbug_numbertableforappliedpatches,138ofrecursivelychangingownershipofaUNIXfile,179toremoveaspecificprintjobfromaUNIXprintqueue,187forremovingaspecificprintjobfromaprintqueue,187ofreportgeneratedafterSTAtaskhasbeenexecuted,124–125forretrievingalistingofApacheprocessesontheserverfortheVISinstance,116forretrievingalistingofFormsprocessesontheserverforVISinstance,113forretrievingOA.
jspversioninformation,173forretrievingthesidandpidforaparticularcondition,187forreviewingactiveconcurrentrequests,81forrunningADMergeutilityagainstunbundledpatches,147forrunningtheDataInstallJavautility,146ofschedulingtherecompile_invalids.
shscripttoexecutedaily,193ofscriptforgeneratingtheapplicationcontextfile,13ofscriptformonitoringforerrorswrittentothealertlog,57scriptforrotatinglogfiles,193–194scriptforschedulingtheApacheServerbounce,196INDEX224ofscriptthatcanbeusedtogatherstatistics,190–191scripttoassistwithrecompilinginvalidobjectsinyourdatabase,192–193tosearchthepatchingreportforaspecificpatchorbug,137toseeanyavailableADPatchoptions,143forsettingcachingdirectivesontheApacheserver,116–117forsettingthemaximumnumberofextentstounlimited,73showingoutputofpatchsets.
shfromMetaLinkNote139684.
1,138showingsettingsofthevaluesin$APPL_TOP/.
envenvironmentfile,115showingthresholdsforsnapshotstakenonOracleApplications(OA),101forspecifyingthelibrarypathofPerlwiththePERL5LIBenvironmentvariable,155forstartingApacheServer,RPCListener,ConcurrentManager,andFormsServer,160startingapatchingsessionbyexecutingadpatchwithoptions,144startingtheFormsServerastheVISinstanceowner,160syntaxforidentandadidentcommands,169syntaxforthef60gencommand,165syntaxforthefnd_stats.
verify_statsprocedure,192syntaxforthemancommand,177syntaxforthestringscommand,169–170syntaxfortheUNIXkillcommand,181syntaxforusingtheUNIXfindcommand,182syntaxoftheadrelink.
shcommand,163syntaxofusingtheJSPprecompiler,167tarsyntaxforcopyingatargetdirectoryanditscontents,184tarsyntaxusedtocompressadirectoryanditscontents,184tarsyntaxusedtoextractatarfile,184templateforbuildingascriptofmanualstepsforpatchingprocess,145fortestingdatabaselisteneravailability,60fortestingifaportisbeingused,17fortestingtheJavaServletconfiguration,78usedtomonitortotalnumberofsessionsinthedatabase,65–66using-parametertogetquickhelp,178usingatexteditortomodifytheapplicationcontextfile,15forusingcustomizationsbyeditingtheadovars.
envconfigurationfile,21usingf60genutilitytogeneratetheGLXIRUN.
fmbform,166usingFNDCPASSutilitytochangeaOracleuser'spassword,162usingFNDCPASSutilitytochangeapplicationuser'spassword,161usingipcscommand,185–186usingipcscommandforremovingamemorysegmentorsemaphore,186usingipcscommandforremovingaspecificsemaphore,186usingtheeditcontextutility,14INDEX225Finditfasterathttp://superindex.
apress.
com/usingthehelpfeatureifmanualpagesarenotinstalled,177usingthesidandserial#tokillthedatabasesession,187usingUNIXdfcommand,182forvalidatingthatopatchisfunctioningproperly,155forvalidatingtheTCFconfiguration,33ofthevalueoftheCLASSPATHvariable,30coe_stats.
sqlscript,toassistwithautomatingthegatheringofstatistics,191Collaborateconference,forOracleApplicationsDBAs,213CollaborativeSupport,requesting,211–212[COMMAND]parameteroptions,forojspCompile.
pl,168COMMON_TOPdirectory,contentsof,7–8communityresources,findingusingYahooorGooglesearchengines,214–215componentstartup/shutdownscriptstableof,159using,160componentversions,determining,168–176computingstatistics,forallrowsinatable,191ConcurrentManagermonitoring,80–84monitoringconcurrentrequestlogandoutputfiles,81monitoringtohandleissueswithscheduledrequests,52reasonsforperformanceproblems,119schedulingofrequestsby,3tuning,118–119ConcurrentProcessingNodebasicconfiguration,27–28ascomponentofE-BusinessSuite,1,2–3configurationof,12,27–29functionof,3locationofbasicconfigurationfilesfor,27–28ConcurrentProcessor,ascomponentoftheE-BusinessSuite,1concurrentrequesthistory,importanceofpurgingonaregularbasis,119concurrentrequestscancelingactive,82–83gatheringstatisticswith,192monitoringpending,81–82monitoringruntimes,83–84purging,196–197reviewingactive,81conferences,asexcellentinformationsourceforOracleApplicationsDBAs,213configurationbestpractices,50coverageofadditionaltopicabout,12forOracleApplications,11–50configurationfiles.
SeealsoApacheconfigurationfiles;applicationconfigurationfiles;wdbsvr.
appconfigurationfileaddingcustomizationsto,20–22addingcustomizationtagsto,21locationofprimaryforwebconfiguration,22restoringfromthebackupofanadconfig.
shrun,20configurationwizards,usingfromOracleApplications(OA)Manager(OAM),44ConsolidatedUpdatepatches,using,133INDEX226$CONTEXT_NAME.
envfile,tableofkeyparametersin,26,28Cost-BasedOracleFundamentals,byJonathanLewis,215CPUstates,asdisplayedbyUNIXtopcommand,108CPUusage,monitoring,85–86CPUutilization,executingsar-utocapture,110crontabtableoflayoutofentriesin,188usingtoschedulesnapshotsonaregularbasis,102usingtoscheduleUNIXjobs,188crontab-ecommand,foropeningthecrontabforediting,188customdatabaseobjects,creating,43CustomerRelationManagement(CRM)products.
SeealsoJTFFulfillmentServersetupoftheJTFFulfillmentServerby,33CustomerSupportIdentifier(CSI),allowingOracleSupporttotrackcustomer'ssupportandlicensinginformation,206customizationtags,preservationofwhenusingtheADConfigurationutility,21Dd(database)patchdriver,functionof,142data,purgingandarchiving,197databasealertlogfileimportanceofmonitoringbydatabaseadministrator,57–58scriptformonitoringforerrorswrittento,57databaseavailability,checking,59–60databaseconnection(DBC)fileadministering,30–31directorylocationof,30tableofkeyparametersin,31databaseinitializationfiledefaultdirectorylocation,34fordefiningconfigurationsettings,34–39databaseinitializationparametersreviewing,39–40tableofforOracle10gforOracleApplications(OA)11.
5.
10,39tableofforOracle9iforOracleApplications(OA)11.
5.
10,38tableofforOracleApplications(OA)11iforOracle9iandOracle10g,35–37databaselistenerconfiguring,41scriptfortestingavailabilityof,60databaselistenerlogreviewingforreasondatabaselistenerisunavailable,60reviewingiferrorsareexperiencedwiththedatabaselistener,58–59databaselogfiles,reviewingwhenmonitoringthedatabase,57–59databasemonitoring,tokeepthesystemrunningproperly,51databasemonitoringandtroubleshooting,monitoringcategoriesthatrequireattention,57–73databasenetworkconfigurationtoestablishremoteconnectionstothedatabaseinstance,40–42validating,42DatabaseNodeascomponentofE-BusinessSuite,1,2,4configurationof,12,34–43functionof,4INDEX227Finditfasterathttp://superindex.
apress.
com/databaseobjects,creatingcustom,43databasepasswordverification,fordefiningadditionalpasswordsecurity,47–48databasepatching,manuallyorusingthedbmigutility,154–156databasesessions,stepsforremoving,187databasetuning,toolsfor,99–108databaseversionquery,forobtainingversionofthedatabase,176–177datafileextents,identifyinglimitations,71–72DataInstallJavautilitylegislativedatasubmenu,147mainmenufor,146runningtoselectneededlegislationsforinstall,146DBCfile.
Seedatabaseconnection(DBC)fileDBCfilesettings,usingtheAOL/JSetupTestspagetoverify,76dbmig(databasemigration)utility,usingfordatabasepatching,155DBMS_ADVISORpackage,performingdatabaseanalysisandbuildingreportsmanuallywith,107–108dbms_jobs,usingtoschedulesnapshotsonaregularbasis,102DefineUserfunctionality,resettinganapplicationuser'spasswordwith,161Deshpande,Kirtikumar,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216dfcommand,usingtoobtainfilesystemspaceinformation,182DiscovererServer,tableofkeycontextfileparametersfor,33distributedAPPL_TOPofE-BusinessSuitearchitecture,1MetaLinkNotefordetailsforimplementing,8DomainNameSystem(DNS),usingpingcommandtofindaproblemwith,88–89ducommand,usingtoobtainfilesystemspaceinformation,183dumpdestinationparameters,settingupacommonfilesystemforlogfiles,37EE-BusinessSuiteadditionalcommandsandusagetips,177–187additionalconfigurationtopics,44–50creatingcustomdatabaseobjectsin,43MetaLinkNoteforinformationaboutadvanceconfiguration,7MetaLinkNoteforsettingsfordatabaseinitializationparametersfor,35methodforcancelingaFormsquery,114monitoringandtroubleshooting,51–94needforunderstandingofOracleApplicationsconfigurationforadministering,11patchingcategories,131performancetuningformanyofthecomponentsof,95–129predefinedConcurrentManagercalledtheStandardManager,119INDEX228primarycomponentsthatcomprise,1recommendedpatchesoptioninMetaLink,205E-BusinessSuitearchitecturebestpractices,9othercomponentsin,1E-BusinessSuiteRelease11iInfoCenter,forinformationaboutlatestreleasesanddocumentation,203editcontextutility,formodifyingtheapplicationcontextfile,13–14EM10gGridControl.
Seealso10gGridControlDiagnosticsPackjobmanagementandschedulingofferedby,189MetaLinkNoteformoreinformationabout,189EnterpriseManager(EM)PreservedSnapshotSetsfeaturein,106usingtoschedulesnapshotsonaregularbasis,102.
envfilenameextension,forenvironmentfiles,29environmentfiles.
Seeapplicationenvironmentfilesestimatingstatistics,forallrowsinatable,191ExpertOracleDatabase10gAdministration,bySamAlapati,215ExpertOracleDatabaseArchitecture:9iand10gProgrammingTechniquesandSolutions,byThomasKyte,215explainplans,tracefilesusefulingenerating,122Ff60gencommand,tableofrequiredparametersfor,166f60genutility,manuallyregeneratingforms,libraries,andmenuswith,165–166FamilyPackpatches,foraparticularfamilygroupofapplicationmodules,132farm,defined,7Feurstein,Steven,OraclePL/SQLProgrammingby,216filepermissions,tableofnumericalvaluesfor,180filesystemusage,monitoringserverfor,86–87findcommand,usingtofindfilesordirectoriesontheserver,182flexfields,recompilingaspartofpost-patchingrequirements,154fnd_statspackage,gatheringstatisticswith,189–191fnd_stats.
verify_statsprocedure,syntaxfor,192FNDCPASSutilitychanginganapplicationuser'spasswordwith,161changingtheAPPLSYSandAPPSpasswordwith,162usingtochangeanOracleuser'spassword,162FNDFSconnectivity,configuring,29FNDFSlistener,configuring,28–29FormsAboutdialogbox,obtainingversioninformationfromaFormsclientsessionfrom,172FormsandPL/SQLversion,obtaininginformationon,171–172INDEX229Finditfasterathttp://superindex.
apress.
com/forms,libraries,andmenusmanuallyregeneratingwithf60genutility,165–166regeneratingtofixissueswith,165–167usingADAdmintoregenerate,166–167Formsloadbalancing,implementing,7FormsMetricClient.
SeeFormsMetricServerandFormsMetricClientFormsMetricloadbalancing,tableofkeycontextfileparametersfor,27FormsMetricServerandFormsMetricClientconfigurationof,26–27MetaLinkNoteforconfiguringinformation,26FormsMetricsServer,asloadbalancerforsendingrequeststomultipleFormsNodes,7Formsmonitoring,lookingathowtoreviewFormssessionsusingOAM,51FormsmonitoringandtroubleshootingusingFormsServerdumpfiles,80usingfunctionalityinOAM,78–80FormsNodebasicconfiguration,25–26ascomponentofE-BusinessSuite,1,2–3configurationof,12,25–27FormsServerdumpfilescreatedon,80functionof,3obtainingversioninformationfrom,171–172Formspatchsetandversions,tableof,172Formsqueries,canceling,114FormsRuntimeProcessesscreen,inOracleApplications(OA)Manager(OAM),79FormsServer,ascomponentoftheE-BusinessSuite,1Formstracefiles,generating,122Formstraffic,MetaLinkNoteforinformationaboutloadbalancing,27Formstuningforresolvingperformanceissues,113–116tableofparametersforsessions,114FulfillmentServer.
SeeJTFFulfillmentServerfundamentalarchitecture,forOracleApplications,4–5Gg(generate)patchdriver,functionof,142GenericServiceManagement(GSM),29configuring,31–32servicescontrolledby,31GeographicUserGroups(GEOs),listofmaintainedinOracleApplicationsUsersGroupWebsite,213Gopalakrishnan,K,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216GSM.
SeeGenericServiceManagement(GSM)guestaccounts,detailsofinDBCfiles,30INDEX230HhighCPUconsumption,resolvingtheissueof,64–65"HowtoMergePatchesUsingadmrgpch",MetaLinkNotefor,148hrglobaldriver,foraclassofpatchesthatcontainlegislativedata,146httpd.
conffile,tableofkeyparametersettingsin,23IiAS.
SeealsoOracleApplicationServer,functionof,3iASconfiguration,troubleshooting,76–77ICMSleepTimesetting,MetaLinkNoteaboutaltering,119identcommand,identifyingtheversionofapplicationfileswith,169identity.
objfile,administering,30IndependentOracleUsersGroup,dedicatedtotechnicalusersofOracleDatabase,213indexes,rebuildingaspartofpreventativemaintenance,195initializationparameters,codeformodifyingwhenusinganspfile,35interoperabilitypatch,applyingwhenupgradingdatabasetoversion10g,133invalidobjects,recompiling,192–193ipcscommandusingtoshowallmemorysegments,messagequeues,andsemaphores,185usingwithgreptolimitthedisplayofthecommand,185iProcurementdebugging,creatingalogfilefor,74–75JJavaclass,usingthestringcommandtoobtainfileversionsfor,175Javaclassfileversionsobtainingfromtheapps.
zipfileortheclassfile,175usingthestringcommandtoobtain,175JavaconsolealteringdisplaysettingsusingtheJInitiatorControlPanel,93–94JInitiatorversionforOracleApplications(OA)asdisplayedin,171Javaprocessing,configuringadditionalJServstoreducecontentionforresources,7JavaServletconfiguration,testing,78java-versioncommand,usingtoretrievethedefaultJDKversion,174JDeveloper,useofDBCfileforconnectivitytothedatabaseby,30JDKversion,retrievingusingseveralcommandsfromtheUNIXprompt,174JInitiatorclearingtheJARcache,93determiningwhichversiontheapplicationisconfiguredtouse,170–171resolvingissueswith,92–94JInitiatorControlPanelalteringJavaconsoledisplaysettingsin,93–94clearingtheJARcachein,93JServconfigurationfiles.
Seealsoapplicationconfigurationfilesdirectoryfor,23JServlogfiles,monitoringforpotentialerrormessages,74–75INDEX231Finditfasterathttp://superindex.
apress.
com/JServtuning,parametersettingtoreducelogging,117–118jserv.
conffile,tableofkeyparametersin,24jserve.
propertiesfile,increasingtheJVMheapsizeparameterin,118jserv.
propertiesfilemodifyingthelevelofdebugmessagingin,74tableofkeyparametersin,24–25JSPpages,recompiling,167–168JSPprecompilerMetaLinkNoteoutliningprerequisitesandrequirementsforusing,167syntaxofusing,167JTFFulfillmentServer,tableofkeycontextfileparametersfor,34JVMconnectionpool,monitoring,78JVMheapsizeparameter,increasinginthejserve.
propertiesfile,118Kkillcommand,forterminatingaprocessontheserver,181KnowledgeBase,searchfeatureinMetaLink,202Kyte,Thomas,ExpertOracleDatabaseArchitecture:9iand10gProgrammingTechniquesandSolutionsby,216LlegislativepatchesapplyingforHRPayrollcustomers,146forHRPayrollcustomers,133Lewis,Jonathan,Cost-BasedOracleFundamentalsby,215listener.
orafilecodeexcerptfromforservicingconnectionrequests,41parametersthatcontroltracinglevelsin,58–59loadbalancing,ofvariousnodesoftheE-BusinessSuite,6–7loadbalancingnodes,ofE-BusinessSuitearchitecture,1logfilesrotating,193–195scriptforrotating,193–194tableoflocationsanddescriptionsofcommon,195longidlesessions,identifying,60–62lprmcommand,tableofparametersfor,187lpstatandlprmcommands,forcancelingprintjobsonaUNIXserver,186–187lsnrctldatabaseutility,forstartingandstoppingthedatabaselistener,41MMaintenanceMode,enabling,142MaintenancePackpatches,thatserveaspoint-levelreleaseupgrade,132ManageabilityMonitor(MMON),newbackgroundprocessinOracle10g,105–106manual(man)pages,fordetaileddescriptionsofUNIXcommands,177–178memory,asdisplayedbyUNIXtopcommand,109memorysegmentsandsemaphores,findingandremovingonaUNIXserver,184–185INDEX232MetaLinkadvancedsearchesin,201–203advancedsearchoptionsin,205downloadingtheopatchutilityfrom,155E-BusinessSuiteinformationportalonhomepage,203KnowledgeBasesearchfeaturein,202locatinganddownloadingpatchesfrom,204–205patchsearchoptionsin,204–205searchtechniques,201–205usingtheMyConfigsandProjectsfeatureof,206MetaLinkNoteforadditionaldetailsregardingAOL/JTest,76foradditionaldetailsregardingOATM,42foradphrept.
sqldetailsanddescriptionofallparameters,136toassistwithusingtheRapidCloneutility,198forbasicinformationabouttheADPatchutility,142forconfiguringFormsMetricServerandFormsMetricClient,26–27containinglatestversionofbde_rebuild.
sqlscriptandexecutiondetails,195describingsharingtheapplication-tierfilesystem,148–149fordetailsaboutimplementingOracleWebCache,9fordetailsforeffectivelyworkingwithOracleSupport,209detailsforimplementingasharedAPPL_TOPorApplicationTierFilesystem,8fordetailsforimplementingdistributedAPPL_TOP,8forfindinglatestcopyofthehrglobalpatch,146for"HowtoMergePatchesUsingadmrgpch",148forinformationaboutadvanceconfigurationofE-BusinessSuite,7forinformationaboutenablingADConfiguration,11forinformationaboutimplementingOracleRACwith11i,7forinformationaboutlatestversionofpatchsets.
sh,137forinformationaboutloadbalancingFormstraffic,27forinformationonusingDiscovererwithOracleApplications(OA),33forinformationregardingFormspatchsetversions,172forinformationregardingMyConfigsandProjects,206forinformationregardingParallelConcurrentProcessing,7forlatestversionofcoe_stats.
sqlscriptandinformationaboutit,191formoreinformationaboutEM10gGridControl,189referencingforthetrcanlzrutility,124regardingthebde_chk_cbo.
sqlscript,40forrequirementsforcancelingFormsqueries,114forsettingsfordatabaseinitializationparametersforE-BusinessSuite,35tableincludedinthatcalculatesportvalues,15thatdescribes11iStatspackspecificsindetail,100INDEX233Finditfasterathttp://superindex.
apress.
com/MetaLinkwebsite,asmaininterfacetoOracleSupport,201MetaLink'sCertifypage,certificationandavailabilityoptionsin,204Minipackpatches,foraparticularmodule,132MMNLbackgroundprocess,responsibleforwritingsessiondatatomemory,104monitoring.
SeealsomonitoringandtroubleshootingConcurrentManager,80–84CPUusage,85–86methodsfor,52–56serveravailability,85serverfilesystemusage,86–87servermemoryutilization,86systembackups,92tableofparameterdescriptionsformonitoringscriptsinChapter3,55–56monitoringandtroubleshootingadditionaltopics,90–94Apacheserver,74–78bestpractices,94networkissues,87–90OracleE-BusinessSuite,51–94toresolveJInitiatorissues,92–94serveravailability,CPUusage,andfilesystemusage,84–87monitoringtools,scriptsusedwith,53–54multi-nodeenvironments,performingpatchingfor,148–149multi-nodepatching,performing,148–149multi-tierconfigurations,forOracleApplications,5–9MyConfigsandProjectsfeature,ofMetaLink,206Nnetworkissues,monitoringandtroubleshooting,87–90networkmonitoring,usingpingandtracertcommandsplususeofNetworkTest,52networkmonitoringandtroubleshooting,usingpingandtracertcommands,87–89networktest,performingfromtheapplication,90NetworkTraceForm,forperforminganetworktestfromtheapplication,90NLSpatchesapplyingforE-BusinessSuiteinstallationswithmulti-languagerequirements,148toupdatelanguage-specificinformationformulti-lingualinstallations,133node-identifyingcontextparameters,forOracleApplications(OA),17–18nodes.
SeealsoAdminNode;ConcurrentProcessingNode;DatabaseNode;FormsNode;WebNodeidentifyingwithcontextparameters,17–18whattheyarecomprisedof,2OOAFrameworkversion,andOA.
jspversiontable,173OA.
jspversionandOAFrameworkversiontable,173OAM.
SeeOracleApplicationsManager(OAM)OAMMinipackversionH,accessingForms-monitoringfeatures,79INDEX234OATM.
SeeOracleApplicationsTablespaceModel(OATM)OATMtablespaces,tableofstandard,43OAUGInsight,anOAUGpublicationprovidedtoOAUGmembers,216OJSPversion,obtainingbysettingupatestJSPfile,173ojspCompile.
pl[ARGS]parameteroptionsfor,168[COMMAND]parameteroptionsfor,168one-offpatches,toresolveaspecificbug,132onlineresources,availabletoApplicationsDBAs,214–2153opatchutility,usingforinterimpatchfixesforthedatabase,155Oracle10gusingActiveSessionHistorywith,104–105usingAutomaticDatabaseDiagnosticMonitoringwith,107–108OracleApplications(OA)buildingatoolkittomanage,157–198cautionregardinginfrastructureupgrades,9componentstartupandshutdownscripts,158–160componentsandarchitectureof,1–9configuringpasswordsecurityfor,46–48methodsformonitoring,51node-identifyingcontextparameters,17–18obtainingFrameworkversioninformationfor,173performancetuning,95–129sharedAPPL_TOPandCOMMON_TOPdirectoryoneachnode,7–8tableofcomponentstartupandshutdownscriptfiles,159tableofprofileoptionsavailableforapplicationpasswordsecurity,46–47utilitiesandcommands,158–168OracleApplications(OA)architecturebestpractices,9ofE-BusinessSuite,1exampleofadvancedmulti-tier,6exampleoftwo-tier,5overviewof,4–9OracleApplications(OA)componentsforservicinguserrequests,2–4OracleApplications(OA)configuration.
Seealsoconfigurationimportanceofhavingathoroughunderstandingof,11OracleApplications(OA)FrameworkJDBCconnectionpoolparameterssetinDBCfile,31obtainingversioninformationfor,173URLfordeterminingversioninformation,173OracleApplicationsManager(OAM)additionalsearchcriteriaofferedby,140exampleoftheSimpleSearchscreenforpatchesin,139findinginformationaboutarunningconcurrentrequestwith,83findingrunningconcurrentrequestwith,81FormsRuntimeProcessesscreenin,79interfacetotheOracleLicenseManager,45–46INDEX235Finditfasterathttp://superindex.
apress.
com/licensingadditionalproductsin,45–46monitoringconcurrentrequestruntimeswith,84patchsearchin,139–140reviewingactiveconcurrentrequeststhrough,81–82usingforFormsmonitoringandtroubleshooting,78–79usingtheconfigurationwizardsfrom,44usingtoaddcustomizations,21–22usingtoquerytheinstanceforappliedpatches,138viewinglicensedproductsin,45OracleApplications(OA)patchingfunctionof,131stepsinvolvedin,132typesofpatches,132–133OracleApplicationsTablespaceModel(OATM)functionof,42–43MetaLinkNoteforadditionaldetailsabout,42tableofstandardtablespacesusedwith,43OracleApplicationsandDatabases,twomajorusergroupsfor,212–213OracleApplicationServer,WebServerforOracleApplications,3OracleApplicationsManager(OAM)accessingtheAOL/JTesttoolwith,76–77configurationof,12functionalitybuiltintotoassistwithcloning,198usingtoedittheapplicationcontextfile,14OracleApplicationsTablespaceModel(OATM),34OracleApplicationsUsersGroup(OAUG),usingasasourceofinformationandassistance,212–213OracleCollaborativeSupport,requesting,210–211OracleDatabase,ascomponentoftheE-BusinessSuite,1OracleDatabase10g(Oracle10g),spfilemandatorywith,34Oracledatabasesystems,schedulingandmonitoringtoolsformanaging,189OracleE-BusinessSuite.
SeeE-BusinessSuitefund_statspackageforgeneratingstatisticsfor,190–191"OracleE-BusinessSuiteRecommendedPerformancePatches",MetaLinkNoteforrecommendedpatches,128–129OracleFormsServer,allFormsapplicationprocessinghandledby,25–26OracleHTTPServer(OHS).
SeeOracleApplicationServerOracleJInitiatorplug-in,requiredtorunOracleFormsasJavaappletsontheClient,3OracleLicenseManager,OracleApplications(OA)Manager(OAM)interfaceto,45–46OracleMagazine,recommendedforApplicationsDBAs,216OracleOpenWorld(OOW)conference,214OraclePL/SQLProgramming,byStevenFeurstein,216OracleRAC,MetaLinkNoteforinformationaboutimplementingwith11i,7INDEX236OracleRealApplicationClusters(RAC),implementingforamultiple-nodeimplementationforadatabase,7OracleSupportinteractingwithtomanagetheE-BusinessSuite,201–212MetaLinkNotefordetailsforeffectivelyworkingwith,209numberforphoning,212openinganSRforhelpifMetaLinkdoesn'tprovidesolutions,74OracleSupportandDevelopment,gettingassistancefromtofixunderlyingcode,96OracleSupportServiceRequests(SRs).
SeeServiceRequests(SRs)OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuning,byRichmondShee,KirtikumarDeshpande,andK.
Gopalakrishnan,216OracleWebCache,MetaLinkNotefordetailsaboutimplementing,9OracleWebsite,maincorporate,214Oracle10ganalyzingSQLStatementin,124–126databaseinitializationparametersforOracleApplications(OA)11.
5.
10,39usingAutomaticWorkloadRepository(AWR)with,105–106Oracle9i,databaseinitializationparametersforOracleApplications(OA)11.
5.
10,38oraInst.
locfile,managing,49oratabfile,managing,49–50OTNWebsite,membershipinformationandaddressfor,214PParallelConcurrentProcessingimplementing,119MetaLinkNoteforinformationabout,7ParallelConcurrentProcessingforGSM,usingforsystemswithamultiple-nodeconfiguration,32passwordsecurityapplicationpasswordverification,46–47configuring,46–48tableofprofileoptionsavailablefor,46–47passwordschanginganOracleuser's,162changingApplication,Oracle,andtheAPPLSYS/APPS,160–163changingapplicationuser's,161encryptingtheAPPSpasswordinthewdbsvr.
appfile,163patchadvisor,140patchanalysis,schedulingoptionsfor,140patchdriverfiles,namingconventionfor,142patchdriversidentifying,142requirementswhenapplyinginamulti-nodeenvironment,149patchreporting,methodsfordeterminingpatchinglevels,136–140PatchWizardTasksmenu,forperformingpatchanalysisagainstyourinstance,140patchesapplying,141–149locatinganddownloading,204–205queryingthedatabasefor,138stepsforapplying,141INDEX237Finditfasterathttp://superindex.
apress.
com/unbundlingusinganunziputility,141usingaseparatefilesystemforstoringandunbundling,141usingOAMtoquerytheinstanceforapplied,138patchingadditionaltipsforresolvingissueswith,152applyinginteroperabilitypatchwhenupgradingdatabasetoversion10g,133bestpractices,156cleanupafterapatchhascompleted,154E-BusinessSuite,131–156importanceofexaminingreadmefileprovidedwiththepatch,133importanceoffullsystembackupbeforeapplyingpatches,134MaintenancePackpatchesthatserveaspoint-levelreleaseupgrade,132Minipackpatchesforaparticularmodule,132monitoringandresolvingissueswith,132monitoringandresolvingproblems,149–154one-offpatchestoresolveaspecificbug,132OracleApplications(OA),132–154patchesforaparticularfamilygroupofapplicationmodules,132post-patchingstepsandcleaningup,132,152–154preparingfor,132,133–140reclaimingusedspacebyremovingunnecessarybackupfiles,154rolluppatchestoupdatecodelevelsforparticularproducts,133specialtypesofpatches,133stepsinvolvedinapplyingpatches,132toupdatelanguage-specificinformationformulti-lingualinstallations,133usingConsolidatedUpdatepatches,133usinglegislativepatchforHRPayrollcustomers,133patchingproblemsmonitoringandresolving,149–154reviewinglogfilesfor,149–150patchingprocessdocumentingtosavetimeandreduceerrors,134–135exampleofsampledocumentationspreadsheet,135performingmanualsteps,145specialconsiderations,146patchsets.
sh,patch-comparisonutilityforreviewingpatchsetlevels,137–139performanceissuescommon,128reviewingtopwaiteventstoresolve,103–104performancetuning.
Seealsotuningadditionalprofileoptionstoconsiderfor,127bestpractices,128–129,128–129formanycomponentsofE-BusinessSuite,95–129questionstofacilitateresolutionofproblem,96–98theserver,108–113performancetuningprocessforidentifyinganddocumentingcauseofperformancedegradation,95–98identifyingperformanceissues,96–98INDEX238performancetuningtools,forresolvingperformanceissues,95–128periodicals,recommendedforApplicationsDBAs,216pingandtracertcommands,usingfornetworkmonitoringandtroubleshooting,87–89pipecharacter(|),usingtoallowmultipleUNIXcommandstoberuntogether,178portnumberingconventioncreatingtosimplifyinstancemanagement,15–17examplefortwotestinstances,16portvalues,tableincludedinMetaLinkNotethatcalculates,15PreservedSnapshotSetsfeature,inEnterpriseManager(EM),106preventativemaintenancegatheringstatistics,190–192tomaintaintheoverallhealthoftheOracleE-BusinessSuite,189–197printjobs,findingandremovingonaUNIXserver,186–187processidentification(pid)file,creatinginhttpd.
conffile,22profilechanges,monitoring,91–92Profit(OracleApplicationspublication),recommendedforApplicationsDBAs,216pscommandfordeterminingiftheoperatingsystemprocesshasterminated,187usingtodisplayactiveprocesses,112Qqcommand,forexitingtop,109R-rcommand,usingwithSystemActivityReporter(sar),110–111RAC.
SeeOracleRACRapidCloneutility,asOracle'srecommendedmethodforcloning,198readmefile,exampleofcontentsofforpatches,133–134recompile_invalids.
shscript,executing,192–193recompiling,invalidobjects,192–193relinking,applicationexecutables,163–165remotedatabaseconnections,configuring,41ReportReviewAgent(FNDFS),configuring,28–29resources,availabletoApplicationsDBAs,201–215rolluppatch,toupdatecodelevelsforparticularproducts,133SSAA(SQLAccessAdvisor)toolcodeforcreatingascriptofrecommendationsfrom,126creatingatuningtaskfor,126stepsforrunningmanually,125–126fortuningmultiplequeries,125–126sandboxinstance,usingtoapplypatches,141sar.
SeeSystemActivityReport(sar)sar-rcommandexecutingtodisplayserverdata,111tableofstatisticsdisplayedby,110sar-ucommandexecutingtocaptureCPUutilization,110tableofcolumnsanddescriptionsfor,110INDEX239Finditfasterathttp://superindex.
apress.
com/schedulingandmonitoringtools,formanagingOracledatabasesystems,189schedulingmanager.
SeeConcurrentManagerscriptscreatingtoautomatethepatchingprocessmanualcommands,145scheduling,188SecureSocketsLayer(SSL)encryption,forencryptingtransactionanddataoveranetwork,8–9Select,anIOUGpublicationprovidedtoIOUGmembers,216SelfServiceTracing,implementationof,122semaphoresandmemorysegments,findingandremovingonaUNIXserver,184–185serveravailabilitymonitoringandtroubleshooting,84–85providinghighwithamulti-serverenvironment,85serverfilesystemusage,monitoring,86–87servermemoryutilization,monitoring,86servermonitoring,forserveravailability,CPUusage,andfilesystemfreespace,52serverperformancedata,analyzing,113serverstatistics,displayedbyvmstatcommand,112servicecomponentsconfigurationof,12thatmeritspecialconfigurationconsideration,32–34ServiceRequests(SRs)assigningofseveritylevelto,207closing,212creatingnew,207escalating,209gatheringdetailsfor,206managing,207–212requestingsoftcloseof,209searching,208statusorbugcodes,209–211updating,208–209ServletAgentsetting,usingtheAOL/JSetupTestspagetodisplayandtest,76sessionID(sid),queryforreturning,82–83sessionmonitoringcommonissuesthatcanbeidentifiedby,60–68identifyingblockingsessions,68identifyinghighactivesessions,62–64identifyinghighCPUconsumingsessions,64–65identifyinglongidlesessions,60–62identifyinglongrunningsessions,66–67oftotalnumberofsessionsinthedatabase,65–66severitylevels(SEVs)forSRs,207SGA.
SeeSystemGlobalArea(SGA)sharedAPPL_TOPorApplicationTierFilesystemofE-BusinessSuitearchitecture,1MetaLinkNotefordetailsforimplementing,8Shee,Richmond,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216snapshotreports,schedulingduringperiodsofnormalactivity,102softclosedSR,defined,209spauto.
sqlscript,willschedulesnapshotstoexecuteeveryhour,102INDEX240SpecialInterestGroups(SIGs),listofmaintainedinOracleApplicationsUsersGroupWebsite,213spfile,mandatorywithOracleDatabase10g(Oracle10g),34spmodfn.
sql,toincludethesourcemodulenameofqueriesinStatspackreportoutput,100SQLAccessAdvisor(SAA)toolstepsforrunningmanually,125–126fortuningmultiplequeries,125–126SQLTuningAdvisor(STA),forautomatingtheSQLtuningprocess,124–125SQLTuningSet(STS)codeforcreatingbeforerunningSAAmanually,125codeforlimitingthequeriesloadedinto,125SQLworkloadassociatingwiththetuningtaskandexecutingthetuningtask,126creatingtoholdtheSTS,126SRbugcodes,tableofforServiceRequests,210–211SRprofiles,creatingandsaving,207SRstatuscodes,tableofforServiceRequests,210SRs(ServiceRequests).
SeeServiceRequests(SRs)SSL.
SeeSecureSocketsLayer(SSL)encryptionStandardManager,aspredefinedConcurrentManagerinE-BusinessSuite,119startup/shutdownscripts,tableof,159statisticsgatheringforallrowsinatable,190–191gatheringwithconcurrentrequests,192proceduresavailableforgatheringwithfnd_stats,190–191reviewingobject-level,192STATISTICS_LEVELinitializationparametersettinginorderforADDMtofunction,107StatspackforOracle9ianalyzingreports,102–104generatingsnapshotreports,100–102foridentifyingdatabaseperformanceissues,99MetaLinkNotethatdescribes11ispecificsindetail,100tableofthresholdsanddescriptions,101StatspackreportsanalyzingOracle9i,102–104sampleof,103statuscodes,tableofforServiceRequests,210storagemonitoringidentifyingdatafileextentlimitations,71–72identifyingmaximumextentlimitations,72–73identifyingtablespacesizinglimitations,69–71toresolvespaceconstraintsbeforeusersencounterfailures,68–73stringscommand,usingtoretrievefileversioninformation,169–170STS(SQLTuningSet)codeforcreatingbeforerunningSAAmanually,125creatingSQLworkloadtohold,126swap,asdisplayedbyUNIXtopcommand,109SystemActivityReport(sar),using,110–111systembackups,monitoring,92INDEX241Finditfasterathttp://superindex.
apress.
com/SystemGlobalArea(SGA),storingactivedatabasesessionsinformationinmemorywithin,104–105Ttablespaces.
SeeOATMtablespaces;OracleApplications(OA)TablespaceModel(OATM)tarcommandfunctionof,183–184tableofparametersfor,184TCFSocket.
SeealsoThinClientFramework(TCF)Socket32–33TechnicalAssistanceRequests(TARs).
SeeServiceRequests(SRs)technologystackcomponentspatching,functionof,131templatefiles,addingcustomizationtagsto,21texteditor,usingtoedittheapplicationcontextfile,15ThinClientFramework(TCF)Socket,tableofparameterinthecontextfilepertainingto,33timed_statisticsdatabaseinitializationparameter,settingtouseStatspack,101tkprof,analyzingtracefileswith,123–124tnsnames.
orafile,excerptfromforconnectingtotheVISservicename,41tnspingcommand,usingtovalidatedatabasenetworkconfiguration,42toolkit,buildingtomanageOracleApplications(OA),157–198topcommandexampleofexecuting,109tableofCPUstatesasdisplayedby,108tableofmemoryasdisplayedby,109tableofswapasdisplayedby,109usingforoverviewofCPUandmemoryutilization,108–109topwaitevents,reviewingtoresolveperformanceissues,103–104TraceAnalyzer(trcanlzr)utility,forreadingarawtraceandgeneratinganHTMLreport,124tracefilesanalyzing,122–124analyzingusingtkprof,123–124generating,122generatingandanalyzingaspartoftheperformancetuningprocess,121–126generatingforaForm,122implementingSelfService,122tracertandpingcommands,usingfornetworkmonitoringandtroubleshooting,87–89translationpatches,applying,148trcanlzr(TraceAnalyzer)utilitydownloading,124forreadingarawtraceandgeneratinganHTMLreport,124troubleshooting.
SeealsomonitoringandtroubleshootingiASconfiguration,76–77tuning.
Seeperformancetuningtuningtask,creatingfortheSAA,126two-tierarchitecture,forOracleApplications,4–5U-ucommand,usingwithSystemActivityReporter(sar),110u(merged)patchdriver,functionof,142unifieddriverpatches,142UNIX,additionalconfigurationfilesofinterest,48INDEX242UNIXbasics,generaltips,177–178UNIXchmodcommand.
SeechmodcommandUNIXchowncommand.
SeechowncommandUNIXdfcommand.
SeedfcommandUNIXducommand.
SeeducommandUNIXfiles,usingchowncommandtochangeownershipof,178–179UNIXfindcommand.
SeefindcommandUnixforOracleDBAsPocketReference,byDonaldBurleson,215UNIXkillcommand.
SeekillcommandUNIXpscommand,usingtodisplayactiveprocesses,112UNIXscripts,referencingofparameterspassedto,54UNIXtarcommand.
SeetarcommandUNIXtopcommand.
Seetopcommanduserrequests,servicing,2–4usertuningmanually,120–121usingtheClientSystemAnalyzertool,120Vv$parameterview,queryingtogetalistingofallcurrentinitializationsettings,39–40vitexteditor,cautionregardinguseoftomodifyapplicationcontextfile,15ViewRunawaysbutton,ontheFormsRuntimeProcessesscreen,79vmstatcommandtableofcategoriesfor,111tableofkeystatistics,111–112usingtodisplayUNIXperformancestatistics,111–112Wwdbsvr.
appconfigurationfilelocationof,23stepsforencryptingtheAPPSpasswordin,163WebAgentsettings,usingtheAOL/JSetupTestspagetodisplayandtest,76webentrypoint,defined,2WebNodeascomponentofE-BusinessSuite,1,2–3configurationof,12,22–25functionof,3WebNodeloadbalancing,requirementsforimplementing,7websearchengines,usingtogetinformationaboutUNIXcommands,178WebServer,ascomponentoftheE-BusinessSuite,1WebsiteaddressforcurrentandarchivedissuesofOracleMagazineandProfitandtosubscribe,216fordownloadingthelatestversionofpatchsets.
sh,137forMetaLinkforOracleSupport,201forOracleApplicationsUsersGroup,212Oracle'smaincorporate,214forOTN,214WindowsTaskManager,accessingandcheckingsystemperformancefrom,121workflowhistory,purging,197INDEX243Finditfasterathttp://superindex.
apress.
com/XXServeraccess,usingtheAOL/JSetupTestspagetotest,76X-emulationsoftware,requiredtoruntheeditcontextutility,13–14Zzone.
propertiesfile,tableofkeyparametersin,25INDEX244
envenvironmentfile,codeshowingsettingsofthevaluesin,11510gGridControlDiagnosticsPack,trendanalysisformetricsthatarecollectedasfeatureof,62AActiveSessionHistory(ASH)usingwithOracle10g,104–105viewinginformationcollectedby,104ADAdministration(adadmin)utilitytheGenerateApplicationsFilessubmenu,153mainmenu,153forperformingmostpost-patchingrequirements,152–154usingtoregenerateforms,libraries,andmenus,166–167usingtorelinkapplicationexecutables,164ADConfiguration.
Seealsoconfigurationforautomatingconfigurationofapplicationanddatabasetiers,11executing,18–19MetalinkNoteforinformationaboutenabling,11preservationofcustomizationtagswhenusingtheutility,21using,18–22ADControlusingnoninteractivelytoexpeditepatchproblemresolution,151usingtomanagepatchworkers,150–151ADControllermenu,exampleof,150ADMergeutility,usingtoapplyagroupoflargepatches,147–148ADPatchutilitydisablinganypasswordconstraintsbeforeexecuting,143usingtoapplyapplicationpatches,142–145ADPatchWorkerfailures,commonerrormessagesandresolutions,151–152ADRelink,usingtorelinkADexecutables,163–164adadminutilityforperformingmostpost-patchingrequirements,152–154recompilinginvalidobjectswith,193adconfig.
shlocationofandallitssupportingscripts,18locationofbackupfiles,20restoringconfigurationfilesfromthebackupofarun,20reviewingtheexecutionchanges,19–20reviewingthelogfiles,19adctrlmenuoption,executing,150219IndexADDM.
SeeAutomaticDatabaseDiagnosticMonitoring(ADDM)processadidentcommand,identifyingtheversionofapplicationfileswith,169adjkeycommand,recreatingtheidentity.
objfilewith,30ADJVAPRG,CLASSPATH,AFJVAPRG,andAF_CLASSPATH,checkingtodeterminetheJDKversionusedbyapplicationcomponents,174AdminNodeascomponentofE-BusinessSuite,2,4configurationof,12,29–32optionsforcreatinganewcustomparameterfor,21–22usedtoexecuteadministrativetasks,4admrgpchutility,tableofoptions,148adovars.
envapplicationconfigurationfiledirectorylocationof,29usingcustomizationsbyediting,21adpatchoptions,tableofcommonlyused,143adpatchutilitydisablinganypasswordconstraintsbeforeexecuting,143namingyourAutoPatchdrivefile,144questionsusermustrespondtowhenstarted,144runningtoapplythehrglobaldriver,147usingtoapplyapplicationpatches,142–145usingtoapplypatches,142adphrept.
sqlgeneratingapatchreportforaninstancewith,136–137tableofparametersfor,136–137adrelink.
sh,tableofdescriptionandvaluesforwith,164advancedarchitecture,forOracleApplications,5–9Alapati,Sam,ExpertOracleDatabase10gAdministrationby,215alertlogfile.
SeedatabasealertlogfileAOL/JTesttooltestmenuoptionsanddiagnosticsmenu,77fortroubleshootingiASconfiguration,76–77Apache.
SeealsoOracleApplicationServerApacheavailability,monitoringandtroubleshooting,75Apacheconfigurationfiles,functionof,22–23Apachelogfiles,monitoringforpotentialerrormessages,74–75Apachemonitoring,tokeepyourWebNoderunningefficiently,51ApacheServermonitoringandtroubleshooting,74–78obtainingversionandrolluppatchinformation,171scriptforschedulingtheApacheServerbounce,196stepsforenablingadditionallogging,74stoppingandrestarting,196Apachetuning,116–117APPL_TOPdirectorycontentsof,7–8specifyingtypefornodecontextfileconfiguration,17–18INDEX220applicationconfigurationfiles,addingcustomizationsto,20–22applicationcontextfileadditionalmiscellaneousparametersin,48–49coverageof,11editing,13–15locatingandcreating,13modifying,13–15applicationenvironmentfilesbasicconfigurationparametersforConcurrentProcessingNodefoundin,27–28usedfordefiningenvironmentvariables,29–30applicationexecutablesrelinking,163–165usingadadmintorelink,165applicationfiles,identifyingversionsof,169–170applicationinstanceclones,usedfordevelopmentandtestingpurposes,198ApplicationModule(AM)PoolMonitor,monitoringtheJVMconnectionpoolwith,78applicationpasswordverification,foraddingsecuritytoapplicationuserpasswords,46–47ApplicationTier,performancetuning,113–119ApplicationTierFilesystem,recommendationtoinvestigateimplementingformultiple-nodeinstallation,7–8applicationuserchangingpasswordfor,161defined,160applicationXMLfile.
SeeapplicationcontextfileApplicationsPackforEnterpriseManager10g,ConcurrentManagerreportsavailablewith,84AppliedPatchesfunctionality,searchesallowedby,139appsweb_$CONTEXT_NAME.
cfgfile,tableofkeyparametersin,25–26apps.
zipfile,retrievingversioninformationforaJavaclassfrom,175[ARGS]parameteroptions,forojspCompile.
pl,168AS.
SeeOracleApplicationServerASH.
SeeActiveSessionHistory(ASH)ASHDUMPevent,fordownloadingtheASHbuffercontentstoatracefile,105autoload.
classesparameter,disablinginthezone.
propertiesfile,118AutomaticDatabaseDiagnosticMonitoring(ADDM)processforcollectingsystemperformancedata,99foridentifyingissuesrelatedtodataaccessbysessions,104–105tableofcommonviews,108usingwithOracle10g,107–108AutomaticWorkloadRepository(AWR)providedwithOracle10gforidentifyingdatabaseperformanceissues,99tableofcommonviews,105usingwithOracle10g,105–106AutoPatchlog,choosingafilenamefor,144AWRsnapshots,codeforgeneratingeachsnapshotbeforerunningSAAmanually,125awrrpt.
sqlscript,runningtogenerateaperformancereport,106INDEX221Finditfasterathttp://superindex.
apress.
com/Bbde_chk_cbo.
sqlscript,MetaLinkNoteregarding,40bde_rebuild.
sqlscript,forrebuildingindexes,195–196blockingsessions,identifying,68books,recommendedforApplicationsDBAs,214–216bugcodes,tableofforServiceRequests,210–211bug_numbertable,queryingtoseeifaspecificpatchhasbeenapplied,138Burleson,Donald,UnixforOracleDBAsPocketReferenceby,215Cc(copy)patchdriver,functionof,142cancelqueryfeature,tableofenvironmentvariablesusedtotune,115certificationmatrix,forinformationaboutproductavailabilityandcertification,203–204chmodcommandforchangingthepermissionsofaUNIXfile,179tableofparametersfor,179–180chowncommandtableofparametersfor,178usingtochangeownershipofaUNIXfile,178–179CLASSPATHandAF_CLASSPATH,JARfilesthatmustbeincludedinboth,174–175CLASSPATHvariable,codeexampleofthevalueof,30ClientascomponentoftheE-BusinessSuite,1–4functionof,3ClientSystemAnalyzertool,usertuningwith,120clonewizards,availableforcloning,198cloningexampleofaportionoftheCloneStatusscreen,198wizardsavailablefor,198cloningcleanup,MetaLinkNotedescribingtheprocess,199codeexampleforaccessingtheAOL/JTest,76foraddingadatafiletothetablespace,70foraddingentriestoorremovingentriesfromthecrontab,188foraddingtheOpatchdirectorytothePATH,155foralertingApplicationsDBAofhighactivesessions,63foralertingyoutoprofilechangeswithinaspecifiedthreshold,91foralteringadatafiletoautomaticallyextendthetablespace,70foralteringadatafiletoextendthetablespacetoagivensize,70forapplyingthedatabaseinterimpatchfixafteropatchissetup,155associatingtheSQLworkloadwiththetuningtaskandexecutingthetuningtask,126ofbasicsyntaxofchmodcommand,179basicsyntaxofchowncommand,178forcallingadautocfg.
shfromtheapplicationtier,19forchangingpermissionsofaUNIXfile,180–181forchangingtheAPPLSYSandAPPSpassword,162INDEX222forcheckingfreespaceavailableforeachobject'snextevent,69–70forcheckingserveravailability,84–85ofcompilingalldeltaJSPpages,168ofcompilingallJSPsthatstartwiththestringjtf,168forconvertingtheOracle9idatabasetoanspfile,35forcreatingabaselinefromsnapshot_id1andsnapshot_id2,106forcreatinganaliasforFNDFS_nodename,29forcreatinganSQLworkloadtoholdtheSTS,126forcreatinganSTSbeforerunningSAAmanually,125forcreatingascriptoftherecommendationsfromSAA,126forcreatingatuningtaskfortheSAA,126fordeterminingwhenanobjectwaslastanalyzed,192fordisablingtheautoload.
classesparameterinzone.
propertiesfile,118forenablingadditionalApachelogging,74forenablinganoptionwithadpatch,143ofexcerptforservicingconnectionrequests,41ofexcerptfromthelistener.
orafilefortheVISinstance,29excerptfromtnsnames.
orafileforconnectingtotheVISservicename,41executingasortcommandalongwiththeUNIXducommand,183forexecutingtheADConfigurationutility,19ofexecutingtheAWRperformancereport,106forexecutingtherecompile_invalids.
shscript,192–193forexecutingthescriptforrotatinglogfiles,194executingtkprofastheinstanceownerwithwritepermissions,123offorcecompilingallJSPpageswithparallelexecutionof10,168toforcerelinkallADexecutables,164toforcerelinktheadadminandadpatchmodules,164toforcerelinktheadadminmodule,164forgatheringstatisticsforallobjectsintheGLschema,190forgeneratingaStatspackreport,102forgeneratingAWRsnapshotsbeforerunningSAAmanually,125foridentifyingblockingsessions,68foridentifyinghighCPUconsumingsessions,64foridentifyingnumberofsessionsinanactivestate,62forincreasingtheJVMheapsizeparameterinjserve.
propertiesfile,118forincreasingthemaximumnumberofextentsallowed,73forlimitingthequeriesloadedintotheSTS,125tolistalltheprintjobsforaspecificUNIXprintqueue,186forlistingthecrontabentriesforauser,188INDEX223Finditfasterathttp://superindex.
apress.
com/forlookingupthemanpagesfordf,177formodifyinginitializationparameterswhenusinganspfile,35formonitoringCPUusing,85–86formonitoringdatabaseavailability,59–60,59–60formonitoringdatafilesneartheirmaximumnumberofextents,71–72formonitoringforApacheavailability,75formonitoringforFormsdumpfiles,80formonitoringlongrunningsessions,66–67formonitoringobjectsclosetotheirmaximumnumberofextents,72–73formonitoringpendingconcurrentrequests,81–82ofamonitoringscriptusingtemplateone,53ofamonitoringscriptusingtemplatethree,54ofamonitoringscriptusingtemplatetwo,54formonitoringserverfilesystemusage,86–87formonitoringservermemoryutilization,86formonitoringsessionsidleforauser-determinedamountoftime,61–62forobtainingadefaultsnapshotofthedatabase,100forobtainingdatabasecomponentinstallationsandversions,176forobtainingthedatabasesessionID,82–83forobtainingversionandrolluppatchinformation,171forobtainingversioninformationfromtheFormsNode,171–172ofparametersettingstoreduceJServlogging,117passwordfunctionthatcheckspasswordsforaspecialcharacter,47–48forqueryingbug_numbertableforappliedpatches,138ofrecursivelychangingownershipofaUNIXfile,179toremoveaspecificprintjobfromaUNIXprintqueue,187forremovingaspecificprintjobfromaprintqueue,187ofreportgeneratedafterSTAtaskhasbeenexecuted,124–125forretrievingalistingofApacheprocessesontheserverfortheVISinstance,116forretrievingalistingofFormsprocessesontheserverforVISinstance,113forretrievingOA.
jspversioninformation,173forretrievingthesidandpidforaparticularcondition,187forreviewingactiveconcurrentrequests,81forrunningADMergeutilityagainstunbundledpatches,147forrunningtheDataInstallJavautility,146ofschedulingtherecompile_invalids.
shscripttoexecutedaily,193ofscriptforgeneratingtheapplicationcontextfile,13ofscriptformonitoringforerrorswrittentothealertlog,57scriptforrotatinglogfiles,193–194scriptforschedulingtheApacheServerbounce,196INDEX224ofscriptthatcanbeusedtogatherstatistics,190–191scripttoassistwithrecompilinginvalidobjectsinyourdatabase,192–193tosearchthepatchingreportforaspecificpatchorbug,137toseeanyavailableADPatchoptions,143forsettingcachingdirectivesontheApacheserver,116–117forsettingthemaximumnumberofextentstounlimited,73showingoutputofpatchsets.
shfromMetaLinkNote139684.
1,138showingsettingsofthevaluesin$APPL_TOP/.
envenvironmentfile,115showingthresholdsforsnapshotstakenonOracleApplications(OA),101forspecifyingthelibrarypathofPerlwiththePERL5LIBenvironmentvariable,155forstartingApacheServer,RPCListener,ConcurrentManager,andFormsServer,160startingapatchingsessionbyexecutingadpatchwithoptions,144startingtheFormsServerastheVISinstanceowner,160syntaxforidentandadidentcommands,169syntaxforthef60gencommand,165syntaxforthefnd_stats.
verify_statsprocedure,192syntaxforthemancommand,177syntaxforthestringscommand,169–170syntaxfortheUNIXkillcommand,181syntaxforusingtheUNIXfindcommand,182syntaxoftheadrelink.
shcommand,163syntaxofusingtheJSPprecompiler,167tarsyntaxforcopyingatargetdirectoryanditscontents,184tarsyntaxusedtocompressadirectoryanditscontents,184tarsyntaxusedtoextractatarfile,184templateforbuildingascriptofmanualstepsforpatchingprocess,145fortestingdatabaselisteneravailability,60fortestingifaportisbeingused,17fortestingtheJavaServletconfiguration,78usedtomonitortotalnumberofsessionsinthedatabase,65–66using-parametertogetquickhelp,178usingatexteditortomodifytheapplicationcontextfile,15forusingcustomizationsbyeditingtheadovars.
envconfigurationfile,21usingf60genutilitytogeneratetheGLXIRUN.
fmbform,166usingFNDCPASSutilitytochangeaOracleuser'spassword,162usingFNDCPASSutilitytochangeapplicationuser'spassword,161usingipcscommand,185–186usingipcscommandforremovingamemorysegmentorsemaphore,186usingipcscommandforremovingaspecificsemaphore,186usingtheeditcontextutility,14INDEX225Finditfasterathttp://superindex.
apress.
com/usingthehelpfeatureifmanualpagesarenotinstalled,177usingthesidandserial#tokillthedatabasesession,187usingUNIXdfcommand,182forvalidatingthatopatchisfunctioningproperly,155forvalidatingtheTCFconfiguration,33ofthevalueoftheCLASSPATHvariable,30coe_stats.
sqlscript,toassistwithautomatingthegatheringofstatistics,191Collaborateconference,forOracleApplicationsDBAs,213CollaborativeSupport,requesting,211–212[COMMAND]parameteroptions,forojspCompile.
pl,168COMMON_TOPdirectory,contentsof,7–8communityresources,findingusingYahooorGooglesearchengines,214–215componentstartup/shutdownscriptstableof,159using,160componentversions,determining,168–176computingstatistics,forallrowsinatable,191ConcurrentManagermonitoring,80–84monitoringconcurrentrequestlogandoutputfiles,81monitoringtohandleissueswithscheduledrequests,52reasonsforperformanceproblems,119schedulingofrequestsby,3tuning,118–119ConcurrentProcessingNodebasicconfiguration,27–28ascomponentofE-BusinessSuite,1,2–3configurationof,12,27–29functionof,3locationofbasicconfigurationfilesfor,27–28ConcurrentProcessor,ascomponentoftheE-BusinessSuite,1concurrentrequesthistory,importanceofpurgingonaregularbasis,119concurrentrequestscancelingactive,82–83gatheringstatisticswith,192monitoringpending,81–82monitoringruntimes,83–84purging,196–197reviewingactive,81conferences,asexcellentinformationsourceforOracleApplicationsDBAs,213configurationbestpractices,50coverageofadditionaltopicabout,12forOracleApplications,11–50configurationfiles.
SeealsoApacheconfigurationfiles;applicationconfigurationfiles;wdbsvr.
appconfigurationfileaddingcustomizationsto,20–22addingcustomizationtagsto,21locationofprimaryforwebconfiguration,22restoringfromthebackupofanadconfig.
shrun,20configurationwizards,usingfromOracleApplications(OA)Manager(OAM),44ConsolidatedUpdatepatches,using,133INDEX226$CONTEXT_NAME.
envfile,tableofkeyparametersin,26,28Cost-BasedOracleFundamentals,byJonathanLewis,215CPUstates,asdisplayedbyUNIXtopcommand,108CPUusage,monitoring,85–86CPUutilization,executingsar-utocapture,110crontabtableoflayoutofentriesin,188usingtoschedulesnapshotsonaregularbasis,102usingtoscheduleUNIXjobs,188crontab-ecommand,foropeningthecrontabforediting,188customdatabaseobjects,creating,43CustomerRelationManagement(CRM)products.
SeealsoJTFFulfillmentServersetupoftheJTFFulfillmentServerby,33CustomerSupportIdentifier(CSI),allowingOracleSupporttotrackcustomer'ssupportandlicensinginformation,206customizationtags,preservationofwhenusingtheADConfigurationutility,21Dd(database)patchdriver,functionof,142data,purgingandarchiving,197databasealertlogfileimportanceofmonitoringbydatabaseadministrator,57–58scriptformonitoringforerrorswrittento,57databaseavailability,checking,59–60databaseconnection(DBC)fileadministering,30–31directorylocationof,30tableofkeyparametersin,31databaseinitializationfiledefaultdirectorylocation,34fordefiningconfigurationsettings,34–39databaseinitializationparametersreviewing,39–40tableofforOracle10gforOracleApplications(OA)11.
5.
10,39tableofforOracle9iforOracleApplications(OA)11.
5.
10,38tableofforOracleApplications(OA)11iforOracle9iandOracle10g,35–37databaselistenerconfiguring,41scriptfortestingavailabilityof,60databaselistenerlogreviewingforreasondatabaselistenerisunavailable,60reviewingiferrorsareexperiencedwiththedatabaselistener,58–59databaselogfiles,reviewingwhenmonitoringthedatabase,57–59databasemonitoring,tokeepthesystemrunningproperly,51databasemonitoringandtroubleshooting,monitoringcategoriesthatrequireattention,57–73databasenetworkconfigurationtoestablishremoteconnectionstothedatabaseinstance,40–42validating,42DatabaseNodeascomponentofE-BusinessSuite,1,2,4configurationof,12,34–43functionof,4INDEX227Finditfasterathttp://superindex.
apress.
com/databaseobjects,creatingcustom,43databasepasswordverification,fordefiningadditionalpasswordsecurity,47–48databasepatching,manuallyorusingthedbmigutility,154–156databasesessions,stepsforremoving,187databasetuning,toolsfor,99–108databaseversionquery,forobtainingversionofthedatabase,176–177datafileextents,identifyinglimitations,71–72DataInstallJavautilitylegislativedatasubmenu,147mainmenufor,146runningtoselectneededlegislationsforinstall,146DBCfile.
Seedatabaseconnection(DBC)fileDBCfilesettings,usingtheAOL/JSetupTestspagetoverify,76dbmig(databasemigration)utility,usingfordatabasepatching,155DBMS_ADVISORpackage,performingdatabaseanalysisandbuildingreportsmanuallywith,107–108dbms_jobs,usingtoschedulesnapshotsonaregularbasis,102DefineUserfunctionality,resettinganapplicationuser'spasswordwith,161Deshpande,Kirtikumar,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216dfcommand,usingtoobtainfilesystemspaceinformation,182DiscovererServer,tableofkeycontextfileparametersfor,33distributedAPPL_TOPofE-BusinessSuitearchitecture,1MetaLinkNotefordetailsforimplementing,8DomainNameSystem(DNS),usingpingcommandtofindaproblemwith,88–89ducommand,usingtoobtainfilesystemspaceinformation,183dumpdestinationparameters,settingupacommonfilesystemforlogfiles,37EE-BusinessSuiteadditionalcommandsandusagetips,177–187additionalconfigurationtopics,44–50creatingcustomdatabaseobjectsin,43MetaLinkNoteforinformationaboutadvanceconfiguration,7MetaLinkNoteforsettingsfordatabaseinitializationparametersfor,35methodforcancelingaFormsquery,114monitoringandtroubleshooting,51–94needforunderstandingofOracleApplicationsconfigurationforadministering,11patchingcategories,131performancetuningformanyofthecomponentsof,95–129predefinedConcurrentManagercalledtheStandardManager,119INDEX228primarycomponentsthatcomprise,1recommendedpatchesoptioninMetaLink,205E-BusinessSuitearchitecturebestpractices,9othercomponentsin,1E-BusinessSuiteRelease11iInfoCenter,forinformationaboutlatestreleasesanddocumentation,203editcontextutility,formodifyingtheapplicationcontextfile,13–14EM10gGridControl.
Seealso10gGridControlDiagnosticsPackjobmanagementandschedulingofferedby,189MetaLinkNoteformoreinformationabout,189EnterpriseManager(EM)PreservedSnapshotSetsfeaturein,106usingtoschedulesnapshotsonaregularbasis,102.
envfilenameextension,forenvironmentfiles,29environmentfiles.
Seeapplicationenvironmentfilesestimatingstatistics,forallrowsinatable,191ExpertOracleDatabase10gAdministration,bySamAlapati,215ExpertOracleDatabaseArchitecture:9iand10gProgrammingTechniquesandSolutions,byThomasKyte,215explainplans,tracefilesusefulingenerating,122Ff60gencommand,tableofrequiredparametersfor,166f60genutility,manuallyregeneratingforms,libraries,andmenuswith,165–166FamilyPackpatches,foraparticularfamilygroupofapplicationmodules,132farm,defined,7Feurstein,Steven,OraclePL/SQLProgrammingby,216filepermissions,tableofnumericalvaluesfor,180filesystemusage,monitoringserverfor,86–87findcommand,usingtofindfilesordirectoriesontheserver,182flexfields,recompilingaspartofpost-patchingrequirements,154fnd_statspackage,gatheringstatisticswith,189–191fnd_stats.
verify_statsprocedure,syntaxfor,192FNDCPASSutilitychanginganapplicationuser'spasswordwith,161changingtheAPPLSYSandAPPSpasswordwith,162usingtochangeanOracleuser'spassword,162FNDFSconnectivity,configuring,29FNDFSlistener,configuring,28–29FormsAboutdialogbox,obtainingversioninformationfromaFormsclientsessionfrom,172FormsandPL/SQLversion,obtaininginformationon,171–172INDEX229Finditfasterathttp://superindex.
apress.
com/forms,libraries,andmenusmanuallyregeneratingwithf60genutility,165–166regeneratingtofixissueswith,165–167usingADAdmintoregenerate,166–167Formsloadbalancing,implementing,7FormsMetricClient.
SeeFormsMetricServerandFormsMetricClientFormsMetricloadbalancing,tableofkeycontextfileparametersfor,27FormsMetricServerandFormsMetricClientconfigurationof,26–27MetaLinkNoteforconfiguringinformation,26FormsMetricsServer,asloadbalancerforsendingrequeststomultipleFormsNodes,7Formsmonitoring,lookingathowtoreviewFormssessionsusingOAM,51FormsmonitoringandtroubleshootingusingFormsServerdumpfiles,80usingfunctionalityinOAM,78–80FormsNodebasicconfiguration,25–26ascomponentofE-BusinessSuite,1,2–3configurationof,12,25–27FormsServerdumpfilescreatedon,80functionof,3obtainingversioninformationfrom,171–172Formspatchsetandversions,tableof,172Formsqueries,canceling,114FormsRuntimeProcessesscreen,inOracleApplications(OA)Manager(OAM),79FormsServer,ascomponentoftheE-BusinessSuite,1Formstracefiles,generating,122Formstraffic,MetaLinkNoteforinformationaboutloadbalancing,27Formstuningforresolvingperformanceissues,113–116tableofparametersforsessions,114FulfillmentServer.
SeeJTFFulfillmentServerfundamentalarchitecture,forOracleApplications,4–5Gg(generate)patchdriver,functionof,142GenericServiceManagement(GSM),29configuring,31–32servicescontrolledby,31GeographicUserGroups(GEOs),listofmaintainedinOracleApplicationsUsersGroupWebsite,213Gopalakrishnan,K,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216GSM.
SeeGenericServiceManagement(GSM)guestaccounts,detailsofinDBCfiles,30INDEX230HhighCPUconsumption,resolvingtheissueof,64–65"HowtoMergePatchesUsingadmrgpch",MetaLinkNotefor,148hrglobaldriver,foraclassofpatchesthatcontainlegislativedata,146httpd.
conffile,tableofkeyparametersettingsin,23IiAS.
SeealsoOracleApplicationServer,functionof,3iASconfiguration,troubleshooting,76–77ICMSleepTimesetting,MetaLinkNoteaboutaltering,119identcommand,identifyingtheversionofapplicationfileswith,169identity.
objfile,administering,30IndependentOracleUsersGroup,dedicatedtotechnicalusersofOracleDatabase,213indexes,rebuildingaspartofpreventativemaintenance,195initializationparameters,codeformodifyingwhenusinganspfile,35interoperabilitypatch,applyingwhenupgradingdatabasetoversion10g,133invalidobjects,recompiling,192–193ipcscommandusingtoshowallmemorysegments,messagequeues,andsemaphores,185usingwithgreptolimitthedisplayofthecommand,185iProcurementdebugging,creatingalogfilefor,74–75JJavaclass,usingthestringcommandtoobtainfileversionsfor,175Javaclassfileversionsobtainingfromtheapps.
zipfileortheclassfile,175usingthestringcommandtoobtain,175JavaconsolealteringdisplaysettingsusingtheJInitiatorControlPanel,93–94JInitiatorversionforOracleApplications(OA)asdisplayedin,171Javaprocessing,configuringadditionalJServstoreducecontentionforresources,7JavaServletconfiguration,testing,78java-versioncommand,usingtoretrievethedefaultJDKversion,174JDeveloper,useofDBCfileforconnectivitytothedatabaseby,30JDKversion,retrievingusingseveralcommandsfromtheUNIXprompt,174JInitiatorclearingtheJARcache,93determiningwhichversiontheapplicationisconfiguredtouse,170–171resolvingissueswith,92–94JInitiatorControlPanelalteringJavaconsoledisplaysettingsin,93–94clearingtheJARcachein,93JServconfigurationfiles.
Seealsoapplicationconfigurationfilesdirectoryfor,23JServlogfiles,monitoringforpotentialerrormessages,74–75INDEX231Finditfasterathttp://superindex.
apress.
com/JServtuning,parametersettingtoreducelogging,117–118jserv.
conffile,tableofkeyparametersin,24jserve.
propertiesfile,increasingtheJVMheapsizeparameterin,118jserv.
propertiesfilemodifyingthelevelofdebugmessagingin,74tableofkeyparametersin,24–25JSPpages,recompiling,167–168JSPprecompilerMetaLinkNoteoutliningprerequisitesandrequirementsforusing,167syntaxofusing,167JTFFulfillmentServer,tableofkeycontextfileparametersfor,34JVMconnectionpool,monitoring,78JVMheapsizeparameter,increasinginthejserve.
propertiesfile,118Kkillcommand,forterminatingaprocessontheserver,181KnowledgeBase,searchfeatureinMetaLink,202Kyte,Thomas,ExpertOracleDatabaseArchitecture:9iand10gProgrammingTechniquesandSolutionsby,216LlegislativepatchesapplyingforHRPayrollcustomers,146forHRPayrollcustomers,133Lewis,Jonathan,Cost-BasedOracleFundamentalsby,215listener.
orafilecodeexcerptfromforservicingconnectionrequests,41parametersthatcontroltracinglevelsin,58–59loadbalancing,ofvariousnodesoftheE-BusinessSuite,6–7loadbalancingnodes,ofE-BusinessSuitearchitecture,1logfilesrotating,193–195scriptforrotating,193–194tableoflocationsanddescriptionsofcommon,195longidlesessions,identifying,60–62lprmcommand,tableofparametersfor,187lpstatandlprmcommands,forcancelingprintjobsonaUNIXserver,186–187lsnrctldatabaseutility,forstartingandstoppingthedatabaselistener,41MMaintenanceMode,enabling,142MaintenancePackpatches,thatserveaspoint-levelreleaseupgrade,132ManageabilityMonitor(MMON),newbackgroundprocessinOracle10g,105–106manual(man)pages,fordetaileddescriptionsofUNIXcommands,177–178memory,asdisplayedbyUNIXtopcommand,109memorysegmentsandsemaphores,findingandremovingonaUNIXserver,184–185INDEX232MetaLinkadvancedsearchesin,201–203advancedsearchoptionsin,205downloadingtheopatchutilityfrom,155E-BusinessSuiteinformationportalonhomepage,203KnowledgeBasesearchfeaturein,202locatinganddownloadingpatchesfrom,204–205patchsearchoptionsin,204–205searchtechniques,201–205usingtheMyConfigsandProjectsfeatureof,206MetaLinkNoteforadditionaldetailsregardingAOL/JTest,76foradditionaldetailsregardingOATM,42foradphrept.
sqldetailsanddescriptionofallparameters,136toassistwithusingtheRapidCloneutility,198forbasicinformationabouttheADPatchutility,142forconfiguringFormsMetricServerandFormsMetricClient,26–27containinglatestversionofbde_rebuild.
sqlscriptandexecutiondetails,195describingsharingtheapplication-tierfilesystem,148–149fordetailsaboutimplementingOracleWebCache,9fordetailsforeffectivelyworkingwithOracleSupport,209detailsforimplementingasharedAPPL_TOPorApplicationTierFilesystem,8fordetailsforimplementingdistributedAPPL_TOP,8forfindinglatestcopyofthehrglobalpatch,146for"HowtoMergePatchesUsingadmrgpch",148forinformationaboutadvanceconfigurationofE-BusinessSuite,7forinformationaboutenablingADConfiguration,11forinformationaboutimplementingOracleRACwith11i,7forinformationaboutlatestversionofpatchsets.
sh,137forinformationaboutloadbalancingFormstraffic,27forinformationonusingDiscovererwithOracleApplications(OA),33forinformationregardingFormspatchsetversions,172forinformationregardingMyConfigsandProjects,206forinformationregardingParallelConcurrentProcessing,7forlatestversionofcoe_stats.
sqlscriptandinformationaboutit,191formoreinformationaboutEM10gGridControl,189referencingforthetrcanlzrutility,124regardingthebde_chk_cbo.
sqlscript,40forrequirementsforcancelingFormsqueries,114forsettingsfordatabaseinitializationparametersforE-BusinessSuite,35tableincludedinthatcalculatesportvalues,15thatdescribes11iStatspackspecificsindetail,100INDEX233Finditfasterathttp://superindex.
apress.
com/MetaLinkwebsite,asmaininterfacetoOracleSupport,201MetaLink'sCertifypage,certificationandavailabilityoptionsin,204Minipackpatches,foraparticularmodule,132MMNLbackgroundprocess,responsibleforwritingsessiondatatomemory,104monitoring.
SeealsomonitoringandtroubleshootingConcurrentManager,80–84CPUusage,85–86methodsfor,52–56serveravailability,85serverfilesystemusage,86–87servermemoryutilization,86systembackups,92tableofparameterdescriptionsformonitoringscriptsinChapter3,55–56monitoringandtroubleshootingadditionaltopics,90–94Apacheserver,74–78bestpractices,94networkissues,87–90OracleE-BusinessSuite,51–94toresolveJInitiatorissues,92–94serveravailability,CPUusage,andfilesystemusage,84–87monitoringtools,scriptsusedwith,53–54multi-nodeenvironments,performingpatchingfor,148–149multi-nodepatching,performing,148–149multi-tierconfigurations,forOracleApplications,5–9MyConfigsandProjectsfeature,ofMetaLink,206Nnetworkissues,monitoringandtroubleshooting,87–90networkmonitoring,usingpingandtracertcommandsplususeofNetworkTest,52networkmonitoringandtroubleshooting,usingpingandtracertcommands,87–89networktest,performingfromtheapplication,90NetworkTraceForm,forperforminganetworktestfromtheapplication,90NLSpatchesapplyingforE-BusinessSuiteinstallationswithmulti-languagerequirements,148toupdatelanguage-specificinformationformulti-lingualinstallations,133node-identifyingcontextparameters,forOracleApplications(OA),17–18nodes.
SeealsoAdminNode;ConcurrentProcessingNode;DatabaseNode;FormsNode;WebNodeidentifyingwithcontextparameters,17–18whattheyarecomprisedof,2OOAFrameworkversion,andOA.
jspversiontable,173OA.
jspversionandOAFrameworkversiontable,173OAM.
SeeOracleApplicationsManager(OAM)OAMMinipackversionH,accessingForms-monitoringfeatures,79INDEX234OATM.
SeeOracleApplicationsTablespaceModel(OATM)OATMtablespaces,tableofstandard,43OAUGInsight,anOAUGpublicationprovidedtoOAUGmembers,216OJSPversion,obtainingbysettingupatestJSPfile,173ojspCompile.
pl[ARGS]parameteroptionsfor,168[COMMAND]parameteroptionsfor,168one-offpatches,toresolveaspecificbug,132onlineresources,availabletoApplicationsDBAs,214–2153opatchutility,usingforinterimpatchfixesforthedatabase,155Oracle10gusingActiveSessionHistorywith,104–105usingAutomaticDatabaseDiagnosticMonitoringwith,107–108OracleApplications(OA)buildingatoolkittomanage,157–198cautionregardinginfrastructureupgrades,9componentstartupandshutdownscripts,158–160componentsandarchitectureof,1–9configuringpasswordsecurityfor,46–48methodsformonitoring,51node-identifyingcontextparameters,17–18obtainingFrameworkversioninformationfor,173performancetuning,95–129sharedAPPL_TOPandCOMMON_TOPdirectoryoneachnode,7–8tableofcomponentstartupandshutdownscriptfiles,159tableofprofileoptionsavailableforapplicationpasswordsecurity,46–47utilitiesandcommands,158–168OracleApplications(OA)architecturebestpractices,9ofE-BusinessSuite,1exampleofadvancedmulti-tier,6exampleoftwo-tier,5overviewof,4–9OracleApplications(OA)componentsforservicinguserrequests,2–4OracleApplications(OA)configuration.
Seealsoconfigurationimportanceofhavingathoroughunderstandingof,11OracleApplications(OA)FrameworkJDBCconnectionpoolparameterssetinDBCfile,31obtainingversioninformationfor,173URLfordeterminingversioninformation,173OracleApplicationsManager(OAM)additionalsearchcriteriaofferedby,140exampleoftheSimpleSearchscreenforpatchesin,139findinginformationaboutarunningconcurrentrequestwith,83findingrunningconcurrentrequestwith,81FormsRuntimeProcessesscreenin,79interfacetotheOracleLicenseManager,45–46INDEX235Finditfasterathttp://superindex.
apress.
com/licensingadditionalproductsin,45–46monitoringconcurrentrequestruntimeswith,84patchsearchin,139–140reviewingactiveconcurrentrequeststhrough,81–82usingforFormsmonitoringandtroubleshooting,78–79usingtheconfigurationwizardsfrom,44usingtoaddcustomizations,21–22usingtoquerytheinstanceforappliedpatches,138viewinglicensedproductsin,45OracleApplications(OA)patchingfunctionof,131stepsinvolvedin,132typesofpatches,132–133OracleApplicationsTablespaceModel(OATM)functionof,42–43MetaLinkNoteforadditionaldetailsabout,42tableofstandardtablespacesusedwith,43OracleApplicationsandDatabases,twomajorusergroupsfor,212–213OracleApplicationServer,WebServerforOracleApplications,3OracleApplicationsManager(OAM)accessingtheAOL/JTesttoolwith,76–77configurationof,12functionalitybuiltintotoassistwithcloning,198usingtoedittheapplicationcontextfile,14OracleApplicationsTablespaceModel(OATM),34OracleApplicationsUsersGroup(OAUG),usingasasourceofinformationandassistance,212–213OracleCollaborativeSupport,requesting,210–211OracleDatabase,ascomponentoftheE-BusinessSuite,1OracleDatabase10g(Oracle10g),spfilemandatorywith,34Oracledatabasesystems,schedulingandmonitoringtoolsformanaging,189OracleE-BusinessSuite.
SeeE-BusinessSuitefund_statspackageforgeneratingstatisticsfor,190–191"OracleE-BusinessSuiteRecommendedPerformancePatches",MetaLinkNoteforrecommendedpatches,128–129OracleFormsServer,allFormsapplicationprocessinghandledby,25–26OracleHTTPServer(OHS).
SeeOracleApplicationServerOracleJInitiatorplug-in,requiredtorunOracleFormsasJavaappletsontheClient,3OracleLicenseManager,OracleApplications(OA)Manager(OAM)interfaceto,45–46OracleMagazine,recommendedforApplicationsDBAs,216OracleOpenWorld(OOW)conference,214OraclePL/SQLProgramming,byStevenFeurstein,216OracleRAC,MetaLinkNoteforinformationaboutimplementingwith11i,7INDEX236OracleRealApplicationClusters(RAC),implementingforamultiple-nodeimplementationforadatabase,7OracleSupportinteractingwithtomanagetheE-BusinessSuite,201–212MetaLinkNotefordetailsforeffectivelyworkingwith,209numberforphoning,212openinganSRforhelpifMetaLinkdoesn'tprovidesolutions,74OracleSupportandDevelopment,gettingassistancefromtofixunderlyingcode,96OracleSupportServiceRequests(SRs).
SeeServiceRequests(SRs)OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuning,byRichmondShee,KirtikumarDeshpande,andK.
Gopalakrishnan,216OracleWebCache,MetaLinkNotefordetailsaboutimplementing,9OracleWebsite,maincorporate,214Oracle10ganalyzingSQLStatementin,124–126databaseinitializationparametersforOracleApplications(OA)11.
5.
10,39usingAutomaticWorkloadRepository(AWR)with,105–106Oracle9i,databaseinitializationparametersforOracleApplications(OA)11.
5.
10,38oraInst.
locfile,managing,49oratabfile,managing,49–50OTNWebsite,membershipinformationandaddressfor,214PParallelConcurrentProcessingimplementing,119MetaLinkNoteforinformationabout,7ParallelConcurrentProcessingforGSM,usingforsystemswithamultiple-nodeconfiguration,32passwordsecurityapplicationpasswordverification,46–47configuring,46–48tableofprofileoptionsavailablefor,46–47passwordschanginganOracleuser's,162changingApplication,Oracle,andtheAPPLSYS/APPS,160–163changingapplicationuser's,161encryptingtheAPPSpasswordinthewdbsvr.
appfile,163patchadvisor,140patchanalysis,schedulingoptionsfor,140patchdriverfiles,namingconventionfor,142patchdriversidentifying,142requirementswhenapplyinginamulti-nodeenvironment,149patchreporting,methodsfordeterminingpatchinglevels,136–140PatchWizardTasksmenu,forperformingpatchanalysisagainstyourinstance,140patchesapplying,141–149locatinganddownloading,204–205queryingthedatabasefor,138stepsforapplying,141INDEX237Finditfasterathttp://superindex.
apress.
com/unbundlingusinganunziputility,141usingaseparatefilesystemforstoringandunbundling,141usingOAMtoquerytheinstanceforapplied,138patchingadditionaltipsforresolvingissueswith,152applyinginteroperabilitypatchwhenupgradingdatabasetoversion10g,133bestpractices,156cleanupafterapatchhascompleted,154E-BusinessSuite,131–156importanceofexaminingreadmefileprovidedwiththepatch,133importanceoffullsystembackupbeforeapplyingpatches,134MaintenancePackpatchesthatserveaspoint-levelreleaseupgrade,132Minipackpatchesforaparticularmodule,132monitoringandresolvingissueswith,132monitoringandresolvingproblems,149–154one-offpatchestoresolveaspecificbug,132OracleApplications(OA),132–154patchesforaparticularfamilygroupofapplicationmodules,132post-patchingstepsandcleaningup,132,152–154preparingfor,132,133–140reclaimingusedspacebyremovingunnecessarybackupfiles,154rolluppatchestoupdatecodelevelsforparticularproducts,133specialtypesofpatches,133stepsinvolvedinapplyingpatches,132toupdatelanguage-specificinformationformulti-lingualinstallations,133usingConsolidatedUpdatepatches,133usinglegislativepatchforHRPayrollcustomers,133patchingproblemsmonitoringandresolving,149–154reviewinglogfilesfor,149–150patchingprocessdocumentingtosavetimeandreduceerrors,134–135exampleofsampledocumentationspreadsheet,135performingmanualsteps,145specialconsiderations,146patchsets.
sh,patch-comparisonutilityforreviewingpatchsetlevels,137–139performanceissuescommon,128reviewingtopwaiteventstoresolve,103–104performancetuning.
Seealsotuningadditionalprofileoptionstoconsiderfor,127bestpractices,128–129,128–129formanycomponentsofE-BusinessSuite,95–129questionstofacilitateresolutionofproblem,96–98theserver,108–113performancetuningprocessforidentifyinganddocumentingcauseofperformancedegradation,95–98identifyingperformanceissues,96–98INDEX238performancetuningtools,forresolvingperformanceissues,95–128periodicals,recommendedforApplicationsDBAs,216pingandtracertcommands,usingfornetworkmonitoringandtroubleshooting,87–89pipecharacter(|),usingtoallowmultipleUNIXcommandstoberuntogether,178portnumberingconventioncreatingtosimplifyinstancemanagement,15–17examplefortwotestinstances,16portvalues,tableincludedinMetaLinkNotethatcalculates,15PreservedSnapshotSetsfeature,inEnterpriseManager(EM),106preventativemaintenancegatheringstatistics,190–192tomaintaintheoverallhealthoftheOracleE-BusinessSuite,189–197printjobs,findingandremovingonaUNIXserver,186–187processidentification(pid)file,creatinginhttpd.
conffile,22profilechanges,monitoring,91–92Profit(OracleApplicationspublication),recommendedforApplicationsDBAs,216pscommandfordeterminingiftheoperatingsystemprocesshasterminated,187usingtodisplayactiveprocesses,112Qqcommand,forexitingtop,109R-rcommand,usingwithSystemActivityReporter(sar),110–111RAC.
SeeOracleRACRapidCloneutility,asOracle'srecommendedmethodforcloning,198readmefile,exampleofcontentsofforpatches,133–134recompile_invalids.
shscript,executing,192–193recompiling,invalidobjects,192–193relinking,applicationexecutables,163–165remotedatabaseconnections,configuring,41ReportReviewAgent(FNDFS),configuring,28–29resources,availabletoApplicationsDBAs,201–215rolluppatch,toupdatecodelevelsforparticularproducts,133SSAA(SQLAccessAdvisor)toolcodeforcreatingascriptofrecommendationsfrom,126creatingatuningtaskfor,126stepsforrunningmanually,125–126fortuningmultiplequeries,125–126sandboxinstance,usingtoapplypatches,141sar.
SeeSystemActivityReport(sar)sar-rcommandexecutingtodisplayserverdata,111tableofstatisticsdisplayedby,110sar-ucommandexecutingtocaptureCPUutilization,110tableofcolumnsanddescriptionsfor,110INDEX239Finditfasterathttp://superindex.
apress.
com/schedulingandmonitoringtools,formanagingOracledatabasesystems,189schedulingmanager.
SeeConcurrentManagerscriptscreatingtoautomatethepatchingprocessmanualcommands,145scheduling,188SecureSocketsLayer(SSL)encryption,forencryptingtransactionanddataoveranetwork,8–9Select,anIOUGpublicationprovidedtoIOUGmembers,216SelfServiceTracing,implementationof,122semaphoresandmemorysegments,findingandremovingonaUNIXserver,184–185serveravailabilitymonitoringandtroubleshooting,84–85providinghighwithamulti-serverenvironment,85serverfilesystemusage,monitoring,86–87servermemoryutilization,monitoring,86servermonitoring,forserveravailability,CPUusage,andfilesystemfreespace,52serverperformancedata,analyzing,113serverstatistics,displayedbyvmstatcommand,112servicecomponentsconfigurationof,12thatmeritspecialconfigurationconsideration,32–34ServiceRequests(SRs)assigningofseveritylevelto,207closing,212creatingnew,207escalating,209gatheringdetailsfor,206managing,207–212requestingsoftcloseof,209searching,208statusorbugcodes,209–211updating,208–209ServletAgentsetting,usingtheAOL/JSetupTestspagetodisplayandtest,76sessionID(sid),queryforreturning,82–83sessionmonitoringcommonissuesthatcanbeidentifiedby,60–68identifyingblockingsessions,68identifyinghighactivesessions,62–64identifyinghighCPUconsumingsessions,64–65identifyinglongidlesessions,60–62identifyinglongrunningsessions,66–67oftotalnumberofsessionsinthedatabase,65–66severitylevels(SEVs)forSRs,207SGA.
SeeSystemGlobalArea(SGA)sharedAPPL_TOPorApplicationTierFilesystemofE-BusinessSuitearchitecture,1MetaLinkNotefordetailsforimplementing,8Shee,Richmond,etal.
,OracleWaitInterface:APracticalGuidetoPerformanceDiagnostics&Tuningby,216snapshotreports,schedulingduringperiodsofnormalactivity,102softclosedSR,defined,209spauto.
sqlscript,willschedulesnapshotstoexecuteeveryhour,102INDEX240SpecialInterestGroups(SIGs),listofmaintainedinOracleApplicationsUsersGroupWebsite,213spfile,mandatorywithOracleDatabase10g(Oracle10g),34spmodfn.
sql,toincludethesourcemodulenameofqueriesinStatspackreportoutput,100SQLAccessAdvisor(SAA)toolstepsforrunningmanually,125–126fortuningmultiplequeries,125–126SQLTuningAdvisor(STA),forautomatingtheSQLtuningprocess,124–125SQLTuningSet(STS)codeforcreatingbeforerunningSAAmanually,125codeforlimitingthequeriesloadedinto,125SQLworkloadassociatingwiththetuningtaskandexecutingthetuningtask,126creatingtoholdtheSTS,126SRbugcodes,tableofforServiceRequests,210–211SRprofiles,creatingandsaving,207SRstatuscodes,tableofforServiceRequests,210SRs(ServiceRequests).
SeeServiceRequests(SRs)SSL.
SeeSecureSocketsLayer(SSL)encryptionStandardManager,aspredefinedConcurrentManagerinE-BusinessSuite,119startup/shutdownscripts,tableof,159statisticsgatheringforallrowsinatable,190–191gatheringwithconcurrentrequests,192proceduresavailableforgatheringwithfnd_stats,190–191reviewingobject-level,192STATISTICS_LEVELinitializationparametersettinginorderforADDMtofunction,107StatspackforOracle9ianalyzingreports,102–104generatingsnapshotreports,100–102foridentifyingdatabaseperformanceissues,99MetaLinkNotethatdescribes11ispecificsindetail,100tableofthresholdsanddescriptions,101StatspackreportsanalyzingOracle9i,102–104sampleof,103statuscodes,tableofforServiceRequests,210storagemonitoringidentifyingdatafileextentlimitations,71–72identifyingmaximumextentlimitations,72–73identifyingtablespacesizinglimitations,69–71toresolvespaceconstraintsbeforeusersencounterfailures,68–73stringscommand,usingtoretrievefileversioninformation,169–170STS(SQLTuningSet)codeforcreatingbeforerunningSAAmanually,125creatingSQLworkloadtohold,126swap,asdisplayedbyUNIXtopcommand,109SystemActivityReport(sar),using,110–111systembackups,monitoring,92INDEX241Finditfasterathttp://superindex.
apress.
com/SystemGlobalArea(SGA),storingactivedatabasesessionsinformationinmemorywithin,104–105Ttablespaces.
SeeOATMtablespaces;OracleApplications(OA)TablespaceModel(OATM)tarcommandfunctionof,183–184tableofparametersfor,184TCFSocket.
SeealsoThinClientFramework(TCF)Socket32–33TechnicalAssistanceRequests(TARs).
SeeServiceRequests(SRs)technologystackcomponentspatching,functionof,131templatefiles,addingcustomizationtagsto,21texteditor,usingtoedittheapplicationcontextfile,15ThinClientFramework(TCF)Socket,tableofparameterinthecontextfilepertainingto,33timed_statisticsdatabaseinitializationparameter,settingtouseStatspack,101tkprof,analyzingtracefileswith,123–124tnsnames.
orafile,excerptfromforconnectingtotheVISservicename,41tnspingcommand,usingtovalidatedatabasenetworkconfiguration,42toolkit,buildingtomanageOracleApplications(OA),157–198topcommandexampleofexecuting,109tableofCPUstatesasdisplayedby,108tableofmemoryasdisplayedby,109tableofswapasdisplayedby,109usingforoverviewofCPUandmemoryutilization,108–109topwaitevents,reviewingtoresolveperformanceissues,103–104TraceAnalyzer(trcanlzr)utility,forreadingarawtraceandgeneratinganHTMLreport,124tracefilesanalyzing,122–124analyzingusingtkprof,123–124generating,122generatingandanalyzingaspartoftheperformancetuningprocess,121–126generatingforaForm,122implementingSelfService,122tracertandpingcommands,usingfornetworkmonitoringandtroubleshooting,87–89translationpatches,applying,148trcanlzr(TraceAnalyzer)utilitydownloading,124forreadingarawtraceandgeneratinganHTMLreport,124troubleshooting.
SeealsomonitoringandtroubleshootingiASconfiguration,76–77tuning.
Seeperformancetuningtuningtask,creatingfortheSAA,126two-tierarchitecture,forOracleApplications,4–5U-ucommand,usingwithSystemActivityReporter(sar),110u(merged)patchdriver,functionof,142unifieddriverpatches,142UNIX,additionalconfigurationfilesofinterest,48INDEX242UNIXbasics,generaltips,177–178UNIXchmodcommand.
SeechmodcommandUNIXchowncommand.
SeechowncommandUNIXdfcommand.
SeedfcommandUNIXducommand.
SeeducommandUNIXfiles,usingchowncommandtochangeownershipof,178–179UNIXfindcommand.
SeefindcommandUnixforOracleDBAsPocketReference,byDonaldBurleson,215UNIXkillcommand.
SeekillcommandUNIXpscommand,usingtodisplayactiveprocesses,112UNIXscripts,referencingofparameterspassedto,54UNIXtarcommand.
SeetarcommandUNIXtopcommand.
Seetopcommanduserrequests,servicing,2–4usertuningmanually,120–121usingtheClientSystemAnalyzertool,120Vv$parameterview,queryingtogetalistingofallcurrentinitializationsettings,39–40vitexteditor,cautionregardinguseoftomodifyapplicationcontextfile,15ViewRunawaysbutton,ontheFormsRuntimeProcessesscreen,79vmstatcommandtableofcategoriesfor,111tableofkeystatistics,111–112usingtodisplayUNIXperformancestatistics,111–112Wwdbsvr.
appconfigurationfilelocationof,23stepsforencryptingtheAPPSpasswordin,163WebAgentsettings,usingtheAOL/JSetupTestspagetodisplayandtest,76webentrypoint,defined,2WebNodeascomponentofE-BusinessSuite,1,2–3configurationof,12,22–25functionof,3WebNodeloadbalancing,requirementsforimplementing,7websearchengines,usingtogetinformationaboutUNIXcommands,178WebServer,ascomponentoftheE-BusinessSuite,1WebsiteaddressforcurrentandarchivedissuesofOracleMagazineandProfitandtosubscribe,216fordownloadingthelatestversionofpatchsets.
sh,137forMetaLinkforOracleSupport,201forOracleApplicationsUsersGroup,212Oracle'smaincorporate,214forOTN,214WindowsTaskManager,accessingandcheckingsystemperformancefrom,121workflowhistory,purging,197INDEX243Finditfasterathttp://superindex.
apress.
com/XXServeraccess,usingtheAOL/JSetupTestspagetotest,76X-emulationsoftware,requiredtoruntheeditcontextutility,13–14Zzone.
propertiesfile,tableofkeyparametersin,25INDEX244
- activeautopatch相关文档
- vendorautopatch
- Tablespacesautopatch
- integratedautopatch
- currenciesautopatch
- GPIO10autopatch
- performautopatch
CloudCone（20美元/年）大硬盘VPS云服务器，KVM虚拟架构，1核心1G内存1Gbps带宽
近日CloudCone商家对旗下的大硬盘VPS云服务器进行了少量库存补货，也是悄悄推送了一批便宜VPS云服务器产品，此前较受欢迎的特价20美元/年、1核心1G内存1Gbps带宽的VPS云服务器也有少量库存，有需要美国便宜大硬盘VPS云服务器的朋友可以关注一下。CloudCone怎么样？CloudCone服务器好不好？CloudCone值不值得购买？CloudCone是一家成立于2017年的美国服务...
georgedatacenter：美国VPS可选洛杉矶/芝加哥/纽约/达拉斯机房,$20/年;洛杉矶独立服务器39美元/月
georgedatacenter怎么样?georgedatacenter这次其实是两个促销，一是促销一款特价洛杉矶E3-1220 V5独服，性价比其实最高;另外还促销三款特价vps，大家可以根据自己的需要入手。georgedatacenter是一家成立于2019年的美国vps商家，主营美国洛杉矶、芝加哥、达拉斯、新泽西、西雅图机房的VPS、邮件服务器和托管独立服务器业务。georgedatacen...
湖北50G防御物理服务器（ 199元/月 ），国内便宜的高防服务器
4324云是成立于2012年的老牌商家，主要经营国内服务器资源，是目前国内实力很强的商家，从价格上就可以看出来商家实力，这次商家给大家带来了全网最便宜的物理服务器。只能说用叹为观止形容。官网地址 点击进入由于是活动套餐 本款产品需要联系QQ客服 购买 QQ 800083597 QQ 2772347271CPU内存硬盘带宽IP防御价格e5 2630 12核16GBSSD 500GB30M1个IP...
autopatch为你推荐
-
敬汉卿姓名被抢注身份证信息被抢注12306账号怎么办微信回应封杀钉钉微信大封杀"违规"了吗www.jjwxc.net有那个网站可以看书？psbc.com邮政储蓄卡如何激活psbc.com95580是什么诈骗信息不点网址就安全吧!长尾关键词挖掘工具外贸长尾关键词挖掘工具哪个好用同一服务器网站同一服务器上可以存放多个网站吗？51sese.com谁有免费看电影的网站？杨丽晓博客明星的最新博文www.493333.comwww.xiaonei.com