date:20020531


Harvinder,

My experience has been that Oracle applies rownum first, then order by.  So,
first it retrieves records that pass the 'where' clause, then sorts them.

The results of your examples may be explained by the use of an index - try
running explain plan against them to see if an index was used (because of
the order-by clause).

The most important thing you need to realize is that you cannot depend on
the order of data being retrieved in the same order it was inserted.

Raj's example is the correct way to solve your query request.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, May 30, 2002 4:52 PM
To: Multiple recipients of list ORACLE-L


Scenario is we have a table having 100 rows and column id_po as 
unique column with distinct values betweem 1 and 100...
we we try 
select id_po from table1 where rownum  5 order by id_po;
it gives result as:
1
2
3
4
and if we try
select id_acc,id_po from table1 where rownum  5 order by id_po desc;
100
99
98
97

That implies oracle is first getting the result set and then apply order by
and then rownum..

But when we try
select id_acc,id_po from table1 where rownum  2 order by id_po desc;
result is:
1 

where it should be 100 if above statement is true

Thanks
--Harvinder


-Original Message-
Sent: Thursday, May 30, 2002 4:30 PM
To: Multiple recipients of list ORACLE-L


When you use rownum  2 you are effectively selecting only one row and
stopping after that. Also This is not the right way to do it, the right way
is to use inline view with rownum condition and order by in outer query.

In your scenario, oracle will retrieve 2 rows and then sort them. These two
rows can be anything and are not affected by the order by clause YET.

Ordering one row reminds of an assignment we had in our Graphics class, we
were asked to implement object rotation, a colleague complained his program
is right, but the object wasn't getting rotated. When we had a look on his
screen, he was trying to rotate a circle !

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

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


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


problem is it works if we have rownum  3(or any value 2) and only fails if
we use rownum  2...
-- 
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: 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: RMAN error registering database

2002-05-31 Thread MICHAEL.SALE

Without having better information (i.e. I assume you are running Oracle between 8.1.6and 8.1.7.2), I would say that you are running into bug 1467871 fixed in 9i and patched in 8.1.7.3 and 4. The work around is to recreate your control file, thus loosing all your backup information stored in the control file. You can capture this information manually via a controlfile dump, but it isn't of much use to you (and besides that it can reoccur if you don't apply the patch). Not necessarily a horrid problem, but certainly good to move past.
You should upgrade to 8.1.7.3 (or 9i) and then upgrade your catalog in order to avoid this problem in the future. You need to upgrade your catalog after applying the patchset:
RMAN CONNECT CATALOG user/passwd@catalogRMAN UPGRADE CATALOG;
Regards,
Michael SaleAuthor: Oracle9i for Windows(R) 2000 Tips  Techniques 


when I try to register my database in RMAN, I get the following error..RMAN-08002: starting full resync of recovery catalogRMAN-03026: error recovery releasing channel resourcesRMAN-00571: ===RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===RMAN-00571: ===RMAN-03008: error while performing automatic resync of recovery catalogRMAN-07004: unhandled exception during command execution on channel defaultRMAN-10035: exception raised in RPC: ORA-01403: no data foundRMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECEdoes anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution.TIADanny HughesDBAKnobias.com601-978-3399 x103[EMAIL PROTECTED]www.knobias.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Danny HughesINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

RE: Archive log full

2002-05-31 Thread Clinton Naude

Title: RE: Archive log full





Do a backup that includes deleteing the archive logs.



-Original Message-
From: sam d [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Archive log full



Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location.
(win2k,Oracle 8.1.6)
(I did went thru the manual)


thx
Sam



__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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).

Re:RE: partition tables


BigP,

You'll have to rebuild the table from scratch as a partitioned table.  Yes
you can expect a performance gain, based on the fact that you partition it
appropriately  Also, if you haven't already licensed the partitioning option
from Oracle, or installed it, you will have to.

One item I've learned about Oracle from our recent audit is that if you have
not licensed an option, but installed it they don't really get bent out of shape
so long as your not using it.

Dick Goulet

Reply Separator
Author: Khedr; Waleed [EMAIL PROTECTED]
Date:   5/30/2002 6:08 PM

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972
http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972


-Original Message-
Sent: Thursday, May 30, 2002 8:59 PM
To: Multiple recipients of list ORACLE-L


Hi All ,
We are thinking of converting one of huge table in to partition table .
What is best way to achieve this ? Is there any alter table clause that can
do this or I will have to export ..recreate table with partition option and
then import . Also how can I mentiod that partition should have only 10
rows . For example after each 10 rows add another partition ?
If I have 1000 rows in the table , should I expect some performance gain
out of this 
 
Thanks ,
BigP
 
 


!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1


META content=MSHTML 5.50.4915.500 name=GENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=#ff
DIVFONT face=Arial color=#ff size=2A 
href=http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972
http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972/A
/FONT/DIV
BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
  DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma 
  size=2-Original Message-BRBFrom:/B BigP 
  [mailto:[EMAIL PROTECTED]]BRBSent:/B Thursday, May 30, 2002 
  8:59 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B 
  partition tablesBRBR/FONT/DIV
  DIVFONT face=Arial size=2Hi All ,/FONT/DIV
  DIVFONT face=Arial size=2We are thinking ofnbsp;converting one of huge 
  table in to partition table .nbsp; What is best way to achieve this ? Is 
  there any alter table clause that can do this or I will have to export 
  ..recreate table with partition option and then import . Also how can I 
  mentiod that partition should have only 10 rows . For example after each 
  10 rows add another partition ?/FONT/DIV
  DIVFONT face=Arial size=2If I have 1000 rows in the table , should I 
  expect some performance gain out of this /FONT/DIV
  DIVFONT face=Arial size=2/FONTnbsp;/DIV
  DIVFONT face=Arial size=2Thanks ,/FONT/DIV
  DIVFONT face=Arial size=2BigP/FONT/DIV
  DIVFONT face=Arial size=2/FONTnbsp;/DIV
  DIVFONT face=Arial size=2/FONTnbsp;/DIV/BLOCKQUOTE/BODY/HTML

-- 
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: Archive log full

2002-05-31 Thread Jack van Zanen



Hi

If no error now you'll get one soon (read the alert logs)

you can safely move all the archive logs that are finished writing. I
assume you have more than a day worth of archives so if you move anything
older than a day for now you should be fine.

after that it's time to write your automated scripts to do this for you.

jack


   

  sam d

  sam_orafan@yahooTo:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  .comcc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  Archive log full  

  [EMAIL PROTECTED] 

   

   

  31-05-2002 14:23 

  Please respond to

  ORACLE-L 

   

   




Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location.
(win2k,Oracle 8.1.6)
(I did went thru the manual)

thx
Sam


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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).




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the

Re: RMAN error registering database - solved

2002-05-31 Thread Danny Hughes


Thanks Cherie I saw that one too...I was hoping that there was another fix rather than 
having to shut our production database down, but after many hours on the phone with 
oracle and getting nowhere, I just recrreated the control file and it did solve my 
problem.


 [EMAIL PROTECTED] 05/31/02 07:48AM 

Danny,

Many RMAN errors will show a hit when searching Metalink.   I found the
following related document on Metalink when I searched with the RMAN-10031
error:

 fact: Oracle Enterprise Edtion 8.1.7

 fact: Recovery Manager (RMAN)

 symptom: Unable to register a database

 symptom: RMAN-10035: exception raised in RPC: ORA-01403: no data found

 symptom: RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.
 CHECKBACKUPPIECE

 symptom: RMAN-03008: error while performing automatic resync of
 recovery
 catalog

 change: Upgrade to Oracle Server - Enterprise Edition 8.1.7

 cause: Bug:1467871
 Dummy records with status ¿D¿ inserted into BS table
 during backup.
 RMAN mishandles these records during sync of the recovery of the
 catalog.




fix:

Upgrade to Oracle Server 9i

Or use following workaround:

Rebuild the target database control file

References:
Note:1012929.6
How to Recreate the Controlfile


.

Hope this helped.

Cherie


   
  
Danny Hughes 
  
DHUGHES@knobi   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
as.com  cc:   
  
Sent by: Subject: RMAN error registering database  
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
05/30/02 06:43 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




when I try to register my database in RMAN, I get the following error..

RMAN-08002: starting full resync of recovery catalog
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10035: exception raised in RPC: ORA-01403: no data found
RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECE

does anyone know how to get around this problem...I have an ITAR open with
oracle right now and wanted to try this forum while I am waiting on a
resolution.

TIA

Danny Hughes
DBA
Knobias.com
601-978-3399 x103
[EMAIL PROTECTED] 
www.knobias.com 

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

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

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

RE: Archive log full


Sam,

Yes, you may move and delete the files and copy them to tape for
safekeeping.

Note:  If you are using Rman, you should run an Rman archivelog backup -
otherwise, it will complain about needing to back the files up.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, May 31, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L


Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location.
(win2k,Oracle 8.1.6)
(I did went thru the manual)

thx
Sam


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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).
-- 
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: ORA-600

2002-05-31 Thread Michael P Sale


This is an error that occurred while recovering from a rolled back
transaction. Not a database recovery. 

This could be caused by doing a control-c while trying to truncate a
large table (Bug 1400739 fixed in 8.1.7.1). Could also be from an undo
operation on a leaf key of a bitmap index. You should be able to tell
this from the trace file. Either way I would open a TAR with Oracle
Support to get a proper diagnosis from the trace files.

Ultimately, it looks like you have some form of rollback segment
corruption, likely block corruption in your rollback tablespace. I would
strongly suggest that you open a tar with Oracle Support. Check your
alert log for related trace files, in particular SMON trace files. In
the mean time check out Metalink note 28814.1 regarding dealing with
block corruptions just to get an idea of the possible implications (e.g.
logical data corruption).

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Sent: Friday, May 31, 2002 6:18 AM
To: Multiple recipients of list ORACLE-L


Dear All,

I am gettying the follwoing error on our alert_log
file,though no porblem in the activity of database.
Has any one faced this problem, It is AIX, Oracle
8.1.7 Database and non archived mode. We never gave
like recover any thing, why it is trying to recover
from error message as follows?

ORA-00600: internal error code, arguments: [2023],
[5], [1], [], [], [], [], []
Mon May 13 16:10:59 2002
ORACLE Instance PAR_D1 (pid = 6) - Error 600
encountered while recovering transaction (7, 43) on
object 1.
Mon May 13 16:10:59 2002

Thanks for your help.
Ravi

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

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

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

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

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

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

2002-05-31 Thread Michael P Sale


You absolutely need to keep the log archive destination disk space free
to create new logs. You NEED to keep these archives for at least the
time of the last beginning of a hot backup, or, if you're doing cold
backups (with the database service stopped) then you need the archives
from at least the time of the last cold backup.

I would strongly suggest that you stop by your favorite bookstore and
read the at least the first 2 chapters of my book Oracle9i for Windows
2000 Tips  Techniques. This will give you a great background to avoid
these kinds of problems in the future. The advantage of this book over
the typical (and VERY good) books is that it is directed to the windows
user. 

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Sent: Friday, May 31, 2002 6:23 AM
To: Multiple recipients of list ORACLE-L


Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location. (win2k,Oracle
8.1.6) (I did went thru the manual)

thx
Sam


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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).

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

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

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

Re:RE: partition tables


 One item I've learned about Oracle from our recent audit is that
 if you have not licensed an option, but installed it they don't
really  get bent out of shape so long as your not using it.


I've had Oracle Support tell me to install EVERYTHING and just use what
I'm licensed for. The logic behind this is that when the developers
test the release, they test it compiled with everything in it. It's too
time-consuming to test every possible variation on options. So if you
install everything then you are at least working with an executable
that has been tested.

Rachel


--- [EMAIL PROTECTED] wrote:
 BigP,
 
 You'll have to rebuild the table from scratch as a partitioned
 table.  Yes
 you can expect a performance gain, based on the fact that you
 partition it
 appropriately  Also, if you haven't already licensed the partitioning
 option
 from Oracle, or installed it, you will have to.
 
 One item I've learned about Oracle from our recent audit is that
 if you have
 not licensed an option, but installed it they don't really get bent
 out of shape
 so long as your not using it.
 
 Dick Goulet
 
 Reply Separator
 Author: Khedr; Waleed [EMAIL PROTECTED]
 Date:   5/30/2002 6:08 PM
 

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972
 
 
 -Original Message-
 Sent: Thursday, May 30, 2002 8:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi All ,
 We are thinking of converting one of huge table in to partition table
 .
 What is best way to achieve this ? Is there any alter table clause
 that can
 do this or I will have to export ..recreate table with partition
 option and
 then import . Also how can I mentiod that partition should have only
 10
 rows . For example after each 10 rows add another partition ?
 If I have 1000 rows in the table , should I expect some
 performance gain
 out of this 
  
 Thanks ,
 BigP
  
  
 
 
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META HTTP-EQUIV=Content-Type CONTENT=text/html;
 charset=iso-8859-1
 
 
 META content=MSHTML 5.50.4915.500 name=GENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=#ff
 DIVFONT face=Arial color=#ff size=2A 

href=http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972/A
 /FONT/DIV
 BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
   DIV class=OutlookMessageHeader dir=ltr align=leftFONT
 face=Tahoma 
   size=2-Original Message-BRBFrom:/B BigP 
   [mailto:[EMAIL PROTECTED]]BRBSent:/B Thursday, May
 30, 2002 
   8:59 PMBRBTo:/B Multiple recipients of list
 ORACLE-LBRBSubject:/B 
   partition tablesBRBR/FONT/DIV
   DIVFONT face=Arial size=2Hi All ,/FONT/DIV
   DIVFONT face=Arial size=2We are thinking ofnbsp;converting one
 of huge 
   table in to partition table .nbsp; What is best way to achieve
 this ? Is 
   there any alter table clause that can do this or I will have to
 export 
   ..recreate table with partition option and then import . Also how
 can I 
   mentiod that partition should have only 10 rows . For example
 after each 
   10 rows add another partition ?/FONT/DIV
   DIVFONT face=Arial size=2If I have 1000 rows in the table ,
 should I 
   expect some performance gain out of this /FONT/DIV
   DIVFONT face=Arial size=2/FONTnbsp;/DIV
   DIVFONT face=Arial size=2Thanks ,/FONT/DIV
   DIVFONT face=Arial size=2BigP/FONT/DIV
   DIVFONT face=Arial size=2/FONTnbsp;/DIV
   DIVFONT face=Arial
 size=2/FONTnbsp;/DIV/BLOCKQUOTE/BODY/HTML
 
 -- 
 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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: So, What is a 'Production DBA'?

2002-05-31 Thread Hately Mike


Wow Joe, how very like-minded we are.
I'm not in the least swayed in this opinion by my programmer/system
administrator/oracle DBA career path.

3 years PL/1,DL/1 and Assembler programming for those of you with good
memories.
3 years mainframe system admin (VSE? VM?). Actually still programming at the
same time. Long days!
11 years sys admin and Oracle DBA with the balance shifting further towards
DBA as the years went by.

=)

Mike

-Original Message-
Sent: 31 May 2002 13:58
To: Multiple recipients of list ORACLE-L



For what it's worth I'll add my .02 cents worth to this.  I've been
in IT now for 14 years, started with Informix for my first 3 or 4 years,
the rest with Oracle.  I've seen my share of duhvelopers but get the
best giggles from the fights that happen between DBA's and System
Admins.  You know the type I'm talking about, the DBA says the semaphores
need to be tweaked and the System Admin knows nothing about Oracle and
doesn't want a lowly DBA to poke around ;-)

In my humble opinion, perfect path to DBA enlightenment:

A couple or three years as a developer,
a few as a System Admin
a year as a junior DBA learning the Job

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

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

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

* Certified Oracle DBAs Needed in the Dallas area..

2002-05-31 Thread OraStaff


Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.

PLEASE Do Not send your resume for this position UNLESS you are fully
certified and 
have the skills outlined below for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes cannot be
considered.
If you are employed by a consulting company you should have a long term
project history.

These are full time staff positions so no sub-contractors or third parties
please.

No H-1B candidates please.

Position #1- Oracle OCP DBA
Salary: 75-90K/yr
Start Date: immediately
 
Position # 2- Oracle OCP DBA Consultant..permanent position
Salary: 75-90K/yr
Start Date: immediately
* This position will be up to 100% travel (limited to TX, OK, LA, and Arkansas
only). All expenses will be reimbursable.
 
The overview of qualifications for both of the above listed OCP's are as
follows:
 
REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I
 
DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,
Windows NT/2000, Unix, HP
 
JOB DESCRIPTION: This technical consultant position will be required to
support many clients, with a broad range of disciplines. Must be a
self-starter, excellent communication skills along with a strong technical
expertise. This position requires strong consulting skills (i.e. some
project management, technical leadership, background with multiple
methodologies), complete development life cycle experience as well as a
proven expert level in the following Oracle disciplines:
 
Database Administration, Performance Tuning, Backup/Recovery Strategies,
Installation/Upgrades, PL/SQL development (stored procedures, packages,
database triggers, etc..), Oracle Networking (SQL*Net, Net8)

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the
position interested in)
ph: 1-800 -549-8502

All Submissions are handled in confidence.

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


 
 

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

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

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

Re: partition tables

2002-05-31 Thread paquette stephane


You can use insert select , export/import, create as
select to move data from a non-partitionned to a
partitionned table.

