Data Transfer or Views from SQL Server to Oracle

[Nikunj Gupta]

Hello,

SQL Server in on Windows 2000 Box.
Oracle 8.1.7 is on Unix.

Is there any process by which data can be transferred from SQL SERVER to
ORACLE directly.. something like views / snapshots. (Requirement is almost
realtime data from SQL Server to Oracle)

I am initially not planning to dump the data from SQL Server (if possible)
and then run loader etc..

I am still not on 9i... else maybe would could have tried to read external
file directly after dump.

Thanks for any help or hint in this.

Nikunj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nikunj Gupta
  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: Excessive SQL*Net message from client waits

[Mohammed Shakir]

I noticed a similar problem on my last contract assignment. I was lucky
as the loading process took 4 hours but only 1 hour was spent by
oracle.
So we knew it was application that was taking the time. running the
application on a faster processor cut the time to 1/3. We also could
not find any problem with the network or sqlnet either.

Hope this helps

Mohammed Shakir


--- Mark Richard <[EMAIL PROTECTED]> wrote:
> I think you can relatively safely argue that Oracle is spending 90%
> of it's
> time waiting for the client (by that a user pressing a button or the
> application processing some logic) - and therefore even if you make
> Oracle
> run infinitely fast you will only improve the application overall by
> 10%.
> Perhaps someone else can verify this.
> 
> Jonathan explained, quite well, why the waits are so high...  It the
> application spawns 10 sessions per user then each session will only
> be
> called once per approx. 10 SQL statements.  Reducing the number of
> sessions
> will reduce the wait time on the report, but won't speed the
> application
> up.
> 
> The stats indicate that the application fired ~3,000 queries in ~10
> minutes
> (if I'm reading it right).  That gives a stat of about 5 queries per
> second
> - it sounds like there is little you can do at the Oracle end of
> town.  My
> guess is that the application is doing a lot of "single row per
> query" type
> statements when it should be working on a record set.  It's a shame,
> but it
> looks like an application problem that Oracle can do very little to
> help
> out.
> 
> Regards,
>  Mark.
> 
> 
> 
>  
>   
> "Karen Morton"   
>   
> <[EMAIL PROTECTED]   To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>   
> lting.com>cc:
>   
> Sent by:  Subject: RE:
> Excessive SQL*Net message from client waits  
> [EMAIL PROTECTED] 
>   
>  
>   
>  
>   
> 13/03/2003 22:53 
>   
> Please respond to
>   
> ORACLE-L 
>   
>  
>   
>  
>   
> 
> 
> 
> 
> Not like this nor should it be the "top" event always as seems to be
> the
> case here I don't believe.  And, I know for certain that the client
> did
> everything as quickly as possible during the trace.  Minimal data
> entry
> done
> and OK buttons clicked without delay...no time out for getting a cup
> of
> coffee in between or anything.  :)
> 
> Karen
> 
> -Original Message-
> Zanen
> Sent: Thursday, March 13, 2003 2:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> 
> Isn't sql*net message from client always sort of on top, because it
> just
> means the rdbms is waiting for the client to send some query/command
> (user
> is not typing/clicking/reading fast enough)
> 
> 
> Jack
> 
> -Original Message-
> Sent: donderdag 13 maart 2003 3:19
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi All,
> 
> I've got a situation where I've collected trace data and am seeing
> 90% of
> total response time is accounted for with the SQL*Net Message From
> Client
> event.  Individual queries within the trace show minimal CPU time
> used and
> no obvious indications of bad SQL being the culprit.  I used the
> Hotsos
> Profiler (way cool) and here's an example of what it shows:
> 
> Response Time Component   Duration #
> Calls
> AvgMin  Max
> -- 
> ---
> 
> --- -- ---
> (i) SQL*Net message from client 500.98s   85.1%  
> 2,757
> 0.181712s  0.00s   5.91s
> (i) unaccounted-for  23.03s3.9%
> (i) direct path write22.38s3.8%  
> 1,373
> 0.016300s  0.00s   0.32s
> (i) log fi

RE: log buffer space

[Rajesh Dayal]

Dear AK,

So far we don't know your log buffer size. 
Can we have a glimpse of this parameter, log_buffer ?

Rajesh


-Original Message-
Sent: Friday, March 14, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L

Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:32 AM


> Arup:
>
> 
> The second condition is not quite true. It is 2/3 full in the current
> versions.
> 
>
> It is very easy to test with the event 10046^8.
>
> KG
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > AK,
> >
> > If the log buffer is at least 4MB, then increasing it will not help,
> > rather it may hurt. The log buffer is flushed when any of the the
> > follwoing occur
> > (i) 1 MB is filled up
> > (2) 1/3rd is filled up
> > (3) every 3 seconds
> > (4) when a checkpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being
> > on a busy disk, or even a slow one.
> >
> > HTH.
> >
> > Arup
> >   - Original Message -
> >   From: Deshpande, Kirti
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Thursday, March 13, 2003 8:13 PM
> >   Subject: RE: log buffer space
> >
> >
> >   Increasing log_buffer size is an option, if it is really small.
> >   I would also check if the redo logs are on a busy disk. If so, try
> > moving those (or other busy data files on the same disk) to other
> > not-so-busy disks.
> >
> >   - Kirti
>
>
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
>   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.net
--
Author: AK
  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.net
-- 
Author: Rajesh Dayal
  INET: [EMAIL PROTECTED]

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

RE: 9i RAC - GFS

[Pete Sharman]

Yup.  I believe it's something we're actively working with Sun on,
because other clustered fil systems (like Compaq's) perform fine.  Sun's
is just too slow for some reason.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 8:39 PM
To: Multiple recipients of list ORACLE-L


Attached in a quote from an Oracle Rep, asking us to avoid Global file
systems on Sun Cluster nodes for 9i RAC.

It is very clear that binaries and/or datafiles on GFS are not supported
today. The reason for this is the proxy I/O that GFS is based on can be
a real performance and scalability bottleneck. However, The use of GFS
for archive logs is the one circumstance where GFS may work for you. The
caveat here is that this has not been well tested. Noone internally at
Oracle is actively testing with GFS in any capacity today, and I'm not
personally aware of any customers who have done this.  As a best
practice recommendation, we suggest it be avoided altogether. However,
if you have the luxury of time to be able to test performance both in
standard operational peak loads, and the various backup and media
recovery scenarios where you would need to access the archive logs, then
you will not get any push back from Oracle Support saying "you are
running an un-supported configuration, we can't help you."

Is this true?

Regards
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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.net
-- 
Author: Pete Sharman
  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: Server Recommendations

[Cary Millsap]

Title: RE: Server Recommendations









Correct answer. Here’s a little more
detail to think about.

 

Assuming that you’re using a
reasonably scalable OS (I’m honestly not sure whether MS Windows yet
actually qualifies), two 1GHz CPUs will provide more scalable performance under
higher concurrency loads. (Scalable doesn’t mean faster, it means more
consistent. See “Scalability is a Rate of Change” at www.hotsos.com/catalog.) However,
under low concurrency loads, a faster CPU will execute more CPU instructions in
the same amount of time. You might also take a look at “Batch Queue
Management and the Magic of ‘2’” at www.hotsos.com/catalog for additional
insight.

 



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

Upcoming events:
- Hotsos Clinic 101,
Mar 25–27 Oxford
- Hotsos Clinic 101,
Apr 8–10 Chicago



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeremy
Pulcifer
Sent: Friday, March 14, 2003 5:24
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Server
Recommendations

 

>
href="">mailto:[EMAIL PROTECTED]]

> 
> 
> I have a question, I have to
make a decision on the purchase 
> of a new web server for a
multiteir Oracle based system.  So 
> here are my two remaining
options, all other things remaining 
> equal, on a system which has
100% dynamically generated web pages. 
> 
> 
> 1. A server with one 2ghz CPU.

> 
> or 
> 
> 2. A server with two 1ghz CPU.

> 
> 
> Which will provide more power?


(42). Or,
It Depends(tm) 

> A
little more food for though.  Would a server with a 1ghz 
> CPU and 512mb RAM be adequate
for a Oracle backed web site, 
> which the pages are all 100%
dynamic? 

See
above. 

9i RAC - GFS

[Rajesh . Rao]

Attached in a quote from an Oracle Rep, asking us to avoid Global file
systems on Sun Cluster nodes for 9i RAC.

It is very clear that binaries and/or datafiles on GFS are not supported
today. The reason for this is the proxy I/O that GFS is based on can be a
real performance and scalability bottleneck. However, The use of GFS for
archive logs is the one circumstance where GFS may work for you. The caveat
here is that this has not been well tested. Noone internally at Oracle is
actively testing with GFS in any capacity today, and I'm not personally
aware of any customers who have done this.  As a best practice
recommendation, we suggest it be avoided altogether. However, if you have
the luxury of time to be able to test performance both in standard
operational peak loads, and the various backup and media recovery scenarios
where you would need to access the archive logs, then you will not get any
push back from Oracle Support saying "you are running an un-supported
configuration, we can't help you."

Is this true?

Regards
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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: log buffer space

[Anjo Kolk]

1 log switch per minute ;-)

AK wrote:
> 
> log buffer is 320 K and log files are 30M approx. there are about 50 log
> switch /hr .
> 
> -ak
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 9:29 AM
> 
> > AK,
> >
> > Could you provide the redo log sizes and the log_buffers parameters,
> please.
> > Also let us know the log switch frequency, too.
> >
> > Thanks.
> >
> > Arup
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 14, 2003 11:14 AM
> >
> >
> > > Do you guys think , adding more log file can help ? I think it should
> not
> > ,
> > > cuz any way logwriter is going to write in one datafile at a time ,
> > correct
> > > ?
> > >
> > > -ak
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 14, 2003 4:32 AM
> > >
> > >
> > > > Arup:
> > > >
> > > > 
> > > > The second condition is not quite true. It is 2/3 full in the current
> > > > versions.
> > > > 
> > > >
> > > > It is very easy to test with the event 10046^8.
> > > >
> > > > KG
> > > >
> > > >
> > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > > > AK,
> > > > >
> > > > > If the log buffer is at least 4MB, then increasing it will not help,
> > > > > rather it may hurt. The log buffer is flushed when any of the the
> > > > > follwoing occur
> > > > > (i) 1 MB is filled up
> > > > > (2) 1/3rd is filled up
> > > > > (3) every 3 seconds
> > > > > (4) when a checkpoint occurs
> > > > > (5) when a commit occurs.
> > > > >
> > > > > Therefore, see if any of these could be the problem. It's easy to
> > > > > check #s 4 and 3.
> > > > >
> > > > > As Kirti suggested, the problem could be due to the redo logs being
> > > > > on a busy disk, or even a slow one.
> > > > >
> > > > > HTH.
> > > > >
> > > > > Arup
> > > > >   - Original Message -
> > > > >   From: Deshpande, Kirti
> > > > >   To: Multiple recipients of list ORACLE-L
> > > > >   Sent: Thursday, March 13, 2003 8:13 PM
> > > > >   Subject: RE: log buffer space
> > > > >
> > > > >
> > > > >   Increasing log_buffer size is an option, if it is really small.
> > > > >   I would also check if the redo logs are on a busy disk. If so, try
> > > > > moving those (or other busy data files on the same disk) to other
> > > > > not-so-busy disks.
> > > > >
> > > > >   - Kirti
> > > >
> > > >
> > > > =
> > > > Have a nice day !!
> > > > 
> > > > Best Regards,
> > > > K Gopalakrishnan,
> > > > Bangalore, INDIA.
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: K Gopalakrishnan
> > > >   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.net
> > > --
> > > Author: AK
> > >   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.net
> > --
> > Author: Arup Nanda
> >   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.net
> --
> Author: AK
>   INET: [EMAIL PROT

Re: Server Recommendations

[Anjo Kolk]

If there is a lot of latch contention, choose 1 fast one. If there is no
latch contention, choose 2 not so fast ones.

Anjo.



Tom Schruefer wrote:
> 
> I have a question, I have to make a decision on the purchase of a new web
> server for a multiteir Oracle based system.  So here are my two remaining
> options, all other things remaining equal, on a system which has 100%
> dynamically generated web pages.
> 
> 1. A server with one 2ghz CPU.
> 
> or
> 
> 2. A server with two 1ghz CPU.
> 
> Which will provide more power?
> 
> A little more food for though.  Would a server with a 1ghz CPU and 512mb RAM
> be adequate for a Oracle backed web site, which the pages are all 100%
> dynamic?
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tom Schruefer
>   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.net
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

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

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

[Darrell Landrum]

Scott (and others),

I apologize, all I was given regarding this document was a hard copy and based on 
confidentiality footers, I'm don't think I'm allowed to distribute it.  However, if 
you're on an EMC system now, I'd call or e-mail your EMC rep and ask for it.  If it 
works as well as described, it will only make them look better.


>>> [EMAIL PROTECTED] 03/07/03 12:44PM >>>
I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they 
publish a lot of pdf documents on their site.  I'll see if I can locate it there and 
send a URL.

>>> [EMAIL PROTECTED] 03/07/03 10:55AM >>>
Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott


At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it, 
>don't worry about it, then recently we we're given a white paper from EMC 
>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on using a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The SAN box
> > we are looking at right now is the EVA3000 from HP (although this isn't a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED] 
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net 
>--
>Author: Chuck Hamilton
>   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.net 
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

Re: log buffer space

[Darrell Landrum]

I'm sorry, I've missed whether this is a production database in archive log mode or 
not.  If it is, log switches twice per hour may be too few.  You should find out what 
your data loss tolerance is for this instance and adjust your redo log setup to 
accomodate that.  I agree, 50 per hour is a bit much, but there are databases where 30 
minutes of data lost could be quite hurtful.


>>> [EMAIL PROTECTED] 03/14/03 05:29PM >>>
Well, there lies your problem. I suggest you do the following in this order
of priority and see if they resolved the problem.

(1) Log buffer of 320K is definitely small. Make it 4 MB (or at least 3MB)
if you have enough memory.
(2) Your log switching is 50 per hour?!! That's a little too much. Are you
sure it's that high? If so, you need to bring it down to about 2 per hour.
If 50/hr is your average rate of switch, then you need to size the logfiles
at least 25 times current size to achieve the 2 per hour rate. Make your
logs 500M each, again if you have enough disk space.
(3) If possible, try to move the redo logs to non-RAID disks, preferably
local (direct attached).

HTH.

Arup Nanda

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:34 PM


> log buffer is 320 K and log files are 30M approx. there are about 50 log
> switch /hr .
>
> -ak
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 9:29 AM
>
>
> > AK,
> >
> > Could you provide the redo log sizes and the log_buffers parameters,
> please.
> > Also let us know the log switch frequency, too.
> >
> > Thanks.
> >
> > Arup
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 14, 2003 11:14 AM
> >
> >
> > > Do you guys think , adding more log file can help ? I think it should
> not
> > ,
> > > cuz any way logwriter is going to write in one datafile at a time ,
> > correct
> > > ?
> > >
> > > -ak
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 14, 2003 4:32 AM
> > >
> > >
> > > > Arup:
> > > >
> > > > 
> > > > The second condition is not quite true. It is 2/3 full in the
current
> > > > versions.
> > > > 
> > > >
> > > > It is very easy to test with the event 10046^8.
> > > >
> > > > KG
> > > >
> > > >
> > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > > > AK,
> > > > >
> > > > > If the log buffer is at least 4MB, then increasing it will not
help,
> > > > > rather it may hurt. The log buffer is flushed when any of the the
> > > > > follwoing occur
> > > > > (i) 1 MB is filled up
> > > > > (2) 1/3rd is filled up
> > > > > (3) every 3 seconds
> > > > > (4) when a checkpoint occurs
> > > > > (5) when a commit occurs.
> > > > >
> > > > > Therefore, see if any of these could be the problem. It's easy to
> > > > > check #s 4 and 3.
> > > > >
> > > > > As Kirti suggested, the problem could be due to the redo logs
being
> > > > > on a busy disk, or even a slow one.
> > > > >
> > > > > HTH.
> > > > >
> > > > > Arup
> > > > >   - Original Message -
> > > > >   From: Deshpande, Kirti
> > > > >   To: Multiple recipients of list ORACLE-L
> > > > >   Sent: Thursday, March 13, 2003 8:13 PM
> > > > >   Subject: RE: log buffer space
> > > > >
> > > > >
> > > > >   Increasing log_buffer size is an option, if it is really small.
> > > > >   I would also check if the redo logs are on a busy disk. If so,
try
> > > > > moving those (or other busy data files on the same disk) to other
> > > > > not-so-busy disks.
> > > > >
> > > > >   - Kirti
> > > >
> > > >
> > > > =
> > > > Have a nice day !!
> > > > 
> > > > Best Regards,
> > > > K Gopalakrishnan,
> > > > Bangalore, INDIA.
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> > > > --
> > > > Author: K Gopalakrishnan
> > > >   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.net 
> > > --
> > > Author: AK
> > >   INET: [EMAIL PROTECTED] 
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> > > San Diego, California-- Mailing list and web hosting services
> > > ---

Re: log buffer space

[Mogens Nørgaard]

50 log switches per hour is a LOT. Get it down to a handful or so by increasing
the size of the redo logs with a factor 10 or so. Redo buffer sounds a bit
small, and going to 1M in size might help a bit, although there's no guarantee
for it.

Mogens

AK wrote:

  log buffer is 320 K and log files are 30M approx. there are about 50 log
switch /hr .

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 9:29 AM


  
  
AK,

Could you provide the redo log sizes and the log_buffers parameters,

  
  please.
  
  
Also let us know the log switch frequency, too.

Thanks.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:14 AM




  Do you guys think , adding more log file can help ? I think it should
  

  
  not
  
  
,


  cuz any way logwriter is going to write in one datafile at a time ,
  

correct


  ?

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:32 AM


  
  
Arup:


The second condition is not quite true. It is 2/3 full in the current
versions.


It is very easy to test with the event 10046^8.

KG


--- Arup Nanda <[EMAIL PROTECTED]> wrote:


  AK,

If the log buffer is at least 4MB, then increasing it will not help,
rather it may hurt. The log buffer is flushed when any of the the
follwoing occur
(i) 1 MB is filled up
(2) 1/3rd is filled up
(3) every 3 seconds
(4) when a checkpoint occurs
(5) when a commit occurs.

Therefore, see if any of these could be the problem. It's easy to
check #s 4 and 3.

As Kirti suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.

HTH.

Arup
  - Original Message -
  From: Deshpande, Kirti
  To: Multiple recipients of list ORACLE-L
  Sent: Thursday, March 13, 2003 8:13 PM
  Subject: RE: log buffer space


  Increasing log_buffer size is an option, if it is really small.
  I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk) to other
not-so-busy disks.

  - Kirti
  


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
  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.net
--
Author: AK
  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.net
--
Author: Arup Nanda
  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).



  

