Can any one tell me how can i read parameter info from RDF(Reports definition file)

[Muhammad Tariq]

Can any one tell me how can i read parameter info 
from RDF(Reports definition file)
 
 

Re: Relation Between Oracle Sessions

[Justin Cave]

At 10:08 PM 11/4/2002, you wrote:


Whenever a form is opened, it opens an Oracle session (can be seen from 
v$session). Now when we call another form from this opened form, (call 
form property of forms), it will open another session. If we consider the 
main form as the parent form and the form called from within it as its 
child form, then, IS there a way to know, from some view or else, that 
session of this newly opened form is the child of which parent session, 
their relationship basically?

I believe the simple answer here is "no".  If your application is opening 
multiple sessions, each session is logically independent of the other-- 
Oracle has no concept of "parent" or "child" sessions.  I would generally 
take this sort of behavior to indicate a bug in your application-- 
generally one wants to reuse connections across multiple forms so that each 
form doesn't have the overhead of opening a new connection to the database.


Justin Cave
Distributed Database Consulting

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

SET ORACLE-L NOMAIL

[pradeep]

SET ORACLE-L NOMAIL

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

Relation Between Oracle Sessions

[Hussain Ahmed Qadri]

Title: Relation Between Oracle Sessions





Hi all,
A question related to Developer but involves forming sessions at the backend, so would appreciate any help or ideas.


Whenever a form is opened, it opens an Oracle session (can be seen from v$session). Now when we call another form from this opened form, (call form property of forms), it will open another session. If we consider the main form as the parent form and the form called from within it as its child form, then, IS there a way to know, from some view or else, that session of this newly opened form is the child of which parent session, their relationship basically?

Thanks in advance


Hussain Ahmed Qadri
DBA SKMCH&RC
Pakistan

Re: Question on in-doubt transaction

[David Davis]

Check out the documentation for the dbms_transaction package. I have used it 
previously (dbms_transaction.purge_lost_db_entry). In my case, the cause was 
due to a problem in SQL Server (DTS process).

See Docids on Metalink:

67590.1 - PROCEDURE:DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY
100664.1 - How to Troubleshoot Distributed Transactions

Good Luck.



From: "Mandal, Ashoke" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Question on in-doubt transaction
Date: Mon, 04 Nov 2002 09:54:14 -0800

Greetings All,

We have a stand alone database on a Windows-NT box. As far as I understand 
from the users of this database that this is not in distributed 
environment.

But there is one in-doubt transaction in this database and if users try to 
work in this database the response is very slow due to this in-doubt 
transaction.

We bounced the database. Restarted the service but in-doubt transaction is 
still sitting there from Feb 2002.

We could see this transaction in DBA Studio also.

How to clean this transaction?

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


_
Choose an Internet access plan right for you -- try MSN! 
http://resourcecenter.msn.com/access/plans/default.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: Re Raid 5+

[John Kanagaraj]

Yechiel,

Just to add to Jared's note, RAID5 does a _lot_ more during a write. It has
to perform what is known as the 'read-modify-write' cycle, where it has to
first read the existing parity for the data that is being written. This is
an I/O to _all_ the disks involved. It then has to calculate the parity
which ties up CPU, and although it can be aurgued that this is done at the
SAN level or controller level, the fact remains that additional work is
involved. Finally, the newly calculated parity has to be written to all the
disks involved. In other words, writes consume a lot more bandwidth on RAID5
as compared to RAID1 for the same amount of useful work.

This is not well documented and manufacturers hide this piece of work behind
larger and larger caches. This is Ok for a small amount of writes, but
following Tim's excellent explanation about pipes, you will face this soon
if you flood your cache and your I/O subsystem. Needless to say, all
manufacturer's claims are based on small writes that are not sustained and
never stress the cache.

On the other hand, I have seen that if I can split the redo, SYSTEM, RBS and
TEMP and other hot datafiles away onto RAID 1 disks, I _can_ live with a
combination of RAID 1 and RAID 5 on a wellconfigured SAN. I have been
successful with a few clients with this method when Cost has been a factor
as far as disks/space go. I had to argue for this, but the client was able
to see benefits that I was able to promise. 

Shalom!
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: Jared Still [mailto:jkstill@;cybcon.com]
> Sent: Sunday, November 03, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Re Raid 5+
> 
> 
> 
> Yechial,
> 
> > You have 12 disks. In raid 0+1 you use striping across 6 volumes.
> > In raid 5 you strip across 11 disks, so you get almost 
> double the work
> 
> They didn't tell you everything they know about RAID 0+1.
> 
> The disks may be striped into 6 logical disks, and they are
> written to as 6 logical disks, but when reading, all 12 disks
> are read from independentantly.
> 
> So a RAID 5 is not actually doing more work a READ.
> 
> But during a write, it's doing quite a bit more than RAID 0+1.
> 
> > without returning and moving the r/w head on the same disk.
> 
> Maybe if there is one user on the system, doing 1 read. Multiuser
> IO systems don't serialize the IO, at least not to the extent that
> the single user scenario requires.  This is much like reorging a table
> so that all data is in a 'contiguous' space.  It's an 
> illusion, it doesn't
> really work that way.
> 
> Jared
> 
> 
> 
> On Sunday 03 November 2002 08:03, Yechiel Adar wrote:
> > Hello Ian
> >
> > I heard a lecture on raid 5 disks a few weeks ago.
> > The rational behind read 5 being faster then raid 0+1 is this:
> > You have 12 disks. In raid 0+1 you use striping across 6 volumes.
> > In raid 5 you strip across 11 disks, so you get almost 
> double the work
> > without returning and moving the r/w head on the same disk.
> >
> > Yechiel Adar
> > Mehish
> >   - Original Message -
> >   From: MacGregor, Ian A.
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Friday, November 01, 2002 2:48 AM
> >   Subject: RE: Re Raid 5+
> >
> >
> >   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:john.hallas@;hcresources.co.uk]
> > Sent: Thursday, October 31, 2002 12: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 fo

RE: Re: Reporting - Casting about for ideas

[Jared . Still]

Well, yes, I am seriously considering that.

Not that I mind doing it, just not sure I have the time.

Jared






DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 02:23 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Re: Reporting - Casting about for ideas


Jared - I think I steered you wrong. Apparently Actuate is even costlier.
Gee, maybe you could whip something up in Perl. Do it on your own time so
you can marked it later.

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


-Original Message-
Sent: Monday, November 04, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L


For those that may be curious, I found the BMC software
that Yechial referred to.  Price for 250 users: $60k US.

Plus consulting $$$. 

Fairly expensive, I would say.

Jared





"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

RE: Re: Reporting - Casting about for ideas

[DENNIS WILLIAMS]

Oops, I meant so you could MARKET it later.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 04, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L


Jared - I think I steered you wrong. Apparently Actuate is even costlier.
Gee, maybe you could whip something up in Perl. Do it on your own time so
you can marked it later.

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


-Original Message-
Sent: Monday, November 04, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L


For those that may be curious, I found the BMC software
that Yechial referred to.  Price for 250 users: $60k US.

Plus consulting $$$. 

Fairly expensive, I would say.

Jared





"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

RE: Re: Reporting - Casting about for ideas

[DENNIS WILLIAMS]

Jared - I think I steered you wrong. Apparently Actuate is even costlier.
Gee, maybe you could whip something up in Perl. Do it on your own time so
you can marked it later.

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


-Original Message-
Sent: Monday, November 04, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L


For those that may be curious, I found the BMC software
that Yechial referred to.  Price for 250 users: $60k US.

Plus consulting $$$. 

Fairly expensive, I would say.

