Re: Re:Query Tuning - Need Some Clarifiations

[C.S.Venkata Subramanian]

Hi,As per your statement and the volume of transaction u have mentioned, I feel the db 
which I tuned is peanuts when compared to yours. But it was the requirement of the 
customer, I did what the customer wanted, that's it buddy.

Regards
venkat 
--

On Mon, 13 Aug 2001 07:15:37  
 dgoulet wrote:
>The frequency at which you rebuild indexes and/or analyze the database is
>somewhat of a black art.  My first question is what do you mean by "there are
>huge inserts,updates and deletes"?  Our operational data store for our testers
>goes through something line 6 million inserts/updates/deletes per day and the
>maintenance is being done every 6 months without any performance degradation in
>between.
>
>Dick Goulet
>
>Reply Separator
>Author: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]>
>Date:   8/10/2001 11:45 PM
>
>Dear Listers,
>My manager called me asked to look into the database problems in an IVR appln.
>The size of the database is around 1 gigs. The db stores information about
>customers, their phone nos and the relevant details. The mail problem was delay
>in playing a welcome prompt when the call connects to IVR, 6 queries are
>executed before playing the welcome message and there was a major delay when the
>customer needed some info. Basically it has to query the database and pass on
>the info the person who had called.
>
>First I got all the queries and checked the plan,time taken for each query. I
>found all the queries did a full table scan and after creating necessary indexes
>and analyzing the tables, I hit the right thing. Now the welcome message is
>played moment the call is connected to IVR and there is no time lag susequent
>queries.
>
>Using tkprof I checked the usage of indexes,CPU usage, time taken for
>parse,execution. All showing 0. The customer is happy now and also the manager.
>
>I have few doubts. It is an OLTP kind of scenario, there are huge
>inserts,updates and deletes, in what frequency I have to rebuild indexes and
>analyze the tables after rebuilding indexes.
>
>Since the db is in noarchivelog mode, it is advisible to put the same in
>archivelog mode.
>
>Any advices/suggestions are welcome.
>
>Regards
>C.S.Venkata Subramanian
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: C.S.Venkata Subramanian
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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).
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

No messages since yesterday evening

[Ranganath K]

Hi all,

I have not received any messages since yesterday evening.  Is it the same
with all or any of you?

Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


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

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

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

Re: RAID or NOT to RAID? What's the diff???

[Jared Still]

And a number of folks will highly recommend that book.

If I could just get time to read more of it.  :(

Jared

On Monday 13 August 2001 13:06, Jonathan Lewis wrote:
> And if it does confuse you, my book has
> a couple of pretty pictures in it that might
> help.
>
> Jonathan Lewis
>
> Seminars on getting the best out of Oracle
> Last few places available for Sept 10th/11th
> See http://www.jlcomp.demon.co.uk/seminar.html
>
>
>
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: 13 August 2001 20:04
>
> |Hope this doesn't confuse you more.
> |
> |-steve
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

[Deshpande, Kirti]

Replication is included with the RDBMS. It is not an additional option that
you buy separately (yet).

Regards,

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

> -Original Message-
> From: Ron Thomas [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 8:01 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle 8.1.7 replication price
> 
> 
> Does anyone know the approximate price to order the replication option for
> 8.1.7EE?  I can't seem to
> find any information on this at the oracle store.
> 
> Ron Thomas
> Hypercom, Inc
> [EMAIL PROTECTED]
> "Either lead by example, or become a terrible warning"
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ron Thomas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re: ORA-379 Error

[Mohammad Rafiq]

Your db_block_buffers are too low for this size of database...It must be in 
the range of 12000 to 16000...Increase it as per available memory and 
adjusting your SHMMAX param at Unix level

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 13 Aug 2001 14:50:26 -0800

Hello, list,

Please forgive me if this question has come up before.  We upgraded a 
production database from Oracle 7.3.4
to 8.1.6.3 on Sun Solaris 2.6  about 1 month ago.  Recently we are receiving 
the ORA-379 error - no free buffers
available in buffer pool DEFAULT, on jobs submitted with dbms_job.
db_block_buffers = 4000,   processes = 350
db_block_size = 8192,  db_file_multiblock_read_count = 64
The database is approximately 40 gigs, mainly OLTP,  approximately 100 
users.  Can anyone shed any light on this
error / possible solutions ?

Thanks in advance,
Mary Ruiz / Atlanta
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruiz, Mary A (CAP, CDI)
   INET: [EMAIL PROTECTED]

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

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


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

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

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

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

Re[2]: OT -- training

[Jonathan Gennick]

Monday, August 13, 2001, 3:41:31 PM, Joe Testa wrote:
JT> You can't write off training.  you need to get incorporated. 

If you run a business, you can write off training. Being
incorporated is irrelevant. It's a bit unfair, I think.
People with jobs really get screwed over in the deduction
department. In my humble opinion (which the IRS will ignore)
people working a job should be able to treat their job as a
business and deduct training expenses, supply expenses, and
anything reasonable. There should not be a threshold either.
You should be able to deduct all expenses.

Best regards,

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

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

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

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

RE: OT -- training

[Rachel Carmichael]

>On the other hand, I can take the day off for the NY Users Group when there 
>aren't any emergencies (about 50% of the time).
>
>
>Jay Miller
>


try not to have any emergencies on September 12th :)   it's gonna be a good 
one!

Rachel

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

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

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

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

RE: OT -- training

[Rachel Carmichael]

the other way to deduct the full amount of conferences/training is to write 
it off against royalties :)



>From: "Bowes, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Mon, 13 Aug 2001 14:05:26 -0800
>
>You can deduct them on Line 20 of your schedule A for itemized deductions.
>
>This is subject to some  HOWEVER's.
>
>You must take your 2% of your adjusted gross income and deduct it from that
>deduction.  So if it cost you 2500 dollars to go to openworld and your
>adjusted gross income (w2's, tips, ira deduction, student loan interest
>deduction all factored) on line 34 of form 1040 is 50K then 2% of 50K is
>1000 dollars.  So you can only deduct 1500 of the 2500 dollars.
>
>And if your standard deduction (4400 for single/ 7350 for married) is 
>higher
>than your sched A, you won't write off any of it.
>
>
>Joe gets that deduction off the top.  Before it ever hits his 1040.  So he
>gets the full 2500 plus all his other business deductions with no 2%
>adjustment,  THEN he still gets any personal deductions of his standard
>deduction.
>
>
>So, yes, you can usually deduct it, but not entirely and at the expense of
>the standard deduction that you would already get.
>
>
>--Chris
>[EMAIL PROTECTED]
>
>
>
>-Original Message-
>Sent: Monday, August 13, 2001 4:01 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Either to don't need to incorporate, or my
>tax accountant lied to me,  I don't know
>which, but I have written off training
>and IOUG-A trips (that were paid for 100% by
>me) while I was an employee of
>a consulting firm.
>
>(Is that the IRS I hear knocking?)
>
>
>
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>Doing linear scans over an associative array is like
>   trying to club someone to death with a loaded Uzi.
>  - Larry Wall (creator of Perl)
>
>
>
>-Original Message-
>Sent: Monday, August 13, 2001 3:42 PM
>To: Multiple recipients of list ORACLE-L
>
>
>You can't write off training.  you need to get incorporated.  I'm a 
>business
>entity and if/when the company i work for won't pay for training, you can
>bet it will get written off on my taxes, that includes all of the oracle
>books, OCP exams, you name it, it gets deducted as a legitimate company
>expense.
>
>2 years ago the company i was working for didnt want to send me to
>openworld(and I knew i'd be leaving in less than 2months anyways), so i ate
>the cost and wrote the entire trip off.
>
>joe
>
>
>
>
>
> >>> [EMAIL PROTECTED] 08/13/01 02:41PM >>>
>Patrice,
>There is "resistance" to any training that I feel is necessary to further 
>my
>knowledge and/or enhance my understanding of the Oracle processes. Even
>though I have money in the budget for such items I have to submit a 
>business
>case defining the gains to the company and after completing the course with
>a passing grade the company will reimburse me the expenses for the course
>only. I also have to sign a waver that I will pay the company back the full
>cost of the course if I leave their employment before 365 days. Needless to
>say I pay for everything myself and hope to write it off on taxes if they
>ever get the bill signed into law.
>ROR mª¿ªm
>
> >>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
>CareerTrack and other "training" companies, or management-related stuff 
>like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED] < mailto:[EMAIL PROTECTED]
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>
>--
>Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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 Cit

Re: Hot Backup.........paths.

[Babette Turner-Underwood]

Also, using FULL paths is often a GOOD thing.

We were keeping online all archivelogs that were created since
the beginning of the hot backup and deleting the others.
I did a cd $ARCHIVELOGDIR
and then did find . -mtime !-newer TIMEFILE -exec rm {} \;
(not exact syntax).

The cd failed.
The job was run via cron.
Guess where cron runs from ??
Yup, the users $HOME directory.
Deleted all ORACLE SOFTWARE, backup scripts, etc, etc, etc

I now use FULL paths for find ALWAYS!!!

- Babette

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 6:40 PM



If you're calling SQL from a shell script you could define variables within
shell.

Veronica Levin wrote:
>
> Hi listers,
> I'm testing a hot backup script that I want to run overnight, but the only
> way I can get it to work is using absolute paths.I don't like it that
> way. is there any chance I can use relative paths in this? I tried to
> include a change directory but it didn't work.
> thanks in advance for your input!
>
> SQL> alter tablespace TEMP begin backup;
> SQL> host /bin/tar -cvf /exp_imp/temp.tar /truck_temp/tempPROD1.dbf
> SQL> host compress -c /exp_imp/temp.tar>/exp_imp/TEMP_08_aug_01.Z
> SQL> alter tablespace TEMP end backup;
>
> f80 root /exp_imp -> tar -vtf temp.tar
> -rw-r- 203 11 419438592 Aug 13 13:30:22 2001 /truck_temp/tempPROD1.dbf
> f80 root /exp_imp ->
>
> Saludos,
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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



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

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

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

Re: OEM index tuning

[Binley Lim]

Afraid not - it produces some good results, and a lot of weird ones. 

Bottom line is you still have to know what you are doing.

>>> [EMAIL PROTECTED] 08/14/01 09:50AM >>>
Hi all,

I run the OEM Oracle Expert for index tuning.  It
generates a script that I should drop some indexes,
and build some indexes.  Should I follow what OEM
suggests?  Is there an easy way to verify whether
OEM's suggestion is corret?  For example, OEM suggests
to bulid index on table1 using col1 and col2.  I tried
to find a query search using col1&2 on T1, but didn't
find any.  (Where did OEM get the idea?)  


Thanks, Andrea

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

Oracle 8.1.7 replication price

[Ron Thomas]

Does anyone know the approximate price to order the replication option for 8.1.7EE?  I 
can't seem to
find any information on this at the oracle store.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Either lead by example, or become a terrible warning"

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

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

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

RE: 07_DICTIONARY_ACCESSIBILITY

[Jon Walthour]

Ron:

All I can find on it is that it's an Oracle 8 parameter used to provide
Oracle 7 dictionary accessibility. Not much, I know.
 
Jon Walthour

-Original Message-
L.
Sent: Monday, August 13, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L


Does anyone have any experience and or info on the
07_DICTIONARY_ACCESSIBILITY parameter?

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

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

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


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

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

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

RE: OT -- training

[Christopher Spence]

Title: Message



Yes, you will get 1099 to your 
social number.  Which is enough to do a business who has no 
employees/benefits.
 
 
"Do not criticize someone until you walked a 
mile in their shoes, that way when you criticize them, you are a mile a way and 
have their shoes."
Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863   

  
  -Original Message-From: Bowes, Chris 
  [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 6:26 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  Really?  I was told 
  that  if you are an independent NON 
  incorporated entity, you will get a 1099 to your social security number.  
  If you incorporate as a 1099 business (sole prop, non schedule C company) then 
  your company will get a 1099.
   
  If you are an S corp or a C 
  corp, and have a corporate EIN then usually you won't get any 
  1099's.
   
  Either way, there will be 
  paper work and numbers needed and your income will be 
  reportted.
   
  Most companies that I have 
  dealt with have demanded that you be incorporated as a C or S corp.  The 
  reason is if you're not an s or c corporation and you're getting any kind of 
  benefit from a company that you're doing work for and not an employee of, then 
  the IRS can (and will, if they discover it), charge that company for your FICA 
  taxes and FUTA taxes.   They can also declare you an employee of 
  them, exposing them to lawsuits from you.
   
  If you are incorporated, then 
  the likelyhood of the IRS telling a company using your work that they are 
  responsible for your payroll taxes goes down.  It's not nonexistant, but 
  it does go down.
   
  I'll have to look this up to 
  see where I am wrong.
   
  --Chris [EMAIL PROTECTED] 
   
  
-Original Message-From: Christopher Spence 
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:58 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
OT -- training
Generally the way it works 
(at least in NH)
 
If you do not hire 
employee's, give benefits you do not need a tax id.
Although alot of companys 
are very uncomfortable dealing with people without tax 
id's.
If you are by yourself 
you generally will not need a tax id.  Although it may prove benefitial 
to have one to make it easier when dealing with larger companies who feel 
insecure.
 
 
"Do not criticize someone until you walked a 
mile in their shoes, that way when you criticize them, you are a mile a way 
and have their shoes."
Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863   

  
  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 
  4:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT -- training
  That i dont know for sure, i incorporated so there would 
  be less questions from the IRS, got a taxid the whole thing, separate 
  checking acct, credit cards, so there is a definite separation between 
  business money and personal money.
   
  joe
   
   
  oh and my original statement should have been a 
  question
   
  You can't write off training?
   
   
  >>> [EMAIL PROTECTED] 08/13/01 04:11PM 
  >>>Joe do you actually have to get incorporated or can you 
  just file as aprivate business? - E-Original 
  Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 
  Monday, August 13, 2001 12:42 PMTo: Multiple recipients of list 
  ORACLE-LYou can't write off training.  you need to get 
  incorporated.  I'm a businessentity and if/when the company i 
  work for won't pay for training, you canbet it will get written off on 
  my taxes, that includes all of the oraclebooks, OCP exams, you name 
  it, it gets deducted as a legitimate companyexpense.  2 
  years ago the company i was working for didnt want to send me 
  toopenworld(and I knew i'd be leaving in less than 2months anyways), 
  so i atethe cost and wrote the entire trip 
  off.joe>>> [EMAIL PROTECTED] 
  08/13/01 02:41PM >>>Patrice,There is "resistance" to any 
  training that I feel is necessary to further myknowledge and/or 
  enhance my understanding of the Oracle processes. Eventhough I have 
  money in the budget for such items I have to submit a businesscase 
  defining the gains to the company and after completing the course 
  witha passing grade the company will reimburse me the expenses for the 
  courseonly. I also have to sign a waver that I will pay the company 
  back the fullcost of the course if I leave their employment before 365 
  days. Needless tosay 

Re: OT -- training

[Joe Testa]

Kewl, i never really knew how it worked, got a CPA to make sure that all
happens, i just send her a spreadsheet with the numbers of all my
receipts(in case irs comes knocking), and she does the rest :)

joe

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
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: Substitute for Materialized Views/Snapshots?

[Page, Bruce]

Two thoughts.

1) buy the Enterprise edition

2) export the tables from the database and then load them in.

> -Original Message-
> From: Chris Rezek [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 5:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Substitute for Materialized Views/Snapshots?
> 
> 
> We are running 8.1.6 Standard Edition on Solaris hardware.  We are
> building a reporting system and would have liked to use materialized
> views (snapshots) but this feature is not available in Standard
> Edition.  We need to create read-consistent copies of several
> million-row tables each night at midnight.  How can we do this without
> Oracle's auto-updating materialized views?
> 
> Chris Rezek
> Oracle DBA
> http://www.dmn.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Chris Rezek
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- training

[Bowes, Chris]

Title: Message



Really?  I was told 
that  if you are an independent NON 
incorporated entity, you will get a 1099 to your social security number.  
If you incorporate as a 1099 business (sole prop, non schedule C company) then 
your company will get a 1099.
 
If you are an S corp or a C 
corp, and have a corporate EIN then usually you won't get any 
1099's.
 
Either way, there will be paper 
work and numbers needed and your income will be reportted.
 
Most companies that I have 
dealt with have demanded that you be incorporated as a C or S corp.  The 
reason is if you're not an s or c corporation and you're getting any kind of 
benefit from a company that you're doing work for and not an employee of, then 
the IRS can (and will, if they discover it), charge that company for your FICA 
taxes and FUTA taxes.   They can also declare you an employee of them, 
exposing them to lawsuits from you.
 
If you are incorporated, then 
the likelyhood of the IRS telling a company using your work that they are 
responsible for your payroll taxes goes down.  It's not nonexistant, but it 
does go down.
 
I'll have to look this up to 
see where I am wrong.
 
--Chris [EMAIL PROTECTED] 
 

  -Original Message-From: Christopher Spence 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:58 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  Generally the way it works 
  (at least in NH)
   
  If you do not hire 
  employee's, give benefits you do not need a tax id.
  Although alot of companys are 
  very uncomfortable dealing with people without tax id's.
  If you are by yourself 
  you generally will not need a tax id.  Although it may prove benefitial 
  to have one to make it easier when dealing with larger companies who feel 
  insecure.
   
   
  "Do not criticize someone until you walked a 
  mile in their shoes, that way when you criticize them, you are a mile a way 
  and have their shoes."
  Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 
  Fuelspot 73 Princeton Street North, Chelmsford 01863   
  

-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 
4:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT -- training
That i dont know for sure, i incorporated so there would 
be less questions from the IRS, got a taxid the whole thing, separate 
checking acct, credit cards, so there is a definite separation between 
business money and personal money.
 
joe
 
 
oh and my original statement should have been a 
question
 
You can't write off training?
 
 
>>> [EMAIL PROTECTED] 08/13/01 04:11PM >>>Joe 
do you actually have to get incorporated or can you just file as 
aprivate business? - E-Original Message-From: JOE 
TESTA [mailto:[EMAIL PROTECTED]]Sent: 
Monday, August 13, 2001 12:42 PMTo: Multiple recipients of list 
ORACLE-LYou can't write off training.  you need to get 
incorporated.  I'm a businessentity and if/when the company i work 
for won't pay for training, you canbet it will get written off on my 
taxes, that includes all of the oraclebooks, OCP exams, you name it, it 
gets deducted as a legitimate companyexpense.  2 years ago 
the company i was working for didnt want to send me toopenworld(and I 
knew i'd be leaving in less than 2months anyways), so i atethe cost and 
wrote the entire trip off.joe>>> 
[EMAIL PROTECTED] 08/13/01 02:41PM >>>Patrice,There is 
"resistance" to any training that I feel is necessary to further 
myknowledge and/or enhance my understanding of the Oracle processes. 
Eventhough I have money in the budget for such items I have to submit a 
businesscase defining the gains to the company and after completing the 
course witha passing grade the company will reimburse me the expenses 
for the courseonly. I also have to sign a waver that I will pay the 
company back the fullcost of the course if I leave their employment 
before 365 days. Needless tosay I pay for everything myself and hope to 
write it off on taxes if theyever get the bill signed into law.ROR 
mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
>>>Just out of curiosity, how many days / weeks of real 
training did youremployer provide you with in the last couple of 
years?"real" is in quotes, I don't mean the little 1 - 3 day 
seminars given byCareerTrack and other "training" companies, or 
management-related stuff likelittle MBA-flavoured certificates from 
universities.Oh, and did the amount of training you received match 
what you were toldduring your job interview?Regards,Patrice 
BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & 
Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 

RE: OT -- training

[Miller, Jay]

When I first started with the company I was told I'd be sent to training
every year.  Nothing.
When I was promoted to my full-time DBA position I asked for training.  I
was told I didn't need it.  I took classes on my own time and dollar.
After 4 years with the company I was finally allowed to go to a week of
Oracle Training (the excellent Internals seminars).  Nothing in the year
since then.
I was allowed to go to ECO when it was held in NYC, but not to any out of
town conferences.

The company, in an effort to cut costs, has now said that all training must
be web based.  Which means that I would be sitting here with everyone asking
me to do my usual work while "training".  Don't think I'll notice much
difference.

On the other hand, I can take the day off for the NY Users Group when there
aren't any emergencies (about 50% of the time).


Jay Miller


-Original Message-
Sent: Monday, August 13, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

RE: OT -- training

[Stephen Andert]

Christopher, 

On that same thought, I read the best response to a company who won't train their 
people because "then they'll leave".  

Which would you rather have happen?  Train people and have them leave or not train 
them and have them stay?  I know where I'd rather work.



Stephen Andert


>>> [EMAIL PROTECTED] 08/13 12:53 PM >>>
Very common what you explained.

I think businesses are afraid to do training as they think you will become
more marketable and opt to leave.
If they are afraid of that, they should fix the problems or give more money
to make it so you would not want to leave.  If they themselves think your
going to leave because of training, they must already know it sucks and they
should fix it.

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 13, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L


Patrice,
 There is "resistance" to any training that I feel is necessary to further
my knowledge and/or enhance my understanding of the Oracle processes. Even
though I have money in the budget for such items I have to submit a business
case defining the gains to the company and after completing the course with
a passing grade the company will reimburse me the expenses for the course
only. I also have to sign a waver that I will pay the company back the full
cost of the course if I leave their employment before 365 days. Needless to
say I pay for everything myself and hope to write it off on taxes if they
ever get the bill signed into law. ROR mª¿ªm 

>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECT

RE: OT -- training

[Bowes, Chris]

You can deduct them on Line 20 
of your schedule A for itemized deductions. 
 
This is subject to 
some  HOWEVER's.  

 
You must take your 2% of your 
adjusted gross income and deduct it from that deduction.  So if it cost you 
2500 dollars to go to openworld and your adjusted gross income (w2's, tips, ira 
deduction, student loan interest deduction all factored) on line 34 of form 1040 
is 50K then 2% of 50K is 1000 dollars.  So you can only deduct 1500 of the 
2500 dollars.
 
And if your standard deduction 
(4400 for single/ 7350 for married) is higher than your sched A, you won't write 
off any of it.  
 
 
Joe gets that deduction off the 
top.  Before it ever hits his 1040.  So he gets the full 2500 plus all 
his other business deductions with no 2% adjustment,  THEN he still gets 
any personal deductions of his standard deduction.  

 
 
So, yes, you can usually deduct 
it, but not entirely and at the expense of the standard deduction that you would 
already get.
 
--Chris [EMAIL PROTECTED] 
 

  -Original Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  Either to 
  don't need to incorporate, or my 
  tax 
  accountant lied to me,  I don't know
  which, but 
  I have written off training
  and IOUG-A 
  trips (that were paid for 100% by
  me) while 
  I was an employee of
  a 
  consulting firm.
   
  (Is that 
  the IRS I hear knocking?)
   
   Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is 
  like   trying to club someone 
  to death with a loaded Uzi.  
  - Larry Wall (creator of Perl) 
   
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 3:42 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
OT -- training
You can't write off training.  you need to get 
incorporated.  I'm a business entity and if/when the company i work for 
won't pay for training, you can bet it will get written off on my taxes, 
that includes all of the oracle books, OCP exams, you name it, it gets 
deducted as a legitimate company expense.  
 
2 years ago the company i was working for didnt want to 
send me to openworld(and I knew i'd be leaving in less than 2months 
anyways), so i ate the cost and wrote the entire trip off.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 08/13/01 02:41PM 
>>>Patrice,There is "resistance" to any training that I 
feel is necessary to further my knowledge and/or enhance my understanding of 
the Oracle processes. Even though I have money in the budget for such items 
I have to submit a business case defining the gains to the company and after 
completing the course with a passing grade the company will reimburse me the 
expenses for the course only. I also have to sign a waver that I will pay 
the company back the full cost of the course if I leave their employment 
before 365 days. Needless to say I pay for everything myself and hope to 
write it off on taxes if they ever get the bill signed into law.ROR 
mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
>>>Just out of curiosity, how many days / weeks of real 
training did youremployer provide you with in the last couple of 
years?"real" is in quotes, I don't mean the little 1 - 3 day 
seminars given byCareerTrack and other "training" companies, or 
management-related stuff likelittle MBA-flavoured certificates from 
universities.Oh, and did the amount of training you received match 
what you were toldduring your job interview?Regards,Patrice 
BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & 
Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | 
Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]  
--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: 
Boivin, Patrice J  INET: [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).--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)

RE: OT -- training

[Ron Thomas]

An LLC (Limited Liability Company) should give you the same protections and tax 
write-off as a corp
except with less paperwork.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Either lead by example, or become a terrible warning"


   
   
JTESTA@longab  
   
erger.comTo: [EMAIL PROTECTED]  
   
Sent by: cc:   
   
root@fatcity.Subject: RE: OT -- training   
   
com
   
   
   
   
   
08/13/01   
   
01:39 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




That i dont know for sure, i incorporated so there would be less questions from the 
IRS, got a taxid
the whole thing, separate checking acct, credit cards, so there is a definite 
separation between
business money and personal money.

joe


oh and my original statement should have been a question

You can't write off training?




>>> [EMAIL PROTECTED] 08/13/01 04:11PM >>>
Joe do you actually have to get incorporated or can you just file as a
private business? - E

-Original Message-
Sent: Monday, August 13, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L


You can't write off training.  you need to get incorporated.  I'm a business
entity and if/when the company i work for won't pay for training, you can
bet it will get written off on my taxes, that includes all of the oracle
books, OCP exams, you name it, it gets deducted as a legitimate company
expense.

2 years ago the company i was working for didnt want to send me to
openworld(and I knew i'd be leaving in less than 2months anyways), so i ate
the cost and wrote the entire trip off.

joe





>>> [EMAIL PROTECTED] 08/13/01 02:41PM >>>
Patrice,
There is "resistance" to any training that I feel is necessary to further my
knowledge and/or enhance my understanding of the Oracle processes. Even
though I have money in the budget for such items I have to submit a business
case defining the gains to the company and after completing the course with
a passing grade the company will reimburse me the expenses for the course
only. I also have to sign a waver that I will pay the company back the full
cost of the course if I leave their employment before 365 days. Needless to
say I pay for everything myself and hope to write it off on taxes if they
ever get the bill signed into law.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] < mailto:[EMAIL PROTECTED]
 >

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

--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, 

RE: OT -- training

[lhoska]

knock, 
knock...
:-)
 
 
p.s. I always wondered if you 
can put blame on your tax adviser in case of trouble.  I suspect, they 
won't buy it...

  [Lyuda Hoska]  -Original 
  Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  Either to 
  don't need to incorporate, or my 
  tax 
  accountant lied to me,  I don't know
  which, but 
  I have written off training
  and IOUG-A 
  trips (that were paid for 100% by
  me) while 
  I was an employee of
  a 
  consulting firm.
   
  (Is that 
  the IRS I hear knocking?)
   
   Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is 
  like   trying to club someone 
  to death with a loaded Uzi.  
  - Larry Wall (creator of Perl) 
   
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 3:42 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
OT -- training
You can't write off training.  you need to get 
incorporated.  I'm a business entity and if/when the company i work for 
won't pay for training, you can bet it will get written off on my taxes, 
that includes all of the oracle books, OCP exams, you name it, it gets 
deducted as a legitimate company expense.  
 
2 years ago the company i was working for didnt want to 
send me to openworld(and I knew i'd be leaving in less than 2months 
anyways), so i ate the cost and wrote the entire trip off.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 08/13/01 02:41PM 
>>>Patrice,There is "resistance" to any training that I 
feel is necessary to further my knowledge and/or enhance my understanding of 
the Oracle processes. Even though I have money in the budget for such items 
I have to submit a business case defining the gains to the company and after 
completing the course with a passing grade the company will reimburse me the 
expenses for the course only. I also have to sign a waver that I will pay 
the company back the full cost of the course if I leave their employment 
before 365 days. Needless to say I pay for everything myself and hope to 
write it off on taxes if they ever get the bill signed into law.ROR 
mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
>>>Just out of curiosity, how many days / weeks of real 
training did youremployer provide you with in the last couple of 
years?"real" is in quotes, I don't mean the little 1 - 3 day 
seminars given byCareerTrack and other "training" companies, or 
management-related stuff likelittle MBA-flavoured certificates from 
universities.Oh, and did the amount of training you received match 
what you were toldduring your job interview?Regards,Patrice 
BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & 
Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | 
Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]  
--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: 
Boivin, Patrice J  INET: [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).--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-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: Hot Backup.........paths.

[Suzy Vordos]

If you're calling SQL from a shell script you could define variables within
shell.

Veronica Levin wrote:
> 
> Hi listers,
> I'm testing a hot backup script that I want to run overnight, but the only
> way I can get it to work is using absolute paths.I don't like it that
> way. is there any chance I can use relative paths in this? I tried to
> include a change directory but it didn't work.
> thanks in advance for your input!
> 
> SQL> alter tablespace TEMP begin backup;
> SQL> host /bin/tar -cvf /exp_imp/temp.tar /truck_temp/tempPROD1.dbf
> SQL> host compress -c /exp_imp/temp.tar>/exp_imp/TEMP_08_aug_01.Z
> SQL> alter tablespace TEMP end backup;
> 
> f80 root /exp_imp -> tar -vtf temp.tar
> -rw-r- 203 11 419438592 Aug 13 13:30:22 2001 /truck_temp/tempPROD1.dbf
> f80 root /exp_imp ->
> 
> Saludos,
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- training

[lhoska]

I've heard from my tax adviser your business doesn't have to show any profit
for number of years after opening.  I suspect even then it is not required.
What if you having hard time making profit?  It doesn't mean you have to
close your business...I assume in that case you can also register as a
non-profit organization.  Are tax breaks better for non-profits?  I don't
know..
Also, if you don't already know.. some training companies (Learning Tree
International per example) won't even register you for class if you're an
individual.  You have to be a corporation.
Lyuda

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


You could create a web site that features some technical materials and use
it to advertise your services if you are willing to moonlight on a few jobs,
just enough to turn a profit within a couple years.  Then I would presume
you would have no trouble writing the training off as a legitimate biz
expense.

- Ethan
- http://www.geocities.com/epost1

>-Original Message-
>From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 13, 2001 11:42 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: OT -- training
>
>
>Patrice,
> There is "resistance" to any training that I feel is 
>necessary to further my knowledge and/or enhance my 
>understanding of the Oracle processes. Even though I have 
>money in the budget for such items I have to submit a business 
>case defining the gains to the company and after completing 
>the course with a passing grade the company will reimburse me 
>the expenses for the course only. I also have to sign a waver 
>that I will pay the company back the full cost of the course 
>if I leave their employment before 365 days. Needless to say I 
>pay for everything myself and hope to write it off on taxes if 
>they ever get the bill signed into law.
>ROR mª¿ªm 
>
 [EMAIL PROTECTED] 08/13/01 11:46AM >>>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day 
>seminars given by
>CareerTrack and other "training" companies, or 
>management-related stuff like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you 
>were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique 
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED]  
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Boivin, Patrice J
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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).
>


--
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy.   Thank you.


==

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

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

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

ORA-379 Error

[Ruiz, Mary A (CAP, CDI)]

Hello, list,

Please forgive me if this question has come up before.  We upgraded a production 
database from Oracle 7.3.4
to 8.1.6.3 on Sun Solaris 2.6  about 1 month ago.  Recently we are receiving the 
ORA-379 error - no free buffers
available in buffer pool DEFAULT, on jobs submitted with dbms_job.db_block_buffers 
= 4000,   processes = 350
db_block_size = 8192,  db_file_multiblock_read_count = 64 
The database is approximately 40 gigs, mainly OLTP,  approximately 100 users.  Can 
anyone shed any light on this
error / possible solutions ? 

Thanks in advance,
Mary Ruiz / Atlanta
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruiz, Mary A (CAP, CDI)
  INET: [EMAIL PROTECTED]

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

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

Re: Explain Plan different on TEST and PRODUCTION instance

[Mohammad Rafiq]

Just for your reading...

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 03 Aug 2001 15:36:05 -0800

Brijesh,

Even though OPTIMIZER_MODE=RULE, the CBO will be used
in the presence of other features (e.g. partitioning,
degree of parallelism, etc...).

In this case TEST is getting a better plan because the
CBO is being used.  You can tell this from several
features in the explain plan:
   1.  Cost = 169
   Only the CBO calculates costs.
   2.  Only the CBO uses hash joins.

The first thing I'd check is the degree of parallelism
on the tables AND indexes.  In 8.0.5 and 8.1.5 the CBO
is used when the indexes have a degree of parallelism
 > 1 even if the tables don't (see note: 70008.1).

If you follow the flow chart in Note: 66484.1 "Which
Optimizer is Used ?"  (looks best if you click on the
"fixed font" above the heading for the note) you
should find what's causing the CBO to be used on Test.

HTH,

-- Anita

--- "Gupta, Brijesh" <[EMAIL PROTECTED]>
wrote:
 > Hi ALL
 >
 >  I have a query with was running fast during the
 > test in the test instance
 > and
 >   now when moved to production is running very slow.
 > On checking I found that same query is using
 > different explain plan on test
 > and production.
 >
 > Test is exact copy of production database only
 > little older data.
 >
 > Both database running Oracle Application with
 > optimizer mode = RULE .
 > Oracle 8.0.5
 > Platform AIX
 >
 > Can somebody give me a pointer why this is
 > happening.
 >
 > Thanks
 >
 > Here is explain plan from both instance and query
 >
 > ON PROD :
 >
 > Query Plan
 >

 > SELECT STATEMENT   Cost =
 >   SORT GROUP BY
 > NESTED LOOPS
 >   NESTED LOOPS
 > TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS
 > TABLE ACCESS BY INDEX ROWID
 > CP_INVOICE_HEADERS_ALL
 >   INDEX RANGE SCAN CP_INVOICE_HEADERS_N2
 >   TABLE ACCESS BY INDEX ROWID
 > CP_INVOICE_ITEMS_ALL
 > INDEX RANGE SCAN CP_INVOICE_ITEMS_N25
 >
 >
 > ON TEST :
 >
 > Query Plan
 >
-
 > SELECT STATEMENT   Cost = 169
 >   SORT GROUP BY
 > HASH JOIN
 >   NESTED LOOPS
 > TABLE ACCESS BY INDEX ROWID
 > CP_INVOICE_HEADERS_ALL
 >   INDEX RANGE SCAN CP_INVOICE_HEADERS_N2
 > TABLE ACCESS BY INDEX ROWID
 > CP_INVOICE_ITEMS_ALL
 >   INDEX RANGE SCAN CP_INVOICE_ITEMS_PK
 >   TABLE ACCESS FULL DI_PRATN_CHARGE_ITEMS
 >
 >
 >
 > and Query is
 >
 >   Select
 >  Nvl(ih.sub_customer_number, ih.customer_number)
 > customer_number
 > ,ih.sub_account_number
 > ,ii.inventory_item_id
 > ,ii.organization_id
 > ,Sum(ii.total_line_amount) total_line_amount
 >   From   apps.CP_INVOICE_ITEMS ii,
 >  apps.CP_INVOICE_HEADERS ih,
 >  apps.DI_PRATN_CHARGE_ITEMS ci
 >   where  ih.billing_period_end_date = '31-jan-2000'
 >   andii.invoice_id = ih.invoice_id
 >   andii.inventory_item_id=ci.inventory_item_id+0
 >   andii.organization_id=ci.organization_id+0
 >   andnvl(ii.total_line_amount, 0) != 0
 >   group by
 >  Nvl(ih.sub_customer_number,
 > ih.customer_number),
 >  ih.sub_account_number,
 >  ii.inventory_item_id,
 >  ii.organization_id
 > /
 >
 >
 >
 >
 >
 >
 > 
 > Brijesh Gupta
 > Oracle Production DBA
 >


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

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

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


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

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

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

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

OEM index tuning

[Andrea Oracle]

Hi all,

I run the OEM Oracle Expert for index tuning.  It
generates a script that I should drop some indexes,
and build some indexes.  Should I follow what OEM
suggests?  Is there an easy way to verify whether
OEM's suggestion is corret?  For example, OEM suggests
to bulid index on table1 using col1 and col2.  I tried
to find a query search using col1&2 on T1, but didn't
find any.  (Where did OEM get the idea?)  


Thanks, Andrea

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

Substitute for Materialized Views/Snapshots?

[Chris Rezek]

We are running 8.1.6 Standard Edition on Solaris hardware.  We are
building a reporting system and would have liked to use materialized
views (snapshots) but this feature is not available in Standard
Edition.  We need to create read-consistent copies of several
million-row tables each night at midnight.  How can we do this without
Oracle's auto-updating materialized views?

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

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

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

RE: OT -- training

[Christopher Spence]

Title: Message



Generally the way it works (at 
least in NH)
 
If you do not hire employee's, 
give benefits you do not need a tax id.
Although alot of companys are 
very uncomfortable dealing with people without tax id's.
If you are by yourself you 
generally will not need a tax id.  Although it may prove benefitial to have 
one to make it easier when dealing with larger companies who feel 
insecure.
 
 
"Do not criticize someone until you walked a 
mile in their shoes, that way when you criticize them, you are a mile a way and 
have their shoes."
Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863   

  
  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 4:40 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  That i dont know for sure, i incorporated so there would be 
  less questions from the IRS, got a taxid the whole thing, separate checking 
  acct, credit cards, so there is a definite separation between business money 
  and personal money.
   
  joe
   
   
  oh and my original statement should have been a 
  question
   
  You can't write off training?
   
   
  >>> [EMAIL PROTECTED] 08/13/01 04:11PM >>>Joe 
  do you actually have to get incorporated or can you just file as aprivate 
  business? - E-Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 
  Monday, August 13, 2001 12:42 PMTo: Multiple recipients of list 
  ORACLE-LYou can't write off training.  you need to get 
  incorporated.  I'm a businessentity and if/when the company i work 
  for won't pay for training, you canbet it will get written off on my 
  taxes, that includes all of the oraclebooks, OCP exams, you name it, it 
  gets deducted as a legitimate companyexpense.  2 years ago 
  the company i was working for didnt want to send me toopenworld(and I knew 
  i'd be leaving in less than 2months anyways), so i atethe cost and wrote 
  the entire trip off.joe>>> 
  [EMAIL PROTECTED] 08/13/01 02:41PM >>>Patrice,There is 
  "resistance" to any training that I feel is necessary to further 
  myknowledge and/or enhance my understanding of the Oracle processes. 
  Eventhough I have money in the budget for such items I have to submit a 
  businesscase defining the gains to the company and after completing the 
  course witha passing grade the company will reimburse me the expenses for 
  the courseonly. I also have to sign a waver that I will pay the company 
  back the fullcost of the course if I leave their employment before 365 
  days. Needless tosay I pay for everything myself and hope to write it off 
  on taxes if theyever get the bill signed into law.ROR mª¿ªm 
  >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
  >>>Just out of curiosity, how many days / weeks of real training 
  did youremployer provide you with in the last couple of 
  years?"real" is in quotes, I don't mean the little 1 - 3 day seminars 
  given byCareerTrack and other "training" companies, or management-related 
  stuff likelittle MBA-flavoured certificates from universities.Oh, 
  and did the amount of training you received match what you were toldduring 
  your job interview?Regards,Patrice BoivinSystems Analyst 
  (Oracle Certified DBA)Systems Admin & Operations | Admin. et 
  Exploit. des systèmesTechnology 
  Services    | Services 
  technologiquesInformatics 
  Branch | Direction de 
  l'informatique Maritimes Region, DFO  | 
  Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED] < mailto:[EMAIL PROTECTED] 
  > --Please see the official ORACLE-L FAQ: http://www.orafaq.com  
  --Author: Boivin, Patrice J  INET: [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).--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-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

Re: Datafile/Tablespace creation....

[JOE TESTA]

Lisa, if the db dont recognize it(and you should be able to do 
a alter system checkpoint and see the date/time on the file didnt get updated), 
then you can remove it safely.
 
hth, joe
 
>>> [EMAIL PROTECTED] 08/13/01 04:31PM >>>I 
attempted to create a new tablespace, but did not have db_files set 
largeenough and so it aborted the tablespace creation (found this in the 
alertlog). However, some of the process completed as it did create a 
datafile.Now that I have bumped up the db_files parameter what do can I 
manuallydelete the datafile (at the OS level) without repercussion? 
Nothingrecognizes the datafile (e.g. select * from dba_data_files, OEM, 
TOAD).thanks,lc--Lisa R. Clary104 N. Main Street, Suite 
600Gainesville, FL 32601(352) 392-5198 x 312(352) 392-8162 
(fax)-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Lisa R. 
Clary  INET: [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).

Hot Backup.........paths.

[Veronica Levin]

Hi listers,
I'm testing a hot backup script that I want to run overnight, but the only
way I can get it to work is using absolute paths.I don't like it that
way. is there any chance I can use relative paths in this? I tried to
include a change directory but it didn't work.
thanks in advance for your input!

SQL> alter tablespace TEMP begin backup;
SQL> host /bin/tar -cvf /exp_imp/temp.tar /truck_temp/tempPROD1.dbf
SQL> host compress -c /exp_imp/temp.tar>/exp_imp/TEMP_08_aug_01.Z
SQL> alter tablespace TEMP end backup;

f80 root /exp_imp -> tar -vtf temp.tar
-rw-r- 203 11 419438592 Aug 13 13:30:22 2001 /truck_temp/tempPROD1.dbf
f80 root /exp_imp ->

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua

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

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

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

RE: Help SQL

[Mercadante, Thomas F]

Miriam,

Looks like you missed a couple of things:

1).  you do not need outer joins in the EXISTS clauses here - you just need
to know if 
 it EXISTS or NOT - it's ok for it to fail
2).  looks like you are missing an additional AND clause in the EXISTS
clause - you did not
 join it to the main PERSON table.
3).  looks like you are missing a set of parens around all of the OR clauses
in the second
 EXISTS clause.

hope this helps

  DS_NPS.NOTES_INFO NOTES
  WHERE((NOT EXISTS

  (SELECT PES.HPC_ID
   FROM DS_NPS.PERSON_EVENT_STATUS pes
==> remove outer joinWHERE person.HPC_ID = pes.HPC_ID AND
==> remove outer join  pes.EVENT_REFERENCE_VALUE_ID = 4116)) 
  OR (EXISTS
   (SELECT pes.HPC_ID
FROM DS_NPS.PERSON_EVENT_STATUS pes
WHERE pes.EVENT_REFERENCE_VALUE_ID = 4116 
AND pes.STATUS_REFERENCE_VALUE_ID = 1586 
==> added this lineAND person.hpc_id  = pes.HPC_ID
==> added parens aroundAND (nvl(pes.LAST_UPDATE_DATE, '01-Jan-1900')
<
==> all of the OR's  nvl(pes.LAST_UPDATE_DATE,
'02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900')
<
 nvl(DEG1089.LAST_UPDATE_DATE,
'02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900')
<
 nvl(addr1087.LAST_UPDATE_DATE,
'02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900')
<
 nvl(addr1322.LAST_UPDATE_DATE,
'02-Jan-1900')


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, August 13, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L


Hello dear list,
yet again I need some brainpower. Hopefully someone can tell me how to
format this query.
Here's my problem. I'm trying to run the below query to get a record set of
those users that qualify to be phoned, but ONLY if they have never been
phoned before(by not existing on the PERSON_EVENT_STATUS table) OR if the
LAST_UPDATE_DATE of the person, address or degree table is greater than the
LAST_UPDATE_DATE on the PERSON_EVENT_STATUS table, which would indicate that
this records have been modified. My problem is formatting or the ORs, I seem
to get all the right records if they are not found on the
PERSON_EVENT_STATUS table, but if I rerun this query, I still get the same
records, although they now exists on the PERSON_EVENT_STATUS table. (What
I'm I doing wrong? Problem area in RED).

QUERY;

SELECT RPAD(PROJECT_EVENT.PROJECT_EVENT_ID,18) PROJECT_EVENT_ID,
   RPAD(ORG.ORG_ID,18) ORG_ID,
   RPAD(TRANSLATE(ORG.ORG_NAME,'1?|''+& *%,#!@_$123.4567832-','1'),100)
ORG_NAME,
   RPAD(PERSON.HPC_ID,18) HPC_ID,
   RPAD(PERSON.DATA_SET_ID,18) DATA_SET_ID,
   RPAD(NVL(TMKT.SPLIT_CODE,'  '),2) SPLIT_CODE,
   RPAD(NVL(PERSON.PREFIX, ''),20) PREFIX,
   RPAD(PERSON.FIRST_NAME, 50) FIRST_NAME,
   RPAD(TRANSLATE(PERSON.LAST_NAME,'1?|''+& *%,#"!@_$123.4567832-','1'),50)
LAST_NAME,
   RPAD(NVL(PERSON.SUFFIX,''),20) SUFFIX,
   RPAD(NVL(ADDR1087.STREET_LINE_1,'
'),50) STREET_LINE_1,
   RPAD(NVL(ADDR1087.STREET_LINE_2,'
'),50) STREET_LINE_2,
   RPAD(NVL(ADDR1087.CITY, '
'),40)CITY,
   RPAD(NVL(ADDR1087.STATE_CODE,'  '),2) STATE_CODE,
   RPAD(DECODE(ADDR1087.COUNTRY, 'Bermuda','BE','Canada','CA','United
States','US','USA','US',NULL,'US','US'), 2) COUNTRY,
   RPAD(NVL(ADDR1087.ZIP,' '), 9) ZIP,
   RPAD(NVL(ADDR1087.PRIMARY_PHONE_NMBR,'00'),10,'0')
PRIMARY_PHONE_NMBR,
   RPAD(NVL(ADDR1322.PRIMARY_PHONE_NMBR,'00'),10,'0')
SECONDARY_PHONE_NMBR,
 
RPAD(NVL(DECODE(ADDR1087.SECONDARY_PHONE_NMBR,NULL,ADDR1338.PRIMARY_PHONE_NM
BR,ADDR1087.SECONDARY_PHONE_NMBR),'00'),10,'0') OTHER_PHONE,
   PERSON.VIP_IND,
   RPAD(NVL(TO_CHAR(PERSON.DATE_OF_BIRTH,'mmdd'),''),8)
DATE_OF_BIRTH,
   RPAD(NVL(PERSON.GENDER,' '),1) GENDER,
   RPAD(NVL(PERSON.MARITAL_STATUS,'  '), 2) MARITAL_STATUS,
   RPAD(NVL(DEG1089.CLASS_YEAR,''), 4) CLASS_YEAR,
   PERSON.MAIL_RESPONDENT_IND,
   PERSON.OLQ_RESPONDENT_IND,
   PERSON.PREVIOUS_PURCHASER_IND,
   RPAD(NVL(TO_CHAR(PROJECT.LCI_DATE, 'mmdd'),''),8) LCI_DATE,
   RPAD(NVL(PERSON.MARKETING_CODE,''),20)
MARKETING_CODE,
   RPAD(NVL(TMKT.CALL_CENTER,'  '), 2) CALL_CENTER,
   RPAD(NVL(DEG1089.DEGREE_NAME, '
'),50) DEGREE_NAME,
   RPAD(NVL(NOTES.NOTES_DESCR,'
'),100) NOTES_DESCR,
   RPAD(NVL(TMKT.TOLL_FREE_NUMBER,8004553052),10,'0') TOLL_FREE_NUMBER,
   Rpad(NVL(PROJECT.PROJECT_ID,000),18) project_id,
   RPAD('FILLER',30) FILLER,
   RPAD('FILLER',30) FILLER2,
   RPAD('FILLER',30) FILLER3,
 
NVL(TMKT.CALL_CENTER,'VA')||RPAD('0',1)||NVL(TMKT.SPLIT_CODE,'1')||PROJECT.F
INANCE_ORG_CODE||RPAD('FILLER',16) LIST_NAME,
   RPAD(NVL(PROJECT.FINANCE_ORG_CODE,'   '),3) FINANCE_ORG_CODE
  FROM
  DS_NPS.ADDRESS addr1087,
  DS_NPS.ADDRESS a

RE: Datafile/Tablespace creation....

[Mercadante, Thomas F]

Lisa,

yeah, you can either delete the files, or use the REUSE clause in the create
tablespace command.  the REUSE clause will reuse the existing file if it
finds it - if it doesn't find it, it will create it normally.

if you are on NT, you may not be able to delete the file (file is sometimes
locked by the Oracle processs - a re-bounce of the database clears this up).

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, August 13, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L


I attempted to create a new tablespace, but did not have db_files set large
enough and so it aborted the tablespace creation (found this in the alert
log). However, some of the process completed as it did create a datafile.
Now that I have bumped up the db_files parameter what do can I manually
delete the datafile (at the OS level) without repercussion? Nothing
recognizes the datafile (e.g. select * from dba_data_files, OEM, TOAD).

thanks,
lc
--
Lisa R. Clary
104 N. Main Street, Suite 600
Gainesville, FL 32601
(352) 392-5198 x 312
(352) 392-8162 (fax)

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

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

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

[JOE TESTA]

That i dont know for sure, i incorporated so there would be 
less questions from the IRS, got a taxid the whole thing, separate checking 
acct, credit cards, so there is a definite separation between business money and 
personal money.
 
joe
 
 
oh and my original statement should have been a 
question
 
You can't write off training?
 
 
>>> [EMAIL PROTECTED] 08/13/01 04:11PM >>>Joe do 
you actually have to get incorporated or can you just file as aprivate 
business? - E-Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 
Monday, August 13, 2001 12:42 PMTo: Multiple recipients of list 
ORACLE-LYou can't write off training.  you need to get 
incorporated.  I'm a businessentity and if/when the company i work for 
won't pay for training, you canbet it will get written off on my taxes, that 
includes all of the oraclebooks, OCP exams, you name it, it gets deducted as 
a legitimate companyexpense.  2 years ago the company i was 
working for didnt want to send me toopenworld(and I knew i'd be leaving in 
less than 2months anyways), so i atethe cost and wrote the entire trip 
off.joe>>> [EMAIL PROTECTED] 
08/13/01 02:41PM >>>Patrice,There is "resistance" to any 
training that I feel is necessary to further myknowledge and/or enhance my 
understanding of the Oracle processes. Eventhough I have money in the budget 
for such items I have to submit a businesscase defining the gains to the 
company and after completing the course witha passing grade the company will 
reimburse me the expenses for the courseonly. I also have to sign a waver 
that I will pay the company back the fullcost of the course if I leave their 
employment before 365 days. Needless tosay I pay for everything myself and 
hope to write it off on taxes if theyever get the bill signed into 
law.ROR mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 
11:46AM >>>Just out of curiosity, how many days / weeks of real 
training did youremployer provide you with in the last couple of 
years?"real" is in quotes, I don't mean the little 1 - 3 day seminars 
given byCareerTrack and other "training" companies, or management-related 
stuff likelittle MBA-flavoured certificates from universities.Oh, 
and did the amount of training you received match what you were toldduring 
your job interview?Regards,Patrice BoivinSystems Analyst (Oracle 
Certified DBA)Systems Admin & Operations | Admin. et Exploit. des 
systèmesTechnology Services    | 
Services technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | Région 
des Maritimes, MPOE-Mail: [EMAIL PROTECTED] < mailto:[EMAIL PROTECTED] 
> --Please see the official ORACLE-L FAQ: http://www.orafaq.com  
--Author: Boivin, Patrice J  INET: [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).--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-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).--This 
e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from 
disclosure under law.  If you have received this message in error, please 
inform us promptly by reply e-mail, then delete the e-mail and destroy any 
printed copy.   Thank 
you.==--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Post, 
Ethan  INET: [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 O

Datafile/Tablespace creation....

[Lisa R. Clary]

I attempted to create a new tablespace, but did not have db_files set large
enough and so it aborted the tablespace creation (found this in the alert
log). However, some of the process completed as it did create a datafile.
Now that I have bumped up the db_files parameter what do can I manually
delete the datafile (at the OS level) without repercussion? Nothing
recognizes the datafile (e.g. select * from dba_data_files, OEM, TOAD).

thanks,
lc
--
Lisa R. Clary
104 N. Main Street, Suite 600
Gainesville, FL 32601
(352) 392-5198 x 312
(352) 392-8162 (fax)

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

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

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

Help SQL

[Bryan, Miriam]

Hello dear list,
yet again I need some brainpower. Hopefully someone can tell me how to
format this query.
Here's my problem. I'm trying to run the below query to get a record set of
those users that qualify to be phoned, but ONLY if they have never been
phoned before(by not existing on the PERSON_EVENT_STATUS table) OR if the
LAST_UPDATE_DATE of the person, address or degree table is greater than the
LAST_UPDATE_DATE on the PERSON_EVENT_STATUS table, which would indicate that
this records have been modified. My problem is formatting or the ORs, I seem
to get all the right records if they are not found on the
PERSON_EVENT_STATUS table, but if I rerun this query, I still get the same
records, although they now exists on the PERSON_EVENT_STATUS table. (What
I'm I doing wrong? Problem area in RED).

QUERY;

SELECT RPAD(PROJECT_EVENT.PROJECT_EVENT_ID,18) PROJECT_EVENT_ID,
   RPAD(ORG.ORG_ID,18) ORG_ID,
   RPAD(TRANSLATE(ORG.ORG_NAME,'1?|''+& *%,#!@_$123.4567832-','1'),100)
ORG_NAME,
   RPAD(PERSON.HPC_ID,18) HPC_ID,
   RPAD(PERSON.DATA_SET_ID,18) DATA_SET_ID,
   RPAD(NVL(TMKT.SPLIT_CODE,'  '),2) SPLIT_CODE,
   RPAD(NVL(PERSON.PREFIX, ''),20) PREFIX,
   RPAD(PERSON.FIRST_NAME, 50) FIRST_NAME,
   RPAD(TRANSLATE(PERSON.LAST_NAME,'1?|''+& *%,#"!@_$123.4567832-','1'),50)
LAST_NAME,
   RPAD(NVL(PERSON.SUFFIX,''),20) SUFFIX,
   RPAD(NVL(ADDR1087.STREET_LINE_1,'
'),50) STREET_LINE_1,
   RPAD(NVL(ADDR1087.STREET_LINE_2,'
'),50) STREET_LINE_2,
   RPAD(NVL(ADDR1087.CITY, '
'),40)CITY,
   RPAD(NVL(ADDR1087.STATE_CODE,'  '),2) STATE_CODE,
   RPAD(DECODE(ADDR1087.COUNTRY, 'Bermuda','BE','Canada','CA','United
States','US','USA','US',NULL,'US','US'), 2) COUNTRY,
   RPAD(NVL(ADDR1087.ZIP,' '), 9) ZIP,
   RPAD(NVL(ADDR1087.PRIMARY_PHONE_NMBR,'00'),10,'0')
PRIMARY_PHONE_NMBR,
   RPAD(NVL(ADDR1322.PRIMARY_PHONE_NMBR,'00'),10,'0')
SECONDARY_PHONE_NMBR,
 
RPAD(NVL(DECODE(ADDR1087.SECONDARY_PHONE_NMBR,NULL,ADDR1338.PRIMARY_PHONE_NM
BR,ADDR1087.SECONDARY_PHONE_NMBR),'00'),10,'0') OTHER_PHONE,
   PERSON.VIP_IND,
   RPAD(NVL(TO_CHAR(PERSON.DATE_OF_BIRTH,'mmdd'),''),8)
DATE_OF_BIRTH,
   RPAD(NVL(PERSON.GENDER,' '),1) GENDER,
   RPAD(NVL(PERSON.MARITAL_STATUS,'  '), 2) MARITAL_STATUS,
   RPAD(NVL(DEG1089.CLASS_YEAR,''), 4) CLASS_YEAR,
   PERSON.MAIL_RESPONDENT_IND,
   PERSON.OLQ_RESPONDENT_IND,
   PERSON.PREVIOUS_PURCHASER_IND,
   RPAD(NVL(TO_CHAR(PROJECT.LCI_DATE, 'mmdd'),''),8) LCI_DATE,
   RPAD(NVL(PERSON.MARKETING_CODE,''),20)
MARKETING_CODE,
   RPAD(NVL(TMKT.CALL_CENTER,'  '), 2) CALL_CENTER,
   RPAD(NVL(DEG1089.DEGREE_NAME, '
'),50) DEGREE_NAME,
   RPAD(NVL(NOTES.NOTES_DESCR,'
'),100) NOTES_DESCR,
   RPAD(NVL(TMKT.TOLL_FREE_NUMBER,8004553052),10,'0') TOLL_FREE_NUMBER,
   Rpad(NVL(PROJECT.PROJECT_ID,000),18) project_id,
   RPAD('FILLER',30) FILLER,
   RPAD('FILLER',30) FILLER2,
   RPAD('FILLER',30) FILLER3,
 
NVL(TMKT.CALL_CENTER,'VA')||RPAD('0',1)||NVL(TMKT.SPLIT_CODE,'1')||PROJECT.F
INANCE_ORG_CODE||RPAD('FILLER',16) LIST_NAME,
   RPAD(NVL(PROJECT.FINANCE_ORG_CODE,'   '),3) FINANCE_ORG_CODE
  FROM
  DS_NPS.ADDRESS addr1087,
  DS_NPS.ADDRESS addr1322,
  DS_NPS.ADDRESS addr1338,
  DS_NPS.PERSON PERSON,
  DS_NPS.DEGREE DEG1089,
  DS_NPS.TMKT_SPLIT TMKT,
  DS_NPS.DATA_SET DATA_SET,
  DS_NPS.PROJECT PROJECT,
  DS_NPS.PROJECT_EVENT PROJECT_EVENT,
  DS_NPS.ORGANIZATION ORG,
  DS_NPS.NOTES_INFO NOTES
  WHERE((NOT EXISTS

  (SELECT PES.HPC_ID
   FROM DS_NPS.PERSON_EVENT_STATUS pes
   WHERE person.HPC_ID = pes.HPC_ID (+) AND
   pes.EVENT_REFERENCE_VALUE_ID (+) = 4116)) OR 
 (EXISTS
   (SELECT pes.HPC_ID
FROM DS_NPS.PERSON_EVENT_STATUS pes
WHERE pes.EVENT_REFERENCE_VALUE_ID = 4116 
AND pes.STATUS_REFERENCE_VALUE_ID = 1586 AND
nvl(pes.LAST_UPDATE_DATE, '01-Jan-1900') <
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900') <
nvl(DEG1089.LAST_UPDATE_DATE, '02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900') <
nvl(addr1087.LAST_UPDATE_DATE, '02-Jan-1900') OR
nvl(pes.LAST_UPDATE_DATE, '02-Jan-1900') <
nvl(addr1322.LAST_UPDATE_DATE, '02-Jan-1900'

 AND TRUNC(SYSDATE) BETWEEN TRUNC(PROJECT.OB_START_DATE -5) AND
TRUNC(PROJECT.LCI_DATE + 5)
  AND  PERSON.DUPLICATE_IND = 'N'
  AND (TMKT.CALL_CENTER <> ' '
   OR TMKT.CALL_CENTER IS NOT NULL)
  AND (TMKT.SPLIT_CODE <> ' '
   OR TMKT.SPLIT_CODE IS NOT NULL)
  AND (PERSON.DO_NOT_CALL_STATUS = ' '
  OR PERSON.DO_NOT_CALL_STATUS IS NULL)
  AND PERSON.REQUESTED_OMIT_IND = 'N'
  AND (NVL(addr1087.CITY,'*') NOT LIKE 'APO%'
  AND NVL(addr1087.CITY,'*') NOT LIKE 'FPO%')
  AND (addr1087.COUNTRY is null
   or addr1087.COUNTRY IN('CA','BE','US')
  AND (addr1087.PRIMARY_PHONE_NMBR is not null
   or addr1322.PRIMARY_PHONE_NMBR is not null
   or addr1087.PRIMARY_PHONE_NM

Re: OT -- training

[Rachel Carmichael]

SEOUC instead of ECO :)




>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OT -- training
>Date: Mon, 13 Aug 2001 11:30:38 -0800
>
>Well i get to go to IOUG every year(even if i wasn't presenting), i bypass 
>on openworld and was hoping to do the ECO thing before they went under :(
>
>joe
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Monday, August 13, 2001 10:46 AM
>
>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
>CareerTrack and other "training" companies, or management-related stuff 
>like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED] 
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bill Gentry
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

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

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

RE: OT -- training

[Adams, Matthew (GEA, 088130)]

Either to 
don't need to incorporate, or my 
tax 
accountant lied to me,  I don't know
which, but I 
have written off training
and IOUG-A 
trips (that were paid for 100% by
me) while I 
was an employee of
a consulting 
firm.
 
(Is that the 
IRS I hear knocking?)
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is 
like   trying to club someone to 
death with a loaded Uzi.  
- Larry Wall (creator of Perl) 
 

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 3:42 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OT -- training
  You can't write off training.  you need to get 
  incorporated.  I'm a business entity and if/when the company i work for 
  won't pay for training, you can bet it will get written off on my taxes, that 
  includes all of the oracle books, OCP exams, you name it, it gets deducted as 
  a legitimate company expense.  
   
  2 years ago the company i was working for didnt want to send 
  me to openworld(and I knew i'd be leaving in less than 2months anyways), so i 
  ate the cost and wrote the entire trip off.
   
  joe
   
   
   
  >>> [EMAIL PROTECTED] 08/13/01 02:41PM 
  >>>Patrice,There is "resistance" to any training that I feel 
  is necessary to further my knowledge and/or enhance my understanding of the 
  Oracle processes. Even though I have money in the budget for such items I have 
  to submit a business case defining the gains to the company and after 
  completing the course with a passing grade the company will reimburse me the 
  expenses for the course only. I also have to sign a waver that I will pay the 
  company back the full cost of the course if I leave their employment before 
  365 days. Needless to say I pay for everything myself and hope to write it off 
  on taxes if they ever get the bill signed into law.ROR mª¿ªm 
  >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
  >>>Just out of curiosity, how many days / weeks of real training 
  did youremployer provide you with in the last couple of 
  years?"real" is in quotes, I don't mean the little 1 - 3 day seminars 
  given byCareerTrack and other "training" companies, or management-related 
  stuff likelittle MBA-flavoured certificates from universities.Oh, 
  and did the amount of training you received match what you were toldduring 
  your job interview?Regards,Patrice BoivinSystems Analyst 
  (Oracle Certified DBA)Systems Admin & Operations | Admin. et 
  Exploit. des systèmesTechnology 
  Services    | Services 
  technologiquesInformatics 
  Branch | Direction de 
  l'informatique Maritimes Region, DFO  | 
  Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]  
  --Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: 
  Boivin, Patrice J  INET: [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).--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-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: OT -- training

[Post, Ethan]

Joe do you actually have to get incorporated or can you just file as a
private business? - E

-Original Message-
From: JOE TESTA [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L


You can't write off training.  you need to get incorporated.  I'm a business
entity and if/when the company i work for won't pay for training, you can
bet it will get written off on my taxes, that includes all of the oracle
books, OCP exams, you name it, it gets deducted as a legitimate company
expense.  
 
2 years ago the company i was working for didnt want to send me to
openworld(and I knew i'd be leaving in less than 2months anyways), so i ate
the cost and wrote the entire trip off.
 
joe
 
 
 


>>> [EMAIL PROTECTED] 08/13/01 02:41PM >>>
Patrice,
There is "resistance" to any training that I feel is necessary to further my
knowledge and/or enhance my understanding of the Oracle processes. Even
though I have money in the budget for such items I have to submit a business
case defining the gains to the company and after completing the course with
a passing grade the company will reimburse me the expenses for the course
only. I also have to sign a waver that I will pay the company back the full
cost of the course if I leave their employment before 365 days. Needless to
say I pay for everything myself and hope to write it off on taxes if they
ever get the bill signed into law.
ROR mª¿ªm 

>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] < mailto:[EMAIL PROTECTED]
 > 

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

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

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



--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

==

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

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

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

Re: RAID or NOT to RAID? What's the diff???

[Jonathan Lewis]

And if it does confuse you, my book has 
a couple of pretty pictures in it that might
help.

Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 13 August 2001 20:04
|
|Hope this doesn't confuse you more.
|
|-steve
|


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

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

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

[dgoulet]

Dave,

First, hope your father gets better fast.  Sounds like you could use some
good news.  But now that you found out about "database recovery in the hot seat"
give the network admin the "You'sa in a deep doo-doo now" for not having done
his/her part.

Dick Goulet

Reply Separator
Author: "Farnsworth; Dave" <[EMAIL PROTECTED]>
Date:   8/13/2001 10:52 AM

Never mind.  I found the "recover database" command.  It worked like a
charm!!  The network admin was happy too!!

Dave

-Original Message-
Sent: Monday, August 13, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L


I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

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

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

[Christopher Spence]

Very common what you explained.

I think businesses are afraid to do training as they think you will become
more marketable and opt to leave.
If they are afraid of that, they should fix the problems or give more money
to make it so you would not want to leave.  If they themselves think your
going to leave because of training, they must already know it sucks and they
should fix it.

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 13, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L


Patrice,
 There is "resistance" to any training that I feel is necessary to further
my knowledge and/or enhance my understanding of the Oracle processes. Even
though I have money in the budget for such items I have to submit a business
case defining the gains to the company and after completing the course with
a passing grade the company will reimburse me the expenses for the course
only. I also have to sign a waver that I will pay the company back the full
cost of the course if I leave their employment before 365 days. Needless to
say I pay for everything myself and hope to write it off on taxes if they
ever get the bill signed into law. ROR mª¿ªm 

>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

RE: CLOBs storage vs Varchar storage

[Jack C. Applewhite]

Rick,

If the CLOB is <4KB and stored inline with the table, then it takes up only
as much space as it needs - much like a VarChar2.  If the CLOB is stored
out-of-line in a LOB segment, it takes at least one, possibly many more,
Oracle DB Blocks, depending on your specification of "Chunk" in the Create
Table command.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
T (Richard)
Sent: Monday, August 13, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I am resending this question as I cannot find the answer

>  CLOBs vs VARCHAR.  If a varchar datatype is not completely used it will
> not allocate storage for what is was defined.
>   Does a CLOB data type use entire storage if not completely used?
>
> Thanks
> Rick

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

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

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

RE: OT -- training

[Christopher Spence]

Hey good idea.

I am going to write an expense report for all the time I spent reading and
payable due to "Christopher R. Spence Training Facility".  

I am going to be rich!

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



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


Better than that... training... read the PDFs and claim training hours for
reading them... preferably charged to another department if possible.

-Original Message-
Sent: Monday, August 13, 2001 1:38 PM
To: Multiple recipients of list ORACLE-L


HA HA HA HA

YEA FREAKIN RIGHT

Seven monthsno training...none scheduled."3000 dollar budget" which
is one (1) oracle course.not great.

HA HA HA HA

-Original Message-
Sent: Monday, August 13, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: Monday, August 13, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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



The information contained in this e-mail is strictly confidential and for
the intended use of the addressee only; it may also be legally privileged
and/or price sensitive.  Notice is hereby given that any disclosure, use or
copying of the information by anyone other than the intended recipient is
prohibited and may be illegal.  If you have received this message in error,
please notify the sender immediately by return e-mail.

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

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

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

Re: OT -- training

[JOE TESTA]

You can't write off training.  you need to get 
incorporated.  I'm a business entity and if/when the company i work for 
won't pay for training, you can bet it will get written off on my taxes, that 
includes all of the oracle books, OCP exams, you name it, it gets deducted as a 
legitimate company expense.  
 
2 years ago the company i was working for didnt want to send 
me to openworld(and I knew i'd be leaving in less than 2months anyways), so i 
ate the cost and wrote the entire trip off.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 08/13/01 02:41PM 
>>>Patrice,There is "resistance" to any training that I feel is 
necessary to further my knowledge and/or enhance my understanding of the Oracle 
processes. Even though I have money in the budget for such items I have to 
submit a business case defining the gains to the company and after completing 
the course with a passing grade the company will reimburse me the expenses for 
the course only. I also have to sign a waver that I will pay the company back 
the full cost of the course if I leave their employment before 365 days. 
Needless to say I pay for everything myself and hope to write it off on taxes if 
they ever get the bill signed into law.ROR mª¿ªm >>> 
[EMAIL PROTECTED] 08/13/01 11:46AM >>>Just out of 
curiosity, how many days / weeks of real training did youremployer provide 
you with in the last couple of years?"real" is in quotes, I don't mean 
the little 1 - 3 day seminars given byCareerTrack and other "training" 
companies, or management-related stuff likelittle MBA-flavoured certificates 
from universities.Oh, and did the amount of training you received match 
what you were toldduring your job interview?Regards,Patrice 
BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & 
Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | Région 
des Maritimes, MPOE-Mail: [EMAIL PROTECTED]  
--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Boivin, 
Patrice J  INET: [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).--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-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: OT -- training

[JOE TESTA]

Well i get to go to IOUG every year(even if i wasn't presenting), i bypass 
on openworld and was hoping to do the ECO thing before they went under :(
 
joe
 
 
- Original Message -To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>Sent: Monday, August 13, 2001 10:46 
AMJust out of curiosity, how many days / weeks of real training did 
youremployer provide you with in the last couple of years?"real" is 
in quotes, I don't mean the little 1 - 3 day seminars given byCareerTrack 
and other "training" companies, or management-related stuff likelittle 
MBA-flavoured certificates from universities.Oh, and did the amount of 
training you received match what you were toldduring your job 
interview?Regards,Patrice BoivinSystems Analyst (Oracle 
Certified DBA)Systems Admin & Operations | Admin. et Exploit. des 
systèmesTechnology Services    | 
Services technologiquesInformatics 
Branch | Direction de 
l'informatiqueMaritimes Region, DFO  | Région 
des Maritimes, MPOE-Mail: [EMAIL PROTECTED] --Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Boivin, 
Patrice J  INET: [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).-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Bill Gentry  INET: [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: Deep Doo-Doo

[Farnsworth, Dave]

Ron,

Thanks, I opened a TAR with Oracle and their support person gave the
solution in a fairly quick manner.  I used the "recover database" command.
My database came back up and is running fine now.  The network admin is
happy to!!  I'll bet that there will ba a tape backup tomorrow!!!

Dave

-Original Message-
Sent: Monday, August 13, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


Dave,
I hope all is okay with your father.
It sounds like you still have some datafiles that are still under the
control of the os backup script. If you did a cold backup and it was still
hung, who started the database up where you had to shutdown abort? Did the
alert log show any problems with the startup after the backup time? Was the
database shutdown to do the backup?
Dig deep and good luck.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/13/01 02:10PM >>>
I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

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

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

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

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

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

RE: OT -- training

[Christopher Spence]

0

No it didn't match.
Besides one company, I have yet to accomplish any training.  Hense my heavy
spending on books.
Although I hardly ask as I know the answers.

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 13, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: Monday, August 13, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

RE: OT -- training

[Post, Ethan]

You could create a web site that features some technical materials and use
it to advertise your services if you are willing to moonlight on a few jobs,
just enough to turn a profit within a couple years.  Then I would presume
you would have no trouble writing the training off as a legitimate biz
expense.

- Ethan
- http://www.geocities.com/epost1

>-Original Message-
>From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 13, 2001 11:42 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: OT -- training
>
>
>Patrice,
> There is "resistance" to any training that I feel is 
>necessary to further my knowledge and/or enhance my 
>understanding of the Oracle processes. Even though I have 
>money in the budget for such items I have to submit a business 
>case defining the gains to the company and after completing 
>the course with a passing grade the company will reimburse me 
>the expenses for the course only. I also have to sign a waver 
>that I will pay the company back the full cost of the course 
>if I leave their employment before 365 days. Needless to say I 
>pay for everything myself and hope to write it off on taxes if 
>they ever get the bill signed into law.
>ROR mª¿ªm 
>
 [EMAIL PROTECTED] 08/13/01 11:46AM >>>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day 
>seminars given by
>CareerTrack and other "training" companies, or 
>management-related stuff like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you 
>were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique 
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED]  
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Boivin, Patrice J
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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).
>

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

==

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

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

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

RE: OT -- training

[April Wells]

Better than that... training... read the PDFs and claim training hours for
reading them... preferably charged to another department if possible.

-Original Message-
Sent: Monday, August 13, 2001 1:38 PM
To: Multiple recipients of list ORACLE-L


HA HA HA HA

YEA FREAKIN RIGHT

Seven monthsno training...none scheduled."3000 dollar budget" which
is one (1)
oracle course.not great.

HA HA HA HA

-Original Message-
Sent: Monday, August 13, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: Monday, August 13, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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



The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

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

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

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

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

Re: RAID or NOT to RAID? What's the diff???

[Steve Armijo]

On Mon, Aug 13, 2001 at 08:05:42AM -0800, Koivu, Lisa wrote:
 
> Admitting ignorance here.  What is the difference between Raid 0+1 and Raid
> 1+0  (is this mirroring)?  If someone can forward a website that describes
> the difference I would really appreciate it.

0 + 1 or 1 + 0 is determined by which type you lay down first.  


RAID 0 is striping.  
So in a simple example of 2 disks, when you lay down the initial RAID you 
create stripes of a given size across both disks.  Say you have 2 1GB
disks.  If your stripe size was 1MB ( ridiculously large ) you would have
2048 stripes, 512k of each stripe would be written across each disk.  2GB of
space would be useable.  If one disk fails you lose the entire striped set.

RAID 1 is mirroring.
If you were to mirror the same 2 disks then each should be an identical copy
of the other.  So once data was written to one disk it would also appear on the 
other.  In this setup ( given the same 2 tiny disks ) only 1GB would be
useable.  This is almost always a 1:1 operation.  Generally speaking you
wouldn't mirror a disk to more than one disk.  If one disk fails the system
keeps operating on the remaining disk

RAID 0 + 1 is Mirrored Stripes.
Now, given the above, say you have 6 disks each of 1GB.  In the 0+1 scenario 
you would divide your disks into 2 groups of 3 disks each.  Create 2 RAID 0
sets of 3 disks each.  Each of these stripes is 3GB.

Here's a bad ASCII drawing:

0   0
|   |
0   0
|   |
0   0

Now, you lay down RAID 1 across the stripes.  This way if a disk in either 
stripe ( and hence the entire stripe ) fails, the system will continue
operating using the remaining stripe.  When the failed disk is replaced the
system has to resync the entire stripe, potentially 3GB if the stripe is full.
Total available space is 3GB

Here's another ASCII drawing trying to picture the above.

0   0
|   |
0 <-1-> 0
|   |
0   0

RAID 1+0 is Striped Mirrors.
So again, 6 disks.  This time you mirror first.  You divide your 6 disks into
groups of 3, and mirror across them.

Again with the ASCII

1-1

1-1

1-1

Now you stripe across the mirrors.  Remember the stripes are divided by the
number of targets in the stripe, so given 1MB stripes, each disk will contain
roughtly 341K.  If a disk dies, that disks mirror takes over and assuming the
worst case of a full stripe when the failed disk is swapped out, you will 
have to wait for 1GB to resync.  Total available space is 3GB

Last ASCII I swear ;)

1-1
 |
 0
 |
1-1
 |
 0
 |
1-1

Hope this doesn't confuse you more.

-steve

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

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

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

Re: CLOBs storage vs Varchar storage

[Jonathan Gennick]

Monday, August 13, 2001, 1:50:28 PM, Clark wrote:
>>  CLOBs vs VARCHAR.  If a varchar datatype is not completely used it will
>> not allocate storage for what is was defined.
>>   Does a CLOB data type use entire storage if not completely used?

No. If you think about it long enough, you'll realize that
could never be the case. When you define a CLOB, you don't
specify a maximum length as you do when you define a
VARCHAR2. The max length of any CLOB column, therefore, is
the max length of a CLOB period, which is 4 gigabytes. A
CLOB column would not be of much use if every small value
that you put into it took up an entire 4 gigs. Some simple
testing will show you that is not the case.

Best regards,

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

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

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

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

RE: Deep Doo-Doo

[Kevin Lange]

The unable to write to   might simply be because another process has it
... i.e. the backup process.

You need to find out if the file is open by another process.   If its
possible, kill that hold.



-Original Message-
Sent: Monday, August 13, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L


I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

[Viktor]

I love the quote beneath your message!
It's so true.


--- Christopher Spence <[EMAIL PROTECTED]> wrote:
> There are many many answers to your question.
> And it all lies in what your trying to accomplish.
> 
> As a general rule, packages perform better than
> procedures are the entire
> package is loaded.
> PL/SQL is slower than SQL in due to the context
> switches and "calls" to sql
> parser, although these can be minmized by using bulk
> transactions and other
> features.  
> Java procedures out perform plsql when it is heavily
> computational.
> PL/SQL out performs Java procedures when it is
> heavily transactional
> OCI calls being one of lowest levels are of course
> very efficient.
> 
> The performance differences can be milliseconds or
> it can be hours depending
> what is trying to be accomplished.
> 
> "Do not criticize someone until you walked a mile in
> their shoes, that way
> when you criticize them, you are a mile a way and
> have their shoes."
> 
> Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> 
> -Original Message-
> Sent: Monday, August 13, 2001 11:21 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In the process of making a design decision, I'm
> looking for information on
> the relative performance of PL/SQL stored procedures
> / packages vs. both
> Pro*C / OCI SQL calls and Java stored procedures. 
> All things being equal,
> let's say for DML calls with little or not
> procedural logic, what technique
> is likely to yield the best performance, and how
> much of a performance
> difference exists?  In the case of PL/SQL vs. SQL,
> is the advantage of
> centralization overshadowed by a performance hit? 
> In the case of PL/SQL vs.
> Java, is the advantage of a more "standard" and
> widely-used language among
> application developers similarly negated by a
> performance disadvantage?
> 
> I'm interested in hearing opinions based on both
> theoretical and empirical
> information.  Thanks.
> 
> Paul Baumgartel
> MortgageSight Holdings, LLC
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

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

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

RE: Deep Doo-Doo

[Farnsworth, Dave]

Never mind.  I found the "recover database" command.  It worked like a
charm!!  The network admin was happy too!!

Dave

-Original Message-
Sent: Monday, August 13, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L


I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

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

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

RE: X$_kglcursor.kglnaobj

[MacGregor, Ian A.]

No, 
there are no objects with names which start with "table_"  in the 
database.
 
Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 9:21 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  X$_kglcursor.kglnaobjIan         
  These rows relate to the library cache pin on the metadata about the objects. 
  Metadata for the objects need to be pinned during the execution of the 
  statement to prevent the invalidation of the dependent objects. Since each one 
  of this sid has this object pinned, I think, you have objects with these names 
  in your database. Does your database have these objects ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle 
  DBAi2 technologies   www.i2.com 
  


  
  "MacGregor, Ian A." 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
08/10/01 06:45 PM Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:       
 X$_kglcursor.kglnaobjI use the following statment when monitoring the 
  databaseselect   sid, s.username,s.osuser,   c.kglnaobj from 
    sys.x$_kglpn  p,   sys.x$_kglcursor  c,   
  v$_session  swhere   p.kglpnhdl = c.kglhdadr and   
  p.kglpnses = s.saddr;Here is some output showing sid and 
  kglnaobj:      28table_1_0_116_0_0_  
      80SELECT 
  LOC,RACK,SLOT,ELE,CONNNUM,PIN,RLOC,RRACK,RELE,RSLOT,RCONNNUM,RPIN FROM 
  CAPTAR.LINKTERM WHERE(LOC=:1) and (RACK=:2) and (CONNNUM=:3) and (PIN LIKE 
  '%L') order by loc, rack, ele, slot, connnum,orderpin, pin  
      28table_1_0_112_0_0_      
  28table_1_0_11a_0_0_      
  82table_1_0_112_0_0_      
  28table_1_0_11a_0_0_      
  82table_1_0_112_0_0_What is the meaning of  the lines 
  which start with "table_"?Ian MacGregorStanford Linear Accelerator 
  Center[EMAIL PROTECTED]-- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com-- Author: MacGregor, Ian A. INET: 
  [EMAIL PROTECTED]Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-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: OT -- training

[Deshpande, Kirti]

They promised a total of 10 days of Training per calendar year when I was
interviewed. And I received all of it for the past 4 years (even in my 1st
partial year).  It is up to us to use those 10 days as we please. Either go
to conferences or any combination of conference days + Oracle ILT days. If
the project needs more education in Oracle Technologies, then it can be also
arranged as a part of the new project cost and support. I have received that
as well. 

HTH,

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

> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 10:47 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT -- training
> 
> Just out of curiosity, how many days / weeks of real training did your
> employer provide you with in the last couple of years?
> 
> "real" is in quotes, I don't mean the little 1 - 3 day seminars given by
> CareerTrack and other "training" companies, or management-related stuff
> like
> little MBA-flavoured certificates from universities.
> 
> Oh, and did the amount of training you received match what you were told
> during your job interview?
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique 
> Maritimes Region, DFO  | Région des Maritimes, MPO
> 
> E-Mail: [EMAIL PROTECTED]  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: RAID or NOT to RAID? What's the diff???

[Kevin Lange]

Title: RAID or NOT to RAID? What's the diff???



Take a 
look at http://www.acnc.com    
Choose the raid.edu item on their menu bar (I think this brings you to http://www.acnc.com/04_00.html ) 
.    Read the explainations.

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 
  11:06 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RAID or NOT to RAID? What's the diff???
  Good morning - 
  Admitting ignorance here.  What 
  is the difference between Raid 0+1 and Raid 1+0  (is this 
  mirroring)?  If someone can forward a website that describes the 
  difference I would really appreciate it.
  Thanks Lisa Koivu Oracle Database 
  Administrator Fairfield Resorts, Inc. 
  954-935-4117 
  
-Original Message- From:   Jonathan Lewis [SMTP:[EMAIL PROTECTED]] Sent:   Saturday, August [Koivu, Lisa]  11, 2001 4:25 AM To: Multiple recipients of list ORACLE-L Subject:    Re: Fwd: RE: RAID or NOT to RAID? 
You could also mention that when you have 
to resilver on RAID 1+0 after a disk 
fails, you only have to resilver one 
disk. 
On RAID 0+1 you have to resilver all the 
disc in the stripe. 
Jonathan Lewis 
Seminars on getting the best out of Oracle 
Last few places available for Sept 
10th/11th See http://www.jlcomp.demon.co.uk/seminar.html 

-Original Message- To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> Date: 11 
August 2001 01:13 
| |For e.g, if 
you have a 2-way striped mirrored volume, |when you lose 1 drive in the volume, with RAID 0+1 you 
|will lose 50% of the logical volume's I/O 
capacity, as |the whole member of the 
logical volume is shot, |because the 
stripe becomes totally invalid. With a |comparable configuration using RAID 1+0, you will lose 
|only 25% of your logical volume's I/O capacity. 
| |When the striped volume is a 4-way stripe, again with 
|1 drive loss, with RAID 0+1 you will lose 50% 
of I/O |capacity versus with RAID 1+0, 
you will only lose 12 |1/2 %. As your 
stripe-width increases, the percentage |loss in the I/O capacity for RAID 1+0 decreases. | |You should (when 
possible) consider using RAID 1+0 any |day when compared to RAID 0+1. 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 
Lewis   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, send 
an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (or the name of mailing 
list you want to be removed from).  You may also send the HELP command for other information (like 
subscribing). 

Re: OT -- training

[Bill Gentry]

Other than my initial Oracle training in 1999 [31 days], I have been getting
5 days in 2000 & 5 days for the current year.
HTH
---Bill


Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 10:46 AM


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 

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

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

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

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

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

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

RE: Stored procedure performance

[Christopher Spence]

There are many many answers to your question.
And it all lies in what your trying to accomplish.

As a general rule, packages perform better than procedures are the entire
package is loaded.
PL/SQL is slower than SQL in due to the context switches and "calls" to sql
parser, although these can be minmized by using bulk transactions and other
features.  
Java procedures out perform plsql when it is heavily computational.
PL/SQL out performs Java procedures when it is heavily transactional
OCI calls being one of lowest levels are of course very efficient.

The performance differences can be milliseconds or it can be hours depending
what is trying to be accomplished.

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 13, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L


In the process of making a design decision, I'm looking for information on
the relative performance of PL/SQL stored procedures / packages vs. both
Pro*C / OCI SQL calls and Java stored procedures.  All things being equal,
let's say for DML calls with little or not procedural logic, what technique
is likely to yield the best performance, and how much of a performance
difference exists?  In the case of PL/SQL vs. SQL, is the advantage of
centralization overshadowed by a performance hit?  In the case of PL/SQL vs.
Java, is the advantage of a more "standard" and widely-used language among
application developers similarly negated by a performance disadvantage?

I'm interested in hearing opinions based on both theoretical and empirical
information.  Thanks.

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Deep Doo-Doo

[Ron Rogers]

Dave,
I hope all is okay with your father.
It sounds like you still have some datafiles that are still under the control of the 
os backup script. If you did a cold backup and it was still hung, who started the 
database up where you had to shutdown abort? Did the alert log show any problems with 
the startup after the backup time? Was the database shutdown to do the backup?
Dig deep and good luck.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/13/01 02:10PM >>>
I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

--
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: Deep Doo-Doo

[Rocky Welch]

Hi Dave,
Are you in archive log mode?

-Rocky

--- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote:
> I have a very bad situation.  When I got in this morning I saw that the
> nightly backup was hung up.  I do a cold backup to another server and
> then
> the network admins backup my backup to tape.  I did a shutdown abort and
> then restarted my database.  But during the startup I got this in my
> alrt.log
> 
> EMN0 started with pid=19
> Mon Aug 13 06:46:23 2001
> KCF: write/open error block=0x1c75 online=1
>  file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write
> to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 457
> Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG
> 
> I also had a oradim.txt file created with this info;
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 8 needs media recovery
> ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> Now comes the good part.  Guess what part of the backup process was not
> scheduled as it should have been.  That's right, the tape backups!!  The
> network admins never scheduled my data for backup to tape.  All I have
> is
> last nights backups which are no good.  I opened a TAR but if any of you
> have any ideas I can try, I'm open for anything.  My database is down.
> I also just heard that my father is hospitalized.  Today really sucks!!
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

RE: RECOVERY

[JOE TESTA]

point in time recovery:
 
1.  restore all datafiles to some time BEFORE you want to 
stop recovery.
2.  recover until (let you look this one up, hint 
probably use time, unless you know the SCN).
3.  open database w/resetlogs option.
 
here is the catch, if you're in noarchivelogmode, all of the 
transactions have to be in the current logs.  definition of current logs is 
they can't have been reused, wrapped, however you want to call it.
 
Example:  I'm restoring a fullbackup from 2 days 
ago,  our redologs are 100M, as i look the timestamps, we've only done 1 
logswitch since the backup, in that case, it will work but if you've used up all 
of the logs and wrapped around, the previous wont help at all.
 
if you want to talk further about it and you have IM, catch me 
at IM screename joen8xct.
 
joe
 
>>> [EMAIL PROTECTED] 08/13/01 02:16PM 
>>>Hi DBA's here is another scenario,I'm trying to recover 
a database from a cold O/S backup onto another NT machine. The source 
database was running in NOARCHIVELOG Mode.I guesss the backup was not taken 
at a consistent state because when I tried to open the database, Oracle 
asked for Archive Log#13.I realized that I don't have the Archived Log 
because the source database was running in NOARCHIVELOG mode. I think I 
copied the online REDO logs as well though.I changed the status on the 
source database to ARCHIVELOG mode in an attempt to write Archive Log#13 to 
disk.I made a mistake at the command line and ended up overwriting the 
online log#13 anyway. I ended up writing Archive Log#14 to disk.Of 
course Log#14 is useless because the destination system requires Log#13.I 
did some reading over the weekend and found out the following:If the 
Archived REDO Log that Oracle needs to complete recovery of a database is 
unavailable, I believe I can use Point in Time Recovery.I've never tested 
this scenario before. What approach is best?How can I determine what is the 
appropriate time to recover to?Thanks in 
advance,Regards,Denmark Weatherburne"Knowledge is power, but 
it is only useful if it is shared.">From: Raj Gopalan 
<[EMAIL PROTECTED]>>To: "LazyDBA.com Discussion" 
<[EMAIL PROTECTED]>>Subject: RE: RECOVERY>Date: Tue, 7 
Aug 2001 10:03:00 +0100>>Use recover until option and enter cancel 
when oracle asks for the >corrupted>archive log. You need to open 
the database with resetlogs.>>-Original 
Message->From: Brian Zelli [mailto:[EMAIL PROTECTED]]>Sent: 
06 August 2001 17:48>To: LazyDBA.com Discussion>Subject: 
RECOVERY>>>Hello all,>    HELP!  
I have a system (oracle 8.1.7 on SUN Solaris 7) that crashed. I>have no 
backup.  I can't seem to recover it.  I called oracle support 
and>they kept hammering on the fact that I needed to re-apply the last 
cold.  >As>I mentioned to him, we have no backup.  I 
tried to recover the database and>it doesn't like that.  I know 
which archive log is corrupted.  How do I get>to a point in time 
just before that log and bring up the 
database?>>Brian>>>>Oracle 
documentation is here:>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage>To 
unsubscribe: send a blank email to [EMAIL PROTECTED]>To 
subscribe:   send a blank email to 
[EMAIL PROTECTED]>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl>Tell 
yer mates about http://www.farAwayJobs.com>By using 
this list you agree to these>terms:http://www.lazydba.com/legal.html>>>Oracle 
documentation is here: >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage>To 
unsubscribe: send a blank email to [EMAIL PROTECTED]>To 
subscribe:   send a blank email to 
[EMAIL PROTECTED]>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl>Tell 
yer mates about http://www.farAwayJobs.com>By using 
this list you agree to these >terms:http://www.lazydba.com/legal.html>_Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Denmark 
Weatherburne  INET: [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: Deep Doo-Doo

[Rodd Holman]

Dave,
First thing I always look at on this is directory/file ownership and
permissions.  Make sure that Oracle can write there.  This is obviously
NT.  Check your disk administrator tool.  I have (in the past) seen
where NT on a reboot reassigns drive letters to the various drives (D
becomes E, F becomes G, etc.).  If that is the case, make sure that all
the oracle services are down and then use the disk admin to reassign the
drive letters correctly.

HTH

If you don't mind I'll keep you and your father in prayre today also.

Rodd Holman

On 13 Aug 2001 10:10:28 -0800, Farnsworth, Dave wrote:
> I have a very bad situation.  When I got in this morning I saw that the
> nightly backup was hung up.  I do a cold backup to another server and then
> the network admins backup my backup to tape.  I did a shutdown abort and
> then restarted my database.  But during the startup I got this in my
> alrt.log
> 
> EMN0 started with pid=19
> Mon Aug 13 06:46:23 2001
> KCF: write/open error block=0x1c75 online=1
>  file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 457
> Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG
> 
> I also had a oradim.txt file created with this info;
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 8 needs media recovery
> ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> Now comes the good part.  Guess what part of the backup process was not
> scheduled as it should have been.  That's right, the tape backups!!  The
> network admins never scheduled my data for backup to tape.  All I have is
> last nights backups which are no good.  I opened a TAR but if any of you
> have any ideas I can try, I'm open for anything.  My database is down.
> I also just heard that my father is hospitalized.  Today really sucks!!
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
(605) 988-1373
[EMAIL PROTECTED]



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

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

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

Re: RAID or NOT to RAID? What's the diff???

[Denmark Weatherburne]

Hi,

>From an article by Gaja Krishna Vaidyanatha:
RAID 0+1 = "Stripe First, Then Mirror What You Just Striped"
RAID 1+0 = "Mirror First, Then Stripe Over What You Just Mirrored".

This site was recommended:
http://www.quest.com/whitepapers/

Hope this helps,

Denmark W.


>From: "Koivu, Lisa" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RAID or NOT to RAID?  What's the diff???
>Date: Mon, 13 Aug 2001 08:05:42 -0800
>
>Good morning -
>
>Admitting ignorance here.  What is the difference between Raid 0+1 and Raid
>1+0  (is this mirroring)?  If someone can forward a website that describes
>the difference I would really appreciate it.
>
>Thanks
>Lisa Koivu
>Oracle Database Administrator
>Fairfield Resorts, Inc.
>954-935-4117
>
>
> > -Original Message-
> > From:   Jonathan Lewis [SMTP:[EMAIL PROTECTED]]
> > Sent:   Saturday, August [Koivu, Lisa]  11, 2001 4:25 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: Fwd: RE: RAID or NOT to RAID?
> >
> >
> > You could also mention that when you have
> > to resilver on RAID 1+0 after a disk fails,
> > you only have to resilver one disk.
> >
> > On RAID 0+1 you have to resilver all the
> > disc in the stripe.
> >
> >
> > Jonathan Lewis
> >
> > Seminars on getting the best out of Oracle
> > Last few places available for Sept 10th/11th
> > See http://www.jlcomp.demon.co.uk/seminar.html
> >
> >
> >
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: 11 August 2001 01:13
> >
> >
> > |
> > |For e.g, if you have a 2-way striped mirrored volume,
> > |when you lose 1 drive in the volume, with RAID 0+1 you
> > |will lose 50% of the logical volume's I/O capacity, as
> > |the whole member of the logical volume is shot,
> > |because the stripe becomes totally invalid. With a
> > |comparable configuration using RAID 1+0, you will lose
> > |only 25% of your logical volume's I/O capacity.
> > |
> > |When the striped volume is a 4-way stripe, again with
> > |1 drive loss, with RAID 0+1 you will lose 50% of I/O
> > |capacity versus with RAID 1+0, you will only lose 12
> > |1/2 %. As your stripe-width increases, the percentage
> > |loss in the I/O capacity for RAID 1+0 decreases.
> > |
> > |You should (when possible) consider using RAID 1+0 any
> > |day when compared to RAID 0+1.
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jonathan Lewis
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).


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

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

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

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

RE: Urgent -- pipe import ???

[Sherman, Edward]

Leslie,

This is what works for me on Oracle 7.3.4.4 on HP-UX

(zcat /extdisk/exp1/acc_per_06300200.dmp.Z > \
/extdisk/exp1/export_pipe &); \
imp parfile=/extdisk/exp1/newpar.par

Maybe you can try this if your Sun has zcat.

I have never seen a pipe work for a while and then fail. I think
it is probably not the pipe (unless you try to run two imports through the
same pipe at the same time?).

>From what I can see your syntax appears okay (I didn't test it) and if it
was working at the start of import then it should continue working until the
import finishes. You saw correct import messages displayed before it hung?

Are you sure the export was a good one with message
"Export terminated successfully without warnings." in the log file?

Let us know how it goes.
Ed

-Original Message-
Sent: Monday, August 13, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I sent this last Friday.  Maybe not too many people
check mail on Friday, so I send it again:

For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z
file, which can be uncompressed to a 9G dmp file:

The directory I issue the following commands has 4G
available:
mknod /tmp/imp_pipe  p
uncompress < arbor_minexp_20010726.dmp.Z >
/tmp/imp_pipe & 
imp file=/tmp/imp_pipe parfile=imp.par

The import worked fine for a little while and then
stuck in a table with 1048 row, which is not big at
all.  It stuck there for more than 8 hours until I
kill it.  (The database is not archived.)

Anything could be wrong?  Should I do the uncompress <
arbor_minexp_20010726.dmp.Z > /tmp/imp_pipe &  in a
directory that has 9G free space???  Also I'm not
familiar with pipe, could the pipe fail?  

Thanks a lot!

Leslie


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

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

RE: OT RE: Fwd: RE: RAID or NOT to RAID?

[Christopher Spence]

I assume you are calling me a silly people but I did mention I did not play
a lot with Raid 1+0, I generally use 0+1 rather than the other solution.
And I said these numbers were a decent guestimate.

I stated Raid 1 takes about 15% hit on write performance, give or take which
I am sure of.
Raid 5 can take as much as 60%.  
So I was guestimating that raid 1+0 would incur 30% but since I haven't
really played with it much, I wasn't completely sure and asked for somoene
who was more familiar with it to be more precise.

Glad you had a laugh.

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

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 13, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L


Ha ha ha!

The problems always appear when people apply theory to the real world.

That's when the principles and the reasoning is consistent throughout and
makes sense, ... but it has no relevance to reality.

Beware of silly people who walk around with theoretical models in their
heads!  They are out of this world.  I am sure there is a label for this in
the DSM-IV.

Some people even start fights because their "maps" of the world don't match!
It's truly hilarious to watch all these silly people.  Unfortunately
sometimes they hurt innocent bystanders, or they cost other people money in
useless implementations.

So keep an eye out for explanations that lull you into feeling comfortable
or too sure of yourself...

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, August 10, 2001 9:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Fwd: RE: RAID or NOT to RAID?

All,

In my experience I have found "NO" performance
differences between RAID 0+1 and 1+0. We have done
some very extensive tests in this regard. I have no
idea where the additional 50% write performance loss
for 1+0 is coming from. RAID 0+1 and 1+0 both perform
comparably at the same levels for writes.

Regardless of 1+0 or 0+1, the overhead of multiple
writes (as a result of 2-way mirroring) does not
exceed 15-20% at worst. When the logical volumes are
supported by cache, the write overhead is even less.
Some tests that we have done show 10ms write times for
single drives and when mirrored the response time goes
up to 11.5-12ms at worst.

Let's first try to understand the difference between
the physical characteristics of 0+1 and 1+0. In the
former, you stripe first and you mirror what you
striped. In the latter, you mirror first and then you
stripe over what you mirroed.

The difference between the 2 RAIDs, is in the
"available I/O capacity (IOPS, Transfer Rate)" of the
logical volume, when a drive failure occurs. With RAID
0+1, you will always lose 50% of your logical volume's
I/O capacity (regardless of your stripe width), when
you lose 1 drive.

For e.g, if you have a 2-way striped mirrored volume,
when you lose 1 drive in the volume, with RAID 0+1 you
will lose 50% of the logical volume's I/O capacity, as
the whole member of the logical volume is shot,
because the stripe becomes totally invalid. With a
comparable configuration using RAID 1+0, you will lose
only 25% of your logical volume's I/O capacity. 

When the striped volume is a 4-way stripe, again with
1 drive loss, with RAID 0+1 you will lose 50% of I/O
capacity versus with RAID 1+0, you will only lose 12
1/2 %. As your stripe-width increases, the percentage
loss in the I/O capacity for RAID 1+0 decreases.

You should (when possible) consider using RAID 1+0 any
day when compared to RAID 0+1.

Cheers,

Gaja

--- Christopher Spence <[EMAIL PROTECTED]> wrote:
> There is significant differences due to the fact of
> 1+0 you have 2 raid 1
> (which generally have -15% hit in performance on
> writes but increased
> throughput on reads).   Raid 0+1 you have a single
> raid 1 stripe, so your
> write performance suffers 50% less than that of Raid
> 1+0.  Which I would say
> (never played with Raid 1+0 

RE: OT -- training

[Mohan, Ross]

HA HA HA HA

YEA FREAKIN RIGHT

Seven monthsno training...none scheduled."3000 dollar budget" which
is one (1)
oracle course.not great.

HA HA HA HA

-Original Message-
Sent: Monday, August 13, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: Monday, August 13, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

Re: Deep Doo-Doo

[Deepak Thapliyal]

Hi Dave,

do you use Alter tablespace  .. begin backup ??

if yes then ..FWIW ..try mounting the DB and doing a
alter tablespace .. end backup for tablespace that
might still be in that mode(maybe the one containing
file10)


hth
Deepak
--- "Farnsworth, Dave"
<[EMAIL PROTECTED]> wrote:
> I have a very bad situation.  When I got in this
> morning I saw that the
> nightly backup was hung up.  I do a cold backup to
> another server and then
> the network admins backup my backup to tape.  I did
> a shutdown abort and
> then restarted my database.  But during the startup
> I got this in my
> alrt.log
> 
> EMN0 started with pid=19
> Mon Aug 13 06:46:23 2001
> KCF: write/open error block=0x1c75 online=1
>  file=10
> E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile()
> failure, unable to write to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 457
> Dump file
> I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG
> 
> I also had a oradim.txt file created with this info;
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 8 needs media recovery
> ORA-01110: data file 8:
> 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> Now comes the good part.  Guess what part of the
> backup process was not
> scheduled as it should have been.  That's right, the
> tape backups!!  The
> network admins never scheduled my data for backup to
> tape.  All I have is
> last nights backups which are no good.  I opened a
> TAR but if any of you
> have any ideas I can try, I'm open for anything.  My
> database is down.
> I also just heard that my father is hospitalized. 
> Today really sucks!!
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: Deep Doo-Doo

[Deepak Thapliyal]

Hi Dave,

do you use Alter tablespace  .. begin backup ??

if yes then ..FWIW ..try mounting the DB and doing a
alter tablespace .. end backup for tablespace that
might still be in that mode(maybe the one containing
file10)


hth
Deepak
--- "Farnsworth, Dave"
<[EMAIL PROTECTED]> wrote:
> I have a very bad situation.  When I got in this
> morning I saw that the
> nightly backup was hung up.  I do a cold backup to
> another server and then
> the network admins backup my backup to tape.  I did
> a shutdown abort and
> then restarted my database.  But during the startup
> I got this in my
> alrt.log
> 
> EMN0 started with pid=19
> Mon Aug 13 06:46:23 2001
> KCF: write/open error block=0x1c75 online=1
>  file=10
> E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile()
> failure, unable to write to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 457
> Dump file
> I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG
> 
> I also had a oradim.txt file created with this info;
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> ORA-01113: file 8 needs media recovery
> ORA-01110: data file 8:
> 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'
> 
> ORA-01113: file 10 needs media recovery
> ORA-01110: data file 10:
> 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
> 
> Now comes the good part.  Guess what part of the
> backup process was not
> scheduled as it should have been.  That's right, the
> tape backups!!  The
> network admins never scheduled my data for backup to
> tape.  All I have is
> last nights backups which are no good.  I opened a
> TAR but if any of you
> have any ideas I can try, I'm open for anything.  My
> database is down.
> I also just heard that my father is hospitalized. 
> Today really sucks!!
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

After restoring PROD to another NT server as DEV...

[Denmark Weatherburne]

Thanks DBA's,

OK, I recently restored the "PROD" database to another NT server as "DEV". 
Thanks for all your input. The best way to learn is to test.
Before I could open the database, I had to use the
RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE; option.
After cancelling without applying any logs, I was able to open the database 
with the RESETLOGS option.

The "PROD" database in running in ARCHIVELOG mode.
I am running the "DEV" database in NOARCHIVELOG mode.

If I change the ARCHIVE MODE to ARCHIVELOG on "DEV", can I apply the 
archived logs from "PROD" to "DEV" database daily?

What are the procedures?

Also could I have used the option NORESETLOGS ARCHIVELOG with the CREATE 
CONTROLFILE statement?

What are the requirements?


BTW,
I observed some Archived Logs on the PROD database with sequence numbers 
having a greater range than the current sequence.
For example, the current logs have sequence like Arc3685.1 while there are a 
few created at random from April to August with sequence numbers like 
Arc5164.1 to Arc5214.1.
What controls the sequence numbering for archived log files?
How can you explain the change of sequence numbers at random?

Regards,

Denmark W.
"Knowledge is power, but it is only useful if it is shared!"


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

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

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

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

Re: OT -- training

[Ron Rogers]

Patrice,
 There is "resistance" to any training that I feel is necessary to further my 
knowledge and/or enhance my understanding of the Oracle processes. Even though I have 
money in the budget for such items I have to submit a business case defining the gains 
to the company and after completing the course with a passing grade the company will 
reimburse me the expenses for the course only. I also have to sign a waver that I will 
pay the company back the full cost of the course if I leave their employment before 
365 days. Needless to say I pay for everything myself and hope to write it off on 
taxes if they ever get the bill signed into law.
ROR mª¿ªm 

>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

[Weaver, Walt]

-Original Message-
Sent: Monday, August 13, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

[Denmark Weatherburne]

Hi DBA's here is another scenario,

I'm trying to recover a database from a cold O/S backup onto another NT 
machine. The source database was running in NOARCHIVELOG Mode.
I guesss the backup was not taken at a consistent state because when I tried 
to open the database, Oracle asked for Archive Log#13.
I realized that I don't have the Archived Log because the source database 
was running in NOARCHIVELOG mode. I think I copied the online REDO logs as 
well though.
I changed the status on the source database to ARCHIVELOG mode in an attempt 
to write Archive Log#13 to disk.
I made a mistake at the command line and ended up overwriting the online 
log#13 anyway. I ended up writing Archive Log#14 to disk.
Of course Log#14 is useless because the destination system requires Log#13.
I did some reading over the weekend and found out the following:
If the Archived REDO Log that Oracle needs to complete recovery of a 
database is unavailable, I believe I can use Point in Time Recovery.
I've never tested this scenario before. What approach is best?
How can I determine what is the appropriate time to recover to?


Thanks in advance,

Regards,

Denmark Weatherburne
"Knowledge is power, but it is only useful if it is shared."




>From: Raj Gopalan <[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>Subject: RE: RECOVERY
>Date: Tue, 7 Aug 2001 10:03:00 +0100
>
>Use recover until option and enter cancel when oracle asks for the 
>corrupted
>archive log. You need to open the database with resetlogs.
>
>-Original Message-
>From: Brian Zelli [mailto:[EMAIL PROTECTED]]
>Sent: 06 August 2001 17:48
>To: LazyDBA.com Discussion
>Subject: RECOVERY
>
>
>Hello all,
>HELP!  I have a system (oracle 8.1.7 on SUN Solaris 7) that crashed. I
>have no backup.  I can't seem to recover it.  I called oracle support and
>they kept hammering on the fact that I needed to re-apply the last cold.  
>As
>I mentioned to him, we have no backup.  I tried to recover the database and
>it doesn't like that.  I know which archive log is corrupted.  How do I get
>to a point in time just before that log and bring up the database?
>
>Brian
>
>
>
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to [EMAIL PROTECTED]
>To subscribe:   send a blank email to [EMAIL PROTECTED]
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>Oracle documentation is here: 
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to [EMAIL PROTECTED]
>To subscribe:   send a blank email to [EMAIL PROTECTED]
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these 
>terms:http://www.lazydba.com/legal.html
>


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

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

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

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

Re:OT -- training

[Rocky Welch]

Select TRAINING, MEET_INTERVIEW_AMOUNT
from real_life;

TRAININGMEET_INTERVIEW_AMOUNT
-
  NO


-Rocky

--- [EMAIL PROTECTED] wrote:
> Zero and NO.  It's been a bone of contention & discussion.  Looks like
> there is
> blame enough to easily spread around.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
> Date:   8/13/2001 7:46 AM
> 
> Just out of curiosity, how many days / weeks of real training did your
> employer provide you with in the last couple of years?
> 
> "real" is in quotes, I don't mean the little 1 - 3 day seminars given by
> CareerTrack and other "training" companies, or management-related stuff
> like
> little MBA-flavoured certificates from universities.
> 
> Oh, and did the amount of training you received match what you were told
> during your job interview?
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique 
> Maritimes Region, DFO  | Région des Maritimes, MPO
> 
> E-Mail: [EMAIL PROTECTED]  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

RE: auditing ... getting offending SQL ??

[Cherie_Machler]

John,

Who is the vendor for EZSQL?   Do you have a web site for them?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


   
 
John Lewis 
 
  
works.com> cc: 
 
Sent by:   Subject: RE: auditing ... getting 
offending SQL ??   
[EMAIL PROTECTED]   
 
   
 
   
 
08/10/01 12:46 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I use ezsql ( I got it for $50 ) to capture this kind of thing.
There are scripts out there that also do it but the ezsql
is cheap considering what it does.

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




hi list,

i set up auditing by access on a few objects (requested by programmers
trying to figure out where their application is failing), and i was
wondering if there's any way to get the full sqltext that is causing the
error. i've searched metalink, read kevin loney's dba 8i handbook, etc.
but haven't found a way to detect the offending sql. dba_audit_object only
gives you the action_name.

dba_audit_trail does give you more information:

SQL> select sessionid, statementid from DBA_AUDIT_TRAIL;

 SESSIONID STATEMENTID
-- ---
595639  16
595639  17

2 rows selected.

but, again, i do not know how to get the sql from the above information.
or even if it's possible. never had to audit before, so this is new to me.

we are running 8.1.6.0 on solaris 2.6, and the programmers are executing
very involved, complex packages which have LOTS of DMLs...

any insight would be most appreciated. :)

thanks,
kris



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

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

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

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

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

Deep Doo-Doo

[Farnsworth, Dave]

I have a very bad situation.  When I got in this morning I saw that the
nightly backup was hung up.  I do a cold backup to another server and then
the network admins backup my backup to tape.  I did a shutdown abort and
then restarted my database.  But during the startup I got this in my
alrt.log

EMN0 started with pid=19
Mon Aug 13 06:46:23 2001
KCF: write/open error block=0x1c75 online=1
 file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 457
Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

I also had a oradim.txt file created with this info;

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

Now comes the good part.  Guess what part of the backup process was not
scheduled as it should have been.  That's right, the tape backups!!  The
network admins never scheduled my data for backup to tape.  All I have is
last nights backups which are no good.  I opened a TAR but if any of you
have any ideas I can try, I'm open for anything.  My database is down.
I also just heard that my father is hospitalized.  Today really sucks!!

Thanks,

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

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

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

RE: ON UPDATE CASCADE?

[Page, Bruce]

I have always done it with triggers.

-Original Message-
Sent: Monday, August 13, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L


I want to update referencing tables when the master table is updated. 
 
Does it have an easy way as in on delete cascade or do I need to Write code?
 
Bunyamin
 

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

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

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

[Cale, Rick T (Richard)]

Hi,

I am resending this question as I cannot find the answer

>  CLOBs vs VARCHAR.  If a varchar datatype is not completely used it will
> not allocate storage for what is was defined.
>   Does a CLOB data type use entire storage if not completely used?
> 
> Thanks
> Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

RE: Urgent -- pipe import ???

[Smith, Ron L.]

Attached are a couple of export import scripts I received earlier from a
member of the user group.
Hope they help.

Ron Smith











-Original Message-
Sent: Monday, August 13, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I sent this last Friday.  Maybe not too many people
check mail on Friday, so I send it again:

For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z
file, which can be uncompressed to a 9G dmp file:

The directory I issue the following commands has 4G
available:
mknod /tmp/imp_pipe  p
uncompress < arbor_minexp_20010726.dmp.Z >
/tmp/imp_pipe & 
imp file=/tmp/imp_pipe parfile=imp.par

The import worked fine for a little while and then
stuck in a table with 1048 row, which is not big at
all.  It stuck there for more than 8 hours until I
kill it.  (The database is not archived.)

Anything could be wrong?  Should I do the uncompress <
arbor_minexp_20010726.dmp.Z > /tmp/imp_pipe &  in a
directory that has 9G free space???  Also I'm not
familiar with pipe, could the pipe fail?  

Thanks a lot!

Leslie


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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


 import.sh

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

 export.sh

Re:OT -- training

[Rachel Carmichael]

depends on what you consider training... I consider going to conferences as 
a training class, so yes, I've been to training




>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re:OT -- training
>Date: Mon, 13 Aug 2001 09:15:49 -0800
>
>Zero and NO.  It's been a bone of contention & discussion.  Looks like 
>there is
>blame enough to easily spread around.
>
>Dick Goulet
>
>Reply Separator
>Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
>Date:   8/13/2001 7:46 AM
>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
>CareerTrack and other "training" companies, or management-related stuff 
>like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED] 
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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).


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

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

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

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

RAID or NOT to RAID? What's the diff???

[Koivu, Lisa]

Title:  RAID or NOT to RAID?  What's the diff???





Good morning - 


Admitting ignorance here.  What is the difference between Raid 0+1 and Raid 1+0  (is this mirroring)?  If someone can forward a website that describes the difference I would really appreciate it.

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



-Original Message-
From:   Jonathan Lewis [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, August [Koivu, Lisa]  11, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L
Subject:    Re: Fwd: RE: RAID or NOT to RAID?



You could also mention that when you have 
to resilver on RAID 1+0 after a disk fails,
you only have to resilver one disk.


On RAID 0+1 you have to resilver all the
disc in the stripe.



Jonathan Lewis


Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html





-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 11 August 2001 01:13



|
|For e.g, if you have a 2-way striped mirrored volume,
|when you lose 1 drive in the volume, with RAID 0+1 you
|will lose 50% of the logical volume's I/O capacity, as
|the whole member of the logical volume is shot,
|because the stripe becomes totally invalid. With a
|comparable configuration using RAID 1+0, you will lose
|only 25% of your logical volume's I/O capacity. 
|
|When the striped volume is a 4-way stripe, again with
|1 drive loss, with RAID 0+1 you will lose 50% of I/O
|capacity versus with RAID 1+0, you will only lose 12
|1/2 %. As your stripe-width increases, the percentage
|loss in the I/O capacity for RAID 1+0 decreases.
|
|You should (when possible) consider using RAID 1+0 any
|day when compared to RAID 0+1.




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


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

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

Re: OT -- training

[Thater, William]

"Boivin, Patrice J" wrote:
> 
> Just out of curiosity, how many days / weeks of real training did your
> employer provide you with in the last couple of years?

a week at IOUG, and no i was promised 2 conferences and a week's worth
of "formal" training a year. 

--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

You know it is going to be a bad day when you forget your new password.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

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

RE: RAID or NOT to RAID? What's the diff???

[Mohan, Ross]

Title: RAID or NOT to RAID? What's the diff???



been 
covered.but.the first is striped...then mirrored...the second is 
mirrored (in disk pairs...) THEN striped..
 
 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 
  12:06 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RAID or NOT to RAID? What's the diff???
  Good morning - 
  Admitting ignorance here.  What 
  is the difference between Raid 0+1 and Raid 1+0  (is this 
  mirroring)?  If someone can forward a website that describes the 
  difference I would really appreciate it.
  Thanks Lisa Koivu Oracle Database 
  Administrator Fairfield Resorts, Inc. 
  954-935-4117 
  
-Original Message- From:   Jonathan Lewis [SMTP:[EMAIL PROTECTED]] Sent:   Saturday, August [Koivu, Lisa]  11, 2001 4:25 AM To: Multiple recipients of list ORACLE-L Subject:    Re: Fwd: RE: RAID or NOT to RAID? 
You could also mention that when you have 
to resilver on RAID 1+0 after a disk 
fails, you only have to resilver one 
disk. 
On RAID 0+1 you have to resilver all the 
disc in the stripe. 
Jonathan Lewis 
Seminars on getting the best out of Oracle 
Last few places available for Sept 
10th/11th See http://www.jlcomp.demon.co.uk/seminar.html 

-Original Message- To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> Date: 11 
August 2001 01:13 
| |For e.g, if 
you have a 2-way striped mirrored volume, |when you lose 1 drive in the volume, with RAID 0+1 you 
|will lose 50% of the logical volume's I/O 
capacity, as |the whole member of the 
logical volume is shot, |because the 
stripe becomes totally invalid. With a |comparable configuration using RAID 1+0, you will lose 
|only 25% of your logical volume's I/O capacity. 
| |When the striped volume is a 4-way stripe, again with 
|1 drive loss, with RAID 0+1 you will lose 50% 
of I/O |capacity versus with RAID 1+0, 
you will only lose 12 |1/2 %. As your 
stripe-width increases, the percentage |loss in the I/O capacity for RAID 1+0 decreases. | |You should (when 
possible) consider using RAID 1+0 any |day when compared to RAID 0+1. 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 
Lewis   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, send 
an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (or 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 Reportwriter & Crystal Reports (Slightly OT)

[dgoulet]

Steven,

I don't think there are any sites that contrast these two against each
other, mainly because it would be an apples vs. oranges type of comparison. 
Sure they both do the same job, but that's where the similarities end.

Oracle ReportWriter is definitely an industrial strength tool, multiple
cursors, multiple display areas or whatever they call them.  Not end user
friendly for developing one's own reports, direct SQL*Net connection and their
"compiled" reports not interpreted so they run faster and can process more data.

Crystal on the other hand is end user friendly, but only one cursor per
report.  Formatting is a little less flexible to, plus you've got to contend
with ODBC and their interpreted reports which do run slower and don't like huge
volumes of data.

Therefore, should you have one or the other?  Naw, you need them both. 
Leverage each's strengths & you'll get exactly what you want.

Dick Goulet

Reply Separator
Author: "Steven Hovington" <[EMAIL PROTECTED]>
Date:   8/13/2001 6:59 AM

Does anyone have any recommendations on these reporting
tools, or pointers to resources discussing the relative
merits?

Thanks in advance,

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

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

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

07_DICTIONARY_ACCESSIBILITY

[Smith, Ron L.]

Does anyone have any experience and or info on the
07_DICTIONARY_ACCESSIBILITY parameter?

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

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

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

Re:OT -- training

[dgoulet]

Zero and NO.  It's been a bone of contention & discussion.  Looks like there is
blame enough to easily spread around.

Dick Goulet

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   8/13/2001 7:46 AM

Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

Urgent -- pipe import ???

[Leslie Lu]

Hi all,

I sent this last Friday.  Maybe not too many people
check mail on Friday, so I send it again:

For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z
file, which can be uncompressed to a 9G dmp file:

The directory I issue the following commands has 4G
available:
mknod /tmp/imp_pipe  p
uncompress < arbor_minexp_20010726.dmp.Z >
/tmp/imp_pipe & 
imp file=/tmp/imp_pipe parfile=imp.par

The import worked fine for a little while and then
stuck in a table with 1048 row, which is not big at
all.  It stuck there for more than 8 hours until I
kill it.  (The database is not archived.)

Anything could be wrong?  Should I do the uncompress <
arbor_minexp_20010726.dmp.Z > /tmp/imp_pipe &  in a
directory that has 9G free space???  Also I'm not
familiar with pipe, could the pipe fail?  

Thanks a lot!

Leslie


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

OT -- training

[Boivin, Patrice J]

Just out of curiosity, how many days / weeks of real training did your
employer provide you with in the last couple of years?

"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
CareerTrack and other "training" companies, or management-related stuff like
little MBA-flavoured certificates from universities.

Oh, and did the amount of training you received match what you were told
during your job interview?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

RE: relink executables

[Glenn Travis]

$ORACLE_HOME/bin/relink

usage: relink 
accepted values for parameter: all, oracle, network, client,
client_sharedlib
interMedia, precomp, utilities, oemagent

NOTE:  Be sure /usr/ccs/bin is in your PATH BEFORE /usr/ucb, in order to
pick up the correct ld linker.  See Metalink Note: 121635.1.

-Original Message-
[EMAIL PROTECTED]
Sent: Saturday, August 11, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L



hi Tatireddy

   make -f oracle.mk install
   This will generate ALL the RDBMS related executables AND move
   them to ?/bin automatically.


Regards

'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Islamabad, PAKISTAN
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'













"Tatireddy, Shrinivas
(MED, Keane)"To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
   Subject: relink
executables
Sent by:
[EMAIL PROTECTED]


08/11/2001 12:10 PM
Please respond to
ORACLE-L





hi lists

after upgrading OS  how to relink oracle executables?

sri

oracle 8.1.6
sun 2.6
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: urgent help need please

[DBarbour]

Chark(sp?) -

Is your listener running?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
"Sairlao, Chark"   
   
  
ld.com.au>   cc:   
   
Sent by: Subject: urgent help need please  
   
[EMAIL PROTECTED]   
   
   
   
   
   
08/12/2001 10:30   
   
PM 
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




all,

our company just installed the virtual private network equipment
(Enterasyss Network), then suddenly peoplesoft application can not login to
the oracle database any more, came back with ora 12203, then I tries
tnsping
nothing works either, however I can do sqlplus user/password@tns and it
lets
me in ok.

any idea please?

Thanks And Regards
Chark Sairlao

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

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

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

[Cale, Rick T (Richard)]

I 
think you will have write a on update, on insert trigger to accomplish 
this.
 
Rick

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 
  11:00 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ON UPDATE CASCADE?
  I want to update referencing tables when the 
  master table is updated. 
   
  Does it have an easy way as in on delete 
  cascade or do I need to Write code?
   
  Bunyamin
   

no email comes from list ?

[Bunyamin K. Karadeniz]

no email comes from list to me? 
Why can it be?
 
Bunyamin

Test Message - receiving no mail..

[Mark Leith]

Too often, we lose sight of life's simple pleasures. Remember, when someone
annoys you it takes 42 muscles in your face to frown, BUT, it only takes 4
muscles to extend your arm and bitch-slap that mother@#?!&! upside the head!

Thanks for listening to my test message :)

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance

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

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

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

RE: Oracle 9i posters

[Garner, John (NESL-IT)]

Who, when where P L E A S E!!!

-Original Message-
Sent: 13 August 2001 15:30
To: Multiple recipients of list ORACLE-L


Are any of these out yet?

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with
it (if any) are confidential and intended for the addressee only.  If you have
received this e-mail in error please notify the originator or telephone
0191 210 2060 or e-mail [EMAIL PROTECTED]

This e-mail and any attachments have been scanned for certain
viruses prior to sending but neither Northern Electric plc nor any of the companies in 
the Northern Electric group of companies from whom this e-mail originates shall be 
liable for any losses as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained in this 
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

Northern Electric plc
Carliol House
Market Street
Newcastle-upon-Tyne
NE1 6NE
Registered in England and Wales: Number 2366942



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Garner, John (NESL-IT)
  INET: [EMAIL PROTECTED]

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

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

Stored procedure performance

[Paul Baumgartel]

In the process of making a design decision, I'm looking for information on
the relative performance of PL/SQL stored procedures / packages vs. both
Pro*C / OCI SQL calls and Java stored procedures.  All things being equal,
let's say for DML calls with little or not procedural logic, what technique
is likely to yield the best performance, and how much of a performance
difference exists?  In the case of PL/SQL vs. SQL, is the advantage of
centralization overshadowed by a performance hit?  In the case of PL/SQL vs.
Java, is the advantage of a more "standard" and widely-used language among
application developers similarly negated by a performance disadvantage?

I'm interested in hearing opinions based on both theoretical and empirical
information.  Thanks.

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

RE: Urgent -- pipe import ???

[Smith, Ron L.]

When you say you are not archiving what do you mean exactly?  If you shut
off auto archiving that does not shut off archiving.  We had that problem.
The log gets full and auto archiving does not run to clean out the archive
log so the system hangs.

Ron Smith

-Original Message-
Sent: Monday, August 13, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I sent this last Friday.  Maybe not too many people
check mail on Friday, so I send it again:

For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z
file, which can be uncompressed to a 9G dmp file:

The directory I issue the following commands has 4G
available:
mknod /tmp/imp_pipe  p
uncompress < arbor_minexp_20010726.dmp.Z >
/tmp/imp_pipe & 
imp file=/tmp/imp_pipe parfile=imp.par

The import worked fine for a little while and then
stuck in a table with 1048 row, which is not big at
all.  It stuck there for more than 8 hours until I
kill it.  (The database is not archived.)

Anything could be wrong?  Should I do the uncompress <
arbor_minexp_20010726.dmp.Z > /tmp/imp_pipe &  in a
directory that has 9G free space???  Also I'm not
familiar with pipe, could the pipe fail?  

Thanks a lot!

Leslie


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

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

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

Re:Query Tuning - Need Some Clarifiations

[dgoulet]

The frequency at which you rebuild indexes and/or analyze the database is
somewhat of a black art.  My first question is what do you mean by "there are
huge inserts,updates and deletes"?  Our operational data store for our testers
goes through something line 6 million inserts/updates/deletes per day and the
maintenance is being done every 6 months without any performance degradation in
between.

Dick Goulet

Reply Separator
Author: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]>
Date:   8/10/2001 11:45 PM

Dear Listers,
My manager called me asked to look into the database problems in an IVR appln.
The size of the database is around 1 gigs. The db stores information about
customers, their phone nos and the relevant details. The mail problem was delay
in playing a welcome prompt when the call connects to IVR, 6 queries are
executed before playing the welcome message and there was a major delay when the
customer needed some info. Basically it has to query the database and pass on
the info the person who had called.

First I got all the queries and checked the plan,time taken for each query. I
found all the queries did a full table scan and after creating necessary indexes
and analyzing the tables, I hit the right thing. Now the welcome message is
played moment the call is connected to IVR and there is no time lag susequent
queries.

Using tkprof I checked the usage of indexes,CPU usage, time taken for
parse,execution. All showing 0. The customer is happy now and also the manager.

I have few doubts. It is an OLTP kind of scenario, there are huge
inserts,updates and deletes, in what frequency I have to rebuild indexes and
analyze the tables after rebuilding indexes.

Since the db is in noarchivelog mode, it is advisible to put the same in
archivelog mode.

Any advices/suggestions are welcome.

Regards
C.S.Venkata Subramanian


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

[Riyaj_Shamsudeen]

Ian
        These rows relate to the library cache pin on the metadata about the objects. Metadata for the objects need to be pinned during the execution of the statement to prevent the invalidation of the dependent objects. Since each one of this sid has this object pinned, I think, you have objects with these names in your database. Does your database have these objects ?

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






"MacGregor, Ian A." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/10/01 06:45 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        X$_kglcursor.kglnaobj


I use the following statment when monitoring the database

select   sid, s.username,s.osuser,   c.kglnaobj from   sys.x$_kglpn  p,   sys.x$_kglcursor  c,   v$_session  s
where   p.kglpnhdl = c.kglhdadr and   p.kglpnses = s.saddr;

Here is some output showing sid and kglnaobj:

       28
table_1_0_116_0_0_

       80
SELECT LOC,RACK,SLOT,ELE,CONNNUM,PIN,RLOC,RRACK,RELE,RSLOT,RCONNNUM,RPIN FROM CAPTAR.LINKTERM WHERE
(LOC=:1) and (RACK=:2) and (CONNNUM=:3) and (PIN LIKE '%L') order by loc, rack, ele, slot, connnum,
orderpin, pin

       28
table_1_0_112_0_0_

       28
table_1_0_11a_0_0_

       82
table_1_0_112_0_0_

       28
table_1_0_11a_0_0_

       82
table_1_0_112_0_0_


What is the meaning of  the lines which start with "table_"?

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

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

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

RE: FW: karma

[Larry Elkins]

Thanks John. I will pass that info on.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John
> Kanagaraj
> Sent: Friday, August 10, 2001 9:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: FW: karma
> 
> 
> Btw, Sean Hull and Andy Duncan (both active in this list in '98-'99) have
> co-authored the 'Oracle and Open Source' book (O'Reilly) which came out
> recently. There is a section which covers DBD in general and Karma
> specifically.
> 
> John Kanagaraj

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

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

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

RE: RAID or NOT to RAID? What's the diff???

[Jon Baker]

Title: RAID or NOT to RAID? What's the diff???



one is 
mirrored stripes while the other is stripped mirrors.    
;-)
 
 
 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 
  12:06 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RAID or NOT to RAID? What's the diff???
  Good morning - 
  Admitting ignorance here.  What 
  is the difference between Raid 0+1 and Raid 1+0  (is this 
  mirroring)?  If someone can forward a website that describes the 
  difference I would really appreciate it.
  Thanks Lisa Koivu Oracle Database 
  Administrator Fairfield Resorts, Inc. 
  954-935-4117 
  
-Original Message- From:   Jonathan Lewis [SMTP:[EMAIL PROTECTED]] Sent:   Saturday, August [Koivu, Lisa]  11, 2001 4:25 AM To: Multiple recipients of list ORACLE-L Subject:    Re: Fwd: RE: RAID or NOT to RAID? 
You could also mention that when you have 
to resilver on RAID 1+0 after a disk 
fails, you only have to resilver one 
disk. 
On RAID 0+1 you have to resilver all the 
disc in the stripe. 
Jonathan Lewis 
Seminars on getting the best out of Oracle 
Last few places available for Sept 
10th/11th See http://www.jlcomp.demon.co.uk/seminar.html 

-Original Message- To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> Date: 11 
August 2001 01:13 
| |For e.g, if 
you have a 2-way striped mirrored volume, |when you lose 1 drive in the volume, with RAID 0+1 you 
|will lose 50% of the logical volume's I/O 
capacity, as |the whole member of the 
logical volume is shot, |because the 
stripe becomes totally invalid. With a |comparable configuration using RAID 1+0, you will lose 
|only 25% of your logical volume's I/O capacity. 
| |When the striped volume is a 4-way stripe, again with 
|1 drive loss, with RAID 0+1 you will lose 50% 
of I/O |capacity versus with RAID 1+0, 
you will only lose 12 |1/2 %. As your 
stripe-width increases, the percentage |loss in the I/O capacity for RAID 1+0 decreases. | |You should (when 
possible) consider using RAID 1+0 any |day when compared to RAID 0+1. 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 
Lewis   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, send 
an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (or the name of mailing 
list you want to be removed from).  You may also send the HELP command for other information (like 
subscribing).