date:20010205


If you are talking about the Universal (Java) Installer, then yes I believe
the installation screen is just the same, there are a few different (read
EXTRA) things you have to with UNIX, but they are all mapped out in the
relevant installation guides.

Regards

-Original Message-
Sent: Monday, February 05, 2001 08:00
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nosie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Async I/O on Windows


Thanks Yong,

Exactly what I was looking for! I'll let you and the list know what it's
like when I'm done..

-Original Message-
Sent: Monday, February 05, 2001 05:15
To: Multiple recipients of list ORACLE-L


Hi, Mark,

David Solomon has written a new book "Inside Microsoft Windows 2000"
(http://www.amazon.com/exec/obidos/ASIN/0735610215/o/qid=981349567/sr=8-1/re
f=aps_sr_b_1_1/107-0770684-3953357).
Regrettably I have not read it. But judging by the technical competence of
the
author as revealed in his excellent "Inside Windows NT", I believe this new
book will not be a disappointment.

However we look at Windows versus UNIX, and Windows users versus UNIX users,
neither of the OS internals is for the faint of heart. Quality of the books
on
them is therefore not to be judged by the quality of the products. I once
wrote
a review on Amazon.com on "Oracle Web Application Server Handbook" titled
something like "Excellent book on a crappy product" (I can't find my review
on
Amazon now for some reason). You get the idea.

Yong Huang
[EMAIL PROTECTED]

you wrote:

Thanks for the reply anyway Yong, I think I will wait for a "good" book on
Win2k to come out (unless you know one?) before I go out and buy one (books

__
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on Unix

2001-02-05 Thread Rajesh Dayal


Yes, this is java based OUI (Oracle Universal Installer).
This is same for all platforms NT, UNIX and even VMS.

Cheers,
Rajesh
-Original Message-
Sent: Monday, February 05, 2001 12:00 PM
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on
unix.
Now, I am trying to use the one on Linux. I see that the installation
screen
is just the same as on NT. Is this also the same with other unix
platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nosie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Automatic Startup instance,Urgent!!!

2001-02-05 Thread Rajesh Dayal


Hi Saroj,

Just create following registry entry in 

HKEY_LOCAL_MACHINE->SOFTEARE->ORACLE

ORA_ORCL_AUTOSTART value  TRUE  (ORCL is SID name)

If you have multiple Oracle Homes then this entry 
should be present in respective Oracle Home only.

You might would have to add another registry entry 
HKEY_LOCAL_MACHINE->SOFTEARE->ORACLE

ORA_STARTUP  value  TRUE  

HTH,
Rajesh

-Original Message-
(CAP,CEF)
Sent: Monday, February 05, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L


Dear All,

  Question is: Oracle will startup automatically when the NT server will
reboot.
   Currently  I maually write the strtup command when the server will
reboot
But in control panel my service "oracle startup SVKH"  is automatic.
Where SVKH is Instance name.

Please tell me where you can do it automatic startup.

Ver: Oracle 8.0.5
OS : Windows NT

Regards,
Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

how can be output of unix man pages converted to text fomat )

2001-02-05 Thread Arslan Bahar



how can be output of unix man pages  converted to text fomat 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

GCC and Proc 8.1.5

2001-02-05 Thread Arslan Bahar



  is there anybody who used successfully  gcc and proc 8.1.5 together 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

CTAS using distributed query

2001-02-05 Thread Sindu


Hi lists,
I have a very strange situation here.

In db A, I have table T1.
In db B, I have table T2.

I'm trying to create table T3 (CTAS) on db B based on join query between
T1 & T2. We tuned the query to use remote view (because T1 is a very huge
table, while T2 is small table), so we create view on db A:

create view T1T2_view as select ... from t1, t2@dbB where ...

and then we can do in db B:
select * from T1T2_view@dbA

This works fine, but when I tried to:
create table T3 as select * from T1T2_view@dbA, it returns no rows.
I also tried precreating T3, and then:
insert into T3 as select * from T1T2_view@dbA, no rows inserted either.
but I can select * from T1T2_view@dbA and I have rows returned.

Finally I'm using SQLPlus
copy from xxx/yyy@dba create t3 using select * from t1t2_view
it works fine.

Why can't I use CTAS? Anybody has similar problem?
We're running 8.0.5.2.1 on Solaris 2.6.

ps. I also have another tables/views similar to above setup, and I can
CTAS on it, but not on the above table only.

regards,
Sindu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sindu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: how can be output of unix man pages converted to text format

2001-02-05 Thread Davies Sue


man SUBJECT > your_file.txt

this will turn the man page output into a file you can ftp to wherever you
want to keep it


Suzanne Davies
Technical Support Officer
London Borough of Barking and Dagenham
020 8227 2737
[EMAIL PROTECTED]




**
CONFIDENTIALITY AND DISCLAIMER
 
This email is confidential to the initial email addressee.
If you are not the intended recipient, please notify the sender
immediately on +44 (0)20 8592 4500 and delete the message
from all locations in your computer network. You should not copy
this email or use it for any purpose, or disclose its
contents to any person : to do so may be unlawful.

Due to the informal nature of this form of communication
the London Borough of Barking and Dagenham (the "Council")
hereby excludes any warranty as to the quality or accuracy
of any information contained in this message and any liability
of any kind for the information contained in it, or for its 
transmission, reception, storage or use in any way whatsoever.
As a result in the absence of prior non-email agreement written 
or otherwise this email does not legally bind the Council to any 
relations or obligations in English or other Jurisdiction law
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Davies Sue
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: how can be output of unix man pages converted to text fomat

2001-02-05 Thread VIVEK_SHARMA



man ls | col -b > ls.man

> -Original Message-
> From: Arslan Bahar [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 2:57 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  how can be output of unix man pages  converted to text fomat
> )
> 
> 
> how can be output of unix man pages  converted to text fomat 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Arslan Bahar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Waits on latch free for shared_pool & library Cache

2001-02-05 Thread VIVEK_SHARMA



Bull's eye . 
Will Check out the Steve Adams' Book & revert
Thanks 

