| 澶辨晥閾炬帴澶勭悊 |
|
Oracle DBA鏃ュ父榪愮淮鍙婂簲鎬ユ晠闅滃鐞嗘墜鍐?PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1H23VUGzCtOOGynCeQbhxLA
鎻愬彇鐮侊細9upi
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
CPU 浣跨敤鐜囬珮鐨勯棶棰?/div>
閫氳繃鎿嶄綔緋葷粺鍛戒護 top topas glance 絳夋煡鐪?top 榪涚▼鍙鳳紝紜鏄郴緇熻繘紼嬭繕鏄?oracle 搴旂敤榪涚▼錛屾煡璇?/div>
褰撳墠 top 榪涚▼鎵ц鐨勬搷浣滃拰 sql 璇彞榪涜鍒嗘瀽銆?/div>
鏍規(guī)嵁榪涚▼鍙瘋幏鍙栨鍦ㄦ墽琛岀殑 sql
SELECT a.osuser, a.username,b.address,b.hash_value, b.sql_text from v$session a,
v$sqltext b, v$process p
where p.spid = &spid
and p.addr = a.paddr
and a.STATUS = 'ACTIVE'
and a.sql_address =b.address
order by address, piece;
鏁版嵁搴撴棤娉曡繛鎺?/div>
鏁版嵁搴撴棤娉曡繛鎺ワ紝涓€鑸彲鑳芥槸濡備笅鍘熷洜閫犳垚錛?/div>
錛?錛夋暟鎹簱瀹曚簡
錛?錛夌洃鍚紓甯?/div>
錛?錛夋暟鎹簱鎸傝搗
錛?錛夊綊?。鐩綍婊?/div>
錛?錛夋暟鎹簱鎴栧簲鐢ㄤ富鏈虹殑緗戝崱鍑虹幇闂涓嶈兘姝ｅ父宸ヤ綔
錛?錛夊簲鐢ㄤ富鏈哄埌鏁版嵁搴撲富鏈虹殑緗戠粶鍑虹幇闂銆?/div>
1銆佹暟鎹簱瀹曚簡
绔嬪嵆鍚姩鏁版嵁搴撱€?/div>
Startup
2銆佺洃鍚紓甯?/div>
姝ゆ椂涓€鑸綋鐜頒負錛?/div>
鐩戝惉榪涚▼鍗犵敤 CPU 璧勬簮澶э紱d
鐩戝惉鏃ュ織寮傚父銆?/div>
姝ゆ椂錛岀珛鍗抽噸鍚洃鍚紝鐩戝惉閲嶅惎涓€鑸兘鍦?1 鍒嗛挓涔嬪唴瀹屾垚銆?/div>
Lsnrctl restart
3銆佹暟鎹簱鎸傝搗
绔嬪嵆閲嶅惎鏁版嵁搴撱€?/div>
鏇村 IT 璁よ瘉璇劇▼璇瘋闂?緹庢渤瀛︿範鍦ㄧ嚎 www.eimhe.com
Startup
4銆佸綊?。鐩綍婊?/div>
錛?錛夊湪娌℃湁閮ㄧ講 OGG 鏁版嵁鍚屾鐨勬儏鍐典笅錛岀珛鍗蟲竻鐞嗗綊?。鏃ュ織鏂囦欢銆?/div>
錛?錛夊鏋滈儴緗蹭簡 OGG 鏁版嵁鍚屾錛屾煡鐪?OGG 姝ｅ湪璇誨彇鐨勫綊妗ｆ棩蹇楁枃浠訛紝绔嬪嵆
娓呯悊 OGG 涓嶅啀闇€瑕佺殑鏃ュ織鏂囦歡銆?/div>
5銆佹暟鎹簱鎴栧簲鐢ㄤ富鏈虹殑緗戝崱鍑虹幇闂涓嶈兘姝ｅ父宸ヤ綔銆?/div>
绔嬪嵆鑱旂郴涓繪満宸ョ▼甯堝鐞嗐€?/div>
6銆佸簲鐢ㄤ富鏈哄埌鏁版嵁搴撲富鏈虹殑緗戠粶鍑虹幇闂銆?/div>
绔嬪嵆鑱旂郴緗戠粶緇存姢浜哄憳鏌ョ湅銆?br />
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
