xmlora-12154

OracleTraceFileAnalyzerOverviewORACLEWHITEPAPER|SEPTEMBER20180|ORACLETRACEFILEANALYZER–OVERVIEWGUIDETableofContentsIntroduction1AutonomousDiagnosticCollections2CommandInterfaces3ConfigureEmailNotification3MaskSensitiveData4On-demandAnalysisandCollection5Real-timeSystem&ClusterStatusSummary5InvestigateLogs&LookforErrors6PerformAnalysisUsingtheIncludedTools6CollectDiagnosticData&UseOneCommandSRDCs8ChangeDefaultUserAccess11ChangeClusterwareTraceLevels12RESTService13ConfigureRESTviaORDS13ConfigureRESTviaTomcat13UseRESTService14MaintainOracleTraceFileAnalyzertotheLatestVersion14Conclusion15IntroductionAsaDBA,you'reexpectedtodomorework,withfewerresourcesallthetime.
You'reunderpressuretokeepmission-criticalappsupandrunning.
Whensomethinggoeswrong,everyonelookstoyoutounderstandwhathappenedandhowtofixit.
It'snotalwayseasy.
You'vegottoruntherighttools,attherighttime.
Ifyou'reusingOracleClusterware,thenyouhavetoalsocollectfromallthedatabasenodes.
Youmightneedtouselotsofdifferenttoolsthatyouonlyeverusenowandagain,andtheyeachhavetheirownsyntax.
Onceyou'vemanagedtogetallthedata,itcanbehuge.
Onlyafractionofwhatyou'vecollectedisuseful,butwhoknowswhichbitisrelevantThat'sifyouwereabletogeteverything.
Ifyouwerequickenoughbeforeitwasoverwritten.
Inthemeantime,youstillhaveaproblem.
Thisiscostingyourcompanymoneyandyoustillneedtogetitfixed.
OracleTraceFileAnalyzerhelpsyouperformreal-timehealthmonitoring,faultdetection&diagnosisviaasingleinterface.
Itwillsecurelyconsolidatealldistributeddiagnosticdata.
Itscontinuouslyavailableandwatchingyourlogsforsignificantproblemsthatmayaffectyourservice.
Ifdesireditcanalsoautomaticallycollecttherelevantdiagnostics,whenitseestheseproblems.
OracleTraceFileAnalyzerknowswhatisrelevantinlogfiles.
Thisallowsittotrimthemtothesmallestsize,yetstillgathereverythingnecessary.
Italsocollectsdataacrossclusternodesandconsolidateseverythinginoneplace.
OncedonecollectingitcanautomaticallyuploadthecollectiontoOracleSupport.
UsingimportantdatabasediagnostictoolsiseasywithOracleTraceFileAnalyzer.
Ithidesthecomplexitybyprovidingasingleinterfaceandsyntaxtothemall.
Thisallcombinestoensureyoucangetexactlywhatyouneed,whenyouneeditandsaveyourbusinessmoney.
AutonomousDiagnosticCollectionsTheresourcefootprintissmall.
Youwillnotusuallybeawareitisrunning.
TheonlytimesTraceFileAnalyzerwillconsumenoticeableCPUare:WhenperforminganinventoryofdiagnosticfilesDuringdiagnosticcollectionTraceFileAnalyzer(TFA)willwatchyourlogsforsignificantproblems,suchasinternalerrorslikeORA-00600ornodeevictions.
Ifdetecteditwill:InvokeanynecessarydiagnosticsandcollectallrelevantlogdataatthetimeofaproblemTrimlogfilesaroundthetimeoftheproblem,soitonlycollectswhatisnecessaryfordiagnosisCollectandpackagealltrimmeddiagnostics.
Fromallnodesinthecluster,consolidatingeverythingonasinglenodeStorethecollectionintherepositorySendyouemailnotificationoftheproblemanddetailsofdiagnosticcollection,readyforuploadtoOracleSupportYoucantheneitheruseTFAtouploadthecollectiontoOracleSupport,ifyoucanmakeaconnectionfromthatenvironment,ortransferthecollectionsomewhereelseforuploadTraceFileAnalyzerusesafloodcontrolmechanism.
Repeatederrorsdonotfloodthesystemwithautomaticcollections.
Theidentificationofaneventtriggersthestartpointforacollection.
5minuteslaterdiagnosticgatheringstarts.
Thisistocaptureanyotherrelevanteventstogether.
Ifafter5minuteseventsarestilloccurring,diagnosticcollectioncontinuestowait.
Itwillwaitforaperiodof30secondswithnoeventsoccurring,uptoafurther5minutes.
Ifeventsarestilloccurringafter10minutes,adiagnosticcollectionhappens.
Anewcollectionpointstarts.
OncecollectioncompletesTraceFileAnalyzerwillsendemailnotificationtorelevantpeople,includingdetailsofwherethecollectionresultsare.
CommandInterfacesThetfactltoolfunctionsas:CommandlineinterfaceShellinterfaceMenuinterfaceINTERFACETYPES&USAGEInterfaceTypeCommandHowtouseCommandline$tfactlSpecifyallcommandoptionsatthecommandlineShellinterface$tfactlSetandchangecontext.
ThenruncommandsfromwithintheshellMenuInterface$tfactlmenuSelectmenunavigationoptionsthenchoosethecommandyouwanttorunAutomaticcollectionsareONbydefault.
Tochangeautomaticcollectionsuse:$tfactlsetautodiagcollect=ConfigureEmailNotificationYoucanprovideOracleTraceFileAnalyzerwithoneormorecommaseparatedemailaddressestosendnotificationofproblems.
TosetthenotificationemailaddresstouseforaspecificORACLE_HOME,includetheOSownerinthecommand:$tfactlsetnotificationAddress=oracle:some.
person@acompany.
comTosetthenotificationemailtouseforanyORACLE_HOMEuse:$tfactlsetnotificationAddress=another.
person@acompany.
comOptionallyconfiguretheSMTPserverforTFAtousewhensendingemailnotificationsbysettingtheSMTPparameterswhenprompted:tfactlsetsmtpYoucanverifytheemailconfigurationusing:tfactlsendmailemail_addressWhenTFAdetectsanORA-00600errorhasoccurred(orotherevents),youwillgetanemailnotificationlikethis:Afterreceivingnotificationofaproblem,youshould:1.
Inspectthereferencedcollectiondetailstodetermineifyouknowtherootcause2.
Resolvetheunderlyingcauseoftheproblemifyouknowhow3.
IfyoudonotknowtherootcauseoftheproblemthenloganSRwithOracleSupportanduploadtherelevantcollectionForamorein-depthviewofusingTFAwithORA-00600internalerrorsseeORA-600(ORA-00600InternalError)Detection,Diagnosis&ResolutionMaskSensitiveDataOracleTraceFileAnalyzercanmasksensitivedatasuchashostnamesorIPaddresses.
Toconfiguremasking,editorcreatethefiletfa_home/resources/mask_strings.
xml,thencopytoeachnode.
Themask_strings.
xmlshouldusethefollowingformattodefinedatareplacements:WidgetNode1MyReplacementName192.
168.
5.
1Node1-IPOn-demandAnalysisandCollectionYoucanrunOracleTraceFileAnalyzeron-demandviathecommandlinetooltfactl.
Thetfactlcommandcan:Provideyouareal-timestatussummaryPerformanalysisusingacombinationofdifferentdatabasetools,usingacommonsyntax.
Collectallrelevantdiagnosticlogdata,withlogstrimmedfilesaroundthetime,collectingonlywhatisnecessaryfordiagnosisSecurelyconsolidatealldistributedcollectionsonthenodewheretfactlwasrunfromUploadthecollectiontoOracleSupportReal-timeSystem&ClusterStatusSummaryUsethesummarycommandforareal-timereportofsystemandclusterstatus.
Itshowsafast,easytoreadsummaryofthestatusincludinganypotentialproblemswithimportantelements.
Usage:$tfactlsummary[options]Formorehelpuse:$tfactlsummary-helpInvestigateLogs&LookforErrorsYoucanuseOracleTraceFileAnalyzertoanalyzeallyourlogsacrossyourclusterandtellyouaboutanyrecenterrors.
Forexample:$tfactlanalyze–last1dor$tfactlanalyze–last18hThiswillreportallerrorsitfindsoverthespecifiedduration.
YoucanalsouseOracleTraceFileAnalyzertofindalloccurrencesofaspecificerroronanynode.
Forexample,thiscommandwillsearchforORA-00600errors:$tfactlanalyze-search"ora-00600"-last8hPerformAnalysisUsingtheIncludedToolsOracleTraceFileAnalyzerwithdatabasesupporttoolsbundleincludesthefollowingtools.
ThesetoolsareonlyavailablewhenOracleTraceFileAnalyzerisdownloadedfromDocument1513912.
1.
TOOLSINCLUDEDONLINUX/UNIXToolDescriptionorachkorexachkProvideshealthchecksfortheOraclestack.
OracleTraceFileAnalyzerwillinstalleitherOracleEXAchkforEngineeredSystems,seedocument1070954.
1formoredetailsorOracleORAchkforallnon-EngineeredSystems,seedocument1268927.
2formoredetailsoswatcherCollectsandarchivesOSmetrics.
Theseareusefulforinstanceornodeevictions&performanceIssues.
Seedocument301137.
1formoredetailsprocwatcherAutomates&capturesdatabaseperformancediagnosticsandsessionlevelhanginformation.
Seedocument459694.
1formoredetailsoratopProvidesnearreal-timedatabasemonitoring.
Seedocument1500864.
1formoredetails.
sqltCapturesSQLtracedatausefulfortuning.
Seedocument215187.
1formoredetails.
alertsummaryProvidessummaryofeventsforoneormoredatabaseorASMalertfilesfromallnodeslsListsallfilesOracleTraceFileAnalyzerknowsaboutforagivenfilenamepattern,acrossallnodespstackGeneratestheprocessstackforthespecifiedprocesses,acrossallnodesgrepSearchesforagivenstringinthealertortracefileswithaspecifieddatabasesummaryProvideshighlevelsummaryoftheconfigurationviOpensalertortracefilesforviewingagivendatabaseandfilenamepatterninthevieditortailRunsatailonanalertortracefilesforagivendatabaseandfilenamepatternparamShowsalldatabaseandOSparametersthatmatchaspecifiedpatterndbglevelSetsandunsetsmultipleCRStracelevelswithonecommandhistoryShowstheshellhistoryforthetfactlshellchangesReportschangesinthesystemsetupoveragiventimeperiod.
Thisincludesdatabaseparameters,OSparametersandpatchesappliedcalogReportsmajoreventsfromtheClusterEventlogeventsReportswarningsanderrorsseeninthelogsmanagelogsShowsdiskspaceusageandpurgesADRlogandtracefilespsFindsprocessestriageSummarizeoswatcher/exawatcherdataTOOLSINCLUDEDONWINDOWSToolDescriptioncalogReportsmajoreventsfromtheClusterEventlogchangesReportschangesinthesystemsetupoveragiventimeperiod.
Thisincludesdatabaseparameters,OSparametersandpatchesapplieddirListsallfilesOracleTraceFileAnalyzerknowsaboutforagivenfilenamepattern,acrossallnodeseventsReportswarningsanderrorsseeninthelogsfindstrSearchesforagivenstringinthealertortracefileswithaspecifieddatabasehistoryShowstheshellhistoryforthetfactlshellmanagelogsShowsdiskspaceusageandpurgesADRlogandtracefilesnotepadOpensalertortracefilesforviewingagivendatabaseandfilenamepatterninthenotepadeditorparamShowsalldatabaseandOSparametersthatmatchaspecifiedpatternsummaryProvideshighlevelsummaryoftheconfigurationtasklistFindsprocessesToverifywhichtoolsyouhaveinstalledrun:$tfactltoolstatusEachtoolcanberunusingtfactleitherincommandlineorshellmode.
Torunatoolfromthecommandlineuse:$tfactlrunThefollowingexampleshowshowtousetfactlinshellmode.
Itwillstarttfactl,connecttothedatabaseMyDBandrunoratop:$tfactltfaclt>databaseMyDBMyDBtfactl>oratopCollectDiagnosticData&UseOneCommandSRDCsToperformanon-demanddiagnosticcollectionuse:$tfactldiagcollectThiswilltrim&collectallimportantlogfilesupdatedinthepast12hoursacrossthewholecluster.
OracleTraceFileAnalyzerwillstorecollectionsintherepositorydirectory.
Youcanchangethediagcollecttimeframewiththeoption–lasth|d.
OracleSupportwilloftenaskyoutorunaServiceRequestDataCollection(SRDC).
TheSRDCisdependentonthetypeofproblemyouexperienced.
Itisaseriesofmanydatagatheringinstructionsaimedatdiagnosingyourproblem.
CollectingtheSRDCmanuallycanbedifficult,withmanydifferentstepsrequired.
OracleTraceFileAnalyzercanrunSRDCcollectionsforyouwithasinglecommand:$tfactldiagcollect-srdcIfyourenvironmentcanmakeaconnectiontooracle.
comyoucanadd–srandOracleTraceFileAnalyzerwillautomaticallyuploadthecollectiontoyourServiceRequestforanalysisbyOracleSupport.
Priortouploading,youwillneedtostoreyourMyOracleSupportcredentialsintheOracleTraceFileAnalyzerwallet.
Thisisaonetimetaskandmustbedonebyroot:$tfactlsetupmosUploadacollectiondirectlytoOracleSupport$tfactldiagcollect-srdc-srUploadanyotherfiletoOracleSupport:Youcanuploadusingthewallet,whichwassetuppreviouslybyrootusingtfactlsetupmos:tfactlupload-wallet-srYoucanalsouploadwithoutthewallet.
Whenuploadingwithoutthewallettfactlpromptsforthepassword.
tfactlupload-useruser_id-srTorunSRDCsuseoneoftheOracleprivilegeduseraccounts:ORACLE_HOMEownerGRID_HOMEownerThesearethedifferentSRDCtypesavailable:TypeofProblemAvailableSRDCsORAErrorsORA-00020ORA-00060ORA-00600ORA-00700ORA-01031ORA-01555ORA-01578ORA-01628ORA-04030ORA-04031ORA-07445ORA-08102ORA-08103ORA-27300ORA-27301ORA-27302ORA-29548ORA-30036DatabaseperformanceproblemsdbperfdbsqlperfdbimpdpperfTransparentDataEncription(TDE)problemsdbtdeDatabaseresourceproblemsdbunixresourcesOtherinternaldatabaseerrorsinternalerrorDatabasepatchingproblemsdbpatchinstalldbpatchconflictDatabaseExportdbexpdbexpdpdbexpdpapiDbexpdpperfdbexpdpttsDatabaseImportdbimpdbimpdpdbimpdpperfRMANdbrmandbrman600dbrmanperfSystemchangenumberdbscnGoldenGatedbggclassicmodedbggintegratedmodeDatabaseinstall/upgradeproblemsdbinstalldbupgradedbpreupgradeDatabasestorageproblemsdbasmExcessiveSYSAUXspaceisusedbytheAutomaticWorkloadRepository(AWR)dbawrspaceDatabasestartup/shutdownproblemsdbshutdowndbstartupXDBInstallationorinvalidobjectproblemsdbxdbDataGuardproblemsdbdataguardAlertlogmessagesofCorruptblockrelativedbaproblemsdbblockcorruptionASM/DBFS/DNFS/ACFSproblemsdnfsCreate/maintainpartitioned/subpartitionedtable/indexproblemsdbpartitionSlowcreate/alter/dropcommandsagainstpartitionedtable/indexdbpartitionperfSQLperformanceproblemsdbsqlperfUNDOcorruptionproblemsdbundocorruptionListenererrors:TNS-12516/TNS-12518/TNS-12519/TNS-12520listener_servicesNamingserviceerrors:ORA-12154/ORA-12514/ORA-12528naming_servicesStandardinformationforOracleDatabaseauditingdbauditEnterpriseManagertablespaceusagemetricproblemsemtbsmetricsEnterpriseManagergeneralmetricspageorthresholdproblemsemmetricalertEnterpriseManagerdebuglogcollectionRunemdebugon,reproducetheproblemthenrunemdebugoff,whichdisablesdebugagainandcollectsdebuglogsemdebugonemdebugoffEnterpriseManagertargetdiscovery/addproblemsemcliaddemclusdiscemdbsysemgendiscemprocdiscEnterpriseManagercrash,hangorperformanceproblemsemagentperfemrestartomsemomscrashemomsheapemomshungcpuOracleExalogicfullExalogsdatacollectioninformationesexalogicWhattheSRDCscollectvariesforeachtype,herearetwoexamples:ONECOMMANDSRDCANDCOLLECTIONSCommandWhatgetscollected$tfactldiagcollect–srdcORA-04031IPSPackagePatchListingAWRreportMemoryinformationRDAHCVEoutput$tfactldiagcollect–srdcdbperfADDMreportAWRforgoodperiodandproblemperiodAWRComparePeriodreportASHreportforgoodandproblemperiodOSWatcherIPSPackage(iferrorsduringproblemperiod)ORAchk(performancerelatedchecks)OracleTraceFileAnalyzerwillpromptyoutoentertheinformationitneedsbasedontheSRDCtype.
Forexample,thisiswhathappenswhenyouruntheora4031SRDC:$tfactldiagcollect–srdcORA-04031Youarepromptedtoentereventdate/timeanddatabasenameOracleTraceFileAnalyzerscansthesystemtoidentifyrecenteventsinthesystem(upto10)Oncetherelevanteventischosen,itproceedswithdiagnosticcollectionAllrequiredfilesareidentifiedAllfilesaretrimmedwhereapplicableAlldataispackageinazipreadytoprovidetosupportYoucanalsorunanSRDCcollectioninnon-interactivesilentmode.
Justprovidealltherequiredparametersupfrontlikethis:$tfactldiagcollect–srdc-database-from""-to""ChangeDefaultUserAccessBydefaulttheGRID_HOMEownerandallORACLE_HOMEownerswillhaveaccesstotheirrespectiveinformationviaOracleTraceFileAnalyzer.
Nooneelsewillbeabletoperformcollections.
UseraccessisonlyapplicableifinstalledasrootonLinux/Unix.
UseraccessisnotapplicableifinstalledasnonrootoronMicrosoftWindows.
Enableordisableuseraccessvia:$tfactlaccessenableor$tfactlaccessdisableAllcommandswillapplyclusterwideunlessyouspecify-localtorestricttoonlythelocalnode.
USEFULUSERACCESSCOMMANDSCommandDescription$tfactlaccesslsusersListuseraccess$tfactlaccessadd–user[-local]Addusers$tfactlaccessremove–user[-local]Removeusers$tfactlaccessremoveall[-local]Removeeveryone$tfactlaccessresetResttodefaultaccessChangeClusterwareTraceLevelsOracleSupportmayaskyoutoenablecertaintracelevelswhenreproducingaproblem.
Thisistoallowyoutocollectenoughdiagnosticstodiagnosethecauseoftheproblem.
OracleTraceFileAnalyzermakesiteasytoenableandthendisablethecorrecttracelevels.
Usedbglevel.
Youcanfindtherequiredtracelevelsettingsgroupedbyproblemtraceprofiles.
Tosetatraceprofileuse:$tfactldbglevel–setForalistoftheavailableprofilesrun:$tfactldbglevel–helpRESTServiceOracleTraceFileAnalyzerimplementsaRepresentationalStateTransfer(REST)Service,allowingyoutoinvokeallmethodssecurelyoverHTTPS.
ForconvenienceOracleTraceFileAnalyzerincludesOracleRESTDataServices(ORDS)whichcanbeusedasaquickandeasymeansofenablingRESTcalls.
AlternativelyOracleTraceFileAnalyzeralsoincludesaWebApplicationResource(WAR)file,whichcanbedeployedintoaTomcatservertoprovidethesameRESTimplantation.
ConfigureRESTviaORDSUsetfactlrestastherootusertoconfigureRESTimplantationusingtheincludedORDS:$tfactlrest[-status|-start|-stop|-upgrade|-uninstall][-dir][-port][-user]TheORDSwillberunastheGRIDownerbydefaultonport9090andstoreconfigurationdetailsintheuser'shomedirectory.
Theseoptionscanallbeconfiguredusingtheaboveoptions,orleftasdefaultbyjustusingrest–startandrespondingtotheprompts.
ConfigureRESTviaTomcatOracleTraceFileAnalyzerinstallcontainsaWebApplicationResource(WAR),whichcanbedeployedwithTomcatandprovidetheRESTimplementationviaaTomcatserveronthesamemachineasOracleTraceFileAnalyzer.
ToconfiguretheRESTserviceviaTomcat:1.
DeploytheWARfilelocatedatTFA_HOME/jlib/tfa.
wartoyourTomcatserver.
2.
Changethetfaadminuserpasswordcurl-k--usertfaadmin:tfaadminhttps://host/tfa/tfactl/user/update'[{"username":"tfaadmin","password":"some_new_password"}]'3.
Changethetfarestuserpasswordcurl-k--usertfarest:tfaresthttps://host/tfa/tfactl/user/update'[{"username":"tfarest","password":"some_new_password"}]'4.
AddtheuserTomcatrunsastotheTFAaccesslisttfactlaccessadd-user{tomcat_user}UseRESTServiceOnceconfiguredtheRESTAPIcanbeinvokedusingaURLofthefollowingformat,whereapiisreplacedwiththerelevantAPImethod:https://host:port/ords/apiTostartadiagnosticcollectionusethefollowingURLandPOSTaJSONwithrelevantoptions:https://host:port/ords/tfactl/diagcollect{"components":"-database-asm-tns-crs-acfs-install-cfgtools-os","timePeriod":"-sincen[d|h]|-lastn[d|h]|-fordate|-fromdate-todate","tagName":"crs_crash_collection","nodeList":"node1,node2","options":"-nocopy|-notrim|-silent|-nocores|-collectalldirs|-collectdirdir1,dir2.
.
.
"}TheRESTservicewillrespondwithaJSONcontainingacollectionId.
OncethecollectionhascompletedthiscollectionIdcanthenbeusedtoretrievethezipfile:https://host:port/ords/tfactl/download/{collectionId}MaintainOracleTraceFileAnalyzertotheLatestVersionOraclereleasesanewversionofOracleTraceFileAnalyzerapproximatelyevery3months.
ApplyingstandardPSUswillautomaticallyupdateOracleTraceFileAnalyzer.
HoweverthePSUversiondoesnotcontaintherestoftheDatabaseSupportToolsBundleupdates.
SoifyouwantthelatestandgreatestversionofOracleTraceFileAnalyzerwiththedatabasesupporttoolsbundledownloaditfromDocument1513912.
1Upgradingissimilartofirsttimeinstall.
AsrootusetheinstallTFAscript.
IfOracleTraceFileAnalyzerisalreadyinstalled,itwillupdatetheexistinginstallation.
Whenalreadyinstalled,aclusterupgradedoesnotneedssh.
Theclusterupgradeusestheexistingdaemonsecuresocketcommunicationbetweenhosts.
$.
/installTFAIfyou'renotabletoinstallasroottheninstallastheORACLE_HOMEowner.
Usethe-extracttoand–javahomeoptions:$.
/installTFA-extractto-javahomeConclusionOracleTraceFileAnalyzerhelpsyoukeepmission-criticalappsupandrunning.
Thekeyfeaturesare:AsingleinterfacetoalldatabasediagnostictoolsMonitoringoflogstodetectsignificantproblemsReal-timemonitoringofsystemandclusterLogsanalysistodeterminewhichdiagnosticinformationisrelevanttoaproblemSimplecollectionofdataacrossclusternodes,consolidatedinoneplaceUploadofcollectionstoOracleSupportReductionintimerequiredtoobtaindiagnosticdata,whichsavesyourbusinessmoneyIfsomethingdoesgowrong,OracleTraceFileAnalyzerhelpsyouanalyzeandcollectwhatyouneed,tofixit.
FormoreinformationandtodownloadOracleTraceFileAnalyzerseeDocument1513912.
1.
OracleCorporation,WorldHeadquartersWorldwideInquiries500OracleParkwayPhone:+1.
650.
506.
7000RedwoodShores,CA94065,USAFax:+1.
650.
506.
7200Copyright2018,Oracleand/oritsaffiliates.
Allrightsreserved.
Thisdocumentisprovidedforinformationpurposesonly,andthecontentshereofaresubjecttochangewithoutnotice.
Thisdocumentisnotwarrantedtobeerror-free,norsubjecttoanyotherwarrantiesorconditions,whetherexpressedorallyorimpliedinlaw,includingimpliedwarrantiesandconditionsofmerchantabilityorfitnessforaparticularpurpose.
Wespecificallydisclaimanyliabilitywithrespecttothisdocument,andnocontractualobligationsareformedeitherdirectlyorindirectlybythisdocument.
Thisdocumentmaynotbereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose,withoutourpriorwrittenpermission.
OracleandJavaareregisteredtrademarksofOracleand/oritsaffiliates.
Othernamesmaybetrademarksoftheirrespectiveowners.
IntelandIntelXeonaretrademarksorregisteredtrademarksofIntelCorporation.
AllSPARCtrademarksareusedunderlicenseandaretrademarksorregisteredtrademarksofSPARCInternational,Inc.
AMD,Opteron,theAMDlogo,andtheAMDOpteronlogoaretrademarksorregisteredtrademarksofAdvancedMicroDevices.
UNIXisaregisteredtrademarkofTheOpenGroup.
0918OracleTraceFileAnalyzer–OverviewGuideSeptember2018Author:GarethChapman&BobCaldwellContributingAuthors:BillBurton&SandeshRaoCONNECTWITHUSblogs.
oracle.
com/oraclefacebook.
com/oracletwitter.
com/oracleoracle.
com