> -Original Message-
> From: yong huang [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 10:30 AM
> To:   [EMAIL PROTECTED]
> Cc:   [EMAIL PROTECTED]
> Subject:  Re: Waits on latch free for shared_pool & library Cache
> 
> Hi, Vivek,
> 
> I can't answer your question. But I know where you get the understanding
> of
> freeabl and perm chunks of shared pool memory (Richard Niemiec, "Oracle
> Performance Tuning", p.615). I don't comment on the overall quality of the
> book
> here but I seriously doubt his explanation of "perm". Steve Adams's note
> says
> "perm: Permanent memory chunks contain persistent objects..." (Steve
> Adams'
> book, p.94)
> 
> Yong Huang
> [EMAIL PROTECTED]
> 
> you wrote:
> 
> > - Waits on Latch Free for shared_pool , Library Cache Phenominally High
> > Qs. What may be Done for the Same ?
> [snipped]
> > freeabl - most probably  stands for the memory that has been used but is
> > freeable
> > perm - most probably stands for the free memory not yet moved to free
> area
> > for use
> 
> __
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem


select empid, empname, dept
   from employees
  where rownum = 3546;

When you are looking for scott..

That is pretty unreliable, and I think that is what Bunyamin(?) was getting
at..

Regards

Mark

-Original Message-
Sent: Sunday, February 04, 2001 02:40
To: Multiple recipients of list ORACLE-L


I agree with your solution.
But why, using a ronum on a single select statement may not be reliable ?

Mark Leith wrote:

> In this case, the rownum should not be a problem when using it in a sub
> select? You are only trying to get the first seven rows from the sub
> select.. Whats the problem?
>
> Fair enough, using a rownum on a single select may not be reliable, but in
> this case it should work like a charm..
>
> -Original Message-
> K.Karadeniz
> Sent: Thursday, February 01, 2001 12:31
> To: Multiple recipients of list ORACLE-L
>
> No, No not for this statement , my group leader tells that rownum is not
> used so much in applications becouse it can give wrong results sometimes.
I
> do not know if it is correct . I ask you for approve him or not..
>   Thanks
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 1:25 PM
>
> paresh mehta,
> what was wrong with the sql-statement using 
>
> It works perfeclty, or am I wrong ??
>
> regards
>
> > Frank Foelz <
> _
> Scheidt & Bachmann GmbH
> Gestaltung Parkhaussysteme
> Breite Strasse 132
> 41238 Moenchengladbach
>
> Phone  :  ++49 2166 / 266 - 837
> Fax:  ++49 2166 / 266 - 615
> e-mail :  mailto:[EMAIL PROTECTED]
> 
> URL:  http://www.scheidt-bachmann.de 
> 
>
> -Ursprüngliche Nachricht-
> Von: Local Folders [mailto:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 1. Februar 2001 08:35
> An: Multiple recipients of list ORACLE-L
> Betreff: ***Problem***
>
> Consider the following case.
> TABLE : DEPT
> empid number,
> deptid number,
> deptnamevarchar2(30)
> primary key (empid, deptid)
>
> now i want to fetch first seven records from a cursor whose deptid is
> maximum
> and empid is minimum. kindly let me know how to write this cursor
> statement.for example.
>
> SQL> select deptid, empid from dept;
>
>  DEPTID   EMPID
> -   -
> 2 94204
> 2 94205
> 2 94206
> 2 94207
> 2 94208
> 5 94209
> 5 94210
> 5 94211
> 5 94212
> 5 94213
> 7 94214
> 7 94215
> 7 94216
> 7 94217
> 7 94218
>
> 15 rows selected.
>
> i want output as following by single query.
>
>  DEPTID   EMPID
> -  -
> 7 94214
> 7 94215
> 7 94216
> 7 94217
> 7 94218
> 5 94209
> 5 94210
>
> 7 rows selected
>
> kindly reply.. thanks in advance.
>
> regards
> paresh mehta
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Foelz.Frank
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bunyamin K.Karadeniz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing:

Re: Problem

2001-02-05 Thread Bunyamin K.Karadeniz


Yes , Jusy As you say,Mark ..
Thanks.
  Using =  seems unreliable to use.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 1:41 PM


select empid, empname, dept
   from employees
  where rownum = 3546;

When you are looking for scott..

That is pretty unreliable, and I think that is what Bunyamin(?) was getting
at..

Regards

Mark

-Original Message-
Sent: Sunday, February 04, 2001 02:40
To: Multiple recipients of list ORACLE-L


I agree with your solution.
But why, using a ronum on a single select statement may not be reliable ?

Mark Leith wrote:

> In this case, the rownum should not be a problem when using it in a sub
> select? You are only trying to get the first seven rows from the sub
> select.. Whats the problem?
>
> Fair enough, using a rownum on a single select may not be reliable, but in
> this case it should work like a charm..
>
> -Original Message-
> K.Karadeniz
> Sent: Thursday, February 01, 2001 12:31
> To: Multiple recipients of list ORACLE-L
>
> No, No not for this statement , my group leader tells that rownum is not
> used so much in applications becouse it can give wrong results sometimes.
I
> do not know if it is correct . I ask you for approve him or not..
>   Thanks
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 1:25 PM
>
> paresh mehta,
> what was wrong with the sql-statement using 
>
> It works perfeclty, or am I wrong ??
>
> regards
>
> > Frank Foelz <
> _
> Scheidt & Bachmann GmbH
> Gestaltung Parkhaussysteme
> Breite Strasse 132
> 41238 Moenchengladbach
>
> Phone  :  ++49 2166 / 266 - 837
> Fax:  ++49 2166 / 266 - 615
> e-mail :  mailto:[EMAIL PROTECTED]
> 
> URL:  http://www.scheidt-bachmann.de 
> 
>
> -Ursprüngliche Nachricht-
> Von: Local Folders [mailto:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 1. Februar 2001 08:35
> An: Multiple recipients of list ORACLE-L
> Betreff: ***Problem***
>
> Consider the following case.
> TABLE : DEPT
> empid number,
> deptid number,
> deptnamevarchar2(30)
> primary key (empid, deptid)
>
> now i want to fetch first seven records from a cursor whose deptid is
> maximum
> and empid is minimum. kindly let me know how to write this cursor
> statement.for example.
>
> SQL> select deptid, empid from dept;
>
>  DEPTID   EMPID
> -   -
> 2 94204
> 2 94205
> 2 94206
> 2 94207
> 2 94208
> 5 94209
> 5 94210
> 5 94211
> 5 94212
> 5 94213
> 7 94214
> 7 94215
> 7 94216
> 7 94217
> 7 94218
>
> 15 rows selected.
>
> i want output as following by single query.
>
>  DEPTID   EMPID
> -  -
> 7 94214
> 7 94215
> 7 94216
> 7 94217
> 7 94218
> 5 94209
> 5 94210
>
> 7 rows selected
>
> kindly reply.. thanks in advance.
>
> regards
> paresh mehta
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Foelz.Frank
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bunyamin K.Karadeniz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>

Oracle startup script for Solaris

2001-02-05 Thread Johan [EMAIL PROTECTED] Services


Has anybody have a automatic startup script for oracle on Solaris? I.e.,
when the box is bounced, the database & listeners can start up automatically

Kind Regards
Johan Locke
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle startup script for Solaris

2001-02-05 Thread lerobe - Lee Robertson


Look in $ORACLE_HOME/bin. dbstart and dbshut will get you there.

> Lee Robertson
> Acxiom
> Tel:  0191 525 7344
> Fax:  0191 525 7007
> Email: [EMAIL PROTECTED]
> 


-Original Message-
Sent: 05 February 2001 11:20
To: Multiple recipients of list ORACLE-L


Has anybody have a automatic startup script for oracle on Solaris? I.e.,
when the box is bounced, the database & listeners can start up automatically

Kind Regards
Johan Locke
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lerobe - Lee Robertson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle startup script for Solaris

2001-02-05 Thread Johan [EMAIL PROTECTED] Services


Thank you!

Kind Regards
Johan

-Original Message-
Sent: Monday, February 05, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L


Look in $ORACLE_HOME/bin. dbstart and dbshut will get you there.

> Lee Robertson
> Acxiom
> Tel:  0191 525 7344
> Fax:  0191 525 7007
> Email: [EMAIL PROTECTED]
> 


-Original Message-
Sent: 05 February 2001 11:20
To: Multiple recipients of list ORACLE-L


Has anybody have a automatic startup script for oracle on Solaris? I.e.,
when the box is bounced, the database & listeners can start up automatically

Kind Regards
Johan Locke
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lerobe - Lee Robertson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Upgrading Scheme versions

2001-02-05 Thread Ronen Levit


Hi all,

We've developing using Oracle8i and Designer2000 tools.

We've got one major scheme and need a methodology for updating the installed
version with scripts.

For example - 

I have my product version 1.0 installed and I want to upgrade it to version
2.0.

I have scripts created by the designer to create clean new version 2.0, but
don't have any scripts to perform an upgrade.

Do you have any methodology for doing upgrades between versions?

Thnx,

Ronen Levit
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ronen Levit
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT:Thunderstone.com: Texis

2001-02-05 Thread Koivu, Lisa

Title: OT:Thunderstone.com:  Texis





Good morning all - 


Anyone using this product?  If so please email me directly. 


(Yes, I am still employed and $50 poorer.  It's only money...)


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com


"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.


I have a public database link defined with userid-1.
Userid-1 has update permissions on table-a in database-b.
Userid-2 has no permissions on table-a in database-b.
Userid-2, in database-a, calls a package that contains the database link and
tries to update table-a in database-b.
The result is an Oracle error that states insufficient privileges on
table-a.

Can anyone help?

Ron Smith
Database Administration
[EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Thunderstone.com: Texis

2001-02-05 Thread Kathy Duret

Title: OT:Thunderstone.com: Texis



Yes I 
have somewhat, context searches are fast. 
 
You 
need to keep three copies of the data and indexes (things get corrupted 
easily).   If you do alot of updates, you will have the rebuild the 
tables and/or redo the indexes all of the time.  
 
But it 
is cheap, fast and pretty easy but can be high maintenance.
 
Kathy

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Monday, February 05, 2001 5:35 AMTo: Multiple recipients of list 
  ORACLE-LSubject: OT:Thunderstone.com: Texis
  Good morning all - 
  Anyone using this product?  If so please email 
  me directly. 
  (Yes, I am still employed and $50 poorer.  
  It's only money...) 
  Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 
  7 Suite G104 Fort Lauderdale, FL  33319 
  V: 954.484.3191, x174 F: 954.484.2933 C: 
  954.658.5849 http://www.qode.com 
  "The information contained herein 
  does not express the opinion or position of Qode.com and cannot be attributed 
  to or made binding upon Qode.com."

Re: Need help - Database link - Please!!

2001-02-05 Thread Ruth Gramolini


You should set up synonyms which define the tables@public_dblink in database
b. Put these synonyms in database a. Then anyone can use the linked tables
from the package in database a.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 8:35 AM


> I have a public database link defined with userid-1.
> Userid-1 has update permissions on table-a in database-b.
> Userid-2 has no permissions on table-a in database-b.
> Userid-2, in database-a, calls a package that contains the database link
and
> tries to update table-a in database-b.
> The result is an Oracle error that states insufficient privileges on
> table-a.
>
> Can anyone help?
>
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:Oracle Vs Tera Data

2001-02-05 Thread dgoulet


Surjit,

I think your "hardcore Tera Data" fans are also bigots.  I've a friend at
Fidelity Investments where they swear by SUN & Oracle.  The last time I talked
to him their datawarehouse was fast approaching 2PB without any problems.  They
use all of 8i's datawarehousing stuff like partitioning, hash & star joins,
etc... and haven't had a single problem.  Now if an investment banker can be
happy, why can't your bigots???

There are two basic problems with data warehouses that I've seen & it should
be noted that I'm in the middle of specing a re-wtite of ours.  1) people create
then in a normalized manner, not in the idea of a series of stars.  COnsequently
you end up with too much data in a single table making that table a real bear to
manage.  2) end users have this ungodly desire for speed.  My GOD, if your
searching through 2 or 3 billion rows of data of course it's going to take a
while.

Dick Goulet

Reply Separator
Author: "Surjit Sharma" <[EMAIL PROTECTED]>
Date:   2/4/2001 4:15 PM


All

I wonder if anyone out there has faced the same dilemma as I am facing
currently. Our database is likely to grow to a couple of Tera bytes.  The
existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6
and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data
fans that Oracle can't do the following:

   Start schema in Oracle is not suitable for datawarehouses.
   Oracle is not scalable to deal with Tera bytes databases.
   Oracle partitioning is not good enough to do the job.

I feel  that Oracle has been working fine on a Sun box with about 200-300
Gig of data.
What is the price/performance of say a Sun Box vs Tera Data. I am sure
there is a huge difference.

I appreciate your valuable thoughts.

Regards

Surjit

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Surjit Sharma
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT NT2K vs Unix.

2001-02-05 Thread Holman, Rodney


We aren't doing any db work on the Linux platform YET, but we do run one of
our mission critical apps on  Red Hat.  We have an app that dials every
hotel that we are installed in every night to bring back our
movie/game/service buys and the navigation summary stats from them.  This
process was running on FreeBSD until about a year ago when we upgraded the
hardware and moved it to Linux.  Runs without a hitch.  I think we rebooted
the box once during the year because of a flaky power supply.  We also run
our web based system monitoring stuff on Red Hat on a Gateway 200Mhz desktop
box we scrounged out of the trash (no capital for behind the scenes things
like this).  It also runs like a champ.  Reboots what are those?  Linux
ROCKS!  About half of the DBA/SA's in our group are running it as their
desktop and using VMWare for the Windows stuff that we have to run because
of Corp Directives - MS Exchange :(  Don't be afraid to go with it.

Rodd Holman

-Original Message-
Sent: Friday, February 02, 2001 3:53 PM
To: Multiple recipients of list ORACLE-L


I'll be interested to see the replies on this one.  We've just embarked on a

new project that will be using Oracle 8.1.7 on RedHat Linux.  Also using 
Oracle 9i AS (with Java stuff) on Linux as well.  Production is slated for 
July timeframe.  It is for a scheduling system that is at the heart of a 
medium-sized business.  This is our first foray with Linux for a critical 
system.  We do have a small web-based survey system that has been running
for 
a year on RedHat Linux with Oracle (just upgraded to 8.1.7) and it's working

very nicely.

Marc Perkowitz
MTP Systems Consulting

In a message dated 2/2/2001 2:45:53 PM Central Standard Time, 
[EMAIL PROTECTED] writes:

<< But, if you all let me return this thread back to a real discussion.  How

many
 of you out there are using Linux, particularly RedHat, in a production
 environment preferably with Oracle?  The boss(s) around here are looking
for 
a
 more "cost efficient" (read that as $0.00) operating system for some of our

DB
 stuff.  We may even decide on a more "cost efficient" (same translation) 
rdbms,
 otherwise known as PostGreSQL.
 
 Dick Goulet
  >>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:Oracle Vs Tera Data

2001-02-05 Thread bill thater


On Mon, 5 Feb 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

->There are two basic problems with data warehouses that I've seen & it should
->be noted that I'm in the middle of specing a re-wtite of ours.  1) people create
->then in a normalized manner, not in the idea of a series of stars.  COnsequently
->you end up with too much data in a single table making that table a real bear to
->manage.  2) end users have this ungodly desire for speed.  My GOD, if your
->searching through 2 or 3 billion rows of data of course it's going to take a
->while.

i'm currently fighting with damagement over the same issues.  "no
datawrehousing is not the same as creating a production database."  "no i
can't get the warehouse to run as fast as the production database and do it
right."

repeat the above two statments several times a day.;-)

--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~
"We are different, in essence from other men.
If you want to will something run 100m.
If you want to experience something run a marathon"
Emil Zatopek
~
How do I love thee?  My accumulator overflows.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ora-07445

2001-02-05 Thread achoto


I posted a question to the list last week regarding this error and didn't
get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
Solaris 6.

A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server.  If we shutdown/restart the
database the errors went away.  Starting Friday the errors are happening
when shutting down/starting up the db.  We shutdown the db at midnight and
start it at 2:15 am every day.  We get lots of core dumps and trace files
filling up the file system.  We clean up the files and start the db, after
that we don't receive the errors anymore until next stop/start the db.

I have submitted a tar to Oracle support, but so far they haven't come up
with a solution or a cause for this.  We made the changes they suggested
but it didn't help.  Sun suggested some changes to the hardware, but it
hasn't help either.

Can anyone out there provide some insights on this?  Here is one of our
trace files:

Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
System name:SunOS
Node name:  auoracle1
Release:5.6
Version:Generic_105181-23
Machine:sun4u
Instance name: ORTE
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 4674, image: oracleORTE

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x626c6568, PC: lxdgetobj()+60
*** 2001.02.05.09.20.39.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
- Call Stack Trace -
calling  call entryargument values in hex
location type point(? means dubious value)
  


Thanks

Ana E. Choto
American University
Washington, DC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:OT:Thunderstone.com: Texis

2001-02-05 Thread dgoulet


I owe, I owe
so off to work I go.


Dick Goulet

Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   2/5/2001 5:35 AM

Good morning all - 

Anyone using this product?  If so please email me directly. 

(Yes, I am still employed and $50 poorer.  It's only money...)

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com

"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."






OT:Thunderstone.com:  Texis



Good morning all - 


Anyone using this product?  If so please email
me directly. 


(Yes, I am still employed and $50 poorer. 
It's only money...)


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com"
TARGET="_blank">http://www.qode.com


"The information contained
herein does not express the opinion or position of Qode.com and cannot be
attributed to or made binding upon Qode.com."



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Who wants to build a tablespace...

2001-02-05 Thread Rocky Welch

A little more detail:
I'm setting up a new application database for a customer who has hired a full-time dba. This system is on a Sun 4500 cluster with 2 D1000 disk arrays. This database will be no bigger than 50 gig with no more than 50 concurrent users. The full-time DBA inisists on 1 3gig datafile for the application (how he came up with that number I don't know) for reasons that there is less fragmentation. There is on large volume of 50gig which is striped and mirrored and a smaller 15gig concatnated and mirrored volume for the redo logs. Any thoughts?
TIA,
-Rocky
Gary Weber <[EMAIL PROTECTED]> wrote:

3 Gb is not all that big. What platform is this on, can it handle larger files? Why is 3 Gb chosen as size below, as opposed to 2 or 4? What is your backup window, if any, and required recovery time?
Fwiw, I have one of the databases (DW) on HPUX 64bit with 4 and 6 Gb datafiles, residing happily on EMC Symmetrix...
Gary Weber
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSent: Friday, February 02, 2001 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: Who wants to build a tablespace...
The question is...One BIG datafile (3 gig) or multiple smaller datafiles.
You still have audience or phone a friend...your final answer?
-Rocky

Do You Yahoo!?- Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year! Do You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address - only $35
a year!

RE: RE: controlfile schema global enqueue lock

2001-02-05 Thread Joan Hsieh


Steve,

Thank you so much for taking time to reply. I did run couple of times the
enque_lock script as you suggested. CF waiting is really minimum. I noticed
the maximum enqueue comes from MR which is Media Recovery in share lock.
Should I need to concern this or this is just a very normal symptoms for the
database nature?
The real exclusive lock comes from TX. Right now I am starting to look into
it.

MR-8-02   S  0
MR-80-0   2   S 335666
MR-81-0   2   S 335238
MR-82-0   2   S 334850
MR-83-0   2   S 334473
MR-84-0   2   S 334094

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
MR-85-0   2   S 333672
MR-86-0   2   S 333131
MR-87-0   2   S 332593
MR-88-0   2   S 331998
MR-89-0   2   S 331386
MR-9-02   S  0
MR-90-0   2   S 330764
RT-1-03   X  0
TM-2750-0  1459  SX   1262
406  SX987
987  SX968

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
TM-2750-0  1474  SX957
462  SX411
286  SX336
TM-3196-0  1318  SX  0
TS-3-16866818 5  SX 332462
TX-1048594-158974  1208   X  1
TX-1048595-158908  1170   X  0
TX-1048640-159199   475   X  1
TX-1835008-159738  1474   X957
TX-1835015-159892  1172   X 64


Thanks,

Joan


-Original Message-
Sent: Friday, February 02, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L


Hi Joan,

This filtered into my Inbox folder because you mentioned my name. I've not
been
following the thread, but I'll comment on the output below.

Normally when seeing CF and ST enqueue waits and a lot of time spent in
'enqueue' waits I would suspect the ST enqueue to be the problem, rather
than
the CF enqueue. CF enqueue waits are seldom longer than half a second or so.
The
typical situation is one session doing a controlfile transaction and others
waiting to read the controlfile. It is relatively rare to need to make two
independent changes to the controlfile at the same time. By contrast, the ST
enqueue is held for many seconds when it is taken, and the waiters always
want
an exclusive lock too.

I suggest that you get a few samples of the enqueue waits using my
'enqueue_locks.sql' script. The new version reports the name of any
background
process involved rather than just its sid, which might be helpful here. You
may
also want to hack the script so that it only shows ST and CF enqueues. Then
run
it intermittently until you see something interesting. Then run it several
times
in quick succession to see what happens. If I'm right you see that the CF
waits
are relatively brief, whereas the ST lock contention will be relatively
enduring. If so, I'm sure you'll know what to do.

If it is the CF enqueue that is the source of most of the waits, then
knowing
which sessions are the holders and waiters will be a help in further
diagnosis
anyway.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 2:21
To: Multiple recipients of list ORACLE-L


Dick,
The system is not in archivelog mode. If the database crashed, I was told
they don't care at all. They just rebuilt a shell database and let getter
and feeder processes gradually feed the database. (The getter will check the
url in the database, if didn't find then will go to the origin server to get
the url) Of course, it will impact the performance. The end user at that
region will experienced the slow access. We just have 5 tables, spilt into
22 separate raw disks. No i/o problem at all. Now the problems is where is
control file enqueue come from? I thought since we have too many log switch
can cause the cf enqueue problem. But that is not true either. Right now we
don't have too many 4 per hr. still have the enqueue problem. We did'nt set
any slave parameter. Oh, we set parallel_max_servers to 5, all the tables
have 50 freelist and we have 8 getter and feeder processes running all the
time.

I run couple Steve Adams scripts,

SQL> @enqueue

RE: Thanks and another book request


Yeah, but look at the cost of living.  Salary
does tend to be reflective how much it costs
to live in that city.

-Original Message-
Sent: Sunday, February 04, 2001 9:36 PM
To: Multiple recipients of list ORACLE-L


Rachel,
$150/hour is an average? Dang, I need to get out of
Kansas City and move to NYC.

Gunawan

--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Djordje,
> 
> the $5 was for each book sold. not per hour.
> 
> My rate (before the book) was  more than the
> average.
> The $150/hour is really an average, I know people
> getting more than that 
> and they haven't written a book, or done lots of
> presentations etc.  NY is a 
> higher paying market.
> 
> And in any case, even at $10/hour, it's still NOT
> worth spending the time 
> writing instead of consulting.
> 
> And the real question is, since  I write in my
> limited, minimal spare time, 
> what is the value per hour of THAT time? Time not
> spent with family and 
> friends, or doing the things that feed my soul?
> 
> Rachel
> 
> >From: "djordjej" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: Re: Thanks and another book request
> >Date: Sat, 03 Feb 2001 23:45:21 -0800
> >
> >Hi Rachel,
> >
> >I definitively believe that the prime drive for
> writing a book must come
> >from the love to teach, to help other people and
> share some of the
> >experience and knowledge that you came to the hard
> way with others.  And I
> >agree that one should not think of writing a book
> to make money.
> >
> >But for the math you did to be fair, I guess it
> should be mentioned that
> >having a name on a good book also helps to reach
> $150 per hour.  I would 
> >not
> >say that this is an average that a
> >senior/experienced/expert/knowledgeable/... DBA
> gets even in NY ?   If the
> >name on the book can bring this number up by at
> least, say $10/hour, this
> >changes your math by at least $1600*10 = $16,000. 
> Am I right in this
> >assumption?
> >
> >Djordje
> >
> >- Original Message -
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Sent: Friday, February 02, 2001 8:05 PM
> >
> >
> > > well, let's do the math.
> > >
> > > let's say I get $5 for each book that is sold (I
> don't, and the 
> >royalties
> > > change depending on if the book has sold at full
> price or from a 
> >discount
> > > house)  but the $5 makes the math easier
> > > (and it's less than minimum wage in the US!)
> > >
> > >
> > > let's round the numbers, and say that an
> independent DBA consultant can
> >earn
> > > $150/hr in New York, where I live. (That's an
> average, some make more,
> >some
> > > less)
> > >
> > > and 150/5 = 30  so I'd have to work 30 times as
> many hours writing books
> >as
> > > I would as a consultant to make the same amount
> of money
> > >
> > > Most personnel departments assume that there are
> 200 workdays in a year
> > > (vacation, weekends and holidays excluded), and
> that a workday is 8 
> >hours
> > > long. Yes, I know no DBA works a 40 hour week,
> this is just an example.
> > >
> > > so 200*8 = 1600 hours work in a year.
> > >
> > > 1600/500= 3.2 books a year and 1600*5=$8000 a
> year
> > >
> > > 1600*150=$240,000
> > >
> > > don't know about you, I'd rather be a
> consultant!
> > >
> > > I repeat -- you don't make money writing books,
> and if that is why you 
> >are
> > > writing them, you'd be better off just
> consulting. Even if you write in
> >your
> > > "spare time", you lose -- I worked evenings, and
> all day all weekend
> > > writing. I didn't see my friends or family for
> the time I was writing.
> > >
> > >
> > > Oh, and since my name does show up when my
> messages post, so it's easy 
> >to
> > > see how it is spelled
> > >
> > > it's Rachel, not Rachael
> > >
> > >
> > > >From: "orclbabu" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > > >Subject: Re: Thanks and another book request
> > > >Date: Fri, 02 Feb 2001 12:32:11 -0800
> > > >
> > > >Rachael
> > > >
> > > > > consultant for that number of hours Not
> profitable to write one.
> > > >
> > > >The very fact that you often repeat this in
> response to mails that 
> >refer
> >to
> > > >your books, makes us think otherwise $$$
> > > >
> > > >;-)
> > > >
> > > >babu
> > > >
> > > >--
> > > >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > >--
> > > >Author: orclbabu
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > > >San Diego, California-- Public Internet
> access / Mailing Lists
> > >
>
>
> > > >To REMOVE yourself from this mailing list, send
> an E-Mail message
> > > >to: [EMAIL PROTECTED] (note EXACT spelling
> of 'ListGuru') and in
> > > >the message BODY, include a line containing:
> UNSUB ORA

Oracle SQL: The Essential Reference

2001-02-05 Thread Glenn Travis



I just got a solicitation for this book:

Oracle SQL: The Essential Reference

Reviews anyone?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Travis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ora-07445

Title: RE: ora-07445





you show a file from your udump.


what is in your bdump? including your alert log.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject: ora-07445



I posted a question to the list last week regarding this error and didn't
get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
Solaris 6.


A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server.  If we shutdown/restart the
database the errors went away.  Starting Friday the errors are happening
when shutting down/starting up the db.  We shutdown the db at midnight and
start it at 2:15 am every day.  We get lots of core dumps and trace files
filling up the file system.  We clean up the files and start the db, after
that we don't receive the errors anymore until next stop/start the db.


I have submitted a tar to Oracle support, but so far they haven't come up
with a solution or a cause for this.  We made the changes they suggested
but it didn't help.  Sun suggested some changes to the hardware, but it
hasn't help either.


Can anyone out there provide some insights on this?  Here is one of our
trace files:


Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
System name:    SunOS
Node name:  auoracle1
Release:    5.6
Version:    Generic_105181-23
Machine:    sun4u
Instance name: ORTE
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 4674, image: oracleORTE


Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x626c6568, PC: lxdgetobj()+60
*** 2001.02.05.09.20.39.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
- Call Stack Trace -
calling  call entry    argument values in hex
location type point    (? means dubious value)
  



Thanks


Ana E. Choto
American University
Washington, DC


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.


I'm sorry.  The error is not that the user cannot use the database link.
The error is that Oracle does not want the user to update table-a in
database-b even though the user has update permissions.

Ron

-Original Message-
Sent: Monday, February 05, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L


You should set up synonyms which define the tables@public_dblink in database
b. Put these synonyms in database a. Then anyone can use the linked tables
from the package in database a.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 8:35 AM


> I have a public database link defined with userid-1.
> Userid-1 has update permissions on table-a in database-b.
> Userid-2 has no permissions on table-a in database-b.
> Userid-2, in database-a, calls a package that contains the database link
and
> tries to update table-a in database-b.
> The result is an Oracle error that states insufficient privileges on
> table-a.
>
> Can anyone help?
>
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Index Usage Monitoring

2001-02-05 Thread Vadim Gorbounov


Hi, 
Why not to use otrace? Of cource, you may need some space to save
trace results, but you'll definitely get complete statistics.

Vadim Gorbounov
Oracle DBA

-Original Message-
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L


We have a purchased application with over 1,300 indexes.

Can someone suggest a method to monitor the system to
determine which indexes are actively being used over time?  I'm assuming
that some are old/not necessary and would like to save the overhead
of maintaining them.

Oracle 8.0.6


 Patrick Prince   email: [EMAIL PROTECTED] 
 Omaha Public Power District   voice: (402) 636-3762 
 444 S 16th St. Mall, Omaha, NE 68102fax: (402) 636-3931  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: PRINCE, PATRICK W.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

User objects in System tablespace

2001-02-05 Thread Sanjay Kumar




Hi,
 
I have a situation where in all the user related 
objects (tables) have been created in System tablespace.
 
I believe there is no convention followed while 
creating these tables. 
 
Now, how do I separate these user related objects 
and put them in Users tablespace?
 
Vinay

Pinning Tables

2001-02-05 Thread Kevin Kostyszyn


Hi all,
I have been trying to find some reference on pinning tables in the SGA.  I
haven't found anything, all that I am finding is table caching and the keep
buffer pool.  Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Async I/O on Windows

Title: RE: Async I/O on Windows

It may well be as you said, because Oracle Corporation thinks grouping all
Oracle "processes" into one OS process makes it run faster on NT. But I'd like
to see some kind of official answer from Oracle.

|| I do not have the ability or inclination to make this kind of information
up. I got my information from OWS directly. You are free to do your own
research, of course.

Multithreaded Oracle.exe has its own problem. For example, if one thread breaks, the
entire process hangs or dies.

|| Definitely not true. Cite a source, can you? Do you mean to assert that if a
user connection thread breaks, the entire database system hangs?No, I didn't think
soNow, on the other hand, if the PMON thread dies, then the instance goes down, yes.
Just like on Unix, and just exactly the way it should be.

It probably makes sense to bundle all essential background "processes" into one
process because if one of them dies, it's meaningless to have all the others
continue running. But server "processes" running on behalf of user programs as
well as non-essential Oracle background "processes" are also part of oracle.exe,
aren't they? Wouldn't Oracle make a decision to favor stability over performance,
in view of the generally accepted instability of NT?

|| See above. There is the thought inside oracle ( from the note i read 46000.1 and
46053.1 ) that thread mgmt is faster and more stable than process mgmt. As for
your assertion of a "generally accepted instability of NT"..

BTW, NT also supports shared memory and of course context switches but may be
inferior to the counterparts on UNIX (I don't know).

|| NT may well support it. That was not the topic of the post. ORACLE on NT does not need it,
nor does it use it.

I made a mistake in my previous message saying "Oracle on NT runs as one
thread". I meant "one process".

|| Ayup.

Re: ora-07445

2001-02-05 Thread Mike Killough


Did you try re-running catalog and catproc and then recompiling invalid 
objects? We were getting ora-7445 errors on one of our databases last week, 
and this fixed it.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: ora-07445
>Date: Mon, 05 Feb 2001 06:55:26 -0800
>
>I posted a question to the list last week regarding this error and didn't
>get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
>Solaris 6.
>
>A few days ago we started receiving ora-07445 errors in the alert log.
>This happened when had to reboot the server.  If we shutdown/restart the
>database the errors went away.  Starting Friday the errors are happening
>when shutting down/starting up the db.  We shutdown the db at midnight and
>start it at 2:15 am every day.  We get lots of core dumps and trace files
>filling up the file system.  We clean up the files and start the db, after
>that we don't receive the errors anymore until next stop/start the db.
>
>I have submitted a tar to Oracle support, but so far they haven't come up
>with a solution or a cause for this.  We made the changes they suggested
>but it didn't help.  Sun suggested some changes to the hardware, but it
>hasn't help either.
>
>Can anyone out there provide some insights on this?  Here is one of our
>trace files:
>
>Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
>Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
>PL/SQL Release 8.0.5.2.0 - Production
>ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
>System name:SunOS
>Node name:  auoracle1
>Release:5.6
>Version:Generic_105181-23
>Machine:sun4u
>Instance name: ORTE
>Redo thread mounted by this instance: 1
>Oracle process number: 35
>Unix process pid: 4674, image: oracleORTE
>
>Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
>addr: 0x626c6568, PC: lxdgetobj()+60
>*** 2001.02.05.09.20.39.000
>ksedmp: internal or fatal error
>ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
>[Address not mapped to object] [1651271016] [] []
>- Call Stack Trace -
>calling  call entryargument values in hex
>location type point(? means dubious value)
>  
>
>
>Thanks
>
>Ana E. Choto
>American University
>Washington, DC
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Killough
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OEM/IA and DB shutdown

2001-02-05 Thread Jesse, Rich


So, there I am, with an HP/UX server hosting 3 production Oracle DBs.  The
node is also running Oracle Intelligent Agent, and I have OEM events to
e-mail/page me if there's problems with productions DBs and servers.

Anyone else running something similar?  How do you shutdown a single
production DB without causing OEM to freak?

If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs and
node being unavailable.  If I SHUTDOWN NORMAL the production DB, like a good
DBA, I need to manually kill the DBSNMP processes that are still connected.
If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN
NORMAL), can the DBSNMP process still connect?

I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes, but
that somehow just seems hokey to me.

Anyone?

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

Title: RE: Async I/O on Windows



WHOOO a SQLServer vs. Oracle debate 
again!!
 
Come 
on guys in the field, lets hear you comments from all those using both in the 
field. I personally have been trained in administration on both, and - like you 
Ross - have to agree that Oracle is my personal favourite, though SQLServer DOES 
perform better on my machine here...
 
In 
terms of admin costs etc. SQLServer does kick ass, and still has all those 
pointy clicky admin wizards - That Oracle is apparently getting with 9i - and 
have attempted quite poorly with OEM. 
 
Bet 
the guy in the Nova will NEVER beat me in my H reg Cavalier with FLUFFY DICE IN 
THE WINDOW!!! When they swing they add to my forward 
momentum!!
 
Mark

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Monday, February 05, 2001 03:56To: Multiple recipients of list 
  ORACLE-LSubject: OT RE: Async I/O on Windows
  "NT 
  still pants"...LOL!!! 
   
  It must be 
  panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running 
  
  SQLServer on NT, as has DB2. 
   
  The 
  general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.  
  Check out the Top Ten TPC-C marks, by pure performance. 
  
   
  Not 
  interested in pure peformance?  Check out the Price/Performance leaders. 
  Oracle doesn't
  even 
  SHOW UP in the top ten. What a shocker, eh? It's painful to lose our 
  illusions
   
  Oh, 
  what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out 
  ANY
  of 
  the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even 
  show
  up. 
  
   
  I 
  mean, I like Oracle, too, butby the time you turn on the multimode 
  airconditioner, use 
  the 
  12-way adjustable power bucket seats, activate the object-oriented 
  OnStar Satellite 
  navigational system, power up the heated 
  side view mirrors and all the other tools, trinkets, 
  and 
  toys that make it my personal favorite database, there *is* the 
  chance that the 
  twenty year old genius mechanic in the the tricked out 
  Nova next to you at the light is going 
  to 
  kick your ass when the light turns 
  green.
   
  But 
  really, I still love Oracle. Warts and all. 
   
  Wanna drag?
   
  (heh 
  heh heh)

OT RE: Async I/O on Windows

Title: RE: Async I/O on Windows

"NT
still pants"...LOL!!!
It must be panting alot, It has BLOWN THE DOORS
OFF of "Oracle on Unix" in running
SQLServer on NT, as has DB2.
The
general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.
Check
out the Top Ten TPC-C marks, by pure performance.

Not
interested in pure peformance? Check out the Price/Performance leaders.
Oracle doesn't
even
SHOW UP in the top ten. What a shocker, eh? It's painful to lose our
illusions
Oh,
what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out
ANY
of the
TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even
show
up.

I
mean, I like Oracle, too, butby the time you turn on the multimode
airconditioner, use
the
12-way adjustable power bucket seats, activate the object-oriented
OnStar Satellite
navigational system, power up the heated
side view mirrors and all the other tools, trinkets,
and
toys that make it my personal favorite database, there *is* the chance that
the
twenty
year old genius mechanic in the the tricked out
Nova next to you at the light is going
to
kick your ass when the light turns green.
But
really, I still love Oracle. Warts and all.
Wanna
drag?
(heh
heh heh)

-Original Message-From: Mark Leith
[mailto:[EMAIL PROTECTED]]Sent: Saturday, February 03, 2001
6:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Async I/O on Windows
I
have actually been doing a fair it of reading on this since the topic was
brought up, and stand corrected, as earlier mentioned. But I have to say guys
that NT is still fairly "pants" when it comes to handling multi threaded
processes.. Win2K is a great improvement but M$ still has a lot of work to do
on in my view. (only when you compare this against UNIX)
Now
don't get me wrong, there is enough traffic on this list about this at the
moment, so I dont want more bandwith added with this thread if at all possible
:)
Thanks for the reply anyway Yong, I think I will wait
for a "good" book on Win2k to come out (unless you know one?) before I go out
and buy one (books come out of my pocket as I am a sales person mostly)..
NT as far as I am concerned is now in Win2K's shadow, and I think that is the
way of the future for Windowze bound people.
For
all out there that have used NT and not Win2K - TRY IT.. Services are handled
a LOT better, file management and sharing.. All sorts of new fun stuff to sink
your teeth in to..
As a
side note, for the last line of my first paragraph - I also feel that UNIX
cannot be compared in anyway to Windows at this time. Windowze O/S's are
designed for pointy clicky people that prefer to look at a nice GUI interface,
and generally don't have the indepth technical knowledge that a good UNIX sys
admin does..
(If
there any NT admins out there don't flame me, I have to deal with it every day
of my life...)
Regards
Mark
The
views expressed here are soley those coming out of my coffee deprived hungover
mind.. They do not express those of my employers, though I'm sure they agree
:^)

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Friday, February 02, 2001 07:00To: Multiple recipients of list
ORACLE-LSubject: RE: Async I/O on Windows
Oracle on NT runs as
ONE PROCESS
with
MULTIPLE THREADS
for performance reasons (no more need for shared memorycontext switches are a LOT less expensive, etc.)
-Original Message- From:
yong huang [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: Async I/O on Windows
Hi, Mark,
Async I/O is available on Windows, at least NT. It's not an
easy topic. If you think you already know enough
about operating systems in general, I suggest you read David Solomon's "Inside WindowsNT". For a lab test, launch
Performance Monitor on your NT box and look at the
counters for Cache.
I'm not sure by "single thread management" whether you mean
NT can't have multiple processes or Oracle on NT
runs as one thread. The former is obviously wrong.
The latter is a design issue inside Oracle Corporation and the
question as to why was asked on this forum before
without an answer (without an answer I can remember,
that is).
Yong Huang [EMAIL PROTECTED]

you wrote:
Asynch I/O on a Windowze box? supresses a snigger...

To the best of my knowledge there are no Windows based
system that can take advantage of this, single
thread management can be enough a problem sometimes..
But, I may be wrong.. List?
__
Get personalized email addres

RE: ora-07445

2001-02-05 Thread achoto



Here is what I get in the alert log:

Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:55:20 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15641.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:57:44 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_16105.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []

Thanks

Ana


   

"Mohan, Ross"  

   
-SMI.com>cc:   

Sent by: Subject: RE: ora-07445

root@fatcity.  

com

   

   

02/05/01   

11:55 AM   

Please 

respond to 

ORACLE-L   

   

   





you show a file from your udump.


what is in your bdump? including your alert log.


-Original Message-
Sent: Monday, February 05, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L





I posted a question to the list last week regarding this error and didn't
get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
Solaris 6.


A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server.  If we shutdown/restart the
database the errors went away.  Starting Friday the errors are happening
when shutting down/starting up the db.  We shutdown the db at midnight and
start it at 2:15 am every day.  We get lots of core dumps and trace files
filling up the file system.  We clean up the files and start the db, after
that we don't receive the errors anymore until next stop/start the db.


I have submitted a tar to Oracle support, but so far they haven't come up
with a solution or a cause for this.  We made the changes they suggested
but it didn't help.  Sun suggested some changes to the hardware, but it
hasn't help either.


Can anyone out there provide some insights on this?  Here is one of our
trace files:


Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
System name:SunOS
Node name:  auoracle1
Release:5.6
Version:Generic_105181-23
Machine:sun4u
Instance name: ORTE
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 4674, image: oracleORTE


Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x626c6568, PC: lxdgetobj()+60
*** 2001.02.05.09.20.39.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
- Call Stack Trace -
calling  call entryargument values in hex
location type point(? means dubious value)
  



Thanks


Ana E. Choto
American University
Washington, DC


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]


Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: Analyze Question -- How CBO uses column statistics for non-in

2001-02-05 Thread jkstill



Larry,

You might want to give this a try using PL/SQL and bind variables.

I don't know if this has changed in 8i, but in 8.x, queries using
bind variables could not make use of histograms ( column statistics )

Jared

On Sat, 3 Feb 2001, larry elkins wrote:

> Sam,
>
> You had the right topic. The original questions was "In what way do
> statistics (or lack thereof) on non-indexed columns influence the CBO?". I
> was having trouble thinking of a scenario where this would make a
> difference, hence my posing the question to the list.
>
> I finally thought of a scenario and threw it out to the list. That's the
> email you responded to. Anyway, I eventually had a chance to test the
> scenario. Created 2 tables, A and B, each containing 50,000 rows. Each have
> a indexed column containing consecutive integer values from 1 to 50,000 and
> a one to one relationship between the tables on this column. Each table also
> has a second *non-indexed* column. For table A, the second column contains
> 25,000 distinct values with each individual value occurring 2 times. For
> table B, the second column contains only 2 distinct values, 0 and 1, with
> each value occurring 25,000 times. So, I have an index on the tables to
> support a join between the 2 tables, and, no indexes on the second column in
> each table. I did a generic analyze compute which would include generating
> stats on the non-indexed columns.
>
> And yes, the CBO would use the stats on the non-indexed column on table A to
> decide whether to join to table B using an indexed NLJ, or, an FTS and HJ
> (and in some cases an FTS and SMJ). After deleting the stats and
> re-analyzing so that stats on the non-indexed columns were not generated,
> the CBO always chose, at least on my test cases, to do an FTS on each and
> use an HJ.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Thanks and another book request

2001-02-05 Thread Yosi


Yeah, but Rachel, think of the FAME! Didn't I hear you were
opening for Billy Joel and Elton John in LA on Feb 6?

:-)

Yosi


> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 04, 2001 1:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Thanks and another book request
> 
> 
> Djordje,
> 
> the $5 was for each book sold. not per hour.
> 
> My rate (before the book) was  more than the average.
> The $150/hour is really an average, I know people getting 
> more than that 
> and they haven't written a book, or done lots of 
> presentations etc.  NY is a 
> higher paying market.
> 
> And in any case, even at $10/hour, it's still NOT worth 
> spending the time 
> writing instead of consulting.
> 
> And the real question is, since  I write in my limited, 
> minimal spare time, 
> what is the value per hour of THAT time? Time not spent with 
> family and 
> friends, or doing the things that feed my soul?
> 
> Rachel
> 
> >From: "djordjej" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Thanks and another book request
> >Date: Sat, 03 Feb 2001 23:45:21 -0800
> >
> >Hi Rachel,
> >
> >I definitively believe that the prime drive for writing a 
> book must come
> >from the love to teach, to help other people and share some of the
> >experience and knowledge that you came to the hard way with 
> others.  And I
> >agree that one should not think of writing a book to make money.
> >
> >But for the math you did to be fair, I guess it should be 
> mentioned that
> >having a name on a good book also helps to reach $150 per 
> hour.  I would 
> >not
> >say that this is an average that a
> >senior/experienced/expert/knowledgeable/... DBA gets even in 
> NY ?   If the
> >name on the book can bring this number up by at least, say 
> $10/hour, this
> >changes your math by at least $1600*10 = $16,000.  Am I right in this
> >assumption?
> >
> >Djordje
> >
> >- Original Message -
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Sent: Friday, February 02, 2001 8:05 PM
> >
> >
> > > well, let's do the math.
> > >
> > > let's say I get $5 for each book that is sold (I don't, and the 
> >royalties
> > > change depending on if the book has sold at full price or from a 
> >discount
> > > house)  but the $5 makes the math easier
> > > (and it's less than minimum wage in the US!)
> > >
> > >
> > > let's round the numbers, and say that an independent DBA 
> consultant can
> >earn
> > > $150/hr in New York, where I live. (That's an average, 
> some make more,
> >some
> > > less)
> > >
> > > and 150/5 = 30  so I'd have to work 30 times as many 
> hours writing books
> >as
> > > I would as a consultant to make the same amount of money
> > >
> > > Most personnel departments assume that there are 200 
> workdays in a year
> > > (vacation, weekends and holidays excluded), and that a 
> workday is 8 
> >hours
> > > long. Yes, I know no DBA works a 40 hour week, this is 
> just an example.
> > >
> > > so 200*8 = 1600 hours work in a year.
> > >
> > > 1600/500= 3.2 books a year and 1600*5=$8000 a year
> > >
> > > 1600*150=$240,000
> > >
> > > don't know about you, I'd rather be a consultant!
> > >
> > > I repeat -- you don't make money writing books, and if 
> that is why you 
> >are
> > > writing them, you'd be better off just consulting. Even 
> if you write in
> >your
> > > "spare time", you lose -- I worked evenings, and all day 
> all weekend
> > > writing. I didn't see my friends or family for the time I 
> was writing.
> > >
> > >
> > > Oh, and since my name does show up when my messages post, 
> so it's easy 
> >to
> > > see how it is spelled
> > >
> > > it's Rachel, not Rachael
> > >
> > >
> > > >From: "orclbabu" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >Subject: Re: Thanks and another book request
> > > >Date: Fri, 02 Feb 2001 12:32:11 -0800
> > > >
> > > >Rachael
> > > >
> > > > > consultant for that number of hours Not 
> profitable to write one.
> > > >
> > > >The very fact that you often repeat this in response to 
> mails that 
> >refer
> >to
> > > >your books, makes us think otherwise $$$
> > > >
> > > >;-)
> > > >
> > > >babu
> > > >
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: orclbabu
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051  FAX: 
> (858) 538-5051
> > > >San Diego, California-- Public Internet access / 
> Mailing Lists
> > > 
> >
> > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > >to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in
> > > >the message BODY, include a line containing: UNSUB ORACLE-L
> > > >(or the name o

Re: OEM/IA and DB shutdown

2001-02-05 Thread Ruth Gramolini


I run about 20+ databases from one OEM session, albeit on NT, and I never
shutdown the agent when I shutdown a database.  You must have OEM sending
email for all events.  Just use email for selected events that you want to
know about.

OEM won't freak if you don't shutdown the repository database.  If you do it
will stop working at all.  I use a small database on one of my servers to
hold the repository and the recovery catalog.  Then no matter what I do with
the other databases OEM doesn't care.

I don't know if this answers all of your questions but I hope it helps,
Ruth


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 10:50 AM


> So, there I am, with an HP/UX server hosting 3 production Oracle DBs.  The
> node is also running Oracle Intelligent Agent, and I have OEM events to
> e-mail/page me if there's problems with productions DBs and servers.
>
> Anyone else running something similar?  How do you shutdown a single
> production DB without causing OEM to freak?
>
> If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs and
> node being unavailable.  If I SHUTDOWN NORMAL the production DB, like a
good
> DBA, I need to manually kill the DBSNMP processes that are still
connected.
> If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN
> NORMAL), can the DBSNMP process still connect?
>
> I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes,
but
> that somehow just seems hokey to me.
>
> Anyone?
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
>
> ---
>
> This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sar Loader Script?

2001-02-05 Thread Ferris, Shawn


> My problem is that the timestamp, which is just that--no date, is only on
the  
> first record of each sample rather than every record and I don't want the
blank 
> lines in between the samples. Perhaps this is a simple awk routine but 
> I don't know awk well enough to do this.  
 
awk '{ if (NF>7) {time=$1;print $0} else print time,$0}'
 
This is off the top of my head. I'm sure there is a more elegant method.
This will add the time field to each record. I didn't take it any further.
The next problem is quoting the correct fields. (You can hard code it) I
just didn't feel like it. 8) (I would've used perl/DBD w/ bind variables.)
 
HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferris, Shawn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM/IA and DB shutdown

2001-02-05 Thread Gary Weber


>>>If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs
and
node being unavailable.  If I SHUTDOWN NORMAL the production DB, like a good
DBA, I need to manually kill the DBSNMP processes that are still connected.
If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN
NORMAL), can the DBSNMP process still connect?
I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes, but
that somehow just seems hokey to me.<<<

I'm on HPUX 11 with Oracle 8.1.6.
Shutdown immediate for once-per-week cold backup. IA stays up at all times.

Gary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Weber
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Need help - Database link - Please!!

2001-02-05 Thread Ruth Gramolini


Doesn't your second example say that ' Userid-2 has no permissions on
table-a in database-b'?

Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 10:30 AM


> I'm sorry.  The error is not that the user cannot use the database link.
> The error is that Oracle does not want the user to update table-a in
> database-b even though the user has update permissions.
>
> Ron
>
> -Original Message-
> Sent: Monday, February 05, 2001 8:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> You should set up synonyms which define the tables@public_dblink in
database
> b. Put these synonyms in database a. Then anyone can use the linked tables
> from the package in database a.
>
> HTH,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, February 05, 2001 8:35 AM
>
>
> > I have a public database link defined with userid-1.
> > Userid-1 has update permissions on table-a in database-b.
> > Userid-2 has no permissions on table-a in database-b.
> > Userid-2, in database-a, calls a package that contains the database link
> and
> > tries to update table-a in database-b.
> > The result is an Oracle error that states insufficient privileges on
> > table-a.
> >
> > Can anyone help?
> >
> > Ron Smith
> > Database Administration
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Smith, Ron L.
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Group/Sort by date field

