Re: No space left on device - but I have lots left.

2002-09-07 Thread ltiu
Yes. Thank you for your advice. I do have to keep this in mind everyday. ltiu On Saturday 07 September 2002 17:28, Steven Lembark wrote: > -- ltiu <[EMAIL PROTECTED]> > > > The error messages are very informative don't you think? > > Error messages in most products stink. If you don't learn > to

Re: No space left on device - but I have lots left.

2002-09-07 Thread Steven Lembark
-- ltiu <[EMAIL PROTECTED]> > The error messages are very informative don't you think? Error messages in most products stink. If you don't learn to outsmart the developers and find what's wrong you will never be able to manage databases or operating systems. -- Steven Lembark

Re: No space left on device - but I have lots left.

2002-09-07 Thread ltiu
Thank you. Yes. You are right. The error messages are very informative don't you think? ltiu On Saturday 07 September 2002 16:23, Mladen Gogala wrote: > I love emails like this. Do you read the error message at all or you simply > email all your findings to the list assuming that the list will

Re: No space left on device - but I have lots left.

2002-09-07 Thread Mladen Gogala
I love emails like this. Do you read the error message at all or you simply email all your findings to the list assuming that the list will automatically be interested in everything coming from you? Don't you think that starting your email with something like "sorry guys and goddesses, I'm a be

No space left on device - but I have lots left.

2002-09-07 Thread ltiu
Hello guys, Could use some help here. 1) System specs. Solaris 8 512MB Ram 1GB Swap Oracle 9i Rel2 2) Relevant init.ora parameters: *.LARGE_POOL_SIZE=1048576 *.SGA_MAX_SIZE=33554432 *.SHARED_POOL_SIZE=16777216 *.SORT_AREA_SIZE=2097152 *.compatible='9.2.0.1.0' *.db_cache_size=2097152 *.log_buff

RE: Correlated subquery performance in 8i & 9i

2002-09-07 Thread Larry Elkins
How about a little more info? I'm kind of reading between the lines here but the comments about correlated queries and things changing in 9i make me wonder if Gaja was getting at the ability to exploit hash/merge joins for correlated queries. For example: 1 select * 2 from code_master cm

RE: OPS Sequences: nocache == order ??

2002-09-07 Thread MacGregor, Ian A.
As I said I didn't verify his figures nor confirm he understands what constitutes a transaction. I'll endeavor to do so. The system collects data from monitors measuring the "health" of various test accelerator equipment. The telemetry is buffered before being inserted so that multiple readin

How to make web server to recognize another server location.

2002-09-07 Thread Amar Kumar Padhi
Title: How to make web server to recognize another server location. Hi, we have installed Forms 6i web server. In our applications we need to retrieve images stored in another server. The issue is that the web server does not recognize the other destinations on the network. When we copy the

Re: Oracle to publish pricing guide on Sept. 3

2002-09-07 Thread Anjo Kolk
Yep, Open source, it is free at last ! On Saturday 07 September 2002 04:18, you wrote: > ... and as September 6th dwindles into its waning hours, there > is still no pricing guide. > > Jared > > On Wednesday 04 September 2002 13:59, [EMAIL PROTECTED] wrote: > > Just checked this, and it is supp

Re: OPS Sequences: nocache == order ??

2002-09-07 Thread Anjo Kolk
Ok, It is saturday morning (brain is working at half power), I have looked at this function and at the original requirement and see a problem (may be 2). 1) The time of the multiple instances needs to be in sync with each other. If not, it could be that the 2nd instance has an earlier time and

Re: Same SQL statement, Same Oracle, Different OS ==> Different E

2002-09-07 Thread Anjo Kolk
I don't have an explanation, but: The CBO uses floating point instructions a lot (I think). May be there is a difference in rounding between the Intel chip and the Sparc chip that causes the cost to differ just enough so that the index isn't/is used. Anjo. On Saturday 07 September 2002 01:4

Re: OPS Sequences: nocache == order ??

2002-09-07 Thread Anjo Kolk
1) I think that the tpc numbers are done represented in Transactons Per Minute (TPM/C) and not Per second. So event with 50 tpm/c it means around 8000 tps. 2) Inserting 13000 rows with direct I/O doesn't mean you did 13000 transactions. It could be one transaction 3) I have seen the the