Database Monitoring tool

[prem]

Dear All,

We are in the process of making a DB monitoring tool, can anyboyd suggest what all things can be monitored. I know that OEM can be used, but then this cannot be distributed to the client.

Regards
Prem

Question about oracle whitepaper casestudy

[chao_ping]

hi, list friends:
I read the parper on oracle otn network:
http://otn.oracle.com/products/oracle9i/pdf/email_server_rac_deployment.pdf
And i have some question on that paper:
1.Since all node have 32GB (Page 5)RAM,and it is RAC, It does not need other 
memory for failover from other nodes, why does it configure onlye 9GB(Page 18) data 
buffer?

2.From statspack report(page 19),   the original server have 186 Transactions 
per second, and later the three nodes have also totol number of 171 Transactions per 
second.So, the pressure on the servers are less than before.So, physical io should be 
less than before,and with the  RAC cache Fusion, there should be even less physical IO 
.But from statspack report, in fact,there is more physical io than before? And oracle 
did not give out the statistics about the Unix CPU load, response time change etc.
 
3.Page 9, since it has 3 nodes, how can they use the cluster_interconnect 
parameter? If using two NIC card both node for internode communication, how did they 
implement it? 


Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Trace

[Anubha Jalsingh]

Hi 

We are running Baan erp application.  Baan opens multilple (upto 4-5) oracle sessions 
for a single user session.  These Oracle sessions have same unix process id but 
different SID and SERIAL#.  In order to diagnose an application performance problem, I 
set 10046 trace in all
sessions of a user.  This generated a single trace file as all these session had same 
process id.
This trace file seems to have all the SQL statements submitted by user.  Now if I run 
tkprof on the trace file , would I get a valid Output ?  The trace file contains 
CURSOR #, which doesn't look unique across the sessions.  

Thanks
Manmohan


__
Outgrown your current e-mail service? Get 25MB Storage, POP3 Access,
Advanced Spam protection with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anubha Jalsingh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Fwd: Re: Reporting - Casting about for ideas

[Jared Still]

Thanks, David.

What I'm looking for is actually a solution to build the  infrastructrue
for this.  And like sqlplus, Oracle Reports can't be used for reporting
on SAP systems.

Thanks for the idea though.  I didn't know about the report caching, and
they may come in handy on another project.

Jared

On Thursday 31 October 2002 16:28, [EMAIL PROTECTED]

wrote:
> We don't use the Oracle Reports Server, but I seem to remember it offers
> report caching.  I did a quick search on Metalink and found this:
>
> Note:118223.1
> TOLERANCE PARAMETER
>
> 3. Creating a backup using the Reports Server  One of the parameters of the
> Reports Server, is the Tolerance parameter. This parameter specifies a
> certain period in which a report which is ran again will use the cached
> output iso actually running the report again.  Just add the tolerance
> parameter to the run report command, run the report to file, run the report
> again, but now to the printer. When you run the report to the printer, the
> cached output will be used.  So if the print fails, you still have the
> backup of the report printed to a file. And if the tolerance period has not
> been expired, you even have an extra copy in the cache and can issue the
> print command again.
>
> 4. Example  In this example we will first print a report to file and then
> to the printer. To do this the Reports Command Line Interface is used, but
> the same can be done from the other run options (see chapter 2).
> Step 1, print the report to file:   RWCLI60  
> SERVER=   DESTYPE=file DESNAME=
> TOLERANCE=<#min>   eg.   RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i
> DESTYPE=file   DESNAME=emp TOLERANCE=5
> Step 2, print the report to the printer using the cached output
> from step 1:   RWCLI60   SERVER=
> DESTYPE=printer DESNAME=   TOLERANCE=<#min>   eg.
> RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i   DESTYPE=printer
> DESNAME=las4d TOLERANCE=5
> Make sure to specify the tolerance parameter in both calls, otherwise the
> cached output will not be used. In the example a tolerance of 5 minutes is
> specified, make sure to activate step 2 within 5 minutes of step one,
> otherwise the cached output will not be used.
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > Sent: Thursday, October 31, 2002 3:49 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Reporting - Casting about for ideas
> >
> >
> > Dear List,
> >
> > First, a little background.  A coworker and I have been charged with
> > developing and implementing a 'short term' 'Reporting Solution'.
> >
> > Glossary:
> >
> > short term:  low cast, fast to implement, throw it away late next year
> >
> > Reporting Solution:  Some method to make it easy for users to
> > see oft run reports without re-running them on the production SAP
> > ( and other apps also ) systems.
> >
> > The goal of the 'Reporting Solution' is perceived performance.
> > Only 1 or 2 of these reports have any detrimental performance
> > impact on the servers.  The goal is to allow users to view current
> > and historic reports ( up to 90 days ) without being required to
> > wait on reports to run on the application/database servers.
> >
> > This is partly political, partly user friendly.
> >
> > The political part is that we want to do *something* for users so
> > that it looks like we're taking their requirements to heart, even
> > though we don't have the resources to do much right now.
> >
> > The user friendly part is that we want to do *something* for users so
> > that we can make their jobs a little easier, even  though we don't
> > have the resources to do much right now.
> >
> > One idea we have is to have an ABAPer ( SAP programmer ) setup
> > the most requested reports to run in batch mode with a specified range
> > of dates and whatever parameters are needed.
> >
> > This would be done periodically, the report output put on a network
> > filer or database or something accessible via browser ( no shared
> > drive type solution, access is to iffy ), and a web page that
> > would allow
> > simple navigation to reports by Category/Date.
> >
> > Click on the report, view your data.
> >
> > One thing that this is *not*, is a data warehouse and/or data marts.
> >
> > This is to be a low cost solution.  Some software OK, a server is Ok
> > if necessary.  The key is fairly easy and quick implementation.
> >
> > I'm open to any and all ideas you may have for this, experiences doing
> > similar projects, etc.  If it uses Oracle software, that's
> > cool, if not,
> > that's
> > cool too.  Oracle is involved in any solution: at the very
> > least, that's
> > where
> > all our source data is stored.
> >
> > Thanks for reading this long winded message.
> >
> > Jared
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcit

Fwd: Re: Reporting - Casting about for ideas

[Jared Still]

On Thursday 31 October 2002 14:45, Fink, Dan wrote:
> Jared,
>   To state the obvious...'Throw away solutions some how never get
> thrown away'.

Yeah, well, I had thought of this.  I'm stuck with this strategy however.

>   Okay, now on to the real task at hand. A couple of ideas
>   Dump the reports out to html format (sql*plus can do this) and the
> users can hit an url for the history. Using a little code to insure that
> the front page shows the current report, with a secondary page with links
> to other pages/reports.
>   Dump the compiled data to flat files on the network and let another
> app (access/excel) get the data, format, graph, display it, etc.
>   Oh, (in deference), write a series of perl scripts...

Sqlplus won't work.  This is SAP.  If you're not familiar with SAP, sqlplus
is not an adequate reporting tool.  Though all SAP data is stored in tables
in the database, there are some that are stored as either 'CLUSTER' or
'POOL' tables, SAP terminology, not Oracle's.  The data is not readable
from sqlplus.

Whatever the solution, I want to avoid coding an infrastructure. I'm looking
for a solution that is fairly simple to build.  It may or may not get thrown
out later, but there will eventually be a DW to supplant it.

Thanks,

Jared

> Dan Fink
>
> -Original Message-
> Sent: Thursday, October 31, 2002 2:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear List,
>
> First, a little background.  A coworker and I have been charged with
> developing and implementing a 'short term' 'Reporting Solution'.
>
> Glossary:
>
> short term:  low cast, fast to implement, throw it away late next year
>
> Reporting Solution:  Some method to make it easy for users to
> see oft run reports without re-running them on the production SAP
> ( and other apps also ) systems.
>
> The goal of the 'Reporting Solution' is perceived performance.
> Only 1 or 2 of these reports have any detrimental performance
> impact on the servers.  The goal is to allow users to view current
> and historic reports ( up to 90 days ) without being required to
> wait on reports to run on the application/database servers.
>
> This is partly political, partly user friendly.
>
> The political part is that we want to do *something* for users so
> that it looks like we're taking their requirements to heart, even
> though we don't have the resources to do much right now.
>
> The user friendly part is that we want to do *something* for users so
> that we can make their jobs a little easier, even  though we don't
> have the resources to do much right now.
>
> One idea we have is to have an ABAPer ( SAP programmer ) setup
> the most requested reports to run in batch mode with a specified range
> of dates and whatever parameters are needed.
>
> This would be done periodically, the report output put on a network
> filer or database or something accessible via browser ( no shared
> drive type solution, access is to iffy ), and a web page that would allow
> simple navigation to reports by Category/Date.
>
> Click on the report, view your data.
>
> One thing that this is *not*, is a data warehouse and/or data marts.
>
> This is to be a low cost solution.  Some software OK, a server is Ok
> if necessary.  The key is fairly easy and quick implementation.
>
> I'm open to any and all ideas you may have for this, experiences doing
> similar projects, etc.  If it uses Oracle software, that's cool, if not,
> that's
> cool too.  Oracle is involved in any solution: at the very least, that's
> where
> all our source data is stored.
>
> Thanks for reading this long winded message.
>
> Jared

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbms_lock.sleep irregularities

[Jared Still]

OK, so my code is too complex. :)

Do you know why dbms_lock.sleep doesn' twork?

Jared

On Thursday 31 October 2002 15:04, Khedr, Waleed wrote:
> Hi Jared,
>
> You do not need the "to_date" function, just:
>
> select (trunc(sysdate)+(10/24) - sysdate ) * ( 24*60*60) into seconds from
> dual;
>
> Regards,
>
> Waleed
>
> -Original Message-
> Sent: Thursday, October 31, 2002 5:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear List,
>
> I wrote the following bit of code yesterday to cause a
> process to kick off at a particular time.  This was not
> doable via DBMS_JOB, as the code that follows this bit
>  is a sqlplus script from an app vendor.
>
> When I ran this last night, I expected it to sleep til 20:00.
>
> Instead, it slept for about 45 minutes.
>
> Here's an example from this morning that should have slept
> until 10:00 AM, but instead only slept 25 minutes.
>
> Any ideas?  Did I code something wrong here?
>
> This is 8.1.6.3 on Windows NT 4 SP 6.
>
> Just change the '10' below to some hour > sysdate
>
> Thanks,
>
> Jared
>
> ===
>
>   declare
>  seconds integer;
>   begin
>  -- seconds from now til 10:00 AM
>  select (to_date(trunc(sysdate)+(10/24)) - sysdate ) * ( 24*60*60)
> into seconds
>  from dual;
>  dbms_output.put_line(seconds);
>  dbms_lock.sleep(seconds);
>  end;
>
> 09:10:15 RSYS13 - agile@orcl SQL> /
> 2681
>
> PL/SQL procedure successfully completed.
>
> 09:36:05 RSYS13 - agile@orcl SQL> select 2861/3600 from dual;
>
>  2861/3600
> --
> .79472
>
> 1 row selected.
>
> 14:13:02 RSYS13 - agile@orcl SQL>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

[Sinardy Xing]

Hi all,

Jared you are right...

kill -9  successful but ps -ef |grep ora_ said the processes are still there (only 
LGWR and CKPT, the rest are die)
when I try to startup again lk refuse to mount my database
I guest Oracle not finished the housekeeping job.

when I try to "sync" the session hung (init will sync automatically therefore it hung 
too)
I have to POWER OFF and POWER ON my SUN BOX to release the mount point
My sun clustering fail to fail over because of this

there is jargon in unix call zombie process (what is this ?) 
What is tampered process, and when it happen ?

Oracle Support said if shutdown abort can't kill the process is your OS problem not 
Oracle.
Why Oracle PMON and SMON never do anything about this ?


Sinardy




-Original Message-
Sent: 01 November 2002 06:40
To: Multiple recipients of list ORACLE-L
UNKILLABLE


I'm not new to Solaris or unix in general.

Rebooting to get rid of an unkillable process is not unheard of in unix 
land.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/31/2002 02:09 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES 
UNKILLABLE



Reboot, Yeah-Right.  This is Solaris, not Windoze.

I would try having the root user do the "kill -9" after doing a "truss" on
the process it see what it's looking at.  Doing a "ipcrm" on the shared
memory segment and semaphores may also help.

Brian



  
  Jared.Still@radis   
  ys.com   To:   Multiple 
recipients of list ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc:
  [EMAIL PROTECTED] Subject:  RE: Unkillable 
Background process "SHUTDOWN ABORT LEAVES UNKILLABLE 
  
  
  10/31/02 12:44 PM   
  Please respond to   
  ORACLE-L   
  
  




Reboot and open a TAR.

Jared





"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 12:28 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT
LEAVES UNKILLABLE
PROCESSES"


Hi,

I am using solaris 8


Sinardy

-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"


Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9
cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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-1078 During a 9iR2 Install

[sstefick]

I tried it and I got the following error:

ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS

Thanks,
-Scott

>= Original Message From [EMAIL PROTECTED] =
>try to startup the database in nomount and then do it.
>
>
>
>-Original Message-
>Sent: Thursday, October 31, 2002 4:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I've never been able to get into the DB yet to open it.
>
>-Scott
>
>
>At 03:48 PM 10/31/02 -0800, you wrote:
>>Was your database in mount,nomount,open or IDLE state?
>>
>>
>>
>>
>>-Original Message-
>>Sent: Thursday, October 31, 2002 3:30 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>I'm really new to 9i and I vaguely heard about the spfile, so I looked in
>>the Oracle9i New Features book (thanks RF!) to read up on the spfile.  I
>>noticed that it said that if an spfile was not created, it would default to
>>look for the initSID.ora file.  Well, I opened a SQLPLUS session and tried
>>to use the syntax in the book to create an spfile anyway and I got the
>>following message:
>>
>>--snip---
>>SQL> CREATE
>SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
>> FROM
>>PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';
>>
>>CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
>>*
>>ERROR at line 1:
>>ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
>>ORA-27037: unable to obtain file status
>>HP-UX Error:  14 Bad address
>>Additional information: 1
>>
>>SQL>
>>--snip---
>>
>>I think my whole problem is that the DBCA is supposed to create one for you
>>and it never got to that point.  I got  the ORA-01078 error before it was
>>ever created.
>>
>>Thanks so much,
>>-Scott
>>
>>
>>
>>At 07:03 AM 10/31/02 -0800, you wrote:
>> >You should recreate your spfile. Oracle9i starts from an spfile, if it
>> >exists
>> >and some installations do put a ghost one in $ORACLE_HOME/dbs.
>> >
>> > > -Original Message-
>> > > From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
>> > > Sent: Wednesday, October 30, 2002 5:04 PM
>> > > To: Multiple recipients of list ORACLE-L
>> > > Subject: ORA-1078 During a 9iR2 Install
>> > >
>> > >
>> > > Hi Gurus,
>> > >
>> > > Hardware: HP rp5470
>> > > OS: HP-UX 11i (11.11)
>> > > Oracle Version: Enterprise Edition 9.2.0.1.0
>> > >
>> > > I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
>> > > trying to create and start the database, I'm getting an
>> > > "ORA-1078: failure
>> > > in processing system parameters" error.  Then when I tried
>> > > startup nomount
>> > > I got that error again along with "LRM-00109: could not open
>> > > parameter file
>> > > '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I
>> > > opened up a TAR with Oracle and so far they just made sure that my
>> > > ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
>> > > correctly.  they
>> > > said they would get back to me on this one.  Has anyone here
>> > > encountered
>> > > anything like this during a 9iR2 install, or does anyone have any
>> > > suggestions that I could try?
>> > >
>> > > Thanks in advance!
>> > > -Scott
>> > >
>> > > **
>> > > Scott Stefick
>> > > UNIX Systems Administrator
>> > > Oracle Certified Professional DBA
>> > > Wm. Rainey Harper College
>> > > 847.925.6130
>> > > **
>> > > --
>> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > > --
>> > > Author: Scott Stefick
>> > >   INET: [EMAIL PROTECTED]
>> > >
>> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> > > San Diego, California-- Mailing list and web hosting services
>> > > -
>> > > 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: Gogala, Mladen
>> >   INET: [EMAIL PROTECTED]
>> >
>> >Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> >San Diego, California-- Mailing list and web hosting services
>> >-
>> >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).
>>
>>
>>**
>>S

RE: Convert DM TSP to LM TSP w/ lots of data

[Govind . Arumugam]

Tom,

Thanks for the script authored by Cary Millsap.  I just attended Cary
Millsap's hotsos performance tuning clinic in Dallas, Texas.  He is a
great guy!  You can get a lot of technical info on their web-site at
www.hotsos.com

Regards,
Govind

-Original Message-
Sent: Wednesday, October 30, 2002 11:04 PM
To: Multiple recipients of list ORACLE-L


Govind,

It occured to me that I suggested you map the location of extents within
the
data files which make up the DMT you're moving objects from but didn't
tell
you how.  If you have cool GUI tool like OEM Tablespace Manager to show
you
precisely where each extent is located in a data file, cool.  If not,
this
script I lifted from Metalink will work.

=
Abstract:
=
This script provides a block-level mapping of the tables inside one or
more tablespaces.  You will be prompted for the name of the tablespace.
=
Requirements:
=
SELECT on DBA_EXTENTS and DBA_FRE_SPACE

Version Testing:

This script was tested on Oracle Versions 7.3.4.X - 8.1.6.XX.
===
Script:
===
--- cut -- cut -- cut
--
SET ECHO off
REM

--
REM REQUIREMENTS:
REMSELECT on DBA_EXTENTS & DBA_FREE_SPACE,
REM

--
REM AUTHOR:
REMCary Millsap
REM

--
REM PURPOSE:
REMThe purpose of this script is to provide a block-level mapping
oftables

REMinside one or more tablespaces.

REM

---

REM EXPLANATION:

REMProvides a block-level mapping of tables inside of a given
tablespace.

REM

---
REM
REM

---
REM DISCLAIMER:
REMThis script is provided for educational purposes only. It is NOT
REMsupported by Oracle World Wide Technical Support.
REMThe script has been tested and appears to work as intended.
REMYou should always run new scripts on a test instance initially.
REM

--
REM Main text of script follows:
def ts  = &&1
col tablespace form a15 head 'Tablespace' just c trunc
col file_idform   990 head 'File' just c
col block_id   form 9,999,990 head 'Block Id'   just c
col blocks form   999,990 head 'Size'   just c
col segmentform   a38 head 'Segment'just c trunc
break - on tablespace skip page -
 on file_id skip 1
