留言簿 - Powered by eYgLe.Com

eygle.com	我要留言
《深入浅出Oracle》内容简介

昵称

内容	页: 1 - << < 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 > >> - 310

# 42809

rainmising

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) 133.254.5.*

To: eygle
　　eygle你好

能不能请继续说明
trim(leading ' ' from replace(' i loveu','"','""'))
与
rtrim(replace(' i loveu','"','""'))
的区别?

谢谢.

From: rainmising
2007.04.21 15:22

版主选项:

编辑

# 42808

xjlibing

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 124.117.8.*

To:
　　你好EYGLE很冒昧的请教你我遇到的问题。我是医院的网管在使用ORACLE9I2时发现LISTENER.LOG文件中有如下信息
TNS-12547: TNS：丢失连接
TNS-12560: TNS: 协议适配器错误
TNS-00517: 丢失连接
　32-bit Windows Error: 54: Unknown error
　 TNS-12500: TNS：监听器未能启动专用的服务器进程
　　TNS-12560: TNS: 协议适配器错误
这些错误并不是客户端每次连接ORACLE数据库都有，主要发生在早晨。
processes　 integer　150
客户端数量也不是很多，如果说是网络问题同样的客户机连接sqlserver2000数据
库一切正常。难道说是它们的连接机智不一样吗？
oracle9i数据库运行环境
windows2000server 系统 pⅢ1.2g 双cpu 内存2.5g RAID5 60G
由于领导指示此服务器上还安装SQLSERVER2000数据库，我已将SQLSERVER2000数据库多大内存定在700M内，并且使用此数据库的用户不是很多数据量也不大。
Total System Global Area 1368466872 bytes
Fixed Size　　　　　　　　　 456120 bytes
Variable Size　　　　　　 528482304 bytes
Database Buffers　　　　　838860800 bytes
Redo Buffers　　　　　　　　 667648 bytes
客户端的 tnsnames.ora 文件
XJMED =
(DESCRIPTION =
　 (ADDRESS_LIST =
　　 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
　 )
　 (CONNECT_DATA =
　　 (SID =tfyb)
　　 (SERVER = DEDICATED)
　 )
)

请大师指教谢谢

From: xjlibing
2007.04.21 12:18

To: xjlibing
　　
这个通常是资源不足造成的，看你的情况，可能和SGA设置有关系，你可以将SGA降低一点。

From: eygle
2007.04.22 09:42

版主选项:

编辑

# 42807

ChailangCompany

来自: qingdao

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; MyIE2; .NET CLR 1.1.4322; .NET CLR 2.0.50727) 60.209.191.*

To: ORACLE10g数据库DOWN机，急求指导意见，谢谢！
　　 ORACLE10g数据库DOWN机，急求指导意见，谢谢！
数据在正常使用时突然运用程序全部都停止响应，需要重新启动监听或者是数据库才能继续运行？不知如何查找原因，请各路高手支招谢谢。
操作系统：AIX 5
数据库：ORACLE 10g

v$session_wait_history
　 SID SEQ# EVENT# EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 WAIT_TIME WAIT_COUNT
28 199 8 256 SQL*Net message from client driver id 1413697536.00 #bytes 1 0 194164 1
76 204 6 256 SQL*Net message from client driver id 1413697536.00 #bytes

详细描述
http://www.itpub.net/showthread.php?s=&;threadid=759856

From: ChailangCompany
2007.04.21 09:22

版主选项:

编辑

# 42806

Chi

来自: Mexico

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1 148.223.76.*

To: Eygle
　　I tried to disable the _disable_logging parameter in my Oracle 10G R2 on AIX 5.3. It revealed the same error of "corrupt redo log block header"
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 2408 (4)

as you mentioned in your old article and also hung the oracle system, and stop my database control.　I saw en error message when I can open the database control -"The database is not available due to the following conditions: Stuck Archiver".　So I think it is better not to alter that variable from default. Besides, under the normal 10G R2, no return from "show parameter disable".

From: Chi
2007.04.21 03:17

To: Chi
　　最好还是别研究这个参数了。

From: eygle
2007.04.23 21:15

版主选项:

编辑

# 42805

bing feng

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; TencentTraveler ; .NET CLR 2.0.50727) 60.23.248.*

To: eygle
　　THANKS SO SUCH!!!

From: bing feng
2007.04.20 14:29

版主选项:

编辑

# 42803

bing feng

To: eygle
　　能帮忙解释下
trim(both ' ' from replace(' i loveu','"','""'))
是什么意思吗，
thanks so much！

From: bing feng
2007.04.19 11:50

To: bing feng
　　
trim和replace函数的连用，trim both是去掉两端的空格，参考：
In Oracle/PLSQL, the trim function removes all specified characters either from the beginning or the ending of a string.

The syntax for the trim function is:

trim( [ leading | trailing | both　[ trim_character ]　]　 string1 )

leading - remove trim_string from the front of string1.

trailing - remove trim_string from the end of string1.

both - remove trim_string from the front and end of string1.

If none of these are chosen (ie: leading, trailing, both), the trim function will remove trim_string from both the front and end of string1.

trim_character is the character that will be removed from string1. If this parameter is omitted, the trim function will remove all leading and trailing spaces from string1.

string1 is the string to trim.

For example:

trim('　 tech　 ') would return 'tech'
trim(' '　from　'　 tech　 ') would return 'tech'
trim(leading '0' from '000123') would return '123'
trim(trailing '1' from 'Tech1') would return 'Tech'
trim(both '1' from '123Tech111') would return '23Tech'

From: eygle
2007.04.19 20:39