2001-02-05 Thread MooreMJ


Hi
I am wondering about some results I am getting back when I am querying based
on date fields. I have a large table partitioned on source year. When I run
the following query the results are not correct results, it seems to be
grouping the year incorrectly.

select to_char(landed_dt,''), count(distinct
vessel_code),sum(landed_value)
 from landing_hist
 where to_char(landed_dt, '') in ('1994','1995','1996')
  and source_year in ('1994','1995','1996')
 group by to_char(landed_dt, '')
 order by to_char(landed_dt, '')

When I run the query for individual years the data returned is correct and
when I rewrite the query so that it is not being grouped by
to_char(landed_dt,'') (see below) the results are correct.

select source_year, count(distinct vessel_code),
   sum(landed_value)
 from landing_hist
 where to_char(landed_dt, '') in ('1994','1995','1996')
  and source_year in ('1994','1995','1996')
 group by source_year
 order by source_year

Can anyone help me out with what I am missing - it seems like it has to be
something obvious - but I don't know what.

Thanks
Jane 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

Title: RE: Async I/O on Windows



LOL!!!   Amen!
 

  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 12:25 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT RE: Async I/O on Windows
  WHOOO a SQLServer vs. Oracle debate 
  again!!
   
  Come 
  on guys in the field, lets hear you comments from all those using both in the 
  field. I personally have been trained in administration on both, and - like 
  you Ross - have to agree that Oracle is my personal favourite, though 
  SQLServer DOES perform better on my machine here...
   
  In 
  terms of admin costs etc. SQLServer does kick ass, and still has all those 
  pointy clicky admin wizards - That Oracle is apparently getting with 9i - and 
  have attempted quite poorly with OEM. 
   
  Bet 
  the guy in the Nova will NEVER beat me in my H reg Cavalier with FLUFFY DICE 
  IN THE WINDOW!!! When they swing they add to my forward 
  momentum!!
   
  Mark
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Monday, February 05, 2001 03:56To: Multiple recipients of list 
ORACLE-LSubject: OT RE: Async I/O on Windows
"NT still pants"...LOL!!! 
 
It must be 
panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running 

SQLServer on NT, as has DB2. 
 
The general public ( and anyone else ) can wake up and smell the 
coffee at www.tpc.org.  

Check out the Top Ten TPC-C marks, by pure performance. 

 
Not interested in pure peformance?  Check out the 
Price/Performance leaders. Oracle doesn't
even SHOW UP in the top ten. What a shocker, eh? It's painful to lose 
our illusions
 
Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? 
Fine, check out ANY
of 
the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't 
even show
up. 
 
I 
mean, I like Oracle, too, butby the time you turn on the multimode 
airconditioner, use 
the 12-way adjustable power bucket seats, 
activate the object-oriented OnStar Satellite 
navigational system, power up the heated 
side view mirrors and all the other tools, trinkets, 
and toys that make it my personal 
favorite database, there *is* the chance that the 
twenty year old genius mechanic in the the tricked 
out Nova next to you at the light is going 
to 
kick your ass when the light turns 
green.
 
But really, I still love Oracle. Warts and all. 
 
Wanna drag?
 
(heh heh heh)

RE: Oracle Vs Tera Data

Title: RE: Oracle Vs Tera Data





Surjit, 


In my experience, Sun storage ( the A5000 stuff, etc. )
does not do the best possible job. 


But, then again, you may be on Fujitsu, EMC, or some
other good storage vendor. 


(Dick, liked your comments about normalization and adjustment
 expectations...)


hth


Ross


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:Oracle Vs Tera Data



Surjit,


    I think your "hardcore Tera Data" fans are also bigots.  I've a friend at
Fidelity Investments where they swear by SUN & Oracle.  The last time I talked
to him their datawarehouse was fast approaching 2PB without any problems.  They
use all of 8i's datawarehousing stuff like partitioning, hash & star joins,
etc... and haven't had a single problem.  Now if an investment banker can be
happy, why can't your bigots???


    There are two basic problems with data warehouses that I've seen & it should
be noted that I'm in the middle of specing a re-wtite of ours.  1) people create
then in a normalized manner, not in the idea of a series of stars.  COnsequently
you end up with too much data in a single table making that table a real bear to
manage.  2) end users have this ungodly desire for speed.  My GOD, if your
searching through 2 or 3 billion rows of data of course it's going to take a
while.


Dick Goulet


Reply Separator
Author: "Surjit Sharma" <[EMAIL PROTECTED]>
Date:   2/4/2001 4:15 PM



All


I wonder if anyone out there has faced the same dilemma as I am facing
currently. Our database is likely to grow to a couple of Tera bytes.  The
existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6
and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data
fans that Oracle can't do the following:


   Start schema in Oracle is not suitable for datawarehouses.
   Oracle is not scalable to deal with Tera bytes databases.
   Oracle partitioning is not good enough to do the job.


I feel  that Oracle has been working fine on a Sun box with about 200-300
Gig of data.
What is the price/performance of say a Sun Box vs Tera Data. I am sure
there is a huge difference.


I appreciate your valuable thoughts.


Regards


Surjit


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Surjit Sharma
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT


I have taken the stance with one junior that he now
has to prove me wrong in anything I tell him.  Loser buys
the beer.  He owes me quite a bit right now:-)

-Original Message-
Sent: Friday, February 02, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L


Kimberly,

I could say the same thing of course, the other part is that I convinced

the programmers here that I knew what I was doing by letting them have their

way in development and watching it die... then converting it to what I 
wanted to do and watching it fly. Now they ask my opinion before they do 
anything.

Rachel


>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Pondering Question of the Day-RESPECT
>Date: Fri, 02 Feb 2001 08:11:03 -0800
>
>I have had that same issue in the past but I don't have it here.  I find
>that
>as long as you have your managements support and the development team
>knows that then life will be much easier.  I am very lucky here in that I
>have good management and a very well trained senior development team
>to work with.  Not that there are never disagreements but comprise is the
>name of the game.  You just got to be picky on what you let them think you
>are
>compromising on:-)  I always have more issues with junior/intermediate
>developers.
>
>-Original Message-
>Sent: Friday, February 02, 2001 7:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>"Hello Oracle Guru"
>
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I 
>say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com 
>
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

