RE: HOW TO MAKE DELETION FAST

[Shreepad . Vaidya]

Hi,
Disabling of Primary keys and other indexes will make  your deletions
faster .

HTH
shreepad

-- 
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: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Patrice Boivin and other list members,

Thanks for your guidance.  I am in the process of
learning DBA stuff by reading concepts manual and I
will try to experiment using personal oracle.

Thanks and Regards.
Dharan.

--- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote:
> Dharan,
> 
> Read the Concepts Manual again.  If you can, go
> through the DBA 101 book and
> perhaps some of those "Starter Kits" Oracle Press
> has been cranking out
> lately.
> 
> Are you administering Oracle database(s) now?  Take
> time to poke around and
> see what is happening.  Create a user account for
> yourself to experiment
> with, being careful not to cripple the rest of the
> system.  You can do that
> by ensuring you don't have rights / privileges that
> give you too much
> freedom on the database.
> 
> To understand, you need to read (know), but you also
> need to practice
> (experience).  Once you will have done both, you
> will have learned from
> mistakes and you will understand what is happening. 
> That will also give you
> a handle on which questions are relevant and which
> are not during
> interviews.  Your next Oracle interview might be
> administered by someone who
> knows little or nothing about Oracle.  (i.e. they
> are looking for a DBA,
> because their previous one left in disgust or they
> never had one).
> 
> If you understand the basics of Oracle and you
> demonstrate during the
> interview that you do not consider saving face
> (putting up appearances)
> being more important than learning and fixing
> problems, you will have an
> honest chance at being hired as a junior DBA.
> 
> At first you will have to live, eat, breathe, dream
> Oracle.  You have to
> decide on this path and never give up.  Never giving
> up is a crucial DBA
> trait.  You have to be more stubborn than the
> server(s) you administer.  You
> also have to be willing to change your approach if
> the previous one didn't
> work, the end result is what you aim for, and it is
> what you keep striving
> for until you get there.  You have to take personal
> responsibility for the
> systems you administer.  You must be reliable.
> 
> 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]
>  
> 
> 
>   -Original Message-
>   From:   Dharani Ravi [SMTP:[EMAIL PROTECTED]]
>   Sent:   Tuesday, December 25, 2001 7:45 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Help - DBA interview questions I faced
> 
>   Dear Rachel,
> 
>   Thanks for your reply.  Initially I felt
> demoralised
>   after reading your  reply.  Truth is always bitter.
> 
>   You are correct.  My Oracle concepts knowledge
> needs
>   to be improved.  I read Oracle 8 concepts manual
> two
>   years ago.  I am working for a small company where
>   there are no seperate DBAs, System Administrators
> and
>   Network Admins.  Only three staff are identified to
>   look after the abovementioned jobs in addition to
>   development job.  Most of our time goes for report
>   generation, foxpro programs and other  activities. 
> I
>   do not have a senior person from whom I can learn
> the
>   job. Jobs like DB creation, maintanence, backup and
>   recovery are done by me and I learned the job from
>   manuals and by experience.  I wanted to work in a
>   production env where I can learn more about DBA
> job. 
>   I need your guidance and seniors guidance from this
>   group.  Hope you will appreciate my position and I
>   sincerely request you to clarify my doubts.  I will
> be
>   grateful to you If you can clarify my mistakes made
> by
>   me in the interview.  I seek the support from this
>   group to develop myself as a DBA.
> 
>   Merry Christmas.
> 
>   Regards.
>   Dharan.
>   --- Rachel Carmichael <[EMAIL PROTECTED]>
> wrote:
>   > Dharan,
>   > 
>   > Answering just those questions will not give you
>   > enough knowledge to
>   > truly be able to answer Oracle questions in an
>   > interview.
>   > 
>   > Based on the answers you gave, it seems to me
> that
>   > you do not
>   > understand the concepts behind how Oracle works
> at
>   > all.  I would
>   > suggest you read the documentation (specifically
> the
>   > Concepts and
>   > Administrator's manuals to start) to get a better
>   > understanding of
>   > Oracle.
>   > 
>   > I would also suggest you talk to the senior DBA
>   > where you are and ask
>   > him or her to help you learn about the database.
>   > 
>   > Rachel
>   > 
>   > --- Dharani Ravi <[EMAIL

RE: synonym for a user-defined data type?

[Alex Hillman]

Did not work much with objects but it is logical that there should be some
privileges granted to have access to other user data type.

Alex Hillman

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, December 18, 2001 3:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: synonym for a user-defined data type?
>
>
>
> have you tried 'create public synonym user_type for user.user_type'  ?
>
> Jared
>
>
>
>
>
> "Feldhausen,
>
> Hans"To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 
> EICO.COM>Subject: synonym for
> a user-defined data type?
> Sent by:
>
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 12/18/01 06:00
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> We're working with Oracle v8.1.6.2.
>
>
>
> How can we declare a synonym for a user-defined data type? We
> would like to
>
> create a public synonym for a user-defined data type so that when this
>
> data-type is created under one schema it is accessible to all schemas
>
> without having to prefix it.
>
>
> TIA!
>
> Hans Feldhausen
> GEICO DBA
> (301) 986-3746
> [EMAIL PROTECTED]
>
>
> 
> This email/fax message is for the sole use of the intended
> recipient(s) and
> may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution of this email/fax is
> prohibited. If
> you are not the intended recipient, please contact the sender by email/fax
> and destroy all paper and electronic copies of the original message.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Feldhausen, Hans
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  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: Alex Hillman
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle registry

[RAYMOND]

HELP ME.it take me one day to trigger this...but still no outcome

When I start install oracle and I accidently cancel the process and
continous install again without cleaninig all the registry.
below is my registry

I try to replace HOME1 TO HOME 0but I still can't tnsping my host, the
error message popup 'message file not found for facility network ... "

I need advice on this...



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"
"ORACLE_HOME"="e:\\oracle\\ora81"
"ORACLE_HOME_NAME"="OraHome81"
"API"="e:\\oracle\\ora81\\dbs"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"NLS_LANG"="NA"
"OLEDB"="c:\\oracle\\ora81\\oledb\\mesg"
"VOBHOME2.0"="c:\\oracle\\ora81"
"OO4O"="c:\\oracle\\ora81\\oo4o\\mesg"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
"HOME_COUNTER"="2"
"DEFAULT_HOME"="OraHome81"
"LAST_HOME"="1"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NAME"="OraHome81"
"PATH"="e:\\oracle\\ora81"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID1]
"NAME"="ORACLEHOME"
"PATH"="c:\\oracle\\ora81"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"ORACLE_HOME_NAME"="OraHome81"
"ORACLE_HOME"="e:\\oracle\\ora81"
"NLS_LANG"="NA"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0"
"SQLPATH"="c:\\oracle\\ora81\\dbs"
"ORACLE_BASE"="c:\\oracle"
"MSHELP_TOOLS"="c:\\oracle\\ora81\\MSHELP"
"RDBMS_CONTROL"="c:\\oracle\\ora81\\DATABASE"
"RDBMS_ARCHIVE"="c:\\oracle\\ora81\\DATABASE\\ARCHIVE"
"ORA_SPD_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SPD_PFILE"=hex(2):63,00,3a,00,5c,00,6f,00,72,00,61,00,63,00,6c,00,65,00
,\

5c,00,61,00,64,00,6d,00,69,00,6e,00,5c,00,73,00,70,00,64,00,5c,00,70,00,66,\

00,69,00,6c,00,65,00,5c,00,69,00,6e,00,69,00,74,00,73,00,70,00,64,00,2e,00,\
  6f,00,72,00,61,00,00,00
"ORA_SPD_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SPD_SHUTDOWNTYPE"=hex(2):69,00,00,00
"ORA_SPD_SHUTDOWN_TIMEOUT"=hex(2):33,00,30,00,00,00
"ORACLE_SID"="spd"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1]
"ID"="1"
"ORACLE_GROUP_NAME"="Oracle - ORACLEHOME"
"ORACLE_HOME_NAME"="ORACLEHOME"
"ORACLE_HOME"="c:\\oracle\\ora81"
"NLS_LANG"="AMERICAN_AMERICA.WE8ISO8859P1"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME1"
"SQLPATH"="c:\\oracle\\ora81\\dbs"
"ORACLE_BASE"="c:\\oracle"
"MSHELP_TOOLS"="c:\\oracle\\ora81\\MSHELP"
"RDBMS_CONTROL"="c:\\oracle\\ora81\\DATABASE"
"RDBMS_ARCHIVE"="c:\\oracle\\ora81\\DATABASE\\ARCHIVE"
"ORA_SPD_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SPD_PFILE"=hex(2):63,00,3a,00,5c,00,6f,00,72,00,61,00,63,00,6c,00,65,00
,\

5c,00,61,00,64,00,6d,00,69,00,6e,00,5c,00,73,00,70,00,64,00,5c,00,70,00,66,\

00,69,00,6c,00,65,00,5c,00,69,00,6e,00,69,00,74,00,73,00,70,00,64,00,2e,00,\
  6f,00,72,00,61,00,00,00
"ORA_SPD_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SPD_SHUTDOWNTYPE"=hex(2):69,00,00,00
"ORA_SPD_SHUTDOWN_TIMEOUT"=hex(2):33,00,30,00,00,00
"ORACLE_SID"="spd"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRSet"="0"
"PwdChgDlg"="1"
"SchRstLng"="1"
"UserDefFn"="0"
"DisableRetClause"="1"
"TraceCategory"="0"
"TraceFileName"="c:\\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OO4O]
"CacheBlocks"="20"
"FetchLimit"="100"
"FetchSize"="4096"
"HelpFile"="c:\\oracle\\ora81\\MSHELP\\oracleo.hlp"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"
"OO4O_HOME"="c:\\oracle\\ora81\\oo4o"




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

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

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

Where Does the Java Run in IFS

[MacGregor, Ian A.]

Is all the Java  for IFS server-based?  We have a growing need for something like IFS, 
but if it uses client-side Java, it's not worth considering.

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: Firing order of triggers

[Ron Yount]

Darren,

I may be missing something, but since you want all three to fire on the same
event, and you also want them to fire in a particular order, why not put
them all in the same trigger with logic to control the order?

-Ron-

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Joe Testa
> Sent: Thursday, December 27, 2001 5:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Firing order of triggers
>
>
> nope
>
> joe
>
>
> Browett, Darren wrote:
>
> > Happy Holidays to everybody.
> >
> > We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
> > there anyway
> > we can control which one fires first,second, third, .. n th
> >
> > Thanks
> >
> > Darren
> >
> >
> --
> --
> > --
> > Darren Browett P.Eng
> This message
> > was transmitted
> > Data Administrator  using 100%
> > recycled electrons
> > Information and Communication Technology
> > City of Coquitlam
> > P:(604)927 - 3614
> > E:[EMAIL PROTECTED]
> >
> --
> --
> > ---
> >
> >
> >
>
>
> --
> Joe Testa, Oracle DBA
> Want to have a good time with a bunch of geeks? Check out:
> http://www.geekcruises.com/standard_interface/future_cruises.html
> I'm presenting, when registering drop my name :)
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

[Scott Shafer]

Opinions vary, but often involve management "fundament-snorkeling".

--Scott

"Diver down!"


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 27, 2001 6:40 AM


I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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] 


-Original Message-
Sent: Wednesday, December 26, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L

and eventually, when they realize they can't find that omniscient
person, they come back to reality


--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project,
and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great at *.  I don't know much about YYY, but I'm
willing
> to
> > learn..We cannot know everything.
>
> That worked in the "good old days" (pre-2001), not any more, not
by a
> long shot
> These days one is expected to be EXPERT of everything the
employers
> list
> explicitly and implicitly (which seems to be getting longer...)
plus
> this and
> that
>
> Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
> Server ?
> Sybase ?
> MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
> ?
> SAP? Essbase ?  Cognos ? Informatica ?
>
> That's what's so freaky and hedious the job market for hands-on
> techies is.
> You ARE expected to know everything !
>
> Robert Chin
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robert Chin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>

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

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

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

Re: Data Archiving

[Scott Shafer]

Title: Data Archiving