CBO Tutorial Day - Orlando

[Jonathan Lewis]

Arrangements are now complete for the 
CBO Tutorial that I will be holding in 
Orlando on  Friday May 2nd.

For further details see
   http://www.jlcomp.demon.co.uk/tutorial.html 


Jonathan Lewis
http://www.jlcomp.demon.co.uk



Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: log buffer space

[Arup Nanda]

Well, there lies your problem. I suggest you do the following in this order
of priority and see if they resolved the problem.

(1) Log buffer of 320K is definitely small. Make it 4 MB (or at least 3MB)
if you have enough memory.
(2) Your log switching is 50 per hour?!! That's a little too much. Are you
sure it's that high? If so, you need to bring it down to about 2 per hour.
If 50/hr is your average rate of switch, then you need to size the logfiles
at least 25 times current size to achieve the 2 per hour rate. Make your
logs 500M each, again if you have enough disk space.
(3) If possible, try to move the redo logs to non-RAID disks, preferably
local (direct attached).

HTH.

Arup Nanda

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:34 PM


> log buffer is 320 K and log files are 30M approx. there are about 50 log
> switch /hr .
>
> -ak
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 9:29 AM
>
>
> > AK,
> >
> > Could you provide the redo log sizes and the log_buffers parameters,
> please.
> > Also let us know the log switch frequency, too.
> >
> > Thanks.
> >
> > Arup
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 14, 2003 11:14 AM
> >
> >
> > > Do you guys think , adding more log file can help ? I think it should
> not
> > ,
> > > cuz any way logwriter is going to write in one datafile at a time ,
> > correct
> > > ?
> > >
> > > -ak
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 14, 2003 4:32 AM
> > >
> > >
> > > > Arup:
> > > >
> > > > 
> > > > The second condition is not quite true. It is 2/3 full in the
current
> > > > versions.
> > > > 
> > > >
> > > > It is very easy to test with the event 10046^8.
> > > >
> > > > KG
> > > >
> > > >
> > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > > > AK,
> > > > >
> > > > > If the log buffer is at least 4MB, then increasing it will not
help,
> > > > > rather it may hurt. The log buffer is flushed when any of the the
> > > > > follwoing occur
> > > > > (i) 1 MB is filled up
> > > > > (2) 1/3rd is filled up
> > > > > (3) every 3 seconds
> > > > > (4) when a checkpoint occurs
> > > > > (5) when a commit occurs.
> > > > >
> > > > > Therefore, see if any of these could be the problem. It's easy to
> > > > > check #s 4 and 3.
> > > > >
> > > > > As Kirti suggested, the problem could be due to the redo logs
being
> > > > > on a busy disk, or even a slow one.
> > > > >
> > > > > HTH.
> > > > >
> > > > > Arup
> > > > >   - Original Message -
> > > > >   From: Deshpande, Kirti
> > > > >   To: Multiple recipients of list ORACLE-L
> > > > >   Sent: Thursday, March 13, 2003 8:13 PM
> > > > >   Subject: RE: log buffer space
> > > > >
> > > > >
> > > > >   Increasing log_buffer size is an option, if it is really small.
> > > > >   I would also check if the redo logs are on a busy disk. If so,
try
> > > > > moving those (or other busy data files on the same disk) to other
> > > > > not-so-busy disks.
> > > > >
> > > > >   - Kirti
> > > >
> > > >
> > > > =
> > > > Have a nice day !!
> > > > 
> > > > Best Regards,
> > > > K Gopalakrishnan,
> > > > Bangalore, INDIA.
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: K Gopalakrishnan
> > > >   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.net
> > > --
> > > Author: AK
> > >   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 offi

RE: Server Recommendations

[Jeremy Pulcifer]

Title: RE: Server Recommendations





> From: Tom Schruefer [mailto:[EMAIL PROTECTED]] 
> 
> 
> I have a question, I have to make a decision on the purchase 
> of a new web server for a multiteir Oracle based system.  So 
> here are my two remaining options, all other things remaining 
> equal, on a system which has 100% dynamically generated web pages.
> 
> 
> 1. A server with one 2ghz CPU.
> 
> or
> 
> 2. A server with two 1ghz CPU.
> 
> 
> Which will provide more power?


(42). Or, It Depends(tm)


> A little more food for though.  Would a server with a 1ghz 
> CPU and 512mb RAM be adequate for a Oracle backed web site, 
> which the pages are all 100% dynamic?


See above.

RE: Multiple Instances and 9iRAC

[Thompson, Todd]

Sorry I didn't explain the
configuration very well-  here is what I'm talking about:

 

We have an existing HP server currently
running 4 instances/databases.  Sid1,sid2,sid3,sid4

 

Is it advisable to implement RAC for all
the databases/sids on this server? 

 

i.e.

 

Cluster1=

Node1= Sid1,sid2,sid3,sid4

Node2= Sid1,sid2,sid3,sid4

Node3= Sid1,sid2,sid3,sid4

Node4= Sid1,sid2,sid3,sid4

 

Or does each cluster  need to manage a
single instance...

 

Cluster1=

Node1= sid1

Node2= sid1

Node3 =sid1

 

Cluster2=

Node4=sid2

Node5=sid2

Node6=sid2

 

Cluster3= 

 

What we are envisioning is a single huge RAC
cluster that will run ALL of our Oracle databases vs. created multiple RAC
clusters with one instance/database per cluster.

 

 