2001-02-05 Thread Richard Ji

Title: RE: Async I/O on Windows

Just
because Oracle hasn't done a benchmark doesn't mean Oracle can't out perform
SQL-Server or DB2. Benchmark is very expensive to do, Oracle doesn't need
to prove to the world every year that it is the best. Oracle has the
reputation that MS and IBM don't have. That's why MS and IBM needs to do
it. And do you know how many scientists MS had to do that benchmark?
I wonder if they factor that into the Price/Performance. Can you (do
you) have the same resources in the real world to achive that result?
Needless to say performance is not the only thing you measure a DB. How
good is SQL-Server when the underlying OS crashes so often?
Richard Ji

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Monday, February 05, 2001 10:56 AMTo: Multiple recipients of list
ORACLE-LSubject: OT RE: Async I/O on Windows
"NT
still pants"...LOL!!!
It must be
panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running

SQLServer on NT, as has DB2.
The
general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.
Check out the Top Ten TPC-C marks, by pure performance.

Not
interested in pure peformance? Check out the Price/Performance leaders.
Oracle doesn't
even
SHOW UP in the top ten. What a shocker, eh? It's painful to lose our
illusions
Oh,
what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out
ANY
of
the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even
show
up.

I
mean, I like Oracle, too, butby the time you turn on the multimode
airconditioner, use
the
12-way adjustable power bucket seats, activate the object-oriented
OnStar Satellite
navigational system, power up the heated
side view mirrors and all the other tools, trinkets,
and
toys that make it my personal favorite database, there *is* the
chance that the
twenty year old genius mechanic in the the tricked out
Nova next to you at the light is going
to
kick your ass when the light turns
green.
But
really, I still love Oracle. Warts and all.
Wanna drag?
(heh
heh heh)

Now don't get me wrong, there is enough traffic on
this list about this at the moment, so I dont want more bandwith added with
this thread if at all possible :)
Thanks for the reply anyway Yong, I think I will
wait for a "good" book on Win2k to come out (unless you know one?) before I
go out and buy one (books come out of my pocket as I am a sales person
mostly).. NT as far as I am concerned is now in Win2K's shadow, and I think
that is the way of the future for Windowze bound people.
For all out there that have used NT and not Win2K -
TRY IT.. Services are handled a LOT better, file management and sharing..
All sorts of new fun stuff to sink your teeth in to..
As
a side note, for the last line of my first paragraph - I also feel that UNIX
cannot be compared in anyway to Windows at this time. Windowze O/S's
are designed for pointy clicky people that prefer to look at a nice GUI
interface, and generally don't have the indepth technical knowledge that a
good UNIX sys admin does..
(If there any NT admins out there don't flame me, I
have to deal with it every day of my life...)
Regards
Mark
The views expressed here are soley those coming out
of my coffee deprived hungover mind.. They do not express those of my
employers, though I'm sure they agree :^)

Sar Loader Script?

2001-02-05 Thread Walter K



By chance, does 
anyone have a script that will reparse a collection of sar statistics, that came 
from "sar -d", into a file that can be used by SQL*Loader?My problem is 
that the timestamp, which is just that--no date, is only on the first record of 
each sample rather than every record and I don't want the blank lines in between 
the samples. Perhaps this is a simple awk routine but I don't know awk well 
enough to do this. Any assistance is appreciated!-wHere is a 
sample of the data I am trying to work with:SunOS pandora 5.6 
Generic_115161-23 sun4u    
01/30/01
08:00:00   device    
%busy   avque   r+w/s  blks/s  avwait  avserv

08:01:00   nfs1  
0 0.0   0   0 0.0 0.0   
sd5   
4 0.0   7 132     0.0 6.5   
sd5,c 
0 0.0   0   0 0.0 0.0   
sd5,d 
0 0.0   0   0 0.0 0.0   
sd5,e 
4 0.0   6 132 0.0 7.2   
sd22  
1 0.1   1  21 0.0    81.3   
sd22,a    
0 0.0   0   0 0.0 0.0   
sd22,b    
0 0.0   0   0 0.0 0.0   
sd22,c    
0 0.0   0   0 0.0 0.0   sd22,d    
0 0.0   0   0 0.0 0.0   
sd22,e    
0 0.0   0   0 0.0 0.0   
sd22,g    
1 0.1   1  21 0.0    81.3   
sd22,h    
0 0.0   0   0 0.0 0.0   
sd23  
2 0.0   3 101 0.0 7.1   
sd23,c    
0 0.0   0   0 0.0 0.0   
sd23,d    
0 0.0   0   0 0.0 0.0   
sd23,e    
2 0.0   3 101 0.0 7.1   
sd34  
0 0.0   0   0 0.0 0.0   
sd45  
1 0.1   1  21 0.0    96.4   
sd45,a    
0 0.0   0   0 0.0 0.0   
sd45,b    
0 0.0   0   0 0.0 0.0   
sd45,c    
0 0.0   0   0 0.0 0.0   
sd45,d    
0 0.0   0   0 0.0 0.0   
sd45,e    
1 0.1   1  21 0.0    96.4   
sd45,g    
0 0.0   0   0 0.0 0.0   
sd45,h    
0 0.0   0   0 0.0 0.0   
sd46  
0 0.0   0   0 0.0 0.0   
sd46,c    
0 0.0   0   0 0.0 0.0   
sd46,d    
0 0.0   0   0 0.0 0.0   
sd46,e    
0 0.0   0   0 0.0 0.0   
sd66  
0 0.0   0   0 0.0 0.0   
sd125 
0 0.0   0   0 0.0 0.0   
sd126 
0 0.0   0   0 0.0 0.0   
sd127 
0 0.0   0   0     0.0 0.0   
sd127,a   
0 0.0   0   0 0.0 0.0   
sd127,b   
0 0.0   0   0 0.0 0.0   
sd127,c   
0 0.0   0   0 0.0 0.0   
sd127,d   
0 0.0   0   0 0.0 0.0   
sd127,e   
0 0.0   0   0 0.0 0.0   
sd127,g   
0 0.0   0   0 0.0 0.0   
sd328 
2 0.0   4  70 0.0 4.9   sd328,c   
0 0.0   0   0 0.0 0.0   
sd328,d   
0 0.0   0   0 0.0 0.0   
sd328,e   
2 0.0   4  70 0.0 4.9   
sd329 
0 0.0   0   0 0.0 0.0   
sd329,c   
0 0.0   0   0 0.0 0.0   
sd329,d   
0 0.0   0   0 0.0 0.0   
sd329,e   
0 0.0   0   0 0.0 0.0   
sd330 0 0.0   0   0 0.0 0.0   
st32  
0 0.0   0   0 0.0 0.0   
st33  
0 0.0   0   0 0.0 0.0
08:02:00   nfs1  
0 0.0   0   0 0.0 0.0   
sd5   
2 0.0   3  82 0.0 7.4   
sd5,c 
0 0.0   0   0 0.0 0.0   
sd5,d 
0 0.0   0   0 0.0 0.0   
sd5,e 
2 0.0   3  82 0.0 9.1   
sd22  
1 0.0   1  11 0.0    53.6   
sd22,a    
0 0.0   0   0 0.0 0.0   
sd22,b    
0 0.0   0   0 0.0 0.0   
sd22,c    
0 0.0   0   0 0.0 0.0   
sd22,d    
0

Linux as a production machine

2001-02-05 Thread Dave Morgan


Hi Dick,
A couple of campanies I consult for are using 
Linux and Oracle (8.0.5, 8.1.6) as production
databases. Neither is really high transaction volume
but one is holding about 1.5 GB of data.

One install occured because Oracle on NT was choking
the box and the company did not want to buy new 
hardware. I find you usually get a 20 -30% performance
boost with Oracle on Linux vs NT for the same hardware.

The 8.0.5 Linux release has some problems so I would 
recommend the 8.1.6 release which is of the same quality 
as all other UNIX Oracle releases (Notice I didn't comment 
on the quality, just the similarity :)

Both machines are in archive log mode and show typical
unix uptimes (Months).

WARNING:
My original kernel is  Slackware 1.2.13 (I think) and
I have maintained my own kernel and system for the past
5-6 years (Currently 2.2.14).  This gives me an extremely 
reliable (but custom) system. My builds are of better
quality than any commercial linux packages I have tested.

I would recommend Caldera over Redhat based on my tests and
what I have  heard from other admins. The feeling 
seems to be Redhat is going after the consumer market 
while Caldera is concentrating on the server market.

In summary, Linux, once properly configured is quite
suitable as a production Oracle platform.
HTH
Dave

-- 
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pinning Tables

2001-02-05 Thread Trassens, Christian


No, pinning is for the code: sql, procedures/functions/packages and
sequences. Take a look of the package dbms_shared_pool.

Regards.

> -Mensaje original-
> De:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Enviado el:   lunes 5 de febrero de 2001 16:36
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Pinning Tables
> 
> Hi all,
>   I have been trying to find some reference on pinning tables in the
> SGA.  I
> haven't found anything, all that I am finding is table caching and the
> keep
> buffer pool.  Is this all that there is, can I "pin" a table in the
> memory?
> Thanks in advance.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(Win2K vs NT4) / RE: OT RE: Async I/O on Windows

2001-02-05 Thread Eric D. Pierce


Ross & Mark,
There are no major performance concerns here (and we get 
Oracle "free" {system wide educational site license} - 
unlike MS/SQL), so what I want to know is: does Oracle8 
generally work well on Windows 2000 server (compared to 
running it on NT4)? We will be running on this hardware:
IBM Netfinity5100 w/ RAID (dedicated Oracle server, w/
web server on same box, if possible).

My assumption is that Win2k/Oracle8 is "ok". Are there any
horror stories out there about running Oracle8 on Win2K
where running on NT4 would have been better?

thanks!
ep

On 5 Feb 2001, at 9:25, Mark Leith wrote:

Date sent:  Mon, 05 Feb 2001 09:25:25 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> RE: Async I/O on WindowsWHOOO a SQLServer vs. Oracle debate again!!

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT


Sounds like you more like the backup DBA then just a developer.
Congrs, I believe you wear two hats.  Now go ask for a raise.

-Original Message-
Sent: Friday, February 02, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L


You are exactly correct.  I as a developer am usually the first line of 
blame when something doesn't work even when it is because the sys admin 
decided to add a service pack or to tweak some parameters to optimize 
something else, or the network guys decided to improve the firewalls or the 
DBA decided to clean up the database without bothering to find out if those 
tables were actually being used.

We are a pretty small shop compared to most of you guys, nobody is on call, 
and sometimes the DBA is not available or is busy with something else, so I 
need to be able to stop and start the listener, create and move tables, 
recreate indexes, drop and add users and privileges.  On the plus side for 
the DBA, I am responsible for fixing my own mistakes, the most he has to do 
for me is load the backup tape.

