Re: I need to change the instance name

[Yechiel Adar]

Sorry

I meant to say partitioning is not available in SE - not replication.

Yechiel Adar
Mehish
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 3:21 PM


Yechiel - Do you have more information (9i and replication)? Previously
there was a document on Oracle's website that showed SE had basic
replication and EE had advanced replication. I don't see that document any
more. Our company is looking at placing Oracle servers at several remote
sites. Originally they wanted to use MS SQL, but Oracle SE pricing looked
okay, and I figured that basic replication would do what they need. If I am
wrong, do you know of any job openings?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 09, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L


I looked at 9i options and I see that replication is not available with SE,
only with EE.
So, if you use replication you can not downgrade to SE from EE.
( replication is just an example).

So you need to take a good look on the options difference between SE and EE
to make
sure you CAN downgrade.

9i option link:
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 08, 2002 11:28 PM


> Yeachiel :
>
> We have 8.1.7 EE.
>
> Regards
>
>
> Cópia Yechiel Adar <[EMAIL PROTECTED]>:
>
> > 8.1.6 SE or EE ?
> >
> > I meant that there are differences inside the same version between SE
> > and
> > EE.
> >
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 08, 2002 3:38 AM
> >
> >
> > >
> > > I am almost 100% sure.
> > > Because i have the application also running in the 8.1.6.
> > >
> > > Thanks Friends
> > >
> > > Eriovaldo
> > >
> > >
> > > - Original Message -
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Yechiel Adar
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
>
> -
> Esta mensagem foi enviada por Siteplanet WebMail.
> http://webmail.siteplanet.com.br
> --
> 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

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

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

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

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

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

[S B]

Sam,

I think this will work. Can you please try it out and
let me know if I understood your problem correctly.

select t1.c2,t1.c4,t23.c2,t23.c3,t4.c4
from   t1,t4,( select  t2.c2 c2 ,t2.c3 c3 from t2,t3
where t2.c3=t3.c3) t23
where  t1.c4=t4.c4(+)
andt1.c2=t23.c2(+)
and exists
( 
  select 1 from t2 where t2.c2=t1.c2
  union
  select 1 from t4 where t2.c4=t4.c4
)


Regards
Bhulu



--- sam d <[EMAIL PROTECTED]> wrote:
> Bhulu,Amit your sol. is correct in the context ,But
> I
> forgot to mention(my apologies)
> that :if T1 has record which does not have
> corresponding entries in T2 as well as in T4
> then that record from T1 should not get selected.
> 
> The third col in table ( T2 ) will be null because
> there is no corresponding record in T3.
> 
> Steven ,I have read the 'C. J. Date' but don't
> remember the edition.
> 
> So can I have a single query (nested will also do)?
> 
> rgds
> Sam
> --- sam d <[EMAIL PROTECTED]> wrote:
> > 
> > Hi,
> > Consider the following case.
> > I have four tables as T1,T2,T3,T4
> > 
> > 1.T1 and T2 has C2 as common field.
> > 2.T2 and T3 has C3 as common field.
> > 3.T1 and T4 has C4 as common field.
> > 
> > 
> > cosider the foll. data:-
> > |---|
> > |T1   | 
> > |---|
> > |  C2 | C4  |  
> > |---|
> > | 100 | 990 | 
> > | 101 | 991 |
> > | 102 | 992 |
> > | 103 | 993 |
> > | 104 | 994 |
> >  ---
> > 
> > |-|
> > |  T2   | 
> > |-|
> > |  C2| C3 |  
> > |-|
> > | 100| 400| 
> > | 101| 401|
> > | 102| 402|//this 402 is missing in the T3
> > table(affects the result)
> > | 103| 403|
> > | 104| 404|
> >  - 
> > 
> > (T2.C3=T3.C3)
> > |-|
> > |  T3| 
> > |-|
> > |  C3  |  
> > ||
> > | 400 | 
> > | 401 |
> > | 403 |//402 is missing 
> > | 404 |
> >  -- 
> > 
> > 
> > ||
> > |  T4 | 
> > |---|
> > |  C4 |  
> > |---|
> > | 990 | 
> > | 991 |
> > | 992 |
> > | 993 |
> >  --
> > //994 missing
> > 
> > 
> > I want the result as :-
> > -
> > | Result |
> > --
> > |( from T1)|  (t2) | (t3)|  (t4) |
> > --|
> > |100 |990  | 100 |400 | 990 | 
> > |101 |991  | 101 |401 | 991 |
> > |102 |992  | null | null | 992|//null in place of
> > 102,402 
> > |103 |993  | 103 |403 | 993 | 
>  
> >  
> > |104 |994  | 104 |404 | null |//null in place of
> 994
> > 
> >  -
> > Can this be done in a single query(no PL/SQL).
> > 
> > 
> > Is this really tough one or i m lost??.
> > 
> > (I have attached the script for table
> > create/inserts.)
> > 
> > 
> > 
> > -
> > Do You Yahoo!?
> > Yahoo! Shopping - Mother's Day is May 12th!>
> CREATE
> TABLE T1 ( 
> >   C2  NUMBER, 
> >   C4  NUMBER) ;
> >   
> > CREATE TABLE T2 ( 
> >   C2  NUMBER, 
> >   C3  NUMBER); 
> >
> > CREATE TABLE T3 ( 
> >   C3  NUMBER);
> >
> > CREATE TABLE T4 ( 
> >   C4  NUMBER); 
> >   
> > 
> > INSERT INTO T1 ( C2, C4 ) VALUES ( 100, 990); 
> > INSERT INTO T1 ( C2, C4 ) VALUES ( 101, 991); 
> > INSERT INTO T1 ( C2, C4 ) VALUES ( 102, 992); 
> > INSERT INTO T1 ( C2, C4 ) VALUES ( 103, 993); 
> > INSERT INTO T1 ( C2, C4 ) VALUES ( 104, 994); 
> > 
> > 
> > INSERT INTO T2 ( C2, C3 ) VALUES ( 100, 400); 
> > INSERT INTO T2 ( C2, C3 ) VALUES ( 101, 401); 
> > INSERT INTO T2 ( C2, C3 ) VALUES ( 102, 402); 
> > INSERT INTO T2 ( C2, C3 ) VALUES ( 103, 403); 
> > INSERT INTO T2 ( C2, C3 ) VALUES ( 104, 404); 
> > 
> > INSERT INTO T3 ( C3 ) VALUES ( 400); 
> > INSERT INTO T3 ( C3 ) VALUES ( 401); 
> > INSERT INTO T3 ( C3 ) VALUES ( 403); 
> > INSERT INTO T3 ( C3 ) VALUES ( 404); 
> > 
> > INSERT INTO T4 ( C4 ) VALUES ( 990); 
> > INSERT INTO T4 ( C4 ) VALUES ( 991); 
> > INSERT INTO T4 ( C4 ) VALUES ( 992); 
> > INSERT INTO T4 ( C4 ) VALUES ( 993); 
> > 
> 
> 
> __
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: sam d
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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! Shopping - Mother's Day is May 12th!
http://shop

Re: I have a black hole in my database

[Simon . Anderson]

You have my sympathy, as I've been in a similar situation after getting a
designer install thrown at me.
I can only offer general advice, as we hit a series of different bugs that
eventually led to abandoning designer, you've probably heard it all from Oracle
support already...

Make sure you're using the latest patch release of 6i, you didn't specify which
one you're on.  Half of our problems were in finding the right release to work
with our 8.1.7.0 database.

It really does need all those separate tablespaces, on separate disks if you've
got them (I hadn't appreciated quite how big the product was until it was too
late to turn down the job).

Keep chasing Oracle support without mercy - don't let them park the call if you
can avoid it, keep their clock ticking.  I don't know how responsive their
support is where you are, but it takes a while to get past the front line in the
UK...

You could try creating an explain plan of the Select that the view uses, and
running the statements themselves without making them into a view might get you
something traceable, but it's a long shot.


Hope This Helps
Simon Anderson.





Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Simon Anderson/SSplc)




Oracle Version 8.1.7.3 64-bit
OS Solaris 8 10/1
Server platform Sunfire 38000
Client Platform WIN2k

I have somehow created a black hole in my database. While installing
designer 6i my process freezes while creating the RM_ELEMENTS view. I do not
have any errors in my alert logs. If I create a new SQL*PLUS session it
hangs before logging in. If I bring up DBA Studios it hangs. My only recover
so far has been to shutdown abort the instance.

If I run the 'cdapirvw.sql' script (this creates the views) it goes to end
of job successfully. No errors. If I then run something simple like 'select
count(*) from rm_elements' the instance hangs. If I attempt to grant
rm_elements to a role the instance hangs. I can descibe rm_elements
successfully. I can drop it.

The create view statement for rm_elements is incredibly long. here is an
example
CREATE OR REPLACE FORCE VIEW rm_elements AS
SELECT sdd_a1.changed_by
  ,sdd_a1.created_by
  ,sdd_a1.date_changed
  ,sdd_a1.date_created
  ,sdd_a1.irid id
  ,sdd_a1.notm number_of_times_modified
  ,sdd_a1.types
FROM   sdd_a1 sdd_a1
  UNION ALL
SELECT sdd_a2.changed_by
  ,sdd_a2.created_by
  ,sdd_a2.date_changed
  ,sdd_a2.date_created
  ,sdd_a2.irid id
  ,sdd_a2.notm number_of_times_modified
  ,sdd_a2.types
FROM   sdd_a10 sdd_a2
  UNION ALL
SELECT sdd_a3.changed_by
  ,sdd_a3.created_by
  ,sdd_a3.date_changed
  ,sdd_a3.date_created
  ,sdd_a3.irid id
  ,sdd_a3.notm number_of_times_modified
  ,sdd_a3.types
FROM   sdd_a11 sdd_a3

There are about 30 or 40 unions at least in this view. The command is a
couple of 100 lines long. Has anyone had a problem like this or a suggestion
I could pursue? I am working with Oracle support but have not had a
resolution yet.



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

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

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

Re: Transactions per second

[Tim Bunce]

On Thu, May 09, 2002 at 02:53:19PM -0800, MacGregor, Ian A. wrote:
> 
> * The way it fails: 
> 
> * If the schema is required, OCIDirPathPrepare() should fail with an error. A 
>crash/core dump is an ... unconventional way of indicating an
> 
> error. 

Sadly not very unconventional for OCI :(

Tim.

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

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

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

MEMORY USAGE

[S B]

Hi ALL,

1. 
How do I get know memory usage by karnel,application
programs,Filesystem Cache etc in SunOS 5.6 . I do not
have the RMC package installed in my m/c

2.
How do I know if the ORACLE is using Raw/UFS ?

3.
If I set _filesystemio_options='directIO' instead of
'async' will that save memory consumption and improve
performance  ?

Any suggestion ...Thanks in advance 

__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: S B
  INET: [EMAIL PROTECTED]

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

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

Re: I have a black hole in my database

[G . Plivna]

I remember once a designer package compiled forever, it just hang up ...

I looked in the previous release of Designer and found that the code has
been changed although the meaning was really the same. So I took some 5-10
lines from previous version and voila! - it worked. Later this was
registered as a bug :-)

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
 
  Simon.Anderson@sc
 
  isys.co.uk   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: I have a black hole in my 
database 
   
 
   
 
  2002.05.10 13:53 
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 






You have my sympathy, as I've been in a similar situation after getting a
designer install thrown at me.
I can only offer general advice, as we hit a series of different bugs that
eventually led to abandoning designer, you've probably heard it all from
Oracle
support already...

Make sure you're using the latest patch release of 6i, you didn't specify
which
one you're on.  Half of our problems were in finding the right release to
work
with our 8.1.7.0 database.

It really does need all those separate tablespaces, on separate disks if
you've
got them (I hadn't appreciated quite how big the product was until it was
too
late to turn down the job).

Keep chasing Oracle support without mercy - don't let them park the call if
you
can avoid it, keep their clock ticking.  I don't know how responsive their
support is where you are, but it takes a while to get past the front line
in the
UK...

You could try creating an explain plan of the Select that the view uses,
and
running the statements themselves without making them into a view might get
you
something traceable, but it's a long shot.


Hope This Helps
Simon Anderson.





Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Simon Anderson/SSplc)




Oracle Version 8.1.7.3 64-bit
OS Solaris 8 10/1
Server platform Sunfire 38000
Client Platform WIN2k

I have somehow created a black hole in my database. While installing
designer 6i my process freezes while creating the RM_ELEMENTS view. I do
not
have any errors in my alert logs. If I create a new SQL*PLUS session it
hangs before logging in. If I bring up DBA Studios it hangs. My only
recover
so far has been to shutdown abort the instance.

If I run the 'cdapirvw.sql' script (this creates the views) it goes to end
of job successfully. No errors. If I then run something simple like 'select
count(*) from rm_elements' the instance hangs. If I attempt to grant
rm_elements to a role the instance hangs. I can descibe rm_elements
successfully. I can drop it.

The create view statement for rm_elements is incredibly long. here is an
example
CREATE OR REPLACE FORCE VIEW rm_elements AS
SELECT sdd_a1.changed_by
  ,sdd_a1.created_by
  ,sdd_a1.date_changed
  ,sdd_a1.date_created
  ,sdd_a1.irid id
  ,sdd_a1.notm number_of_times_modified
  ,sdd_a1.types
FROM   sdd_a1 sdd_a1
  UNION ALL
SELECT sdd_a2.changed_by
  ,sdd_a2.created_by
  ,sdd_a2.date_changed
  ,sdd_a2.date_created
  ,sdd_a2.irid id
  ,sdd_a2.notm number_of_times_modified
  ,sdd_a2.types
FROM   sdd_a10 sdd_a2
  UNION ALL
SELECT sdd_a3.changed_by
  ,sdd_a3.created_by
  ,sdd_a3.date_changed
  ,sdd_a3.date_created
  ,sdd_a3.irid id
  ,sdd_a3.notm number_of_times_modified
  ,sdd_a3.types
FROM   sdd_a11 sdd_a3

There are about 30 or 40 unions at least in this view. The command is a
couple of 100 lines long. Has anyone had a p

Re: formating 10046 (level 12) trace file

[Mogens Nørgaard]

Torben Holm from Miracle created the Trace File Repository, which is a neat
little utility to put data from the 10046 output files into a couple of tables.
Then it's entirely up to you to either use one of Torbens pre-created output
formats or create your own. Torben - where can these guys get it from?

A couple of comments:

- As has already been said, the information available in the 10046 output
files, can roughly be figured out by anyone. The public notes on Metalink
have been there for years. It's been discussed in books. This has nothing
to do with being inside Oracle or not. And people who have done serious SQL
tuning and research should all have known about this feature since many of
us have been discussing it, talking about it, lecturin about it and dreamed
abou it for many years now. You'd have to be working for Microsoft not to
have heard about it :).

- The trick - what in my opinion sets Cary's tool apart from the rest, including
our TFR - is the very hard, very elaborate research that Jeff Holt and Cary
has put into this project. It's easy to get the first, rough data out of
the trace files. But as you dig into them you'll find a lot of problems with
the interpretation that you cannot find the answer to anywhere, so it's a
question of R&D for months on end. If you study the other tools, including
the new facility available in the 9i tkprof, you'll find that those areas
are not adressed properly. So they might be good enough for your purpose,
but if you want it to be professional you have to use Hotsos - and I think
it's reasonable enough to charge money for work performed, isn't it (in this
case a LOT of work)? Or have I misunderstood the whole IT business?

Mogens

[EMAIL PROTECTED] wrote:

  Henry,Thanks for the script..tkprof in 9i has some enhanced functionality whichincludes the wait events from the trace file..which is very similar to whatyour script does in addition to regular tkprof statistics..I have installed and used 9i tkprof with 8i generated trace file. Worksfine.The following is a sample output of the new addition from 9i tkprof.Elapsed times include waiting on following events:  Event waited on Times   Max. Wait  TotalWaited     Waited  --  SQL*Net message to client   10.000.00  db file sequential read 40.010.02  SQL*Net message from client 10.000.00***
*Also, I would like to thank everyone else for their comments andsuggestions..Mohammed AhsanuddinOracle DBA-Original Message-Sent: Thursday, May 09, 2002 2:46 PMTo: Multiple recipients of list ORACLE-LI did write an awk script to summarize the wait events in a 10046 tracefile. It lists the SQL, and sums the count and time of the waits for theSQL.Henry#  Script for analyzing Oracle Trace files with WAIT statistics#  Usage:  wait_scan.awk #  Written:Henry Poras#  5/16/00#  Modified:   12/3/01  Initially assumes all wait states for a cursor arebetween#   parse statements.##nawk  '# need nawk,not awk   BEGIN{N=""  PARSE_FLAG=0 # PARSE_FLAG= 0 (normal state)  printf("\n\n%-35s %-12s %-18s\n\n",  # PARSE_FLAG= 1 (previous line PARSING) "WAIT EVENT", "# OF TIMES", "ELAPSED TIME (sec)") # printcolumn headers } {if (PARSE_FLAG==1)   # if previousline started{SQL[N]=$0 # withPARSING, print PARSE_FLAG=0  # the SQL.N=""} }   /^PARSING/  {FS=" "  N=$4  sub("#","",N)  if (N in SQL)prinfo(N)  PARSE_FLAG=1 }   /^WAIT/ {FS="#| nam=|ela=|p1="  N=$2   sub(":","",N)  PARSE_FLAG=2  n_wait[N,$3] += 1  ela_wait[N,$3] += $4 }   END  {for (N in SQL){   # Prin
t Waitstatistics for finalprintf "\n\n\n%s\n\n", SQL[N]  # SQLstatement in filefor (k in n_wait) { split(k,arg,SUBSEP) if (arg[1]==N && n_wait[k]!=0) {   printf "%-35s %-12s %12.2f\n",   arg[2],n_wait[k],ela_wait[k]/100   n_wait[k]=0   ela_wait[k]=0 }}  printf "\n\n" } for (k in n_wait) {split(k,arg,SUBSEP)if (n_wait[k] != 0) {   printf "%-35s %-12s %12.2f\n",   arg[2],n_wait[k],ela_wait[k]/100   n_wait[k]=0   ela_wait[k]=0