On new db:create a db link from the new server to 
the old server.
create table history_table as select * from orginal_table 
where criteria = meets_my_criteria_for _archiving;
On old db:
delete unneeded (archived) records from the original 
tables.
 
--Scott
 
 

  - Original Message - 
  From: 
  Nirmal Kumar 
  Muthu Kumaran 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, December 27, 2001 3:10 
  AM
  Subject: Data Archiving
  
  Hi all, 
  New year Greetings. 
  We need to archive some history tables from 
  the production database to new server. Totally around 50 history 
  tables we need to move and each table 
  having around 10 million of records. Some of history tables having records, 
  which are required for another a year the production database, approximatedly 
  i can say around 2 million of records in each table
  like this. 
  So what is the best way to move these 
  tables?. 
  I suggested them to export/import tables and 
  delete invalid records. 
  But another team are planned to do it by a 
  simple pl/sql script by making cursor, check validity of record, if yes insert 
  into new server and then delete from production, repeat.
  I want to know the best way to do this job 
  without any major implications. 
  Both servers are oracle7.3.1. running on 
  VAX/VMS. 
  Thanks. 
  Nirmal. 

Re: Firing order of triggers

[Joe Testa]

nope

joe


Browett, Darren wrote:

> Happy Holidays to everybody.
> 
> We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
> there anyway
> we can control which one fires first,second, third, .. n th
> 
> Thanks
> 
> Darren
> 
> 
> --
> Darren Browett P.Eng  This message
> was transmitted
> Data Administratorusing 100%
> recycled electrons 
> Information and Communication Technology
> City of Coquitlam 
> P:(604)927 - 3614 
> E:[EMAIL PROTECTED] 
> 
> --- 
> 
> 
> 


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






-- 
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: Help - DBA interview questions I faced

[Peter . McLarty]

In some organisations I have worked for you get to be a manager by longevity so you could be a programmer one day and because you stuck it out, the next one your an IT manager for everything IT, Dont laugh one of the guys there now got to be the IT manager just that way. I didnt want to stick it out long enough to see if I could make IT manager

Cheers




--
=
Peter McLarty               E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

    - Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=









"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
27/12/2001 10:40 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        RE: Help - DBA interview questions I faced


I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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]  


                 -Original Message-
                 From:                 Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
                 Sent:                 Wednesday, December 26, 2001 7:05 AM
                 To:                 Multiple recipients of list ORACLE-L
                 Subject:                 Re: Help - DBA interview questions I faced

                 and eventually, when they realize they can't find that omniscient
                 person, they come back to reality


                 --- Robert Chin <[EMAIL PROTECTED]> wrote:
                 > > I liked the interviews where they told me about their project,
and
                 > > I told them how I could contribute - strengths and weaknesses.
                 > > I'm great at *.  I don't know much about YYY, but I'm
willing
                 > to
                 > > learn..We cannot know everything.
                 > 
                 > That worked in the "good old days" (pre-2001), not any more, not
by a
                 > long shot
                 > These days one is expected to be EXPERT of everything the
employers
                 > list
                 > explicitly and implicitly (which seems to be getting longer...)
plus
                 > this and
                 > that
                 > 
                 > Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
                 > Server ?
                 > Sybase ?
                 > MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
                 > ?
                 > SAP? Essbase ?  Cognos ? Informatica ?
                 > 
                 > That's what's so freaky and hedious the job market for hands-on
                 > techies is.
                 > You ARE expected to know everything !
                 > 
                 > Robert Chin
                 > 
                 > -- 
                 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
                 > -- 
                 > Author: Robert Chin
                 >   INET: [EMAIL PROTECTED]
                 > 
                 > Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                 > San Diego, California        -- Public Internet access / Mailing
                 > Lists
                 >

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

Re: Embedding perl in Oracle

[Tim Bunce]

I'm putting together a "Using Perl with Oracle" talk (for the Perl
Whirl '02 GeekCruise conference) and would very much like to hear
from anyone who's used Jeff's extproc_perl.

The talk, like all my others, will be available from
http://cpan.valueclick.com/authors/id/TIMB/
once it's done.

Thanks.

Tim.

p.s. cross-posted to oracle-l and dbi-users, please reply direct or
ammend any followups.


On Wed, Dec 05, 2001 at 02:22:07AM -0800, Andy Duncan wrote:
> Hi Tim,
> 
> > > I've done it, it works.  Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > > That is being remedied however...
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme
> > I'll take a look and add that to my Perl Whirl talk.
> 
> You can also get hold of all of Jeff's other work, including the latest
> extproc_perl, at his personal site:
> 
> => http://www.smashing.org/
> 
> It's groovy, baby! :-)
> 
> Also, some useful extra utiltities for using Doug MacEachern's ExtUtils::Embed,
> which is used to drive extproc_perl, along with OCIExtProcContext et al, can be
> found in the full ExtUtils::Embed tarball download.  Particularly useful for
> Win32 users, is the genmake utility:
> 
> => http://www.cpan.org/authors/id/DOUGM/
> => http://www.cpan.org/authors/id/DOUGM/ExtUtils-Embed-1.14.tar.gz
> 
> The extproc_perl Oracle Perl Procedure Library is, IMHO, an amazing piece of
> work.  Just for starters, as a super-basic example, you can write a subroutine
> in a Perl bootfile, like this:
> 
> sub perl_localtime {
>my $x = localtime(time);
>return $x;
> }
> 
> And get output like this:
> 
> SQL> select perl('perl_localtime') localtime from dual;
> 
> LOCALTIME
> -
> Wed Dec  5 10:12:20 2001
> 
> 1 row selected.
> 
> SQL>
> 
> You can also link back to the Oracle database from within the Perl bootfile
> script using DBI, stay within the original transaction, and not create a new
> connection, as with SQLJ etc.  Fantastic stuff!!!
> 
> I really _do_ have to get out more! 8-)
> 
> Rgds,
> AndyD
> 
> =
> Make Someone Happy.  Buy a Copy of:
> => http://www.oreilly.com/catalog/oracleopen/
> -BEGIN GEEK CODE BLOCK-
> GO/SS/TW d- s+:+ a C++$ U++$ P$ L++$ !E W+ N+ K- W O- 
> M+ V-- PS+ PE++ Y+ PGP t+@ 5 X- R* tv- b+++ DI++ D G e++ 
> h r+++ y 
> --END GEEK CODE BLOCK--
> 
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: [EMAIL PROTECTED]

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

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

Re: sqlloader question

[Peter . McLarty]

Have a look at the section in sql loader on "applying  SQL to fields" in theSLQ Loader documents
else
 Is it possible for you to run the data through a Perl script to alter tha data before invoking sqlloader

Cheers



--
=
Peter McLarty               E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

    - Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=









[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
28/12/2001 04:55 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        sqlloader question


I need to load a text format file into my database using sqlloader.  The
table I am loading into contains a special code column  9 positions long
with a following format ##--###--## (note dashes in between).  Dashes are
being stored in the database! (don't ask me why :-)  ).  My input file data
for that column comes in straight text  ( no dashes, of course ).  It is 7
positions long.
Is there a way to somehow input dashes using control file while loading
data?  I've looked 'concatenate' sqlloader command.  It is not going to take
care of my need.
Thank you to everyone who replies.  Have a safe a joyful new year.

Lyuda Hoska

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




-- 
This transmission is for the intended addressee only and is confidential information.  If you have received this transmission in error, please delete it and notify the sender.  The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

RE: Firing order of triggers

[Kimberly Smith]

Why have three triggers?  I am not sure if things have changed in 9i
but previously there was not way to guarantee which trigger would fire
first.

-Original Message-
Darren
Sent: Thursday, December 27, 2001 1:25 PM
To: Multiple recipients of list ORACLE-L


Happy Holidays to everybody.

We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
there anyway
we can control which one fires first,second, third, .. n th

Thanks

Darren


--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons
Information and Communication Technology
City of Coquitlam
P:(604)927 - 3614
E:[EMAIL PROTECTED]

---


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

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

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

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

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

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

Re: database administration questions

[Stephane Faroult]

[EMAIL PROTECTED] wrote:
> 
> Software may become simpler for users, but to do so the
> software must be more complex internally.
> 

'Simpler for users' ? Hmmm, seeing the number of companies making
fortunes giving training on 'intuitive', 'point-and-click' products, I
am not so sure.

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

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

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

RE: HOW TO MAKE DELETION FAST

[Mohan, Ross]

indexes, yea, constraints, possibly. 

making sure the disk(s) holding the datafile(s) holding the index extent(s)
were as quiet as possible? Yes

Using parallel execution (in the case the delete has a WHERE clause ) Yes...

Peforming the delete while the database server was relatively quiet? Yes

"Every little bit helps"


hth, 

Ross

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


Would dropping indexes and (if applicable) disabling constraints on the
table, before deleting help ??

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

QOTD: Any clod can have facts, but having an opinion is an art!
-- 
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: RE: database administration questions

[Jared . Still]

Hmm...

You're the second person to tell me I'm too dense to 'get it'.

A couple of more and it might start to sink in.  :)

Jared




   

"Kimberly  

Smith"To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
Subject: RE: RE: database administration 
questions   
Sent by:   

[EMAIL PROTECTED]

m  

   

   

12/27/01 01:35 

PM 

Please respond 

to ORACLE-L

   

   





I could be wrong but I think he was making a play on your
words Jared.  not intimidated by love complexity


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L




Software is not getting simpler, and Oracle is no exception.

If you don't enjoy the complexity, you will find it tough going.

Software may become simpler for users, but to do so the
software must be more complex internally.

Jared






"Ron Rogers"

tery.org>cc:
Sent by: Subject: RE: RE: database
administration questions
[EMAIL PROTECTED]
om


12/27/01 11:50
AM
Please respond
to ORACLE-L






* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)

Would you care to elaborate on the "not intimidated by love complexity"
At my age "I WISH!!!"
ROR mô¿ôm

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

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

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




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

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

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

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

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

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




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

RE: Firing order of triggers

[Hamid Alavi]

Title: RE: Firing order of triggers



