date:20010206


Ray,

I had a similar discussion a long time ago. Alter table cache or using
buffer keep is a way for caching or allocating a table in a different
buffer. Pining is a concept relate with shared pool and sql code.

Regards.

> -Mensaje original-
> De:   Raj Gopalan [SMTP:[EMAIL PROTECTED]]
> Enviado el:   lunes 5 de febrero de 2001 19:46
> Para: Multiple recipients of list ORACLE-L
> Asunto:   RE: Pinning Tables
> 
> 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).
-- 
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: Index Usage Monitoring


Or set a cron to check periodically the sql area. With something like this:

set serverout on
set termout off
spool $SPOOLNAME
declare 
-- exclude statements with v$sqlarea.parsing_schema_id = 0 (SYS) 
cursor c1 is select address, sql_text, DISK_READS, EXECUTIONS, 
PARSE_CALLS 
from v$sqlarea wherecommand_type in (2,3,6,7) 
and parsing_schema_id != 0; 
cursor c2 is select addr, sql_text from sqltemp; 
addr2 varchar(16); 
sqltext v$sqlarea.sql_text%type; 
dreads v$sqlarea.disk_reads%type; 
execs v$sqlarea.executions%type; 
pcalls v$sqlarea.parse_calls%type; 
begin 
open c1; 
fetch c1 into addr2,sqltext,dreads,execs,pcalls; 
while (c1%found) loop 
insert into sqltemp
values(addr2,sqltext,dreads,execs,pcalls); 
commit; 
fetch c1 into addr2,sqltext,dreads,execs,pcalls; 
end loop; 
close c1; 
open c2; 
fetch c2 into addr2, sqltext; 
while (c2%found) loop 
do_explain(addr2,sqltext); 
fetch c2 into addr2, sqltext; 
end loop; 
close c2; 
dbms_output.put_line('Ejecutado sin inconvenientes');
exception when others then
dbms_output.put_line('ERROR: '||sqlerrm(sqlcode));
end; 
/
spool off



> -Mensaje original-
> De:   Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
> Enviado el:   lunes 5 de febrero de 2001 16:31
> Para: Multiple recipients of list ORACLE-L
> Asunto:   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: 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: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

2001-02-06 Thread Holman, Rodney

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE



Ross,
I was 
at the Open World conference session where Jeremy Burton made the comments about 
clustering, OPS, data segmentation, etc.  The data segmentation part was 
about MS SQLServer, and about how it creates significant work to add cluster 
nodes. C|net has their terms and comments a little scrambled.  The Oracle 
9i solution used OPS for the instances and an EMC/SRDF SAN for the data 
storage.  Each OPS cluster node had full access to every piece of 
data.  By doing this no node is a single point of failure (as Larry 
demonstrated and was chastised for by MS).  Also it creates greater 
capability for scalability.  Just configure and add a node and it improves 
performance (also part of Larry's demo).  As described with the MS 
federated database configuration you would need to resegment the data to add a 
node.  This would then destabilize the system even further by adding 
another single point of failure.  Failure of an OPS cluster node with the 
data on a SAN  with redundancy, such as the EMC/SRDF option, only decreases 
performance, it doesn't kill the operation of the system.
 
Rodd 
Holman

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 5:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT RE: Async I/O on Windows - WHAT is a FEDERATED 
DATABASE
  Very Interesting!  It appears Oracle 9i, is, in fact, a 
  Hybrid Federated Database! 
  http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni 
  
  A snippet:

Re: Anyone know about x_$kcccp?

2001-02-06 Thread Danisment UNAL


Hello,

x$kcccp shows CHECKPOINT PROGRESS RECORDS in
controlfile.

If you are interested in internals, see thread in
http://pipetalk.revealnet.com/read?63845,59

regards...

--- "Terrian, Thomas"
<[EMAIL PROTECTED]> wrote:
> Can anyone explain this?
> My understanding of sys.x_$kcccp is that it has the
> current log file
> information in it.  But mine seems very old:
> 
> SQL> select cpodr_seq, cpodr_bno from sys.x_$kcccp;
> 
> CPODR_SEQ CPODR_BNO
> ----
> 23904 2658
> 
> 1 row selected.
> 
> SQL> select sequence#, status from v$log;
> 
> SEQUENCE# STATUS
> --
> 23907 INACTIVE
> 23908 CURRENT
> 
> 2 rows selected.
> 
> 
> Can anyone explain this?
> 
> Thanks,
> Tom Terrian
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Terrian, Thomas
>   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).


=
---
Danisment Gazi Unal
Web: http://www.geocities.com/danisment
---

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment UNAL
  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: Creating indexes in seperate tablespace

2001-02-06 Thread Arul kumar



Hi John,
Here is the answer:
CREATE TABLE salgrade
   ( grade  NUMBER  CONSTRAINT pk_salgrade
   
PRIMARY KEY
   
USING INDEX TABLESPACE users_a,
 losal  NUMBER,
 hisal  NUMBER )
   TABLESPACE human_resource
   STORAGE (INITIAL 6144
 NEXT   
6144
 MINEXTENTS
1
 MAXEXTENTS
5 );
regards,
Arul.
John Dunn wrote:
We have tables with primary keys, which result in
indexes being created. We
do not explicitly create indexes.
How can I ensure that indexes are created in a seperate tablespace from
the
tables?
Can I specify this in the create table statement?
Oracle version is 8.1.6
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  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: User objects in System tablespace

2001-02-06 Thread nlzanen1



Hi,


It's gonna be trial and error I guess,

But compare the objects with those in a clean install of oracle.
Also the object ID only goes up and supposed to be SYS objects are usually
created first.


Jack


   
  
"Sanjay Kumar" 
  
 
ail.com> cc:   
  
Sent by: Subject: Re: User objects in System 
tablespace  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
05-02-2001 
  
23:21  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Thanks to those who responded.

I also have another question.

How do I distinguish between the non-system tables and system tables.?

This user has created all the application related tables as User SYS. I
would like filter them and give a new tablespace.

Thanks
Sanjay
 - Original Message -
 From: Mark Leith
 To: Multiple recipients of list ORACLE-L
 Sent: Monday, February 05, 2001 10:45 AM
 Subject: 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
  Kumar
  Sent: Monday, February 05, 2001 05:51
  To: Multiple recipients of list ORACLE-L
  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



=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that

RE: Pinning Tables


Look for buffer keep in the documentation.

> -Mensaje original-
> De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Enviado el:   lunes 5 de febrero de 2001 19:53
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Re: Pinning Tables
> 
> 
> 
> 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).
-- 
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: Reg. SPOOL in SQL*PLUS

2001-02-06 Thread nlzanen1



Hi,


Try

column seq new_value seq noprint
select LTRIM(test_seq.nextval)  seq from dual;
spool c:\test_&seq..lst
spool off



Met vriendelijke groet,

Jacob van Zanen
(Oracle DBA) Informatie Systemen

Ernst & Young
Informatie & Communicatie Technologie

Kantoor Gouda
Tel.: 0182 575316 (intern: 923 316)
Fax: 0182 536311
E-mail: [EMAIL PROTECTED]



   
  
Arul kumar 
  
 
drabt.com>   cc:   
  
Sent by: Subject: Reg. SPOOL in SQL*PLUS   
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
06-02-2001 
  
05:45  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Hi DBAs,


I would like to know the way for specifying a filename dynamically in SQL
PLUS.


Say, for example


The file name should be suffixed with a sequence number available from a
SEQUENCE object. ( like SPOOL ||seq1.nextval).


Any idea?


Thank You,
Arul.







=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





--
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

Using timers on a database stored procedure

2001-02-06 Thread Sergio Boix Moriano



Hi all,

We need to use timers on a stored procedure, from a compiled
form we've used the included built-ins to this (create_timer, etc), but
how can we use this from the database.

Thanks in advance for all your responses.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sergio Boix Moriano
  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: Creating indexes in seperate tablespace

2001-02-06 Thread Arun Aggarwal


Yes,

when you specify the primary key in the create table statement also mention
USING INDEX TABLESPACE, this way you can ensure that the index is created in
separate tablespace

Regards
Arun Aggarwal
Aithent Technologies (P) Ltd.
[EMAIL PROTECTED]
+91-11-6920905 (35)

"If I knew what I was so anxious about, I wouldn't be so anxious."
--Mignon McLaughlin

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 14:12


> We have tables with primary keys, which result in indexes being created.
We
> do not explicitly create indexes.
>
> How can I ensure that indexes are created in a seperate tablespace from
the
> tables?
>
> Can I specify this in the create table statement?
>
> Oracle version is 8.1.6
>
> John
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
>   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: Arun Aggarwal
  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).

table access via Browser

2001-02-06 Thread Jäck Stephan


Hi,

what would you prefer to have a simple way to view and modify 
table-data of an oracle-DB by a browser?

Is there a simpler way to go than OAS/iAS?
Any ODBC-plugins? 
Has WebDB features that can be used?

Any comments are welcome.

Thanks
Stephan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?J=E4ck_Stephan?=
  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: Creating indexes in seperate tablespace

2001-02-06 Thread nlzanen1



Yes


Somewhere you create Primary Keys in your create statements just add

Using index tablespace 



Jack


   
  
John Dunn  
  
 
as.co.uk>cc:   
  
Sent by: Subject: Creating indexes in seperate 
tablespace
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
06-02-2001 
  
09:42  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



We have tables with primary keys, which result in indexes being created. We
do not explicitly create indexes.

How can I ensure that indexes are created in a seperate tablespace from the
tables?

Can I specify this in the create table statement?

Oracle version is 8.1.6

John



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  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).




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

Re: Creating indexes in seperate tablespace

2001-02-06 Thread chaos


John Dunn£¬ÄúºÃ£¡
  u can use a clause in the create table command to specify the details of the 
primary key,or alter table to add constraint ,using index clause to specify the detail 
about the index.
for example:
sql>create table pk
(name char(8),
 age  number);
sql> alter table pk add constraint pk1  primary key (name)
 using index
 tablespace system;
or in create table command:
SQL> create table pk
  2  (name char(8) primary key using index tablespace system,
  3   num  number);
this also works.



ÔÚ 2001-2-6 0:42:00 ÄúÐ´µÀ£º
>We have tables with primary keys, which result in indexes being created. We
>do not explicitly create indexes.
>
>How can I ensure that indexes are created in a seperate tablespace from the
>tables?
>
>Can I specify this in the create table statement?
>
>Oracle version is 8.1.6
>
>John
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: John Dunn
>  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).

ÖÂ
Àñ£¡

chaos
[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: chaos
  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-06 Thread Marin Dimitrov


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 17:36

> 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.


try ALTER TABLE xxx  STORAGE(BUFFER_POOL KEEP);

when the table blocks are first accessed they should go to the KEEP buffer
and if it is big enough they should  never be flushed out (take a look at
the BUFFER_POOL_KEEP init.ora parameter).


several people mentioned ALTER TABLE xxx CACHE; but this is different from
"pinning" because it will just instruct the server to place the table blocks
on the "most recently used" end of the buffer pool (instead on the "least
recently used" one)  if full table scan is performed and sooner or later
they would probably be flushed out.

hth,

Marin



"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


Herman Hesse, "Siddhartha"


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  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).

Reporting database

2001-02-06 Thread Terrian, Thomas


How are you all creating reporting databases?  We currently have an OLTP
database and we wish to create a reporting database from it.  As I see it,
we have the following options:

1.  Create the reporting database as a Standby database.  I don't think that
this will work since the database must be up and not in standby mode.
2.  Use Oracle replication.  I have heard it is cumbersome and has trouble
keeping up with lots of transactions.
3.  Snapshots/materialized views.
4.  Beef up our current machine so that it can handle OLTP transactions and
reports.
5.  Since we are using a BMC disk array, we could break the mirror
periodically and mount the disks on a new machine.
6.  Other 3rd party replication products.
7.  We could probably use some type of import/exports.

How are the rest of you doing it?  Are there any other options that I
forgot?

Thanks,
Tom


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terrian, Thomas
  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

2001-02-06 Thread Mark Leith


Ep,

I have 8i running concurrently on a Win2k system with SS7, and have to say
that it still runs like a dream. Like I mentioned earlier Oracle is still my
favourite databeast, but there are a few things that still cough and
splutter - like OEM for example. The Java side of things can be a little
painful, but as I understand it is mostly on all platforms, as Oracle still
haven't got it just right - though 9i again is "supposed" to be a great
improvement on how the JVM is managed.

Win2K has better service management - unless I didn't notice under NT -
where if a service fails, you can first try and restart the service, if that
fails, you can run a file - whatever it may be - and if THAT fails you can
reboot the machine automatically, and cross your fingers that the service
starts properly with spewing nasty error messages at you.

I have been using Win2k for around 4 months now and have NEVER seen a BSOD
(Blue Screen of Death), I reboot quite often - granted - but that is only
because LookOut keep trying to dial my mail server, gets it knickers in a
twist, hangs, gives me a mail delivery error, trys again, then comes back
telling me the phone entry it already being dialed!! So because I can't live
without my Lyris "Family" I have to reboot the bloody thing. I have only
once had to reboot when installing new software, and that was because the
dongle wasn't recognized properly.

All in all Win2K is far and above NT 4 in my view. File management is
handled a lot better, you can have online network drives, even if the
network machine is down.. IIS is OK but I can't see a business need for it
though..

Oh, and they have even added the lovely little desktops themes available
with Windows 98, but not NT.. Now, I have to say, this little feature is the
one that sold it for me :)

Give it a try Eric, if you are used to NT, you may be pleasantly suprised..

Regards

Mark

P.S Win2K was Built on NT Technology according to the new splash screen.. It
can only improve right? Right? Micrslop? hardy har har har...



-Original Message-
Pierce
Sent: Monday, February 05, 2001 07:06
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: 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: RE: OT NT2K vs Unix.

2001-02-06 Thread Anderson, Brian


The future of computers, look at the games of today.



 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]


> -Original Message-

> are some that I can think of).  Heck, I wouldn't be surprised 
> if the code
> for some database query optimizers trace back to some gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  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 - WHAT is a FEDERATED DATABASE ???

Title: RE: OT - WHAT is a FEDERATED DATABASE ???

Ross, glad to see you're starting to come up to speed here. :>)

|| Only with the help of the listers, Steve! Thanks..

> But for the clustering to work, businesses would have to change software
> and segment the data

The CNet authors obviously got tangled up in their notes and didn't
understand what they were writing about. (Not a first.) You don't have to
"segment the data" in OPS-

|| right, but.maybe they meant PARTITIONED data?