Jared





"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

[John Kanagaraj]

Hi Mike,

> Your article was very good in describing RBO vs. CBO. I hope 
> you don't mind
> me using it to help better describe why we're switching from 
> RBO to CBO to
> my team.

I forgot to mention this before, but you should also look at Tim Gorman's
excellent paper on the CBO at http://www.evdbt.com - search in the library.
 
> On the other hand it didn't help me much in practical use of ALL_ROWS
> (CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the
> paper.

Yes, but we can always discuss this here in the list :) The problem I have
with the FIRST_ROWS is that _all_ queries would default to use this mode.
While this may be good for a specific interactive query, it certainly would
perform poorly for batch jobs, more so when the table joins larger tables.
IMHO, you are better off leaving it to default to CHOOSE and control
specific modes. This can be done via a variety of methods, including login
triggers, Outlines, anf finally the code itself.
 
> Note: When leaving your web page I was notified that my IP address was
> captured. I didn't like that.

My web page is served by Yahoo! Geocities, and I obtained that when it was
free (and still is free). I suppose that they capture some info and do
manipulate cookies. This is the first time, though that I have come across
such a message. I will need to investigate further...

Hth,
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 **
-- 
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: What's your opinion: ALL_ROWS vs. FIRST_ROWS

[DENNIS WILLIAMS]

Michael - In Oracle9i it goes even further. Now there is FIRST_ROWS_1,
FIRST_ROWS_10, and on up to _1000. Just thought you might want to take that
in consideration.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, November 04, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


John,

Your article was very good in describing RBO vs. CBO. I hope you don't mind
me using it to help better describe why we're switching from RBO to CBO to
my team.

On the other hand it didn't help me much in practical use of ALL_ROWS
(CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the
paper.

Note: When leaving your web page I was notified that my IP address was
captured. I didn't like that.

Michael Armstead
Principal Database Administrator, OCP-Certified
World Wide Corporate IT Database Administration
GlaxoSmithKline

> -Original Message-
> From: John Kanagaraj [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 31, 2002 12:54 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: What's your opinion: ALL_ROWS vs FIRST_ROWS
> 
> 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).

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

RE: Database Design: unique PK across all tables

[MacGregor, Ian A.]

If the application were to use a table-driven sequence; i.e., " select max(keynum) +1  
from sequence_table;" then it would indeed be database neutral; however, as you 
stated, that technique does not scale.  Oracle sequences; i.e., those employing 
sequence.nextval, are an Oracle construct and are not database neutral.

SYS_GUID is not database neutral either.  A sequence generating the primary keys for 
all pertinent tables in the database is probably better than using sys_guid.  The 
latter would be used when you want to guarantee uniqueness  not only within a 
database, but between databases as well.

If you really need database neutrality, do a  google search on "uuidgen".  I presume 
this is the program upon which sys_guid is based.  It's available for nearly all *NIX 
flavors.  I'm not condoning its use, just letting you know that it's available.  We 
have one system which uses uuidgen here, much to my dismay.   

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, November 04, 2002 5:34 AM
To: Multiple recipients of list ORACLE-L


Thanks everyone.

We're going forth with using a single sequence w/o any additional "meaning" put into 
the PK.

Ian's recommendation of using the sys_guid function would be ideal, however, we are 
trying to remain database neutral at this point.


[EMAIL PROTECTED] wrote:

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

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

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

[Jesse, Rich]

H.  I had no such message using Opera 6.05 with Java/JS/Cookies off.

Although, by default, IP logging is on for many webservers, so just about
anywhere you surf to has "captured" your IP.  Probably one reason more why
we have a proxy server here at work.

Rich


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

> -Original Message-
> From: Armstead, Michael A [mailto:maa25681@;GlaxoWellcome.com]
> Sent: Monday, November 04, 2002 1:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS
> 
> 
> Note: When leaving your web page I was notified that my IP address was
> captured. I didn't like that.
> 
> Michael Armstead  
-- 
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: Moving datafiles, controlfiles, and redos.

[Stephen Lee]

If you are, in fact, moving the files to different file systems:

Change the location of the control files in the init.ora.

Startup mount.
alter database rename file '/from/where/it/was' to '/where/it/is/now';
etc.
etc.

alter database open;
-- 
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: Re: Reporting - Casting about for ideas

[Jared . Still]

For those that may be curious, I found the BMC software
that Yechial referred to.  Price for 250 users: $60k US.

Plus consulting $$$. 

Fairly expensive, I would say.

Jared





"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

RE: Red Hat or Suse

[Gogala, Mladen]

so, now you want to date Mr. Gates? I think he's married.

> -Original Message-
> From: Mike Killough [mailto:mwkillough@;hotmail.com]
> Sent: Monday, November 04, 2002 12:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Red Hat or Suse
> 
> 
> Me too. She was unstable.
> 
> 
> 
> 
> 
> 
> >From: "Farnsworth, Dave" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Red Hat or Suse
> >Date: Mon, 04 Nov 2002 08:45:06 -0800
> >
> >I think I used to date Suse.
> >
> >-Original Message-
> >Sent: Monday, November 04, 2002 10:14 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hmmm, I'm using SuSE on my servers more than 3 years
> >and I've never used kernel from distribution and I hope 
> nobody is using
> >standard kernel on server. (SuSE standard kernel doesn't 
> know ServerWorks
> >chipset).
> >Software location in SuSE is very orderly organized, but 
> other than in RH.
> >I don't think this the way they urge you to use only SuSE.
> >SuSE helpdesk is usable only if you need "shit of the day". 
> But it is the 
> >same
> >with RedHat, Microsoft, Oracle, IBM etc.
> >
> >But, I think, SuSE have closed the US office.
> >
> >JP
> >
> >On Monday 04 November 2002 15:38, you wrote:
> > > There was a little squabble when RH tried promoting 
> Postgres (a.k.a "Red
> > > Hat database")
> > > but after a retaliation from Oracle,  Red Hat came to its 
> senses. Suse 
> >was
> > > merely a tool
> > > in this squabble. It isn't big enough, software 
> availability is so much
> > > worse then for RH and
> > > they are trying to lock people in SuSE distribution by 
> putting software 
> >in
> > > unusual places.
> > > Relinking SuSE kernel was practically impossible, because 
> of  unexpected
> > > dependencies
> > > and kernel not returning the proper version string so 
> that OSS was 
> >unable
> > > to recognize it.
> > > Need I say that SuSE Helpdesk was less then helpful? I ended up 
> >downloading
> > > the
> > > regular kernel from ftp://ftp.kernel.org   
> >compiling
> > > it and ditching the SuSE kernel altogether.
> > > For Thanksgiving, I'll go back to RH, now that they are 
> using standard 
> >GNU
> > > CC again.
> > >
> > > -Original Message-
> > > Sent: Monday, November 04, 2002 3:29 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > I heard that Oracle is shifting it's priorities from Suse 
> toward Red 
> >Hat.
> > >
> > > Yechiel Adar
> > > Mehish
> > >
> > > - Original Message -
> > > To: Multiple   recipients of 
> list ORACLE-L
> > > Sent: Thursday, October 31, 2002 5:53 PM
> > >
> > >
> > > 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) ?
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jan Pruner
> >   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: Farnsworth, Dave
> >   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).
> 
> 
> _
> 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: Mike Killough
>   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
> th

RE: Re: Reporting - Casting about for ideas

[DENNIS WILLIAMS]

