RE: Async I/O on Sun Solaris

[Miller, Jay]

cribing).
>
>
// George Schlossnagle
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Griping about auditing (not the Oracle Kind)

[Miller, Jay]

You mean you're not in on the conspiracy?  You will be receiving a visit
very soon...

You know who had to train the non-DBA how to read the alert logs...

In the end it's not so bad, primarily because my immediate manager (started
as a good SQL server DBA and is now slowly going insane since he has to
attend 3 Change Management meetings a day, at 7am, 2pm and 4pm) decided to
use it as a training experience.  The responsibility was given to one of the
SQL Server DBAs as part of my training them in Oracle DBA work.  So I no
longer have the frustration of looking at it as a complete waste of time.
Of course I suppose that once she is fully trained on Oracle and has joined
the conspiracy someone else will have to take over reviewing the alert logs
:).

-Original Message-
Sent: Monday, June 25, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


A non-DBA? Is that because we stick together like the Mafia or
something?!

g


-Original Message-
Sent: Monday, June 25, 2001 3:32 PM
To: Multiple recipients of list ORACLE-L


We've been through an internal audit and I was just wondering if anyone
else
has to deal with the rather ludicrous requirements I now have.  In order
to
add or resize a datafile I now need to fill out a form and get Senior VP
approval and the alert logs must be reviewed every day by a non-DBA in
order
to be certain that I didn't make any database changes without such
approval.
The auditors were horrified to discover that not only did I do such
things
whenever I thought them necessary but that we didn't have a non-DBA
review
everything I did after an Oracle upgrade to ensure I didn't install any
other software.
Fortunately I managed to convince them that yes, I really did need a
Unix
login (they were skeptical).

So, any similar horror stories?

Jay Miller
Sr. Oracle DBA
-- 
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: Guy Hammond
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Griping about auditing (not the Oracle Kind)

[Miller, Jay]

ve come to expect from consultants/contractors.  My change management
> procedure has under it's "Executive Delegation" section, the following
> caveats:
>
> The  Executive can delegate authority to appropriately qualified
people
> (referred  to in this document as the Delegated Authority) to
authorize
> a  change.  The delegation will be documented and will form part of
the
> Managed Product List, and will state as a minimum:
>
> ·specification of the areas covered by the delegation;
> ·the extent of the delegation and any restrictions on the authority;
> ·the period for which the delegation applies;
> ·that the Delegated Authority has had the appropriate education and
> training to carry out the delegated task;
> ·any reporting actions required of the Delegated Authority;
> ·any review period for the delegation.
>
> Documented administrative procedures that have been approved as such
by
> the  Executive can be implemented without individual approvals from
the
> Executive  as  long  as  each  change  is  implemented according to
the
> authorized   procedure.However,   changes   to  the
administrative
> procedures require reauthorization by the Executive.
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
>
> [EMAIL PROTECTED]
> LTo: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> root@fatcity.Subject: Re: Griping about
auditing (not the Oracle Kind)
> com
>
>
> 06/25/2001
> 10:22 AM
> Please
> respond to
> ORACLE-L
>
>
>
> Hi,
>
> Been there recently
>
> We had change management here breathing down our necks at one point. They
> wanted everything documented and approved. I flooded them with change
> request forms (even for changing a users password on the test database)
> and within two days they wanted a meeting about what we ,DBA's, thought
> should be approved and documented.
>
> We now only have to make sure no other stuff is scheduled by the UNIX
boys
> on the same machine if we do something that could conflict with OS stuff.
>
> Jack
>
> PS: The funniest thing is that the reviewers in general have no clue
about
> what's going on.
>
> "Miller, Jay"
>
>  list ORACLE-L <[EMAIL PROTECTED]>
> house.com>   cc: (bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)
> Sent by: Subject: Griping about
> auditing (not the Oracle Kind)
> [EMAIL PROTECTED]
>
> 25-06-2001 16:31
>
> Please respond to
>
> ORACLE-L
>
> We've been through an internal audit and I was just wondering if anyone
> else
> has to deal with the rather ludicrous requirements I now have.  In order
to
> add or resize a datafile I now need to fill out a form and get Senior VP
> approval and the alert logs must be reviewed every day by a non-DBA in
> order
> to be certain that I didn't make any database changes without such
> approval.
> The auditors were horrified to discover that not only did I do such
things
> whenever I thought them necessary but that we didn't have a non-DBA
review
> everything I did after an Oracle upgrade to ensure I didn't install any
> other software.
> Fortunately I managed to convince them that yes, I really did need a Unix
> login (they were skeptical).
>
> So, any similar horror stories?
>
> Jay Miller
> Sr. Oracle DBA
> --
> 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).
>
> =
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking

RE: Griping about auditing (not the Oracle Kind)

[Miller, Jay]

 A DBA on another database had his request to increase the next extent size
> on a table refused on the grounds that "what if this change causes the
> database to go down?".  His explanation that having a table that was over
> 5,000 extents and growing rapidly was far more likely to cause problems
was
> rejected on the grounds of "if it ain't broke don't fix it.  If you say it
> is broke then why is it we aren't having any problems?"
>
> I wasn't looking for confirmation that this is silly (I know it is) so
much
> as just wondering if anyone else has had to deal with this level of
> bureaucracy.  And maybe a little commiseration :)
>
> Thanks for helping me get it off my chest,
> Jay Miller
>
> -Original Message-
> Sent: Monday, June 25, 2001 11:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
> One of the reasons DBA's are paid well is that they have total control
over
> the production data.  No matter what rules the auditors put in place, a
DBA
> could manipulate the data if they wanted to.  The company should trust you
> to do your job and not put up read blocks that prevent you from
maintaining
> the database and making changes in a timely manner.
>
>
>
> -Original Message-
> Sent: Monday, June 25, 2001 9:32 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We've been through an internal audit and I was just wondering if anyone
else
> has to deal with the rather ludicrous requirements I now have.  In order
to
> add or resize a datafile I now need to fill out a form and get Senior VP
> approval and the alert logs must be reviewed every day by a non-DBA in
order
> to be certain that I didn't make any database changes without such
approval.
> The auditors were horrified to discover that not only did I do such things
> whenever I thought them necessary but that we didn't have a non-DBA review
> everything I did after an Oracle upgrade to ensure I didn't install any
> other software.
> Fortunately I managed to convince them that yes, I really did need a Unix
> login (they were skeptical).
>
> So, any similar horror stories?
>
> Jay Miller
> Sr. Oracle DBA
> --
> 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: 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: 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: Don Granaman
  INET: [EMAIL PROTECTED]

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

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

RE: Good Beginner Oracle book recommendations:

[Miller, Jay]

A hearty second to both these books (though the Tuning Book is definitely
something to look at later).
DBA 101 is perfect for where you are now.

I've finally gotten my copy of Tuning 101 and am breaking the spine to have
it open on my desk.  I snatch the opportunity to read pages in between phone
calls and e-mails.  Once things calm down (ha!) I intend to implement a
thorough performance review of all our Oracle databases using that book.
I'm really looking forward to it (in fact, the prospect of being able to do
it is one of the few things keeping me here at the moment).

Jay Miller

-Original Message-
Sent: Friday, June 29, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L


>Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and 
>James Viscusi.
>
>That is what I started with and it was a great source.  Also, you will
>notice that some of these authors participate on this list.

Peter,

May I add 'Oracle Tuning 101 by Gaja Vaidyanatha and Kirti Deshpande' to
your list when you progress upward (you will!) after DBA 101. The authors of
this book are on this list too. In short, it will set you along the correct
path right in the beginning as far as understanding and resolving
performance issues as it deals very well with myths and incorrect
information 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Griping about auditing (not the Oracle Kind)

[Miller, Jay]

As you might have gathered from my previous e-mail I'm not a big fan of
functional division as opposed to project division.
Since I was moved to a different building from the developers much of the
time I don't spend dealing with the new paperwork and bureaucracy I spend on
the phone.  I can see the temptation that people have to just say, 'don't
think about working *with* the developers, just put their stuff into
production and send it back if it doesn't compile' (this is my current job
description), but I'm still holding onto doing some review, helping them
with SQL, recommending hints, etc.  Don't know how much longer I'll be able
to keep doing it (though the appreciation and thanks from the developers
helps a lot).

My impression (this is confirmed by a friend who was a product manager at
his company and is now leading a consulting team) is that this is the latest
management fad.  According to my friend this goes in waves, with everyone
moving to functional division, then project division, then back again.  He's
been through a few shifts back and forth in his time.  This is my first one.


Jay Miller

-Original Message-
Sent: Thursday, June 28, 2001 7:52 PM
To: Multiple recipients of list ORACLE-L


On June 28, 2001 11:51 am, Miller, Jay wrote:
> Yep, I've dealt with incredibly incompetent consultants (Because of
> our new division of responsibilties, all programming must come from
> the development team.  I

This brings up an interesting point - I've noticed that recently 
division of responsibilities is increasing and becoming more 
polarized. For example, in past incarnations, I was the dba, unix 
sysadmin, configuration manager, and responsible for software 
licenses for all software in the plant (in addition to whatever else 
the boss needed at that exact moment in time... :). Lately, however, 
I have started working on another project (in addition to my usual 
stuff) that has the sysadmin, development, "System" dba, and 
"Application" dba responsibilities spread across different group. 
Sysdba is handled by an Infernal Beuracratic Monster, sysadmin by 
somewhat Ejectable Data Sources, and Application dba stuff handled by 
we keaners. Very strange to have development arrive, review it for 
application impact, then send off any physical database change 
requests to another group.

I don't seem any valid reason to stratify the various 
responsibilities in this manner as it only seems to add several more 
layers of beauracracy without adding any addition value.

So,
a) am I alone, or have others seen this sort of stratification, and 
b) is my griping simply the loss of turf and the slowly broiling coup 
to get it back, or is it somewhat valid?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gaping holes found in Oracle 8i (patch 1654631 info)

[Miller, Jay]

resses from Yahoo! Mail
> http://personal.mail.yahoo.com/


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Client Connection-SQLNET ?/? ODBC.

[Miller, Jay]

Hello James,

Every ODBC connection I've seen or used has connected through SQL Net
(i.e,., app->odbc->sqlnet->database).  But ODBC isn't really my area of
expertise...

Jay Miller

-Original Message-
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

A danger in cloning databases

[Miller, Jay]

Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

[Miller, Jay]

That's what we do too.
This is the command to do it:

ln -sn $ORACLE_HOME/bin/sqlldr $ORACLE_HOME/bin/sqlload

-Original Message-
Sent: Monday, July 09, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


Ken,
   Earlier versions had sqlldr and sqlload as copies of the same code.  I
think sqlload was a link in 8.0.x. Now with 8i it's gone. You can create the
link if you do not wish to change the existing code. We did just that since
Developers did not want to change their scripts. 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Fowler, Kenneth R [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr
> 
> List,
> 
> I am currently working on migrating an application from Oracle 7.3 to
> Oracle
> 8.1.6.2 (This is on Solaris 2.6).  One of the shell scripts makes use of
> sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not
> on
> the 8.1.6.2 server.  On the 7.3 server it looks like there are two
> directory
> entries, one for sqlload and one for sqlldr...
> 
> orapps1 $ ls -al | grep sql
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlldr
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlload
> 
> On the 8.1.6.2 server there is just sqlldr.  I am wondering if the sqlload
> link is something that has been dropped from newer versions? or has
> someone
> manually applied the link to the 7.3 server?
> 
> Thanks,
> Ken
> _
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:[EMAIL PROTECTED]
> 
> 
> 
> LEGAL NOTICE
> Unless expressly stated otherwise, this message is confidential and may be
> privileged. It is intended for the addressee(s) only. Access to this
> E-mail by anyone else is unauthorized. If you are not an addressee, any
> disclosure or copying of the contents of this E-mail or any action taken
> (or not taken) in reliance on it is unauthorized and may be unlawful. If
> you are not an addressee, please inform the sender immediately.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fowler, Kenneth R
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT - interviewing your superior(fun question)

[Miller, Jay]

I don't usually read the OT posts but I glanced at this while deleting
stuff.  Apologies if anyone already supplied the correct quote.

What Al Gore said was 'While in the Senate I played a major role in creating
the internet'.  Apparently he was a major sponsor a author of the bills that
transformed arpanet into the more commercially oriented internet.

I used to have links that traced the evolution of that entirely truthful
quote to 'I invented the internet' but dropped most of them after the
election.  I could probably track them down again in the unlikely event
anyone was interested :).  I think it was Wired magazine that first used the
word 'invented'.

Jay Miller

-Original Message-
Sent: Thursday, June 21, 2001 11:25 PM
To: Multiple recipients of list ORACLE-L


Yes, the statement is different, but just based on the words in the
sentence. "Playing a role in inventing"!=  "inventing".  Odd thing
about words: they mean something.

Hell, I play a role in the community on this listserv. 
I am certain Jared and Esteemed Company would make the 
semantic mistake of thinking I AM the community on this listserv. 

Unless, of course, I were in Florida, where votes don't count. 

JUST KIDDING! God Bless the Appointed President, and the
minority that voted for him!

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/21/2001 6:28 PM

And this statement is ANY better???  I use "Software that Powers the
Internet" therefore I guess I, in a way, run the darn thing. :) God
bless
the electoral college!

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Thursday, June 21, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L


nope, he said

"I played a role in inventing the Internet"

-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L