At 10:05 AM 2/2/01 -0800, you wrote:
>Pondering Question of the Day-RESPECTcome on! give me an user who prefer
we,
>developers and dbas working in a decent way, instead of
>get its job done "rigth now in this moment" and I'll shave my head and
paint
>it blue.
>
>developers get crazy trying to solve a problem with users on the other side
>of the phone yelling!
>and that's first reason of messing everything up.
>(ok, don't generalize)
>users' bosses want the same.
>
>why can't we talk about the complete organization? and why everybody thinks
>developers and dbas as
>separate things?
>If you can't separate responsabilities and duties, well, it's an
>organization problem
>
>try to take an equilibrium and you'll be happy
>
>Gabriel Galanternik
>
>- Original Message -
>To: Multiple recipients of list ORACLE-L
>Sent: Friday, February 02, 2001 1:10 PM
>
>
>Lisa,
>Rather than talking to the CTO about this go to the Dir, VP, or whatever of
>the USERS of the system.  In-fact he/she is the actual OWNER of the data in
>the system.  Explain to him/her how dangerous and devious the developers
are
>to the data.  Talk about corruption, system downtime, partial and
incomplete
>restores.  Use some technical DBA language to make them understand you have
>the knowledge, but make sure you keep the message at a manager level of
>understanding.  Get them good and scared.  Then when the developers are
>asking for the free ride in production you have an advocate in high postion
>that can put the CTO in a position of getting a backbone.  When the COO
>starts asking why his people can't work, or why the P/L statement is messed
>up the CTO will start scrambling for a lockdown on production and more
>comprehensive testing of new or enhanced code.  Remember the politics.  We
>in the IT field are not the production organization we are the service
>organization.  When it comes to power struggles at the Cxx levels the
>production/operations guys always beat the IT/IS guys.  It's a mater of $$$
>and performance in front of the CEO.
>
>HTH
>
>Rodd Holman
>-Original Message-
>Sent: Friday, February 02, 2001 9:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>"Hello Oracle Guru"
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I
say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gabriel Galanternik
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, Califor

Re: ora-07445

2001-02-05 Thread achoto



I recompiled invalid objects, but I haven't run catalog and catproc.  I'll
try it and see what happens.  Thanks for your help

Ana Choto.




   
 
"Mike  
 
Killough" To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Subject: Re: ora-07445   
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
02/05/01 12:10 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Did you try re-running catalog and catproc and then recompiling invalid
objects? We were getting ora-7445 errors on one of our databases last week,

and this fixed it.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: ora-07445
>Date: Mon, 05 Feb 2001 06:55:26 -0800
>
>I posted a question to the list last week regarding this error and didn't
>get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
>Solaris 6.
>
>A few days ago we started receiving ora-07445 errors in the alert log.
>This happened when had to reboot the server.  If we shutdown/restart the
>database the errors went away.  Starting Friday the errors are happening
>when shutting down/starting up the db.  We shutdown the db at midnight and
>start it at 2:15 am every day.  We get lots of core dumps and trace files
>filling up the file system.  We clean up the files and start the db, after
>that we don't receive the errors anymore until next stop/start the db.
>
>I have submitted a tar to Oracle support, but so far they haven't come up
>with a solution or a cause for this.  We made the changes they suggested
>but it didn't help.  Sun suggested some changes to the hardware, but it
>hasn't help either.
>
>Can anyone out there provide some insights on this?  Here is one of our
>trace files:
>
>Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
>Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
>PL/SQL Release 8.0.5.2.0 - Production
>ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
>System name:SunOS
>Node name:  auoracle1
>Release:5.6
>Version:Generic_105181-23
>Machine:sun4u
>Instance name: ORTE
>Redo thread mounted by this instance: 1
>Oracle process number: 35
>Unix process pid: 4674, image: oracleORTE
>
>Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
>addr: 0x626c6568, PC: lxdgetobj()+60
>*** 2001.02.05.09.20.39.000
>ksedmp: internal or fatal error
>ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
>[Address not mapped to object] [1651271016] [] []
>- Call Stack Trace -
>calling  call entryargument values in hex
>location type point(? means dubious value)
>  
>
>
>Thanks
>
>Ana E. Choto
>American University
>Washington, DC
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other informa

RE: Pinning Tables

Title: RE: Pinning Tables





you pin the table as a namespace entity in the rowcache ( i think ) any
time you use it...it can be flushed, though. None of this is under your
control.


you pin the table as a datasource through bufferpool and CACHE settings. 


hth


Ross


-Original Message-
From: Trassens, Christian [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Pinning Tables



No, pinning is for the code: sql, procedures/functions/packages and
sequences. Take a look of the package dbms_shared_pool.


Regards.


> -Mensaje original-
> De:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Enviado el:   lunes 5 de febrero de 2001 16:36
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Pinning Tables
> 
> Hi all,
>   I have been trying to find some reference on pinning tables in the
> SGA.  I
> haven't found anything, all that I am finding is table caching and the
> keep
> buffer pool.  Is this all that there is, can I "pin" a table in the
> memory?
> Thanks in advance.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sar Loader Script?

2001-02-05 Thread Charlie Mengler


#!/usr/local/bin/perl
# file - sar-d.pl
$sar_out = "/tmp/sar.out";
$sar_dat = ">/tmp/sar.dat";
# a file suitable for SQLLDR is created as /tmp/sar.dat
system("sar -d > $sar_out"); 
open(INP,$sar_out);
open(OUT,$sar_dat);
$line_cnt = 1;
while () { 
   if ( ($line_cnt > 4) && (length($_) > 1) )
   {
  if ( (substr($_,0,1) ne " ") && (substr($_,0,1) ne "A") )
  {
 $timestamp = substr($_,0,8);
 #print "$timestamp\n";
 $input = $_;
  } else
  {
 $input = $timestamp . substr($_,8);
  }
  print OUT $input;
   }
   $line_cnt++;
}
close(INP);
close(OUT);
unlink($sar_out);

HTH & HAND!

> By chance, does anyone have a script that will reparse a collection of sar 
>statistics, that came from "sar -d", into a file that can be used by SQL*Loader?

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
HOME DEPOT - The Big Boy's Toy store!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

2001-02-05 Thread Jeffery Stevenson

Title: RE: Async I/O on Windows

Well, Oracle does
have all three of the top spots in TPC-C for Non-clustered results...I wonder
how a performance/square foot rating would turn
out...hmmm...
:)

Jeffery StevensonChief Databeast TamerMedical Present
Value, Inc.Austin, TX

-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 9:56
AMTo: Multiple recipients of list ORACLE-LSubject: OT
RE: Async I/O on Windows
"NT
still pants"...LOL!!!
It must be
panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running

SQLServer on NT, as has DB2.
The
general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.
Check out the Top Ten TPC-C marks, by pure performance.

Not
interested in pure peformance? Check out the Price/Performance leaders.
Oracle doesn't
even
SHOW UP in the top ten. What a shocker, eh? It's painful to lose our
illusions
Oh,
what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out
ANY
of
the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even
show
up.

I
mean, I like Oracle, too, butby the time you turn on the multimode
airconditioner, use
the
12-way adjustable power bucket seats, activate the object-oriented
OnStar Satellite
navigational system, power up the heated
side view mirrors and all the other tools, trinkets,
and
toys that make it my personal favorite database, there *is* the
chance that the
twenty year old genius mechanic in the the tricked out
Nova next to you at the light is going
to
kick your ass when the light turns
green.
But
really, I still love Oracle. Warts and all.
Wanna drag?
(heh
heh heh)

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Friday, February 02, 2001 07:00To: Multiple recipients of list
ORACLE-LSubject: RE: Async I/O on Windows
Oracle on NT runs as
ONE PROCESS
with
MULTIPLE THREADS
for performance reasons (no more need for shared memorycontext switches are a LOT less expensive, etc.)
-Original Message- From:
yong huang [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: Async I/O on Windows
Hi, Mark,
Async I/O is available on Windows, at least NT. It's not
an easy topic. If you think you already know
enough about operating systems in general, I suggest you read David Solomon's "Inside WindowsNT". For a lab test, launch
Performance Monitor on your NT box and look at the
counters for Cache.
I'm not sure by "single thread management" whether you
mean NT can't have multiple processes or

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Rocky Welch

 Try this:
"It sure would be a shame if all that work you did today were to somehow disappear. It would certainly be nice if somebody brought me a ."
This works pretty well.
-Rocky
  Rachel Carmichael <[EMAIL PROTECTED]> wrote: 
hm, I like that. I've been working on training people here on the proper bribes for the DBA, but they are SLOWWW learners.>From: Kimberly Smith <[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Subject: RE: Pondering Question of the Day-RESPECT>Date: Mon, 05 Feb 2001 08:55:48 -0800>>I have taken the stance with one junior that he now>has to prove me wrong in anything I tell him. Loser buys>the beer. He owes me quite a bit right now:-)>>-Original Message->Sent: Friday, February 02, 2001 9:16 AM>To: Multiple recipients of list ORACLE-L>>>Kimberly,>>I could say the same thing of course, the other part is that I >convinced>>the progra!
!
mmers here that I knew what I was doing by letting them have >their>>way in development and watching it die... then converting it to what I>wanted to do and watching it fly. Now they ask my opinion before they do>anything.>>Rachel>>> >From: Kimberly Smith <[EMAIL PROTECTED]>> >Reply-To: [EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> >Subject: RE: Pondering Question of the Day-RESPECT> >Date: Fri, 02 Feb 2001 08:11:03 -0800> >> >I have had that same issue in the past but I don't have it here. I find> >that> >as long as you have your managements support and the development team> >knows that then life will be much easier. I am very lucky here in that I> >have good management and a very well trained senior development team> >to work with. Not that !
!
there are never disagreements but comprise is the> >name of the game. You just got to be picky on what you let them think >you> >are> >compromising on:-) I always have more issues with junior/intermediate> >developers.> >> >-Original Message-> >Sent: Friday, February 02, 2001 7:20 AM> >To: Multiple recipients of list ORACLE-L> >> >> >> >"Hello Oracle Guru"> >> >Now why is it that I get more respect on the Internet than I do in my> >workplace. ??> >> >How many of you have this problem? It's like an ongoing fight with> >developers, they want carte blanche in the production database, and they >do> >whatever they want EVEN THOUGH I tell them NO, let's do something >different> >that won't affect production. I go to the CTO because this is like the >3!
!
rd> >time this has happened, and he sends out a> >let's-be-sure-not-to-offend-anyone email. But the developer(s) will go> >ahead and do what they want ANYWAY. I'm waiting for the first >user-mistake> >recovery to say STOP, I've had ENOUGH and this is how it's going to be, >no> >ifs, ands or buts.> >> >My last job may have been a sweatshop, but at least people respected my> >authority. Here, it's a free for all no matter what I do. Even when I> >say,> >Dude, I own the database. If there's a problem, I have to fix it.> >Therefore I say what happens in production and what doesn' t happen in> >production.> >> >And yes, I am looking for another position. I can only take this> >dba/developer/janitor role for so long.> >> >I'M SO GLAD IT'S FRIDAY... Bring on the Captain Morgan! It's noon> >som!
!
ewhere...> >> >Lisa Rutland Koivu> >Oracle Database Administrator> >Qode.com> >4850 North State Road 7> >Suite G104> >Fort Lauderdale, FL 33319> >> >V: 954.484.3191, x174> >F: 954.484.2933> >C: 954.658.5849> >http://www.qode.com > >> >"The information contained herein does not express the opinion or >position> >of Qode.com and cannot be attributed to or made binding upon Qode.com."> >>>_>Get your FREE download of MSN Explorer at http://explorer.msn.com>>-->Please see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author: Rachel Carmichael> INET: [EMAIL PROTECTED]>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051>San Diego, Ca!
!
lifornia -- Public Internet access / Mailing Lists>>To REMOVE yourself from this mailing list, send an E-Mail message>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in>the message BODY, include a line containing: UNSUB ORACLE-L>(or the name of mailing list you want to be removed from). You may>also send the HELP command for other information (like subscribing).>-->Please see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author: Kimberly Smith> INET: [EMAIL PROTECTED]>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051>San Diego, California -- Public Internet access / Mailing Lists>>To REMOVE yourself from this mailing list, send an E-Mail message>to: [EMAIL PROTECTED] (note !
!
EXACT spelling of 'ListGuru') and in>the message BODY, include a line containing: UNSUB ORACLE-L>(or the name

RE: Linux as a production machine

2001-02-05 Thread Daniel . Curry


Thanks.  I have been saying this for years, but just not limited to Oracle
systems.  Nice to have someone agree with you after years of saying pretty
much the same thing.

Daniel Curry
Tsola, Inc.
[EMAIL PROTECTED]
650.486.2624

 -Original Message-
Sent:   Monday, February 05, 2001 9:02 AM
To: Multiple recipients of list ORACLE-L
Subject:Linux as a production machine

Hi Dick,
A couple of campanies I consult for are using 
Linux and Oracle (8.0.5, 8.1.6) as production
databases. Neither is really high transaction volume
but one is holding about 1.5 GB of data.

One install occured because Oracle on NT was choking
the box and the company did not want to buy new 
hardware. I find you usually get a 20 -30% performance
boost with Oracle on Linux vs NT for the same hardware.

The 8.0.5 Linux release has some problems so I would 
recommend the 8.1.6 release which is of the same quality 
as all other UNIX Oracle releases (Notice I didn't comment 
on the quality, just the similarity :)

Both machines are in archive log mode and show typical
unix uptimes (Months).

WARNING:
My original kernel is  Slackware 1.2.13 (I think) and
I have maintained my own kernel and system for the past
5-6 years (Currently 2.2.14).  This gives me an extremely 
reliable (but custom) system. My builds are of better
quality than any commercial linux packages I have tested.

I would recommend Caldera over Redhat based on my tests and
what I have  heard from other admins. The feeling 
seems to be Redhat is going after the consumer market 
while Caldera is concentrating on the server market.

In summary, Linux, once properly configured is quite
suitable as a production Oracle platform.
HTH
Dave

-- 
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: controlfile schema global enqueue lock

2001-02-05 Thread Steve Adams


Hi Joan,

You don't have a problem unless there is a session WANTING a lock on the
resource. By "something interesting", I meant a session waiting for a lock on
either the CF or ST enqueues. Then you run it repeatedly to see how long the
problem persists. Because you are going to run it repeatedly, it would be good
to hack the script to exclude all other enqueue types. Also, I note that you are
not running the new version of this script that gives the names of the
background processes instead of their SIDs.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Tuesday, 6 February 2001 1:11
To: Multiple recipients of list ORACLE-L


Steve,

Thank you so much for taking time to reply. I did run couple of times the
enque_lock script as you suggested. CF waiting is really minimum. I noticed
the maximum enqueue comes from MR which is Media Recovery in share lock.
Should I need to concern this or this is just a very normal symptoms for the
database nature?
The real exclusive lock comes from TX. Right now I am starting to look into
it.

MR-8-02   S  0
MR-80-0   2   S 335666
MR-81-0   2   S 335238
MR-82-0   2   S 334850
MR-83-0   2   S 334473
MR-84-0   2   S 334094

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
MR-85-0   2   S 333672
MR-86-0   2   S 333131
MR-87-0   2   S 332593
MR-88-0   2   S 331998
MR-89-0   2   S 331386
MR-9-02   S  0
MR-90-0   2   S 330764
RT-1-03   X  0
TM-2750-0  1459  SX   1262
406  SX987
987  SX968

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
TM-2750-0  1474  SX957
462  SX411
286  SX336
TM-3196-0  1318  SX  0
TS-3-16866818 5  SX 332462
TX-1048594-158974  1208   X  1
TX-1048595-158908  1170   X  0
TX-1048640-159199   475   X  1
TX-1835008-159738  1474   X957
TX-1835015-159892  1172   X 64


Thanks,

Joan


-Original Message-
Sent: Friday, February 02, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L


Hi Joan,

This filtered into my Inbox folder because you mentioned my name. I've not
been
following the thread, but I'll comment on the output below.

Normally when seeing CF and ST enqueue waits and a lot of time spent in
'enqueue' waits I would suspect the ST enqueue to be the problem, rather
than
the CF enqueue. CF enqueue waits are seldom longer than half a second or so.
The
typical situation is one session doing a controlfile transaction and others
waiting to read the controlfile. It is relatively rare to need to make two
independent changes to the controlfile at the same time. By contrast, the ST
enqueue is held for many seconds when it is taken, and the waiters always
want
an exclusive lock too.

I suggest that you get a few samples of the enqueue waits using my
'enqueue_locks.sql' script. The new version reports the name of any
background
process involved rather than just its sid, which might be helpful here. You
may
also want to hack the script so that it only shows ST and CF enqueues. Then
run
it intermittently until you see something interesting. Then run it several
times
in quick succession to see what happens. If I'm right you see that the CF
waits
are relatively brief, whereas the ST lock contention will be relatively
enduring. If so, I'm sure you'll know what to do.

If it is the CF enqueue that is the source of most of the waits, then
knowing
which sessions are the holders and waiters will be a help in further
diagnosis
anyway.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 2:21
To: Multiple recipients of list ORACLE-L


Dick,
The system is not in archivelog mode. If the database crashed, I was told
they don't care at all. They just rebuilt a shell database and let getter
and feeder processes gradually feed the database. (The getter will check the
url in the datab

RE: ora-07445

2001-02-05 Thread Mohammad Rafiq


Ana,
I am trying to remember about this problem 2 years back with 7.3.4 and if I 
am not wrong it was application related problem which was fixed by our 
developers at that time. It was my previous assignment so I cannot provide 
any further details. ORA-7445 is also like ORA-600 for catch all
situation.
I shall suggest to check application changes when this problem started and 
see notes for 8.0.6 upgrade whether it was fixed in that relaese.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 05 Feb 2001 10:00:26 -0800


Here is what I get in the alert log:

Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:55:20 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15641.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:57:44 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_16105.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []

Thanks

Ana



 "Mohan, Ross"
 
 -SMI.com>cc:
 Sent by: Subject: RE: ora-07445
 root@fatcity.
 com


 02/05/01
 11:55 AM
 Please
 respond to
 ORACLE-L






you show a file from your udump.


what is in your bdump? including your alert log.


-Original Message-
Sent: Monday, February 05, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L





I posted a question to the list last week regarding this error and didn't
get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
Solaris 6.


A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server.  If we shutdown/restart the
database the errors went away.  Starting Friday the errors are happening
when shutting down/starting up the db.  We shutdown the db at midnight and
start it at 2:15 am every day.  We get lots of core dumps and trace files
filling up the file system.  We clean up the files and start the db, after
that we don't receive the errors anymore until next stop/start the db.


I have submitted a tar to Oracle support, but so far they haven't come up
with a solution or a cause for this.  We made the changes they suggested
but it didn't help.  Sun suggested some changes to the hardware, but it
hasn't help either.


Can anyone out there provide some insights on this?  Here is one of our
trace files:


Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
System name:SunOS
Node name:  auoracle1
Release:5.6
Version:Generic_105181-23
Machine:sun4u
Instance name: ORTE
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 4674, image: oracleORTE


Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x626c6568, PC: lxdgetobj()+60
*** 2001.02.05.09.20.39.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
- Call Stack Trace -
calling  call entryargument values in hex
location type point(? means dubious value)
  



Thanks


Ana E. Choto
American University
Washington, DC


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: [EMAIL PROTECTED]


Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (not

Re: Oracle Vs Tera Data

2001-02-05 Thread jkstill

Moving to TeraData was what caused me to leave my previous position.

The idea that Oracle can't handle Terabytes of data is ludicrous.

Pricing?  Plan to spend 5x as much on a Teradata solution.

Star schemas?  Take a look at how Teradata does joins on a Star
schema.  It's ridiculous.   7-11 has a huge multi-terabyte
DW with tables that have Billions of rows.  They can do DW
queries against these stars and return results in 7 minutes.
( old data, probably faster now. )

Teradata was designed as a high speed OLTP database.  I doubt
that they even have much of an advantage in that arena
anymore; I think of them as a legacy app that is fighting
for survival.

Marketability?  Goto monster.com and lookup all the jobs for available
for Teradata, then look up the same thing for Oracle.

Last time I checked it was 69 nationwide for Teradata, 6900 for Oracle.

Do the math.

Jared

On Sun, 4 Feb 2001, Surjit Sharma wrote:

>
> All
>
> I wonder if anyone out there has faced the same dilemma as I am facing
> currently. Our database is likely to grow to a couple of Tera bytes.  The
> existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6
> and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data
> fans that Oracle can't do the following:
>
>Start schema in Oracle is not suitable for datawarehouses.
>Oracle is not scalable to deal with Tera bytes databases.
>Oracle partitioning is not good enough to do the job.
>
> I feel  that Oracle has been working fine on a Sun box with about 200-300
> Gig of data.
> What is the price/performance of say a Sun Box vs Tera Data. I am sure
> there is a huge difference.
>
> I appreciate your valuable thoughts.
>
> Regards
>
> Surjit
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Rachel Carmichael


hm, I like that. I've been working on training people here on the proper 
bribes for the DBA, but they are SLOWWW learners.




>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Pondering Question of the Day-RESPECT
>Date: Mon, 05 Feb 2001 08:55:48 -0800
>
>I have taken the stance with one junior that he now
>has to prove me wrong in anything I tell him.  Loser buys
>the beer.  He owes me quite a bit right now:-)
>
>-Original Message-
>Sent: Friday, February 02, 2001 9:16 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Kimberly,
>
>I could say the same thing of course, the other part is that I 
>convinced
>
>the programmers here that I knew what I was doing by letting them have 
>their
>
>way in development and watching it die... then converting it to what I
>wanted to do and watching it fly. Now they ask my opinion before they do
>anything.
>
>Rachel
>
>
> >From: Kimberly Smith <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Pondering Question of the Day-RESPECT
> >Date: Fri, 02 Feb 2001 08:11:03 -0800
> >
> >I have had that same issue in the past but I don't have it here.  I find
> >that
> >as long as you have your managements support and the development team
> >knows that then life will be much easier.  I am very lucky here in that I
> >have good management and a very well trained senior development team
> >to work with.  Not that there are never disagreements but comprise is the
> >name of the game.  You just got to be picky on what you let them think 
>you
> >are
> >compromising on:-)  I always have more issues with junior/intermediate
> >developers.
> >
> >-Original Message-
> >Sent: Friday, February 02, 2001 7:20 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >"Hello Oracle Guru"
> >
> >Now why is it that I get more respect on the Internet than I do in my
> >workplace.  ??
> >
> >How many of you have this problem?  It's like an ongoing fight with
> >developers, they want carte blanche in the production database, and they 
>do
> >whatever they want EVEN THOUGH I tell them NO, let's do something 
>different
> >that won't affect production.  I go to the CTO because this is like the 
>3rd
> >time this has happened, and he sends out a
> >let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
> >ahead and do what they want ANYWAY.  I'm waiting for the first 
>user-mistake
> >recovery to say STOP, I've had ENOUGH and this is how it's going to be, 
>no
> >ifs, ands or buts.
> >
> >My last job may have been a sweatshop, but at least people respected my
> >authority.  Here, it's a free for all no matter what I do.  Even when I
> >say,
> >Dude, I own the database.  If there's a problem, I have to fix it.
> >Therefore I say what happens in production and what doesn' t happen in
> >production.
> >
> >And yes, I am looking for another position.  I can only take this
> >dba/developer/janitor role for so long.
> >
> >I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
> >somewhere...
> >
> >Lisa Rutland Koivu
> >Oracle Database Administrator
> >Qode.com
> >4850 North State Road 7
> >Suite G104
> >Fort Lauderdale, FL  33319
> >
> >V: 954.484.3191, x174
> >F: 954.484.2933
> >C: 954.658.5849
> >http://www.qode.com 
> >
> >"The information contained herein does not express the opinion or 
>position
> >of Qode.com and cannot be attributed to or made binding upon Qode.com."
> >
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).

Re: Pinning Tables

2001-02-05 Thread John Carlson


What you have found is correct.  You "pin" a package or stored procedure and you 
"cache" a table.

HTH,
John  Carlson


>>> [EMAIL PROTECTED] 02/05/01 07:36AM >>>
Hi all,
I have been trying to find some reference on pinning tables in the SGA.  I
haven't found anything, all that I am finding is table caching and the keep
buffer pool.  Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com 
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED] 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Carlson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

2001-02-05 Thread Jesse, Rich


Actually, not that it matters from what I can tell, but Oracle is tops if
you consider clustered vs. non-clustered.  It seems that Oracle doesn't even
have tests for clustered systems.  I wonder what happened to the VLDB tests
in the huge DEC/Compaq Alpha cluster?
 
As far as SQL (pronounced: "SQueaL") Server "blown the doors off", there are
factors that TPC does not consider.  First, is reliability.  According to
Oracle Magazine, Jan/Feb 2001, p38, "...a 12-computer configuration from
Microsoft, such as that used in recent TPC-C benchmarks, is estimated to
experience a catastophic failure once every 7.5 days, according to
Microsoft's own estimates."  Granted, the quote is from Oramag, but I've
heard the same from other "Industry Sources".
 
I know of a specific implementation where the NT database servers would dog
and/or crash when approximately 500 concurrent users were attached (note:
"attached" <> "active") to the database.  The decision was made to dump NT
for DB serving and go with a major (HP or Sun or IBM) flavor of Unix for
it's scalability and reliability.
 
Second, when was the last time you needed a 500K TPC-C from only 48 clients?
>From a couple thousand, yes, but only 48?  And who's gonna buy everyone in
their company a $7500 desktop PC with twin PIII-800s in them for clients?
While those numbers are specific to the top TPC-C Compaq/MS result, that's
how all these companies get their numbers.
 
I'm not betting my job on TPC-C numbers.  The numbers just don't reflect
real-life situations.
 
And I didn't even touch upon the potential locking problems on SQL Server,
or how it can do dirty reads...  :)
 