Jared - My company has had good luck with Actuate.
http://www.actuate.com/products/server/index.asp
It is reasonably flexible in serving HTML or text reports to users via a Web
interface. It can also create the reports via SQL queries. You can manage
which users can access which reports, and can even define security by page
of the report. That is about all I know off the top of my head. They
converted from Crystal Reports. I don't know what the price was but I didn't
hear much griping which I would interpret as not being very expensive. I
work with a developer that uses it, creating views for it and that sort of
thing. If you have more questions I can ask him.

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


-Original Message-
Sent: Monday, November 04, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


Yechiel,

Thanks for the info.  I'll see if I can find it on the BMC website.

Though the fact that it's from BMC probably rules out 'inexpensive'.

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

Oracle 817 on Solaris 2.6 moving to Solaris 8

[Godlewski, Melissa]

Title: Oracle 817 on Solaris 2.6 moving to  Solaris 8





OS upgrade relink all?


We are actually moving from one physical machine to another, but in reality we are just doing and OS upgrade from Sun Solaris 2.6 to Sun Solaris 8.  My idea is to just backup the database and restore to the new machine.  Relink all the oracle executables, and I'm back up and running.  Did I miss/forget something in here?

TIA
MCG

RE: Re Raid 5+

[Markham, Richard]

Title: RE: Re Raid 5+





Jared 


raid 5 is good over a single disk for the read speed and the fact
you can rebuild if a disk is lost.  A raid 5 write includes the
additional overhead of calculating parity, no question about it.
My raid 1+0 spindles are faster than my raid 5 when it comes to 
writes.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 04, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re Raid 5+



>> I cannot fathom Raid 5 being faster than Raid 1 for writes. 
 
>Well in sequential writes like redo log, copy redo log to archive log and 
many other cases raid 5 will be faster.


Care to explain how RAID5 will be faster for a redo log write, because I
don't have that understanding of it.


If I'm wrong, I welcome the correction. 


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: Partition Question

[Don Jerman]

It depends on your reason for partitioning -- if you mean to drop a partition in
the future (to roll off the 1999 data or whatever) then the ID range is
potentially a valid approach, as long as ID is serial.  If you just want to put
chunks on different disk volumes, you could use the type or even a hash
partitioning scheme.  It's down to what you're trying to accomplish, and what is
good for one partition key is probably bad or neutral for the other.


Hamid Alavi wrote:

> Hi List,
>
> I have a question regarding partitioning: If I want to partition a table
> which strategy is better, like do i have to use a value which from first day
> of using this table all those partion is using or just using first partion,
> then second etc.
> E.G:
> If I do partion tableA based on ID range 1000, so for few month the only
> first partion of this table will be used then second partion, but if I
> partion it on Type (1,2,3,4,5) any record can be any of these type and from
> first day all of the partions will be used.
> Just want to check with you guys which way is better for performance?
> THanks for HELP>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 416-5095
>
> === Confidentiality Statement ===
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law.  If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information.  Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> = End Confidentiality Statement =
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   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

MTS process HIGH CPU

[Seema Singh]

Hi
I am using MTS in 8.1.6.I am wondering one of MTS process is locked 2 table 
since morning and this process is taking more CPU.Can I kill that process 
like "ora_s000_prod" by using alter system and then unix kill command?
Thx
-Seema






_
Choose an Internet access plan right for you -- try MSN! 
http://resourcecenter.msn.com/access/plans/default.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).

RE: Moving datafiles, controlfiles, and redos.

[Fink, Dan]

TIA - 
Thanks In Advance...
What 
is the 'ned of the message'

  -Original Message-From: Paulo Gomes 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, November 04, 2002 10:49 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Moving datafiles, controlfiles, and redos.
  sorry what is that TIA thing on the ned of the 
  message
   
  
-Original Message-From: Gabriel Aragon 
[mailto:[EMAIL PROTECTED]]Sent: segunda-feira, 4 de Novembro 
de 2002 17:04To: Multiple recipients of list 
ORACLE-LSubject: Moving datafiles, controlfiles, and 
redos.
Hi Gurus, 
Oracle 8.0.6 and SunOS 5.7 using and A1000 disk array to store instance 
files, datafiles, controlfiles, redos.. (not Oracle Product Files).
We are increasing disk space in the A1000 (RAid 0+1), so we need to 
backup and destroy the informacion, install new ones and restore the 
information and make the configuration to recognize the new file 
allocations.
I'm planning hotbackup previous to the shutdown and then a coldbackup, 
and complete server backup. Install the disks, create the File Systems and 
recover the info.
My question is, what do I need to do, after moving all the files, 
datafiles, controlfiles and redos.. to make the instance recognize the new 
file allocations?
Any advice is welcome. TIA
Gabriel"Any dream worth having is a dream worth fighting 
for" (Cualquier sueño que valga la pena tener, es un sueño por el que vale 
la pena luchar) Charles Xavier 


Do you Yahoo!?HotJobs 
- Search new jobs daily now

RE: Moving datafiles, controlfiles, and redos.

[Scott Stefick]

(T)hanks (I)n (A)dvance


At 09:48 AM 11/4/02 -0800, you wrote:
sorry
what is that TIA thing on the ned of the message
 

