| 配置?{度?M程的?的俊?
3> MTS_MAX_DISPATCHERS
配置?{度?M程的最大?的俊?
4> MTS_SERCERS
???庸蚕矸??掌鞯淖畛??的俊?
5> MTS_MAX_SERVERS
?O置共享服?掌鞯淖畲??的俊?
6> MTS_LISTENTER_ADDRESS
?@是?{度程序用?硐?SQL*NET?O??器注?苑??盏姆??彰?的地址。
一??MTS的配置例子:
在INIT.ORA中
mts_listener_address=’(ADDRESS=(PROTOCOL=TCP)(KEY=MYDB))’
mts_dispatchers=’tcp,10’
mts_dispatchers=’ipx,2’
mts_max_dispatchers=10
mts_max_servers=10
mts_servers=2
在LISTENER.ORA中??包括下??似的?热?:
LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPX)
(KEY=MYDB)
)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=OURHOST)
(PORT=1521
)
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER=10
TRACE_LEVEL_LISTENER=ADMIN
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=MYDB)
)
)
添加MTS???抵?后要重新?????????臁?
在SQL*PLUS下用PS命令?z查共享服?掌骱驼{度程序是否存在。
Ø PS -EF|GREP FOXMOLD;
具有ORA_SNNN_SID和ORA_DNNN_SID名?Q的?M程分?e是共享服?掌骱驼{度?M程。
SELECT USERNAME,PROGRAM,SERVER FROM V$SESSION WHERE AUDSID=USERENV(‘SESSIONID’);
在SERVER列中返回的值????是SHARED,如果是DEDICATED,就?f明?]有正?_配置MTS.
用LSNRCTL SERVICES命令???z查?{度程序是否向?O??器登??了服?铡?
7. 移???????煳募?
第一?N方法?s(ALTER DATABASE)
?P?]??????-移??????文件-?b?d并改名-????
1> SVRMGRL
2> CONNECT INTERNAL
3> SHUTDOWN
4> EXIT
5> MV /U/PRODUCT/ORADATA/FOXMOLD/USER01.DBF /DB3/ORADATA
6> SVRMGRL
7> CONNECT INTERNAL
8> STARTUP MOUNT FOXMOLD
9> ALTER DATABASE RENAME FILE
‘/U/PRODUCT/ORADATA/FOXMOLD/USER01.DBF’ TO
‘/DB3/ORADATA/USER01.DBF’
10> ALTER DATABASE OPEN
第二?N方法?s(ALTER TABLESPACE)
?P?]??????-移??????文件-?b?d并改名-????
1> SVRMGRL
2> CONNECT INTERNAL
3> SHUTDOWN
4> EXIT
5> MV /U/PRODUCT/ORADATA/FOXMOLD/USER01.DBF /DB3/ORADATA
6> SVRMGRL
7> CONNECT INTERNAL
8> ALTER TABLESPACE DATA RENAME DATAFILE
‘/U/PRODUCT/ORADATA/FOXMOLD/USER01.DBF’ TO
‘/DB3/ORADATA/USER01.DBF’
9> ALTER DATABASE OPEN
8. ?y??分析
SPOOL C:ANALYZE.SQL
SELECT 'ANALYZE TABLE '||TRIM(OBJECT_NAME)||' COMPUTE STATISTICS; '
FROM USER_OBJECTS
| 