YOU 
CAN DISABLED ALL 3 TRIGGERS THEN ANY TIME YOU WANT TO FIRE IT ENABLED IT SO IT 
THIS WAY YOU HAVE FULL CONTROL TO RUN WHICH ONE FIRST.

  -Original Message-From: Jon Baker 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 27, 2001 1:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Firing order of triggers
  can you combine the code of all three into one trigger? 
  
  you can then easily programmatically determine what gets done 
  in what order. 
  -Original Message- From: 
  Browett, Darren [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, December 27, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Firing order of triggers 
  Happy Holidays to everybody. 
  We have three triggers (all BEFORE EACH ROW on INSERT ) 
  on  a table, is there anyway we can control which one fires first,second, third, .. n th 
  
  Thanks 
  Darren 
   
  -- 
  Darren Browett P.Eng    
      
      
      
      
      This message was transmitted Data 
  Administrator  
   
     
      
      
      using 100% recycled electrons Information and 
  Communication Technology City of Coquitlam 
  P:(604)927 - 3614 E:[EMAIL PROTECTED]  
  --- 
  
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Browett, Darren   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (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 message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system.

RE: Firing order of triggers

[Mohan, Ross]

Title: RE: Firing order of triggers



Ye! Exactly...this is a technique known to the Oracle Cognoscenti 

(you 
know who you are) as "Filing Down the Firing Pin" for automatic 
fire
 
Very 
Slick, Your Bakerness.
 
 

  -Original Message-From: Jon Baker 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 27, 2001 4:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Firing order of triggers
  can you combine the code of all three into one trigger? 
  
  you can then easily programmatically determine what gets done 
  in what order. 
  -Original Message- From: 
  Browett, Darren [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, December 27, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Firing order of triggers 
  Happy Holidays to everybody. 
  We have three triggers (all BEFORE EACH ROW on INSERT ) 
  on  a table, is there anyway we can control which one fires first,second, third, .. n th 
  
  Thanks 
  Darren 
   
  -- 
  Darren Browett P.Eng    
      
      
      
      
      This message was transmitted Data 
  Administrator  
   
     
      
      
      using 100% recycled electrons Information and 
  Communication Technology City of Coquitlam 
  P:(604)927 - 3614 E:[EMAIL PROTECTED]  
  --- 
  
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Browett, Darren   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: HOW TO MAKE DELETION FAST

[Jamadagni, Rajendra]

Would dropping indexes and (if applicable) disabling constraints on the
table, before deleting help ??

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

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



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

RE: RE: database administration questions

[Mohan, Ross]

Maybe it's Grandpa Lawrence that's getting simpler?


-Original Message-

ah, but didn't Uncle Larry say it's getting so simple we won't need
DBAs?

:)


--- [EMAIL PROTECTED] wrote:
> 
> 
> Software is not getting simpler, and Oracle is no exception.
> 
> If you don't enjoy the complexity, you will find it tough going.
> 
> Software may become simpler for users, but to do so the
> software must be more complex internally.
> 
> Jared
> 
> 
> 
> 
> 
>  
> 
> "Ron Rogers" 
> 
>  of list ORACLE-L <[EMAIL PROTECTED]>  
> tery.org>cc: 
> 
> Sent by: Subject: RE: RE:
> database administration questions   
> [EMAIL PROTECTED]   
> 
> om   
> 
>  
> 
>  
> 
> 12/27/01 11:50   
> 
> AM   
> 
> Please respond   
> 
> to ORACLE-L  
> 
>  
> 
>  
> 
> 
> 
> 
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> 
> Would you care to elaborate on the "not intimidated by love
> complexity"
> At my age "I WISH!!!"
> ROR mô¿ôm
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Deadlock Graphs

[Jamadagni, Rajendra]

Thanks ...

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

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


-Original Message-
Sent: Thursday, December 27, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


There are a couple of bulletins on Metalink that discuss interpreting the
deadlock graph and the various types of issues that can cause a deadlock. I
also found some info on the Adams site, www.ixora.com.au. Last but not
least, do a search at http://groups.google.com/ on the words deadlock
graph -- you will turn up even more info and links on the subject.

And if you like, post the deadlock graph to the list.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walter K
> Sent: Thursday, December 27, 2001 2:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Deadlock Graphs
>
>
> Hi,
>
> Can anyone provide some details, or perhaps point me
> to a web site, that explains the components of a
> deadlock graph (and/or the contents of the trace file)
> in detail? I'm trying to understand why some deadlocks
> are occurring in one of my systems and I'm having
> trouble trying to decipher the trace file.
>
> Thanks.
> -w
>
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Walter K
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

RE: HOW TO MAKE DELETION FAST

[Rachel Carmichael]

Stephen,

I agree with everything you suggested except #3 -- if he is deleting
that many rows, Oracle will ignore the indexes and will full table scan
the delete anyway. Last I heard (from Oracle University) was that if
Oracle expects more than 5-8% of the table to return from the query, it
will do a full table scan no matter what

Rachel

--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> OK.  Everyone is assuming that your deletion of millions of rows may
> be
> expedited by simply truncating the table.  Now, that would be perfect
> if you
> were simply emptying the table.  However, if data is to remain in the
> table,
> then truncate is not the preferred choice.  Here are some options
> along with
> some cautions.
> 
> 1. PL/SQL procedure to perform delete - If you are deleting data
> based on
> values in another table, you could use a DELETE with a correlated
> sub-query
> to delete data.  You could also add a counter to the PL/SQL code to
> delete
> 50,000 rows, commit the deletion and then continue.  Unfortunately,
> if you
> make a mistake with the DELETE, you must recover the table from
> Offline
> archivedlogs.  PL/SQL has never been the preferred choice for working
> with
> LOTS of data.
> 2. CTAS - Create Table as SELECT is another alternative.  If you can
> create
> another table with only the data you want, delete the original table
> and
> simply rename this new table to the old name, you may speed up the
> process.
> Additionally, creating the table as UNRECOVERABLE helps as it reduces
> the
> amount of redo data generated by Oracle.
> 3. Use indexes with the delete process - If your delete process is
> referencing non-indexed columns, you are performing a full table scan
> for
> the DELETE.  Using indexes will help performance significantly
> because the
> amount of data scanned is significantly reduced.
> 4. Traditional DELETE wit subquery - Same as PL/SQL offering except
> you
> cannot control the amount of data deleted between commits.
> 
>   These are four options.  Good luck.
> 
> Thank You
> 
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
> 
> 
>  -Original Message-
> Sent: Thursday, December 27, 2001 3:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: HOW TO MAKE DELETION FAST
> 
> TRUNCATE TABLE :-)
> 
> 
> -Original Message-
> Sent: Thursday, December 27, 2001 3:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gurus
> How to make deletetion of millions rows faster?
> Please suggest.
> Thx
> Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Karniotis, Stephen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.

RE: RE: database administration questions

[Rachel Carmichael]

ah, but didn't Uncle Larry say it's getting so simple we won't need
DBAs?

:)


--- [EMAIL PROTECTED] wrote:
> 
> 
> Software is not getting simpler, and Oracle is no exception.
> 
> If you don't enjoy the complexity, you will find it tough going.
> 
> Software may become simpler for users, but to do so the
> software must be more complex internally.
> 
> Jared
> 
> 
> 
> 
> 
>  
> 
> "Ron Rogers" 
> 
>  of list ORACLE-L <[EMAIL PROTECTED]>  
> tery.org>cc: 
> 
> Sent by: Subject: RE: RE:
> database administration questions   
> [EMAIL PROTECTED]   
> 
> om   
> 
>  
> 
>  
> 
> 12/27/01 11:50   
> 
> AM   
> 
> Please respond   
> 
> to ORACLE-L  
> 
>  
> 
>  
> 
> 
> 
> 
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> 
> Would you care to elaborate on the "not intimidated by love
> complexity"
> At my age "I WISH!!!"
> ROR mô¿ôm
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: HOW TO MAKE DELETION FAST

[Godlewski, Melissa]

Title: RE: HOW TO MAKE DELETION FAST





If you have indexes on the table you may want to drop prior to delete and rebuild them after it completes.


Does this table have foreign key constraints?  


Rowid is the fastest data access method.  


Create a interim table of the rowids for the rows you want deleted and delete from table where rowid in interim table rowid column.  

You may want to lock the table if you are worried about row migration.


-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L



Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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


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

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


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

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

RE: RE: database administration questions

[Mohan, Ross]

I do(did, when i cared deeply) bothread like a book most of
the conceptsparts of the adminthe rest gets dipped into
just as you described. 

Lot's of dipping, oh yea. 

That's the skinny on dipping, methinks. 


Autopunitively Yours, 

etc. 

-Original Message-
Sent: Thursday, December 27, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


don't know about you, but I'd be bored to tears and not retain anything
if I read the manuals straight through. 

I read the "new features", the "concepts" and then go merrily digging
and following links as I need new stuff works best for me


--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> yea, so it takes a year or sonot a Herculean task, methinks. 
> 
> -Original Message-
> Sent: Thursday, December 27, 2001 1:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> A problem with RTFM is when the manual is over 10,000 pages long.
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> 
>  -Original Message-
> Sent: Thursday, December 27, 2001 2:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: RE: database administration questions
> 
> 
> Yeah, once they find out this job isn't a cakewalk, they vanish.
> 
> For those that:
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> * can't forget about a problem until it's fixed
> * willing to RTFM til they drop
> * design and execute tests to understand how things work
> * RTFM some more
> * drive technology.  Hey, there's more to a good DBA than databases.
> * did I mention RTFM?
> * learn from their mistakes
> * admit they make mistakes
> * RTFM to minimize mistakes
> 
> All others need not apply.
> 
> Jared
> 
> "No guts, no glory"  ;)
> 
> 
> 
>  
> 
> "Kimberly
> 
> Smith"To: Multiple recipients
> of
> list ORACLE-L <[EMAIL PROTECTED]>  
>  
> tlink.net>Subject: RE: RE:
> database
> administration questions   
> Sent by:
> 
> [EMAIL PROTECTED]
> 
> m
> 
>  
> 
>  
> 
> 12/27/01 09:00
> 
> AM
> 
> Please respond
> 
> to ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> You need to find some new cooks then.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, December 27, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In our shop we've tried the cross training tact.  Problem was that
> those
> who
> accepted the challenge could not take the heat, so they left the
> kitchen.
> Damn!!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> Date:   12/26/2001 4:50 PM
> 
> I quite agree with Kimberly. I used to be a full-fledge Oracle
> programmer
> but wanted to dabble with database administration. I asked my boss
> whether
> I
> could be a database administrator. His answer is yes but I still need
> to
> maintain my current systems.  Now, I am a database
> administrator-cum-programmer.  I support turnkey projects, automate
> processes for my users, maintain current projects, install/maintain
> database
> & support Oracle Applications etc.
> 
> Prepare for lots of OT but what the heck, U will get to learn a lots
> of
> interesting things in the process 
> 
> New Bees
> -Original Message-
> From:   Kimberly Smith
> [mailto:[EMAIL PROTECTED]]
> Sent:   Thursday, December 27, 2001 1:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject:RE: database administration questions
> 
> If you work on a site like I do you could always
> cross
> train.  I am always
> looking for suckers (um, people) to be my backup. 
> Right
> now
> I use one from
> the Unix team and one from the development team.  Its
> the
> only way I get to
> take vacations and what no.  Check with your current
> DBA
> and
> see if they are
> willing to train you while you are off doing your
> 'real'
> job.  Of course,
> there are some folks who are worried about job
> security (or
> are just
> assholes)
> and they would not give you the time of day.  You
> don't
> want
> to learn from
> those folks anyway.  The excuse, "I'm too busy" is
> not
> really valid either.
> Training someone allowed me to offload some of my
> work.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, December 26, 2001 5:30 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> With your

RE: RE: database administration questions

[Kimberly Smith]

I could be wrong but I think he was making a play on your
words Jared.  not intimidated by love complexity


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L




Software is not getting simpler, and Oracle is no exception.

If you don't enjoy the complexity, you will find it tough going.

Software may become simpler for users, but to do so the
software must be more complex internally.

Jared






"Ron Rogers"

tery.org>cc:
Sent by: Subject: RE: RE: database
administration questions
[EMAIL PROTECTED]
om


12/27/01 11:50
AM
Please respond
to ORACLE-L






* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)

Would you care to elaborate on the "not intimidated by love complexity"
At my age "I WISH!!!"
ROR mô¿ôm

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

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

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




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

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

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

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

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

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

RE: Firing order of triggers

[Jon Baker]

Title: RE: Firing order of triggers





can you combine the code of all three into one trigger?


you can then easily programmatically determine what gets done in what order.




-Original Message-
From: Browett, Darren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 27, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Firing order of triggers



Happy Holidays to everybody.


We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
there anyway
we can control which one fires first,second, third, .. n th


Thanks


Darren



--
Darren Browett P.Eng                        This message
was transmitted
Data Administrator                  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



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


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

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

[Rachel Carmichael]

don't know about you, but I'd be bored to tears and not retain anything
if I read the manuals straight through. 

I read the "new features", the "concepts" and then go merrily digging
and following links as I need new stuff works best for me