I thought he invented the internet.  Just ask him.  The best line was "I
knew Jack Kennedy and You are no Jack Kennedy" said by Loyd Benson to
Dan
Quayle. 


>>> [EMAIL PROTECTED] 06/21/01 05:13PM >>>
:), actually if you parrot Gore, it would be

"I played a role in inventing certifications".

The devil is in forgetting the details!


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Speaks, Chuck W.
  INET: [EMAIL PROTECTED]

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

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

RE: A danger in cloning databases

[Miller, Jay]

Immediately after this happened I thought of that and removed all other
entries from tnsnames.ora so database links wouldn't work (and of course
changed the reference for the local entry).

-Original Message-
Sent: Wednesday, July 11, 2001 1:03 PM
To: Multiple recipients of list ORACLE-L


And watch out for any database links that points to other production
servers.

>>> [EMAIL PROTECTED] 07/11/01 12:27PM >>>
Another thing to watch are the dbms_job entries, especially ones which
interact with other databases.  For example  a job which pulls data from
another database and writes back to that database the success of its
efforts.  If this job were to run in the clone, it might perform this task
before the "real" database does.  Jobs such as these should first check to
see that they are running on the proper database before executing.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, July 11, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Richard Ji
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: can i place online redologs with oracle engine ?

[Miller, Jay]

Hi, 

That's exactly what we did when we moved to a new box and got to design the
disk layout however we liked.  
Getting the redo logs to not be striped with the datafiles enabled us to
more than double transaction load in load testing (to such an extent that I
started getting Checkpoint Not Complete errors and had to increase the log
file size).

Jay Miller

-Original Message-
Sent: Friday, July 06, 2001 6:51 AM
To: Multiple recipients of list ORACLE-L


infact i should have been more clearer 
offcourse i can place them on any disk..the reason i asked was...

how much IO does the root + oracle engine do when an instance is running...?


and given no other choice, i plan to place them with root+oracle rather than
with some data or indexes. 



> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 05, 2001 7:54 PM
> To:   Rahul; Multiple recipients of list ORACLE-L
> Subject:  Re:can i place online redologs with oracle engine ?
> 
> Rahul,
> 
> You can put them just about anywhere you want, but since they tend to
> be a
> high IO item you may end up paying a price.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:can i place online redologs with oracle engine ?
> Author: Rahul <[EMAIL PROTECTED]>
> Date:   7/5/2001 1:16 AM
> 
> > list, 
> > i cannot spare a separate drive for the redologs,
> > can i place the online logs with the same drive as
> > the solaris + oracle engine  ? 
> > (m,y solaris and oralce are also on the same drive) 
> > 
> > TIA
> > 
> > Rahul
> > 
> > 
> > 
> > 
> -- 
> 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).
> 
-- 
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).
-- 
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: DB Backup Question

[Miller, Jay]

We don't back up the filesystems that have the live data during our tape
backups.  Since these files are effectively unusable there's no point in
saving them.

Jay Miller

-Original Message-
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

-- 
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 EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Listener Security !!

[Miller, Jay]

If you still have the mail, this topic was discussed after I posted under:
A Danger in Cloning Databases

when I brought my production listener down after cloning a test database :(

-Original Message-
Sent: Monday, July 23, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L


Hi All !!

   Today I came across a typical Hole in Listener Security.
If you have lsnrctl utility (or Database installation) at one
Box, then you can stop the listener on another Box. Just change
the parameter file (listener.ora) to have hostname of another
(may be production server) box. Now goto lsnrctl and fire stop
command. you would notice that the local listener is running
but the remote listener is down...
This is more serious issue on platforms like Unix and VMS 
where you can control listener (locally) only if you are a 
member of DBA group. This means that Listener doesn't have any
cross OS check in it
Is this a known issue/bug. Any-ideas, any patches? Oracle
Corp guys, what you say? 
Waiting for you views..

Rajesh
OC DBA 8&8i
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: how to run explain plan on SP???

[Miller, Jay]

One idea would be to start SQL Trace for your session, execute the stored
procedure, stop SQL Trace.
That will create a trace file in your udump directory which you can format
using TKPROF to include the explain plan for each SQL statement executed.
E.g.,

tkprof x.trc formattedfile.txt sys=no explain=username/password

Jay Miller

-Original Message-
Sent: Tuesday, July 24, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


Hi,

Can anyone show me how to run explain plan on a whole
stored procedure?  815 on Sun 5.6.  Thanks a lot.

Leslie

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ERROR IN INSTALING PATCH 8.1.6.3.0

[Miller, Jay]

We had a similar problem when installing the patchset for Oracle Client on
Windows.  We ended up renaming each existing .dll (.dll.old) and continuing.
Worked fine.
 
Jay Miller

-Original Message-
Sent: Tuesday, July 24, 2001 7:55 PM
To: Multiple recipients of list ORACLE-L


Had a similar problem with a diff. set of files when installing patch
8.1.7.1.0b and that was on AIX. Just removed the offending files which gave
a similar error to allow the patch to write a new file and it worked for us.
No problems encountered so far, though I would not hesitate to say that it
was a wrong practice, but took a chance and it worked.
If you have backed up your systems correctly as recommended,  I would say go
for it.
 
Satish


>>> [EMAIL PROTECTED] 07/24/01 02:58PM >>>
For what purpose u are installing this patch let me know


>From: Harvinder Singh <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: ERROR IN INSTALING PATCH 8.1.6.3.0
>Date: Tue, 24 Jul 2001 12:45:24 -0800
>
>Hi,
>
>I am trying to install patch 8.1.6.3.0 on WIN 2 and i am getting error:
>Error in writing to file f:\ORACLE\ORA81\BIN\ORANCDS8.DLL..and if i
>ignore this
>error the same error comes for other DLL...Oracle is shutdown properly
>and there is
>no service running of Oracle.
>What might be the reason.
>
>Thanks
>Harvinder
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
<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).


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

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

Tuning question - Why did this index help so much?

[Miller, Jay]

The other week a new production process was running much more slowly than
anticipated.  A file needed to be sent out by 6:00pm and at the rate the
table was being populated it wouldn't complete until around 9:30pm.  The
production people and developers came to me for help and I  saw that the SQL
Explain Plan that was usually being executed (this would run a few million
times) was something like

select a.col1,a.col2,a.col3,b.col2
from a, b
where a.col4=b.col1
and a.col5=:b1

nested loops
table a
index a1 (unique)
table b
index b1 (range)

This looked pretty good, but it occurred to me that only one column was
being selected from table b, so if I added a index (b2) that combined col1
and col2 to table b then it wouldn't be necessary to read table b at all,
all the information would be in index b2.

This resulted in a plan of:

nested loops
table a
index a1 (unique)
index b1 (range)

I did so on the fly (this was only a 4,000 row table so it took almost no
time to create the index).  I anticipated that it would cut about 25% off
the processing time (only 3/4 as many block reads).  Instead it cut about
75% off the processing time causing it to finish at 5:45 (I was a hero to
the developers and production people, but had to warn them not to tell their
management about it since I could get in trouble for not following the
Change Control Process).  

My question is, where did the additional 50% efficiency come from?  What am
I missing?  I'm glad it worked so well, but would like to understand why...
-- 
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: both dbms_stats & dbms_utility are gathering stats on sys obj

[Miller, Jay]

Yep.  That's what we do also.

-Original Message-
Sent: Tuesday, July 24, 2001 8:51 PM
To: Multiple recipients of list ORACLE-L
objects


Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
dbms_utility.analyze_database() and then
dbms_utility.analyze_schema('SYS','DELETE') to remove SYS's stats. What
about one of those?

Jon Walthour

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 3:55 PM


>
> Both DBMS_STATS.GATHER_DATABASE_STATS and DBMS_UTILITY.ANALYZE_DATABASE
are
> gathering statistics on sys objects. As per oracle, we shouldn't analyze
> the objects owned by sys.
>
> When I searched on metalink, I found the following information provided by
> oracle tech support.
>
> filed bug 969814 against DBMS_UTILITY.ANALYZE_DATABASE which was not
> excluding these tables.
> This bug is fixed in 8.1.7.
>
> I did my tests on 8.1.7 database on hp-ux. Apparently it is not fixed on
> 8.1.7.0.0.
>
> Is it fixed in later releases? I appreciate your comments.
>
> Best regards,
> Prasad
>
> --
> 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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Tuning question - Why did this index help so much?

[Miller, Jay]

Kirti made a similar suggestion. But I had done a select count(*) on the
table so that all the table rows would be loaded into memory.  I suppose
that the index blocks might not have been, but even there the likelihood
that any given one of the million plus reads wouldn't find one of the 4,000
rows in memory seems rather small.

Hmm, is it possible to Cache an index?  I just tried an ALTER INDEX xxx
CACHE; command and it didn't work.

Jay Miller
 

-Original Message-
Sent: Wednesday, July 25, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L


it's possible that the index was small enough to stay cached in the SGA?


>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Tuning question - Why did this index help so much?
>Date: Wed, 25 Jul 2001 08:31:28 -0800
>
>The other week a new production process was running much more slowly than
>anticipated.  A file needed to be sent out by 6:00pm and at the rate the
>table was being populated it wouldn't complete until around 9:30pm.  The
>production people and developers came to me for help and I  saw that the 
>SQL
>Explain Plan that was usually being executed (this would run a few million
>times) was something like
>
>select a.col1,a.col2,a.col3,b.col2
>from a, b
>where a.col4=b.col1
>and a.col5=:b1
>
>nested loops
>   table a
>   index a1 (unique)
>   table b
>   index b1 (range)
>
>This looked pretty good, but it occurred to me that only one column was
>being selected from table b, so if I added a index (b2) that combined col1
>and col2 to table b then it wouldn't be necessary to read table b at all,
>all the information would be in index b2.
>
>This resulted in a plan of:
>
>nested loops
>   table a
>   index a1 (unique)
>   index b1 (range)
>
>I did so on the fly (this was only a 4,000 row table so it took almost no
>time to create the index).  I anticipated that it would cut about 25% off
>the processing time (only 3/4 as many block reads).  Instead it cut about
>75% off the processing time causing it to finish at 5:45 (I was a hero to
>the developers and production people, but had to warn them not to tell 
>their
>management about it since I could get in trouble for not following the
>Change Control Process).
>
>My question is, where did the additional 50% efficiency come from?  What am
>I missing?  I'm glad it worked so well, but would like to understand why...
>--
>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).


_
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: 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: 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: re-archiving a redo log file

[Miller, Jay]

Hmm, would it work to do an OS level copy so long as you get to the redo log
before it starts being written to again?
Just a random thought...

-Original Message-
Sent: Wednesday, July 25, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L


I don't think, it's possible.
Most probably it checks 'archived' column in v$log.
Also, it keeps track of archived files in v$archived_log.
 
Igor 
  


- Original Message - 
To: Multiple  <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L 
Sent: Wednesday, July 25, 2001 11:55 AM


Is it possible to re-archive an already archived 
but still online redo log file? 

the 8.1.6 sql*plus manual says it is, but 
I can't get the syntax down right apparently. 

SQL>  archive log 227 

returns a ORA-16013 (does not need archiving) error 
and 

SQL> archive log 227 to '/tmp' 
returns 
SP2-0718  illegal arhicve log option 

Anybody done this? 
 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Doing linear scans over an associative array is like 
  trying to club someone to death with a loaded Uzi. 
 - Larry Wall (creator of Perl) 

-- 
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: Tuning question - Why did this index help so much?

[Miller, Jay]

Hi Tom,

That's why I expected a 25% decrease in processing time (instead of reading
2 index blocks and 2 table blocks it read 2 index blocks and 1 table block).
But why would it give a 75% decrease?

Jay

-Original Message-
Sent: Wednesday, July 25, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L


I think it's because the optimizxer did not have to go to the table b to
satisfy the query - it went to the index only.

does this make sense?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, July 25, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L


it's possible that the index was small enough to stay cached in the SGA?


>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Tuning question - Why did this index help so much?
>Date: Wed, 25 Jul 2001 08:31:28 -0800
>
>The other week a new production process was running much more slowly than
>anticipated.  A file needed to be sent out by 6:00pm and at the rate the
>table was being populated it wouldn't complete until around 9:30pm.  The
>production people and developers came to me for help and I  saw that the 
>SQL
>Explain Plan that was usually being executed (this would run a few million
>times) was something like
>
>select a.col1,a.col2,a.col3,b.col2
>from a, b
>where a.col4=b.col1
>and a.col5=:b1
>
>nested loops
>   table a
>   index a1 (unique)
>   table b
>   index b1 (range)
>
>This looked pretty good, but it occurred to me that only one column was
>being selected from table b, so if I added a index (b2) that combined col1
>and col2 to table b then it wouldn't be necessary to read table b at all,
>all the information would be in index b2.
>
>This resulted in a plan of:
>
>nested loops
>   table a
>   index a1 (unique)
>   index b1 (range)
>
>I did so on the fly (this was only a 4,000 row table so it took almost no
>time to create the index).  I anticipated that it would cut about 25% off
>the processing time (only 3/4 as many block reads).  Instead it cut about
>75% off the processing time causing it to finish at 5:45 (I was a hero to
>the developers and production people, but had to warn them not to tell 
>their
>management about it since I could get in trouble for not following the
>Change Control Process).
>
>My question is, where did the additional 50% efficiency come from?  What am
>I missing?  I'm glad it worked so well, but would like to understand why...
>--
>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).


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

RE: deletion of data from a large table

[Miller, Jay]