that's the "federated database" scene where you
place different tables for the same database app on different servers. If
you segment an enterprise package like SAP or Oracle ERP then you have
1000's of tables to deal with. Chances are, no matter how "intelligently"
you segment your data, just losing any random machine, and its attendant
subset of tables, will bring the application to a halt and no more
transactions will be possible even though the database is still "up."

|| I don't know about that. I know if i lose one-tenth of my EMP table,
I can still query the other 9/10thsbut you have a specific type
of failure in mind?

That's a single point a failure and that's the real problem.

|| Single points of failure are the first places to look for
weaknesses, yes. There is also of concept of "partial failure"
or service brownout. (Versus "the-sky-is-falling" catastrophic
failure.)

And to add a machine to the federated cluster you still have to re-segment the data. I don't
believe the good folks at Dell have architected a federated database like
Microsoft did for the TPC.

|| I honestly do not know, but that type of question is an example of the
good discourse that goes on on this list. If i do find out ( and I will
ask ) I will let you know.

Here's a challenge... Does anyone know of ANY enterprise ERP type package or
any other application where the software vendor supports a "federated"
architecture? If not then it's likely no one will ever experience the
performance seen in the TPC-C benchmarks by Microsoft. If no real world apps
support a federated architecture then we may as well just ignore all those
benchmarks. And after we throw all those benchmarks out which database
engines consistently score the best on the remaining benchmarks?

|| Nicely put.

Here's another challenge... Has anyone ever worked with or even know of
anyone who's worked with a federated database? While I wouldn't configure my
database exactly like Oracle configures those used for TPC benchmarking,
(turning off redo, etc.), in terms of physical design I do believe my
databases are at least somewhat similar or recognizably in the same
ballpark. I do not believe anyone comes close to configuring SQLServer's
physical layout like that used in the Microsoft benchmarks. That's the
challenge and until someone can address this challenge we should practically
ignore all TPC benchmarks produced from Microsoft's federated database
architecture. IMHO.

|| I agree. Let the search begin!

> the TPC is *independent*.
Yes, and it's flawed and vendors take advantage of this to dupe the
unwitting.

|| Name one metric/benchmark that is NOT flawed. You get a free meal
from me if you do. After you can't do that, name one company
that would not use a test or competitor's flaws/shortcomings
to their advantage. Come on, it's not about some kind of
dreamy "perfection", it's about doing the best we can.
I personally believe that quoting the TPC is alot more
defensible that quoting Oracle Magazine. LOL!!

BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you
implement the SRDF option but I've never done it so what do I know? Well
I'll answer that by saying I don't know much but I do try to keep an open
minded pursuit of the truth. Sometimes I actually succeed... I think. ;-)

|| Amen, that's why we're all here.

RE: OT RE: Async I/O on Windows

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





Alex, 


thanks for your positive comments about your enjoyment
of my sense of humor. Laughing is good medicine in
these serious times. 


On the other stuff, if you know of any independent testing
labs you like, I'd be curious about their results, too!


Ross


p.s.  you did not say, but was it the Transaction Processing Council
website you found ridiculous?


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



Hi Ross


From you previous posts to the lists you seems to be a guy with the great
sense of humour that's why I always read your posts - very often they are
very funny. 
The first one about TPC-C marks was really good and made me laughing.


But after 10 times even the brilliant joke becomes boring.


If you argue not just to argue and if you do really support M$ solution and
prefer in to Oracle/UNIX would you be able to provide more references and
facts than this ridiculous advertising site that could be useful only for
people that do not have time/wish/knowledge for research but like flashy
charts and tables ( unfortunately these people very often take a decision) 



With regards
Alex Afanassiev
Oracle DBA, Internet.Operations/iFactory/Area63
Tel:    (03) 8 661 20 61
Fax:    (03) 9 650 36 74



> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 9:21 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OT RE: Async I/O on Windows
> 
> [Richard Ji]  
> What I mean here is Oracle hasn't done a benchmark since MS and IBM
> published their numbers.  
> So do jump to conclusion so fast about who is better. 
> 
> ||  Point taken. They alway leapfrog. On the next jump, Oracle needs to
> jump about FOUR TIMES 
> as far.  That's alot. 
> 
> [Richard Ji]  
> Actually Major Networks makes tons of money from Olympics, the Tour de
> France.  Why do you think they spend so much money to sign the exclusive
> right to broadcast it?
> 
> ||  Uhbecause the "products" keep getting better?  Maybe we should
> keep looking at benchmark 
> numbers, too?  That's my only argument. 
> 
> That's fine with me if you found it far more cost-effective to read the
> results.  You said: "Oracle is NEVER in the top three. Usually, it doesn't
> even show up."  Funny just on the tpc site you referred to, Oracle is all
> I see in the top three for Non-clustered category.
> 
> ||  See my previous post on the folly of RESTRICTING the servers to
> NON-clustered systems. 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Afanassiev, Alex
  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: 175 Terabyte Objectivity Database

Title: OT: 175 Terabyte Objectivity Database





OOoooh, how COOL!..Objectivity is neither Oracle nor SS
is it ( gasp ) "federated" in any sense?


Can you tell us more?  This is interesting..


-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 8:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT - WHAT is a FEDERATED DATABASE ???



We have a 175 terabyte database in Objectivity.  It houses event data  from  a physics experiments looking at the decay of B-mesons and their antimatter counterparts, trying to find out  what's going on with CP violation.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


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



Ross, glad to see you're starting to come up to speed here. :>)


> But for the clustering to work, businesses would have to change software
> and segment the data


The CNet authors obviously got tangled up in their notes and didn't
understand what they were writing about. (Not a first.) You don't have to
"segment the data" in OPS- that's the "federated database" scene where you
place different tables for the same database app on different servers. If
you segment an enterprise package like SAP or Oracle ERP then you have
1000's of tables to deal with. Chances are, no matter how "intelligently"
you segment your data, just losing any random machine, and its attendant
subset of tables, will bring the application to a halt and no more
transactions will be possible even though the database is still "up." That's
a single point a failure and that's the real problem. And to add a machine
to the federated cluster you still have to re-segment the data. I don't
believe the good folks at Dell have architected a federated database like
Microsoft did for the TPC.


Here's a challenge... Does anyone know of ANY enterprise ERP type package or
any other application where the software vendor supports a "federated"
architecture? If not then it's likely no one will ever experience the
performance seen in the TPC-C benchmarks by Microsoft. If no real world apps
support a federated architecture then we may as well just ignore all those
benchmarks. And after we throw all those benchmarks out which database
engines consistently score the best on the remaining benchmarks?


Here's another challenge... Has anyone ever worked with or even know of
anyone who's worked with a federated database? While I wouldn't configure my
database exactly like Oracle configures those used for TPC benchmarking,
(turning off redo, etc.), in terms of physical design I do believe my
databases are at least somewhat similar or recognizably in the same
ballpark. I do not believe anyone comes close to configuring SQLServer's
physical layout like that used in the Microsoft benchmarks. That's the
challenge and until someone can address this challenge we should practically
ignore all TPC benchmarks produced from Microsoft's federated database
architecture. IMHO.


> the TPC is *independent*.
Yes, and it's flawed and vendors take advantage of this to dupe the
unwitting.


BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you
implement the SRDF option but I've never done it so what do I know? Well
I'll answer that by saying I don't know much but I do try to keep an open
minded pursuit of the truth. Sometimes I actually succeed... I think.   ;-)



Steve Orr



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



Very Interesting!  It appears Oracle 9i, is, in fact, a Hybrid Federated
Database!
http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni
A snippet:
"An Oracle spokeswoman said the new Oracle 9i database, due in the first
half of next year, will feature new "clustering" technology that will make
the company's databases perform faster and more reliably than before.
Clustering allows businesses to harness multiple servers to run a very large
database, allowing servers to share work or take over from each other if one
fails.
The company's previous clustering technology, called Oracle Parallel Server,
allowed businesses to add as many servers, or high-end computers, as they
needed. But for the clustering to work, businesses would have to change
software and segment the data, a time-consuming effort for database
administrators, said Jeremy Burton, Oracle's senior vice president of
products and services marketing..."



-Original Message-
Sent: Monday, February 05, 2001 5:55 PM
To: '[EMAIL PROTECTED]'



I have some answers, for the curious:
http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html



It appears that SS can partition data storage among multiple
machines, giving it "blow your doors off" performance.
If a machine goes ( gets dynamited at an Oracle demo, for instance)
the data goes with it.
This would be much in the same

RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE



I 
understand the argument, Rodd and it raises three 
points/questions:
 
1) I 
can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN 
does 
    for the Oracle solution, and at less cost, 
and
 
2) Do 
you believe you can simply "add nodes" to an OPS farm to improve performance? I 
have
    personally never gone over a humble two nodes in OPS, and 
even then, locking issues must
    be addressed. One way out of this is the geographically 
segregate and partition the data. But
this would be "federated."  In a pure 
play OPS scenario, I would imagine the system 
would
    choke 
to death after the fourth or sixth node, without special tweaks like 
partitioning, either
    by 
data or application. 
 
3) Loss of a SS "state", just like loss of an oracle 
partition, does not "kill the operation of the system". 

    here, they are the same. 
..
 
just a thought..
 
 
    
 
 -Original Message-From: 
Holman, Rodney [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 
February 06, 2001 5:21 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
FEDERATED DATABASE

  Ross,
  I 
  was at the Open World conference session where Jeremy Burton made the comments 
  about clustering, OPS, data segmentation, etc.  The data segmentation 
  part was about MS SQLServer, and about how it creates significant work to add 
  cluster nodes. C|net has their terms and comments a little scrambled. The 
  Oracle 9i solution used OPS for the instances and an EMC/SRDF SAN for the data 
  storage.  Each OPS cluster node had full access to every piece of 
  data.  By doing this no node is a single point of failure (as Larry 
  demonstrated and was chastised for by MS).  Also it creates greater 
  capability for scalability.  Just configure and add a node and it 
  improves performance (also part of Larry's demo).  As described with the 
  MS federated database configuration you would need to resegment the data to 
  add a node.  This would then destabilize the system even further by 
  adding another single point of failure.  Failure of an OPS cluster node 
  with the data on a SAN  with redundancy, such as the EMC/SRDF option, 
  only decreases performance, it doesn't kill the operation of the 
  system.
   
  Rodd 
  Holman
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 5:09 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
OT RE: Async I/O on Windows - WHAT is a FEDERATED 
DATABASE
Very Interesting!  It appears Oracle 9i, is, in fact, a 
Hybrid Federated Database! 
http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni 

A snippet:

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

2001-02-06 Thread Jeffery Stevenson


Enough monkeys, enough typewriters and enough time can get you Shakespeare.

Enough developers, enough resources and enough time should eventually get
software that works.  BTW, I use Win2K here for my desktop box.  It runs
fairly well (and surprisingly even runs faster than NT)...the Oracle db I
have running on it runs nicely.  I can usually leave my system up and
running for a couple of months before encountering any oddities/lock-ups.
There are still some things that are quirky/annoying about it, but it runs
so I can't complain too much.  I mean, they eventually had to correct some
of their past mistakes and get something that works decently, but still a
system is really only as good as the people that maintain it (and some
people are just better at it than others).  Well, as soon as I get VMWare
tested at home and it delivers like it says, then I'll be able to run Win2K
under a window in Linux (and then I can have the best of both worlds).   :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-Original Message-
Sent: Tuesday, February 06, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L


Ep,

I have 8i running concurrently on a Win2k system with SS7, and have to say
that it still runs like a dream. Like I mentioned earlier Oracle is still my
favourite databeast, but there are a few things that still cough and
splutter - like OEM for example. The Java side of things can be a little
painful, but as I understand it is mostly on all platforms, as Oracle still
haven't got it just right - though 9i again is "supposed" to be a great
improvement on how the JVM is managed.

Win2K has better service management - unless I didn't notice under NT -
where if a service fails, you can first try and restart the service, if that
fails, you can run a file - whatever it may be - and if THAT fails you can
reboot the machine automatically, and cross your fingers that the service
starts properly with spewing nasty error messages at you.

I have been using Win2k for around 4 months now and have NEVER seen a BSOD
(Blue Screen of Death), I reboot quite often - granted - but that is only
because LookOut keep trying to dial my mail server, gets it knickers in a
twist, hangs, gives me a mail delivery error, trys again, then comes back
telling me the phone entry it already being dialed!! So because I can't live
without my Lyris "Family" I have to reboot the bloody thing. I have only
once had to reboot when installing new software, and that was because the
dongle wasn't recognized properly.

All in all Win2K is far and above NT 4 in my view. File management is
handled a lot better, you can have online network drives, even if the
network machine is down.. IIS is OK but I can't see a business need for it
though..

Oh, and they have even added the lovely little desktops themes available
with Windows 98, but not NT.. Now, I have to say, this little feature is the
one that sold it for me :)

Give it a try Eric, if you are used to NT, you may be pleasantly suprised..

Regards

Mark

P.S Win2K was Built on NT Technology according to the new splash screen.. It
can only improve right? Right? Micrslop? hardy har har har...



-Original Message-
Pierce
Sent: Monday, February 05, 2001 07:06
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: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California

RE: OT RE: Async I/O on Windows

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





Oh, btw, I have NOT supported a single "large" MS/SS 
database, but.I would be curious to hear more about
them, and am (at least these days) the ULTIMATE AGNOSTIC.


People with "religion" (Larry is God, Oracle is God, Gates
is Satan, My God is better than your God, etc.) are fun to 
poke at, especially when they run around with their eyes 
and ears closed, swinging their weapons, and yelling about
their total supremacy.


Bottomline, i think it would be cool as hell to hear about
getting a massive SS2K/NT database up and going.I am, 
after all, a TECHNOLOGIST, not a "Company Man". 



Yours in Data, 



(me)


-Original Message-
From: Afanassiev, Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 6:18 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: OT RE: Async I/O on Windows



Hi Ross


From you previous posts to the lists you seems to be a guy with the great
sense of humour that's why I always read your posts - very often they are
very funny. 
The first one about TPC-C marks was really good and made me laughing.


But after 10 times even the brilliant joke becomes boring.


If you argue not just to argue and if you do really support M$ solution and
prefer in to Oracle/UNIX would you be able to provide more references and
facts than this ridiculous advertising site that could be useful only for
people that do not have time/wish/knowledge for research but like flashy
charts and tables ( unfortunately these people very often take a decision) 



With regards
Alex Afanassiev
Oracle DBA, Internet.Operations/iFactory/Area63
Tel:    (03) 8 661 20 61
Fax:    (03) 9 650 36 74



> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 9:21 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OT RE: Async I/O on Windows
> 
> [Richard Ji]  
> What I mean here is Oracle hasn't done a benchmark since MS and IBM
> published their numbers.  
> So do jump to conclusion so fast about who is better. 
> 
> ||  Point taken. They alway leapfrog. On the next jump, Oracle needs to
> jump about FOUR TIMES 
> as far.  That's alot. 
> 
> [Richard Ji]  
> Actually Major Networks makes tons of money from Olympics, the Tour de
> France.  Why do you think they spend so much money to sign the exclusive
> right to broadcast it?
> 
> ||  Uhbecause the "products" keep getting better?  Maybe we should
> keep looking at benchmark 
> numbers, too?  That's my only argument. 
> 
> That's fine with me if you found it far more cost-effective to read the
> results.  You said: "Oracle is NEVER in the top three. Usually, it doesn't
> even show up."  Funny just on the tpc site you referred to, Oracle is all
> I see in the top three for Non-clustered category.
> 
> ||  See my previous post on the folly of RESTRICTING the servers to
> NON-clustered systems. 
>

Rollback Question

2001-02-06 Thread Casey Jordan





Is there anyway to find out if a long running 
concurrent program is rolling back its transactions?
 
 
Thanks
 
Casey

RE: table access via Browser

2001-02-06 Thread David Barbour


Cold Fusion is one possibility.  I used it quite successfully for
vendor/customer data lookup and entry in an extranet application running on
a Netscape webserver/NT Box connected to SAP/Oracle running on AIX.  Simple,
inexpensive and fairly painless.  The ODBC connection is solid, NT had some
problems(what else is new?) handling more than 20 connections at a time.
Allaire(authors of CF) probably have this one figured out by now.

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


-Original Message-
Sent: Tuesday, February 06, 2001 3:35 AM
To: Multiple recipients of list ORACLE-L


Hi,

what would you prefer to have a simple way to view and modify 
table-data of an oracle-DB by a browser?

Is there a simpler way to go than OAS/iAS?
Any ODBC-plugins? 
Has WebDB features that can be used?

Any comments are welcome.

Thanks
Stephan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?J=E4ck_Stephan?=
  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: Reporting database

2001-02-06 Thread Ron Rogers


Tom,
One of the big advantages of a "standby" database is that it can be opened in the 
"read only" mode just for the purpose of a report type database.
Be sure to check all of your options before you make the final decision. The report 
database and the OLTP database could/should have different INIT.ORA parameters to have 
the database operate at peak effeciency.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 02/06/01 07:25AM >>>
How are you all creating reporting databases?  We currently have an OLTP
database and we wish to create a reporting database from it.  As I see it,
we have the following options:

1.  Create the reporting database as a Standby database.  I don't think that
this will work since the database must be up and not in standby mode.
2.  Use Oracle replication.  I have heard it is cumbersome and has trouble
keeping up with lots of transactions.
3.  Snapshots/materialized views.
4.  Beef up our current machine so that it can handle OLTP transactions and
reports.
5.  Since we are using a BMC disk array, we could break the mirror
periodically and mount the disks on a new machine.
6.  Other 3rd party replication products.
7.  We could probably use some type of import/exports.

How are the rest of you doing it?  Are there any other options that I
forgot?

Thanks,
Tom


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Terrian, Thomas
  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: Ron Rogers
  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: Using timers on a database stored procedure


There's a dynamic view called v$timer or you can get it with the function:
dbms_utility.get_time.

Regards.

> -Mensaje original-
> De:   Sergio Boix Moriano [SMTP:[EMAIL PROTECTED]]
> Enviado el:   martes 6 de febrero de 2001 10:20
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Using timers on a database stored procedure
> 
> 
> Hi all,
> 
> We need to use timers on a stored procedure, from a compiled
> form we've used the included built-ins to this (create_timer, etc), but
> how can we use this from the database.
> 
> Thanks in advance for all your responses.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Sergio Boix Moriano
>   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: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows

2001-02-06 Thread Bill Pribyl

"Eric D. Pierce" wrote:

> Just got off the phone w/ Oracle tech support, and they said that OEM
> *is* definetly supported on Windows 2000, and should work fine.

I stand corrected.  It didn't work for me or a client of mine "out of the
box" but I just went and turned on *all* the Oracle-related services in the
control panel, and it seems to be working now.

Thanks!
Bill

PS  Dontcha just love answers from tech support that include the phrase
"should work fine"?

__
http://www.datacraft.com/http://plnet.org/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pribyl
  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).