-Original Message-
From: Arup Nanda
[mailto:[EMAIL PROTECTED] 
Sent: Friday, March
 14, 2003 2:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Multiple Instances
and 9iRAC

 



Todd,





 





RAC is a multi-instance database. If
you have n nodes in a cluster then you generally have (although not necessarily
that many) n instances accessing the same database. When you mention 3 or more
Oracle instances, perhaps you mean 3 or more "databases" each in a
separate cluster of 4 to 8 nodes each.





 





Interconnect plays a very important
role in performance in this case and depends heavily on the hardware you decide
on. For instance if you use Tru64 Clusters on Compaq alphas, you would probably
go for Memory channels as interconnect; but for HP clusters you will lean
towards CLIC interface.





 





The environment you mentioned is not
just viable, but that's exactly how it is done.





 





HTH.





 





Arup Nanda







- Original Message - 





From: Thompson,
Todd 





To: Multiple
recipients of list ORACLE-L 





Sent: Friday,
March 14, 2003 1:29 PM





Subject: Multiple
Instances and 9iRAC 





 



 

My company is currently considering using Oracle 9i
RAC. One of the proposed environments is to have multiple oracle instances (3
or more) configured on a 4-8 node RAC cluster. Does anyone have any insights as
to the viability of this implementation?  Will the high speed inter
connect be able to handle the traffic from multiple instances?  I always
thought of RAC as a single instance implementation with each instance needing
its own cluster...

RE: Sun=/var/messages HP-UX=???

[Deshpande, Kirti]

dmesg... now, that, I know. 
It needs root privs to use. And unless it is run via some automated setup (cron, as 
you mentioned) to create a public accessible report, we are stuck with syslog.log. At 
least, on most systems, it is public readable... 

Thanks..

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


hpux 11.0 
man dmesg shows the standard setup using /var/adm/messages.

  dmesg looks in a system buffer for recently printed diagnostic
  messages and prints them on the standard output.  The messages are
  those printed by the system when unusual events occur (such as when
  system tables overflow or the system crashes).  If the - argument is
  specified, dmesg computes (incrementally) the new messages since the
  last time it was run and places these on the standard output.  This is
  typically used with cron (see cron(1)) to produce the error log
  /var/adm/messages by running the command:

   /usr/sbin/dmesg - >> /var/adm/messages

  every 10 minutes.

  The arguments core and system allow substitution for the defaults
  /dev/kmem and /stand/vmunix respectively, where core should be a file
  containing the image of the kernel virtual memory saved by the
  savecore(1M) command and system should be the corresponding kernel.
  If the system is booted with a kernel other than /stand/vmunix say
  /stand/vmunix_new, dmesg must be passed this name, the command must
  be,

   /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new

 WARNINGS
  The system error message buffer is of small, finite size.  dmesg is
  run only every few minutes, so there is no guarantee that all error
  messages will be logged.

 AUTHOR
  dmesg was developed by the University of California, Berkeley.

 FILES
  /var/adm/messageserror log (conventional location)
  /var/adm/msgbuf  memory scratch file for - option
  /dev/kmemspecial file containing the image of kernel
   virtual memory
  /stand/vmunixthe kernel, system name list

> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2003 3:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sun=/var/messages HP-UX=???
> 
> 
> What version of HP-UX?
> Here is what I get on HP-UX 11.0: 
> 
> df2hp105 [IWHA]: ll /var/adm/me*
> /var/adm/me* not found
> 
> - Kirti 
> 
> -Original Message-
> Sent: Friday, March 14, 2003 10:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Actually /var/adm/messages on hpux is the message file, which 
> my solaris 8(2.8) machine is also using /var/adm/messages, 
> maybe I changed this, I don't remember.
> /var/adm/syslog/ is the default syslog directory equivalent 
> to /var/log/ on solaris.
> 
> > -Original Message-
> > From: Nelson, Allan [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 13, 2003 9:20 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Sun=/var/messages HP-UX=???
> > 
> > 
> > /var/adm/syslog/syslog.log is the hp-ux equivelant.
> > 
> > -Original Message-
> > Sent: Thursday, March 13, 2003 12:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I monitor /var/messages on my Sun boxes, does HP-UX have 
> anytype of OS
> > log files worth monitoring?
> > 
> > Thanks,
> > Ethan
> -- 




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Server Recommendations

[Tom Schruefer]

I have a question, I have to make a decision on the purchase of a new web
server for a multiteir Oracle based system.  So here are my two remaining
options, all other things remaining equal, on a system which has 100%
dynamically generated web pages.


1. A server with one 2ghz CPU.

or

2. A server with two 1ghz CPU.


Which will provide more power?


A little more food for though.  Would a server with a 1ghz CPU and 512mb RAM
be adequate for a Oracle backed web site, which the pages are all 100%
dynamic?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tom Schruefer
  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: rollback segment

[Darrell Landrum]

ak,

Here is a query you can run to see if it is currently in use...

SQL> select b.segment_name, a.xacts, a.shrinks, a.wraps, a.extends
  2  from v$rollstat a, dba_rollback_segs b
  3  where a.usn = b.segment_id
  4  /

SEGMENT_NAMEXACTSSHRINKS  WRAPSEXTENDS
-- -- -- -- --
SYSTEM  0  0  0  0
RBS_BIG01   0  1 46  6
RBS_BIG02   0  1 57  8
RBS_BIG03   0  0 31  0
RBS_BIG04   1  4 86 27
RBS_BIG05   1  1 43  8

6 rows selected.

--
What you're looking for here is the 'XACTS' column to be zero for the rollback segment 
you want to take offline.
Once you see it is not in use, shrink it: 'alter rollback segment RBSNAME shrink;'.
Then take it offline.  If it is taking up too much space, maybe drop and recreated it 
with smaller extent sizes, but I wouldn't just drop it.  This is a good rollback 
segment to have handy to bring online under special circumstances.  Also, you might 
check any available code to ensure no one is explicitly using this rollback segment in 
their sql code.

Darrell



>>> [EMAIL PROTECTED] 03/14/03 03:53PM >>>
I have recently found that one temporary rollback segment in system tablespace is 
having more then 600 extnets . It looks like previous dba created this rollback 
segment at the time of db creation and forgot to take it offline . 
Now how do I find it this rollback segment is being used actively . I see values in 
gets , writes from v$rollstat view .

What step should I take to drop this rollback segment . What implication might have if 
I take this offline ? I want to relase the space taken by this rollback segment ( >600 
extents ..thats big ) , so just taking offline wont do this.

Are there any views accessible from system( no sys) account which can tell me which 
trasaction is using which rollback segment .


thanks
-ak




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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: rollback segment

[Daniel W. Fink]

You can take the rollback segment offline. It will not impact any currently
running transactions and no new transactions will be assigned to it. Oracle
will not let you drop a rollback segment while there are any active transactions
writing undo to the rollback segment. IIRC, the v$rollstat.status goes to
'PENDING OFFLINE'  when you set if offline, but transactions are still using
it. It then changes to 'OFFLINE' when the pending transactions are completed.

One caveat is that the status is unaffected by consistent read operations.
It is possible to drop the rollback segment and have queries fail with Snapshot
Too Old. My recommendation is to offline the segment during a time of low
activity and then drop it.

v$transaction provides limited undo info, but enough to determine which sessions/users
are using the specific rollback segment.
    
 
-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals


AK wrote:
  
  
 
  
 

  I have recently found that one temporary
rollback  segment in system tablespace is having more then 600 extnets .
It looks like  previous dba created this rollback segment at the time of
db creation and forgot  to take it offline . 
 
  Now how do I find it this rollback segment
is being  used actively . I see values in gets , writes from v$rollstat view
 .
 
   
 
  What step should I take to drop this rollback
 segment . What implication might have if I take this offline ? I want to
relase  the space taken by this rollback segment ( >600 extents ..thats
big ) , so  just taking offline wont do this.
 
   
 
  Are there any views accessible from system(
no  sys) account which can tell me which trasaction is using which rollback
 segment .
 
   
 
   
 
  thanks
 
  -ak

Re: log buffer space

[AK]

log buffer is 320 K and log files are 30M approx. there are about 50 log
switch /hr .

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 9:29 AM


> AK,
>
> Could you provide the redo log sizes and the log_buffers parameters,
please.
> Also let us know the log switch frequency, too.
>
> Thanks.
>
> Arup
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 11:14 AM
>
>
> > Do you guys think , adding more log file can help ? I think it should
not
> ,
> > cuz any way logwriter is going to write in one datafile at a time ,
> correct
> > ?
> >
> > -ak
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 14, 2003 4:32 AM
> >
> >
> > > Arup:
> > >
> > > 
> > > The second condition is not quite true. It is 2/3 full in the current
> > > versions.
> > > 
> > >
> > > It is very easy to test with the event 10046^8.
> > >
> > > KG
> > >
> > >
> > > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > > AK,
> > > >
> > > > If the log buffer is at least 4MB, then increasing it will not help,
> > > > rather it may hurt. The log buffer is flushed when any of the the
> > > > follwoing occur
> > > > (i) 1 MB is filled up
> > > > (2) 1/3rd is filled up
> > > > (3) every 3 seconds
> > > > (4) when a checkpoint occurs
> > > > (5) when a commit occurs.
> > > >
> > > > Therefore, see if any of these could be the problem. It's easy to
> > > > check #s 4 and 3.
> > > >
> > > > As Kirti suggested, the problem could be due to the redo logs being
> > > > on a busy disk, or even a slow one.
> > > >
> > > > HTH.
> > > >
> > > > Arup
> > > >   - Original Message -
> > > >   From: Deshpande, Kirti
> > > >   To: Multiple recipients of list ORACLE-L
> > > >   Sent: Thursday, March 13, 2003 8:13 PM
> > > >   Subject: RE: log buffer space
> > > >
> > > >
> > > >   Increasing log_buffer size is an option, if it is really small.
> > > >   I would also check if the redo logs are on a busy disk. If so, try
> > > > moving those (or other busy data files on the same disk) to other
> > > > not-so-busy disks.
> > > >
> > > >   - Kirti
> > >
> > >
> > > =
> > > Have a nice day !!
> > > 
> > > Best Regards,
> > > K Gopalakrishnan,
> > > Bangalore, INDIA.
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: K Gopalakrishnan
> > >   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.net
> > --
> > Author: AK
> >   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.net
> --
> Author: Arup Nanda
>   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.net
-- 
Author: AK
  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 '

RE: Statspack recomendations.

[Rich Holland]

I alwasys use bookfinder.com to search for books; it queries quite a few
sites and generally finds the best price for me (new and/or used).
Another useful site is the ISBN locator at www.isbn.nu

Good luck!
Rich

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Bob Metelsky
> Sent: Thursday, January 23, 2003 4:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Statspack recomendations.
> 
> 
> 
> > 
> > Go to bookpool.com. Best prices on tech books. I've ordered
> > several books from them and have always been happy.
> > 
> 
> Yes definetly... But this one
> 
> "Conducting the Oracle Job Interview"
> 
> Is not available at bookpool or amazon... 
> (personally I like the  "buy used" books from amazon) quite a 
> few deals
> there Ive always been reasonably pleased with the service as well.
> 
> Thanks
> bob
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bob Metelsky
>   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.net
-- 
Author: Rich Holland
  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: rollback segment

[DENNIS WILLIAMS]

AK
   Sometime when your system isn't at its peak, just take the segment
offline. Then wait a little while and check the status. Oracle won't take
the segment offline as long as active processes are using it. Oracle won't
let you drop it until it is able to take it offline.



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

-Original Message-
Sent: Friday, March 14, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L


I have recently found that one temporary rollback segment in system
tablespace is having more then 600 extnets . It looks like previous dba
created this rollback segment at the time of db creation and forgot to take
it offline . 
Now how do I find it this rollback segment is being used actively . I see
values in gets , writes from v$rollstat view .
 
What step should I take to drop this rollback segment . What implication
might have if I take this offline ? I want to relase the space taken by this
rollback segment ( >600 extents ..thats big ) , so just taking offline wont
do this.
 
Are there any views accessible from system( no sys) account which can tell
me which trasaction is using which rollback segment .
 
 
thanks
-ak
 
 
 
 

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

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

rollback segment

[AK]

I have recently found that one temporary rollback 
segment in system tablespace is having more then 600 extnets . It looks like 
previous dba created this rollback segment at the time of db creation and forgot 
to take it offline . 
Now how do I find it this rollback segment is being 
used actively . I see values in gets , writes from v$rollstat view 
.
 
What step should I take to drop this rollback 
segment . What implication might have if I take this offline ? I want to relase 
the space taken by this rollback segment ( >600 extents ..thats big ) , so 
just taking offline wont do this.
 
Are there any views accessible from system( no 
sys) account which can tell me which trasaction is using which rollback 
segment .
 
 
thanks
-ak
 
 
 
 

Re: db file scattered read

[Jonathan Lewis]

It's doing that because it ISN'T reading
a sequential set of blocks.   In my example
(taken from your original list) block 14,709
is presumably already in the buffer, so
Oracle has to read up to it, (which takes
three blocks), skip it, and then start again
at the block after.

Arguably it might be a better strategy for
Oracle to allocate an 8-block multiblock
object and always read 8 blocks into,
then 'free' any that are already in the buffer.
But it doesn't - and there may or may not
be a very sensible argument why not, it
might simply be an accident of history.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 14 March 2003 21:04


> Thanks Jonathen ,
> But what I am pointing to is , why it is reading 3 blocks first time
and
> then 8 blocks next time ,  why not 8 blocks  always .
> Look at p3 which is no of block read .
>
> >
> >
> > Here is a part of trace file . I am finding that oracle is trying
to
> > read 8 or 3 or 7 blocks at a time . But block numbers are all
> > sequential i.e. it will read 3 blocks starting from 14706 and then
8
> > blocks starting from 14710 ( 14706+3 ). Why it doesn't read 8
blcoks
> > always it multi_block_read is set to 8 ? Any Idea .
> > Also what is ela=1 ,does it mean elapsed time is 1 sentisec ?
> >
> >
> >
> > WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14706 p3=3
> > WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14710 p3=8


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: Sun=/var/messages HP-UX=???

[Anderson, Brian]

hpux 11.0 
man dmesg shows the standard setup using /var/adm/messages.

  dmesg looks in a system buffer for recently printed diagnostic
  messages and prints them on the standard output.  The messages are
  those printed by the system when unusual events occur (such as when
  system tables overflow or the system crashes).  If the - argument is
  specified, dmesg computes (incrementally) the new messages since the
  last time it was run and places these on the standard output.  This is
  typically used with cron (see cron(1)) to produce the error log
  /var/adm/messages by running the command:

   /usr/sbin/dmesg - >> /var/adm/messages

  every 10 minutes.

  The arguments core and system allow substitution for the defaults
  /dev/kmem and /stand/vmunix respectively, where core should be a file
  containing the image of the kernel virtual memory saved by the
  savecore(1M) command and system should be the corresponding kernel.
  If the system is booted with a kernel other than /stand/vmunix say
  /stand/vmunix_new, dmesg must be passed this name, the command must
  be,

   /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new

 WARNINGS
  The system error message buffer is of small, finite size.  dmesg is
  run only every few minutes, so there is no guarantee that all error
  messages will be logged.

 AUTHOR
  dmesg was developed by the University of California, Berkeley.

 FILES
  /var/adm/messageserror log (conventional location)
  /var/adm/msgbuf  memory scratch file for - option
  /dev/kmemspecial file containing the image of kernel
   virtual memory
  /stand/vmunixthe kernel, system name list

> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2003 3:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sun=/var/messages HP-UX=???
> 
> 
> What version of HP-UX?
> Here is what I get on HP-UX 11.0: 
> 
> df2hp105 [IWHA]: ll /var/adm/me*
> /var/adm/me* not found
> 
> - Kirti 
> 
> -Original Message-
> Sent: Friday, March 14, 2003 10:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Actually /var/adm/messages on hpux is the message file, which 
> my solaris 8(2.8) machine is also using /var/adm/messages, 
> maybe I changed this, I don't remember.
> /var/adm/syslog/ is the default syslog directory equivalent 
> to /var/log/ on solaris.
> 
> > -Original Message-
> > From: Nelson, Allan [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 13, 2003 9:20 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Sun=/var/messages HP-UX=???
> > 
> > 
> > /var/adm/syslog/syslog.log is the hp-ux equivelant.
> > 
> > -Original Message-
> > Sent: Thursday, March 13, 2003 12:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I monitor /var/messages on my Sun boxes, does HP-UX have 
> anytype of OS
> > log files worth monitoring?
> > 
> > Thanks,
> > Ethan
> -- 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Deshpande, Kirti
>   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.net
-- 
Author: Anderson, Brian
  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: constraints and optimizer

[Jonathan Lewis]

All recent versions of Oracle have used
unique, pk and not-null constraints to
help optimise queries - but I don't suppose
you were thinking of those in particular.

In general Oracle did not make use of
check constraints except for partition
views, but Oracle 9 can now make very
good use of check constraints to help
optimise queries.

There is an example on www.dbazine.com
by Vadim Tropashko demonstrating that
Oracle can combine the constraint
col_X = upper(col_X)
with the predicate
upper(col_X) = 'abc'
to infer the predicate
col_X = 'abc'
and so be able to use an index on col_X .


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 14 March 2003 20:19


>
> Hello,
>
> Env: Oracle 9.2.0.2.0 on Solaris 9
>
> I suspect this is a foolish question, but I will ask anyway:
> (It's Friday; my brain stops working after Wednesday)
> How much does the presence of constraints influence the optimizer,
> if the indexes are present?
>
> We are developing a method for transporting a large volume of data
> between a staging instance and a query instance of Oracle, using
transportable
> tablespaces (tts). When the tts export uses CONSTRAINTS=Y, the
> subsequent tts import takes about 4 hours; when the tts export
> excludes constraints, it takes about 1 hour. We prefer the 1 hour.
>
> I know we can do the constraints in a separate step and create them
> as ENABLE NOVALIDATE to save time, but the question was posed:
> Do we need them at all in an instance that will receive no updates,
> only queries, if the indexes exist?
>
> My first thought was, yes, the optimizer uses them, but I'm not sure
> how much value they add if the indexes exist. Is the optimizer MUCH
> more likely to make an intelligent choice if the constraints are
present,
> or is the presence of an index the major deciding factor?
>
> We do intend to do some testing with in-house queries, but I thought
I
> would pass this along, hoping some kind soul(s) will provide the
> benefit of their experience.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: Sun=/var/messages HP-UX=???

[Post, Ethan]

Thanks, I looked through both files (they are both here) and the information
in syslog seems more meaningfull on the HP-UX than what I see in the
messages file, it is just the opposite on the Sun box.  

- Ethan

-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Actually /var/adm/messages on hpux is the message file, which my solaris
8(2.8) machine is also using /var/adm/messages, maybe I changed this, I
don't remember.
/var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on
solaris.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  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: Standby errors

[Jeremiah Wilton]

Why does the copying of archive logs to the standby have anything to
do with a hot backup on the primary?  They seem like unrelated events.

The reason you are getting an incomplete log is that you are using
'alter system switch logfile'.  This command returns before archival,
so your copy can commence and finish before archival is complete.

The correct command to use is 'alter system archive log current'.
This command will not return until the current log is fully archived.
Than your copy can proceed safely.

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

On Fri, 14 Mar 2003, Ball, Terry wrote:

> Oracle 8.1.6 on Solaris 5.8.
> 
> We have a read-only standby database for one of our production databases.
> Each night, the standby is shutdown and the previous days archive logs from
> production are applied.  Then the database is brought backup in read-only
> mode.  To get the archive logs, a hot backup is done on the production
> database.  As the last step is the hot backup, a log switch is done and then
> the archive logs are ftp'd to the server where the standby is.
> 
> After the hot backup completed yesterday, the log switch occurred, and the
> logs sent, but when an attempt was made to apply the archive logs we got an
> error:
> 
> ORA-00332: archived log is too small - may be incompletely archived
> ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc'
> ORA-332 signalled during: ALTER DATABASE RECOVER
> 
> In looking at the archive log, both on the production and standby servers,
> they are the same size - 16k  (the block size for the db is 8k).  The next
> log is 8k in size and then there is another that is 16k before we see any
> that are normal sized.  These would have been the first logs _after_ the hot
> backup the night before.
> 
> In the alert log for the production db, it appears the log 1353 was archived
> _before_ 1352.
> 
> Has anyone seen this behavior before?  Does anybody have any idea why it
> happened in the first place?  Is there something we can do to make sure it
> never happens again?
> 
> 
> P.S.  We are upgrading to 9.2 this weekend, if that makes any difference.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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: db file scattered read

[AK]

Thanks Jonathen ,
But what I am pointing to is , why it is reading 3 blocks first time and
then 8 blocks next time ,  why not 8 blocks  always .
Look at p3 which is no of block read .

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:54 AM


>
> The counts are inclusive:
> 14706 / 3 means
> 14,706 14,707 14,708
>  so you have to skip one then start
> again at 14,710.
>
> Yes, 'ela' is the elapsed time in 1/100 of a second.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Now available One-day tutorials:
>   Cost Based Optimisation
>   Trouble-shooting and Tuning
>   Indexing Strategies
>
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> UK___April 8th
> UK___April 22nd
>
> Denmark May 21-23rd
>
> USA_(FL)_May 2nd
>
>
> Next dates for the 3-day seminar:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> UK_(Manchester)_May
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: 14 March 2003 17:04
>
>
> Here is a part of trace file . I am finding that oracle is trying to
> read 8 or 3 or 7 blocks at a time . But block numbers are all
> sequential i.e. it will read 3 blocks starting from 14706 and then 8
> blocks starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks
> always it multi_block_read is set to 8 ? Any Idea .
> Also what is ela=1 ,does it mean elapsed time is 1 sentisec ?
>
>
>
> WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14706 p3=3
> WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14710 p3=8
> WAIT #32: nam='db file scattered read' ela= 2 p1=4 p2=14718 p3=8
> WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14727 p3=3
> WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14731 p3=7
> WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14739 p3=3
> WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14744 p3=8
> WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=129784 p3=8
>
>
> Thanks
> -ak
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
>   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.net
-- 
Author: AK
  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: log buffer space

[Rachel Carmichael]

I remember seeing documentation on it for 8i as well.


--- Pete Sharman <[EMAIL PROTECTED]> wrote:
> Really?  I thought that condition was there pre-9i as well.  Maybe
> I'm
> mistaken.
> 
> Pete
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
>  
> 
> 
> -Original Message-
> WILLIAMS
> Sent: Friday, March 14, 2003 8:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Add one more condition: 
>New in Oracle 9i, it will write when 1 meg is reached, so the 1/3
> criteria is never reached if you use a big buffer.
> 
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Friday, March 14, 2003 8:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> KG,
> 
> Thanks for the response. Just for my curiosity, is it documented
> somewhere that the log buffer if flushed when 2/3rd full? From the
> Manual /server.920/a96524/c09procs.htm#3158 (please check the URL in
> OTN, the first part is not complete), here is an excerpt
> 
> 
> LGWR writes one contiguous portion of the buffer to disk. LGWR
> writes:
>   a.. A commit record when a user process commits a transaction
>   b.. Redo log buffers
> a.. Every three seconds
> b.. When the redo log buffer is one-third full
> c.. When a DBWn process writes modified buffers to disk, if
> necessary
> 
> 
> 
> At least this was the behavior I tested in 8.1.7; although I have not
> tested in 9i. This has also been stated by several Oracle Support
> Analysts.
> 
> Thanks.
> 
> Arup Nanda
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 7:32 AM
> 
> 
> > Arup:
> >
> > 
> > The second condition is not quite true. It is 2/3 full in the
> current 
> > versions. 
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
> >
> >
> > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > AK,
> > >
> > > If the log buffer is at least 4MB, then increasing it will not
> help,
> 
> > > rather it may hurt. The log buffer is flushed when any of the the
> 
> > > follwoing occur
> > > (i) 1 MB is filled up
> > > (2) 1/3rd is filled up
> > > (3) every 3 seconds
> > > (4) when a checkpoint occurs
> > > (5) when a commit occurs.
> > >
> > > Therefore, see if any of these could be the problem. It's easy to
> 
> > > check #s 4 and 3.
> > >
> > > As Kirti suggested, the problem could be due to the redo logs
> being 
> > > on a busy disk, or even a slow one.
> > >
> > > HTH.
> > >
> > > Arup
> > >   - Original Message -
> > >   From: Deshpande, Kirti
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Thursday, March 13, 2003 8:13 PM
> > >   Subject: RE: log buffer space
> > >
> > >
> > >   Increasing log_buffer size is an option, if it is really small.
> > >   I would also check if the redo logs are on a busy disk. If so,
> try
> 
> > > moving those (or other busy data files on the same disk) to other
> 
> > > not-so-busy disks.
> > >
> > >   - Kirti
> >
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: K Gopalakrishnan
> >   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.net
> -- 
> Author: Arup Nanda
>   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.net
> -- 
> 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: Sun=/var/messages HP-UX=???

[Deshpande, Kirti]

What version of HP-UX?
Here is what I get on HP-UX 11.0: 

df2hp105 [IWHA]: ll /var/adm/me*
/var/adm/me* not found

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) 
machine is also using /var/adm/messages, maybe I changed this, I don't remember.
/var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris.

> -Original Message-
> From: Nelson, Allan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 9:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sun=/var/messages HP-UX=???
> 
> 
> /var/adm/syslog/syslog.log is the hp-ux equivelant.
> 
> -Original Message-
> Sent: Thursday, March 13, 2003 12:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS
> log files worth monitoring?
> 
> Thanks,
> Ethan
-- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: db file scattered read

[Jonathan Lewis]

The counts are inclusive:
14706 / 3 means
14,706 14,707 14,708
 so you have to skip one then start
again at 14,710.

Yes, 'ela' is the elapsed time in 1/100 of a second.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 14 March 2003 17:04


Here is a part of trace file . I am finding that oracle is trying to
read 8 or 3 or 7 blocks at a time . But block numbers are all
sequential i.e. it will read 3 blocks starting from 14706 and then 8
blocks starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks
always it multi_block_read is set to 8 ? Any Idea .
Also what is ela=1 ,does it mean elapsed time is 1 sentisec ?



WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14706 p3=3
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14710 p3=8
WAIT #32: nam='db file scattered read' ela= 2 p1=4 p2=14718 p3=8
WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14727 p3=3
WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14731 p3=7
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14739 p3=3
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14744 p3=8
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=129784 p3=8


Thanks
-ak

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: log buffer space

[DENNIS WILLIAMS]

Arup
   I have a busy day, so the only resource I can quote without research is
the Oracle Education Oracle9i Database Performance Tuning Student Guide.
Lesson 5-3 reads: "When the redo log buffer is one-third full". Hope that
answers your question.

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


-Original Message-
Sent: Friday, March 14, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Dennis,

The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned in my
original post.

I was always under impresssion that the flush is triggered by the buffer
being 1/3rd full; but KG mentioned it was 2/3rd, not 1/3rd and I was
wondering where he got that information from and if it's documented. It
true, that will certainly invalidate most of the what the fine manuals and
Oracle Support analysts have said.

Any ideas, anybody?

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:18 AM


> Add one more condition:
>New in Oracle 9i, it will write when 1 meg is reached, so the 1/3
> criteria is never reached if you use a big buffer.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Friday, March 14, 2003 8:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> KG,
>
> Thanks for the response. Just for my curiosity, is it documented somewhere
> that the log buffer if flushed when 2/3rd full? From the Manual
> /server.920/a96524/c09procs.htm#3158 (please check the URL in OTN, the
first
> part is not complete), here is an excerpt
>
> 
> LGWR writes one contiguous portion of the buffer to disk. LGWR writes:
>   a.. A commit record when a user process commits a transaction
>   b.. Redo log buffers
> a.. Every three seconds
> b.. When the redo log buffer is one-third full
> c.. When a DBWn process writes modified buffers to disk, if necessary
>
> 
>
> At least this was the behavior I tested in 8.1.7; although I have not
tested
> in 9i. This has also been stated by several Oracle Support Analysts.
>
> Thanks.
>
> Arup Nanda
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 7:32 AM
>
>
> > Arup:
> >
> > 
> > The second condition is not quite true. It is 2/3 full in the current
> > versions.
> > 
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
> >
> >
> > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > AK,
> > >
> > > If the log buffer is at least 4MB, then increasing it will not help,
> > > rather it may hurt. The log buffer is flushed when any of the the
> > > follwoing occur
> > > (i) 1 MB is filled up
> > > (2) 1/3rd is filled up
> > > (3) every 3 seconds
> > > (4) when a checkpoint occurs
> > > (5) when a commit occurs.
> > >
> > > Therefore, see if any of these could be the problem. It's easy to
> > > check #s 4 and 3.
> > >
> > > As Kirti suggested, the problem could be due to the redo logs being
> > > on a busy disk, or even a slow one.
> > >
> > > HTH.
> > >
> > > Arup
> > >   - Original Message -
> > >   From: Deshpande, Kirti
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Thursday, March 13, 2003 8:13 PM
> > >   Subject: RE: log buffer space
> > >
> > >
> > >   Increasing log_buffer size is an option, if it is really small.
> > >   I would also check if the redo logs are on a busy disk. If so, try
> > > moving those (or other busy data files on the same disk) to other
> > > not-so-busy disks.
> > >
> > >   - Kirti
> >
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: K Gopalakrishnan
> >   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.net
> --
> Author: Arup Nanda
>   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 containi

constraints and optimizer

[becker . bill]

Hello,

Env: Oracle 9.2.0.2.0 on Solaris 9

I suspect this is a foolish question, but I will ask anyway:
(It's Friday; my brain stops working after Wednesday)
How much does the presence of constraints influence the optimizer,
if the indexes are present?

We are developing a method for transporting a large volume of data 
between a staging instance and a query instance of Oracle, using transportable
tablespaces (tts). When the tts export uses CONSTRAINTS=Y, the
subsequent tts import takes about 4 hours; when the tts export
excludes constraints, it takes about 1 hour. We prefer the 1 hour.

I know we can do the constraints in a separate step and create them
as ENABLE NOVALIDATE to save time, but the question was posed: 
Do we need them at all in an instance that will receive no updates, 
only queries, if the indexes exist? 

My first thought was, yes, the optimizer uses them, but I'm not sure
how much value they add if the indexes exist. Is the optimizer MUCH
more likely to make an intelligent choice if the constraints are present,
or is the presence of an index the major deciding factor?

We do intend to do some testing with in-house queries, but I thought I
would pass this along, hoping some kind soul(s) will provide the
benefit of their experience.

Thanks to any responders. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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: Backup Strategy

[Hallas, John, Tech Dev]

I have found Joe Testa's site has a good set of RMAN scripts (I think they came from 
Jack van Zanen off this list), quite simple but they give the syntax for most of the 
commands you will want
The link was http://www.oracle-dba.com but that is no longer working

Where have you put them Joe??

John

-Original Message-
Sent: 14 March 2003 16:34
To: Multiple recipients of list ORACLE-L


Jay
If you want a good book to get up to speed on RMAN, buy
Oracle9i RMAN Backup & Recovery by Robert Freeman and Matthew Hart
 
If you want to compare the steps for various recovery scenarios between RMAN
and user-managed recovery, get Oracle Backup & Recovery 101 by Smith and
Haisley. It has you create a small test database and then run various backup
and recovery steps for various types of failures and recoveries.



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

-Original Message-
Sent: Friday, March 14, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L



Dear All, 

Iam entitled the responsibility to come out with a plan for Backup (using
RMAN) for our 
forthcoming data centre operations. Could someone help me on this? 

I would also like to know the steps for Recovery in the case of a Redo Log
member failure, 
using RMAN and the traditional Recovery commands from SQLPLUS. 

TIA . 

Best Regards
Jai

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hallas, John, Tech Dev
  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).

