Spotlight監(jiān)控Oracle的安裝與使用

1、Spotlight得安裝與使用安裝：1、被監(jiān)控服務(wù)器為Ubuntuserver,先在服務(wù)器上創(chuàng)建一個(gè)用戶，專門用于監(jiān)控使用！因?yàn)檫h(yuǎn)程監(jiān)控服務(wù)器，需要獲取服務(wù)器得資源，所以必須要有權(quán)限。使用文檔明確說明，不能使用root用戶，但就是我用其她已存在得用戶也不行，所以只能創(chuàng)建一個(gè)新用戶，方便起見就用spotlight作為用戶名，設(shè)置如下 useraddspotlightpasswdspotlight設(shè)置完密碼就。k了。不錯(cuò)此處，有相關(guān)介紹說，要這個(gè)用戶必須要有root權(quán)限才行，但這里我只就是創(chuàng)建一個(gè)朋友同用戶就能。如果創(chuàng)業(yè)具有ro。t用戶得權(quán)限，命令如下，同時(shí)建議密碼稍微復(fù)雜一些useradd-gr

2、oot-Grootspotlight1passwdspotlight1設(shè)置完密碼即可。2、需要在服務(wù)器有監(jiān)控工具，如sysstat，ubuntu下直接安裝即可 apt-getinstallsysstat完成即可3、本地機(jī)器安裝spot1ight，創(chuàng)建監(jiān)控信息如下進(jìn)入Spotlight界面，進(jìn)入File菜單點(diǎn)擊Connect，進(jìn)入如下界面雙擊AddNewconnection,進(jìn)入創(chuàng)建一個(gè)新得監(jiān)控鏈接如下使用：一、首先建立Oracle得連接第一步要新建connection，這樣能夠使用spot1ight連接到要監(jiān)測(cè)得數(shù)據(jù)庫。尊Spotlight3I&劃郭rewritesToolsijeb.*1T4

3、UA?，WelcometoSpclivecorinection?SpotlightConxieGtionKaxB9$exMnmWonw|MconnectinnsAllcoirmecttorfi、4iiiPrevioustipNexttipiidkWeccm3toSpotlight*，不、系統(tǒng)主界面系統(tǒng)主界面反映了系統(tǒng)得整體運(yùn)行情況，如果系統(tǒng)哪方面出現(xiàn)問題，會(huì)報(bào)相應(yīng)得警告，查瞧相應(yīng)同級(jí)別顯示不同得顏色，最嚴(yán)重為紅色警告。然后據(jù)此警告可下鉆到相應(yīng)得子窗口情況。下面介紹各子窗口。1、Session面板：(1)Response0leJewFavoritesToalsHelpIICAnlC1EuLive

4、connections；伴dpmTop5QLCriteriaSQLExec?BLFfer.gets|SQL呂dement%oftotalDickreads7085鋸.83也8571A.5846/327,883697select.f?ciEwli_woiiliEt_t日或task,vli_worklist_task_5tate&tate,wlijy598.11922(83418,100,.,施2娜翱10.380select.fromdocument_dir_definitondocforclerconnectbydocforder.456/4。32,。明jLS59,643565Lselect*f

5、rom(selectrownumrownurn_from(selectIs.CListomE22,83&22,83632,032219.S42Lselectcountascounterfrom(selectIs.customer_rmrn,Is.customer_ne13,92513,92723,206006,9791selectcounty)崩counterfrom(select*fronn(selectIs.customer_narrie13,919276,491Z3,B5j60e5,9733,7261select+from(eetectrownumrownum_from(select卜f

6、rom(sg均193s均均3j4S05.77536(86191汩select/*+nestsd_table_ciet_refc+*/tlprnwir*.,bli_nrocess_eventM.*fra6,602,169654頃.13,309,2104.003select,.fromdocument_typejdeflnitionct/peboO_where(dactypel41,631&3424092.51744,0082,780,selecta,custorner-nurrija.hiandlinguuserjnumountCcontract-num)con6,21352,6375,915,

7、6271,78252selectdocunftent5t0_.document_type_i：clcol_0_0_fromdacunnerit5_50,03155)LljSOOA1conneciiansWekonr.eto弓patlight，5,59M07,一A-if1.06五、Activity:這個(gè)窗口，主要提供了等待事件，鎖等待，閆鎖等待，當(dāng)前事務(wù)等。LogicalIOBocksMmcos8,0006jOW4,OCO2.0COK:30YClSS&ssmsa-L-14:30Block,changesCurrentreadsConsistentreads14:50Spot1ightojtOra

8、cledpi.FieViewFavoritesToolsHetLiveCollections鹿dpERNummaryWslts*aiHngEven2StockingLocksLackActivityLatchesServerPhysicalIOAllconrectionsWecorrieh?SpctligtitEvenrvjjtcRedovdritesoQoo43212=5EnonCL14:3014:50naa叫盛Rates1;3D4:50DBbuffer-BuirDiskI/O-Con,i,Diskl/ODEf.,Dlkl/O-&at.蜀?。篶rnr#_一.印604020Ir14:3014:

9、50六、配置與內(nèi)存：主要顯示SGA得使用情況及參數(shù)配置情況sharedpoolsharedpodsharedpoolsharedpoolsharedpod如伯dpool如同pgsharedpoolsharedpoolsharedpoolsharedpoolsharedpad時(shí)ioxsheapinitfixeclallocationcallbiacktriggerin-formtriggerSDUfcePLSnondibhptriggerdefirnKQRSSQKGKheappartitioningdPL/SQLSOURCEtabledefinitiPL/SQLPPOODESGAUtilzatl

10、onLiveconnectioris,Conhguratiori改Memory胃佰FQvoriteE1口叫5jllpbuffercachesharetlpoollargepoolI-othtr600eoo400MeSGAStorageSummary(KBSGAUtllizadonSharedPaolUtllaUonBuFFtirCacheOraclePdrametersAllDonnectiansWe虹imeto5potttq時(shí)七、磁盤存儲(chǔ)情況：顯示表空間利用率與在線日志得使用情況。郵SpotlightonOracle一clpaileViewFavoritesToolsHelpLiveconnections麝dpmDisk.StoresOrdirtERedo7TatlespdceUtjllotion(roupSrnupstatusArchived?MembernameSequence#1181日11S1711816Group1CURRENTNOGrBLT3IMACTIVENOGroup2INACTIVEND/home/dpmtest/clpmtestdbs/o