Just my $.02.  I need to go create some Oracle databases on HP/UX now.  ;)
 
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Monday, February 05, 2001 09:56
To: Multiple recipients of list ORACLE-L


"NT still pants"...LOL!!! 
 
It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in
running 
SQLServer on NT, as has DB2. 
 
The general public ( and anyone else ) can wake up and smell the coffee at
www.tpc.org  .  
Check out the Top Ten TPC-C marks, by pure performance. 
 
Not interested in pure peformance?  Check out the Price/Performance leaders.
Oracle doesn't
even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our
illusions
 
Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine,
check out ANY
of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't
even show
up. 
 
I mean, I like Oracle, too, butby the time you turn on the multimode
airconditioner, use 
the 12-way adjustable power bucket seats, activate the object-oriented
OnStar Satellite 
navigational system, power up the heated side view mirrors and all the other
tools, trinkets, 
and toys that make it my personal favorite database, there *is* the chance
that the 
twenty year old genius mechanic in the the tricked out Nova next to you at
the light is going 
to kick your ass when the light turns green.
 
But really, I still love Oracle. Warts and all. 
 
Wanna drag?
 
(heh heh heh)
 
 
 
 

-Original Message-
Sent: Saturday, February 03, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


I have actually been doing a fair it of reading on this since the topic was
brought up, and stand corrected, as earlier mentioned. But I have to say
guys that NT is still fairly "pants" when it comes to handling multi
threaded processes.. Win2K is a great improvement but M$ still has a lot of
work to do on in my view. (only when you compare this against UNIX) 
 
Now don't get me wrong, there is enough traffic on this list about this at
the moment, so I dont want more bandwith added with this thread if at all
possible :)
 
Thanks for the reply anyway Yong, I think I will wait for a "good" book on
Win2k to come out (unless you know one?) before I go out and buy one (books
come out of my pocket as I am a sales person mostly).. NT as far as I am
concerned is now in Win2K's shadow, and I think that is the way of the
future for Windowze bound people.
 
For all out there that have used NT and not Win2K - TRY IT.. Services are
handled a LOT better, file management and sharing.. All sorts of new fun
stuff to sink your teeth in to.. 
 
As a side note, for the last line of my first paragraph - I also feel that
UNIX cannot be compared in anyway to Windows at this time. Windowze O/S's
are designed for pointy clicky people that prefer to look at a nice GUI
interface, and generally don't have the indepth technical knowledge that a
good UNIX sys admin does.. 
 
(If there any NT admins out there don't flame me, I have to deal with it
every day of my life...)
 
Regards
 
Mark
 
The views expressed here are soley those coming out of my coffee deprived
hungover mind.. They do not express those of my employers, though I'm sure
they agree :^)

RE: OT RE: Async I/O on Windows

Title: RE: Async I/O on Windows



Well, 
that was certainly a interestingly-reasoned response. I 
haven't
seen 
logic applied like that since...sincesincewell, I have 
never
seen 
such a display of logic.
 
 
Just 
to recap, your arguments are:
 
1) 
"Just because they didn't do a benchmark, doesn't mean they 
can't"
 
    Actually, Oracle submitted a benchmark. Lot's of them. 
Right now, they FAIL to
    top the list in ANY category. 

 
2) 
"Benchmarks are expensive, and so Oracle won't repeat them, because Oracle is 
the best."
 
    I guess, on this basis, we can cancel the Olympics, the 
Tour de France, etc. The major networks 
    could save BOATS of money by letting them in on this 
stunning insight. Come to think of it, 
    this would put Alex Trebek, (the host of Jeopardy! ) out of 
a job. Why keep showing that
    silly show?
 
3) 
They don't factor "scientists" [sic] into Price/Performance benchmarks. 

    
    Wellnot explicitly, no. Just by WINNING 
them!  Ha! Or did I misunderstand, and your
    real complaint was that Microsoft has scientists, and 
Oracle doesn't?
 
4)  "Can you do a benchmark?"
 
    No; properly done and referred, they cost about six figures. 
I have found it far more cost-effective
    to read the results. Of course, having an entirely 
uninformed opinion is highly cost effective, too.
 
 
 
 
 -Original Message-From: 
Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 
2001 2:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on 
Windows

  Just 
  because Oracle hasn't done a benchmark doesn't mean Oracle can't out perform 
  SQL-Server or DB2.  Benchmark is very expensive to do, Oracle doesn't 
  need to prove to the world every year that it is the best.  Oracle has 
  the reputation that MS and IBM don't have.  That's why MS and IBM needs 
  to do it.  And do you know how many scientists MS had to do that 
  benchmark?  I wonder if they factor that into 
  the Price/Performance.  Can you (do you) have the same resources in 
  the real world to achive that result?  Needless to say performance is not 
  the only thing you measure a DB.  How good is SQL-Server when the 
  underlying OS crashes so often?
   
  Richard Ji
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Monday, February 05, 2001 10:56 AMTo: Multiple recipients of list 
ORACLE-LSubject: OT RE: Async I/O on Windows
"NT still pants"...LOL!!! 
 
It must be 
panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running 

SQLServer on NT, as has DB2. 
 
The general public ( and anyone else ) can wake up and smell the 
coffee at www.tpc.org.  

Check out the Top Ten TPC-C marks, by pure performance. 

 
Not interested in pure peformance?  Check out the 
Price/Performance leaders. Oracle doesn't
even SHOW UP in the top ten. What a shocker, eh? It's painful to lose 
our illusions
 
Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? 
Fine, check out ANY
of 
the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't 
even show
up. 
 
I 
mean, I like Oracle, too, butby the time you turn on the multimode 
airconditioner, use 
the 12-way adjustable power bucket seats, 
activate the object-oriented OnStar Satellite 
navigational system, power up the heated 
side view mirrors and all the other tools, trinkets, 
and toys that make it my personal 
favorite database, there *is* the chance that the 
twenty year old genius mechanic in the the tricked 
out Nova next to you at the light is going 
to 
kick your ass when the light turns 
green.
 
But really, I still love Oracle. Warts and all. 
 
Wanna drag?
 