LMT's Question

2001-02-06 Thread Terry Ball


AIX 4.3.3  Oracle 8.1.6.2

Is anyone using LMT's in either an OPS environment and/or ad standby
database environment?  There is some concern here about using LMT's
because we are discussing these two options.  I don't know or nor forsee
any problems, but would like to know if others have any experience.

Any input is appreciated and TIA.

Terry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  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).

revision control systems for Oracle source - cvs - cvsnt?

2001-02-06 Thread Paul Drake


Hi.

Any thoughts on PL/SQL Source Control Systems for a windows-centric
development environment?
Once development is moved to 8.1.7 - I was thinking about using the ALTER
SCHEMA event to log changes to source.

Is anyone using prcs, cvs, cvsnt for managing Oracle Source?
Any merits of Linux vs. WinNT/2000 implementations?

I will post findings back to the list.

This seemed to be the most informative site:

http://www.devguy.com/fp/cfgmgmt/cvs/cvs_admin_nt.htm

Here's the obvious initial links:

Linux Version Control & Configuration

http://linas.org/linux/cmvc.html

CVS

The real question for using CVS is this 

- install on Unix or go with 2nd rate implementation on
NT/2000?

Home

http://www.loria.fr/~molli/cvs/doc/cvs_toc.html

WinCVS

http://www.wincvs.org/

CVS Server for NT

Homehttp://www.cvsnt.org/
Install
http://www.devguy.com/fp/cfgmgmt/cvs/cvs_admin_nt.htm


thanks in advance,

Paul

Paul Drake
Professional Software Systems

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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

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





Thanks for the extended mail on your direct experience. 


Much better than CNET, I guess we can all agree?


-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 8:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows



Ep,


I have 8i running concurrently on a Win2k system with SS7, and have to say
that it still runs like a dream. Like I mentioned earlier Oracle is still my
favourite databeast, but there are a few things that still cough and
splutter - like OEM for example. The Java side of things can be a little
painful, but as I understand it is mostly on all platforms, as Oracle still
haven't got it just right - though 9i again is "supposed" to be a great
improvement on how the JVM is managed.


Win2K has better service management - unless I didn't notice under NT -
where if a service fails, you can first try and restart the service, if that
fails, you can run a file - whatever it may be - and if THAT fails you can
reboot the machine automatically, and cross your fingers that the service
starts properly with spewing nasty error messages at you.


I have been using Win2k for around 4 months now and have NEVER seen a BSOD
(Blue Screen of Death), I reboot quite often - granted - but that is only
because LookOut keep trying to dial my mail server, gets it knickers in a
twist, hangs, gives me a mail delivery error, trys again, then comes back
telling me the phone entry it already being dialed!! So because I can't live
without my Lyris "Family" I have to reboot the bloody thing. I have only
once had to reboot when installing new software, and that was because the
dongle wasn't recognized properly.


All in all Win2K is far and above NT 4 in my view. File management is
handled a lot better, you can have online network drives, even if the
network machine is down.. IIS is OK but I can't see a business need for it
though..


Oh, and they have even added the lovely little desktops themes available
with Windows 98, but not NT.. Now, I have to say, this little feature is the
one that sold it for me :)


Give it a try Eric, if you are used to NT, you may be pleasantly suprised..


Regards


Mark


P.S Win2K was Built on NT Technology according to the new splash screen.. It
can only improve right? Right? Micrslop? hardy har har har...




-Original Message-
Pierce
Sent: Monday, February 05, 2001 07:06
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: 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).

unix cron

2001-02-06 Thread Arslan Bahar



  how can i  start  and stop  cron deamon  on solaris 2.6
-- 
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).

RE: Pinning Tables

2001-02-06 Thread Kevin Kostyszyn

Title: RE: Pinning Tables



Sorry 
about how late this reply is, we got hammered with 12 inches of snow 
yesterday.  Anyway, I guess I was thinking that "pinning" a table in memory 
would mean it is always there as opposed to caching where it might not be there 
all of the time.
Kev

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Monday, February 05, 2001 4:50 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Pinning Tables
  What is the difference between table caching and "pinning", to 
  your thinking? 
  -Original Message- From: Kevin 
  Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 10:36 AM To: 
  Multiple recipients of list ORACLE-L 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).

RE: ora-07445



Thanks Rafiq.  It took me a long while to find out what the problem was.
We have some consultants that monitor our databases and they have a daemon
that runs constantly gathering information.  This daemon was the culprit.
We stopped it, and since then the ora 07445 went away, and we were able to
resume our normal operations,

Ana


   

"Mohammad  

Rafiq"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: RE: ora-07445

Sent by:   

root@fatcity.  

com

   

   

02/05/01   

01:29 PM   

Please 

respond to 

ORACLE-L   

   

   





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

RE: Reg. SPOOL in SQL*PLUS

2001-02-06 Thread William Rogge


It can be done like this:

column ext noprint new_value ext
select to_char(sysdate,'HH24MI') ext
  from dual;

spool File.&ext
select ...
spool off

The output will be in a file 'File.' where  is the formatted time.

-Original Message-
From:   Arul kumar [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, February 05, 2001 11:45 PM
To: Multiple recipients of list ORACLE-L
Subject:Reg. SPOOL in SQL*PLUS

Hi DBAs,

I would like to know the way for specifying a filename dynamically in
SQL PLUS.

Say, for example

The file name should be suffixed with a sequence number available from a
SEQUENCE object. ( like SPOOL ||seq1.nextval).

Any idea?

Thank You,
Arul.
 << File: ATT00052.html >> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Rogge
  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).

Upgrade Oracle8.1.6 to 8.1.7

2001-02-06 Thread Feng, Jun


Hi

We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6. Have
anybody done this work without database downtime? What was your downtime
window for upgrade? Anybody have any suggestions about the upgrade without
downtime?

Thanks,

Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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: LMT's Question

2001-02-06 Thread Kirsh, Gary


Terry,

I've seem LMT's used in standby db's without a problem.  As a matter of
fact, if you ever want to use the standby in read-only mode, the temp
tablespace needs to be a LMT, otherwise any query resulting in a sort to
disk will fail.

Gary Kirsh
Next Extent, Inc

-Original Message-
Sent: Tuesday, February 06, 2001 9:08 AM
To: oracledba; oracle list


AIX 4.3.3  Oracle 8.1.6.2

Is anyone using LMT's in either an OPS environment and/or ad standby
database environment?  There is some concern here about using LMT's
because we are discussing these two options.  I don't know or nor forsee
any problems, but would like to know if others have any experience.

Any input is appreciated and TIA.

Terry



Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsh, Gary
  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: User objects in System tablespace



If you add a user to Oracle and don't specify the default tablespace as
'users' it defaults to the system tablespace.

Ana Choto
American University


   

"Mark Leith"   

   
ols.co.uk>   cc:   

Sent by: Subject: RE: User objects in System 
tablespace
root@fatcity.  

com

   

   

02/05/01   

01:45 PM   

Please 

respond to 

ORACLE-L   

   

   





Roerg the tables, and specify the user tablespace..
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sanjay
 Kumar
 Sent: Monday, February 05, 2001 05:51
 To: Multiple recipients of list ORACLE-L
 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



-- 
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: COPY command dieing - help

2001-02-06 Thread Shaw, John B

I didn't - but now I have with the following result.

*
ERROR at line 1:
ORA-00900: invalid SQL statement

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

Did you try leaving off the semi colon?  Like this, for instance:

copy from v55/v55@int to user/pwd@frog create DMF -
using select * from DMF@int
/

Notice that if you have several lines, you need to put a space and hyphen
after each line except the last one.  At least, that has been my experience.

>>> [EMAIL PROTECTED] 02/02/01 11:00AM >>>
On Thu, 1 Feb 2001, Shaw, John B wrote:

> I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the
tables
> have come across successfully. One table is having a problem.
> The command:
> copy from v55/v55@int to user/pwd@frog create DMF using select * from
> DMF@int;
> This table gives ora-00911 error (invalid character ? where? - this same
> command worked on many other tables).
> I manually created the table in the local db and tried to do an append of
> the data
> copy from v55/v55@int to user/pwd@frog append DMF using select * from
> DMF@int;
>
> This causes sqlplus and sqlworksheet to die (this is on NT0
> anybody have an idea of what's going on?

Maybe a silly question, but do the databases use the same character set?

Jared

-- 
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: Tim Sawmiller
  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: Shaw, John B
  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: Rollback Question

2001-02-06 Thread Steve Adams


Hi Casey,

Look at the USED_UBLK field in V$TRANSACTION, twice.
If the number is going down, then the transaction is rolling back.

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


-Original Message-
Sent: Wednesday, 7 February 2001 0:00
To: Multiple recipients of list ORACLE-L


Is there anyway to find out if a long running concurrent program is rolling back
its transactions?


Thanks

Casey

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  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: Reporting database

2001-02-06 Thread Oracle Apps



You can use the standby database in read only mode if
you are going to do reporting only.


--- "Terrian, Thomas"
<[EMAIL PROTECTED]> wrote:
> How are you all creating reporting databases?  We
> currently have an OLTP
> database and we wish to create a reporting database
> from it.  As I see it,
> we have the following options:
> 
> 1.  Create the reporting database as a Standby
> database.  I don't think that
> this will work since the database must be up and not
> in standby mode.
> 2.  Use Oracle replication.  I have heard it is
> cumbersome and has trouble
> keeping up with lots of transactions.
> 3.  Snapshots/materialized views.
> 4.  Beef up our current machine so that it can
> handle OLTP transactions and
> reports.
> 5.  Since we are using a BMC disk array, we could
> break the mirror
> periodically and mount the disks on a new machine.
> 6.  Other 3rd party replication products.
> 7.  We could probably use some type of
> import/exports.
> 
> How are the rest of you doing it?  Are there any
> other options that I
> forgot?
> 
> Thanks,
> Tom
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Terrian, Thomas
>   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).


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle Apps
  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: Reporting database

2001-02-06 Thread Joan Hsieh


