date:20010921


way too cynical.

One of the few things I learned in the management class I took was you have to train 
the people
below you to do your job if you ever want a promotion

If no one else can do what you do, then you can't move on to other things.

On the other hand, Satar is a consultant. And looking at the world from that 
direction, you
wouldn't want anyone else around to do what you do because you'd lose the contract if 
there were a
full-timer around (you can have a fulltimer put in extra hours without having to pay 
more)

But as a full-time employee, I want someone else around. Because there is ALWAYS too 
much work for
one person, at least in my shop.

Rachel

--- Weaver, Walt [EMAIL PROTECTED] wrote:
 Well, this seems to me to be a cynical/paranoid way of looking at things.
 Probably true in some circles though.
 
 Personally, I'm with the Hire A Second DBA crowd. I, too, would much rather
 have a life. Too much fun stuff to do out there, too many places to go and
 beer to drink.
 
 --Walt (I'm goin' fishin') Weaver
   Bozeman, Montana
 
 -Original Message-
 Sent: Thursday, September 20, 2001 5:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 If we lived in a perfect world, where the employee
 matters, then I would hire an additional DBA to share
 ideas and responsibility.
 
 However, since we live in a capatilistic world, I
 would do the job by myself for the following reasons:
 1. Management will see one of you as being redundant
 during financial problems because there was one person
 doing this job before, therefore they can get rid of
 one of the DBAs and still be ok.
 
 2. Mamangement acknowledges that there is a possible
 need to hire an additional person, thus acknowledging
 that you do the job of two people. This is a benefit
 to you for asking for a big pay increase.
 
 3. Hiring Oracle consultants and purchasing software
 are tax deductible to the company as opposed to paying
 a salary to another person and providing them with
 Health Care and Office Space. At least in the USA.
 
 4. If you hire a entry-level DBA, chances are that
 he/she  will learn his skill set from you and then
 move on to bigger opportunities (which puts you back
 to square one) or he/she will just stab you in the
 back to try to get your job.
 
 Regards,
 Satar
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Weaver, Walt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Bellefeuille, Wayne S


This is the one I am running.  It just doesn't seem to be doing the
trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
need to look elsewhere for my temp segment problem?

Wayne

-Original Message-
Sent: Thursday, September 20, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the wake SMON approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup smon_pid.

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

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

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

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

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

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

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

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

RE: coalesce tablespace

2001-09-21 Thread Farnsworth, Dave


Does this also apply to a temporary tablespace??  I have a temp TS that has
a percent extents coalesced of 1.

Thanks,

Dave

-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Following script may be used to check whether coalesing is required or not. 
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

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

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


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

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

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

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

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

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

RE: Rash of shared memory errors

2001-09-21 Thread Rahul

almost always because of the applicaiton NOT using bind variables...

 --
 From: Arn Klammer[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, September 21, 2001 2:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Rash of shared memory errors

 Hi,

 Just recently, we have been frequently receiving errors like the following
 in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
 our test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
 developing a new application in the database, but this has been ongoing
 for some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

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

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

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

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

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

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

RE: Best Uses for Oracle Designer 2000?

David,

I
agree with Jack.

I have
not used Designer for generating applications (have tried, but not been
successfull - clearly because I did not have the time).

But I
use it exclusively for database design and object creation (TbSpaces, tables,
indexes, PK's, FK's, CK's, Seq's, Trigs Views). It is great for
buidling all of the relatioinships and then generating the DDL scripts.
Once you learn how it works, it is *much* faster than maintaining sql scripts
for all of your database objects.

I
agree, that there is a learning curve. But, you can "reverse engineer" a
small database, and see how everything is stored to learn what needs to be done
where.

I do
not keep PL/SQL (except for triggers) in the repos, mostly because I don't see
the benefit. The tool does not help you develop the scripts (we use Toad),
so storing them in the repos makes no sense to me (our developers use SourceSafe
for code managment).

Hope
this helps.
Tom Mercadante Oracle Certified Professional

-Original Message-From: Jack C. Applewhite
[mailto:[EMAIL PROTECTED]]Sent: Thursday, September 20,
2001 7:30 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Best Uses for Oracle Designer
2000?
David,

I've
used Designer (and Oracle*CASE before it) for about 10 years now. I've
always used it for logical data modelling and physical database
implementation. In my Developer past, I've done a ton of Oracle Forms
and Reports generation from Designer, as well as Web Server Generator
apps. All my PL/SQL stored packages have always (and still do) live in
Designer.

Now
that I'm focussed on Development DBA work, I user Designer for physical
database design and implementation and PL/SQL package development. It is
wonderful for specifying tables, along with their constraints, indexes,
triggers, etc., etc. then generating theDDL scripts to create the
objects. Designer even lets you deploy the same object, such as a table,
with different storage parameters to different databases - say, development,
test, and production.

The
reverse engineering functionality (called "Design Capture" in the tool) of
Designer is extremely useful. You don't have to create all the objects
of a database by hand, just point Designer at a schema and let it suck up all
the details into the Designer Repository - a real time
saver.

There is definitely a *steep* learning curve
associated with Designer and the benefits of the tool are more along the lines
of quality, consistency, impact analysis, etc. rather than more rapid
development and/or deployment. Get some (or lots) of training
andhire a Designer "Guru" to spend some time with you showing you some
good techniques for doing what you want to do. Don't get an expert in
Oracle Forms generation to help you with Designer's DBA functionaliy,
however. Get the "Guru" that has the specific expertise you need.
Check out the Oracle Development Tools User Group (ODTUG) at www.odtug.comfor info on how to
subscribe to the Designer (and other) lists, which are hosted along with this
list right here at FatCity.

Designer is HUGE, but you can successfully and
profitably use just the pieces you want.

Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8
DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent:
Thursday, September 20, 2001 4:45 PMTo: Multiple recipients of
list ORACLE-LSubject: Best Uses for Oracle Designer
2000?

Is
anyone out there deriving much benefit from Oracle Designer 2000? My company has the product and I set
it up but it looks like the initial investment in learning the product and
creating everything in the repository will be extremely time-consuming. So, please tell me your favorite
uses for Designer.

Thanks,

David

David B.
Wagoner
Database
Administrator
Arsenal
Digital Solutions Worldwide Inc.
4815
Emperor Blvd., Suite 110
Durham,
NC 27703
Tel.
(919) 941-4645
Fax
(919) 474-0695
Email
mailto:[EMAIL PROTECTED]
Web
http://www.arsenaldigital.com/

*** NOTICE ***
This
e-mail message is confidential, intended only for the named recipient(s)
above and may contain information that is privileged, 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 the sender at (919) 941-4645 and
delete this e-mail message from your computer. Thank you.

Re: Upgrade to 8.1.7.2 on Linux -- an interesting happening

2001-09-21 Thread Bill Buchan



Yes - same thing - just applied the 8172 patch yesterday to two 817 
Standard Edition servers on SuSE 7.2 and they both now indicate Enterprise 
Edition  with all the options enabled.

- Bill.

At 14:20 20/09/01 -0800, you wrote:
Today we upgraded one of our 8.1.7.0.1 _STANDARD EDITION_ distributions on a
test server to 8.1.7.2.

An interesting thing happened.

After we brought up the test database we had running on the machine, it came
up indicating that we were running the _ENTERPRISE EDITION_ of Oracle. A
query of v$option showed that we were, indeed, running the Enterprise
Edition of Oracle.

Just for grins, we restored the old 8.1.7.0.1 distribution, brought up the
old database, and it was running under the Standard Edition.

Has anyone else done an upgrade to 8.1.7.2? Anyone notice the same thing?

We think it's great of Oracle to provide us a patch allowing us to
seamlessly switch to the Enterprise Edition.

Somehow, though, I don't think that's what they're trying to do here...

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

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

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

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

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

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

Re: Rash of shared memory errors

2001-09-21 Thread Maria Aurora VT de la Vega


are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following in our 
development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than our test 
and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been developing 
a new application in the database, but this has been ongoing for some months; the 
errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

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

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

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

RE: 2nd DBA or ?


Agreed, it is in the best interest of the company to have two Oracle
professionals.  ESPECIALLY if your doing in house development.

Production support, generally the amount of dba's is very black and white,
you can tell by the amount of work they are doing and how much has to be put
off to the next day.  As for development, it is not as measurable.  I tend
to like a lot of involvement with development, even help out code when there
are some issues that need to resolve quickly.  It is very noticeable when a
product is development without dba involvement.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L

Well, this seems to me to be a cynical/paranoid way of looking at things.
Probably true in some circles though.

Personally, I'm with the Hire A Second DBA crowd. I, too, would much rather
have a life. Too much fun stuff to do out there, too many places to go and
beer to drink.

--Walt (I'm goin' fishin') Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, September 20, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L


If we lived in a perfect world, where the employee
matters, then I would hire an additional DBA to share
ideas and responsibility.

However, since we live in a capatilistic world, I
would do the job by myself for the following reasons:
1. Management will see one of you as being redundant
during financial problems because there was one person
doing this job before, therefore they can get rid of
one of the DBAs and still be ok.

2. Mamangement acknowledges that there is a possible
need to hire an additional person, thus acknowledging
that you do the job of two people. This is a benefit
to you for asking for a big pay increase.

3. Hiring Oracle consultants and purchasing software
are tax deductible to the company as opposed to paying
a salary to another person and providing them with
Health Care and Office Space. At least in the USA.

4. If you hire a entry-level DBA, chances are that
he/she  will learn his skill set from you and then
move on to bigger opportunities (which puts you back
to square one) or he/she will just stab you in the
back to try to get your job.

Regards,
Satar

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

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

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

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

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

RE: Rash of shared memory errors

2001-09-21 Thread Toepke, Kevin M


There is also a fix for this on Metalink (I think version 8.1.7.3)

-Original Message-
Sent: Friday, September 21, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following
in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
our test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

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

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

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Rash of shared memory errors


Yes, one of the reasons we upgraded to 8.1.7.2 was to fix this bug. Can't
report just yet as to whether it works or not.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, September 21, 2001 3:30 AM
To: Multiple recipients of list ORACLE-L


are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following
in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
our test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

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

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

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Rash of shared memory errors


Arn

A shared pool size of 16 Meg is not large enough.  This error clearly
indicates that you are out of memory.

It may be larger than your test and maintenance db, but it is not large
enough for your developers. 

I don't know about you, but I have more developers on my Dev instances than
testers on my testing instance!  My shared pool value in my Dev instance is
80Meg, and I never get this error.

Try increasing your shared pool to at least 50 Meg and see if the problem
goes away.

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 21, 2001 3:55 AM
To: Multiple recipients of list ORACLE-L


Hi,

Just recently, we have been frequently receiving errors like the following
in our development database:

ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

The size of our shared pool is not too small (I think); it's larger than our
test and maintenance databases, for example.

shared_pool_reserved_sizestring  80
shared_pool_size string  1600

What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

What should I be looking for to solve this?

Thanx for any advice.

-arn




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

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

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

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

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

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

RE: Intermedia question

2001-09-21 Thread Martin Kendall


Hi Maria,

IFS would involve scanning the whole document whereas Intermedia allows
for indexing the documents.



-Original Message-
Sent: 21 September 2001 10:40
To: Multiple recipients of list ORACLE-L


yes, its possible.
although, from my experience indexing a bfile takes a lot longer than
indexing a blob...
and why not try using IFS for this?


[EMAIL PROTECTED] wrote:

 Good day,

 I have an application that has many documents (Word, Excel, pdf, email
etc) stored on a Solaris file system. I want to be able to search the
contents of those document. Is it possible to create some tables in the
database that has BFILE
 columns that reference those documents outside the database and use
InterMedia to do searching?

 I am not familiar with LOBs and Intermedia, that's why I ask this basic
question.

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

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

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Rash of shared memory errors

2001-09-21 Thread Rahul

i would take a look at the application before increasing the size

 --
 From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, September 21, 2001 7:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Rash of shared memory errors

 Arn

 A shared pool size of 16 Meg is not large enough.  This error clearly
 indicates that you are out of memory.

 It may be larger than your test and maintenance db, but it is not large
 enough for your developers. 

 I don't know about you, but I have more developers on my Dev instances
 than
 testers on my testing instance!  My shared pool value in my Dev instance
 is
 80Meg, and I never get this error.

 Try increasing your shared pool to at least 50 Meg and see if the problem
 goes away.

 Hope this helps

 Tom Mercadante
 Oracle Certified Professional

 -Original Message-
 Sent: Friday, September 21, 2001 3:55 AM
 To: Multiple recipients of list ORACLE-L

 Hi,

 Just recently, we have been frequently receiving errors like the following
 in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
 our
 test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
 developing a new application in the database, but this has been ongoing
 for
 some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

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

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

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

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

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

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

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

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

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Mark Leith


Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and then
to 0 again?

Mark

-Original Message-
Bellefeuille, Wayne S
Sent: Friday, September 21, 2001 13:15
To: Multiple recipients of list ORACLE-L


This is the one I am running.  It just doesn't seem to be doing the
trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
need to look elsewhere for my temp segment problem?

Wayne

-Original Message-
Sent: Thursday, September 20, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the wake SMON approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup smon_pid.

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

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

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

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

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

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

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

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

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

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

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

RE: coalesce tablespace

2001-09-21 Thread Koivu, Lisa

Title: RE: coalesce tablespace





Hi Dave, 


No. temporary tablespaces provide a performance gain by not de-allocating extents. The next transaction that needs the temp tablespace can utilize extents that are already allocated, thus bypassing the overhead of allocating the extents. 

That's the idea behind it anyway. I always ignored temp when determining if coalescing is necessray in the database. 


Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117




-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 7:23 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: coalesce tablespace


Does this also apply to a temporary tablespace?? I have a temp TS that has
a percent extents coalesced of 1.


Thanks,


Dave


-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L



Following script may be used to check whether coalesing is required or not. 
If lasr column not 100% then coalesce that tbs


select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/



MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800


It would take contiguous free extents and make them larger extents, which
would be more likely to reuse. Especially if there are many smaller ones,
this moot if using LMT.


It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.


Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


We have tablespaces in acceptance and production that are being resized for
growth. Pctincrease is set at 0. Would it also help to coalesce the
tablespace? What are the benefits of this command?
Thanks,
Sandi


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


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

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


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

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



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


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


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

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


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

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

RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening

2001-09-21 Thread Todd Carlson


Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...

-Original Message-
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


Yes - same thing - just applied the 8172 patch yesterday to two 817 
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise 
Edition  with all the options enabled.

- Bill.

At 14:20 20/09/01 -0800, you wrote:
Today we upgraded one of our 8.1.7.0.1 _STANDARD EDITION_ distributions
on a
test server to 8.1.7.2.

An interesting thing happened.

After we brought up the test database we had running on the machine, it
came
up indicating that we were running the _ENTERPRISE EDITION_ of Oracle.
A
query of v$option showed that we were, indeed, running the Enterprise
Edition of Oracle.

Just for grins, we restored the old 8.1.7.0.1 distribution, brought up
the
old database, and it was running under the Standard Edition.

Has anyone else done an upgrade to 8.1.7.2? Anyone notice the same
thing?

We think it's great of Oracle to provide us a patch allowing us to
seamlessly switch to the Enterprise Edition.

Somehow, though, I don't think that's what they're trying to do here...

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

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

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

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

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

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

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

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

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

RE: 2nd DBA or ?

2001-09-21 Thread Koivu, Lisa

Title: RE: 2nd DBA or ?





Another angle: when I left my last job, I was the only dba. They panicked and did everything they could to try to keep me. The result was they were left without a skilled dedicated dba, assigning my job responsibilities to a bda (big dumb a$$) who tried to learn it in one week. 

Any manager should be well aware of how dependent they become on just one person in such an important role. What if that person gets hit by a bus?

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 2nd DBA or ?


Agreed, it is in the best interest of the company to have two Oracle
professionals. ESPECIALLY if your doing in house development.


Production support, generally the amount of dba's is very black and white,
you can tell by the amount of work they are doing and how much has to be put
off to the next day. As for development, it is not as measurable. I tend
to like a lot of involvement with development, even help out code when there
are some issues that need to resolve quickly. It is very noticeable when a
product is development without dba involvement.



Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.


Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Thursday, September 20, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L


Well, this seems to me to be a cynical/paranoid way of looking at things.
Probably true in some circles though.


Personally, I'm with the Hire A Second DBA crowd. I, too, would much rather
have a life. Too much fun stuff to do out there, too many places to go and
beer to drink.


--Walt (I'm goin' fishin') Weaver
 Bozeman, Montana


-Original Message-
Sent: Thursday, September 20, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L



If we lived in a perfect world, where the employee
matters, then I would hire an additional DBA to share
ideas and responsibility.


However, since we live in a capatilistic world, I
would do the job by myself for the following reasons:
1. Management will see one of you as being redundant
during financial problems because there was one person
doing this job before, therefore they can get rid of
one of the DBAs and still be ok.


2. Mamangement acknowledges that there is a possible
need to hire an additional person, thus acknowledging
that you do the job of two people. This is a benefit
to you for asking for a big pay increase.


3. Hiring Oracle consultants and purchasing software
are tax deductible to the company as opposed to paying
a salary to another person and providing them with
Health Care and Office Space. At least in the USA.


4. If you hire a entry-level DBA, chances are that
he/she will learn his skill set from you and then
move on to bigger opportunities (which puts you back
to square one) or he/she will just stab you in the
back to try to get your job.


Regards,
Satar


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


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

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


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

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

Optimal Disk Layout??

2001-09-21 Thread Walter K


Hi,

I'm encuntering a relatively high iowait percentage
when my hot backups are running. The platform is Sun
(E420 2cpu running SunOS 5.7) with an A1000 disk array
(8 9Gb drives, hardware Raid-5). The array is one
volume and all DB components (redo, archive, data,
index, system, etc.) are on the same volume except for
the binaries. The database is not large, only ~8Gb in
size and the transactional volume is not much either.
However, when the backups run, the iowait according to
'top' hovers between 50-70% which causes our
application to time-out via Web Logic 6.0.

The developers can't explain why the timeouts are
occurring (WLS 6.0 is a new upgrade from 5.1). The
SysAdmin isn't much help either.

I have an opportunity to rebuild the database on
another machine and use RAID 1+0 -- the thought being
that we are choking ourselves with Raid-5 when the hot
backups are performing the cp's (copies) and then the
files are compressed. 

My first question is, how is the data distributed
across the drives in my Raid-5 configuration? Is each
disk being filled contiguously in series or is the
data being spread around in a pseudo-striping manner?

My second question/dilema is, the new array (another
A1000) will have 6 18Gb drives and with Raid 1+0 that
shrinks to 3 drives of usable space for everything
except redo and archive. 4 9Gb drives will be added in
two mirrored sets, one for redo and the other for
archive. I'm afraid that I will see worse I/O
performance with the new array because it has so fewer
physical drives, thus eliminating the benefit of not
having to write the parity info. 

Do you concur? Knowing the two arrays I have to work
with, which would be the better configuration? 

Any suggestions, recommendations would VERY much be
appreciated.

Thanks again for the feedback.
-w

__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  INET: [EMAIL PROTECTED]

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

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

RE: Best Uses for Oracle Designer 2000?

2001-09-21 Thread Vadim Gorbounov

Tom, Jack,

Thank you for sharing your invaluable experience. Can you
shed some light, how do you estimate impact of database changes (anythimng,
changing view's or procedure interface) on application? How do you (or
developers) know in advance, what pieces of code need to be revised in this
case, especially when the project is, say, large? As far as I see, there is no
central repository in your environment. Of course, I understand, best practice
addressing these issues do not make such changes at all, but in case? Anybody in
this list has technology helping database-application (say Java, or VB whatever)
dependency tracking?

Thank you
Vadim Gorbounov
Oracle DBA

-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, September 21, 2001
9:00 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Best Uses for Oracle Designer 2000?
David,

I
agree with Jack.

I
have not used Designer for generating applications (have tried, but not been
successfull - clearly because I did not have the time).

But
I use it exclusively for database design and object creation (TbSpaces,
tables, indexes, PK's, FK's, CK's, Seq's, Trigs Views). It is
great for buidling all of the relatioinships and then generating the DDL
scripts. Once you learn how it works, it is *much* faster than
maintaining sql scripts for all of your database objects.

I
agree, that there is a learning curve. But, you can "reverse engineer" a
small database, and see how everything is stored to learn what needs to be
done where.

I do
not keep PL/SQL (except for triggers) in the repos, mostly because I don't see
the benefit. The tool does not help you develop the scripts (we use
Toad), so storing them in the repos makes no sense to me (our developers use
SourceSafe for code managment).

Hope
this helps.
Tom Mercadante Oracle Certified Professional

I've used Designer (and Oracle*CASE before it) for
about 10 years now. I've always used it for logical data modelling and
physical database implementation. In my Developer past, I've done a
ton of Oracle Forms and Reports generation from Designer, as well as Web
Server Generator apps. All my PL/SQL stored packages have always (and
still do) live in Designer.

Now that I'm focussed on Development DBA work, I
user Designer for physical database design and implementation and PL/SQL
package development. It is wonderful for specifying tables, along with
their constraints, indexes, triggers, etc., etc. then generating
theDDL scripts to create the objects. Designer even lets you
deploy the same object, such as a table, with different storage parameters
to different databases - say, development, test, and
production.

The reverse engineering functionality (called
"Design Capture" in the tool) of Designer is extremely useful. You
don't have to create all the objects of a database by hand, just point
Designer at a schema and let it suck up all the details into the Designer
Repository - a real time saver.

There is definitely a *steep* learning curve
associated with Designer and the benefits of the tool are more along the
lines of quality, consistency, impact analysis, etc. rather than more rapid
development and/or deployment. Get some (or lots) of training
andhire a Designer "Guru" to spend some time with you showing you some
good techniques for doing what you want to do. Don't get an expert in
Oracle Forms generation to help you with Designer's DBA functionaliy,
however. Get the "Guru" that has the specific expertise you
need. Check out the Oracle Development Tools User Group (ODTUG) at www.odtug.comfor info on how to
subscribe to the Designer (and other) lists, which are hosted along with
this list right here at FatCity.

Designer is HUGE, but you can successfully and
profitably use just the pieces you want.

Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8
DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

Is
anyone out there deriving much benefit from Oracle Designer 2000? My company has the product and I
set it up but it looks like the initial investment in learning

RE: coalesce tablespace

2001-09-21 Thread tday6


This script will show you how much you will gain via a coalesce.  Not all
tablespaces will coalesce to 100%.

rem
rem FILE: BEFORE_AFTER.SQL
rem location: $HOME/bin
rem invocation: @before_after TABLESPACE (where TABLESPACE is the
rem name of the tablespace being investigated)
rem
rem From Oracle DBA Handbook by Kevin Loney, Oracle Press
rem
rem This SQL*Plus script evaluates a target tablespace to determine
rem the potential benefit of coalescing the neighboring free space
rem extents. If the New FSFI value is beneath your threshold,
rem then the tablespace must be defragmented.
rem

spool before_after.lst

set verify off pagesize 60
ttitle center 'Before-After Changes Report for '1 skip 2
break on starting_file_id skip 1
column new_length format 
column num_fragments format 
column current_top format 

SELECT
starting_file_id, /*starting file ID for extent*/
starting_block_id, /*starting block ID for extent*/
sum(blocks) new_length, /*combine length for extents*/
count(blocks) num_fragments, /*number of frags combined*/
max(blocks) current_top /*largest extent of the set*/
FROM contig_space
WHERE tablespace_name = upper('1')
GROUP BY
starting_file_id,
starting_block_id
HAVING count(*)1
ORDER BY 1,2
/
ttitle center 'Old FSFI rating for '1 skip 1
column fsfi format 999.999

SELECT
sqrt(max(blocks)/sum(blocks))*
(100/sqrt(sqrt(count(blocks fsfi
FROM sys.dba_free_space
WHERE tablespace_name = upper('1')
/

ttitle center 'New FSFI rating for '1 skip 1
column new_fsfi format 999.999
SELECT
sqrt(max(sum_blocks)/sum(sum_blocks))*
(100/sqrt(sqrt(count(sum_blocks fsfi
FROM new_look
WHERE tablespace_name = upper('1')
/
spool off




   

Mohammad   

RafiqTo: Multiple recipients of list ORACLE-L  

rafiq9857   [EMAIL PROTECTED]

@hotmail.comcc:   

Sent by: rootSubject: RE: coalesce tablespace  

   

   

09/20/2001 

04:50 PM   

Please 

respond to 

ORACLE-L   

   

   





Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

Re: Oracle error after recovery

2001-09-21 Thread Ruth Gramolini


You need to recover the database using backup controlfile.  That should
still be ok to do it now if you haven't already gotten the answer.

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 20, 2001 10:25 AM


 I did a complete recovery of an Oracle instance.  Everything looked great
 but when I bounced the instance
 and tried to bring it back up I got the following Oracle error.  I have
 checked everything.  There are no other
 instances running.

 Any ideas?

 Ron

 ORA-00205: error in identifying control file
 '/stk0103/m001/oradata/conv/control1.ctl'
 ORA-09782: sfifi: another instance has the same database mounted.
 SVRMGR exit
 Server Manager complete.
  mailto:oracle@conv oracle@conv: oerr ORA 09782
 09782, 0, sfifi: another instance has the same database mounted.
 // *Cause:  In non-shared disk systems, database cannot be mounted shared.
 // *Action: Shutdown the other oracle instance and try again.  The name
 //  of the other instance was dumped to the trace file.



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

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


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

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

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

SharePlex Questions

2001-09-21 Thread Mike J Kurth


I am evaluating SharePlex and I have some questions:

In the current release, do the foreign key constraints need to be disabled
in the target database? Doesn't it take a while to enable the foreign keys
during failover?

How did you handle switching the users over to the target database?
Push out new tnsnames.ora?
Change IP addresses on servers?

How fast is the failover?

How do you handle reorganizing tables and other table maint?

Thanks


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

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

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

RE: Oracle error after recovery

2001-09-21 Thread Smith, Ron L.


How do you do a recover when you can't mount the database?
Ron

-Original Message-
Sent: Friday, September 21, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L


You need to recover the database using backup controlfile.  That should
still be ok to do it now if you haven't already gotten the answer.

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 20, 2001 10:25 AM


 I did a complete recovery of an Oracle instance.  Everything looked great
 but when I bounced the instance
 and tried to bring it back up I got the following Oracle error.  I have
 checked everything.  There are no other
 instances running.

 Any ideas?

 Ron

 ORA-00205: error in identifying control file
 '/stk0103/m001/oradata/conv/control1.ctl'
 ORA-09782: sfifi: another instance has the same database mounted.
 SVRMGR exit
 Server Manager complete.
  mailto:oracle@conv oracle@conv: oerr ORA 09782
 09782, 0, sfifi: another instance has the same database mounted.
 // *Cause:  In non-shared disk systems, database cannot be mounted shared.
 // *Action: Shutdown the other oracle instance and try again.  The name
 //  of the other instance was dumped to the trace file.



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

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


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

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

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

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

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

Oracle DBA Needed in St. Louis..

2001-09-21 Thread OraStaff


Join an excellent West St. Louis county based organization that needs an
Oracle DBA.
This company has offering challenging projects and a great work environment. 

*Responsibilitites
In this environment, you will have a variety of responsibilities including
logical 
and physical design, performance tuning, security, full cycle scratch
development projects 
as well as support of SAP and other packages.

* This company is looking for someone local to the St Louis area. 
Candidates not in the St Louis area cannot be considered.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.



* Requirements:
- 3+ Years Oracle DBA experience 
- Any Data Warehouse/Data Mining experience is a plus
- U.S. citizenship or Permanent residency is also required

These positions offer:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base salary-D.O.E. up to 82K to start.
   
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
ph: 1-800 -549-8502
Please use job code One/St. Louis/DBA/Fred

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law







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

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

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

RE: 2nd DBA or ?


one of my old bosses used to prefix things with if Rachel gets hit by
a bus

still didn't hire anyone else, just asked me to document


--- Koivu, Lisa [EMAIL PROTECTED] wrote:
 Another angle:  when I left my last job, I was the only dba.  They
 panicked
 and did everything they could to try to keep me.  The result was they
 were
 left without a skilled dedicated dba, assigning my job
 responsibilities to a
 bda (big dumb a$$) who tried to learn it in one week.  
 
 Any manager should be well aware of how dependent they become on just
 one
 person in such an important role.  What if that person gets hit by a
 bus?
 
 Lisa Koivu
 Oracle Database Administrator
 Fairfield Resorts, Inc.
 954-935-4117
 
 
  -Original Message-
  From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, September 21, 2001 9:15 AM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: 2nd DBA or ?
  
  Agreed, it is in the best interest of the company to have two
 Oracle
  professionals.  ESPECIALLY if your doing in house development.
  
  Production support, generally the amount of dba's is very black and
 white,
  you can tell by the amount of work they are doing and how much has
 to be
  put
  off to the next day.  As for development, it is not as measurable. 
 I tend
  to like a lot of involvement with development, even help out code
 when
  there
  are some issues that need to resolve quickly.  It is very
 noticeable when
  a
  product is development without dba involvement.
  
  
  Do not criticize someone until you walked a mile in their shoes,
 that way
  when you criticize them, you are a mile a way and have their
 shoes.
  
  Christopher R. Spence 
  Oracle DBA
  Phone: (978) 322-5744
  Fax:(707) 885-2275
  
  Fuelspot
  73 Princeton Street
  North, Chelmsford 01863
   
  
  
  -Original Message-
  Sent: Thursday, September 20, 2001 11:10 PM
  To: Multiple recipients of list ORACLE-L
  
  Well, this seems to me to be a cynical/paranoid way of looking at
 things.
  Probably true in some circles though.
  
  Personally, I'm with the Hire A Second DBA crowd. I, too, would
 much
  rather
  have a life. Too much fun stuff to do out there, too many places to
 go and
  beer to drink.
  
  --Walt (I'm goin' fishin') Weaver
Bozeman, Montana
  
  -Original Message-
  Sent: Thursday, September 20, 2001 5:45 PM
  To: Multiple recipients of list ORACLE-L
  
  
  If we lived in a perfect world, where the employee
  matters, then I would hire an additional DBA to share
  ideas and responsibility.
  
  However, since we live in a capatilistic world, I
  would do the job by myself for the following reasons:
  1. Management will see one of you as being redundant
  during financial problems because there was one person
  doing this job before, therefore they can get rid of
  one of the DBAs and still be ok.
  
  2. Mamangement acknowledges that there is a possible
  need to hire an additional person, thus acknowledging
  that you do the job of two people. This is a benefit
  to you for asking for a big pay increase.
  
  3. Hiring Oracle consultants and purchasing software
  are tax deductible to the company as opposed to paying
  a salary to another person and providing them with
  Health Care and Office Space. At least in the USA.
  
  4. If you hire a entry-level DBA, chances are that
  he/she  will learn his skill set from you and then
  move on to bigger opportunities (which puts you back
  to square one) or he/she will just stab you in the
  back to try to get your job.
  
  Regards,
  Satar
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Weaver, Walt
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Christopher Spence
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).

RE: Oracle error after recovery

2001-09-21 Thread MHately




Ron,

Check that the instance lock file LK isn't still present in your
$OACLE_HOME/dbs directory.
It's there to stop a database being mounted twice and in the case of a database
crash there's a good chance that it's been left lying about.

Cheers,
Mike Hately
Oracle DBA

PS 1st email to the list from this site (which uses a Lotus Notes email client).
Can someone tell me is it sending html or text?
I don't want to flood the server with huge messages.



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

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

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

RE: Optimal Disk Layout??


1.  depends on the stripe width, data may be on one or many drives, parity
will always get written to all.

2.  I believe your performance will be better; you have 6 drives for data,
and 4 for archive/redo.  That equates to 12 drives over the previous 8.
However, you were using all eight for everything.

I don't believe there is any purpose to mirror the four drives, I like to
use Raid 0 or single drives for redo, and just do multiple members and
archive destinations.  Redo/Archive is high write activity, Raid 1 takes a
small hit on write, and only benefits read performance.  You can get the
same redundancy using duplex destination and multiple members.

Having redo logs and archive logs separate will prove to be beneficial.

All and all, I think you will come up with a better configuration
performance-wise.

Make sure the A1000 has the 80Mb cache, and has the latest firmware, as it
there are a lot of buggy A1000's out there that cause corruption if they are
saturated.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L

Hi,

I'm encuntering a relatively high iowait percentage
when my hot backups are running. The platform is Sun
(E420 2cpu running SunOS 5.7) with an A1000 disk array
(8 9Gb drives, hardware Raid-5). The array is one
volume and all DB components (redo, archive, data,
index, system, etc.) are on the same volume except for
the binaries. The database is not large, only ~8Gb in
size and the transactional volume is not much either.
However, when the backups run, the iowait according to
'top' hovers between 50-70% which causes our
application to time-out via Web Logic 6.0.

The developers can't explain why the timeouts are
occurring (WLS 6.0 is a new upgrade from 5.1). The
SysAdmin isn't much help either.

I have an opportunity to rebuild the database on
another machine and use RAID 1+0 -- the thought being
that we are choking ourselves with Raid-5 when the hot
backups are performing the cp's (copies) and then the
files are compressed. 

My first question is, how is the data distributed
across the drives in my Raid-5 configuration? Is each
disk being filled contiguously in series or is the
data being spread around in a pseudo-striping manner?

My second question/dilema is, the new array (another
A1000) will have 6 18Gb drives and with Raid 1+0 that
shrinks to 3 drives of usable space for everything
except redo and archive. 4 9Gb drives will be added in
two mirrored sets, one for redo and the other for
archive. I'm afraid that I will see worse I/O
performance with the new array because it has so fewer
physical drives, thus eliminating the benefit of not
having to write the parity info. 

Do you concur? Knowing the two arrays I have to work
with, which would be the better configuration? 

Any suggestions, recommendations would VERY much be
appreciated.

Thanks again for the feedback.
-w

__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: 2nd DBA or ?

2001-09-21 Thread Todd Carlson

Title: RE: 2nd DBA or ?









Whats with the normal sig. What the
hell happened to the Wanton Kicking Boxing Goddess Lisa? 



Todd Carlson

Oracle Database Administrator

Tripos, Inc.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Koivu,
Lisa
Sent: Friday, September 21, 2001
9:21 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: 2nd DBA or ?



Another angle:
when I left my last job, I was the only dba. They panicked and did
everything they could to try to keep me. The result was they were left
without a skilled dedicated dba, assigning my job responsibilities to a bda
(big dumb a$$) who tried to learn it in one week. 

Any manager should be
well aware of how dependent they become on just one person in such an important
role. What if that person gets hit by a bus?

Lisa Koivu 
Oracle Database
Administrator 
Fairfield Resorts, Inc.

954-935-4117




-Original Message- 
From: Christopher Spence
[SMTP:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001 9:15 AM

To: Multiple recipients
of list ORACLE-L 
Subject:
RE: 2nd
DBA or ? 

Agreed, it is in the best interest of the company to
have two Oracle 
professionals.
ESPECIALLY if your doing in house development. 

Production support, generally the amount of dba's is
very black and white, 
you
can tell by the amount of work they are doing and how much has to be put

off to
the next day. As for development, it is not as measurable. I tend

to
like a lot of involvement with development, even help out code when there

are
some issues that need to resolve quickly. It is very noticeable when a

product
is development without dba involvement. 



Do not criticize someone until you walked a
mile in their shoes, that way 
when
you criticize them, you are a mile a way and have their shoes.


Christopher R. Spence 
Oracle
DBA 
Phone:
(978) 322-5744 
Fax:
(707) 885-2275 

Fuelspot 
73
Princeton Street 
North,
Chelmsford 01863 





-Original Message- 
Sent:
Thursday, September 20, 2001 11:10 PM 
To:
Multiple recipients of list ORACLE-L 

Well, this seems to me to be a cynical/paranoid way
of looking at things. 
Probably
true in some circles though. 

Personally, I'm with the Hire A Second DBA crowd. I,
too, would much rather 
have a
life. Too much fun stuff to do out there, too many places to go and

beer
to drink. 

--Walt (I'm goin' fishin') Weaver 

Bozeman, Montana 

-Original Message- 
Sent:
Thursday, September 20, 2001 5:45 PM 
To:
Multiple recipients of list ORACLE-L 



If we lived in a perfect world, where the employee

matters,
then I would hire an additional DBA to share 
ideas
and responsibility. 

However, since we live in a capatilistic world, I

would
do the job by myself for the following reasons: 
1.
Management will see one of you as being redundant 
during
financial problems because there was one person 
doing
this job before, therefore they can get rid of 
one of
the DBAs and still be ok. 

2. Mamangement acknowledges that there is a possible

need
to hire an additional person, thus acknowledging 
that
you do the job of two people. This is a benefit 
to you
for asking for a big pay increase. 

3. Hiring Oracle consultants and purchasing software

are
tax deductible to the company as opposed to paying 
a
salary to another person and providing them with 
Health
Care and Office Space. At least in the USA. 

4. If you hire a entry-level DBA, chances are that

he/she
will learn his skill set from you and then 
move
on to bigger opportunities (which puts you back 
to
square one) or he/she will just stab you in the 
back
to try to get your job. 

Regards, 
Satar


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

-- 
Author:
Weaver, Walt 

INET: [EMAIL PROTECTED] 

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


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

also
send the HELP command for other information (like subscribing). 
-- 
Please
see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author:
Christopher Spence 

INET: [EMAIL PROTECTED] 

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


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

also
send the HELP command for other information (like subscribing).

Re: 9iAS Forms on Solaris (or Unix)

2001-09-21 Thread Niyi Olajide


Hi Charlie,

Dont know about f60gen.

However, I do compile forms with the f60genm and works fine.
I scratched the script below to make my task a bit easier, so I just do
compile form formname.fmb or
compile menu menuname.mmb as applicable.

You can try modifying the environment vairables below, to suit your
environment, (no pun intended!). Whats more, you can even enahance it and
let me have a copy when you're done. I'll like to make it as parameterised
as possible, as soon I can squeeze out some 30 minutes.

HTH,
Niyi




#!/bin/sh
## Script to compile a form for the PayPers froms server
## Refer to Install Doc for more detail on each of these environment
variables
## Scratched by Niyi Olajide 13th September 2001

#ORACLE_HOME=/oracle/9i/OraIasHome/6iserver; export ORACLE_HOME
ORACLE_HOME=/oracle/9i/OraIasHome/6iserver; export ORACLE_HOME

echo ...
echo ...Forms Compiler Script...
if [ $1 ]
then
   form=$ORACLE_HOME/forms60/PayPers/Forms/$1.fmb
 else
   echo `basename $0`: no form specified
   echo Usage: `basename $0` { form name },  path searched is
/oracle/9i/OraIasHome/6iserver/forms60/PayPers/forms } 
   echo (c) 2001 Niyi Olajide 
   exit 1
fi



## If you need more than one directory in your path, all directories should
be
## separated by ':'
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:$ORACLE_HOME/n
etwork/jre11/lib/sparc/native_threads; export LD_LIBRARY_PATH

## You may need to set TWO_TASK or ORACLE_SID to connect to database
#TWO_TASK=; export TWO_TASK
ORACLE_SID=devdb; export ORACLE_SID
#COMP_DB=devdb; export COMP_DB

## setting for Forms runtime
# Forms Server looks in FORMS60_PATH for Forms to run
FORMS60_PATH=$ORACLE_HOME/forms60:$ORACLE_HOME/forms60/PayPers/Forms:$FORMS
60_PATH; export FORMS60_PATH
FORMS60_OUTPUT=$ORACLE_HOME/tools/web60/temp; export FORMS60_OUTPUT
TNS_ADMIN=/oracle/9i/OraHome/network/admin ; export TNS_ADMIN
#FORMS60_MAPPING=http://sparky:/dev60temp; export FORMS60_MAPPING
FORMS60_MAPPING=http://sparky:7778; export FORMS60_MAPPING
FORMS60_REPFORMAT=html; export FORMS60_REPFORMAT

## Need to have PRINTER or ORACLE_PRINTER or REPORTS60_NO_DUMMY_PRINTER
#  set if Forms will run a Report via RUN_PRODUCT
if [ $PRINTER =  ]
then
  if [ $ORACLE_PRINTER =  ]
  then
 REPORTS60_NO_DUMMY_PRINTER=; export REPORTS60_NO_DUMMY_PRINTER
  fi
fi

REPORTS60_PATH=$ORACLE_HOME/reports60/admin/templates:$ORACLE_HOME/tools/dev
dem60/demo/reports; export REPORTS60_PATH


echo \nCompiling form $form
#echodo
f60genm module=$form  userid=hrman/hrman@$ORACLE_SID
echo (c) 2001 Niyi Olajide 
exit 0


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 10:56 PM


 I have a collection of *mmb, *olb,  *plx files
 which are needed to successfully compile *fmb files in *fmx.
 At the present I have all of these libraries residing in a
 single directory which is included in FORMS60_PATH; but f60gen
 does not seem to be able to resolve objects that reside in
 these libraries.

 If/when I placed the fmb file into this library directory
 and make it my current working directory, I can successfully
 get f60gen to create the desired *fmx file.

 So far Oracle Tech. Sup. has been unable to assist.
 It is not clear whether the source of the problem is
 related to an environmental variable, filename case
 sensitivity (since the FMB files were created on NT),
 or something else.

 I'd like to hear from anyone who is successfully using
 *mmb, *olb,  *plx files on Unix to generate fmx files.

 --
 Charlie MenglerMaintenance Warehouse
 [EMAIL PROTECTED]   10641 Scripps Summit Ct.
 858-831-2229   San Diego, CA 92131
 There is at least one infinite resource in the universe. Stupidity!
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY,

Installing 8.1.7

2001-09-21 Thread Ramon Estevez




Hi 
folks,


Actually I have 8.0.5 and will 
install 8.1.7 in the weekend, and would like to have somethings clear.

Actually I have just 2 
tablespaces, but planning to make one for each application 
system,
will be like 
7.

Of course will makeallkind of backups, cold, hot including redo 
logs, password files, parameter files and archives.

What I am planning to do 
is make an export of the user owner of the all objects and
make and import in the 
new DB. 


1) How to find the 
ideal size of the extent for a locally managed 
 
tablespace uniform size ?

2) 
As far as 
I know, not much, the import will create the same tablespaces where 
the
 
objects exists in the old DB in the new DB. Now,  if I use an alter table 
move 
 
tablespace to move the tables to the new LMTtablespace, will it use the extent 

 
size of the new TBS or will remain with the old one ? 

3) I'm considering 
to recreate all the indexes.

4) Is it a good 
idea to have an TBS for each APP system ?

5) What are the 
consequences of having all of them with different extent size 
?

6) If by any chance 
some of themare going to have the same extent size 
 
wouldn't be better to put them in one TBS ?
 

6) Any tips for 
sizing of the SGA, shared pool, log_buffers, sort_area_size 
?

7) Planning make 
db_block_size 8k


8) My second step 
will be implement Forms Server, anything to include in the 
 
installation of have in mind from now ?

My DB is transactional, 
not that heavily, like 40 users, but like 12 of them are 
remote.

Hardware
Compaq 

2 Pentium III processor 
800 mhz
6 Hard Drive 9.1 GB - 
raid 5
1 GB 
Memory
Win 2000 
server


Thanks in advance and 
sure that your help will be very, very useful.



Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121

RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening


I decided to try it out.

I tried creating both a bitmap index and a function-based index as follows:
=
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate table test_table(
  2  col1 number,
  3  col2 varchar2(50));
 
Table created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate bitmap index index1 on
test_table(col1);
 
Index created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate index index2 on
test_table(UPPER(col2));
 
Index created.
===
When I tried this on the original, non-patched 8.1.7.0.1 Standard Edition I
got the usual Feature not enabled message.

So, yeah, I'd say the functionality is there. Gosh, I wonder if Oracle is
aware of this?

--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Friday, September 21, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L


Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...

-Original Message-
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


Yes - same thing - just applied the 8172 patch yesterday to two 817 
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise 
Edition  with all the options enabled.

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

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

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

RE: 2nd DBA or ?

2001-09-21 Thread Gogala, Mladen

Document getting hit by a bus? You must have a photographer 
following you around

 -Original Message-
 From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 21, 2001 11:16 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: 2nd DBA or ?

 one of my old bosses used to prefix things with if Rachel gets hit by
 a bus

 still didn't hire anyone else, just asked me to document

 --- Koivu, Lisa [EMAIL PROTECTED] wrote:
  Another angle:  when I left my last job, I was the only dba.  They
  panicked
  and did everything they could to try to keep me.  The 
 result was they
  were
  left without a skilled dedicated dba, assigning my job
  responsibilities to a
  bda (big dumb a$$) who tried to learn it in one week.  

  Any manager should be well aware of how dependent they 
 become on just
  one
  person in such an important role.  What if that person gets hit by a
  bus?

  Lisa Koivu
  Oracle Database Administrator
  Fairfield Resorts, Inc.
  954-935-4117

   -Original Message-
   From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
   Sent: Friday, September 21, 2001 9:15 AM
   To:   Multiple recipients of list ORACLE-L
   Subject:  RE: 2nd DBA or ?

   Agreed, it is in the best interest of the company to have two
  Oracle
   professionals.  ESPECIALLY if your doing in house development.

   Production support, generally the amount of dba's is very 
 black and
  white,
   you can tell by the amount of work they are doing and how much has
  to be
   put
   off to the next day.  As for development, it is not as 
 measurable. 
  I tend
   to like a lot of involvement with development, even help out code
  when
   there
   are some issues that need to resolve quickly.  It is very
  noticeable when
   a
   product is development without dba involvement.

   Do not criticize someone until you walked a mile in their shoes,
  that way
   when you criticize them, you are a mile a way and have their
  shoes.

   Christopher R. Spence 
   Oracle DBA
   Phone: (978) 322-5744
   Fax:(707) 885-2275

   Fuelspot
   73 Princeton Street
   North, Chelmsford 01863

   -Original Message-
   Sent: Thursday, September 20, 2001 11:10 PM
   To: Multiple recipients of list ORACLE-L

   Well, this seems to me to be a cynical/paranoid way of looking at
  things.
   Probably true in some circles though.

   Personally, I'm with the Hire A Second DBA crowd. I, too, would
  much
   rather
   have a life. Too much fun stuff to do out there, too many 
 places to
  go and
   beer to drink.

   --Walt (I'm goin' fishin') Weaver
 Bozeman, Montana

   -Original Message-
   Sent: Thursday, September 20, 2001 5:45 PM
   To: Multiple recipients of list ORACLE-L

   If we lived in a perfect world, where the employee
   matters, then I would hire an additional DBA to share
   ideas and responsibility.

   However, since we live in a capatilistic world, I
   would do the job by myself for the following reasons:
   1. Management will see one of you as being redundant
   during financial problems because there was one person
   doing this job before, therefore they can get rid of
   one of the DBAs and still be ok.

   2. Mamangement acknowledges that there is a possible
   need to hire an additional person, thus acknowledging
   that you do the job of two people. This is a benefit
   to you for asking for a big pay increase.

   3. Hiring Oracle consultants and purchasing software
   are tax deductible to the company as opposed to paying
   a salary to another person and providing them with
   Health Care and Office Space. At least in the USA.

   4. If you hire a entry-level DBA, chances are that
   he/she  will learn his skill set from you and then
   move on to bigger opportunities (which puts you back
   to square one) or he/she will just stab you in the
   back to try to get your job.

   Regards,
   Satar

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

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

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

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

RE: Installing 8.1.7

2001-09-21 Thread DENNIS WILLIAMS


Ramon -  
 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See
white papers at technet.oracle.com for further details on the new
philosophy.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Hi folks,
 

Actually I have 8.0.5 and  will install 8.1.7 in the weekend, and would like
to have somethings clear.
 
Actually I have just 2 tablespaces, but planning to make one for each
application system,
will be like 7.
 
Of course will make all kind of backups, cold, hot including redo logs,
password files, parameter files and archives.
 
What I am planning to do is make an export of the user owner of the all
objects and
make and import in the new DB.  
 

 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
 
 2) As far as I know, not much, the import will create the same tablespaces
where the
 objects exists in the old DB in the new DB.  Now, if I use an alter
table move   
 tablespace to move the tables to the new LMT tablespace, will it use
the extent 
 size of the new TBS or will remain with the old one ? 
 
 3) I'm considering to recreate all the indexes.
 
 4) Is it a good idea to have an TBS for each APP system ?
 
 5) What are the consequences of having all of them with different extent
size ?
 
 6) If by any chance some of them are going to have the same extent size 