select
  tablespace_name  tablespace,
  file_id,
  1 block_id,
  1blocks,
  '' segment
from
  dba_extents
where
  tablespace_name = upper('&ts')
union
select
  tablespace_name  tablespace,
  file_id,
  1block_id,
  1  blocks,
  '' segment
from
  dba_free_space
where
  tablespace_name = upper('&ts')
union
select
  tablespace_name  tablespace,
  file_id,
  block_id,
  blocks,
  owner||'.'||segment_name  segment
from
  dba_extents
where
  tablespace_name = upper('&ts')
union
select
  tablespace_name  tablespace,
  file_id,
  block_id,
  blocks,
  ''
from
  dba_free_space
where
  tablespace_name = upper('&ts')
order by
  1,2,3
8
/
undef ts
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 7:48 PM


Tom and Dennis,

Thanks a lot for your input on this. I liked the phased approach to move
objects to LMT.

Govind

-Original Message-
Sent: Tuesday, October 29, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


If you have to convert in place, do it.  But let's examine things a bit
more
closely first.  You say you have tablespaces sized from 5 GB to 60 GB
and
you don't have much freespace as a buffer.  Do you have 60 GB buffer?
If
so, you're home free.  Create a new LMT, move the objects from the DMT
to
the new LMT, drop the old tablespace including contents and delete the
data
files.

You don't have 60 GB free space?  Create a map of where each object
resides
in the data files which make up the DMT.  Create a new LMT tablespace
with
as many files as you can fit in your free space..  Move the object from
DMT
to LMT that'll allow you to shrink the data files in the DMT as much as
possible.  Now you have more free space.  Continue adding data files to
the
LMT as needed as you move each object and shrink the DMT's data files.
When
the DMT is empty, drop it including contents and delete the data files.
That's one DMT converted.  Now on to the next ones.

If you're just embarking on conversion to LMT and permanent rollback
segments, convert your rollback tablespaces first.  You'll get a
per

RE: Multiple Oracle Versions on Same Host (Workgroup 8.0.6 & Ente

[DENNIS WILLIAMS]

David
   Technically it shouldn't be a problem. You'll use different ORACLE_HOMEs
of course. Have you considered the licensing issues? I agree with Stephen
that you should stick to the vendor's recommendation, but press them to move
their certification forward, for Pete's sake! Are they going to certify
8.1.7 before Oracle drops it?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, October 31, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Enterprise 8.1.7 on AIX



There is a desire to consolidate some Unix servers. A couple of the servers 
are using Oracle 8.0.6 Standard (formerly Workgroup server) and the intended

target servers already have 8.1.7 Enterprise. The source/target servers are 
using AIX 4.3. My understanding is that the application on 8.0.6 is not 
certified/supported on 8.1.7 by its vendor, yet.

Does anyone know if there are any problems/issues with doing this?
Any advice on the procedures would be appreciated (in a non-monetary way - 
just like most corporate rewards programs).

Thanks,
David
[EMAIL PROTECTED]





_
Unlimited Internet access -- and 2 months free!  Try MSN. 
http://resourcecenter.msn.com/access/plans/2monthsfree.asp

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Raid 5+

[listmail]

On Thu, 31 Oct 2002 00:33:43 -0800, John Hallas wrote:

>We are certainly going to be performing extensive testing to ensure
>performance of our applications under Raid5+ is acceptable.
> 
>That means it is as good if not better than that experienced under Raid1

I once threw my redo logs onto a RAID 5 array just for grins (while
doing some preproduction testing before going live with a new
database). The sysadmin and I saw a huge increase in disk activity,
but that increase didn't translate into a negative impact on
application performance. Who cares whether the poor disks are
thrashing, so long as they are keeping up, right? Even so, we couldn't
bring ourselves to leave the redo on RAID 5, so we moved it into RAID
0+1 before going live.

My point here is that you just might find performance to be
acceptable.

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * mailto:jonathan@;gennick.com * 906.387.1698
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Raw / VB / ADODB

[Rachel Carmichael]

close :)

Lawng GUY-lend

Please to note, I live on "the island" (is there any other one?) but I
pray I don't sound like the above!


--- [EMAIL PROTECTED] wrote:
> ...the correct pronunciation is "lan GUY-lun"...
> 
> > Ya, that's it!
> > (Peter still wanted to argue with me.  Is Long Island the
> > "show-me" city?? But when he tried it, it worked)
> > 
> > Thanks a bunch!
> > Barb
> > 
> > 
> > > --
> > > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> > > Reply To: [EMAIL PROTECTED]
> > > Sent: Thursday, October 31, 2002 12:13 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Raw / VB / ADODB
> > > 
> > > Barb,
> > > 
> > > Ask them to wrap RAWTOHEX() around the RAW column, which
> > > will convert the resulting datatype to VARCHAR2?
> > > 
> > > Hope this helps...
> > > 
> > > -Tim
> > > 
> > > > Solaris 8
> > > > Oracle 8.1.7.3
> > > > 
> > > > We have a field level_id defined as raw(5) in a table
> > > > called objects.  I can pull data from this table from
> > > > sqlplus as follows:
> > > > select name, obj_id, level_id from objects where
> > > > level_id='010101' and name = '1X3HRJOHNSON'
> > > > 
> > > > NAMEOBJ_ID LEVEL_ID
> > > > --- -- --
> > > > 1X3HRJOHNSON500583 010101
> > > > 
> > > > The developer is not able to pull identifiable data
> > > > from the raw column level_id using VB.  His notes are
> > > > shown below.  We searched metalink and google, and
> > > > cannot find an answer. 
> > > > Any help?  Thanks!!
> > > > 
> > > > Barb
> > > > 
> > > > OK,
> > > > 
> > > > I am using ADODB microsoft data objects version 2.7
> > > > 
> > > > I am using Oracle odbc driver 8.01
> > > > I am trying to extract a raw field that is described
> > > > as   level_id raw(5) 
> > > > Every field extracts correctly except level_id
> > > > 
> > > > 
> > > > Here is an example code excerpt
> > > > 
> > > > Set oRS = CreateObject("ADODB.Recordset")
> > > > sSQL = "Select distinct level_id from objects"
> > > > oRS.Source = sSQL
> > > > oRS.ActiveConnection = conn
> > > > oRS.Open
> > > > Do Until oRS.EOF
> > > > For i = 0 To oRS.Fields.Count - 1
> > > > If oRS.Fields(i).Type = 204 Then' RAW
> > > > field type
> > > > strTemp = oRS.Fields(i).Value
> > > > end if
> > > > next
> > > > oRS.movenext
> > > > loop
> > > > 
> > > > In SQLPLUS when we ran a query on a record we got
> > > > level _id 010101 , the above vb program returned 
> > > > 971. SQLPLUS level_id  010A03, vb returned
> > > > 633... 
> > > > 
> > > > What is ODBC returning?  is the value truncated
> > > > somehow?
> > > > does it need to be converted ?
> > > > I think we are getting partial data and not the
> > > > full length of the RAW field 
> > > > Is RAW(5) equivalent to 10 bytes ?
> > > >  SQLPLUS shows 10 positions on output 
> > > > 
> > > > HELP !!!
> > > > 
> > > > -- 
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com -- 
> > > > Author: Baker, Barbara
> > > >   INET: [EMAIL PROTECTED]
> > > > 
> > > > Fat City Network Services-- 858-538-5051
> > > > http://www.fatcity.com San Diego, California--
> > > > Mailing list and web hosting services
> > > >
> > > >
> > --
> > > > --- 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
> > > http://www.fatcity.com San Diego, California--
> > > Mailing list and web hosting services
> > --
> > > --- 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: Baker, Barbara
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com San Diego, California--
> > Mailing list and web hosting services
> > --
> > --- To REMOVE yourself from this mailing list,
> > send an E-Mail message to:

RE: Re Raid 5+

[MacGregor, Ian A.]

I 
cannot fathom Raid 5 being faster than Raid 1 tor writes.  The real 
question is, is it fast enough for your users.  We happen to have a 650 
terabyte database here.  Even using Raid 5 disk storage would be 
prohibitedly expensive.  So we use a home-built hierarchal storage system 
and store much of the data on Redwood tape drives.  Users know that  
requesting data from the Redwood drives will take  some time.   
But they were told to expect that.  (The database is Objectivity not 
Oracle, and I have nothing to do with it).  The online data as 
opposed to the near-line data is stored in Raid 5 arrays. 

 
What I 
don't know is what percentage of Oracle databases can  run fine  on Raid 5 
vs. Raid 1.  It would not surprise me if the answer was well over 
50%
 
Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  -Original Message-From: John Hallas 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 
  2002 12:34 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re Raid 5+
  
  Jared,
   
  We are certainly going to be 
  performing extensive testing to ensure performance of our applications under 
  Raid5+ is acceptable.
   
  That means it is as good if not 
  better than that experienced under Raid1
   
  As I see it Oracle gain no benefit for stating that Raid5 should be used if 
  they did not believe that to be the case. If there was any doubt it would be 
  easier fro them to leave things as they were
   
   
  John 
  

RE: ORA-1078 During a 9iR2 Install

[Wong, Bing]

try to startup the database in nomount and then do it.



-Original Message-
Sent: Thursday, October 31, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L


I've never been able to get into the DB yet to open it.

-Scott


At 03:48 PM 10/31/02 -0800, you wrote:
>Was your database in mount,nomount,open or IDLE state?
>
>
>
>
>-Original Message-
>Sent: Thursday, October 31, 2002 3:30 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I'm really new to 9i and I vaguely heard about the spfile, so I looked in
>the Oracle9i New Features book (thanks RF!) to read up on the spfile.  I
>noticed that it said that if an spfile was not created, it would default to
>look for the initSID.ora file.  Well, I opened a SQLPLUS session and tried
>to use the syntax in the book to create an spfile anyway and I got the
>following message:
>
>--snip---
>SQL> CREATE
SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
> FROM
>PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';
>
>CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
>*
>ERROR at line 1:
>ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
>ORA-27037: unable to obtain file status
>HP-UX Error:  14 Bad address
>Additional information: 1
>
>SQL>
>--snip---
>
>I think my whole problem is that the DBCA is supposed to create one for you
>and it never got to that point.  I got  the ORA-01078 error before it was
>ever created.
>
>Thanks so much,
>-Scott
>
>
>
>At 07:03 AM 10/31/02 -0800, you wrote:
> >You should recreate your spfile. Oracle9i starts from an spfile, if it
> >exists
> >and some installations do put a ghost one in $ORACLE_HOME/dbs.
> >
> > > -Original Message-
> > > From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> > > Sent: Wednesday, October 30, 2002 5:04 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: ORA-1078 During a 9iR2 Install
> > >
> > >
> > > Hi Gurus,
> > >
> > > Hardware: HP rp5470
> > > OS: HP-UX 11i (11.11)
> > > Oracle Version: Enterprise Edition 9.2.0.1.0
> > >
> > > I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
> > > trying to create and start the database, I'm getting an
> > > "ORA-1078: failure
> > > in processing system parameters" error.  Then when I tried
> > > startup nomount
> > > I got that error again along with "LRM-00109: could not open
> > > parameter file
> > > '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I
> > > opened up a TAR with Oracle and so far they just made sure that my
> > > ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
> > > correctly.  they
> > > said they would get back to me on this one.  Has anyone here
> > > encountered
> > > anything like this during a 9iR2 install, or does anyone have any
> > > suggestions that I could try?
> > >
> > > Thanks in advance!
> > > -Scott
> > >
> > > **
> > > Scott Stefick
> > > UNIX Systems Administrator
> > > Oracle Certified Professional DBA
> > > Wm. Rainey Harper College
> > > 847.925.6130
> > > **
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Scott Stefick
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > 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: Gogala, Mladen
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >San Diego, California-- Mailing list and web hosting services
> >-
> >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).
>
>
>**
>Scott Stefick
>UNIX Systems Administrator
>Oracle Certified Professional DBA
>Wm. Rainey Harper College
>847.925.6130
>**
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Scott Stefick
>   INET: [EMAIL PROTECTED]
>
>Fat City Networ

RE: Reporting - Casting about for ideas

[David . Schmoldt]

We don't use the Oracle Reports Server, but I seem to remember it offers
report caching.  I did a quick search on Metalink and found this:

Note:118223.1 
TOLERANCE PARAMETER 

3. Creating a backup using the Reports Server  One of the parameters of the
Reports Server, is the Tolerance parameter. This parameter specifies a
certain period in which a report which is ran again will use the cached
output iso actually running the report again.  Just add the tolerance
parameter to the run report command, run the report to file, run the report
again, but now to the printer. When you run the report to the printer, the
cached output will be used.  So if the print fails, you still have the
backup of the report printed to a file. And if the tolerance period has not
been expired, you even have an extra copy in the cache and can issue the
print command again.

4. Example  In this example we will first print a report to file and then to
the printer. To do this the Reports Command Line Interface is used, but the
same can be done from the other run options (see chapter 2).  
Step 1, print the report to file:   RWCLI60  
SERVER=   DESTYPE=file DESNAME=
TOLERANCE=<#min>   eg.   RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i
DESTYPE=file   DESNAME=emp TOLERANCE=5  
Step 2, print the report to the printer using the cached output from
step 1:   RWCLI60   SERVER=
DESTYPE=printer DESNAME=   TOLERANCE=<#min>   eg.
RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i   DESTYPE=printer
DESNAME=las4d TOLERANCE=5  
Make sure to specify the tolerance parameter in both calls, otherwise the
cached output will not be used. In the example a tolerance of 5 minutes is
specified, make sure to activate step 2 within 5 minutes of step one,
otherwise the cached output will not be used.  

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> Sent: Thursday, October 31, 2002 3:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Reporting - Casting about for ideas
> 
> 
> Dear List,
> 
> First, a little background.  A coworker and I have been charged with
> developing and implementing a 'short term' 'Reporting Solution'.
> 
> Glossary:
> 
> short term:  low cast, fast to implement, throw it away late next year
> 
> Reporting Solution:  Some method to make it easy for users to
> see oft run reports without re-running them on the production SAP
> ( and other apps also ) systems.
> 
> The goal of the 'Reporting Solution' is perceived performance. 
> Only 1 or 2 of these reports have any detrimental performance
> impact on the servers.  The goal is to allow users to view current
> and historic reports ( up to 90 days ) without being required to
> wait on reports to run on the application/database servers.
> 
> This is partly political, partly user friendly. 
> 
> The political part is that we want to do *something* for users so
> that it looks like we're taking their requirements to heart, even 
> though we don't have the resources to do much right now.
> 
> The user friendly part is that we want to do *something* for users so
> that we can make their jobs a little easier, even  though we don't 
> have the resources to do much right now.
> 
> One idea we have is to have an ABAPer ( SAP programmer ) setup
> the most requested reports to run in batch mode with a specified range
> of dates and whatever parameters are needed. 
> 
> This would be done periodically, the report output put on a network
> filer or database or something accessible via browser ( no shared
> drive type solution, access is to iffy ), and a web page that 
> would allow
> simple navigation to reports by Category/Date.
> 
> Click on the report, view your data.
> 
> One thing that this is *not*, is a data warehouse and/or data marts.
> 
> This is to be a low cost solution.  Some software OK, a server is Ok
> if necessary.  The key is fairly easy and quick implementation.
> 
> I'm open to any and all ideas you may have for this, experiences doing
> similar projects, etc.  If it uses Oracle software, that's 
> cool, if not, 
> that's
> cool too.  Oracle is involved in any solution: at the very 
> least, that's 
> where
> all our source data is stored.
> 
> Thanks for reading this long winded message.
> 
> Jared
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 ORA

RE: ORA-1078 During a 9iR2 Install

[Scott Stefick]

I've never been able to get into the DB yet to open it.

-Scott


At 03:48 PM 10/31/02 -0800, you wrote:

Was your database in mount,nomount,open or IDLE state?




-Original Message-
Sent: Thursday, October 31, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L


I'm really new to 9i and I vaguely heard about the spfile, so I looked in
the Oracle9i New Features book (thanks RF!) to read up on the spfile.  I
noticed that it said that if an spfile was not created, it would default to
look for the initSID.ora file.  Well, I opened a SQLPLUS session and tried
to use the syntax in the book to create an spfile anyway and I got the
following message:

--snip---
SQL> CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
FROM
PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';

CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
*
ERROR at line 1:
ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
ORA-27037: unable to obtain file status
HP-UX Error:  14 Bad address
Additional information: 1

SQL>
--snip---

I think my whole problem is that the DBCA is supposed to create one for you
and it never got to that point.  I got  the ORA-01078 error before it was
ever created.

Thanks so much,
-Scott



At 07:03 AM 10/31/02 -0800, you wrote:
>You should recreate your spfile. Oracle9i starts from an spfile, if it
>exists
>and some installations do put a ghost one in $ORACLE_HOME/dbs.
>
> > -Original Message-
> > From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> > Sent: Wednesday, October 30, 2002 5:04 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: ORA-1078 During a 9iR2 Install
> >
> >
> > Hi Gurus,
> >
> > Hardware: HP rp5470
> > OS: HP-UX 11i (11.11)
> > Oracle Version: Enterprise Edition 9.2.0.1.0
> >
> > I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
> > trying to create and start the database, I'm getting an
> > "ORA-1078: failure
> > in processing system parameters" error.  Then when I tried
> > startup nomount
> > I got that error again along with "LRM-00109: could not open
> > parameter file
> > '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I
> > opened up a TAR with Oracle and so far they just made sure that my
> > ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
> > correctly.  they
> > said they would get back to me on this one.  Has anyone here
> > encountered
> > anything like this during a 9iR2 install, or does anyone have any
> > suggestions that I could try?
> >
> > Thanks in advance!
> > -Scott
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > 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: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>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).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: UNSU

RE: ORA-1078 During a 9iR2 Install

[Wong, Bing]

Was your database in mount,nomount,open or IDLE state?




-Original Message-
Sent: Thursday, October 31, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L


I'm really new to 9i and I vaguely heard about the spfile, so I looked in 
the Oracle9i New Features book (thanks RF!) to read up on the spfile.  I 
noticed that it said that if an spfile was not created, it would default to 
look for the initSID.ora file.  Well, I opened a SQLPLUS session and tried 
to use the syntax in the book to create an spfile anyway and I got the 
following message:

--snip---
SQL> CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
FROM
PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';

CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
*
ERROR at line 1:
ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
ORA-27037: unable to obtain file status
HP-UX Error:  14 Bad address
Additional information: 1

SQL>
--snip---

I think my whole problem is that the DBCA is supposed to create one for you 
and it never got to that point.  I got  the ORA-01078 error before it was 
ever created.

Thanks so much,
-Scott



At 07:03 AM 10/31/02 -0800, you wrote:
>You should recreate your spfile. Oracle9i starts from an spfile, if it
>exists
>and some installations do put a ghost one in $ORACLE_HOME/dbs.
>
> > -Original Message-
> > From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> > Sent: Wednesday, October 30, 2002 5:04 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: ORA-1078 During a 9iR2 Install
> >
> >
> > Hi Gurus,
> >
> > Hardware: HP rp5470
> > OS: HP-UX 11i (11.11)
> > Oracle Version: Enterprise Edition 9.2.0.1.0
> >
> > I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
> > trying to create and start the database, I'm getting an
> > "ORA-1078: failure
> > in processing system parameters" error.  Then when I tried
> > startup nomount
> > I got that error again along with "LRM-00109: could not open
> > parameter file
> > '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I
> > opened up a TAR with Oracle and so far they just made sure that my
> > ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
> > correctly.  they
> > said they would get back to me on this one.  Has anyone here
> > encountered
> > anything like this during a 9iR2 install, or does anyone have any
> > suggestions that I could try?
> >
> > Thanks in advance!
> > -Scott
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > 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: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>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).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Stefick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

RE: Jonathan Lewis seminar in Dallas, 19-21 November

[Cary Millsap]

I know, I know, … We’ll just
have to imagine his admonishing us for improper use of the letter “zed,”
and his further informing us that the criticism we’ve levied upon his zpelling
is of subjunctive form, and in such case should have read “…if only
‘optimizing’ *were*
spelled correctly…”  J

 

Even still, it’s a delight that we’ll
have him with us in a few weeks.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- 2003 Hotsos Symposium on
Oracle® System Performance, Feb 9–12 Dallas
- Jonathan Lewis'
Optimising Oracle, Nov 19–21 Dallas



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Tim
Gorman
Sent: Thursday, October 31, 2002
5:05 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Jonathan Lewis
seminar in Dallas, 19-21 November

 



...if only "optimizing" was spelled
correctly...  :-)







- Original Message - 





From: Cary
Millsap 





To: Multiple
recipients of list ORACLE-L 





Sent: Thursday, October
31, 2002 1:59 PM





Subject: Jonathan Lewis
seminar in Dallas, 19-21 November





 



   
Announcement

 

 
Optimising Oracle: Performance by Design


a 3-day seminar by Jonathan Lewis

 

 

Jonathan Lewis will conduct his "Optimising
Oracle" seminar in the

Dallas/Fort Worth area this November 19-21.
"Optimising Oracle" is a

three-day, intensive seminar aimed at DBAs, senior
developers, architects,

and designers.

 

Jonathan Lewis, author of "Practical Oracle 8i:
Building Efficient

Databases," is a UK-based consultant with more
than 17 years of experience

working with the Oracle database. His specialization
lies with

understanding and teaching how the functional
implications of various

database features can impact an application's design
and performance.

 

"Optimising Oracle" is one of the best
seminars I've ever taken.

Jonathan's superb audience-participation exercises
bring complicated

concepts beautifully to life. I encourage you not to
miss this rare

opportunity to see Jonathan teach in the US.

 

See http://www.jlcomp.demon.co.uk/seminar.html for a
detailed outline of

the course objectives.

 

  
Seminar Details

  
---

 

What  Optimising
Oracle: Performance by Design

Who   Jonathan
Lewis, author of "Practical Oracle 8i"

When  8am to 5pm each
day, November 19-21, 2002

Where Embassy Suites Hotel
in Grapevine, Texas

How much  USD $1,650.00

 

Seating is strictly limited to 30 people. Priority
will be assigned in the

order that payments are received.

 

For those traveling from outside DFW area, you will
want to fly into

either DFW International Airport (DFW) or Dallas
Love Field (DAL). The

seminar hotel is approximately 10 minutes by car
from DFW, and 30 minutes

from DAL. Specific directions will be provided as
part of confirmation of

your booking.

 

For more information, contact Alison Holt at
[EMAIL PROTECTED], or

+1.817.329.3155.

 

Please forward this to anyone you think may be
interested. Thank you.

 

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- 2003 Hotsos Symposium on
Oracle® System Performance, Feb 9–12 Dallas
- Jonathan Lewis'
Optimising Oracle, Nov 19–21 Dallas

 

RE: ORA-1078 During a 9iR2 Install

[Scott Stefick]

I'm really new to 9i and I vaguely heard about the spfile, so I looked in 
the Oracle9i New Features book (thanks RF!) to read up on the spfile.  I 
noticed that it said that if an spfile was not created, it would default to 
look for the initSID.ora file.  Well, I opened a SQLPLUS session and tried 
to use the syntax in the book to create an spfile anyway and I got the 
following message:

--snip---
SQL> CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
   FROM PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';

CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
*
ERROR at line 1:
ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
ORA-27037: unable to obtain file status
HP-UX Error:  14 Bad address
Additional information: 1

SQL>
--snip---

I think my whole problem is that the DBCA is supposed to create one for you 
and it never got to that point.  I got  the ORA-01078 error before it was 
ever created.

Thanks so much,
-Scott



At 07:03 AM 10/31/02 -0800, you wrote:
You should recreate your spfile. Oracle9i starts from an spfile, if it
exists
and some installations do put a ghost one in $ORACLE_HOME/dbs.

> -Original Message-
> From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> Sent: Wednesday, October 30, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-1078 During a 9iR2 Install
>
>
> Hi Gurus,
>
> Hardware: HP rp5470
> OS: HP-UX 11i (11.11)
> Oracle Version: Enterprise Edition 9.2.0.1.0
>
> I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
> trying to create and start the database, I'm getting an
> "ORA-1078: failure
> in processing system parameters" error.  Then when I tried
> startup nomount
> I got that error again along with "LRM-00109: could not open
> parameter file
> '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I
> opened up a TAR with Oracle and so far they just made sure that my
> ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
> correctly.  they
> said they would get back to me on this one.  Has anyone here
> encountered
> anything like this during a 9iR2 install, or does anyone have any
> suggestions that I could try?
>
> Thanks in advance!
> -Scott
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Stefick
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Jonathan Lewis seminar in Dallas, 19-21 November

[Tim Gorman]

...if only "optimizing" was spelled 
correctly...  :-)

  - Original Message - 
  From: 
  Cary 
  Millsap 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, October 31, 2002 1:59 
  PM
  Subject: Jonathan Lewis seminar in 
  Dallas, 19-21 November
  
  
      
  Announcement
   
    
  Optimising Oracle: Performance by Design
   
  a 3-day seminar by Jonathan Lewis
   
   
  Jonathan Lewis will conduct his 
  "Optimising Oracle" seminar in the
  Dallas/Fort Worth area 
  this November 19-21. "Optimising Oracle" is a
  three-day, intensive 
  seminar aimed at DBAs, senior developers, architects,
  and 
  designers.
   
  Jonathan Lewis, author of "Practical 
  Oracle 8i: Building Efficient
  Databases," is a UK-based 
  consultant with more than 17 years of experience
  working with the Oracle 
  database. His specialization lies with
  understanding and teaching 
  how the functional implications of various
  database features can 
  impact an application's design and performance.
   
  "Optimising Oracle" is one 
  of the best seminars I've ever taken.
  Jonathan's superb 
  audience-participation exercises bring complicated
  concepts beautifully to 
  life. I encourage you not to miss this rare
  opportunity to see 
  Jonathan teach in the 
  US.
   
  See 
  http://www.jlcomp.demon.co.uk/seminar.html for a detailed outline 
  of
  the course 
  objectives.
   
     
  Seminar Details
     
  ---
   
  What  
  Optimising Oracle: Performance by Design
  Who   
  Jonathan Lewis, author of "Practical 
  Oracle 8i"
  When  
  8am to 
  5pm each day, 
  November 19-21, 
  2002
  Where 
  Embassy Suites Hotel in Grapevine, Texas
  How much  USD 
  $1,650.00
   
  Seating is strictly 
  limited to 30 people. Priority will be assigned in the
  order that payments are 
  received.
   
  For those traveling from 
  outside DFW area, you will want to fly into
  either DFW International Airport (DFW) or Dallas Love 
  Field (DAL). The
  seminar hotel is 
  approximately 10 minutes by car from DFW, and 30 minutes
  from DAL. Specific 
  directions will be provided as part of confirmation of
  your 
  booking.
   
  For more information, 
  contact Alison Holt at 
  [EMAIL PROTECTED], or
  +1.817.329.3155.
   
  Please forward this to 
  anyone you think may be interested. Thank you.
   
  Cary 
  MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming 
  events:- Hotsos 
  Clinic, Dec 9–11 Honolulu- 2003 Hotsos Symposium on 
  Oracle® System Performance, Feb 9–12 Dallas- Jonathan Lewis' Optimising 
  Oracle, Nov 19–21 Dallas
   

RE: Database Design: unique PK across all tables

[MacGregor, Ian A.]

Sorry, I have never used it.  We do have one system which uses a uuid, but not one 
generated by Oracle.  The function did not exist  when that system was implemented.

Ian

-Original Message-
Sent: Thursday, October 31, 2002 11:41 AM
To: Multiple recipients of list ORACLE-L


Thanks Ian, I don't recall every playing with that function.

Have you ever done any performance testing on it?

Jared





"MacGregor, Ian A." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 09:13 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Database Design: unique PK across all tables


If you want to use globally unique identifiers Oracle has a sys_guid 
function to provide this.There should never be any "additional 
meaning" placed in keys. 
 
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 
-Original Message-
Sent: Thursday, October 31, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L

  Our developers are proposing a database design for an OLTP application 
in which each table has a PK of the same type and size.  In addition, each 
possible PK value can belong to at most one table. 
  Each table insert would require a call to the a single function to get 
the next PK value and an additional table would be used to store the 
current set of values.  (The developers want to put some additional 
meaning into a PK value and a sequence would not be sufficient, hence the 
need for the PK generating function and current value table). 
  I've never seen this done before and I would think this application 
would suffer greatly from contention when performing a large number of 
concurrent inserts. 
  Has anyone ever encountered a design like this?  Is this a bad design? 
  Thanks. 
Brian 


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbms_lock.sleep irregularities

[Khedr, Waleed]

Hi Jared,

You do not need the "to_date" function, just:

select (trunc(sysdate)+(10/24) - sysdate ) * ( 24*60*60) into seconds from
dual;

Regards,

Waleed

-Original Message-
Sent: Thursday, October 31, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L


Dear List,

I wrote the following bit of code yesterday to cause a 
process to kick off at a particular time.  This was not
doable via DBMS_JOB, as the code that follows this bit
 is a sqlplus script from an app vendor.

When I ran this last night, I expected it to sleep til 20:00.

Instead, it slept for about 45 minutes.

Here's an example from this morning that should have slept
until 10:00 AM, but instead only slept 25 minutes.

Any ideas?  Did I code something wrong here?

This is 8.1.6.3 on Windows NT 4 SP 6.

Just change the '10' below to some hour > sysdate

Thanks,

Jared

===

  declare
 seconds integer;
  begin
 -- seconds from now til 10:00 AM
 select (to_date(trunc(sysdate)+(10/24)) - sysdate ) * ( 24*60*60) 
into seconds
 from dual;
 dbms_output.put_line(seconds);
 dbms_lock.sleep(seconds);
 end;

09:10:15 RSYS13 - agile@orcl SQL> /
2681

PL/SQL procedure successfully completed.

09:36:05 RSYS13 - agile@orcl SQL> select 2861/3600 from dual;

 2861/3600
--
.79472

1 row selected.

14:13:02 RSYS13 - agile@orcl SQL>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Oracle 9.2.0.1 on hpux 11i using Virtual Partitions

[Scott Stefick]

Hello List,

Has anyone installed Oracle 9.2.0.1 Enterprise on an HP machine running 
hpux 11i using VPAR's (Virtual Partitions)?  I currently have an HP rp5470 
with 2  virtual partitions (prod and dev).  I'm trying to install 9.2.0.1 
and I get to the DBCA part of the installation (46% to be exact) and I get 
an error message: ORA-01078: failure in processing system parameters.   My 
main concern right now is to see if anyone has Virtual Partitions set up 
and they are able to install Oracle 9.2.0.1.

Thanks in advance,
-Scott

**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 - Casting about for ideas

[Fink, Dan]

Jared,
To state the obvious...'Throw away solutions some how never get
thrown away'.

Okay, now on to the real task at hand. A couple of ideas
Dump the reports out to html format (sql*plus can do this) and the
users can hit an url for the history. Using a little code to insure that the
front page shows the current report, with a secondary page with links to
other pages/reports.
Dump the compiled data to flat files on the network and let another
app (access/excel) get the data, format, graph, display it, etc.
Oh, (in deference), write a series of perl scripts...

Dan Fink

-Original Message-
Sent: Thursday, October 31, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L


Dear List,

First, a little background.  A coworker and I have been charged with
developing and implementing a 'short term' 'Reporting Solution'.

Glossary:

short term:  low cast, fast to implement, throw it away late next year

Reporting Solution:  Some method to make it easy for users to
see oft run reports without re-running them on the production SAP
( and other apps also ) systems.

The goal of the 'Reporting Solution' is perceived performance. 
Only 1 or 2 of these reports have any detrimental performance
impact on the servers.  The goal is to allow users to view current
and historic reports ( up to 90 days ) without being required to
wait on reports to run on the application/database servers.

This is partly political, partly user friendly. 

The political part is that we want to do *something* for users so
that it looks like we're taking their requirements to heart, even 
though we don't have the resources to do much right now.

The user friendly part is that we want to do *something* for users so
that we can make their jobs a little easier, even  though we don't 
have the resources to do much right now.

One idea we have is to have an ABAPer ( SAP programmer ) setup
the most requested reports to run in batch mode with a specified range
of dates and whatever parameters are needed. 

This would be done periodically, the report output put on a network
filer or database or something accessible via browser ( no shared
drive type solution, access is to iffy ), and a web page that would allow
simple navigation to reports by Category/Date.

Click on the report, view your data.

One thing that this is *not*, is a data warehouse and/or data marts.

This is to be a low cost solution.  Some software OK, a server is Ok
if necessary.  The key is fairly easy and quick implementation.

I'm open to any and all ideas you may have for this, experiences doing
similar projects, etc.  If it uses Oracle software, that's cool, if not, 
that's
cool too.  Oracle is involved in any solution: at the very least, that's 
where
all our source data is stored.

Thanks for reading this long winded message.

Jared



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: oracle or mssql

[Tim Gorman]

Any database engine that offers dirty-reads as an "option" is doing so
because it hasn't perfected the ability to avoid them.

The dust settled on this issue over a decade ago.  Check out Gray and Reuter
"Transaction Processing:  Concepts and Techniques" (ISBN: 1558601902 - it'll
be in any college library) and read the section on the ACID properties,
especially the sections on "C" for "consistency" and "I" for "isolation"...

Oracle is doing the best thing.  It supplies "statement-level
read-consistency" by default.  The ACID properties advise "transaction-level
read-consistency" and Oracle offers that option, but it is not advisable to
use it unless you are using a transaction-processing monitor besides...

Thousand-to-one odds are awful.  You can run across the "exception" millions
of times per day.  90% of all coding is created to deal with 10% or
less of the possible situations...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 9:54 AM


> I would like to point out that what you call "dirty reads" are mostly
> the correct reads. Oracle method IS the dirty read.
>
> I am sure that your users does at least 1000 commits to every rollback.
> So when oracle gives you the data it already knows that this data is
> wrong. If you do the query again a minute later you will get new results
> that were available when you did the original query but were committed
> later. So you get a 1000/1 chance to get incorrect data.
>
> The "dirty read" method, on the other hand, gives you the current values,
> believing that they will be committed in a moment. So you get 1/1000
chance
> to get wrong data.
>
> Which odds will you bet on?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, October 29, 2002 2:18 PM
>
>
> List,
> I'm always keen to refresh on database comparisons so thanks for
> everyone's pointers.
>
> I'm surprised Oracle doesn't make more of an issue about their locking and
> concurrency methods (i.e. redo/rollback/undo).
>
> MSSQL seems to deal with it in two ways:
> Default: readers and writers prevent writers from accessing data until
they
> are finished with it!
> Other method: no control, you just get dirty reads!
>
> Anyone got anything to add to this? Or am I wrong?
>
> - Mike.
>
>
> -Original Message-
> Sent: 24 October 2002 17:29
> To: Multiple recipients of list ORACLE-L
>
>
> As I said, use mssql ONLY if your boss is willing to be strapped into a
> MicroSlop only platform.  If he's even remotely thinking of using a
> different OS
> then you can't use mssql.
>
> Dick Goulet
>
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   10/23/2002 11:48 PM
>
> goodmorning
> everybody who responded to my basic question : thanks
>
> summary
>
> professional : use oracle enterprise edition
> semi professional : use oracle standard edition / mssql enterprise edition
> in all other cases mssql standard edition
>
>
>
> > -Oorspronkelijk bericht-
> > Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> > Verzonden:woensdag 23 oktober 2002 20:51
> > Aan:  Multiple recipients of list ORACLE-L
> > Onderwerp:RE: oracle or mssql
> >
> > Xenix is history now...SCO itself stopped it sometime in 1990
> >
> >
> >
> >
> >
> >
> > Reply-To: [EMAIL PROTECTED]
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: Wed, 23 Oct 2002 09:02:19 -0800
> >
> > XENIX maybe.
> >
> > : )
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > Technology Services| Services technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO  | Région des Maritimes, MPO
> >
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >
> >
> > -Original Message-
> > Sent: Wednesday, October 23, 2002 12:59 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Is MSSQL server available on UNIX?
> >
> > -Rachna
> > --
> > 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 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> > _
> > Get faster connections -- switch to MSN Internet Access!
> > http://resourcecen

Re: creating a 9.2 database

[Reginald . W . Bailey]

My bad. Instead of OUI use DBCA.

RWB





