RE: What is a large database?

2003-09-11 Thread Guang Mei



There 
must be a "G" missing there. It should be "(20G or more Oracle 
tables)".
 
Guang

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent: 
  Thursday, September 11, 2003 11:49 AMTo: Multiple recipients of 
  list ORACLE-LSubject: What is a large 
database?
  I got a mail from a recruiter searching for 
  Senior Oracle Developers.
   
  "Minimum of four years hands-on application 
  programming experience using Oracle RDBMS, including two years using Oracle 
  version 8.0 or higher on large databases (20 or more Oracle 
  tables)."
   
  I've always wondered, where goes the 
  line between small and large databases, now I'm enlightened, if 
  you got at least 20 tables, then your db is large. Damn, I could have put 
  experience with VLDBs to my resume several years ago ;)
   
  Tanel.
   


Re: What is a large database?

2003-09-11 Thread M Rafiq
Tanel,

As I am still in the job  market looking for any full time assignment, I see 
all type of requirements like 5+ years 9i experience etc and will see in 
coming weeks same for 10g( 5+ years experience with Oracle 10g)..

What you can do for this when dealing with recruiters who even don't know 
what they want DBA or DeveloperThe worst problem with Oracle Financials 
where they are confused with Functional/Technical or Apps DBA requirement.

It is bad time to be in the job market.

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 07:49:25 -0800
I got a mail from a recruiter searching for Senior Oracle Developers.

"Minimum of four years hands-on application programming experience using 
Oracle RDBMS, including two years using Oracle version 8.0 or higher on 
large databases (20 or more Oracle tables)."

I've always wondered, where goes the line between small and large databases, 
now I'm enlightened, if you got at least 20 tables, then your db is large. 
Damn, I could have put experience with VLDBs to my resume several years ago 
;)

Tanel.

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

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


RE: What is a large database?

2003-09-11 Thread A.Bahar
  It is because of some oxes in  HR departments

-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L


Tanel,

As I am still in the job  market looking for any full time assignment, I see 
all type of requirements like 5+ years 9i experience etc and will see in 
coming weeks same for 10g( 5+ years experience with Oracle 10g)..

What you can do for this when dealing with recruiters who even don't know 
what they want DBA or DeveloperThe worst problem with Oracle Financials 
where they are confused with Functional/Technical or Apps DBA requirement.

It is bad time to be in the job market.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 07:49:25 -0800

I got a mail from a recruiter searching for Senior Oracle Developers.

"Minimum of four years hands-on application programming experience using 
Oracle RDBMS, including two years using Oracle version 8.0 or higher on 
large databases (20 or more Oracle tables)."

I've always wondered, where goes the line between small and large databases, 
now I'm enlightened, if you got at least 20 tables, then your db is large. 
Damn, I could have put experience with VLDBs to my resume several years ago 
;)

Tanel.

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

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

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

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


Re: What is a large database?

2003-09-11 Thread Tanel Poder
In Estonian language, the word "administrator" also means receptionist.
Guess how many former hotel receptionists or whatever security desk
operators I've had to turn down in past when they've looked for DBA job. Oh,
yes, some of them had over 20 years administrator experience in large
organizations, also lots of experience with 24x7 operations etc ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 8:04 PM


> Tanel,
>
> As I am still in the job  market looking for any full time assignment, I
see
> all type of requirements like 5+ years 9i experience etc and will see in
> coming weeks same for 10g( 5+ years experience with Oracle 10g)..
>
> What you can do for this when dealing with recruiters who even don't know
> what they want DBA or DeveloperThe worst problem with Oracle
Financials
> where they are confused with Functional/Technical or Apps DBA requirement.
>
> It is bad time to be in the job market.
>
> Regards
> Rafiq
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Thu, 11 Sep 2003 07:49:25 -0800
>
> I got a mail from a recruiter searching for Senior Oracle Developers.
>
> "Minimum of four years hands-on application programming experience using
> Oracle RDBMS, including two years using Oracle version 8.0 or higher on
> large databases (20 or more Oracle tables)."
>
> I've always wondered, where goes the line between small and large
databases,
> now I'm enlightened, if you got at least 20 tables, then your db is large.
> Damn, I could have put experience with VLDBs to my resume several years
ago
> ;)
>
> Tanel.
>
> _
> Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.
> http://join.msn.com/?PAGE=features/es
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: M Rafiq
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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


RE: What is a large database?

2003-09-11 Thread M Rafiq
Excellent..but most difficult part to pass through recruiters these 
days...

Date: Thu, 11 Sep 2003 09:29:24 -0800

  It is because of some oxes in  HR departments

-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Tanel,

As I am still in the job  market looking for any full time assignment, I see
all type of requirements like 5+ years 9i experience etc and will see in
coming weeks same for 10g( 5+ years experience with Oracle 10g)..
What you can do for this when dealing with recruiters who even don't know
what they want DBA or DeveloperThe worst problem with Oracle Financials
where they are confused with Functional/Technical or Apps DBA requirement.
It is bad time to be in the job market.

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 07:49:25 -0800
I got a mail from a recruiter searching for Senior Oracle Developers.

"Minimum of four years hands-on application programming experience using
Oracle RDBMS, including two years using Oracle version 8.0 or higher on
large databases (20 or more Oracle tables)."
I've always wondered, where goes the line between small and large databases,
now I'm enlightened, if you got at least 20 tables, then your db is large.
Damn, I could have put experience with VLDBs to my resume several years ago
;)
Tanel.

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.
http://join.msn.com/?PAGE=features/es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
Use custom emotions -- try MSN Messenger 6.0! 
http://www.msnmessenger-download.com/tracking/reach_emoticon

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


RE: What is a large database?

2003-09-11 Thread Mladen Gogala
And the database must be muave.
 
 
--
Mladen Gogala
Oracle DBA 


-Original Message-
Guang Mei
Sent: Thursday, September 11, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L


There must be a "G" missing there. It should be "(20G or more Oracle
tables)".
 
Guang

-Original Message-
nel
Poder
Sent: Thursday, September 11, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L


I got a mail from a recruiter searching for Senior Oracle Developers.
 
"Minimum of four years hands-on application programming experience using
Oracle RDBMS, including two years using Oracle version 8.0 or higher on
large databases (20 or more Oracle tables)."
 
I've always wondered, where goes the line between small and large databases,
now I'm enlightened, if you got at least 20 tables, then your db is large

Re: What is a large database?

2003-09-11 Thread Stephane Faroult
And possibly more than 20 tables in the hotel's restaurant ...

Tanel Poder wrote:
> 
> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or whatever security desk
> operators I've had to turn down in past when they've looked for DBA job. Oh,
> yes, some of them had over 20 years administrator experience in large
> organizations, also lots of experience with 24x7 operations etc ;)
> 
> Tanel.
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, September 11, 2003 8:04 PM
> 
> > Tanel,
> >
> > As I am still in the job  market looking for any full time assignment, I
> see
> > all type of requirements like 5+ years 9i experience etc and will see in
> > coming weeks same for 10g( 5+ years experience with Oracle 10g)..
> >
> > What you can do for this when dealing with recruiters who even don't know
> > what they want DBA or DeveloperThe worst problem with Oracle
> Financials
> > where they are confused with Functional/Technical or Apps DBA requirement.
> >
> > It is bad time to be in the job market.
> >
> > Regards
> > Rafiq
> >
> >
> >
> >
> >
> >
> > Reply-To: [EMAIL PROTECTED]
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: Thu, 11 Sep 2003 07:49:25 -0800
> >
> > I got a mail from a recruiter searching for Senior Oracle Developers.
> >
> > "Minimum of four years hands-on application programming experience using
> > Oracle RDBMS, including two years using Oracle version 8.0 or higher on
> > large databases (20 or more Oracle tables)."
> >
> > I've always wondered, where goes the line between small and large
> databases,
> > now I'm enlightened, if you got at least 20 tables, then your db is large.
> > Damn, I could have put experience with VLDBs to my resume several years
> ago
> > ;)
> >
> > Tanel.
> >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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


Re: What is a large database?

2003-09-12 Thread Nuno Souto
you should send them over to Australia.  At least they'd be
better than the standard of "dba" we get here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 


> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or whatever security desk
> operators I've had to turn down in past when they've looked for DBA job. Oh,
> yes, some of them had over 20 years administrator experience in large
> organizations, also lots of experience with 24x7 operations etc ;)
> 

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

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


RE: What is a large database?

2003-09-22 Thread Craig Munday
Hi,

Do you really think the standard of database administrators in Australia is
low?  What is it that you are expecting?

Cheers,
Craig.


-Original Message-
Sent: Friday, 12 September 2003 8:59 PM
To: Multiple recipients of list ORACLE-L


you should send them over to Australia.  At least they'd be
better than the standard of "dba" we get here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 


> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or whatever security desk
> operators I've had to turn down in past when they've looked for DBA job.
Oh,
> yes, some of them had over 20 years administrator experience in large
> organizations, also lots of experience with 24x7 operations etc ;)
> 

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

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

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


RE: What is a large database?

2003-09-22 Thread Suhen Pather
Title: RE: What is a large database?







I think there are many *poorly skilled* Oracle DBA's in Australia.


I had one of my clients sugest increasing the Oracle log_buffer to 10MB.
His claim is since the box has sufficient amount of memory "why not use a very large log buffer".
I do not think he reads the oracle docs very well and he knows when LGWR writes to the redo log files.


This was after I recommended changing an Oracle system disk configuration from RAID 5 ( 4 disks)
which includes the Windows OS on the same RAID 5 array to using a RAID 1 for the OS 
and multiple standalone and RAID 1 disks for Oracle.  Sugesting RAID 1 and standalone disks since there
are not enough disks that can fit into the array.  Client does not want to spend $$$ so they have only
a  5 disk array that we could use for Oracle.


Surpising enough the write cache on the disk array was set to 0 and 100% for the read cache on this particular 
RAID 5 system which does lots of small writes for the application making things even worse.


The DBA also sugested "but the BCHR is 99.7% which means that blah , blah , blah and in Oracle terms performance is very good".

It could be clearly seen from the Windows performance monitors and statspack that the IO sub system 
was being stressed and the only way to improve performance was to re arrange the disks to reduce the
contention between the various processes contending for IO resources. And get rid of the RAID 5 configuration.


Another thing that came up in my furious conversation with them was "but the disks has enough capacity blah blah blah,
why do we need additional disks".


I had to explain the concepts of RAID and how bad RAID 5 is for write performance esp when the datafiles, redo logs, archives,

control files and OS is on the same RAID 5 array.


No offense to any Oracle DBA in Australia as we all know there are some excellent DBA's here like Connor, Steve, 
Mark Gurry, Guy Harrison, Nuno Sunto, Howard Rogers, etc, etc


Anyway that was some humour I thought I should share with the list since we were on the topic of talented DBA's in Australia.

Regards
Suhen






-Original Message-
From: Craig Munday [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 September 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: What is a large database?



Hi,


Do you really think the standard of database administrators in Australia is
low?  What is it that you are expecting?


Cheers,
Craig.



-Original Message-
Sent: Friday, 12 September 2003 8:59 PM
To: Multiple recipients of list ORACLE-L



you should send them over to Australia.  At least they'd be
better than the standard of "dba" we get here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 



> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or whatever security desk
> operators I've had to turn down in past when they've looked for DBA job.
Oh,
> yes, some of them had over 20 years administrator experience in large
> organizations, also lots of experience with 24x7 operations etc ;)
> 


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


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


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





Re: What is a large database?

2003-09-23 Thread Nuno Souto
- Original Message - 

> Do you really think the standard of database administrators in Australia is
> low?  What is it that you are expecting?
> 

When projects sponsored and supported by such large 
companies as IBM and Oracle get 27 "DBAs" and 30 developers,
one has to start asking EXACTLY what does being a DBA in this 
country mean...


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

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


Re: What is a large database?

2003-09-23 Thread Nuno Souto
- Original Message - 

> Surpising enough the write cache on the disk array was set to 0 and 100% for
> the read cache on this particular 
> RAID 5 system which does lots of small writes for the application making
> things even worse.


Hehehe!  Can never win, eh?  :)

> 
> The DBA also sugested "but the BCHR is 99.7% which means that blah , blah ,
> blah and in Oracle terms performance is very good".


Ah yes, the ratios!  How much longer is that one gonna linger...


> Another thing that came up in my furious conversation with them was "but the
> disks has enough capacity blah blah blah,
> why do we need additional disks".


but, isn't a 256Gb disk faster than an 80Gb disk anyway?  It's 
what the hardware vendor told me!


> No offense to any Oracle DBA in Australia as we all know there are some
> excellent DBA's here like Connor, Steve, 
> Mark Gurry, Guy Harrison, Nuno Sunto, Howard Rogers, etc, etc

I dunno about the others and I certainly don't consider myself excellent.
But I suspect most will agree with me: given the poor standard of DBAs 
in Australia, I'd rather not be associated with that title, thank you very much.


Is it too much to ask to have my name spelled properly?
Or am I being singled out for any particular reason?


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

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


RE: What is a large database?

2003-09-23 Thread Jared . Still

It seems that DBA's with poor skills is not limited to any particular locale.

After all, people are pretty much the same in regards to personal
motivations, regardless of nationality.

We're all equally plagued by folks with a less than adequate skill set
and knowledge of systems they purport to be expert in.

Fortunately for us, there are a number of people on this list that
are very gifted, talented and hard working, as well as willing to
share their expertise.


Jared







Suhen Pather <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/23/2003 12:29 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: What is a large database?




I think there are many *poorly skilled* Oracle DBA's in Australia. 
I had one of my clients sugest increasing the Oracle log_buffer to 10MB. 
His claim is since the box has sufficient amount of memory "why not use a very large log buffer". 
I do not think he reads the oracle docs very well and he knows when LGWR writes to the redo log files. 
This was after I recommended changing an Oracle system disk configuration from RAID 5 ( 4 disks) 
which includes the Windows OS on the same RAID 5 array to using a RAID 1 for the OS 
and multiple standalone and RAID 1 disks for Oracle.  Sugesting RAID 1 and standalone disks since there 
are not enough disks that can fit into the array.  Client does not want to spend $$$ so they have only 
a  5 disk array that we could use for Oracle. 
Surpising enough the write cache on the disk array was set to 0 and 100% for the read cache on this particular 
RAID 5 system which does lots of small writes for the application making things even worse. 
The DBA also sugested "but the BCHR is 99.7% which means that blah , blah , blah and in Oracle terms performance is very good".
It could be clearly seen from the Windows performance monitors and statspack that the IO sub system 
was being stressed and the only way to improve performance was to re arrange the disks to reduce the 
contention between the various processes contending for IO resources. And get rid of the RAID 5 configuration. 
Another thing that came up in my furious conversation with them was "but the disks has enough capacity blah blah blah, 
why do we need additional disks". 
I had to explain the concepts of RAID and how bad RAID 5 is for write performance esp when the datafiles, redo logs, archives,
control files and OS is on the same RAID 5 array. 
No offense to any Oracle DBA in Australia as we all know there are some excellent DBA's here like Connor, Steve, 
Mark Gurry, Guy Harrison, Nuno Sunto, Howard Rogers, etc, etc 
Anyway that was some humour I thought I should share with the list since we were on the topic of talented DBA's in Australia.
Regards 
Suhen 




-Original Message- 
Sent: Tuesday, 23 September 2003 1:55 PM 
To: Multiple recipients of list ORACLE-L 

Hi, 
Do you really think the standard of database administrators in Australia is 
low?  What is it that you are expecting? 
Cheers, 
Craig. 

-Original Message- 
Sent: Friday, 12 September 2003 8:59 PM 
To: Multiple recipients of list ORACLE-L 

you should send them over to Australia.  At least they'd be 
better than the standard of "dba" we get here... 
Cheers 
Nuno Souto 
[EMAIL PROTECTED] 
- Original Message - 

> In Estonian language, the word "administrator" also means receptionist. 
> Guess how many former hotel receptionists or whatever security desk 
> operators I've had to turn down in past when they've looked for DBA job. 
Oh, 
> yes, some of them had over 20 years administrator experience in large 
> organizations, also lots of experience with 24x7 operations etc ;) 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Nuno Souto 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Craig Munday 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelli

OT Re: RE: What is a large database?

2003-09-11 Thread Guido Konsolke
Hi Mladen,

please excuse me. Since I try to improve my knowledge
about the English: what do youmean with muave? Some
kind of wood?

Please enlighten me.

Greetings,
Guido

>>> [EMAIL PROTECTED] 11.09.2003  20.49 Uhr >>>
And the database must be muave.
 
 
--
Mladen Gogala
Oracle DBA 


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

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


RE: OT Re: RE: What is a large database?

2003-09-12 Thread Mark Leith
LOL, Mauve is a shade of the colour Purple.

And of course, everybody knows that purple databases run faster! ;)

Personally, I've always preferred Electric Blue databases, funky, fast, and
FAR easier to manage!



-Original Message-
Guido Konsolke
Sent: 12 September 2003 08:54
To: Multiple recipients of list ORACLE-L


Hi Mladen,

please excuse me. Since I try to improve my knowledge
about the English: what do youmean with muave? Some
kind of wood?

Please enlighten me.

Greetings,
Guido

>>> [EMAIL PROTECTED] 11.09.2003  20.49 Uhr >>>
And the database must be muave.


--
Mladen Gogala
Oracle DBA


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

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

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


RE: OT Re: RE: What is a large database?

2003-09-12 Thread Hately, Mike (LogicaCMG)
Hmm, applied Feng Shui for Oracle Performance.

For optimum throughput storage should be coloured red and white in
alternating bands of colour.
It's called disk-striping.

Badummp-k !!

I'll get me coat ... and back on topic.

Mike

-Original Message-
Sent: 12 September 2003 11:14
To: Multiple recipients of list ORACLE-L


LOL, Mauve is a shade of the colour Purple.

And of course, everybody knows that purple databases run faster! ;)

Personally, I've always preferred Electric Blue databases, funky, fast, and
FAR easier to manage!





E mail Disclaimer

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

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

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

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  INET: [EMAIL PROTECTED]

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


RE: OT Re: RE: What is a large database?

2003-09-12 Thread Jesse, Rich
It's supposed to be "mauve", the color.  The reference is from a Dilbert
cartoon.  Google found a copy here:

http://www-dbs.cs.uni-sb.de/~dbs02/images/dilbert.gif

Rich

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


> -Original Message-
> From: Guido Konsolke
> [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 2:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: OT Re: RE: What is a large database?
> 
> 
> Hi Mladen,
> 
> please excuse me. Since I try to improve my knowledge
> about the English: what do youmean with muave? Some
> kind of wood?
> 
> Please enlighten me.
> 
> Greetings,
> Guido
> 
> >>> [EMAIL PROTECTED] 11.09.2003  20.49 Uhr >>>
> And the database must be muave.
>  
>  
> --
> Mladen Gogala
> Oracle DBA 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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


RE: OT Re: RE: What is a large database?

2003-09-12 Thread Mladen Gogala
Selling

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Jesse, Rich
> Sent: Friday, September 12, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT Re: RE: What is a large database?
> 
> 
> It's supposed to be "mauve", the color.  The reference is 
> from a Dilbert cartoon.  Google found a copy here:
> 
> http://www-dbs.cs.uni-sb.de/~dbs02/images/dilbert.gif
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -Original Message-
> > From: Guido Konsolke 
> > [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 12, 2003 2:54 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: OT Re: RE: What is a large database?
> > 
> > 
> > Hi Mladen,
> > 
> > please excuse me. Since I try to improve my knowledge
> > about the English: what do youmean with muave? Some
> > kind of wood?
> > 
> > Please enlighten me.
> > 
> > Greetings,
> > Guido
> > 
> > >>> [EMAIL PROTECTED] 11.09.2003  20.49 Uhr >>>
> > And the database must be muave.
> >  
> >  
> > --
> > Mladen Gogala
> > Oracle DBA
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

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