wouldn't be better to put them in one TBS ?
 
 6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size
?
 
 7) Planning make db_block_size 8k
 

 8) My second step will be implement Forms Server, anything to include in
the 
 installation of have in mind from now ?
 
My DB is transactional, not that heavily, like 40 users, but like 12 of them
are remote.
 
Hardware
Compaq 
2 Pentium III processor 800 mhz
6 Hard Drive 9.1 GB - raid 5
1 GB Memory
Win 2000 server
 
 
Thanks in advance and sure that your help will be very, very useful.
 
 
 
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Dominican Republic
809-565-3121
 

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

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

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

Re: Oracle error after recovery

2001-09-21 Thread Ruth Gramolini


Try a shutdown and startup force.  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 21, 2001 11:00 AM


 How do you do a recover when you can't mount the database?
 Ron

 -Original Message-
 Sent: Friday, September 21, 2001 9:40 AM
 To: Multiple recipients of list ORACLE-L


 You need to recover the database using backup controlfile.  That should
 still be ok to do it now if you haven't already gotten the answer.

 HTH,
 Ruth
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, September 20, 2001 10:25 AM


  I did a complete recovery of an Oracle instance.  Everything looked
great
  but when I bounced the instance
  and tried to bring it back up I got the following Oracle error.  I have
  checked everything.  There are no other
  instances running.
 
  Any ideas?
 
  Ron
 
  ORA-00205: error in identifying control file
  '/stk0103/m001/oradata/conv/control1.ctl'
  ORA-09782: sfifi: another instance has the same database mounted.
  SVRMGR exit
  Server Manager complete.
   mailto:oracle@conv oracle@conv: oerr ORA 09782
  09782, 0, sfifi: another instance has the same database mounted.
  // *Cause:  In non-shared disk systems, database cannot be mounted
