# 44230
rocket_zhao
|
|
To: eygle
新书出版没有阿,大师
From: rocket_zhao 2008.12.17 02:39
|
|
|
|
To: rocket_zhao
今天我刚拿到样书了。。。。
From: eygle 2008.12.18 19:00
|
|
|
|
# 44229
lx
|
|
To: eygle
aix 5300-08 8个cpu 16G内存
oracle 10204 数据库都使用jfs2文件,4K文件系统块大小,数据库块大小8K
vmstat显示I/O等待较多,是否可以通过使用CIO方式装载文件系统改善性能,有否风险,有什么注意事项吗?
From: lx 2008.12.16 21:50
|
|
|
|
To: lx
使用CIO在一定程度上可以提升你的数据库性能。
一般没什么风险,很多这么用
From: eygle 2008.12.21 01:18
|
|
|
|
# 44228
国字号
|
|
To:
这样一个问题:procedure A(c in,a out,b out)
在另外一个procedure B 中调用 A,plsql正常调用 A(c,a,b);
但是有朋友想这样:A(c,a)、A(c,b),或者是写个通配符
A(c,a,-),A(c,-,b) 这样就不用传递a或b了,也不接收a或b了,
不知可否,或者是oracle对in,out 参数如何规定的,
了解不是很深刻,特此请教!
From: 国字号 2008.12.16 01:49
|
|
|
|
To: 国字号
你可以给那两个传入参数指定Default值,这样就可以不传入参数了。
你看看dbms_system包,Oracle很多都是如此处理的。
From: eygle 2008.12.16 16:42
|
|
|
|
# 44224
balsilliy
|
|
To: eygle
根据《循序渐进》中第 P17 中 指出的 listener.ora中 sid_name来自instance_name 可是我自己做实验的时候就发现
instance_namestringtest1
service_namesstringtest
[root@rac2 dbs]# ps -ef|grep ora_
oracle3160 10 03:39 ?00:00:04 ora_pmon_test
oracle3162 10 03:39 ?00:00:02 ora_psp0_test
(SID_DESC =
(ORACLE_HOME = /opt/u01/app/oracle/product/10201/db1)
(SID_NAME = test1)
)
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
就会远程连接时这样报错,请指教
From: balsilliy 2008.12.11 00:21
|
|
|
|
|
|
|
|
|
|
To: balsilliy
我说tnsnames.ora中配置的SID_NAME来自instance_name,但是不意味着,instance_name和SID不一致就能如此连接数据库。
10g中实际上和9i已经有所不同,如果要在以上模式下连接数据库,需要指定SID连接。
看我以下测试:
[oracle@jumper admin]$ lsnrctl status
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:44:33
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date11-DEC-2008 17:43:51
Uptime0 days 0 hr. 0 min. 41 sec
Trace Level off
SecurityOFF
SNMPOFF
Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jumper.hurray.com.cn)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jumper admin]$ lsnrctl status
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:45:08
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date11-DEC-2008 17:43:51
Uptime0 days 0 hr. 1 min. 16 sec
Trace Level off
SecurityOFF
SNMPOFF
Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jumper.hurray.com.cn)(PORT=1521)))
Services Summary...
Service "eygle" has 1 instance(s).
Instance "JULIA", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@jumper admin]$ sqlplus eygle/eygle@lia
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Dec 11 17:45:43 2008
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
[oracle@jumper admin]$ tnsping lia
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:45:48
Copyright (c) 1997 Oracle Corporation.All rights reserved.
Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.11)(PORT = 1521))) (CONNECT_DATA = (SID = julia)))
OK (0 msec)
[oracle@jumper admin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Dec 11 17:46:04 2008
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> show parameter ins
NAME TYPEVALUE
------------------------------------ ----------- ------------------------------
active_instance_countinteger
cluster_database_instances integer 1
instance_groupsstring
instance_namestringJULIA
instance_numberinteger 0
open_links_per_instanceinteger 4
parallel_instance_groupstring
parallel_server_instancesinteger 1
SQL> show parameter service
NAME TYPEVALUE
------------------------------------ ----------- ------------------------------
mts_servicestringeygle
service_namesstringeygle
From: eygle 2008.12.11 01:47
|
|
|
|
|
|
|
# 44223
骑着猫咪逛大街的老鼠
|
|
To: eygle
DBA2.0的时代 - DBA将向何处去?
这篇文章为什么不能看……
From: 骑着猫咪逛大街的老鼠 2008.12.09 04:22
|
|
|
|
To: 骑着猫咪逛大街的老鼠
你太及时啦,哈哈!
From: eygle 2008.12.11 01:10
|
|
|
|
# 44220
spring
|
|
To: eygle
每天有空就会来你的网站,有时有问题宁可自己再看也不懂 也不想来这里打扰您,看您每天都有这么多留言要回答 确实不想麻烦您;
不过这个问题确实困惑我好久了,不得已又来麻烦你。
就是library cache的pin 和lock 都是在什么级别上的。您的几篇文章我都看了 还是没有理解,望赐教:)
From: spring 2008.12.06 05:20
|
|
|
|
To: spring
这两者都是内存上的锁,应用与Library Cache之上
Library Cache的Handle和Object是两个不同结构,所以用两种锁机制来控制!
From: eygle 2008.12.08 19:27
|
|
|
|
|