If your production database can afford a short downtime. You can copy all
the datafiles and rename the database. We did this way. Refreshed the
database everyday. 15GB database needs 15 min. downtime on the production
database. Depends on your system I guess. Or using hot backup recover to
another machine rename the database. Of course, all those methods are not
real time approach. We don't care a one day delayed data on reporting
purpose.

Thanks,
Joan

-Original Message-
Sent: Tuesday, February 06, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L


Tom,
One of the big advantages of a "standby" database is that it can be opened
in the "read only" mode just for the purpose of a report type database.
Be sure to check all of your options before you make the final decision. The
report database and the OLTP database could/should have different INIT.ORA
parameters to have the database operate at peak effeciency.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 02/06/01 07:25AM >>>
How are you all creating reporting databases?  We currently have an OLTP
database and we wish to create a reporting database from it.  As I see it,
we have the following options:

1.  Create the reporting database as a Standby database.  I don't think that
this will work since the database must be up and not in standby mode.
2.  Use Oracle replication.  I have heard it is cumbersome and has trouble
keeping up with lots of transactions.
3.  Snapshots/materialized views.
4.  Beef up our current machine so that it can handle OLTP transactions and
reports.
5.  Since we are using a BMC disk array, we could break the mirror
periodically and mount the disks on a new machine.
6.  Other 3rd party replication products.
7.  We could probably use some type of import/exports.

How are the rest of you doing it?  Are there any other options that I
forgot?

Thanks,
Tom


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Thomas
  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: Ron Rogers
  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: Joan Hsieh
  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).

Unix SysAdmin Book??

2001-02-06 Thread Raghu Kota


Hi Guys

Could you suggest any Best book for System Administration and Shell 
Scripting for Solaris.

Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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



Thanks for your help.  I found the cause.  It was a daemon that our
consultants run to gather information and monitor our database.  We stopped
the daemon.  And that took care of the error and core dumps.

Ana


   

"Mohan, Ross"  

   
-SMI.com>cc:   

Sent by: Subject: RE: ora-07445

root@fatcity.  

com

   

   

02/05/01   

01:45 PM   

Please 

respond to 

ORACLE-L   

   

   





nothing before or after?


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


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






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





Ex

RE: RE: OT NT2K vs Unix.

Title: RE: RE: OT  NT2K vs Unix.





Pithy as hell and twice as true. 


I agree totally..agents...interfacesgraphicsAI...


-Original Message-
From: Anderson, Brian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: OT NT2K vs Unix.



The future of computers, look at the games of today.




 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]



> -Original Message-


> are some that I can think of).  Heck, I wouldn't be surprised 
> if the code
> for some database query optimizers trace back to some gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  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: table access via Browser

2001-02-06 Thread Smith, Ron L.


Toad by Quest Software.  Cheap and works great!

Ron Smith
Database Administration
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, February 06, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L


Cold Fusion is one possibility.  I used it quite successfully for
vendor/customer data lookup and entry in an extranet application running on
a Netscape webserver/NT Box connected to SAP/Oracle running on AIX.  Simple,
inexpensive and fairly painless.  The ODBC connection is solid, NT had some
problems(what else is new?) handling more than 20 connections at a time.
Allaire(authors of CF) probably have this one figured out by now.

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


-Original Message-
Sent: Tuesday, February 06, 2001 3:35 AM
To: Multiple recipients of list ORACLE-L


Hi,

what would you prefer to have a simple way to view and modify 
table-data of an oracle-DB by a browser?

Is there a simpler way to go than OAS/iAS?
Any ODBC-plugins? 
Has WebDB features that can be used?

Any comments are welcome.

Thanks
Stephan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?J=E4ck_Stephan?=
  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).
-- 
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: unix cron

2001-02-06 Thread Anderson, Brian


On Solaris 7 (probably the same as 2.6)

as root:
/etc/init.d/cron stop
/etc/init.d/cron start


 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]




> -Original Message-
> From: Arslan Bahar [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 9:11 AM
> To: Multiple recipients of list ORACLE-L
> Subject: unix cron
> 
> 
> 
>   how can i  start  and stop  cron deamon  on solaris 2.6
> -- 
> 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: Anderson, Brian
  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).

System tablespace as locally managed only on 8.1.7

2001-02-06 Thread Reddy, Gautam




Has anyone tried this. Any problems that you think we 
should be aware of.  Want to play around on a dev database, but before that 
wanted to see if anyone tried it and has some useful 
suggestions
 
Thx
Gautam

RE: OT NT2K vs Unix.

2001-02-06 Thread Boivin, Patrice J


Hey, I saw the ads on TV.  Microsoft now makes enterprise software, which
gives sa's peace of mind...

It always amazes me how companies identify a problem, then create ads to
turn people's perception around.  So now Microsoft is telling people that
their systems are reliable and never crash, so system administrators can
relax.

Hopefully with Win2K they actually fixed the problems, and are not just
posting ads on TV to turn people's perception around to boost sales.

Eventually I will figure out how the world works.  It's taking me a while,
though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, February 01, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT  NT2K vs Unix.

There is, however, one significant difference: stability. If
Microsoft
starts making stable
products, we might just as well start using them, but  knowing
Microsoft,
I'm not overly
worried.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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-06 Thread Boivin, Patrice J


I heard that the Mac OS is a variant of UNIX with a GUI on top.

So that wouldn't be far off the mark.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Rocky Welch [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, February 01, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: OT  NT2K vs Unix.


The same prediction was made at least 5 years ago. At the rate
Microsoft is going, Windows will be a direct form of Unix. It becomes more
like it with every release. 

-Rocky 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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

Title: RE: Pondering Question of the Day-RESPECT

PC Answer:   How awful. This denigrates blah blah blah and is
    just another example of the Post-Male Doctrinal Hegemony
    laid out (so to speak) by E. Jong in her "Fear of Flying"
    manifesto. 
    exhausted.>

Non PC Answer:  Technically, none such exists. In reality

-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 4:52 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Pondering Question of the Day-RESPECT

http://www.theregister.co.uk/content/30/12701.html

-

http://www.theregister.co.uk/content/archive/16057.html
(Prostitutes used to tempt IT staff into jobs)

On 5 Feb 2001, at 12:12, Rocky Welch wrote:

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

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

-- 
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: OT NT2K vs Unix.

2001-02-06 Thread Jamadagni, Rajendra


In fact there was a recent discussion on /. that if Mac OS X is ported to
x86 platform ... it could challenge Linux ...

so there we go ..
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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

2001-02-06 Thread Mohammad Rafiq


Ana,
Congrat. In our case it was some code running through dbms_job and some 
contribution from Oracle Discoverer. It was a dataware house application
custom designed by Oracle Consulting.
Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 06 Feb 2001 06:20:26 -0800


Thanks Rafiq.  It took me a long while to find out what the problem was.
We have some consultants that monitor our databases and they have a daemon
that runs constantly gathering information.  This daemon was the culprit.
We stopped it, and since then the ora 07445 went away, and we were able to
resume our normal operations,

Ana



 "Mohammad
 Rafiq"   To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: ora-07445
 Sent by:
 root@fatcity.
 com


 02/05/01
 01:29 PM
 Please
 respond to
 ORACLE-L






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)
  
--

problem displaying umlaut character

2001-02-06 Thread Jerry C




Hi all,
 
I'm having problems displaying an umlaut 
character correctly. For example:
create table umlaut(col1 
varchar2(10));  Table created.
 
insert into umlaut 
values('Brömmel'); 1 row created. select * from umlaut 
where col1='Brömmel';  
 
COL1--Brvmmel 
 
My NLS parameters:
 
msuawo01> svrmgrl Oracle 
Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, 
Oracle Corporation.  All Rights Reserved. Oracle8i Enterprise 
Edition Release 8.1.5.0.0 - ProductionWith the Partitioning and Java 
optionsPL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect 
internalConnected.SVRMGR> show parameter 
NLSNAME    
TYPE    VALUE--- --- 
--nls_calendar    
string    
nls_comp    
string    
nls_currency    
string    
nls_date_format 
string  
MM/DD/    
nls_date_language   
string    
nls_dual_currency   
string    
nls_iso_currency    
string    
nls_language    
string  
AMERICAN  
nls_numeric_characters  
string    
nls_sort    
string    
nls_territory   
string  
AMERICA   
nls_time_format 
string    
nls_time_tz_format  
string    
nls_timestamp_format    
string    
nls_timestamp_tz_format 
string    

 
SQL> set linesize 125SQL> select 
* from nls_database_parameters ;PARAMETER 
VALUE-- 
--NLS_LANGUAGE 
AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY 
AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET UTF8NLS_CALENDAR 
GREGORIANNLS_DATE_FORMAT DD-MON-YYNLS_DATE_LANGUAGE AMERICANNLS_SORT 
BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER 
VALUE-- 
--NLS_TIMESTAMP_FORMAT 
DD-MON-YY HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM 
TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM 
TZH:TNLS_DUAL_CURRENCY $NLS_COMPNLS_NCHAR_CHARACTERSET 
UTF8NLS_RDBMS_VERSION 8.1.5.0.018 rows selected.A 
virtual homebrew (British Pale Ale) to anybody who can help!
 
 
Thanks!
 
- Jerry

RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

2001-02-06 Thread Tony Johnson

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE



The 
whole idea behind 9i is CacheFusion which uses a high-speed
interconnect to solve the pinging issues. At least that 
is the marketing
line 
that will only be proved in time. Any database of any size 
should
be 
using partititioning if you want it to perform and be able to manage 
it.
--Tony 
Johnson        
    
    
    Email  : 
[EMAIL PROTECTED]Senior Database Administrator   
    
    Voice  : ( 480 ) 682 - 
0849GridData    
    
    
    
    Cell   : ( 602 ) 363 - 
7328     
   7408 W. Detroit 
#100        
    
    Fax    : ( 480 ) 961 - 
8801Chandler, AZ 
85226--Murphy's 
Data Constant:Data will be damaged in direct proportion to its value 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
  FEDERATED DATABASE
  I 
  understand the argument, Rodd and it raises three 
  points/questions:
   
  1) I 
  can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD 
  SAN does 
      for the Oracle solution, and at less cost, 
  and
   
  2) 
  Do you believe you can simply "add nodes" to an OPS farm to improve 
  performance? I have
      personally never gone over a humble two nodes in OPS, and 
  even then, locking issues must
      be addressed. One way out of this is the geographically 
  segregate and partition the data. But
  this would be "federated."  In a pure 
  play OPS scenario, I would imagine the system 
  would
      choke to death after the fourth or sixth node, without special 
  tweaks like partitioning, either
      by 
  data or application. 
   
  3) Loss of a SS "state", just like loss of an oracle 
  partition, does not "kill the operation of the system". 
  
      here, they are the same. 
  ..
   
  just a thought..
   
   
      
   
   -Original 
  Message-From: Holman, Rodney 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 
  5:21 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED 
  DATABASE
  
Ross,
I 
was at the Open World conference session where Jeremy Burton made the 
comments about clustering, OPS, data segmentation, etc.  The data 
segmentation part was about MS SQLServer, and about how it creates 
significant work to add cluster nodes. C|net has their terms and 
comments a little scrambled. The Oracle 9i solution used OPS for the 
instances and an EMC/SRDF SAN for the data storage.  Each OPS cluster 
node had full access to every piece of data.  By doing this no node is 
a single point of failure (as Larry demonstrated and was chastised for by 
MS).  Also it creates greater capability for scalability.  Just 
configure and add a node and it improves performance (also part of Larry's 
demo).  As described with the MS federated database configuration you 
would need to resegment the data to add a node.  This would then 
destabilize the system even further by adding another single point of 
failure.  Failure of an OPS cluster node with the data on a SAN  
with redundancy, such as the EMC/SRDF option, only decreases performance, it 
doesn't kill the operation of the system.
 
Rodd Holman

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 
  5:09 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
  FEDERATED DATABASE
  Very Interesting!  It appears Oracle 9i, is, in fact, 
  a Hybrid Federated Database! 
  http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni 
  
  A snippet:

RE: OT NT2K vs Unix.

2001-02-06 Thread Jeffery Stevenson


  Consensus reality (as one of my friends calls it).  If everyone thinks
that something should work a certain way then they will alter reality so
that it works as they think it should.  With all these ads they can get the
masses to believe that it really works now and then it actually will (even
if it's not supposed to work properly).   :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-Original Message-
Sent: Tuesday, February 06, 2001 8:46 AM
To: Multiple recipients of list ORACLE-L


Hey, I saw the ads on TV.  Microsoft now makes enterprise software, which
gives sa's peace of mind...

It always amazes me how companies identify a problem, then create ads to
turn people's perception around.  So now Microsoft is telling people that
their systems are reliable and never crash, so system administrators can
relax.

Hopefully with Win2K they actually fixed the problems, and are not just
posting ads on TV to turn people's perception around to boost sales.

Eventually I will figure out how the world works.  It's taking me a while,
though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, February 01, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT  NT2K vs Unix.

There is, however, one significant difference: stability. If
Microsoft
starts making stable
products, we might just as well start using them, but  knowing
Microsoft,
I'm not overly
worried.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: Jeffery Stevenson
  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).

Pro*C book

2001-02-06 Thread Kimberly Smith


Just wondering what people are using for a Pro*C reference?
I am seeing some pretty bad code here in that area (mostly
by a developer who likes to hack and no longer works here but
its what people are using for guidelines) and would like to have
a reference around that the developers can use.  I used to have
a copy of the Oracle Press one and it was not to bad.  Actually,
the manual is not to bad but they don't seem to want to use
it.



Kimberly Smith
EDS 
Fujitsu/GMD
21015 SE Stark St
Gresham, OR
97030
Phone:  (503) 669-6050
Fax:  (503) 669-5705

-- 
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: Patchset installation

2001-02-06 Thread Molina, Gerardo


A method that has worked very well for us is to re-install the base release
(eg. 8.1.6) in a different ORACLE_HOME (eg. 8.1.6.3) and then apply the
patchset (eg. 8.1.6.3).  This allows different release levels to exist on
same server.  I remember one of the OFA rules was to use only 3 digits for
the ORACLE_HOME, but I think this should be changed to 4, based on Oracle's
recent patch naming practices.

HTH
Gerardo

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


Not a good idea.  Oracle links some libs in with a direcory that is in
Oracle Home.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 3:42 PM


