Hi all: Check you DNS, maybe some client cannot ping by the server name. Choose a client and add the server name and ip record to hosts file. I hit this problem before. On 11/11/05, 時期 精霊 <kuon@xxxxxxxxxx> wrote: > > Hello, > > I'm currently developing a JDBC program on Oracle and I have the > following problem. > > I use the BLOB.getBinaryStream() method, it works fine, I got the > stream and I can read it. > > My problem is slow performances, when I call stream.read(): > > The first call takes 10 seconds. > Then 32*1024 next calls are very fast. > Then hang for 10 seconds > Then 32ko readed fast, hang.... > > Do you have any idea if this is Database or JDBC problem? > > The network is fine. > > I think it's a SQL Net problem, because when I SQL plus to the db on > the local computer, the connection is immediate, but if I sqlPlus > from remote computer, the connection hang for 5 seconds before > showing me the sqlPlus prompt. And 32ko seems to be the net packet > size, but I'm not sure of this. > > So, my questions are: > > - How can I use SQLPlus to select a blob (without printing it) with > set autot on so I can benchmark and be sure it's not my JDBC? (I > tried column binaryData noprint, select binaryData, id from akData > where id = 1, but I still got the "SQLPlus cannot print this kind of > data" error). > - How can I tune the SQLNet configuration? > - I use ASM, can this be a problem? > - Should I move the BLOB to a different tablespace? If yes, how? > - Any other settings to tune my db? > > I use oracle 10g on Solaris 10. > Last JDBC (thin) driver. > > Best regards > > Kuon > -- > //www.freelists.org/webpage/oracle-l > > > -- Welcome! Home: http://www.anysql.net/en/