Re: Server upgrade NT4 -> W2K Oracle implications

[Yechiel Adar]

1) Oracle uses the registry also to register some staff in other places
except the oracle entry.
2) Oracle also use c:\program files\oracle for some stuff (install log
etc.).

Why do not upgrade the machine without recreating C partition.
(I know that upgrade is more work then ghosting a new C drive).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 12:47 AM


We have an 8.1.7 SE database on a server which is currently NT4 SP6.  The
System Admin group wish to upgrade the server to W2K and propose doing so by
recreating the C: partitition.  Our Oracle software resides on E: (same
physical disk) and database files on other disks/partitions.  Are there any
implications for the Oracle software and database for this upgrade.  Are
there any steps I need to take pre or post OS upgrade?.  In particular I'm
wondering about implications for the registry.
Any advice/help would be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

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

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

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

RE: Server upgrade NT4 -> W2K Oracle implications

[Mark Leith]

Sean,

We did a straight upgrade of an NT box to Win2K (some time ago) that held an
Oracle 8.1.6 database.. The database was fine after the upgrade.. What is
the choice for recreating rather than upgrading?

Mark

-Original Message-
Adar
Sent: 10 May 2002 12:29
To: Multiple recipients of list ORACLE-L


1) Oracle uses the registry also to register some staff in other places
except the oracle entry.
2) Oracle also use c:\program files\oracle for some stuff (install log
etc.).

Why do not upgrade the machine without recreating C partition.
(I know that upgrade is more work then ghosting a new C drive).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 12:47 AM


We have an 8.1.7 SE database on a server which is currently NT4 SP6.  The
System Admin group wish to upgrade the server to W2K and propose doing so by
recreating the C: partitition.  Our Oracle software resides on E: (same
physical disk) and database files on other disks/partitions.  Are there any
implications for the Oracle software and database for this upgrade.  Are
there any steps I need to take pre or post OS upgrade?.  In particular I'm
wondering about implications for the registry.
Any advice/help would be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

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

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

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

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

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

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

Re: Good HR vs. Bad HR...

[bill thater]

[EMAIL PROTECTED] wrote:

> I think enough has been said already - I didn't intend to name the company at all.  
>Actually, I
> don't think that I said that all the managers were incompetent.  (A select few in 
>the wrong places
> perhaps.)  Since the cat is out of the bag though, I will try to end this here and 
>now.
> 
> I had a number of specific and well-documented "complaints", so I fired off this 
>kamikaze
> resignation letter - straight through three layers of management, even cc'ing one of 
>the two owners
> of the company.  The original formatting was better, but here it is in ASCII.


oh damn, can i get you to help author my resignation the next time i get 
to do one?  please?



-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [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.

Dreams are free, but you get soaked on the connect time.




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

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

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

[Rachel_Carmichael]

And I respectfully agree that I was wrong :)It happens, I think I already
posted a note to the list apologizing and correcting my error.

This is what happens when I post from memory without double checking
obviously I had done a "flush" of my shared_pool!

Rachel


|+--->
||   |
||   |
||  MGogala@oxhp.|
||  com  |
||   |
||  05/09/2002   |
||  05:43 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: optimizer not using function|
  |   based indexes|
  >|




I respectfully disagree. In order to use a function based index
you do need the upper. If optimizer doesn't pick it up straigt
away, he should give a hand with a hint (/*+ INDEX(alias,index) */)

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: optimizer not using function based indexes
>
>
>
>
> you don't need the upper(ename) in your where clause... that
> forces oracle to
> NOT use an index
>
>
>
>
> |+->
> || |
> || |
> ||  Harvinder.Singh@met|
> ||  ratech.com |
> || |
> ||  05/09/2002 04:18 PM|
> ||  Please respond to  |
> ||  ORACLE-L   |
> || |
> |+->
>   >|
>   ||
>   |   To: [EMAIL PROTECTED] |
>   |   cc: (bcc: Rachel Carmichael) |
>   |   Subject: optimizer not using function|
>   |   based indexes|
>   >|
>
>
>
>
> Hi,
>
> We are trying to use function based indexes in our
> application but it looks like
>
> optimizer is  not using them.
> So we created a sample table emp with 3 columns
> empno,ename,sal and populate
> this table with 10 rows and created function based index
> on upper(ename).
> we try to run simple query like below and optimzer is not using index:
> select sal from emp
> where upper(ename)=upper('abc98');
>
> Even we use index hint optimizer is still not using index.
>
> 1) table is analyzed as compute after creating index.
> 2) query rewrite is granted to user
> 3) query_rewrite_enabled=true.
> 4) optimzer mode is choose.
> 5) optimer should use index as there is no way full scan can
> be faster than
> index in this case as i tried to create simple
> index on ename and remove upper function from where clause of query..
>
>
> What can be the possible reason that optimzer is not using index??
>
> 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network 

Re: script to show heirarchical list of object dependencies for a

[Rachel_Carmichael]

How is this essentially different than what you can get from utldtree.sql?

when Kevin Loney and I were writing the Annotated Archives a few years ago, I
tried to write a script that would show the dependencies, because part of the
reason for the book was to provide "home-grown" scripts that wre documented. I
ended up essentially rewriting the cod from utldtree.sql and we gave up that
particular effort.




|+--->
||   |
||   |
||  jack_silvey@y|
||  ahoo.com |
||   |
||  05/09/2002   |
||  07:03 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: script to show heirarchical list|
  |   of object dependencies for a given object|
  >|




Greetings listers,

Ever worry about wrinkles, loss of hair, and bad
breath?

Well, the following script can't help you with THAT,
but it CAN show you a heirarchical list of objects
that depend upon the given object! Just pass in
&1=owner and &2=object name, and viola! No more
changing objects without knowing what depends on them
(and might break). (The reason for the temp table is
that you can't do recursive self-join sql on complex
views.) This can be a very useful script if you make
production database changes.

prompt
prompt objects depending on &1. &2:
prompt

set termout off
set head off
set verify off

drop table depends;

create table depends as select * from
sys.dba_dependencies tablespace tools;

set termout on

select  '*'||lpad(' ',level+3)||type||'
'||owner||'.'||name
from depends
connect by prior owner = referenced_owner
and prior name = referenced_name
and prior type = referenced_type
start with referenced_owner = upper('&1')
and referenced_name = upper('&2')
and owner is not null
/

good luck,

jack silvey


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

Oracle and Character formatting

[Hussain Ahmed Qadri]

Title: Oracle and Character formatting





Hello All,

We want some text to be stored in our database, entered through a Dev6 Form. Is it possible that formatted data can be stored in the database in the form it is written, i.e. with different fonts or special characters or numeric values with power ( 5x102   - where 2 is the superscript of 10, as in MS Word terminologies). If we give MS word as the editor for the Forms entry screen and save the data in any of the above formats, Will the data, when retrieved, be in the same format as it was entered. Or would it convert in ASCII and later display a simple value rather than the formatted one. 

Is there any way to do such a thing.

Would appreciate any advice on it.

Oracle 8.1.7, WINNT4

Hussain Ahmed Qadri

DBA

Shaukat Khanum Memorial Cancer Hospital and Research Center

Lahore 

Pakistan

Re: Good HR vs. Bad HR...

[Rachel_Carmichael]

Don,

Next time I need to resign, will you help me write the letter?

Having worked at several large and not-so large companies, all I can say is, the
problems you documented seem to be ubiquitous throughout most management. I have
found it nearly impossible in some places to do my job with any degree of
accuracy, because management has its own version of reality and if what I said
didn't conform, it was thrown out.  Something akin to deciding what the results
of that physics experiment should be before beginning it, and throwing out all
results that don't support the hypothesis.

What amazes me is that these companies continue to survive in the face of such
insanity.

So far, it does not look to be like that here. I have reviewed and made
suggestions in the past two weeks and the response has been "she's right, let's
do it". And it gets done. I might actually like it here :)

Rachel



|+--->
||   |
||   |
||  granaman@cox.|
||  net  |
||   |
||  05/09/2002   |
||  06:37 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re: Good HR vs. Bad HR...   |
  >|




I think enough has been said already - I didn't intend to name the company at
all.  Actually, I
don't think that I said that all the managers were incompetent.  (A select few
in the wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this here
and now.

I had a number of specific and well-documented "complaints", so I fired off this
kamikaze
resignation letter - straight through three layers of management, even cc'ing
one of the two owners
of the company.  The original formatting was better, but here it is in ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and "geniuses"
hand off botched,
half-baked, poorly designed, and dysfunctional systems, then get major
promotions and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I as
upper management
mourned the loss of their "Oracle genius" (a direct quote). Well this "genius"
left us a system with
almost no data integrity - there were only two foreign keys for 44 tables. Only
about 70% of the
tables even had a primary key. There were no check constraints or triggers to
enforce data
integrity.  Nothing was enforced in the application.  And the application
handled extremely few of
the business requirements.  For example, the application does not function
properly unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint.
Furthermore, the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness
constraint alone is
insufficient - there also needs to be a method to enforce uppercase only on this
column on inserts
and updates.  There was none.  One could enter a new employee record, then
immediately query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file
were in the same
directory. The online redo logs were not mirrored. While these and other basic
errors and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The users
were connecting to
the database as the SYSTEM user (with the default password "MANAGER" of course).
His project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This doesn't
work, all it does is
remove the ORACLE_HOME directory and replace it with files copied from a server.
It doesn't update
the registry and it doesn't consider that there may already be an Oracle client
on the machine
(typically, there is - and it includes things that this method would delete,
like the Oracle forms
runtime).  This last item became an issue when I first heard of it less than a
week before the
implementation date. (Incidentally, that was the first time that most of us even
heard about this
project.)  We tested a variation of this method for CIT client installations and
determined that it
was impractical. How does one do such a poor job and yet convince everyone they
are a "genius"? Is
perception is truly everything here?

To further compound the problem, we were never allowed to question or even
review anything - not the
application, not the database, and not the schema.  The whole mess was a
well-guarded secret until
the very Friday afternoon that this consultant's contract was over and he left
the company.  At that
time, it was turned over to us.  We very quickly di

Solaris RC Script Output

[Erik Williams]

Where can I find the output of the Solaris run control scripts? I am trying
to debug a database startup problem and would like to view the output of the
echo commands in these scripts. 

Thanks
Erik

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

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

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

Re: Good HR vs. Bad HR...

[Gene Sais]

Don - Excellent letter!  Wonder what happened after you left?  Did anything change?

>>> [EMAIL PROTECTED] 05/09/02 06:37PM >>>
I think enough has been said already - I didn't intend to name the company at all.  
Actually, I
don't think that I said that all the managers were incompetent.  (A select few in the 
wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this here and now.

I had a number of specific and well-documented "complaints", so I fired off this 
kamikaze
resignation letter - straight through three layers of management, even cc'ing one of 
the two owners
of the company.  The original formatting was better, but here it is in ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and "geniuses" hand off 
botched,
half-baked, poorly designed, and dysfunctional systems, then get major promotions 
and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I as upper 
management
mourned the loss of their "Oracle genius" (a direct quote). Well this "genius" left us 
a system with
almost no data integrity - there were only two foreign keys for 44 tables. Only about 
70% of the
tables even had a primary key. There were no check constraints or triggers to enforce 
data
integrity.  Nothing was enforced in the application.  And the application handled 
extremely few of
the business requirements.  For example, the application does not function properly 
unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint. Furthermore, 
the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness constraint 
alone is
insufficient - there also needs to be a method to enforce uppercase only on this 
column on inserts
and updates.  There was none.  One could enter a new employee record, then immediately 
query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file were in 
the same
directory. The online redo logs were not mirrored. While these and other basic errors 
and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The users were 
connecting to
the database as the SYSTEM user (with the default password "MANAGER" of course). His 
project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This doesn't work, 
all it does is
remove the ORACLE_HOME directory and replace it with files copied from a server.  It 
doesn't update
the registry and it doesn't consider that there may already be an Oracle client on the 
machine
(typically, there is - and it includes things that this method would delete, like the 
Oracle forms
runtime).  This last item became an issue when I first heard of it less than a week 
before the
implementation date. (Incidentally, that was the first time that most of us even heard 
about this
project.)  We tested a variation of this method for CIT client installations and 
determined that it
was impractical. How does one do such a poor job and yet convince everyone they are a 
"genius"? Is
perception is truly everything here?

To further compound the problem, we were never allowed to question or even review 
anything - not the
application, not the database, and not the schema.  The whole mess was a well-guarded 
secret until
the very Friday afternoon that this consultant's contract was over and he left the 
company.  At that
time, it was turned over to us.  We very quickly discovered that almost nothing 
actually worked.  We
were told that it absolutely had to go live Monday morning and that the deadline was 
totally
inflexible.  Then, in a rather nasty and threatening tone, we were told that we would 
just have to
work over the weekend to "fix it" and install the Oracle client on 400 PCs.  Since the 
only way to
actually fix this disaster was to redesign and rewrite significant portions of it, we 
insisted that
this "plan" wasn't realistic.  How could we be expected to repair nine months of 
damage in a single
weekend - in our "spare time" while also doing 400 client installations?  The response 
was that we
were simply "not team players".
---
Another significant aspect of my dissatisfaction is that management quite frequently 
fails to
understand (or even question) the usefulness of tasks assigned. I have been assigned 
many tasks that
were said to be "urgent and critical" only to have the results discarded when 
completed. I have
several classic examples*

Case in point: During the very early stages of Telephony development, Steve Flott and 
I were
assigned the task of writing "data injectors" to populate the Telephony tables for 
RACP testing. We
were told this was of paramount importance and had to be done in less than two weeks 
by doing
"whatever it takes". After we started and saw how immature the design was, we 
questioned whether
this task was premature. The design was changing as fast as we could write code. We 
worked 60-70
hours weeks until it was done. Every time we were 

Re[2]: Improving Oracle Performance

[dgoulet]

Sankar,

1) How many indexes does this table have?
2) How many rows currently exist?
3) Are there ANY triggers on this table?
4) Are there any column constraints other than NOT NULL?
5) Is there a foreign key on from this table to another?
6) How many rows are in the master table, if applicable?
7) Are the data and index tablespaces one and the same?
8) Are the data and index tablespaces on the same disk drive?
9) Are there other applications trying to update/delete from/insert to this
table at the same time?

10) Do any of those applications explicitly lock the table?  (lock 
in exclusive mode;)


Dick Goulet

Reply Separator
Author: Greg Moore <[EMAIL PROTECTED]>
Date:   5/9/2002 2:58 PM

Sankar,

For starters,

SQL> set autotrace trace explain

Now run your SQL and you'll get an explain plan.

Send another email to the list showing both:   the SQL statement,  and the
explain plan.  These may reveal your problem quickly.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 6:08 AM


>
>  Hi,
>  We are using Oracle 8.1.5 on solaris 2.7.We have a table with 70 columns.
> My problem is when i try to insert/update  data into the table,it is
> taking a very long time[45secs to update 40rows].Is there any methods to
> improve the updation/access speed other than Table partitions.
>
> Thanks & Regards,
> Sankar
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: P.V.Sankar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

RE: Good HR vs. Bad HR...

[Mercadante, Thomas F]

Don,

And, of course, since it was a resignation letter, the company probably just
filed it away.  I'll give you the "Brass Cajones" award though, for setting
the record straight.

Just curious, is the company still around?  Need to make sure to avoid it in
the future!  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, May 09, 2002 6:38 PM
To: Multiple recipients of list ORACLE-L


I think enough has been said already - I didn't intend to name the company
at all.  Actually, I
don't think that I said that all the managers were incompetent.  (A select
few in the wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this
here and now.

I had a number of specific and well-documented "complaints", so I fired off
this kamikaze
resignation letter - straight through three layers of management, even
cc'ing one of the two owners
of the company.  The original formatting was better, but here it is in
ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and
"geniuses" hand off botched,
half-baked, poorly designed, and dysfunctional systems, then get major
promotions and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I
as upper management
mourned the loss of their "Oracle genius" (a direct quote). Well this
"genius" left us a system with
almost no data integrity - there were only two foreign keys for 44 tables.
Only about 70% of the
tables even had a primary key. There were no check constraints or triggers
to enforce data
integrity.  Nothing was enforced in the application.  And the application
handled extremely few of
the business requirements.  For example, the application does not function
properly unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint.
Furthermore, the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness
constraint alone is
insufficient - there also needs to be a method to enforce uppercase only on
this column on inserts
and updates.  There was none.  One could enter a new employee record, then
immediately query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file
were in the same
directory. The online redo logs were not mirrored. While these and other
basic errors and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The
users were connecting to
the database as the SYSTEM user (with the default password "MANAGER" of
course). His project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This
doesn't work, all it does is
remove the ORACLE_HOME directory and replace it with files copied from a
server.  It doesn't update
the registry and it doesn't consider that there may already be an Oracle
client on the machine
(typically, there is - and it includes things that this method would delete,
like the Oracle forms
runtime).  This last item became an issue when I first heard of it less than
a week before the
implementation date. (Incidentally, that was the first time that most of us
even heard about this
project.)  We tested a variation of this method for CIT client installations
and determined that it
was impractical. How does one do such a poor job and yet convince everyone
they are a "genius"? Is
perception is truly everything here?