> Hi,
>
> I am looking into installing a patchset with minimum downtime.  Standard
> Oracle procedure for installing a patchset is:
> 1. Shutdown the database
> 2. Install the patch binaries, relink.
> 3. Startup database (restrict ?), run the cat* scripts.
>
> I wanted to change the procedure so that instead of having the database
down
> during the patch install and relinking, prior to the procedure I copy the
> binaries to a newly created home, install the patch on the new home,
relink
> the binaries under the new home, and than just restart the database from
the
> new home.  To make sure that everything is OK, I would postpone the cat*
> scripts run, for a later time, once I am sure that everything is OK.  If
> something goes wrong I haven't changed anything in the database, and I can
> just go back to the old home.
>
> Has anybody tried this ?  What is the significance of cat* scripts.  As
far
> as I understand them, oracle does not use them and do not care about them,
> only some apps might break (most of all DBA type of scripts).
>
> Thanks.
>
> Djordje
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Djordje Jankovic
>   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: Allan Nelson
  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: Molina, Gerardo
  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: Reporting database

2001-02-06 Thread james ellis


I have worked in an environment where we used simple
snapshots to replicate data to a reporting database.
It was low maintenance once you developed the right
fast refresh intervals for the tables that are being
replicated. 


--- "Terrian, Thomas"
<[EMAIL PROTECTED]> wrote:
> How are you all creating reporting databases?  We
> currently have an OLTP
> database and we wish to create a reporting database
> from it.  As I see it,
> we have the following options:
> 
> 1.  Create the reporting database as a Standby
> database.  I don't think that
> this will work since the database must be up and not
> in standby mode.
> 2.  Use Oracle replication.  I have heard it is
> cumbersome and has trouble
> keeping up with lots of transactions.
> 3.  Snapshots/materialized views.
> 4.  Beef up our current machine so that it can
> handle OLTP transactions and
> reports.
> 5.  Since we are using a BMC disk array, we could
> break the mirror
> periodically and mount the disks on a new machine.
> 6.  Other 3rd party replication products.
> 7.  We could probably use some type of
> import/exports.
> 
> How are the rest of you doing it?  Are there any
> other options that I
> forgot?
> 
> Thanks,
> Tom
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Terrian, Thomas
>   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).


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: james ellis
  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: Linux as a production machine

2001-02-06 Thread Dave Morgan

Hi Steve,
Thanks, I wasn't aware of that. As I said, they are not busy
machines so I hadn't noticed any paging activity at all. 
Two more kernels, 2.2.17 and a 2.4 are in my test area so
I guess I should upgrade once again sigh..
I would like to jump straight to 2.4 but the first release 
issues always scare me (Not just Linux but any software)

Dave

Steve Adams wrote:
> 
> Hi Dave,
> 
> I would recommend a later kernel for anyone who wants to run a production Oracle
> system on Linux. The 2.2.14 kernel has bugs in the VM. It pages much too
> aggressively and cannot be tamed. So you need to ensure that you never page
> which is wasteful.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
> 

-- 
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: ora-07445

Title: RE: ora-07445





I run daemons all the time without 7445s.


So, I'd say you found the vehicle, but not the root cause. 


For future use, I'd humbly suggest you continue analysis until
you determine root cause, or be prepared to repeat history. 


hth


ross


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ora-07445




Thanks for your help.  I found the cause.  It was a daemon that our
consultants run to gather information and monitor our database.  We stopped
the daemon.  And that took care of the error and core dumps.


Ana



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





nothing before or after?



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



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







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"


    
list ORACLE-L <[EMAIL PROTECTED]>
    -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 i

RE: unix cron

2001-02-06 Thread Molina, Gerardo


I'm not sure what your particular needs are without more information but,
one way is not to "stop" it all but to control what it does with a semaphore
file.  If it's scheduled in cron, then you probably have it there for a
reason.  If you want to "disable" it temporarily, then add some logic to the
script to check for the existence of the semaphore file, call it
"DISABLE.DAEMON".  If the file exists, then just skip over daemon code.  Now
you can control the daemon by touching and removing a file.

HTH
Gerardo 

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



  how can i  start  and stop  cron deamon  on solaris 2.6
-- 
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: Molina, Gerardo
  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

2001-02-06 Thread Mike Killough


Ana,

What was the daemon doing? You should be able to see from the trace file 
where the error occurs and the sql that was run. Our problem also came from 
our monitoring scripts, but we didn't want to stop using them to fix the 
problem. The core dump occurred on a select from dba_segments. Just doing 
select count(*) from dba_segments would core dump. That is when we ran 
catalog and catproc, then compiled invalid objects, to fix this. If it is a 
user table, you could try re-creating it. If an export fails, you may find 
you have a data corruption problem.

Mike



>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: ora-07445
>Date: Tue, 06 Feb 2001 06:20:26 -0800
>
>
>Thanks Rafiq.  It took me a long while to find out what the problem was.
>We have some consultants that monitor our databases and they have a daemon
>that runs constantly gathering information.  This daemon was the culprit.
>We stopped it, and since then the ora 07445 went away, and we were able to
>resume our normal operations,
>
>Ana
>
>
>
> "Mohammad
> Rafiq"   To: Multiple recipients of 
>list ORACLE-L <[EMAIL PROTECTED]>
>  tmail.com>   Subject: RE: ora-07445
> Sent by:
> root@fatcity.
> com
>
>
> 02/05/01
> 01:29 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>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"
>  list ORACLE-L <[EMAIL PROTECTED]>
>  -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 mounte

RE: Pinning Tables

Title: RE: Pinning Tables



If 
it's frequently accessed, caching it will keep it there. 
 
if 
it's big, it may may a splash in the buffer pool, so use the multiple pool 
features.
 
"big" 
and "small" are relative to size of buffer pools, of 
course.
 
hth
 

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 9:11 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Pinning Tables
  Sorry about how late this reply is, we got hammered with 12 inches of 
  snow yesterday.  Anyway, I guess I was thinking that "pinning" a table in 
  memory would mean it is always there as opposed to caching where it might not 
  be there all of the time.
  Kev
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Monday, February 05, 2001 4:50 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Pinning Tables
What is the difference between table caching and "pinning", 
to your thinking? 
-Original Message- From: 
Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 05, 2001 10:36 AM To: Multiple recipients of list ORACLE-L 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).

RE: OT NT2K vs Unix.

Title: RE: OT  NT2K vs Unix.





Given that "most" db problems are app-centric, and a healthy
majority of *any* datacenters' downtime is human-error related, 
it seems to be that the route to stability is through the
enhanced learning of the operator/developer/administrators. And
learning requires open minds and for things like technology, 
frequent refreshing


But that is just my opinion. It may actually be the case that
the way to improve something is to castigate, excoriate, and
denigrate.  But, I need to continue my observations on that
topic.


;->


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT NT2K vs Unix.



Hey, I saw the ads on TV.  Microsoft now makes enterprise software, which
gives sa's peace of mind...


It always amazes me how companies identify a problem, then create ads to
turn people's perception around.  So now Microsoft is telling people that
their systems are reliable and never crash, so system administrators can
relax.


Hopefully with Win2K they actually fixed the problems, and are not just
posting ads on TV to turn people's perception around to boost sales.


Eventually I will figure out how the world works.  It's taking me a while,
though.


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)



    -Original Message-
    From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
    Sent:   Thursday, February 01, 2001 4:01 PM
    To: Multiple recipients of list ORACLE-L
    Subject:    RE: OT  NT2K vs Unix.


    There is, however, one significant difference: stability. If
Microsoft
    starts making stable
    products, we might just as well start using them, but  knowing
Microsoft,
    I'm not overly
    worried.


    
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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).

NT 6a?

2001-02-06 Thread Smith, Ron L.


Does anyone know if there are any problem with compatibility for NT 6.a and
Oracle Server Work Group version 7.3.4.4.0?

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: RE: OT NT2K vs Unix.

2001-02-06 Thread Shakeel Qureshi


Hi gurus!

I am having the following bug in alert_log.  Oracle
says it may be because of using Pro*C which we are 
not using at all.

Anybody has any idea about it. It oracle version 8.1.6
on salaris 2.7.

TIA,

Shakeel Qureshi
[EMAIL PROTECTED]

Sat Jan 27 10:15:47 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_14886.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:15:47 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_14888.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:56:45 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_14940.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:56:45 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_14942.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 12:15:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15040.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 12:15:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_15042.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 13:14:31 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/udump/bpnext_ora_13259.trc:
ORA-07445: exception encountered: core dump
[kkoapk()+40] [SIGBUS] [Invalid address alignment]
[2031883] [] []
Sat Jan 27 15:41:02 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15367.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 15:41:02 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_15369.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 17:27:52 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15496.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  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.

Title: RE: OT  NT2K vs Unix.





Hell, if Apple gave ANYBODY access in the early days, we'd all
be reading this mail on MacInstoshes instead of wintel boxes. 


-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT NT2K vs Unix.



In fact there was a recent discussion on /. that if Mac OS X is ported to
x86 platform ... it could challenge Linux ...


so there we go ..
Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.


QOTD: Any clod can have facts, but having an opinion is an art !


*


This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

*


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: 175 Terabyte Objectivity Database

2001-02-06 Thread MacGregor, Ian A.

Title: OT: 175 Terabyte Objectivity Database

The
way Objectivity sets up a federated database is that you have a
master database which records information about the
federation. An individual database can be attached or detached from
the federation. An individual database is comprised of a database
file ,which holds logical structrures termed containers, which in turn hold
the persistent data, termed basic objects. The data is stored in
a hierarchical file system, HPSS, with Redwood tape drives providing
the near-line storage.
There
are numerous load balanced data servers which handle parts of the
federation.
Ian
MacGregor
Stanford Linear Acclerator Center
[EMAIL PROTECTED]

-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 5:46
AMTo: Multiple recipients of list ORACLE-LSubject: OT:
175 Terabyte Objectivity Database
OOoooh, how COOL!..Objectivity is neither Oracle nor
SS is it ( gasp ) "federated" in any sense?

Can you tell us more? This is interesting..

-Original Message- From:
MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 8:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT - WHAT is a FEDERATED DATABASE ???
We have a 175 terabyte database in Objectivity. It
houses event data from a physics experiments looking at the decay
of B-mesons and their antimatter counterparts, trying to find out what's
going on with CP violation.
Ian MacGregor Stanford Linear
Accelerator Center [EMAIL PROTECTED]
-Original Message- Sent:
Monday, February 05, 2001 4:56 PM To: Multiple
recipients of list ORACLE-L
Ross, glad to see you're starting to come up to speed here.
:>)
> But for the clustering to work, businesses would have to
change software > and segment the data
The CNet authors obviously got tangled up in their notes and
didn't understand what they were writing about. (Not a
first.) You don't have to "segment the data" in OPS-
that's the "federated database" scene where you place
different tables for the same database app on different servers. If
you segment an enterprise package like SAP or Oracle ERP then
you have 1000's of tables to deal with. Chances are,
no matter how "intelligently" you segment your data,
just losing any random machine, and its attendant subset of tables, will bring the application to a halt and no
more transactions will be possible even though the
database is still "up." That's a single point a
failure and that's the real problem. And to add a machine to the federated cluster you still have to re-segment the data. I
don't believe the good folks at Dell have architected
a federated database like Microsoft did for the
TPC.
Here's a challenge... Does anyone know of ANY enterprise ERP
type package or any other application where the
software vendor supports a "federated" architecture?
If not then it's likely no one will ever experience the performance seen in the TPC-C benchmarks by Microsoft. If no real world
apps support a federated architecture then we may as
well just ignore all those benchmarks. And after we
throw all those benchmarks out which database engines
consistently score the best on the remaining benchmarks?
Here's another challenge... Has anyone ever worked with or
even know of anyone who's worked with a federated
database? While I wouldn't configure my database
exactly like Oracle configures those used for TPC benchmarking,
(turning off redo, etc.), in terms of physical design I do
believe my databases are at least somewhat similar or
recognizably in the same ballpark. I do not believe
anyone comes close to configuring SQLServer's physical
layout like that used in the Microsoft benchmarks. That's the challenge and until someone can address this challenge we should
practically ignore all TPC benchmarks produced from
Microsoft's federated database architecture.
IMHO.
> the TPC is *independent*. Yes,
and it's flawed and vendors take advantage of this to dupe the
unwitting.
BTW, Oracle OPS / EMC doesn't have to be a single point of
failure if you implement the SRDF option but I've
never done it so what do I know? Well I'll answer that
by saying I don't know much but I do try to keep an open minded pursuit of the truth. Sometimes I actually succeed... I
think. ;-)
Steve Orr
-Original Message- Sent:
Monday, February 05, 2001 3:09 PM To: Multiple
recipients of list ORACLE-L
Very Interesting! It appears Oracle 9i, is, in fact, a
Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni
A snippet: "An Oracle spokeswoman
said the new Oracle 9i database, due in the first half
of next year, will feature new "clustering" technology that will make
the company

FW: OT - WHAT is a FEDERATED DATABASE ???

2001-02-06 Thread Bowes, Chris

Title: RE: OT - WHAT is a FEDERATED DATABASE ???




  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 8:46 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT - WHAT is a FEDERATED DATABASE ??? 
   
  > the TPC is *independent*. Yes, 
  and it's flawed and vendors take advantage of this to dupe the 
  unwitting. 
  || Name one metric/benchmark that is NOT flawed. You get a 
  free meal     from me if you do. After you can't do that, name one company 
      that would 
  not use a test or competitor's   
  flaws/shortcomings     to their advantage. Come on, it's not about some kind of 
      dreamy 
  "perfection", it's about doing the best we can. 
      I 
  personally believe that quoting the TPC is alot more 
      defensible that 
  quoting Oracle Magazine. LOL!!  
   
  I can 
  name one.  It's the Chris Bowes Mouse Count benchmark 
  system...
  I set 
  up the computer and software you give me and the competitors and run counts, 
  table accesses and the like and time it with the Mickey Mouse watch I 
  got my toddler the last time were went to Disney.  I then 
  stick "YOU WIN" smiley face stickers on the winner and "YOU SUCK" stickers on 
  the one(s) that don't.  In case of a tie, the computers 
  home and take a baseball bat to the ones that don't match my drapes.  
  (The fee for the test is I get to keep the winner).  So do I get the 
  meal?  Huh? Do I? Do I? Do I?

FW: Upgrade Oracle8.1.6 to 8.1.7

2001-02-06 Thread Feng, Jun


> Hi
> 
> We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6.
> Have anybody done this work without database downtime? What was your
> downtime window for upgrade? Anybody have any suggestions about the
> upgrade without downtime?
> 
> Thanks,
> 
> Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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: NT 6a?

Title: RE: NT 6a?





I ran it no problem, but it was super light
use, and several years ago. SP6a is a nice 
fix. 