--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> yea, so it takes a year or sonot a Herculean task, methinks. 
> 
> -Original Message-
> Sent: Thursday, December 27, 2001 1:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> A problem with RTFM is when the manual is over 10,000 pages long.
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> 
>  -Original Message-
> Sent: Thursday, December 27, 2001 2:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: RE: database administration questions
> 
> 
> Yeah, once they find out this job isn't a cakewalk, they vanish.
> 
> For those that:
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> * can't forget about a problem until it's fixed
> * willing to RTFM til they drop
> * design and execute tests to understand how things work
> * RTFM some more
> * drive technology.  Hey, there's more to a good DBA than databases.
> * did I mention RTFM?
> * learn from their mistakes
> * admit they make mistakes
> * RTFM to minimize mistakes
> 
> All others need not apply.
> 
> Jared
> 
> "No guts, no glory"  ;)
> 
> 
> 
>  
> 
> "Kimberly
> 
> Smith"To: Multiple recipients
> of
> list ORACLE-L <[EMAIL PROTECTED]>  
>  
> tlink.net>Subject: RE: RE:
> database
> administration questions   
> Sent by:
> 
> [EMAIL PROTECTED]
> 
> m
> 
>  
> 
>  
> 
> 12/27/01 09:00
> 
> AM
> 
> Please respond
> 
> to ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> You need to find some new cooks then.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, December 27, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In our shop we've tried the cross training tact.  Problem was that
> those
> who
> accepted the challenge could not take the heat, so they left the
> kitchen.
> Damn!!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> Date:   12/26/2001 4:50 PM
> 
> I quite agree with Kimberly. I used to be a full-fledge Oracle
> programmer
> but wanted to dabble with database administration. I asked my boss
> whether
> I
> could be a database administrator. His answer is yes but I still need
> to
> maintain my current systems.  Now, I am a database
> administrator-cum-programmer.  I support turnkey projects, automate
> processes for my users, maintain current projects, install/maintain
> database
> & support Oracle Applications etc.
> 
> Prepare for lots of OT but what the heck, U will get to learn a lots
> of
> interesting things in the process 
> 
> New Bees
> -Original Message-
> From:   Kimberly Smith
> [mailto:[EMAIL PROTECTED]]
> Sent:   Thursday, December 27, 2001 1:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject:RE: database administration questions
> 
> If you work on a site like I do you could always
> cross
> train.  I am always
> looking for suckers (um, people) to be my backup. 
> Right
> now
> I use one from
> the Unix team and one from the development team.  Its
> the
> only way I get to
> take vacations and what no.  Check with your current
> DBA
> and
> see if they are
> willing to train you while you are off doing your
> 'real'
> job.  Of course,
> there are some folks who are worried about job
> security (or
> are just
> assholes)
> and they would not give you the time of day.  You
> don't
> want
> to learn from
> those folks anyway.  The excuse, "I'm too busy" is
> not
> really valid either.
> Training someone allowed me to offload some of my
> work.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, December 26, 2001 5:30 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> With your current background, your more likely to
> land a
> job
> as a network
> administrator LONG before you'll end up in a database
> position.  Access is
> still
> looked on as a single user system and frankly I
> haven't run
> into any large
> scale
> applications that use it, period.  One

RE: Firing order of triggers

[Jamadagni, Rajendra]

No ... you can't control that ... the order is undefined

Easier solution would be to merge the logic in one trigger rather than 3,
and THEN you can control the flow of actions.

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

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


-Original Message-
Sent: Thursday, December 27, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


Happy Holidays to everybody.

We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
there anyway we can control which one fires first,second, third, .. n th

Thanks
Darren




*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

RE: RE: database administration questions

[Rachel Carmichael]

and the index is getting better and better, you can search there as
well for things


--- [EMAIL PROTECTED] wrote:
> 
> Sorry, I don't find that a problem.
> 
> Use the index, look for relevant chapters in the manual.
> 
> The online manuals have a search feature.  It's also
> available via WWW at tahiti.oracle.com.
> 
> If you're not sure where to read, then ask someone.
> 
> Asking where to find something in the manual is fine.
> 
> Just don't expect others to do the research.
> 
> Jared
> 
> 
> 
>  
>
> "Boivin, Patrice 
>
> J"  To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>  
> <[EMAIL PROTECTED]   cc:  
>
> mpo.gc.ca>  Subject: RE: RE:
> database administration questions   
> Sent by: 
>
> [EMAIL PROTECTED] 
>
>  
>
>  
>
> 12/27/01 10:50 AM
>
> Please respond to
>
> ORACLE-L 
>
>  
>
>  
>
> 
> 
> 
> 
> A problem with RTFM is when the manual is over 10,000 pages long.
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> 
>  -Original Message-
> Sent:   Thursday, December 27, 2001 2:15 PM
> To:Multiple recipients of list ORACLE-L
> 
> 
> Yeah, once they find out this job isn't a cakewalk, they vanish.
> 
> For those that:
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> * can't forget about a problem until it's fixed
> * willing to RTFM til they drop
> * design and execute tests to understand how things work
> * RTFM some more
> * drive technology.  Hey, there's more to a good DBA than databases.
> * did I mention RTFM?
> * learn from their mistakes
> * admit they make mistakes
> * RTFM to minimize mistakes
> 
> All others need not apply.
> 
> Jared
> 
> "No guts, no glory"  ;)
> 
> 
> 
> 
> 
> "Kimberly
> 
> Smith"To: Multiple recipients
> of
> list ORACLE-L <[EMAIL PROTECTED]>
>  
> tlink.net>Subject: RE: RE:
> database
> administration questions
> Sent by:
> 
> [EMAIL PROTECTED]
> 
> m
> 
> 
> 
> 
> 
> 12/27/01 09:00
> 
> AM
> 
> Please respond
> 
> to ORACLE-L
> 
> 
> 
> 
> 
> 
> 
> 
> 
> You need to find some new cooks then.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, December 27, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In our shop we've tried the cross training tact.  Problem was that
> those
> who
> accepted the challenge could not take the heat, so they left the
> kitchen.
> Damn!!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> Date:   12/26/2001 4:50 PM
> 
> I quite agree with Kimberly. I used to be a full-fledge Oracle
> programmer
> but wanted to dabble with database administration. I asked my boss
> whether
> I
> could be a database administrator. His answer is yes but I still need
> to
> maintain my current systems.  Now, I am a database
> administrator-cum-programmer.  I support turnkey projects, automate
> processes for my users, maintain current projects, install/maintain
> database
> & support Oracle Applications etc.
> 
> Prepare for lots of OT but what the heck, U will get to learn a lots
> of
> interesting things in the process 
> 
> New Bees
> -Original Message-
> From:   Kimberly Smith
> [mailto:[EMAIL PROTECTED]]
> Sent: 

Firing order of triggers

[Browett, Darren]

Happy Holidays to everybody.

We have three triggers (all BEFORE EACH ROW on INSERT ) on  a table, is
there anyway
we can control which one fires first,second, third, .. n th

Thanks

Darren


--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


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

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

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

[Mohan, Ross]

i believe he was referring, tongue in cheek, to the complexities of love. 

Writing in abject apology for the offtopicity of this post, 

Ross

-Original Message-
Sent: Thursday, December 27, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L




Software is not getting simpler, and Oracle is no exception.

If you don't enjoy the complexity, you will find it tough going.

Software may become simpler for users, but to do so the
software must be more complex internally.

Jared





 

"Ron Rogers"

  
tery.org>cc:

Sent by: Subject: RE: RE: database
administration questions   
[EMAIL PROTECTED]

om

 

 

12/27/01 11:50

AM

Please respond

to ORACLE-L

 

 





* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)

Would you care to elaborate on the "not intimidated by love complexity"
At my age "I WISH!!!"
ROR mô¿ôm

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

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

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




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

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

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

[George Schlossnagle]

Ok...  but that doesn't answer my original 
question either and I also then have to post-process it.  If I could query 
x$ksmpp for it, then I could get the info online.  
 
'You can't do it' is a fine answer as 
well
 
 
george
 

  - Original Message - 
  From: 
  Khedr, 
  Waleed 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, December 27, 2001 3:50 
  PM
  Subject: RE: x$ksmpp table question
  
  dump 
  the heap.
  
-Original Message-From: George Schlossnagle [mailto:[EMAIL PROTECTED]]Sent: 
Thursday, December 27, 2001 3:35 PMTo: Multiple recipients of 
list ORACLE-LSubject: Re: x$ksmpp table 
question
I want access to the fll heap structure 
though.   My process pga is huge, I want to see what the 
allocations are.
 
George
 

  - Original Message - 
  From: 
  Khedr, 
  Waleed 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Thursday, December 27, 2001 
  2:20 PM
  Subject: RE: x$ksmpp table 
  question
  
  George,
   
  You can get the PGA information you're looking for from 
  v$sesstat
  Query v$statname: select * from v$statname where name like 
  '%pga%'
  get the statistic# and query v$sesstat for that 
  session.
   
  Waleed
  
-Original Message-From: George Schlossnagle 
[mailto:[EMAIL PROTECTED]]Sent: 
Thursday, December 27, 2001 2:00 PMTo: Multiple recipients of 
list ORACLE-LSubject: x$ksmpp table 
question
I have a question about the x$ksmpp 
table.  Supposedly (according to Steve Adams' internals book) is 
the reference table for the heap allocation for a processes 
pga.  I assume this means for a processes own pga.  If so, is 
it possible  (and if so how) to access the same data for an 
arbitrary shadow process (in particular, not the one associated with the 
ssession running the query).
 
Thanks,
 
George
 
--- http://www.pythian.com --  [EMAIL PROTECTED] 
--  877-PYTHIANSmarter than adding another team member, 
Pythian has new services forsupplementing DBAs: get our help with 
monitoring, 24x7 on-call, dailyverifications, storage management, 
performance and 
more.

RE: Deadlock Graphs

[Larry Elkins]

There are a couple of bulletins on Metalink that discuss interpreting the
deadlock graph and the various types of issues that can cause a deadlock. I
also found some info on the Adams site, www.ixora.com.au. Last but not
least, do a search at http://groups.google.com/ on the words deadlock
graph -- you will turn up even more info and links on the subject.

And if you like, post the deadlock graph to the list.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walter K
> Sent: Thursday, December 27, 2001 2:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Deadlock Graphs
>
>
> Hi,
>
> Can anyone provide some details, or perhaps point me
> to a web site, that explains the components of a
> deadlock graph (and/or the contents of the trace file)
> in detail? I'm trying to understand why some deadlocks
> are occurring in one of my systems and I'm having
> trouble trying to decipher the trace file.
>
> Thanks.
> -w
>
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Walter K
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: RE: database administration questions

[Rachel Carmichael]

or as Marlene, Jim and I not so jokingly ask in DBA 101 (if you can
answer yes to most of these, you have what it takes to become an Oracle
DBA):

Are you able to function at top efficiency with little or no sleep -
possibly for days at a time?

Do you like getting phone calls in the middle of the night that aren't
a wrong number?

Do you enjoy being the "invisible" person in your organization, that
is, until something goes wrong?

Do you enjoy life under a microscope?

Do you enjoy long lines of people outside your door? 

Do you enjoy spending time filling out electronic iTARs in the off
chance that a human being will actually pick them up, read, and respond
to them in a "timely manner?"

Do you love solving puzzles that make no sense?

Is your favorite weekend meal Twinkies and Coca-Cola, and do you view
pizza as a seven-day-a-week healthy meal plan?

Do you love being on a perpetual steep learning curve?

Do you enjoy the challenge of moving between different computer
platforms?

Do you believe that you'll have enough time to teach yourself  (possible choices: XML, 9i, PL/SQL, Built-in Packages, Java,
etc.)?

--- [EMAIL PROTECTED] wrote:
> 
> Yeah, once they find out this job isn't a cakewalk, they vanish.
> 
> For those that:
> 
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> * can't forget about a problem until it's fixed
> * willing to RTFM til they drop
> * design and execute tests to understand how things work
> * RTFM some more
> * drive technology.  Hey, there's more to a good DBA than databases.
> * did I mention RTFM?
> * learn from their mistakes
> * admit they make mistakes
> * RTFM to minimize mistakes
> 
> All others need not apply.
> 
> Jared
> 
> "No guts, no glory"  ;)
> 
> 
> 
>  
>  
> "Kimberly
>  
> Smith"To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>  
>   
> tlink.net>Subject: RE: RE:
> database administration questions   
> Sent by: 
>  
> [EMAIL PROTECTED]  
>  
> m
>  
>  
>  
>  
>  
> 12/27/01 09:00   
>  
> AM   
>  
> Please respond   
>  
> to ORACLE-L  
>  
>  
>  
>  
>  
> 
> 
> 
> 
> You need to find some new cooks then.
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, December 27, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> In our shop we've tried the cross training tact.  Problem was that
> those
> who
> accepted the challenge could not take the heat, so they left the
> kitchen.
> Damn!!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> Date:   12/26/2001 4:50 PM
> 
> I quite agree with Kimberly. I used to be a full-fledge Oracle
> programmer
> but wanted to dabble with database administration. I asked my boss
> whether
> I
> could be a database administrator. His answer is yes but I still need
> to
> maintain my current systems.  Now, I am a database
> administrator-cum-programmer.  I support turnkey projects, automate
> processes for my users, maintain current projects, install/maintain
> database
> & support Oracle Applications etc.
> 
> Prepare for lots of OT but what the heck, U will get to learn a lots
> of
> interesting things in the process 
> 
> New Bees
> -Original Message-
> From:   Kimberly Smith
> [mailto:[EMAIL PROTECTED]]
> Sent:   Thursday, December 27, 2001 1:

RE: HOW TO MAKE DELETION FAST

[Karniotis, Stephen]

OK.  Everyone is assuming that your deletion of millions of rows may be
expedited by simply truncating the table.  Now, that would be perfect if you
were simply emptying the table.  However, if data is to remain in the table,
then truncate is not the preferred choice.  Here are some options along with
some cautions.

1. PL/SQL procedure to perform delete - If you are deleting data based on
values in another table, you could use a DELETE with a correlated sub-query
to delete data.  You could also add a counter to the PL/SQL code to delete
50,000 rows, commit the deletion and then continue.  Unfortunately, if you
make a mistake with the DELETE, you must recover the table from Offline
archivedlogs.  PL/SQL has never been the preferred choice for working with
LOTS of data.
2. CTAS - Create Table as SELECT is another alternative.  If you can create
another table with only the data you want, delete the original table and
simply rename this new table to the old name, you may speed up the process.
Additionally, creating the table as UNRECOVERABLE helps as it reduces the
amount of redo data generated by Oracle.
3. Use indexes with the delete process - If your delete process is
referencing non-indexed columns, you are performing a full table scan for
the DELETE.  Using indexes will help performance significantly because the
amount of data scanned is significantly reduced.
4. Traditional DELETE wit subquery - Same as PL/SQL offering except you
cannot control the amount of data deleted between commits.

  These are four options.  Good luck.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Thursday, December 27, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: HOW TO MAKE DELETION FAST

TRUNCATE TABLE :-)


-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

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

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

SQL Loader Question

[Ken Janusz]

I have two control files.  Each file loads from a different flat file to a
series of Oracle (8.1.7) tables.  Is there a way I can place both of these
files together into one control file or on parfile?  

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

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

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

RE: RE: database administration questions

[Jared . Still]

Software is not getting simpler, and Oracle is no exception.

If you don't enjoy the complexity, you will find it tough going.

Software may become simpler for users, but to do so the
software must be more complex internally.

Jared





   
   
"Ron Rogers"   
   
  
tery.org>cc:   
   
Sent by: Subject: RE: RE: database administration 
questions   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
12/27/01 11:50 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)

Would you care to elaborate on the "not intimidated by love complexity"
At my age "I WISH!!!"
ROR mô¿ôm

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

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

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




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

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

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

[MILLER, DAVID L (CONTRACTOR)]

SET ORACLE-L DIGEST

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MILLER, DAVID L (CONTRACTOR)
  INET: [EMAIL PROTECTED]

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

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

RE: Deadlock Graphs

[Jamadagni, Rajendra]

I'd be interesting in this too...

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

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


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


Hi,

Can anyone provide some details, or perhaps point me to a web site, that
explains the components of a deadlock graph (and/or the contents of the
trace file) in detail? I'm trying to understand why some deadlocks are
occurring in one of my systems and I'm having trouble trying to decipher the
trace file.

Thanks.
-w



*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

RE: x$ksmpp table question

[Khedr, Waleed]

dump 
the heap.

  -Original Message-From: George Schlossnagle 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 27, 2001 3:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  x$ksmpp table question
  I want access to the fll heap structure 
  though.   My process pga is huge, I want to see what the allocations 
  are.
   
  George
   
  
- Original Message - 
From: 
Khedr, 
Waleed 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, December 27, 2001 2:20 
PM
Subject: RE: x$ksmpp table 
question

George,
 
You can get the PGA information you're looking for from 
v$sesstat
Query v$statname: select * from v$statname where name like 
'%pga%'
get the statistic# and query v$sesstat for that 
session.
 
Waleed

  -Original Message-From: George Schlossnagle [mailto:[EMAIL PROTECTED]]Sent: 
  Thursday, December 27, 2001 2:00 PMTo: Multiple recipients of 
  list ORACLE-LSubject: x$ksmpp table 
  question
  I have a question about the x$ksmpp 
  table.  Supposedly (according to Steve Adams' internals book) is 
  the reference table for the heap allocation for a processes 
  pga.  I assume this means for a processes own pga.  If so, is it 
  possible  (and if so how) to access the same data for an arbitrary 
  shadow process (in particular, not the one associated with the ssession 
  running the query).
   
  Thanks,
   
  George
   
  --- http://www.pythian.com --  [EMAIL PROTECTED] 
  --  877-PYTHIANSmarter than adding another team member, 
  Pythian has new services forsupplementing DBAs: get our help with 
  monitoring, 24x7 on-call, dailyverifications, storage management, 
  performance and 
more.

RE: HOW TO MAKE DELETION FAST

[Khedr, Waleed]

how many rows are left? or what is the percentage of rows will be deleted?

-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

Deadlock Graphs

[Walter K]

Hi,

Can anyone provide some details, or perhaps point me
to a web site, that explains the components of a
deadlock graph (and/or the contents of the trace file)
in detail? I'm trying to understand why some deadlocks
are occurring in one of my systems and I'm having
trouble trying to decipher the trace file.

Thanks.
-w

__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  INET: [EMAIL PROTECTED]

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

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

Re: x$ksmpp table question

[George Schlossnagle]

I want access to the fll heap structure 
though.   My process pga is huge, I want to see what the allocations 
are.
 
George
 

  - Original Message - 
  From: 
  Khedr, 
  Waleed 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, December 27, 2001 2:20 
  PM
  Subject: RE: x$ksmpp table question
  
  George,
   
  You 
  can get the PGA information you're looking for from 
  v$sesstat
  Query v$statname: select * from v$statname where name like 
  '%pga%'
  get 
  the statistic# and query v$sesstat for that session.
   
  Waleed
  
-Original Message-From: George Schlossnagle [mailto:[EMAIL PROTECTED]]Sent: 
Thursday, December 27, 2001 2:00 PMTo: Multiple recipients of 
list ORACLE-LSubject: x$ksmpp table question
I have a question about the x$ksmpp 
table.  Supposedly (according to Steve Adams' internals book) is 
the reference table for the heap allocation for a processes pga.  
I assume this means for a processes own pga.  If so, is it 
possible  (and if so how) to access the same data for an arbitrary 
shadow process (in particular, not the one associated with the ssession 
running the query).
 
Thanks,
 
George
 
--- http://www.pythian.com --  [EMAIL PROTECTED] 
--  877-PYTHIANSmarter than adding another team member, Pythian 
has new services forsupplementing DBAs: get our help with monitoring, 
24x7 on-call, dailyverifications, storage management, performance and 
more.

Re: HOW TO MAKE DELETION FAST

[Ron Rogers]

Seema,
 You did not say how many rows you wanted to keep. If the number is small then I would 
create a table as select.. nologging. and populate it with the rows you want to keep. 
Then truncate the original table and repopulate it with the rows you saved in the 
secondary table. This way the HWM gets reset and and frees up the space not used 
anymore.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 12/27/01 03:00PM >>>
Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com 

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

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

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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: HOW TO MAKE DELETION FAST

[lhoska]

TRUNCATE TABLE :-)


-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

RE: HOW TO MAKE DELETION FAST

[Sherman, Paul R.]

If you do not need to log the deletions, truncate the table, then coalesce
the tablespace in question.

Thank you,

Paul Sherman
DBA
voice -  781-501-4143 (office)
fax-  781-278-8341 (office)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

Re: VNI-2015 LInux server / winNT station / Linux server

[Srini . Chavali]

Joe/Kim,
It *is* a security risk. See Note 167001.1 on MetaLink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc




Joe Testa <[EMAIL PROTECTED]>@fatcity.com on 12/21/2001 07:00:17 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



well if it is owned by oracle then only oracle type jobs can be executed
by the (un)intelligent agent),  if you needed to run a job that needed
privileges outside of oracle, it wont run, hence the reason it needed to
be owned and setuid of root.

is it a security risk, no doubt, would i run it on my prod machines,
probably not but for development, i would.

joe


Kimberly Smith wrote:

> Well, if root is suppose to own it then how come
> when it was changed it to oracle it worked?  I must
> say, I never looked but I installed the 9i OEM and
> did not run root.sh after and it still worked.  Since
> I don't have root access I don't see how it could be
> owned by root.  That was on HP.  Just confused.
>
> -Original Message-
> Sent: Friday, December 21, 2001 1:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> because root is supposed to own it.
>
> root.sh sets it, last i checked,
>
> joe
>
> Kimberly Smith wrote:
>
>
>>How did root end up owning it???
>>
>>-Original Message-
>>Sent: Friday, December 21, 2001 10:20 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Guys!!!
>>
>>I found the problem, you just needed to change the ownership of the
dbsnmp
>>file from root to oracle, after that everything is working!!!
>>
>>thanks to the people who took of their time on this one.
>>
>>Jose
>>
>>
>>
>>At 06:05 AM 12/21/01 -0800, you wrote:
>>
>>
>>>Joe;
>>>
>>>I already tried that, I went to my linux server, I installed the OMS,
it's
>>>up and working, I discovered the node and the database, the agent dsnmp
is
>>>working, I am logon as oracle, I created an account under the same name,
>>>with all the rights and roles available, I have the credentials set to
>>>this accounts for linux and oracle database user, and I am still getting
>>>the same thing
>>>
>>>And about the article from Mr. Raube (thanks for your time on this one),
I
>>>have already tried that, I was login in as a local user, I set that
>>>account with all the rights from the windows user manager, and still the
>>>same problem. I am getting desperate with this problem, because I
haven't
>>>backup my database and I don't want any unsuspected problems, please any
>>>other help would be greatly appreciate it.
>>>
>>>thanks in advance for your time and comments!!
>>>
>>>At 03:25 PM 12/20/01 -0800, you wrote:
>>>
>>>
leave windows and go to unix.

joe


Joe Raube wrote:



>I searched OTN and found this:
>http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/

>
> a
>
>>85247/ch6.htm
>>
>>
>"Note:
>The Windows NT or Windows 2000 Domain User works only if the machine
is
>a primary domain controller (PDC); otherwise, jobs will fail with
>VNI-2015 "authentication error." In all non-PDC environments the
account
>must be local to the machine. "
>-Joe
>At 01:31 PM 12/20/01 -0800, you wrote:
>
>
>
>>I have a Linux server running Oracle Standart 8I, I already setup the
>>init file with the exclusive value to accept backup jobs, I also
>>created a special account with sysdba, sysoper, and dba rights and a
>>linux account same name password and with all rights to sysoper,
sysdba
>>and root groups. On the nt side I have the same account local and in
>>the domain both with the log on as batch logs from the advance
rights,
>>same password, administrator rights for both, I also have the same
name
>>and password unde the OEM as a manager with superuser rights, and I
>>have set the preferences for default node and linux node with the
same
>>name, even the service for the database is the same as sysdba, and
>>still when I try to send a job, I get this VNI-2015 and the job
reports
>>failed, I even created a file with the orapwd with the same account
>>name and the password. So if somebody could give a couple of ideas,
out
>>of this, I will appreciate it, I have read all of the messages and I
>>tried all, I have no more ideas, I thanks for your help and time on
>>this one in advance. Jose
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: tomas
>>INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing
Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or 

HOW TO MAKE DELETION FAST

[Seema Singh]

Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

RE: RE: database administration questions

[Ron Rogers]

* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)

Would you care to elaborate on the "not intimidated by love complexity"
At my age "I WISH!!!"
ROR mô¿ôm

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

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

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

RE: RE: database administration questions

[Mohan, Ross]

yea, so it takes a year or sonot a Herculean task, methinks. 

-Original Message-
Sent: Thursday, December 27, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L


A problem with RTFM is when the manual is over 10,000 pages long.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, December 27, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: RE: database administration questions


Yeah, once they find out this job isn't a cakewalk, they vanish.

For those that:

* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)
* can't forget about a problem until it's fixed
* willing to RTFM til they drop
* design and execute tests to understand how things work
* RTFM some more
* drive technology.  Hey, there's more to a good DBA than databases.
* did I mention RTFM?
* learn from their mistakes
* admit they make mistakes
* RTFM to minimize mistakes

All others need not apply.

Jared

"No guts, no glory"  ;)



 