To further compound the problem, we were never allowed to question or even
review anything - not the
application, not the database, and not the schema.  The whole mess was a
well-guarded secret until
the very Friday afternoon that this consultant's contract was over and he
left the company.  At that
time, it was turned over to us.  We very quickly discovered that almost
nothing actually worked.  We
were told that it absolutely had to go live Monday morning and that the
deadline was totally
inflexible.  Then, in a rather nasty and threatening tone, we were told that
we would just have to
work over the weekend to "fix it" and install the Oracle client on 400 PCs.
Since the only way to
actually fix this disaster was to redesign and rewrite significant portions
of it, we insisted that
this "plan" wasn't realistic.  How could we be expected to repair nine
months of damage in a single
weekend - in our "spare time" while also doing 400 client installations?
The response was that we
were simply "not team players".
---
Another significant aspect of my dissatisfaction is that management quite
frequently fails to
understand (or even question) the usefulness of tasks assigned. I have been
assigned many tasks that
were said to be "urgent and critical" only to have the results discarded
when completed. I have
several classic examples…

Case in point: During the very early stages of Telephony development, Steve
Flott and I were
assigned the task of writing "data injectors" to populate the Telephony
tables for RACP testing. We
were told this was of paramount importance and had to be done in less than
two weeks 

RE: Good HR vs. Bad HR...

[Jenkins, Michael - EDS]

Wow, it's a small world.  My first DBA position was at CSG Systems!  And
yes, the company broke off of First Data and became its own publicly traded
company.  By the way, nice letter :)

-Original Message-
Sent: Friday, May 10, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L


Don,

And, of course, since it was a resignation letter, the company probably just
filed it away.  I'll give you the "Brass Cajones" award though, for setting
the record straight.

Just curious, is the company still around?  Need to make sure to avoid it in
the future!  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, May 09, 2002 6:38 PM
To: Multiple recipients of list ORACLE-L


I think enough has been said already - I didn't intend to name the company
at all.  Actually, I
don't think that I said that all the managers were incompetent.  (A select
few in the wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this
here and now.

I had a number of specific and well-documented "complaints", so I fired off
this kamikaze
resignation letter - straight through three layers of management, even
cc'ing one of the two owners
of the company.  The original formatting was better, but here it is in
ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and
"geniuses" hand off botched,
half-baked, poorly designed, and dysfunctional systems, then get major
promotions and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I
as upper management
mourned the loss of their "Oracle genius" (a direct quote). Well this
"genius" left us a system with
almost no data integrity - there were only two foreign keys for 44 tables.
Only about 70% of the
tables even had a primary key. There were no check constraints or triggers
to enforce data
integrity.  Nothing was enforced in the application.  And the application
handled extremely few of
the business requirements.  For example, the application does not function
properly unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint.
Furthermore, the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness
constraint alone is
insufficient - there also needs to be a method to enforce uppercase only on
this column on inserts
and updates.  There was none.  One could enter a new employee record, then
immediately query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file
were in the same
directory. The online redo logs were not mirrored. While these and other
basic errors and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The
users were connecting to
the database as the SYSTEM user (with the default password "MANAGER" of
course). His project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This
doesn't work, all it does is
remove the ORACLE_HOME directory and replace it with files copied from a
server.  It doesn't update
the registry and it doesn't consider that there may already be an Oracle
client on the machine
(typically, there is - and it includes things that this method would delete,
like the Oracle forms
runtime).  This last item became an issue when I first heard of it less than
a week before the
implementation date. (Incidentally, that was the first time that most of us
even heard about this
project.)  We tested a variation of this method for CIT client installations
and determined that it
was impractical. How does one do such a poor job and yet convince everyone
they are a "genius"? Is
perception is truly everything here?

To further compound the problem, we were never allowed to question or even
review anything - not the
application, not the database, and not the schema.  The whole mess was a
well-guarded secret until
the very Friday afternoon that this consultant's contract was over and he
left the company.  At that
time, it was turned over to us.  We very quickly discovered that almost
nothing actually worked.  We
were told that it absolutely had to go live Monday morning and that the
deadline was totally
inflexible.  Then, in a rather nasty and threatening tone, we were told that
we would just have to
work over the weekend to "fix it" and install the Oracle client on 400 PCs.
Since the only way to
actually fix this disaster was to redesign and rewrite significant portions
of it, we insisted that
this "plan" wasn't realistic.  How could we be expected to repair nine
months of damage in a single
weekend - in our "spare time" while also doing 400 client installations?
The response was that we
were simply "not team players".
---
Another significant aspect of my dissatisfaction is that management quite
frequently fails to
understand (or even question) the usefulness of tasks assigned. I have been
assigned many tasks that
were said to be "urgent and critical" only to have the results discarded
when completed. I have
several clas

errors with CREATE SYNONYM procedure

[Magaliff, Bill]

I've developed a procedure that will create a public synonym on an object,
which I'd eventually like to call from a ddl "after create on schema"
trigger.

But I'm first working on this piece - I get an INSUFFICIENT PRIVILEGES error
(ORA-1031) on the EXECUTE IMMEDIATE line.  The user running the proc has
both DBA role and specifically the CREATE ANY SYNONYM procedure, which
should be enough.  I can create the synonym manually from SQL*Plus, but
never through this proc . . . any ideas?

thx

here's the code, which compiles perfectly:

CREATE OR REPLACE procedure CREATE_GRANTS (
p_lwowner varchar2,
p_objname varchar2,
p_objtype varchar2) AS

pragma autonomous_transaction;
v_lwowner varchar2(30) := p_lwowner;
v_objname varchar2(30) := p_objname;
v_objtype varchar2(30) := p_objtype;
v_sql varchar2(200);

begin
v_sql := 'create public synonym ' || v_objname || ' for ' ||
v_lwowner || '.' || v_objname;
execute immediate (v_sql);

end;
/

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

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

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

[Sherman, Paul R.]

Hello,

Has anyone ever tried setting dml_locks to zero or disabling table locks on
an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing
contention and freeing up resources ? We currently use 7,250
dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say:

Obtaining table locks, such as DML locks, for inserts, deletes, and updates
can
diminish performance in Oracle Parallel Server. Locking a table in Oracle
Parallel
Server is undesirable because all instances holding locks on the table must
release
those locks. Consider disabling these locks entirely using one of the two
methods
described under the following headings:

 Disabling Table Locks
 Setting DML_LOCKS to Zero

We found, of our 200MB shared pool, that 108MB was taken up by State
objects, gc_*, and dlm shared memory (100,000 gc_releasable_locks),
frequently leaving us with just 3-6MB of shared pool free and getting
occasional 4031's, so next week, plan on reducing the granularity
considerably by setting gc_files_to_locks as 1=500R:2-600=100REACH, and
gc_releasable_locks to roughly 30,000 (doing the math, you get 22,600 for
the 1 system datafile and 221 other datafiles; we added 7,400 locks for 74
datafiles future growth). Adding up non-PCM and PCM locks would result in
needing 120,123 for lm_ress and 180,185 for lm_locks.

Any assistance would be both informative and appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul 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).

RE: Good HR vs. Bad HR...

[Freeman, Robert]

>> So far, it does not look to be like that here. I have reviewed and made
>> suggestions in the past two weeks and the response has been "she's right,

>> let's do it". And it gets done. I might actually like it here :)

Careful... they will slap you down when you least expect it! :-)

RF

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L




Don,

Next time I need to resign, will you help me write the letter?

Having worked at several large and not-so large companies, all I can say is,
the
problems you documented seem to be ubiquitous throughout most management. I
have
found it nearly impossible in some places to do my job with any degree of
accuracy, because management has its own version of reality and if what I
said
didn't conform, it was thrown out.  Something akin to deciding what the
results
of that physics experiment should be before beginning it, and throwing out
all
results that don't support the hypothesis.

What amazes me is that these companies continue to survive in the face of
such
insanity.

So far, it does not look to be like that here. I have reviewed and made
suggestions in the past two weeks and the response has been "she's right,
let's
do it". And it gets done. I might actually like it here :)

Rachel



|+--->
||   |
||   |
||  granaman@cox.|
||  net  |
||   |
||  05/09/2002   |
||  06:37 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re: Good HR vs. Bad HR...   |
  >|




I think enough has been said already - I didn't intend to name the company
at
all.  Actually, I
don't think that I said that all the managers were incompetent.  (A select
few
in the wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this
here
and now.

I had a number of specific and well-documented "complaints", so I fired off
this
kamikaze
resignation letter - straight through three layers of management, even
cc'ing
one of the two owners
of the company.  The original formatting was better, but here it is in
ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and
"geniuses"
hand off botched,
half-baked, poorly designed, and dysfunctional systems, then get major
promotions and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I
as
upper management
mourned the loss of their "Oracle genius" (a direct quote). Well this
"genius"
left us a system with
almost no data integrity - there were only two foreign keys for 44 tables.
Only
about 70% of the
tables even had a primary key. There were no check constraints or triggers
to
enforce data
integrity.  Nothing was enforced in the application.  And the application
handled extremely few of
the business requirements.  For example, the application does not function
properly unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint.
Furthermore, the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness
constraint alone is
insufficient - there also needs to be a method to enforce uppercase only on
this
column on inserts
and updates.  There was none.  One could enter a new employee record, then
immediately query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file
were in the same
directory. The online redo logs were not mirrored. While these and other
basic
errors and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The
users
were connecting to
the database as the SYSTEM user (with the default password "MANAGER" of
course).
His project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This
doesn't
work, all it does is
remove the ORACLE_HOME directory and replace it with files copied from a
server.
It doesn't update
the registry and it doesn't consider that there may already be an Oracle
client
on the machine
(typically, there is - and it includes things that this method would delete,
like the Oracle forms
runtime).  This last item became an issue when I first heard of it less than
a
week before the
implementation date. (Incidentally, that was the first time that most of us
even
heard about this
project.)  We tested a variation of this method for CIT client installations
and
determined that it
was impractical. How does one do such a poor job and yet convince

RE: errors with CREATE SYNONYM procedure

[Mercadante, Thomas F]

Bill,

Does the OWNER of the proc have CREATE PUBLIC SYNONYM system priv?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, May 10, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L


I've developed a procedure that will create a public synonym on an object,
which I'd eventually like to call from a ddl "after create on schema"
trigger.

But I'm first working on this piece - I get an INSUFFICIENT PRIVILEGES error
(ORA-1031) on the EXECUTE IMMEDIATE line.  The user running the proc has
both DBA role and specifically the CREATE ANY SYNONYM procedure, which
should be enough.  I can create the synonym manually from SQL*Plus, but
never through this proc . . . any ideas?

thx

here's the code, which compiles perfectly:

CREATE OR REPLACE procedure CREATE_GRANTS (
p_lwowner varchar2,
p_objname varchar2,
p_objtype varchar2) AS

pragma autonomous_transaction;
v_lwowner varchar2(30) := p_lwowner;
v_objname varchar2(30) := p_objname;
v_objtype varchar2(30) := p_objtype;
v_sql varchar2(200);

begin
v_sql := 'create public synonym ' || v_objname || ' for ' ||
v_lwowner || '.' || v_objname;
execute immediate (v_sql);

end;
/

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

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

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

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

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

RE: errors with CREATE SYNONYM procedure

[Magaliff, Bill]

That was it - thanks!
Forgot there were two distinct system privs - CREATE ANY SYNONYM and CREATE
PUBLIC SYNONYM



-Original Message-
Sent: Friday, May 10, 2002 10:38 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Bill,

Does the OWNER of the proc have CREATE PUBLIC SYNONYM system priv?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, May 10, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L


I've developed a procedure that will create a public synonym on an object,
which I'd eventually like to call from a ddl "after create on schema"
trigger.

But I'm first working on this piece - I get an INSUFFICIENT PRIVILEGES error
(ORA-1031) on the EXECUTE IMMEDIATE line.  The user running the proc has
both DBA role and specifically the CREATE ANY SYNONYM procedure, which
should be enough.  I can create the synonym manually from SQL*Plus, but
never through this proc . . . any ideas?

thx

here's the code, which compiles perfectly:

CREATE OR REPLACE procedure CREATE_GRANTS (
p_lwowner varchar2,
p_objname varchar2,
p_objtype varchar2) AS

pragma autonomous_transaction;
v_lwowner varchar2(30) := p_lwowner;
v_objname varchar2(30) := p_objname;
v_objtype varchar2(30) := p_objtype;
v_sql varchar2(200);

begin
v_sql := 'create public synonym ' || v_objname || ' for ' ||
v_lwowner || '.' || v_objname;
execute immediate (v_sql);

end;
/

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

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

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

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

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

Oracle Diagnostic and Tuning Packs

[Schauss, Peter]

Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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

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

[Jack Silvey]

Great minds think alike? Either that or we are the
borg and just don't know that we are part of the
collective yet.


--- [EMAIL PROTECTED] wrote:
> 
> 
> How is this essentially different than what you can
> get from utldtree.sql?
> 
> when Kevin Loney and I were writing the Annotated
> Archives a few years ago, I
> tried to write a script that would show the
> dependencies, because part of the
> reason for the book was to provide "home-grown"
> scripts that wre documented. I
> ended up essentially rewriting the cod from
> utldtree.sql and we gave up that
> particular effort.
> 
> 
> 
> 
> |+--->
> ||   |
> ||   |
> ||  jack_silvey@y|
> ||  ahoo.com |
> ||   |
> ||  05/09/2002   |
> ||  07:03 PM |
> ||  Please   |
> ||  respond to   |
> ||  ORACLE-L |
> ||   |
> |+--->
>  
>
>|
>   | 
>   |
>   |   To: [EMAIL PROTECTED]  
>   |
>   |   cc: (bcc: Rachel Carmichael)  
>   |
>   |   Subject: script to show heirarchical
> list|
>   |   of object dependencies for a given object 
>   |
>  
>
>|
> 
> 
> 
> 
> Greetings listers,
> 
> Ever worry about wrinkles, loss of hair, and bad
> breath?
> 
> Well, the following script can't help you with THAT,
> but it CAN show you a heirarchical list of objects
> that depend upon the given object! Just pass in
> &1=owner and &2=object name, and viola! No more
> changing objects without knowing what depends on
> them
> (and might break). (The reason for the temp table is
> that you can't do recursive self-join sql on complex
> views.) This can be a very useful script if you make
> production database changes.
> 
> prompt
> prompt objects depending on &1. &2:
> prompt
> 
> set termout off
> set head off
> set verify off
> 
> drop table depends;
> 
> create table depends as select * from
> sys.dba_dependencies tablespace tools;
> 
> set termout on
> 
> select  '*'||lpad(' ',level+3)||type||'
> '||owner||'.'||name
> from depends
> connect by prior owner = referenced_owner
> and prior name = referenced_name
> and prior type = referenced_type
> start with referenced_owner = upper('&1')
> and referenced_name = upper('&2')
> and owner is not null
> /
> 
> good luck,
> 
> jack silvey
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jack Silvey
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

RE: Upgrade is Necessary?

[Miller, Jay]

Well, I'd take a look at the fixed bug list for the 8.1.7.2 (since several
people have said there are unspecified problems with 8.1.7.3).  It's about a
hundred pages long :), but if nothing there affects you you might be all
right.  I have 2 8.1.7.0 databases that have been running without problems
for about a year.  Of course they're very small, straightforward databases.
I had been planning on patching to 8.1.7.3 next week but put those plans on
hold after reading the posts here.

Jay Miller

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




>  -Original Message-
> From: Hamid Alavi  
> Sent: Wednesday, May 08, 2002 9:04 AM
> To:   'ORACLE-L (E-mail)
> Subject:  Upgrade is Necessary?
> 
> Hi List,
> 
> May be is silly question but want to know, do I need at all to upgrade
> from 8.1.7.0 to any patch(2 or 3) or not?
> What's wrong with 8.1.7.0?
> We are in development phase and very soon will deliver the application and
> using at the moment 8.1.7.0.
> Do I have to Upgrade at all or no need for that?
> 
> Thanks alot for Help.
> 
> 
> 
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> 
> 
> 
> 
> 
=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  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: too low optimizer_index_cost_adj causing bizarre index choice

[Miller, Jay]

Is this surprising?  I still remember an Oracle presentation when 8i was
first coming out and the Oracle rep answered a question about hints by
saying that no one should use hints any more because the optimizer always
used the best path.

Half the room burst out laughing :).

Jay Miller

-Original Message-
Sent: Thursday, May 09, 2002 11:43 PM
To: Multiple recipients of list ORACLE-L
choice


Even Oracle was reluctant
to admit that it was accessing a wacko index until I
pressed them for it. I asked them to give me the
relevant CBO code, but noo, not even a decent
10053 doc.


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

e: locks, not cronjob!

[Sherman, Paul R.]

Hello,

Sorry about the screw-up in the subject. It should be "locks". Dreaming
about the week-end, I suppose.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 10, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L