Reginald W. Bailey/JPMCHASE@[EMAIL PROTECTED] on 10/31/2002 03:54:29 PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



I must disagree. There is no $ORACLE_HOME/admin//scripts. There is no
admin directory under $ORACLE_HOME. In 9.2.0 you must create a template
first by using the default configuration, save it, then exit the OUI. Then
start it up again and use the existing template.  Go through the normal
prompts and then select the option to have it generate a shell script file
near the end of the process.  Have it save the script file in a directory
of your choosing or it will put it in
$ORACLE_HOME/assistants/dbca/templates by default.

RWB





"Adriano Freire" <[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 02:59:10
PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



normally in  $ORACLE_HOME/admin//scripts
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 5:40  PM

I always like to create my databases by hand via
the create database statement.  However, whenever a  new
version comes out I use the dbca assistant to  generate the
create database script so I can see what  Oracle does by
default (although I usually don't run  this generated script.)

I'm trying to do this with my new 9.2 installation, but
at the end (step 7), it doesn't seem to allow the
generation of the script without creating the  database.

Is dbca creating a script to run and if so, where is
it storing it?

9.2.0 on HP-UX 11i

Matt


Matt Adams - GE Appliances -  [EMAIL PROTECTED]
My computer beat me at chess,  but I won
when it came to kick boxing.




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Get together at OOW

[Cary Millsap]

"One check" works great if there's someone from Oracle there with a "V"
in his or her title. Even when the ORCL share price is less than the
kernel release number, the group merely moves on to another bar when the
"V" person goes to the little room in back of the restaurant to return
the beer and margaritas that he or she has rented for the evening. I've
seen it executed dozens of times, from both sides of the game.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Stephen
Sent: Thursday, October 31, 2002 3:40 PM
To: Multiple recipients of list ORACLE-L

Personal experience with the "one check" concept and large numbers of
people
is not good.  I would pressure them into say 5 checks.  Easier to
coordinate.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, October 31, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Get together at OOW

Absolutely OK!  I just made the reservation at Chevy's (3rd and Howard)
for
Tuesday Nov. 12th, 7pm for 20-25 people.  The only restriction is that
we
put it on one check.  Hopefully that will not be a problem for anyone.

Gerardo

-Original Message-
Sent: Thursday, October 31, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L


I might be able to scrounge a 7pm appearance by Anjo Kolk, Mogens
Nørgaard,
James Morle, Connor McDonald, Gaja Vaidyanatha, John Beresniewicz, Pete
Sharman, Lex de Haan, and maybe a few others if there's room. Would that
be
okay?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle(r) System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Gerardo
Sent: Thursday, October 31, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at
the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the
end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those
of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper management 
> balking at the registration fee.  As for getting together, I think
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing Saddles.

> ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during

> > > those same dates ( 11/10 - 11/15), just a couple miles from the
> > > Moscone Center where OOW is held.
> > >
> > > Are there any 

RE: Multiple Oracle Versions on Same Host (Workgroup 8.0.6 & Ente

[Stephen Lee]

When a vendor says it isn't certified for a version, then it's best that you
follow what the vendor says.  I've seen a number of apps break when the
database was upgraded.  Sometimes just changing a single driver will break
things.  For example, we have an app here (HEAT trouble ticket tracking)
that requires the client to use the 8.1.7.3 ODBC driver and only that
driver.  Granted, the example deals with the client side of things, but it
shows how touchy some vendor's apps are.

Running multiple versions of Oracle on a Unix box is not a problem.


> -Original Message-
> 
> There is a desire to consolidate some Unix servers. A couple 
> of the servers 
> are using Oracle 8.0.6 Standard (formerly Workgroup server) 
> and the intended 
> target servers already have 8.1.7 Enterprise. The 
> source/target servers are 
> using AIX 4.3. My understanding is that the application on 
> 8.0.6 is not 
> certified/supported on 8.1.7 by its vendor, yet.
> 
> Does anyone know if there are any problems/issues with doing this?
> Any advice on the procedures would be appreciated (in a 
> non-monetary way - 
> just like most corporate rewards programs).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

[Jared . Still]

I'm not new to Solaris or unix in general.

Rebooting to get rid of an unkillable process is not unheard of in unix 
land.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/31/2002 02:09 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES 
UNKILLABLE



Reboot, Yeah-Right.  This is Solaris, not Windoze.

I would try having the root user do the "kill -9" after doing a "truss" on
the process it see what it's looking at.  Doing a "ipcrm" on the shared
memory segment and semaphores may also help.

Brian



  
  Jared.Still@radis   
  ys.com   To:   Multiple 
recipients of list ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc:
  [EMAIL PROTECTED] Subject:  RE: Unkillable 
Background process "SHUTDOWN ABORT LEAVES UNKILLABLE 
  
  
  10/31/02 12:44 PM   
  Please respond to   
  ORACLE-L   
  
  




Reboot and open a TAR.

Jared





"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 12:28 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT
LEAVES UNKILLABLE
PROCESSES"


Hi,

I am using solaris 8


Sinardy

-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"


Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9
cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Store?

[Johnston, Tim]

Um...  Where do you see the message?  I'm able to get there...  I even put
some stuff in my cart...  But, I didn't log in and try to purchase...  My
credit card doesn't have a high enough limit to do a sample purchase...

:-)

-Original Message-
Sent: Thursday, October 31, 2002 4:40 PM
To: Multiple recipients of list ORACLE-L


Not really.  They are testing their "Unbreakable" message.  Something didn't
work.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, October 31, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Store?

I've hearded Oracle is going back as a brick and
mortar shop ...  ;-)

 --- [EMAIL PROTECTED] a écrit : > Does anyone
here have the scoop on the Oracle Store?
> 
> It's been down for at least a week.  The web page
> says
> down for maintenance, but given the amount of time,
> I
> don't believe it.
> 
> Thanks,
> 
> Jared
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> 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).
>  

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

dbms_lock.sleep irregularities

[Jared . Still]

Dear List,

I wrote the following bit of code yesterday to cause a 
process to kick off at a particular time.  This was not
doable via DBMS_JOB, as the code that follows this bit
 is a sqlplus script from an app vendor.

When I ran this last night, I expected it to sleep til 20:00.

Instead, it slept for about 45 minutes.

Here's an example from this morning that should have slept
until 10:00 AM, but instead only slept 25 minutes.

Any ideas?  Did I code something wrong here?

This is 8.1.6.3 on Windows NT 4 SP 6.

Just change the '10' below to some hour > sysdate

Thanks,

Jared

===

  declare
 seconds integer;
  begin
 -- seconds from now til 10:00 AM
 select (to_date(trunc(sysdate)+(10/24)) - sysdate ) * ( 24*60*60) 
into seconds
 from dual;
 dbms_output.put_line(seconds);
 dbms_lock.sleep(seconds);
 end;

09:10:15 RSYS13 - agile@orcl SQL> /
2681

PL/SQL procedure successfully completed.

09:36:05 RSYS13 - agile@orcl SQL> select 2861/3600 from dual;

 2861/3600
--
.79472

1 row selected.

14:13:02 RSYS13 - agile@orcl SQL>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

[Brian_P_MacLean]

Reboot, Yeah-Right.  This is Solaris, not Windoze.

I would try having the root user do the "kill -9" after doing a "truss" on
the process it see what it's looking at.  Doing a "ipcrm" on the shared
memory segment and semaphores may also help.

Brian



   
   
  Jared.Still@radis
   
  ys.com   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  Sent by: cc: 
   
  [EMAIL PROTECTED] Subject:  RE: Unkillable Background 
process "SHUTDOWN ABORT LEAVES UNKILLABLE  
   
   
   
   
  10/31/02 12:44 PM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Reboot and open a TAR.

Jared





"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 12:28 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT
LEAVES UNKILLABLE
PROCESSES"


Hi,

I am using solaris 8


Sinardy

-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"


Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9
cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the m

Re: creating a 9.2 database

[Reginald . W . Bailey]

I must disagree. There is no $ORACLE_HOME/admin//scripts. There is no
admin directory under $ORACLE_HOME. In 9.2.0 you must create a template
first by using the default configuration, save it, then exit the OUI. Then
start it up again and use the existing template.  Go through the normal
prompts and then select the option to have it generate a shell script file
near the end of the process.  Have it save the script file in a directory
of your choosing or it will put it in
$ORACLE_HOME/assistants/dbca/templates by default.

RWB





"Adriano Freire" <[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 02:59:10
PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



normally in  $ORACLE_HOME/admin//scripts
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 5:40  PM

I always like to create my databases by hand via
the create database statement.  However, whenever a  new
version comes out I use the dbca assistant to  generate the
create database script so I can see what  Oracle does by
default (although I usually don't run  this generated script.)

I'm trying to do this with my new 9.2 installation, but
at the end (step 7), it doesn't seem to allow the
generation of the script without creating the  database.

Is dbca creating a script to run and if so, where is
it storing it?

9.2.0 on HP-UX 11i

Matt


Matt Adams - GE Appliances -  [EMAIL PROTECTED]
My computer beat me at chess,  but I won
when it came to kick boxing.




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 - Casting about for ideas

[Jared . Still]

Dear List,

First, a little background.  A coworker and I have been charged with
developing and implementing a 'short term' 'Reporting Solution'.

Glossary:

short term:  low cast, fast to implement, throw it away late next year

Reporting Solution:  Some method to make it easy for users to
see oft run reports without re-running them on the production SAP
( and other apps also ) systems.

The goal of the 'Reporting Solution' is perceived performance. 
Only 1 or 2 of these reports have any detrimental performance
impact on the servers.  The goal is to allow users to view current
and historic reports ( up to 90 days ) without being required to
wait on reports to run on the application/database servers.

This is partly political, partly user friendly. 

The political part is that we want to do *something* for users so
that it looks like we're taking their requirements to heart, even 
though we don't have the resources to do much right now.

The user friendly part is that we want to do *something* for users so
that we can make their jobs a little easier, even  though we don't 
have the resources to do much right now.

One idea we have is to have an ABAPer ( SAP programmer ) setup
the most requested reports to run in batch mode with a specified range
of dates and whatever parameters are needed. 

This would be done periodically, the report output put on a network
filer or database or something accessible via browser ( no shared
drive type solution, access is to iffy ), and a web page that would allow
simple navigation to reports by Category/Date.

Click on the report, view your data.

One thing that this is *not*, is a data warehouse and/or data marts.

This is to be a low cost solution.  Some software OK, a server is Ok
if necessary.  The key is fairly easy and quick implementation.

I'm open to any and all ideas you may have for this, experiences doing
similar projects, etc.  If it uses Oracle software, that's cool, if not, 
that's
cool too.  Oracle is involved in any solution: at the very least, that's 
where
all our source data is stored.

Thanks for reading this long winded message.

Jared



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Store?

[Karniotis, Stephen]

Not really.  They are testing their "Unbreakable" message.  Something didn't
work.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, October 31, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Store?

I've hearded Oracle is going back as a brick and
mortar shop ...  ;-)

 --- [EMAIL PROTECTED] a écrit : > Does anyone
here have the scoop on the Oracle Store?
> 
> It's been down for at least a week.  The web page
> says
> down for maintenance, but given the amount of time,
> I
> don't believe it.
> 
> Thanks,
> 
> Jared
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> 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).
>  

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Store?

[Jesse, Rich]

What country did you select?  I've got $millions in my Cart right
now...carefully clicking  now.

Don't forget that most shopping sites require cookies and JavaScript,
because they are really really cool and every developer makes them
browser-independant.

Rich



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


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> Sent: Thursday, October 31, 2002 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Store?
> 
> 
> Does anyone here have the scoop on the Oracle Store?
> 
> It's been down for at least a week.  The web page says
> down for maintenance, but given the amount of time, I
> don't believe it.
> 
> Thanks,
> 
> Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Multiple Oracle Versions on Same Host (Workgroup 8.0.6 & Enterprise 8.1.7 on AIX

[David Davis]

There is a desire to consolidate some Unix servers. A couple of the servers 
are using Oracle 8.0.6 Standard (formerly Workgroup server) and the intended 
target servers already have 8.1.7 Enterprise. The source/target servers are 
using AIX 4.3. My understanding is that the application on 8.0.6 is not 
certified/supported on 8.1.7 by its vendor, yet.

Does anyone know if there are any problems/issues with doing this?
Any advice on the procedures would be appreciated (in a non-monetary way - 
just like most corporate rewards programs).

Thanks,
David
[EMAIL PROTECTED]





_
Unlimited Internet access -- and 2 months free!  Try MSN. 
http://resourcecenter.msn.com/access/plans/2monthsfree.asp

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: PL/SQL package

[BigP]

Hi Hoyt ,
Let me know exactly what you need . I can give some ideas . May not be the
code , cuz  my company closed recently and I am looking out for another job
. :)Let me know you if you have something in mind . Is it really hard to
find job for senior oracle analyst /developer .


Thanks ,
Bp

- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 8:50 AM


> Hi, BigP,
>
> I googled across a posting of yours about your PL/SQL error-handling
package. I'm looking for one, and yours sounds great!
>
> Is it the kind of thing you can share? I'd rather not re-invent.
>
> Thanks, Hoyt
> --
> __
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BigP
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: What do you think about multiples schemas versus 1 schema

[Mark Richard]

Stephane,

Just thinking of a few potential issues (I've worked in a warehouse set up
that way):

CONS
1)  Duplicate objects (same name, different schema) - can be accidentally
created and cause a lot of confusion
2)  Need to prefix objects with schema or create synonyms to get data from
one schema to the next
3)  May hit a few errors regarding permissions across schemas - all can be
worked around though

PROS
1)  Provides logical separation between objects
2)  May make it easier to provide objects for adhoc reporting, etc (users
connected to dw cannot see stage tables)
3)  In a complex environment it can help enforce good standards - like a dw
processing job should be able to read from stage but not update it (this
depends on the application design though)

I would recommend having a strong naming convention, even if using multiple
schema's, so that the purpose of each table is understood without knowing
which schema it is in - this helps fix con#1.  I think the logical
separation and ability to restrict access to end users are good reasons for
choosing multiple schema's though.

I think schema's are a little like folders in a filesystem.  Therefore your
question is similar to "should I put all of my documents in a single folder
or should I create folders for design, construction and testing.  However I
do understand the issue is slightly more complex than that.

Regards,
 Mark.



   
 
paquette stephane  
 
   
yahoo.com>cc:  
 
Sent by:  Subject: What do you think about 
multiples schemas versus 1 schema
[EMAIL PROTECTED]   
 
   
 
   
 
01/11/2002 07:09   
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Hi,

What do you think about multiples schemas versus 1
schema, pros and cons.

For example, having the schemas:  stage, dw, metadata
or only dw.

I have my ideas but I want to check if do not missed
anything.


TIA

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).



<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>

-

Re: Oracle Store?

[paquette stephane]

I've hearded Oracle is going back as a brick and
mortar shop ...  ;-)

 --- [EMAIL PROTECTED] a écrit : > Does anyone
here have the scoop on the Oracle Store?
> 
> It's been down for at least a week.  The web page
> says
> down for maintenance, but given the amount of time,
> I
> don't believe it.
> 
> Thanks,
> 
> Jared
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> 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).
>  

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

One step closer to the "New/Improved" MetaLink?

[Jesse, Rich]

Looks like new articles are now formatted in the familiar Oracle Portal
style:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=107182.1

At least these pages display properly in browsers other than I.

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Machine column in V$session

[Ray Stell]

You've got questions, we've got answers; but interrogative sentences may help
the twain to meet.



On Thu, Oct 31, 2002 at 08:28:51AM -0800, Naveen Nahata wrote:
> I have 2 questions regarding the machine column in V$SESSION.
> 
> 1. It shows just the machine name of the server for all the background
> processes, but for all user connections it shows domain\machine_name
> 2. Also for user processes, the machine name is appended with a chr(0)
> whereas for background processes it is not.
> 
> Oracle 8.0.6.1 Windows NT
> 
> Regards
> Naveen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Naveen Nahata
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: oracle or mssql

[Igor Neyman]

Very good point.

Also, transaction can include multiple inserts/deletes/updates, and they all
are in one transaction, because they make sense (from business point of
view) only when they all are executed/finished.  So, allowing "dirty" reads,
you allow to see "partial" results of the transaction (running in the
"other" session), and those partial results may have no sense.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 3:18 PM


Yechiel,

  If I understand your argument, you are saying that a select statement
should return all data, even if it is not committed.  Since most changes are
usually committed you are getting better data than if you get the pre-commit
data.  This pre-commit data is wrong in your view because it will change in
the very near future after the commit.
  The flaw with this thinking is that you will see partially changed data if
you see it without a commit being issued.  Imagine that I am giving all
employees a raise with the following statement:

update employees set salary=salary*1.15;

  If I run a select statement (that lets me see data before it is committed)
while this update is running, I may see some employees that got the raise
and some that didn't.  You are making the assumption that updates to the
data have been completed.  There is no way to know this without issuing a
commit.  Therefore your queries of non-committed data will only be right
1000/1 times if the queries are issued AFTER the updates are finished.  If
they are issued while the updates are occurring, then your queries will be
wrong every time.  In a world where non-committed data is available, a query
will almost never return the same results on tables that are being
constantly updated.

  Oracle takes the commit/rollback odds into consideration in its
architecture.  Updates are made to datablocks and copies of the pre-update
data are stored in the rollback segment in case a rollback is needed.  If
the odds were the other way around, the updates would be stored in a
pre-commit area and the original data blocks would stay as they are until
commit.

  A dirty block is a block that needs to be written to disk.  A dirty read
is what you would get if you saw data that has not been committed.

>From the 8i concepts manual:
The three preventable phenomena are:

dirty read
 A transaction reads data that has been written by another transaction that
has not been committed yet.

nonrepeatable (fuzzy) read
 A transaction rereads data it has previously read and finds that another
committed transaction has modified or deleted the data.

phantom read
 A transaction re-executes a query returning a set of rows that satisfies a
search condition and finds that another committed transaction has inserted
additional rows that satisfy the condition.

Jay


>>> [EMAIL PROTECTED] 10/31/02 10:28AM >>>
That was exactly my point.

It is NOT 6 of one , half dozen of the other.

You commit 1000's of times for each rollback.
So the data you read is incorrect while you read it with enormous odds that
the changes will be committed.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 8:09 PM


But Yechiel,

