a我考网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

查看: 133|回复: 0

[考试辅导] Oracle性能调优:plsql连接选项

[复制链接]
发表于 2012-8-4 14:06:19 | 显示全部楼层 |阅读模式
oracle plsql连接选项
+ z/ s  F+ u/ y9 E, }& c   
. ?8 p0 o" o- X6 @3 \6 t    文件名:tnsname.ora
8 m" M: X- i/ u2 d8 J  v4 a5 a    % X  |- I3 `4 b! R( U
    # tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora' G+ f3 W$ O; Z8 P) Z
   
9 W$ @" H( f) O2 T    # Generated by Oracle configuration tools.9 E5 C" |5 T1 {0 m
   
, w# V1 r6 V% H" M; Y7 e+ D    www.2cto.com
( R$ z( w. H; {* s   
% Q! q& a# ~. H    DEV =: k! P3 V+ j8 x0 \3 g
    " V3 P; D5 g7 K! \/ [2 ]5 N% e
    (DESCRIPTION =
9 C) f. V7 k4 _# u5 H    ( I4 S- E$ ~3 K5 _2 p
    (ADDRESS_LIST =) A5 R, _; [7 L% }
   
0 c- D. \% r* B" T    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.5)(PORT = 1522))
8 Z& h+ a0 j; s* ]      N5 x1 a& R. v; |4 [
    )& I2 o* K5 p2 m2 s
   
& c+ U% k6 U% S8 W    (CONNECT_DATA =
5 ]# [7 n2 i. ~( W( A+ `7 q1 n( L+ W   
1 c* x: A1 `2 d' T* E3 r( _    (SERVICE_NAME = DEV)
$ s4 O  [. }6 `: X" b    3 e3 v% F& ~- p  s
    )7 {& e" U0 x2 o  I
    ; b7 t5 k0 D  I! @" J/ [( h% r$ T
    )$ O# n$ N% W+ S& O( M- J% B% x1 B
    3 k3 m7 X2 O- W6 D: s
    ORCL =+ g# A& i) m( Y. ~- `
    6 ]; R& z6 H$ a
    (DESCRIPTION =
- l, O, J  G8 W# d0 C    4 V& C( l0 t4 s3 F9 f, R
    (ADDRESS = (PROTOCOL = TCP)(HOST = PC-201112051649)(PORT = 1521))' k( s1 @( f1 o7 T6 I: z2 n
    : z8 C/ R& f( e7 ?3 a1 O5 ]
    (CONNECT_DATA =
6 i! p5 M3 f: U2 j" E5 s   
; x" F1 y% e$ D2 d! `( B    (SERVER = DEDICATED)( P# {6 l0 d; a- C. a0 Q
   
: i6 m4 J: y: Y& @) G! c2 O9 k0 W    (SERVICE_NAME = orcl)
. P  I$ v* m, _; V- c/ `1 N    % A9 |$ [+ r& l) H1 y+ }, c) n
    )
/ O+ [2 X5 x. `, c$ J3 _   
: R$ d" ?8 F! W9 P* V4 Q1 K    )( S/ Y/ e% U6 }: M! y) U+ J
   
1 C+ P  P1 ?3 i3 E    www.2cto.com% {' u) ?* S# X! x
   
3 g! b. S, G" N5 F( w6 O: g; c, {    EXTPROC_CONNECTION_DATA =
% \& s- }% Y+ f6 I    . E, k, O- S6 P. y1 t
    (DESCRIPTION =* c% i% z: y, D" A$ V2 v% d
    1 C7 R7 m" p1 _2 a
    (ADDRESS_LIST =
: t/ I! ^+ ?( h! r    3 a  u# A/ F# }$ q' {
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
6 w( Q( r' R1 X8 [4 _& ]$ \0 M   
5 y& G/ R2 |1 F' J    )" q" }4 C5 `- e, Q% d7 v
   
  k* q+ j5 }3 C& e. M    (CONNECT_DATA =
; |1 B# G/ A: p" W$ O6 @" G' {    ; U! p, Q. V# {  @
    (SID = PLSExtProc)) c  U0 r' x( ^! A: C+ x* S
   
1 x( z+ K8 K* U8 s0 j3 f. M    (PRESENTATION = RO)2 S) ^7 K* p' T! u: i! m4 Y3 w7 H- h
   
# X8 M, D8 d2 a    )
) m1 |( `% I4 l- O$ p   
- E% q. G3 r. I9 O    )2 S" p, |0 v' c$ R
   
8 e4 D$ x9 ]; K6 k+ h) g    YYGAME =
! y1 Y2 q9 M* E$ ?. A$ ^   
* E0 l3 `# j; g3 n6 [6 O3 B- o    (DESCRIPTION =
  k/ g6 _3 p* o" l   
, w: F& M! k% H9 l1 B5 s    (ADDRESS_LIST =0 m5 q; O; }0 l, T4 U3 z
    5 e$ z& ?. t: ~* ?
    (ADDRESS = (PROTOCOL = TCP)(HOST = 211.94.128.29)(PORT = 8989))
! v: t  z5 `- `/ [: c   
2 h4 I* H% s3 w# H- e: c    )
( |% Z/ s. [7 R; y# C. n    6 f! k0 b. r7 E. J; q2 p" }# k
    (CONNECT_DATA =
& S0 M6 \" ~) o6 I3 I' C% M2 k    2 N/ ]+ x% }3 `. E
    (SERVICE_NAME = orcl)% }4 t' i8 x/ y8 p5 ^8 F
   
5 L$ {: A2 A9 }0 K2 X    ); ]' `- F/ n. K! `
   
9 ?* w2 E3 s; I3 G3 w    )
' v' P6 i8 d5 e9 w- l8 E# Y   
, g1 t" \: @( G! h    GAMEDB =
7 d9 w. F! t) d! [4 q   
9 G! @) x! n7 ]" T# P8 r1 @4 B    (DESCRIPTION =
2 c  b$ x5 C- ]2 E6 Y! l0 U% X    9 u3 j( ]" r8 Z& b
    (ADDRESS_LIST =' H% i3 F5 _; N3 a  h, l
    7 i( o$ i6 f1 v3 N
    (ADDRESS = (PROTOCOL = TCP)(HOST = 123.126.31.60)(PORT = 1521))+ ?* h8 ~6 Z, _- M+ m" q. [6 Z2 O
   
% w4 _) d$ j8 Q! Y" w    )
  p7 p! R# f; u  S4 F8 E6 v; q' P! X* o   
8 u: R4 I: s7 Z; q* j3 [: K    (CONNECT_DATA =
. E( S. e; [. N) ]. ^   
6 o. R  A8 x  c: d- L/ ?; a    (SID = gamedb)+ n$ a2 i3 S1 c4 _! n
   
: v& O7 {" i' [' O9 @  Z& s    )$ c5 [9 g. [) o0 z3 z9 x
    . _. a. r; t' w+ p1 [# `
    )
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|Woexam.Com ( 湘ICP备18023104号 )

GMT+8, 2024-6-27 00:26 , Processed in 0.230225 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表