(heh heh heh)
 
 
 
 

  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED]]Sent: Saturday, February 03, 2001 
  6:45 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Async I/O on Windows
  I have actually been doing a fair it of reading 
  on this since the topic was brought up, and stand corrected, as earlier 
  mentioned. But I have to say guys that NT is still fairly "pants" when it 
  comes to handling multi threaded processes.. Win2K is a great improvement 
  but M$ still has a lot of work to do on in my view. (only when you compare 
  this against UNIX) 
   
  Now don't get me wrong, there is enough traffic 
  on this list about this at the moment, so I dont want more bandwith added 
  with this thread if at all possible :)
   
  Thanks for the reply anyway Yong, I think I will 
  wait for a "good" book on Win2k to come out (unless you know one?) before 
  I go out and buy one (books come out of my pocket as I am a sales 
  person mos

Re: User objects in System tablespace

2001-02-05 Thread exu




You can use export/import to move  non-sys owned tables to a proper tablespaces.

Eveleen



Please respond to [EMAIL PROTECTED]


"Sanjay Kumar" <[EMAIL PROTECTED]> on 02/05/2001 11:50:52 AM


  Message - From: "Sanjay Kumar" <[EMAIL PROTECTED]> on 02/05/2001 05:50 PM  
 GMT




  
  
  
 To:  Multiple recipients of list ORACLE-L
  <[EMAIL PROTECTED]>  
  
 cc:  (bcc: Eveleen Xu/NNIB/NNNG) 
  
  
  
 Subject: User objects in System tablespace   
  






Hi,

I have a situation where in all the user related objects (tables) have been
created in System tablespace.

I believe there is no convention followed while creating these tables.

Now, how do I separate these user related objects and put them in Users
tablespace?

Vinay




Hi,
 
I have a situation where in all the user related 
objects (tables) have been created in System tablespace.
 
I believe there is no convention followed while 
creating these tables. 
 
Now, how do I separate these user related objects 
and put them in Users tablespace?
 
Vinay

RE: User objects in System tablespace




Roerg 
the tables, and specify the user tablespace..

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sanjay KumarSent: 
  Monday, February 05, 2001 05:51To: Multiple recipients of list 
  ORACLE-LSubject: User objects in System 
  tablespace
  Hi,
   
  I have a situation where in all the user related 
  objects (tables) have been created in System tablespace.
   
  I believe there is no convention followed while 
  creating these tables. 
   
  Now, how do I separate these user related objects 
  and put them in Users tablespace?
   
  Vinay

RE: Pinning Tables

2001-02-05 Thread Raj Gopalan


alter table  cache;

-Original Message-
Sent: 05 February 2001 15:36
To: Multiple recipients of list ORACLE-L


Hi all,
I have been trying to find some reference on pinning tables in the
SGA.  I
haven't found anything, all that I am finding is table caching and the keep
buffer pool.  Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows


I am running ORacle8i on Windows2000 and for what I use
it for I see no difference from NT.

-Original Message-
Sent: Monday, February 05, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L


Ross & Mark,
There are no major performance concerns here (and we get 
Oracle "free" {system wide educational site license} - 
unlike MS/SQL), so what I want to know is: does Oracle8 
generally work well on Windows 2000 server (compared to 
running it on NT4)? We will be running on this hardware:
IBM Netfinity5100 w/ RAID (dedicated Oracle server, w/
web server on same box, if possible).

My assumption is that Win2k/Oracle8 is "ok". Are there any
horror stories out there about running Oracle8 on Win2K
where running on NT4 would have been better?

thanks!
ep

On 5 Feb 2001, at 9:25, Mark Leith wrote:

Date sent:  Mon, 05 Feb 2001 09:25:25 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>

> RE: Async I/O on WindowsWHOOO a SQLServer vs. Oracle debate
again!!

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Ascii code of tab?

2001-02-05 Thread Guidry, Chris


I believe chr(9).

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Viktor [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 11:57 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Ascii code of tab?
> 
> What is ascii code of TAB?
> 
> Thanks
> 
> __
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Viktor
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

2001-02-05 Thread Troiano, Paul (CAP, GEFA)


You might want to check those results again. Oracle has the top three in the TP-C, 
nonclustered results. With the clustered results Oracle has the highest for 1 
CPU/client. Everything above them has 2 CPU/client. The configuration is important. MS 
SQL Server's configuration for
their highest rating was absurd (192 CPU's). 
 
- Paul
 
 -Original Message-
Sent: Monday, February 05, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L



"NT still pants"...LOL!!! 
 
It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running 
SQLServer on NT, as has DB2. 
 
The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org 
 .  
Check out the Top Ten TPC-C marks, by pure performance. 
 
Not interested in pure peformance?  Check out the Price/Performance leaders. Oracle 
doesn't
even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions
 
Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY
of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show
up. 
 
I mean, I like Oracle, too, butby the time you turn on the multimode 
airconditioner, use 
the 12-way adjustable power bucket seats, activate the object-oriented OnStar 
Satellite 
navigational system, power up the heated side view mirrors and all the other tools, 
trinkets, 
and toys that make it my personal favorite database, there *is* the chance that the 
twenty year old genius mechanic in the the tricked out Nova next to you at the light 
is going 
to kick your ass when the light turns green.
 
But really, I still love Oracle. Warts and all. 
 
Wanna drag?
 
(heh heh heh)
 
 
 
 

-Original Message-
Sent: Saturday, February 03, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


I have actually been doing a fair it of reading on this since the topic was brought 
up, and stand corrected, as earlier mentioned. But I have to say guys that NT is still 
fairly "pants" when it comes to handling multi threaded processes.. Win2K is a great 
improvement but M$ still
has a lot of work to do on in my view. (only when you compare this against UNIX) 
 
Now don't get me wrong, there is enough traffic on this list about this at the moment, 
so I dont want more bandwith added with this thread if at all possible :)
 
Thanks for the reply anyway Yong, I think I will wait for a "good" book on Win2k to 
come out (unless you know one?) before I go out and buy one (books come out of my 
pocket as I am a sales person mostly).. NT as far as I am concerned is now in Win2K's 
shadow, and I think that is
the way of the future for Windowze bound people.
 
For all out there that have used NT and not Win2K - TRY IT.. Services are handled a 
LOT better, file management and sharing.. All sorts of new fun stuff to sink your 
teeth in to.. 
 
As a side note, for the last line of my first paragraph - I also feel that UNIX cannot 
be compared in anyway to Windows at this time. Windowze O/S's are designed for pointy 
clicky people that prefer to look at a nice GUI interface, and generally don't have 
the indepth technical
knowledge that a good UNIX sys admin does.. 
 
(If there any NT admins out there don't flame me, I have to deal with it every day of 
my life...)
 
Regards
 
Mark
 
The views expressed here are soley those coming out of my coffee deprived hungover 
mind.. They do not express those of my employers, though I'm sure they agree :^)

-Original Message-
Sent: Friday, February 02, 2001 07:00
To: Multiple recipients of list ORACLE-L



Oracle on NT runs as 

ONE PROCESS 

with 

MULTIPLE THREADS 


for performance reasons (no more 
need for shared memorycontext switches 
are a LOT less expensive, etc.) 


-Original Message- 
Sent: Friday, February 02, 2001 12:51 PM 
To: Multiple recipients of list ORACLE-L 


Hi, Mark, 

Async I/O is available on Windows, at least NT. It's not an easy topic. If you 
think you already know enough about operating systems in general, I suggest you 
read David Solomon's "Inside WindowsNT". For a lab test, launch Performance 
Monitor on your NT box and look at the counters for Cache. 

I'm not sure by "single thread management" whether you mean NT can't have 
multiple processes or Oracle on NT runs as one thread. The former is obviously 
wrong. The latter is a design issue inside Oracle Corporation and the question 
as to why was asked on this forum before without an answer (without an answer I 
can remember, that is). 

Yong Huang 
[EMAIL PROTECTED] 

you wrote: 

Asynch I/O on a Windowze box? supresses a snigger... 

To the best of my knowledge there are no Windows based system that can take 
advantage of this, single thread management can be enough a problem 
sometimes.. 

But, I may be wrong.. List? 

__ 
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.c

Re: Pinning Tables

2001-02-05 Thread exu




Only  method (which I am aware of )  to pin objects in SGA is DBMS_SHARED_POOL
package. However,  this package does not support pinning tables and views.

I am curious if there is a way to pin a table/view.


Eveleen




Please respond to [EMAIL PROTECTED]


"Kevin Kostyszyn" <[EMAIL PROTECTED]> on 02/05/2001 09:36:13 AM


  Message - From: "Kevin Kostyszyn" <[EMAIL PROTECTED]> on 02/05/2001 03:36 PM  
 GMT




  
  
  
 To:  Multiple recipients of list ORACLE-L
  <[EMAIL PROTECTED]>  
  
 cc:  (bcc: Eveleen Xu/NNIB/NNNG) 
  
  
  
 Subject: Pinning Tables  
  






Hi all,
 I have been trying to find some reference on pinning tables in the SGA.  I
haven't found anything, all that I am finding is table caching and the keep
buffer pool.  Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-01187: cannot read from file 1 because it failed verification

2001-02-05 Thread Tony Guo

Title: RE: Async I/O on Windows




Does 
anyone know what this error means?  What caused this 
error?
TIA
 SVRMGR> alter database 
open;
alter database open
*
ORA-01187: cannot read from file 1 because it 
failed verification tests
ORA-01110: data file 1: '/opt/oracle/oradata /system01.dbf'

RE: Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.


Let me rephrase it.  The user defined in the database link has insert
permissions on table-a.  The user calling the database link does not have
any permissions on any table in database-b.

Ron

-Original Message-
Sent: Monday, February 05, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L


Doesn't your second example say that ' Userid-2 has no permissions on
table-a in database-b'?

Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 10:30 AM


> I'm sorry.  The error is not that the user cannot use the database link.
> The error is that Oracle does not want the user to update table-a in
> database-b even though the user has update permissions.
>
> Ron
>
> -Original Message-
> Sent: Monday, February 05, 2001 8:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> You should set up synonyms which define the tables@public_dblink in
database
> b. Put these synonyms in database a. Then anyone can use the linked tables
> from the package in database a.
>
> HTH,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, February 05, 2001 8:35 AM
>
>
> > I have a public database link defined with userid-1.
> > Userid-1 has update permissions on table-a in database-b.
> > Userid-2 has no permissions on table-a in database-b.
> > Userid-2, in database-a, calls a package that contains the database link
> and
> > tries to update table-a in database-b.
> > The result is an Oracle error that states insufficient privileges on
> > table-a.
> >
> > Can anyone help?
> >
> > Ron Smith
> > Database Administration
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Smith, Ron L.
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed fro

RE: ora-07445

Title: RE: ora-07445





nothing before or after?


no checkpointing? no archiving?  whats was going
on from, say, 12 noon  or so?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ora-07445




Here is what I get in the alert log:


Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:55:20 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15641.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb  5 12:57:44 2001
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_16105.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []


Thanks


Ana



   
    "Mohan, Ross"  
       
    -SMI.com>    cc:   
    Sent by: Subject: RE: ora-07445    
    root@fatcity.  
    com    
   
   
    02/05/01   
    11:55 AM   
    Please 
    respond to 
    ORACLE-L   
   
   





you show a file from your udump.



what is in your bdump? including your alert log.



-Original Message-
Sent: Monday, February 05, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L






I posted a question to the list last week regarding this error and didn't
get any responses.  I'm trying again.  We're on Oracle 8.0.5.2.1, and
Solaris 6.



A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server.  If we shutdown/restart the
database the errors went away.  Starting Friday the errors are happening
when shutting down/starting up the db.  We shutdown the db at midnight and
start it at 2:15 am every day.  We get lots of core dumps and trace files
filling up the file system.  We clean up the files and start the db, after
that we don't receive the errors anymore until next stop/start the db.



I have submitted a tar to Oracle support, but so far they haven't come up
with a solution or a cause for this.  We made the changes they suggested
but it didn't help.  Sun suggested some changes to the hardware, but it
hasn't help either.



Can anyone out there provide some insights on this?  Here is one of our
trace files:



Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle02/app/oracle/product/8.0.5
System name:    SunOS
Node name:  auoracle1
Release:    5.6
Version:    Generic_105181-23
Machine:    sun4u
Instance name: ORTE
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 4674, image: oracleORTE



Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x626c6568, PC: lxdgetobj()+60
*** 2001.02.05.09.20.39.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
- Call Stack Trace -
calling  call entry    argument values in hex
location type point    (? means dubious value)
  
---

Bitmap index

2001-02-05 Thread Bala, Prakash


Hi DBAs,

Oracle 8.1.6 on Sun; DW environment:

Have a table that gets populated by SQL*Loader and thereafter lots of
queries go against this table using different combinations of 4 columns
(date, varchar2(6), varchar2(5), char(1)). Once a row is processed, the
char(1) column gets updated from null to 'Y'. There are no updates to any
other columns or no deletes. Roughly 1000 rows gets inserted to this table
every day.

When I tried 'explain plain' for different queries, I find that a bitmap
index on these 4 columns performs much better than a normal index. Before
implementing this, would like to get your ideas on this.

Appreciate any help!

Prakash
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bala, Prakash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Ascii code of tab?

2001-02-05 Thread Viktor


What is ascii code of TAB?

Thanks

__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Ascii code of tab?

2001-02-05 Thread Ari D Kaplan


It is CHR(9):

SELECT column_1||chr(9)||column_2 FROM table_name;

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant
Founder/CEO, PocketDBA Systems -- Wireless Database Management Now
www.pocketdba.com

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 400+ Oracle tips, visit:   <->
<-><->
<-> www.arikaplan.com  <->
<-><->
<-> email: [EMAIL PROTECTED]   <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->


On Mon, 5 Feb 2001, Viktor wrote:

> What is ascii code of TAB?
> 
> Thanks
> 
> __
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Viktor
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ari D Kaplan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: Async I/O on Windows

2001-02-05 Thread Scott . Shafer


> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 9:56 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT RE: Async I/O on Windows
> 

>  
> Wanna drag?
>  
> (heh heh heh)
>  
>  Well, I'd have to shave my legs, but for the right amount of money...
> I'm game...  
> 
--Scott

"I was meant to be born rich and shameless.  One out of two isn't
bad..."
>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Index Usage Monitoring

2001-02-05 Thread exu




I do know there is a way to tell which indexes are accessed most recently by
query x$bh view.  Is this what you want or something different? Sorry  I forgot
the initial posting of this issue.

Eveleen



Please respond to [EMAIL PROTECTED]


Vadim Gorbounov <[EMAIL PROTECTED]> on 02/05/2001 09:30:47 AM


  Message - From: Vadim Gorbounov <[EMAIL PROTECTED]> on 
 02/05/2001 03:30 PM GMT




  
  
  
 To:  Multiple recipients of list ORACLE-L
  <[EMAIL PROTECTED]>  
  
 cc:  (bcc: Eveleen Xu/NNIB/NNNG) 
  
  
  
 Subject: RE: Index Usage Monitoring  
  






 Hi,
 Why not to use otrace? Of cource, you may need some space to save
trace results, but you'll definitely get complete statistics.

 Vadim Gorbounov
 Oracle DBA

-Original Message-
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L


We have a purchased application with over 1,300 indexes.

Can someone suggest a method to monitor the system to
determine which indexes are actively being used over time?  I'm assuming
that some are old/not necessary and would like to save the overhead
of maintaining them.

Oracle 8.0.6


 Patrick Prince   email: [EMAIL PROTECTED]
 Omaha Public Power District   voice: (402) 636-3762
 444 S 16th St. Mall, Omaha, NE 68102fax: (402) 636-3931


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: PRINCE, PATRICK W.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Ascii code of tab?

2001-02-05 Thread David Barbour


^I   Dec - 9   Oct - 011   Hex - 09

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, February 05, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L


What is ascii code of TAB?

Thanks

__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Barbour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Stephen Andert


Rachel:

I miss a couple of my old jobs where I has other roles (developer/dba and network & 
admin/helpdesk/etc) where I got quite a few people trained real well :) I could count 
on a snack from several people a week.  Although I guess that could be seen from their 
side as "We sure got this guy trained better than the last IT guy here!"  

Stephen

>>> [EMAIL PROTECTED] 02/05 11:35 AM >>>
hm, I like that. I've been working on training people here on the proper 
bribes for the DBA, but they are SLOWWW learners.




>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Pondering Question of the Day-RESPECT
>Date: Mon, 05 Feb 2001 08:55:48 -0800
>
>I have taken the stance with one junior that he now
>has to prove me wrong in anything I tell him.  Loser buys
>the beer.  He owes me quite a bit right now:-)
>
>-Original Message-
>Sent: Friday, February 02, 2001 9:16 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Kimberly,
>
>I could say the same thing of course, the other part is that I 
>convinced
>
>the programmers here that I knew what I was doing by letting them have 
>their
>
>way in development and watching it die... then converting it to what I
>wanted to do and watching it fly. Now they ask my opinion before they do
>anything.
>
>Rachel
>
>
> >From: Kimberly Smith <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED] 
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Pondering Question of the Day-RESPECT
> >Date: Fri, 02 Feb 2001 08:11:03 -0800
> >
> >I have had that same issue in the past but I don't have it here.  I find
> >that
> >as long as you have your managements support and the development team
> >knows that then life will be much easier.  I am very lucky here in that I
> >have good management and a very well trained senior development team
> >to work with.  Not that there are never disagreements but comprise is the
> >name of the game.  You just got to be picky on what you let them think 
>you
> >are
> >compromising on:-)  I always have more issues with junior/intermediate
> >developers.
> >
> >-Original Message-
> >Sent: Friday, February 02, 2001 7:20 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >"Hello Oracle Guru"
> >
> >Now why is it that I get more respect on the Internet than I do in my
> >workplace.  ??
> >
> >How many of you have this problem?  It's like an ongoing fight with
> >developers, they want carte blanche in the production database, and they 
>do
> >whatever they want EVEN THOUGH I tell them NO, let's do something 
>different
> >that won't affect production.  I go to the CTO because this is like the 
>3rd
> >time this has happened, and he sends out a
> >let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
> >ahead and do what they want ANYWAY.  I'm waiting for the first 
>user-mistake
> >recovery to say STOP, I've had ENOUGH and this is how it's going to be, 
>no
> >ifs, ands or buts.
> >
> >My last job may have been a sweatshop, but at least people respected my
> >authority.  Here, it's a free for all no matter what I do.  Even when I
> >say,
> >Dude, I own the database.  If there's a problem, I have to fix it.
> >Therefore I say what happens in production and what doesn' t happen in
> >production.
> >
> >And yes, I am looking for another position.  I can only take this
> >dba/developer/janitor role for so long.
> >
> >I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
> >somewhere...
> >
> >Lisa Rutland Koivu
> >Oracle Database Administrator
> >Qode.com
> >4850 North State Road 7
> >Suite G104
> >Fort Lauderdale, FL  33319
> >
> >V: 954.484.3191, x174
> >F: 954.484.2933
> >C: 954.658.5849
> >http://www.qode.com 
> >
> >"The information contained herein does not express the opinion or 
>position
> >of Qode.com and cannot be attributed to or made binding upon Qode.com."
> >
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com 
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Kimberly Smith
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538

RE: OT RE: Async I/O on Windows

Title: RE: OT RE: Async I/O on Windows





LOL!


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows



> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 9:56 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT RE: Async I/O on Windows
> 
    
>  
> Wanna drag?
>  
> (heh heh heh)
>  
>  Well, I'd have to shave my legs, but for the right amount of money...
> I'm game...  
> 
    --Scott


    "I was meant to be born rich and shameless.  One out of two isn't
bad..."
>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-01187: cannot read from file 1 because it failed verifica

2001-02-05 Thread Koivu, Lisa

Title: RE: Async I/O on Windows



You 
may want to run dbverify on this and see if the datafile is corrupted. 


  -Original Message-From: Tony Guo 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 3:12 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-01187: cannot read from file 1 because it failed 
  verification
  
  Does anyone know what this error means?  What caused this 
  error?
  TIA
   SVRMGR> alter database 
  open;
  alter database open
  *
  ORA-01187: cannot read from file 1 because it 
  failed verification tests
  ORA-01110: data file 1: 
  '/opt/oracle/oradata /system01.dbf'

RE: OT RE: Async I/O on Windows