You would need to drop any foreign key constraints pointing to that table
before truncating and then recreate them after reloading the data.
If I remember correctly, simply disabling them won't work since Oracle
treats Truncate Table the same as Drop Table in many ways.
Other constraints (NOT NULL, etc) won't be affected.

Also, depending on the size of your initial extent and the amount of data
you have remaining, you might be able to resize the one remaining datafile
down after you truncate the table. (e.g., if your initial exent is 5 Meg and
you don't anticipate ever having more than 1 Meg of data, you can RESIZE the
datafile down to 5 Meg after the truncate).

Jay Miller

-Original Message-
Sent: Thursday, July 26, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L


This can be done . But what about the constraints ?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 5:41 PM


> I think this is happening because when you DELETE data the High Water
> Mark(HWM) is not lowered. Essentially
> you have not gained any freespace. If possible you could export remaining
> data truncate table then re-import.
>
> Correct me if I am wrong here.
>
> Rick
>
> -Original Message-
> Sent: Thursday, July 26, 2001 7:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>I have deleted 3 lakhs records from a large table. But there is no
effect
> on tablespace i.e. before I delete the data freespace in TS is 100MB ,
after
> deletion also it is showing 100MB. What could be the reason ? How to get
the
> freespace after deleting the data ?
> Thanks
> rukmini
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rukmini Devi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Rukmini Devi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: deletion of data from a large table

[Miller, Jay]

Oops, meant to say "you can RESIZE the
datafile down to 1 Meg after the truncate"

-Original Message-
Sent: Thursday, July 26, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


You would need to drop any foreign key constraints pointing to that table
before truncating and then recreate them after reloading the data.
If I remember correctly, simply disabling them won't work since Oracle
treats Truncate Table the same as Drop Table in many ways.
Other constraints (NOT NULL, etc) won't be affected.

Also, depending on the size of your initial extent and the amount of data
you have remaining, you might be able to resize the one remaining datafile
down after you truncate the table. (e.g., if your initial exent is 5 Meg and
you don't anticipate ever having more than 1 Meg of data, you can RESIZE the
datafile down to 5 Meg after the truncate).

Jay Miller

-Original Message-
Sent: Thursday, July 26, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L


This can be done . But what about the constraints ?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 5:41 PM


> I think this is happening because when you DELETE data the High Water
> Mark(HWM) is not lowered. Essentially
> you have not gained any freespace. If possible you could export remaining
> data truncate table then re-import.
>
> Correct me if I am wrong here.
>
> Rick
>
> -Original Message-
> Sent: Thursday, July 26, 2001 7:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>I have deleted 3 lakhs records from a large table. But there is no
effect
> on tablespace i.e. before I delete the data freespace in TS is 100MB ,
after
> deletion also it is showing 100MB. What could be the reason ? How to get
the
> freespace after deleting the data ?
> Thanks
> rukmini
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rukmini Devi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Rukmini Devi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
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-- Pu

RE: completely off-topic question...

[Miller, Jay]

Just for the record, LeGuin's novel is entitled "The Dispossessed".  But I
agree that it's a great book.
 
Just reread Asimov's "The Gods Themselves" two weeks ago.  My favorite of
his books, I stopped reading them when he started combining them into one
mish mash of a future history.
 
Whoever said Zelazny was one of their favorites, full agreement here.  Lord
of Light is probably my all time favorite sf work.
 
Another current author worth checking out is Lois McMaster Bujold.  She
rights very fast moving, *very* readable sf novels (the whole Vorkosigan
series, I'd recommend reading them in order) and has one excellent fantasy:
The Spirit Ring.
 
For current fantasy, I really like Stephen Brust, though he can be uneven.
Still, if you're a fan of the The Three Musketeers then his book The Phoenix
Guards is absolutely hilarious.
 
And Rachel:  I'm afraid I can't speak to you any more now that I know you
don't like Tolkien :).
 
Jay Miller

-Original Message-
Sent: Friday, August 03, 2001 6:17 PM
To: Multiple recipients of list ORACLE-L



> -Original Message- 
> From: Rachel Carmichael [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] 
> 
> I prefer Science Fantasy to Science Fiction (Marion Zimmer 
> Bradley, Anne 
> McCaffrey) 


I'm the same way. I don't keep up with all the new authors, but someone
needs to mention Larry Niven (his "known space" series is the one that
taught me the acronym "tanstaafl") and Ursula K. LeGuin ("The Unpossessed"
is one of my favourite books of all time; unfortunately she wasn't very
prolific).

And of course an obeisance to Isaac Asimov. I can honestly say I think I've
read all his science-fiction novels and short stories. H. G. Wells and Jules
Verne should not be forgotten either.

Amongst the more recent authors I've encountered, I always recommend C. J.
Cherryh (try "Downbelow Station" and "Cyteen") and Kim Stanley Robinson
("Red Mars", "Green Mars", "Blue Mars" - an excellent description of what
problems a new society might run into on Mars)

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

[Miller, Jay]

t any disclosure, use or
copying of the information by anyone other than the intended recipient is
prohibited and may be illegal.  If you have received this message in error,
please notify the sender immediately by return e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that
any attachment to this e-mail has been swept for viruses.  We accept no
liability for any damage sustained as a result of software viruses and
advise you carry out your own virus checks before opening any attachment.

-- 
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: completely off-topic question...

[Miller, Jay]

Well, okay.  But gee, he didn't invent his own language or anything...



Jay

-Original Message-
Sent: Monday, August 06, 2001 3:33 PM
To: Multiple recipients of list ORACLE-L


Jay,

That's okay -- I'll get my mom to talk to your aunt to have her talk to your

mom... they'll make you talk to me :)

Besides, I agree with you about Asimov -- that should count for something

Rachel


>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: completely off-topic question...
>Date: Mon, 06 Aug 2001 10:50:39 -0800
>
>Just for the record, LeGuin's novel is entitled "The Dispossessed".  But I
>agree that it's a great book.
>
>Just reread Asimov's "The Gods Themselves" two weeks ago.  My favorite of
>his books, I stopped reading them when he started combining them into one
>mish mash of a future history.
>
>Whoever said Zelazny was one of their favorites, full agreement here.  Lord
>of Light is probably my all time favorite sf work.
>
>Another current author worth checking out is Lois McMaster Bujold.  She
>rights very fast moving, *very* readable sf novels (the whole Vorkosigan
>series, I'd recommend reading them in order) and has one excellent fantasy:
>The Spirit Ring.
>
>For current fantasy, I really like Stephen Brust, though he can be uneven.
>Still, if you're a fan of the The Three Musketeers then his book The 
>Phoenix
>Guards is absolutely hilarious.
>
>And Rachel:  I'm afraid I can't speak to you any more now that I know you
>don't like Tolkien :).
>
>Jay Miller
>
>-Original Message-
>Sent: Friday, August 03, 2001 6:17 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
> > -Original Message-
> > From: Rachel Carmichael [ mailto:[EMAIL PROTECTED]
><mailto:[EMAIL PROTECTED]> ]
> >
> > I prefer Science Fantasy to Science Fiction (Marion Zimmer
> > Bradley, Anne
> > McCaffrey)
>
>
>I'm the same way. I don't keep up with all the new authors, but someone
>needs to mention Larry Niven (his "known space" series is the one that
>taught me the acronym "tanstaafl") and Ursula K. LeGuin ("The Unpossessed"
>is one of my favourite books of all time; unfortunately she wasn't very
>prolific).
>
>And of course an obeisance to Isaac Asimov. I can honestly say I think I've
>read all his science-fiction novels and short stories. H. G. Wells and 
>Jules
>Verne should not be forgotten either.
>
>Amongst the more recent authors I've encountered, I always recommend C. J.
>Cherryh (try "Downbelow Station" and "Cyteen") and Kim Stanley Robinson
>("Red Mars", "Green Mars", "Blue Mars" - an excellent description of what
>problems a new society might run into on Mars)
>
>--
>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).


_
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: 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: 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: Optimizer Mode......how to choose the right one?

[Miller, Jay]

You probably already thought of this, but I hope you aren't analyzing the
SYS schema?  This can cause terrible performance problems.

Jay Miller

-Original Message-
Sent: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L

...

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: database disaster recovery

[Miller, Jay]

!! Please do not post Off Topic to this List !!

Well, all our servers were fine as of the time our building was evacuated on
Tuesday but I got paged on Wednesday that our 100 Wall St. office had lost
power and was running on generator.  Fortunately the only machines I had
there were our standby server (so we're running without a standby at the
moment), our development server (I ftp'ed the last export file over to a NJ
server and will probably be importing the development schemas to our QA box
as an interim measure) and a clone of our production server that we were
using for upgrade testing.  Somehow I don't think our planned upgrade will
happen this weekend...

Some of my colleagues had production servers in NY and, with some minor
snafus, have brought up the standby servers in NJ and switched everyone
over.

I am having fond recollections of arguing about 3 years ago that we had to
have our standby server in a different datacenter than our production
server. When I first joined this group they were both in NY.

Jay Miller
x48355


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


!! Please do not post Off Topic to this List !!

I'm curious. With all that's going on in New York, were any
Oracle databases lost? Has anyone had to activate a disaster
recovery plan and bring up their database at a new location?
If so, how did that go? It would be interesting, and
possibly instructive, to hear some real-life stories about
what went wrong, what went well, etc.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

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

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

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

Lock Manager in Enterprise Manager 2.1?

[Miller, Jay]

!! Please do not post Off Topic to this List !!

Hi,

I remember this being discussed a long time ago but I'm still using 1.6 and
one of the other DBAs just asked me.  Does anyone know what happened to Lock
Manager (formerly part of Diagnostics Pack in 1.6) in Enterprise Manager
2.1? 
Is it now part of a different app?

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

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

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

RE: Copy Oracle's binary.

[Miller, Jay]

One more thing, be careful that if you do this that you change the
listener.ora file to point to the new hostname.  Otherwise you can
accidently shut down the listener on the other server.

-Original Message-
Sent: Monday, September 17, 2001 6:31 PM
To: Multiple recipients of list ORACLE-L


Hello,
 
I've two machines (with the same unix's configuration on Sun Solaris). On
has Oracle 8.1.7. installed and a database. Do you think it's possible to
copy Oracle's binary and the database on Unix level to the new serveur
instead of installing and cloning the db ?
 
Thank you very much.
 
Thanh-truc Nguyen  

-- 
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: Better Way Of DeFragmentation

[Miller, Jay]

I assume you intend to also:
.5) Clone database to second machine
.6) Drop all objects in schema on 2nd machine
4.5) Take cold backup of 1st machine

With those caveats, it looks fine.

Jay Miller

-Original Message-
Sent: Thursday, September 20, 2001 10:35 AM
To: Multiple recipients of list 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: 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: Better Way Of DeFragmentation

[Miller, Jay]

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

   <[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 EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 ?

[Miller, Jay]

Agreed.  Do you want to ever be able to go on a 2 week vacation at some
point in your life?  Or even 1 week overseas?
 
Then you need a 2nd DBA.
 
It's also much better for the company.  If you should ever decide to seek
greener pastures elsewhere there will be someone familiar with all their
systems and databases.
 

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



second person, you get to have a life 


-Original Message- 
<mailto:[EMAIL PROTECTED]> ] 
Sent: Thursday, September 20, 2001 12:30 PM 
To: Multiple recipients of list ORACLE-L 


I've been presented with an opportunity to justify requirements for a 2nd 
DBA at our site.  As I see it there are an number of paths this presents: 

1 - Justify and get a 2nd DBA.  
Pro's: Gives me more time to get involved in other projects as a senior DBA.

Holidays and attendance at courses and seminars etc. easier to take 

2 - Outsource this role and activate it when required and justify putting 
money into investing in software and/or hardware to allow a single DBA 
function to required levels. 
Pros: New tools etc. to learn and broader experience gained.  More 
bargaining power if required. 

I'd like to hear your feedback on which path you'd be inclined to take and 
why?.  Also if going it alone what you'd look for software in hardware and 
other areas.  Currently 6 NT servers, 10 databases and expanding... 


Sean :) 

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

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
<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
<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). 

-- 
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: Better Way Of DeFragmentation

[Miller, Jay]

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"

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

   <[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 EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of m

RE: 2nd DBA or ?

[Miller, Jay]

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).
-- 
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: Design Issue - Quick response appreciated

[Miller, Jay]

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: Design Issue - Quick response appreciated

[Miller, Jay]

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
-

RE: 2nd DBA or ?

[Miller, Jay]

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: ORACLE VS. SYBASE

[Miller, Jay]

No guarantees as to accuracy, but I heard this story about 7 years ago from
someone who said he was there.

Apparently when the major Wall St. firms were deciding whether to go with
Oracle or Sybase they arranged to have both companies come in and do
presentations and say what special arrangements they'd be willing to offer.

Sybase sent high level management who came with a list of features,
explained their policies and offered a substantial discount.

Oracle sent Larry Ellison who told them Oracle didn't have to offer
discounts because it was obviously superior and anyone who bought Sybase was
an idiot.


They bought Sybase.


Jay Miller

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




-- Guy Hammond <[EMAIL PROTECTED]>


> That's about all I can be bothered to type for now. In summary, I would
> like to say that Sybase is a fine product for your grandmother to store
> her recipes in :0)

Interesting to note that a good number of financial companies -- who
make a living off of fast, stable databases -- use Sybase.  They tend
to prefer it for its combination of speed and cost of operation.  None
of them store recipies on it that I know of, nor do they allow their
grandmothers access to the systems.

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: When optimizer reevaluate SQL statement

