Spotlight On Oracle

Spotlight®onOracleGettingStartedGuide7.5©2010QuestSoftware,Inc.ALLRIGHTSRESERVED.Thisguidecontainsproprietaryinformationprotectedbycopyright.Thesoftwaredescribedinthisguideisfurnishedunderasoftwarelicenseornondisclosureagreement.Thissoftwaremaybeusedorcopiedonlyinaccordancewiththetermsoftheapplicableagreement.Nopartofthisguidemaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,includingphotocopyingandrecordingforanypurposeotherthanthepurchaser'spersonalusewithoutthewrittenpermissionofQuestSoftware,Inc.TheinformationinthisdocumentisprovidedinconnectionwithQuestproducts.Nolicense,expressorimplied,byestoppelorotherwise,toanyintellectualpropertyrightisgrantedbythisdocumentorinconnectionwiththesaleofQuestproducts.EXCEPTASSETFORTHINQUEST'STERMSANDCONDITIONSASSPECIFIEDINTHELICENSEAGREEMENTFORTHISPRODUCT,QUESTASSUMESNOLIABILITYWHATSOEVERANDDISCLAIMSANYEXPRESS,IMPLIEDORSTATUTORYWARRANTYRELATINGTOITSPRODUCTSINCLUDING,BUTNOTLIMITEDTO,THEIMPLIEDWARRANTYOFMERCHANTABILITY,FITNESSFORAPARTICULARPURPOSE,ORNON-INFRINGEMENT.INNOEVENTSHALLQUESTBELIABLEFORANYDIRECT,INDIRECT,CONSEQUENTIAL,PUNITIVE,SPECIALORINCIDENTALDAMAGES(INCLUDING,WITHOUTLIMITATION,DAMAGESFORLOSSOFPROFITS,BUSINESSINTERRUPTIONORLOSSOFINFORMATION)ARISINGOUTOFTHEUSEORINABILITYTOUSETHISDOCUMENT,EVENIFQUESTHASBEENADVISEDOFTHEPOSSIBILITYOFSUCHDAMAGES.Questmakesnorepresentationsorwarrantieswithrespecttotheaccuracyorcompletenessofthecontentsofthisdocumentandreservestherighttomakechangestospecificationsandproductdescriptionsatanytimewithoutnotice.Questdoesnotmakeanycommitmenttoupdatetheinformationcontainedinthisdocument.Ifyouhaveanyquestionsregardingyourpotentialuseofthismaterial,pleasecontact:QuestSoftwareWorldHeadquartersLEGALDept5PolarisWayAlisoViejo,[e-mail]egionalandinternationalofficeinformation.Trademarks:Quest,QuestSoftware,theQuestSoftwarelogo,AccessManager,ActiveRoles,Aelita,Akonix,BenchmarkFactory,BigBrother,BridgeAccess,BridgeAutoEscalate,BridgeSearch,BridgeTrak,BusinessInsight,ChangeAuditor,CIDiscovery,Defender,DeployDirector,DesktopAuthority,DirectoryAnalyzer,DirectoryTroubleshooter,DSAnalyzer,DSExpert,Foglight,GPOADmin,HelpDeskAuthority,Imceda,IntelliProfile,InTrust,Invirtus,iToken,JClass,JProbe,LeccoTech,LiteSpeed,LiveReorg,LogADmin,MessageStats,Monosphere,NBSpool,NetBase,NetControl,Npulse,NetPro,PassGo,PerformaSure,Point,Click,Done!,QuestvToolkit,QuestvWorkSpace,ReportADmin,RestoreADmin,ScriptLogic,SelfServiceADmin,SharePlex,Sitraka,SmartAlarm,Spotlight,SQLNavigator,SQLWatch,SQLab,Stat,StealthCollect,StorageHorizon,TagandFollow,Toad,T.O.A.D.,ToadWorld,vAutomator,vConverter,vEcoShell,VESI,vFoglight,vPackager,vRanger,vSpotlight,vStream,vToad,Vintela,VirtualDBA,VizionCore,VizioncorevAutomationSuite,VizioncorevEssentials,VizioncorevWorkflow,WebDefender,Webthority,Xaffire,andXRTaretrademarksandregisteredtrademarksofQuestSoftware,IncintheUnitedStatesofAmericaandothercountries.Othertrademarksandregisteredtrademarksarepropertyoftheirrespectiveowners.SpotlightonOracleGettingStartedGuideUpdatedMay2010TableofContentsIntroduction.........................................................................................................................................................5 WelcometoSpotlightonOracle........................................................................................................................7 AnoverviewoftheOraclearchitecture....................................................................................................................7 AnoverviewofSpotlightonOracle..........................................................................................................................9 FeaturesofSpotlight..............................................................................................................................................11 GettingstartedwithSpotlightonOracle.......................................................................................................15 InstallingSpotlight..................................................................................................................................................15 StartingSpotlight....................................................................................................................................................18 CreatinganewSpotlightuser................................................................................................................................19 CreatinganOracledatabaseconnection...............................................................................................................21 ConnectingtoanOracledatabase.........................................................................................................................26 InstallingandusingDTracewithinSpotlight..........................................................................................................27 UsingSpotlightonOracle.......................