-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Subject: NT 6a?



Does anyone know if there are any problem with compatibility for NT 6.a and
Oracle Server Work Group version 7.3.4.4.0?


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: OT NT2K vs Unix.

2001-02-06 Thread Boivin, Patrice J


I agree with you, most down time is due to human error, or applying
something (like an upgrade) to existing systems.

I don't understand how management decides whether or not to spend money on
training or on shoring up procedures to reduce down time, I suspect they
only do it when there is a "perceived need" - i.e. when something bad has
happened.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, February 06, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT  NT2K vs Unix.

Given that "most" db problems are app-centric, and a healthy 
majority of *any* datacenters' downtime is human-error related, 
it seems to be that the route to stability is through the 
enhanced learning of the operator/developer/administrators. And 
learning requires open minds and for things like technology, 
frequent refreshing 

But that is just my opinion. It may actually be the case that 
the way to improve something is to castigate, excoriate, and 
denigrate.  But, I need to continue my observations on that 
topic. 

;-> 

-Original Message- 
From: Boivin, Patrice J [ mailto:[EMAIL PROTECTED]
 ] 
Sent: Tuesday, February 06, 2001 9:46 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: OT NT2K vs Unix. 


Hey, I saw the ads on TV.  Microsoft now makes enterprise software,
which 
gives sa's peace of mind... 

It always amazes me how companies identify a problem, then create
ads to 
turn people's perception around.  So now Microsoft is telling people
that 
their systems are reliable and never crash, so system administrators
can 
relax. 

Hopefully with Win2K they actually fixed the problems, and are not
just 
posting ads on TV to turn people's perception around to boost sales.


Eventually I will figure out how the world works.  It's taking me a
while, 
though. 

Regards, 
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 


-Original Message- 
From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, February 01, 2001 4:01 PM 
To: Multiple recipients of list ORACLE-L 
Subject:RE: OT  NT2K vs Unix. 

There is, however, one significant difference: stability. If

Microsoft 
starts making stable 
products, we might just as well start using them, but
knowing 
Microsoft, 
I'm not overly 
worried. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Boivin, Patrice J 
  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: Boivin, Patrice J
  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 - WHAT is a FEDERATED DATABASE ???

2001-02-06 Thread dgoulet


Steve,

I've never heard of any ERP vendor that supports a "federated database" as
you describe it.  PeopleSoft on the other hand keeps telling us that they will
support a replicated/distributed database sometime in the future.  Now if you
understand PeopleTalk that means never.

Dick Goulet

Reply Separator
Author: "Steve Orr" <[EMAIL PROTECTED]>
Date:   2/5/2001 4:55 PM

Ross, glad to see you're starting to come up to speed here. :>)

> But for the clustering to work, businesses would have to change software
> and segment the data

The CNet authors obviously got tangled up in their notes and didn't
understand what they were writing about. (Not a first.) You don't have to
"segment the data" in OPS- that's the "federated database" scene where you
place different tables for the same database app on different servers. If
you segment an enterprise package like SAP or Oracle ERP then you have
1000's of tables to deal with. Chances are, no matter how "intelligently"
you segment your data, just losing any random machine, and its attendant
subset of tables, will bring the application to a halt and no more
transactions will be possible even though the database is still "up." That's
a single point a failure and that's the real problem. And to add a machine
to the federated cluster you still have to re-segment the data. I don't
believe the good folks at Dell have architected a federated database like
Microsoft did for the TPC.

Here's a challenge... Does anyone know of ANY enterprise ERP type package or
any other application where the software vendor supports a "federated"
architecture? If not then it's likely no one will ever experience the
performance seen in the TPC-C benchmarks by Microsoft. If no real world apps
support a federated architecture then we may as well just ignore all those
benchmarks. And after we throw all those benchmarks out which database
engines consistently score the best on the remaining benchmarks?

Here's another challenge... Has anyone ever worked with or even know of
anyone who's worked with a federated database? While I wouldn't configure my
database exactly like Oracle configures those used for TPC benchmarking,
(turning off redo, etc.), in terms of physical design I do believe my
databases are at least somewhat similar or recognizably in the same
ballpark. I do not believe anyone comes close to configuring SQLServer's
physical layout like that used in the Microsoft benchmarks. That's the
challenge and until someone can address this challenge we should practically
ignore all TPC benchmarks produced from Microsoft's federated database
architecture. IMHO.

> the TPC is *independent*.
Yes, and it's flawed and vendors take advantage of this to dupe the
unwitting.

BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you
implement the SRDF option but I've never done it so what do I know? Well
I'll answer that by saying I don't know much but I do try to keep an open
minded pursuit of the truth. Sometimes I actually succeed... I think.   ;-)


Steve Orr


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


Very Interesting!  It appears Oracle 9i, is, in fact, a Hybrid Federated
Database!
http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni
A snippet:
"An Oracle spokeswoman said the new Oracle 9i database, due in the first
half of next year, will feature new "clustering" technology that will make
the company's databases perform faster and more reliably than before.
Clustering allows businesses to harness multiple servers to run a very large
database, allowing servers to share work or take over from each other if one
fails.
The company's previous clustering technology, called Oracle Parallel Server,
allowed businesses to add as many servers, or high-end computers, as they
needed. But for the clustering to work, businesses would have to change
software and segment the data, a time-consuming effort for database
administrators, said Jeremy Burton, Oracle's senior vice president of
products and services marketing..."


-Original Message-
Sent: Monday, February 05, 2001 5:55 PM
To: '[EMAIL PROTECTED]'


I have some answers, for the curious:
http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html


It appears that SS can partition data storage among multiple
machines, giving it "blow your doors off" performance.
If a machine goes ( gets dynamited at an Oracle demo, for instance)
the data goes with it.
This would be much in the same way that your data (ALL of it) would
go if you blew up the EMC/Hitachi/StorageWorks array.
Oracle Parallel Server, in contrast, has a single location for
it's data ( read: single point of failure! )
Granted, there are more failure points in a federated architecture,
but there is no such thing as a TOTAL failure ( like "site down" )
since only part of the data needs to be recovered from backup.
But, with Oracle

RE: OT - WHAT is a FEDERATED DATABASE ???

2001-02-06 Thread Steve Orr


Name one company who wouldn't try to tweak a benchmark test in an
unrealistic and/or deceptive fashion in order to make a few more sales.
Oracle is guiltier than most and has made an art of it. Aren't benchmarks
supposed to help us make better decisions? Instead they just add to the
confusion. Nevertheless, I do appreciate the independent attempts of the
TPC.

Here's a benchmark: The database company with the most ads quoting benchmark
results deserve the most scrutiny. Not worth a free meal... I owe you a cup
of coffee. Room for cream? Thanks Ross for playing devil's advocate and
stirring up the pot for the sake of spirited discussion. :-) It's been fun
but work beckons... Sigh.

Steve Orr


-Original Message-
Sent: Tuesday, February 06, 2001 5:46 AM
To: Multiple recipients of list ORACLE-L

> the TPC is *independent*.
Yes, and it's flawed and vendors take advantage of this to dupe the
unwitting.
|| Name one metric/benchmark that is NOT flawed. You get a free meal
from me if you do. After you can't do that, name one company
that would not use a test or competitor's   flaws/shortcomings
to their advantage. Come on, it's not about some kind of
dreamy "perfection", it's about doing the best we can.
I personally believe that quoting the TPC is alot more
defensible that quoting Oracle Magazine. LOL!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Orr
  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: RE: OT NT2K vs Unix.

2001-02-06 Thread dgoulet


Hey, I'm waiting for the wearable computer with the wireless link into the
network.  Especially if it comes with voice command.  That way when a "middle of
the night" problem occurs all I'll have to do is roll over, fix the problem, and
then fall back asleep.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   2/6/2001 6:26 AM

Pithy as hell and twice as true. 

I agree totally..agents...interfacesgraphicsAI...

-Original Message-
Sent: Tuesday, February 06, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L


The future of computers, look at the games of today.



 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]


> -Original Message-

> are some that I can think of).  Heck, I wouldn't be surprised 
> if the code
> for some database query optimizers trace back to some gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  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: OT  NT2K vs Unix.



Pithy as hell and twice as true. 


I agree
totally..agents...interfacesgraphicsAI...


-Original Message-
From: Anderson, Brian [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]
achnet.edu]
Sent: Tuesday, February 06, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: OT NT2K vs Unix.



The future of computers, look at the games of today.




 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]



> -Original Message-


> are some that I can think of).  Heck, I wouldn't be
surprised 
> if the code
> for some database query optimizers trace back to some
gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com
-- 
Author: Anderson, Brian
  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: Rollback Question

2001-02-06 Thread salu Ullah


Hello Casey

Run this script. It will display rollback & commit of all running session

set head on
set echo off
set verify   off
set feedback off
set pagesize 1000
set tab  off
col "SID"   format 999
col "Nb commit"format 99,999,999,999
col "Nb rollback"  format 999,999,999

-- to find the
select  min(sid) "SID",
sum(cmt)  "Nb commit",
sum(roll) "Nb rollback"
from (
  select ses.sid, st.value cmt, 0 roll
  from v$session ses, v$sesstat st, v$statname nm
  where ses.sid = st.sid and
st.statistic# = nm.statistic# and
nm.NAME = 'user commits'
union
  select ses.sid, 0, st.value
  from v$session ses, v$sesstat st, v$statname nm
  where ses.sid = st.sid and
st.statistic# = nm.statistic# and
nm.NAME = 'user rollbacks'
  )
group by sid ;




>From: "Casey Jordan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rollback Question
>Date: Tue, 06 Feb 2001 06:00:23 -0800
>
>Is there anyway to find out if a long running concurrent program is rolling 
>back its transactions?
>
>
>Thanks
>
>Casey

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: salu Ullah
  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 to use Export Transportable Tablespaces

2001-02-06 Thread Larry Taylor



Does anyone have an example of how to use transportable tablespaces with
export/import.

I want export a user (8.1.6 database) source and import fromuser
touser(8.1.6 database) target.

I tried to import fromuser/ touser, but many contraints were not created and
lost some data
so I was told to try transportable tables. Can't find any good examples on
how to use this new
feature.

Can someone please help me.

Thanks
Larry





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Taylor
  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

2001-02-06 Thread Eric D. Pierce

On 6 Feb 2001, at 7:45, Bill Pribyl wrote:

Date sent:  Tue, 06 Feb 2001 07:45:49 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> > Just got off the phone w/ Oracle tech support, and they said that OEM
> > *is* definetly supported on Windows 2000, and should work fine.
> 
> I stand corrected.  It didn't work for me or a client of mine "out of the
> box" but I just went and turned on *all* the Oracle-related services in the
> control panel, and it seems to be working now.

Really! Interesting, where did you get that idea?

> 
> Thanks!

no problema.

> Bill
> 
> PS  Dontcha just love answers from tech support that include the phrase
> "should work fine"?

Well... that was my paraphrase of something they said along the lines
of: "no known issues, but read the release notes and documentation
carefully."

Good thing I don't work at Oracle tech support! :)

regards,
ep

-- 
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: OT NT2K vs Unix.

Title: RE: OT  NT2K vs Unix.





My understanding is that the current flavor of MAC OS is
about $129. 


That's not very Unix like!



MAC OS X is based on NeXT OS (that was KILLER) and NeXT was
based on CMU Mach kernel (microkernel ideas). 


Like Win NT.   (ahem.)





-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT NT2K vs Unix.



I heard that the Mac OS is a variant of UNIX with a GUI on top.


So that wouldn't be far off the mark.


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


    -Original Message-
    From:   Rocky Welch [SMTP:[EMAIL PROTECTED]]
    Sent:   Thursday, February 01, 2001 3:01 PM
    To: Multiple recipients of list ORACLE-L
    Subject:    Re: OT  NT2K vs Unix.



    The same prediction was made at least 5 years ago. At the rate
Microsoft is going, Windows will be a direct form of Unix. It becomes more
like it with every release. 


    -Rocky 


    
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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).

Precise Sql info

2001-02-06 Thread Mike Lanteigne


Hi all,

Thanks for all who responded to my dba/PeopleSoft query. Your insights were
very helpful.

Now I'm looking for any thoughts on Precise SQL and the Precise Enterprise
product line. From their web page, it seems like a job unto itself to run!
Any thought or experiences welcome.

Thanks again

Mike

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Lanteigne
  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-06 Thread Eric D. Pierce

On 6 Feb 2001, at 8:51, Mohan, Ross wrote:

Date sent:  Tue, 06 Feb 2001 08:51:43 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Or if some people hadn't been snoozing... maybe a better OS
from Digital Research, or other boxes based on the 
Xerox/PARC work???

> Hell, if Apple gave ANYBODY access in the early days, we'd all
> be reading this mail on MacInstoshes instead of wintel boxes. 
> 
> -Original Message-
> Sent: Tuesday, February 06, 2001 10:10 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In fact there was a recent discussion on /. that if Mac OS X is ported to
> x86 platform ... it could challenge Linux ...

-- 
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:Pro*C book

2001-02-06 Thread dgoulet


Kimberly,

There is a book on C language programming style written by Kerrigan & Richie
(the FATHERS of the language) that I really love.  Consequently it's at home
where it can't grow legs.  Otherwise I simply use the Pro*C manual from Oracle
and follow the standard that all "EXEC SQL" statements are in uppercase, except
for host variables.  Which is the way Oracle teaches it.  I've even had some of
my code reviewed by other managers & directors here who have made my ideas the
standards.  Pretty simple actually, ask the developers to critique each others
code.  The desired results will fall out.

Dick Goulet

PS: Here's an example;

int deltext(void)
{  char efile[100];
   int y = 0;
   EXEC SQL DECLARE TEXTDEL CURSOR FOR
 SELECT PREFIX||TO_CHAR(TO_DATE(:loaddate,'fmDDMONYY'),FORMAT)
  ||SUFFIX||'.'||EXTENSION
 FROM TEXT_LOAD_FORMATS
 WHERE ID = :testerid
 ORDER BY DECODE(TABLE_TYPE,'HEADER',0,'DATA',1);
   if(oracle_error("Declare textload cursor")) return(1);
   EXEC SQL OPEN TEXTDEL;
   if(oracle_error("Open Text Load")) return(1);
   do
   {  EXEC SQL FETCH TEXTDEL INTO :fname;
  if(oracle_error("Fetch text load")|| sqlca.sqlcode > 0) break;
  NULLTERM(fname);
  sprintf(efile,"%s\\%s\0", testerpath.arr, fname.arr);
  y = remove(efile);
  if(y!= 0) break;
   }while(sqlca.sqlcode == 0);
   EXEC SQL CLOSE TEXTDEL;
   return(y);
}

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   2/6/2001 8:20 AM