"Kimberly

Smith"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>  
Subject: RE: RE: database
administration questions   
Sent by:

[EMAIL PROTECTED]

m

 

 

12/27/01 09:00

AM

Please respond

to ORACLE-L

 

 





You need to find some new cooks then.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L


In our shop we've tried the cross training tact.  Problem was that those
who
accepted the challenge could not take the heat, so they left the kitchen.
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether
I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain
database
& support Oracle Applications etc.

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right
now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take vacations and what no.  Check with your current DBA
and
see if they are
willing to train you while you are off doing your 'real'
job.  Of course,
there are some folks who are worried about job security (or
are just
assholes)
and they would not give you the time of day.  You don't
want
to learn from
those folks anyway.  The excuse, "I'm too busy" is not
really valid either.
Training someone allowed me to offload some of my work.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


With your current background, your more likely to land a
job
as a network
administrator LONG before you'll end up in a database
position.  Access is
still
looked on as a single user system and frankly I haven't run
into any large
scale
applications that use it, period.  One of my current tasks
is working with a
forecasting package that states in the manual that Access
should only be
used
for the demos.  Any other application of the package should
use Oracle or
DB2.
Also a SPC (Statistical Process Control, for those who
don't
know, don't ask
further) package we're evaluating (actually two of them)
won't work with
Access
even for the demos.  Therefore, I'd suggest staying with
the
networking
world.
It will be around as long as database administration, if
not
longer.  Your
  

RE: RE: database administration questions

[Jared . Still]

Sorry, I don't find that a problem.

Use the index, look for relevant chapters in the manual.

The online manuals have a search feature.  It's also
available via WWW at tahiti.oracle.com.

If you're not sure where to read, then ask someone.

Asking where to find something in the manual is fine.

Just don't expect others to do the research.

Jared



   
  
"Boivin, Patrice   
  
J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc:
  
mpo.gc.ca>  Subject: RE: RE: database 
administration questions   
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
12/27/01 10:50 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




A problem with RTFM is when the manual is over 10,000 pages long.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, December 27, 2001 2:15 PM
To:Multiple recipients of list ORACLE-L


Yeah, once they find out this job isn't a cakewalk, they vanish.

For those that:

* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)
* can't forget about a problem until it's fixed
* willing to RTFM til they drop
* design and execute tests to understand how things work
* RTFM some more
* drive technology.  Hey, there's more to a good DBA than databases.
* did I mention RTFM?
* learn from their mistakes
* admit they make mistakes
* RTFM to minimize mistakes

All others need not apply.

Jared

"No guts, no glory"  ;)





"Kimberly

Smith"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: RE: database
administration questions
Sent by:

[EMAIL PROTECTED]

m





12/27/01 09:00

AM

Please respond

to ORACLE-L









You need to find some new cooks then.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L


In our shop we've tried the cross training tact.  Problem was that those
who
accepted the challenge could not take the heat, so they left the kitchen.
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether
I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain
database
& support Oracle Applications etc.

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right
now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take v

RE: x$ksmpp table question

[Khedr, Waleed]

George,
 
You 
can get the PGA information you're looking for from 
v$sesstat
Query 
v$statname:  select * from v$statname where name like 
'%pga%'
get 
the statistic# and query v$sesstat for that session.
 
Waleed

  -Original Message-From: George Schlossnagle 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 27, 2001 
  2:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  x$ksmpp table question
  I have a question about the x$ksmpp table.  
  Supposedly (according to Steve Adams' internals book) is the reference 
  table for the heap allocation for a processes pga.  I assume this means 
  for a processes own pga.  If so, is it possible  (and if so how) to 
  access the same data for an arbitrary shadow process (in particular, not the 
  one associated with the ssession running the query).
   
  Thanks,
   
  George
   
  --- http://www.pythian.com --  [EMAIL PROTECTED] 
  --  877-PYTHIANSmarter than adding another team member, Pythian 
  has new services forsupplementing DBAs: get our help with monitoring, 24x7 
  on-call, dailyverifications, storage management, performance and 
  more.

Re: Help - DBA interview questions I faced

[Dwayne Cox]

Thanks Patrice!  That was an outstanding synopsis!  And it explains why I am 
behind the curve...I have been a little reluctant (such an understatement) to 
make the time commitment.  Guess there's nothing to it but to do it.  Thanks 
for the encouragement/push!

-D-


On Thursday 27 December 2001 07:55 am, Boivin, Patrice J wrote:
> Dharan,
>
> Read the Concepts Manual again.  If you can, go through the DBA 101 book
> and perhaps some of those "Starter Kits" Oracle Press has been cranking out
> lately.
>
> Are you administering Oracle database(s) now?  Take time to poke around and
> see what is happening.  Create a user account for yourself to experiment
> with, being careful not to cripple the rest of the system.  You can do that
> by ensuring you don't have rights / privileges that give you too much
> freedom on the database.
>
> To understand, you need to read (know), but you also need to practice
> (experience).  Once you will have done both, you will have learned from
> mistakes and you will understand what is happening.  That will also give
> you a handle on which questions are relevant and which are not during
> interviews.  Your next Oracle interview might be administered by someone
> who knows little or nothing about Oracle.  (i.e. they are looking for a
> DBA, because their previous one left in disgust or they never had one).
>
> If you understand the basics of Oracle and you demonstrate during the
> interview that you do not consider saving face (putting up appearances)
> being more important than learning and fixing problems, you will have an
> honest chance at being hired as a junior DBA.
>
> At first you will have to live, eat, breathe, dream Oracle.  You have to
> decide on this path and never give up.  Never giving up is a crucial DBA
> trait.  You have to be more stubborn than the server(s) you administer. 
> You also have to be willing to change your approach if the previous one
> didn't work, the end result is what you aim for, and it is what you keep
> striving for until you get there.  You have to take personal responsibility
> for the systems you administer.  You must be reliable.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>

-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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

[Bill Gentry]

and is incorrect in the first place!

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: Thursday, December 27, 2001 12:50 PM


> A problem with RTFM is when the manual is over 10,000 pages long.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
>  -Original Message-
> Sent: Thursday, December 27, 2001 2:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: database administration questions
>
>
> Yeah, once they find out this job isn't a cakewalk, they vanish.
>
> For those that:
>
> * live for challenge
> * are afraid of nothing and not intimidated by complexity
> * make that, 'love complexity'  ;)
> * can't forget about a problem until it's fixed
> * willing to RTFM til they drop
> * design and execute tests to understand how things work
> * RTFM some more
> * drive technology.  Hey, there's more to a good DBA than databases.
> * did I mention RTFM?
> * learn from their mistakes
> * admit they make mistakes
> * RTFM to minimize mistakes
>
> All others need not apply.
>
> Jared
>
> "No guts, no glory"  ;)
>
>
>
>
>
> "Kimberly
>
> Smith"To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> 
> tlink.net>Subject: RE: RE: database
> administration questions
> Sent by:
>
> [EMAIL PROTECTED]
>
> m
>
>
>
>
>
> 12/27/01 09:00
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> You need to find some new cooks then.
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, December 27, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> In our shop we've tried the cross training tact.  Problem was that those
> who
> accepted the challenge could not take the heat, so they left the kitchen.
> Damn!!!
>
> Dick Goulet
>
> Reply Separator
> Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> Date:   12/26/2001 4:50 PM
>
> I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
> but wanted to dabble with database administration. I asked my boss whether
> I
> could be a database administrator. His answer is yes but I still need to
> maintain my current systems.  Now, I am a database
> administrator-cum-programmer.  I support turnkey projects, automate
> processes for my users, maintain current projects, install/maintain
> database
> & support Oracle Applications etc.
>
> Prepare for lots of OT but what the heck, U will get to learn a lots of
> interesting things in the process 
>
> New Bees
> -Original Message-
> From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
> Sent:   Thursday, December 27, 2001 1:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject:RE: database administration questions
>
> If you work on a site like I do you could always cross
> train.  I am always
> looking for suckers (um, people) to be my backup.  Right
> now
> I use one from
> the Unix team and one from the development team.  Its the
> only way I get to
> take vacations and what no.  Check with your current DBA
> and
> see if they are
> willing to train you while you are off doing your 'real'
> job.  Of course,
> there are some folks who are worried about job security
(or
> are just
> assholes)
> and they would not give you the time of day.  You don't
> want
> to learn from
> those folks anyway.  The excuse, "I'm too busy" is not
> really valid either.
> Training someone allowed me to offload some of my work.
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, December 26, 2001 5:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> With your current background, your more likely to land a
> job
> as a network
> administrator LONG before you'll end up in a database
> position.  Access is
> still
> looked on as a single user system and frankly I haven't
run
> into any large
> scale
> applications that use it, period.  One of my current tasks
> is working with a
> forecasting package that states in the manual that Access
> should only be
> used
> for the demos.  Any other application of the package
should
> use Oracle or
> DB2.
> Also a SPC (Statistical Process Control, for those who

x$ksmpp table question

[George Schlossnagle]

I have a question about the x$ksmpp table.  
Supposedly (according to Steve Adams' internals book) is the reference 
table for the heap allocation for a processes pga.  I assume this means for 
a processes own pga.  If so, is it possible  (and if so how) to access 
the same data for an arbitrary shadow process (in particular, not the one 
associated with the ssession running the query).
 
Thanks,
 
George
 
--- http://www.pythian.com --  [EMAIL PROTECTED] --  
877-PYTHIANSmarter than adding another team member, Pythian has new services 
forsupplementing DBAs: get our help with monitoring, 24x7 on-call, 
dailyverifications, storage management, performance and 
more.

sqlloader question

[lhoska]

I need to load a text format file into my database using sqlloader.  The
table I am loading into contains a special code column  9 positions long
with a following format ##--###--## (note dashes in between).  Dashes are
being stored in the database! (don't ask me why :-)  ).  My input file data
for that column comes in straight text  ( no dashes, of course ).  It is 7
positions long.
Is there a way to somehow input dashes using control file while loading
data?  I've looked 'concatenate' sqlloader command.  It is not going to take
care of my need.
Thank you to everyone who replies.  Have a safe a joyful new year.

Lyuda Hoska

-- 
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: RE: database administration questions

[Boivin, Patrice J]

A problem with RTFM is when the manual is over 10,000 pages long.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, December 27, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: RE: database administration questions


Yeah, once they find out this job isn't a cakewalk, they vanish.

For those that:

* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)
* can't forget about a problem until it's fixed
* willing to RTFM til they drop
* design and execute tests to understand how things work
* RTFM some more
* drive technology.  Hey, there's more to a good DBA than databases.
* did I mention RTFM?
* learn from their mistakes
* admit they make mistakes
* RTFM to minimize mistakes

All others need not apply.

Jared

"No guts, no glory"  ;)



 

"Kimberly

Smith"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>  
Subject: RE: RE: database
administration questions   
Sent by:

[EMAIL PROTECTED]

m

 

 

12/27/01 09:00

AM

Please respond

to ORACLE-L

 

 





You need to find some new cooks then.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L


In our shop we've tried the cross training tact.  Problem was that those
who
accepted the challenge could not take the heat, so they left the kitchen.
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether
I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain
database
& support Oracle Applications etc.

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right
now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take vacations and what no.  Check with your current DBA
and
see if they are
willing to train you while you are off doing your 'real'
job.  Of course,
there are some folks who are worried about job security (or
are just
assholes)
and they would not give you the time of day.  You don't
want
to learn from
those folks anyway.  The excuse, "I'm too busy" is not
really valid either.
Training someone allowed me to offload some of my work.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


With your current background, your more likely to land a
job
as a network
administrator LONG before you'll end up in a database
position.  Access is
still
looked on as a single user system and frankly I haven't run
into any large
scale
applications that use it, period.  One of my current tasks
is working with a
forecasting package that states in the manual that Access
should only be
used
for the demos.  Any other application of the package should
use Oracle or
DB2.
Also a SPC (Statistical Process Control, for those who
don't
know, don't ask
further) package we're evaluating (actually two of them)
won't work with
Access
even for the demos.  Therefore, I'd suggest staying with
the
networking
world.
It will be around as long as database administration, if
not
longer.  Your
already trained and certified, and getting a Cisco
certification is no small
feat.  If you really want to move into database admin, your
probably looking

RE: RE: database administration questions

[Jared . Still]

Yeah, once they find out this job isn't a cakewalk, they vanish.

For those that:

* live for challenge
* are afraid of nothing and not intimidated by complexity
* make that, 'love complexity'  ;)
* can't forget about a problem until it's fixed
* willing to RTFM til they drop
* design and execute tests to understand how things work
* RTFM some more
* drive technology.  Hey, there's more to a good DBA than databases.
* did I mention RTFM?
* learn from their mistakes
* admit they make mistakes
* RTFM to minimize mistakes