what is better?  Getting data that has not been committed by the
application, or data that has been updated by an application without a
commit being issued?

In the mssql option, do you really want to return data as valid, taking the
chance that the person who updated the record may issue a "rollback"?

I think it's 6 of one, half a dozen of the other.  At least with Oracle,
it's logical and under the applications control.  If the user issues a
commit, then the new data is available for query.  If the application needs
the data commited more frequently, then issuing commits more often is
certainly available.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, October 30, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L


I would like to point out that what you call "dirty reads" are mostly
the correct reads. Oracle method IS the dirty read.

I am sure that your users does at least 1000 commits to every rollback.
So when oracle gives you the data it already knows that this data is
wrong. If you do the query again a minute later you will get new results
that were available when you did the original query but were committed
later. So you get a 1000/1 chance to get incorrect data.

The "dirty read" method, on the other hand, gives you the current values,
believing that they will be committed in a moment. So you get 1/1000 chance
to get wrong data.

Which odds will you bet on?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM


List,
I'm always keen to refresh on database comparisons so thanks

Re: Machine column in V$session

[BigP]

so what is your question .

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 8:28 AM


I have 2 questions regarding the machine column in V$SESSION.

1. It shows just the machine name of the server for all the background
processes, but for all user connections it shows domain\machine_name
2. Also for user processes, the machine name is appended with a chr(0)
whereas for background processes it is not.

Oracle 8.0.6.1 Windows NT

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: BigP
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Get together at OOW

[Karniotis, Stephen]

Personal experience with the "one check" concept and large numbers of people
is not good.  I would pressure them into say 5 checks.  Easier to
coordinate.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, October 31, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Get together at OOW

Absolutely OK!  I just made the reservation at Chevy's (3rd and Howard) for
Tuesday Nov. 12th, 7pm for 20-25 people.  The only restriction is that we
put it on one check.  Hopefully that will not be a problem for anyone.

Gerardo

-Original Message-
Sent: Thursday, October 31, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L


I might be able to scrounge a 7pm appearance by Anjo Kolk, Mogens Nørgaard,
James Morle, Connor McDonald, Gaja Vaidyanatha, John Beresniewicz, Pete
Sharman, Lex de Haan, and maybe a few others if there's room. Would that be
okay?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle(r) System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Gerardo
Sent: Thursday, October 31, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper management 
> balking at the registration fee.  As for getting together, I think
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing Saddles.  
> ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during

> > > those same dates ( 11/10 - 11/15), just a couple miles from the
> > > Moscone Center where OOW is held.
> > >
> > > Are there any plans yet among list members to get together one
> > > evening?  I think Monday is spoken for myself, but it
> would be nice
> > > to meet a few list members another evening.
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > 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-

Jonathan Lewis seminar in Dallas, 19-21 November

[Cary Millsap]

   
Announcement

 

 
Optimising Oracle: Performance by Design


a 3-day seminar by Jonathan
 Lewis

 

 

Jonathan Lewis
will conduct his "Optimising Oracle" seminar in the

Dallas/Fort Worth area this November 19-21. "Optimising
Oracle" is a

three-day, intensive seminar aimed at DBAs, senior
developers, architects,

and designers.

 

Jonathan Lewis,
author of "Practical Oracle 8i: Building Efficient

Databases," is a UK-based consultant with more
than 17 years of experience

working with the Oracle database. His specialization
lies with

understanding and teaching how the functional
implications of various

database features can impact an application's design
and performance.

 

"Optimising Oracle" is one of the best
seminars I've ever taken.

Jonathan's
superb audience-participation exercises bring complicated

concepts beautifully to life. I encourage you not to
miss this rare

opportunity to see Jonathan
teach in the US.

 

See http://www.jlcomp.demon.co.uk/seminar.html for a
detailed outline of

the course objectives.

 

  
Seminar Details

  
---

 

What  Optimising Oracle:
Performance by Design

Who   Jonathan
 Lewis, author of "Practical
Oracle 8i"

When  8am
 to 5pm each day, November
 19-21, 2002

Where Embassy Suites Hotel
in Grapevine, Texas

How much  USD $1,650.00

 

Seating is strictly limited to 30 people. Priority
will be assigned in the

order that payments are received.

 

For those traveling from outside DFW area, you will
want to fly into

either DFW
 International Airport
(DFW) or Dallas Love Field (DAL). The

seminar hotel is approximately 10 minutes by car
from DFW, and 30 minutes

from DAL. Specific directions will be provided as
part of confirmation of

your booking.

 

For more information, contact Alison
 Holt at [EMAIL PROTECTED],
or

+1.817.329.3155.

 

Please forward this to anyone you think may be
interested. Thank you.

 

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- 2003 Hotsos Symposium on
Oracle® System Performance, Feb 9–12 Dallas
- Jonathan Lewis'
Optimising Oracle, Nov 19–21 Dallas

 

Re: What do you think about multiples schemas versus 1 schema

[BigP]

multiple schema sounds better ,
If think like dw is container which contains stage and metadata , hmmm is it
? make single schema
else
go for separate one .


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 12:09 PM


> Hi,
>
> What do you think about multiples schemas versus 1
> schema, pros and cons.
>
> For example, having the schemas:  stage, dw, metadata
> or only dw.
>
> I have my ideas but I want to check if do not missed
> anything.
>
>
> TIA
>
> =
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> __
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: BigP
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database design, replacing null by a default value

[Don Jerman]

Properly formulated, a DW only reports on what happened, and ignores what
did not happen.
If it's really like a DW then you just leave the nulls out.  You should
do this if you can.

Otherwise you have to decide how to lie based on least harm to
aggregates.  If you average or sum you should use 0 to avoid messing up
the sums.  If you can use a conditional code to skip a negative, and the
negative is not allowed, -1 makes a good null, but you wouldn't want to
sum it into an account or anything.  Blanks may be an option depending on
how Seibel interperets them, but it's probably a coding error.

For a varchar I'd use a zero-length string or a single blank, if
zero-length isn't allowed.  If blanks are significant, first shoot your
source system designer, then use ''. :)


paquette stephane wrote:

> Hi,
>
> We're in the process of writing functionnal specs for
> a system which is like a DW but instead of a DW the
> staging area push the data in Siebel.
>
> If we replaced null by something else.
> What would you choose :
>for a varchar field ?
>for a numeric field ?
>
> Someone has proposed blanks for the character field
> but I'm not comfortable with that.
>
> TIA
>
> =
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> __
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).

begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

RE: Get together at OOW

[Molina, Gerardo]

Absolutely OK!  I just made the reservation at Chevy's (3rd and Howard) for
Tuesday Nov. 12th, 7pm for 20-25 people.  The only restriction is that we
put it on one check.  Hopefully that will not be a problem for anyone.

Gerardo

-Original Message-
Sent: Thursday, October 31, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L


I might be able to scrounge a 7pm appearance by Anjo Kolk, Mogens Nørgaard,
James Morle, Connor McDonald, Gaja Vaidyanatha, John Beresniewicz, Pete
Sharman, Lex de Haan, and maybe a few others if there's room. Would that be
okay?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Gerardo
Sent: Thursday, October 31, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper management 
> balking at the registration fee.  As for getting together, I think
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing Saddles.  
> ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during

> > > those same dates ( 11/10 - 11/15), just a couple miles from the
> > > Moscone Center where OOW is held.
> > >
> > > Are there any plans yet among list members to get together one
> > > evening?  I think Monday is spoken for myself, but it
> would be nice
> > > to meet a few list members another evening.
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > 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: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --

Re: creating a 9.2 database

[Adriano Freire]

Title: creating a 9.2 database



normally in 
$ORACLE_HOME/admin//scripts

  - Original Message - 
  From: 
  Adams, 
  Matthew (GECP, MABG, 088130) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, October 31, 2002 5:40 
  PM
  Subject: creating a 9.2 database
  
  I always like to create my databases by hand via 
  the create database statement.  However, whenever a 
  new version comes out I use the dbca assistant to 
  generate the create database script so I can see what 
  Oracle does by default (although I usually don't run 
  this generated script.) 
  I'm trying to do this with my new 9.2 installation, but 
  at the end (step 7), it doesn't seem to allow the 
  generation of the script without creating the 
  database. 
  Is dbca creating a script to run and if so, where is 
  it storing it? 
  9.2.0 on HP-UX 11i 
  Matt 
   Matt Adams - GE Appliances - 
  [EMAIL PROTECTED] My computer beat me at chess, 
  but I won when it came to kick boxing. 

linux cluster s/w

[Ray Stell]

free linux cluster s/w, have not tried it, but will:

http://slashdot.org/article.pl?sid=02/10/30/1858241
http://clic.mandrakesoft.com/index-en.html
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Fw: Oracle Internals course

[Gogala, Mladen]

Stephane Faroult wrote:

> No John, the author of DUL is Bernard van forgot-his-name.

Van Damme?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

[Alex]

try kill -TERM

On Thu, 31 Oct 2002 [EMAIL PROTECTED] wrote:

> Reboot and open a TAR.
>
> Jared
>
>
>
>
>
> "Sinardy Xing" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/31/2002 12:28 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES 
>UNKILLABLE
> PROCESSES"
>
>
> Hi,
>
> I am using solaris 8
>
>
> Sinardy
>
> -Original Message-
> Sent: 31 October 2002 15:43
> To: Multiple recipients of list ORACLE-L
> PROCESSES"
>
>
> Hi all,
>
> When I do shutdown abort my LGWR and CKPT still around and also kill -9
> cannot get rid of them anyone know why ?
>
> because of this my cluster fail to failover
>
> Thanks
>
> Sinardy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Red Hat or Suse

[Gogala, Mladen]

Red 
Hat. Support is better, availability of the software is 10 times 
better
and 
help desk personnel is much, much better. As for stability, RH's 
2.4.18
kernel 
is extremely stable.

  -Original Message-From: Juan Miranda 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 2002 
  10:54 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Red Hat or Suse
   
  Hello
   
  Red Hat advanced 
  server or Suse Enterprise ?
   
  What is better 
  with Oracle ?
   
  What is more 
  recent (kernel 2.4.19, asynch I/O, big mem, etc) 
?

RE: Raw / VB / ADODB

[tim]

...the correct pronunciation is "lan GUY-lun"...

> Ya, that's it!
> (Peter still wanted to argue with me.  Is Long Island the
> "show-me" city?? But when he tried it, it worked)
> 
> Thanks a bunch!
> Barb
> 
> 
> > --
> > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> > Reply To: [EMAIL PROTECTED]
> > Sent: Thursday, October 31, 2002 12:13 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Raw / VB / ADODB
> > 
> > Barb,
> > 
> > Ask them to wrap RAWTOHEX() around the RAW column, which
> > will convert the resulting datatype to VARCHAR2?
> > 
> > Hope this helps...
> > 
> > -Tim
> > 
> > > Solaris 8
> > > Oracle 8.1.7.3
> > > 
> > > We have a field level_id defined as raw(5) in a table
> > > called objects.  I can pull data from this table from
> > > sqlplus as follows:
> > > select name, obj_id, level_id from objects where
> > > level_id='010101' and name = '1X3HRJOHNSON'
> > > 
> > > NAMEOBJ_ID LEVEL_ID
> > > --- -- --
> > > 1X3HRJOHNSON500583 010101
> > > 
> > > The developer is not able to pull identifiable data
> > > from the raw column level_id using VB.  His notes are
> > > shown below.  We searched metalink and google, and
> > > cannot find an answer. 
> > > Any help?  Thanks!!
> > > 
> > > Barb
> > > 
> > > OK,
> > > 
> > > I am using ADODB microsoft data objects version 2.7
> > > 
> > > I am using Oracle odbc driver 8.01
> > > I am trying to extract a raw field that is described
> > > as   level_id raw(5) 
> > > Every field extracts correctly except level_id
> > > 
> > > 
> > > Here is an example code excerpt
> > > 
> > > Set oRS = CreateObject("ADODB.Recordset")
> > > sSQL = "Select distinct level_id from objects"
> > > oRS.Source = sSQL
> > > oRS.ActiveConnection = conn
> > > oRS.Open
> > > Do Until oRS.EOF
> > > For i = 0 To oRS.Fields.Count - 1
> > > If oRS.Fields(i).Type = 204 Then' RAW
> > > field type
> > > strTemp = oRS.Fields(i).Value
> > > end if
> > > next
> > > oRS.movenext
> > > loop
> > > 
> > > In SQLPLUS when we ran a query on a record we got
> > > level _id 010101 , the above vb program returned 
> > > 971. SQLPLUS level_id  010A03, vb returned
> > > 633... 
> > > 
> > > What is ODBC returning?  is the value truncated
> > > somehow?
> > > does it need to be converted ?
> > > I think we are getting partial data and not the
> > > full length of the RAW field 
> > > Is RAW(5) equivalent to 10 bytes ?
> > >  SQLPLUS shows 10 positions on output 
> > > 
> > > HELP !!!
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com -- 
> > > Author: Baker, Barbara
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com San Diego, California--
> > > Mailing list and web hosting services
> > >
> > >
> --
> > > --- 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
> > http://www.fatcity.com San Diego, California--
> > Mailing list and web hosting services
> --
> > --- 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: Baker, Barbara
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com San Diego, California--
> Mailing list and web hosting services
> --
> --- 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 http://www.fatcity.

Oracle Store?

[Jared . Still]

Does anyone here have the scoop on the Oracle Store?

It's been down for at least a week.  The web page says
down for maintenance, but given the amount of time, I
don't believe it.

Thanks,

Jared

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: oracle or mssql

[Jay Hostetter]

Yechiel,

  If I understand your argument, you are saying that a select statement should return 
all data, even if it is not committed.  Since most changes are usually committed you 
are getting better data than if you get the pre-commit data.  This pre-commit data is 
wrong in your view because it will change in the very near future after the commit.
  The flaw with this thinking is that you will see partially changed data if you see 
it without a commit being issued.  Imagine that I am giving all employees a raise with 
the following statement:

update employees set salary=salary*1.15;

  If I run a select statement (that lets me see data before it is committed) while 
this update is running, I may see some employees that got the raise and some that 
didn't.  You are making the assumption that updates to the data have been completed.  
There is no way to know this without issuing a commit.  Therefore your queries of 
non-committed data will only be right 1000/1 times if the queries are issued AFTER the 
updates are finished.  If they are issued while the updates are occurring, then your 
queries will be wrong every time.  In a world where non-committed data is available, a 
query will almost never return the same results on tables that are being constantly 
updated.

  Oracle takes the commit/rollback odds into consideration in its architecture.  
Updates are made to datablocks and copies of the pre-update data are stored in the 
rollback segment in case a rollback is needed.  If the odds were the other way around, 
the updates would be stored in a pre-commit area and the original data blocks would 
stay as they are until commit. 

  A dirty block is a block that needs to be written to disk.  A dirty read is what you 
would get if you saw data that has not been committed.

>From the 8i concepts manual:
The three preventable phenomena are: 

dirty read 
 A transaction reads data that has been written by another transaction that has not 
been committed yet.  

nonrepeatable (fuzzy) read 
 A transaction rereads data it has previously read and finds that another committed 
transaction has modified or deleted the data. 

phantom read 
 A transaction re-executes a query returning a set of rows that satisfies a search 
condition and finds that another committed transaction has inserted additional rows 
that satisfy the condition. 
 
Jay


>>> [EMAIL PROTECTED] 10/31/02 10:28AM >>>
That was exactly my point.

It is NOT 6 of one , half dozen of the other.

You commit 1000's of times for each rollback.
So the data you read is incorrect while you read it with enormous odds that
the changes will be committed.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 8:09 PM


But Yechiel,

what is better?  Getting data that has not been committed by the
application, or data that has been updated by an application without a
commit being issued?

In the mssql option, do you really want to return data as valid, taking the
chance that the person who updated the record may issue a "rollback"?

I think it's 6 of one, half a dozen of the other.  At least with Oracle,
it's logical and under the applications control.  If the user issues a
commit, then the new data is available for query.  If the application needs
the data commited more frequently, then issuing commits more often is
certainly available.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, October 30, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L


I would like to point out that what you call "dirty reads" are mostly
the correct reads. Oracle method IS the dirty read.

I am sure that your users does at least 1000 commits to every rollback.
So when oracle gives you the data it already knows that this data is
wrong. If you do the query again a minute later you will get new results
that were available when you did the original query but were committed
later. So you get a 1000/1 chance to get incorrect data.

The "dirty read" method, on the other hand, gives you the current values,
believing that they will be committed in a moment. So you get 1/1000 chance
to get wrong data.

Which odds will you bet on?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM


List,
I'm always keen to refresh on database comparisons so thanks for
everyone's pointers.

I'm surprised Oracle doesn't make more of an issue about their locking and
concurrency methods (i.e. redo/rollback/undo).

MSSQL seems to deal with it in two ways:
Default: readers and writers prevent writers from accessing data until they
are finished with it!
Other method: no control, you just get dirty reads!

Anyone got anything to add to this? Or am I wrong?

- Mike.





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or en

RE: Latest Release

[Jamadagni, Rajendra]

I have 9202 for AIX for last 5 days now ... I believe AIX uses to be the 
last one ...
 
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!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 2002 
  12:29 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Latest ReleaseWhat is 
  the next release of Oracle 9i database (92020 ??) and when will it be 
  released for Windows 2000 (Next Week 
  ?? ;-)  ) Thanks 
  Steve ParkerE Mail: 
  [EMAIL PROTECTED]        
  --
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 corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

What do you think about multiples schemas versus 1 schema

[paquette stephane]

Hi,

What do you think about multiples schemas versus 1
schema, pros and cons.

For example, having the schemas:  stage, dw, metadata
or only dw. 

I have my ideas but I want to check if do not missed
anything.


TIA

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OS Authentication on Win2K

[Jared . Still]

Thanks, I'll give that a try.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/31/2002 02:38 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: OS Authentication on Win2K


when you create the registry setting in HKLM\software\oracle :
OSAUTH_PREFIX_DOMAIN=FALSE, then is it possible to log on
with domain account as /

it dit work for me.