[Miller, Jay]

om this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Dropping table is not completing

[Miller, Jay]

As someone else asked, how many extents does the table have?

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


It just hangs and I am not sure what tables/views to query to find out what
the problem is.

Thanks
Rick

-Original Message-
Sent: Thursday, October 04, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L


What is the error?  Or does it just hang?
Have you looked at session wait events to see what is holding it up?
If it was locked, it would echo right back saying acquire with nowait
failed.  Perhaps trying to drop it with a trace behind it.  Or trace the
session as you wait from sys.


"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, October 04, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L

Hi All,

I am trying to drop a table. It is not locked and has very few records in
it.  I am trying to drop it but it will not.
What can I check to find out why it will not drop?

Thanks
Rick
-- 
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: 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: 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: 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).

getting password request on connect internal

[Miller, Jay]

I know this was discussed recently but I just did a major clean up of my
1,000+ unread posts so my apologies.

All of a sudden I'm unable to shutdown a database.  This is the alert_log:

Shutting down instance (immediate)
License high water mark = 21
Thu Oct  4 20:30:38 2001
SHUTDOWN: waiting for active calls to complete.



And when I try to connect internal to do a shutdown abort I get this:


Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

ORA-03113: end-of-file on communication channel

SVRMGR> connect internal
Password:


I've already gone through every step  in the Oracle Note 69642.1 (Checklist
for Resolving CONNECT INTERNAL PASSWORD Issues) without any results.  Any
ideas?

Thanks,
Jay Miller
x48355
-- 
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: getting password request on connect internal - more info

[Miller, Jay]

Oops.
Oracle 8.1.6.3
Solaris 2.6

-Original Message-
Sent: Friday, October 05, 2001 10:03 AM
To: '[EMAIL PROTECTED]'


I know this was discussed recently but I just did a major clean up of my
1,000+ unread posts so my apologies.

All of a sudden I'm unable to shutdown a database.  This is the alert_log:

Shutting down instance (immediate)
License high water mark = 21
Thu Oct  4 20:30:38 2001
SHUTDOWN: waiting for active calls to complete.



And when I try to connect internal to do a shutdown abort I get this:


Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

ORA-03113: end-of-file on communication channel

SVRMGR> connect internal
Password:


I've already gone through every step  in the Oracle Note 69642.1 (Checklist
for Resolving CONNECT INTERNAL PASSWORD Issues) without any results.  Any
ideas?

Thanks,
Jay Miller
x48355
-- 
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: getting password request on connect internal

[Miller, Jay]

Yep.  In fact I had no problem connecting to another instance running on the
same machine.  And they've been running (with a nightly shutdown) with no
problems for the last 2 weeks.

Jay Miller

-Original Message-
Sent: Friday, October 05, 2001 11:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


are you part of the dba, oinstall group?

>>> [EMAIL PROTECTED] 10/05/01 11:43 AM >>>
I know this was discussed recently but I just did a major clean up of my
1,000+ unread posts so my apologies.

All of a sudden I'm unable to shutdown a database.  This is the alert_log:

Shutting down instance (immediate)
License high water mark = 21
Thu Oct  4 20:30:38 2001
SHUTDOWN: waiting for active calls to complete.



And when I try to connect internal to do a shutdown abort I get this:


Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

ORA-03113: end-of-file on communication channel

SVRMGR> connect internal
Password:


I've already gone through every step  in the Oracle Note 69642.1 (Checklist
for Resolving CONNECT INTERNAL PASSWORD Issues) without any results.  Any
ideas?

Thanks,
Jay Miller
x48355
-- 
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: 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: getting password request on connect internal

[Miller, Jay]

Well, we ended up rebooting the server and we were then able to start up,
shut down, and start up the instance.  Weird.

-Original Message-
Sent: Friday, October 05, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L


Yep.  In fact I had no problem connecting to another instance running on the
same machine.  And they've been running (with a nightly shutdown) with no
problems for the last 2 weeks.

Jay Miller

-Original Message-
Sent: Friday, October 05, 2001 11:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


are you part of the dba, oinstall group?

>>> [EMAIL PROTECTED] 10/05/01 11:43 AM >>>
I know this was discussed recently but I just did a major clean up of my
1,000+ unread posts so my apologies.

All of a sudden I'm unable to shutdown a database.  This is the alert_log:

Shutting down instance (immediate)
License high water mark = 21
Thu Oct  4 20:30:38 2001
SHUTDOWN: waiting for active calls to complete.



And when I try to connect internal to do a shutdown abort I get this:


Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

ORA-03113: end-of-file on communication channel

SVRMGR> connect internal
Password:


I've already gone through every step  in the Oracle Note 69642.1 (Checklist
for Resolving CONNECT INTERNAL PASSWORD Issues) without any results.  Any
ideas?

Thanks,
Jay Miller
x48355
-- 
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: 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: 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: SOLARIS VERSION

[Miller, Jay]

I tried to log into Metalink to get the matrix for you but it was down.
 
But I just came across  a printout so here it is.  8.1.7 is compatible with
2.6, 2.7 and 2.8.  It is not compatible with 2.4 or 2.5.
 
Jay Miller

-Original Message-
Sent: Wednesday, October 17, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L


Hi,

We need to install Oracle 8.1.7.1.5 ON SOLARIS box.

Can someone point me to article which shows the compatibity matrix between
oracle 8.1.7 and

solaris versions.

Thanks

-Harvinder

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

Concealing SQL Loader password from ps -ef

[Miller, Jay]

When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

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

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

Unable to rebuild database from hot backup

[Miller, Jay]

Okay, this is weird.

I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.

After doing
recover database using backup controlfile;

I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf

Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  

Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unable to rebuild database from hot backup

[Miller, Jay]

Another piece of information:

On the basis of "it couldn't hurt to try" I recopied everything but instead
of using the regular control file I used the standby control file.  I then
mounted it in standby mode, issued the recover standby database command,
activated the standby, shutdown, and opened the database.  It worked fine.

Why would it work with a standby controlfile and not with the regular
control file?  I have my QC database working but I'm really puzzled.

Jay Miller

-Original Message-
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L


Okay, this is weird.

I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.

After doing
recover database using backup controlfile;

I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf

Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  

Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: good workaround for a ORA-2016?

[Miller, Jay]

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


__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

[Miller, Jay]

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

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

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

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

A really stupid question

[Miller, Jay]

How can I access the Oracle-L archives?  
 
There's something I remember reading a few months ago that I want to look
up.
 
Embarassedly yours,
Jay Miller
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

RE: help!! smon

[Miller, Jay]

SMON is the Oracle background process that handles recovery.  Did you
perhaps do a shutdown abort and then restart your database?
If so SMON is rolling forward and rolling back uncommitted transaction.

-Original Message-
Sent: Friday, October 04, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L


Hi gurus ,,,
i need check what do you doing the smon proc!!!
this process have 99% of CPU
somebody help me!!!




@lex 
 
  Lic. Alexander Ordóñez Arroyo 
  Soporte Tru64Unix & BD  Oracle  
  Caja Costarricense del Seguro Social 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]  Celular 397-0532

 
The truth is out there in WWW 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexander Ordonez
  INET: [EMAIL PROTECTED]

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

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

Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issues because there will be a large cache.
 
I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
could then at least seperate the redo logs from the datafiles (probably
putting them with the oracle executables and some other files).
 
The Sun rep kept talking up how much more powerful the CPUs were and I kept
saying, "but we're not CPU bound, we don't need any more CPU".
 
If anyone can either
 
a) tell me I'm worrying for nothing
b) recommend a better way to stripe/distribute my files
c) provide references  or experience to show this is a bad idea
 
I'd really appreciate it.  
 
 
Thanks,
Jay Miller 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

I obviously left out a lot of information :).

We would be using server partitioning, with seperate ORACLE_HOMES for each
database (necessary since we have a variety of versions running).

The box would be running 1+0, the Sun reps suggest striping across all disks
(my first red flag).

I hadn't even thought of the problem of not being able to reboot the server,
that's an excellent point.

Currently we have absolutely no performance problems on our OLTP database.
This whole kerfuffle was an outgrowth of my pushing really hard to get a
backup box for our datawarehouse (which currently has no standby, no box
that it can restored to and no QA box).  The suggestion was made that rather
than get a separate box for the datawarehouse - get the 15K and have the
OLTP and datawarehouse on different partitions.  This would certainly speed
up the data transfer between them (data is transferred from OLTP -> Data
Warehouse on a daily basis).  We could then put other databases that access
my databases on other partitions (several other databases have snapshots on
some of my tables).  

So this would make some processes more efficient, but i/o on my OLTP
database is currently tuned so well that it hurts every time I think of
giving it up.  One spindle has the Oracle executables with the redo logs on
the outside of the disk.  Another has the various .dat files, shell scripts,
etc, with the archive logs on the outside of the disk.   Even when we run
really intensive updates our wio rarely gets very high.

Regarding the load question: We have fairly active transaction activity
during the day but most connections are managed by Microsoft Transaction
Server in a middle tier so while there are usually app. 200 sessions
(including some old client server apps) we rarely have more than 20 or so
active at any one time.

The datawarehouse has fewer sessions but often has some resource intensive
queries running.

If anyone can point me to docs/websites saying that a large caches does
*not* make up for fewer disks/spindles I would greatly appreciate it.
Currently I'm being told that Sun must know what they're talking about.


Thanks again,
Jay Miller






-Original Message-
Sent: Wednesday, October 09, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Others have addressed the performance issues.

What about the admin issues?

If consolidate to a single server, consider a separate
ORACLE_HOME for each database.  You may need
to apply different patches to fix different problems in
various databases. 

You have this ability now, but will lose it if you consolidate
without separate ORACLE_HOME's.

Something else you will lose is the ability to reboot the
server if needed for a single database.

Since you may be moving to a 15k, investigate server
partitioning to retain this functionality. 

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/09/2002 11:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Advice needed on move to Sun 15K (losing spindles)


 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issues because there will be a large cache.
 
I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
could then at least seperate the redo logs from the datafiles (probably
putting them with the oracle executables and some other files).
 
The Sun rep kept talking up how much more powerful the CPUs were and I 
kept
saying, "but we're not CPU bound, we don't need any more CPU".
 
If anyone can either
 
a) tell me I'm worrying for nothing
b) recommend a better way to stripe/distribute my files
c) provide references  or experience to show this is a bad idea
 
I'd really appreciate it. 
 
 
Thanks,
Jay Miller 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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



-- 
Please see the official ORACLE-L FA

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

Thanks Kirti!

I loved the line "The first thing to do, regardless of platform or claims by
the vendor, is to completely forget the existence of a cache"

Any similar references will be greatly appreciated.  The more ammunition I
have the likelier I am to kill something :)

Jay

-Original Message-
Sent: Friday, October 11, 2002 12:36 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


I suggest reviewing James Morle's paper 'Sane SAN' at
http://www.oraperf.com/whitepapers.html. 

- Kirti 

-Original Message-
Sent: Friday, October 11, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


I obviously left out a lot of information :).

We would be using server partitioning, with seperate ORACLE_HOMES for each
database (necessary since we have a variety of versions running).

The box would be running 1+0, the Sun reps suggest striping across all disks
(my first red flag).

I hadn't even thought of the problem of not being able to reboot the server,
that's an excellent point.

Currently we have absolutely no performance problems on our OLTP database.
This whole kerfuffle was an outgrowth of my pushing really hard to get a
backup box for our datawarehouse (which currently has no standby, no box
that it can restored to and no QA box).  The suggestion was made that rather
than get a separate box for the datawarehouse - get the 15K and have the
OLTP and datawarehouse on different partitions.  This would certainly speed
up the data transfer between them (data is transferred from OLTP -> Data
Warehouse on a daily basis).  We could then put other databases that access
my databases on other partitions (several other databases have snapshots on
some of my tables).  

So this would make some processes more efficient, but i/o on my OLTP
database is currently tuned so well that it hurts every time I think of
giving it up.  One spindle has the Oracle executables with the redo logs on
the outside of the disk.  Another has the various .dat files, shell scripts,
etc, with the archive logs on the outside of the disk.   Even when we run
really intensive updates our wio rarely gets very high.

Regarding the load question: We have fairly active transaction activity
during the day but most connections are managed by Microsoft Transaction
Server in a middle tier so while there are usually app. 200 sessions
(including some old client server apps) we rarely have more than 20 or so
active at any one time.

The datawarehouse has fewer sessions but often has some resource intensive
queries running.

If anyone can point me to docs/websites saying that a large caches does
*not* make up for fewer disks/spindles I would greatly appreciate it.
Currently I'm being told that Sun must know what they're talking about.


Thanks again,
Jay Miller






-Original Message-
Sent: Wednesday, October 09, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Others have addressed the performance issues.

What about the admin issues?

If consolidate to a single server, consider a separate
ORACLE_HOME for each database.  You may need
to apply different patches to fix different problems in
various databases. 

You have this ability now, but will lose it if you consolidate
without separate ORACLE_HOME's.

Something else you will lose is the ability to reboot the
server if needed for a single database.

Since you may be moving to a 15k, investigate server
partitioning to retain this functionality. 

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/09/2002 11:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Advice needed on move to Sun 15K (losing spindles)


 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issues because there will be a large cache.
 
I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
could then at least seperate the redo logs from the datafiles (probably
putting them with the oracle executables and some other files).
 