Partitionning helps in the management of large tables
more than in speeding the queries. 
Will you delete data from that table one day ?
Choose the partition key carefully. 

A partition with only 100 000 rows is pretty small.
Since you have 10 000 000 rows in your table, you will
have 100 partitions of 100 000 rows, it's way too many
small partitions.


 --- BigP [EMAIL PROTECTED] a écrit :  Hi
All ,
 We are thinking of converting one of huge table in
 to partition table .  What is best way to achieve
 this ? Is there any alter table clause that can do
 this or I will have to export ..recreate table with
 partition option and then import . Also how can I
 mentiod that partition should have only 10 rows
 . For example after each 10 rows add another
 partition ?
 If I have 1000 rows in the table , should I
 expect some performance gain out of this 
 
 Thanks ,
 BigP
 
 
  

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

MySQL versus Oracle

2002-05-31 Thread Joe Testa


Anyone on the list done a comparison(or worked with both) MySQL and 
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move 
into the oracle world and i know nothing about mySQL and am wondering if 
the transition from one to the other is easily done.

thanks, joe


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

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

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

RE: partition tables

2002-05-31 Thread DENNIS WILLIAMS


BigP - I agree with Dick that you will need to create your new partitioned
table and copy the rows from your current table into it. Given your
questions, before you charge into partitioning, carefully study the ways
partitioning can increase your performance. It isn't just some magic pixie
dust that simply makes everything faster. Carefully study how the table is
accessed. For example, I applied partitioning to two instances. For one, the
performance gain was tremendous. Queries that had taken more than 2 minutes
to complete dropped to under 10 seconds. You could hear the users cheering.
On another instance, there was no detectable performance gain and I ended up
undoing the partitioning. Fortunately Oracle is pretty lenient in terms of
letting you try the feature to make sure it will deliver performance worth
the licensing fee.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, May 30, 2002 7:59 PM
To: Multiple recipients of list ORACLE-L


Hi All ,
We are thinking of converting one of huge table in to partition table .
What is best way to achieve this ? Is there any alter table clause that can
do this or I will have to export ..recreate table with partition option and
then import . Also how can I mentiod that partition should have only 10
rows . For example after each 10 rows add another partition ?
If I have 1000 rows in the table , should I expect some performance gain
out of this 
 
Thanks ,
BigP
 
 

-- 
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: So, What is a 'Production DBA'?


see, this is why I always bribe my SAs. chocolate seems to work well,
beers after work as necessary :)


--- Joe LaCascio [EMAIL PROTECTED] wrote:
 
 For what it's worth I'll add my .02 cents worth to this.  I've been
 in IT now for 14 years, started with Informix for my first 3 or 4
 years,
 the rest with Oracle.  I've seen my share of duhvelopers but get the
 best giggles from the fights that happen between DBA's and System
 Admins.  You know the type I'm talking about, the DBA says the
 semaphores
 need to be tweaked and the System Admin knows nothing about Oracle
 and
 doesn't want a lowly DBA to poke around ;-)
 
 In my humble opinion, perfect path to DBA enlightenment:
 
 A couple or three years as a developer,
 a few as a System Admin
 a year as a junior DBA learning the Job
 
 Joe
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe LaCascio
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: partition tables

2002-05-31 Thread Steven Lembark




-- paquette stephane [EMAIL PROTECTED]

 You can use insert select , export/import, create as
 select to move data from a non-partitionned to a
 partitionned table.

 Partitionning helps in the management of large tables
 more than in speeding the queries.
 Will you delete data from that table one day ?
 Choose the partition key carefully.

 A partition with only 100 000 rows is pretty small.
 Since you have 10 000 000 rows in your table, you will
 have 100 partitions of 100 000 rows, it's way too many
 small partitions.

Depends on the use. If they have many queries for which
indexes don't help then locally managed part's w/ table
scans in parallel server might help. It also depends on
their unit of rolloff. In a near-realtime system being
able to offline/truncate a small partition every 3 minutes
can be a big help. I've dealt with databases that had
houly partitions for 7 days (though with more rows than
this, the count of partitions helped).

A lot of it comes down to how the primary key breaks
down and how granular the rolloff needs to be.

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

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

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

RE: So, What is a 'Production DBA'?

2002-05-31 Thread DENNIS WILLIAMS


Amen to that. Keep on the good side of the sys admins!
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 31, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L


see, this is why I always bribe my SAs. chocolate seems to work well,
beers after work as necessary :)


--- Joe LaCascio [EMAIL PROTECTED] wrote:
 
 For what it's worth I'll add my .02 cents worth to this.  I've been
 in IT now for 14 years, started with Informix for my first 3 or 4
 years,
 the rest with Oracle.  I've seen my share of duhvelopers but get the
 best giggles from the fights that happen between DBA's and System
 Admins.  You know the type I'm talking about, the DBA says the
 semaphores
 need to be tweaked and the System Admin knows nothing about Oracle
 and
 doesn't want a lowly DBA to poke around ;-)
 
 In my humble opinion, perfect path to DBA enlightenment:
 
 A couple or three years as a developer,
 a few as a System Admin
 a year as a junior DBA learning the Job
 
 Joe
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe LaCascio
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

2002-05-31 Thread Joe Testa


no aliens either the foreigner or outer space kind,

this response follows the same as the HELP command.

I just feel the need.

joe


OraStaff wrote:

Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.

PLEASE Do Not send your resume for this position UNLESS you are fully
certified and 
have the skills outlined below for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes cannot be
considered.
If you are employed by a consulting company you should have a long term
project history.

These are full time staff positions so no sub-contractors or third parties
please.

No H-1B candidates please.

Position #1- Oracle OCP DBA
Salary: 75-90K/yr
Start Date: immediately
 
Position # 2- Oracle OCP DBA Consultant..permanent position
Salary: 75-90K/yr
Start Date: immediately
* This position will be up to 100% travel (limited to TX, OK, LA, and Arkansas
only). All expenses will be reimbursable.
 
The overview of qualifications for both of the above listed OCP's are as
follows:
 
REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I
 
DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,
Windows NT/2000, Unix, HP
 
JOB DESCRIPTION: This technical consultant position will be required to
support many clients, with a broad range of disciplines. Must be a
self-starter, excellent communication skills along with a strong technical
expertise. This position requires strong consulting skills (i.e. some
project management, technical leadership, background with multiple
methodologies), complete development life cycle experience as well as a
proven expert level in the following Oracle disciplines:
 
Database Administration, Performance Tuning, Backup/Recovery Strategies,
Installation/Upgrades, PL/SQL development (stored procedures, packages,
database triggers, etc..), Oracle Networking (SQL*Net, Net8)

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the
position interested in)
ph: 1-800 -549-8502

All Submissions are handled in confidence.

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


 
 



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

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

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


Joe,

I would say that depends on the needs of the job.  If the guy/girl is trying
to get a development slot, yeah not too hard.  If a DBA slot, the difference is
kind of night  day.  As a junior DBA I'd be inclined to say yes, then pack the
person off to an Oracle DBA class pretty quick.

Dick Goulet

Reply Separator
Author: Joe Testa [EMAIL PROTECTED]
Date:   5/31/2002 6:38 AM

Anyone on the list done a comparison(or worked with both) MySQL and 
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move 
into the oracle world and i know nothing about mySQL and am wondering if 
the transition from one to the other is easily done.

thanks, joe


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

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

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


Big (or should we just call you P?),

I have become somewhat experienced at manipulating
large partition tables since I have had to do it so
often (can you say poor initial design?). Export /
import is not the fastest way to go.

Here are some tips from the trenches:

1) You mention that each partition should have only
100,000 rows, but it might be beneficial for you to
focus more on the partition key. If you choose the
right partition key, queries will be able to do
partition pruning, where they can look at the data
dictionary and see that they only want to look at
certain partitions and not others. This is the big win
for partitioned tables - remove as much data from the
initial lookup as possible by skipping partitions.

2) Investigate create table as select with the
nologging option, in combination with the partition
exchange option. Let's assume that you want a
partition table with 10 partitions. You can create an
empty partition table with 10 partitions, CTAS 10 new
tables from your original table, and exchange the
partitions. After this, you will have a partitition
table full of data. Ain't it cool. 

3) If you are sure of your data integrity, use the
without validation clause of the partition exchange.
Otherwise, Oracle will look at each and every row in
each and every partition when it is swapped in -
really slows things down.