Hello,

Has anyone ever tried setting dml_locks to zero or disabling table locks on
an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing
contention and freeing up resources ? We currently use 7,250
dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say:

Obtaining table locks, such as DML locks, for inserts, deletes, and updates
can
diminish performance in Oracle Parallel Server. Locking a table in Oracle
Parallel
Server is undesirable because all instances holding locks on the table must
release
those locks. Consider disabling these locks entirely using one of the two
methods
described under the following headings:

 Disabling Table Locks
 Setting DML_LOCKS to Zero

We found, of our 200MB shared pool, that 108MB was taken up by State
objects, gc_*, and dlm shared memory (100,000 gc_releasable_locks),
frequently leaving us with just 3-6MB of shared pool free and getting
occasional 4031's, so next week, plan on reducing the granularity
considerably by setting gc_files_to_locks as 1=500R:2-600=100REACH, and
gc_releasable_locks to roughly 30,000 (doing the math, you get 22,600 for
the 1 system datafile and 221 other datafiles; we added 7,400 locks for 74
datafiles future growth). Adding up non-PCM and PCM locks would result in
needing 120,123 for lm_ress and 180,185 for lm_locks.

Any assistance would be both informative and appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul 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: Sherman, Paul 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).

AFTER CREATE trigger help, please

[Magaliff, Bill]

I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
OR sys.dictionary_obj_type='SEQUENCE'
then

begin
 dbms_output.put_line ('TEST');
 dbms_output.put_line (sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
exception
when others then 
dbms_output.put_line ('ERROR');

end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . .
. 

any ideas, please??

thanks, all

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

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

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

[DENNIS WILLIAMS]

Amol - I think that you are on the right track, looking at LD_LIBRARY_PATH.
Possibly you don't have that variable set just quite right, or it isn't set
when you issue the lsnrctl. You can check the setting by entering "env" just
before you issue lsnrctl. Try to check for extra characters or non-printing
characters. Try to find someone that knows more about Unix to look over your
shoulder.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 10, 2002 2:48 AM
To: Multiple recipients of list ORACLE-L


Hi All

I have problem related to listener. On my machine I have Oracle 
8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the 
following error message

lsnrctl: error in loading shared libraries: libskgxp8.so: cannot 
open shared object file: No such file or directory
I have downloaded the library from rpmfind.net and installed it 
 from root user on my machine. My file libskgxp8.so is located in 
$ORACLE_HOME/lib.
However still when I say $ lsnrctl then I get the above error. Is 
that file is not used or what? I have also restarted my machine 
but it is still not working.

I already have these settings in my .bash_profile. But it is not 
working. Does anyone has the solution for this problem?

LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export 
LD_LIBRARY_PATH


Amol
_
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Sherman, Paul R.]

A la Ned Flanders, absolu-tiv-tiv-tively! Especially if you plan on usingem.

Thank you,

Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 10, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L


Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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

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

RE: too low optimizer_index_cost_adj causing bizarre index choice

[Jack Silvey]

ROFL over here over this one. Wish I could have been
there. 

I hear that in 9i you won't need a DBA anymore!


jack


--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Is this surprising?  I still remember an Oracle
> presentation when 8i was
> first coming out and the Oracle rep answered a
> question about hints by
> saying that no one should use hints any more because
> the optimizer always
> used the best path.
> 
> Half the room burst out laughing :).
> 
> Jay Miller
> 
> -Original Message-
> Sent: Thursday, May 09, 2002 11:43 PM
> To: Multiple recipients of list ORACLE-L
> choice
> 
> 
> Even Oracle was reluctant
> to admit that it was accessing a wacko index until I
> pressed them for it. I asked them to give me the
> relevant CBO code, but noo, not even a decent
> 10053 doc.
> 
> 
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

[Don Granaman]

Actually, I don't think the company is all that bad now.  In fact, I would have 
preferred to keep
the company name out of it.

Also, I should have put this into a context.  At the time this was written, upper 
management had
started an intimidation campaign.  They were doing some layoffs, but rather than do it 
in any kind
of normal fashion, they were laying off one or two people per day - and making a 
spectacle of it.
They would come around to the victim and force them to stop whatever they were doing 
immediately and
parade them out of the building with a security escort.  They were not allowed to even 
log off,
finish a line of code, or pick up personal items - which were instead to be shipped to 
their home.
After about a week or two of this, I happened to be on an elevator with a VP and a 
director (ones I
didn't really know) - just the three of us.  They started talking, for my benefit 
obviously, about
the success of their "let's put the fear of God into our employees" (a direct quote) 
strategy.  It
was then that I decided it wasn't someplace I wanted to stay.  That night, I wrote up 
this
resignation - as a sort of counter-attack.  The next morning, I came in, packed up 
most of my stuff,
took it to the car, and submitted the letter to about three layers of management above 
me, the
managers whose projects I was working on, one of the owners of the company, and HR.  
Most were
included only because I wanted them to know why I was actually leaving, not some 
distorted version
they might get through the bureaucracy.  I also sent a fairly comprehensive turnover 
document to one
of my co-workers (Mike M.), as I knew that this wouldn't be considered as an essential 
part of the
exit process.  About three hours later I was called up to HR.  The director of the 
division I worked
for was there, as well as the HR person.  The HR person said that they had "chosen to 
terminate my
employment effective immediately".  I said "So, you are accepting my resignation?" and 
she turned
bright red and glowered at me.  She said that I wouldn't be able to return to my cube 
- that
security would escort me out of the building directly from her office.  I told them 
that all I had
left there was one small box of books that belonged to me.  This director was actually 
a very
sensible and technical guy who had come up through the ranks.  He told the HR clown 
that he would go
back with me and escort me out.  We went back to my cube, he carried the box out to my 
car for me,
and told me "Well, at least maybe this will do some good".

I think they slacked up a bit after that.  I still have friends who work there.  About 
a year after
I left, I saw one of my past managers at a user group meeting.  He is now a VP I 
believe.  He said
that if I ever decided I could work there again, to give him call.  About two years 
after I left, I
went back out there for a visit and was greeted warmly by former co-workers and even a 
few managers.

I think that the reason that, as Matt said, this became "legendary" is only because it 
was a sort of
"suicide attack" against the arrogance and stupidity that existed in some upper 
management circles
at that time.  I was the first "martyr", but quite a number of others also resigned 
within the next
few months (none so flamboyantly though).  Of the group (ET) of twenty that I was in, 
well over half
had left (voluntarily) within a year.  Matt was among the "defectors", as was our 
manager and a
large percentage of the other senior technical people.

Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 9:33 AM


> Don,
>
> And, of course, since it was a resignation letter, the company probably just
> filed it away.  I'll give you the "Brass Cajones" award though, for setting
> the record straight.
>
> Just curious, is the company still around?  Need to make sure to avoid it in
> the future!  :)
>
> Tom Mercadante
> Oracle Certified Professional

-- 
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 line containing: UNSUB ORACLE-L
(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: too low optimizer_index_cost_adj causing bizarre index choice

[Vergara, Michael (TEM)]

Where've you been?  According to Oracle, customers haven't
needed a DBA since version 7.

-Original Message-
Sent: Friday, May 10, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
choice


ROFL over here over this one. Wish I could have been
there. 

I hear that in 9i you won't need a DBA anymore!


jack


--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Is this surprising?  I still remember an Oracle
> presentation when 8i was
> first coming out and the Oracle rep answered a
> question about hints by
> saying that no one should use hints any more because
> the optimizer always
> used the best path.
> 
> Half the room burst out laughing :).
> 
> Jay Miller
> 
> -Original Message-
> Sent: Thursday, May 09, 2002 11:43 PM
> To: Multiple recipients of list ORACLE-L
> choice
> 
> 
> Even Oracle was reluctant
> to admit that it was accessing a wacko index until I
> pressed them for it. I asked them to give me the
> relevant CBO code, but noo, not even a decent
> 10053 doc.
> 
> 
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

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

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

[Paul Baumgartel]

I don't have an answer, but I do wish to point out that your ""
should be "XL".  Roman numeral innumeracy:  a growing problem?




__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

[DENNIS WILLIAMS]

Peter - It depends. If you are a big user of OEM today, then you'll probably
want them. In the long run they are probably a little like OEM itself.
Excellent for getting novices into the Oracle game, but eventually you must
learn what is beneath the tool. I found that STATSPACK offered better
information and was easier to use and especially to automate. Management
likes GUI tools because they can walk past and see some impressive graphs. I
don't like the fact that Oracle has chosen to limit these tools to EE. It is
ridiculous to make me pay a stiff price for an optional tool and then tell
me I can't use it with all my databases.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 10, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L


Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Ray Stell]

On Thu, May 09, 2002 at 03:23:24PM -0800, MacGregor, Ian A. wrote:
> I have learned some rudimentary gnuplot skills.  Each morning  I
produce graphs of what went on the in the databases the previous day on
and hour by hour basis.  If  something is really askew  I break the
hour down into ten minute blocks.  This helps me to better recognize
patterns of database usage.
-- 

Can you talk about your data collection methodology?
===
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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Cherie_Machler]

Peter,

I guess it depends on whether you have any other monitoring and/or
performance tuning tools that you use.If you do, there may be quite a
bit of duplication of features provided.If you don't have any other
automated tools that provide performance monitoring and tuning
capabilities, these have a large number of features and capabilities that
the base OEM doesn't offer.

One thing that I should note is that we decided not to implement the
enhanced monitoring capabilities because we had to have a modem in order to
implement the paging option.   Our company does not have modems internally,
for security reasons.

So we are not using OEM as fully as we could and are licensed for.

Another thing I should note is that I have heard that OEM starts to degrade
when large numbers of nodes are monitored.   So if you have a large number
of databases, etc. to monitor (I think the documntation states more than
50), you need to design a heavy-duty implementation and give it some real
thought.   You might also need to pass on OEM if you have a really large
network.

I would suggest that you load it up and do a small prototype on a test
database.   It should only take a couple of days to check it out.   If the
features look promising, you could do a larger test involving more
databases and more people.

Cherie Machler
Oracle DBA
Gelco Information Network


   

"Schauss, Peter"   

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

Sent by: Subject: Oracle Diagnostic and Tuning 
Packs   
[EMAIL PROTECTED]   

   

   

05/10/02 10:58 AM  

Please respond to  

ORACLE-L   

   

   





Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]

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

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

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




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

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

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

RE: Oracle Diagnostic and Tuning Packs

[Jesse, Rich]

For around the same money (I think...maybe before the pricing restructure),
I like Spotlight On Oracle from Quest.  Excellent drilldown capabilities,
MUCH better GUI, and for management, it's cooler-looking too.

Trials are free.  Just expect a call from a salesman.

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


> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 10, 2002 11:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Diagnostic and Tuning Packs
> 
> 
> Peter - It depends. If you are a big user of OEM today, then 
> you'll probably
> want them. In the long run they are probably a little like OEM itself.
> Excellent for getting novices into the Oracle game, but 
> eventually you must
> learn what is beneath the tool. I found that STATSPACK offered better
> information and was easier to use and especially to automate. 
> Management
> likes GUI tools because they can walk past and see some 
> impressive graphs. I
> don't like the fact that Oracle has chosen to limit these 
> tools to EE. It is
> ridiculous to make me pay a stiff price for an optional tool 
> and then tell
> me I can't use it with all my databases.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

[Whittle Jerome Contr NCI]

Title: RE: Asinine security workarounds in Oracle, Part III






Paul,


Does that mean some of the films I have at home are sequels with 29 other episodes?





Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Paul Baumgartel [SMTP:[EMAIL PROTECTED]]


I don't have an answer, but I do wish to point out that your ""

should be "XL".  Roman numeral innumeracy:  a growing problem?

Re: Server upgrade NT4 -> W2K Oracle implications

[Thomas Day]

Recreating the C: drive will definitely destroy your Oracle registry
entries and your Oracle and listener services.  Doing an in-place upgrade
should not and will also give you a more stable server.  Ghosting is much
easier but it can produce an unstable machine that will intermittently
suffer a GPF for no apparent reason.  I can understand why a company
bringing in 500 new machines will resort to ghosting but to do it for just
a single machine ... I can't justify that in my own mind.

Have them do the NT to 2K upgrade rather than recreate the C: partition.



   

"O'Neill,  

Sean"To: Multiple recipients of list ORACLE-L  



@organon.ie> cc:   

Sent by: rootSubject: Server upgrade NT4 -> W2K Oracle 

 implications  

   

05/09/2002 

06:47 PM   

Please 

respond to 

ORACLE-L   

   

   





We have an 8.1.7 SE database on a server which is currently NT4 SP6.  The
System Admin group wish to upgrade the server to W2K and propose doing so
by
recreating the C: partitition.  Our Oracle software resides on E: (same
physical disk) and database files on other disks/partitions.  Are there any
implications for the Oracle software and database for this upgrade.  Are
there any steps I need to take pre or post OS upgrade?.  In particular I'm
wondering about implications for the registry.
Any advice/help would be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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



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

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

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

[DENNIS WILLIAMS]

Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefly
covers RMAN, no classroom exercises), and felt I was getting nowhere. I
needed some concrete practice exercises. 
About half of Backup & Recovery 101 is devoted to RMAN. He takes you
step-by-step through creating a practice database, creating an RMAN catalog
database, configuring RMAN, performing backups, listing RMAN information
from both the RMAN catalog and the target database control file, performing
recoveries using RMAN, creating an RMAN duplicate database, creating an RMAN
standby database, and performing an RMAN tablespace point-in-time recovery.
Each chapter has several relevant exercises to work through.
He has instructions for both Linux and NT, but he worked the
exercises on Linux, so for NT you will have to adjust more, but there is
probably enough information for you to succeed. I used the Linux
instructions on a Unix system and had no problems, other than the fact that
my practice system is Oracle 8.1.6 and his instructions are for Oracle
8.1.7. But the adjustments were simple and even added to my learning.
So, if you are considering RMAN, but don't know where to start, I
enthusiastically recommend that you buy Oracle Backup & Recovery 101.
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J&;
mscssid=G50N06L3282V9M7H7E1C63LT2FLNDC69&isbn=0072194618
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, April 09, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


FWIW -- 
Oracle Press recently published a "Backup & Recovery 101" book by Kenny
Smith and Stephan Haisley. 
I have not yet read it, but it claims to have RMAN coverage. 
Since it is part of the '101' series, I presume it covers most of the basic
stuff. 
Has anyone purchased it? And read it? 
I may check it out at IOUG-A next week :) 

Regards,

- Kirti  
 

-Original Message-
Sent: Tuesday, April 09, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


I'm contemplating doing an Rman backup and recovery handbook. I'm wondering
what you would like to see in such a book and would you use such a book?
Ideas and comments welcome.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, April 08, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L


I don't think you can do it.. I mean, you could change it to trunc the
oracle_date field (that eliminates the minutes) and then do a to_date
of :b1 but you will still be operating on the oracle_date field.

Okay, I HATE to suggest this, but since the table is small:

add another field to the table oracle_date_2 as a date field. Update
the table set oracle_date_2=trunc(oracle_date)

add a trigger to fill in oracle_date_2 when you insert a row or update
the oracle_date column


create an index on oracle_date_2 and change the query to use that
column


--- [EMAIL PROTECTED] wrote:
> 
> I've got the following SQL statement that is running very long on a
> nightly
> data load.   The problem is the TO_CHAR function which is preventing
> me from using the index on this small (20,000-row table).
> 
> This is an 8.0.4 database so it is not possible for me to use
> make this a function-based index.
> 
> The problem is that the date field has minutes, etc. included and
> those need to be eliminated before the comparison can be made.
> That's why I can't just eliminate the TO_CHAR from both sides
> of the equation.
> 
> Isn't there a way that I can pull this function out of the select
> statement
> and do it in a preceeding statement?   Then I could just pass in both
> variables to this statement without the TO_CHAR and use my index.
> 
> Is this realistic?  How, exactly could it be done?
> 
> 
> SELECT DATE_KEY
> FROM DATE_DIM
> WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') =
> TO_CHAR(:b1,'DD-MON-')
> 
> 
> SQL> desc date_dim;
>  NameNull?Type
>  ---  
>  DATE_KEYNOT NULL NUMBER(5)
>  ORACLE_DATE NOT NULL DATE
>  DATACOM_DATE NUMBER(6)
>  DATACOM_REVERSE_DATE NUMBER(6)
>  DAY_OF_WEEK NOT NULL VARCHAR2(30)
>  DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3)
>  DAY_NUMBER_OVERALL  NOT NULL NUMBER(9)
>  WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3)
>  WEEK_NUMBER_OVERALL NOT NULL NUMBER(7)
>  MONTH   NOT NULL VARCHAR2(30)
>  MONTH_NUMBER_OVERALL  

Re:Oracle Diagnostic and Tuning Packs

[dgoulet]

We've go them & I think so.

Dick Goulet


Reply Separator
Author: "Schauss; Peter" <[EMAIL PROTECTED]>
Date:   5/10/2002 7:58 AM

Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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

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

data warehousing desing - to denormalize or not to denormalize - that is the question

[Gurelei]

Hi.

We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and tuning. What are the
disadvantages that we should be aware of? Wasted space
is not an issue because the tables a pretty small.
What else should we consider as a potential issue?

thank you

__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

[Jared . Still]

Bill,

A trigger cannot display output.

Where would it go?  A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.

Jared





"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 09:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:AFTER CREATE trigger help, please