Just wondering what people are using for a Pro*C reference?
I am seeing some pretty bad code here in that area (mostly
by a developer who likes to hack and no longer works here but
its what people are using for guidelines) and would like to have
a reference around that the developers can use.  I used to have
a copy of the Oracle Press one and it was not to bad.  Actually,
the manual is not to bad but they don't seem to want to use
it.



Kimberly Smith
EDS 
Fujitsu/GMD
21015 SE Stark St
Gresham, OR
97030
Phone:  (503) 669-6050
Fax:  (503) 669-5705

-- 
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).
-- 
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: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows

2001-02-06 Thread Mark Leith

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

No
problem..

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Tuesday, February 06, 2001 03:51To: Multiple recipients of list
ORACLE-LSubject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on
Windows
Thanks for the extended mail on your direct experience.

Much better than CNET, I guess we can all agree?
-Original Message- From: Mark
Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows

Ep,
I have 8i running concurrently on a Win2k system with SS7, and
have to say that it still runs like a dream. Like I
mentioned earlier Oracle is still my favourite
databeast, but there are a few things that still cough and splutter - like OEM for example. The Java side of things can be a
little painful, but as I understand it is mostly on
all platforms, as Oracle still haven't got it just
right - though 9i again is "supposed" to be a great improvement on how the JVM is managed.
Win2K has better service management - unless I didn't notice
under NT - where if a service fails, you can first try
and restart the service, if that fails, you can run a
file - whatever it may be - and if THAT fails you can reboot the machine automatically, and cross your fingers that the
service starts properly with spewing nasty error
messages at you.
I have been using Win2k for around 4 months now and have NEVER
seen a BSOD (Blue Screen of Death), I reboot quite
often - granted - but that is only because LookOut
keep trying to dial my mail server, gets it knickers in a twist, hangs, gives me a mail delivery error, trys again, then comes
back telling me the phone entry it already being
dialed!! So because I can't live without my Lyris
"Family" I have to reboot the bloody thing. I have only once had to reboot when installing new software, and that was because
the dongle wasn't recognized properly.
All in all Win2K is far and above NT 4 in my view. File
management is handled a lot better, you can have
online network drives, even if the network machine is
down.. IIS is OK but I can't see a business need for it though..
Oh, and they have even added the lovely little desktops themes
available with Windows 98, but not NT.. Now, I have to
say, this little feature is the one that sold it for
me :)
Give it a try Eric, if you are used to NT, you may be
pleasantly suprised..
Regards
Mark
P.S Win2K was Built on NT Technology according to the new
splash screen.. It can only improve right? Right?
Micrslop? hardy har har har...
-Original Message- Pierce Sent: Monday, February 05, 2001
07:06 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: 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 mes

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

2001-02-06 Thread Eric D. Pierce

On 6 Feb 2001, at 7:01, Jeffery Stevenson wrote:

Date sent:  Tue, 06 Feb 2001 07:01:30 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> ...  BTW, I use Win2K here for my desktop box.  It runs
> fairly well (and surprisingly even runs faster than NT)...the Oracle db I
> have running on it runs nicely.  I can usually leave my system up and
> running for a couple of months before encountering any oddities/lock-ups.

Sounds good, thanks for the feedback.

> system is really only as good as the people that maintain it (and some
> people are just better at it than others).  

That seems to be the conventional wisdom about NT/Win2k. Our
campus NT/Win2k SAs (&network engineers) are really smart 
guys, so I don't think we will have problems. 

Also, fortunately it seem there is quite of bit of good quality
free tech support material that the user community has out there
on the web.

> -Original Message-
> Sent: Tuesday, February 06, 2001 7:46 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Ep,
> 
> I have 8i running concurrently on a Win2k system with SS7, and have to say
> that it still runs like a dream. Like I mentioned earlier Oracle is still my
> favourite databeast, but there are a few things that still cough and
> splutter - like OEM for example. 

The Oracle tech support person I talked to yesterday said that
you need *more* than 256Mb RAM for OEM. They suggested at least
128Mb more than 256Mb, and to make sure that you have good disk
I/O on the box to mitigate OS swapping issues.

They also said to avoid AD like the plague (unless you *REALLY*
undestand AD architecture/implementation, and are able to make 
sure every singe little thing related to AD on the whole network
is done exactly the same on each node).

fwiw:

>From what Oracle tech support said, we will probably *eventually* 
end up with the following (after a year or so):

1) Oracle9i RDBMS (upgraded from 8.1.6 and WebDB 2.2?) on a
   "dedicated" Win2K (or whistler).

2) Oracle Portal (and/or other web server stuff) on a 
   separate "middle-tier" server machine - could be NT4, or Win2k
(or maybe Linux if the SAs get brave!)

(possible share with other departments using Oracle,
 or we will use our old departmental Netware3 box, 
 reformatted with NT4/Win2k)

   (Portal shouldn't/can't run on the same box as 9i RDBMS)

3) OEM on a beefy NT4, or Win2k "pro" desktop
(this moves the flakiness off the 8i/9i RDBMS box)

...

> I have been using Win2k for around 4 months now and have NEVER seen a BSOD
> (Blue Screen of Death), I reboot quite often - granted - but that is only
> because LookOut keep trying to dial my mail server

...

yuk. 

[OT/plug]

if you really don't need Outlook (calendar, Exchange compatibility, 
or whatever for Lyris), check out http://www.pmail.com , David Harris 
is going to have a new/improved version of Pegasus Mail out soon 
(better IMAP client support and so forth), and his next "Mercury/32" 
mail server will have an IMAP module.

 ...

> All in all Win2K is far and above NT 4 in my view. File management is
> handled a lot better

Oh yea.

...

> Give it a try Eric, if you are used to NT, you may be pleasantly suprised..

Server-wise, we are migrating from Oracle7.3/Netware3 (gasp), not
NT4. My goal was, if possible, to not get "stuck" with NT4 while the
rest of the world was moving on to better things. This was with
hope that Win2k will work good for a couple of years, or at least if 
we have to go Whistler in a year or so, it will be easier to do that 
from Win2k than from NT4 (?). Everyone around here hates server OS 
upgrades. The tendency is to get something working, and leave it 
alone for as long as possible (which is why we are still on 
Netware3/Oracle7.3!).

thanks again,
(also thanks to everyone else that contributed to the thread)
ep

...

> -Original Message-
> Pierce
> Sent: Monday, February 05, 2001 07:06
> To: Multiple recipients of list ORACLE-L

...

>> 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?

...

-- 
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: Reporting database

2001-02-06 Thread Yosi


You don't need replication. You can simply create tables on one
machine across a db link fom the first. Depends on the volume and
type of data.

We (only a few Gb) rebuild our reporting environment from transaction.
Reporting doesn't have ALL the tables from OLTP, just the ones we need,
somewhat denormalized, summarized, etc.

G'luck.

Yosi


> -Original Message-
> From: Terrian, Thomas [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 7:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Reporting database
> 
> 
> How are you all creating reporting databases?  We currently 
> have an OLTP
> database and we wish to create a reporting database from it.  
> As I see it,
> we have the following options:
> 
> 1.  Create the reporting database as a Standby database.  I 
> don't think that
> this will work since the database must be up and not in standby mode.
> 2.  Use Oracle replication.  I have heard it is cumbersome 
> and has trouble
> keeping up with lots of transactions.
> 3.  Snapshots/materialized views.
> 4.  Beef up our current machine so that it can handle OLTP 
> transactions and
> reports.
> 5.  Since we are using a BMC disk array, we could break the mirror
> periodically and mount the disks on a new machine.
> 6.  Other 3rd party replication products.
> 7.  We could probably use some type of import/exports.
> 
> How are the rest of you doing it?  Are there any other options that I
> forgot?
> 
> Thanks,
> Tom
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Terrian, Thomas
>   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: Unix SysAdmin Book??

2001-02-06 Thread Roy Ferguson


Unix System administration handbook second edition
 by: evi nemeth * garth snyder * scott seebass * trent r. hein
 
Shell scriping
the new kornshell command and programming language
by: morris I bolsky and david g. korn



>Hi Guys
>
>Could you suggest any Best book for System Administration and Shell 
>Scripting for Solaris.
>
>Thanks
>Raghu.
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Raghu Kota
>  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).




Roy E. Ferguson II
Sr. Database Administrator
Intel Sacramento
916-854-1123

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Roy Ferguson
  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 displaying umlaut character

2001-02-06 Thread Kirsh, Gary




Jerry,
 
When 
debugging this type of problem, you need to determine if the umlaut character is 
being stored incorrectly in the database, or just displayed incorrectly when you 
select it.  Use the DUMP function to see the internal representation of the 
character:
 
select 
dump(col1) from umlaut where col1='Brömmel';  
 
Check the ascii value of the 3rd char to see it it is a v or an 
ö  
Also, what is the 
value of NLS_LANG on the client?  Is it AMERICAN_AMERICA.UTF8?  What 
is the client?  Are you on the server, or connecting over sqlnet?  If 
you are running from a DOS client, you may need to change the code page to 
display the character correctly.
 
If you post the answers to these questions, I'll try to 
earn my virtual homebrew!
 
Gary Kirsh
Next Extent, Inc
 
 

  -Original Message-From: Jerry C 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 10:01 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  problem displaying umlaut character
  Hi all,
   
  I'm having problems displaying an umlaut 
  character correctly. For example:
  create table umlaut(col1 
  varchar2(10));  Table created.
   
  insert into umlaut 
  values('Brömmel'); 1 row created. select * from 
  umlaut where col1='Brömmel';  
   
  COL1--Brvmmel 
   
  My NLS parameters:
   
  msuawo01> svrmgrl Oracle 
  Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, 
  Oracle Corporation.  All Rights Reserved. Oracle8i 
  Enterprise Edition Release 8.1.5.0.0 - ProductionWith the Partitioning and 
  Java optionsPL/SQL Release 8.1.5.0.0 - Production SVRMGR> 
  connect internalConnected.SVRMGR> show parameter 
  NLSNAME    
  TYPE    VALUE--- --- 
  --nls_calendar    
  string    
  nls_comp    
  string    
  nls_currency    
  string    
  nls_date_format 
  string  
  MM/DD/    
  nls_date_language   
  string    
  nls_dual_currency   
  string    
  nls_iso_currency    
  string    
  nls_language    
  string  
  AMERICAN  
  nls_numeric_characters  
  string    
  nls_sort    
  string    
  nls_territory   
  string  
  AMERICA   
  nls_time_format 
  string    
  nls_time_tz_format  
  string    
  nls_timestamp_format    
  string    
  nls_timestamp_tz_format 
  string    
  
   
  SQL> set linesize 125SQL> 
  select * from nls_database_parameters ;PARAMETER 
  VALUE-- 
  --NLS_LANGUAGE 
  AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY 
  AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET UTF8NLS_CALENDAR 
  GREGORIANNLS_DATE_FORMAT DD-MON-YYNLS_DATE_LANGUAGE 
  AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER 
  VALUE-- 
  --NLS_TIMESTAMP_FORMAT 
  DD-MON-YY HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM 
  TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM 
  TZH:TNLS_DUAL_CURRENCY $NLS_COMPNLS_NCHAR_CHARACTERSET 
  UTF8NLS_RDBMS_VERSION 8.1.5.0.018 rows selected.A 
  virtual homebrew (British Pale Ale) to anybody who can help!
   
   
  Thanks!
   
  - Jerry

RE: problem displaying umlaut character


And the session ones ?: nls_session_parameters. Derivated from init.ora
settings and NLS_LANG environment variable on Unix or NLS_LANG field of
regedit on Windows.

Regards.

> -Mensaje original-
> De:   Jerry C [SMTP:[EMAIL PROTECTED]]
> Enviado el:   martes 6 de febrero de 2001 16:01
> Para: Multiple recipients of list ORACLE-L
> Asunto:   problem displaying umlaut character
> 
> Hi all,
>  
> I'm having problems displaying an umlaut character correctly. For example:
> 
> create table umlaut(
> col1 varchar2(10));
>   
> Table created.
>  
> insert into umlaut values('Brömmel');
>  
> 1 row created.
>  
> select * from umlaut where col1='Brömmel';  
>  
> COL1
> --
> Brvmmel
>  
>  
> My NLS parameters:
>  
> msuawo01> svrmgrl
>  
> Oracle Server Manager Release 3.1.5.0.0 - Production
>  
> (c) Copyright 1997, Oracle Corporation.  All Rights Reserved.
>  
> Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> With the Partitioning and Java options
> PL/SQL Release 8.1.5.0.0 - Production
>  
> SVRMGR> connect internal
> Connected.
> SVRMGR> show parameter NLS
> NAMETYPEVALUE
> --- --- --
> nls_calendarstring
> nls_compstring
> nls_currencystring
> nls_date_format string  MM/DD/
> nls_date_language   string
> nls_dual_currency   string
> nls_iso_currencystring
> nls_languagestring  AMERICAN  
> nls_numeric_characters  string
> nls_sortstring
> nls_territory   string  AMERICA   
> nls_time_format string
> nls_time_tz_format  string
> nls_timestamp_formatstring
> nls_timestamp_tz_format string
>  
> SQL> set linesize 125
> SQL> select * from nls_database_parameters ;
> 
> PARAMETER VALUE
> -- 
> --
> --
> --
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CHARACTERSET UTF8
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-YY
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
> 
> PARAMETER VALUE
> -- 
> --
> --
> --
> NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM TZH:T
> NLS_DUAL_CURRENCY $
> NLS_COMP
> NLS_NCHAR_CHARACTERSET UTF8
> NLS_RDBMS_VERSION 8.1.5.0.0
> 
> 18 rows selected.
> 
> 
> A virtual homebrew (British Pale Ale) to anybody who can help!
>  
>  
> Thanks!
>  
> - Jerry
> 
>  
--
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: RE: OT NT2K vs Unix.

2001-02-06 Thread Koivu, Lisa

Title: RE: RE: OT  NT2K vs Unix.





Are you using parallel query?  Looks like parallel query slaves bombing out.  What's in your trace files?


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."


-Original Message-
From: Shakeel Qureshi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: OT NT2K vs Unix.



Hi gurus!


I am having the following bug in alert_log.  Oracle
says it may be because of using Pro*C which we are 
not using at all.


Anybody has any idea about it. It oracle version 8.1.6
on salaris 2.7.