> -Oorspronkelijk bericht-
> Van:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Verzonden: woensdag 30 oktober 2002 19:10
> Aan:   Multiple recipients of list ORACLE-L
> Onderwerp: Re: OS Authentication on Win2K
> 
> run:
> 
> select username from dba_users 
> where password = 'EXTERNAL'
> 
> Is there a user that matches the currently logged on
> Win2k account? 
> 
> Is it a domain account?  It needs to be a local account,
> as I don't think you can use a domain account without
> also using 'remote_os_authent=true'.
> 
> At least, it doesn't work for me that way.  I've only used
> external auth with local accounts.
> 
> HTH
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Mike Sardina" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/30/2002 09:24 AM
>  Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:OS Authentication on Win2K
> 
> 
> I am having problems getting OS authentication to work on a Win2K oracle
> server (8.1.7.1.1).
> 
> All parameters are set properly (from what I can see). There cannot be a
> prefix so the following parameter is set as follows: os_authent_prefix = 

> ""
> 
> I need to be able to log into the server as a user identified externally 

> and
> just type sqlplus / for access. It is also necessary for the users 
> identified
> externally to be  able to use a password as well.  Any suggestions? 
Anyone
> else run into problems with this?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mike Sardin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Design: unique PK across all tables

[Jared . Still]

Thanks Ian, I don't recall every playing with that function.

Have you ever done any performance testing on it?

Jared





"MacGregor, Ian A." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 09:13 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Database Design: unique PK across all tables


If you want to use globally unique identifiers Oracle has a sys_guid 
function to provide this.There should never be any "additional 
meaning" placed in keys. 
 
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 
-Original Message-
Sent: Thursday, October 31, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L

  Our developers are proposing a database design for an OLTP application 
in which each table has a PK of the same type and size.  In addition, each 
possible PK value can belong to at most one table. 
  Each table insert would require a call to the a single function to get 
the next PK value and an additional table would be used to store the 
current set of values.  (The developers want to put some additional 
meaning into a PK value and a sequence would not be sufficient, hence the 
need for the PK generating function and current value table). 
  I've never seen this done before and I would think this application 
would suffer greatly from contention when performing a large number of 
concurrent inserts. 
  Has anyone ever encountered a design like this?  Is this a bad design? 
  Thanks. 
Brian 


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Raw / VB / ADODB

[Baker, Barbara]

Ya, that's it!
(Peter still wanted to argue with me.  Is Long Island the "show-me" city??
But when he tried it, it worked)

Thanks a bunch!
Barb


> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, October 31, 2002 12:13 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Raw / VB / ADODB
> 
> Barb,
> 
> Ask them to wrap RAWTOHEX() around the RAW column, which
> will convert the resulting datatype to VARCHAR2?
> 
> Hope this helps...
> 
> -Tim
> 
> > Solaris 8
> > Oracle 8.1.7.3
> > 
> > We have a field level_id defined as raw(5) in a table
> > called objects.  I can pull data from this table from
> > sqlplus as follows:
> > select name, obj_id, level_id from objects where
> > level_id='010101' and name = '1X3HRJOHNSON'
> > 
> > NAMEOBJ_ID LEVEL_ID
> > --- -- --
> > 1X3HRJOHNSON500583 010101
> > 
> > The developer is not able to pull identifiable data from
> > the raw column level_id using VB.  His notes are shown
> > below.  We searched metalink and google, and cannot find
> > an answer. 
> > Any help?  Thanks!!
> > 
> > Barb
> > 
> > OK,
> > 
> > I am using ADODB microsoft data objects version 2.7
> > 
> > I am using Oracle odbc driver 8.01
> > I am trying to extract a raw field that is described as  
> > level_id raw(5) 
> > Every field extracts correctly except level_id
> > 
> > 
> > Here is an example code excerpt
> > 
> > Set oRS = CreateObject("ADODB.Recordset")
> > sSQL = "Select distinct level_id from objects"
> > oRS.Source = sSQL
> > oRS.ActiveConnection = conn
> > oRS.Open
> > Do Until oRS.EOF
> > For i = 0 To oRS.Fields.Count - 1
> > If oRS.Fields(i).Type = 204 Then' RAW
> > field type
> > strTemp = oRS.Fields(i).Value
> > end if
> > next
> > oRS.movenext
> > loop
> > 
> > In SQLPLUS when we ran a query on a record we got
> > level _id 010101 , the above vb program returned  971.
> > SQLPLUS level_id  010A03, vb returned 633...
> > 
> > 
> > What is ODBC returning?  is the value truncated
> > somehow?
> > does it need to be converted ?
> > I think we are getting partial data and not the full
> > length of the RAW field 
> > Is RAW(5) equivalent to 10 bytes ?
> >  SQLPLUS shows 10 positions on output 
> > 
> > HELP !!!
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com -- 
> > Author: Baker, Barbara
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com San Diego, California--
> > Mailing list and web hosting services
> > --
> > --- 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

[Jared . Still]

Reboot and open a TAR.

Jared





"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 12:28 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES 
UNKILLABLE 
PROCESSES"


Hi,

I am using solaris 8


Sinardy

-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"


Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9 
cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Get together at OOW

[Karniotis, Stephen]

CM:

  If you can Gaja to eat at a non-vegetarian restaurant, I have to see that.
What trouble he can be sometimes.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, October 31, 2002 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Get together at OOW

I might be able to scrounge a 7pm appearance by Anjo Kolk, Mogens
Nørgaard, James Morle, Connor McDonald, Gaja Vaidyanatha, John
Beresniewicz, Pete Sharman, Lex de Haan, and maybe a few others if
there's room. Would that be okay?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle(r) System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Gerardo
Sent: Thursday, October 31, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at
the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the
end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those
of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper
> management balking
> at the registration fee.  As for getting together, I think 
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple 
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing
> Saddles.  ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John 
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during

> > > those same dates ( 11/10 - 11/15), just a couple miles from the 
> > > Moscone Center where OOW is held.
> > >
> > > Are there any plans yet among list members to get together one 
> > > evening?  I think Monday is spoken for myself, but it
> would be nice
> > > to meet a few list members another evening.
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > 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: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California   

creating a 9.2 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: creating a 9.2 database





I always like to create my databases by hand via
the create database statement.  However, whenever a new
version comes out I use the dbca assistant to generate the
create database script so I can see what Oracle does by 
default (although I usually don't run this generated script.)


I'm trying to do this with my new 9.2 installation, but 
at the end (step 7), it doesn't seem to allow the 
generation of the script without creating the database.


Is dbca creating a script to run and if so, where is
it storing it?


9.2.0 on HP-UX 11i


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.

Re: Database Design: unique PK across all tables

[Jared . Still]

Brian,

As you pointed out, the design of this function will play 
a rather important part in the performance of this app.

The first thing I would question is the use of this column
as a PK.  A generated number should be fine.  PK's should
not carry any information in them, they're just an ID.  A series
of sequences or any non-serialized method of generating
them would be appropriate.

Regardless of whether this function generates a PK or a
UK, it needs to be designed to prevent serialization.

e.g. Using a single row table with some kind of counter, or
any similar one-at-a-time key generation will really limit
the scalability of the app.

HTH

Jared






"Brian P Andrews" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 05:33 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Database Design: unique PK across all tables


  Our developers are proposing a database design for an OLTP application 
in which each table has a PK of the same type and size.  In addition, each 
possible PK value can belong to at most one table. 
  Each table insert would require a call to the a single function to get 
the next PK value and an additional table would be used to store the 
current set of values.  (The developers want to put some additional 
meaning into a PK value and a sequence would not be sufficient, hence the 
need for the PK generating function and current value table). 
  I've never seen this done before and I would think this application 
would suffer greatly from contention when performing a large number of 
concurrent inserts. 
  Has anyone ever encountered a design like this?  Is this a bad design? 
  Thanks. 
Brian


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Raw / VB / ADODB

[tim]

Barb,

Ask them to wrap RAWTOHEX() around the RAW column, which
will convert the resulting datatype to VARCHAR2?

Hope this helps...

-Tim

> Solaris 8
> Oracle 8.1.7.3
> 
> We have a field level_id defined as raw(5) in a table
> called objects.  I can pull data from this table from
> sqlplus as follows:
> select name, obj_id, level_id from objects where
> level_id='010101' and name = '1X3HRJOHNSON'
> 
> NAMEOBJ_ID LEVEL_ID
> --- -- --
> 1X3HRJOHNSON500583 010101
> 
> The developer is not able to pull identifiable data from
> the raw column level_id using VB.  His notes are shown
> below.  We searched metalink and google, and cannot find
> an answer. 
> Any help?  Thanks!!
> 
> Barb
> 
> OK,
> 
> I am using ADODB microsoft data objects version 2.7
> 
> I am using Oracle odbc driver 8.01
> I am trying to extract a raw field that is described as  
> level_id raw(5) 
> Every field extracts correctly except level_id
> 
> 
> Here is an example code excerpt
> 
> Set oRS = CreateObject("ADODB.Recordset")
> sSQL = "Select distinct level_id from objects"
> oRS.Source = sSQL
> oRS.ActiveConnection = conn
> oRS.Open
> Do Until oRS.EOF
> For i = 0 To oRS.Fields.Count - 1
> If oRS.Fields(i).Type = 204 Then' RAW
> field type
> strTemp = oRS.Fields(i).Value
> end if
> next
> oRS.movenext
> loop
> 
> In SQLPLUS when we ran a query on a record we got
> level _id 010101 , the above vb program returned  971.
> SQLPLUS level_id  010A03, vb returned 633...
> 
> 
> What is ODBC returning?  is the value truncated
> somehow?
> does it need to be converted ?
> I think we are getting partial data and not the full
> length of the RAW field 
> Is RAW(5) equivalent to 10 bytes ?
>  SQLPLUS shows 10 positions on output 
> 
> HELP !!!
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com -- 
> Author: Baker, Barbara
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com San Diego, California--
> Mailing list and web hosting services
> --
> --- 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database design, replacing null by a default value

[Miller, Jay]

That really depends on what the real data looks like since it has to be
absolutely distinct.

For example if all your numeric data is positive then a value of -1 easily
identifies the "null" data.  If -1 is a valid value then this doesn't work.

How about 'null' for the varchar2 column?

Jay Miller

-Original Message-
Sent: Thursday, October 31, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


Hi,

We're in the process of writing functionnal specs for
a system which is like a DW but instead of a DW the
staging area push the data in Siebel.

If we replaced null by something else. 
What would you choose :
   for a varchar field ?
   for a numeric field ?

Someone has proposed blanks for the character field
but I'm not comfortable with that.

TIA

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Get together at OOW

[Cary Millsap]

I might be able to scrounge a 7pm appearance by Anjo Kolk, Mogens
Nørgaard, James Morle, Connor McDonald, Gaja Vaidyanatha, John
Beresniewicz, Pete Sharman, Lex de Haan, and maybe a few others if
there's room. Would that be okay?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Gerardo
Sent: Thursday, October 31, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at
the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the
end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those
of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper
> management balking
> at the registration fee.  As for getting together, I think 
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple 
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing
> Saddles.  ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John 
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during

> > > those same dates ( 11/10 - 11/15), just a couple miles from the 
> > > Moscone Center where OOW is held.
> > >
> > > Are there any plans yet among list members to get together one 
> > > evening?  I think Monday is spoken for myself, but it
> would be nice
> > > to meet a few list members another evening.
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > 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: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 su

RE: Help in Training on DBA

[Miller, Jay]

Hmm, I don't see anything on installing/upgrading/patching the database
software.  Even if a consultant does the initial install it will be
necessary to eventually install patches and/or upgrades.

BTW, I'll recommend the book Oracle DBA 101.  A great resource for a
starting DBA.

Jay Miller

-Original Message-
Sent: Thursday, October 31, 2002 12:58 AM
To: Multiple recipients of list ORACLE-L


Thank you Stephane for a detailed answer and sharing your experience. 

Most importantly what to expect once our server is up. Good mentioning of
SQL,

This will give us enough basic knowledge for the training class.

Thank you once again,

Aleem


 -Original Message-
Sent:   Wednesday, October 30, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Help in Training on DBA

Forgot : enter a technical bookshop and browse (and possibly buy) DBA books.
They are a worthy alternate view.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Fw: Oracle Internals course

[Stephane Faroult]

John Kanagaraj wrote:
> 
> Isn't Lex also the author (or initial creator) of DUL (DataUnLoader) that is
> charged out at $500/hr? (or is it $5000?)
> 
> John
> 

No John, the author of DUL is Bernard van forgot-his-name.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Auditing grant and revoke privileges

[Miller, Jay]

I'm trying to set up auditing for granting and revoking privileges on
objects. I thought this could be done with the command: 

audit grant on default; 

When I issued this command on a development database it seemed to have no
effect (i.e., granting and revoking privileges did not create an entry in
dba_audit_trail). After the database was shut down and restarted I then got
an entry in dba_audit trail for grants but not for revokes. 

I issued the following commands: 

SQL> create table testjay (t1 number(1)); 

Table created. 

SQL> grant select on testjay to wsidba; 

Grant succeeded. 

SQL> revoke select on testjay from wsidba; 

Revoke succeeded. 

This resulted in the following entries: 

oracle WSI pts/6 23-OCT-02 WSI TESTJAY 1 CREATE TABLE 
oracle WSI pts/6 23-OCT-02 WSI TESTJAY 103 SESSION REC 

I'm not clear on 

1) What the action SESSION REC means 
2) Why there was no entry for the revoke 
3) Why the entry for the grant had no data in the columns OBJ_PRIVILEGE or
GRANTEE 

Is there anything else I should be doing to audit these actions? 


I tried posting this on the Oracle Forum and all the support person told me
was that I probably hadn't restarted the database since changing the
init.ora parameter (untrue).


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Data guard

[Miller, Jay]

Are you using nologging or unrecoverable options at the primary site?  This
can cause problems.

Jay Miller

-Original Message-
Sent: Monday, October 28, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L


Hi
I have setup dataguard on 8.1.7.4 and have been noticing corruption of
archive logs at standby end some times.What could be reason?
With regards
-Seema





_
Surf the Web without missing calls! Get MSN Broadband.  
http://resourcecenter.msn.com/access/plans/freeactivation.asp

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Latest Release

[Steve . Parker]

What is the next release of Oracle 9i database (92020 ??) and when will it be released
for Windows 2000 (Next Week ?? ;-)  )

Thanks

Steve Parker
E Mail: [EMAIL PROTECTED]
         --

RE: What's your opinion: ALL_ROWS vs FIRST_ROWS

[John Kanagaraj]

Mike,

Check this out and let me know if this is helpful. Larry has already
answered the main concern, but this paper may address some of the other
hidden mines :)

http://www.geocities.com/john_sharmila/links.htm - click on the IOUG paper
link.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Armstead, Michael A [mailto:maa25681@;GlaxoWellcome.com]
> Sent: Tuesday, October 29, 2002 1:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: What's your opinion: ALL_ROWS vs FIRST_ROWS
> 
> 
> We're moving from RBO to CBO. 
> 
> For those of you who use CBO, what mode do you use FIRST_ROWS 
> or ALL_ROWS?
> And why?
> 
> My thinking is if it's a database where most of the querying 
> is done on
> small sets of records, then we may want to use FIRST_ROWS. On 
> the other
> hand, if our database is used to generate sizable reports, we 
> might use
> ALL_ROWS.
> 
> I also understand that we can always change it per session (with alter
> session) and per query (with hints).
> 
> Michael Armstead  
> Principal Database Administrator, OCP-Certified
> World Wide Corporate IT Database Administration
> GlaxoSmithKline
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Raid 5+

[Cary Millsap]

John,

 

Actually, a software vendor *does* have something to gain by nudging you
in the direction of RAID level 5. Using a cost-per-byte argument (a flawed
argument, as you know if you’ve paid attention to Anjo’s postings),
RAID5 *seems* cheaper to procure
than RAID1, leaving more capital budget left over for software purchase.

 

It’s only after the initial purchase
that many find out that the cost-per-byte argument is flawed. The only way to
fix the RAID5 performance problem is to purchase more I/O capacity. By then, your
software money is already spent; there’s no getting that back. You’re
forced by circumstance either to live with a really poor-performing application
or shell out more cash for a disk I/O capacity upgrade.

 

Both vendors’ hands are clean. They
both have a legitimate right to claim that the problem here is that the customer
just didn’t do enough homework.

 

I take comfort in your opening paragraph:
Do your homework. See “Is RAID5 Really a Bargain?” at www.hotsos.com/catalog for a list of
questions that you should be testing, and that sometimes people forget to ask.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- 2003 Hotsos Symposium on
Oracle® System Performance, Feb 9–12 Dallas
- Jonathan Lewis'
Optimising Oracle, Nov 19–21 Dallas



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of John Hallas
Sent: Thursday,
 October 31, 2002 2:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re Raid 5+

 

Jared,

 

We are certainly going to be performing extensive
testing to ensure performance of our applications under Raid5+ is acceptable.

 

That means it is as good if not better than that
experienced under Raid1

 

As I see it Oracle gain no benefit for stating that
Raid5 should be used if they did not believe that to be the case. If there was
any doubt it would be easier fro them to leave things as they were

 

 

John 

Raw / VB / ADODB

[Baker, Barbara]

Solaris 8
Oracle 8.1.7.3

We have a field level_id defined as raw(5) in a table called objects.  I can
pull data from this table from sqlplus as follows:
select name, obj_id, level_id from objects where
level_id='010101' and name = '1X3HRJOHNSON'

NAMEOBJ_ID  LEVEL_ID
---  -- --
1X3HRJOHNSON500583  010101

The developer is not able to pull identifiable data from the raw column
level_id using VB.  His notes are shown below.  We searched metalink and
google, and cannot find an answer.

Any help?  Thanks!!

Barb

OK,

I am using ADODB microsoft data objects version 2.7

I am using Oracle odbc driver 8.01
I am trying to extract a raw field that is described as   level_id raw(5)

Every field extracts correctly except level_id


Here is an example code excerpt

Set oRS = CreateObject("ADODB.Recordset")
sSQL = "Select distinct level_id from objects"
oRS.Source = sSQL
oRS.ActiveConnection = conn
oRS.Open
Do Until oRS.EOF
For i = 0 To oRS.Fields.Count - 1
If oRS.Fields(i).Type = 204 Then' RAW field type
strTemp = oRS.Fields(i).Value
end if
next
oRS.movenext
loop

In SQLPLUS when we ran a query on a record we got level _id
010101 , the above vb program returned  971. 
SQLPLUS level_id  010A03, vb returned 633...