I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
 OR sys.dictionary_obj_type='SEQUENCE'
then

 begin
  dbms_output.put_line ('TEST');
  dbms_output.put_line 
(sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
 exception
 when others then 
 dbms_output.put_line 
('ERROR');

 end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . 
.
. 

any ideas, please??

thanks, all

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

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

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



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

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

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

RE: Upgrade is Necessary?

[Gene Sais]

I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem.  I patch 
only when its broke.  Or for a new install, e.g. waiting for 9i rel 2 w/ its patches 
before I start the upgrade process.

FWIW,
Gene

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

RE: AFTER CREATE trigger help, please

[Magaliff, Bill]

ok - thanks
i edited the trigger to insert a row into a dummy table, just to see if it
works, and all works fine.

Now - the next piece.
I want this trigger to call a stored procedure that runs as an autonomous
txn and creates a public synonym for the newly-created table.

I've verified independently that the proc works (from the SQL*Plus command
line) and I know now that the trigger is being called, based on the previous
test.

so why wouldn't the public synonym be created?

THANKS!

**

Here's the text of the new trigger and procedure:

CREATE OR REPLACE procedure CREATE_SYNONYMS (
p_lwowner varchar2,
p_objname varchar2,
p_objtype varchar2) AS

pragma autonomous_transaction;
v_lwowner varchar2(30) := p_lwowner;
v_objname varchar2(30) := p_objname;
v_objtype varchar2(30) := p_objtype;
v_sql varchar2(200);

begin
v_sql := 'create public synonym ' || v_objname || ' for ' ||
v_lwowner || '.' || v_objname;
execute immediate (v_sql);

end;
/


CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
  OR sys.dictionary_obj_type='SEQUENCE'  then
 begin
create_synonyms ('lwdev', sys.dictionary_obj_name,
sys.dictionary_obj_type);
   exception
when others then null;

   end;

   end if;

end;
/


-Original Message-
Sent: Friday, May 10, 2002 1:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Bill,

A trigger cannot display output.

Where would it go?  A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.

Jared





"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 09:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:AFTER CREATE trigger help, please


I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
 OR sys.dictionary_obj_type='SEQUENCE'
then

 begin
  dbms_output.put_line ('TEST');
  dbms_output.put_line 
(sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
 exception
 when others then 
 dbms_output.put_line 
('ERROR');

 end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . 
.
. 

any ideas, please??

thanks, all

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

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

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


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

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

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

RE: Upgrade is Necessary?

[Jared . Still]

I'm upgrading a couple of boxes to 8.1.7.2 simply because
that is the earliest version in which Oracle Names checkpoints
actually work.

Jared






"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 08:58 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Upgrade is Necessary?


Well, I'd take a look at the fixed bug list for the 8.1.7.2 (since several
people have said there are unspecified problems with 8.1.7.3).  It's about 
a
hundred pages long :), but if nothing there affects you you might be all
right.  I have 2 8.1.7.0 databases that have been running without problems
for about a year.  Of course they're very small, straightforward 
databases.
I had been planning on patching to 8.1.7.3 next week but put those plans 
on
hold after reading the posts here.

Jay Miller

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




>  -Original Message-
> From:  Hamid Alavi 
> Sent:  Wednesday, May 08, 2002 9:04 AM
> To:'ORACLE-L (E-mail)
> Subject:   Upgrade is Necessary?
> 
> Hi List,
> 
> May be is silly question but want to know, do I need at all to upgrade
> from 8.1.7.0 to any patch(2 or 3) or not?
> What's wrong with 8.1.7.0?
> We are in development phase and very soon will deliver the application 
and
> using at the moment 8.1.7.0.
> Do I have to Upgrade at all or no need for that?
> 
> Thanks alot for Help.
> 
> 
> 
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> 
> 
> 
> 
> 
=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement = 


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

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

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

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

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

Locks and Waits

[Reddy, Madhusudana]

Hello All,
Here is the result I have got from the v$session_event 


 SID EVENT
TIME_WAITED
 
---
  22 direct path read
109
  20 db file scattered read
125
  24 db file scattered read
160
  26 SQL*Net more data to client
162
  26 db file scattered read
191
  26 db file sequential read
230
  26 log file sync
240
  27 db file sequential read
398
  24 db file sequential read
415
  22 rdbms ipc reply
533
  20 db file sequential read
603
  24 log file sync
813
  24 latch free
904
  20 log file sync
917
  27 log file sync
966
  26 latch free
983
  27 latch free
2779
  20 latch free
3212
  22 db file scattered read
4319
  24 SQL*Net message from client
5583
  20 SQL*Net message from client
6261
  27 SQL*Net message from client
7286
  22 db file sequential read
8883
  22 latch free
16164
  26 SQL*Net message from client
56266
  26 row cache lock
6487782
  27 library cache lock
7433464
  20 library cache lock
7433918
  22 library cache lock
7435227
  24 row cache lock
7435680

Could somebody explain me , what are thsese Librarycache Lock  and Row cache
lock, and what should I do..

I could see lot of locks on the database.. and batch jobs are going very
slow , taking hours ...

Seems to me like something is happening on database, any idea ???

Pl response will be very much appreciated.

Thanks,
Madhu


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

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

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

Joys of having an intern

[jkstill]

I hope you will all forgive this slightly off topic post.

You may find it a bit interesting.  There's also a punch
line for all the codgers among us.  ;)

Jared

-


Joys of having an intern

If you have ever had the privilege of having a fresh faced
intern at your side, one that is still in school and still
has a couple of years to go, you can probably identify
with this missive.

If not, well, you may just want one of your own.

Or not.

Our groups manager signed us up with an intern program from
one of the state universities.  One of my coworkers was to
work with him first, and had a number of tasks lined out
for him.

This coworker unfortunately left the company the week before
the intern was due to arrive.  So you can guess who was dutifully
assigned on short notice to put him to work.  :)

I had previously decided that his efforts would be directed
toward implementing Oracle Names at our headquarters. I've
been here less than a year, and though the tnsnames.ora-on-
every-desktop had been a thorn in my side at times, it was
nonetheless not a high priority item.

Perfect.  I can get rid of this plague of tnsnames.ora locusts,
and someone else can do the work!

Wrong.

First let me say that the student intern is a very bright young
man of 20 years old, and is majoring in business information
systems.  He has obviously spent some time with computers
before entering college.  This time has all been spent in
Windoze environments however.  He has never ( no, *never* )
done anything from a command line.

Hmmm This may require some education.

This intern is in addition to being intelligent, a very polite
and nice young man.

Secondly, let me say that it would have been easier, faster,
cheaper and less stressful to do this myself.  Not to say
that this effort is without its rewards.

There is a certain amount of satisfaction that goes along with
teaching someone to do your job.  You get to teach it to them
the way you think it should be done for instance.

There was a point where after a few days a of struggling with
the assignments I had given him, a lot of it came together for
him.  He was excited that much of the stuff I had been discussing
with him was now actually making sense. The excitement was
contagious.

He now has a good understanding of Oracle Names, and could probably
do most of the implementation himself.  Since it will be done
on production servers, I will do it, and he will have to be
content to watch.

There are other, less altruistic forms of gratification that can
be achieved from having an intern.  This comes in the form of
the ego boosting that occurs when you see a bright young fellow
struggling for several hours with the latest assignment.

An assignment that you spent 90 minutes outlining in a document
with plenty of hints of what to do, and all of the code 90%
done with just a few fill-in-the-blanks sections.

An assignment that you just did yourself, in 15 minutes.  ;)




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

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

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

RE: AFTER CREATE trigger help, please

[Grabowy, Chris]

Actually...

SQL> create or replace trigger test
  2  after insert on test_table
  3  begin
  4  dbms_output.put_line ('Hello from trigger!!!');
  5  end;
  6  /

Trigger created.

Elapsed: 00:00:00.02
SQL> insert into test_table values ('Hello');
Hello from trigger!!!

1 row created.

Elapsed: 00:00:00.06

Execution Plan
--
   0  INSERT STATEMENT Optimizer=CHOOSE




Statistics
--
  3  recursive calls
  5  db block gets
  7  consistent gets
  0  physical reads
372  redo size
550  bytes sent via SQL*Net to client
627  bytes received via SQL*Net from client
  4  SQL*Net roundtrips to/from client
  2  sorts (memory)
  0  sorts (disk)
  1  rows processed

SQL> 

Bill, I would simplify the trigger, and then work out from there.

Chris

-Original Message-
Sent: Friday, May 10, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L


Bill,

A trigger cannot display output.

Where would it go?  A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.

Jared





"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 09:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:AFTER CREATE trigger help, please


I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
 OR sys.dictionary_obj_type='SEQUENCE'
then

 begin
  dbms_output.put_line ('TEST');
  dbms_output.put_line 
(sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
 exception
 when others then 
 dbms_output.put_line 
('ERROR');

 end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . 
.
. 

any ideas, please??

thanks, all

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

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

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

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

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

RE: Rman ... what do YOU need

[Rachel_Carmichael]

Folks, just a word of warning. Through NO FAULT of the authors, there are a
number of errata in the first edition of the book.

There is a complete errata list on the Osborne site:

http://shop.osborne.com/cgi-bin/oraclepress/errata.html


Page proofing is one of the worst tasks on earth (I know, I'm doing it now for
the 9i version of DBA 101). We found one chapter that is totally messed up, we
had to have it resubmitted to be put into proofs. With deadlines and print
schedules what they are (TIGHT), we are lucky that there is time to redo it
before the book comes out in June.

Rachel





|+--->
||   |
||   |
||  DWILLIAMS@lif|
||  etouch.com   |
||   |
||  05/10/2002   |
||  01:58 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: Rman ... what do YOU need   |
  >|




Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefly
covers RMAN, no classroom exercises), and felt I was getting nowhere. I
needed some concrete practice exercises.
   About half of Backup & Recovery 101 is devoted to RMAN. He takes you
step-by-step through creating a practice database, creating an RMAN catalog
database, configuring RMAN, performing backups, listing RMAN information
from both the RMAN catalog and the target database control file, performing
recoveries using RMAN, creating an RMAN duplicate database, creating an RMAN
standby database, and performing an RMAN tablespace point-in-time recovery.
Each chapter has several relevant exercises to work through.
   He has instructions for both Linux and NT, but he worked the
exercises on Linux, so for NT you will have to adjust more, but there is
probably enough information for you to succeed. I used the Linux
instructions on a Unix system and had no problems, other than the fact that
my practice system is Oracle 8.1.6 and his instructions are for Oracle
8.1.7. But the adjustments were simple and even added to my learning.
   So, if you are considering RMAN, but don't know where to start, I
enthusiastically recommend that you buy Oracle Backup & Recovery 101.
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J&;
mscssid=G50N06L3282V9M7H7E1C63LT2FLNDC69&isbn=0072194618
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, April 09, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


FWIW --
Oracle Press recently published a "Backup & Recovery 101" book by Kenny
Smith and Stephan Haisley.
I have not yet read it, but it claims to have RMAN coverage.
Since it is part of the '101' series, I presume it covers most of the basic
stuff.
Has anyone purchased it? And read it?
I may check it out at IOUG-A next week :)

Regards,

- Kirti


-Original Message-
Sent: Tuesday, April 09, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


I'm contemplating doing an Rman backup and recovery handbook. I'm wondering
what you would like to see in such a book and would you use such a book?
Ideas and comments welcome.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, April 08, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L


I don't think you can do it.. I mean, you could change it to trunc the
oracle_date field (that eliminates the minutes) and then do a to_date
of :b1 but you will still be operating on the oracle_date field.

Okay, I HATE to suggest this, but since the table is small:

add another field to the table oracle_date_2 as a date field. Update
the table set oracle_date_2=trunc(oracle_date)

add a trigger to fill in oracle_date_2 when you insert a row or update
the oracle_date column


create an index on oracle_date_2 and change the query to use that
column


--- [EMAIL PROTECTED] wrote:
>
> I've got the following SQL statement that is running very long on a
> nightly
> data load.   The problem is the TO_CHAR function which is preventing
> me from using the index on this small (20,000-row table).
>
> This is an 8.0.4 database so it is not possi

why does DBCA (DB Create Assist) reassign default tablesepace for

[Magaliff, Bill]

Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?

This is a separate script it runs at the end, after the db and data
dictionary are both created.

thought system should have system tablespace as default, no?

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

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

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

RE: Upgrade is Necessary?

[Hamid Alavi]

Thanks, so I can survive with 8.1.7.0 specially for development Env.


-Original Message-
Sent: Friday, May 10, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L


I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem.
I patch only when its broke.  Or for a new install, e.g. waiting for 9i rel
2 w/ its patches before I start the upgrade process.

FWIW,
Gene

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





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


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

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

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

[Grabowy, Chris]

Limited yes, but invaluable when debugging a trigger, and other possible
uses.

Chris

-Original Message-
Sent: Friday, May 10, 2002 2:33 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris


Chris,

Well, dang, it does work!

Guess I should have tried it myself first.

It will only work from SQL Plus though, or other
tools that capture DBMS_OUTPUT.

Oracle must send it to the big bit bucket in the
sky otherwise.

Jared







"Grabowy, Chris" <[EMAIL PROTECTED]>
05/10/2002 11:25 AM

 
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: 
Subject:RE: AFTER CREATE trigger help, please


Actually...

SQL> create or replace trigger test
  2  after insert on test_table
  3  begin
  4  dbms_output.put_line ('Hello from trigger!!!');
  5  end;
  6  /

Trigger created.

Elapsed: 00:00:00.02
SQL> insert into test_table values ('Hello');
Hello from trigger!!!

1 row created.

Elapsed: 00:00:00.06

Execution Plan
--
   0  INSERT STATEMENT Optimizer=CHOOSE




Statistics
--
  3  recursive calls
  5  db block gets
  7  consistent gets
  0  physical reads
372  redo size
550  bytes sent via SQL*Net to client
627  bytes received via SQL*Net from client
  4  SQL*Net roundtrips to/from client
  2  sorts (memory)
  0  sorts (disk)
  1  rows processed

SQL> 

Bill, I would simplify the trigger, and then work out from there.

Chris

-Original Message-
Sent: Friday, May 10, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L


Bill,

A trigger cannot display output.

Where would it go?  A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.

Jared





"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 09:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc: 
Subject:AFTER CREATE trigger help, please


I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
 OR sys.dictionary_obj_type='SEQUENCE'
then

 begin
  dbms_output.put_line ('TEST');
  dbms_output.put_line 
(sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
 exception
 when others then 
 dbms_output.put_line 
('ERROR');

 end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . 
.
. 

any ideas, please??

thanks, all

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

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

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

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

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

RE: AFTER CREATE trigger help, please

[Jared . Still]

Chris,

Well, dang, it does work!

Guess I should have tried it myself first.

It will only work from SQL Plus though, or other
tools that capture DBMS_OUTPUT.

Oracle must send it to the big bit bucket in the
sky otherwise.

Jared







"Grabowy, Chris" <[EMAIL PROTECTED]>
05/10/2002 11:25 AM

 
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: 
Subject:RE: AFTER CREATE trigger help, please


Actually...

SQL> create or replace trigger test
  2  after insert on test_table
  3  begin
  4  dbms_output.put_line ('Hello from trigger!!!');
  5  end;
  6  /

Trigger created.

Elapsed: 00:00:00.02
SQL> insert into test_table values ('Hello');
Hello from trigger!!!

1 row created.

Elapsed: 00:00:00.06

Execution Plan
--
   0  INSERT STATEMENT Optimizer=CHOOSE




Statistics
--
  3  recursive calls
  5  db block gets
  7  consistent gets
  0  physical reads
372  redo size
550  bytes sent via SQL*Net to client
627  bytes received via SQL*Net from client
  4  SQL*Net roundtrips to/from client
  2  sorts (memory)
  0  sorts (disk)
  1  rows processed

SQL> 

Bill, I would simplify the trigger, and then work out from there.

Chris

-Original Message-
Sent: Friday, May 10, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L


Bill,

A trigger cannot display output.

Where would it go?  A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.

Jared





"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 09:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc: 
Subject:AFTER CREATE trigger help, please


I'm creating an AFTER CREATE ddl trigger:

CREATE OR REPLACE TRIGGER after_create_trg
  after create
   on lwdev.schema
begin
   if sys.dictionary_obj_type='TABLE'
 OR sys.dictionary_obj_type='SEQUENCE'
then

 begin
  dbms_output.put_line ('TEST');
  dbms_output.put_line 
(sys.dictionary_obj_name || ' , ' ||
sys.dictionary_obj_type);
 exception
 when others then 
 dbms_output.put_line 
('ERROR');

 end;
   end if;

end;
/

Trigger created as user LWDEV

I have serverout set to ON, but I get nothing when creating a new table . 
.
. 

any ideas, please??

thanks, all

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

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

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

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

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

Re: Server upgrade NT4 -> W2K Oracle implications

[Jared . Still]

Doh!

I forgot to mention services.

Thanks Thomas.





Thomas Day <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 11:03 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Server upgrade NT4 -> W2K Oracle implications



Recreating the C: drive will definitely destroy your Oracle registry
entries and your Oracle and listener services.  Doing an in-place upgrade
should not and will also give you a more stable server.  Ghosting is much
easier but it can produce an unstable machine that will intermittently
suffer a GPF for no apparent reason.  I can understand why a company
bringing in 500 new machines will resort to ghosting but to do it for just
a single machine ... I can't justify that in my own mind.

Have them do the NT to 2K upgrade rather than recreate the C: partition.



  
"O'Neill,  
Sean"To: Multiple recipients of 
list ORACLE-L 
   
@organon.ie> cc:  
Sent by: rootSubject: Server upgrade NT4 
-> W2K Oracle 
 implications  
  
05/09/2002  
06:47 PM  
Please  
respond to  
ORACLE-L  
  
  




We have an 8.1.7 SE database on a server which is currently NT4 SP6.  The
System Admin group wish to upgrade the server to W2K and propose doing so
by
recreating the C: partitition.  Our Oracle software resides on E: (same
physical disk) and database files on other disks/partitions.  Are there 
any
implications for the Oracle software and database for this upgrade.  Are
there any steps I need to take pre or post OS upgrade?.  In particular I'm
wondering about implications for the registry.
Any advice/help would be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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



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

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

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



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

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

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

Re:Oracle Diagnostic and Tuning Packs

[Rachel_Carmichael]

supposedly no additional cost in 9i, but when I checked Oracle's store, there
was a $20 charge for each. Considering that for 7.3 and 8.0 they were $100 for
EVERY NAMED USER, regardless of how many people were actually going to use them,
that's "no cost" :)




|+--->
||   |
||   |
||  dgoulet@vicr.|
||  com  |
||   |
||  05/10/2002   |
||  02:33 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re:Oracle Diagnostic and Tuning |
  |   Packs|
  >|




We've go them & I think so.

Dick Goulet


Reply Separator
Author: "Schauss; Peter" <[EMAIL PROTECTED]>
Date:   5/10/2002 7:58 AM

Are these addons to OEM worth buying?

Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]

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

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

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

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

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