The Sun rep kept talking up how much more powerful the CPUs were and I 
kept
saying, "but we're not CPU bound, we don't need any more CPU".
 
If anyone can either
 
a) tell me I'm worrying for nothing
b) recommend a better way to stripe/distribute my files
c) provide references  or experience to show this is a bad idea
 
I'd really appreciate it. 
 
 
Thanks,
Jay Miller 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

Yes, it's entirely separate CPUs and disks.  If I can believe the Sun rep
(ehem) there should be no interference.

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


Jay - Will your server partitioning protect the OLTP users from the DW
queries? In the normal situation, a company first adds their DW to an
existing system. Then they find that the DW doesn't make a good neighbor and
buy a separate server. The DW typically does a LOT of full-table scans, so
if you share disks, that may not be good for your OLTP.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, October 11, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


I obviously left out a lot of information :).

We would be using server partitioning, with seperate ORACLE_HOMES for each
database (necessary since we have a variety of versions running).

The box would be running 1+0, the Sun reps suggest striping across all disks
(my first red flag).

I hadn't even thought of the problem of not being able to reboot the server,
that's an excellent point.

Currently we have absolutely no performance problems on our OLTP database.
This whole kerfuffle was an outgrowth of my pushing really hard to get a
backup box for our datawarehouse (which currently has no standby, no box
that it can restored to and no QA box).  The suggestion was made that rather
than get a separate box for the datawarehouse - get the 15K and have the
OLTP and datawarehouse on different partitions.  This would certainly speed
up the data transfer between them (data is transferred from OLTP -> Data
Warehouse on a daily basis).  We could then put other databases that access
my databases on other partitions (several other databases have snapshots on
some of my tables).  

So this would make some processes more efficient, but i/o on my OLTP
database is currently tuned so well that it hurts every time I think of
giving it up.  One spindle has the Oracle executables with the redo logs on
the outside of the disk.  Another has the various .dat files, shell scripts,
etc, with the archive logs on the outside of the disk.   Even when we run
really intensive updates our wio rarely gets very high.

Regarding the load question: We have fairly active transaction activity
during the day but most connections are managed by Microsoft Transaction
Server in a middle tier so while there are usually app. 200 sessions
(including some old client server apps) we rarely have more than 20 or so
active at any one time.

The datawarehouse has fewer sessions but often has some resource intensive
queries running.

If anyone can point me to docs/websites saying that a large caches does
*not* make up for fewer disks/spindles I would greatly appreciate it.
Currently I'm being told that Sun must know what they're talking about.


Thanks again,
Jay Miller






-Original Message-
Sent: Wednesday, October 09, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Others have addressed the performance issues.

What about the admin issues?

If consolidate to a single server, consider a separate
ORACLE_HOME for each database.  You may need
to apply different patches to fix different problems in
various databases. 

You have this ability now, but will lose it if you consolidate
without separate ORACLE_HOME's.

Something else you will lose is the ability to reboot the
server if needed for a single database.

Since you may be moving to a 15k, investigate server
partitioning to retain this functionality. 

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/09/2002 11:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Advice needed on move to Sun 15K (losing spindles)


 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issues because there will be a large cache.
 
I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
could then at least seperate the redo logs from the datafiles (probably
putting them with the oracle executables and some other files).
 
The Sun rep kept talking up how much more powerful the CPUs were and I 
kept
saying, "but we're not CPU bound, we don't need any more CPU".
 
If anyone can either
 
a) tell me I'm worrying for nothing
b) recommend a better way to stripe/distribute my files
c) provide references  or experience to show this is a bad idea
 
I'

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

Thanks, I'm reading the first one now.

Jay

-Original Message-
Sent: Friday, October 11, 2002 3:19 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Well, there are Gaja's papers : "Proactive Storage Management - A Method to
Predictable System Performance", and "Implementing RAID on Oracle systems"
available at http://www.quest.com/whitepapers. Scan the page for Title and
for not Gaja's name. 


- Kirti 

-Original Message-
Sent: Friday, October 11, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L


Thanks Kirti!

I loved the line "The first thing to do, regardless of platform or claims by
the vendor, is to completely forget the existence of a cache"

Any similar references will be greatly appreciated.  The more ammunition I
have the likelier I am to kill something :)

Jay

-Original Message-
Sent: Friday, October 11, 2002 12:36 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


I suggest reviewing James Morle's paper 'Sane SAN' at
http://www.oraperf.com/whitepapers.html. 

- Kirti 

-Original Message-
Sent: Friday, October 11, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


I obviously left out a lot of information :).

We would be using server partitioning, with seperate ORACLE_HOMES for each
database (necessary since we have a variety of versions running).

The box would be running 1+0, the Sun reps suggest striping across all disks
(my first red flag).

I hadn't even thought of the problem of not being able to reboot the server,
that's an excellent point.

Currently we have absolutely no performance problems on our OLTP database.
This whole kerfuffle was an outgrowth of my pushing really hard to get a
backup box for our datawarehouse (which currently has no standby, no box
that it can restored to and no QA box).  The suggestion was made that rather
than get a separate box for the datawarehouse - get the 15K and have the
OLTP and datawarehouse on different partitions.  This would certainly speed
up the data transfer between them (data is transferred from OLTP -> Data
Warehouse on a daily basis).  We could then put other databases that access
my databases on other partitions (several other databases have snapshots on
some of my tables).  

So this would make some processes more efficient, but i/o on my OLTP
database is currently tuned so well that it hurts every time I think of
giving it up.  One spindle has the Oracle executables with the redo logs on
the outside of the disk.  Another has the various .dat files, shell scripts,
etc, with the archive logs on the outside of the disk.   Even when we run
really intensive updates our wio rarely gets very high.

Regarding the load question: We have fairly active transaction activity
during the day but most connections are managed by Microsoft Transaction
Server in a middle tier so while there are usually app. 200 sessions
(including some old client server apps) we rarely have more than 20 or so
active at any one time.

The datawarehouse has fewer sessions but often has some resource intensive
queries running.

If anyone can point me to docs/websites saying that a large caches does
*not* make up for fewer disks/spindles I would greatly appreciate it.
Currently I'm being told that Sun must know what they're talking about.


Thanks again,
Jay Miller






-Original Message-
Sent: Wednesday, October 09, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Others have addressed the performance issues.

What about the admin issues?

If consolidate to a single server, consider a separate
ORACLE_HOME for each database.  You may need
to apply different patches to fix different problems in
various databases. 

You have this ability now, but will lose it if you consolidate
without separate ORACLE_HOME's.

Something else you will lose is the ability to reboot the
server if needed for a single database.

Since you may be moving to a 15k, investigate server
partitioning to retain this functionality. 

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/09/2002 11:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Advice needed on move to Sun 15K (losing spindles)


 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issues because there will be a large cache.
 
I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
could then at least seperate the redo logs from t

RE:

[Miller, Jay]

That's DROP USER user_name CASCADE;
 
Jay Miller

-Original Message-
Sent: Tuesday, October 22, 2002 6:49 AM
To: Multiple recipients of list ORACLE-L


You can do a 
 
DELETE USER User_Name CASCADE;
 
But this will get rid of a whole schema.
 
Dave

-Original Message-
Sent: Tuesday, October 22, 2002 4:33 AM
To: Multiple recipients of list ORACLE-L





What is the syntax to delete multiple objects, or more specifically multiple
tables from a user in 1 go.

I need to delete 50+ tables/objects without deleting them 1 by 1.

 

Thanks

 

Clint

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

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

RE: Creating new user

[Miller, Jay]

He mentions checking /oracle/bin, not $ORACLE_HOME/bin.

Santosh: If this is a Windows environment (as it seems to be) you can check
the Registry Editor for the value of ORACLE_HOME (it should be under
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE)

-Original Message-
Sent: Tuesday, October 22, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L


Probably he is not in %ORACLE_HOME%/bin directory.

A 'Find' for imp* on all drives would tell where it is hiding..

- Kirti 

-Original Message-
Sent: Tuesday, October 22, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


Not really. dir imp* will list all files which start with 'imp'

so it will list imp.exe, imp80.exe, imp.log etc

But I'm clueless as to why there is nothing like imp or imp80 in the
%oracle_home%/bin. Use some other machine to do the import, is the only
solution i can offer

Regards
Naveen

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


If it is windows, you'll have to use dir imp*.* to capture those with
extensions of .exe

Phil Wilson  ([EMAIL PROTECTED])
DBA,  Operations Group
SkillSoft, Learning Solutions for the Human Enterprise
506.462.1124(w)
506.447.0334(c)


-Original Message-
Sent: Tuesday, October 22, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L

What kind of client do you have?
Maybe the install installed only net8 without the utilities?

Check if you have exp*.

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


> but my friend...
> i gave the command "dir imp*" and there are no files found... so now where
> and how and what do i use my imagination
>
> santosh
>
> -Original Message-
> Sent: Tuesday, October 22, 2002 6:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> There were imp73 and imp80 for appropriate versions, I don't know about
more
> recent ones
> Use your imagination, friend! :-)
>
> Gints Plivna,
> Softex Latvia,
> Tel. 7204520
> Fax 7204260
> http://www.softex.lv
> -Original Message-
> Sent: otrdiena, 2002. gada 22. oktobri 15:19
> To: Multiple recipients of list ORACLE-L
>
> thanks ...but still
>
> i gave imp command on command prompt..
> but it tells imp not found...
> and i checked the path also...i have given f:\oracle\bin as the path
> and there are no imp* files in oracle/bin.
>
> any ideas ?
> santosh
>
> -Original Message-
> Nahata
> Sent: Tuesday, October 22, 2002 5:40 PM
> To: Multiple recipients of list ORACLE-L
> SQL> CREATE USER  IDENTIFIED BY  [DEFAULT TABLESPACE
>  TEMPORARY TABLESPACE ]
>
> for importing on command prompt
>
> imp username/password@database fromuser= touser=
> file=
>
> If you just want the table structure and no data then use ROWS=N option
too.
>
> regards
> Naveen
> -Original Message-
> Sent: Tuesday, October 22, 2002 5:14 PM
> To: Multiple recipients of list ORACLE-L
> how to create a new user ? in oracle 8.1.7 ?
> and i want to import a dump file into that user so that i could create the
> tables. How to acheive this ?
>
> any help will be appreciated.
> Thanks and regards,
>
> Santosh
>

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

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

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

RE:

[Miller, Jay]

That's the sort of thing that drove me crazy when I took the Certification
exam.

Niggling syntax issues that you'd figure out as soon as you typed the wrong
command in... ;)

Jay

-Original Message-
Sent: Tuesday, October 22, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


Doh, my bad.  Send me to my room with no supper.

-Original Message-
Sent: Tuesday, October 22, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L


That's DROP USER user_name CASCADE;
 
Jay Miller

-Original Message-
Sent: Tuesday, October 22, 2002 6:49 AM
To: Multiple recipients of list ORACLE-L


You can do a 
 
DELETE USER User_Name CASCADE;
 
But this will get rid of a whole schema.
 
Dave

-Original Message-
Sent: Tuesday, October 22, 2002 4:33 AM
To: Multiple recipients of list ORACLE-L





What is the syntax to delete multiple objects, or more specifically multiple
tables from a user in 1 go.

I need to delete 50+ tables/objects without deleting them 1 by 1.

 

Thanks

 

Clint

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

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

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

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

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

Thank you very much!

I can tell what I'll be reading this weekend :).  With highlighter in
hand...


Jay

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


Check out www.hotsos.com/dnloads/1.Littlefield2000.01.03-Specs.pdf,
written a couple of years ago by Jim Littlefield of Real Networks.


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

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


-Original Message-
Jay
Sent: Friday, October 11, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L

Thanks Kirti!

I loved the line "The first thing to do, regardless of platform or
claims by
the vendor, is to completely forget the existence of a cache"

Any similar references will be greatly appreciated.  The more ammunition
I
have the likelier I am to kill something :)

Jay

-Original Message-
Sent: Friday, October 11, 2002 12:36 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


I suggest reviewing James Morle's paper 'Sane SAN' at
http://www.oraperf.com/whitepapers.html. 

- Kirti 

-Original Message-
Sent: Friday, October 11, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


I obviously left out a lot of information :).

We would be using server partitioning, with seperate ORACLE_HOMES for
each
database (necessary since we have a variety of versions running).

The box would be running 1+0, the Sun reps suggest striping across all
disks
(my first red flag).

I hadn't even thought of the problem of not being able to reboot the
server,
that's an excellent point.

Currently we have absolutely no performance problems on our OLTP
database.
This whole kerfuffle was an outgrowth of my pushing really hard to get a
backup box for our datawarehouse (which currently has no standby, no box
that it can restored to and no QA box).  The suggestion was made that
rather
than get a separate box for the datawarehouse - get the 15K and have the
OLTP and datawarehouse on different partitions.  This would certainly
speed
up the data transfer between them (data is transferred from OLTP -> Data
Warehouse on a daily basis).  We could then put other databases that
access
my databases on other partitions (several other databases have snapshots
on
some of my tables).  

So this would make some processes more efficient, but i/o on my OLTP
database is currently tuned so well that it hurts every time I think of
giving it up.  One spindle has the Oracle executables with the redo logs
on
the outside of the disk.  Another has the various .dat files, shell
scripts,
etc, with the archive logs on the outside of the disk.   Even when we
run
really intensive updates our wio rarely gets very high.