What is ODBC returning?  is the value truncated somehow?
does it need to be converted ?
I think we are getting partial data and not the full length of the
RAW field 
Is RAW(5) equivalent to 10 bytes ?
SQLPLUS shows 10 positions on output 

HELP !!!

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: oracle or mssql

[Igor Neyman]

Disagree.

"row-level" locking in SQL Server was introduced in some capacity only in
SQL Server 7 (not long time ago).
Before, it was "block-level" locking, and I saw lots of problems with that.
It's not the length of the single statement (select/update/...) that
matters.  It's the length of the transaction, that causes a problem, if
"block_level" locking is used (and could be automatically escalated to
"extent" or even "table" level lock).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 10:18 AM


> I don't see it as a gotcha, I've worked with SQL Server for almost 6 years
> on some pretty big databases and have never had a problem.
>
> At the end of the day, locking is at the row level, locks are held for a
> very short time (unless developers don't know what they are doing). A read
> will take a shared row level lock for a sub-second period of time
> (potentially), if your update is blocked for 0.2 seconds are you going to
> notice ? You have to realise that with row level locking the scope for
> blocking is minimal.
>
> Ade
>
> -Original Message-
> Sent: 31 October 2002 14:04
> To: Multiple recipients of list ORACLE-L
>
>
>
> But this default mssql behaviour is the performance 'gotcha' where readers
> block writers and writers block readers isn't it?
>
>
> Mike.
>
> -Original Message-
> Sent: 31 October 2002 09:12
> To: Multiple recipients of list ORACLE-L
>
>
> 'Dirty reads' in SQL Server means that you can view records that have not
> been committed. This is implemented by setting the TRANSACTION ISOLATION
> LEVEL to READ UNCOMMITTED.
>
> This is not default behaviour in SQL Server, the default TIL is READ
> COMMITTED (for very good reason). I can think of very few situations where
> you would want to see uncommitted records.
>
> Dirty blocks in SQL Server/Oracle are the same thing ie. a block/page in
> cache that has been changed but not flushed to disk.
>
> Ade
>
> -Original Message-
> Sent: 30 October 2002 18:43
> To: Multiple recipients of list ORACLE-L
>
>
> It sounds like he is saying that, once an "insert, update or delete"
> statement has been issued (without a following commit), then the records
> acted upon are now considered "dirty" - i.e. needing writing to disk.
>
> this is, of course, NOT what Oracle considers a dirty block.
>
> I agree with you, Jared!
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Wednesday, October 30, 2002 1:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> At least one of us has the incorrect understanding of 'dirty' reads,
> or I am taking you too literally, or something.
>
> What are you really saying?
>
> Oracle does not allow dirty reads.
>
> All queries are consistent to a point in time, the beginning
> of a transaction, whether implicit (select) or explicit ( start
> transaction ).
>
> SQL Server and Sybase do not guarantee this.
>
> The 'dirty' reads you are speaking of sound more to me
> like sloppy programming.
>
> Is that what you're referring to?
>
> Jared
>
>
>
>
>
>
> "Yechiel Adar" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/30/2002 08:54 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Re: RE: oracle or mssql
>
>
> I would like to point out that what you call "dirty reads" are mostly
> the correct reads. Oracle method IS the dirty read.
>
> I am sure that your users does at least 1000 commits to every rollback.
> So when oracle gives you the data it already knows that this data is
> wrong. If you do the query again a minute later you will get new results
> that were available when you did the original query but were committed
> later. So you get a 1000/1 chance to get incorrect data.
>
> The "dirty read" method, on the other hand, gives you the current values,
> believing that they will be committed in a moment. So you get 1/1000
> chance
> to get wrong data.
>
> Which odds will you bet on?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, October 29, 2002 2:18 PM
>
>
> List,
> I'm always keen to refresh on database comparisons so thanks for
> everyone's pointers.
>
> I'm surprised Oracle doesn't make more of an issue about their locking and
> concurrency methods (i.e. redo/rollback/undo).
>
> MSSQL seems to deal with it in two ways:
> Default: readers and writers prevent writers from accessing data until
> they
> are finished with it!
> Other method: no control, you just get dirty reads!
>
> Anyone got anything to add to this? Or am I wrong?
>
> - Mike.
>
>
> -Original Message-
> Sent: 24 October 2002 17:29
> To: Multiple recipients of list ORACLE-L
>
>
> As I said, use mssql ONLY if your boss is willing to be strapped into a
> MicroSlop only platform.  

RE: Convert DM TSP to LM TSP w/ lots of data

[Jesse, Rich]

Govind, 

We have just implemented Quest's LiveReorg, which I plan to use in our
conversion to LMT.  Does it completely eliminate downtime?  No, but in our
shop, I'll be able to do the conversion in "quiet" hours on weekends without
the need to keep users completely off of the system (i.e. I don't need to
schedule downtime).  How applicable this is to other shops depends on how
many users, how active they are and when, the nature of the system/data,
etc.  It just happens to fit very well for us at this point.

My $.02,

Rich

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Govind.Arumugam@;alltel.com]
> Sent: Tuesday, October 29, 2002 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Convert DM TSP to LM TSP w/ lots of data
> 
> 
> This is what we have in mind.
> 
> For the partitioned tables that are going to have the 
> 'rotation' logic,
> we will convert them to LMT when they become empty.  We drop the
> 'oldest' partition and create a new one for next month. This will be
> carried out every month. Partition for November data is empty 
> now and is
> being converted to use LMT as of this week;  Next month we will do the
> same for December partition;  This way, we would convert all our 5
> CALLDETAIL tablespaces to use LMT in 5 months time.
> 
> Now, for other tablespaces that contain data and indexes, we need to
> decide whether we should create corresponding LMT tablespaces and move
> the existing objects to it or change them using the procedure that
> Oracle recommends; Some of these tablespaces are sized 
> anywhere from 5Gb
> to 60Gb and we do not have much of freespace as buffer. Our database
> size is about 1.2 tera bytes.  Also for this we might have to 
> ask for a
> bigger maintenance window which will be hard to get.  So we are toying
> up with the idea of converting them from DMT to LMT using 'in place'
> mechanism and rebuild the tables/indexes eventually as time permits.
> Obviously, we are not trying cause any outage knowingly.  Hence these
> questions to the forum.
> 
> Thanks,
> Govind
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Design: unique PK across all tables

[MacGregor, Ian A.]

Title: Message



If you 
want to use globally unique identifiers Oracle has a sys_guid function to 
provide this.    There should never be any "additional meaning" 
placed in keys. 
 
Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]   


  
  -Original Message-From: Brian P Andrews 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 31, 2002 5:33 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Database Design: unique PK across all tables  
  Our developers are proposing a database design for an OLTP application in 
  which each table has a PK of the same type and size.  In addition, each 
  possible PK value can belong to at most one table. 
    Each table insert would require a call to the a single function 
  to get the next PK value and an additional table would be used to store the 
  current set of values.  (The developers want to put some additional 
  meaning into a PK value and a sequence would not be sufficient, hence the need 
  for the PK generating function and current value table). 
    I've never seen this done before and I would think this 
  application would suffer greatly from contention when performing a large 
  number of concurrent inserts. 
    Has anyone ever encountered a design like this?  Is this a 
  bad design? 
    Thanks. 
  Brian 

RE: Get together at OOW

[Molina, Gerardo]

John,

I'm planning to make a reservation (for dinner) at 7pm for 15 people on
Tuesday 11/12/2002.  We can congregate in the cantina for drinks anytime
before then.  We should have no problem changing the number of people at the
last minute, if necessary.

Gerardo

-Original Message-
Sent: Wednesday, October 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Steve,

I will send out an invite closer to that time - say around 6th or 7th.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those of my
employer or clients **

> -Original Message-
> From: Steve McClure [mailto:smcclure@;usscript.com]
> Sent: Monday, October 28, 2002 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Get together at OOW
> 
> 
> It looks like I will be attending this year pending upper
> management balking
> at the registration fee.  As for getting together, I think 
> that would be
> great, Chevy's is great as well,  In fact Tuesday evening 
> looks great too.
> 
> So how big a party does that make?  Count me in.
> 
> 
> Steve McClure
> 
> -Original Message-
> Sent: Saturday, October 26, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> John,
> 
> Yes, it would be nice to meet.
> 
> I'm not planning anything, I'll let someone else do it.
> 
> I won't be available during the day at the conference, so
> it would be best if someone else put's something together.
> 
> My previous post didn't make it to the list:  I'm attending a couple 
> of Veritas classes at the same time as the conference, so I'll just  
> be a couple miles down the road at the Embarcadero.
> 
> Jared
> 
> PS. Rachel, too bad you won't be there.  I'm bringing Blazing
> Saddles.  ;)
> 
> On Monday 21 October 2002 16:43, John Kanagaraj wrote:
> > Jared,
> >
> > Count me in as I live in San Jose, and will drop in on any
> agreed date.
> > Gerardo Molina (of SF, still on this list?) and self pulled
> together a
> > group of illustrious personalities that even included Steve
> Adams (and the
> > Goddess of course!)
> >
> > It would be a pleasure to meet you after all these years! John 
> > Kanagaraj
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > > Sent: Monday, October 21, 2002 4:19 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Get together at OOW
> > >
> > >
> > > Dear list,
> > >
> > > Though I won't be attending OOW, I will be in San Francisco during 
> > > those same dates ( 11/10 - 11/15), just a couple miles from the 
> > > Moscone Center where OOW is held.
> > >
> > > Are there any plans yet among list members to get together one 
> > > evening?  I think Monday is spoken for myself, but it
> would be nice
> > > to meet a few list members another evening.
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > 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: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Steve McClure
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 

RE: RE: oracle or mssql

[Stephen Lee]

> -Original Message-
> 
> I just got steamed up because he called it "dirty" reads. To 
> my taste they
> are uncommitted changes.
> 

Perhaps it would be better to use Oracle's non-judgmental and eminently more
politically correct terminology of "consistent" versus "inconsistent".
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: 9i RAC

[BALA,PRAKASH (HP-USA,ex1)]

Hi Mark,

It is [EMAIL PROTECTED]

Prakash

-Original Message-
Sent: Wednesday, October 30, 2002 11:40
To: Multiple recipients of list ORACLE-L


Many thanks for the feedback all.. I'll certainly try to search out Murali
at the UKOUG.. Does anybody have his email address?

Cheers!!

Mark

 -Original Message-
Faroult
Sent:   29 October 2002 19:07
To: Multiple recipients of list ORACLE-L
Subject:Re: 9i RAC

John Kanagaraj wrote:
> 
> Mark,
> 
> If you read the latest Oracle Mag (Peer-to-Peer), you will find that a
> (sometime?) list member Murali Vallath is using RAC and is actually
planning
> a book sometime later. Maybe you can address the question to him? Murali
> presents/attends IOUG 

  What is more relevant, perhaps, to Mark is that Murali should be in
Brum in december.

> and I know for sure that he 'speakes from the
> trenches' (unlike a lot of the bull from Oracle marketing).
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> What would you see if you were allowed to look back at your life at the
end
> of your journey in this earth?
> 
> ** The opinions and statements above are entirely my own and not those of
my
> employer or clients **
> 
> > -Original Message-
> > From: Mark Leith [mailto:mark@;cool-tools.co.uk]
> > Sent: Tuesday, October 29, 2002 8:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 9i RAC
> >
> >
> > A quick question out to the masses..
> >
> > How many of you out there are ACTUALLY USING 9i RAC technology?
> >
> > If not already using it - how many have plans to use it (or
> > at least plan to investigate it)?
> >
> > Cheers
> >
> > Mark
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: BALA,PRAKASH (HP-USA,ex1)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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[2]: Database Design: unique PK across all tables

[Robert Eskridge]

Brian,

Yeah, I've encountered it in databases for real time process control systems, but
those were systems where relational databases were rejected for having
too much overhead in the data dictionary.  The PK was actually a pointer to an absolute
location (sort of like rowid but even more basic).  These systems were
heavy read and update but almost zero insert and delete in a production
environment.  Selects as known in a relational database did not exist,
all information retrieval was pre-interpreted to the PK's and specific
attributes of the row.  These are very difficult to work with and
certainly not general purpose databases.  Historical reporting was
often snapshots taken and moved to a general purpose database like
Oracle where the whole uniform PK stuff was forgotten.

-rje





B>   Our developers are proposing a database design for an OLTP application in
B> which each table has a PK of the same type and size.  In addition, each
B> possible PK value can belong to at most one table.

B>   Each table insert would require a call to the a single function to get the
B> next PK value and an additional table would be used to store the current set
B> of values.  (The developers want to put some additional meaning into a PK
B> value and a sequence would not be sufficient, hence the need for the PK
B> generating function and current value table).


B>   I've never seen this done before and I would think this application would
B> suffer greatly from contention when performing a large number of concurrent
B> inserts.


B>   Has anyone ever encountered a design like this?  Is this a bad design?


B>   Thanks.


B> Brian

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Design: unique PK across all tables

[Gogala, Mladen]

Just 
tell your developers that primary key on the tables leads to spiritual 
enlightment 
and 
will help them earn reward points for paradise. Creating tables without a 
primary key
is  a sure fire way to eternal damnation and that 
place where they have a great, ongoing 
party 
withj lots of controlled substances and without law enforcement or moralists 
(that
was in the demo).

  -Original Message-From: Jack van Zanen 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 2002 10:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Database Design: unique PK across all tables
  Haven't encountered it, but reading what your saying 
  sounds like a performance problem waiting to happen.
  
-Original Message-From: Brian P Andrews 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 2002 
2:33 PMTo: Multiple recipients of list 
ORACLE-LSubject: Database Design: unique PK across all 
tables  Our developers are proposing a 
database design for an OLTP application in which each table has a PK of the 
same type and size.  In addition, each possible PK value can belong to 
at most one table. 
  Each table insert would require a call to the a single 
function to get the next PK value and an additional table would be used to 
store the current set of values.  (The developers want to put some 
additional meaning into a PK value and a sequence would not be sufficient, 
hence the need for the PK generating function and current value 
table). 
  I've never seen this done before and I would think this 
application would suffer greatly from contention when performing a large 
number of concurrent inserts. 
  Has anyone ever encountered a design like this?  Is this 
a bad design? 
  Thanks. 
Brian 

RE: Defragmentation of tablespace

[Stephen Lee]

> -Original Message-
> 
> Does anybody help me to defrag / reorganise the user tablespaces which
> is large in size.
> Is there any script for that ? If available can somebody send it to me
> ?
> 

The two methods that come to mind are:

1. Export the objects in the tablespace; drop them from the tablespace;
coalesce the table tablespace; import the objects back in.  If there are
relationships between objects in this tablespace and those in another
tablespace, it might be easier to export the entire schema, drop the
schema's objects, then import the schema after coalescing all free space.

2. Create a new tablespace (you might need to grant quota for a schema);
move tables to that tablespace (which will require rebuilding any indexes on
those tables after you are done); AND/OR rebuild indexes to that tablespace.
If you are moving only indexes, you can do that online.  You can move tables
without taking down the database, but all the indexes go invalid when you
move the table; so any DML activity will probably get clobbered.  I suppose,
if you wanted to go to the trouble, you could keep the database active by
dropping indexes on any tables to be moved, then re-create the indexes after
the tables were moved.  This would allow at least some DML activity to
continue -- at a reduced level of performance.  Then move everything back to
the original tablespace after coalescing if you need for the objects to
reside in the original tablespace.  (All the online stuff assumes your
version of Oracle is recent enough to support it.)

Before going to all this trouble, try coalescing the free space in the
tablespace, then look to see if you still have chunks of free space
scattered all over the place, all of them smaller than you need, but the sum
of which is considerable.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Machine column in V$session

[Naveen Nahata]

I have 2 questions regarding the machine column in V$SESSION.

1. It shows just the machine name of the server for all the background
processes, but for all user connections it shows domain\machine_name
2. Also for user processes, the machine name is appended with a chr(0)
whereas for background processes it is not.

Oracle 8.0.6.1 Windows NT

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Soft

[Aponte, Tony]

Title: RE: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Soft






Would you happen to know how the software layer that combined LUNs to make it look like a large file system was enabled?  We're experiencing similar issues with one of our Clarion arrays.

TIA

Tony Aponte


-Original Message-