All others need not apply.

Jared

"No guts, no glory"  ;)



   

"Kimberly  

Smith"To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
Subject: RE: RE: database administration 
questions   
Sent by:   

[EMAIL PROTECTED]

m  

   

   

12/27/01 09:00 

AM 

Please respond 

to ORACLE-L

   

   





You need to find some new cooks then.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L


In our shop we've tried the cross training tact.  Problem was that those
who
accepted the challenge could not take the heat, so they left the kitchen.
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether
I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain
database
& support Oracle Applications etc.

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right
now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take vacations and what no.  Check with your current DBA
and
see if they are
willing to train you while you are off doing your 'real'
job.  Of course,
there are some folks who are worried about job security (or
are just
assholes)
and they would not give you the time of day.  You don't
want
to learn from
those folks anyway.  The excuse, "I'm too busy" is not
really valid either.
Training someone allowed me to offload some of my work.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


With your current background, your more likely to land a
job
as a network
administrator LONG before you'll end up in a database
position.  Access is
still
looked on as a single user system and frankly I haven

RE: Help - DBA interview questions I faced

[Jared . Still]

Patrice,

This is excellent!  Thanks capsulizing the essence of a DBA.

Make that a *good* DBA.  :)

Jared



   
  
"Boivin, Patrice   
  
J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc:
  
mpo.gc.ca>  Subject: RE: Help - DBA interview 
questions I faced  
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
12/27/01 04:55 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Dharan,

Read the Concepts Manual again.  If you can, go through the DBA 101 book
and
perhaps some of those "Starter Kits" Oracle Press has been cranking out
lately.

Are you administering Oracle database(s) now?  Take time to poke around and
see what is happening.  Create a user account for yourself to experiment
with, being careful not to cripple the rest of the system.  You can do that
by ensuring you don't have rights / privileges that give you too much
freedom on the database.

To understand, you need to read (know), but you also need to practice
(experience).  Once you will have done both, you will have learned from
mistakes and you will understand what is happening.  That will also give
you
a handle on which questions are relevant and which are not during
interviews.  Your next Oracle interview might be administered by someone
who
knows little or nothing about Oracle.  (i.e. they are looking for a DBA,
because their previous one left in disgust or they never had one).

If you understand the basics of Oracle and you demonstrate during the
interview that you do not consider saving face (putting up appearances)
being more important than learning and fixing problems, you will have an
honest chance at being hired as a junior DBA.

At first you will have to live, eat, breathe, dream Oracle.  You have to
decide on this path and never give up.  Never giving up is a crucial DBA
trait.  You have to be more stubborn than the server(s) you administer.
You
also have to be willing to change your approach if the previous one didn't
work, the end result is what you aim for, and it is what you keep striving
for until you get there.  You have to take personal responsibility for the
systems you administer.  You must be reliable.

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

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

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

[Kimberly Smith]

You need to find some new cooks then.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L


In our shop we've tried the cross training tact.  Problem was that those who
accepted the challenge could not take the heat, so they left the kitchen.
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain database
& support Oracle Applications etc.

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take vacations and what no.  Check with your current DBA and
see if they are
willing to train you while you are off doing your 'real'
job.  Of course,
there are some folks who are worried about job security (or
are just
assholes)
and they would not give you the time of day.  You don't want
to learn from
those folks anyway.  The excuse, "I'm too busy" is not
really valid either.
Training someone allowed me to offload some of my work.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


With your current background, your more likely to land a job
as a network
administrator LONG before you'll end up in a database
position.  Access is
still
looked on as a single user system and frankly I haven't run
into any large
scale
applications that use it, period.  One of my current tasks
is working with a
forecasting package that states in the manual that Access
should only be
used
for the demos.  Any other application of the package should
use Oracle or
DB2.
Also a SPC (Statistical Process Control, for those who don't
know, don't ask
further) package we're evaluating (actually two of them)
won't work with
Access
even for the demos.  Therefore, I'd suggest staying with the
networking
world.
It will be around as long as database administration, if not
longer.  Your
already trained and certified, and getting a Cisco
certification is no small
feat.  If you really want to move into database admin, your
probably looking
at
2 to 3 years of learning and smaller paychecks as you pay
your dues.

BTW: A database restore usually takes a lot longer than
fixing a network
outage,
to boot.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   12/23/2001 11:15 PM

Hi!
I'm looking into getting into the field of Database
Administrating.  Right
now, I have experience with MS Access and have created
several databases for
companies that I have worked with in the past with Access.

I'm looking for a jump in my career and the next logical
step for me, I
would
think, would be in database field.  However, I also have
some networking
knowledge (Cisco certified...).  So, I'm looking into the
advantages of both
fields.  I have some questions & I'm not sure who to ask or
where to get my
answers.  But, here they go:

Questions for a Database Administrator:

1)  What is your typical workday like?
2) Do you work a lot of overtime?
3) What are the most valuable databse programs to learn?
 

RE: Data Archiving

[Kimberly Smith]

Title: Data Archiving



No 
matter what I think you have a headache on your hand.  I think the PL/SQL 
method will take forever.  Did you
think 
of maybe restoring a copy of the production database on the new server and then 
removing the objects you
don't 
need as well as records you don't need? 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Nirmal Kumar Muthu 
  KumaranSent: Thursday, December 27, 2001 1:11 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Data 
  Archiving
  Hi all, 
  New year Greetings. 
  We need to archive some history tables from 
  the production database to new server. Totally around 50 history 
  tables we need to move and each table 
  having around 10 million of records. Some of history tables having records, 
  which are required for another a year the production database, approximatedly 
  i can say around 2 million of records in each table
  like this. 
  So what is the best way to move these 
  tables?. 
  I suggested them to export/import tables and 
  delete invalid records. 
  But another team are planned to do it by a 
  simple pl/sql script by making cursor, check validity of record, if yes insert 
  into new server and then delete from production, repeat.
  I want to know the best way to do this job 
  without any major implications. 
  Both servers are oracle7.3.1. running on 
  VAX/VMS. 
  Thanks. 
  Nirmal. 

Re:RE: database administration questions

[dgoulet]

In our shop we've tried the cross training tact.  Problem was that those who
accepted the challenge could not take the heat, so they left the kitchen. 
Damn!!!

Dick Goulet

Reply Separator
Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Date:   12/26/2001 4:50 PM

I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether I
could be a database administrator. His answer is yes but I still need to
maintain my current systems.  Now, I am a database
administrator-cum-programmer.  I support turnkey projects, automate
processes for my users, maintain current projects, install/maintain database
& support Oracle Applications etc. 

Prepare for lots of OT but what the heck, U will get to learn a lots of
interesting things in the process 

New Bees
-Original Message-
From:   Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, December 27, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: database administration questions

If you work on a site like I do you could always cross
train.  I am always
looking for suckers (um, people) to be my backup.  Right now
I use one from
the Unix team and one from the development team.  Its the
only way I get to
take vacations and what no.  Check with your current DBA and
see if they are
willing to train you while you are off doing your 'real'
job.  Of course,
there are some folks who are worried about job security (or
are just
assholes)
and they would not give you the time of day.  You don't want
to learn from
those folks anyway.  The excuse, "I'm too busy" is not
really valid either.
Training someone allowed me to offload some of my work.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


With your current background, your more likely to land a job
as a network
administrator LONG before you'll end up in a database
position.  Access is
still
looked on as a single user system and frankly I haven't run
into any large
scale
applications that use it, period.  One of my current tasks
is working with a
forecasting package that states in the manual that Access
should only be
used
for the demos.  Any other application of the package should
use Oracle or
DB2.
Also a SPC (Statistical Process Control, for those who don't
know, don't ask
further) package we're evaluating (actually two of them)
won't work with
Access
even for the demos.  Therefore, I'd suggest staying with the
networking
world.
It will be around as long as database administration, if not
longer.  Your
already trained and certified, and getting a Cisco
certification is no small
feat.  If you really want to move into database admin, your
probably looking
at
2 to 3 years of learning and smaller paychecks as you pay
your dues.

BTW: A database restore usually takes a lot longer than
fixing a network
outage,
to boot.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   12/23/2001 11:15 PM

Hi!
I'm looking into getting into the field of Database
Administrating.  Right
now, I have experience with MS Access and have created
several databases for
companies that I have worked with in the past with Access.

I'm looking for a jump in my career and the next logical
step for me, I
would
think, would be in database field.  However, I also have
some networking
knowledge (Cisco certified...).  So, I'm looking into the
advantages of both
fields.  I have some questions & I'm not sure who to ask or
where to get my
answers.  But, here they go:

Questions for a Database Administrator:

1)  What is your typical workday like?
2) Do you work a lot of overtime?
3) What are the most valuable databse programs to learn?
4) If I was to look into learning these, should I take
classes?  Where would
you recommend I look for classes in the Los Angeles area?
 

Re: Data Archiving

[Steven Lembark]

-- Nirmal Kumar  Muthu Kumaran <[EMAIL PROTECTED]>

> Hi all,
>
> New year Greetings.
>
> We need to archive some history tables from the production database to new
> server. Totally around 50 history
> tables we need to move and each table having around 10 million of records.
> Some of history tables having records, which are required for another a
> year the production database, approximatedly i can say around 2 million of
> records in each table
> like this.
>
> So what is the best way to move these tables?.
>
> I suggested them to export/import tables and delete invalid records.
>
> But another team are planned to do it by a simple pl/sql script by making
> cursor, check validity of record, if yes insert into new server and then
> delete from production, repeat.

It will be far less work to do the same thing via DBI if you
want to stay w/in the running oracle server.

You can dump the stuff out to disk, filter it to new files
and re-insert it also (i.e., combine your export and their
filtering methods).

Main problem with single-row methods is that latency between
fetches will greatly increase the processing time -- this
has nothing to do with bandwidth, it's the turnaround time
required to re-access the curser, move it to the next record,
etc.

If you dump the data out delimeted (vs. fixed field) it will
save time by decreasing the disk writes. You can then access
the external files using perl and split /$delimieter/o, $line
to get the fields, examine them to your heart's content and
then print them to another delimeted file. After that suck up
the delimeted files and you're done with it. I've used that
method in data warehousing projects and it works well enough.
If the product Fast Unload for Oracle ("FUO") still exists
it does a faster job of dumping the data out; used to be
a Platinum Tech. product.

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

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

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

Re: Help - DBA interview questions I faced

[Rachel Carmichael]

Ramesh,

Don't be sorry, I just don't want people buying my book and expecting
Gaja and Kirti's wonderful stuff.

Thank you -- we tried hard to make the book a good one. We're in the
beginning stages of revising it for 9i and hope to make it even better.

Rachel