[no subject]

[Joseph S Testa]

They have been removed due to my rman framework scripts taking the disk
space.

Sorry.

Joe



>I have found Joe Testa's site has a good set of RMAN scripts (I think
>they came from Jack van Zanen off this list), quite simple but they
>give the syntax for most of the commands you will want
>The link was http://www.oracle-dba.com but that is no longer working

>Where have you put them Joe??

>John





Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

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

RE: Oracle JDBC thin driver

[Pete Sharman]

Title: Message



No, that's why it's the thin driver.  If you want TAF capability, 
you have to use the JDBC thick driver instead.
 
 

Pete

"Controlling 
developers is like herding cats."
Kevin 
Loney, Oracle DBA Handbook
"Oh 
no, it's not.  It's much harder than 
that!"
Bruce 
Pihlamae, long-term Oracle DBA
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Rick StephensonSent: 
  Friday, March 14, 2003 10:15 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle JDBC thin driver
  
  Oracle 9.2.0.2
   
  Can the Oracle JDBC thin driver be 
  used with RAC to setup failover and load balancing between instances in the 
  same way the thick driver can?
   
  Thanks,
   
  Rick Stephenson
   
  This email and any files transmitted with it are 
  confidential and intended solely for the use of the individual or entity to 
  which they are addressed. This message contains confidential information and 
  is intended only for the individual named. If you are not the named addressee 
  you should not disseminate, distribute or copy this e-mail. Please notify the 
  sender immediately by e-mail if you have received this e-mail by mistake and 
  delete this e-mail from your system. If you are not the intended recipient you 
  are notified that disclosing, copying, forwarding or otherwise distributing or 
  taking any action in reliance on the contents of this information is strictly 
  prohibited. 

Re: Fixed_date and dbms_job

[Darrell Landrum]

Thanks!!

Darrell Landrum
Database Administrator
Zale Corporation

>>> [EMAIL PROTECTED] 03/14/03 12:44PM >>>
It takes 16 failures to mark the job as "broken".

Igor Neyman, OCP DBA
[EMAIL PROTECTED] 



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:24 AM


> Ben,
>
> If this problem has not been fixed, check something else.
> Run:
> select job, what, broken, failures from dba_jobs;
>
> I don't know how many, but after a certain number of failures, a job is
marked as broken and won't run automatically.
>
>
> Darrell
>
>
>
> >>> [EMAIL PROTECTED] 03/14/03 08:38AM >>>
> Thanks Jacques,
>  Yes I did:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
> true);
> commit;
> end;
> /
>
> Ben
>
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > After calling dbms_job.submit, did you issue a
> > commit?
> >
> > > -Original Message-
> > > From: Kader Ben [mailto:[EMAIL PROTECTED] 
> > >
> > >  I'm simulating the date in future with
> > fixed_date.
> > > I wrote procedure to be called every seconde
> > through
> > > dbms_job to increment the fixed_date.
> > >
> > > I did that dbms_job.submit(:job_num,
> > 'myprocedure;',
> > > sysdate, 'sysdate');
> > >
> > > the  dba_jobs table show me the right interval un
> > > next_date:
> > >
> > >
> > > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> > INTERVAL
> > > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> > sysdate
> > >
> > > And the sysdate is:
> > > 13-JUN-2003 17:50:06
> > >
> > > But the job never execute.
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: Kader Ben
>   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.net 
> --
> Author: Darrell Landrum
>   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.net 
-- 
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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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: File Restoration/Recovery

[Jamadagni, Rajendra]

Title: RE: File Restoration/Recovery





Schema level export can fix the *thinking* 


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: File Restoration/Recovery



Gary - send the developer to backup and recovery school.


he is wrong.  as Rachel said, *maybe* it will work once.  but as a DBA, you
personally can *never* support this in a real environment.  you will not be
able to guarantee the same results every time.


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L



All...


A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance.  I explain that it will be a waste of
tape because the files will be corrupt and useless.  He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."


Will this be the case?  I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again?  TIA


Gary Chambers


//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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.net
-- 
Author: Mercadante, Thomas F
  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).




*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: segment from block#

[Deshpande, Kirti]

You will need FILE_ID as well.
Here is what I use:

-- find_segment.sql 
-- Finds segment name based on file_id and block_id 
set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30
select Owner,
   Segment_Name,
   Segment_Type,
   Tablespace_Name
from
DBA_EXTENTS
where
File_Id = &File_Id_In
and &Block_Id_in between
Block_Id and Block_Id + Blocks - 1;


- Kirti 


-Original Message-
Sent: Friday, March 14, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


Is this a good query to find segment where this block ( 259186 )  belongs ?
select  segment_name 
from dba_extents
where block_id<= 259186 and 259186 <= block_id+blocks


-ak

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: db file scattered read

[Cary Millsap]

For the answer to your first question, see
Jeff Holt’s “Predicting
Multiblock Read Size” at www.hotsos.com/catalog.
Prior to Release 9, the statistic “ela= 1” means that the syscall lasted
somewhere between 0.005000 and 0.014999 seconds in duration. Full details
forthcoming in “Optimizing Oracle Performance”,
due out in approximately July.

 



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

Upcoming events:
- Hotsos Clinic 101,
Mar 25–27 Oxford
- Hotsos Clinic 101,
Apr 8–10 Chicago



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of AK
Sent: Friday, March 14, 2003 11:05
AM
To: Multiple recipients of list
ORACLE-L
Subject: db file scattered read

 



Here is a part of trace file . I am finding that oracle is
trying to read 8 or 3 or 7 blocks at a time . But block numbers are all
sequential i.e. it will read 3 blocks starting from 14706 and then 8 blocks
starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks always it
multi_block_read is set to 8 ? Any Idea .





Also what is ela=1 ,does it mean elapsed time is 1 sentisec
?





 





 





 





WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14706
p3=3
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14710 p3=8
WAIT #32: nam='db file scattered read' ela= 2 p1=4 p2=14718 p3=8
WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14727 p3=3
WAIT #32: nam='db file scattered read' ela= 0 p1=4 p2=14731 p3=7
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14739 p3=3
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14744 p3=8
WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=129784 p3=8





 





 





Thanks





-ak

How to get working hours ???

[Andrea Oracle]

Hi,

We have open Time for every order, ef:

Open Time
--
03/12/03 11:08:07

How to calculate the working hours (8am - 5pm, no
weekends) that a file remain open until now?  (Sysdate
- Open_Time) returns all the hours including weekend
and <8am, >5pm hours.  We only like to know the
WORKING hours.

Thank you so much!

Andrea

__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Andrea Oracle
  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: High current mode buffer gets on insert

[Jonathan Lewis]

Current mode gets for index inserts is one
option.  Another cause of CU gets is from
checking referential integrity.  The block
holding the parent key is acquired in current
mode as the child row is inserted.  There
is an optimisation to reduce this effect in
arrays/select inserts in Oracle 9, though.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 14 March 2003 16:43


> I thought I'd repost to see if I could get a response.  Anyone?
>
>
> --- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> > I'm looking at a client's tkprof output, showing among other
things
> > that the insertion of about 135,000 rows taking 450 seconds of
CPU,
> > and
> > with current mode buffer gets numbering almost 800,000.  This is a
> > daily warehouse load process, and I know that indexes are left in
> > place
> > during the load.  Am I correct in concluding that the high CPU,
and
> > especially the current mode block gets numbering over 6 times the
> > number of rows inserted, are due to index updates?
> >


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: Fixed_date and dbms_job

[Igor Neyman]

It takes 16 failures to mark the job as "broken".

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:24 AM


> Ben,
>
> If this problem has not been fixed, check something else.
> Run:
> select job, what, broken, failures from dba_jobs;
>
> I don't know how many, but after a certain number of failures, a job is
marked as broken and won't run automatically.
>
>
> Darrell
>
>
>
> >>> [EMAIL PROTECTED] 03/14/03 08:38AM >>>
> Thanks Jacques,
>  Yes I did:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
> true);
> commit;
> end;
> /
>
> Ben
>
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > After calling dbms_job.submit, did you issue a
> > commit?
> >
> > > -Original Message-
> > > From: Kader Ben [mailto:[EMAIL PROTECTED]
> > >
> > >  I'm simulating the date in future with
> > fixed_date.
> > > I wrote procedure to be called every seconde
> > through
> > > dbms_job to increment the fixed_date.
> > >
> > > I did that dbms_job.submit(:job_num,
> > 'myprocedure;',
> > > sysdate, 'sysdate');
> > >
> > > the  dba_jobs table show me the right interval un
> > > next_date:
> > >
> > >
> > > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> > INTERVAL
> > > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> > sysdate
> > >
> > > And the sysdate is:
> > > 13-JUN-2003 17:50:06
> > >
> > > But the job never execute.
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kader Ben
>   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.net
> --
> Author: Darrell Landrum
>   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.net
-- 
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: RE: why SAN ? why not external storage ?

[Scott . Shafer]

All of the places I've worked its been sysadmins fat-fingering that has
hosed or cross mounted disks.  Then again, we've never had EMC...  HP arrays
are enough trouble.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2003 12:36 PM
> To:   [EMAIL PROTECTED]; Multiple recipients of list
> ORACLE-L
> Subject:  Re:RE: why SAN ? why not external storage ?
> 
> Humm, must of missed this one on the rebound.  Anyway, here Disk space is
> an
> admin nightmare.  Each time we want to reassign disks from one server to
> another
> here comes EMC to re-program the Symmetrix array otherwise the SA has the
> possibility of assigning 2 servers to the same disk.  OOPS I really did
> not wnat
> to do a newfs on that disk!!!?!??!  And at $4000 per disk (72GB) I would
> not say
> that their cheap.  IDE drives have gotten real cheap, when will SCSI
> follow
> suit??
> 
> Dick Goulet
> 
> Reply Separator
> Subject:RE: why SAN ? why not external storage ?
> Author: [EMAIL PROTECTED]
> Date:   3/14/2003 10:03 AM
> 
> Oh, Gods forbid the sysadmins would have to  do their job...
> 
> HAHAHAHAHA!!!
> 
> Scott Shafer
> San Antonio, TX
> 210.581.6217
> 
> 
> > -Original Message-
> > From: Mogens Norgaard [SMTP:[EMAIL PROTECTED]
> > Sent: Thursday, March 13, 2003 5:25 PM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Re: why SAN ? why not external storage ?
> > 
> > There are many things I don't get in this life. One of them is the 
> > statements about disk storage being an admin nightmare and way too 
> > expensive. Aren't disks very cheap these days?!
> > 
> > Mogens
> > 
> > [EMAIL PROTECTED] wrote:
> > 
> > >Rahul,
> > >
> > >This is personal opinion, but it looks to me like your concerned
> > about the
> > >database your creating for the client and may not have the total or
> > corporate
> > >wide view your client has.  We're heading down the SAN road not because
> > of any
> > >specific database requirements but because disk storage has become an
> > >administrative nightmare as well as way too expensive.
> > >
> > >Dick Goulet
> > >
> > >Reply Separator
> > >Author: "Arun Annamalai" <[EMAIL PROTECTED]>
> > >Date:   3/13/2003 12:24 PM
> > >
> > >Usaually SAN and NAS is used for several good reasons...the two main
> > are...
> > >1) High availability - When you have your database files on SAN/NAS
> then
> > you can
> > >bring ur database on another server when the primary goes down.
> Obviously
> > you
> > >have to use a cluster or Big IP (F5) on the front.
> > >2) reduce redundancy -A unix userid with home directory attached to a
> > paticular
> > >NFS drive on NAS/SAN, will  able to see all his files when he logs into
> > other
> > >servers.
> > >
> > >so far I heard "Net App" is low cost including with Raid 5.
> > >
> > >-Arun.
> > >Sr oracle dba
> > >  - Original Message - 
> > >  From: Rahul 
> > >  To: Multiple recipients of list ORACLE-L 
> > >  Sent: Wednesday, March 12, 2003 9:38 PM
> > >  Subject: Re: why SAN ? why not external storage ?
> > >
> > >
> > >  my reasons to recommend an external storage was..
> > >  1) the database size is 36GB, and according to many documents i have
> > read, SAN
> > >is not cost effevtive unless populated 
> > >  by a large numbers of drives !!, now for the client the cost is not
> the
> > >factor.. given the situation.. wouldnt a SAN be an overkill ? 
> > >
> > >  2) NO DBA or SYS ADMIN skills to manage the SAN !! 
> > >
> > >- Original Message - 
> > >From: Tim Gorman 
> > >To: Multiple recipients of list ORACLE-L 
> > >Sent: Wednesday, March 12, 2003 8:33 PM
> > >Subject: Re: why SAN ? why not external storage ?
> > >
> > >
> > >Can you share some of the reasons related to your decision in
> > choosing a
> > >direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
> > much
> > >smarter choice than DAS.
> > >  - Original Message - 
> > >  From: Rahul 
> > >  To: Multiple recipients of list ORACLE-L 
> > >  Sent: Wednesday, March 12, 2003 1:33 AM
> > >  Subject: why SAN ? why not external storage ?
> > >
> > >
> > >  list, one of our clietns are going to by SAN, the current oracle
> > databases
> > >take around 
> > >  36GB of storage i dnt understand there reason to go for SAN,
> i
> > >sugguested to buy an external storage 
> > >  box instead. How can i justify my desicion ? (cost of not the
> > factor) 
> > >
> > >  TIA
> > >  rahul
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >Usaually SAN and NAS is used for several
> > good 
> > >reasons...the two main are...
> > >1) High availability - When you have your
> > database 
> > >files on SAN/NAS then you can bring ur database on another server when
> > the 
> > >primary goes down. Obviously 

RE: Organizational Challenge - Data Management Team

[Mercadante, Thomas F]

Ron,

I think you are starting at a good place.

Production DBA's worry about different things than Development DBA's.
Mostly they are concerned with (in priority order) Backup schedules &
Validations (make sure they are working), disk usage (make sure there is
enough) and on-going tuning issues.  Add to that the migration of new
releases of the product and database structure changes.

Development DBA's deal with (in priority order) rapid changes to the
database structure,migration of the changes to user test and production
instances, disk sizings of projected data, and delivering the application
and database to a production environment.

So you can see that the priorities are a bit different.

Saying that, I think the best structure is to have a team of people who
monitor production databases.  This could be done in a rotating basis so
that everyone can become familiar with the production environment.  And I
really think that having a DBA assigned to a database as it is being
developed is a good idea.  The application team gets a dedicated person who
grows in knowledge with the system.  

Of course, all of this only works if you have solid DBA Standards -
everything from server structure layout to database object naming standards.
This creates an environment where anyone can step in anyplace and learn the
system as quickly as possible.

Good luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, March 14, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L


Ron - As a solo DBA shop, I can't be much help except to point out that most
of what I've heard involves the DBAs specializing between production work
and development work. Some DBAs administer the production databases, others
work with the developers. This also seems to suit the personality types.



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

-Original Message-
Sent: Thursday, March 13, 2003 6:39 PM
To: Multiple recipients of list ORACLE-L


All,
 
I would like to open a discussion to solicit information regarding the
support structure you utilize in your Data Management department.
 
We currently have a flat end-to-end approach whereby a dba adopts an
application and subsequent database in the early planning stages via teaming
up with the Data Architect and developers and owns that application all the
way through design, development, testing, and ultimately production support.
 
As a smaller group (3-5) dba's this model worked fine, and everyone knew
their respective database quite well.
 
As more and more applications (internal and 3rd party) continue to rollover
from legacy systems into Oracle solutions, this is proving to be very
challenging to provide 24x7 support and related on-call duties spanning
three RDBMS platforms (Informix, Oracle, and MS SQL Server).  Our challenges
are two fold:
 
One, we are (like any shop today) extremely overloaded with work requests,
so this makes cross-application training to spread the knowledge nearly
impossible to accomplish. 
Two, with everyone tied to a project, we have no resource with large enough
buckets of time to take on new and imperative technologies such as java,
replication, high availability, xml as examples that our development teams
would like to leverage in the database.
 