-Original Message-
From: Gabriel Aragon
[mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 4 de Novembro de 2002 17:04
To: Multiple recipients of list ORACLE-L
Subject: Moving datafiles, controlfiles, and redos.


Hi Gurus, 


Oracle 8.0.6 and SunOS 5.7 using and A1000 disk array to store
instance files, datafiles, controlfiles, redos.. (not Oracle Product
Files).


We are increasing disk space in the A1000 (RAid 0+1), so we need to
backup and destroy the informacion, install new ones and restore the
information and make the configuration to recognize the new file
allocations.


I'm planning hotbackup previous to the shutdown and then a
coldbackup, and complete server backup. Install the disks, create the
File Systems and recover the info.


My question is, what do I need to do, after moving all the files,
datafiles, controlfiles and redos.. to make the instance recognize the
new file allocations?


Any advice is welcome. TIA


Gabriel




"Any dream worth having is a dream worth fighting for"
(Cualquier sueño que valga la pena tener, es un sueño por el que vale la
pena luchar) Charles Xavier 




Do you Yahoo!?
HotJobs
- Search new jobs daily now


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

[Armstead, Michael A]

John,

Your article was very good in describing RBO vs. CBO. I hope you don't mind
me using it to help better describe why we're switching from RBO to CBO to
my team.

On the other hand it didn't help me much in practical use of ALL_ROWS
(CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the
paper.

Note: When leaving your web page I was notified that my IP address was
captured. I didn't like that.

Michael Armstead
Principal Database Administrator, OCP-Certified
World Wide Corporate IT Database Administration
GlaxoSmithKline

> -Original Message-
> From: John Kanagaraj [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 31, 2002 12:54 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: What's your opinion: ALL_ROWS vs FIRST_ROWS
> 
> 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).

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

Re: Re Raid 5+

[Jared . Still]

>> I cannot fathom Raid 5 being faster than Raid 1 for writes. 
 
>Well in sequential writes like redo log, copy redo log to archive log and 
many other cases raid 5 will be faster.

Care to explain how RAID5 will be faster for a redo log write, because I
don't have that understanding of it.

If I'm wrong, I welcome the correction. 

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: Re: Reporting - Casting about for ideas

[Jared . Still]

Yechiel,

Thanks for the info.  I'll see if I can find it on the BMC website.

Though the fact that it's from BMC probably rules out 'inexpensive'.

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/04/2002 12:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Re: Reporting - Casting about for ideas


Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that 
does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

Question on in-doubt transaction

[Mandal, Ashoke]

Greetings All,

We have a stand alone database on a Windows-NT box. As far as I understand from the 
users of this database that this is not in distributed environment.

But there is one in-doubt transaction in this database and if users try to work in 
this database the response is very slow due to this in-doubt transaction.

We bounced the database. Restarted the service but in-doubt transaction is still 
sitting there from Feb 2002.

We could see this transaction in DBA Studio also.

How to clean this transaction?

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

[Lyndon Tiu]

I have no choice but to use stock kernels in my production servers.  I have
general purpose servers and you never know what or when you need to plug in new
hardware or peripherals. It's a pain if you need to recompile the kernel
everytime you plug in a new peripheral. The only time I need to compile is when
I need a module for a piece of hardware not supported by the stock kernel, even
then, I only compile the module but leave the kernel itself untouched.

Now, I just realized this is an Oracle email list. Sure looks like a LUG email list.

-- 
Lyndon Tiu


Quoting Jan Pruner <[EMAIL PROTECTED]>:

> Hmmm, I'm using SuSE on my servers more than 3 years 
> and I've never used kernel from distribution and I hope nobody is using 
> standard kernel on server.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  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: Moving datafiles, controlfiles, and redos.

[Paulo Gomes]

sorry 
what is that TIA thing on the ned of the message
 

  -Original Message-From: Gabriel Aragon 
  [mailto:[EMAIL PROTECTED]]Sent: segunda-feira, 4 de Novembro de 
  2002 17:04To: Multiple recipients of list 
  ORACLE-LSubject: Moving datafiles, controlfiles, and 
  redos.
  Hi Gurus, 
  Oracle 8.0.6 and SunOS 5.7 using and A1000 disk array to store instance 
  files, datafiles, controlfiles, redos.. (not Oracle Product Files).
  We are increasing disk space in the A1000 (RAid 0+1), so we need to backup 
  and destroy the informacion, install new ones and restore the information and 
  make the configuration to recognize the new file allocations.
  I'm planning hotbackup previous to the shutdown and then a coldbackup, and 
  complete server backup. Install the disks, create the File Systems and recover 
  the info.
  My question is, what do I need to do, after moving all the files, 
  datafiles, controlfiles and redos.. to make the instance recognize the new 
  file allocations?
  Any advice is welcome. TIA
  Gabriel"Any dream worth having is a dream worth fighting 
  for" (Cualquier sueño que valga la pena tener, es un sueño por el que vale la 
  pena luchar) Charles Xavier
  
  
  Do you Yahoo!?HotJobs 
  - Search new jobs daily now

RE: N-tier data access and security

[DENNIS WILLIAMS]

Tracy
   We are wrestling with these issues. I certainly can't claim to be an
expert, although I certainly hope you receive some replies, but I can share
what I have learned in this area so far. I'm going to rephrase your
questions slightly so you can verify whether I've understood you.

1) Your second question first. I agree with Robert that you should consider
Oracle's Fine Grain Access Control and Application Context. This may mean
that you have separate usernames and maybe even separate schemas. We are
wrestling with that currently. The developers feel one big schema suits
them, but I'm wondering how we will be able to locate users. Given
geographic dispersal, giving each user their own username would be very
cumbersome. And by the way, Oracle9i has a way to get away from embedding
the password in the application code, at least the password for the role.

2) Should my SQL statements be in separate Java classes or scattered
throughout my Java? There are advantages and disadvantages to both:
  Advantages: Fits the O-O model.
- Access style will be more uniform.
- You will probably have a person or a small team that creates the
data access classes. Not all developers will need to be proficient in SQL.
- If you have other systems besides Oracle, like legacy systems,
then the data interfaces can shield the developers from the complexity of
accessing those systems.

  Disadvantages: You will not get the full power of the database. The O-O
model is distinctly different from the relational model. The tendency is to
modularize data access so that, for example, joins are performed in the
database itself.
- Individual developers won't need to learn SQL, but they will need
to learn the data interfaces that are built for them. Depending on your
development organization, they will need to request additional classes from
the database interface group. Or rather than wait, they may simply use the
interfaces that are currently available to them, which means they do the
join in Java.
- Another issue is referential integrity. Essentially the O-O model
doesn't consider RI, but we database people don't like to see it left out
for many reasons. But by restricting the access to the O-O interfaces, RI
may be either ignored or at least slighted.

Whether you go as far as Robert is suggesting and move the business logic
itself into Oracle may depend to some extent on your development
organization. If your organization has pried the developers away from
Microsoft and they are irritated about not getting to learn .NET, then
suggesting PL/SQL may sound akin to proprietary. I haven't seen very much
interest in Java in Oracle recently even from Oracle. 
As to batch, my feeling is that there will be situations where
performance is a key issue that only PL/SQL will satisfy. However, again it
depends on how much commitment to PL/SQL your organization is willing to
make. Having a batch program run from the application server shouldn't be
too bad because the app server should have good bandwidth to Oracle.

I have been searching for some good information on this subject, but have
found very little. 

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


-Original Message-
Sent: Monday, November 04, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L


We are heading down the N-tier path, (browser, websphere app server, oracle
database).  What is the best method to setup this architecture for security
and
the logic?

1) Should the business logic be physically separate from the data access on
the
app server?  And if yes, where should the data access component reside?
(database or app server)  How does batch affect the decision?  What
variables
should we be considering when making this decision?

2) How should the database connection be established from the app server to
the
database?  Should it use a generic account on the app server with the
password
encrypted in a file?


In addition, does anybody have any good white papers or urls?  Thanks



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

RE: Red Hat or Suse

[Mike Killough]

Me too. She was unstable.







From: "Farnsworth, Dave" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Red Hat or Suse
Date: Mon, 04 Nov 2002 08:45:06 -0800

I think I used to date Suse.

-Original Message-
Sent: Monday, November 04, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Hmmm, I'm using SuSE on my servers more than 3 years
and I've never used kernel from distribution and I hope nobody is using
standard kernel on server. (SuSE standard kernel doesn't know ServerWorks
chipset).
Software location in SuSE is very orderly organized, but other than in RH.
I don't think this the way they urge you to use only SuSE.
SuSE helpdesk is usable only if you need "shit of the day". But it is the 
same
with RedHat, Microsoft, Oracle, IBM etc.

But, I think, SuSE have closed the US office.

JP

On Monday 04 November 2002 15:38, you wrote:
> There was a little squabble when RH tried promoting Postgres (a.k.a "Red
> Hat database")
> but after a retaliation from Oracle,  Red Hat came to its senses. Suse 
was
> merely a tool
> in this squabble. It isn't big enough, software availability is so much
> worse then for RH and
> they are trying to lock people in SuSE distribution by putting software 
in
> unusual places.
> Relinking SuSE kernel was practically impossible, because of  unexpected
> dependencies
> and kernel not returning the proper version string so that OSS was 
unable
> to recognize it.
> Need I say that SuSE Helpdesk was less then helpful? I ended up 
downloading
> the
> regular kernel from ftp://ftp.kernel.org   
compiling
> it and ditching the SuSE kernel altogether.
> For Thanksgiving, I'll go back to RH, now that they are using standard 
GNU
> CC again.
>
> -Original Message-
> Sent: Monday, November 04, 2002 3:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I heard that Oracle is shifting it's priorities from Suse toward Red 
Hat.
>
> Yechiel Adar
> Mehish
>
> - Original Message -
> To: Multiple   recipients of list ORACLE-L
> Sent: Thursday, October 31, 2002 5:53 PM
>
>
> 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) ?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
  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: Farnsworth, Dave
  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).


_
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: Mike Killough
 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).

Moving datafiles, controlfiles, and redos.

[Gabriel Aragon]