[DENNIS WILLIAMS]

Let's see . . . disadvantages . . . hmmm. scorn of anyone that understands
data warehousing? On your resume putting "created a completely normalized
DW" and wondering why everyone giggles when they read it.

Actually, a normalized schema will probably use less space than
denormalized.
The key point is your users. A typical normalized design means a lot of
tables. These tables must be joined in specific manners. Non-I.S. users find
this intimidating. So they don't use it. So you've spent a lot of time
creating a DW only to have nobody use it. 
Normalized schemas are optimized for inserts and updates, not
generating reports. To generate a report from an OLTP normalized schema, you
usually start by interviewing the developers. And they usually have to do
some research. A DW is a "write mostly" schema. Our DW is only refreshed
weekly. Sunday is spent loading it and Monday the users charge in and run
reports all day.
Study star schema. Go to http://www.ralphkimball.com and read
articles he has written, starting with the oldest ones and working forward.
Read Ralph Kimball's book "The Data Warehouse Toolkit: Practical Techniques
for Building Dimensional Data Warehouses". Classic work, excellent starting
point.
A beginning star schema DW should have only a central fact table and
4-6 dimension tables. Non-computer-geeks actually have a hope of
understanding how to navigate that. How many tables did your 3nf schema
produce?
Or go ahead, build a normalized one, then study and build the second
version incorporating the hard-won lessons others have learned.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Friday, May 10, 2002 1:43 PM
To: Multiple recipients of list ORACLE-L
- that is the question


Hi.

We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and tuning. What are the
disadvantages that we should be aware of? Wasted space
is not an issue because the tables a pretty small.
What else should we consider as a potential issue?

thank you

__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[lembark]

-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 10:43:23 -0800

> Hi.
> 
> We are designing a small database using a data
> warehousing desing. We have created a 3rd normal form
> and are now debating whether and how to denormalize
> it. I see the pluses of denormalization - easier
> queries creation and tuning. What are the
> disadvantages that we should be aware of? Wasted space
> is not an issue because the tables a pretty small.
> What else should we consider as a potential issue?

Oracle was designed (and still is) an OLTP tool. It doesn't
do very well with fully denormalized data. Wasted space is
only one problem, bloated indexes are another. You can also
end up with indexes that lack enough entropy for general
use due to repatition, leaving you better off with table
scans in most cases. 

For a small(ish) database there may not be any real 
difference between a snowflake and star schema, but
databases tend to grow. Every time I've dealt with any
denormalized schemas in Oracle they have performed poorly
(or crashed).

--
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: 
  INET: [EMAIL PROTECTED]

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

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

[Danisment Gazi Unal]

Hi,

I resisted, but I decided to join in this thread after reading some indirect
comments about our products.

- As said by others, trace file format is documented. But, there are many-many
traps in raw trace files. Reading them by eyes or by a simple script may give
wrong results. In other words, it's not easy as seen.  I'm sharing my knowlege
if somone posts a question about event 10046 trace files. I've never hided my
knowledge through my life.

- I've developed itrprof in 6 months*15 hours. It consists of 5500+ lines. Many
of you used it. I didn't want to meantion about it. But, If I see "other
products are wrong" in ORACLE-L, I have right to post this. If someone claims
that "others are wrong" they should put the real cases to confirm their
thoughs.I do it. We trust our products as our customers.

- Yes, we are not selling itrprof. We offer it as service. This is our business
policy. You may understand us. We are living in the same world too. But, our
other products iOraBugFinder, iOraHangAnalyzer, iOraDumpReader are free. Many of
you used them. We are giving free support for these products. Some of you got
free support for their ORA-600/ORA-7445 trace files.


Sorry for this kind of email.

btw,

you should not format 8i trace files by tkprof of 9i. Time granularity is
different in 8i and 9i.

danisment...






[EMAIL PROTECTED] wrote:

> Henry,
>
> Thanks for the script..tkprof in 9i has some enhanced functionality which
> includes the wait events from the trace file..which is very similar to what
> your script does in addition to regular tkprof statistics..
>
> I have installed and used 9i tkprof with 8i generated trace file. Works
> fine.
>
> The following is a sample output of the new addition from 9i tkprof.
>
> 
> 
> Elapsed times include waiting on following events:
>   Event waited on Times   Max. Wait  Total
> Waited
>      Waited  --
> 
>   SQL*Net message to client   10.00
> 0.00
>   db file sequential read 40.01
> 0.02
>   SQL*Net message from client 10.00
> 0.00
> 
> 
>
> Also, I would like to thank everyone else for their comments and
> suggestions..
>
> Mohammed Ahsanuddin
> Oracle DBA
>
> -Original Message-
> Sent: Thursday, May 09, 2002 2:46 PM
> To: Multiple recipients of list ORACLE-L
>
> I did write an awk script to summarize the wait events in a 10046 trace
> file. It lists the SQL, and sums the count and time of the waits for the
> SQL.
>
> Henry
>
> #  Script for analyzing Oracle Trace files with WAIT statistics
> #  Usage:  wait_scan.awk 
> #  Written:Henry Poras
> #  5/16/00
> #  Modified:   12/3/01  Initially assumes all wait states for a cursor are
> between
> #   parse statements.
> #
> #
> nawk  '# need nawk,
> not awk
>BEGIN{N=""
>   PARSE_FLAG=0 # PARSE_FLAG
> = 0 (normal state)
>   printf("\n\n%-35s %-12s %-18s\n\n",  # PARSE_FLAG
> = 1 (previous line PARSING)
>  "WAIT EVENT", "# OF TIMES", "ELAPSED TIME (sec)") # print
> column headers
>  }
>
>  {if (PARSE_FLAG==1)   # if previous
> line started
> {SQL[N]=$0 # with
> PARSING, print
>  PARSE_FLAG=0  # the SQL.
> N=""
> }
>  }
>/^PARSING/  {FS=" "
>   N=$4
>   sub("#","",N)
>   if (N in SQL)
> prinfo(N)
>   PARSE_FLAG=1
>  }
>/^WAIT/ {FS="#| nam=|ela=|p1="
>   N=$2
>sub(":","",N)
>   PARSE_FLAG=2
>   n_wait[N,$3] += 1
>   ela_wait[N,$3] += $4
>  }
>END  {for (N in SQL){   # Print Wait
> statistics for final
> printf "\n\n\n%s\n\n", SQL[N]  # SQL
> statement in file
> for (k in n_wait) {
>  split(k,arg,SUBSEP)
>  if (arg[1]==N && n_wait[k]!=0) {
>printf "%-35s %-12s %12.2f\n",
>arg[2],n_wait[k],ela_wait[k]/100
>n_wait[k]=0
>ela_wait[k]=0
>  }
> }
>   printf "\n\n"
>  }
>  for (k in n_wait) {
> split(k,arg,SUBSEP)
> if (n_wait[k] != 0) {
>printf "%-35s %-12s %12.2f\n",
>arg[2],n_wait[k],ela_wait[k]/100
>n_wait[k]=0
>ela_wait[k]=0
> }
>  }
>  }
>
>function prinfo(N, 

RE: Rman ... what do YOU need

[DENNIS WILLIAMS]

Thanks Rachel. To choose between speedy publication (copyright 2002) and
waiting another 6 months for an error-free book, I'll choose speedy.
Especially since I've become increasingly desperate for a good RMAN tutorial
over the past months. And after all, this book is designed to teach you to
BACKUP your database. And honestly, I haven't noticed the typos. But I do
appreciate your pointing out the errata site.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L




Folks, just a word of warning. Through NO FAULT of the authors, there are a
number of errata in the first edition of the book.

There is a complete errata list on the Osborne site:

http://shop.osborne.com/cgi-bin/oraclepress/errata.html


Page proofing is one of the worst tasks on earth (I know, I'm doing it now
for
the 9i version of DBA 101). We found one chapter that is totally messed up,
we
had to have it resubmitted to be put into proofs. With deadlines and print
schedules what they are (TIGHT), we are lucky that there is time to redo it
before the book comes out in June.

Rachel





|+--->
||   |
||   |
||  DWILLIAMS@lif|
||  etouch.com   |
||   |
||  05/10/2002   |
||  01:58 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: Rman ... what do YOU need   |
  >|




Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefly
covers RMAN, no classroom exercises), and felt I was getting nowhere. I
needed some concrete practice exercises.
   About half of Backup & Recovery 101 is devoted to RMAN. He takes
you
step-by-step through creating a practice database, creating an RMAN catalog
database, configuring RMAN, performing backups, listing RMAN information
from both the RMAN catalog and the target database control file, performing
recoveries using RMAN, creating an RMAN duplicate database, creating an RMAN
standby database, and performing an RMAN tablespace point-in-time recovery.
Each chapter has several relevant exercises to work through.
   He has instructions for both Linux and NT, but he worked the
exercises on Linux, so for NT you will have to adjust more, but there is
probably enough information for you to succeed. I used the Linux
instructions on a Unix system and had no problems, other than the fact that
my practice system is Oracle 8.1.6 and his instructions are for Oracle
8.1.7. But the adjustments were simple and even added to my learning.
   So, if you are considering RMAN, but don't know where to start, I
enthusiastically recommend that you buy Oracle Backup & Recovery 101.
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J&;
mscssid=G50N06L3282V9M7H7E1C63LT2FLNDC69&isbn=0072194618
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, April 09, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


FWIW --
Oracle Press recently published a "Backup & Recovery 101" book by Kenny
Smith and Stephan Haisley.
I have not yet read it, but it claims to have RMAN coverage.
Since it is part of the '101' series, I presume it covers most of the basic
stuff.
Has anyone purchased it? And read it?
I may check it out at IOUG-A next week :)

Regards,

- Kirti


-Original Message-
Sent: Tuesday, April 09, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


I'm contemplating doing an Rman backup and recovery handbook. I'm wondering
what you would like to see in such a book and would you use such a book?
Ideas and comments welcome.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, April 08, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L


I don't think you can do it.. I mean, you could change it to trunc the
oracle_date field (that eliminates the minutes) and then do a to_date
of :b1 but you will still be operating on the oracle_date field.

Okay, I HATE to suggest this, but sinc

Re: data warehousing desing - to denormalize or not to denormalize - that

[Gurelei]

Jared,

Thanks for the answer. I must admit my ignorance in
terminology as for me data warehouse and data mart a
pretty much the same thing except for size. I
understand that data mart is smaller. The database I'm
referring to could probably be described as data mart
as it is going to be rather small - a gig or so maybe.


--- [EMAIL PROTECTED] wrote:
> One philosophy of DW states that you build a DW that
> is
> fairly normalized, much like an OLTP database,
> albeit one
> with a temporal component and complete logging of
> transactions
> within the data.
> 
> This is then used as a warehouse.  The data from the
> DW is used
> to assemble data marts. These data marts are queried
> by users.
> 
> They never look at the data warehouse.
> 
> So to answer your question:  It depends. 
> 
> * On how much time you have
> *  do you want the ability to create new data marts
> without adding to
> the ETL system ? ( it should already be getting
> everything you need )
> 
> Since you already have something that looks like a
> DW, why not
> use that to build data marts that employ star
> schemas and bitmap 
> indexes?  They are easier to query, and faster.
> 
> I believe both Kimball and Inmon subscribe to this
> philosphy.
> 
> Jared
> 
> 
> 
> 
> 
> 
> Gurelei <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/10/2002 11:43 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:data warehousing desing - to
> denormalize or not to denormalize - that is 
> the question
> 
> 
> Hi.
> 
> We are designing a small database using a data
> warehousing desing. We have created a 3rd normal
> form
> and are now debating whether and how to denormalize
> it. I see the pluses of denormalization - easier
> queries creation and tuning. What are the
> disadvantages that we should be aware of? Wasted
> space
> is not an issue because the tables a pretty small.
> What else should we consider as a potential issue?
> 
> thank you
> 
> __
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

[Diego Cutrone]

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 5:03 AM


> Hi ALL,
>
> 1.
> How do I get know memory usage by karnel,application
> programs,Filesystem Cache etc in SunOS 5.6 . I do not
> have the RMC package installed in my m/c
>
I think that you can use /usr/proc/bin/pmap pid

This will display the memmory map for a process.  Detailing shared memory,
shared libraries, code, etc.

Here you have an example:
25431:  ora_lgwr_PRUE73
0001   8312K read/exec /u01/app/oracle/product/7.3.4/bin/oracle
0083D000 76K read/write/exec   /u01/app/oracle/product/7.3.4/bin/oracle
0085140K read/write/exec [ heap ]
8000   6440K read/write/exec/shared  [ shmid=0x578 ]
8064A000  4K read/shared[ shmid=0x578 ]
8064B000160K read/write/exec/shared  [ shmid=0x578 ]
80673000  4K read/shared[ shmid=0x578 ]
80674000  4K read/write/exec/shared  [ shmid=0x578 ]
EF5A 12K read/exec /usr/lib/libmp.so.2
EF5B2000  4K read/write/exec   /usr/lib/libmp.so.2

> 2.
> How do I know if the ORACLE is using Raw/UFS ?
>
Check in dba_data_files (dba_temp_files if you're using temporary tablespace
Oracle 8i onwards), v$controlfile , v$logfile
the locations of the files. After this, go and take a look to these files
with
the comand "file":

oracle:/u01/oradata/RAW81> file raw_data01.dbf
raw_data01.dbf: character special (32/39)

oracle:/u02/oradata/PRUE73> file data1_01.dbf
data1_01.dbf:   data

> 3.
> If I set _filesystemio_options='directIO' instead of
> 'async' will that save memory consumption and improve
> performance  ?

It depends on the tipe of datafiles you're using.
If your database is on FS, and you mount your FS with forcedirectio option,
you can set set _filesystemio_options='directIO'
and you'll be using direct io for the FS datafiles. This will save you
memory and will boost your performance.
If you're on Raw devices you should use Async I/O (KAIO in solaris to be
precise)


HTH
Greetings
Diego Cutrone

>
> Any suggestion ...Thanks in advance
>
> __
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: S B
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

[Jared . Still]

One philosophy of DW states that you build a DW that is
fairly normalized, much like an OLTP database, albeit one
with a temporal component and complete logging of transactions
within the data.

This is then used as a warehouse.  The data from the DW is used
to assemble data marts. These data marts are queried by users.

They never look at the data warehouse.

So to answer your question:  It depends. 

* On how much time you have
*  do you want the ability to create new data marts without adding to
the ETL system ? ( it should already be getting everything you need )

Since you already have something that looks like a DW, why not
use that to build data marts that employ star schemas and bitmap 
indexes?  They are easier to query, and faster.

I believe both Kimball and Inmon subscribe to this philosphy.

Jared






Gurelei <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 11:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:data warehousing desing - to denormalize or not to denormalize 
- that is 
the question


Hi.

We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and tuning. What are the
disadvantages that we should be aware of? Wasted space
is not an issue because the tables a pretty small.
What else should we consider as a potential issue?

thank you

__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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



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

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

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

Re: Locks and Waits

[Anjo Kolk]

There are many things that you could check:
1) size of the shared pool
2) fragmentation of the shared pool
3) free space in the shared pool (together with 2)

check also the application for parsing  (also soft parses).

Check v$rowcache to see access to the rowcache.

Anjo.


"Reddy, Madhusudana" wrote:

> Hello All,
> Here is the result I have got from the v$session_event
>
>  SID EVENT
> TIME_WAITED
>  
> ---
>   22 direct path read
> 109
>   20 db file scattered read
> 125
>   24 db file scattered read
> 160
>   26 SQL*Net more data to client
> 162
>   26 db file scattered read
> 191
>   26 db file sequential read
> 230
>   26 log file sync
> 240
>   27 db file sequential read
> 398
>   24 db file sequential read
> 415
>   22 rdbms ipc reply
> 533
>   20 db file sequential read
> 603
>   24 log file sync
> 813
>   24 latch free
> 904
>   20 log file sync
> 917
>   27 log file sync
> 966
>   26 latch free
> 983
>   27 latch free
> 2779
>   20 latch free
> 3212
>   22 db file scattered read
> 4319
>   24 SQL*Net message from client
> 5583
>   20 SQL*Net message from client
> 6261
>   27 SQL*Net message from client
> 7286
>   22 db file sequential read
> 8883
>   22 latch free
> 16164
>   26 SQL*Net message from client
> 56266
>   26 row cache lock
> 6487782
>   27 library cache lock
> 7433464
>   20 library cache lock
> 7433918
>   22 library cache lock
> 7435227
>   24 row cache lock
> 7435680
>
> Could somebody explain me , what are thsese Librarycache Lock  and Row cache
> lock, and what should I do..
>
> I could see lot of locks on the database.. and batch jobs are going very
> slow , taking hours ...
>
> Seems to me like something is happening on database, any idea ???
>
> Pl response will be very much appreciated.
>
> Thanks,
> Madhu
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reddy, Madhusudana
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

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

[lembark]

-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 12:13:27 -0800

> Jared,
> 
> Thanks for the answer. I must admit my ignorance in
> terminology as for me data warehouse and data mart a
> pretty much the same thing except for size. I
> understand that data mart is smaller. The database I'm
> referring to could probably be described as data mart
> as it is going to be rather small - a gig or so maybe.

"Data Mart" == summarized data from a Warehouse used to 
speed up query times. Main point to a mart is that by
pre-aggregating the data the volume (and keyspace) are
reduced. Mart's acutally increase total storage becuase
they store the data more than once (Warehouse + agg'd
into the Mart). Advantage is speed for the 90% of all
queries that use agg'd data in the first place.

--
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: 
  INET: [EMAIL PROTECTED]

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

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

[Rachel_Carmichael]

Dennis,

It's possible the version you have was corrected. I know that it was the first
printing that had some serious, unintentinal omissions I think only in the
first few chapters.

What really hurts the author is when they catch the error, send the correction
in in time to be fixed for the bound printing and it doesn't make it in. I mean,
it's bad enough that I miss things and they get into print (and thank goodness
marlene and I back each other up and find things the other misses). Fortunately,
we've never had the problem where we corrected the errors and they went through
anyway.

We have an excellent project editor, who is as anal as we are about putting out
a clean book.. so I sometimes get several sets of page proofs.  Sigh, and I
wonder why my eyes ache all the time and I can't see anymore!

Rachel



|+--->
||   |
||   |
||  DWILLIAMS@lif|
||  etouch.com   |
||   |
||  05/10/2002   |
||  04:13 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: Rman ... what do YOU need   |
  >|




Thanks Rachel. To choose between speedy publication (copyright 2002) and
waiting another 6 months for an error-free book, I'll choose speedy.
Especially since I've become increasingly desperate for a good RMAN tutorial
over the past months. And after all, this book is designed to teach you to
BACKUP your database. And honestly, I haven't noticed the typos. But I do
appreciate your pointing out the errata site.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L




Folks, just a word of warning. Through NO FAULT of the authors, there are a
number of errata in the first edition of the book.

There is a complete errata list on the Osborne site:

http://shop.osborne.com/cgi-bin/oraclepress/errata.html


Page proofing is one of the worst tasks on earth (I know, I'm doing it now
for
the 9i version of DBA 101). We found one chapter that is totally messed up,
we
had to have it resubmitted to be put into proofs. With deadlines and print
schedules what they are (TIGHT), we are lucky that there is time to redo it
before the book comes out in June.

Rachel





|+--->
||   |
||   |
||  DWILLIAMS@lif|
||  etouch.com   |
||   |
||  05/10/2002   |
||  01:58 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: Rman ... what do YOU need   |
  >|




Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefly
covers RMAN, no classroom exercises), and felt I was getting nowhere. I
needed some concrete practice exercises.
   About half of Backup & Recovery 101 is devoted to RMAN. He takes
you
step-by-step through creating a practice database, creating an RMAN catalog
database, configuring RMAN, performing backups, listing RMAN information
from both the RMAN catalog and the target database control file, performing
recoveries using RMAN, creating an RMAN duplicate database, creating an RMAN
standby database, and performing an RMAN tablespace point-in-time recovery.
Each chapter has several relevant exercises to work through.
   He has instructions for both Linux and NT, but he worked the
exercises on Linux, so for NT you will have to adjust more, but there is
probably enough information for you to succeed. I used the Linux
instructions on a Unix system and had no problems, other than the fact that
my practice system is Oracle 8.1.6 and his instructions are for Oracle
8.1.7. But the adjustments were simple and even added to my learning.
   So, 

Re: why does DBCA (DB Create Assist) reassign default tablesepace

[Rachel_Carmichael]

That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the
default tablespace. No one should have SYSTEM as the temporary tablespace.

for years oracle would say "change the default tablespace". Now they do it for
you (and about bloodly time!)




|+-->
||  |
||  |
||  Bill.Magaliff@le|
||  ndware.com  |
||  |
||  05/10/2002 03:48|
||  PM  |
||  Please respond  |
||  to ORACLE-L |
||  |
|+-->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: why does DBCA (DB Create Assist)|
  |   reassign default tablesepace for |
  >|




Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?

This is a separate script it runs at the end, after the db and data
dictionary are both created.

thought system should have system tablespace as default, no?

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

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

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




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

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

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

Re: data warehousing desing - to denormalize or not to denormalize - that

[Tim Gorman]

The distinction between a data mart and a data warehouse is not size ("Size
doesn't matter").  It just works out that way usually...

The distinction between a DM and a DW is its function within the entire
decision-support strategy.  A data warehouse is the consolidation point for
all data from all sources.  Data marts are downstream breakouts, subsets of
that consolidated data for specific business functions, optimized for
end-user access.  There a situations where a data mart can exceed the data
warehouse in size (usually due to different data retention requirements),
but a data mart is by definition focused on one specific business topic or
area whereas the contents of a data warehouse encompass the entire
enterprise, across all business areas.  Usually, this means the DW is larger
than any of the many possible DMs, but it is not a requirement that this be
so.  Another common distinction between a data mart and a data warehouse is
political.  If the accounting department ponies up money for a
decision-support strategy but the marketing department does not, then you
are unlikely to have anything that can be referred to as a data warehouse.
Hence, the popularity of data marts...

The third major component of a decision-support strategy is the operational
data store (ODS), which is largely understood to be a "staging" area during
extraction, transformation, and loading into the data warehouse from the
operational source systems.  But, depending on requirements, an ODS can also
be utilized as a consolidation point for data for unified "tactical"
reporting, possibly to offload the operational systems.  For example,
consider the example of a company that runs Peoplesoft financials that
acquires another one company that runs Lawson financials, another company
that runs Oracle financials, and a third company that runs Quickbooks for
financials.  How is these folks going to get consolidated tactical (not
strategic) financial reporting?  One option is to utilize the first step of
the decision-support strategy.  As the data is staged on it's way to the
data warehouse and the financial data mart after that, why not allow the
consolidated data to be reported upon from the "staging area" in the ODS?
Yet another use of the ODS (besides "staging" for transformation from
operational to DSS data models and offloading tactical reporting) is
possible archival of transactional data, when the source system does not
support archival.  For example, most legacy systems and quite a few "modern"
software packages never dealt with the issue of archival.  Rather than
trying to modify each individual source system for archival, why not archive
at the consolidation point, in the ODS?

Sorry for the long-winded insertion into this thread, but I just wanted to
add that little change of perspective...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 2:13 PM
denormalize - that


> Jared,
>
> Thanks for the answer. I must admit my ignorance in
> terminology as for me data warehouse and data mart a
> pretty much the same thing except for size. I
> understand that data mart is smaller. The database I'm
> referring to could probably be described as data mart
> as it is going to be rather small - a gig or so maybe.
>
>
> --- [EMAIL PROTECTED] wrote:
> > One philosophy of DW states that you build a DW that
> > is
> > fairly normalized, much like an OLTP database,
> > albeit one
> > with a temporal component and complete logging of
> > transactions
> > within the data.
> >
> > This is then used as a warehouse.  The data from the
> > DW is used
> > to assemble data marts. These data marts are queried
> > by users.
> >
> > They never look at the data warehouse.
> >
> > So to answer your question:  It depends.
> >
> > * On how much time you have
> > *  do you want the ability to create new data marts
> > without adding to
> > the ETL system ? ( it should already be getting
> > everything you need )
> >
> > Since you already have something that looks like a
> > DW, why not
> > use that to build data marts that employ star
> > schemas and bitmap
> > indexes?  They are easier to query, and faster.
> >
> > I believe both Kimball and Inmon subscribe to this
> > philosphy.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > Gurelei <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/10/2002 11:43 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject:data warehousing desing - to
> > denormalize or not to denormalize - that is
> > the question
> >
> >
> > Hi.
> >
> > We are designing a small database using a data
> > warehousing desing. We have created a 3rd normal
> > form
> > and are now debating whether and how to denormalize
> > it. I see the pluses of denormalization - easier
> > queries creation and tuning. What are the
> > disadvantages that we should be aware of? Wasted

Re[2]: why does DBCA (DB Create Assist) reassign default tab

[dgoulet]

New feature in 9i, default temporary tablespaces.  Now you don't have to state
what a users temporary tablespace is and have them end up in system.  It covers
sys and system at the same time since it's declared in the create database
command.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   5/10/2002 1:00 PM



That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the
default tablespace. No one should have SYSTEM as the temporary tablespace.

for years oracle would say "change the default tablespace". Now they do it for
you (and about bloodly time!)




|+-->
||  |
||  |
||  Bill.Magaliff@le|
||  ndware.com  |
||  |
||  05/10/2002 03:48|
||  PM  |
||  Please respond  |
||  to ORACLE-L |
||  |
|+-->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: why does DBCA (DB Create Assist)|
  |   reassign default tablesepace for |
  >|




Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?

This is a separate script it runs at the end, after the db and data
dictionary are both created.

thought system should have system tablespace as default, no?

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

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

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

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

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

[Gurelei]

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> The key point is your users. A typical normalized
> design means a lot of
> tables. These tables must be joined in specific
> manners. Non-I.S. users find
> this intimidating. So they don't use it. So you've
> spent a lot of time
> creating a DW only to have nobody use it. 
> How many tables
> did your 3nf schema
> produce?

Our schema has 4 fact tables, 6 aggregates build on
them and more than 20 dimension tables. And we have
exctly the situation of users asking to denormalize
them to simplify the report creation. 

>   Or go ahead, build a normalized one, then > study
and
> build the second
> version incorporating the hard-won lessons others
> have learned.

What I'm trying to do is to pick the best "starting
point" design. Having a totally normalized schema
would be one option. If the performance or report
creation (in terms of simplisity) prove unsatisfactory
we can change the design and denormalize to address
the known issues. If however I'm able to identify the
tables that can be denormalized without causing damage
I'd rather do it now. 


__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

[paquette stephane]

A DW stores data in a denormalised fashion, that's one
point that every body knows but it is also subject
oriented. It is also developped one subject at a time.

A DW is multi-subjects as a datamart is on one
subject.


>From Bill Inmon

>From the data warehouse data flows to various
departments from their customized DSS usage. These
departmental DSS data bases are called data marts. A
data mart is a body of DSS data for a department that
has an architectural foundation of a data warehouse.

The data that resides in the data warehouse is at a
very granular level and the data in the data mart is
at a refined level. The different data marts contain
different combinations and selections of the same
detailed data found at the data warehouse. In some
cases data warehouse detailed data is added
differently across the different data marts. Yet in
other cases a data mart will structure detailed data
differently from other data marts. But in every case
the data warehouse provides the granular foundation
for all of the data found in all of the data marts.
Because of the singular data warehouse foundation that
all data marts have, all of the data marts have a
common heritage and are able to be reconciled at the
most basic level.




 --- [EMAIL PROTECTED] a écrit : > 
> 
> -- Gurelei <[EMAIL PROTECTED]> on 05/10/02 12:13:27
> -0800
> 
> > Jared,
> > 
> > Thanks for the answer. I must admit my ignorance
> in
> > terminology as for me data warehouse and data mart
> a
> > pretty much the same thing except for size. I
> > understand that data mart is smaller. The database
> I'm
> > referring to could probably be described as data
> mart
> > as it is going to be rather small - a gig or so
> maybe.
> 
> "Data Mart" == summarized data from a Warehouse used
> to 
> speed up query times. Main point to a mart is that
> by
> pre-aggregating the data the volume (and keyspace)
> are
> reduced. Mart's acutally increase total storage
> becuase
> they store the data more than once (Warehouse +
> agg'd
> into the Mart). Advantage is speed for the 90% of
> all
> queries that use agg'd data in the first place.
> 
> --
> 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: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Re[2]: Re[2]: why does DBCA (DB Create Assist) reassign defa

[dgoulet]

See, they do listen.  Now if we could only get them to move faster than Molasses
going up hill in the middle of an Alaskan winter!!

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   5/10/2002 4:22 PM



yeah it's sweet. they finally got around to doing some of the things DBAs have
been begging for for years.. like you can now do a TABLESPACE export!!!




|+--->
||   |
||   |
||  dgoulet@vicr.|
||  com  |
||   |
||  05/10/2002   |
||  04:17 PM |
||   |
|+--->
  >|
  ||
  |   To: Rachel Carmichael@Sony_Music,|
  |   [EMAIL PROTECTED] |
  |   cc:  |
  |   Subject: Re[2]: why does DBCA (DB Create |
  |   Assist) reassign default tab |
  >|




New feature in 9i, default temporary tablespaces.  Now you don't have to state
what a users temporary tablespace is and have them end up in system.  It covers
sys and system at the same time since it's declared in the create database
command.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   5/10/2002 1:00 PM



That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the
default tablespace. No one should have SYSTEM as the temporary tablespace.

for years oracle would say "change the default tablespace". Now they do it for
you (and about bloodly time!)




|+-->
||  |
||  |
||  Bill.Magaliff@le|
||  ndware.com  |
||  |
||  05/10/2002 03:48|
||  PM  |
||  Please respond  |
||  to ORACLE-L |
||  |
|+-->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: why does DBCA (DB Create Assist)|
  |   reassign default tablesepace for |
  >|




Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?

This is a separate script it runs at the end, after the db and data
dictionary are both created.

thought system should have system tablespace as default, no?

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

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

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

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

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

Redo log files questions. Need help.

[Meomeo Nguyen]

 I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then enabled automatic archiving of filled groups by setting
 log_archive_start=true
 in the database's parameter file.  Finally I used 
alter system archive log start; 
to enable automatic archiving of filled online redo log group without shutting down the current instance.  For some reason, when using the SQL*Plus statement
archive log list;
 it shows the archiving information for the connected instance:
database log mode    ARCHIVELOG
automatic archival ENABLED
..etc
But when I shutdown immediate then startup the instance with database open, I then issue the 
archive log list;    this time the 
automatic archival  DISABLED.  Anyone came across this problem and had a fix.  Please direct me how to fix it.  I just wanted to archive online logs to multiple locations, then back up the archived logs. Please help.
Thanks in advance.  Your help is greatly appreciated.
TrangDo You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!

Re: Redo log files questions. Need help.

[Gene Sais]

You probably received an error in your alert log and Oracle disabled archiving.  Make 
sure yuou have these 3 parameters in your init.ora and set accordingly:

log_archive_dest = /oracle/data/arc//
log_archive_format = _%s.arc
log_archive_start = true

hth,
Gene

>>> [EMAIL PROTECTED] 05/10/02 06:08PM >>>

 I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then 
enabled automatic archiving of filled groups by setting

 log_archive_start=true

 in the database's parameter file.  Finally I used 

alter system archive log start; 

to enable automatic archiving of filled online redo log group without shutting down 
the current instance.  For some reason, when using the SQL*Plus statement

archive log list;

 it shows the archiving information for the connected instance:

database log modeARCHIVELOG

automatic archival ENABLED

..etc

But when I shutdown immediate then startup the instance with database open, I then 
issue the 

archive log list;this time the 

automatic archival  DISABLED.  Anyone came across this problem and had a fix.  Please 
direct me how to fix it.  I just wanted to archive online logs to multiple locations, 
then back up the archived logs. Please help.

Thanks in advance.  Your help is greatly appreciated.

Trang



-
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!

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

RE: Redo log files questions. Need help.

[DENNIS WILLIAMS]

Trang: I think that you missed the step of "alter database archivelog" while
the database is mounted but not open.
 
Here is the precise steps for you to review:
 
Modify the init.ora file with log_archive_start = true (you've already done
that)
 
Shutdown the database.
 
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ARCHIVE LOG START
ALTER DATABASE OPEN

-Original Message-
Sent: Friday, May 10, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L



 I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I
then enabled automatic archiving of filled groups by setting

 log_archive_start=true

 in the database's parameter file.  Finally I used 

alter system archive log start; 

to enable automatic archiving of filled online redo log group without
shutting down the current instance.  For some reason, when using the
SQL*Plus statement

archive log list;

 it shows the archiving information for the connected instance:

database log modeARCHIVELOG

automatic archival ENABLED

..etc

But when I shutdown immediate then startup the instance with database open,
I then issue the 

archive log list;this time the 

automatic archival  DISABLED.  Anyone came across this problem and had a
fix.  Please direct me how to fix it.  I just wanted to archive online logs
to multiple locations, then back up the archived logs. Please help.

Thanks in advance.  Your help is greatly appreciated.

Trang




  _  

Do You Yahoo!?
Yahoo!   Shopping -
Mother's Day is May 12th!

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

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

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

Re: data warehousing desing - to denormalize or not to denormalize - that

[Jared . Still]

Tim,

Don't *ever* apologize for long threads when
they are full of useful content.  :)