TIA,


Shakeel Qureshi
[EMAIL PROTECTED]


Sat Jan 27 10:15:47 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_14886.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:15:47 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_14888.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:56:45 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_14940.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 10:56:45 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_14942.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 12:15:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15040.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 12:15:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_15042.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 13:14:31 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/udump/bpnext_ora_13259.trc:
ORA-07445: exception encountered: core dump
[kkoapk()+40] [SIGBUS] [Invalid address alignment]
[2031883] [] []
Sat Jan 27 15:41:02 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15367.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 15:41:02 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_15369.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Sat Jan 27 17:27:52 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_15496.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  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 - CacheFusion

2001-02-06 Thread Gary Weber

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE



CacheFusion is already available in 8i. They call it the first phase, or 
something along those lines. 8i version handles the redo blocks over the 
interconnect, whereas the 9i will also ship the actual data blocks. So, in 
theory, 9i OPS should perform MUCH better and scale easier, given the fast 
interconnect...
 
Gary 
Weber
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Tony JohnsonSent: 
Tuesday, February 06, 2001 11:11 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
FEDERATED DATABASE
The 
whole idea behind 9i is CacheFusion which uses a high-speed
interconnect to solve the pinging issues. At least that 
is the marketing
line 
that will only be proved in time. Any database of any size 
should
be 
using partititioning if you want it to perform and be able to manage 
it.
--Tony 
Johnson        
    
    
    Email  : 
[EMAIL PROTECTED]Senior Database Administrator   
    
    Voice  : ( 480 ) 682 - 
0849GridData    
    
    
    
    Cell   : ( 602 ) 363 - 
7328     
   7408 W. Detroit 
#100        
    
    Fax    : ( 480 ) 961 - 
8801Chandler, AZ 
85226--Murphy's 
Data Constant:Data will be damaged in direct proportion to its value 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
  FEDERATED DATABASE
  I 
  understand the argument, Rodd and it raises three 
  points/questions:
   
  1) I 
  can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD 
  SAN does 
      for the Oracle solution, and at less cost, 
  and
   
  2) 
  Do you believe you can simply "add nodes" to an OPS farm to improve 
  performance? I have
      personally never gone over a humble two nodes in OPS, and 
  even then, locking issues must
      be addressed. One way out of this is the geographically 
  segregate and partition the data. But
  this would be "federated."  In a 
  pure play OPS scenario, I would imagine the system 
  would
      choke to death after the fourth or sixth node, without special 
  tweaks like partitioning, either
      by 
  data or application. 
   
  3) Loss of a SS "state", just like loss of an oracle 
  partition, does not "kill the operation of the system". 
  
      here, they are the same. 
  ..
   
  just a thought..
   
   
      
   
   -Original 
  Message-From: Holman, Rodney 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 
  5:21 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED 
  DATABASE
  
Ross,
I 
was at the Open World conference session where Jeremy Burton made the 
comments about clustering, OPS, data segmentation, etc.  The data 
segmentation part was about MS SQLServer, and about how it creates 
significant work to add cluster nodes. C|net has their terms and 
comments a little scrambled. The Oracle 9i solution used OPS for the 
instances and an EMC/SRDF SAN for the data storage.  Each OPS cluster 
node had full access to every piece of data.  By doing this no node is 
a single point of failure (as Larry demonstrated and was chastised for by 
MS).  Also it creates greater capability for scalability.  Just 
configure and add a node and it improves performance (also part of Larry's 
demo).  As described with the MS federated database configuration you 
would need to resegment the data to add a node.  This would then 
destabilize the system even further by adding another single point of 
failure.  Failure of an OPS cluster node with the data on a SAN  
with redundancy, such as the EMC/SRDF option, only decreases performance, it 
doesn't kill the operation of the system.
 
Rodd Holman

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 
  5:09 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
  FEDERATED DATABASE
  Very Interesting!  It appears Oracle 9i, is, in fact, 
  a Hybrid Federated Database! 
  http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni 
  
  A snippet:

Alert Log

2001-02-06 Thread Shakeel Qureshi


Hi gurus!

I am receiving the following bug in my Alert Log.
Oracle says it may be because of using PRO*C which
we are not using all.

Please review the contents and if someone has any idea
about it, the input will be appreciated.

Thu Jan 25 06:56:15 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 06:56:15 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 06:56:37 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 06:56:37 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:05:05 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:05:05 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:06:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:06:39 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:06:59 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Thu Jan 25 10:06:59 2001
Errors in file
/u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc:
ORA-00600: internal error code, arguments: [KGHALO2],
[0], [], [], [], [], [], []
Fri Jan 26 04:43:13 2001
alter database backup controlfile to trace
Fri Jan 26 04:43:13 2001

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  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: RE: OT NT2K vs Unix.

Title: RE: RE: RE: OT  NT2K vs Unix.





It exists!


I even see "anti RF" clothing for sale!



Amazing world.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 12:49 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: OT NT2K vs Unix.



Hey, I'm waiting for the wearable computer with the wireless link into the
network.  Especially if it comes with voice command.  That way when a "middle of
the night" problem occurs all I'll have to do is roll over, fix the problem, and
then fall back asleep.


Dick Goulet


Reply Separator
Subject:    RE: RE: OT  NT2K vs Unix.
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   2/6/2001 6:26 AM


Pithy as hell and twice as true. 


I agree totally..agents...interfacesgraphicsAI...


-Original Message-
Sent: Tuesday, February 06, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L



The future of computers, look at the games of today.




 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]



> -Original Message-


> are some that I can think of).  Heck, I wouldn't be surprised 
> if the code
> for some database query optimizers trace back to some gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  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: OT  NT2K vs Unix.




Pithy as hell and twice as true. 



I agree
totally..agents...interfacesgraphicsAI...



-Original Message-
From: Anderson, Brian [
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]
achnet.edu]
Sent: Tuesday, February 06, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: OT NT2K vs Unix.




The future of computers, look at the games of today.





 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]




> -Original Message-



> are some that I can think of).  Heck, I wouldn't be
surprised 
> if the code
> for some database query optimizers trace back to some
gaming 
> AI code.   :)
> 
-- 
Please see the official ORACLE-L FAQ: 
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com
-- 
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]



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

SIZE=2>
T>
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 - WHAT is a FEDERATED DATABASE

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE



right. 

 
kind 
of an Akamai-like localization of content. 
 
Now, 
the interesting behavior arises when the local server "blows up" 

and 
the users have to go back to the central server to get the data. 

 
The 
localization of data for fast access makes it look federated 
and
the 
existence of a "Mother of all Single Points of Failure" central site 

makes 
it look like good old OPS. 
 

 
 
I 
agree wholeheartedly with the partitioning observation you made. 

Now, 
put your data on physically distinct machines and you've
federated your database. In Oracle!  neat trick. 


  -Original Message-From: Tony Johnson 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 
  11:11 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED 
  DATABASE
  The 
  whole idea behind 9i is CacheFusion which uses a 
high-speed
  interconnect to solve the pinging issues. At least 
  that is the marketing
  line 
  that will only be proved in time. Any database of any size 
  should
  be 
  using partititioning if you want it to perform and be able to manage 
  it.
  --Tony 
  Johnson        
      
      
      Email  : 
  [EMAIL PROTECTED]Senior Database Administrator   
      
      Voice  : ( 480 ) 682 - 
  0849GridData    
      
      
      
      Cell   : ( 602 ) 363 - 
  7328     
     7408 W. Detroit 
  #100        
      
      Fax    : ( 480 ) 961 
  - 8801Chandler, AZ 
  85226--Murphy's 
  Data Constant:Data will be damaged in direct proportion to its value 
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
FEDERATED DATABASE
I 
understand the argument, Rodd and it raises three 
points/questions:
 
1) 
I can always back up a "state" ( part of a federation?) just like 
EMC/SRDF/BFD SAN does 
    for the Oracle solution, and at less cost, 
and
 
2) 
Do you believe you can simply "add nodes" to an OPS farm to improve 
performance? I have
    personally never gone over a humble two nodes in OPS, 
and even then, locking issues must
    be addressed. One way out of this is the geographically 
segregate and partition the data. But
this would be "federated."  In a 
pure play OPS scenario, I would imagine the system 
would
    choke to death after the fourth or sixth node, without special 
tweaks like partitioning, either
    by data or application. 
 
3) Loss of a SS "state", just like 
loss of an oracle partition, does not "kill the operation of the system". 

    here, they are the 
same. ..
 
just a 
thought..
 
 
    
 
 -Original 
Message-From: Holman, Rodney 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 
2001 5:21 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
FEDERATED DATABASE

  Ross,
  I was at the Open World conference session where 
  Jeremy Burton made the comments about clustering, OPS, data segmentation, 
  etc.  The data segmentation part was about MS SQLServer, and about 
  how it creates significant work to add cluster nodes. C|net has their 
  terms and comments a little scrambled. The Oracle 9i solution used OPS for 
  the instances and an EMC/SRDF SAN for the data storage.  Each OPS 
  cluster node had full access to every piece of data.  By doing this 
  no node is a single point of failure (as Larry demonstrated and was 
  chastised for by MS).  Also it creates greater capability for 
  scalability.  Just configure and add a node and it improves 
  performance (also part of Larry's demo).  As described with the MS 
  federated database configuration you would need to resegment the data to 
  add a node.  This would then destabilize the system even further by 
  adding another single point of failure.  Failure of an OPS cluster 
  node with the data on a SAN  with redundancy, such as the EMC/SRDF 
  option, only decreases performance, it doesn't kill the operation of the 
  system.
   
  Rodd Holman
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 
5:09 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a 
FEDERATED DATABASE
Very Interesting!  It appears Oracl

RE: ora-07445



I really appreciate your input.  The consultants are working on this as it
is their product.  When I found out it was their daemon that was causing
the ora-07445 I contacted them.  They assured me with a 100% confidence
that it wasn't the daemon but that they'll stop it and see what happens.
As soon as they stopped the daemon the errors disappeared.  So, they're
trying to figure out what is the root of the problem.

Thanks

Ana


   

"Mohan, Ross"  

   
-SMI.com>cc:   

Sent by: Subject: RE: ora-07445

root@fatcity.  

com

   

   

02/06/01   

12:10 PM   

Please 

respond to 

ORACLE-L   

   

   





I run daemons all the time without 7445s.


So, I'd say you found the vehicle, but not the root cause.


For future use, I'd humbly suggest you continue analysis until
you determine root cause, or be prepared to repeat history.


hth


ross


-Original Message-
Sent: Tuesday, February 06, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L






Thanks for your help.  I found the cause.  It was a daemon that our
consultants run to gather information and monitor our database.  We stopped

the daemon.  And that took care of the error and core dumps.


Ana






"Mohan, Ross"


-SMI.com>cc:

Sent by: Subject: RE: ora-07445

root@fatcity.

com



02/05/01

01:45 PM

Please

respond to

ORACLE-L









nothing before or after?





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





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









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

RE: problem displaying umlaut character




NLS to 
WesternEuropean.

  -Original Message-From: Jerry C 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 10:01 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  problem displaying umlaut character
  Hi all,
   
  I'm having problems displaying an umlaut 
  character correctly. For example:
  create table umlaut(col1 
  varchar2(10));  Table created.
   
  insert into umlaut 
  values('Brömmel'); 1 row created. select * from 
  umlaut where col1='Brömmel';  
   
  COL1--Brvmmel 
   
  My NLS parameters:
   
  msuawo01> svrmgrl Oracle 
  Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, 
  Oracle Corporation.  All Rights Reserved. Oracle8i 
  Enterprise Edition Release 8.1.5.0.0 - ProductionWith the Partitioning and 
  Java optionsPL/SQL Release 8.1.5.0.0 - Production SVRMGR> 
  connect internalConnected.SVRMGR> show parameter 
  NLSNAME    
  TYPE    VALUE--- --- 
  --nls_calendar    
  string    
  nls_comp    
  string    
  nls_currency    
  string    
  nls_date_format 
  string  
  MM/DD/    
  nls_date_language   
  string    
  nls_dual_currency   
  string    
  nls_iso_currency    
  string    
  nls_language    
  string  
  AMERICAN  
  nls_numeric_characters  
  string    
  nls_sort    
  string    
  nls_territory   
  string  
  AMERICA   
  nls_time_format 
  string    
  nls_time_tz_format  
  string    
  nls_timestamp_format    
  string    
  nls_timestamp_tz_format 
  string    
  
   
  SQL> set linesize 125SQL> 
  select * from nls_database_parameters ;PARAMETER 
  VALUE-- 
  --NLS_LANGUAGE 
  AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY 
  AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET UTF8NLS_CALENDAR 
  GREGORIANNLS_DATE_FORMAT DD-MON-YYNLS_DATE_LANGUAGE 
  AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER 
  VALUE-- 
  --NLS_TIMESTAMP_FORMAT 
  DD-MON-YY HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM 
  TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM 
  TZH:TNLS_DUAL_CURRENCY $NLS_COMPNLS_NCHAR_CHARACTERSET 
  UTF8NLS_RDBMS_VERSION 8.1.5.0.018 rows selected.A 
  virtual homebrew (British Pale Ale) to anybody who can help!
   
   
  Thanks!
   
  - Jerry

FW: Upgrade Oracle8.1.6 to 8.1.7

2001-02-06 Thread Feng, Jun


It should be database upgrade from Oracle8.1.6 to Oracle8.1.7.

Sorry,

Jun

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


> Hi
> 
> We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6.
> Have anybody done this work without database downtime? What was your
> downtime window for upgrade? Anybody have any suggestions about the
> upgrade without downtime?
> 
> Thanks,
> 
> Jun
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feng, Jun
  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: Feng, Jun
  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 to use Export Transportable Tablespaces

2001-02-06 Thread Jim Conboy


There are straightforward examples in the 8.1.7 documentation.  I don't know if that 
feature is available in 8.1.6.  But regardless, you should investigate WHY the 
fromuser/touser didn't achieve the desired results or I fear you'll be disappointed 
again.

Jim

>>> [EMAIL PROTECTED] 02/06/01 12:22PM >>>

Does anyone have an example of how to use transportable tablespaces with
export/import.

I want export a user (8.1.6 database) source and import fromuser
touser(8.1.6 database) target.

I tried to import fromuser/ touser, but many contraints were not created and
lost some data
so I was told to try transportable tables. Can't find any good examples on
how to use this new
feature.

Can someone please help me.

Thanks
Larry





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Larry Taylor
  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: Jim Conboy
  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: 175 Terabyte Objectivity Database