Hi Gurus, 
Oracle 8.0.6 and SunOS 5.7 using and A1000 disk array to store instance files, datafiles, controlfiles, redos.. (not Oracle Product Files).
We are increasing disk space in the A1000 (RAid 0+1), so we need to backup and destroy the informacion, install new ones and restore the information and make the configuration to recognize the new file allocations.
I'm planning hotbackup previous to the shutdown and then a coldbackup, and complete server backup. Install the disks, create the File Systems and recover the info.
My question is, what do I need to do, after moving all the files, datafiles, controlfiles and redos.. to make the instance recognize the new file allocations?
Any advice is welcome. TIA
Gabriel"Any dream worth having is a dream worth fighting for"
(Cualquier sueño que valga la pena tener, 
es un sueño por el que vale la pena luchar)

Charles XavierDo you Yahoo!?
HotJobs - Search new jobs daily now

RE: Red Hat or Suse

[Farnsworth, Dave]

I think I used to date Suse.

-Original Message-
Sent: Monday, November 04, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Hmmm, I'm using SuSE on my servers more than 3 years 
and I've never used kernel from distribution and I hope nobody is using 
standard kernel on server. (SuSE standard kernel doesn't know ServerWorks 
chipset).
Software location in SuSE is very orderly organized, but other than in RH. 
I don't think this the way they urge you to use only SuSE.
SuSE helpdesk is usable only if you need "shit of the day". But it is the same 
with RedHat, Microsoft, Oracle, IBM etc.
 
But, I think, SuSE have closed the US office.

JP

On Monday 04 November 2002 15:38, you wrote:
> There was a little squabble when RH tried promoting Postgres (a.k.a "Red
> Hat database")
> but after a retaliation from Oracle,  Red Hat came to its senses. Suse was
> merely a tool
> in this squabble. It isn't big enough, software availability is so much
> worse then for RH and
> they are trying to lock people in SuSE distribution by putting software in
> unusual places.
> Relinking SuSE kernel was practically impossible, because of  unexpected
> dependencies
> and kernel not returning the proper version string so that OSS was unable
> to recognize it.
> Need I say that SuSE Helpdesk was less then helpful? I ended up downloading
> the
> regular kernel from ftp://ftp.kernel.org   compiling
> it and ditching the SuSE kernel altogether.
> For Thanksgiving, I'll go back to RH, now that they are using standard GNU
> CC again.
>
> -Original Message-
> Sent: Monday, November 04, 2002 3:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I heard that Oracle is shifting it's priorities from Suse toward Red Hat.
>
> Yechiel Adar
> Mehish
>
> - Original Message -
> To: Multiple   recipients of list ORACLE-L
> Sent: Thursday, October 31, 2002 5:53 PM
>
>
> 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) ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  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: Farnsworth, Dave
  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).

Partition Question

[Hamid Alavi]

Hi List,

I have a question regarding partitioning: If I want to partition a table
which strategy is better, like do i have to use a value which from first day
of using this table all those partion is using or just using first partion,
then second etc.
E.G:
If I do partion tableA based on ID range 1000, so for few month the only
first partion of this table will be used then second partion, but if I
partion it on Type (1,2,3,4,5) any record can be any of these type and from
first day all of the partions will be used.
Just want to check with you guys which way is better for performance?
THanks for HELP>




Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

[Jesse, Rich]

I suppose it's way too late for this, but did you check to see if the shared
memory is still active using "ipcs -a"?  And if so, kill it with "ipcrm".
I've seen this before, but it was 7.x or 8.0 (I've got a good memory, but
it's short).

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

> -Original Message-
> From: Sinardy Xing [mailto:SinardyXing@;bkgcomsvc.com]
> Sent: Thursday, October 31, 2002 9:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Unkillable Background process "SHUTDOWN ABORT LEAVES
> UNKILLABLE
> 
> 
> 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
> 
-- 
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: dbms_lock.sleep irregularities

[Jared Still]

Too late, I'm done with it.  :)

Jared

On Sunday 03 November 2002 18:53, Babette Turner-Underwood wrote:
> One other suggestion 
>
> If you know what time you want to sleep until, why not just write the
> accu_sleep procedure to accept time to sleep and have it calculate how many
> chunks, etc it needs (rather than calculate seconds and then use the
> seconds)??
>
> - - - Psuedo code: - - -
> declare
>time_to_sleep_to date := trunc(sysdate) + 10/24;
> begin
>sleep_until (time_to_sleep_to);
> end;
> /
>
> and re-write accusleep (or encapsulate it into sleep_until)
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Friday, November 01, 2002 1:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> Here is a working version of accusleep if anyone
> is interested.  I ran a test to sleep for about
> 65 minutes, and the result was within 1 second
> of the target time.
>
> 08:56:25 rsysdevdb.radisys.com - jkstill@dv01 SQL> @accusleep
>
> Procedure created.
>
> 08:56:28 rsysdevdb.radisys.com - jkstill@dv01 SQL> @accutest
> 3809
>
> PL/SQL procedure successfully completed.
>
> 09:59:59 rsysdevdb.radisys.com - jkstill@dv01 SQL>
>
> Here is the procedure:
> --
> create or replace procedure accusleep ( seconds_in number )
> is
>v_chunk_size constant integer := 100;
>v_compensation constant number := 0.976;
>v_chunks integer;
>v_remainder integer;
>v_seconds integer;
> begin
>v_seconds := seconds_in * v_compensation;
>v_chunks := trunc(v_seconds/v_chunk_size);
>v_remainder := mod(v_seconds, v_chunk_size);
>
>for i in 1..v_chunks
>loop
>   dbms_lock.sleep(v_chunk_size);
>end loop;
>dbms_lock.sleep(v_remainder);
>
>--dbms_output.put_line(v_chunks);
>--dbms_output.put_line(v_remainder);
>
> end;
> /
> --
>
> Here is the test:
>
>
> 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);
>accusleep(seconds);
> end;
> /
>
>
> 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).

Re: Red Hat or Suse

[Jan Pruner]

Hmmm, I'm using SuSE on my servers more than 3 years 
and I've never used kernel from distribution and I hope nobody is using 
standard kernel on server. (SuSE standard kernel doesn't know ServerWorks 
chipset).
Software location in SuSE is very orderly organized, but other than in RH. 
I don't think this the way they urge you to use only SuSE.
SuSE helpdesk is usable only if you need "shit of the day". But it is the same 
with RedHat, Microsoft, Oracle, IBM etc.
 
But, I think, SuSE have closed the US office.

JP

On Monday 04 November 2002 15:38, you wrote:
> There was a little squabble when RH tried promoting Postgres (a.k.a "Red
> Hat database")
> but after a retaliation from Oracle,  Red Hat came to its senses. Suse was
> merely a tool
> in this squabble. It isn't big enough, software availability is so much
> worse then for RH and
> they are trying to lock people in SuSE distribution by putting software in
> unusual places.
> Relinking SuSE kernel was practically impossible, because of  unexpected
> dependencies
> and kernel not returning the proper version string so that OSS was unable
> to recognize it.
> Need I say that SuSE Helpdesk was less then helpful? I ended up downloading
> the
> regular kernel from ftp://ftp.kernel.org   compiling
> it and ditching the SuSE kernel altogether.
> For Thanksgiving, I'll go back to RH, now that they are using standard GNU
> CC again.
>
> -Original Message-
> Sent: Monday, November 04, 2002 3:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I heard that Oracle is shifting it's priorities from Suse toward Red Hat.
>
> Yechiel Adar
> Mehish
>
> - Original Message -
> To: Multiple   recipients of list ORACLE-L
> Sent: Thursday, October 31, 2002 5:53 PM
>
>
> 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) ?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
  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... bordering on OT