--- [EMAIL PROTECTED] wrote:
> Rachel,
> I'm Sorry for quoting wrong book. Actually I have both books and both
> are 
> excellent!
> 
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> http://www22.Brinkster.com/rpapnoi
> 
> -- Original Text --
> 
> To: internet["Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>]
> 
> dba 101 is not by gaja and kirti -- that's performance tuning 101
> which
> is indeed an excellent book
> 
> dba 101 is theriault, carmichael and viscusi.
> --- [EMAIL PROTECTED] wrote:
> > Dear Ravi
> > DBA 101 book - BY Gaja and kirti is available in India (indian
> > edition).  I 
> > already have one. Excelent book!!
> > 
> > Regards,
> > Ramesh D Papnoi
> > Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> > (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> > http://www22.Brinkster.com/rpapnoi
> > 
> > -- Original Text --
> > 
> > To: internet["Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>]
> > 
> > Dear Rachel,
> > 
> > Thanks for your reply and guidance.  Also thanks to
> > Kirti Deshpande and Jenny Jacobson  for their replies.
> >  In India Oracle DBA 101 book is not yet released. 
> > Once it is released I will defently purchase the book.
> >  
> > 
> > Regarding Question No.1, I told that Server Process is
> > the background process and sysauth or objauth view is
> > used to  check for username and password.  The
> > employer told me that I am wrong.  Could you pl
> > clarify.
> > 
> > 
> > 1)  When you enter 'sqlplus scott/tiger'  which
> > background process checks for authentication ?  From
> > which table/view it checks for authentication ?  If
> > password is wrong from where oracle throws the msg ? 
> > 
> > Regards.
> > Dharan.
> > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Dharani Ravi
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  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 your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTE

RE: XP vs. W2000

[Ken Janusz]

No magazine can be truly objective when they report on company products that
they receive advertising revenue from.  A negative report will mean lose of
revenue.  The newspaper industry found out this one the hard way with the
automobile industry.

Ken

 -Original Message-
Sent:   Thursday, December 27, 2001 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: XP vs. W2000

I wouldn't put my hopes on PC Magazine, I remember their "objective" reviews
of OS/2... They are not Consumer Report for the IT industry.

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]  


-Original Message-
From:   Larry Elkins [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, December 26, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: XP vs. W2000

As we are treading towards OT land, I've got a Dell PIII 750 with
512MB on
my desktop running WIN2K Pro. I just bought a laptop, Compaq
Presario PIII
1.0 Gig Chip with 512MB running XP Pro. I run 8i and 9i on both
machines.
The laptop is definitely snappier when running OEM 9i. With
comparably
configured laptops and desktops, you would expect the desktop to be
much
faster. So, even though my laptop has a 1 Ghz chip vs the 750 Mhz
chip on my
desktop, I expected the laptop to be slower. And it is when running
disk
intensive operations -- 4500 RPM on the laptop vs 7200 RPM and a
caching
controller on the desktop. But otherwise, the laptop with XP seems
to be a
tad faster, and maybe it's strictly due to the faster processor. It
would be
interesting to run some benchmarks against the same machine running
XP vs.
WIN2K -- I'm sure PC Magazine or some other group has already done
this.

And I haven't been on the Internet with the laptop since the XP
security
issues came to light. Something I need to address on the laptop.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

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

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

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

Re: Data Archiving

[Jay Hostetter]

Nirmal,

  Sometimes the simplest way to move data between two databases is with the SQL*Plus 
COPY command.

Jay

>>> [EMAIL PROTECTED] 12/27/01 04:10AM >>>
Hi all,

New year Greetings.

We need to archive some history tables from the production database to new
server. Totally around 50 history
tables we need to move and each table having around 10 million of records.
Some of history tables having records, which are required for another a year
the production database, approximatedly i can say around 2 million of
records in each table
like this. 

So what is the best way to move these tables?.

I suggested them to export/import tables and delete invalid records.

But another team are planned to do it by a simple pl/sql script by making
cursor, check validity of record, if yes insert into new server and then
delete from production, repeat.

I want to know the best way to do this job without any major implications.

Both servers are oracle7.3.1. running on VAX/VMS.

Thanks.

Nirmal.

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

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

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

[Boivin, Patrice J]

I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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]  


-Original Message-
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, December 26, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Help - DBA interview questions I faced

and eventually, when they realize they can't find that omniscient
person, they come back to reality


--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project,
and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great at *.  I don't know much about YYY, but I'm
willing
> to
> > learn..We cannot know everything.
> 
> That worked in the "good old days" (pre-2001), not any more, not
by a
> long shot
> These days one is expected to be EXPERT of everything the
employers
> list
> explicitly and implicitly (which seems to be getting longer...)
plus
> this and
> that
> 
> Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
> Server ?
> Sybase ?
> MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
> ?
> SAP? Essbase ?  Cognos ? Informatica ?
> 
> That's what's so freaky and hedious the job market for hands-on
> techies is.
> You ARE expected to know everything !
> 
> Robert Chin
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robert Chin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>

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

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

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

[Boivin, Patrice J]

Dharan,

Read the Concepts Manual again.  If you can, go through the DBA 101 book and
perhaps some of those "Starter Kits" Oracle Press has been cranking out
lately.

Are you administering Oracle database(s) now?  Take time to poke around and
see what is happening.  Create a user account for yourself to experiment
with, being careful not to cripple the rest of the system.  You can do that
by ensuring you don't have rights / privileges that give you too much
freedom on the database.

To understand, you need to read (know), but you also need to practice
(experience).  Once you will have done both, you will have learned from
mistakes and you will understand what is happening.  That will also give you
a handle on which questions are relevant and which are not during
interviews.  Your next Oracle interview might be administered by someone who
knows little or nothing about Oracle.  (i.e. they are looking for a DBA,
because their previous one left in disgust or they never had one).

If you understand the basics of Oracle and you demonstrate during the
interview that you do not consider saving face (putting up appearances)
being more important than learning and fixing problems, you will have an
honest chance at being hired as a junior DBA.

At first you will have to live, eat, breathe, dream Oracle.  You have to
decide on this path and never give up.  Never giving up is a crucial DBA
trait.  You have to be more stubborn than the server(s) you administer.  You
also have to be willing to change your approach if the previous one didn't
work, the end result is what you aim for, and it is what you keep striving
for until you get there.  You have to take personal responsibility for the
systems you administer.  You must be reliable.

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]  


-Original Message-
From:   Dharani Ravi [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, December 25, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Help - DBA interview questions I faced

Dear Rachel,

Thanks for your reply.  Initially I felt demoralised
after reading your  reply.  Truth is always bitter. 
You are correct.  My Oracle concepts knowledge needs
to be improved.  I read Oracle 8 concepts manual two
years ago.  I am working for a small company where
there are no seperate DBAs, System Administrators and
Network Admins.  Only three staff are identified to
look after the abovementioned jobs in addition to
development job.  Most of our time goes for report
generation, foxpro programs and other  activities.  I
do not have a senior person from whom I can learn the
job. Jobs like DB creation, maintanence, backup and
recovery are done by me and I learned the job from
manuals and by experience.  I wanted to work in a
production env where I can learn more about DBA job. 
I need your guidance and seniors guidance from this
group.  Hope you will appreciate my position and I
sincerely request you to clarify my doubts.  I will be
grateful to you If you can clarify my mistakes made by
me in the interview.  I seek the support from this
group to develop myself as a DBA.

Merry Christmas.

Regards.
Dharan.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Dharan,
> 
> Answering just those questions will not give you
> enough knowledge to
> truly be able to answer Oracle questions in an
> interview.
> 
> Based on the answers you gave, it seems to me that
> you do not
> understand the concepts behind how Oracle works at
> all.  I would
> suggest you read the documentation (specifically the
> Concepts and
> Administrator's manuals to start) to get a better
> understanding of
> Oracle.
> 
> I would also suggest you talk to the senior DBA
> where you are and ask
> him or her to help you learn about the database.
> 
> Rachel
> 
> --- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> > Dear Seniors,
> > 
> > I am a junior DBA and last weekend I attended a
> > interview for DBA post.  The following questions
> were
> > asked to me and I could not able to answer to the
> > employers satsifaction.  He asked me around 20
> > questions and the following are the questions
> where I
> > have not fared well.  Could Seniors help me by
 

RE: XP vs. W2000

[Boivin, Patrice J]

I wouldn't put my hopes on PC Magazine, I remember their "objective" reviews
of OS/2... They are not Consumer Report for the IT industry.

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]  


-Original Message-
From:   Larry Elkins [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, December 26, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: XP vs. W2000

As we are treading towards OT land, I've got a Dell PIII 750 with
512MB on
my desktop running WIN2K Pro. I just bought a laptop, Compaq
Presario PIII
1.0 Gig Chip with 512MB running XP Pro. I run 8i and 9i on both
machines.
The laptop is definitely snappier when running OEM 9i. With
comparably
configured laptops and desktops, you would expect the desktop to be
much
faster. So, even though my laptop has a 1 Ghz chip vs the 750 Mhz
chip on my
desktop, I expected the laptop to be slower. And it is when running
disk
intensive operations -- 4500 RPM on the laptop vs 7200 RPM and a
caching
controller on the desktop. But otherwise, the laptop with XP seems
to be a
tad faster, and maybe it's strictly due to the faster processor. It
would be
interesting to run some benchmarks against the same machine running
XP vs.
WIN2K -- I'm sure PC Magazine or some other group has already done
this.

And I haven't been on the Internet with the laptop since the XP
security
issues came to light. Something I need to address on the laptop.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

--
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: Data Archiving

[C.S.Venkata Subramanian]

Nirmal
After moving the data are u planning to delete the same from the original server. In 
7.3 direct=y will work. I suggest you write some pl/sql procedure or Pro*C utility 
that will move the data to new server whenever required based on the criteria you pass.

Venkat
--

On Thu, 27 Dec 2001 02:15:18  
 Arul kumar wrote:
>Hi Nirmal,
>
>Export/Import sounds good for this.
>
>I think u can give a try with DIRECT=Y option in exp utility (for faster
>export !).
>
>I am not sure abt this option in 7.3.. do give it a try.
>
>Arul.
>
>I am not sure abt this
>
>Nirmal Kumar Muthu Kumaran wrote:
>
>>
>>
>> Hi all,
>>
>> New year Greetings.
>>
>> We need to archive some history tables from the production database to
>> new server. Totally around 50 history
>> tables we need to move and each table having around 10 million of
>> records. Some of history tables having records, which are required for
>> another a year the production database, approximatedly i can say
>> around 2 million of records in each table
>>
>> like this.
>>
>> So what is the best way to move these tables?.
>>
>> I suggested them to export/import tables and delete invalid records.
>>
>> But another team are planned to do it by a simple pl/sql script by
>> making cursor, check validity of record, if yes insert into new server
>> and then delete from production, repeat.
>>
>> I want to know the best way to do this job without any major
>> implications.
>>
>> Both servers are oracle7.3.1. running on VAX/VMS.
>>
>> Thanks.
>>
>> Nirmal.
>
>*
>Disclaimer
>
>This message (including any attachments) contains 
>confidential information intended for a specific 
>individual and purpose, and is protected by law. 
>If you are not the intended recipient, you should 
>delete this message and are hereby notified that 
>any disclosure, copying, or distribution of this
>message, or the taking of any action based on it, 
>is strictly prohibited.
>
>*
>Visit us at http://www.mahindrabt.com


--
Click here for your very own create-a-date adventure from MatchMaker
Go to http://ecard.matchmaker.com/dating.html
-- 
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).

Re: Data Archiving

[Arul kumar]

Hi Nirmal,
Export/Import sounds good for this.
I think u can give a try with DIRECT=Y option in exp utility (for faster
export !).
I am not sure abt this option in 7.3.. do give it a try.
Arul.
I am not sure abt this
Nirmal Kumar Muthu Kumaran wrote:
 
Hi all,
New year Greetings.
We need to archive some history tables
from the production database to new server. Totally around 50 history
tables we need to move and each table
having around 10 million of records. Some of history tables having records,
which are required for another a year the production database, approximatedly
i can say around 2 million of records in each table
like this.
So what is the best way to move these
tables?.
I suggested them to export/import tables
and delete invalid records.
But another team are planned to do it
by a simple pl/sql script by making cursor, check validity of record, if
yes insert into new server and then delete from production, repeat.
I want to know the best way to do this
job without any major implications.
Both servers are oracle7.3.1. running
on VAX/VMS.
Thanks.
Nirmal.




*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com

Data Archiving

[Nirmal Kumar Muthu Kumaran]

Title: Data Archiving





Hi all,


New year Greetings.


We need to archive some history tables from the production database to new server. Totally around 50 history
tables we need to move and each table having around 10 million of records. Some of history tables having records, which are required for another a year the production database, approximatedly i can say around 2 million of records in each table

like this. 


So what is the best way to move these tables?.


I suggested them to export/import tables and delete invalid records.


But another team are planned to do it by a simple pl/sql script by making cursor, check validity of record, if yes insert into new server and then delete from production, repeat.

I want to know the best way to do this job without any major implications.


Both servers are oracle7.3.1. running on VAX/VMS.


Thanks.


Nirmal.