We are in the early stages of looking at organization alternatives.  We are
fortunate in that 90% of the database support is already centralized in our
department for the company, so that allows us the ability to minimize every
dba learning lessons the hard way.   
 
Specifically, we are considering some "role" divisions amongst the DBA's.
That is to say a subset dedicated to "engineering" such as implementing and
architecting new technologies and related best practices, a second subset
for implementation of systems being developed, and a third subset for
production support.
 
I would like to hear about the organization structure you are involved with
and the pro and cons of a flat structure as compared to a more "role" based
structure.
 
Thanks in advance,
-Ron-
Lead Oracle DBA
 

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

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

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

Re: Veritas Quick I/O for Oracle

[Brian Haas]

DENNIS WILLIAMS wrote:
Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming "up to 400 times faster". I would like to know if
anyone else has discovered this miracle and what benefits you are seeing.
Thanks.


Dennis,

What version of Oracle are you running? And are you purchsing Veritas 
Database Edition for Oracle or just the quick IO feature? Veritas 
database edition takes advantage of Oracle Disk Manager API. According 
to veritas benchmarks, using ODM is about the same as using raw devices 
and quick IO, but without any management. If you set up veritas to use 
ODM any datafiles you create will automatically use it.

Read more here:

http://seer.support.veritas.com/docs/249774.htm -- Database Edition 
Admin guide.

http://eval.veritas.com/downloads/pro/db_edition/dbed_35_sol9_ext.pdf

White paper with benchmark results of various IO methods.

I think they(veritas) are recommending ODM with Oracle 9

I'm planning on using ODM with DBED 3.5 on Solaris on the new hardware 
we just got for our data warehouse.

I'm also using quick IO on an 817 instance. I can't really say if it's 
faster or not, because when we also had a major database and codebase 
change when we implemented it so I can't really compare it to the 
previous instance, but I doubt it's anywhere close to 400 times faster.

-Brian

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian Haas
 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: Bypassing startup triggers

[Chaim . Katz]

How about
alter system set "_system_trig_enabled" =false
chaim





"Thomas Day" <[EMAIL PROTECTED]>@fatcity.com on 03/14/2003 12:04:33 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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




Any way to do that?

Fast answer is appreciated.

TIA


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
  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.net
-- 
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: log buffer space

[Pete Sharman]

Maybe finger stutter.  I've never seen it mentioned anywhere except as
1/3.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Friday, March 14, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L


Dennis,

The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned
in my original post.

I was always under impresssion that the flush is triggered by the buffer
being 1/3rd full; but KG mentioned it was 2/3rd, not 1/3rd and I was
wondering where he got that information from and if it's documented. It
true, that will certainly invalidate most of the what the fine manuals
and Oracle Support analysts have said.

Any ideas, anybody?

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:18 AM


> Add one more condition:
>New in Oracle 9i, it will write when 1 meg is reached, so the 1/3 
> criteria is never reached if you use a big buffer.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Friday, March 14, 2003 8:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> KG,
>
> Thanks for the response. Just for my curiosity, is it documented 
> somewhere that the log buffer if flushed when 2/3rd full? From the 
> Manual /server.920/a96524/c09procs.htm#3158 (please check the URL in 
> OTN, the
first
> part is not complete), here is an excerpt
>
> 
> LGWR writes one contiguous portion of the buffer to disk. LGWR writes:
>   a.. A commit record when a user process commits a transaction
>   b.. Redo log buffers
> a.. Every three seconds
> b.. When the redo log buffer is one-third full
> c.. When a DBWn process writes modified buffers to disk, if 
> necessary
>
> 
>
> At least this was the behavior I tested in 8.1.7; although I have not
tested
> in 9i. This has also been stated by several Oracle Support Analysts.
>
> Thanks.
>
> Arup Nanda
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 7:32 AM
>
>
> > Arup:
> >
> > 
> > The second condition is not quite true. It is 2/3 full in the 
> > current versions. 
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
> >
> >
> > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > AK,
> > >
> > > If the log buffer is at least 4MB, then increasing it will not 
> > > help, rather it may hurt. The log buffer is flushed when any of 
> > > the the follwoing occur
> > > (i) 1 MB is filled up
> > > (2) 1/3rd is filled up
> > > (3) every 3 seconds
> > > (4) when a checkpoint occurs
> > > (5) when a commit occurs.
> > >
> > > Therefore, see if any of these could be the problem. It's easy to 
> > > check #s 4 and 3.
> > >
> > > As Kirti suggested, the problem could be due to the redo logs 
> > > being on a busy disk, or even a slow one.
> > >
> > > HTH.
> > >
> > > Arup
> > >   - Original Message -
> > >   From: Deshpande, Kirti
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Thursday, March 13, 2003 8:13 PM
> > >   Subject: RE: log buffer space
> > >
> > >
> > >   Increasing log_buffer size is an option, if it is really small.
> > >   I would also check if the redo logs are on a busy disk. If so, 
> > > try moving those (or other busy data files on the same disk) to 
> > > other not-so-busy disks.
> > >
> > >   - Kirti
> >
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: K Gopalakrishnan
> >   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.net
> --
> Author: Arup Nanda
>   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 w

Ignore post about startup trigger

[Thomas Day]

That wasn't the problem at all.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  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: utl_file_dir and 9i

[Pete Sharman]

Nah, can't do that!  It would make our training courses that use it too
difficult to set up!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Kirti
Sent: Friday, March 14, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L


Precisely 

But wouldn't it be nice if Oracle made '*', in the utl_file_dir
specification, an unacceptable parameter value? 

- Kirti


-Original Message-
Sent: Friday, March 14, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway!  Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it.  Hmm, could that cause any problems?  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Landrum
Sent: Friday, March 14, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L


Good points, also consider the security issues that exist because of
'util_file_dir=*'. With that, any user that can run a procedure and
write (or overwrite) files in locations that should be accessible only
by oracle.


>>> [EMAIL PROTECTED] 03/14/03 07:08AM >>>
John,

In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY'
rather than UTL_FILE_DIR ... firstly because a directory can be created
dynamically, so to adda new sub-directory you don't have to bounce the
instance.

Plus instead of '*', you can dynamically create directory ... read/write
and drop the directory if you wish.

I'd recommend you make use of this feature John, because UTL_FILE_DIR
might just go away  because of its limitations.

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!


-Original Message-
Sent: Friday, March 14, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


In 8i we set utl_file_dir = "*" because otherwise we have to specify
lots of individual directories. It was not possible to just specify a
top level directory.

Has this changed in 9i?   Is it possible to specify a top level
directory
and then utl_file  can write to subdirectories?

John


-- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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.net
-- 
Author: Pete Sharman
  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: Multiple Instances and 9iRAC

[Arup Nanda]

Todd,
 
RAC is a multi-instance database. If you have n 
nodes in a cluster then you generally have (although not necessarily that many) 
n instances accessing the same database. When you mention 3 or more Oracle 
instances, perhaps you mean 3 or more "databases" each in a separate cluster of 
4 to 8 nodes each.
 
Interconnect plays a very important role in 
performance in this case and depends heavily on the hardware you decide on. For 
instance if you use Tru64 Clusters on Compaq alphas, you would probably go for 
Memory channels as interconnect; but for HP clusters you will lean towards CLIC 
interface.
 
The environment you mentioned is not just viable, 
but that's exactly how it is done.
 
HTH.
 
Arup Nanda

  - Original Message - 
  From: 
  Thompson, Todd 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, March 14, 2003 1:29 
PM
  Subject: Multiple Instances and 9iRAC 
  
  
  
   
  My 
  company is currently considering using Oracle 9i RAC. One of the proposed 
  environments is to have multiple oracle instances (3 or more) configured on a 
  4-8 node RAC cluster. Does anyone have any insights as to the viability of 
  this implementation?  Will the high speed inter connect be able to handle 
  the traffic from multiple instances?  I always thought of RAC as a single 
  instance implementation with each instance needing its own 
  cluster...

RE: File Restoration/Recovery

[Pete Sharman]

What can I say?  Shoot the danged developer!

No, no, no, no, no.  The backup is as much use as the proverbial  on
a bull.  Period.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Chambers
Sent: Friday, March 14, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L


All...

A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance.  I explain that it will be a waste of
tape because the files will be corrupt and useless.  He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."

Will this be the case?  I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again?  TIA

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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.net
-- 
Author: Pete Sharman
  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: log buffer space

[Arup Nanda]

Dennis,

The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned in my
original post.

I was always under impresssion that the flush is triggered by the buffer
being 1/3rd full; but KG mentioned it was 2/3rd, not 1/3rd and I was
wondering where he got that information from and if it's documented. It
true, that will certainly invalidate most of the what the fine manuals and
Oracle Support analysts have said.

Any ideas, anybody?

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:18 AM


> Add one more condition:
>New in Oracle 9i, it will write when 1 meg is reached, so the 1/3
> criteria is never reached if you use a big buffer.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Friday, March 14, 2003 8:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> KG,
>
> Thanks for the response. Just for my curiosity, is it documented somewhere
> that the log buffer if flushed when 2/3rd full? From the Manual
> /server.920/a96524/c09procs.htm#3158 (please check the URL in OTN, the
first
> part is not complete), here is an excerpt
>
> 
> LGWR writes one contiguous portion of the buffer to disk. LGWR writes:
>   a.. A commit record when a user process commits a transaction
>   b.. Redo log buffers
> a.. Every three seconds
> b.. When the redo log buffer is one-third full
> c.. When a DBWn process writes modified buffers to disk, if necessary
>
> 
>
> At least this was the behavior I tested in 8.1.7; although I have not
tested
> in 9i. This has also been stated by several Oracle Support Analysts.
>
> Thanks.
>
> Arup Nanda
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 7:32 AM
>
>
> > Arup:
> >
> > 
> > The second condition is not quite true. It is 2/3 full in the current
> > versions.
> > 
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
> >
> >
> > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > AK,
> > >
> > > If the log buffer is at least 4MB, then increasing it will not help,
> > > rather it may hurt. The log buffer is flushed when any of the the
> > > follwoing occur
> > > (i) 1 MB is filled up
> > > (2) 1/3rd is filled up
> > > (3) every 3 seconds
> > > (4) when a checkpoint occurs
> > > (5) when a commit occurs.
> > >
> > > Therefore, see if any of these could be the problem. It's easy to
> > > check #s 4 and 3.
> > >
> > > As Kirti suggested, the problem could be due to the redo logs being
> > > on a busy disk, or even a slow one.
> > >
> > > HTH.
> > >
> > > Arup
> > >   - Original Message -
> > >   From: Deshpande, Kirti
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Thursday, March 13, 2003 8:13 PM
> > >   Subject: RE: log buffer space
> > >
> > >
> > >   Increasing log_buffer size is an option, if it is really small.
> > >   I would also check if the redo logs are on a busy disk. If so, try
> > > moving those (or other busy data files on the same disk) to other
> > > not-so-busy disks.
> > >
> > >   - Kirti
> >
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: K Gopalakrishnan
> >   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.net
> --
> Author: Arup Nanda
>   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.net
> --
> 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: Bypassing startup triggers

[Darrell Landrum]

You might try putting
_system_trig_enabled=FALSE
in your init file.  I'd test this though to make sure.
(or disable the triggers in question)

>>> [EMAIL PROTECTED] 03/14/03 11:04AM >>>

Any way to do that?

Fast answer is appreciated.

TIA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Thomas Day
  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.net
-- 
Author: Darrell Landrum
  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: File Restoration/Recovery

[Darrell Landrum]

Gary,

I second this user's comments.  Is it possible to get a valid backup while the 
database is up?  Yes, it is but it is just plain silly (at the very least), to plan to 
do so.  Whether or not this backup is good depends on no activity and if there's no 
activity, why not just shut it down and do the copy.  If this is a development system, 
you're better off shutting it down to back it up.  If it is production, it should be 
in archivelog mode and you can leave it up but do nightly 'hot' backups by putting the 
tablespaces in backup mode.
I agree with you, I would not routinely, as a plan, write these files to tape (unless, 
perhaps, your setup allows you to write these files to the same tape(s) each night).
If one were to make a list of different ways to backup this database and list them in 
order of best to worst, this idea of online copies would honestly be near or at the 
bottom.

Hope this helps.
Darrell

>>> [EMAIL PROTECTED] 03/14/03 10:54AM >>>
no no no no no no

If he is REALLY lucky, and no one is using the database at the instant
he does all the copies (and I mean the OS as well), then MAYBE,
POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the
copy, he might have a valid backup.

But I wouldn't bet my job on it. 

He needs to have either a noarchivelog "cold" backup (database
shutdown) done, which will restore to that point in time, or an
archivelog "cold" backup (database shutdown) which will allow you to
roll forward providing you also have the archived logs or an archivelog
"hot" backup (database up, tablespaces in "begin backup" mode) which
will allow you to let anyone keep working while you do the backup and
then allow you to roll forward providing you have the archived logs.

Prove it to him:  bet him something that will hurt him to lose, then do
the copy the way he wants and try to start up the database. Just to
ensure sure you prove your point,  have some transaction that modifies
data running in the database. If you can, make sure that that
transaction is active enough to cycle through ALL your online logs and
loop back to the first one. 


--- Gary Chambers <[EMAIL PROTECTED]> wrote:
> All...
> 
> A developer working on a Solaris 2.6 server running Oracle 7.3.4
> desires
> a nightly backup (by simply copying them to a backup directory) of
> the
> datafiles of an active instance.  I explain that it will be a waste
> of
> tape because the files will be corrupt and useless.  He counters, "As
> long as these files are there, irrespective of their state, oracle
> [sic]
> provides the tools to restore the skeleton database based on these
> files."
> 
> Will this be the case?  I understand that there will [most likely] be
> some loss of data, but will Oracle "fix" itself to a point where it's
> useful again?  TIA
> 
> Gary Chambers
> 
> //--
> // Lucent Technologies ITO/Servers/Unix
> // Senior Unix System Administrator
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //--
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> -- 
> Author: Gary Chambers
>   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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED] 

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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-Mai

RE: log buffer space

[Chris Stephens]

Title: RE: log buffer space





I think this might help...



http://www.ixora.com.au/tips/tuning/log_buffer_size.htm





-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 14, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: log buffer space


What's the size of your log buffer, and the redo log file? 
Do you see any errors/messages in alert.log file that are related to 'checkpoints' or 'log switching'? 


- Kirti 


-Original Message-
Sent: Friday, March 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L



Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?


-ak



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:32 AM



> Arup:
>
> 
> The second condition is not quite true. It is 2/3 full in the current
> versions.
> 
>
> It is very easy to test with the event 10046^8.
>
> KG
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > AK,
> >
> > If the log buffer is at least 4MB, then increasing it will not help,
> > rather it may hurt. The log buffer is flushed when any of the the
> > follwoing occur
> > (i) 1 MB is filled up
> > (2) 1/3rd is filled up
> > (3) every 3 seconds
> > (4) when a checkpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being
> > on a busy disk, or even a slow one.
> >
> > HTH.
> >
> > Arup
> >   - Original Message -
> >   From: Deshpande, Kirti
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Thursday, March 13, 2003 8:13 PM
> >   Subject: RE: log buffer space
> >
> >
> >   Increasing log_buffer size is an option, if it is really small.
> >   I would also check if the redo logs are on a busy disk. If so, try
> > moving those (or other busy data files on the same disk) to other
> > not-so-busy disks.
> >
> >   - Kirti
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Bypassing startup triggers

[Jared . Still]

alter system set _system_trig_enabled = false;

Jared






"Thomas Day" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/14/2003 09:04 AM
 Please respond to ORACLE-L

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



Any way to do that?

Fast answer is appreciated.

TIA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  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.net
-- 
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).

Oracle JDBC thin driver

[Rick Stephenson]

Oracle 9.2.0.2

 

Can the Oracle JDBC thin driver be used with RAC to setup
failover and load balancing between instances in the same way the thick driver
can?

 

Thanks,

 

Rick Stephenson

 









This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited. 

Re:RE: why SAN ? why not external storage ?

[dgoulet]

Humm, must of missed this one on the rebound.  Anyway, here Disk space is an
admin nightmare.  Each time we want to reassign disks from one server to another
here comes EMC to re-program the Symmetrix array otherwise the SA has the
possibility of assigning 2 servers to the same disk.  OOPS I really did not wnat
to do a newfs on that disk!!!?!??!  And at $4000 per disk (72GB) I would not say
that their cheap.  IDE drives have gotten real cheap, when will SCSI follow
suit??

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   3/14/2003 10:03 AM

Oh, Gods forbid the sysadmins would have to  do their job...

HAHAHAHAHA!!!

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Mogens Norgaard [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 5:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: why SAN ? why not external storage ?
> 
> There are many things I don't get in this life. One of them is the 
> statements about disk storage being an admin nightmare and way too 
> expensive. Aren't disks very cheap these days?!
> 
> Mogens
> 
> [EMAIL PROTECTED] wrote:
> 
> >Rahul,
> >
> >This is personal opinion, but it looks to me like your concerned
> about the
> >database your creating for the client and may not have the total or
> corporate
> >wide view your client has.  We're heading down the SAN road not because
> of any
> >specific database requirements but because disk storage has become an
> >administrative nightmare as well as way too expensive.
> >
> >Dick Goulet
> >
> >Reply Separator
> >Author: "Arun Annamalai" <[EMAIL PROTECTED]>
> >Date:   3/13/2003 12:24 PM
> >
> >Usaually SAN and NAS is used for several good reasons...the two main
> are...
> >1) High availability - When you have your database files on SAN/NAS then
> you can
> >bring ur database on another server when the primary goes down. Obviously
> you
> >have to use a cluster or Big IP (F5) on the front.
> >2) reduce redundancy -A unix userid with home directory attached to a
> paticular
> >NFS drive on NAS/SAN, will  able to see all his files when he logs into
> other
> >servers.
> >
> >so far I heard "Net App" is low cost including with Raid 5.
> >
> >-Arun.
> >Sr oracle dba
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 9:38 PM
> >  Subject: Re: why SAN ? why not external storage ?
> >
> >
> >  my reasons to recommend an external storage was..
> >  1) the database size is 36GB, and according to many documents i have
> read, SAN
> >is not cost effevtive unless populated 
> >  by a large numbers of drives !!, now for the client the cost is not the
> >factor.. given the situation.. wouldnt a SAN be an overkill ? 
> >
> >  2) NO DBA or SYS ADMIN skills to manage the SAN !! 
> >
> >- Original Message - 
> >From: Tim Gorman 
> >To: Multiple recipients of list ORACLE-L 
> >Sent: Wednesday, March 12, 2003 8:33 PM
> >Subject: Re: why SAN ? why not external storage ?
> >
> >
> >Can you share some of the reasons related to your decision in
> choosing a
> >direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
> much
> >smarter choice than DAS.
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 1:33 AM
> >  Subject: why SAN ? why not external storage ?
> >
> >
> >  list, one of our clietns are going to by SAN, the current oracle
> databases
> >take around 
> >  36GB of storage i dnt understand there reason to go for SAN, i
> >sugguested to buy an external storage 
> >  box instead. How can i justify my desicion ? (cost of not the
> factor) 
> >
> >  TIA
> >  rahul
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Usaually SAN and NAS is used for several
> good 
> >reasons...the two main are...
> >1) High availability - When you have your
> database 
> >files on SAN/NAS then you can bring ur database on another server when
> the 
> >primary goes down. Obviously you have to use a cluster or Big IP (F5) on
> the 
> >front.
> >2) reduce redundancy - face=Arial 
> >size=2>A unix userid with home directory attached to a
> paticular 
> >NFS drive on NAS/SAN, will  able to see all his files
> when 
> >he logs into other servers.
> > 
> >so far I heard "Net App" is low cost
> including with
> >
> >Raid 5.
> > 
> >-Arun.
> >Sr oracle dba
> > >style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
> BORDER-LEFT:
> >#00 2px solid; MARGIN-RIGHT: 0px">
> >  - Original Message - 
> >   >  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black">From: 
> >   href="mailto:[EMAIL PROTECTED]">Rahul 
> >  
> >  To:  >  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list
> ORACLE-L 
> >  
> >  Sent: Wednesday, March 12, 2003
> 9:3

Re: Fixed_date and dbms_job

[Kader Ben]

Many thanks Jared,

 Definitely I think this is only one away to resolve
my problem.

Have nice week end,

Ben


--- [EMAIL PROTECTED] wrote:
> You can't call a job every second via DBMS_JOB.
> 
> I believe that at best the resolution is 1 minute.
> 
> You could just open another session and run
> something like this:
> 
> declare
>fd varchar2(50) := '01/01/2010 00:00:00';
>v_sql varchar2(200);
> begin
>loop
>   v_sql := 'alter system set fixed_date = "' ||
> fd || '"';
>   execute immediate v_sql;
>   dbms_lock.sleep(1);
>   fd := to_char(to_date(fd,'mm/dd/
> hh24:mi:ss') + 1/86400, 
> 'mm/dd/ hh24:mi:ss');
>   end loop;
> end;
> /
> 
> Jared
> 
> 
> 
> 
> 
> 
> Kader Ben <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  03/13/2003 03:18 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Fixed_date and dbms_job
> 
> 
> Hi Listers,
> 
>  I'm simulating the date in future with fixed_date.
> I wrote procedure to be called every seconde through
> dbms_job to increment the fixed_date.
> 
> I did that dbms_job.submit(:job_num, 'myprocedure;',
> sysdate, 'sysdate');
> 
> the  dba_jobs table show me the right interval un
> next_date:
> 
>  
> BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> INTERVAL
> N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate
> 
> And the sysdate is:
> 13-JUN-2003 17:50:06
> 
> But the job never execute.
> 
> Could you please give me hint how to resolve this
> problem?
> 
> Thanks you,
> 
> Ben
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Kader Ben
>   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.net
> -- 
> 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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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: Multiple Instances and 9iRAC

[Pete Sharman]

Title: Message



RAC is a multiple instance one database configuration.  Different 
instances on different nodes accessing a single database on shared 
disk.
 
Can you have multiple RAC databases running in a cluster?  Sure, if 
the machine has enough resources.  That's about as close as we can say 
without testing it.  I'd be surprised to see the interconnect flood because 
of three instances though.

Pete

"Controlling 
developers is like herding cats."
Kevin 
Loney, Oracle DBA Handbook
"Oh 
no, it's not.  It's much harder than 
that!"
Bruce 
Pihlamae, long-term Oracle DBA
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Thompson, ToddSent: 
  Friday, March 14, 2003 10:29 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Multiple Instances and 9iRAC 
  
   
  My 
  company is currently considering using Oracle 9i RAC. One of the proposed 
  environments is to have multiple oracle instances (3 or more) configured on a 
  4-8 node RAC cluster. Does anyone have any insights as to the viability of 
  this implementation?  Will the high speed inter connect be able to handle 
  the traffic from multiple instances?  I always thought of RAC as a single 
  instance implementation with each instance needing its own 
  cluster...

RE: File Restoration/Recovery

[Mercadante, Thomas F]

Gary - send the developer to backup and recovery school.

he is wrong.  as Rachel said, *maybe* it will work once.  but as a DBA, you
personally can *never* support this in a real environment.  you will not be
able to guarantee the same results every time.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


All...

A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance.  I explain that it will be a waste of
tape because the files will be corrupt and useless.  He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."

Will this be the case?  I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again?  TIA

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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.net
-- 
Author: Mercadante, Thomas F
  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: log buffer space

[Pete Sharman]

Really?  I thought that condition was there pre-9i as well.  Maybe I'm
mistaken.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
WILLIAMS
Sent: Friday, March 14, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Add one more condition: 
   New in Oracle 9i, it will write when 1 meg is reached, so the 1/3
criteria is never reached if you use a big buffer.

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


-Original Message-
Sent: Friday, March 14, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L


KG,

Thanks for the response. Just for my curiosity, is it documented
somewhere that the log buffer if flushed when 2/3rd full? From the
Manual /server.920/a96524/c09procs.htm#3158 (please check the URL in
OTN, the first part is not complete), here is an excerpt


LGWR writes one contiguous portion of the buffer to disk. LGWR writes:
  a.. A commit record when a user process commits a transaction
  b.. Redo log buffers
a.. Every three seconds
b.. When the redo log buffer is one-third full
c.. When a DBWn process writes modified buffers to disk, if
necessary



At least this was the behavior I tested in 8.1.7; although I have not
tested in 9i. This has also been stated by several Oracle Support
Analysts.

Thanks.

Arup Nanda

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 7:32 AM


> Arup:
>
> 
> The second condition is not quite true. It is 2/3 full in the current 
> versions. 
>
> It is very easy to test with the event 10046^8.
>
> KG
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > AK,
> >
> > If the log buffer is at least 4MB, then increasing it will not help,

> > rather it may hurt. The log buffer is flushed when any of the the 
> > follwoing occur
> > (i) 1 MB is filled up
> > (2) 1/3rd is filled up
> > (3) every 3 seconds
> > (4) when a checkpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to 
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being 
> > on a busy disk, or even a slow one.
> >
> > HTH.
> >
> > Arup
> >   - Original Message -
> >   From: Deshpande, Kirti
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Thursday, March 13, 2003 8:13 PM
> >   Subject: RE: log buffer space
> >
> >
> >   Increasing log_buffer size is an option, if it is really small.
> >   I would also check if the redo logs are on a busy disk. If so, try

> > moving those (or other busy data files on the same disk) to other 
> > not-so-busy disks.
> >
> >   - Kirti
>
>
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
>   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.net
-- 
Author: Arup Nanda
  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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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


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

Re: disable ODBC access to Oracle db

[Dwayne Cox]

This was my first thought.

On Friday 14 March 2003 10:48, Stephane Paquette wrote:
> Access is very appreciated by our end users here.
> On the most sensible systems we worked with the dev teams on the login
> procedure.
> We usually enable a role in the login procedure so the users can only
> connect to the database via the application.
> Another way we had implemented security is that we padded the username with
> a string, so it's application username is not the same as the Oracle
> username.
>
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 925-7187
> [EMAIL PROTECTED]
> 
>
>
>
> -Original Message-
> Sent: Friday, March 14, 2003 9:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I don't think so.
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 8:18 AM
>
> > Hi,
> >
> > Is there a way to disable ODBC access to an Oracle database from the
>
> database
>
> > side?  Perhaps an init.ora setting or something?
> >
> > TIA
> >
> > Dwayne

-- 
Dwayne Cox
Corporate Database Administrator
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608

email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dwayne Cox
  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: Veritas Quick I/O for Oracle

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

Title: RE: Veritas Quick I/O for Oracle





got a copy, benchmarked it.  No discernable
difference for our application.  Others I 
know swear that it's great. So I guess it varies by
the application.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.  
All goals met
All customers satisfied
All staff ready and enthusiastic
All pigs fed and ready to fly


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: Veritas Quick I/O for Oracle



Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming "up to 400 times faster". I would like to know if
anyone else has discovered this miracle and what benefits you are seeing.
Thanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


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

RE: Standby errors

[Steve McClure]

I have seen lower sequence logs complete archival after higher sequence
logs.  Usually coinciding with some sort of I/O bottleneck where multiple
archiver processes are competing for limited bandwidth.  I have not seen any
sort of log corruption as a result of that process though.  If the logs are
identical on both the primary and standby, (use diff to verify) I would
suggest doing another backup.  Because if that archived log is corrupt it
will put a keebosh on your restore.  If you used rman for your backup, I am
pretty sure you can verify that your archive logs will restore properly.  Of
course if you can't recover your standby it will have to be resynched as
well.

Steve

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

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

RE: Organizational Challenge - Data Management Team

[Stephen Lee]

In a previous life, I worked at WilTel (very well managed), which became
WorldCom (so-so), which became MCI WorldCom (no comment).  I started out in
WilTel's Engineering Department which (wisely) kept all of IT operations
separate and independent from the grand and glorious (and huge) company IT
department.  We had our own mail servers (POP3), print servers (PostScript
... YEA!), file servers, etc. (which I maintained), and even a semi-firewall
between us and the WAN (put there by Big IT because they didn't like us ...
arrogant engineering assholes that we were).

When I moved into DBA work, I moved from Engineering into the Giant Octopus
IT department.  For what it's worth, here's how things were set up (at the
Tulsa location, which was the majority of the pre-MCI operations).

There were two general DBA groups: Test/Dev and Production.  The test/dev
DBA's were, generally, the more experienced because it was their
responsibility to:

1.  Ensure that the final test database was, if not an exact copy of
production, at least functionally equivalent to production prior to testing
a release.

2.  Ensure that implementation scripts and any required documentation for
the production staff to perform the release were tested and correct.

The documentation provided to production would list such things as steps to
perform, estimated time for each step, any new filesystem space
requirements, any security related requirements (for example, the need for a
user to have restricted session), etc.

The production DBA staff always had one, experienced, senior DBA in case
something blew up.  There might be more, but most of the production staff
were there to follow procedures and not do much thinking.  So the majority
of the production staff were less experienced.  It was up the test/dev DBA's
to make sure anything sent to production was in clear, reliable, monkey see
- monkey do form, and that it would work the first time, every time.

The DBA's were not the owners of the data.  Whoever owned the data was
expected to manage their data.  This is just a simple case "If you own it,
then you take care of it."  Or  "If we take care of, then we own it, and you
don't mess with it unless we say so."  Sometimes, if you explain it to
people the second way, then they are more likely to step up and take
responsibility for what is theirs.

Database design was managed by a dedicated database design person(s), the
reason being that this is the best way to get uniformity in design and
naming.  This provides a central point for all matters related to design.

Each project had a primary DBA and a secondary DBA (so the primary could
take a vacation ... you want what!?).  A DBA might be associated with more
than one project depending on the complexity of the project.  The test/dev
group had one on-call DBA who, if required, would contact the primary or
secondary DBA for a project if needed.  The on-call rotated weekly among the
test/dev DBA's.

The coding of stored procedures, triggers, packages, etc. varied by project.
Maybe a test/dev DBA would do it; maybe not.  This was mostly determined by
the practical matter of who had the ability to do it.  If the test/dev DBA
was to write the code, it was the responsibility of the application owner to
write a clear specification for what was to be written: input values, output
values, format, data checking, error handling, etc. As a recent example: The
"Corrected SQL Question" would have been rejected by our group as being
incomplete. It was NOT the responsibly of the DBA to determine whether the
specification was appropriate for the application; so if the requirements
group specified garbage, they got garbage.  The GIGO rule was in effect;
although if it were obvious that the specification was inappropriate, the
DBA would say so.

And, as long as we are on the topic of requirements, it can't be emphasized
too much the importance of assigning the responsibility for requirements to
a requirements group.  This relieves developers and DBA's from wasting their
time documenting requirements; and a clear set of requirements gives the
test group (you have one of those ... RIGHT?!!) a clear set of things to
test.  Doctors don't service bed pans, and your technically skilled people
shouldn't be wasting time in meetings determining and documenting
requirements.

The test/dev DBA's could not log into the production servers at the OS
level.  Since test/dev was responsible for verifying that test was at least
a functional duplicate of production (preferably and exact duplicate), we
could log into the production database and had CREATE SESSION and SELECT ANY
TABLE privilege.

I'm sure this is an incomplete description.  But maybe it will answer some
of the questions and give rise to new questions.  By the way, the
Engineering department was set up similar to what you are moving away from.
But, even there, we had a clear division between test/dev and production.  A
good philosophy for this is like Heaven and Hell (

Multiple Instances and 9iRAC

[Thompson, Todd]

 

My
company is currently considering using Oracle 9i RAC. One of the proposed environments
is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC
cluster. Does anyone have any insights as to the viability of this
implementation?  Will the high speed inter connect be able to handle the
traffic from multiple instances?  I always thought of RAC as a single
instance implementation with each instance needing its own cluster...

Re: File Restoration/Recovery

[Babu Nagarajan]

you are right and the developer is not. cold backups taken with the db open
are worthless. you cannot use them to open it back to a consistent state

babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 10:44 AM


> All...
>
> A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
> a nightly backup (by simply copying them to a backup directory) of the
> datafiles of an active instance.  I explain that it will be a waste of
> tape because the files will be corrupt and useless.  He counters, "As
> long as these files are there, irrespective of their state, oracle [sic]
> provides the tools to restore the skeleton database based on these
> files."
>
> Will this be the case?  I understand that there will [most likely] be
> some loss of data, but will Oracle "fix" itself to a point where it's
> useful again?  TIA
>
> Gary Chambers
>
> //--
> // Lucent Technologies ITO/Servers/Unix
> // Senior Unix System Administrator
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //--
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gary Chambers
>   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.net
-- 
Author: Babu Nagarajan
  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: Veritas Quick I/O for Oracle

[Babu Nagarajan]

we recently moved from t64 to sun and had io related perf issues w/o quick
io. once the veritas db version (which which quick io comes) was installed,
the performance was back on par with t64...

babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:14 AM


> Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
> Solaris systems with fiber channel and Veritas File System, and the
Veritas
> salesperson is claiming "up to 400 times faster". I would like to know if
> anyone else has discovered this miracle and what benefits you are seeing.
> Thanks.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babu Nagarajan
  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:File Restoration/Recovery

[Gene Sais]

Now, you could put the tablespaces in read only mode, then the copy would 
work.  But then again, could you put all the tablespaces in read only mode 
?
 
h, don't think so :).>>> [EMAIL PROTECTED] 03/14/03 
11:54AM >>>Gary,    Only if 1) The database 
is shutdown prior to the copy of the datafiles, andeverything else that 
compromises the database (online redo, control files,etc...) or 2) the 
effected tablespaces are put into hot backup mode before thecopy, in which 
case when you restore the files Oracle will ask for the archiveredo to roll 
them forward to the rest of the database.  As far as "returning 
theskeleton database based on these files" he's smoking something 
good!!  What Ibelieve he's more likely asking for is a schema 
export.Dick GouletReply 
SeparatorAuthor: Gary Chambers 
<[EMAIL PROTECTED]>Date:   3/14/2003 
7:44 AMAll...A developer working on a Solaris 2.6 server running 
Oracle 7.3.4 desiresa nightly backup (by simply copying them to a backup 
directory) of thedatafiles of an active instance.  I explain that it 
will be a waste oftape because the files will be corrupt and useless.  
He counters, "Aslong as these files are there, irrespective of their state, 
oracle [sic]provides the tools to restore the skeleton database based on 
thesefiles."Will this be the case?  I understand that there 
will [most likely] besome loss of data, but will Oracle "fix" itself to a 
point where it'suseful again?  TIAGary 
Chambers//--// Lucent 
Technologies ITO/Servers/Unix// Senior Unix System Administrator// 4 
Robbins Road, Westford, MA 01886// 978-399-0481 / 888-480-6924 (Pager)// 
Nothing fancy and nothing 
Microsoft// Please 
see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Gary 
Chambers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.net-- 
Author:   INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: File Restoration/Recovery

[Spears, Brian]

Chances are excellent, that you/oracle would not be able to 
recover. 
Oracle support might bring the super tool with the 
swat expert for 5000 bucks an hour...and then 
it might still be a mess. They would love you doing this 
stuff..

Brian

-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


All...

A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance.  I explain that it will be a waste of
tape because the files will be corrupt and useless.  He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."

Will this be the case?  I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again?  TIA

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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.net
-- 
Author: Spears, Brian
  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: Is range partitioning possible on part of varchar2 column ???

[Janardhana Babu Donga]

This seems to be a good idea. I will see if this is acceptable to my people.
Earliar I suggested to change to date field, and was not acceptable for them
as there seems plenty of code needs to be changed. I will see if this change
is acceptable for them. 

One thing I could understand clearly from the LIST MEMBERS is that it is not
at all possible to range partition without changing the column
type/contents. I have two options now, one with what you suggested. 

Thanks for your help and thanks for all those who replied.

-- Babu

-Original Message-
Sent: Thursday, March 13, 2003 8:34 PM
To: Multiple recipients of list ORACLE-L
???


Babu,

On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this

PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'),
PARTITION P1999 VALUES LESS THAN ('2000%'),
PARTITION P2000 VALUES LESS THAN ('2001%'),
.
PARTITION PMAX VALUES LESS THAN (maxvalue)
)

Hope this helps.

Arup Nanda

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 5:19 PM


> Babu
> I don't think partitions are clearly documented anywhere. Here is some SQL
> that works so you can see how to use a date function. It partitions on two
> columns, but I wanted you to see something that works.
>
>add partition sum_fy_28
> values less than ('FY', to_date('02012003','mmdd'))
> tablespace data_fy_28
>
> -Original Message-
> Sent: Thursday, March 13, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
> ??
>
>
> Dear List,
>
> I have a table of size approx 10gig, and I need to partition based on the
> YEAR. I have column in the table, REPORT_CYCLE_CD  with VARCHAR2(7). The
> data in the column of format "MON" . I need to partition the table
based
> on the year , that is, substr(report_cycle_cd, 4,4).
>
> Substr function doesn't seem to be permitted in the partitioning syntax
and
> so am getting errors. Only TO_DATE function seems to be permitted. Since
it
> is not a date column, I would like to know if there is a way to  RANGE
> partition the table, instead of HASH partitioning.
>
> Appreciate any suggestions.
>
> Thanks,
> -- Babu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Janardhana Babu Donga
>   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.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  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.net
-- 
Author: Janardhana Babu Donga
  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 oth

Re: segment from block#

[Wolfgang Breitling]

Title: Re: segment from block#





You also need to specify the file_id in the predicate. However, on anything 
but a micky-mouse (T) database this query will take a long time which is 
why I run a nightly job to populate a "extent_to_object" table which will 
give me that answer quickly (except for any newly created extents) and 
without incurring too much overhead on the system.


At 08:03 AM 3/14/2003 -0800, you wrote:


>Is this a good query to find segment where this block ( 259186 )  belongs ?
>
>select  segment_name
>
>from dba_extents
>
>where block_id<= 259186 and 259186 <= block_id+blocks


Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com



 


This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited.  If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately.  We honour similar requests relating to the privacy of email communications.

Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie.  Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.

Bypassing startup triggers

[Thomas Day]

Any way to do that?

Fast answer is appreciated.

TIA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  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: Fixed_date and dbms_job

[Jared . Still]

You can't call a job every second via DBMS_JOB.

I believe that at best the resolution is 1 minute.

You could just open another session and run
something like this:

declare
   fd varchar2(50) := '01/01/2010 00:00:00';
   v_sql varchar2(200);
begin
   loop
  v_sql := 'alter system set fixed_date = "' || fd || '"';
  execute immediate v_sql;
  dbms_lock.sleep(1);
  fd := to_char(to_date(fd,'mm/dd/ hh24:mi:ss') + 1/86400, 
'mm/dd/ hh24:mi:ss');
  end loop;
end;
/

Jared






Kader Ben <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/13/2003 03:18 PM
 Please respond to ORACLE-L

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


Hi Listers,

 I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to increment the fixed_date.

I did that dbms_job.submit(:job_num, 'myprocedure;',
sysdate, 'sysdate');

the  dba_jobs table show me the right interval un
next_date:

 
BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC INTERVAL
N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate

And the sysdate is:
13-JUN-2003 17:50:06

But the job never execute.

Could you please give me hint how to resolve this
problem?

Thanks you,

Ben


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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.net
-- 
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: why SAN ? why not external storage ?

[Scott . Shafer]

Oh, Gods forbid the sysadmins would have to  do their job...

HAHAHAHAHA!!!

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 5:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: why SAN ? why not external storage ?
> 
> There are many things I don't get in this life. One of them is the 
> statements about disk storage being an admin nightmare and way too 
> expensive. Aren't disks very cheap these days?!
> 
> Mogens
> 
> [EMAIL PROTECTED] wrote:
> 
> >Rahul,
> >
> >This is personal opinion, but it looks to me like your concerned
> about the
> >database your creating for the client and may not have the total or
> corporate
> >wide view your client has.  We're heading down the SAN road not because
> of any
> >specific database requirements but because disk storage has become an
> >administrative nightmare as well as way too expensive.
> >
> >Dick Goulet
> >
> >Reply Separator
> >Author: "Arun Annamalai" <[EMAIL PROTECTED]>
> >Date:   3/13/2003 12:24 PM
> >
> >Usaually SAN and NAS is used for several good reasons...the two main
> are...
> >1) High availability - When you have your database files on SAN/NAS then
> you can
> >bring ur database on another server when the primary goes down. Obviously
> you
> >have to use a cluster or Big IP (F5) on the front.
> >2) reduce redundancy -A unix userid with home directory attached to a
> paticular
> >NFS drive on NAS/SAN, will  able to see all his files when he logs into
> other
> >servers.
> >
> >so far I heard "Net App" is low cost including with Raid 5.
> >
> >-Arun.
> >Sr oracle dba
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 9:38 PM
> >  Subject: Re: why SAN ? why not external storage ?
> >
> >
> >  my reasons to recommend an external storage was..
> >  1) the database size is 36GB, and according to many documents i have
> read, SAN
> >is not cost effevtive unless populated 
> >  by a large numbers of drives !!, now for the client the cost is not the
> >factor.. given the situation.. wouldnt a SAN be an overkill ? 
> >
> >  2) NO DBA or SYS ADMIN skills to manage the SAN !! 
> >
> >- Original Message - 
> >From: Tim Gorman 
> >To: Multiple recipients of list ORACLE-L 
> >Sent: Wednesday, March 12, 2003 8:33 PM
> >Subject: Re: why SAN ? why not external storage ?
> >
> >
> >Can you share some of the reasons related to your decision in
> choosing a
> >direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
> much
> >smarter choice than DAS.
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 1:33 AM
> >  Subject: why SAN ? why not external storage ?
> >
> >
> >  list, one of our clietns are going to by SAN, the current oracle
> databases
> >take around 
> >  36GB of storage i dnt understand there reason to go for SAN, i
> >sugguested to buy an external storage 
> >  box instead. How can i justify my desicion ? (cost of not the
> factor) 
> >
> >  TIA
> >  rahul
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Usaually SAN and NAS is used for several
> good 
> >reasons...the two main are...
> >1) High availability - When you have your
> database 
> >files on SAN/NAS then you can bring ur database on another server when
> the 
> >primary goes down. Obviously you have to use a cluster or Big IP (F5) on
> the 
> >front.
> >2) reduce redundancy - face=Arial 
> >size=2>A unix userid with home directory attached to a
> paticular 
> >NFS drive on NAS/SAN, will  able to see all his files
> when 
> >he logs into other servers.
> > 
> >so far I heard "Net App" is low cost
> including with
> >
> >Raid 5.
> > 
> >-Arun.
> >Sr oracle dba
> > >style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
> BORDER-LEFT:
> >#00 2px solid; MARGIN-RIGHT: 0px">
> >  - Original Message - 
> >   >  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black">From: 
> >   href="mailto:[EMAIL PROTECTED]">Rahul 
> >  
> >  To:  >  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list
> ORACLE-L 
> >  
> >  Sent: Wednesday, March 12, 2003
> 9:38 
> >  PM
> >  Subject: Re: why SAN ? why not
> external 
> >  storage ?
> >  
> >  my reasons to recommend an external
> storage 
> >  was..
> >  1) the database size is 36GB, and
> according to 
> >  many documents i have read, SAN is not cost effevtive unless populated 
> >  
> >  by a large numbers of drives !!, now for
> the 
> >  client the cost is not the factor.. given the situation.. wouldnt a SAN
> be an 
> >  overkill ? 
> >   
> >  2) NO DBA or SYS ADMIN skills to manage
> the SAN 
> >  !! 
> >   
> >   >  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
> BORDER-LEFT:
>

db file scattered read

[AK]

Here is a part of trace file . I am finding that 
oracle is trying to read 8 or 3 or 7 blocks at a time . But block numbers are 
all sequential i.e. it will read 3 blocks starting from 14706 and then 8 blocks 
starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks always it 
multi_block_read is set to 8 ? Any Idea .
Also what is ela=1 ,does it mean elapsed time is 1 
sentisec ?
 
 
 
WAIT #32: nam='db file scattered read' ela= 0 p1=4 
p2=14706 p3=3WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14710 
p3=8WAIT #32: nam='db file scattered read' ela= 2 p1=4 p2=14718 p3=8WAIT 
#32: nam='db file scattered read' ela= 0 p1=4 p2=14727 p3=3WAIT #32: nam='db 
file scattered read' ela= 0 p1=4 p2=14731 p3=7WAIT #32: nam='db file 
scattered read' ela= 1 p1=4 p2=14739 p3=3WAIT #32: nam='db file scattered 
read' ela= 1 p1=4 p2=14744 p3=8WAIT #32: nam='db file scattered read' ela= 1 
p1=4 p2=129784 p3=8
 
 
Thanks
-ak

Re: segment from block#

[Arup Nanda]

Join the file_id as well as follows
 
select segment_name
from dba_extents
where file_id = 123
and 259186 between blocks and 
blocks+block_id
 
HTH
 
Arup

  - Original Message - 
  From: 
  AK 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, March 14, 2003 11:03 
  AM
  Subject: segment from block#
  
  
  Is this a good query to find segment where this block ( 
  259186 )  belongs ?
  select  
  segment_name 
  from dba_extents
  where block_id<= 259186 and 259186 <= block_id+blocks
   
   
  -ak
   

Re:File Restoration/Recovery

[dgoulet]

Gary,

Only if 1) The database is shutdown prior to the copy of the datafiles, and
everything else that compromises the database (online redo, control files,
etc...) or 2) the effected tablespaces are put into hot backup mode before the
copy, in which case when you restore the files Oracle will ask for the archive
redo to roll them forward to the rest of the database.  As far as "returning the
skeleton database based on these files" he's smoking something good!!  What I
believe he's more likely asking for is a schema export.

Dick Goulet

Reply Separator
Author: Gary Chambers <[EMAIL PROTECTED]>
Date:   3/14/2003 7:44 AM

All...

A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance.  I explain that it will be a waste of
tape because the files will be corrupt and useless.  He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."

Will this be the case?  I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again?  TIA

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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.net
-- 
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[2]:File Restoration/Recovery

[dgoulet]

Gary,

I had a similar "engineer" managed DB around here for a while.  The problem
was that 'someone' deleted a couple of the datafiles by 'mistake'. (Ever see
that CDW commercial concerning the "full file server"?)  Well I got asked the
same question to which I had a very good laugh & told the engineer to "go away".
 That database is now under the DBA staff support & the engineer has no say in
what we do to protect it.  My premise is, I'm no engineer so I won't tell them
how to design product, but at the same time their not a DBA so they don't tell
me how to run a database.

Basically, put it into archive log mode & handle it as you would ay other
database.  If they don't like it, let them swing on their own.

Dick Goulet

Reply Separator
Author: Gary Chambers <[EMAIL PROTECTED]>
Date:   3/14/2003 12:22 PM

Dick...

Thanks very much for the reply!

> Only if 1) The database is shutdown prior to the copy of the
> datafiles, and everything else that compromises the database (online
> redo, control files, etc...)

I hate second-guessing myself, but this is what I've been trying to tell
him.

> or 2) the effected tablespaces are put into hot backup mode before the
> copy, in which case when you restore the files Oracle will ask for the
> archive redo to roll them forward to the rest of the database.

Here's another direct quote on my admonition for not running the
database with archive logging:

"Thanks again for your help on this. we've [sic] not decided to run
oracle in archive mode yet as content on this oracle [sic] instance will
only be changed through replication and instead of recovering from
archive logs it is easy to recover it from replication."

The replication to which he is referring is through the application
(Documentum).

> As far as "returning the skeleton database based on these files" he's
> smoking something good!!  What I believe he's more likely asking for
> is a schema export.


I considered offering him that option, but that wouldn't solve his
problem.  The background (briefly) is that this server, until Wednesday,
was being "administered" by an engineer -- it's part of someone's empire
here at Lucent, and [WAS] outside of the scope of my Unix system
administration team.  On Wednesday, one of the hard drives failed,
taking with it many of the datafiles Oracle finds useful.  Not
surprisingly, it quickly became in-scope.  We replaced the failed drive,
then discovered that the system wasn't even being backed-up.  Now, this
developer wants a way to recover without, again, having to manually
recreate the database.

Thanks again for the reply and the assistance!!

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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: utl_file_dir and 9i

[Deshpande, Kirti]

Precisely 

But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an 
unacceptable parameter value? 

- Kirti


-Original Message-
Sent: Friday, March 14, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway!  Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it.  Hmm, could that cause any problems?  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Landrum
Sent: Friday, March 14, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L


Good points, also consider the security issues that exist because of
'util_file_dir=*'. With that, any user that can run a procedure and
write (or overwrite) files in locations that should be accessible only
by oracle.


>>> [EMAIL PROTECTED] 03/14/03 07:08AM >>>
John,

In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY'
rather than UTL_FILE_DIR ... firstly because a directory can be created
dynamically, so to adda new sub-directory you don't have to bounce the
instance.

Plus instead of '*', you can dynamically create directory ... read/write
and drop the directory if you wish.

I'd recommend you make use of this feature John, because UTL_FILE_DIR
might just go away  because of its limitations.

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!


-Original Message-
Sent: Friday, March 14, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


In 8i we set utl_file_dir = "*" because otherwise we have to specify
lots of individual directories. It was not possible to just specify a
top level directory.

Has this changed in 9i?   Is it possible to specify a top level
directory
and then utl_file  can write to subdirectories?

John


-- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: File Restoration/Recovery

[Ray Stell]

As with all backup and recovery plans, you should test, document, and
perhaps automate the process, with particular emphasis on the recovery.
What your associate describes sounds like an very expensive B&R plan.




 
On Fri, Mar 14, 2003 at 07:44:01AM -0800, Gary Chambers wrote:
> All...
> 
> A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
> a nightly backup (by simply copying them to a backup directory) of the
> datafiles of an active instance.  I explain that it will be a waste of
> tape because the files will be corrupt and useless.  He counters, "As
> long as these files are there, irrespective of their state, oracle [sic]
> provides the tools to restore the skeleton database based on these
> files."
> 
> Will this be the case?  I understand that there will [most likely] be
> some loss of data, but will Oracle "fix" itself to a point where it's
> useful again?  TIA
> 
> Gary Chambers
> 
> //--
> // Lucent Technologies ITO/Servers/Unix
> // Senior Unix System Administrator
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //--
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gary Chambers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

Re: Oracle Development Suite for Linux?

[Stephen Andert]

This link is about installing on Red Hat Advanced Server.  What
differences will I face trying to install on Red Hat 7 (or 8 if I can
get my video card working in 8)?

Thanks
Stephen

>>> [EMAIL PROTECTED] 03/10/03 09:28PM >>>
I installed 9.2 on redhat 8.0 with great luck.  I installed on a 700 PC
with 
756 megs of memory.  I was using forms 6i running on NT client and
could not 
tell when I was pointed at this instance verus one running on a HP
machine.  
  The document I found that was helpful in the install was   
http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf 






>From: Alex Andriyashchenko <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Development Suite for Linux?
>Date: Mon, 10 Mar 2003 12:24:01 -0800
>
>Hello List,
>
>Has somebody had any luck or problems to install Oracle development
>suite v9.0.2 under RH Linux? How good it is there now?
>
>I found that previous versions run much better under Windows.
>
>Thank you for your help.
>--
>Best regards,
>Alex  mailto:[EMAIL PROTECTED] 
>
>__
>Do You Yahoo!?
>Everything you'll ever need on one web page
>from News and Sport to Email and Music Charts
>http://uk.my.yahoo.com 
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net 
>--
>Author: Alex Andriyashchenko
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Charles Hart
  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.net
-- 
Author: Stephen Andert
  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: log buffer space

[Arup Nanda]

AK,

Could you provide the redo log sizes and the log_buffers parameters, please.
Also let us know the log switch frequency, too.

Thanks.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:14 AM


> Do you guys think , adding more log file can help ? I think it should not
,
> cuz any way logwriter is going to write in one datafile at a time ,
correct
> ?
>
> -ak
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 14, 2003 4:32 AM
>
>
> > Arup:
> >
> > 
> > The second condition is not quite true. It is 2/3 full in the current
> > versions.
> > 
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
> >
> >
> > --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > > AK,
> > >
> > > If the log buffer is at least 4MB, then increasing it will not help,
> > > rather it may hurt. The log buffer is flushed when any of the the
> > > follwoing occur
> > > (i) 1 MB is filled up
> > > (2) 1/3rd is filled up
> > > (3) every 3 seconds
> > > (4) when a checkpoint occurs
> > > (5) when a commit occurs.
> > >
> > > Therefore, see if any of these could be the problem. It's easy to
> > > check #s 4 and 3.
> > >
> > > As Kirti suggested, the problem could be due to the redo logs being
> > > on a busy disk, or even a slow one.
> > >
> > > HTH.
> > >
> > > Arup
> > >   - Original Message -
> > >   From: Deshpande, Kirti
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Thursday, March 13, 2003 8:13 PM
> > >   Subject: RE: log buffer space
> > >
> > >
> > >   Increasing log_buffer size is an option, if it is really small.
> > >   I would also check if the redo logs are on a busy disk. If so, try
> > > moving those (or other busy data files on the same disk) to other
> > > not-so-busy disks.
> > >
> > >   - Kirti
> >
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: K Gopalakrishnan
> >   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.net
> --
> Author: AK
>   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.net
-- 
Author: Arup Nanda
  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: High current mode buffer gets on insert

[Paul Baumgartel]

I thought I'd repost to see if I could get a response.  Anyone?


--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I'm looking at a client's tkprof output, showing among other things
> that the insertion of about 135,000 rows taking 450 seconds of CPU,
> and
> with current mode buffer gets numbering almost 800,000.  This is a
> daily warehouse load process, and I know that indexes are left in
> place
> during the load.  Am I correct in concluding that the high CPU, and
> especially the current mode block gets numbering over 6 times the
> number of rows inserted, are due to index updates?
> 
> Thanks!
> 
> 
> 
> =
> Paul Baumgartel, Adept Computer Associates, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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: log buffer space

[Cary Millsap]

I think the only ways adding more log files might help is if your app is
waiting on "log file switch (%)" events.


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

Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr  8-10 Chicago


-Original Message-
Sent: Friday, March 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L

Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:32 AM


> Arup:
>
> 
> The second condition is not quite true. It is 2/3 full in the current
> versions.
> 
>
> It is very easy to test with the event 10046^8.
>
> KG
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > AK,
> >
> > If the log buffer is at least 4MB, then increasing it will not help,
> > rather it may hurt. The log buffer is flushed when any of the the
> > follwoing occur
> > (i) 1 MB is filled up
> > (2) 1/3rd is filled up
> > (3) every 3 seconds
> > (4) when a checkpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being
> > on a busy disk, or even a slow one.
> >
> > HTH.
> >
> > Arup
> >   - Original Message -
> >   From: Deshpande, Kirti
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Thursday, March 13, 2003 8:13 PM
> >   Subject: RE: log buffer space
> >
> >
> >   Increasing log_buffer size is an option, if it is really small.
> >   I would also check if the redo logs are on a busy disk. If so, try
> > moving those (or other busy data files on the same disk) to other
> > not-so-busy disks.
> >
> >   - Kirti
>
>
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
>   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.net
-- 
Author: AK
  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.net
-- 
Author: Cary Millsap
  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: Organizational Challenge - Data Management Team

[DENNIS WILLIAMS]

Ron - As a solo DBA shop, I can't be much help except to point out that most
of what I've heard involves the DBAs specializing between production work
and development work. Some DBAs administer the production databases, others
work with the developers. This also seems to suit the personality types.



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

-Original Message-
Sent: Thursday, March 13, 2003 6:39 PM
To: Multiple recipients of list ORACLE-L


All,
 
I would like to open a discussion to solicit information regarding the
support structure you utilize in your Data Management department.
 
We currently have a flat end-to-end approach whereby a dba adopts an
application and subsequent database in the early planning stages via teaming
up with the Data Architect and developers and owns that application all the
way through design, development, testing, and ultimately production support.
 
As a smaller group (3-5) dba's this model worked fine, and everyone knew
their respective database quite well.
 
As more and more applications (internal and 3rd party) continue to rollover
from legacy systems into Oracle solutions, this is proving to be very
challenging to provide 24x7 support and related on-call duties spanning
three RDBMS platforms (Informix, Oracle, and MS SQL Server).  Our challenges
are two fold:
 
One, we are (like any shop today) extremely overloaded with work requests,
so this makes cross-application training to spread the knowledge nearly
impossible to accomplish. 
Two, with everyone tied to a project, we have no resource with large enough
buckets of time to take on new and imperative technologies such as java,
replication, high availability, xml as examples that our development teams
would like to leverage in the database.
 
We are in the early stages of looking at organization alternatives.  We are
fortunate in that 90% of the database support is already centralized in our
department for the company, so that allows us the ability to minimize every
dba learning lessons the hard way.   
 
Specifically, we are considering some "role" divisions amongst the DBA's.
That is to say a subset dedicated to "engineering" such as implementing and
architecting new technologies and related best practices, a second subset
for implementation of systems being developed, and a third subset for
production support.
 
I would like to hear about the organization structure you are involved with
and the pro and cons of a flat structure as compared to a more "role" based
structure.
 
Thanks in advance,
-Ron-
Lead Oracle DBA
 

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

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

Re:File Restoration/Recovery

[Gary Chambers]

Dick...

Thanks very much for the reply!

> Only if 1) The database is shutdown prior to the copy of the
> datafiles, and everything else that compromises the database (online
> redo, control files, etc...)

I hate second-guessing myself, but this is what I've been trying to tell
him.

> or 2) the effected tablespaces are put into hot backup mode before the
> copy, in which case when you restore the files Oracle will ask for the
> archive redo to roll them forward to the rest of the database.

Here's another direct quote on my admonition for not running the
database with archive logging:

"Thanks again for your help on this. we've [sic] not decided to run
oracle in archive mode yet as content on this oracle [sic] instance will
only be changed through replication and instead of recovering from
archive logs it is easy to recover it from replication."

The replication to which he is referring is through the application
(Documentum).

> As far as "returning the skeleton database based on these files" he's
> smoking something good!!  What I believe he's more likely asking for
> is a schema export.

I considered offering him that option, but that wouldn't solve his
problem.  The background (briefly) is that this server, until Wednesday,
was being "administered" by an engineer -- it's part of someone's empire
here at Lucent, and [WAS] outside of the scope of my Unix system
administration team.  On Wednesday, one of the hard drives failed,
taking with it many of the datafiles Oracle finds useful.  Not
surprisingly, it quickly became in-scope.  We replaced the failed drive,
then discovered that the system wasn't even being backed-up.  Now, this
developer wants a way to recover without, again, having to manually
recreate the database.

Thanks again for the reply and the assistance!!

Gary Chambers

//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Chambers
  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: log buffer space

[AK]

Are there any equations which can say log buffer is 
small or large ? I mean how to find the proper size of log buffer .
 
-ak

  - Original Message - 
  From: 
  Deshpande, Kirti 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, March 13, 2003 5:13 
  PM
  Subject: RE: log buffer space
  
  Increasing log_buffer size is an option, if it is really small. 
  
  I 
  would also check if the redo logs are on a busy disk. If so, try moving those 
  (or other busy data files on the same disk) to other not-so-busy 
  disks. 
   
  - 
  Kirti 
   
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 4:49 
  PMTo: Multiple recipients of list ORACLE-LSubject: log 
  buffer space
  
I am finding tons of  "log buffer space" 
waits in 10046 output . Does it necessarily means I should look for resizing 
log_buffer ? What else can be done or looked at to reduce these waits 
.
 
Thanks,
ak
 

RE: log buffer space

[Deshpande, Kirti]

What's the size of your log buffer, and the redo log file? 
Do you see any errors/messages in alert.log file that are related to 'checkpoints' or 
'log switching'? 

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:32 AM


> Arup:
>
> 
> The second condition is not quite true. It is 2/3 full in the current
> versions.
> 
>
> It is very easy to test with the event 10046^8.
>
> KG
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > AK,
> >
> > If the log buffer is at least 4MB, then increasing it will not help,
> > rather it may hurt. The log buffer is flushed when any of the the
> > follwoing occur
> > (i) 1 MB is filled up
> > (2) 1/3rd is filled up
> > (3) every 3 seconds
> > (4) when a checkpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being
> > on a busy disk, or even a slow one.
> >
> > HTH.
> >
> > Arup
> >   - Original Message -
> >   From: Deshpande, Kirti
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Thursday, March 13, 2003 8:13 PM
> >   Subject: RE: log buffer space
> >
> >
> >   Increasing log_buffer size is an option, if it is really small.
> >   I would also check if the redo logs are on a busy disk. If so, try
> > moving those (or other busy data files on the same disk) to other
> > not-so-busy disks.
> >
> >   - Kirti
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: a DIFFERENT sql question

[Aponte, Tony]

Title: RE: a DIFFERENT sql question






SELECT DISTINCT 

 t1.category CAT

,t2.type TYP

,SUM(DISTINCT t1.amount1) OVER(PARTITION BY t1.category) Sum1

,SUM(t2.amount2) OVER(PARTITION BY t1.category, t2.type) Sum2

FROM

 t1

,t2

WHERE

 t1.mykey1 = t2.mykey1

/


CAT TYP SUM1    SUM2

AA  x   8   27

AA  y   8   6

AA  z   8   10

BB  y   50  27



HTH

Tony APonte

Home Shopping Network



-Original Message-

From: STEVE OLLIG [mailto:[EMAIL PROTECTED]]

Sent: Thursday, March 13, 2003 2:24 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: a DIFFERENT sql question



ok - i came up with a solution.  but in real life i have a lot of amount1's

in t1 so it becomes an ugly brute force looking query.  anybody have a more

elegant solution?



  1  select a.category

  2   , (select sum(s.amount1) from t1 s where a.category = s.category)

as amount1sum

  3   , b.type

  4   , sum(b.amount2)

  5    from t1 a

  6   , t2 b

  7   where a.mykey1 = b.mykey1

  8   group by

  9 a.category

 10*  , b.type

SQL> /


CATEG AMOUNT1SUM TYPE  SUM(B.AMOUNT2)

- -- - --

AA 8 x 27

AA 8 y  6

AA 8 z 10

BB    50 y 27


4 rows selected.


SQL> 


-Original Message-

Sent: Thursday, March 13, 2003 10:49 AM

To: Multiple recipients of list ORACLE-L



since we're having fun with SQL today - here's one that's hurting my brain

at the moment.  I need to sum columns at 2 different groupings in my

resultset.  The first select is perfect; the 2nd is where i have trouble;

but i know i can do stuff like the 3rd example.  How do I get the 2nd one to

work?


SQL SCRIPT:

drop table t1;

drop table t2;

create table t1 (mykey1 number(5), category varchar2(5), amount1 number(5));

create table t2 (mykey2 number(5), mykey1 number(5), type varchar2(5),

amount2 number(5));

insert into t1 values (1, 'AA', 5);

insert into t1 values (2, 'AA', 3);

insert into t1 values (3, 'BB', 50);

insert into t2 values (1, 1, 'x', 1);

insert into t2 values (2, 1, 'x', 2);

insert into t2 values (3, 1, 'y', 6);

insert into t2 values (4, 2, 'x', 4);

insert into t2 values (5, 2, 'z', 10);

insert into t2 values (6, 2, 'x', 20);

insert into t2 values (7, 3, 'y', 12);

insert into t2 values (8, 3, 'y', 15);

select a.category

 , a.mykey1

 , sum(distinct a.amount1)

 , b.type

 , sum(b.amount2)

  from t1 a

 , t2 b

 where a.mykey1 = b.mykey1

 group by

   a.category

 , a.mykey1

 , a.amount1

 , b.type

/

select a.category

--   , a.mykey1

 , sum(distinct a.amount1)

 , b.type

 , sum(b.amount2)

  from t1 a

 , t2 b

 where a.mykey1 = b.mykey1

 group by

   a.category

--   , a.mykey1

--   , a.amount1

 , b.type

/

select decode(grouping(a.category), 1, 'All', a.category) as category

 , decode(grouping(a.mykey1), 1, 'All', a.mykey1) as job

 , decode(grouping(b.type), 1, 'All', b.type) as type

 , count(*)

 , sum(distinct a.amount1)

 , sum(b.amount2)

  from t1 a

 , t2 b

 where a.mykey1 = b.mykey1

 group by rollup

 ( a.category

 , a.mykey1

 , b.type

 )

order by

   a.category

 , a.mykey1

 , b.type

/


here's what i get:


SQL> select a.category

  2   , a.mykey1

  3   , sum(distinct a.amount1)

  4   , b.type

  5   , sum(b.amount2)

  6    from t1 a

  7   , t2 b

  8   where a.mykey1 = b.mykey1

  9   group by

 10 a.category

 11   , a.mykey1

 12   , a.amount1

 13   , b.type

 14  /


CATEG MYKEY1 SUM(DISTINCTA.AMOUNT1) TYPE  SUM(B.AMOUNT2)

- -- -- - --

AA 1  5 x  3

AA 1  5 y  6

AA 2  3 x 24

AA 2  3 z 10

BB 3 50 y 27


5 rows selected.


perfect.


but this is the problem query:


SQL> select a.category

  2  --   , a.mykey1

  3   , sum(distinct a.amount1)

  4   , b.type

  5   , sum(b.amount2)

  6    from t1 a

  7   , t2 b

  8   where a.mykey1 = b.mykey1

  9   group by

 10 a.category

 11  --   , a.mykey1

 12  --   , a.amount1

 13   , b.type

 14  /


CATEG SUM(DISTINCTA.AMOUNT1) TYPE  SUM(B.AMOUNT2)

- -- - --

AA 8 x 27

AA 5 y  6

AA 3 z 10

BB    50 y 27


4 rows selected.


wrong.  i want the resultset to look like this:


CATEG SUM(DISTINCTA.AMOUNT1) TYPE  SUM(B.AMOUNT2)

- --

RE: ODBC access to Oracle db

[Stephane Paquette]

Access is very appreciated by our end users here.
On the most sensible systems we worked with the dev teams on the login
procedure.
We usually enable a role in the login procedure so the users can only
connect to the database via the application.
Another way we had implemented security is that we padded the username with
a string, so it's application username is not the same as the Oracle
username.


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
[EMAIL PROTECTED] 



-Original Message-
Sent: Friday, March 14, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


I don't think so.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 8:18 AM


> Hi,
>
> Is there a way to disable ODBC access to an Oracle database from the
database
> side?  Perhaps an init.ora setting or something?
>
> TIA
>
> Dwayne
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dwayne Cox
>   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.net
--
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  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).

Veritas Quick I/O for Oracle

[DENNIS WILLIAMS]

Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming "up to 400 times faster". I would like to know if
anyone else has discovered this miracle and what benefits you are seeing.
Thanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: utl_file_dir and 9i

[Jamadagni, Rajendra]

Title: RE: utl_file_dir and 9i





Pete,


At-least that way to can verify that your backup and recovery scenario's are up-to-date 8:)


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Pete Sharman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: utl_file_dir and 9i



True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway!  Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it.  Hmm, could that cause any problems?  :)


Pete



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

Re: File Restoration/Recovery

[Rachel Carmichael]

no no no no no no

If he is REALLY lucky, and no one is using the database at the instant
he does all the copies (and I mean the OS as well), then MAYBE,
POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the
copy, he might have a valid backup.

But I wouldn't bet my job on it. 

He needs to have either a noarchivelog "cold" backup (database
shutdown) done, which will restore to that point in time, or an
archivelog "cold" backup (database shutdown) which will allow you to
roll forward providing you also have the archived logs or an archivelog
"hot" backup (database up, tablespaces in "begin backup" mode) which
will allow you to let anyone keep working while you do the backup and
then allow you to roll forward providing you have the archived logs.

Prove it to him:  bet him something that will hurt him to lose, then do
the copy the way he wants and try to start up the database. Just to
ensure sure you prove your point,  have some transaction that modifies
data running in the database. If you can, make sure that that
transaction is active enough to cycle through ALL your online logs and
loop back to the first one. 


--- Gary Chambers <[EMAIL PROTECTED]> wrote:
> All...
> 
> A developer working on a Solaris 2.6 server running Oracle 7.3.4
> desires
> a nightly backup (by simply copying them to a backup directory) of
> the
> datafiles of an active instance.  I explain that it will be a waste
> of
> tape because the files will be corrupt and useless.  He counters, "As
> long as these files are there, irrespective of their state, oracle
> [sic]
> provides the tools to restore the skeleton database based on these
> files."
> 
> Will this be the case?  I understand that there will [most likely] be
> some loss of data, but will Oracle "fix" itself to a point where it's
> useful again?  TIA
> 
> Gary Chambers
> 
> //--
> // Lucent Technologies ITO/Servers/Unix
> // Senior Unix System Administrator
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //--
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gary Chambers
>   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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: utl_file_dir and 9i

[Jamadagni, Rajendra]

Title: RE: utl_file_dir and 9i





The answer is still NO


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: utl_file_dir and 9i



Which is why I want to know if in 9i I can specify a top level directory


John
-Original Message-
Sent: 14 March 2003 14:19
To: Multiple recipients of list ORACLE-L



Good points, also consider the security issues that exist because of
'util_file_dir=*'.
With that, any user that can run a procedure and write (or overwrite) files
in locations that should be accessible only by oracle.



>>> [EMAIL PROTECTED] 03/14/03 07:08AM >>>
John,


In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY' rather
than UTL_FILE_DIR ... firstly because a directory can be created
dynamically, so to adda new sub-directory you don't have to bounce the
instance.


Plus instead of '*', you can dynamically create directory ... read/write and
drop the directory if you wish.


I'd recommend you make use of this feature John, because UTL_FILE_DIR might
just go away  because of its limitations.


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
Sent: Friday, March 14, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L



In 8i we set utl_file_dir = "*" because otherwise we have to specify lots of
individual directories. It was not possible to just specify a top level
directory.


Has this changed in 9i?   Is it possible to specify a top level directory
and then utl_file  can write to subdirectories?


John



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



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

RE: Sun=/var/messages HP-UX=???

[Anderson, Brian]

Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) 
machine is also using /var/adm/messages, maybe I changed this, I don't remember.
/var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris.

> -Original Message-
> From: Nelson, Allan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 9:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sun=/var/messages HP-UX=???
> 
> 
> /var/adm/syslog/syslog.log is the hp-ux equivelant.
> 
> -Original Message-
> Sent: Thursday, March 13, 2003 12:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS
> log files worth monitoring?
> 
> Thanks,
> Ethan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anderson, Brian
  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: Backup Strategy

[DENNIS WILLIAMS]

Jay
If you want a good book to get up to speed on RMAN, buy
Oracle9i RMAN Backup & Recovery by Robert Freeman and Matthew Hart
 
If you want to compare the steps for various recovery scenarios between RMAN
and user-managed recovery, get Oracle Backup & Recovery 101 by Smith and
Haisley. It has you create a small test database and then run various backup
and recovery steps for various types of failures and recoveries.



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

-Original Message-
Sent: Friday, March 14, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L



Dear All, 

Iam entitled the responsibility to come out with a plan for Backup (using
RMAN) for our 
forthcoming data centre operations. Could someone help me on this? 

I would also like to know the steps for Recovery in the case of a Redo Log
member failure, 
using RMAN and the traditional Recovery commands from SQLPLUS. 

TIA . 

Best Regards
Jai

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

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