Test mesg

2003-11-16 Thread Jared Still
Just making sure the list is up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Test mesg

2003-11-16 Thread Robert Eskridge
JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Oracle 8i DB with Oracle 9i client

2003-11-16 Thread jaysingh1
Dear Gurus, Current versions: DB : 8.1.7.3 Client : 8.1.7.0 We are in the process of upgrading ONLY the clients from 8.1.7.0 to 9i to address few bugs. Are there any known issues for 8i database with 9i client? TIA Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: Test mesg

2003-11-16 Thread Brian_P_MacLean
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r 1 select case 2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY') 3 then 'Working from home' 4 else case 5 when to_char(sysdate,'HH24') between 8 and 17 6

Re: Test mesg

2003-11-16 Thread Jared Still
It was just a little strange to see no traffic in 20 or so hours, even on a weekend, so just thought I would check. Jared On Sun, 2003-11-16 at 07:59, Robert Eskridge wrote: JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a

Re: Test mesg

2003-11-16 Thread Mladen Gogala
Thought that when Larry has created the database in 7 days, he allocated the 7th day for rest and meditation. No email lists were mentioned in the original 10 commandments. On 11/16/2003 07:39:25 PM, Jared Still wrote: It was just a little strange to see no traffic in 20 or so hours, even on a

Re: Test mesg

2003-11-16 Thread Paul Drake
Hey! that looks like my switch_logfile proc (scheduled with dbms_job), which I still like better than archive_lag_target (except that it only looks at the first character being an 'S') Why generate a log every half hour over the weekend? Pd[EMAIL PROTECTED] wrote: [EMAIL

Re: Oracle 8i DB with Oracle 9i client

2003-11-16 Thread vze1vwnd
I used the 9i client on WinNT and Win2K against 8.1.7.0 on HP-UX 11i for 4 months without a problem. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, November 16, 2003 11:09 AM Dear Gurus, Current versions: DB : 8.1.7.3 Client :

Re: Timed_statistics : Why so many getrusage syscall via truss/strace output?

2003-11-16 Thread zhu chao
Hi, I think I get it. Timed_statistics does have much impact on SYSTEM CALLS. But as system calls CPU utilization is just part of total CPU that the process consumes(more of them are user calls), so, when timed statistics is on, system call increased about 40-50% increasement,but the total

Re: Re[2]: var source_data varchar2(12)

2003-11-16 Thread Carel-Jan Engel
Hi Mladen, At 06:19 12-11-03 -0800, you wrote: SQL*Plus has a ghastly and disgusting user interface, implemented without readline or equivalent, which would give a command history. Littering the system with those @#$%! afiedt.buf files is bad enough but line editting commands are an indicator of

Re: Re[2]: var source_data varchar2(12)

2003-11-16 Thread Mladen Gogala
Carel, I know that. That was my first oracle version. I installed V4 on an IBM PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could each hold 360k of information. Yes, you read it correctly. It was 20 MB hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic card

Re: Test mesg

2003-11-16 Thread Mladen Gogala
Brian, you are bad. On 2003.11.16 17:04, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r 1 select case 2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY') 3 then 'Working from home' 4 else case 5 when

Trace versus Statspack data

2003-11-16 Thread VIVEK_SHARMA
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpu elapsed disk query current