4) Another way of creating a partition table from a
standalone is to create the empty partition table and
do a insert /*+ nologging append parallel(a,12) */
into tablea a select /*+ parallel (b,12) /* from
tableb b; and this will spawn off 12 parallel
processes for the select, 12 parallel processes for
the insert, use almost no rollback (appends the data)
and use almost no logging. This screams like a
banshee, very fast. Remember, *each* pq process will
write to its own extent, size your extents
accordingly.

5) Create bitmap partitioned indexes on your low
cardinality join columns (look at number of distinct
values / number of rows) - make sure and set your
sort_area_size wayy high (and set your
sort_area_retained_size to the same value - bug in
oracle with the two not being equal throwing a -600
error) but remember - *each* pq process gets its own
sort_area_size - don't run the box out of ram.

6) Don't create the indexes before you load - this
will fragment them and slow down your insert.

7) Remember to set your parallelism on your table back
to a reasonable level if you CTAS with pq - otherwise,
a high parallelism level on the table will tend to
make Oracle favor full table scans and hash or sort
joins over nested loops and index lookups. Same goes
with indexes - more PQ favors full index scans.

8) You can analyze all your partitions separate from
each other, and in tandem if you wish.

9) alter your index partitions unusable before you
load and then rebuild those partitions with the
compute statistics clause - this is faster and
optimizes your indexes. Bitmap indexes do not like to
be up while loading. Be advised, if someone tries to
query this table and they don't have
skip_unusable_indexes=true set in their session,
they will get an error. One way to set this parameter
in every session is to include it in a logon trigger
using execute immediate 'alter session set
skip_unusable_indexes=true' - HOWEVER, this will
change their execution plan to favor FTS since the
index is *not available*. Use caution. 

10) Create and rebuild your indexes in parallel.

11) Use a MAXVALUE partition - this will allow you to
load all data and catch that data that falls outside
the other partition ranges. If you don't have a
maxvalue partition, and you try to insert a row that
does not match the other partitions, you will get
inserted value beyond highest legal partition key
and your insert will fail and might stop your load.
You can always split the MAXVALUE partition later.

12) Put all your table partitions in one tablespace
and all your index partitions in another single
tablespace (each suitably striped, of course, and
respecting recovery plans.) This will allow you to
automate partition management (addition of new
partitions and dropping of old) if you need to and
manage your tablespace space more effectively.

13) Use the monitoring option on your partitions -
not all partitions change enough to be analyzed each
time necessarily, and this will tell you which ones
need it.

14) *do not* create your table with pctfree = 0 and
*do* create with healthy initrans value (we use 8). If
you have initrans of 2 and pctfree of 0, and you try
to insert/update the table with 3 or more parallel
processes, the ITL table (the thing that the processes
register with when they use the table)  cannot grow
(no space with pctfree 0) and the extra processes will
either wait or fail with a deadlock error. To change
pctfree you will have to rebuild the table. 

hth,

jack silvey







 -Original Message-
 Sent: Thursday, May 30, 2002 8:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi

Re[2]: So, What is a 'Production DBA'?


(UPI) WASHINGTON, DC Police warn all male clubbers, party-goers and
unsuspecting pub regulars to keep alert and stay cautious when offered a
drink from any woman. A new date rape drug on the market, called beer, is
being used by females to target unsuspecting men. 

  The drug is generally found in liquid form, and is now available
almost anywhere. Beer is used by female sexual predators at parties and
bars to convince their male victims to go home and have sex with them. 

  Typically, a woman needs only to persuade a guy to consume a few units
of beer and then simply ask him home for 'no-strings-attached sex.'  Men
are rendered helpless against this approach: After several beers men will
often succumb to desires to perform sexual acts on horrific looking women to
whom they would never normally be attracted. 

  Men often awaken after being given beer with only hazy memories of
exactly what has happened to them the night before, just a vague feeling
that something bad occurred. At other times these unfortunate men are stung
for their life's savings in a familiar scam known as a relationship. 

  Please!  Forward this warning to every male you know. However, if you
fall victim to this insidious beer and the predatory women administering
it, there are male support groups with venues in every town where you can
discuss the details of your shocking encounter in an open and frank manner
with similarly-affected, like-minded guys. For the nearest such support
group near you, just look up: 
  Golf Courses  in the Yellow Pages. 



Dick Goulet :)

Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date:   5/31/2002 6:19 AM

see, this is why I always bribe my SAs. chocolate seems to work well,
beers after work as necessary :)


--- Joe LaCascio [EMAIL PROTECTED] wrote:
 
 For what it's worth I'll add my .02 cents worth to this.  I've been
 in IT now for 14 years, started with Informix for my first 3 or 4
 years,
 the rest with Oracle.  I've seen my share of duhvelopers but get the
 best giggles from the fights that happen between DBA's and System
 Admins.  You know the type I'm talking about, the DBA says the
 semaphores
 need to be tweaked and the System Admin knows nothing about Oracle
 and
 doesn't want a lowly DBA to poke around ;-)
 
 In my humble opinion, perfect path to DBA enlightenment:
 
 A couple or three years as a developer,
 a few as a System Admin
 a year as a junior DBA learning the Job
 
 Joe
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe LaCascio
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: partition tables

2002-05-31 Thread Ron Rogers


BigP,
  You stated that you would like to limit the number of rows in a
partition. The partitioning option uses a range function on a column
to determine what partition to place to data into. If you do not have a
column that is used in your where clause, you are going to have a
difficult time determining what data is placed in what partition. The
biggest performance is gained when Oracle can eliminate the partitions
that do not match the where clause and then applies the search criteria
to a small subset of data, ie: a partition. As an example, if all of
your data had a date field that was used in the where clause you could
partition the data by range on that column by year or year,month and
have the data divided into a years worth of data or a months worth of
data. When oracle is requested to search for data it would eliminate all
of the partitions that do not match the date in the where clause, thus
eliminating the majority of the partitions if not all but one
partition.
 I would suggest as others have that you read and understand the
workings of partitioning and the possible benefits gained.
Ron
ROR mª¿ªm

 [EMAIL PROTECTED] 05/31/02 10:33AM 
BigP - I agree with Dick that you will need to create your new
partitioned
table and copy the rows from your current table into it. Given your
questions, before you charge into partitioning, carefully study the
ways
partitioning can increase your performance. It isn't just some magic
pixie
dust that simply makes everything faster. Carefully study how the table
is
accessed. For example, I applied partitioning to two instances. For
one, the
performance gain was tremendous. Queries that had taken more than 2
minutes
to complete dropped to under 10 seconds. You could hear the users
cheering.
On another instance, there was no detectable performance gain and I
ended up
undoing the partitioning. Fortunately Oracle is pretty lenient in terms
of
letting you try the feature to make sure it will deliver performance
worth
the licensing fee.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, May 30, 2002 7:59 PM
To: Multiple recipients of list ORACLE-L


Hi All ,
We are thinking of converting one of huge table in to partition table
.
What is best way to achieve this ? Is there any alter table clause that
can
do this or I will have to export ..recreate table with partition option
and
then import . Also how can I mentiod that partition should have only
10
rows . For example after each 10 rows add another partition ?
If I have 1000 rows in the table , should I expect some performance
gain
out of this 
 
Thanks ,
BigP
 
 

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

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

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

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

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

RE: MySQL versus Oracle

2002-05-31 Thread Weaver, Walt


We use both here, use'em as back-end databases for our hosted web sites.

MySQL is fast, easy to set up and maintain, and free. Works great for our
small and medium-sized web sites. But, it doesn't scale as well as Oracle
and we've had better luck using Oracle with our large, active sites. MySQL
with MyISAM table types has table-level locking only, and a large number of
concurrent selects can slow things down tremendously.

IMHO, maintaining a MySQL database is more of a SysAdmin job than a DBA job,
and I don't think you'll have much of a problem with the transition. 

We recently finished up some benchmarking, using Oracle and MySQL with
MyISAM and InnoDB table types. I can send you the test report if you'd like.

I personally think MySQL has a bright future, and when 4.1 comes out (not
expected for a year or so) it could start making a real dent in the database
market. It has certainly helped us here; we've been able to keep our Oracle
licensing costs to a minimum by using MySQL for the majority of our sites.

If you'd like more information, Joe, email me directly.

--Walt Weaver
  Bozeman, Montana 

-Original Message-
Sent: Friday, May 31, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L


Anyone on the list done a comparison(or worked with both) MySQL and 
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move 
into the oracle world and i know nothing about mySQL and am wondering if 
the transition from one to the other is easily done.

thanks, joe


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

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

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

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

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

RE: RE: partition tables

2002-05-31 Thread Michael P Sale


I can confirm that this is true and a good idea. Testing is also done in
this fasion. Besides that, an Oracle salesperson would gladly have you
pay more without having to do anything on their part or yours.  ;)

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Carmichael
Sent: Friday, May 31, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


 One item I've learned about Oracle from our recent audit is that 
 if you have not licensed an option, but installed it they don't
really  get bent out of shape so long as your not using it.


I've had Oracle Support tell me to install EVERYTHING and just use what
I'm licensed for. The logic behind this is that when the developers test
the release, they test it compiled with everything in it. It's too
time-consuming to test every possible variation on options. So if you
install everything then you are at least working with an executable that
has been tested.

Rachel


--- [EMAIL PROTECTED] wrote:
 BigP,
 
 You'll have to rebuild the table from scratch as a partitioned 
 table.  Yes you can expect a performance gain, based on the fact that 
 you partition it
 appropriately  Also, if you haven't already licensed the partitioning
 option
 from Oracle, or installed it, you will have to.
 
 One item I've learned about Oracle from our recent audit is that 
 if you have not licensed an option, but installed it they don't really

 get bent out of shape
 so long as your not using it.
 
 Dick Goulet
 
 Reply Separator
 Author: Khedr; Waleed [EMAIL PROTECTED]
 Date:   5/30/2002 6:08 PM
 

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#4369
72

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436
972
 
 
 -Original Message-
 Sent: Thursday, May 30, 2002 8:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi All ,
 We are thinking of converting one of huge table in to partition table 
 . What is best way to achieve this ? Is there any alter table clause
 that can
 do this or I will have to export ..recreate table with partition
 option and
 then import . Also how can I mentiod that partition should have only
 10
 rows . For example after each 10 rows add another partition ?
 If I have 1000 rows in the table , should I expect some
 performance gain
 out of this 
  
 Thanks ,
 BigP
  
  
 
 
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN 
 HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html;
 charset=iso-8859-1
 
 
 META content=MSHTML 5.50.4915.500 name=GENERATOR STYLE/STYLE
 /HEAD
 BODY bgColor=#ff
 DIVFONT face=Arial color=#ff size=2A 

href=http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.ht
m#436972

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#43
6972/A
 /FONT/DIV
 BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
   DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma
   size=2-Original Message-BRBFrom:/B BigP 
   [mailto:[EMAIL PROTECTED]]BRBSent:/B Thursday, May
 30, 2002 
   8:59 PMBRBTo:/B Multiple recipients of list
 ORACLE-LBRBSubject:/B 
   partition tablesBRBR/FONT/DIV
   DIVFONT face=Arial size=2Hi All ,/FONT/DIV
   DIVFONT face=Arial size=2We are thinking ofnbsp;converting one
 of huge 
   table in to partition table .nbsp; What is best way to achieve
 this ? Is 
   there any alter table clause that can do this or I will have to
 export 
   ..recreate table with partition option and then import . Also how
 can I 
   mentiod that partition should have only 10 rows . For example
 after each 
   10 rows add another partition ?/FONT/DIV
   DIVFONT face=Arial size=2If I have 1000 rows in the table ,
 should I 
   expect some performance gain out of this /FONT/DIV
   DIVFONT face=Arial size=2/FONTnbsp;/DIV
   DIVFONT face=Arial size=2Thanks ,/FONT/DIV
   DIVFONT face=Arial size=2BigP/FONT/DIV
   DIVFONT face=Arial size=2/FONTnbsp;/DIV
   DIVFONT face=Arial
 size=2/FONTnbsp;/DIV/BLOCKQUOTE/BODY/HTML
 
 --
 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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

RE: * Certified Oracle DBAs Needed in the Dallas area..


I like:

REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I


uh-8.x has not been out for 3 years, has it?

Tom Mercadante
Oracle Certified Professional


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


no aliens either the foreigner or outer space kind,

this response follows the same as the HELP command.

I just feel the need.

joe


OraStaff wrote:

Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.

PLEASE Do Not send your resume for this position UNLESS you are fully
certified and 
have the skills outlined below for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes cannot be
considered.
If you are employed by a consulting company you should have a long term
project history.

These are full time staff positions so no sub-contractors or third parties
please.

No H-1B candidates please.

Position #1- Oracle OCP DBA
Salary: 75-90K/yr
Start Date: immediately
 
Position # 2- Oracle OCP DBA Consultant..permanent position
Salary: 75-90K/yr
Start Date: immediately
* This position will be up to 100% travel (limited to TX, OK, LA, and
Arkansas
only). All expenses will be reimbursable.
 
The overview of qualifications for both of the above listed OCP's are as
follows:
 
REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I
 
DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,
Windows NT/2000, Unix, HP
 
JOB DESCRIPTION: This technical consultant position will be required to
support many clients, with a broad range of disciplines. Must be a
self-starter, excellent communication skills along with a strong technical
expertise. This position requires strong consulting skills (i.e. some
project management, technical leadership, background with multiple
methodologies), complete development life cycle experience as well as a
proven expert level in the following Oracle disciplines:
 
Database Administration, Performance Tuning, Backup/Recovery Strategies,
Installation/Upgrades, PL/SQL development (stored procedures, packages,
database triggers, etc..), Oracle Networking (SQL*Net, Net8)

For  immediate consideration, please send your resume as a Word attachment
to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the
position interested in)
ph: 1-800 -549-8502

All Submissions are handled in confidence.

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


 
 



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

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

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

Design question.

2002-05-31 Thread Grabowy, Chris


We have a designer that is adding a FK on two columns from one table to
another.  These two columns are not in the parent table's primary key.

So we are kind of scratching our heads wondering if you can, from a proper
design point of view, create such a FK?  It appears that if you update one
of the two columns in the child table then you would need to create a new
record in the parent table.  

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

rebuilding indexes

2002-05-31 Thread Adams, Matthew (GEA, MABG, 088130)

Title: rebuilding indexes





Under what conditions would an 'alter index .. rebuild' 
actually case the size of the index to increase 
by about 12 percent?





Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly. 
It's just particular about who it makes friends with.

Re: MySQL versus Oracle

2002-05-31 Thread Joe Raube


I've seen MySQL truncate data on insert without warning.

MySQL also does not have foreign keys. It accepts the syntax of
create foreign key, but nothing is created, nothing is enforced.

I recently did a migration from MySQL to Oracle, and these were the
two major issues I faced.

Let me know if you have any more specific questions.

-Joe

--- Joe Testa [EMAIL PROTECTED] wrote:
 Anyone on the list done a comparison(or worked with both) MySQL and
 
 Oracle and can give me the good/bad points of My SQL?
 
 Doing interviewer thing and someone has My SQL who would like to
 move 
 into the oracle world and i know nothing about mySQL and am
 wondering if 
 the transition from one to the other is easily done.
 
 thanks, joe


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

2002-05-31 Thread Whittle Jerome Contr NCI

Title: RE: * Certified Oracle DBAs Needed in the Dallas area..

I have a stable work history! As a teenager I worked at a race track cleaning out stables. Some of those skills and the working environment translated well into being a DBA.

Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

OraStaff wrote:

Great Company located in Greater Dallas, Texas area (Richardson) needs 2

CERTIFIED (OCP)

Oracle DBAs for full time staff positions.

PLEASE Do Not send your resume for this position UNLESS you are fully

certified and

have the skills outlined below for this position.

Please Do Not send your resume unless you have a stable work history.

Candidates whose work history includes frequent job changes cannot be

considered.

If you are employed by a consulting company you should have a long term

project history.

These are full time staff positions so no sub-contractors or third parties

please.

No H-1B candidates please.

Position #1- Oracle OCP DBA

Salary: 75-90K/yr

Start Date: immediately

Position # 2- Oracle OCP DBA Consultant..permanent position

Salary: 75-90K/yr

Start Date: immediately

* This position will be up to 100% travel (limited to TX, OK, LA, and Arkansas

only). All expenses will be reimbursable.

The overview of qualifications for both of the above listed OCP's are as

follows:

REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle

Database 8.x, 8I

DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,

Windows NT/2000, Unix, HP

JOB DESCRIPTION: This technical consultant position will be required to

support many clients, with a broad range of disciplines. Must be a

self-starter, excellent communication skills along with a strong technical

expertise. This position requires strong consulting skills (i.e. some

project management, technical leadership, background with multiple

methodologies), complete development life cycle experience as well as a

proven expert level in the following Oracle disciplines:

Database Administration, Performance Tuning, Backup/Recovery Strategies,

Installation/Upgrades, PL/SQL development (stored procedures, packages,

database triggers, etc..), Oracle Networking (SQL*Net, Net8)

For immediate consideration, please send your resume as a Word attachment to:

OraStaff, Inc.

Email: [EMAIL PROTECTED]

Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the

position interested in)

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.

So please contact me if you know of anyone who would be qualified/interested

in the posiition described above- if it is not a match for your skills.

Thanks,

Bill Law

Peoplesoft/EPM Administrator with Oracle/Unix Needed..

2002-05-31 Thread OraStaff


Stable Financial Services Company in Memphis, Tennessee needs a
Peoplesoft/EPM Administrator
for a full time staff position.

PLEASE Do Not send your resume UNLESS you have the skills outlined below for
this position.


* Please do not send your resume unless you have a stable work history.
  Candidates whose work history includes frequent job changes connot be
  considered.
  If you are employed by a consulting company you must have a long term
  project history.

NO Sponsorship is available!

This is a full time staff position..Please No sub-contractors or third parties.

Some relocation assistance is available.

Position description is as follows:

Essential Job Functions:
Will be a member of the Systems Integration Team (SI) responsible for the
development and technical maintenance of several PeopleSoft HRMS, Financials
and EPM environments.

Will be responsible for the configuration and administration of all
components of the PeopleSoft EPM environments. Will be responsible for EPM
report customization and testing, EPM security setup/maintenance,
Informatica PowerMart (ETL) execution and trouble-shooting and COGNOS Cube
Manager and Powerplay administration and security.

Will also assist with application server/web server/process scheduler
administration and configuration, data administration, PeopleTools upgrades
and PeopleSoft patches  fixes. Will also assist with migrating object
changes between the various PeopleSoft environments. These objects would
include online objects (pages, records, fields, etc...) and batch components
(SQR, COBOL, etc...)

Requirements:
-Solid Knowledge/Experience of PeopleSoft EPM, Informatica and COGNOS as
well as 
 Peoplesoft administration (Unix/Oracle)
-Should have some PeopleSoft application server/web server/process scheduler
 administration and configuration experience, preferrably in a PeopleSoft 8
 environment. 
-Should have some experience using PeopleSoft's data management
 tools (e.g. Data Mover).
-Should have some experience applying PeopleSoft patches  fixes.
-Must have PeopleSoft trouble-shooting experience working in
 an Oracle/UNIX environment.

* MUST have U.S. citzenship or green card holder.

This Company offers:
* Financial Stability
* Competitive compensation package -80K base salary maybe more.

PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as an attachment 
ALONG with the number(s) of the positions that you are interested in to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Memphis/PS-EPM Admin/Bob 

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

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

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

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

RE: MySQL versus Oracle

2002-05-31 Thread Bill Pass



The transition to oracle from mysql is a great deal
more complicated than the inverse. I am hoping that is
what you meant :}

--- Weaver, Walt [EMAIL PROTECTED] wrote:
 We use both here, use'em as back-end databases for
 our hosted web sites.
 
 MySQL is fast, easy to set up and maintain, and
 free. Works great for our
 small and medium-sized web sites. But, it doesn't
 scale as well as Oracle
 and we've had better luck using Oracle with our
 large, active sites. MySQL
 with MyISAM table types has table-level locking
 only, and a large number of
 concurrent selects can slow things down
 tremendously.
 
 IMHO, maintaining a MySQL database is more of a
 SysAdmin job than a DBA job,
 and I don't think you'll have much of a problem with
 the transition. 
 
 We recently finished up some benchmarking, using
 Oracle and MySQL with
 MyISAM and InnoDB table types. I can send you the
 test report if you'd like.
 
 I personally think MySQL has a bright future, and
 when 4.1 comes out (not
 expected for a year or so) it could start making a
 real dent in the database
 market. It has certainly helped us here; we've been
 able to keep our Oracle
 licensing costs to a minimum by using MySQL for the
 majority of our sites.
 
 If you'd like more information, Joe, email me
 directly.
 
 --Walt Weaver
   Bozeman, Montana 
 
 -Original Message-
 Sent: Friday, May 31, 2002 8:39 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Anyone on the list done a comparison(or worked with
 both) MySQL and 
 Oracle and can give me the good/bad points of My
 SQL?
 
 Doing interviewer thing and someone has My SQL who
 would like to move 
 into the oracle world and i know nothing about mySQL
 and am wondering if 
 the transition from one to the other is easily done.
 
 thanks, joe
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

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

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

How to grant privileges on all the tables of owner1 to owner2?

2002-05-31 Thread Mandal, Ashoke


Greetings,

Here is the scenario. 
I have 2 users(owner1, owner2) in an oracle database.
owner1 owns 150 tables.
owner2 needs select,insert,update,delete privilege on all the tables owned by owner1.

One option is : login as owner1 and 

grant select,insert,update,delete on owner1.table1 to owner2;
.
.
.
grant select,insert,update,delete on owner1.table150 to owner2;

I was wondering if there is any way I can perform the same work using one sql 
statement instead of using 150 statements.

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

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

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

2002-05-31 Thread Weaver, Walt


Yes, that's exactly what I meant.

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



The transition to oracle from mysql is a great deal
more complicated than the inverse. I am hoping that is
what you meant :}

--- Weaver, Walt [EMAIL PROTECTED] wrote:
 We use both here, use'em as back-end databases for
 our hosted web sites.
 
 MySQL is fast, easy to set up and maintain, and
 free. Works great for our
 small and medium-sized web sites. But, it doesn't
 scale as well as Oracle
 and we've had better luck using Oracle with our
 large, active sites. MySQL
 with MyISAM table types has table-level locking
 only, and a large number of
 concurrent selects can slow things down
 tremendously.
 
 IMHO, maintaining a MySQL database is more of a
 SysAdmin job than a DBA job,
 and I don't think you'll have much of a problem with
 the transition. 
 
 We recently finished up some benchmarking, using
 Oracle and MySQL with
 MyISAM and InnoDB table types. I can send you the
 test report if you'd like.
 
 I personally think MySQL has a bright future, and
 when 4.1 comes out (not
 expected for a year or so) it could start making a
 real dent in the database
 market. It has certainly helped us here; we've been
 able to keep our Oracle
 licensing costs to a minimum by using MySQL for the
 majority of our sites.
 
 If you'd like more information, Joe, email me
 directly.
 
 --Walt Weaver
   Bozeman, Montana 
 
 -Original Message-
 Sent: Friday, May 31, 2002 8:39 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Anyone on the list done a comparison(or worked with
 both) MySQL and 
 Oracle and can give me the good/bad points of My
 SQL?
 
 Doing interviewer thing and someone has My SQL who
 would like to move 
 into the oracle world and i know nothing about mySQL
 and am wondering if 
 the transition from one to the other is easily done.
 
 thanks, joe
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

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

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

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

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

SQL Question

2002-05-31 Thread Carle, William T (Bill), ALCAS


Hi,

I have a table with 1 field and 2 dates: field1, date1, date2. I need to find the 
max value of date2 for all the field1, date1 combinations. Then I want to join the 
table to itself on field1 and find all the rows where field1 matches, date1  date1, 
and max(date2)  max(date2). I did this in 2 queries. First I created a view as 
follows:

create view v1 (f1, d1, d2)
as select field1,date1,max(date2) from table1
group by field1,date1;

Then I joined the 2 views together like this:

select a.f1,a.d1,a.d2 from v1 a, v1 b
where a.f1 = b.f1
and a.d1  b.d1
and a.d2  b.d2;

This worked fine, but I was wondering if there was a way to do this in one query 
without having to create a view.


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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

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

2002-05-31 Thread G . Plivna



I'm trying to collect some links of resources that compares various
databases

Here is the result until today
http://www.itsystems.lv/gints/compare_db.htm

You all are welcomed to send more!


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



   
 
  Weaver, Walt   
 
  wweaver@rightnowTo:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  .comcc: 
 
  Sent by: Subject:  RE: MySQL versus Oracle   
 
  [EMAIL PROTECTED] 
 
   
 
   
 
  2002.05.31 18:18 
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




We use both here, use'em as back-end databases for our hosted web sites.

MySQL is fast, easy to set up and maintain, and free. Works great for our
small and medium-sized web sites. But, it doesn't scale as well as Oracle
and we've had better luck using Oracle with our large, active sites. MySQL
with MyISAM table types has table-level locking only, and a large number of
concurrent selects can slow things down tremendously.

IMHO, maintaining a MySQL database is more of a SysAdmin job than a DBA
job,
and I don't think you'll have much of a problem with the transition.

We recently finished up some benchmarking, using Oracle and MySQL with
MyISAM and InnoDB table types. I can send you the test report if you'd
like.

I personally think MySQL has a bright future, and when 4.1 comes out (not
expected for a year or so) it could start making a real dent in the
database
market. It has certainly helped us here; we've been able to keep our Oracle
licensing costs to a minimum by using MySQL for the majority of our sites.

If you'd like more information, Joe, email me directly.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, May 31, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L


Anyone on the list done a comparison(or worked with both) MySQL and
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move
into the oracle world and i know nothing about mySQL and am wondering if
the transition from one to the other is easily done.

thanks, joe


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

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

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

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

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




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

RE: How to grant privileges on all the tables of owner1 to owner2


Ashoke,

Run the following script from the owner1 account:

set head off
set lines 120
set pages 200
spool grant.sql
select 'grant select,insert,update,delete on ' || table_name || ' to
owner2;'
from user_tables
/
spool off
@grant.sql

good luck!

Tom Mercadante
Oracle Certified Professional


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


Greetings,

Here is the scenario. 
I have 2 users(owner1, owner2) in an oracle database.
owner1 owns 150 tables.
owner2 needs select,insert,update,delete privilege on all the tables owned
by owner1.

One option is : login as owner1 and 

grant select,insert,update,delete on owner1.table1 to owner2;
.
.
.
grant select,insert,update,delete on owner1.table150 to owner2;

I was wondering if there is any way I can perform the same work using one
sql statement instead of using 150 statements.

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

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

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


Chris,

The column in the parent table needs to be the PK or be unique.
Should be no problem.

Tom Mercadante
Oracle Certified Professional


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


We have a designer that is adding a FK on two columns from one table to
another.  These two columns are not in the parent table's primary key.

So we are kind of scratching our heads wondering if you can, from a proper
design point of view, create such a FK?  It appears that if you update one
of the two columns in the child table then you would need to create a new
record in the parent table.  

Thoughts??
-- 
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).
-- 
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: Design question.

2002-05-31 Thread Whittle Jerome Contr NCI

Title: RE: Design question.






Chris,


Is there a unique constraint based on the two fields in the parent table? If so it might work OK. Still there are the problems of referential integrity, orphan records, etc. If there isn't a unique constraint in the parent table, you can also add in potential many-to-many relationships as a problem to.

Basically I'd say this falls into the Not Good category.


Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]

Sent: Friday, May 31, 2002 10:33 AM

To: Multiple recipients of list ORACLE-L

Subject: Design question.


We have a designer that is adding a FK on two columns from one table to

another. These two columns are not in the parent table's primary key.


So we are kind of scratching our heads wondering if you can, from a proper

design point of view, create such a FK? It appears that if you update one

of the two columns in the child table then you would need to create a new

record in the parent table. 


Thoughts??

Re: How to grant privileges on all the tables of owner1 to owner2?


try something like this:

set serveroutput on size 100;

declare 

v_sql varchar2(4000);
cursor c_cur is select table_name from user_tables;


begin

begin

for v_cur in c_cur loop
v_sql = 'grant select,insert,update,delete  on
'||v_cur.table_name||' to owner2';

dbms_output.put_line('did '||v_sql);

execute immediate v_sql;

exception 
when others then
dbms_output.put_line ('problem with '||v_sql);
end;

end loop;

end;

/

jack silvey



--- Mandal, Ashoke [EMAIL PROTECTED]
wrote:
 Greetings,
 
 Here is the scenario. 
 I have 2 users(owner1, owner2) in an oracle
 database.
 owner1 owns 150 tables.
 owner2 needs select,insert,update,delete privilege
 on all the tables owned by owner1.
 
 One option is : login as owner1 and 
 
 grant select,insert,update,delete on owner1.table1
 to owner2;
 .
 .
 .
 grant select,insert,update,delete on owner1.table150
 to owner2;
 
 I was wondering if there is any way I can perform
 the same work using one sql statement instead of
 using 150 statements.
 
 Thanks,
 Ashoke
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Mandal, Ashoke
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

CLOBS AND Semicolons

2002-05-31 Thread MacGregor, Ian A.


Most of our Oracle databases are not that busy.  I decided a week ago to start 
capturing individual SQL statements.  I run
a korn shell script every minute  to do so.  The script invokes the following SQL

insert into oracle.statement_info   (SID, USERNAME, STATUS,
OSUSER, MACHINE, RUNTIME, ADDRESS,HASH_VALUE, SQL_TEXT, PIECE,
RUN#, COMMAND_TYPE)  SELECT A.SID, A.USERNAME, A.STATUS,
A.OSUSER, A.MACHINE, SYSDATE,  B.ADDRESS, B.HASH_VALUE,
B.SQL_TEXT, B.PIECE, :V_RUN#, B.COMMAND_TYPE  FROM V$SESSION
A, V$SQLTEXT B  WHERE A.SQL_ADDRESS = B.ADDRESS  AND
A.SQL_HASH_VALUE = B.HASH_VALUE  and command_type = 7
AND (A.LAST_CALL_ET  120 or a.status = 'ACTIVE')


---
Once an hour I call a package which gloms the pieces of  sql_text together.

create or replace package slac_stats_pkg is
   procedure glom_statement;
end slac_stats_pkg;
/
create or replace package body slac_stats_pkg as
   procedure glom_statement is
  psid number;
  prun# number(10,0);
  paddress raw(4);
  phash_value number;
  pstatus varchar2(8);
  posuser varchar2(30);
  pmachine varchar2(64);
  pruntime date;
  pcommand_type number;
  ppiece number;
  pusername varchar2(30);
  statement_line varchar2(64);
  statement_buffer varchar2(32760);
  statement_buffer_length number;
  psql_text clob;
  offset number;
  maxrun# number(10,0);
  cursor get_statement is 
 select piece, sql_text 
 from statement_info
 where 
 address = paddress
 and hash_value = phash_value
 and run# = prun#
 order by  run#, address, hash_value, piece;
 cursor get_statement_metadata is
  select  distinct sid, username, status, osuser, machine, runtime,
  address, hash_value, run#, command_type
  from oracle.statement_info
  where run# = maxrun#
  order by  run#, address, hash_value;
begin
 select max(run#) into maxrun# from statement_info;
 open get_statement_metadata;
 loop
  fetch get_statement_metadata into
  psid, pusername, pstatus, posuser, pmachine, pruntime,
  paddress, phash_value, prun#, pcommand_type;
 exit when get_statement_metadata%notfound;
  open get_statement;
  loop
 fetch get_statement into ppiece, statement_line;
  exit when get_statement%notfound;
 statement_buffer := concat(statement_buffer, statement_line);
  end loop;
  close get_statement;
  statement_buffer := concat(statement_buffer,';'); 
  statement_buffer_length := length(statement_buffer);
  offset := 1;
  insert into statement_info_temp
 values (slac_statement_seq.nextval, psid, pusername, pstatus, posuser,
 pmachine, pruntime,paddress, phash_value, prun#, pcommand_type,
 empty_clob())
 return sql_text into psql_text;
  dbms_lob.write(psql_text, statement_buffer_length, 
 offset, statement_buffer);
  commit;
  statement_buffer := null;
end loop;
close get_statement_metadata;
   delete from statement_info where run# = maxrun#;
   commit;
   end glom_statement;
end slac_stats_pkg;
/
  
---
Note that I append a  semicolon  to the end of the statement.  I do  this because I'm 
going to build explain statements
from them.  The above procedure is called by the script below

SQL host cat statements_to_explain.sql 
SET PAGESIZE 0
COLUMN STANZA FORMAT A79 WORD_WRAPPED;
SET TERMOUT OFF
SET FEEDBACK OFF
set scan off
set verify off
set arraysize 3
whenever sqlerror continue
exec slac_stats_pkg.glom_statement;
set long 16384
set arraysize 3
SPOOL explainthem.sql
Select
'alter session set current_schema = ' ||nvl(username, 'SYS') ||';' ||CHR(10) ||
'EXPLAIN PLAN' ||CHR(10) ||
'SET STATEMENT_ID = '''||to_char(statement_id)|| ||chr(10)
||'FOR' ||CHR(10) ||
DBMS_LOB.SUBSTR(SQL_TEXT, DBMS_LOB.GETLENGTH(SQL_TEXT), 1) STANZA 
FROM STATEMENT_INFO_TEMP
/
spool off
set arraysize 20
set long 80
truncate table plan_table
/
@@explainthem
alter session set current_schema = ORACLE;
@@populate_slac_plan_table
@@populate_statement_info_perm
exit
--
The result of running the   sql statment above is ...

alter session set current_schema = SYS;
EXPLAIN PLAN
SET STATEMENT_ID = '168361'
FOR
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts#
and t.dflextpct!=0 and t.bitmapped=0 ;
.
.
.

RE: SQL Question

2002-05-31 Thread Kevin Lange


Try this

select a.f1, a.d1, a.d2
from
  (select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
a,
  (select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
b
where a.f1 = b.f1
and a.d1  b.d1
and a.d2  b.d2


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


Hi,

I have a table with 1 field and 2 dates: field1, date1, date2. I need to
find the max value of date2 for all the field1, date1 combinations. Then I
want to join the table to itself on field1 and find all the rows where
field1 matches, date1  date1, and max(date2)  max(date2). I did this in 2
queries. First I created a view as follows:

create view v1 (f1, d1, d2)
as select field1,date1,max(date2) from table1
group by field1,date1;

Then I joined the 2 views together like this:

select a.f1,a.d1,a.d2 from v1 a, v1 b
where a.f1 = b.f1
and a.d1  b.d1
and a.d2  b.d2;

This worked fine, but I was wondering if there was a way to do this in
one query without having to create a view.


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Design question.

Title: RE: Design question.



I 
agree that "Not Good" might characterize this - what it points out is "not good" 
table design. the parent table now will have a row with two unique items - 
the existing primary kay, and a combination of two other 
columns.

I 
would review the tabl3e designand decide if something else needs to be 
done.

Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Whittle Jerome Contr NCI 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, May 31, 2002 
  12:07 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Design question.
  Chris, 
  
  Is there a unique 
  constraint based on the two fields in the parent table? If so it might work 
  OK. Still there are the problems of referential integrity, orphan records, 
  etc. If there isn't a unique constraint in the parent table, you can also add 
  in potential many-to-many relationships as a problem to.
  Basically I'd say 
  this falls into the "Not Good" category. 
  Jerry Whittle ACIFICS DBA NCI Information Systems Inc. 
  [EMAIL PROTECTED] 618-622-4145 
  
-Original 
Message- From: Grabowy, Chris 
[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 10:33 AM To: 
Multiple recipients of list ORACLE-L 
Subject: Design question. 
We have a designer that is 
adding a FK on two columns from one table to another. These two columns are not 
in the parent table's primary key. 
So we are kind of scratching our 
heads wondering if you can, from a proper design point of view, create such a 
FK? It appears that if you update one of the two columns in the child table 
then you would need to create a new record in the parent table. 
Thoughts??

RE: * Certified Oracle DBAs Needed in the Dallas area..

2002-05-31 Thread Freeman, Robert


8.x has been out for some time. I was using 8.0.4 back in '96 or so... 

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
anyone ever told you that you're bad luck?
Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
mother's dying words. But I guess if your body's covered in third degree
burns, and your foot's caught in a bear trap, you tend to start talkin'
crazy.



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


I like:

REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I


uh-8.x has not been out for 3 years, has it?

Tom Mercadante
Oracle Certified Professional


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


no aliens either the foreigner or outer space kind,

this response follows the same as the HELP command.

I just feel the need.

joe


OraStaff wrote:

Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.

PLEASE Do Not send your resume for this position UNLESS you are fully
certified and 
have the skills outlined below for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes cannot be
considered.
If you are employed by a consulting company you should have a long term
project history.

These are full time staff positions so no sub-contractors or third parties
please.

No H-1B candidates please.

Position #1- Oracle OCP DBA
Salary: 75-90K/yr
Start Date: immediately
 
Position # 2- Oracle OCP DBA Consultant..permanent position
Salary: 75-90K/yr
Start Date: immediately
* This position will be up to 100% travel (limited to TX, OK, LA, and
Arkansas
only). All expenses will be reimbursable.
 
The overview of qualifications for both of the above listed OCP's are as
follows:
 
REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I
 
DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,
Windows NT/2000, Unix, HP
 
JOB DESCRIPTION: This technical consultant position will be required to
support many clients, with a broad range of disciplines. Must be a
self-starter, excellent communication skills along with a strong technical
expertise. This position requires strong consulting skills (i.e. some
project management, technical leadership, background with multiple
methodologies), complete development life cycle experience as well as a
proven expert level in the following Oracle disciplines:
 
Database Administration, Performance Tuning, Backup/Recovery Strategies,
Installation/Upgrades, PL/SQL development (stored procedures, packages,
database triggers, etc..), Oracle Networking (SQL*Net, Net8)

For  immediate consideration, please send your resume as a Word attachment
to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the
position interested in)
ph: 1-800 -549-8502

All Submissions are handled in confidence.

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


 
 



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

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

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

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

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego,

Re: MySQL versus Oracle

2002-05-31 Thread Alex


This depends on what the interview is for. MySQL, Oracle, Access,
PostgresSQL, and SQLServer are all databases and can be accessed with SQL. 
Other than that, they are all completely different. 

On Fri, 31 May 2002, Joe Testa wrote:

 Anyone on the list done a comparison(or worked with both) MySQL and 
 Oracle and can give me the good/bad points of My SQL?
 
 Doing interviewer thing and someone has My SQL who would like to move 
 into the oracle world and i know nothing about mySQL and am wondering if 
 the transition from one to the other is easily done.
 
 thanks, joe
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

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

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

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

Functions

2002-05-31 Thread Sherrie . Kubis


Hello all.  I am seeking opinions of experienced database folks on this
issue:

I am implementing a replication environment between IBM DB2 and UNIX Oracle
using DataMirror's Transformation Server (TS) product.   TS replicates and
transforms data between disparate databases.  (Right now I am using
Oracle's
snapshot with Transparent Gateway to do this, but must do a total refresh
each
night.  Using TS gives me net change.)   One requirement for a simple
transformation
of data is to convert the columns LATITUDE NUMBER(8,2) into LATDEG NUMBER,
LATMIN NUMBER and LATSEC NUMBER.  At the onset of this product I planned to
us TS to perform the translation.  I have this working just fine.

Our DB2 and Oracle groups are 'culturally' different in their thinking.
The DB2 DBA
is pushing to create a DB2 user-defined function that accepts the LATITUDE
value
and returns the three LATDEG LATMIN and LATSEC values, rather than use TS.
At
this point it is unclear to me on the reasoning for this.  However, my
reasons for wanting
to do this function within my tool are:
 1) Easier administration.  By keeping all replication processes within
one
 area, it is easier to support.
 2) The DEG, MIN and SEC columns are ultimately used on the
Oracle side.
   Seems unnecessary to put more into the DB2 side when
we're moving
   to the direction of Oracle.

I'd like to say performance is a reason, but I'm not sure this is a valid
reason.  Seems that
using a DB2 function or TS derived expression in terms of performance will
be comparable.

Do you have any insights or thoughts to share that may help me in this
decision?
My appreciation in advance.


---
Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville FL 34604-6899

Phone:  (352) 796-7211, Ext. 4033
Fax: (352) 754-6776
Email:  Mailto:[EMAIL PROTECTED]



-- 
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: MySQL versus Oracle

2002-05-31 Thread Gogala, Mladen


I read few articles in Linux magazine and had it installed on
my box for a while and here are my impressions:

a) It's blindingly fast as a single user database, faster then oracle.
b) It uses more or less standard SQL minus all the unnecessary functions 
   like substr, decode, nvl and alike which nobody ever uses anyway (evil
grin).
c) It's small. You can have both software and a small database within 150M
d) I didn't learn how to do recovery. It doesn't have hot backups. You have
to
   shut it down to make a sensible backup.
e) It's easy to configure and doesn't have too many things to set up.

Allegedly, the present version (I did my dirty work back in August 2001) can
use
Perl as a scripting language, I don't know whether DBI/DBD is needed for
that and
it can cope with committs and rollbacks. 


 -Original Message-
 From: Joe Testa [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 31, 2002 10:39 AM
 To: Multiple recipients of list ORACLE-L
 Subject: MySQL versus Oracle
 
 
 Anyone on the list done a comparison(or worked with both) MySQL and 
 Oracle and can give me the good/bad points of My SQL?
 
 Doing interviewer thing and someone has My SQL who would like to move 
 into the oracle world and i know nothing about mySQL and am 
 wondering if 
 the transition from one to the other is easily done.
 
 thanks, joe
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  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 Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

2002-05-31 Thread Eric D. Pierce



  | Joan Miro, Man and Woman in Front of a Pile of Excrement 
  | (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8, 
  | Joan Miro Foundation, Barcelona  

http://www.complit.fju.edu.tw/project/project3/miro3-a.htm

( http://www.supersphere.com/Zinetropa/Article.html?ID=Angry_ThoreauanNAME=miro )

---

On 31 May 2002 at 7:33, Whittle Jerome Contr NCI wrote:

 I have a stable work history! As a teenager I worked at a race track cleaning out 
stables. Some 
 of those skills and the working environment translated well into being a DBA.

...

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

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

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

RE: partition tables

2002-05-31 Thread Cherie_Machler



Jack,

Thanks for these great hints.   I have not seen lots of these before and
they have given me lots of ideas.

Here's a question that you've induced:   How do you determine what a good
value is for INITRANS?
What are the downsides of setting it too high?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Jack Silvey
  
jack_silvey@y   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
ahoo.comcc:   
  
Sent by: Subject: RE: partition tables 
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
05/31/02 10:08 
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Big (or should we just call you P?),

I have become somewhat experienced at manipulating
large partition tables since I have had to do it so
often (can you say poor initial design?). Export /
import is not the fastest way to go.

Here are some tips from the trenches:

1) You mention that each partition should have only
100,000 rows, but it might be beneficial for you to
focus more on the partition key. If you choose the
right partition key, queries will be able to do
partition pruning, where they can look at the data
dictionary and see that they only want to look at
certain partitions and not others. This is the big win
for partitioned tables - remove as much data from the
initial lookup as possible by skipping partitions.

2) Investigate create table as select with the
nologging option, in combination with the partition
exchange option. Let's assume that you want a
partition table with 10 partitions. You can create an
empty partition table with 10 partitions, CTAS 10 new
tables from your original table, and exchange the
partitions. After this, you will have a partitition
table full of data. Ain't it cool.

3) If you are sure of your data integrity, use the
without validation clause of the partition exchange.
Otherwise, Oracle will look at each and every row in
each and every partition when it is swapped in -
really slows things down.

4) Another way of creating a partition table from a
standalone is to create the empty partition table and
do a insert /*+ nologging append parallel(a,12) */
into tablea a select /*+ parallel (b,12) /* from
tableb b; and this will spawn off 12 parallel
processes for the select, 12 parallel processes for
the insert, use almost no rollback (appends the data)
and use almost no logging. This screams like a
banshee, very fast. Remember, *each* pq process will
write to its own extent, size your extents
accordingly.

5) Create bitmap partitioned indexes on your low
cardinality join columns (look at number of distinct
values / number of rows) - make sure and set your
sort_area_size wayy high (and set your
sort_area_retained_size to the same value - bug in
oracle with the two not being equal throwing a -600
error) but remember - *each* pq process gets its own
sort_area_size - don't run the box out of ram.

6) Don't create the indexes before you load - this
will fragment them and slow down your insert.

7) Remember to set your parallelism on your table back
to a reasonable level if you CTAS with pq - otherwise,
a high parallelism level on the table will tend to
make Oracle favor full table scans and hash or sort
joins over nested loops and index lookups. Same goes
with indexes - more PQ favors full index scans.

8) You can analyze all your partitions separate from
each other, and in tandem if you wish.

9) alter your index partitions unusable before you
load and then rebuild those partitions with the
compute statistics clause - this is faster and
optimizes your indexes.

Re: Design question.



FK can be on unique columns, not just PK columns and you would not
be allowed to add a row in the child table with a value not in the
parent table unless the child row had a null in it


--- Grabowy, Chris [EMAIL PROTECTED] wrote:
 We have a designer that is adding a FK on two columns from one table
 to
 another.  These two columns are not in the parent table's primary
 key.
 
 So we are kind of scratching our heads wondering if you can, from a
 proper
 design point of view, create such a FK?  It appears that if you
 update one
 of the two columns in the child table then you would need to create a
 new
 record in the parent table.  
 
 Thoughts??
 -- 
 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: rebuilding indexes


storage parameter difference?  are you moving from one tablespace to
another without specifying parameters?

pctfree/pctused influence?


--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
 Under what conditions would an 'alter index .. rebuild' 
 actually case the size of the index to increase 
 by about 12 percent?
 
 
 
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user friendly.  
 It's just particular about who it makes friends with.
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Any Equivalent of SAR command in NT/2000

2002-05-31 Thread Gogala, Mladen


Well, I was a VAX/VMS system administrator, and we were 
a spoiled lot who was used to things like the source code
(on microfish, can you believe it?) and very good internal books.
I once knew precisely at what IPL a page fault  occurs (IPL 2), 
at which IPL is the clock running (IPL_SYNCH=8) and alike.
I was used to the entrails of VAX/VMS. When I switched to
Unix, I kept the same mentality.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 30, 2002 6:53 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Any Equivalent of SAR command in NT/2000
 
 
 I should have known you were a 'Magic Garden Explained' man.
 
 Wish I had all of mine read.
 
 Jared
 
 
 
 
 
 Mladen Gogala [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 05/29/2002 06:48 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: Any Equivalent of SAR command in NT/2000
 
 
 
 On 2002.05.29 09:08 Michael P Sale wrote:
  There is no direct equivalent of sar on windows via the 
 command line,
  but there is a utility called perfmon that can log much more detail
  regarding CPU than sar can.
 How about paging, swapping, disk I/O, and buffer cache hit rate?
 IS there any good book explaining the internals of NT (Win 2k) in
 the fashion similar to the one MAgic Garden Explained or Design
 and Implementation od 4.4 BSD or Maurice Bach's System V? I'm very
 reluctant to use the system which doesn't publish it's internal 
 structure.
 THat is precisely why I'm using Linux at home.
 -- 
 Mladen Gogala
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mladen Gogala
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  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 Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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


since '98 I've changed jobs about once a year. Of course from '78 to
'98 I worked at the same company... wonder which of those they'd look
at to determine if I had a stable work history


--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
 I have a stable work history! As a teenager I worked at a race track
 cleaning out stables. Some of those skills and the working
 environment translated well into being a DBA.
 
 Jerry Whittle
 ACIFICS DBA
 NCI Information Systems Inc.
 [EMAIL PROTECTED]
 618-622-4145
 
  OraStaff wrote:
  
  Great Company located in Greater Dallas, Texas area (Richardson)
 needs 2
  CERTIFIED (OCP)
  Oracle DBAs for full time staff positions.
  
  PLEASE Do Not send your resume for this position UNLESS you are
 fully
  certified and 
  have the skills outlined below for this position.
  
  Please Do Not send your resume unless you have a stable work
 history.
  Candidates whose work history includes frequent job changes cannot
 be
  considered.
  If you are employed by a consulting company you should have a long
 term
  project history.
  
  These are full time staff positions so no sub-contractors or third
 parties
  please.
  
  No H-1B candidates please.
  
  Position #1- Oracle OCP DBA
  Salary: 75-90K/yr
  Start Date: immediately
   
  Position # 2- Oracle OCP DBA Consultant..permanent position
  Salary: 75-90K/yr
  Start Date: immediately
  * This position will be up to 100% travel (limited to TX, OK, LA,
 and Arkansas
  only). All expenses will be reimbursable.
   
  The overview of qualifications for both of the above listed OCP's
 are as
  follows:
   
  REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience,
 Oracle
  Database 8.x, 8I
   
  DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java,
 C++,
  Windows NT/2000, Unix, HP
   
  JOB DESCRIPTION: This technical consultant position will be
 required to
  support many clients, with a broad range of disciplines. Must be a
  self-starter, excellent communication skills along with a strong
 technical
  expertise. This position requires strong consulting skills (i.e.
 some
  project management, technical leadership, background with multiple
  methodologies), complete development life cycle experience as well
 as a
  proven expert level in the following Oracle disciplines:
   
  Database Administration, Performance Tuning, Backup/Recovery
 Strategies,
  Installation/Upgrades, PL/SQL development (stored procedures,
 packages,
  database triggers, etc..), Oracle Networking (SQL*Net, Net8)
  
  For  immediate consideration, please send your resume as a Word
 attachment to:
  OraStaff, Inc.
  Email: [EMAIL PROTECTED]
  Please use job code: One/Dallas/OCP DBA/B. Law (along with the #
 of the
  position interested in)
  ph: 1-800 -549-8502
  
  All Submissions are handled in confidence.
  
  *We pay referral fees.
  So please contact me if you know of anyone who would be
 qualified/interested
  in the posiition described above- if it is not a match for your
 skills.
  Thanks,
  Bill Law
  
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: * Certified Oracle DBAs Needed in the Dallas area..

2002-05-31 Thread JoJo Al-Zawawi


It's pretty funny what some people have bookmarked!

:D  JoJo


-Original Message-

  | Joan Miro, Man and Woman in Front of a Pile of Excrement 
  | (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8, 
  | Joan Miro Foundation, Barcelona  

http://www.complit.fju.edu.tw/project/project3/miro3-a.htm

(
http://www.supersphere.com/Zinetropa/Article.html?ID=Angry_ThoreauanNAME=mi
ro )

---

On 31 May 2002 at 7:33, Whittle Jerome Contr NCI wrote:

 I have a stable work history! As a teenager I worked at a race track
cleaning out stables. Some 
 of those skills and the working environment translated well into being a
DBA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: [EMAIL PROTECTED]

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

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

2002-05-31 Thread Pat Howe


Bill : 
I have currently been wrestling with the same issues as you are : How best
to configure RMAN.
I have put together an 'RMAN Configuration Doc' with 'PROs and CONs' from
information that I have scrapped together from this list, papers and books.
Like anything in Oracle - no one configuration is right for all situations -
you have to look at your system needs and choose the best approach.
Hopefully this paper will help you in arriving at the right configuration
for your company.

Denise : 
I have incorporated your thoughts into a document I have been assembling on
RMAN configuration.
I originally was leaning towards going with OPTION1 just for the KISS law
(keep it simple stupid) - but a lot of what you said made sense and the PROs
list is growing for OPTION2.
Since I am still just playing around with the product I have the option of
going with what ever path I see fit.

All :
If anyone has anything to add - I would be glad to hear from you - this is a
work in progress.

Thanks


RMAN CATALOG CONFIGURATION OPTIONS
From a RMAN catalog perspective we have many configuration options ;


Configuration OPTION 1 
Create one RMAN database with one RMAN catalog for all the databases that
you are backing up.
IE; If you had two databases PROD and DEV then create one RMAN database
with one RMAN Catalog in one RMAN tablespace to manage all database recovery
info.  

PROS
- Simple to setup and to Simple to understand

CONS
- When using SQL to query the RMAN catalog views you will have to isolate
the database (join db key).
- You will need to manually backup (script-backup) the RMAN database.



Configuration OPTION 2
Create one RMAN database with one RMAN catalog per database that you are
backing up.  
IE: If you had two databases PROD and DEV then setup one RMAN database
with an RMAN-PROD catalog and an RMAN-DEV catalog in the same RMAN
tablespace to manage each database's recovery info.  

PROS
- When using SQL to query the RMAN catalog views you do not have to isolate
the database (join dbkey) because in this configuration each RMAN schema
(catalog) will only contain one database.
- Along the same lines as the above point ; If you have perform RMAN Catalog
maintenance (clean out some records), it would be easier to focus on an RMAN
catalog that contains one database rather then multiple database.
- Easier to maintain the RMAN catalog if you are dropping a database - Just
drop the RMAN schema owner.
- This configuration adds a level of security by always matching the TARGET
you are on to the RMAN repository you are signing on to.  ie; If you were on
TARGET PROD then you would have to signon to the RMAN-PROD schema owner.
- If you need to upgrade the target database, you can do that without
affecting the other databases. For example, if the upgrade requires a change
to the RMAN catalog schema, you can just change it for that database without
worrying about it affecting the other databases.
- If the RMAN catalog for one of your databases gets corrupted, you minimize
the damage to a single schema/target database.
- You may decide to relocate the catalog for a database to another instance
and/or host. Separate catalogs give you this flexibility.
- If you like the philosophy of a backup tape(s) containing everything you
need to recreate the system. You can run the backup to disk, export the RMAN
catalog schema and FTP it over to the target system before tape backup
starts, so everything winds up on a single tape. 

CONS
- Multiple RMAN catalogs will consume more physical space (their own set of
tables) on the RMAN   
database.
- You will need to manually backup (script-backup) the RMAN database.
 
  
Configuration OPTION 3
Create an RMAN database for each version of database that you are backing
up.  
IE: If you had to maintain two 8.1.7 databases and three 9.1 databases then
setup a RMAN817 database and a RMAN910 database (same box) to maintain the
two different versions of Oracle databases.  

PROS
- I saw this option posted on a previous discussion thread, but I was unable
to see the advantage to this configuration.  

CONS
- This is not technically necessary.  Lower levels of RMAN work with higher
levels of the RMAN catalog.
- You will need to manually backup (script-backup) the RMAN database.



Configuration OPTION 4
Split up your RMAN catalogs by physical location.  
IE: If you maintained a west coast set of databases and an east cost set of
databases then setup a RMAN-WEST database and an RMAN-EAST database
(different RMAN boxes in two physically different locals).

PROS
- Keeping the catalogs on independent hardware prevents a single point of
failure.  RMAN West can backup RMAN East and visa-versa.

CONS
- Costly (2 boxes).

_ 
 Patrick J. Howe 
 Oracle DBA 
 Illuminet.  A Verisign Company. 
 4501 Intelco Loop SE 
 Olympia, WA 98507 
 Phone : 360.493.6284 
 Email  : [EMAIL PROTECTED]  


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

RE: rebuilding indexes

2002-05-31 Thread Adams, Matthew (GEA, MABG, 088130)

Title: RE: rebuilding indexes






storage parameter difference? None


are you moving from one tablespace to
another without specifying parameters? No


pctfree/pctused influence? none



I should have put this in the original message.


Indexes stayed in original tablespace with identical
storage parameters, but number of extents went from 
20 to 25 (each extents is 65 8-K blocks)

Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly. 
It's just particular about who it makes friends with.


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: rebuilding indexes



storage parameter difference? are you moving from one tablespace to
another without specifying parameters?


pctfree/pctused influence?



--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
 Under what conditions would an 'alter index .. rebuild' 
 actually case the size of the index to increase 
 by about 12 percent?
 
 
 
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user friendly. 
 It's just particular about who it makes friends with.
 



__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]


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

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

Re: rebuilding indexes


Matt,

1) Storage parameter changes? Do you specify storage
at the index or tablespace (or top partition)
level?pctfree go up? initrans go up? bigger INITIAL or
NEXT?

2) did you build it the first time using parallelism
and rebuild using single thread? When a PQ processes
is used to build an object it uses its own extent, and
then *deallocates the extra space* at the end. If you
will notice, when you build using PQ your segments
have wacko sizes, and that is why.

If you rebuilt using a single process, it could be
that you have a full allocation of space, some empty.

3) more data? did you alter unusable, load, and
rebuild?

4) have you changed the minimize_records_per_block
parameter and the index is a bitmap?

5) has your data distribution changed? bitmap indexes
tend to get bigger as your data moves towards high
cardinality.

6) has this index been eating too much sugar again?
sometimes, this can cause an index glucose spike and
tend to make it store more fat in the leaf blocks,
especially around the middle of the index, but
sometimes on the hips too. Perhaps you are not doing
DDL on the table enough, and so the index is not
getting enough exercise.

hth, 

jack silvey

 
 --- Adams, Matthew (GEA, MABG, 088130)
 [EMAIL PROTECTED]
 wrote:
  Under what conditions would an 'alter index ..
 rebuild' 
  actually case the size of the index to increase 
  by about 12 percent?
  
  
  
  
  Matt Adams - GE Appliances -
 [EMAIL PROTECTED]
  Contrary to popular opinion, Unix is user
 friendly.  
  It's just particular about who it makes friends
 with.
  
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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: rebuilding indexes

2002-05-31 Thread Jeffrey Beckstrom




But when you rebuild, it will reestablish the pctfree in all of the index 
blocks. If you had a lot of activity this free space would have been used 
in the original index and is now reclaimed.

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204 [EMAIL PROTECTED] 5/31/02 1:11:54 PM 

storage parameter difference? None 
are you moving from one tablespace to another without specifying parameters? No 
pctfree/pctused influence? none 
I should have put this in the original message. 
Indexes stayed in original tablespace with identical 
storage parameters, but number of extents went from 
20 to 25 (each extents is 65 8-K blocks) 
 Matt Adams - GE Appliances - 
[EMAIL PROTECTED] Contrary to popular opinion, Unix 
is user friendly. It's just particular about who 
it makes friends with. 
-Original Message- From: Rachel 
Carmichael [mailto:[EMAIL PROTECTED]] 
Sent: Friday, May 31, 2002 12:49 PM To: 
Multiple recipients of list ORACLE-L Subject: Re: 
rebuilding indexes 
storage parameter difference? are you moving from one 
tablespace to another without specifying 
parameters? 
pctfree/pctused influence? 
--- "Adams, Matthew (GEA, MABG, 088130)" 
[EMAIL PROTECTED] wrote:  Under what conditions would an 'alter index .. rebuild' 
 actually case the size of the index to increase 
 by about 12 percent?  
     Matt Adams - GE Appliances - 
[EMAIL PROTECTED]  Contrary to popular opinion, 
Unix is user friendly.  It's just particular 
about who it makes friends with.  
__ 
Do You Yahoo!? Yahoo! - Official 
partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: Rachel Carmichael  INET: [EMAIL PROTECTED] 
Fat City Network Services -- (858) 
538-5051 FAX: (858) 538-5051 San Diego, 
California -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from). You may also send 
the HELP command for other information (like subscribing).

UPGRADE

2002-05-31 Thread Hamid Alavi


Hi List,
I have decided to Upgrade the database from 8.1.7.0 to 8.1.7.4 this
afternoon on sun solaris.
Please give me any advise before I go for upgrade.

Thanks allot and have a good weekend



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

RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-31 Thread Fink, Dan


I agree, the Jr. DBA must focus on learning.
Mid DBA...is still learning. Many Mid still view tuning/troubleshooting as
an art (with a little magic thrown in)
Sr. DBA...is still learning. Realizes that database management is a science,
requiring research, expirementation and a very healthy dose of skepticism.

The best Sr. DBAs that I know are the first ones to say 'I don't know'. That
is the only true path to learning. No one can know everything. Often times
the Jr. DBA will be a great source of knowledge since they don't know what
NOT to ask.

Reaction to reading Books/Documentation
Junior - I did not know that
Mid - I know that
Senior - Perhaps...let's prove it

When a developer/user asks for a change to the database
Junior - I'll look it up and change it
Mid - I have a script to do that, I'll let you know when I am done
Senior - Why are you needing this change? Did you realize that x will cause
y? Let's figure out the best way to accomplish the result.

When faced with an undocumented condition/unknown error
Junior - Log a TAR, get frustrated with 'We need a trace file. We need more
information. We have no clue...'. Calls more senior help.
Mid - Remembers a passage in a book, tries out the command. Fixes the
symptom.
Senior - Knows that x can cause y, if z is present. Tracks condition from
symptom through to actual problem.

Attends sessions at IOUG
Junior - Assumes that all speakers know exactly what they are talking about
and all vendor tools work as advertised.
Mid - Listens to and believes Tim, Cary, Craig, Rich, Rachel, Gaja and all
other High Holy Oracle Gurus preach
Senior - Listens to, questions and tests (on non production systems) what
Tim, Cary, Craig, Rich, Rachel, Gaja and all other High Holy Oracle Gurus
preach

Knowledge level
Junior - Has no clue what they know and don't know
Mid - Knows what they know
Senior - Knows what they don't know

Every Senior DBA is a mix of Jr. and Mid. They may know a great deal about
one subsystem of Oracle, but lack knowledge in another area.


Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


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


Junior DBA's job is a learning.
Mid DBA's job is a science.
Sr. DBA's job is the Art.

Srs feel database, users, developers and everything else.
They feel what, where, how, when and why should by done.
Their intuition is of high degree.
... and everybody is sure - the Sr DBA knows everything. (so one of the
priority of Sr DBA is to make this impression)

--
Alexandre

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

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

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

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

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

Re: Design question.

2002-05-31 Thread Jared . Still


Well then, that's not an FK.

That's just two columns that the 'duhsigner' is copying to some
other table, presenting a nice little update anomaly.

You can soon expect different programs to return different answers
from the database, depending on which table the data is
queried from.

Jared





Grabowy, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/31/2002 08:33 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Design question.


We have a designer that is adding a FK on two columns from one table to
another.  These two columns are not in the parent table's primary key.

So we are kind of scratching our heads wondering if you can, from a proper
design point of view, create such a FK?  It appears that if you update one
of the two columns in the child table then you would need to create a new
record in the parent table. 

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



-- 
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: MySQL versus Oracle

2002-05-31 Thread Jared . Still


Joe,

If the interviewee's experience is all MySql, then he/she will not know 
about:

* stored procedures
* foreign keys
* triggers ( I think )
* probably never heard of an ERD
* no check constraints


That's about the extent of my MySql knowledge.  Depends a lot on the 
indivual,
whether or not you think the interviewee is a self starter, knows how to 
read, etc.

Jared





Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/31/2002 07:38 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:MySQL versus Oracle


Anyone on the list done a comparison(or worked with both) MySQL and 
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move 
into the oracle world and i know nothing about mySQL and am wondering if 
the transition from one to the other is easily done.

thanks, joe


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

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

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


Attends sessions at IOUG
Junior - Assumes that all speakers know exactly what they are talking 
about and all vendor tools work as advertised.
Mid - Listens to and believes Tim, Cary, Craig, Rich, Rachel, Gaja and

all other High Holy Oracle Gurus preach
Senior - Listens to, questions and tests (on non production systems) 
what Tim, Cary, Craig, Rich, Rachel, Gaja and all other High Holy
Oracle 
Gurus preach


I appreciate the compliment but I'm NOT in their league! I guess I'm
Senior -- I know what I don't know!




--- Fink, Dan [EMAIL PROTECTED] wrote:
 I agree, the Jr. DBA must focus on learning.
 Mid DBA...is still learning. Many Mid still view
 tuning/troubleshooting as
 an art (with a little magic thrown in)
 Sr. DBA...is still learning. Realizes that database management is a
 science,
 requiring research, expirementation and a very healthy dose of
 skepticism.
 
 The best Sr. DBAs that I know are the first ones to say 'I don't
 know'. That
 is the only true path to learning. No one can know everything. Often
 times
 the Jr. DBA will be a great source of knowledge since they don't know
 what
 NOT to ask.
 
 Reaction to reading Books/Documentation
 Junior - I did not know that
 Mid - I know that
 Senior - Perhaps...let's prove it
 
 When a developer/user asks for a change to the database
 Junior - I'll look it up and change it
 Mid - I have a script to do that, I'll let you know when I am done
 Senior - Why are you needing this change? Did you realize that x will
 cause
 y? Let's figure out the best way to accomplish the result.
 
 When faced with an undocumented condition/unknown error
 Junior - Log a TAR, get frustrated with 'We need a trace file. We
 need more
 information. We have no clue...'. Calls more senior help.
 Mid - Remembers a passage in a book, tries out the command. Fixes the
 symptom.
 Senior - Knows that x can cause y, if z is present. Tracks condition
 from
 symptom through to actual problem.
 
 Attends sessions at IOUG
 Junior - Assumes that all speakers know exactly what they are talking
 about
 and all vendor tools work as advertised.
 Mid - Listens to and believes Tim, Cary, Craig, Rich, Rachel, Gaja
 and all
 other High Holy Oracle Gurus preach
 Senior - Listens to, questions and tests (on non production systems)
 what
 Tim, Cary, Craig, Rich, Rachel, Gaja and all other High Holy Oracle
 Gurus
 preach
 
 Knowledge level
 Junior - Has no clue what they know and don't know
 Mid - Knows what they know
 Senior - Knows what they don't know
 
 Every Senior DBA is a mix of Jr. and Mid. They may know a great deal
 about
 one subsystem of Oracle, but lack knowledge in another area.
 
 
 Daniel W. Fink
 Sr. Oracle DBA
 MICROMEDEX
 303.486.6456
 
 
 -Original Message-
 Sent: Friday, May 31, 2002 2:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Junior DBA's job is a learning.
 Mid DBA's job is a science.
 Sr. DBA's job is the Art.
 
 Srs feel database, users, developers and everything else.
 They feel what, where, how, when and why should by done.
 Their intuition is of high degree.
 ... and everybody is sure - the Sr DBA knows everything. (so one of
 the
 priority of Sr DBA is to make this impression)
 
 --
 Alexandre
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Alexandre Gorbatchev
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 i
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Fink, Dan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: UPGRADE


don't do it this afternoon... read the release notes, check for any
known bugs on Metalink and PLAN what you are going to do, including
backout of the upgrade if necessary.

upgrades are not not something you do on the spur of the moment.

of course if you decide to do this anyway and it breaks, please don't
send URGENT NEED HELP messages to the list. 


--- Hamid Alavi [EMAIL PROTECTED] wrote:
 Hi List,
 I have decided to Upgrade the database from 8.1.7.0 to 8.1.7.4 this
 afternoon on sun solaris.
 Please give me any advise before I go for upgrade.
 
 Thanks allot and have a good weekend
 
 
 
 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: rebuilding indexes


I'm sure it's #6 :)


--- Jack Silvey [EMAIL PROTECTED] wrote:
 Matt,
 
 1) Storage parameter changes? Do you specify storage
 at the index or tablespace (or top partition)
 level?pctfree go up? initrans go up? bigger INITIAL or
 NEXT?
 
 2) did you build it the first time using parallelism
 and rebuild using single thread? When a PQ processes
 is used to build an object it uses its own extent, and
 then *deallocates the extra space* at the end. If you
 will notice, when you build using PQ your segments
 have wacko sizes, and that is why.
 
 If you rebuilt using a single process, it could be
 that you have a full allocation of space, some empty.
 
 3) more data? did you alter unusable, load, and
 rebuild?
 
 4) have you changed the minimize_records_per_block
 parameter and the index is a bitmap?
 
 5) has your data distribution changed? bitmap indexes
 tend to get bigger as your data moves towards high
 cardinality.
 
 6) has this index been eating too much sugar again?
 sometimes, this can cause an index glucose spike and
 tend to make it store more fat in the leaf blocks,
 especially around the middle of the index, but
 sometimes on the hips too. Perhaps you are not doing
 DDL on the table enough, and so the index is not
 getting enough exercise.
 
 hth, 
 
 jack silvey
 
  
  --- Adams, Matthew (GEA, MABG, 088130)
  [EMAIL PROTECTED]
  wrote:
   Under what conditions would an 'alter index ..
  rebuild' 
   actually case the size of the index to increase 
   by about 12 percent?
   
   
   
   
   Matt Adams - GE Appliances -
  [EMAIL PROTECTED]
   Contrary to popular opinion, Unix is user
  friendly.  
   It's just particular about who it makes friends
  with.
   
  
  
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.yahoo.com
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Jr.DBA, Mid level DBA, Sr.DBA


The jr thinks that she knows.
The mid knows that she knows.
The sr knows that she knows not.

Awareness of ignorance is the mark of true knowledge.

I like cake.

jack silvey


--- Fink, Dan [EMAIL PROTECTED] wrote:
 I agree, the Jr. DBA must focus on learning.
 Mid DBA...is still learning. Many Mid still view
 tuning/troubleshooting as
 an art (with a little magic thrown in)
 Sr. DBA...is still learning. Realizes that database
 management is a science,
 requiring research, expirementation and a very
 healthy dose of skepticism.
 
 The best Sr. DBAs that I know are the first ones to
 say 'I don't know'. That
 is the only true path to learning. No one can know
 everything. Often times
 the Jr. DBA will be a great source of knowledge
 since they don't know what
 NOT to ask.
 
 Reaction to reading Books/Documentation
 Junior - I did not know that
 Mid - I know that
 Senior - Perhaps...let's prove it
 
 When a developer/user asks for a change to the
 database
 Junior - I'll look it up and change it
 Mid - I have a script to do that, I'll let you know
 when I am done
 Senior - Why are you needing this change? Did you
 realize that x will cause
 y? Let's figure out the best way to accomplish the
 result.
 
 When faced with an undocumented condition/unknown
 error
 Junior - Log a TAR, get frustrated with 'We need a
 trace file. We need more
 information. We have no clue...'. Calls more
 senior help.
 Mid - Remembers a passage in a book, tries out the
 command. Fixes the
 symptom.
 Senior - Knows that x can cause y, if z is present.
 Tracks condition from
 symptom through to actual problem.
 
 Attends sessions at IOUG
 Junior - Assumes that all speakers know exactly what
 they are talking about
 and all vendor tools work as advertised.
 Mid - Listens to and believes Tim, Cary, Craig,
 Rich, Rachel, Gaja and all
 other High Holy Oracle Gurus preach
 Senior - Listens to, questions and tests (on non
 production systems) what
 Tim, Cary, Craig, Rich, Rachel, Gaja and all other
 High Holy Oracle Gurus
 preach
 
 Knowledge level
 Junior - Has no clue what they know and don't know
 Mid - Knows what they know
 Senior - Knows what they don't know
 
 Every Senior DBA is a mix of Jr. and Mid. They may
 know a great deal about
 one subsystem of Oracle, but lack knowledge in
 another area.
 
 
 Daniel W. Fink
 Sr. Oracle DBA
 MICROMEDEX
 303.486.6456
 
 
 -Original Message-
 Sent: Friday, May 31, 2002 2:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Junior DBA's job is a learning.
 Mid DBA's job is a science.
 Sr. DBA's job is the Art.
 
 Srs feel database, users, developers and everything
 else.
 They feel what, where, how, when and why should by
 done.
 Their intuition is of high degree.
 ... and everybody is sure - the Sr DBA knows
 everything. (so one of the
 priority of Sr DBA is to make this impression)
 
 --
 Alexandre
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Alexandre Gorbatchev
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

RE: rman duplicate dbid? AND rman catalog config options

2002-05-31 Thread DENNIS WILLIAMS


Pat - I think you've pretty well covered the pros/cons from what I
understand. I haven't implemented in production, so hopefully some people
with some experience of living with RMAN will respond. How about it guys?
One point bothered me. You didn't explicitly say that you were
keeping your RMAN catalog on a system separate from the production system it
is backing up. The nightmare situation is where you have only one system and
you store the RMAN tablespace on the same disk as some production tables.
Then the disk goes bad and you can't use RMAN to recover the tables. That is
the sort of thing that has you waking up in the middle of the night in a
cold sweat.
You were probably considering this, but I just thought I should
bring it out explicitly.
We have gone back and forth on this issue. At first, I was going to
use our test system so I could use RMAN to back up all production systems.
The system administrator didn't like that idea. He preferred a valuable
production resource to reside on a production system. I have put the RMAN
catalog on a production system we don't plan to use RMAN to back up.
I have heard some people cross-mount their RMAN catalogs. Say you
have two production systems, A and B. Put the RMAN catalog for A on system
B, and the RMAN catalog for B on system A.

Oh yeah, I don't mind you mis-spelling my name, but let's just keep the
gender consistent. It's Dennis, not Denise. 

And have a good weekend.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Bill : 
I have currently been wrestling with the same issues as you are : How best
to configure RMAN.
I have put together an 'RMAN Configuration Doc' with 'PROs and CONs' from
information that I have scrapped together from this list, papers and books.
Like anything in Oracle - no one configuration is right for all situations -
you have to look at your system needs and choose the best approach.
Hopefully this paper will help you in arriving at the right configuration
for your company.

Denise : 
I have incorporated your thoughts into a document I have been assembling on
RMAN configuration.
I originally was leaning towards going with OPTION1 just for the KISS law
(keep it simple stupid) - but a lot of what you said made sense and the PROs
list is growing for OPTION2.
Since I am still just playing around with the product I have the option of
going with what ever path I see fit.

All :
If anyone has anything to add - I would be glad to hear from you - this is a
work in progress.

Thanks


RMAN CATALOG CONFIGURATION OPTIONS
From a RMAN catalog perspective we have many configuration options ;


Configuration OPTION 1 
Create one RMAN database with one RMAN catalog for all the databases that
you are backing up.
IE; If you had two databases PROD and DEV then create one RMAN database
with one RMAN Catalog in one RMAN tablespace to manage all database recovery
info.  

PROS
- Simple to setup and to Simple to understand

CONS
- When using SQL to query the RMAN catalog views you will have to isolate
the database (join db key).
- You will need to manually backup (script-backup) the RMAN database.



Configuration OPTION 2
Create one RMAN database with one RMAN catalog per database that you are
backing up.  
IE: If you had two databases PROD and DEV then setup one RMAN database
with an RMAN-PROD catalog and an RMAN-DEV catalog in the same RMAN
tablespace to manage each database's recovery info.  

PROS
- When using SQL to query the RMAN catalog views you do not have to isolate
the database (join dbkey) because in this configuration each RMAN schema
(catalog) will only contain one database.
- Along the same lines as the above point ; If you have perform RMAN Catalog
maintenance (clean out some records), it would be easier to focus on an RMAN
catalog that contains one database rather then multiple database.
- Easier to maintain the RMAN catalog if you are dropping a database - Just
drop the RMAN schema owner.
- This configuration adds a level of security by always matching the TARGET
you are on to the RMAN repository you are signing on to.  ie; If you were on
TARGET PROD then you would have to signon to the RMAN-PROD schema owner.
- If you need to upgrade the target database, you can do that without
affecting the other databases. For example, if the upgrade requires a change
to the RMAN catalog schema, you can just change it for that database without
worrying about it affecting the other databases.
- If the RMAN catalog for one of your databases gets corrupted, you minimize
the damage to a single schema/target database.
- You may decide to relocate the catalog for a database to another instance
and/or host. Separate catalogs give you this flexibility.
- If you like the philosophy of a backup tape(s) containing everything you
need to recreate the system. You can run the backup to disk, export the RMAN

RE: rebuilding indexes


then the only thing I can think of is that there was heavy activity on
the index prior to the rebuild and the blocks filled and the rebuild
evened it out.


--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
 
 storage parameter difference?  None
 
  are you moving from one tablespace to
 another without specifying parameters?  No
 
 pctfree/pctused influence?  none
 
 
 I should have put this in the original message.
 
 Indexes stayed in original tablespace with identical
 storage parameters, but number of extents went from 
 20 to 25 (each extents is 65 8-K blocks)
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user friendly.  
 It's just particular about who it makes friends with.
 
 -Original Message-
 Sent: Friday, May 31, 2002 12:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 storage parameter difference?  are you moving from one tablespace to
 another without specifying parameters?
 
 pctfree/pctused influence?
 
 
 --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
 wrote:
  Under what conditions would an 'alter index .. rebuild' 
  actually case the size of the index to increase 
  by about 12 percent?
  
  
  
  
  Matt Adams - GE Appliances - [EMAIL PROTECTED]
  Contrary to popular opinion, Unix is user friendly.  
  It's just particular about who it makes friends with.
  
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-31 Thread Freeman, Robert


A few thoughts...

Jr. DBA: Asks the Mid or Sr. DBA where to look.
Mid DBA: Kind of knows where the answer is, but takes a bit to find it.
Sr. DBA: Answer is dog eared in one or more of his office full of books.
Really Sr. DBA: Answer is dog eared in his own book or paper.

Jr. DBA: Feels a lot of fear with every change of the database he has to
make.
Mid DBA: Looks forward to the experience of making the changes.
Sr. DBA: Suggests improvements when reviewing changes, helps implement those
improvements and
 then monitors the Mid. DBA as he/she makes the change.
Really Sr. DBA: Is busy installing the latest version of Oracle on AIX, and
updating the current Oracle
standards manual for the department, when the change is requested. Opens
another window, quickly realizes that the change will end up causing all
sorts of data inconsistencies,
redesigns the entire change while at the same time flipping out CD 3 of 5 of
Oracle9iR2 for AIX, Implements
the redesigned change after the developer reviews and approves. Then flips
in CD 4 of 5.

Jr. DBA: Checks with the Mid-tier DBA before making a change to make sure
it's ok.
Mid DBA: Checks with the Sr. DBA before making a change to make sure it's
ok.
Sr. DBA: Comfortable with making the change in his own right, but for more
complicated changes
or new architectural implementations, checks with the Sr. DBA to make sure
it is ok.
Really Sr. DBA: Talks with anyone who will listen and wonders why he is
considered the grand-pobah
DBA because he really doesn't feel like one.

Jr. DBA: 3 Books on his desk.
Mid DBA: 7 Books on his desk.
Sr. DBA: 10-20 books on his desk.
Really Sr. DBA: You can't find because he is buried under the books on his
desk OR he is writing
his latest book. 

Jr. DBA: 2 weeks vacation, all taken.
Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All made up
by long weekend and holiday changes.
Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three times,
occasional Friday off too. All made up for by long weekend and holiday
changes.
Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of course the
company doesn't accrue vacation time) and all those long weekend and holiday
changes. Pager of cell phone always going off.






Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
anyone ever told you that you're bad luck?
Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
mother's dying words. But I guess if your body's covered in third degree
burns, and your foot's caught in a bear trap, you tend to start talkin'
crazy.


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

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

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

2002-05-31 Thread Jared . Still


Thanks John







John Kanagaraj [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/30/2002 03:28 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Oracle apps 10.7 client on Windows 2000


Jared,

 Does anyone know of any issues using 10.7 apps clients
 on Win2k?

I believe the issue is one of NOT being in a 'Certified' combination, 
rather
than a technical issue. We had no technical problems here in a recent 
test,
but deferred implementation on account of the 'risk' involved with 
stepping
out of the strict line laid down by Apps support. We did step out of line
using Citrix boxes, though, but that was done with the tacit understanding
from Premium Oracle Services. Apps support will drop you like a hot potato
if they know you are using a non-certified platform, but with the relative
stability (!) of 10.7 and the fact that it is going to be desupported 
anyway

...


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

Veritas Quick io

2002-05-31 Thread Kathy Duret



We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps 11.5.6 on 
8.1.7.2 database.

Right now we do not have the temp files converted to quick io and wonder if we should. 
 The guy who installed Quick IO didn't seen to think we could but he was a pretty 
junior person.  

Anybody here have any experience with this?

Kathy

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

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


Lose 20 blocks in 10 days! Load as much as you
normally do and still lose index width.

no segment size restrictions or tiring delete routines
that never seem to finish. easy-to-follow
substr(column,1,1) update routine that guarentees a
maximum of data loss and a minimum of storage!

email to [EMAIL PROTECTED] for
details.




--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 I'm sure it's #6 :)
 
 
 --- Jack Silvey [EMAIL PROTECTED] wrote:
  Matt,
  
  1) Storage parameter changes? Do you specify
 storage
  at the index or tablespace (or top partition)
  level?pctfree go up? initrans go up? bigger
 INITIAL or
  NEXT?
  
  2) did you build it the first time using
 parallelism
  and rebuild using single thread? When a PQ
 processes
  is used to build an object it uses its own extent,
 and
  then *deallocates the extra space* at the end. If
 you
  will notice, when you build using PQ your segments
  have wacko sizes, and that is why.
  
  If you rebuilt using a single process, it could be
  that you have a full allocation of space, some
 empty.
  
  3) more data? did you alter unusable, load, and
  rebuild?
  
  4) have you changed the minimize_records_per_block
  parameter and the index is a bitmap?
  
  5) has your data distribution changed? bitmap
 indexes
  tend to get bigger as your data moves towards high
  cardinality.
  
  6) has this index been eating too much sugar
 again?
  sometimes, this can cause an index glucose spike
 and
  tend to make it store more fat in the leaf blocks,
  especially around the middle of the index, but
  sometimes on the hips too. Perhaps you are not
 doing
  DDL on the table enough, and so the index is not
  getting enough exercise.
  
  hth, 
  
  jack silvey
  
   
   --- Adams, Matthew (GEA, MABG, 088130)
   [EMAIL PROTECTED]
   wrote:
Under what conditions would an 'alter index ..
   rebuild' 
actually case the size of the index to
 increase 
by about 12 percent?




Matt Adams - GE Appliances -
   [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user
   friendly.  
It's just particular about who it makes
 friends
   with.

   
   
  
 __
   Do You Yahoo!?
   Yahoo! - Official partner of 2002 FIFA World Cup
   http://fifaworldcup.yahoo.com
   -- 
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.com
   -- 
   Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
 FAX:
   (858) 538-5051
   San Diego, California-- Public Internet
   access / Mailing Lists
  
 


   To REMOVE yourself from this mailing list, send
 an
   E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
   'ListGuru') and in
   the message BODY, include a line containing:
 UNSUB
   ORACLE-L
   (or the name of mailing list you want to be
 removed
   from).  You may
   also send the HELP command for other information
   (like subscribing).
  
  
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.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).
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

Fat

Re: UPGRADE


I second that emotion. Write your plan down and think
it through. Do some research about what problems you
will encounter. Decide how to backout in the event
that the data dictionary goes poof or all the datafile
headers become inconsistent. Script and test your
upgrade on another system if possible - there are
usually gotchas that don't show up until testing. 

Remember, glory fades quickly but screw-ups are
remembered forever.



--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 don't do it this afternoon... read the release
 notes, check for any
 known bugs on Metalink and PLAN what you are going
 to do, including
 backout of the upgrade if necessary.
 
 upgrades are not not something you do on the spur of
 the moment.
 
 of course if you decide to do this anyway and it
 breaks, please don't
 send URGENT NEED HELP messages to the list. 
 
 
 --- Hamid Alavi [EMAIL PROTECTED] wrote:
  Hi List,
  I have decided to Upgrade the database from
 8.1.7.0 to 8.1.7.4 this
  afternoon on sun solaris.
  Please give me any advise before I go for upgrade.
  
  Thanks allot and have a good weekend
  
  
  
  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).
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.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: MySQL versus Oracle

2002-05-31 Thread Tim Bunce


On Fri, May 31, 2002 at 08:40:51AM -0800, Gogala, Mladen wrote:
 I read few articles in Linux magazine and had it installed on
 my box for a while and here are my impressions:
 
 a) It's blindingly fast as a single user database, faster then oracle.
 b) It uses more or less standard SQL minus all the unnecessary functions 
like substr, decode, nvl and alike which nobody ever uses anyway (evil grin).

It has all those (some under different names) and more.

 c) It's small. You can have both software and a small database within 150M
 d) I didn't learn how to do recovery. It doesn't have hot backups. You have to
shut it down to make a sensible backup.

There's a mysqlhotcopy script (I wrote myself) and there's now a BACKUP command in SQL.

 e) It's easy to configure and doesn't have too many things to set up.
 
 Allegedly, the present version (I did my dirty work back in August 2001) can
 use Perl as a scripting language, I don't know whether DBI/DBD is needed for
 that and it can cope with committs and rollbacks. 

There is a Perl DBI driver for MySQL and yes, it supports transactions
(MySQL supports multiple table types, some of which support transactions).

MySQL is a fast moving target. August 2001 is a long time ago in it's history.

For example, the InnoDB table type now supports foreign keys.

Tim.

 
  -Original Message-
  From: Joe Testa [mailto:[EMAIL PROTECTED]]
  Sent: Friday, May 31, 2002 10:39 AM
  To: Multiple recipients of list ORACLE-L
  Subject: MySQL versus Oracle
  
  
  Anyone on the list done a comparison(or worked with both) MySQL and 
  Oracle and can give me the good/bad points of My SQL?
  
  Doing interviewer thing and someone has My SQL who would like to move 
  into the oracle world and i know nothing about mySQL and am 
  wondering if 
  the transition from one to the other is easily done.
  
  thanks, joe
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Joe Testa
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  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 Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim 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).

RE: Veritas Quick io

2002-05-31 Thread Mohammed . Ahsanuddin


Hi,

The following link has the procedure to convert temp files to qio files..

http://support.veritas.com/docs/233722

We have converted our temp files to qio files and I think from performance
point of they should be converted to qio.

Mohammed Ahsanuddin
Oracle DBA


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



We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps
11.5.6 on 8.1.7.2 database.

Right now we do not have the temp files converted to quick io and wonder if
we should.  The guy who installed Quick IO didn't seen to think we could but
he was a pretty junior person.  

Anybody here have any experience with this?

Kathy

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

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


AIX? Come on all really senior DBAs work on SUN

(ducking and running broken field pattern :)  )



--- Freeman, Robert  [EMAIL PROTECTED] wrote:
 A few thoughts...
 
 Jr. DBA: Asks the Mid or Sr. DBA where to look.
 Mid DBA: Kind of knows where the answer is, but takes a bit to find
 it.
 Sr. DBA: Answer is dog eared in one or more of his office full of
 books.
 Really Sr. DBA: Answer is dog eared in his own book or paper.
 
 Jr. DBA: Feels a lot of fear with every change of the database he has
 to
 make.
 Mid DBA: Looks forward to the experience of making the changes.
 Sr. DBA: Suggests improvements when reviewing changes, helps
 implement those
 improvements and
  then monitors the Mid. DBA as he/she makes the change.
 Really Sr. DBA: Is busy installing the latest version of Oracle on
 AIX, and
 updating the current Oracle
 standards manual for the department, when the change is requested.
 Opens
 another window, quickly realizes that the change will end up causing
 all
 sorts of data inconsistencies,
 redesigns the entire change while at the same time flipping out CD 3
 of 5 of
 Oracle9iR2 for AIX, Implements
 the redesigned change after the developer reviews and approves. Then
 flips
 in CD 4 of 5.
 
 Jr. DBA: Checks with the Mid-tier DBA before making a change to make
 sure
 it's ok.
 Mid DBA: Checks with the Sr. DBA before making a change to make sure
 it's
 ok.
 Sr. DBA: Comfortable with making the change in his own right, but for
 more
 complicated changes
 or new architectural implementations, checks with the Sr. DBA to make
 sure
 it is ok.
 Really Sr. DBA: Talks with anyone who will listen and wonders why he
 is
 considered the grand-pobah
 DBA because he really doesn't feel like one.
 
 Jr. DBA: 3 Books on his desk.
 Mid DBA: 7 Books on his desk.
 Sr. DBA: 10-20 books on his desk.
 Really Sr. DBA: You can't find because he is buried under the books
 on his
 desk OR he is writing
 his latest book. 
 
 Jr. DBA: 2 weeks vacation, all taken.
 Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
 made up
 by long weekend and holiday changes.
 Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
 times,
 occasional Friday off too. All made up for by long weekend and
 holiday
 changes.
 Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
 course the
 company doesn't accrue vacation time) and all those long weekend and
 holiday
 changes. Pager of cell phone always going off.
 
 
 
 
 
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
 anyone ever told you that you're bad luck?
 Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
 mother's dying words. But I guess if your body's covered in third
 degree
 burns, and your foot's caught in a bear trap, you tend to start
 talkin'
 crazy.
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Freeman, Robert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: rebuilding indexes


it's definitely friday   :)


--- Jack Silvey [EMAIL PROTECTED] wrote:
 Lose 20 blocks in 10 days! Load as much as you
 normally do and still lose index width.
 
 no segment size restrictions or tiring delete routines
 that never seem to finish. easy-to-follow
 substr(column,1,1) update routine that guarentees a
 maximum of data loss and a minimum of storage!
 
 email to [EMAIL PROTECTED] for
 details.
 
 
 
 
 --- Rachel Carmichael [EMAIL PROTECTED] wrote:
  I'm sure it's #6 :)
  
  
  --- Jack Silvey [EMAIL PROTECTED] wrote:
   Matt,
   
   1) Storage parameter changes? Do you specify
  storage
   at the index or tablespace (or top partition)
   level?pctfree go up? initrans go up? bigger
  INITIAL or
   NEXT?
   
   2) did you build it the first time using
  parallelism
   and rebuild using single thread? When a PQ
  processes
   is used to build an object it uses its own extent,
  and
   then *deallocates the extra space* at the end. If
  you
   will notice, when you build using PQ your segments
   have wacko sizes, and that is why.
   
   If you rebuilt using a single process, it could be
   that you have a full allocation of space, some
  empty.
   
   3) more data? did you alter unusable, load, and
   rebuild?
   
   4) have you changed the minimize_records_per_block
   parameter and the index is a bitmap?
   
   5) has your data distribution changed? bitmap
  indexes
   tend to get bigger as your data moves towards high
   cardinality.
   
   6) has this index been eating too much sugar
  again?
   sometimes, this can cause an index glucose spike
  and
   tend to make it store more fat in the leaf blocks,
   especially around the middle of the index, but
   sometimes on the hips too. Perhaps you are not
  doing
   DDL on the table enough, and so the index is not
   getting enough exercise.
   
   hth, 
   
   jack silvey
   

--- Adams, Matthew (GEA, MABG, 088130)
[EMAIL PROTECTED]
wrote:
 Under what conditions would an 'alter index ..
rebuild' 
 actually case the size of the index to
  increase 
 by about 12 percent?
 
 
 
 
 Matt Adams - GE Appliances -
[EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user
friendly.  
 It's just particular about who it makes
  friends
with.
 


   
  __
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051 
  FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
   
  
 
 
To REMOVE yourself from this mailing list, send
  an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing:
  UNSUB
ORACLE-L
(or the name of mailing list you want to be
  removed
from).  You may
also send the HELP command for other information
(like subscribing).
   
   
   __
   Do You Yahoo!?
   Yahoo! - Official partner of 2002 FIFA World Cup
   http://fifaworldcup.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).
  
  
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.yahoo.com
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).

RE: Veritas Quick io

2002-05-31 Thread Jay Earle (DBA)


Hi Kathy,


Here is an excerpt from the Veritas Admin Guide.


Chapter 3, Using VERITAS Quick I/O P69

Handling Oracle Temporary Tablespaces and Quick I/O
You cannot convert temporary tablespaces using regular files to Quick I/O
files. By
default, qio_getdbfiles skips any tablespaces marked TEMPORARY because they
can
be sparse, which means that not all blocks in the file are allocated.
Quick I/O files cannot be sparse, as Quick I/O provides a raw-type interface
to storage. If
a sparse file is converted to a Quick I/O file, the Oracle instance can fail
if Oracle attempts
to write into one of these unallocated blocks.
You have the following options:
 You can create a new temporary tablespace using Quick I/O files. When you
initially
create a temporary tablespace on Quick I/O files, Oracle sees them as raw
devices and
does not create sparse files.
 You can drop your existing temporary tablespaces using regular files and
recreate
them using Quick I/O files.
 You can manually create the mkqio.dat file containing the Oracle database
filenames that you want to convert to use Quick I/O, excluding Oracle
tablespaces
that are marked TEMPORARY from the list.



Regards,


Jay

-Original Message-
Sent: Friday, May 31, 2002 3:37 PM
To: Multiple recipients of list ORACLE-L



We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps
11.5.6 on 8.1.7.2 database.

Right now we do not have the temp files converted to quick io and wonder if
we should.  The guy who installed Quick IO didn't seen to think we could but
he was a pretty junior person.  

Anybody here have any experience with this?

Kathy

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

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

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

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

Re:RE: Jr.DBA, Mid level DBA, Sr.DBA


Better run like WIND!!  All Real DBA's use HP.

Dick Goulet

Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date:   5/31/2002 11:01 AM

AIX? Come on all really senior DBAs work on SUN

(ducking and running broken field pattern :)  )



--- Freeman, Robert  [EMAIL PROTECTED] wrote:
 A few thoughts...
 
 Jr. DBA: Asks the Mid or Sr. DBA where to look.
 Mid DBA: Kind of knows where the answer is, but takes a bit to find
 it.
 Sr. DBA: Answer is dog eared in one or more of his office full of
 books.
 Really Sr. DBA: Answer is dog eared in his own book or paper.
 
 Jr. DBA: Feels a lot of fear with every change of the database he has
 to
 make.
 Mid DBA: Looks forward to the experience of making the changes.
 Sr. DBA: Suggests improvements when reviewing changes, helps
 implement those
 improvements and
  then monitors the Mid. DBA as he/she makes the change.
 Really Sr. DBA: Is busy installing the latest version of Oracle on
 AIX, and
 updating the current Oracle
 standards manual for the department, when the change is requested.
 Opens
 another window, quickly realizes that the change will end up causing
 all
 sorts of data inconsistencies,
 redesigns the entire change while at the same time flipping out CD 3
 of 5 of
 Oracle9iR2 for AIX, Implements
 the redesigned change after the developer reviews and approves. Then
 flips
 in CD 4 of 5.
 
 Jr. DBA: Checks with the Mid-tier DBA before making a change to make
 sure
 it's ok.
 Mid DBA: Checks with the Sr. DBA before making a change to make sure
 it's
 ok.
 Sr. DBA: Comfortable with making the change in his own right, but for
 more
 complicated changes
 or new architectural implementations, checks with the Sr. DBA to make
 sure
 it is ok.
 Really Sr. DBA: Talks with anyone who will listen and wonders why he
 is
 considered the grand-pobah
 DBA because he really doesn't feel like one.
 
 Jr. DBA: 3 Books on his desk.
 Mid DBA: 7 Books on his desk.
 Sr. DBA: 10-20 books on his desk.
 Really Sr. DBA: You can't find because he is buried under the books
 on his
 desk OR he is writing
 his latest book. 
 
 Jr. DBA: 2 weeks vacation, all taken.
 Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
 made up
 by long weekend and holiday changes.
 Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
 times,
 occasional Friday off too. All made up for by long weekend and
 holiday
 changes.
 Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
 course the
 company doesn't accrue vacation time) and all those long weekend and
 holiday
 changes. Pager of cell phone always going off.
 
 
 
 
 
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
 anyone ever told you that you're bad luck?
 Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
 mother's dying words. But I guess if your body's covered in third
 degree
 burns, and your foot's caught in a bear trap, you tend to start
 talkin'
 crazy.
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Freeman, Robert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself

Using RMAN

2002-05-31 Thread Debi


At 10:11 AM 5/31/2002 -0800, DENNIS WILLIAMS wrote:
Pat - I think you've pretty well covered the pros/cons from what I
understand. I haven't implemented in production, so hopefully some people
with some experience of living with RMAN will respond. How about it guys?

I have been using RMAN in production for three years, although only 
recently began backing up my archived logs with it as well.  I do take 
exports as well, to make simple table recovery easier.  We use Veritas 
NetBackup for tape.

I keep an RMAN catalog database separate from the production database. It 
is now on the same server, although originally I had it on a development 
server but decided that was too risky.  Immediately after a backup, I 
export the RMAN catalog database, then take an OS backup to tape of that 
dmp file.

Our weekly cold backups were over 8 hours and with RMAN, the equivalent 
(level 0 consistent) takes about 2 and a half hours.  Daily incrementals 
take an hour or less.  I regularly create/refresh development and test 
databases from production with RMAN.  These clones (what a great test of 
your backups!) generally take about 2 hours, and now that I have the 
archived logs, I can have a copy of production right to the minute.

I don't have to worry about changing backups when adding datafiles. I 
monitor my log_archive_dest directory and when it gets to about 50% full I 
kick off a RMAN backup that puts a copy on two different tapes before 
deleting the input (archived logs on disk).  My current issue is with tapes 
(and that is always an issue no matter what method you use), but I came 
across an RMAN command, restore validate, that I wonder if it will verify 
that my tape is ok.  Twice I have tried to do a certain restore and the 
tape has been bad.  I had to pick an earlier date and use archived logs...

I cannot imagine NOT using RMAN!

Debi



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

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

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

2002-05-31 Thread Freeman, Robert


 (ducking and running broken field pattern :)  )

Opens black looking suitcase with secret Nuclear launch codes,
chanting the mantra, there is always a solution.

Enjoying that new job?

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your body's
covered in third degree
burns, and your foot's caught in a bear trap, you tend to start talkin'
crazy.


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

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

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


it's fun so far. and one of these days I'll get to do DBA work too..
right now I'm trying to Teach yourself Data warehousing in 2 weeks


--- Freeman, Robert  [EMAIL PROTECTED] wrote:
  (ducking and running broken field pattern :)  )
 
 Opens black looking suitcase with secret Nuclear launch codes,
 chanting the mantra, there is always a solution.
 
 Enjoying that new job?
 
 RF
 
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
 Cousin Eddie: Those were my mother's dying words. But I guess if your
 body's
 covered in third degree
 burns, and your foot's caught in a bear trap, you tend to start
 talkin'
 crazy.
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Freeman, Robert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: rebuilding indexes

2002-05-31 Thread Ron Rogers


Mathew,
  There has to be something that changed in the index or the storage
parameters. The index storage is basically based on the database block
size, the pctfree, the average length of the index entry, and the number
of rows in the index. If you changed none of these the index should
remain the same.
You said that each extend is 65 - 8K blocks and the increase was 5
extents. that's 2720 K of additional storage for the indexes. That is a
lot of rows of data to be indexing. 
 Are you sure that the information is correct? Did the 20 extent number
come from old records and there were a lot of additions to the data?
 DID you analyze the indexes to create the extra space used?
Ron
ROR mª¿ªm

 [EMAIL PROTECTED] 05/31/02 02:11PM 
then the only thing I can think of is that there was heavy activity on
the index prior to the rebuild and the blocks filled and the rebuild
evened it out.


--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
 
 storage parameter difference?  None
 
  are you moving from one tablespace to
 another without specifying parameters?  No
 
 pctfree/pctused influence?  none
 
 
 I should have put this in the original message.
 
 Indexes stayed in original tablespace with identical
 storage parameters, but number of extents went from 
 20 to 25 (each extents is 65 8-K blocks)
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED] 
 Contrary to popular opinion, Unix is user friendly.  
 It's just particular about who it makes friends with.
 
 -Original Message-
 Sent: Friday, May 31, 2002 12:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 storage parameter difference?  are you moving from one tablespace to
 another without specifying parameters?
 
 pctfree/pctused influence?
 
 
 --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
 wrote:
  Under what conditions would an 'alter index .. rebuild' 
  actually case the size of the index to increase 
  by about 12 percent?
  
  
  
  
  Matt Adams - GE Appliances - [EMAIL PROTECTED] 
  Contrary to popular opinion, Unix is user friendly.  
  It's just particular about who it makes friends with.
  
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED] 

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

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

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

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

Stubborn Table

2002-05-31 Thread kkennedy


Well, it's time to call for the cavalry.

I have a table where the optimizer stubbornly insists on doing full table scans for 
practically every operation in spite of the fact that full table scans have gruesome 
performance.  Every hint I have tried has either been ignored or doesn't help (and 
yes, I have used hints before and have carefully checked my syntax).  The only way I 
have gotten the optimizer to even use an index on one query was to jam the session 
settings OPTIMIZER_INDEX_CACHING=100 plus OPTIMIZER_INDEX_COST_ADJ=1 which is not a 
healthy way to do things.  I would appreciate some help in psychoanalyzing the 
optimizer.

Oracle 8.1.7.3 on Solaris 2.8, all files on a single volume RAID-5 array (I know, I 
know but I can't do anything about it at the moment).

MDMA_INPUT_FILE is a high transaction table used for data loading and validation.  The 
table is badly denormalized due to decisions made long before I started working here.  
It has 15 indexes to support the validation GUI (yes, I know, lots of indexes on a 
high transaction table is insane and I have plans to deal with that in a month or 
two).  At the moment, the table holds over 800K rows.  The table has been analyzed.

Here are a couple examples of loony optimizer behavior:

###
SELECT Record_Type, Archive_Input_File
FROM MDMA_Input_File
GROUP BY Record_Type, Archive_Input_File

SELECT STATEMENT Hint=CHOOSE162 7500
  SORT GROUP BY 162 6 K 7500
TABLE ACCESS FULL   MDMA_INPUT_FILE 839 K   31 M1882

There is a valid index where these two columns are the first of 5 columns.  I've tried 
most permutations of INDEX hints and they are all ignored.

Actually, this statement stemmed from working around a problem of reading the full 
table ordered by the 5 index columns.  The optimizer chose to do a full table scan 
plus sort (with resultant RAID-5 ugly performance).  Apparently, it feels the sort 
would be quicker than index access -- which might be true on a non-IO bound system.

###
UPDATE mdma_input_file mif
   SET partial_day_hold = :b1,
   ok_to_process = :b2,
   vee_usage_end = to_date(:b3)
 WHERE EXISTS (SELECT 1
   FROM st_vee_input_file
  WHERE mif.rowid=mdma_rowid)

st_vee_input_file is a session temporary table with 96 rows.

UPDATE STATEMENT Hint=CHOOSE41 K1882 
  UPDATEMDMA_INPUT_FILE
FILTER
  TABLE ACCESS FULL MDMA_INPUT_FILE 41 K409 K   1882 
  TABLE ACCESS FULL ST_VEE_INPUT_FILE   82  574 7

Unless I can figure this out, I foresee reading the temp table into an array then 
doing the update in a forall loop.  Shouldn't have to do this much coding to work 
around the optimizer.

Thanks for any help you can give (or sympathy if help is unavailable),
Kevin Kennedy
First Point Energy Corporation 

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

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

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

2002-05-31 Thread Fink, Dan


REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief Tablets
as their hot standby

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Friday, May 31, 2002 1:01 PM
To: Multiple recipients of list ORACLE-L


AIX? Come on all really senior DBAs work on SUN

(ducking and running broken field pattern :)  )



--- Freeman, Robert  [EMAIL PROTECTED] wrote:
 A few thoughts...
 
 Jr. DBA: Asks the Mid or Sr. DBA where to look.
 Mid DBA: Kind of knows where the answer is, but takes a bit to find
 it.
 Sr. DBA: Answer is dog eared in one or more of his office full of
 books.
 Really Sr. DBA: Answer is dog eared in his own book or paper.
 
 Jr. DBA: Feels a lot of fear with every change of the database he has
 to
 make.
 Mid DBA: Looks forward to the experience of making the changes.
 Sr. DBA: Suggests improvements when reviewing changes, helps
 implement those
 improvements and
  then monitors the Mid. DBA as he/she makes the change.
 Really Sr. DBA: Is busy installing the latest version of Oracle on
 AIX, and
 updating the current Oracle
 standards manual for the department, when the change is requested.
 Opens
 another window, quickly realizes that the change will end up causing
 all
 sorts of data inconsistencies,
 redesigns the entire change while at the same time flipping out CD 3
 of 5 of
 Oracle9iR2 for AIX, Implements
 the redesigned change after the developer reviews and approves. Then
 flips
 in CD 4 of 5.
 
 Jr. DBA: Checks with the Mid-tier DBA before making a change to make
 sure
 it's ok.
 Mid DBA: Checks with the Sr. DBA before making a change to make sure
 it's
 ok.
 Sr. DBA: Comfortable with making the change in his own right, but for
 more
 complicated changes
 or new architectural implementations, checks with the Sr. DBA to make
 sure
 it is ok.
 Really Sr. DBA: Talks with anyone who will listen and wonders why he
 is
 considered the grand-pobah
 DBA because he really doesn't feel like one.
 
 Jr. DBA: 3 Books on his desk.
 Mid DBA: 7 Books on his desk.
 Sr. DBA: 10-20 books on his desk.
 Really Sr. DBA: You can't find because he is buried under the books
 on his
 desk OR he is writing
 his latest book. 
 
 Jr. DBA: 2 weeks vacation, all taken.
 Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
 made up
 by long weekend and holiday changes.
 Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
 times,
 occasional Friday off too. All made up for by long weekend and
 holiday
 changes.
 Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
 course the
 company doesn't accrue vacation time) and all those long weekend and
 holiday
 changes. Pager of cell phone always going off.
 
 
 
 
 
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
 anyone ever told you that you're bad luck?
 Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
 mother's dying words. But I guess if your body's covered in third
 degree
 burns, and your foot's caught in a bear trap, you tend to start
 talkin'
 crazy.
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Freeman, Robert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-31 Thread Weaver, Walt


You guys are rookies. The Gods all use Linux.

--Walt

-Original Message-
Sent: Friday, May 31, 2002 1:17 PM
To: Multiple recipients of list ORACLE-L


Better run like WIND!!  All Real DBA's use HP.

Dick Goulet

Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date:   5/31/2002 11:01 AM

AIX? Come on all really senior DBAs work on SUN

(ducking and running broken field pattern :)  )



--- Freeman, Robert  [EMAIL PROTECTED] wrote:
 A few thoughts...
 
 Jr. DBA: Asks the Mid or Sr. DBA where to look.
 Mid DBA: Kind of knows where the answer is, but takes a bit to find
 it.
 Sr. DBA: Answer is dog eared in one or more of his office full of
 books.
 Really Sr. DBA: Answer is dog eared in his own book or paper.
 
 Jr. DBA: Feels a lot of fear with every change of the database he has
 to
 make.
 Mid DBA: Looks forward to the experience of making the changes.
 Sr. DBA: Suggests improvements when reviewing changes, helps
 implement those
 improvements and
  then monitors the Mid. DBA as he/she makes the change.
 Really Sr. DBA: Is busy installing the latest version of Oracle on
 AIX, and
 updating the current Oracle
 standards manual for the department, when the change is requested.
 Opens
 another window, quickly realizes that the change will end up causing
 all
 sorts of data inconsistencies,
 redesigns the entire change while at the same time flipping out CD 3
 of 5 of
 Oracle9iR2 for AIX, Implements
 the redesigned change after the developer reviews and approves. Then
 flips
 in CD 4 of 5.
 
 Jr. DBA: Checks with the Mid-tier DBA before making a change to make
 sure
 it's ok.
 Mid DBA: Checks with the Sr. DBA before making a change to make sure
 it's
 ok.
 Sr. DBA: Comfortable with making the change in his own right, but for
 more
 complicated changes
 or new architectural implementations, checks with the Sr. DBA to make
 sure
 it is ok.
 Really Sr. DBA: Talks with anyone who will listen and wonders why he
 is
 considered the grand-pobah
 DBA because he really doesn't feel like one.
 
 Jr. DBA: 3 Books on his desk.
 Mid DBA: 7 Books on his desk.
 Sr. DBA: 10-20 books on his desk.
 Really Sr. DBA: You can't find because he is buried under the books
 on his
 desk OR he is writing
 his latest book. 
 
 Jr. DBA: 2 weeks vacation, all taken.
 Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
 made up
 by long weekend and holiday changes.
 Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
 times,
 occasional Friday off too. All made up for by long weekend and
 holiday
 changes.
 Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
 course the
 company doesn't accrue vacation time) and all those long weekend and
 holiday
 changes. Pager of cell phone always going off.
 
 
 
 
 
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
 anyone ever told you that you're bad luck?
 Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
 mother's dying words. But I guess if your body's covered in third
 degree
 burns, and your foot's caught in a bear trap, you tend to start
 talkin'
 crazy.
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Freeman, Robert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

SQLServer copy table from 1 db to another

2002-05-31 Thread Gene Sais


Is there a way to copy a table in 1 sqlserver db to another, similar to Oracle's 
exp/imp, or create tablle as select.., etc.  It appears the only way you can do it is 
thru DTS packages.


--
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: Jr.DBA, Mid level DBA, Sr.DBA


you win :)


--- Fink, Dan [EMAIL PROTECTED] wrote:
 REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief
 Tablets
 as their hot standby
 
 Daniel W. Fink
 Sr. Oracle DBA
 MICROMEDEX
 303.486.6456
 
 
 -Original Message-
 Sent: Friday, May 31, 2002 1:01 PM
 To: Multiple recipients of list ORACLE-L
 
 
 AIX? Come on all really senior DBAs work on SUN
 
 (ducking and running broken field pattern :)  )
 
 
 
 --- Freeman, Robert  [EMAIL PROTECTED] wrote:
  A few thoughts...
  
  Jr. DBA: Asks the Mid or Sr. DBA where to look.
  Mid DBA: Kind of knows where the answer is, but takes a bit to find
  it.
  Sr. DBA: Answer is dog eared in one or more of his office full of
  books.
  Really Sr. DBA: Answer is dog eared in his own book or paper.
  
  Jr. DBA: Feels a lot of fear with every change of the database he
 has
  to
  make.
  Mid DBA: Looks forward to the experience of making the changes.
  Sr. DBA: Suggests improvements when reviewing changes, helps
  implement those
  improvements and
   then monitors the Mid. DBA as he/she makes the change.
  Really Sr. DBA: Is busy installing the latest version of Oracle on
  AIX, and
  updating the current Oracle
  standards manual for the department, when the change is requested.
  Opens
  another window, quickly realizes that the change will end up
 causing
  all
  sorts of data inconsistencies,
  redesigns the entire change while at the same time flipping out CD
 3
  of 5 of
  Oracle9iR2 for AIX, Implements
  the redesigned change after the developer reviews and approves.
 Then
  flips
  in CD 4 of 5.
  
  Jr. DBA: Checks with the Mid-tier DBA before making a change to
 make
  sure
  it's ok.
  Mid DBA: Checks with the Sr. DBA before making a change to make
 sure
  it's
  ok.
  Sr. DBA: Comfortable with making the change in his own right, but
 for
  more
  complicated changes
  or new architectural implementations, checks with the Sr. DBA to
 make
  sure
  it is ok.
  Really Sr. DBA: Talks with anyone who will listen and wonders why
 he
  is
  considered the grand-pobah
  DBA because he really doesn't feel like one.
  
  Jr. DBA: 3 Books on his desk.
  Mid DBA: 7 Books on his desk.
  Sr. DBA: 10-20 books on his desk.
  Really Sr. DBA: You can't find because he is buried under the books
  on his
  desk OR he is writing
  his latest book. 
  
  Jr. DBA: 2 weeks vacation, all taken.
  Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
  made up
  by long weekend and holiday changes.
  Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
  times,
  occasional Friday off too. All made up for by long weekend and
  holiday
  changes.
  Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
  course the
  company doesn't accrue vacation time) and all those long weekend
 and
  holiday
  changes. Pager of cell phone always going off.
  
  
  
  
  
  
  Robert G. Freeman - Oracle8i OCP
  Oracle DBA Technical Lead
  CSX Midtier Database Administration
  Author: Oracle9i New Features 
  Mastering Oracle8i
  
  Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
  anyone ever told you that you're bad luck?
  Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
  mother's dying words. But I guess if your body's covered in third
  degree
  burns, and your foot's caught in a bear trap, you tend to start
  talkin'
  crazy.
  
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Freeman, Robert
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ:

Re: Stubborn Table