shared.
  // *Action: Shutdown the other oracle instance and try again.  The name
  //  of the other instance was dumped to the trace file.
 
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).


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

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

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

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

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

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

RE: Optimal Disk Layout??

2001-09-21 Thread Walter K


Isn't it 3 drives for data, not 6, because of the
mirroring? I agree, mirroring the extra 4 (9Gb) drives
isn't necessary because this can be accomplished via
the DB config.

Veritas is also being used on the existing array and
the sys admin seems to think that we've got extra
overhead for that on top of the hardware raid-5.

I have also been told that the controller has a 16Mb
cache on it, and it only goes to 64Mb.

-w


--- Christopher Spence [EMAIL PROTECTED] wrote:
 1.  depends on the stripe width, data may be on one
 or many drives, parity
 will always get written to all.
 
 2.  I believe your performance will be better; you
 have 6 drives for data,
 and 4 for archive/redo.  That equates to 12 drives
 over the previous 8.
 However, you were using all eight for everything.
 
 I don't believe there is any purpose to mirror the
 four drives, I like to
 use Raid 0 or single drives for redo, and just do
 multiple members and
 archive destinations.  Redo/Archive is high write
 activity, Raid 1 takes a
 small hit on write, and only benefits read
 performance.  You can get the
 same redundancy using duplex destination and
 multiple members.
 
 Having redo logs and archive logs separate will
 prove to be beneficial.
 
 All and all, I think you will come up with a better
 configuration
 performance-wise.
 
 Make sure the A1000 has the 80Mb cache, and has the
 latest firmware, as it
 there are a lot of buggy A1000's out there that
 cause corruption if they are
 saturated.
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence 
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275
 
 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863
  
 
 
 -Original Message-
 Sent: Friday, September 21, 2001 10:15 AM
 To: Multiple recipients of list ORACLE-L
 
 Hi,
 
 I'm encuntering a relatively high iowait percentage
 when my hot backups are running. The platform is Sun
 (E420 2cpu running SunOS 5.7) with an A1000 disk
 array
 (8 9Gb drives, hardware Raid-5). The array is one
 volume and all DB components (redo, archive, data,
 index, system, etc.) are on the same volume except
 for
 the binaries. The database is not large, only ~8Gb
 in
 size and the transactional volume is not much
 either.
 However, when the backups run, the iowait according
 to
 'top' hovers between 50-70% which causes our
 application to time-out via Web Logic 6.0.
 
 The developers can't explain why the timeouts are
 occurring (WLS 6.0 is a new upgrade from 5.1). The
 SysAdmin isn't much help either.
 
 I have an opportunity to rebuild the database on
 another machine and use RAID 1+0 -- the thought
 being
 that we are choking ourselves with Raid-5 when the
 hot
 backups are performing the cp's (copies) and then
 the
 files are compressed. 
 
 My first question is, how is the data distributed
 across the drives in my Raid-5 configuration? Is
 each
 disk being filled contiguously in series or is the
 data being spread around in a pseudo-striping
 manner?
 
 My second question/dilema is, the new array (another
 A1000) will have 6 18Gb drives and with Raid 1+0
 that
 shrinks to 3 drives of usable space for everything
 except redo and archive. 4 9Gb drives will be added
 in
 two mirrored sets, one for redo and the other for
 archive. I'm afraid that I will see worse I/O
 performance with the new array because it has so
 fewer
 physical drives, thus eliminating the benefit of not
 having to write the parity info. 
 
 Do you concur? Knowing the two arrays I have to work
 with, which would be the better configuration? 
 
 Any suggestions, recommendations would VERY much be
 appreciated.
 
 Thanks again for the feedback.
 -w
 
 __
 Terrorist Attacks on U.S. - How can you help?
 Donate cash, emergency relief information

http://dailynews.yahoo.com/fc/US/Emergency_Information/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Walter K
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


 To REMOVE

RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening

2001-09-21 Thread Mark Leith


The question is - are you going to be the one to tell them? :

Isn't Anita an Oracle employee?

Say no more.. :P

-Original Message-
Walt
Sent: Friday, September 21, 2001 16:55
To: Multiple recipients of list ORACLE-L


I decided to try it out.

I tried creating both a bitmap index and a function-based index as follows:
=
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate table test_table(
  2  col1 number,
  3  col2 varchar2(50));
 
Table created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate bitmap index index1 on
test_table(col1);
 
Index created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate index index2 on
test_table(UPPER(col2));
 
Index created.
===
When I tried this on the original, non-patched 8.1.7.0.1 Standard Edition I
got the usual Feature not enabled message.

So, yeah, I'd say the functionality is there. Gosh, I wonder if Oracle is
aware of this?

--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Friday, September 21, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L


Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...

-Original Message-
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


Yes - same thing - just applied the 8172 patch yesterday to two 817 
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise 
Edition  with all the options enabled.

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

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

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

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

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

Design Issue - Quick response appreciated




List,

OLTP 
application with 24x7 requirement.300,000 records per day are inserted 
into the transaction table. Environment: Solari 7. Oracle 
817.

The 
transaction table layout.

Security ID 
Account ID
Account Type
Trade 
Date
And 
other columns in this table.

In the 
above table, the primary key is -- Security ID + Account ID + Account Type + 
Trade Date

There 
aremanyto one relationshipsbuiltto other child tables 
from TransactionTable

Scenario:

User 
inserts a record into transaction table. In the first record, Account ID 
value is "HP" and he might insert a record into the child table (Or this 
transaction may not insert a record into a child table). After some time, the 
user queries the original record with the primary key and then changes the value 
in the column - Account ID to "IBM". Now, the original transaction 
record is NOT UPDATED. A record IS INSERTED with the new values. 
Also, he might or might not  insert a record into a child table with this new 
values of primary key.

Now 
the user would query the transaction table with Account ID = IBM. 
But,the user wants to get all the previous records also; in this case, he 
want to see the record with Account ID = "HP" also. Also, he want to see the 
related records from the child tables. 

I 
tried with the idea of sequence number generation but it was 
failing.

Any 
ideasor suggestions are much appreciated.

Thanks,

Rao
Maheswara Rao,
Oracle 
DBA
SunGard 
Securities

RE: 2nd DBA or ?

2001-09-21 Thread Kimberly Smith


Ditto.  One of the things that I get praised on is me training people.
Damn, I will train the whole office if that's what it takes.  I have 
been the only one, got a second dba for a month, and am back to being 
the only one.  Life is a lot easier with the second one around let me
tell you.  And it also lets you spread out the day to day 'boring' tasks
so you have time to tackle more exciting problems.  

-Original Message-
Sent: Friday, September 21, 2001 4:23 AM
To: Multiple recipients of list ORACLE-L


way too cynical.

One of the few things I learned in the management class I took was you have
to train the people
below you to do your job if you ever want a promotion

If no one else can do what you do, then you can't move on to other things.

On the other hand, Satar is a consultant. And looking at the world from that
direction, you
wouldn't want anyone else around to do what you do because you'd lose the
contract if there were a
full-timer around (you can have a fulltimer put in extra hours without
having to pay more)

But as a full-time employee, I want someone else around. Because there is
ALWAYS too much work for
one person, at least in my shop.

Rachel

--- Weaver, Walt [EMAIL PROTECTED] wrote:
 Well, this seems to me to be a cynical/paranoid way of looking at things.
 Probably true in some circles though.
 
 Personally, I'm with the Hire A Second DBA crowd. I, too, would much
rather
 have a life. Too much fun stuff to do out there, too many places to go and
 beer to drink.
 
 --Walt (I'm goin' fishin') Weaver
   Bozeman, Montana
 
 -Original Message-
 Sent: Thursday, September 20, 2001 5:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 If we lived in a perfect world, where the employee
 matters, then I would hire an additional DBA to share
 ideas and responsibility.
 
 However, since we live in a capatilistic world, I
 would do the job by myself for the following reasons:
 1. Management will see one of you as being redundant
 during financial problems because there was one person
 doing this job before, therefore they can get rid of
 one of the DBAs and still be ok.
 
 2. Mamangement acknowledges that there is a possible
 need to hire an additional person, thus acknowledging
 that you do the job of two people. This is a benefit
 to you for asking for a big pay increase.
 
 3. Hiring Oracle consultants and purchasing software
 are tax deductible to the company as opposed to paying
 a salary to another person and providing them with
 Health Care and Office Space. At least in the USA.
 
 4. If you hire a entry-level DBA, chances are that
 he/she  will learn his skill set from you and then
 move on to bigger opportunities (which puts you back
 to square one) or he/she will just stab you in the
 back to try to get your job.
 
 Regards,
 Satar
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Weaver, Walt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

2nd DBA or ? - THANX!

2001-09-21 Thread O'Neill, Sean


Thanx to all you folk who replied on this matter.  The humour, satire,
paranoia etc. in replies was worth the posting.  The 2nd DBA vote won by a
large majority.  Now to convince damagament


Sean :)

Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA --- End 2002 deadline =:-O
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King

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

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

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

RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening


Yes, this is truly a moral dilemma.

I'm gonna buy a couple six packs of Moose Drool and ponder on it, or maybe
not ponder on it and concentrate on football instead, this weekend.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, September 21, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L


The question is - are you going to be the one to tell them? :

Isn't Anita an Oracle employee?

Say no more.. :P

-Original Message-
Walt
Sent: Friday, September 21, 2001 16:55
To: Multiple recipients of list ORACLE-L


I decided to try it out.

I tried creating both a bitmap index and a function-based index as follows:
=
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate table test_table(
  2  col1 number,
  3  col2 varchar2(50));
 
Table created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate bitmap index index1 on
test_table(col1);
 
Index created.
 
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate index index2 on
test_table(UPPER(col2));
 
Index created.
===
When I tried this on the original, non-patched 8.1.7.0.1 Standard Edition I
got the usual Feature not enabled message.

So, yeah, I'd say the functionality is there. Gosh, I wonder if Oracle is
aware of this?

--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Friday, September 21, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L


Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...

-Original Message-
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


Yes - same thing - just applied the 8172 patch yesterday to two 817 
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise 
Edition  with all the options enabled.

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

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

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

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

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

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

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

RE: Better Way Of DeFragmentation


Agreed.


-Original Message-
Sent: Thursday, September 20, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


True.  If he clones the whole database each way.  My understanding was that
he planned just to move the schema into a dummy database, resize the
objects, do a cold backup, and move the datafiles from the cold backup that
contained the appropriate tablespaces.  I don't think that that would work.



 

Miller, Jay

JayMiller@TDWaterTo: Multiple recipients of
list ORACLE-L  
house.com[EMAIL PROTECTED]

Sent by:  cc:

[EMAIL PROTECTED]  Subject: RE: Better Way Of
DeFragmentation
 

 

09/20/2001 02:31

PM

Please respond to

ORACLE-L

 

 





My understanding that he was copying the control files also - i.e., cloning
the 2nd database back to the first machine.  This works since he said it's
usually read only so there wouldn't have been any changes between when he
cloned 1 to 2 and when he clones 2 to 1.



-Original Message-
Sent: Thursday, September 20, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L


Consider going to tablespaces where all the extents are of a uniform size.
I.e., all objects in any one tablespace have the same INITIAL and NEXT
storage parameters.  These tablespaces will never need to be defragmented.

I'm not sure that your outlined procedure will work.  I think that your
cold backup from the 2nd machine will be out of synch (timestamp-wise) with
your control files.  It may be possible to do some recovery to overcome
this but I'm not familiar with that.

You could do an export from the 2nd machine, drop the tablespace(s) on the
1st machine, and do in import.

If you have data that is changing a lot over time, then you could get set
all the objects' NEXT parameter to a uniform size and the tablespaces will
coalesce naturally over time.





Harvinder Singh

Harvinder.Singh@MetrTo: Multiple
recipients
of list ORACLE-L
aTech.com   [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED] Subject: Better Way Of
DeFragmentation




09/20/2001 10:35 AM

Please respond to

ORACLE-L









Hi,

We have to defragment one of our production databases..(objects are not
properly sized)..
Since i can't shutdown database for more than 2 hrs and database is read
only and  DML
statements run thru batch jobs 2 days in month. We r thinking of using the
following scheme.

1) export the particular application schema name NMDD of production
database.
2) On second machine run the DDL script which creates all the objects with
proper sizing.
3) Import the data from export taken in step 1.
4) take the cold backup of 2nd machine.
5) copy the backup files from 2nd machine to production machine.

Is there any better way to get rid of fragmentation without using any third
party tool..
or Is there any flaw in above procedure.

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

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

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


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

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

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

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

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

Oracle Recovery from Cold backup.

2001-09-21 Thread Smith, Ron L.


I have a what if question.
Say you had a complete cold backup, including control files from a few days
ago.
You also had all the archive logs for the past few days.
Today you lost your server and had to recover.
You lay down all the database files, including the control files.
Now you want to apply your archive logs.
Oracle can't know about the archive logs because all the files you restored
are old.
Do you just tell Oracle where the archive logs are and it keeps aplying them
until 
you say you are finished?

Just wondering.

Ron

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

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

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

RE: coalesce tablespace

2001-09-21 Thread Mohammad Rafiq


Yes, But in your case being pctincrease set as '1' you will most of the time 
see 100% in your last column. Even if you don't coalesce manually, it will 
be done by smon internally with regular interval...

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 21 Sep 2001 03:23:27 -0800

Does this also apply to a temporary tablespace??  I have a temp TS that has
a percent extents coalesced of 1.

Thanks,

Dave

-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

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

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


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

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

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

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

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

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


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

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

RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening

2001-09-21 Thread tday6


I suspect that they do now.  LOL



   

Weaver,   

WaltTo: Multiple recipients of list ORACLE-L  

wweaver [EMAIL PROTECTED]

@rightnow.comcc:   

Subject: RE: Upgrade to 8.1.7.2 on Linux 
--   
Sent by: rootan interesting happening  

   

   

09/21/2001 

11:55 AM   

Please 

respond to 

ORACLE-L   

   

   





I decided to try it out.

I tried creating both a bitmap index and a function-based index as follows:
=
TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate table test_table(
  2  col1 number,
  3  col2 varchar2(50));

Table created.

TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate bitmap index index1 on
test_table(col1);

Index created.

TESTDB.US.ORACLE.COM.SYSTEM.SQLcreate index index2 on
test_table(UPPER(col2));

Index created.
===
When I tried this on the original, non-patched 8.1.7.0.1 Standard Edition I
got the usual Feature not enabled message.

So, yeah, I'd say the functionality is there. Gosh, I wonder if Oracle is
aware of this?

--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Friday, September 21, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L


Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...

-Original Message-
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


Yes - same thing - just applied the 8172 patch yesterday to two 817
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise
Edition  with all the options enabled.

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

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

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


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

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

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

RE: Design Issue - Quick response appreciated










Generally it is bad practice to use columns in the primary key, which
change. They introduce many different
problems.





Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes.

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax: (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
 



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: Design Issue - Quick
response appreciated





List,











OLTP application with
24x7 requirement.300,000 records per day are inserted into the
transaction table. Environment: Solari 7. Oracle 817.











The transaction table
layout.











Security ID 





Account ID





Account Type





Trade Date





And other columns in this
table.











In the above table, the
primary key is -- Security ID + Account ID + Account Type + Trade Date











There
aremanyto one relationshipsbuiltto other child tables
from TransactionTable











Scenario:











User inserts a record
into transaction table. In the first record, Account ID value is
HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time, the
user queries the original record with the primary key and then changes the
value in the column - Account ID to IBM. Now, the
original transaction record is NOT UPDATED. A record IS INSERTED with the
new values. Also, he might or might not insert a record into a child
table with this new values of primary key.











Now the user would query
the transaction table with Account ID = IBM. But,the user wants to
get all the previous records also; in this case, he want to see the record with
Account ID = HP also. Also, he want to see the related records from
the child tables. 











I tried with the idea of
sequence number generation but it was failing.











Any ideasor
suggestions are much appreciated.











Thanks,











Rao





Maheswara Rao,





Oracle DBA





SunGard Securities

RE: Oracle Recovery from Cold backup.

2001-09-21 Thread Kimberly Smith


You have to tell it that you are using a backup control file.
Otherwise it will think the database is up-to-date.  

-Original Message-
Sent: Friday, September 21, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L


I have a what if question.
Say you had a complete cold backup, including control files from a few days
ago.
You also had all the archive logs for the past few days.
Today you lost your server and had to recover.
You lay down all the database files, including the control files.
Now you want to apply your archive logs.
Oracle can't know about the archive logs because all the files you restored
are old.
Do you just tell Oracle where the archive logs are and it keeps aplying them
until 
you say you are finished?

Just wondering.

Ron

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

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

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

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

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

RE: 2nd DBA or ?


Not to mention having the time to study and read.  I'm back to the Oracle
101 Performance Tuning Book for the first time in over a month today.
And that's only because all changes have been frozen except for Disaster
Recovery...

Jay Miller

-Original Message-
Sent: Friday, September 21, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Ditto.  One of the things that I get praised on is me training people.
Damn, I will train the whole office if that's what it takes.  I have 
been the only one, got a second dba for a month, and am back to being 
the only one.  Life is a lot easier with the second one around let me
tell you.  And it also lets you spread out the day to day 'boring' tasks
so you have time to tackle more exciting problems.  

-Original Message-
Sent: Friday, September 21, 2001 4:23 AM
To: Multiple recipients of list ORACLE-L


way too cynical.

One of the few things I learned in the management class I took was you have
to train the people
below you to do your job if you ever want a promotion

If no one else can do what you do, then you can't move on to other things.

On the other hand, Satar is a consultant. And looking at the world from that
direction, you
wouldn't want anyone else around to do what you do because you'd lose the
contract if there were a
full-timer around (you can have a fulltimer put in extra hours without
having to pay more)

But as a full-time employee, I want someone else around. Because there is
ALWAYS too much work for
one person, at least in my shop.

Rachel

--- Weaver, Walt [EMAIL PROTECTED] wrote:
 Well, this seems to me to be a cynical/paranoid way of looking at things.
 Probably true in some circles though.
 
 Personally, I'm with the Hire A Second DBA crowd. I, too, would much
rather
 have a life. Too much fun stuff to do out there, too many places to go and
 beer to drink.
 
 --Walt (I'm goin' fishin') Weaver
   Bozeman, Montana
 
 -Original Message-
 Sent: Thursday, September 20, 2001 5:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 If we lived in a perfect world, where the employee
 matters, then I would hire an additional DBA to share
 ideas and responsibility.
 
 However, since we live in a capatilistic world, I
 would do the job by myself for the following reasons:
 1. Management will see one of you as being redundant
 during financial problems because there was one person
 doing this job before, therefore they can get rid of
 one of the DBAs and still be ok.
 
 2. Mamangement acknowledges that there is a possible
 need to hire an additional person, thus acknowledging
 that you do the job of two people. This is a benefit
 to you for asking for a big pay increase.
 
 3. Hiring Oracle consultants and purchasing software
 are tax deductible to the company as opposed to paying
 a salary to another person and providing them with
 Health Care and Office Space. At least in the USA.
 
 4. If you hire a entry-level DBA, chances are that
 he/she  will learn his skill set from you and then
 move on to bigger opportunities (which puts you back
 to square one) or he/she will just stab you in the
 back to try to get your job.
 
 Regards,
 Satar
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Weaver, Walt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

RE: coalesce tablespace


SMON very poorly does coalesce and a source of many problems.  
(ST Enqueue which is serial for atomic modification of the data dictionary).

I always set my PCTINCREASE 0, and manually coalesce or use LMT.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L

Yes, But in your case being pctincrease set as '1' you will most of the time

see 100% in your last column. Even if you don't coalesce manually, it will 
be done by smon internally with regular interval...

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 21 Sep 2001 03:23:27 -0800

Does this also apply to a temporary tablespace??  I have a temp TS that has
a percent extents coalesced of 1.

Thanks,

Dave

-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

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

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


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

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

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

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

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

setting up HACMP and Oracle 8.1.6

2001-09-21 Thread jacinth


I hope someone may be able to shed some light on this.  Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing).  I am not an HA expert, so I may just be
missing something or not asking right questions.

HW:  IBM S7A
OS:  AIX 4.3.3
Oracle 8.1.6

Scenario:  Two nodes, one set up production, the other test/batch.  We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process.  Oracle is installed on
each node, but in different directories.

Problem:  On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener.  Listener log not much help.
HACMP log shows:

Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?


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

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

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

RE: Design Issue - Quick response appreciated


One thought is to have an additional column called something like
'PRIOR_ID'.  If the Account_id is changed (actually a new value inserted)
then the PRIOR_ID for the new row is set to the ACCOUNT_ID of the old row.
That way you can always trace back if the transaction used to have a
different account.
 
 
Jay Miller

-Original Message-
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L


List,
 
OLTP application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.
 
The transaction table layout.
 
Security ID  
Account ID
Account Type
Trade Date
And other columns in this table.
 
In the above table, the primary key is -- Security ID + Account ID + Account
Type + Trade Date
 
There are many to one relationships built to other child tables from
Transaction Table
 
Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 
 
I tried with the idea of sequence number generation but it was failing.
 
Any ideas or suggestions are much appreciated.
 
Thanks,
 
Rao
Maheswara Rao,
Oracle DBA
SunGard Securities


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

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

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

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Bellefeuille, Wayne S


The problem is not the TEMP tablespace.  Rather, the index rebuild is
failing on finding temp segment space in the index's tablespace.  This
is because SMON doesn't seem to be cleaning the temp segments after the
prior index's rebuild is done, and eventually, the rebuild of the
indexes fails.  However, when I restart the process in a few minutes,
the index that failed before works now, but a different index (or
partition) fails.  This seems to point to SMON not working fast enough
to clean out the temp segments before the next index's rebuild starts.

The wake smon script worked great in 8.0 to fix this problem, but
doesn't seem to work (or at least work fast enough) in 8i.  

Is there anything that can be done?

Wayne

-Original Message-
Sent: Friday, September 21, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and
then
to 0 again?

Mark

-Original Message-
Bellefeuille, Wayne S
Sent: Friday, September 21, 2001 13:15
To: Multiple recipients of list ORACLE-L


This is the one I am running.  It just doesn't seem to be doing the
trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
need to look elsewhere for my temp segment problem?

Wayne

-Original Message-
Sent: Thursday, September 20, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the wake SMON approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup smon_pid.

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

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

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

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

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

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

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

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

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

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

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

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

RE: Design Issue - Quick response appreciated




In our 
case, we do not have any other columns --- 1. which could identify uniquely a 
record and yet do not undergo a change.

Thanks,

Rao

  -Original Message-From: Christopher Spence 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, September 21, 2001 1:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Design Issue - Quick response appreciated
  
  Generally it is bad practice 
  to use columns in the primary key, which change. They introduce many different 
  problems.
  
  
  "Do not criticize 
  someone until you walked a mile in their shoes, that way when you criticize 
  them, you are a mile a way and have their shoes."
  Christopher 
  R. Spence Oracle 
  DBA Phone: 
  (978) 322-5744 Fax: 
  (707) 885-2275 
  Fuelspot 
  73 
  Princeton Street North, 
  Chelmsford 01863  
  
  -Original 
  Message-From: Rao, 
  Maheswara [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 12:35 
  PMTo: Multiple recipients of 
  list ORACLE-LSubject: Design 
  Issue - Quick response appreciated
  
  
  List,
  
  
  
  OLTP 
  application with 24x7 requirement.300,000 records per day are inserted 
  into the transaction table. Environment: Solari 7. Oracle 
  817.
  
  
  
  The 
  transaction table layout.
  
  
  
  Security 
  ID 
  
  Account 
  ID
  
  Account 
  Type
  
  Trade 
  Date
  
  And 
  other columns in this table.
  
  
  
  In the 
  above table, the primary key is -- Security ID + Account ID + Account Type + 
  Trade Date
  
  
  
  There 
  aremanyto one relationshipsbuiltto other child tables 
  from TransactionTable
  
  
  
  Scenario:
  
  
  
  User 
  inserts a record into transaction table. In the first record, Account ID 
  value is "HP" and he might insert a record into the child table (Or this 
  transaction may not insert a record into a child table). After some time, the 
  user queries the original record with the primary key and then changes the 
  value in the column - Account ID to "IBM". Now, the original 
  transaction record is NOT UPDATED. A record IS INSERTED with the new 
  values. Also, he might or might not insert a record into a child table 
  with this new values of primary key.
  
  
  
  Now the 
  user would query the transaction table with Account ID = IBM. 
  But,the user wants to get all the previous records also; in this case, 
  he want to see the record with Account ID = "HP" also. Also, he want to see 
  the related records from the child tables. 
  
  
  
  I tried 
  with the idea of sequence number generation but it was 
  failing.
  
  
  
  Any 
  ideasor suggestions are much 
  appreciated.
  
  
  
  Thanks,
  
  
  
  Rao
  
  Maheswara 
  Rao,
  
  Oracle 
  DBA
  
  SunGard 
  Securities

RE: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread Mohan, Ross


could this be an oracle email thing?...just guessing from libe name...


anyways...if you can, see if you can place symlinks to this libe in
/lib, /usr/lib, $ORACLE_HOME/lib, etc. 

if the system still can't find it...well...either a LD_LIBRARY_PATH or PATH
error?

oh, btw, are the oracle versions identical on the nodes?

- Ross

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


I hope someone may be able to shed some light on this.  Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing).  I am not an HA expert, so I may just be
missing something or not asking right questions.

HW:  IBM S7A
OS:  AIX 4.3.3
Oracle 8.1.6

Scenario:  Two nodes, one set up production, the other test/batch.  We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process.  Oracle is installed on
each node, but in different directories.

Problem:  On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener.  Listener log not much help.
HACMP log shows:

Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?


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

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

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

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

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

RE: Design Issue - Quick response appreciated










Then use a surrogate key, i.e. sequence
number.



Numbers that change are not candidates for
key, doing so introduces problems in which you are having as well as others.



Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes.

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax: (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
 



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001 2:30 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Design Issue - Quick
response appreciated





In our case, we do not
have any other columns --- 1. which could identify uniquely a record and yet do
not undergo a change.











Thanks,











Rao





-Original Message-
From: Christopher Spence
[mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001
1:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Design Issue - Quick
response appreciated

Generally it is bad
practice to use columns in the primary key, which change. They introduce many different problems.





Do not criticize
someone until you walked a mile in their shoes, that way when you criticize
them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax: (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
 



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001
12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: Design Issue - Quick
response appreciated





List,











OLTP
application with 24x7 requirement.300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.











The
transaction table layout.











Security
ID 





Account
ID





Account
Type





Trade
Date





And other
columns in this table.











In the
above table, the primary key is -- Security ID + Account ID + Account Type +
Trade Date











There
aremanyto one relationshipsbuiltto other child tables
from TransactionTable











Scenario:











User
inserts a record into transaction table. In the first record, Account ID
value is HP and he might insert a record into the child table (Or
this transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes the
value in the column - Account ID to IBM. Now, the
original transaction record is NOT UPDATED. A record IS INSERTED with the
new values. Also, he might or might not insert a record into a child table
with this new values of primary key.











Now the
user would query the transaction table with Account ID = IBM.
But,the user wants to get all the previous records also; in this case, he
want to see the record with Account ID = HP also. Also, he want to
see the related records from the child tables. 











I tried
with the idea of sequence number generation but it was failing.











Any
ideasor suggestions are much appreciated.











Thanks,











Rao





Maheswara
Rao,





Oracle
DBA





SunGard
Securities

RE: Waking SMON Not Doing Trick


When you get an error  failing on finding temp segment space in the
index's tablespace.  It has nothing to do with your temporary tablespace.
It has to do with your data/index tablespace.

The error saying Unable to allocate 5 bytes of temp space in tablespace
blah is saying that your tablespace does not have enough room to create the
temporary segment that upon completion becomes the actual index/table
segment, add space to the tablespace, or defragment it to get larger
extents.

This error is a little confusing as it leads you to believe it is looking
for temporary tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


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

The problem is not the TEMP tablespace.  Rather, the index rebuild is
failing on finding temp segment space in the index's tablespace.  This
is because SMON doesn't seem to be cleaning the temp segments after the
prior index's rebuild is done, and eventually, the rebuild of the
indexes fails.  However, when I restart the process in a few minutes,
the index that failed before works now, but a different index (or
partition) fails.  This seems to point to SMON not working fast enough
to clean out the temp segments before the next index's rebuild starts.

The wake smon script worked great in 8.0 to fix this problem, but
doesn't seem to work (or at least work fast enough) in 8i.  

Is there anything that can be done?

Wayne

-Original Message-
Sent: Friday, September 21, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and
then
to 0 again?

Mark

-Original Message-
Bellefeuille, Wayne S
Sent: Friday, September 21, 2001 13:15
To: Multiple recipients of list ORACLE-L


This is the one I am running.  It just doesn't seem to be doing the
trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
need to look elsewhere for my temp segment problem?

Wayne

-Original Message-
Sent: Thursday, September 20, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the wake SMON approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup smon_pid.

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

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

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

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

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

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

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

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

RE: Installing 8.1.7

2001-09-21 Thread Ron Rogers


Dennis,
 I know that Oracle lists 3 sizes for the LMTbut you can specify any size extent if 
you do not use the auto feature. I have created a lot of different LMT extent sizes 
for tables that are like in size and activity. That way I have a better handle on the 
resources especually when the disks are a premium. Why put an active table initial 50 
K next 50 K in a 128K tablespace. Why not manage the tablespace and make the extents 
100 K?
 
From the ORAMAG article:The Autuallocate option allows
Oracle to take control of the extent allocation. Oracle will use extent
sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The
table created in the tablespace will adapt the auto extent policy of the
tablespace and use increasingly larger extents as the table grows in size.
 Locally Managed Tablespaces
by Jonathan Gennick. located at
http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html
  
  
Just a thought.
ROR mª¿ªm

 [EMAIL PROTECTED] 09/21/01 12:00PM 
Ramon -  
 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See
white papers at technet.oracle.com for further details on the new
philosophy.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Hi folks,
 

Actually I have 8.0.5 and  will install 8.1.7 in the weekend, and would like
to have somethings clear.
 
Actually I have just 2 tablespaces, but planning to make one for each
application system,
will be like 7.
 
Of course will make all kind of backups, cold, hot including redo logs,
password files, parameter files and archives.
 
What I am planning to do is make an export of the user owner of the all
objects and
make and import in the new DB.  
 

 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
 
 2) As far as I know, not much, the import will create the same tablespaces
where the
 objects exists in the old DB in the new DB.  Now, if I use an alter
table move   
 tablespace to move the tables to the new LMT tablespace, will it use
the extent 
 size of the new TBS or will remain with the old one ? 
 
 3) I'm considering to recreate all the indexes.
 
 4) Is it a good idea to have an TBS for each APP system ?
 
 5) What are the consequences of having all of them with different extent
size ?
 
 6) If by any chance some of them are going to have the same extent size 
wouldn't be better to put them in one TBS ?
 
 6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size
?
 
 7) Planning make db_block_size 8k
 

 8) My second step will be implement Forms Server, anything to include in
the 
 installation of have in mind from now ?
 
My DB is transactional, not that heavily, like 40 users, but like 12 of them
are remote.
 
Hardware
Compaq 
2 Pentium III processor 800 mhz
6 Hard Drive 9.1 GB - raid 5
1 GB Memory
Win 2000 server
 
 
Thanks in advance and sure that your help will be very, very useful.
 
 
 
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Dominican Republic
809-565-3121
 

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

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

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

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

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

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

Re: Design Issue - Quick response appreciated

2001-09-21 Thread Big Planet




Rao ,
Does it mean you want all the transaction in that 
session .If yesthen ,Do you keep 
session_id somewhere ?

-BigP

  - Original Message - 
  From: 
  Rao, Maheswara 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, September 21, 2001 9:35 
  AM
  Subject: Design Issue - Quick response 
  appreciated
  
  List,
  
  OLTP 
  application with 24x7 requirement.300,000 records per day are inserted 
  into the transaction table. Environment: Solari 7. Oracle 
  817.
  
  The 
  transaction table layout.
  
  Security ID 
  Account ID
  Account Type
  Trade Date
  And 
  other columns in this table.
  
  In 
  the above table, the primary key is -- Security ID + Account ID + Account Type 
  + Trade Date
  
  There aremanyto one 
  relationshipsbuiltto other child tables from 
  TransactionTable
  
  Scenario:
  
  User 
  inserts a record into transaction table. In the first record, Account ID 
  value is "HP" and he might insert a record into the child table (Or this 
  transaction may not insert a record into a child table). After some time, the 
  user queries the original record with the primary key and then changes the 
  value in the column - Account ID to "IBM". Now, the original 
  transaction record is NOT UPDATED. A record IS INSERTED with the new 
  values. Also, he might or might not insert a record into a child table 
  with this new values of primary key.
  
  Now 
  the user would query the transaction table with Account ID = IBM. 
  But,the user wants to get all the previous records also; in this case, 
  he want to see the record with Account ID = "HP" also. Also, he want to see 
  the related records from the child tables. 
  
  I 
  tried with the idea of sequence number generation but it was 
  failing.
  
  Any 
  ideasor suggestions are much appreciated.
  
  Thanks,
  
  Rao
  Maheswara Rao,
  Oracle DBA
  SunGard 
Securities

RE: Waking SMON Not Doing Trick


SMON takes 5 minutes before it wakes up.

I have used the oradebug wakeup in Version 8i and it has worked for me,
although I don't need to use it much, I know it has worked when I have.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


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

The problem is not the TEMP tablespace.  Rather, the index rebuild is
failing on finding temp segment space in the index's tablespace.  This
is because SMON doesn't seem to be cleaning the temp segments after the
prior index's rebuild is done, and eventually, the rebuild of the
indexes fails.  However, when I restart the process in a few minutes,
the index that failed before works now, but a different index (or
partition) fails.  This seems to point to SMON not working fast enough
to clean out the temp segments before the next index's rebuild starts.

The wake smon script worked great in 8.0 to fix this problem, but
doesn't seem to work (or at least work fast enough) in 8i.  

Is there anything that can be done?

Wayne

-Original Message-
Sent: Friday, September 21, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and
then
to 0 again?

Mark

-Original Message-
Bellefeuille, Wayne S
Sent: Friday, September 21, 2001 13:15
To: Multiple recipients of list ORACLE-L


This is the one I am running.  It just doesn't seem to be doing the
trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
need to look elsewhere for my temp segment problem?

Wayne

-Original Message-
Sent: Thursday, September 20, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Steve Adams has a script, but I don't know if it works 8i

http://www.ixora.com.au/scripts/sql/post_smon.sql


-Original Message-
Sent: Thursday, September 20, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


Back in 8.0 days, we were running into space problems for temp segments
while rebuilding indexes on our large partitioned tables.  Someone on
this list suggested that we use the wake SMON approach, which
essentially running the following command from svrmgrl:  noradebug
wakeup smon_pid.

This worked great.  However, now that we have moved to 8i, we have
started getting the temp segments space problem again.  That is, this
command doesn't seem to be doing its job anymore.

Any ideas?

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

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

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

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

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

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

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

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

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

To REMOVE

RE: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread Vadim Gorbounov


Denise, 
This is one of Oracle libraries, responsible for integration with
third-party backup tools. 
Make sure, $ORACLE_HOME\lib is in LD_LIBRARY_PATH on node b. libobk.a should
be here ($ORACLE_HOME\lib)
HTH
Vadim Gorbounov
Oracle DBA 

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


I hope someone may be able to shed some light on this.  Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing).  I am not an HA expert, so I may just be
missing something or not asking right questions.

HW:  IBM S7A
OS:  AIX 4.3.3
Oracle 8.1.6

Scenario:  Two nodes, one set up production, the other test/batch.  We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process.  Oracle is installed on
each node, but in different directories.

Problem:  On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener.  Listener log not much help.
HACMP log shows:

Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?


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

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

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

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

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

RE: 2nd DBA or ?


but of course I do! doesn't every goddess?  :)


--- Gogala, Mladen [EMAIL PROTECTED] wrote:
 Document getting hit by a bus? You must have a photographer 
 following you around
 
  -Original Message-
  From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
  Sent: Friday, September 21, 2001 11:16 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: 2nd DBA or ?
  
  
  one of my old bosses used to prefix things with if Rachel gets hit
 by
  a bus
  
  still didn't hire anyone else, just asked me to document
  
  
  --- Koivu, Lisa [EMAIL PROTECTED] wrote:
   Another angle:  when I left my last job, I was the only dba. 
 They
   panicked
   and did everything they could to try to keep me.  The 
  result was they
   were
   left without a skilled dedicated dba, assigning my job
   responsibilities to a
   bda (big dumb a$$) who tried to learn it in one week.  
   
   Any manager should be well aware of how dependent they 
  become on just
   one
   person in such an important role.  What if that person gets hit
 by a
   bus?
   
   Lisa Koivu
   Oracle Database Administrator
   Fairfield Resorts, Inc.
   954-935-4117
   
   
-Original Message-
From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, September 21, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: 2nd DBA or ?

Agreed, it is in the best interest of the company to have two
   Oracle
professionals.  ESPECIALLY if your doing in house development.

Production support, generally the amount of dba's is very 
  black and
   white,
you can tell by the amount of work they are doing and how much
 has
   to be
put
off to the next day.  As for development, it is not as 
  measurable. 
   I tend
to like a lot of involvement with development, even help out
 code
   when
there
are some issues that need to resolve quickly.  It is very
   noticeable when
a
product is development without dba involvement.


Do not criticize someone until you walked a mile in their
 shoes,
   that way
when you criticize them, you are a mile a way and have their
   shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L

Well, this seems to me to be a cynical/paranoid way of looking
 at
   things.
Probably true in some circles though.

Personally, I'm with the Hire A Second DBA crowd. I, too, would
   much
rather
have a life. Too much fun stuff to do out there, too many 
  places to
   go and
beer to drink.

--Walt (I'm goin' fishin') Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, September 20, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L


If we lived in a perfect world, where the employee
matters, then I would hire an additional DBA to share
ideas and responsibility.

However, since we live in a capatilistic world, I
would do the job by myself for the following reasons:
1. Management will see one of you as being redundant
during financial problems because there was one person
doing this job before, therefore they can get rid of
one of the DBAs and still be ok.

2. Mamangement acknowledges that there is a possible
need to hire an additional person, thus acknowledging
that you do the job of two people. This is a benefit
to you for asking for a big pay increase.

3. Hiring Oracle consultants and purchasing software
are tax deductible to the company as opposed to paying
a salary to another person and providing them with
Health Care and Office Space. At least in the USA.

4. If you hire a entry-level DBA, chances are that
he/she  will learn his skill set from you and then
move on to bigger opportunities (which puts you back
to square one) or he/she will just stab you in the
back to try to get your job.

Regards,
Satar

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

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

RE: Undo x Rollback Segments in 9i


There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old method
of doing redo.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT RBS01  TABLESPACE RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback 
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback 
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito! 
http://explorer.msn.com.br

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

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

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

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

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

Re: Oracle Recovery from Cold backup.


I think you need a backup controlfile to keep applying the archived
logs
past the point of the cold backup. Otherwise Oracle thinks the database
is complete and won't do recovery

so...  when you do the cold backup, backup the controlfiles, but
also do a 'backup controlfile to filename';

so you can roll forward if you want. This presumes that the database is
in archivelog mode of course.

--- Smith, Ron L. [EMAIL PROTECTED] wrote:
 I have a what if question.
 Say you had a complete cold backup, including control files from a
 few days
 ago.
 You also had all the archive logs for the past few days.
 Today you lost your server and had to recover.
 You lay down all the database files, including the control files.
 Now you want to apply your archive logs.
 Oracle can't know about the archive logs because all the files you
 restored
 are old.
 Do you just tell Oracle where the archive logs are and it keeps
 aplying them
 until 
 you say you are finished?
 
 Just wondering.
 
 Ron
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread jacinth


Mohan, Ross wrote:
could this be an oracle email thing?...just guessing from libe name...

I don't know.  All I can tell is that the listener refuses to start and
repeats this over and over again.  hm...  I have seen a similar error
accompanying a linking problem, but do you have to relink everytime you
failover?  That would be pretty hokey, but you never know

anyways...if you can, see if you can place symlinks to this libe in
/lib, /usr/lib, $ORACLE_HOME/lib, etc. 

if the system still can't find it...well...either a LD_LIBRARY_PATH or PATH
error?

I will try this.

oh, btw, are the oracle versions identical on the nodes?

Exactly the same version.

- Ross

Thanks, Ross.

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


I hope someone may be able to shed some light on this.  Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing).  I am not an HA expert, so I may just be
missing something or not asking right questions.

HW:  IBM S7A
OS:  AIX 4.3.3
Oracle 8.1.6

Scenario:  Two nodes, one set up production, the other test/batch.  We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process.  Oracle is installed on
each node, but in different directories.

Problem:  On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener.  Listener log not much help.
HACMP log shows:

Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?


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

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

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

Re: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread tday6


How are your permissions?



   

jacinth

jacinth To: Multiple recipients of list ORACLE-L  

@mail.ev1.net[EMAIL PROTECTED]

cc:   

Sent by: rootSubject: setting up HACMP and Oracle 
8.1.6
   

   

09/21/2001 

02:20 PM   

Please 

respond to 

ORACLE-L   

   

   





I hope someone may be able to shed some light on this.  Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing).  I am not an HA expert, so I may just be
missing something or not asking right questions.

HW:  IBM S7A
OS:  AIX 4.3.3
Oracle 8.1.6

Scenario:  Two nodes, one set up production, the other test/batch.  We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process.  Oracle is installed on
each node, but in different directories.

Problem:  On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener.  Listener log not much help.
HACMP log shows:

Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?


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

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

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


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

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

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

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Lucy Lin


please check whether your index tablespace has enough space for index
rebuild.  When oracle rebuilds index, it requires space to store both old
index and new index during the process.

Lucy



On Fri, 21 Sep 2001, Bellefeuille, Wayne S wrote:

 The problem is not the TEMP tablespace.  Rather, the index rebuild is
 failing on finding temp segment space in the index's tablespace.  This
 is because SMON doesn't seem to be cleaning the temp segments after the
 prior index's rebuild is done, and eventually, the rebuild of the
 indexes fails.  However, when I restart the process in a few minutes,
 the index that failed before works now, but a different index (or
 partition) fails.  This seems to point to SMON not working fast enough
 to clean out the temp segments before the next index's rebuild starts.
 
 The wake smon script worked great in 8.0 to fix this problem, but
 doesn't seem to work (or at least work fast enough) in 8i.  
 
 Is there anything that can be done?
 
 Wayne
 
 -Original Message-
 Sent: Friday, September 21, 2001 8:00 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and
 then
 to 0 again?
 
 Mark
 
 -Original Message-
 Bellefeuille, Wayne S
 Sent: Friday, September 21, 2001 13:15
 To: Multiple recipients of list ORACLE-L
 
 
 This is the one I am running.  It just doesn't seem to be doing the
 trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
 need to look elsewhere for my temp segment problem?
 
 Wayne
 
 -Original Message-
 Sent: Thursday, September 20, 2001 3:05 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Steve Adams has a script, but I don't know if it works 8i
 
 http://www.ixora.com.au/scripts/sql/post_smon.sql
 
 
 -Original Message-
 Sent: Thursday, September 20, 2001 1:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Back in 8.0 days, we were running into space problems for temp segments
 while rebuilding indexes on our large partitioned tables.  Someone on
 this list suggested that we use the wake SMON approach, which
 essentially running the following command from svrmgrl:  noradebug
 wakeup smon_pid.
 
 This worked great.  However, now that we have moved to 8i, we have
 started getting the temp segments space problem again.  That is, this
 command doesn't seem to be doing its job anymore.
 
 Any ideas?
 
 Wayne Bellefeuille
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bellefeuille, Wayne S
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Norwood Bradly A
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bellefeuille, Wayne S
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 

-- 
Lucy Lin Oracle DBA

condenet.com 212-286-3852

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

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

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

RE: coalesce tablespace

2001-09-21 Thread Mohammad Rafiq


Agreed. I rather prefer temporary temp tablespace with tempfile and uniform 
LMT which even does not require coalesing infact that is an invalid option 
for that. But one must have 8i database to use it.
Regards
Rafiq



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 21 Sep 2001 10:06:02 -0800

SMON very poorly does coalesce and a source of many problems.
(ST Enqueue which is serial for atomic modification of the data dictionary).

I always set my PCTINCREASE 0, and manually coalesce or use LMT.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Friday, September 21, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L

Yes, But in your case being pctincrease set as '1' you will most of the time

see 100% in your last column. Even if you don't coalesce manually, it will
be done by smon internally with regular interval...

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 21 Sep 2001 03:23:27 -0800

Does this also apply to a temporary tablespace??  I have a temp TS that has
a percent extents coalesced of 1.

Thanks,

Dave

-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

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

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


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

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

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

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

I need help understanding how Oracle uses the OS buffer cache...

2001-09-21 Thread Shukle, Pranav


Hi Everyone,
We have been experiencing some I/O issues; and the systems support team (HP)
thinks that we should bump up our OS buffer cache.  Currently we are sitting
at 150MB; after researching on Metalink the recommendation from Oracle for
HPUX is to have a max of 128MB of buffer cache.  I have been trying to find
a document to help me understand how Oracle uses this buffer cache, and even
have opened up a TAR with Oracle; but does anyone know of a document or a
book which would help me understand this?
Metalink docs say that the buffer cache should be set to =128MB to avoid
losing writes; I cannot make sense of this statement.  Could someone help
me with this? 
We have HPUX 11.0 with 3 550MHZ CPU's and 4GB of memory running SIEBEL's CRM
plus a couple of other databases; does anyone else have similar
configuration?  If so, what is your buffer cache, and why have you set it
so?
Any help would greatly be  appreciated.
Thanks,
Pranav Shukle
Database Administrator
EPCOR Information Services
780-412-3052

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

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

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

RE: 2nd DBA or ?

2001-09-21 Thread Thater, William


At 03:17 PM 9/21/2001, you wrote:
but of course I do! doesn't every goddess?  :)

click, click click, click click, click click, click;-)



--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Quotes 4 (c) Edwin Jongsma 1998 http://www.xs4all.nl/~ed [EMAIL PROTECTED]



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

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

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

Re: I need help understanding how Oracle uses the OS buffer cache...

2001-09-21 Thread Mohammad Rafiq


We are having 134MB for buffer cache with same platform and version. You can 
go upto 256MB,if you want. There are other list members like Kirti who can 
give better explanation of this.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 21 Sep 2001 11:30:27 -0800

Hi Everyone,
We have been experiencing some I/O issues; and the systems support team (HP)
thinks that we should bump up our OS buffer cache.  Currently we are sitting
at 150MB; after researching on Metalink the recommendation from Oracle for
HPUX is to have a max of 128MB of buffer cache.  I have been trying to find
a document to help me understand how Oracle uses this buffer cache, and even
have opened up a TAR with Oracle; but does anyone know of a document or a
book which would help me understand this?
Metalink docs say that the buffer cache should be set to =128MB to avoid
losing writes; I cannot make sense of this statement.  Could someone help
me with this?
We have HPUX 11.0 with 3 550MHZ CPU's and 4GB of memory running SIEBEL's CRM
plus a couple of other databases; does anyone else have similar
configuration?  If so, what is your buffer cache, and why have you set it
so?
Any help would greatly be  appreciated.
Thanks,
Pranav Shukle
Database Administrator
EPCOR Information Services
780-412-3052

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

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

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


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

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

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

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

RE: Installing 8.1.7

2001-09-21 Thread DENNIS WILLIAMS


Ron - Sorry I wasn't clear. There are two alternatives for LMTs, automatic
and uniform. You are entirely correct that there are many possibilities.
Then I discovered the paper: How to Stop Defragmenting and Start Living:
The Definitive Word on Fragmentation
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049

This certainly sounded GREAT to me (I found it through the Gennick paper you
reference). That mentions that Oracle has slightly different recommendations
for Oracle8i. I found an Oracle paper Fragmentation and Data
Reorganization
http://otn.oracle.com/deploy/availability/htdocs/fragment.html, which
contains the following statements:
Oracle has a number of recommendations:
First, set all the extents in a tablespace to the same size (to me
that says Uniform).
Second, . . . Choose tablespaces for segments based on three
recommended extent sizes, 128k, 4MB, or 128MB.

I believe that both papers are based on the same philosophy. At this point I
am basing my physical layouts based on these two papers, believing that this
represents the direction that Oracle is going. If you or anyone else has
more information to contribute, I am eager to listen.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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


Dennis,
 I know that Oracle lists 3 sizes for the LMTbut you can specify any size
extent if you do not use the auto feature. I have created a lot of
different LMT extent sizes for tables that are like in size and activity.
That way I have a better handle on the resources especually when the disks
are a premium. Why put an active table initial 50 K next 50 K in a 128K
tablespace. Why not manage the tablespace and make the extents 100 K?
 
From the ORAMAG article:The Autuallocate option allows
Oracle to take control of the extent allocation. Oracle will use extent
sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The
table created in the tablespace will adapt the auto extent policy of the
tablespace and use increasingly larger extents as the table grows in size.
 Locally Managed Tablespaces
by Jonathan Gennick. located at
http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html
  
  
Just a thought.
ROR mª¿ªm

 [EMAIL PROTECTED] 09/21/01 12:00PM 
Ramon -  
 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See
white papers at technet.oracle.com for further details on the new
philosophy.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Hi folks,
 

Actually I have 8.0.5 and  will install 8.1.7 in the weekend, and would like
to have somethings clear.
 
Actually I have just 2 tablespaces, but planning to make one for each
application system,
will be like 7.
 
Of course will make all kind of backups, cold, hot including redo logs,
password files, parameter files and archives.
 
What I am planning to do is make an export of the user owner of the all
objects and
make and import in the new DB.  
 

 1) How to find the ideal size of the extent for a locally managed 
 tablespace uniform size ?
 
 2) As far as I know, not much, the import will create the same tablespaces
where the
 objects exists in the old DB in the new DB.  Now, if I use an alter
table move   
 tablespace to move the tables to the new LMT tablespace, will it use
the extent 
 size of the new TBS or will remain with the old one ? 
 
 3) I'm considering to recreate all the indexes.
 
 4) Is it a good idea to have an TBS for each APP system ?
 
 5) What are the consequences of having all of them with different extent
size ?
 
 6) If by any chance some of them are going to have the same extent size 
wouldn't be better to put them in one TBS ?
 
 6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size
?
 
 7) Planning make db_block_size 8k
 

 8) My second step will be implement Forms Server, anything to include in
the 
 installation of have in mind from now ?
 
My DB is transactional, not that heavily, like 40 users, but like 12 of them
are remote.
 
Hardware
Compaq 
2 Pentium III processor 800 mhz
6 Hard Drive 9.1 GB - raid 5
1 GB Memory
Win 2000 server
 
 
Thanks in advance and sure that your help will be very, very useful.
 
 
 
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Dominican Republic
809-565-3121
 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to:

RE: Design Issue - Quick response appreciated


Jay,

Good thought.  Questions:

1. How many prior_ID's do I need to maintain?  Logically, user could change
any of the columns in a primary key.

2. Say, a transaction udergoes 2 times changes i.e., first time, account_ID
is changed.  Second time, Security_id is changed. This means, I inserted two
records into the transaction table pertaining to original transaction.  How
do I retrieve earlier three records? i.e., the latest change in the
account_id=IBM.  If the user is querying based on this, he would get two
records.  But he would not get the record where he changed security_ID. (My
primary key = Security ID + Account ID + Account
Type + Trade Date).

3. How do manage and retrieve the records from the child tables?

Thanks,

Rao


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


One thought is to have an additional column called something like
'PRIOR_ID'.  If the Account_id is changed (actually a new value inserted)
then the PRIOR_ID for the new row is set to the ACCOUNT_ID of the old row.
That way you can always trace back if the transaction used to have a
different account.
 
 
Jay Miller

-Original Message-
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L


List,
 
OLTP application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.
 
The transaction table layout.
 
Security ID  
Account ID
Account Type
Trade Date
And other columns in this table.
 
In the above table, the primary key is -- Security ID + Account ID + Account
Type + Trade Date
 
There are many to one relationships built to other child tables from
Transaction Table
 
Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 
 
I tried with the idea of sequence number generation but it was failing.
 
Any ideas or suggestions are much appreciated.
 
Thanks,
 
Rao
Maheswara Rao,
Oracle DBA
SunGard Securities


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

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

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

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

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

Rachel - RE: 2nd DBA or ?

2001-09-21 Thread satar naghshineh



--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 way too cynical.

Thanks! It's this personality (or lack of) that has
made me very sucessful at my age. I was driving a 45k
dollar car (which you rode in) and owned my first
house at age 23. Now at 26, I also own a new Benz
(valued at 75k) and own a second home. I hate to sound
egotistical (isn't that one of the traits of a good
DBA?), but I just want you to know where I am coming
from.

 One of the few things I learned in the management
 class I took was you have to train the people
 below you to do your job if you ever want a
 promotion

Who wants to work in Management? At my full-time job,
I make close to what my boss makes (he is the CIO) but
without all the responsibility and dealing with
personal problems. To me, if you know the basics of
Business Management and Child Psychology, you'll do
well in Management.
 
 If no one else can do what you do, then you can't
 move on to other things.

Maybe because I'm still young, but I always believe
that your future is in your own hands, not at your
company's discretion. If I don't get what I want, then
I move on to another company. It might change when I
get married and have kids, in which I have to worry if
my child eats Frosted Flakes cereal in the morning or
if he/she goes to school hungry. Until then, I am
free.
 
 On the other hand, Satar is a consultant.

I also have a full time job, but hopefully I can quit
my job soon if this project I'm currently working on
is sucessful. I have goals, and I am close to
self-actualizing them. 

 And looking at the world from that direction, you
 wouldn't want anyone else around to do what you do
 because you'd lose the contract if there were a
 full-timer around (you can have a fulltimer put in
 extra hours without having to pay more)

Nice philosophy. In a dog-eat-dog world, it's good not
to be a dog! Also, if you live in California, chances
are you are getting paid by the hour, along with
overtime. California residents, you might want to look
into California Assembly Bill 60 (AB 60) on the
internet.
 
 But as a full-time employee, I want someone else
 around. Because there is ALWAYS too much work for
 one person, at least in my shop.

The MIS managers or system admins can experience
Oracle Support if they can't get a hold of me.
Unfortunately, they put a lo-jack system (cell phone)
on me, so I am available to them 24/7. To date, after
1 and half years working for this company, none of my
databases have experienced any problems. I like to
think it's due to my expertise, or maybe I'm wrong,
and it's just luck.

Also, I hope this doesn't come across mean or
unappreciative, but if you remove yourself from the
list, you will give yourself so much more time to
tackle the work at your shop. As you might have
noticed, I removed myself from the list for 7-8 months
while my company gave me the responsibility of UK's
databases. I needed that time to go to the UK,
configure and tune the datbases, setup an automated
backup and recovery procedure, post application tuning
and provide remote support, along with other things. 

I do have to agree with Christopher Spence, if this is
a in-house Development, or continued developed oracle
application environment, then of course you will need
additional people to help you out.

I initially replied to this post, because I was given
the same opportunity to bring in another DBA for the
UK. I chose to do the job myself, eliminating a
part-time DBA that was positioned in the UK and also
removing the need for Oracle Support in the UK (which
is extremely expensive compared to the US). 

I made my suggestion based on my previous experiences
as a consultant working for corporate America. You may
call it cynical and paranoid, which is ok because
everyone is entitled to their own views, but this is
my reality.
 
 Rachel

Regards,
Satar

PS I'm glad to see you are OK from last week's
attacks. I was praying for everyone in NY and
Washington, especially for you. I hope you and your
family are doing well. 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Recovery from Cold backup.

2001-09-21 Thread Smith, Ron L.


I know, but the point is Oracle doesn't know anything about the archive
logs, it just takes whatever you feed it until you cancel.
Correct?
 
Ron

-Original Message-
Sent: Friday, September 21, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L



As long as you have all archived log files in log archive destination
directory, which is defined in init.ora, you don't have to do anything but
type 'auto' while doing recovery. Oracle will automatically apply all
necessary archive log files and then you need to open database. 


  Smith, Ron L. [EMAIL PROTECTED] wrote: 


I have a what if question.
Say you had a complete cold backup, including control files from a few days
ago.
You also had all the archive logs for the past few days.
Today you lost your server and had to recover.
You lay down all the database files, including the control files.
Now you want to apply your archive logs.
Oracle can't know about the archive logs because all the files you restored
are old.
Do you just tell Oracle where the archive logs are and it keeps aplying them
until 
you say you are finished?

Just wondering.

Ron

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

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




  _  

Terrorist Attacks on U.S. - How can you help? 
Donate cash, emergency relief information in Yahoo!
http://rd.yahoo.com/mail_us/tag/?http://dailynews.yahoo.com/fc/US/Emergency
_Information/ News.

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

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

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

RE: How to find the current instance name?

2001-09-21 Thread Glenn Travis


Here's a great little script.  Edit as necessary.

--Begin
column today noprint new_value xdate
column name noprint new_value dbname
column created noprint new_value dbcreated
column host_name noprint new_value hostname
column instance_name noprint new_value instname
column start_time noprint new_value starttime
column status noprint new_value dbstatus

set echo off
set feedback off
set termout off

select substr(to_char(sysdate,'fmMonth DD,  HH:MI:SS P.M.'),1,35) today from dual;
select name,to_char(created,'fmMonth DD,  HH:MI:SS P.M.') created from v$database;

select host_name, instance_name,
to_char(startup_time,'fmMonth DD,  HH:MI:SS P.M.') start_time, 
status from v$instance;

set pagesize 0
set linesize 80
set echo off
set feedback off
set termout on

prompt Cur Date:  xdate
prompt Database:  dbname
prompt Instance:  instname
prompt Host:  hostname
prompt Created:   dbcreated
prompt Startup:   starttime
prompt Status:dbstatus
prompt
--End

-Original Message-
Sent: Thursday, September 20, 2001 8:20 AM
To: Multiple recipients of list ORACLE-L


You probably want to do the following.  v$database.name is the database name
not the instance name. Although
most name the same but not required.

SELECT instance FROM v$thread;

Rick

-Original Message-
Sent: Thursday, September 20, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


List,

How to find the current instance name for the session?.

From svrmgrl, i can using SELECT name FROM v$database.

What is the equivalant from the ordinary user?

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

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

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

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

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

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

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

RE: SQLLOADER question.

2001-09-21 Thread Ken Janusz


Get yourself a copy of Oracle SQL*Loader by Gennick  Mishra, O'Reilly
Books.  

I reviewed the discussion of it in Ch 8 of the book. 
It looks like you need to script a Function and then reference the Function
name in the Control File.

Hope this helps.

It's not to simple so you need to get the book.

Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.

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


List,
 Oracle 7.3.4
 Using SqlLoader I load a table with 5 columns of data. I would like to be
able to have column 4 be the value of (col3 * .07). I have RTFM and other
books but it seems that you are not allowed to perform calculations during
the load except the date functions.
Am I correct in my understanding?

Control file info:

Load data
Append
Into table tab1
trailing nullcols
( col1 terminated by , ,
 col2 terminated by , TO_DATE(:col2,'MMDD'),  
 col3 terminated by , ,
 col4 terminated by , ,
 col5 terminated by , )

The source data has values in each location:
123,20010920,20,30,35

Any Ideas?
Thanks,
Ron
ROR mª¿ªm 


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

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

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

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

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

RE: SQLLOADER question.


Ron,

try this:

Load data
infile *
Append
Into table tab1
trailing nullcols
( col1 terminated by , ,
 col2 terminated by ,,
 col3 terminated by , ,
 col4 terminated by , :col3*.07,
 col5 terminated by , )

begindata
123,20010920,20,30,35
123,20010920,20,30,35
123,20010920,20,30,35

I just ran it - works fine!


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 21, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L


List,
 Oracle 7.3.4
 Using SqlLoader I load a table with 5 columns of data. I would like to be
able to have column 4 be the value of (col3 * .07). I have RTFM and other
books but it seems that you are not allowed to perform calculations during
the load except the date functions.
Am I correct in my understanding?

Control file info:

Load data
Append
Into table tab1
trailing nullcols
( col1 terminated by , ,
 col2 terminated by , TO_DATE(:col2,'MMDD'),  
 col3 terminated by , ,
 col4 terminated by , ,
 col5 terminated by , )

The source data has values in each location:
123,20010920,20,30,35

Any Ideas?
Thanks,
Ron
ROR mª¿ªm 


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

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

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

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

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

Re: Optimal Disk Layout??

2001-09-21 Thread satar naghshineh


Hi Walter,

It looks like you're having a bottleneck on your
controller during a hot backup. This is a result of
(1) reading the data then (2) writing the data and
compressing the data within the same controller.

To answer your questions:
1. During RAID 5, all your disks are being written to
and parity rotates on each disks. You can do a search
on RAID levels on the web. One thing to note is that a
RAID 5 needs at least 4 physical drives to work
efficiently.

2. Since you are running a single A1000 with 8 slots,
I would avoid the RAID 0+1 idea. Keep the RAID 5 setup
unless you go with 10 drives, then go for RAID 1+0.
Alocate a couple of drives for redo logs (on seperate
internal disk bus within the A1000) and multiplex the
redo logs on the two drives. Keep a drive for the
archived redo logs, you can even use a bigger hard
drive that has the same form factor as the 9GB hard
drive. Try to squeeze a Hot Spare in as well. seperate
the RAID 5 drives between the two internal disk bus of
the A1000 as well. Look into backing up your database
to a TAPE device instead of hard drives. With a 8GB
database, you can restore your database in 10 minutes
with a DLT 8000, just make sure the backup software
binaries and database resides on a sperate system on
your network.

Your best bet, if you can afford it, is to return the
A1000 and get a A3500, which comes with 2 D1000's. Buy
the additional controller for redundancy and do a RAID
50 or 10. This is the best bet because of the
redundancy on the conntroller, disks and internal bus
of the system. Also implement the TAPE backup system.

I believe the A1000 is a 10 slot (for 9GB drives and
some 18GB drives). If it is only a 8 slot storage,
make adjustments accordingly, keeping the internal
disk bus in mind. Lay out your disk:

Slot 1 - RAID 5 DRIVE
Slot 2 - RAID 5 DRIVE
Slot 3 - Archived redo logs
Slot 4 - Redo Logs (Members A)
Slot 5 - EMPTY
Slot 6 - RAID 5 DRIVE
Slot 7 - RAID 5 DRIVE
Slot 8 - Redo Logs (Members B)
Slot 9 - HOT SPARE
Slot 10-  EMPTY

If it is a 10 slot and you decide to go with 10 hard
drives, implement RAID 1+0 to increase write
performance. Use the Hot SPARE disk as an extra disk
to throw junk into. 

Hope this helps. Let me know if I confused you more or
if you need additional info.

Regards,
Satar

--- Walter K [EMAIL PROTECTED] wrote:
 Hi,
 
 I'm encuntering a relatively high iowait percentage
 when my hot backups are running. The platform is Sun
 (E420 2cpu running SunOS 5.7) with an A1000 disk
 array
 (8 9Gb drives, hardware Raid-5). The array is one
 volume and all DB components (redo, archive, data,
 index, system, etc.) are on the same volume except
 for
 the binaries. The database is not large, only ~8Gb
 in
 size and the transactional volume is not much
 either.
 However, when the backups run, the iowait according
 to
 'top' hovers between 50-70% which causes our
 application to time-out via Web Logic 6.0.
 
 The developers can't explain why the timeouts are
 occurring (WLS 6.0 is a new upgrade from 5.1). The
 SysAdmin isn't much help either.
 
 I have an opportunity to rebuild the database on
 another machine and use RAID 1+0 -- the thought
 being
 that we are choking ourselves with Raid-5 when the
 hot
 backups are performing the cp's (copies) and then
 the
 files are compressed. 
 
 My first question is, how is the data distributed
 across the drives in my Raid-5 configuration? Is
 each
 disk being filled contiguously in series or is the
 data being spread around in a pseudo-striping
 manner?
 
 My second question/dilema is, the new array (another
 A1000) will have 6 18Gb drives and with Raid 1+0
 that
 shrinks to 3 drives of usable space for everything
 except redo and archive. 4 9Gb drives will be added
 in
 two mirrored sets, one for redo and the other for
 archive. I'm afraid that I will see worse I/O
 performance with the new array because it has so
 fewer
 physical drives, thus eliminating the benefit of not
 having to write the parity info. 
 
 Do you concur? Knowing the two arrays I have to work
 with, which would be the better configuration? 
 
 Any suggestions, recommendations would VERY much be
 appreciated.
 
 Thanks again for the feedback.
 -w
 


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger. 
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

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

File/RAID layout for Oracle database???

2001-09-21 Thread Grabowy, Chris


Any thoughts?  Opinions?  Concerns?

Dell Xeon Dual servers using Win2000 for OPS.

Disk layout...

  - Channel 0 
- A1 = RAID 5 (3 disks, one spare)
  - OS/pagefile/Oracle software.
  
  - Channel 1 
- A2 = RAID 5 (4 disks, one spare)
  - Archive logs, exports
- A5 = RAID 0 (1 disk)
  - Redo logs A

  - Channel 2
- A3 = RAID 5 (4 disks, one spare)
  - Data, System tablespace
- A6 = RAID 0 (1 disk)
  - Redo logs B

  - Channel 3
- A4 = RAID 5 (4 disks, one spare)
  - Index, rollback, temp, exports
- A7 = RAID 0 (1 disk)
  - Redo logs C


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

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

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

RE: Design Issue - Quick response appreciated


Christopher,

Thanks for the reply.

Surrogate key solves the problem of having a record with a unique identifier
for a record.  But I still have the following problems.

1. How do I link the previous records whenever a query is issued by the
user?
2. Please see my requirement below:

Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 

How do I do this?

Thanks,

Rao

 -Original Message-
Sent: Friday, September 21, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L


Then use a surrogate key, i.e. sequence number.
 
Numbers that change are not candidates for key, doing so introduces problems
in which you are having as well as others.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 
Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  
-Original Message-
Sent: Friday, September 21, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
 
In our case, we do not have any other columns --- 1. which could identify
uniquely a record and yet do not undergo a change.
 
Thanks,
 
Rao
-Original Message-
Sent: Friday, September 21, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
Generally it is bad practice to use columns in the primary key, which
change.  They introduce many different problems.
 
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 
Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  
-Original Message-
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
 
List,
 
OLTP application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.
 
The transaction table layout.
 
Security ID  
Account ID
Account Type
Trade Date
And other columns in this table.
 
In the above table, the primary key is -- Security ID + Account ID + Account
Type + Trade Date
 
There are many to one relationships built to other child tables from
Transaction Table
 
Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 
 
I tried with the idea of sequence number generation but it was failing.
 
Any ideas or suggestions are much appreciated.
 
Thanks,
 
Rao
Maheswara Rao,
Oracle DBA
SunGard Securities
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

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

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

RE: Undo x Rollback Segments in 9i

2001-09-21 Thread Cherie_Machler



Christopher,

Can you switch modes once the database has been in use for a while?
Or do you need to recreate the database in order to do that?

Thanks,

Cherie


   
   
Christopher
   
Spence   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
cspence@FuelS   cc:   
   
pot.com Subject: RE: Undo x Rollback Segments in 
9i  
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
09/21/01 02:30 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old
method
of doing redo.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT RBS01  TABLESPACE RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito!
http://explorer.msn.com.br

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

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

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

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

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




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

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

RE: 2nd DBA or ?


Rachel,

sounds like you have a stalker...

-Original Message-
Sent: Friday, September 21, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L


At 03:17 PM 9/21/2001, you wrote:
but of course I do! doesn't every goddess?  :)

click, click click, click click, click click, click;-)



--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Quotes 4 (c) Edwin Jongsma 1998 http://www.xs4all.nl/~ed [EMAIL PROTECTED]



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

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

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

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

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

Re: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread jacinth


How are your permissions?

Hmmm.  Had not considered this as it was a default install in the node
I did.  Oracle had been installed on Node 1 by some contractor who came
in... seemed plain vanilla, but I see these differences.

Node 1:
-rwxrwxr-x   1 oracle   dba  8649602 Apr 04 2000  lsnrctl

Node 2:
-rwxr-x--x   1 oracle   dba  4524044 May 17 11:08 lsnrctl

On Node 1, oracle has uid of 11.  On Node 2, oracle is uid 12.  Both are
part of dba group, and I would think that they both could run this from
these permissions?

Wow!  I just realized those files are different sizes...  Obviously not
the same file. :(  These should be the same.

When I do a what on each, I get:

Node 1 lsnrctl:
lsnrctl:
62  1.5  src/bos/usr/ccs/lib/libld/allocldptr.c, libld, bos430, 9737A_430 
5/6/97 09:48:09
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
78  1.11  src/bos/usr/ccs/lib/libld/ldopen.c, libld, bos43K, 9831A_43K 7/30/98 
09:38:41
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
53  1.2  src/bos/usr/ccs/lib/libld/readhdr.c, libld, bos43K, 9831A_43K 7/30/98 
09:55:00
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
63  1.5  src/bos/usr/ccs/lib/libld/freeldptr.c, libld, bos430, 9737A_430 
5/6/97 09:48:21
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
87  1.5  src/bos/usr/ccs/lib/libld/vldldptr.c, libld, bos430, 9737A_430 5/6/97 
09:54:06
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
84  1.6  src/bos/usr/ccs/lib/libld/ldtbseek.c, libld, bos430, 9737A_430 5/6/97 
09:53:24
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
83  1.7  src/bos/usr/ccs/lib/libld/ldtbread.c, libld, bos43K, 9831A_43K 
7/28/98 18:20:29
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
70  1.9  src/bos/usr/ccs/lib/libld/ldgetname.c, libld, bos43K, 9831A_43K 
7/30/98 16:57:29
68  1.6  src/bos/usr/ccs/lib/libld/lddef.h, libld, bos43K, 9831A_43K 7/28/98 
18:18:24
23  1.3  src/bos/usr/ccs/lib/libpthreads/init.c, libpth, bos430, 9737A_430 
7/17/97 10:33:02
61  1.13  src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos43N 
3/25/99 13:50:27
38  1.18  src/bos/usr/ccs/lib/libm/POWER/log10.c, libm, bos430, 9737A_430 
7/16/97 07:22:57
19  1.25  src/bos/usr/ccs/lib/libm/POWER/log.c, libm, bos430, 9737A_430 
7/16/97 07:22:51
00  1.3  src/bos/usr/ccs/lib/libm/__set_errno128.c, libm, bos430, 
9737A_430 7/17/96 17:46:14
51  1.3  src/bos/usr/ccs/lib/libm/POWER/sqrt_raise_xcp.c, libm, bos430, 
9737A_430 3/10/97 22:40:58


For Node 2 lsnrctl:
lsnrctl:
23  1.3  src/bos/usr/ccs/lib/libpthreads/init.c, libpth, bos430, 9737A_430 
7/17/97 10:33:02
61  1.13  src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos43N 
3/25/99 13:50:27
38  1.18  src/bos/usr/ccs/lib/libm/POWER/log10.c, libm, bos430, 9737A_430 
7/16/97 07:22:57


This may explain the error... so how do I fix this?  What did I do in
installation that might have affected this?  Maybe this is starting to
make sense...

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

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

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

RE: Design Issue - Quick response appreciated


Sounds like the case of super trigger

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 4:58 PM
To: Multiple recipients of list ORACLE-L

Christopher,

Thanks for the reply.

Surrogate key solves the problem of having a record with a unique identifier
for a record.  But I still have the following problems.

1. How do I link the previous records whenever a query is issued by the
user?
2. Please see my requirement below:

Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 

How do I do this?

Thanks,

Rao

 -Original Message-
Sent: Friday, September 21, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L


Then use a surrogate key, i.e. sequence number.
 
Numbers that change are not candidates for key, doing so introduces problems
in which you are having as well as others.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 
Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  
-Original Message-
Sent: Friday, September 21, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
 
In our case, we do not have any other columns --- 1. which could identify
uniquely a record and yet do not undergo a change.
 
Thanks,
 
Rao
-Original Message-
Sent: Friday, September 21, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
Generally it is bad practice to use columns in the primary key, which
change.  They introduce many different problems.
 
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 
Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  
-Original Message-
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
 
List,
 
OLTP application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.
 
The transaction table layout.
 
Security ID  
Account ID
Account Type
Trade Date
And other columns in this table.
 
In the above table, the primary key is -- Security ID + Account ID + Account
Type + Trade Date
 
There are many to one relationships built to other child tables from
Transaction Table
 
Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 
 
I tried with the idea of sequence number generation but it was failing.
 
Any ideas or suggestions are much appreciated.
 
Thanks,
 
Rao
Maheswara Rao,
Oracle DBA
SunGard Securities
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

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

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

RE: Undo x Rollback Segments in 9i


I don't have a lot of extensive experience with 9i, but from what I red, you
can change it on the fly.  Don't quote me on it.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


Christopher,

Can you switch modes once the database has been in use for a while?
Or do you need to recreate the database in order to do that?

Thanks,

Cherie


 

Christopher

Spence   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]  
cspence@FuelS   cc:

pot.com Subject: RE: Undo x Rollback
Segments in 9i  
Sent by:

[EMAIL PROTECTED]

om

 

 

09/21/01 02:30

PM

Please respond

to ORACLE-L

 

 





There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old
method
of doing redo.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT RBS01  TABLESPACE RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito!
http://explorer.msn.com.br

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

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

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

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

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




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

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

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

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

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

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Bellefeuille, Wayne S


Thanks, but if there wasn't enough space, then when I restarted it
should have failed again, right?  I expect what is happening is that by
the time I get logged into the system and restart the rebuild index
process, SMON finally got around to cleaning up the temp segments.  That
is why the index successfully rebuilds on the restart, but then an index
later in the process fails.
Wayne

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


please check whether your index tablespace has enough space for index
rebuild.  When oracle rebuilds index, it requires space to store both
old
index and new index during the process.

Lucy



On Fri, 21 Sep 2001, Bellefeuille, Wayne S wrote:

 The problem is not the TEMP tablespace.  Rather, the index rebuild is
 failing on finding temp segment space in the index's tablespace.
This
 is because SMON doesn't seem to be cleaning the temp segments after
the
 prior index's rebuild is done, and eventually, the rebuild of the
 indexes fails.  However, when I restart the process in a few minutes,
 the index that failed before works now, but a different index (or
 partition) fails.  This seems to point to SMON not working fast enough
 to clean out the temp segments before the next index's rebuild starts.
 
 The wake smon script worked great in 8.0 to fix this problem, but
 doesn't seem to work (or at least work fast enough) in 8i.  
 
 Is there anything that can be done?
 
 Wayne
 
 -Original Message-
 Sent: Friday, September 21, 2001 8:00 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Have you tried setting the TEMP tablespaces PCTINCREASE value to 1 and
 then
 to 0 again?
 
 Mark
 
 -Original Message-
 Bellefeuille, Wayne S
 Sent: Friday, September 21, 2001 13:15
 To: Multiple recipients of list ORACLE-L
 
 
 This is the one I am running.  It just doesn't seem to be doing the
 trick in 8i, where it worked fine for 8.0.  Is that possible?  Or do I
 need to look elsewhere for my temp segment problem?
 
 Wayne
 
 -Original Message-
 Sent: Thursday, September 20, 2001 3:05 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Steve Adams has a script, but I don't know if it works 8i
 
 http://www.ixora.com.au/scripts/sql/post_smon.sql
 
 
 -Original Message-
 Sent: Thursday, September 20, 2001 1:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Back in 8.0 days, we were running into space problems for temp
segments
 while rebuilding indexes on our large partitioned tables.  Someone on
 this list suggested that we use the wake SMON approach, which
 essentially running the following command from svrmgrl:  noradebug
 wakeup smon_pid.
 
 This worked great.  However, now that we have moved to 8i, we have
 started getting the temp segments space problem again.  That is, this
 command doesn't seem to be doing its job anymore.
 
 Any ideas?
 
 Wayne Bellefeuille
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bellefeuille, Wayne S
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Norwood Bradly A
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bellefeuille, Wayne S
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 

-- 
Lucy Lin Oracle DBA

condenet.com 212-286-3852

--

RE: Rachel - RE: 2nd DBA or ?

2001-09-21 Thread Gogala, Mladen

Where exactly are you coming from? Beware because me, my Ford F350 and my 
faithful pump-action shotgun always have the right of way, $75k car or
not

 -Original Message-
 From: satar naghshineh [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 21, 2001 3:40 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Rachel - RE: 2nd DBA or ?

 --- Rachel Carmichael [EMAIL PROTECTED] wrote:
  way too cynical.

 Thanks! It's this personality (or lack of) that has
 made me very sucessful at my age. I was driving a 45k
 dollar car (which you rode in) and owned my first
 house at age 23. Now at 26, I also own a new Benz
 (valued at 75k) and own a second home. I hate to sound
 egotistical (isn't that one of the traits of a good
 DBA?), but I just want you to know where I am coming
 from.

  One of the few things I learned in the management
  class I took was you have to train the people
  below you to do your job if you ever want a
  promotion

 Who wants to work in Management? At my full-time job,
 I make close to what my boss makes (he is the CIO) but
 without all the responsibility and dealing with
 personal problems. To me, if you know the basics of
 Business Management and Child Psychology, you'll do
 well in Management.

  If no one else can do what you do, then you can't
  move on to other things.

 Maybe because I'm still young, but I always believe
 that your future is in your own hands, not at your
 company's discretion. If I don't get what I want, then
 I move on to another company. It might change when I
 get married and have kids, in which I have to worry if
 my child eats Frosted Flakes cereal in the morning or
 if he/she goes to school hungry. Until then, I am
 free.

  On the other hand, Satar is a consultant.

 I also have a full time job, but hopefully I can quit
 my job soon if this project I'm currently working on
 is sucessful. I have goals, and I am close to
 self-actualizing them. 

  And looking at the world from that direction, you
  wouldn't want anyone else around to do what you do
  because you'd lose the contract if there were a
  full-timer around (you can have a fulltimer put in
  extra hours without having to pay more)

 Nice philosophy. In a dog-eat-dog world, it's good not
 to be a dog! Also, if you live in California, chances
 are you are getting paid by the hour, along with
 overtime. California residents, you might want to look
 into California Assembly Bill 60 (AB 60) on the
 internet.

  But as a full-time employee, I want someone else
  around. Because there is ALWAYS too much work for
  one person, at least in my shop.

 The MIS managers or system admins can experience
 Oracle Support if they can't get a hold of me.
 Unfortunately, they put a lo-jack system (cell phone)
 on me, so I am available to them 24/7. To date, after
 1 and half years working for this company, none of my
 databases have experienced any problems. I like to
 think it's due to my expertise, or maybe I'm wrong,
 and it's just luck.

 Also, I hope this doesn't come across mean or
 unappreciative, but if you remove yourself from the
 list, you will give yourself so much more time to
 tackle the work at your shop. As you might have
 noticed, I removed myself from the list for 7-8 months
 while my company gave me the responsibility of UK's
 databases. I needed that time to go to the UK,
 configure and tune the datbases, setup an automated
 backup and recovery procedure, post application tuning
 and provide remote support, along with other things. 

 I do have to agree with Christopher Spence, if this is
 a in-house Development, or continued developed oracle
 application environment, then of course you will need
 additional people to help you out.

 I initially replied to this post, because I was given
 the same opportunity to bring in another DBA for the
 UK. I chose to do the job myself, eliminating a
 part-time DBA that was positioned in the UK and also
 removing the need for Oracle Support in the UK (which
 is extremely expensive compared to the US). 

 I made my suggestion based on my previous experiences
 as a consultant working for corporate America. You may
 call it cynical and paranoid, which is ok because
 everyone is entitled to their own views, but this is
 my reality.

  Rachel

 Regards,
 Satar

 PS I'm glad to see you are OK from last week's
 attacks. I was praying for everyone in NY and
 Washington, especially for you. I hope you and your
 family are doing well. 

 __
 Terrorist Attacks on U.S. - How can you help?
 Donate cash, emergency relief information
 http://dailynews.yahoo.com/fc/US/Emergency_Information/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: satar naghshineh
   INET: [EMAIL PROTECTED]

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

RE: Rachel - RE: 2nd DBA or ?


Geesh, and I got bashed (and still do) for being sarcastically egotistic.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 way too cynical.

Thanks! It's this personality (or lack of) that has
made me very sucessful at my age. I was driving a 45k
dollar car (which you rode in) and owned my first
house at age 23. Now at 26, I also own a new Benz
(valued at 75k) and own a second home. I hate to sound
egotistical (isn't that one of the traits of a good
DBA?), but I just want you to know where I am coming
from.

 One of the few things I learned in the management
 class I took was you have to train the people
 below you to do your job if you ever want a
 promotion

Who wants to work in Management? At my full-time job,
I make close to what my boss makes (he is the CIO) but
without all the responsibility and dealing with
personal problems. To me, if you know the basics of
Business Management and Child Psychology, you'll do
well in Management.
 
 If no one else can do what you do, then you can't
 move on to other things.

Maybe because I'm still young, but I always believe
that your future is in your own hands, not at your
company's discretion. If I don't get what I want, then
I move on to another company. It might change when I
get married and have kids, in which I have to worry if
my child eats Frosted Flakes cereal in the morning or
if he/she goes to school hungry. Until then, I am
free.
 
 On the other hand, Satar is a consultant.

I also have a full time job, but hopefully I can quit
my job soon if this project I'm currently working on
is sucessful. I have goals, and I am close to
self-actualizing them. 

 And looking at the world from that direction, you
 wouldn't want anyone else around to do what you do
 because you'd lose the contract if there were a
 full-timer around (you can have a fulltimer put in
 extra hours without having to pay more)

Nice philosophy. In a dog-eat-dog world, it's good not
to be a dog! Also, if you live in California, chances
are you are getting paid by the hour, along with
overtime. California residents, you might want to look
into California Assembly Bill 60 (AB 60) on the
internet.
 
 But as a full-time employee, I want someone else
 around. Because there is ALWAYS too much work for
 one person, at least in my shop.

The MIS managers or system admins can experience
Oracle Support if they can't get a hold of me.
Unfortunately, they put a lo-jack system (cell phone)
on me, so I am available to them 24/7. To date, after
1 and half years working for this company, none of my
databases have experienced any problems. I like to
think it's due to my expertise, or maybe I'm wrong,
and it's just luck.

Also, I hope this doesn't come across mean or
unappreciative, but if you remove yourself from the
list, you will give yourself so much more time to
tackle the work at your shop. As you might have
noticed, I removed myself from the list for 7-8 months
while my company gave me the responsibility of UK's
databases. I needed that time to go to the UK,
configure and tune the datbases, setup an automated
backup and recovery procedure, post application tuning
and provide remote support, along with other things. 

I do have to agree with Christopher Spence, if this is
a in-house Development, or continued developed oracle
application environment, then of course you will need
additional people to help you out.

I initially replied to this post, because I was given
the same opportunity to bring in another DBA for the
UK. I chose to do the job myself, eliminating a
part-time DBA that was positioned in the UK and also
removing the need for Oracle Support in the UK (which
is extremely expensive compared to the US). 

I made my suggestion based on my previous experiences
as a consultant working for corporate America. You may
call it cynical and paranoid, which is ok because
everyone is entitled to their own views, but this is
my reality.
 
 Rachel

Regards,
Satar

PS I'm glad to see you are OK from last week's
attacks. I was praying for everyone in NY and
Washington, especially for you. I hope you and your
family are doing well. 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

RE: Design Issue - Quick response appreciated


Ouch!
I was assuming (for no good reason) that the field you used in your example
(ACCOUNT_ID) is the only one that would change.

In this case I agree with Christopher.  Go with a generated key as your
primary key (your current primary key columns can be an alternate key), then
you can use that as the only prior_id column.

With regards to the second question you can then go back as far as you like
using the START WITH/CONNECT BY clauses in your SELECT statement.

Jay Miller

-Original Message-
Sent: Friday, September 21, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L


Jay,

Good thought.  Questions:

1. How many prior_ID's do I need to maintain?  Logically, user could change
any of the columns in a primary key.

2. Say, a transaction udergoes 2 times changes i.e., first time, account_ID
is changed.  Second time, Security_id is changed. This means, I inserted two
records into the transaction table pertaining to original transaction.  How
do I retrieve earlier three records? i.e., the latest change in the
account_id=IBM.  If the user is querying based on this, he would get two
records.  But he would not get the record where he changed security_ID. (My
primary key = Security ID + Account ID + Account
Type + Trade Date).

3. How do manage and retrieve the records from the child tables?

Thanks,

Rao


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


One thought is to have an additional column called something like
'PRIOR_ID'.  If the Account_id is changed (actually a new value inserted)
then the PRIOR_ID for the new row is set to the ACCOUNT_ID of the old row.
That way you can always trace back if the transaction used to have a
different account.
 
 
Jay Miller

-Original Message-
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L


List,
 
OLTP application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.
 
The transaction table layout.
 
Security ID  
Account ID
Account Type
Trade Date
And other columns in this table.
 
In the above table, the primary key is -- Security ID + Account ID + Account
Type + Trade Date
 
There are many to one relationships built to other child tables from
Transaction Table
 
Scenario:
 
User inserts a record into transaction table.  In the first record, Account
ID value is HP and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes
the value in the column - Account ID to  IBM.  Now, the original
transaction record is NOT UPDATED.  A record IS INSERTED with the new
values.  Also, he might or might not insert a record into a child table with
this new values of primary key.
 
Now the user would query the transaction table with Account ID = IBM.  But,
the user wants to get all the previous records also; in this case, he want
to see the record with Account ID = HP also. Also, he want to see the
related records from the child tables. 
 
I tried with the idea of sequence number generation but it was failing.
 
Any ideas or suggestions are much appreciated.
 
Thanks,
 
Rao
Maheswara Rao,
Oracle DBA
SunGard Securities


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

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

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

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

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

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

To REMOVE yourself from this

RE: 2nd DBA or ?


Nah, that's just the sound of the paparazzi.  

-Original Message-
Sent: Friday, September 21, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L


Rachel,

sounds like you have a stalker...

-Original Message-
Sent: Friday, September 21, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L


At 03:17 PM 9/21/2001, you wrote:
but of course I do! doesn't every goddess?  :)

click, click click, click click, click click, click;-)



--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Quotes 4 (c) Edwin Jongsma 1998 http://www.xs4all.nl/~ed [EMAIL PROTECTED]



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

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

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

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

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

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

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

RE: Undo x Rollback Segments in 9i

2001-09-21 Thread Godlewski, Melissa


Taken from Oracle 9i Admin book.

You cannot use both methods in the same database instance, although for
migration
purposes it is possible, for example, to create undo tablespaces in a
database that is
using rollback segments, or to drop rollback segments in a database that is
using
undo tablespaces. However, you must shutdown and restart your database in
order
to effect the switch to another method of managing undo.

If you use the rollback segment method of managing undo space, you are said
to be
operating in the manual undo management mode. If you use the undo tablespace
method, you are operating in the automatic undo management mode. You
determine the mode at instance startup using the UNDO_MANAGEMENT
initialization
parameter.

-Original Message-
Sent: Friday, September 21, 2001 5:17 PM
To: Multiple recipients of list ORACLE-L


I don't have a lot of extensive experience with 9i, but from what I red, you
can change it on the fly.  Don't quote me on it.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


Christopher,

Can you switch modes once the database has been in use for a while?
Or do you need to recreate the database in order to do that?

Thanks,

Cherie


 

Christopher

Spence   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]  
cspence@FuelS   cc:

pot.com Subject: RE: Undo x Rollback
Segments in 9i  
Sent by:

[EMAIL PROTECTED]

om

 

 

09/21/01 02:30

PM

Please respond

to ORACLE-L

 

 





There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old
method
of doing redo.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT RBS01  TABLESPACE RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito!
http://explorer.msn.com.br

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

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

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

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

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




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

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

Re: File/RAID layout for Oracle database???

2001-09-21 Thread Paul Drake


Grabowy, Chris, inquired:

Any thoughts?  Opinions?  Concerns?

Dell Xeon Dual servers using Win2000 for OPS.

Disk layout...

  - Channel 0 
- A1 = RAID 5 (3 disks, one spare)   evil. Make this RAID
1, 2 drives.
  - OS/pagefile/Oracle software. better yet, make it
RAID10.
and put your RBS
here
  
  - Channel 1 
- A2 = RAID 5 (4 disks, one spare)see, both archlogs and
exports are occassional
  - Archive logs, exports   
- A5 = RAID 0 (1 disk)
  - Redo logs A

  - Channel 2
- A3 = RAID 5 (4 disks, one spare)
  - Data, System tablespace
- A6 = RAID 0 (1 disk)
  - Redo logs B

  - Channel 3
- A4 = RAID 5 (4 disks, one spare)   and where do you keep
your hot backups?
  - Index, rollback, temp, exports   or are you using RMAN?
- A7 = RAID 0 (1 disk)
  - Redo logs C


TIA!!!


---

Chris,

Do you have this same DB up currently?
I'd run a script to show I/O by tablespace/datafile.
Pay attention as to what the ration of reads:writes are.
RBS should not go on RAID 5 - too much writes.
I'd also look at redo log generation volume per hour.
if Data and Indexes are pretty much static, RAID 5 not so bad.
WHATEVER else you do - DO NOT SET online redo log volumes to write-back
caching.
I have seen first hand 2 Dell boxes with corrupted databases because of
writefile() errors on online redo logs. Let those sync as WRITE THROUGH.

Where do you keep your on-disk hot and/or cold backups?
You're not *just* using exports for recovery, right?
Without a backup set of datafiles, the archived redo logs might not be so
helpful.

back to my upgrade.

Paul




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

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

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

RE: Rachel - RE: 2nd DBA or ?


Well, I guess there are different ways of measuring success.

--Walt (I'm not coming from anywhere) Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Friday, September 21, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L



--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 way too cynical.

Thanks! It's this personality (or lack of) that has
made me very sucessful at my age. I was driving a 45k
dollar car (which you rode in) and owned my first
house at age 23. Now at 26, I also own a new Benz
(valued at 75k) and own a second home. I hate to sound
egotistical (isn't that one of the traits of a good
DBA?), but I just want you to know where I am coming
from.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

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

job opportunity

2001-09-21 Thread Ginger Mejia


Dear Colleagues,

Palladian Consulting is currently recruiting SQL Server Application
Developers to assist with the implementation and development of SQL Server
applications for a New York State agency. Palladian Consulting custom
tailors all employee packages to meet the individual requirements of our
consultants and delivers the best possible results on time and within
budget. Project is located in Albany, N.Y.. For more information please
contact Ginger Mejia or Charlene Saunders at 800-750-1777 or email
[EMAIL PROTECTED]


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

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

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

RE: Oracle Recovery from Cold backup.