From: John Kanagaraj [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, October 29, 2002 9:13 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Soft


Yes - and I just completed stress-testing an OLTP database were we went

from 2 distinct 'filesystems' for data files to 12 separate filesystems.

Average wait times for I/O dropped from 40 - 50 msec (yes 40 - 50 msec!) to

about 10 - 13 msec. All this was on a Disk Array and all we did was to 

convince the SAs to chop it up this way. Apparently, some software layers at 

the Array level that 'combined' LUNs to make it look like a lar

RE: ORA-1078 During a 9iR2 Install

[Gogala, Mladen]

You should recreate your spfile. Oracle9i starts from an spfile, if it
exists
and some installations do put a ghost one in $ORACLE_HOME/dbs. 

> -Original Message-
> From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> Sent: Wednesday, October 30, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-1078 During a 9iR2 Install
> 
> 
> Hi Gurus,
> 
> Hardware: HP rp5470
> OS: HP-UX 11i (11.11)
> Oracle Version: Enterprise Edition 9.2.0.1.0
> 
> I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is 
> trying to create and start the database, I'm getting an 
> "ORA-1078: failure 
> in processing system parameters" error.  Then when I tried 
> startup nomount 
> I got that error again along with "LRM-00109: could not open 
> parameter file 
> '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message.  I 
> opened up a TAR with Oracle and so far they just made sure that my 
> ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set 
> correctly.  they 
> said they would get back to me on this one.  Has anyone here 
> encountered 
> anything like this during a 9iR2 install, or does anyone have any 
> suggestions that I could try?
> 
> Thanks in advance!
> -Scott
> 
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Scott Stefick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Red Hat or Suse

[Juan Miranda]

 
Hello
 
Red Hat advanced 
server or Suse Enterprise ?
 
What is better with 
Oracle ?
 
What is more recent 
(kernel 2.4.19, asynch I/O, big mem, etc) ?

RE: upgrade 8-9 and ofa compliance

[Stephen Lee]

I'm just curious:
You mention "registry settings", but the slashes on your
paths go in this -> / direction.

At least in the past, there is a difference in what you must do if you are
on Unix or non-Unix.  With non-Unix, completely eliminating everything of a
previous installation involves the use of regedt32 (Oh boy!).  

At our shop, to install a new version of Oracle on a non-Unix box, we remove
everything by hand PRIOR to installing the new version: All registry
entries, all Oracle binaries, and the oracle directory (er ... folder) in
the program files directory (where the inventory file is).  This might be
unnecessary paranoia; but when on non-Unix, paranoia is good.


> -Original Message-
> 
> We are planning to migrate our database from 8i to 9i soon, i 
> had the idea
> to use the migrate utility from oracle.
> So far so good, but at one moment i have 2 OFA compliant 
> software trees on
> my server :
> /oracle/ora81 and /oracle/ora90 with the corresponding 
> registry settings.
> What is the correct procedure to eliminate everything of oracle 8i
> afterwards and that nothing is pointing
> to the /oracle/ora81 directory ??
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Design: unique PK across all tables

[Jack van Zanen]

Haven't encountered it, but reading what your saying 
sounds like a performance problem waiting to happen.

  -Original Message-From: Brian P Andrews 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 31, 2002 2:33 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Database Design: unique PK across all tables  
  Our developers are proposing a database design for an OLTP application in 
  which each table has a PK of the same type and size.  In addition, each 
  possible PK value can belong to at most one table. 
    Each table insert would require a call to the a single function 
  to get the next PK value and an additional table would be used to store the 
  current set of values.  (The developers want to put some additional 
  meaning into a PK value and a sequence would not be sufficient, hence the need 
  for the PK generating function and current value table). 
    I've never seen this done before and I would think this 
  application would suffer greatly from contention when performing a large 
  number of concurrent inserts. 
    Has anyone ever encountered a design like this?  Is this a 
  bad design? 
    Thanks. 
  Brian 

RE: Defragmentation of tablespace

[Gogala, Mladen]

Wow! Your disclaimer is larger then your message! As for the defragmentation
look into DBA guide under "locally managed tablespaces" and then in SQL
reference
under: "ALTER TABLE" and pay particular attention to the "MOVE" qualifier.
The site to visit is http://technet.oracle.com. And yes, this is a "read the
fine
manual" answer.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pradeep@;ibsplc.com]
> Sent: Thursday, October 31, 2002 7:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Defragmentation of tablespace
> 
> 
> Dear Friends,
> 
> Does anybody help me to defrag / reorganise the user tablespaces which
> is large in size.
> Is there any script for that ? If available can somebody send it to me
> ?
> 
> Regards,
> Pradeep
> 
> Disclaimer:
> "The information in this e-mail is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. It should not be used by anyone who is not the
> original intended recipient. If you have erroneously received this
> message, please delete it immediately and notify the sender. The
> recipient acknowledges that IBS or IBS Group like any other large
> global corporation, are unable to exercise total control or ensure or
> guarantee the integrity of contents of the information contained in
> individual e-mail transmissions and the recipient acknowledges that
> any views expressed in this message may be those of the individual
> sender and no binding nature of the message shall be implied or
> assumed unless the sender does so expressly with due authority of IBS
> Group. Before opening any attachments please check them for viruses
> and defects."
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: oracle or mssql

[Yechiel Adar]

I meant that the data itself is dirty, i.e. - incorrect at the time of
reading.

As for the correct behavior - check ADABAS database. They are allowing what
you called dirty reads and they are used in the mainframe all over.

This is a design point in the database that you have to live with.
At least, in the ADABAS way you are more correct then incorrect to the tune
of 1000's to one.

I just got steamed up because he called it "dirty" reads. To my taste they
are uncommitted changes.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 8:42 PM


> It sounds like he is saying that, once an "insert, update or delete"
> statement has been issued (without a following commit), then the records
> acted upon are now considered "dirty" - i.e. needing writing to disk.
>
> this is, of course, NOT what Oracle considers a dirty block.
>
> I agree with you, Jared!
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Wednesday, October 30, 2002 1:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> At least one of us has the incorrect understanding of 'dirty' reads,
> or I am taking you too literally, or something.
>
> What are you really saying?
>
> Oracle does not allow dirty reads.
>
> All queries are consistent to a point in time, the beginning
> of a transaction, whether implicit (select) or explicit ( start
> transaction ).
>
> SQL Server and Sybase do not guarantee this.
>
> The 'dirty' reads you are speaking of sound more to me
> like sloppy programming.
>
> Is that what you're referring to?
>
> Jared
>
>
>
>
>
>
> "Yechiel Adar" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/30/2002 08:54 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Re: RE: oracle or mssql
>
>
> I would like to point out that what you call "dirty reads" are mostly
> the correct reads. Oracle method IS the dirty read.
>
> I am sure that your users does at least 1000 commits to every rollback.
> So when oracle gives you the data it already knows that this data is
> wrong. If you do the query again a minute later you will get new results
> that were available when you did the original query but were committed
> later. So you get a 1000/1 chance to get incorrect data.
>
> The "dirty read" method, on the other hand, gives you the current values,
> believing that they will be committed in a moment. So you get 1/1000
> chance
> to get wrong data.
>
> Which odds will you bet on?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, October 29, 2002 2:18 PM
>
>
> List,
> I'm always keen to refresh on database comparisons so thanks for
> everyone's pointers.
>
> I'm surprised Oracle doesn't make more of an issue about their locking and
> concurrency methods (i.e. redo/rollback/undo).
>
> MSSQL seems to deal with it in two ways:
> Default: readers and writers prevent writers from accessing data until
> they
> are finished with it!
> Other method: no control, you just get dirty reads!
>
> Anyone got anything to add to this? Or am I wrong?
>
> - Mike.
>
>
> -Original Message-
> Sent: 24 October 2002 17:29
> To: Multiple recipients of list ORACLE-L
>
>
> As I said, use mssql ONLY if your boss is willing to be strapped into a
> MicroSlop only platform.  If he's even remotely thinking of using a
> different OS
> then you can't use mssql.
>
> Dick Goulet
>
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   10/23/2002 11:48 PM
>
> goodmorning
> everybody who responded to my basic question : thanks
>
> summary
>
> professional : use oracle enterprise edition
> semi professional : use oracle standard edition / mssql enterprise edition
> in all other cases mssql standard edition
>
>
>
> > -Oorspronkelijk bericht-
> > Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> > Verzonden:woensdag 23 oktober 2002 20:51
> > Aan:  Multiple recipients of list ORACLE-L
> > Onderwerp:RE: oracle or mssql
> >
> > Xenix is history now...SCO itself stopped it sometime in 1990
> >
> >
> >
> >
> >
> >
> > Reply-To: [EMAIL PROTECTED]
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: Wed, 23 Oct 2002 09:02:19 -0800
> >
> > XENIX maybe.
> >
> > : )
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > Technology Services| Services technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO  | Région des Maritimes, MPO
> >
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >
> >
> > -Original Message-
> > Sent: Wednesday, October 23, 2002 12:59 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Is MSSQL server availab

Re: oracle or mssql

[Yechiel Adar]

That was exactly my point.

It is NOT 6 of one , half dozen of the other.

You commit 1000's of times for each rollback.
So the data you read is incorrect while you read it with enormous odds that
the changes will be committed.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 8:09 PM


But Yechiel,

what is better?  Getting data that has not been committed by the
application, or data that has been updated by an application without a
commit being issued?

In the mssql option, do you really want to return data as valid, taking the
chance that the person who updated the record may issue a "rollback"?

I think it's 6 of one, half a dozen of the other.  At least with Oracle,
it's logical and under the applications control.  If the user issues a
commit, then the new data is available for query.  If the application needs
the data commited more frequently, then issuing commits more often is
certainly available.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, October 30, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L


I would like to point out that what you call "dirty reads" are mostly
the correct reads. Oracle method IS the dirty read.

I am sure that your users does at least 1000 commits to every rollback.
So when oracle gives you the data it already knows that this data is
wrong. If you do the query again a minute later you will get new results
that were available when you did the original query but were committed
later. So you get a 1000/1 chance to get incorrect data.

The "dirty read" method, on the other hand, gives you the current values,
believing that they will be committed in a moment. So you get 1/1000 chance
to get wrong data.

Which odds will you bet on?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM


List,
I'm always keen to refresh on database comparisons so thanks for
everyone's pointers.

I'm surprised Oracle doesn't make more of an issue about their locking and
concurrency methods (i.e. redo/rollback/undo).

MSSQL seems to deal with it in two ways:
Default: readers and writers prevent writers from accessing data until they
are finished with it!
Other method: no control, you just get dirty reads!

Anyone got anything to add to this? Or am I wrong?

- Mike.


-Original Message-
Sent: 24 October 2002 17:29
To: Multiple recipients of list ORACLE-L


As I said, use mssql ONLY if your boss is willing to be strapped into a
MicroSlop only platform.  If he's even remotely thinking of using a
different OS
then you can't use mssql.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/23/2002 11:48 PM

goodmorning
everybody who responded to my basic question : thanks

summary

professional : use oracle enterprise edition
semi professional : use oracle standard edition / mssql enterprise edition
in all other cases mssql standard edition



> -Oorspronkelijk bericht-
> Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>
> Xenix is history now...SCO itself stopped it sometime in 1990
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 23 Oct 2002 09:02:19 -0800
>
> XENIX maybe.
>
> : )
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
>
> E-Mail: [EMAIL PROTECTED]
>
>
>
>
> -Original Message-
> Sent: Wednesday, October 23, 2002 12:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Is MSSQL server available on UNIX?
>
> -Rachna
> --
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
> _
> Get faster connections -- switch to MSN Internet Access!
> http://resourcecenter.msn.com/access/plans/default.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.

RE: RE: oracle or mssql

[Jack van Zanen]

My limited knowledge of MySQL had me testing this once, and yes AFAIK it is

Jack

-Original Message-
Sent: Thursday, October 31, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L



But this default mssql behaviour is the performance 'gotcha' where readers
block writers and writers block readers isn't it?


Mike.

-Original Message-
Sent: 31 October 2002 09:12
To: Multiple recipients of list ORACLE-L


'Dirty reads' in SQL Server means that you can view records that have not
been committed. This is implemented by setting the TRANSACTION ISOLATION
LEVEL to READ UNCOMMITTED.

This is not default behaviour in SQL Server, the default TIL is READ
COMMITTED (for very good reason). I can think of very few situations where
you would want to see uncommitted records.

Dirty blocks in SQL Server/Oracle are the same thing ie. a block/page in
cache that has been changed but not flushed to disk.

Ade

-Original Message-
Sent: 30 October 2002 18:43
To: Multiple recipients of list ORACLE-L


It sounds like he is saying that, once an "insert, update or delete"
statement has been issued (without a following commit), then the records
acted upon are now considered "dirty" - i.e. needing writing to disk.

this is, of course, NOT what Oracle considers a dirty block.

I agree with you, Jared!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, October 30, 2002 1:21 PM
To: Multiple recipients of list ORACLE-L


At least one of us has the incorrect understanding of 'dirty' reads,
or I am taking you too literally, or something.

What are you really saying? 

Oracle does not allow dirty reads.

All queries are consistent to a point in time, the beginning
of a transaction, whether implicit (select) or explicit ( start 
transaction ).

SQL Server and Sybase do not guarantee this.

The 'dirty' reads you are speaking of sound more to me
like sloppy programming.

Is that what you're referring to?

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/30/2002 08:54 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: RE: oracle or mssql


I would like to point out that what you call "dirty reads" are mostly
the correct reads. Oracle method IS the dirty read.

I am sure that your users does at least 1000 commits to every rollback.
So when oracle gives you the data it already knows that this data is
wrong. If you do the query again a minute later you will get new results
that were available when you did the original query but were committed
later. So you get a 1000/1 chance to get incorrect data.

The "dirty read" method, on the other hand, gives you the current values,
believing that they will be committed in a moment. So you get 1/1000 
chance
to get wrong data.

Which odds will you bet on?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM


List,
I'm always keen to refresh on database comparisons so thanks for
everyone's pointers.

I'm surprised Oracle doesn't make more of an issue about their locking and
concurrency methods (i.e. redo/rollback/undo).

MSSQL seems to deal with it in two ways:
Default: readers and writers prevent writers from accessing data until 
they
are finished with it!
Other method: no control, you just get dirty reads!

Anyone got anything to add to this? Or am I wrong?

- Mike.


-Original Message-
Sent: 24 October 2002 17:29
To: Multiple recipients of list ORACLE-L


As I said, use mssql ONLY if your boss is willing to be strapped into a
MicroSlop only platform.  If he's even remotely thinking of using a
different OS
then you can't use mssql.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/23/2002 11:48 PM

goodmorning
everybody who responded to my basic question : thanks

summary

professional : use oracle enterprise edition
semi professional : use oracle standard edition / mssql enterprise edition
in all other cases mssql standard edition



> -Oorspronkelijk bericht-
> Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 

RE: RE: oracle or mssql

[Adrian Roe]

I don't see it as a gotcha, I've worked with SQL Server for almost 6 years
on some pretty big databases and have never had a problem.

At the end of the day, locking is at the row level, locks are held for a
very short time (unless developers don't know what they are doing). A read
will take a shared row level lock for a sub-second period of time
(potentially), if your update is blocked for 0.2 seconds are you going to
notice ? You have to realise that with row level locking the scope for
blocking is minimal.

Ade

-Original Message-
Sent: 31 October 2002 14:04
To: Multiple recipients of list ORACLE-L



But this default mssql behaviour is the performance 'gotcha' where readers
block writers and writers block readers isn't it?


Mike.

-Original Message-
Sent: 31 October 2002 09:12
To: Multiple recipients of list ORACLE-L


'Dirty reads' in SQL Server means that you can view records that have not
been committed. This is implemented by setting the TRANSACTION ISOLATION
LEVEL to READ UNCOMMITTED.

This is not default behaviour in SQL Server, the default TIL is READ
COMMITTED (for very good reason). I can think of very few situations where
you would want to see uncommitted records.

Dirty blocks in SQL Server/Oracle are the same thing ie. a block/page in
cache that has been changed but not flushed to disk.

Ade

-Original Message-
Sent: 30 October 2002 18:43
To: Multiple recipients of list ORACLE-L


It sounds like he is saying that, once an "insert, update or delete"
statement has been issued (without a following commit), then the records
acted upon are now considered "dirty" - i.e. needing writing to disk.

this is, of course, NOT what Oracle considers a dirty block.

I agree with you, Jared!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, October 30, 2002 1:21 PM
To: Multiple recipients of list ORACLE-L


At least one of us has the incorrect understanding of 'dirty' reads,
or I am taking you too literally, or something.

What are you really saying? 

Oracle does not allow dirty reads.

All queries are consistent to a point in time, the beginning
of a transaction, whether implicit (select) or explicit ( start 
transaction ).

SQL Server and Sybase do not guarantee this.

The 'dirty' reads you are speaking of sound more to me
like sloppy programming.

Is that what you're referring to?

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/30/2002 08:54 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: RE: oracle or mssql


I would like to point out that what you call "dirty reads" are mostly
the correct reads. Oracle method IS the dirty read.

I am sure that your users does at least 1000 commits to every rollback.
So when oracle gives you the data it already knows that this data is
wrong. If you do the query again a minute later you will get new results
that were available when you did the original query but were committed
later. So you get a 1000/1 chance to get incorrect data.

The "dirty read" method, on the other hand, gives you the current values,
believing that they will be committed in a moment. So you get 1/1000 
chance
to get wrong data.

Which odds will you bet on?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM


List,
I'm always keen to refresh on database comparisons so thanks for
everyone's pointers.

I'm surprised Oracle doesn't make more of an issue about their locking and
concurrency methods (i.e. redo/rollback/undo).

MSSQL seems to deal with it in two ways:
Default: readers and writers prevent writers from accessing data until 
they
are finished with it!
Other method: no control, you just get dirty reads!

Anyone got anything to add to this? Or am I wrong?

- Mike.


-Original Message-
Sent: 24 October 2002 17:29
To: Multiple recipients of list ORACLE-L


As I said, use mssql ONLY if your boss is willing to be strapped into a
MicroSlop only platform.  If he's even remotely thinking of using a
different OS
then you can't use mssql.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/23/2002 11:48 PM

goodmorning
everybody who responded to my basic question : thanks

summary

professional : use oracle enterprise edition
semi professional : use oracle standard edition / mssql enterprise edition
in all other cases mssql standard edition



> -Oorspronkelijk bericht-
> Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, 

RE: LONG size -- set in database?

[Gogala, Mladen]

Try with JDBC. It can retrieve chunks. The call to facilitate 
that is "getBinaryStream". J2EE can do anything that .net can
and faster. Plus, you get portability to other environments.
Just say no to Microsoft.

> -Original Message-
> From: Mike Sardina [mailto:cemail2@;sprintmail.com]
> Sent: Wednesday, October 30, 2002 8:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: LONG size -- set in database?
> 
> 
> Is there any way to set the LONG chunk size on the database 
> for all queries?
> 
> The "set long " command works fine in SQL Plus to set the 
> chunk size of LONG
> but when .NET pulls info, it doesn't work.  Is there was a 
> way to set it on
> the database side so that it would work regardless of how the 
> database is
> being connected too.  Any ideas?
>  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mike Sardin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Design: unique PK across all tables

[Rachel Carmichael]

we are doing this, but using a sequence so we don't have the table
access contention.

seems to me the bigger problem is "why are they trying to put
additional meaning into the PK?"


--- Brian P Andrews <[EMAIL PROTECTED]> wrote:
>   Our developers are proposing a database design for an OLTP
> application in
> which each table has a PK of the same type and size.  In addition,
> each possible
> PK value can belong to at most one table.
> 
>   Each table insert would require a call to the a single function to
> get the
> next PK value and an additional table would be used to store the
> current set of
> values.  (The developers want to put some additional meaning into a
> PK value and
> a sequence would not be sufficient, hence the need for the PK
> generating
> function and current value table).
> 
>   I've never seen this done before and I would think this application
> would
> suffer greatly from contention when performing a large number of
> concurrent
> inserts.
> 
>   Has anyone ever encountered a design like this?  Is this a bad
> design?
> 
>   Thanks.
> 
> Brian
> 


__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Database design, replacing null by a default value

[paquette stephane]

Hi,

We're in the process of writing functionnal specs for
a system which is like a DW but instead of a DW the
staging area push the data in Siebel.

If we replaced null by something else. 
What would you choose :
   for a varchar field ?
   for a numeric field ?

Someone has proposed blanks for the character field
but I'm not comfortable with that.

TIA

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).