Regarding the load question: We have fairly active transaction activity
during the day but most connections are managed by Microsoft Transaction
Server in a middle tier so while there are usually app. 200 sessions
(including some old client server apps) we rarely have more than 20 or
so
active at any one time.

The datawarehouse has fewer sessions but often has some resource
intensive
queries running.

If anyone can point me to docs/websites saying that a large caches does
*not* make up for fewer disks/spindles I would greatly appreciate it.
Currently I'm being told that Sun must know what they're talking about.


Thanks again,
Jay Miller






-Original Message-
Sent: Wednesday, October 09, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Others have addressed the performance issues.

What about the admin issues?

If consolidate to a single server, consider a separate
ORACLE_HOME for each database.  You may need
to apply different patches to fix different problems in
various databases. 

You have this ability now, but will lose it if you consolidate
without separate ORACLE_HOME's.

Something else you will lose is the ability to reboot the
server if needed for a single database.

Since you may be moving to a 15k, investigate server
partitioning to retain this functionality. 

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/09/2002 11:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:Advice needed on move to Sun 15K (losing
spindles)


 Our  CIO  has  suggested that we get a Sun 15K to house all of our
databases.  This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
 
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
vendor (Sun) was recommending striping across all 4 spindles. He said we
don't need to worry about i/o issue

RE: Advice needed on move to Sun 15K (losing spindles)

[Miller, Jay]

Fortunately my SA believes that so we were able to present a united front at
the presentation (and yes, the Sun rep said that with a large enough cache
RAID 5 works just as well as 1+0 - which is what we would be using).

Jay Miller

-Original Message-
Sent: Friday, October 11, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L



One thing that should be made clear: Never, ever, stripe with parity (i.e.
RAID 5, etc.) unless you are force, at gunpoint, to do it.  That is BAD.
Your database will run faster on an abacus ... well ... maybe a slide rule.


> -Original Message-
> 
> Yes, it's entirely separate CPUs and disks.  If I can believe 
> the Sun rep
> (ehem) there should be no interference.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

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

RE: admin_restrictions_listener

[Miller, Jay]

Although if you set the lsnrctl to 700 that problem goes away (that's what
we did).  I'm still amazed that it's world executable.

Jay Miller

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


yup.  i can run "lsnrctl" from my laptop somewhere on your network and
"stop" the listener otherwise...

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


> hi all
>
> I have my listener.ora owned by the oracle owner with 600 permissions and
> admin_restrictions_listener set.
> On a machine in the DMZ.
> Is there any point in having a password as well?
>
> thanks
> trevor
>
>
>
>
>
> Disclaimer.
>
> This e-mail is private and confidential. If you are not the intended
> recipient, please advise us by return e-mail immediately, and delete
> the e-mail and any attachments without using or disclosing the
> contents in any way. The views expressed in this e-mail are those
> of the author, and do not represent those of this company unless
> this is clearly indicated.
>
> You should scan this e-mail and any attachments for viruses.
>
> This company accepts no liability for any direct or indirect
> damage or loss resulting from the use of any attachments to this e-mail.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: admin_restrictions_listener

[Miller, Jay]

Ah, you're right of course.  

I'm so used to doing everything from telnet sessions (even from my laptop)
that I forgot it's possible to have the software locally.  And of course
I've made the mistake you mention (only once!) so I should have realized it.

Jay 

-Original Message-
Sent: Thursday, October 17, 2002 2:11 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Importance: High


Jay,

That doesn't solve the problem.

What Tim was referring to was executing the copy of lsnrctl that
exists on his laptop.

I recall a DBA doing this accidentally at a previous job.  He copied
the listener.ora file to another server, then ran 'lsnrctl stop' before
modifying the file for the new server.

Guess what happened?

Jared





"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/17/2002 11:29 AM
 Please respond to ORACLE-L

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


Although if you set the lsnrctl to 700 that problem goes away (that's what
we did).  I'm still amazed that it's world executable.

Jay Miller

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


yup.  i can run "lsnrctl" from my laptop somewhere on your network and
"stop" the listener otherwise...

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


> hi all
>
> I have my listener.ora owned by the oracle owner with 600 permissions 
and
> admin_restrictions_listener set.
> On a machine in the DMZ.
> Is there any point in having a password as well?
>
> thanks
> trevor
>
>
>
>
>
> Disclaimer.
>
> This e-mail is private and confidential. If you are not the intended
> recipient, please advise us by return e-mail immediately, and delete
> the e-mail and any attachments without using or disclosing the
> contents in any way. The views expressed in this e-mail are those
> of the author, and do not represent those of this company unless
> this is clearly indicated.
>
> You should scan this e-mail and any attachments for viruses.
>
> This company accepts no liability for any direct or indirect
> damage or loss resulting from the use of any attachments to this e-mail.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: Adhoc queries and limiting the amount of records queried...

[Miller, Jay]

Aside from severely restricting access to analysts who need to investigate
problems in production data we limit the CPU time in their profile to 5
minutes.  That's a pretty generous limit and they've never had any issues
with it.

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



I just wanted to ping the list to see what other people have done to control
or constrain adhoc query users??? 

We have a group that is struggling with the adhoc query piece that's in
production.  Some of the users end up firing off insane queries.  The group
is trying to find a way to limit the amount of records queried for, so that
a wild query doesn't hose the database.

Appending a ROWNUM to the WHERE clause is one idea.  Using USER PROFILEs is
another.  Any other thoughts?? 

Dare I ask...this custom app also runs on SQL Server, so SQL Server ideas
would also be appreciated. 

Many thanks!!! 

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

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

RE: Data guard

[Miller, Jay]

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

Jay Miller

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


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





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

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

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

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

Auditing grant and revoke privileges

[Miller, Jay]

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

audit grant on default; 

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

I issued the following commands: 

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

Table created. 

SQL> grant select on testjay to wsidba; 

Grant succeeded. 

SQL> revoke select on testjay from wsidba; 

Revoke succeeded. 

This resulted in the following entries: 

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

I'm not clear on 

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

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


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


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

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

RE: Help in Training on DBA

[Miller, Jay]

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

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

Jay Miller

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


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

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

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

Thank you once again,

Aleem


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

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

Regards,

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

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

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

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

RE: Database design, replacing null by a default value

[Miller, Jay]

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

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

How about 'null' for the varchar2 column?

Jay Miller

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


Hi,

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

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

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

TIA

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

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

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

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

RE: Defragmentation of tablespace

[Miller, Jay]

Also, if you do move to a new tablespace please consider moving to uniform
extents which will remove any need to defragment in the future (I assume
you're doing it because of wasted space in the tablespace and not because of
the now-discredited notion that it's bad to have many extents for a
particular segment?).

Check out the paper "How to stop defragmenting and start living".  It
changed my life many years ago.  Well, my life as a DBA anyway :)

Jay Miller

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




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

The two methods that come to mind are:

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

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

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

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

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

RE: LOCALLY MANAGED TABLESPACE

[Miller, Jay]

Very, very lucky.
 
I've been trying to get permission to move just my temporary tablespace to
locally managed for months.  My boss' boss refuses to give the okay until
after our standby database is moved to a new location (if anyone can explain
why those two things are related in any way I'd be overjoyed).
 
And yes, I pointed out that every other database (either new or migrated
before DBA responsibilities got shifted to someone who knows nothing about
databases) has been using locally managed tablespaces and that our QA and QC
testing went perfectly.
 
 
 
Jay Miller
 
 

 
 -Original Message-
Sent: Friday, October 25, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L


You are lucky, very lucky...

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


Pardon the ignorance, I'm simply trying to understand... What is meant by
"management" in this context? I'm can't imagine a circumstance under which
ANY business manager would have a say on what goes on in the black box
called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can
see the input on those issues. But, all the way down to extent management??
Or am I simply lucky to not have that level of bureaucracy?
 

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC


-Original Message-
Sent: Friday, October 25, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L



Same here

 

Getting management to first understand the extent issue on Dictionary
managed was a interesting exercise. Now trying to break that understanding
down when wanting to use LMT is like double the work, painful.

 

Difficult thing trying to educate them enough to understand something but
not leaving at the same time halve way where you start getting these
interesting architecture decisions or ideas.

 

George



George Leonard

Oracle Database Administrator

Dimension Data (Pty) Ltd

(Reg. No. 1987/006597/07)

Tel: (+27 11) 575 0573

Fax: (+27 11) 576 0573

E-mail:[EMAIL PROTECTED]

Web:   http://www.didata.co.za <http://www.didata.co.za> 

 

You Have The Obligation to Inform One Honestly of the risk, And As a Person

You Are Committed to Educate Yourself to the Total Risk In Any Activity!

Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!

-Original Message-
Sent: 25 October 2002 13:04 PM
To: Multiple recipients of list ORACLE-L

 

The only issue we faced was convincing the management that in LMT having 150
extents is not really a problem. 

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

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

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

 

Hi 
I am thinking to change our few dictinary manages tablespace to locally 
managed tablespace.Can any one experienced any issues with locally managed 
tablespace? 
Do any one experience what gain after changing to locally managed 
tablespace? 

Thx 
-Seema 

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

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

RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

[Miller, Jay]

I had a similar problem once and it ended up being that a disk was in the
process of starting to fail but hadn't completely failed (and therefore
didn't fail over to the mirror).

This didn't show up in any Solaris logs until *after* the server had been
rebooted, the database had been restarted and then the database was shut
down again.  We did see some aiowait errors in the alert log though.

Jay Miller

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


Hi all,

Jared you are right...

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

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

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

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


Sinardy




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


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

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

Jared





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

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



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

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

Brian



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




Reboot and open a TAR.

Jared





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


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


Hi,

I am using solaris 8


Sinardy

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


Hi all,

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

because of this my cluster fail to failover

Thanks

Sinardy




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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE your

CLOB inserts

[Miller, Jay]

One of my developers is testing a process that reads a CLOB, modifies it,
and inserts it to another table.  The reading and modifying goes very
quickly, but the inserts take a long time.  Looking at the main Wait Events
I'm seeing a lot of direct path read (lob) and direct path write (lob) which
seems to imply that a lot of the delay is i/o related.
 
Does anyone have any suggestions to speed up the inserts?  The developer has
been playing around with chunk size but without any improvement.
 
Oracle 8.1.7.2
Solaris 2.6
 
Here are the main wait events from statspack.  The SQL*Net message from
dblink is from a different process that was running at the same time:
 
SQL*Net message from dblink   381,218  0   0 0
689.4
SQL*Net message to dblink 381,216  0   0 0
689.4
db file scattered read 11,034  0   0 0
20.0
direct path read (lob)  1,233  0   0 0
2.2
log file parallel write   696  0   0 0
1.3
direct path write (lob)   548  0   0 0
1.0
db file sequential read   217  0   0 0
0.4
db file parallel write170  0   0 0
0.3
control file parallel write   161  0   0 0
0.3
 
 
Thanks,
Jay Miller
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

RE: System Tablespace and Autoextend

[Miller, Jay]

I've been running with autoextend on (though limited to 2Gig) and never had
a problem.  

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


I run my SYSTEM tablesaces in autoextend, and have for some time. I run them
that way from the point of database creation and have never had a problem.
There were some problems with autoextend in earlier versions of 8 (and I
think they managed to migrate to early 8i versions as well) with 2GB
boundaries, but those have all been corrected.

RF

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

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

 



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


Sam - 
   I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack of space in the system tablespace. With
other tablespaces you can always rebuild the tablespace if you need to.

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


-Original Message-
Sent: Thursday, October 24, 2002 1:27 PM
To: Multiple recipients of list ORACLE-L


Hello All,

I have heard several times that if the SYSTEM tablespace runs out of space
and needs to autoextend (assuming autoextend is turned on for the data
file), then you run the risk of the database crashing and of data dictionary
corruption.  I have never personally encountered this problem, so I have no
experience on what actually does happen.

I looked in metalink for documents on this, but turned up nothing.  Does
anybody have experience on the dangers of allowing the SYSTEM tablespace to
autoextend and also any documents on Metalink or OTN that describe this
problem? 

We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2.  All our Oracle
versions are running on Windows NT (or Windows 2000).

Thanks for any feedback.

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

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

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

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

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

RE: Data Purging Strategy

[Miller, Jay]

FWIW, what we just implemented (because senior management refuses to approve
additional storage on the grounds that "making the database larger will
affect performance" - aaargh!) is 

1) Confirmed with business how long data needs to be online for various
tables (they're all partitioned so that makes it a lot easier)
2) Export partitions older than that once/month (this is generated off a
table that lists each partitioned table and how long data should be kep)
3) After confirming that all export files are valid we drop the old
partitions (this will be done by script but is being done manually for the
first few months)
4) Leave dmp files on server for 2 end of months (our end of month backup
tapes are stored for 7 years)
5) Maintain a table in database saying what exported partitions are on what
date's tapes


And I really long for the days in this company when senior management made
technical decisions by asking the technical people instead of just making
things up...

Jay Miller


-Original Message-
Sent: Wednesday, November 06, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Someone asked about this 3 weeks ago.  Here's my take
on archiving data.  I don't expect everyone to agree with this,
but nonetheless,  I have an opinion.   :)

Here's an email from last month.  You can undoubtedly find
some other ideas on this by searching the archives of this
list at fatcity.com

Jared

==

I'm not a proponent of purging data.

Unless of course, you expect to never see it again.

That word 'archive' rolls of the tongues of managers
and consultants pretty easily, but what's behind it?

There are a few gotchas with purging and archiving.