Jared





"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 02:19 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: data warehousing desing - to denormalize or not to 
denormalize - that


The distinction between a data mart and a data warehouse is not size 
("Size
doesn't matter").  It just works out that way usually...

The distinction between a DM and a DW is its function within the entire
decision-support strategy.  A data warehouse is the consolidation point 
for
all data from all sources.  Data marts are downstream breakouts, subsets 
of
that consolidated data for specific business functions, optimized for
end-user access.  There a situations where a data mart can exceed the data
warehouse in size (usually due to different data retention requirements),
but a data mart is by definition focused on one specific business topic or
area whereas the contents of a data warehouse encompass the entire
enterprise, across all business areas.  Usually, this means the DW is 
larger
than any of the many possible DMs, but it is not a requirement that this 
be
so.  Another common distinction between a data mart and a data warehouse 
is
political.  If the accounting department ponies up money for a
decision-support strategy but the marketing department does not, then you
are unlikely to have anything that can be referred to as a data warehouse.
Hence, the popularity of data marts...

...


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

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

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

RE: WAITS

[Orr, Steve]

> Each morning I produce graphs...
I think this is key. Having historical data graphically presented helps to
establish the norm and when there may be performance issues to investigate.
This follows step 2 of Gaja's "Oracle Performance Tuning 101 Methodology"
which says, "Measure and document current performance." 

To do this I created a DBA monitoring HTML display tool which gets data from
V$SYSSTAT and V$SYSTEM_EVENT once a minute, stores it in a round robin
database and displays it with RRDTool. I've accumulated 2 months of this
data and it's amazing how lightweight it is. With graphs it's easy to see
when something's amiss. We capture expensive SQL via StatsPack every 15
minutes and I have correlated a spike on a graph to specific SQL executed 2
hours earlier. 

Now I'm trying to decide on my next enhancement: 1) HTML/GUI interface to
StatsPack data or; 2) Drill down to V$SESSION_WAIT ???


Steve Orr
Bozeman, Montana



-Original Message-
Sent: Thursday, May 09, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
Importance: High

In general There are two problems in using the "top five waits" out of
statspack:  it reports idle waits; no matter how well-tuned your database
there will always be a top five.  The numbers presented show total
time-waited in csecs for the time period.  As Jared said we don't know the
time period.  We don't know the average wait time.  

I have learned some rudimentary gnuplot skills.  Each morning  I produce
graphs of what went on the in the databases the previous day on and hour by
hour basis.  If  something is really askew  I break the hour down into ten
minute blocks.  This helps me to better recognize patterns of database
usage. 

Ian MacGregor  
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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

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

[Henry Poras]

>From what I remember, one of the main advantages of a normalized database is
a certain level of data integrity and flexibility. The integrity comes from
foreign keys, lack of duplicate data, and generally a data design based on
characteristics of the data. The flexibility comes from the ablility to
query in many different ways (you are not restricted as you are in a
heirarchical db). Though I have never designed a data warehouse, I always
thought that the integrety piece would be less of an issue. Since there are
very few writes to a warehouse, there is less chance to fowl up the data
integrity as long as there are good controls on the load. Flexibility on
querying a warehouse seems to also be possible using other design methods
(fact tables, snowflake, ...)

Henry

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 3:48 PM


> Let's see . . . disadvantages . . . hmmm. scorn of anyone that understands
> data warehousing? On your resume putting "created a completely normalized
> DW" and wondering why everyone giggles when they read it.
>
> Actually, a normalized schema will probably use less space than
> denormalized.
> The key point is your users. A typical normalized design means a lot of
> tables. These tables must be joined in specific manners. Non-I.S. users
find
> this intimidating. So they don't use it. So you've spent a lot of time
> creating a DW only to have nobody use it.
> Normalized schemas are optimized for inserts and updates, not
> generating reports. To generate a report from an OLTP normalized schema,
you
> usually start by interviewing the developers. And they usually have to do
> some research. A DW is a "write mostly" schema. Our DW is only refreshed
> weekly. Sunday is spent loading it and Monday the users charge in and run
> reports all day.
> Study star schema. Go to http://www.ralphkimball.com and read
> articles he has written, starting with the oldest ones and working
forward.
> Read Ralph Kimball's book "The Data Warehouse Toolkit: Practical
Techniques
> for Building Dimensional Data Warehouses". Classic work, excellent
starting
> point.
> A beginning star schema DW should have only a central fact table and
> 4-6 dimension tables. Non-computer-geeks actually have a hope of
> understanding how to navigate that. How many tables did your 3nf schema
> produce?
> Or go ahead, build a normalized one, then study and build the second
> version incorporating the hard-won lessons others have learned.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> Sent: Friday, May 10, 2002 1:43 PM
> To: Multiple recipients of list ORACLE-L
> - that is the question
>
>
> Hi.
>
> We are designing a small database using a data
> warehousing desing. We have created a 3rd normal form
> and are now debating whether and how to denormalize
> it. I see the pluses of denormalization - easier
> queries creation and tuning. What are the
> disadvantages that we should be aware of? Wasted space
> is not an issue because the tables a pretty small.
> What else should we consider as a potential issue?
>
> thank you
>
> __
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  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  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

T

Re: data warehousing desing - to denormalize or not to denormaliz

[Steven Lembark]

-- Henry Poras <[EMAIL PROTECTED]>

>> From what I remember, one of the main advantages of a normalized
>> database is
> a certain level of data integrity and flexibility. The integrity comes
> from foreign keys, lack of duplicate data, and generally a data design
> based on characteristics of the data. The flexibility comes from the
> ablility to query in many different ways (you are not restricted as you
> are in a heirarchical db). Though I have never designed a data warehouse,
> I always thought that the integrety piece would be less of an issue.
> Since there are very few writes to a warehouse, there is less chance to
> fowl up the data integrity as long as there are good controls on the
> load. Flexibility on querying a warehouse seems to also be possible using
> other design methods (fact tables, snowflake, ...)

Basic warehouse operations use an offline update with
read-only access to users. The offline update allows
for complete validation before the data is used (in
theory at least), which makes foreign keys less important
for maintaing consistency. The normal ETL cycle is
usually designed to reject data with missing keys in
the transform cycle anyway -- usually by placing the
offending items in a reject que for later analysis.

Avoiding snowflakes makes any foreign key issues moot
in the dimensions: the ETL cycle will either merge
the data successfully or reject it. The fact table is
mostly key in the first place, with a small amount of
data hung off the side. Inserting the record requires
pre-merging all of the key information also, so at
insert time the records should be valid (or the ETL
code reworked).

An RDBMS allows the same queries in both a star or
3rd (or BCD) normal form. The difference is that a
star schema is much simpler to query since the joins
are only 1-2 levels deep (dims:fact or dim:fact:dim
is as far as it goes). The joins tend to be faster
also since indexes are 1:1, the dim's are shorter
tables and the fact is "narrow" enough that they
don't require excessive I/O to process down their
length.

In most cases a synthetic integer key is used for the
dim's also. This is partly done to keep the fact table
narrow, since most of it is the composite key for each
fact. This tends to help indexes also.

Depending on the database, joining dimensions across the
fact table is also more effecient. Red Brick was the
first with their "star index", which basically pre-joins
the dimension and fact records at load time. Informix
and DB2 picked up the technology by purchasing RB and
Informix; Oracle is currently working on a similar
concept (I think). This basically trades off a fairly
expensive operation done once at load time for read
effeciency. This works in a warehousing environment
where the ETL cycle can pre-sort records for better
load speed and the loads happen offline on basically a
dedicated system. After that read effeciency is the
only thing going, noone cares about update speed until
tomorrows load -- at which point they don't really
care about user effeciency for a while.

The cycle works pretty well in most cases, the biggest
problem being the management of rollof. If the data can
be segmented in "rollof units" (e.g., time buckets) then
the process is simple. In Oracle, for example, with
locally managed partitions you can offline, truncate and
drop them without any real pain. If the unit of partitioning
isn't the unit of rollof -- not hard since the primary key
has to start with the partitioning field in nearly all
cases -- then you end up having to perform deletes. THAT
can be a Real, True Pain (tm) on a 3-4 TByte warehouse.
It's even worse in cases where the rollof units are not
uniformly distributed, in which case Oracle will have to
perform a table scan to find the records. In most cases
the simplest fix it to force the rollof value into the
primary key and be done with it, hopefully that doesn't
screw up the database.

Data marting helps this in some ways, since the ETL
process can pre-generate the aggregates required for
marting. In that case a smaller database gets updated
with a smaller load each cycle and can usually be placed
online quicker. The marts can also hold data longer without
degrading performance, so their rollof cycles tend to be
longer. Many databases will have pre-aggregated data
prepared for drilldowns already loaded into the fact
table (this is a requirement of some querying tools). In
that case the "rollof" procedure consists of deleting
the more detailed period records (say daily totals) on
a monthly basis, leving monthly aggregate values online
for perhaps 24 months. The delete cycle is less painful
in a -- much smaller -- data mart than the whole warehouse
and leaves users able to make the buisness-cycle queries
they need.

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: h

RE: Good HR vs. Bad HR...

[Kimberly Smith]

Hum, I have to fight a bit more for mine suggestions to go through.  That's
not fair.  I guess its good for me as its helping my debating skills:-)  It
does not help that the folks I work with are half way across the country.

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, May 10, 2002 6:38 AM
To: Multiple recipients of list ORACLE-L




Don,

Next time I need to resign, will you help me write the letter?

Having worked at several large and not-so large companies, all I can say is,
the
problems you documented seem to be ubiquitous throughout most management. I
have
found it nearly impossible in some places to do my job with any degree of
accuracy, because management has its own version of reality and if what I
said
didn't conform, it was thrown out.  Something akin to deciding what the
results
of that physics experiment should be before beginning it, and throwing out
all
results that don't support the hypothesis.

What amazes me is that these companies continue to survive in the face of
such
insanity.

So far, it does not look to be like that here. I have reviewed and made
suggestions in the past two weeks and the response has been "she's right,
let's
do it". And it gets done. I might actually like it here :)

Rachel



|+--->
||   |
||   |
||  granaman@cox.|
||  net  |
||   |
||  05/09/2002   |
||  06:37 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re: Good HR vs. Bad HR...   |
  >|




I think enough has been said already - I didn't intend to name the company
at
all.  Actually, I
don't think that I said that all the managers were incompetent.  (A select
few
in the wrong places
perhaps.)  Since the cat is out of the bag though, I will try to end this
here
and now.

I had a number of specific and well-documented "complaints", so I fired off
this
kamikaze
resignation letter - straight through three layers of management, even
cc'ing
one of the two owners
of the company.  The original formatting was better, but here it is in
ASCII.
---
[...]
---
It is demoralizing also to see a parade of "experts", "gurus", and
"geniuses"
hand off botched,
half-baked, poorly designed, and dysfunctional systems, then get major
promotions and/or
commendations.

Case in point: The CIS applications were handed over to Wanda Kelley and I
as
upper management
mourned the loss of their "Oracle genius" (a direct quote). Well this
"genius"
left us a system with
almost no data integrity - there were only two foreign keys for 44 tables.
Only
about 70% of the
tables even had a primary key. There were no check constraints or triggers
to
enforce data
integrity.  Nothing was enforced in the application.  And the application
handled extremely few of
the business requirements.  For example, the application does not function
properly unless LOGONID
in the EMPLOYEE table is unique. There was no such uniqueness constraint.
Furthermore, the
application uses "where upper(LOGONID) = :some_variable", so a uniqueness
constraint alone is
insufficient - there also needs to be a method to enforce uppercase only on
this
column on inserts
and updates.  There was none.  One could enter a new employee record, then
immediately query for it,
exactly as entered, and not find it!  Both copies of the Oracle control file
were in the same
directory. The online redo logs were not mirrored. While these and other
basic
errors and omissions
were obvious to us untrusted flunkies, the "genius" overlooked them. The
users
were connecting to
the database as the SYSTEM user (with the default password "MANAGER" of
course).
His project plan
included installing SQL*Net on hundreds of PC's using WCSGCOPY.  This
doesn't
work, all it does is
remove the ORACLE_HOME directory and replace it with files copied from a
server.
It doesn't update
the registry and it doesn't consider that there may already be an Oracle
client
on the machine
(typically, there is - and it includes things that this method would delete,
like the Oracle forms
runtime).  This last item became an issue when I first heard of it less than
a
week before the
implementation date. (Incidentally, that was the first time that most of us
even
heard about this
project.)  We tested a variation of this method for CIT client installations
and
determined that it
was impractical. How does one do such a poor job and yet convince everyone
they
are a "genius"? Is
perception is truly everything here?

To

Oracle version usage

[Alex Hillman]

Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1
and prognosys in an year.

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

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

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

[Sinardy Xing]

I wish I can work for you beside learning Oracle I can be a wiser man.

-Original Message-
From: Don Granaman [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2002 00:38
To: Multiple recipients of list ORACLE-L
Subject: Re: Good HR vs. Bad HR...


Actually, I don't think the company is all that bad now.  In fact, I would have 
preferred to keep
the company name out of it.

Also, I should have put this into a context.  At the time this was written, upper 
management had
started an intimidation campaign.  They were doing some layoffs, but rather than do it 
in any kind
of normal fashion, they were laying off one or two people per day - and making a 
spectacle of it.
They would come around to the victim and force them to stop whatever they were doing 
immediately and
parade them out of the building with a security escort.  They were not allowed to even 
log off,
finish a line of code, or pick up personal items - which were instead to be shipped to 
their home.
After about a week or two of this, I happened to be on an elevator with a VP and a 
director (ones I
didn't really know) - just the three of us.  They started talking, for my benefit 
obviously, about
the success of their "let's put the fear of God into our employees" (a direct quote) 
strategy.  It
was then that I decided it wasn't someplace I wanted to stay.  That night, I wrote up 
this
resignation - as a sort of counter-attack.  The next morning, I came in, packed up 
most of my stuff,
took it to the car, and submitted the letter to about three layers of management above 
me, the
managers whose projects I was working on, one of the owners of the company, and HR.  
Most were
included only because I wanted them to know why I was actually leaving, not some 
distorted version
they might get through the bureaucracy.  I also sent a fairly comprehensive turnover 
document to one
of my co-workers (Mike M.), as I knew that this wouldn't be considered as an essential 
part of the
exit process.  About three hours later I was called up to HR.  The director of the 
division I worked
for was there, as well as the HR person.  The HR person said that they had "chosen to 
terminate my
employment effective immediately".  I said "So, you are accepting my resignation?" and 
she turned
bright red and glowered at me.  She said that I wouldn't be able to return to my cube 
- that
security would escort me out of the building directly from her office.  I told them 
that all I had
left there was one small box of books that belonged to me.  This director was actually 
a very
sensible and technical guy who had come up through the ranks.  He told the HR clown 
that he would go
back with me and escort me out.  We went back to my cube, he carried the box out to my 
car for me,
and told me "Well, at least maybe this will do some good".

I think they slacked up a bit after that.  I still have friends who work there.  About 
a year after
I left, I saw one of my past managers at a user group meeting.  He is now a VP I 
believe.  He said
that if I ever decided I could work there again, to give him call.  About two years 
after I left, I
went back out there for a visit and was greeted warmly by former co-workers and even a 
few managers.

I think that the reason that, as Matt said, this became "legendary" is only because it 
was a sort of
"suicide attack" against the arrogance and stupidity that existed in some upper 
management circles
at that time.  I was the first "martyr", but quite a number of others also resigned 
within the next
few months (none so flamboyantly though).  Of the group (ET) of twenty that I was in, 
well over half
had left (voluntarily) within a year.  Matt was among the "defectors", as was our 
manager and a
large percentage of the other senior technical people.

Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 9:33 AM


> Don,
>
> And, of course, since it was a resignation letter, the company probably just
> filed it away.  I'll give you the "Brass Cajones" award though, for setting
> the record straight.
>
> Just curious, is the company still around?  Need to make sure to avoid it in
> the future!  :)
>
> Tom Mercadante
> Oracle Certified Professional

-- 
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 line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscri

Alter table failes with ORA-00054:resource busy

[Ravindra]

I want to alter a table and add a new column on our 
production database.
 
I am getting the following error
ERROR at line 1:ORA-00054: resource busy and 
acquire with NOWAIT specified
 
Some user/process is holding the lock on this 
table.I have tried at different times
and still cannot get it done.There are some 
processes that will comtinuously use these
tables.
 
How can I add the column.
 
Ravi

RE: Alter table failes with ORA-00054:resource busy

[Ganesh Raja]

Why don't  u do this during off peak hours.

Anyways what u can do is take a Lock on the table and wait till the lock is
obtained and then alter tahe table.

HTH


Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again.



-Original Message-
Sent: Saturday, May 11, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L


I want to alter a table and add a new column on our production database.

I am getting the following error
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

Some user/process is holding the lock on this table.I have tried at
different times
and still cannot get it done.There are some processes that will comtinuously
use these
tables.

How can I add the column.

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

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

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