[Freeman, Robert]

Thats an idea... that I'm going to go eat with this crowd of folks tells you
just how much I think of them! :-) If even half of those who said they
are coming are there, it should be some party! :-)

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Monday, November 04, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L


Sounds like you guys need to get in touch with one of the tools vendors, and
give them a little sweet talk.. ;0)

With the brains that are going to be there, I'm sure some smart "Product
Manager" type would snap up the chance to get the majority of feedback from
the gurus on this list (tool related of course! ;P) - in return for the
price of a meal..

I'm just sorry that we can't get to the show! Next year maybe..

http://www.ioug.org/ioug_p/live_2003?v_nav=&v_text=LIVE_2003_EXHIBITION

Go get 'em! lol..

Mark

-Original Message-
Robert
Sent: 04 November 2002 14:49
To: Multiple recipients of list ORACLE-L


Paula,

I'm with you, there are few people in the world that I'd shell out my hard
earned $$$ to eat with.

Of course, if Gillian Anderson just happened to be around. well

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-Original Message-
Sent: Friday, November 01, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L


Paula,

Why would I be offended you are on a budget and have to pick and
choose?

In any case, before Jared gets annoyed with us, let's agree to set up
some sort of Oracle-L dinner at IOUG and we'll work out the details
when it's closer to the date.

Rachel

--- [EMAIL PROTECTED] wrote:
> I certainly will and think we should get together a dinner at IOUG
> too.  It
> will be great to put a face to your name Rachel.  Please don't be
> offended.
> I am on a limited budget - there are actually about 2 people I would
> pay my
> personal $$ to have dinner with as it would come out of my sons
> college
> education.  I bet you can guess who they might be.  Of course, they
> might
> pay $$ not to have dinner with me.  Hehe.
>
> Paula
>
> -Original Message-
> Sent: Friday, November 01, 2002 4:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Paula,
>
> Even if I'm not on that list of names make sure you find me at
> IOUG
> to say hi :)
>
> Rachel
> --- [EMAIL PROTECTED] wrote:
> > If it is a get together for dinner after IOUG live in April in
> > Orlando I
> > would even pick up the bill for a couple of names on this list.  (I
> > get to
> > choose the names).
> >
> > Hehe
> >
> > -Original Message-
> > [mailto:MATT.ADAMS@;APPL.GE.COM]
> > Sent: Friday, November 01, 2002 12:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Not all the time.  At the IOUG-A Live in Ananheim a few years
> > ago, we all met
> > at a resturant for dinner.  We had just one bill, I collected the
> > cash from everyone and paid the bill.  Everybody insisted that they
>
> > only gave me enough money to cover their portion of the bill and
> > the tip (which was an automatic 18%).  After paying the bill and
> > tip, I still had about $15 left over and everybody insisted that
> > it wasn't theirs, so we went back to hotel and I bought a round.
> >
> > This is just that kind of group.  Generous to a fault with
> > time, knowledge, and on occasion, money.
> >
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > My computer beat me at chess, but I won
> > when it came to kick boxing.
> >
> > -Original Message-
> >  ]
> > Sent: Friday, November 01, 2002 8:49 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Its the classic three part story...
> >
> > Part 1:  20 great friends meet for the dinner
> >
> > Part 2:  The bill arrrive
> >
> >   "I only had one piece of garlic bread!"
> >   "You drank some of my wine!"
> >   "I shared my burger with Joe over there!"
> >
> > Part 3:  20 arch enemies storm out...
> >
> > :-)
> >
> >  --- "Karniotis, Stephen"
> > <[EMAIL PROTECTED]> wrote: > 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: N-tier data access and security

[Freeman, Robert]

A few thoughts:

1. Keep as much of the business logic resident within the database itself as
possible. Use PL/SQL, Stored Java, etc... within the database to control the
business logic. Restrict all DML operations to only pass through these
interfaces. This affords you scalability later on as additional
applications/users want to interface with your database data. In the same
light, enforce constraints/relationships at the database level, not through
application logic.

2. Look at some of Oracle's security products and features such as global
application contexts for single sign-on. Also, consider the security schema
of your database. For example, While you might not have a need for granular
security right now you never know what the future will bring. 

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Monday, November 04, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


We are heading down the N-tier path, (browser, websphere app server, oracle
database).  What is the best method to setup this architecture for security
and
the logic?

1) Should the business logic be physically separate from the data access on
the
app server?  And if yes, where should the data access component reside?
(database or app server)  How does batch affect the decision?  What
variables
should we be considering when making this decision?

2) How should the database connection be established from the app server to
the
database?  Should it use a generic account on the app server with the
password
encrypted in a file?


In addition, does anybody have any good white papers or urls?  Thanks



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  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: Freeman, Robert
  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 Internals course URL

[Boivin, Patrice J]

Here is a URL pointing to the public Oracle Internals course:
http://education.oracle.com/seminars/track3.html

It is based on a course offered to Oracle employees.

The instructor is excellent.

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]



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

Re: Database Design: unique PK across all tables

[Jared Still]

Database nuetral?

Is this a commercial app to be sold?

If not, why are you doing this?

I suggest you read Tom Kyte's comments about this
in 'Expert: one-on-one Oracle'.

Essentially, you're paying for a lot of features you're not going to use.

Are you setting the FIPS level to force ANSI SQL compliance?

Jared

On Monday 04 November 2002 05:33, Brian P Andrews wrote:
> Thanks everyone.
>
> We're going forth with using a single sequence w/o any additional "meaning"
> put into the PK.
>
> Ian's recommendation of using the sys_guid function would be ideal,
> however, we are
> trying to remain database neutral at this point.
>
> [EMAIL PROTECTED] wrote:
> > 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).
-- 
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: Get together at OOW... bordering on OT

[Mark Leith]

Sounds like you guys need to get in touch with one of the tools vendors, and
give them a little sweet talk.. ;0)

With the brains that are going to be there, I'm sure some smart "Product
Manager" type would snap up the chance to get the majority of feedback from
the gurus on this list (tool related of course! ;P) - in return for the
price of a meal..

I'm just sorry that we can't get to the show! Next year maybe..

http://www.ioug.org/ioug_p/live_2003?v_nav=&v_text=LIVE_2003_EXHIBITION

Go get 'em! lol..

Mark

-Original Message-
Robert
Sent: 04 November 2002 14:49
To: Multiple recipients of list ORACLE-L


Paula,

I'm with you, there are few people in the world that I'd shell out my hard
earned $$$ to eat with.

Of course, if Gillian Anderson just happened to be around. well

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-Original Message-
Sent: Friday, November 01, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L


Paula,

Why would I be offended you are on a budget and have to pick and
choose?

In any case, before Jared gets annoyed with us, let's agree to set up
some sort of Oracle-L dinner at IOUG and we'll work out the details
when it's closer to the date.

Rachel

--- [EMAIL PROTECTED] wrote:
> I certainly will and think we should get together a dinner at IOUG
> too.  It
> will be great to put a face to your name Rachel.  Please don't be
> offended.
> I am on a limited budget - there are actually about 2 people I would
> pay my
> personal $$ to have dinner with as it would come out of my sons
> college
> education.  I bet you can guess who they might be.  Of course, they
> might
> pay $$ not to have dinner with me.  Hehe.
>
> Paula
>
> -Original Message-
> Sent: Friday, November 01, 2002 4:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Paula,
>
> Even if I'm not on that list of names make sure you find me at
> IOUG
> to say hi :)
>
> Rachel
> --- [EMAIL PROTECTED] wrote:
> > If it is a get together for dinner after IOUG live in April in
> > Orlando I
> > would even pick up the bill for a couple of names on this list.  (I
> > get to
> > choose the names).
> >
> > Hehe
> >
> > -Original Message-
> > [mailto:MATT.ADAMS@;APPL.GE.COM]
> > Sent: Friday, November 01, 2002 12:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Not all the time.  At the IOUG-A Live in Ananheim a few years
> > ago, we all met
> > at a resturant for dinner.  We had just one bill, I collected the
> > cash from everyone and paid the bill.  Everybody insisted that they
>
> > only gave me enough money to cover their portion of the bill and
> > the tip (which was an automatic 18%).  After paying the bill and
> > tip, I still had about $15 left over and everybody insisted that
> > it wasn't theirs, so we went back to hotel and I bought a round.
> >
> > This is just that kind of group.  Generous to a fault with
> > time, knowledge, and on occasion, money.
> >
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > My computer beat me at chess, but I won
> > when it came to kick boxing.
> >
> > -Original Message-
> >  ]
> > Sent: Friday, November 01, 2002 8:49 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Its the classic three part story...
> >
> > Part 1:  20 great friends meet for the dinner
> >
> > Part 2:  The bill arrrive
> >
> >   "I only had one piece of garlic bread!"
> >   "You drank some of my wine!"
> >   "I shared my burger with Joe over there!"
> >
> > Part 3:  20 arch enemies storm out...
> >
> > :-)
> >
> >  --- "Karniotis, Stephen"
> > <[EMAIL PROTECTED]> wrote: > 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 Norgaard,
> > > James Morle

RE: disable SNP job processing temporarily

[Jack van Zanen]

Title: disable SNP job processing temporarily



Would 
alter system set job_queue_processes = 0 be anoption???
 
 
Jack

  -Original Message-From: Markham, Richard 
  [mailto:[EMAIL PROTECTED]]Sent: maandag 4 november 2002 
  15:44To: Multiple recipients of list ORACLE-LSubject: 
  disable SNP job processing temporarily
  I have job_queue_processes 5 and job_queue_interval 3 
  I need to release locks on packages for a recompile 
  but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not 
  always an option for me.  Does anyone know what I 
  can do to suspend job processing (with minimal 
  impact). 

Re: disable SNP job processing temporarily

[Jeremiah Wilton]

How about:

1. alter system set job_queue_processes = 0;
2. wait for nothing to be running in dba_jobs_running
3. do your stuff
4. alter system set job_queue_processes = 5;

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 4 Nov 2002, Markham, Richard wrote:

> I have job_queue_processes 5 and job_queue_interval 3
> I need to release locks on packages for a recompile
> but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not 
> always an option for me.  Does anyone know what I can 
> do to suspend job processing (with minimal impact).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: disable SNP job processing temporarily

[Igor Neyman]

Title: disable SNP job processing temporarily



1. Mark all your jobs as "broken": dbms_job.broken(job_no, 
TRUE).

declare nJ int;
JobNum_Array DBMS_SQL.NUMBER_TABLE;
begin
SELECT job BULK COLLECT INTO JobNum_Array
FROM dba_jobs;
FOR nJ IN 1..JobNum_Array.COUNT LOOP
DBMS_JOB.BROKEN(JobNum_Array(nJ), TRUE);
END LOOP;
commit;
DBMS_LOCK.SLEEP(60);
EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
end;
/
 
2. Wait untill there is no records in 
dba_jobs_running.

declare lCount int := 1;
BEGIN
WHILE (lCount > 0) LOOP
SELECT COUNT(*) INTO lCount
FROM dba_jobs_running;
DBMS_LOCK.SLEEP(20);
END LOOP;
END;
/
 
3. Recompile your packages.
 
4. Mark all your jobs as "un-broken": dbms_job.broken(job_no, 
FALSE, next_date), specifying proper "next_date".
 
 
Igor Neyman, OCP DBA[EMAIL PROTECTED]  
 
 

  - Original Message - 
  From: 
  Markham, Richard 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, November 04, 2002 9:43 
  AM
  Subject: disable SNP job processing 
  temporarily
  
  I have job_queue_processes 5 and job_queue_interval 3 
  I need to release locks on packages for a recompile 
  but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not 
  always an option for me.  Does anyone know what I 
  can do to suspend job processing (with minimal 
  impact). 

RE: Red Hat or Suse

[Gogala, Mladen]

There 
was a little squabble when RH tried promoting Postgres (a.k.a "Red Hat 
database")
but 
after a retaliation from Oracle,  Red Hat came to its senses. Suse was 
merely a tool
in 
this squabble. It isn't big enough, software availability is so much worse then 
for RH and
they 
are trying to lock people in SuSE distribution by putting software in unusual 
places.
Relinking SuSE kernel was practically impossible, 
because of  unexpected dependencies
and 
kernel not returning the proper version string so that OSS was unable to 
recognize it.
Need I 
say that SuSE Helpdesk was less then helpful? I ended up downloading the 

regular kernel from ftp://ftp.kernel.org compiling it and ditching 
the SuSE kernel altogether.
For 
Thanksgiving, I'll go back to RH, now that they are using standard GNU CC 
again.

  -Original Message-From: Yechiel Adar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, November 04, 2002 3:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Red Hat or Suse
  I heard that Oracle is shifting it's priorities 
  from Suse toward Red Hat.
   
  Yechiel AdarMehish
  
- Original Message - 
From: 
Juan 
Miranda 
To: Multiple 
recipients of list ORACLE-L 
Sent: Thursday, October 31, 2002 5:53 
PM
Subject: 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) 
  ?

N-tier data access and security

[Tracy Rahmlow]

We are heading down the N-tier path, (browser, websphere app server, oracle
database).  What is the best method to setup this architecture for security and
the logic?

1) Should the business logic be physically separate from the data access on the
app server?  And if yes, where should the data access component reside?
(database or app server)  How does batch affect the decision?  What variables
should we be considering when making this decision?

2) How should the database connection be established from the app server to the
database?  Should it use a generic account on the app server with the password
encrypted in a file?


In addition, does anybody have any good white papers or urls?  Thanks



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  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... bordering on OT

[Freeman, Robert]

Paula,

I'm with you, there are few people in the world that I'd shell out my hard
earned $$$ to eat with.

Of course, if Gillian Anderson just happened to be around. well

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Friday, November 01, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L


Paula,

Why would I be offended you are on a budget and have to pick and
choose?

In any case, before Jared gets annoyed with us, let's agree to set up
some sort of Oracle-L dinner at IOUG and we'll work out the details
when it's closer to the date.

Rachel

--- [EMAIL PROTECTED] wrote:
> I certainly will and think we should get together a dinner at IOUG
> too.  It
> will be great to put a face to your name Rachel.  Please don't be
> offended.
> I am on a limited budget - there are actually about 2 people I would
> pay my
> personal $$ to have dinner with as it would come out of my sons
> college
> education.  I bet you can guess who they might be.  Of course, they
> might
> pay $$ not to have dinner with me.  Hehe.
> 
> Paula
> 
> -Original Message-
> Sent: Friday, November 01, 2002 4:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Paula,
> 
> Even if I'm not on that list of names make sure you find me at
> IOUG
> to say hi :)
> 
> Rachel
> --- [EMAIL PROTECTED] wrote:
> > If it is a get together for dinner after IOUG live in April in
> > Orlando I
> > would even pick up the bill for a couple of names on this list.  (I
> > get to
> > choose the names).
> >  
> > Hehe
> > 
> > -Original Message-
> > [mailto:MATT.ADAMS@;APPL.GE.COM]
> > Sent: Friday, November 01, 2002 12:00 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > Not all the time.  At the IOUG-A Live in Ananheim a few years 
> > ago, we all met 
> > at a resturant for dinner.  We had just one bill, I collected the 
> > cash from everyone and paid the bill.  Everybody insisted that they
> 
> > only gave me enough money to cover their portion of the bill and 
> > the tip (which was an automatic 18%).  After paying the bill and 
> > tip, I still had about $15 left over and everybody insisted that 
> > it wasn't theirs, so we went back to hotel and I bought a round. 
> > 
> > This is just that kind of group.  Generous to a fault with 
> > time, knowledge, and on occasion, money. 
> > 
> >  
> > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > My computer beat me at chess, but I won 
> > when it came to kick boxing. 
> > 
> > -Original Message- 
> >  ] 
> > Sent: Friday, November 01, 2002 8:49 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> > 
> > 
> > Its the classic three part story... 
> > 
> > Part 1:  20 great friends meet for the dinner 
> > 
> > Part 2:  The bill arrrive 
> > 
> >   "I only had one piece of garlic bread!" 
> >   "You drank some of my wine!" 
> >   "I shared my burger with Joe over there!" 
> > 
> > Part 3:  20 arch enemies storm out... 
> > 
> > :-) 
> > 
> >  --- "Karniotis, Stephen" 
> > <[EMAIL PROTECTED]> wrote: > 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 Norgaard, 
> > > 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 
> > > 
> > > 

disable SNP job processing temporarily

[Markham, Richard]

Title: disable SNP job processing temporarily





I have job_queue_processes 5 and job_queue_interval 3
I need to release locks on packages for a recompile
but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not 
always an option for me.  Does anyone know what I can 
do to suspend job processing (with minimal impact).

Re: Database Design: unique PK across all tables

[Igor Neyman]

How is using sequence makes it more database neutral than using sys_guid?
"Sequence" is proprietary Oracle's feature (i.e. in SQL Server you'll have
to assign "IDENTITY" property to the appropriate column instead, and you'll
have to deal with it differently: insert statements will change).
While, I'm pretty sure that most databases have functions similar to
sys_guid().

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 8:33 AM


> Thanks everyone.
>
> We're going forth with using a single sequence w/o any additional
"meaning" put
> into the PK.
>
> Ian's recommendation of using the sys_guid function would be ideal,
however, we
> are
> trying to remain database neutral at this point.
>
>
> [EMAIL PROTECTED] wrote:
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brian P Andrews
>   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: Igor Neyman
  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

[Tim Gorman]

How about using a stored procedure/function to encapsulate the sequence or
SYS_GUID value?  That's database-neutral.  Under the covers, it's whatever
optimal mechanism you want, but from the app-developer perspective, it's a
function returning a PK value...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 6:33 AM


> Thanks everyone.
>
> We're going forth with using a single sequence w/o any additional
"meaning" put
> into the PK.
>
> Ian's recommendation of using the sys_guid function would be ideal,
however, we
> are
> trying to remain database neutral at this point.
>
>
> [EMAIL PROTECTED] wrote:
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brian P Andrews
>   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: Tim Gorman
  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

[Brian P Andrews]

Thanks everyone.

We're going forth with using a single sequence w/o any additional "meaning" put
into the PK.

Ian's recommendation of using the sys_guid function would be ideal, however, we
are
trying to remain database neutral at this point.


[EMAIL PROTECTED] wrote:

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian P Andrews
  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 Monitoring tool

[Jamadagni, Rajendra]

Title: RE: Database Monitoring tool





Thank You Govind ... we all know who Anjo is and if you know what I meant by my email ... you'd know what it stands for.

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: Saturday, November 02, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database Monitoring tool



For those who don't know who Anjo Kolk is, please visit www.oraperf.com.  Anjo has worked for over 16 years at Oracle (1985-2001). 

Many people generate utlbstat/utlestats and statspack reports, but don't know how to interpret the data. People that do look at these are reports also mostly looking at the wrong information and end up making the wrong tuning decisions. That is why the reports are analyzed based on the YAPP method. The YAPP method will show what component of the total response time should be tuned first. 

I am a frequent visitor to their web-site to analyze our statspack reports.  


Govind



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

RE: Oracle Internals course

[Boivin, Patrice J]

Scott mentioned that he taught the course in Europe at some point.

He also mentioned Japan, the U.S..

I got the impression he might be involved with the Oracle Masters testing.

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: Tuesday, October 29, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L


Tim,

Do you  mean this Scott Gosset is working here in the Netherlands or
used to be? Any idea about these courses in the Netherlands?
I can always call Oracle support here but I doubt if they know
about it.

Tia,

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

DataGuard Remote Process startup Failed- Error

[Shibu MB]

 
 
Hi 
friends..
 
 
  
I am trying to create a stand by database using dataguard and i am getting the 
error ' DataGuard remote process startup failed'   . In  primary 
and secondary database oracle agent is running  . I have management server 
installed in the primary node itself . i have set  
dg_broker_start =  TRUE in the primary node.
But still i am getting the 
error . I did not find any documentation  for this .Can anyone help me to 
solve this error ?? Oracle version is 9i release 2  and O/S is win2k 
.
 
 
Thanks
Shibu

Re: Red Hat or Suse

[Yechiel Adar]

I heard that Oracle is shifting it's priorities 
from Suse toward Red Hat.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Juan 
  Miranda 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, October 31, 2002 5:53 
  PM
  Subject: 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: Re: Reporting - Casting about for ideas

[Yechiel Adar]

Hello Jared

BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that does
the same.

(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 8:43 AM


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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.co

Re: Re Raid 5+

[Yechiel Adar]

Hello Tim
 
You wrote:
> There is the problem of 
synchronization and the impact of that synchronization on other 
simultaneous requests.  Since all 
> 11-12 devices are servicing 
one request at a time, who gets served first?  
The answer is of course: The blond with the big 
bosom.
 
Seriously: (and this is also a reply to Jared  as 
well) The mail I answered to started with:
> I cannot fathom Raid 5 being faster than Raid 1 
for writes.  
 
Well in sequential writes like redo log, copy redo log 
to archive log and many other cases raid 5 will be 
faster.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Tim Gorman 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Sunday, November 03, 2002 10:53 
  PM
  Subject: Re: Re Raid 5+
  
  ...using a similar rationale, nine 
  women could produce a baby in a month...
   
  There is the problem of synchronization and the 
  impact of that synchronization on other simultaneous requests.  
  Since all 11-12 devices are servicing one request at a time, who gets served 
  first?  Sure, there are optimizations to ensure that 
  "whoever is closest" will get served first, but it still implies 
  single-threading at the slowest part of the subsytem.  While the stated 
  rationale surely sounds good for one user, what is the impact of such an 
  arrangement for a hundred concurrent users?
   
  
- Original Message - 
From: 
Yechiel 
Adar 
To: Multiple 
recipients of list ORACLE-L 
Sent: Sunday, November 03, 2002 9:03 
AM
Subject: Re: Re Raid 5+

Hello Ian
 
I heard a lecture on raid 5 disks a few weeks 
ago.
The rational behind read 5 being faster then raid 0+1 
is this:
You have 12 disks. In raid 0+1 you use striping across 
6 volumes.
In raid 5 you strip across 11 disks, so you get almost 
double the work without returning and moving the r/w head on the same 
disk.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  MacGregor, Ian A. 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Friday, November 01, 2002 2:48 
  AM
  Subject: RE: Re Raid 5+
  
  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