Let's assume you have some 3 year old data that 
you need to see again, and it has been purged.

Here are some of the possible problems:

*  Your backup tapes are corrupted
*  Your new backup hardware can't read the old tapes
*  Your software no longer understands the format that
the data is in.
* You have the correct software, but it won't work on the
   current version of OS on your hardware.
* The data format/software/whatever is not well documented
*  The employees that understood the data 3 years ago
   have been laid off.
* ... lots more stuff

Read Bryon Bergeron's "Dark Ages II: When the Digital Data Die"
http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0

Perhaps much better than archiving the data, is to stick with the
idea of moving it to another database, and using lots of cheap
disk storage (NAS) or a heirarchical file system to store it.

The point being that if it's online somewhere, it will be maintained.

Don't purge it till Finance, HR, the IRS and any other stakeholder
says it's ok.  Only then purge it and archive it to offline tape with the
knowledge that you may never see that data again.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/06/2002 01:13 AM
 Please respond to ORACLE-L

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



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but 
then at a later time, some user might request for this purged data. So it 
must be possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database 
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to 
moved to tapes. Now my question, how can we move this data to tapes and at 
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be 
possible to retrieve data from the tapes based on a date and load it to 
the database tables. 

Regards 
Prem 

 


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

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

Fat City Network Serv

RE: Can any one tell me how can i read parameter info from RDF(Re

[Miller, Jay]

You'll have to open the report using Oracle Developer (Reports).  If it is
on Unix I usually ftp it to my local workstation and open it there.
 
Jay Miller
x48355

-Original Message-
Sent: Tuesday, November 05, 2002 1:13 AM
To: Multiple recipients of list ORACLE-L
definition file)


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

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

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

RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

[Miller, Jay]

You don't need to rebuild when a datafile is added.  Once the recovery fails
you just issue the create datafile command on the standby.

Jay Miller

-Original Message-
Sent: Tuesday, November 05, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
2k


First off, your process is doing a lot of unnecessary work.

Standby databases are available in 7.3.4.  I believe that
would be somewhat simpler than your current procedure.

I haven't tried it though, so I could be wrong.

Even with your current procedure, you don't need to copy
all of the files, most of the time anyway.

Build your standby database, put it in recovery mode, and 
just keep applying archive log files to it.

You may need to rebuild when a datafile is added to a 
tablespace, not sure.

In 8i, why not just use standby database?

Jared





"Arif Khan (GWL)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/05/2002 06:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Clone Production Server to Stand by Server on 8.1.7
on Win 2k


Hello

We currently have two Identical servers (identical in terms of both 
Hardware
and SW).
We run Oracle 7.3.4.0 (Workgroup server) on Win NT 4 on both the servers. 
We
call them as Production Server and Stand by server. The Stand by server is
passive in nature (i.e. does not do anything). Every night a batch process
shuts down Oracle instance on both the machines and copies over all the
files (Data, log, ctl etc) from Production Server to the Stand by server
(Drive to drive, directory to directory...)

In case the Production Server fails, we simply switch over the users (with 
a
different alias to the stand by server) and they are back in business.

Now, we are thinking of migrating to 8.1.7, however while trying to 
install
this version, one needs to specify a Global name which I believe has to be
unique on the network. So will the same process that I used to run (i.e.
copy all files over from production to stand by ) work??? I guess both my
servers will now have to have separate/unique Global Names. 

Is there any other approach that any of you can suggest??? 

TIA
Arif
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arif Khan (GWL)
  INET: [EMAIL PROTECTED]

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



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

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

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

RE: Data Purging Strategy

[Miller, Jay]

 


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

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

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

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

RE: Destination address unreachable

[Miller, Jay]

Hmm, the same way 8.0.1 was stable, and 8.1.5 was stable, and...?

-Original Message-
Sent: Friday, November 08, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L


So, in my opinion, Oracle really has no choice but to pursue the course that
it is. I think they have learned some lessons down the road, and I'm willing
to bet that 10.0.1 (or whatever) will be far more stable than 9.0.1 was.

RF

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

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

 

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

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

RE: System Tablespace and Autoextend

[Miller, Jay]

Actually, SYSTEM is one of the only tablespaces I like to have it set on.
While I originally set it to autoextend when I was doing an upgrade I left
it active on the grounds that while I know how to recover if by some chance
one of my datafiles runs out of space, I'm uncertain as to the implications
of SYSTEM needing to extend and failing.

-Original Message-
Sent: Thursday, November 07, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


I use AUTOEXTEND and it has been extremely helpful to me in managing growth.

However, my policy is not to use autoextend for SYSTEM, rollback tablespace,

or temp tablespace.  

SYSTEM (for me) is relatively stable.  The only time I have significant
growth
in SYSTEM is during an upgrade.  For rollback and temp tablespaces, I don't 
want to throw away diskspace on "unreasonable" or "abnormal" usage.  If I
grow
these spaces, I've made certain that it is necessary.

Kip Bryant  

|FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM
|tablespace.
|(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe
on
|dev and sandbox databases).
|If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM
|rollback) or temporary segments and the auditing information is written to
|it's own tablespace then I can't think of a set of circumstances that would
|cause the SYSTEM tablespace to rapidly fill up.
|System upgrade/migrations are the exception to this rule but in general a
|DBA would plan ahead for those occasions anyway.

|-Original Message-
|Sent: Thursday, November 07, 2002 4:29 PM
|To: Multiple recipients of list ORACLE-L


|I've been running with autoextend on (though limited to 2Gig) and never had
|a problem.

|-Original Message-
|Sent: Thursday, October 24, 2002 5:26 PM

|I run my SYSTEM tablesaces in autoextend, and have for some time. I run
them
|that way from the point of database creation and have never had a problem.
|There were some problems with autoextend in earlier versions of 8 (and I
|think they managed to migrate to early 8i versions as well) with 2GB
|boundaries, but those have all been corrected.

|RF

|Robert G. Freeman - Oracle OCP
|Oracle Database Architect
|CSX Midtier Database Administration



|-Original Message-
|Sent: Thursday, October 24, 2002 4:46 PM

|Sam -
|   I haven't made the system tablespace autoextend because I can't easily
|recover the space if it overextends. I would rather take the risk that
|something hits an error from a lack of space in the system tablespace. With
|other tablespaces you can always rebuild the tablespace if you need to.

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


|-Original Message-
|Sent: Thursday, October 24, 2002 1:27 PM

|Hello All,

|I have heard several times that if the SYSTEM tablespace runs out of space
|and needs to autoextend (assuming autoextend is turned on for the data
|file), then you run the risk of the database crashing and of data
dictionary
|corruption.  I have never personally encountered this problem, so I have no
|experience on what actually does happen.

|I looked in metalink for documents on this, but turned up nothing.  Does
|anybody have experience on the dangers of allowing the SYSTEM tablespace to
|autoextend and also any documents on Metalink or OTN that describe this
|problem?

|We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2.  All our
Oracle
|versions are running on Windows NT (or Windows 2000).

|Thanks for any feedback.

|Sam Bootsma, OCP
|[EMAIL PROTECTED]
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Hately, Mike (NESL-IT)
|  INET: [EMAIL PROTECTED]

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

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

10046 Level 8 Trace file disappeared

[Miller, Jay]

After playing around with this in development for a while I just tried
setting Event 10046, Level 8 trace on a production process that was taking
too long to run.
 
Everything went smoothly, the trace file was being written to, when suddenly
the trace file disappeared.  The last time I checked it was a little over 2
Meg but I had max file size set to 2 Gig.  All the space was freed up
according to df -k.
 
I tried setting the event to level 0 and back to level 8 but there was still
no trace file.  The session was still running.
 
Here's what I ran:
 
exec sys.dbms_system.set_bool_param_in_session(265, 16097,
'timed_statistics', true);
exec sys.dbms_system.set_int_param_in_session(265, 16097,
'max_dump_file_size', 2147483647);
exec sys.dbms_system.set_ev(265,16097,10046, 8, '');
 
I'm on Oracle 8.1.7.2, Solaris 2.6.
 
Does anyone have any ideas as to what might have happened to my file?
 
 
Thanks,
Jay Miller
x48355
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

RE: Data specs of columns

[Miller, Jay]

Take a look at dba_cons_columns for primary and foreign key constraints

Jay Miller

-Original Message-
Sent: Friday, November 15, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


I have a request from a developer to determine if a column is computed,
has a primary key
has a foreign key.

Im looking through the dictionary tables eg user_tab_columns but these
firlds seem to be elusive.

Any ideas what views  to querry ?
Many thanks
bob

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

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

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

Do user processes apply against shmmax limit?

[Miller, Jay]

Hi everyone,

I was always under the impression that the only concern with shmmax was that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual user processes (i.e.,
the PGA since we're not using multi-threaded server) get added to the SGA
and if that SGA + user processes > shmmax the system will start swapping.

I haven't found anything to specifically address this issue on Metalink so I
though I'd throw it open. We've started experiencing  system slowdown and he
says that increasing shmmax could resolve it. I'm skeptical (he also
suggested increasing SGA to decrease swapping which I told him in no
uncertain terms was nonsense).

If anyone has a link to a note or white paper I'd appreciate that too. 

I've appended his email at the bottom. This slowdown seems to occur even
when there's virtually on oracle activity so I'm suspecting some other
cause.

Thanks,
Jay Miller

 

 
nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This
morning nycsun1 was very slow and I noticed that there was lots of swaping.
see vmstst and iostat below in red:

procs memorypagedisk  faults  cpu
 r b w   swap  free  re  mf pi po fr de sr s2 s4 s4 sd   in   sy   cs us sy
id
 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0  0 1104 3330  974 11  8
81
 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0  0  0  935  847  416  3  1
96
 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183  670 13  4
84
 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065  607 12  6
82
 0 0 23 4362384 96080 1   6  4  8  8 77376 0 0 0  0  0  975  465  457  2  1
97
 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859  734  8  3
89
 0 0 23 4360424 95480 4  41 36 40 100 77376 7 0 0 0  0  986 1250  542  6  0
94
 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0  0  0 1037  942  665  5  3
92
 0 0 23 4359680 95784 2 449  4 28 84 95520 8 0 0  0  0  922 1047  374  4  1
95
 0 0 23 4359936 95464 2 544  4 20 332 95520 44 0 0 0 0  931 1095  384  2  2
96

/s  w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
  0.0  0.00.00.0  0.0  0.00.00.0   0   0 c2t6d0
  0.0 34.50.0  270.0  0.2 13.86.7  399.5   6  44 c5t12d0 -- swap
disk
  0.0 34.50.0  270.0  0.5 10.7   15.5  309.4  18  39 c5t13d0 -- swap
disk


This shows that the system is not effectively using memory. I suggest
increasing the share memory to 4 GB so that DBAs can increase their memory
usage. Also set priority paging on. Priority paging will give application
first priority then free memory will be allocated to file cache( Solaris 2.6
and 7. Solaris 8 is set dynamically).

* ORACLE CONFIGS
set shmsys:shminfo_shmmax  =204800 -- increase to 409600
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=300
set shmsys:shminfo_shmseg=30
set semsys:seminfo_semmap=500
set semsys:seminfo_semmni=200
set semsys:seminfo_semmns=2000
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=150

 

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

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

RE: Do user processes apply against shmmax limit?

[Miller, Jay]

Good morning everyone,

Thanks for confirming my belief.  He was so definite I was starting to doubt
myself (surely a Unix SA must know how the Unix parameters work right?).

And the problem has been tracked down to a bad network switch (so I'm in the
office again today to switch to our standby box while they work on it and
then switch back when they're done).


Jay Miller



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


Jay,

I would suggest that your SA look at the 'w' column under procs. This shows
that _since_ UNIX restart 23 jobs were continuously in the wait queue. Maybe
something starts up on system reboot...

>procs memorypagedisk  
> r b w   swap  free  re  mf pi po fr de sr s2 s4 s4 sd   in   
> 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0  0 1104 
> 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0  0  0  935  
> 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 

Also, could he show you 'sar -q' stats? This should show any swapping (as
opposed to paging).

John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **


>-Original Message-
>From: Miller, Jay [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, November 23, 2002 10:49 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Do user processes apply against shmmax limit?
>
>
>Hi everyone,
>
>I was always under the impression that the only concern with 
>shmmax was that
>it be large enough for the SGA to fit into it. One of my System
>Administrators has just told me that the individual user 
>processes (i.e.,
>the PGA since we're not using multi-threaded server) get added 
>to the SGA
>and if that SGA + user processes > shmmax the system will 
>start swapping.
>
>I haven't found anything to specifically address this issue on 
>Metalink so I
>though I'd throw it open. We've started experiencing  system 
>slowdown and he
>says that increasing shmmax could resolve it. I'm skeptical (he also
>suggested increasing SGA to decrease swapping which I told him in no
>uncertain terms was nonsense).
>
>If anyone has a link to a note or white paper I'd appreciate that too. 
>
>I've appended his email at the bottom. This slowdown seems to 
>occur even
>when there's virtually on oracle activity so I'm suspecting some other
>cause.
>
>Thanks,
>Jay Miller
>
> 
>
> 
>nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share 
>memory. This
>morning nycsun1 was very slow and I noticed that there was 
>lots of swaping.
>see vmstst and iostat below in red:
>
>procs memorypagedisk  
>faults  cpu
> r b w   swap  free  re  mf pi po fr de sr s2 s4 s4 sd   in   
>sy   cs us sy
>id
> 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0  0 1104 
>3330  974 11  8
>81
> 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0  0  0  935  
>847  416  3  1
>96
> 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 
>2183  670 13  4
>84
> 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 
>4065  607 12  6
>82
> 0 0 23 4362384 96080 1   6  4  8  8 77376 0 0 0  0  0  975  
>465  457  2  1
>97
> 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 
>1859  734  8  3
>89
> 0 0 23 4360424 95480 4  41 36 40 100 77376 7 0 0 0  0  986 
>1250  542  6  0
>94
> 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0  0  0 1037  
>942  665  5  3
>92
> 0 0 23 4359680 95784 2 449  4 28 84 95520 8 0 0  0  0  922 
>1047  374  4  1
>95
> 0 0 23 4359936 95464 2 544  4 20 332 95520 44 0 0 0 0  931 
>1095  384  2  2
>96
>
>/s  w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
>  0.0  0.00.00.0  0.0  0.00.00.0   0   0 c2t6d0
>  0.0 34.50.0  270.0  0.2 13.86.7  399.5   6  44 
>c5t12d0 -- swap
>disk
>  0.0 34.50.0  270.0  0.5 10.7   15.5  309.4  18  39 
>c5t13d0 -- swap
>disk
>
>
>This shows that the system is not effectively using memory. I suggest
>increasing the share memory to 4 GB so that DBAs can increase 
>their memory
>usage. Also set priority paging on. Priority paging will give 
>application
>first priority then free memory will be allocated to file 
>cache( Solaris 2.6
>and 7. Solaris 8 is set dynamically).
>
>* ORACLE CONFIGS
>set shmsys:shminfo_shmmax  =2048000000 -- increase to 409600
>set shmsys:shminfo_shmmin=1
>set shmsys:shminfo_shmmni=300
>set shmsys:sh

ORA-1653: unable to extend table - Why?

[Miller, Jay]

Okay, I can't figure this one out.  Earlier this week I got an ORA-1653:
unable to extend table on a really big table.  However this was just after I
had deleted over 2 million rows in the table and we were only inserting
30,000.

After reanalyzing the table I saw the following stats in DBA_TABLES:

num_freelist_blocks:  2266966
avg_space_freelist_blocks: 3895

Unless I'm misreading this I should have had over 8Gig available for
inserts.

We tried the insert again and got the same error so I added a datafile and
it went through (using about 40Meg of space in the new datafile).

Why isn't it making use of the existing blocks on the freelist?

Oracle 8.1.7.2
Solaris 2.6
PCTFREE = 10
PCTUSED = 75
Block Size = 4K


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

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

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

I was told by the department manager that they were neither using a direct
load nor the Append hint.
But the developer is back from vacation today so I'll get a more definite
answer from him.

Thanks,
Jay Miller

-Original Message-
Sent: Friday, November 29, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L


How are the inserts being done?  Are you doing an insert with append hint?

-Original Message-
Sent: Friday, November 29, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Okay, I can't figure this one out.  Earlier this week I got an ORA-1653:
unable to extend table on a really big table.  However this was just after I
had deleted over 2 million rows in the table and we were only inserting
30,000.

After reanalyzing the table I saw the following stats in DBA_TABLES:

num_freelist_blocks:  2266966
avg_space_freelist_blocks: 3895

Unless I'm misreading this I should have had over 8Gig available for
inserts.

We tried the insert again and got the same error so I added a datafile and
it went through (using about 40Meg of space in the new datafile).

Why isn't it making use of the existing blocks on the freelist?

Oracle 8.1.7.2
Solaris 2.6
PCTFREE = 10
PCTUSED = 75
Block Size = 4K


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

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

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

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

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

Okay, I just heard back from the developer.  It was definitely not using
either a Direct load or and Append hint.  Just a regular insert.

Any more ideas?

-Original Message-
Sent: Friday, November 29, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L


Did you insert using direct path ? 
If so the insert inserts after the highwater mark.
The highwater mark is not reinitialized after deletes.
So maybe that's why the insert failed.
 


 --- "Miller, Jay" <[EMAIL PROTECTED]> a
écrit : > Okay, I can't figure this one out.  Earlier
this
> week I got an ORA-1653:
> unable to extend table on a really big table. 
> However this was just after I
> had deleted over 2 million rows in the table and we
> were only inserting
> 30,000.
> 
> After reanalyzing the table I saw the following
> stats in DBA_TABLES:
> 
> num_freelist_blocks:  2266966
> avg_space_freelist_blocks: 3895
> 
> Unless I'm misreading this I should have had over
> 8Gig available for
> inserts.
> 
> We tried the insert again and got the same error so
> I added a datafile and
> it went through (using about 40Meg of space in the
> new datafile).
> 
> Why isn't it making use of the existing blocks on
> the freelist?
> 
> Oracle 8.1.7.2
> Solaris 2.6
> PCTFREE = 10
> PCTUSED = 75
> Block Size = 4K
> 
> 
> Jay Miller
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
>  

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

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

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

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

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L


Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
> 
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
> 
> Have a Happy Thanksgiving.
> 
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
> 
> Richard Ji
> 
> 
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed. 
> 
> 
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> > 
> > Richard Ji
> > 
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > did u coalesced the tablespaces?
> > 
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> > 
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> > 
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> > 
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> > 
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> > 
> > Why isn't it making use of the existing blocks on the freelist?
> > 
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> > 
> > 
> > Jay Miller
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> >

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

r 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Ji
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

 following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Ji
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

d be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.or

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

; >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Ji
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

 be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT s

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

;>One thing I haven't seen mentioned yet is what degree of parallelism is
>>defined for the table?
>>What is the next extent size set to?
>>If the table is paralleled, EACH parallel worker will grab a next extent
>>sized segment. (Been bit by
>>this a few times...)
>>How many indexes and are they in the same tablespace?
>>
>>Ron Thomas
>>Hypercom, Inc
>>[EMAIL PROTECTED]
>>Each new user of a new system uncovers a new class of bugs. -- Kernighan
>>
>>
>> 
>>
>>  JayMiller@TDWater
>>
>>  house.comTo:
>>[EMAIL PROTECTED]
>>
>>  Sent by: cc:
>>
>>  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
>>unable to extend table - Why?
>>
>> 
>>
>> 
>>
>>  12/02/2002 02:04
>>
>>  PM
>>
>>  Please respond to
>>
>>  ORACLE-L
>>
>> 
>>
>> 
>>
>>
>>
>>
>>
>>Yep, I agree that coalescing is irrelevant in my current situation.  In
any
>>event there was no free space until I added the additional datafile but
>>there was the 8gig of space on the freelists.
>>
>>Jay
>>
>>-Original Message-
>>Sent: Friday, November 29, 2002 8:54 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Richard,
>>
>>if pctincrease is zero, and there are a large number of contiguous
>>smaller extents, SMON will not automatically coalesce the tablespace.
>>However, whether or not SMON does an automatic coalesce, if you need an
>>extent that is larger than any of the small ones, Oracle will coalesce
>>those smaller extents to make the one you need. so Jay would not have
>>needed to add a datafile no matter what, if he was not doing a direct
>>path insert.
>>
>>As for meeting in person there is a user group meeting on Dec 12
>>(check www.nyoug.org for details). You can meet me, and more
>>importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
>>Bardeen, also of this list. They are all presenting :)
>>
>>I saw Priscilla about a month ago, haven't talked with her since.
>>
>>Rachel
>>
>>--- Richard Ji <[EMAIL PROTECTED]> wrote:
>>
>>
>>>Rachel,
>>>
>>>What I mean to say is when there are a lot of contiguous smaller free
>>>extents.
>>>Then coalesce will produce a larger free extent so Jay wouldn't have
>>>to
>>>add a datafile for his table to grow.
>>>
>>>On the automatically coalescing part, I believe SMON will only
>>>coalesce
>>>when pctincrease != 0, or has that changed?  My understand could be
>>>outdated.
>>>With LMT one doesn't have to worry about it.
>>>
>>>Have a Happy Thanksgiving.
>>>
>>>PS, I am in New York too, would love to meet you in person some time.
>>> Have
>>>you
>>>talked to Priscilla lately?
>>>
>>>Richard Ji
>>>
>>>
>>>-Original Message-
>>>Sent: Friday, November 29, 2002 5:29 PM
>>>To: Multiple recipients of list ORACLE-L
>>>
>>>
>>>how would coalescing help even if there were a lot of smaller free
>>>extents? Oracle would do the coalesce automatically, there would be
>>>no
>>>difference between manually coalescing or allowing Oracle to do it
>>>when
>>>a new extent was needed.
>>>
>>>
>>>--- Richard Ji <[EMAIL PROTECTED]> wrote:
>>>  
>>>
>>>>Coalescing might help if there are many smaller free extents
>>>>that can be coalesced.  But that still doesn't solve Jay's problem.
>>>>Because he doesn't want the table to extent at all since he just
>>>>deleted
>>>>2 million rows so there are plenty of space within the segment
>>>>itself.
>>>>Those free blocks should be used, unless he is doing a direct path
>>>>insert
>>>>which will only use space above the HWM.
>>>>
>>>>Richard Ji
>>>>
>>>>-Original Message-
>>>>Sent: Friday, November 29, 2002 2:05 PM
>>>>To: Multiple recipients of list ORACLE-L
>>>>
>>>>
>>>>did u coalesced the tablespaces?
>>>>
>>>>-Original Message-
>>>>Sent: sexta-fei

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

> -Original Message-
> Sent: Friday, November 29, 2002 8:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Richard,
> 
> if pctincrease is zero, and there are a large number of contiguous
> smaller extents, SMON will not automatically coalesce the tablespace.
> However, whether or not SMON does an automatic coalesce, if you need an
> extent that is larger than any of the small ones, Oracle will coalesce
> those smaller extents to make the one you need. so Jay would not have
> needed to add a datafile no matter what, if he was not doing a direct
> path insert.
> 
> As for meeting in person there is a user group meeting on Dec 12
> (check www.nyoug.org for details). You can meet me, and more
> importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
> Bardeen, also of this list. They are all presenting :)
> 
> I saw Priscilla about a month ago, haven't talked with her since.
> 
> Rachel
> 
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Rachel,
> >
> > What I mean to say is when there are a lot of contiguous smaller free
> > extents.
> > Then coalesce will produce a larger free extent so Jay wouldn't have
> > to
> > add a datafile for his table to grow.
> >
> > On the automatically coalescing part, I believe SMON will only
> > coalesce
> > when pctincrease != 0, or has that changed?  My understand could be
> > outdated.
> > With LMT one doesn't have to worry about it.
> >
> > Have a Happy Thanksgiving.
> >
> > PS, I am in New York too, would love to meet you in person some time.
> >  Have
> > you
> > talked to Priscilla lately?
> >
> > Richard Ji
> >
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 5:29 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > how would coalescing help even if there were a lot of smaller free
> > extents? Oracle would do the coalesce automatically, there would be
> > no
> > difference between manually coalescing or allowing Oracle to do it
> > when
> > a new extent was needed.
> >
> >
> > --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > > Coalescing might help if there are many smaller free extents
> > > that can be coalesced.  But that still doesn't solve Jay's problem.
> > > Because he doesn't want the table to extent at all since he just
> > > deleted
> > > 2 million rows so there are plenty of space within the segment
> > > itself.
> > > Those free blocks should be used, unless he is doing a direct path
> > > insert
> > > which will only use space above the HWM.
> > >
> > > Richard Ji
> > >
> > > -Original Message-
> > > Sent: Friday, November 29, 2002 2:05 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > did u coalesced the tablespaces?
> > >
> > > -Original Message-
> > > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Okay, I can't figure this one out.  Earlier this week I got an
> > > ORA-1653:
> > > unable to extend table on a really big table.  However this was
> > just
> > > after I
> > > had deleted over 2 million rows in the table and we were only
> > > inserting
> > > 30,000.
> > >
> > > After reanalyzing the table I saw the following stats in
> > DBA_TABLES:
> > >
> > > num_freelist_blocks:  2266966
> > > avg_space_freelist_blocks: 3895
> > >
> > > Unless I'm misreading this I should have had over 8Gig available
> > for
> > > inserts.
> > >
> > > We tried the insert again and got the same error so I added a
> > > datafile and
> > > it went through (using about 40Meg of space in the new datafile).
> > >
> > > Why isn't it making use of the existing blocks on the freelist?
> > >
> > > Oracle 8.1.7.2
> > > Solaris 2.6
> > > PCTFREE = 10
> > > PCTUSED = 75
> > > Block Size = 4K
> > >
> > >
> > > Jay Miller
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Miller, Jay
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> &

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

ll produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> S

RE: ORA-1653: unable to extend table - Why?

[Miller, Jay]

t of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > unable to extend table on a really big table.  However this was
> just
> > after I
> > had deleted over 2 million rows in the table and we were only
> > inserting
> > 30,000.
> >
> > After reanalyzing the table I saw the following stats in
> DBA_TABLES:
> >
> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895
> >
> > Unless I'm misreading this I should have had over 8Gig available
> for
> > inserts.
> >
> > We tried the insert again and got the same error so I added a
> > datafile and
> > it went through (using about 40Meg of space in the new datafile).
> >
> > Why isn't it making use of the existing blocks on the freelist?
> >
> > Oracle 8.1.7.2
> > Solaris 2.6
> > PCTFREE = 10
> > PCTUSED = 75
> > Block Size = 4K
> >
> >
> > Jay Miller
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROT