RE: oaktable people

[Carel-Jan Engel]

 I resemble that remark!  Aussies are ALWAYS great communicators, just a
 bit direct for some people sometime.  :)

Aussies aint direct, oh no. Just talk with Danish!

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  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: Re: Problem with understanding Optimization methods.

[Stephane Faroult]

To what Mladen said about the optimizer_blah parameters, there is another thing which 
can be added. Most third-party software is over-indexed (as you have noticed) because 
they optimistically want to cover *all* possible cases and quite often a column which 
is highly discreminant at one site contains a single value elsewhere and so on. What I 
mean is that it is common to have totally skewed distributions, and AFAIK collecting 
column statistics for the indexed columns isn't the default. Try it, the optimizer may 
then have more information, and pick intelligently the index which it picks randomly 
in rule mode. Especially if you follow Mladen's advice about cost adjustment.

HTH,

SF 

- --- Original Message --- -
From: Mladen Gogala [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 06 Jan 2004 22:09:24

You can find out by employing  the event 10053, lev
8.  Looking from afar, however, it seems more
likely that you haven't configured your CBO
properly. Here is something you can try:

Execute the following commands:

alter session set optimizer_index_caching=40;  
alter session set optimizer_index_cost_adj=25;



After that,  retry the query. If I'm correct,
optimizer will now know that index I/O is much
cheaper
then the table one and will be much more likely to
select full index scan over the full table scan.
When you're really, really bored, you can read
Practical Oracle 8i - Building Efficient Databases,

it has a few pages about the parameters above. 
Read the Gospel of Jonathan and enjoy.



On 2004.01.07 00:29, Denham Eva wrote:
 Hello Listers,
 
 A normal sql query from a data warehouse tool
called Sagent. 
 SELECT COL1, COL2, COL3
 FROM TABLE
 ORDER BY 3;
 
 The table has approximately 2 mil records.
 table has 22 indexes.
 
 The database is set up optimizer CHOOSE.
 I run
DBMS_Stats.Gather_Schema_Stats('SchemaName')
regularly.
 OS is Win2k
 ORACLE 81741
 
 OK, when doing a explain plan on the above sql, I
get the following...
 SELECT STATEMENT Optimizer Mode=CHOOSE
 SORT ORDER BY
  TABLE ACCESS FULL  TABLENAME
  -- Very slow and takes
 hours!
 
 When adding the hint /*+RULE*/ for example I get
 SELECT STATEMENT Optimizer Mode=Hint:RULE
TABLE ACCESS BY INDEX ROWID 
TABLENAME
INDEX FULL SCAN   
   TABLE_INDEX  --
 Much faster!!!
 
 Have I given enough info that anyone can explain
why the CHOOSE mode insists
 on doing a TABLE ACCESS FULL?
 Is there anything I can do to improve
performance? Please remember that this
 query comes from a Data Warehouse tool and hence
does not appear to accept
 hints.
 
 Any help will be much appreciated!
 Denham
  
-- 
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: Book (was) oaktable people

[Nuno Souto]

- Original Message - 

 
 (And unlike my presentations, I promise that there is
 no profanity in the book...)
 


You mean you gloss over BCHR?
Shame on you!
;)
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).

Sql question

[roland . skoldblom]

Hallo,

I have this sql query. I would like to change it  so I could pick out the three forst 
three charachters in the between statements.  How can I do that in the most simply way?

and vgr in (between 101 and 101)
  and vgr in (between 104 and 104)  order by Avdnr ,Datum1

in the statement above I woul dlike to do the changing,

select substr(Avdnr,2) Avdnr , Dato Datum1,  Dato datum2 , lpad(vgr,3) VGRP from 
kunlin A where transfil_id in
 (select transfil_id from transfil_dag where avdnr between 20 and 29 and dato 
between to_date
  ('2003-12-07','-mm-dd') and to_date ('2003-12-07','-mm-dd'))

  and vgr in (between 101 and 101)
  and vgr in (between 104 and 104)  order by Avdnr ,Datum1




Thanks in advance


Roland


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Hotsos' Classes

[Gudmundur Bjarni Josepsson]

Venu,

I've taken both PD101 and OP101 and I can thoroughly recommend both of
them.  The sequence of those two is irrelevant in my opinion.

If you're looking to improve your tuning skills and your understanding
of Oracle performance issues I would suggest the OP101.  It has a very
good balance of lectures and hands-on, brain-heating exercises.  You
will probably scratch your head when it comes to the exercises but they
really drive home what the lecturer has been talking about.  The
exercises take at least 50% of the time but of course I don't know of
the course will develop since the first beta class.

(The correct URL for the OP101 is
http://www.hotsos.com/courses/OP101.php).

Gudmundur

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Potluri, Venu (CT Appl Suppt)
 Sent: 6. janúar 2004 19:24
 To: Multiple recipients of list ORACLE-L
 Subject: Hotsos' Classes
 
 
 Is there a proper sequence of classes to take, among those 
 offered by Hotsos? While I do use Wait events to monitor  
 tune  my Oracle Financials databases, I need more training 
 in Performance tuning. I am just dipping my toes into the 
 world of Oracle Performance Tuning. I am reading Cary's book 
 and I have used Ixora's treasure of information, quite a bit 
 in the past. 
 
 I see there are a number of classes now as opposed to a 
 clinic in the past.
 
 Performance Diagnosis 101
 SQL Optimization 101
 Hotsos Symposium 2004
 Steve Adams Seminar
 
 While I would love to take all of them, time  work schedule 
 permitting, I wouldn't want to waste time either if any of 
 the subject matter goes above my head and I spend time 
 scratching my head. God knows I might even find SQL Tuning 
 class useful to brush up little that I know. Would the Hotsos 
 Symposium be not suitable for poeple like myself who haven't 
 taken the Performance Diagnostics 101 class and aren't well 
 versed with Performance Tuning? What is expected of the 
 audience in terms of prior knowledge? Mind you, I am not an 
 expert like most of you guys. Haven't written a book or even a paper!
 
 Venu Potluri
 Oracle Financials DBA
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Potluri, Venu (CT Appl Suppt)
   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: Gudmundur Bjarni Josepsson
  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: Moving Objects from One Tablespace to Another

[N.Anand Kumar]

This works well in ver 8 or higher how do we do in Oracle 7 version.

Anand Kumar
ITW Signode India Ltd





- Original Message -
To: LazyDBA.com Discussion
Sent: Wednesday, January 07, 2004 1:50 PM



alter table emp move tablespace tbs2;
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



  Vikas Sharma
  [EMAIL PROTECTED]To:   LazyDBA.com
Discussion [EMAIL PROTECTED]
  .co.in  cc:
   Subject:  Moving Objects from
One Tablespace to Another
  01/07/2004 01:07
  PM






How do I move my objects (say Tables) from One Tablespace to Another
without the need to recreate them?

Regards,

Vikas Sharma


Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
By using this list you agree to these terms:
http://www.lazydba.com/legal.html








Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: N.Anand Kumar
  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: Problem with understanding Optimization methods.

[Jonathan Lewis]

Check the costs of the two queries (autotrace will be
sufficient).

In this example, rule based uses the index because
it exists and will return the right answer.

Cost based works out that the scan and sort is
cheaper.

The cost of an index full scan is approximately
blevel  +  leaf_blocks  (columns from user_indexes).

The cost of the tablescan is
blocks / 'adjusted db_file_multiblock_read_count'
If your dbfmbrc is 8, use 6.59
If it's 16 use 10
If it's 32 use 16.4

The cost of the sort (which seems to be wrong
in 8.1.7.4) is likely to be about the same as the
cost of the tablescan.


So, as an example, pretend your dbfmbrc is 16,
then if the index is larger than 1/5th of the size
of the table, the scan and sort will work out
cheaper than the index full scan.


I am a little surprised, though, that you don't
have a path that is index FAST full scan.
This suggests that your index is actually
bigger than your table.  Maybe it's got
lots of holes in it.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 5:29 AM


 Hello Listers,

 A normal sql query from a data warehouse tool called Sagent.
 SELECT COL1, COL2, COL3
 FROM TABLE
 ORDER BY 3;

 The table has approximately 2 mil records.
 table has 22 indexes.

 The database is set up optimizer CHOOSE.
 I run DBMS_Stats.Gather_Schema_Stats('SchemaName') regularly.
 OS is Win2k
 ORACLE 81741

 OK, when doing a explain plan on the above sql, I get the following...
 SELECT STATEMENT Optimizer Mode=CHOOSE
 SORT ORDER BY
  TABLE ACCESS FULL  TABLENAME   -- Very slow and takes
 hours!

 When adding the hint /*+RULE*/ for example I get
 SELECT STATEMENT Optimizer Mode=Hint:RULE
TABLE ACCESS BY INDEX ROWID  TABLENAME
INDEX FULL SCAN   TABLE_INDEX  --
 Much faster!!!

 Have I given enough info that anyone can explain why the CHOOSE mode
insists
 on doing a TABLE ACCESS FULL?
 Is there anything I can do to improve performance? Please remember that
this
 query comes from a Data Warehouse tool and hence does not appear to accept
 hints.

 Any help will be much appreciated!
 Denham


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: ORACLE-L Digest -- Volume 2004, Number 007 (Out of Office

[Tony Miller]

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

OCP question from Boson practice tests

[Prem Khanna J]

Hi List, this is the question .


You are calculating the proper size for a temporary tablespace .
Which of the following are two most important factors to consider ?

A. users
B. sort_area_size
C. type of tablespace management
D. db_block_size


my choice is A  B .

but boson's choice is B  D . the explanation given by boson is :
when sizing a temporary tablespace , the formula is 
db_block_size * sort_area_size .

is it so ? do we need not take no. of users into account ?
kindly explain me .

Regards,
Prem.

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

Rollback segment shrinkage

[Satav, Pawan]

Hi,
  Can anyone point pros/cons of shrinking a rollback segment ? (other
than performance overheads associated with extent allocation and
reallocation)

  Optimal is not set for my rollback segments. Recently I shrunk a
rollback segments which had more than 100 extents allocated to it.

  

 Regards
Pawan Satav
Database Services





This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst  Young Group. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, you are not authorised to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all copies
of this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Satav, Pawan
  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).

another OCP question -- help me guys

[Prem Khanna J]

Hi list , sorry to pester you with questions regarding 
boson OCP questions . i have scheduled for #1Z0-031 exam
and so desperately need help from this list . 
please bear with me  for while . look at the 2 questions below .

-
QUESTION #1 
what happens when you issue the command below .
drop tablespace testtbs including contents cascade constraints and
datafiles;

A.the tablespace will be dropped , constraints will be droppped and the
datafiles will be taken out of the o/s.

B. statement will fail 

C.you must drop constraints before issuing this command.

this is what happens when i try on 9.2.0.4 :
ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE

but boson's  choice is A.  i wonder how ???
-
QUESTION #2
you need to determine how much space has been allocated for a table.
which view would give you this information ?

A. dba_extents 
B. dba_ts_quotas 
C. dba_segments

my choice is C . 
but boson's choice is A . it says other views cannot give
the required details .

a metalink doc says that dba_segments.blocks gives the
total number of blocks  allocated to the table. 

what will be the choice that you would go for ?
-

so now i have the question whether boson is reliable ? 
how many in this list have used it ?
or am i missing something  : ((

Regards,
Prem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Book (was) oaktable people

[Connor McDonald]

I'm saving that for the Hotsos symposium

 --- Daniel W. Fink [EMAIL PROTECTED] wrote: 
Who cares about the profanity
 
 Do you a) pound nails in a squirrel and b) force
 David Kurtz to consume massive amounts of gin whilst
 lobbing Fosters at the
 audience?
 
 
 Connor McDonald wrote:
 
  I have to admit I like this stuff about Connor's
  book especially since I'm only a co-author for
 the
  thing :-)
 
  (And unlike my presentations, I promise that there
 is
  no profanity in the book...)
 
  Cheers
  Connor
 
   --- Niall Litchfield
  [EMAIL PROTECTED] wrote:  I
 haven't
  read it yet, but I'd be amazed if Connor's
   book wasn't excellent.
   He is a great communicator, despite being an
 aussie
   and all.
  
   Mogens and Tony from apress are probably pretty
 busy
   with the Miracle db
   forum right now (work gloves and stuff were
   mentioned euurgh), but there are
   plans that exist in more than Mogens' head for
 an
   OakTable press sequence of
   books, with apress as publishers. Someone has to
   write the buggers though.
   Some of us have work to do.
  
   Niall
  
   Not american, but not big and not clever either.
  
-Original Message-
From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On
Behalf Of Ryan
Sent: 05 January 2004 22:34
To: Multiple recipients of list ORACLE-L
Subject: oaktable people
   
   
Conner McDonald's book just came out and it
 looks
   to be
pretty good. Any more books in the pipeline?
   
--
Please see the official ORACLE-L FAQ:
   http://www.orafaq.net
--
Author: Ryan
  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: Niall Litchfield
 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).
 
  =
  Connor McDonald
  web: http://www.oracledba.co.uk
  web: http://www.oaktable.net
  email: [EMAIL PROTECTED]
 
  GIVE a man a fish and he will eat for a day. But
 TEACH him how to fish, and...he will sit in a boat
 and drink beer all day
 
 


  Yahoo! Messenger - Communicate instantly...Ping
  your friends today! Download Messenger Now
  http://uk.messenger.yahoo.com/download/index.html
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
  --
  Author: =?iso-8859-1?q?Connor=20McDonald?=
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: Daniel W. Fink
   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). 

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

GIVE a man a fish and he will eat for a day. But TEACH him how 

Last date for Oracle 8i OCP?

[katimbs]

Title: Last date for Oracle 8i OCP?








Does any one have an idea when is the last date to complete ORACLE 8i OCP exams? 

Is there any last date announced or yet to announce for Oracle 8i OCP? 

Thanks

Sanyu

Re: Moving Objects from One Tablespace to Another

[Mladen Gogala]

You have to apply mig to it. The sooner you do it, the better.
Read database migration guide.


On 2004.01.07 05:19, N.Anand Kumar wrote:
 This works well in ver 8 or higher how do we do in Oracle 7 version.
 
 Anand Kumar
 ITW Signode India Ltd
 
 
 
 
 
 - Original Message -
 To: LazyDBA.com Discussion
 Sent: Wednesday, January 07, 2004 1:50 PM
 
 
 
 alter table emp move tablespace tbs2;
 Deepa Kale -DBA
 Jyoti Structures - Nasik(IT)
 
 
 
   Vikas Sharma
   [EMAIL PROTECTED]To:   LazyDBA.com
 Discussion [EMAIL PROTECTED]
   .co.in  cc:
Subject:  Moving Objects from
 One Tablespace to Another
   01/07/2004 01:07
   PM
 
 
 
 
 
 
 How do I move my objects (say Tables) from One Tablespace to Another
 without the need to recreate them?
 
 Regards,
 
 Vikas Sharma
 
 
 Get today's cartoon: http://www.LazyDBA.com
 Please don't reply to RTFM questions
 Oracle documentation is here: http://tahiti.oracle.com
 To unsubscribe: send a blank email to [EMAIL PROTECTED]
 To subscribe:   send a blank email to [EMAIL PROTECTED]
 By using this list you agree to these terms:
 http://www.lazydba.com/legal.html
 
 
 
 
 
 
 
 
 Get today's cartoon: http://www.LazyDBA.com
 Please don't reply to RTFM questions
 Oracle documentation is here: http://tahiti.oracle.com
 To unsubscribe: send a blank email to [EMAIL PROTECTED]
 To subscribe:   send a blank email to [EMAIL PROTECTED]
 By using this list you agree to these
 terms:http://www.lazydba.com/legal.html
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: N.Anand Kumar
   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).
 

-- 
Mladen Gogala
Oracle DBA
-- 
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).

Re: Problem with understanding Optimization methods.

[Jonathan Lewis]

Apologies to the list.

The previous reply may have been informative,
but it was irrelevant.  I failed to notice that the
indexed access path was followed up by a 
table access by rowid.  (This does explain why
the index_FFS path wasn't used, of course).

In this case, the cost of the indexed path would be
blevel + leaf_blocks + clustering_factor
(in 8.1.7.4).

Given that the clustering_factor for btree indexes
falls between the number of blocks in the table
and the number of rows in the table, you could
make the access path go either way by hacking
the clustering factor between two extremes.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:30 AM


 
 Check the costs of the two queries (autotrace will be
 sufficient).
 
 In this example, rule based uses the index because
 it exists and will return the right answer.
 
 Cost based works out that the scan and sort is
 cheaper.
 
 The cost of an index full scan is approximately
 blevel  +  leaf_blocks  (columns from user_indexes).
 
 The cost of the tablescan is
 blocks / 'adjusted db_file_multiblock_read_count'
 If your dbfmbrc is 8, use 6.59
 If it's 16 use 10
 If it's 32 use 16.4
 
 The cost of the sort (which seems to be wrong
 in 8.1.7.4) is likely to be about the same as the
 cost of the tablescan.
 
 
 So, as an example, pretend your dbfmbrc is 16,
 then if the index is larger than 1/5th of the size
 of the table, the scan and sort will work out
 cheaper than the index full scan.
 
 
 I am a little surprised, though, that you don't
 have a path that is index FAST full scan.
 This suggests that your index is actually
 bigger than your table.  Maybe it's got
 lots of holes in it.
 
 Regards
 
 Jonathan Lewis
 http://www.jlcomp.demon.co.uk
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: oaktable people

[April Wells]

Title: RE: oaktable people





You would fit right in fine in the North East US...


I am also too direct for people sometimes!


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 /\
/ \
/ \
\ /
 \/
 \
 \
 \
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Pete Sharman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 06, 2004 5:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: oaktable people



I resemble that remark! Aussies are ALWAYS great communicators, just a bit direct for some people sometime. :)



Pete

Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook

Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Sent: Wednesday, 7 January 2004 7:09 AM
To: Multiple recipients of list ORACLE-L


I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent.
He is a great communicator, despite being an aussie and all. 


Mogens and Tony from apress are probably pretty busy with the Miracle db
forum right now (work gloves and stuff were mentioned euurgh), but there are
plans that exist in more than Mogens' head for an OakTable press sequence of
books, with apress as publishers. Someone has to write the buggers though.
Some of us have work to do. 


Niall


Not american, but not big and not clever either. 


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On 
 Behalf Of Ryan
 Sent: 05 January 2004 22:34
 To: Multiple recipients of list ORACLE-L
 Subject: oaktable people
 
 
 Conner McDonald's book just came out and it looks to be 
 pretty good. Any more books in the pipeline?
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Ryan
 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: Niall Litchfield
 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: Pete Sharman
 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).




The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

RE: freebie. Summarize Oracle Listener logs

[waibals]

Hi 
Steve-
Quite 
interested in having a go at it.
Please 
send to me a copy asap.

Cheers 
and regards,

CSW 
Simon.

  -Original Message-From: Steve Perry 
  [mailto:[EMAIL PROTECTED]Sent: Monday, January 05, 2004 6:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  freebie. Summarize Oracle Listener logs
  I wanted to summarize our listener 
  logs to see who's connecting with what tools. I checked google and didn't see 
  anything, so I decided to write one. It may be useful to somebody 
  else.
  
  It summarizes the linesof a 
  listener log. the output is similar to 
  
  Ora Listener Log Summary 
  V0.5Oracle SID: ODP Log File: TSOORDDB.listener.logListener Started 
  at: 06-DEC-2003 
  07:53:26User 
  Host 
  Program 
  Total   
  PA1DBO 
  TSOORA49 
  DMSERVER_V4.EXE 
  6,594PW1DBO 
  TSOORA50 
  DLLHOST.EXE 
  1,514IWAM_TSOORA50 
  TSOORA50 
  DLLHOST.EXE 
  600PW2DBO 
  TSOORA56 
  DLLHOST.EXE 
  362ITMDBO 
  TSOORA52 
  SQLPLUS.EXE 
  166SYSTEM 
  TSOORA56 
  MAPS_BIZ 
  88PW3DBO 
  TSOORA57 
  TD2000.EXE 
  72ASPNET 
  TSOORA56 
  ASPNET_WP.EXE 
  57ORACLE 
  __JDBC__ 
  41ARCDBO 
  SATSAP09 
  SQLPLUS.EXE 
  122KNUPPS 
  SKNUPP-1 
  TOAD.EXE 
  7PERRYSM 
  SAIT02547 
  SQLPLUSW.EXE 
  62RILEYJ 
  GLEFIO01210 
  TOAD.EXE 
  42MASHUA 
  GLEFIO01262 
  TOAD.EXE 
  3PA1DBO 
  TSOORA49 
  DMFILESCAN.EXE 
  3PA1DBO 
  TSOORA49 
  DMCLEAN.EXE 
  3LDQDBO 
  TSOORA24 
  JREW.EXE 
  22SHURTN 
  GLEFIO01261 
  TOAD.EXE 
  1PW3DBO 
  TSOORA57 
  DBDBOIN.EXE 
  1PA1DBO 
  TSOORA49 
  SQLPLUSW.EXE 
  1ODDDBO 
  TSOORD08 
  EXP.EXE 
  12KNUPPS 
  SKNUPP-1 
  SQLPLUSW.EXE 
  1PW2DBO 
  TSOORA56 
  SQLPLUSW.EXE 
  1
  
  notes:
  It sorts in descending order by the 
  connect attempts.
  all connect lines are counted. It 
  doesn't take into account if the connection was made - only that it was 
  attempted. seperating the failed connections may be a future 
  enhancement.
  I just wrote it (and some 
  cutting/pasting from the net), so it hasn't been burned in yet. 
  It will process 100 megof 
  logs in few minutes. 
  It was written forwindows 
  only. sorry, I workin a MicroSlop env... 
  
  I have a cmd file that I use 
  to run it so it can process our current logs or older stuff.
  Rather than pasting both of 
  theminline, email me and I'll sendthem out.
  if you want it bad :), email me at 
  work [EMAIL PROTECTED]
  otherwise use[EMAIL PROTECTED] and I'll get to it 
  when I get home.
  
  if somebody optimizes it, cleans it 
  up,finds a flaw..., let me know so I can update it.
  
  Steve
  
  

Re: another OCP question -- help me guys

[Richard Foote]

Hi Prem,

Firstly, thank you for bringing back fond memories of when I used to teach
this stuff for Oracle. If we ever meet one day, I'll show you my highlighter
penned copy of the notes showing the various errors and inaccuracies (except
the Performance Tuning course where I highlighted the correct bits ;)

Just a personal opinion (don't get me started on OCP) but if I were going
for a certification classifying me as a Professional, I would like to
display a greater air of confidence in that I know what all this stuff
actually means. I mean once you get the certificate, you'll actually be
expected to know how to tune a temp tablespace, drop a tablespace, etc,
right ... You're heading in the right direction by questioning these
questions but knowing the answers to questions is not the same as being able
to solve real-life problems which should be the mandatory skill of any
so-called certified professional. I guess I'm suggesting that before you pin
on the certification badge, you should have the skills to determine the
correct answers to these questions yourself.

Now you've gone and got me started on OCP, but hopefully you know what I
mean.

Question 1) Answer B - Statement will fail.

You actually proven this yourself and yet you still have doubts? Trust what
you *see*, not what you *read*. The cascade constraints clause if used must
go at the end of the statement.

Question 2) Answer A and C.

Again, a simple query or describe of these views would do the trick.

I think we can safely say that Boson (whatever he/she/it is) is not a very
reliable source ...

Good luck with your OCP

Richard

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:24 PM


 Hi list , sorry to pester you with questions regarding
 boson OCP questions . i have scheduled for #1Z0-031 exam
 and so desperately need help from this list .
 please bear with me  for while . look at the 2 questions below .

 -
 QUESTION #1
 what happens when you issue the command below .
 drop tablespace testtbs including contents cascade constraints and
 datafiles;

 A.the tablespace will be dropped , constraints will be droppped and the
 datafiles will be taken out of the o/s.

 B. statement will fail

 C.you must drop constraints before issuing this command.

 this is what happens when i try on 9.2.0.4 :
 ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE

 but boson's  choice is A.  i wonder how ???
 -
 QUESTION #2
 you need to determine how much space has been allocated for a table.
 which view would give you this information ?

 A. dba_extents
 B. dba_ts_quotas
 C. dba_segments

 my choice is C .
 but boson's choice is A . it says other views cannot give
 the required details .

 a metalink doc says that dba_segments.blocks gives the
 total number of blocks  allocated to the table.

 what will be the choice that you would go for ?
 -

 so now i have the question whether boson is reliable ?
 how many in this list have used it ?
 or am i missing something  : ((

 Regards,
 Prem.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Prem Khanna J
   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: Richard Foote
  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).

test

[Ryan]

switched emails. just testing. 

Listen to Cary in Charlotte on Thursday

[Murali Vallath]

If you leave in and around the Charlotte area or in a reachable distance and have not heard throughthe user group'sregular e-mail invitations here is the opportunity. 

Cary presents for the Charlotte Oracle Users Group on Thursday January 8th - for more details visit www.cltoug.org 


Murali Vallath
President, Charlotte Oracle Users Group.
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Re: another OCP question -- help me guys

[Jonathan Gennick]

Hello Prem,

The syntax the question gives for DROP TABLESPACE doesn't
look right to me. Without looking at the current docsgrin,
I believe INCLUDING CONTENTS is a valid option, and that the
others are invalid. Thus, answer B, the statement will fail,
looks correct. Whoever wrote that test question does not
appear to have tested their test.

As for question 2, until you asked, I too would have looked
in DBA_EXTENTS. But as I look at one table in my database, I
see that DBA_SEGMENTS.BLOCKS reports the same value as
DBA_EXTENTS.BLOCKS. It may be that DBA_SEGMENTS reports on
SUM(BLOCKS) for all extents in each segment. Interesting.
I'll have to read the docs on this, to find out for certain
what's going on.

One thing to be aware of with respect to question 2 below is
that in a partitioned table, each partition is a segment.
Thus, whether you go to DBA_EXTENTS or DBA_SEGMENTS, you do
need to be sure to consider all partitions of the table in
question.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.


Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote:
PKJ Hi list , sorry to pester you with questions regarding 
PKJ boson OCP questions . i have scheduled for #1Z0-031 exam
PKJ and so desperately need help from this list . 
PKJ please bear with me  for while . look at the 2 questions below .

PKJ -
PKJ QUESTION #1 
PKJ what happens when you issue the command below .
PKJ drop tablespace testtbs including contents cascade constraints and
PKJ datafiles;

PKJ A.the tablespace will be dropped , constraints will be droppped and the
PKJ datafiles will be taken out of the o/s.

PKJ B. statement will fail 

PKJ C.you must drop constraints before issuing this command.

PKJ this is what happens when i try on 9.2.0.4 :
PKJ ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE

PKJ but boson's  choice is A.  i wonder how ???
PKJ -
PKJ QUESTION #2
PKJ you need to determine how much space has been allocated for a table.
PKJ which view would give you this information ?

PKJ A. dba_extents 
PKJ B. dba_ts_quotas 
PKJ C. dba_segments

PKJ my choice is C . 
PKJ but boson's choice is A . it says other views cannot give
PKJ the required details .

PKJ a metalink doc says that dba_segments.blocks gives the
PKJ total number of blocks  allocated to the table. 

PKJ what will be the choice that you would go for ?
PKJ -

PKJ so now i have the question whether boson is reliable ? 
PKJ how many in this list have used it ?
PKJ or am i missing something  : ((

PKJ Regards,
PKJ Prem.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Book (was) oaktable people

[Thater, William]

Connor McDonald  scribbled on the wall in glitter crayon:

 I have to admit I like this stuff about Connor's
 book especially since I'm only a co-author for the
 thing :-)
 
 (And unlike my presentations, I promise that there is
 no profanity in the book...)

oh damn.;-)

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

The whole of science is nothing more than a refinement of everyday thinking.
- Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: OCP question from Boson practice tests

[Richard Foote]

Hi again Prem,

OK, I've changed my opinion of dear Boson. At first I simply thought they
had no idea, now I suspect it's all a big joke designed to make DBAs have a
bit of a giggle on warm summer nights ...

Sizing the temp tablespace by the formula you've given is really quite
witty. Perhaps a little on the silly side but I love Monty Python so I liked
it.

The correct answer is actually none of the four listed (so I'm really
struggling to find two of the buggers).

A. Users: Not really. I could show you a DW database with only a handful of
users that requires a much larger temp tablespace than an OLTP database with
1000s of users. It not the number of users but what the users *do* that's
important.

B. Sort Area Size. Not really. Although it can influence whether a sort is
performed on temp or not, it's the size of the *sort*, not the size of the
S_A_S that's important. And not just the size of one sort, but the size of
the *max concurrent* sort activity. I guess a badly set S_A_S could result
in needing a larger temp tablespace but I doubt that's the point of the
question. And then there's hash joins, etc, ooops, the question has kinda
forgotten about non sort activity in temp

C. tablespace management. Not really although I guess those bitmaps do take
up some space ...

D. db_block_size. What the #@* ??.

Thinking about all this a bit more, if Boson's practice questions puts
people off doing OCPs, it might not be such a bad thing after all ...

Cheers ;)

Richard

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 8:44 PM


 Hi List, this is the question .

 
 You are calculating the proper size for a temporary tablespace .
 Which of the following are two most important factors to consider ?

 A. users
 B. sort_area_size
 C. type of tablespace management
 D. db_block_size
 

 my choice is A  B .

 but boson's choice is B  D . the explanation given by boson is :
 when sizing a temporary tablespace , the formula is
 db_block_size * sort_area_size .

 is it so ? do we need not take no. of users into account ?
 kindly explain me .

 Regards,
 Prem.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Prem Khanna J
   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: Richard Foote
  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: oaktable people

[Richard Foote]

To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:44 AM


 I resemble that remark!  Aussies are ALWAYS great communicators, just a
bit direct for some people sometime.  :)


Hi Pete,

Me direct ???

Never !!

Richard ;)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  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: Listen to Cary in Charlotte on Thursday

[Richard Foote]

And if enough attend, Cary has promised to related 
the little tale of a certain rat called Rupert.

Cary, dare ya !!

Richard ;)

  - Original Message - 
  From: 
  Murali Vallath 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 07, 2004 10:59 
  PM
  Subject: Listen to Cary in Charlotte on 
  Thursday
  
  If you leave in and around the Charlotte area or in a reachable distance 
  and have not heard throughthe user group'sregular e-mail 
  invitations here is the opportunity. 
  
  Cary presents for the Charlotte Oracle Users Group on Thursday January 
  8th - for more details visit www.cltoug.org 
  
  
  Murali Vallath
  President, Charlotte Oracle Users Group.
  
  
  Do you Yahoo!?Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes

Re: another OCP question -- help me guys

[Rachel Carmichael]

Jonathan,

I successfully use drop tablespace including contents and datafiles
all the time. And a quick check of the docs shows that cascade
constraints is valid but, as Richard said, belongs at the end of the
statement.

As for the second question. DBA_SEGMENTS gives you the total allocated
blocks in a single select, without aggregation. To use DBA_EXTENTS
you'd have to use sum(blocks) in the select. From prior experience with
OCP exams, they tend to go for the simplest way to get an answer. So
DBA_SEGMENTS is the correct answer in their view, although you *can*
get the same information from DBA_EXTENTS.


--- Jonathan Gennick [EMAIL PROTECTED] wrote:
 Hello Prem,
 
 The syntax the question gives for DROP TABLESPACE doesn't
 look right to me. Without looking at the current docsgrin,
 I believe INCLUDING CONTENTS is a valid option, and that the
 others are invalid. Thus, answer B, the statement will fail,
 looks correct. Whoever wrote that test question does not
 appear to have tested their test.
 
 As for question 2, until you asked, I too would have looked
 in DBA_EXTENTS. But as I look at one table in my database, I
 see that DBA_SEGMENTS.BLOCKS reports the same value as
 DBA_EXTENTS.BLOCKS. It may be that DBA_SEGMENTS reports on
 SUM(BLOCKS) for all extents in each segment. Interesting.
 I'll have to read the docs on this, to find out for certain
 what's going on.
 
 One thing to be aware of with respect to question 2 below is
 that in a partitioned table, each partition is a segment.
 Thus, whether you go to DBA_EXTENTS or DBA_SEGMENTS, you do
 need to be sure to consider all partitions of the table in
 question.
 
 Best regards,
 
 Jonathan Gennick --- Brighten the corner where you are
 http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
 Join the Oracle-article list and receive one
 article on Oracle technologies per month by 
 email. To join, visit
 http://four.pairlist.net/mailman/listinfo/oracle-article, 
 or send email to [EMAIL PROTECTED] and 
 include the word subscribe in either the subject or body.
 
 
 Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J
 ([EMAIL PROTECTED]) wrote:
 PKJ Hi list , sorry to pester you with questions regarding 
 PKJ boson OCP questions . i have scheduled for #1Z0-031 exam
 PKJ and so desperately need help from this list . 
 PKJ please bear with me  for while . look at the 2 questions below .
 
 PKJ
 -
 PKJ QUESTION #1 
 PKJ what happens when you issue the command below .
 PKJ drop tablespace testtbs including contents cascade constraints
 and
 PKJ datafiles;
 
 PKJ A.the tablespace will be dropped , constraints will be droppped
 and the
 PKJ datafiles will be taken out of the o/s.
 
 PKJ B. statement will fail 
 
 PKJ C.you must drop constraints before issuing this command.
 
 PKJ this is what happens when i try on 9.2.0.4 :
 PKJ ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE
 
 PKJ but boson's  choice is A.  i wonder how ???
 PKJ
 -
 PKJ QUESTION #2
 PKJ you need to determine how much space has been allocated for a
 table.
 PKJ which view would give you this information ?
 
 PKJ A. dba_extents 
 PKJ B. dba_ts_quotas 
 PKJ C. dba_segments
 
 PKJ my choice is C . 
 PKJ but boson's choice is A . it says other views cannot give
 PKJ the required details .
 
 PKJ a metalink doc says that dba_segments.blocks gives the
 PKJ total number of blocks  allocated to the table. 
 
 PKJ what will be the choice that you would go for ?
 PKJ
 -
 
 PKJ so now i have the question whether boson is reliable ? 
 PKJ how many in this list have used it ?
 PKJ or am i missing something  : ((
 
 PKJ Regards,
 PKJ Prem.
 
 PKJ -- 
 PKJ Please see the official ORACLE-L FAQ: http://www.orafaq.net
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jonathan Gennick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

Re: Last date for Oracle 8i OCP?

[DEEDSD]

The date has not been announced.  I contacted The OCP folks late last month
and they said that there has been no date set for ending the 8i OCP tests,
nor was he aware of anything being said about it.


   
  
  [EMAIL PROTECTED]  
  
   T   
  
  Sent by: To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
  [EMAIL PROTECTED]cc: 
  
   
  
   bcc:
  
   Subject:
  Last date for   
  01/07/2004 06:59 AM  Oracle 8i OCP?  
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




Does any one have an idea when is the last date to complete ORACLE 8i OCP
exams?


Is there any last date announced or yet to announce for Oracle 8i OCP?


Thanks


Sanyu








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: oracle client on PC's

[david davis]

We do an install on the workstation but the installation has been packaged 
and is pushed I believe with SMS or at least it used to be done that way.


From: Jeffrey Beckstrom [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: oracle client on PC's
Date: Tue, 06 Jan 2004 12:14:28 -0800
The application is a third-party application using Merant's ODBC driver.

How do people normally install the client.  Do you do an install to every 
workstation???

 [EMAIL PROTECTED] 1/6/04 2:54:34 PM 

At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
Rather than installing the Oracle client on every client PC, we have 
been:
- installing client on 1 PC
- copying directory to a network server
- extract the registry for oracle key
- fix registry that was extracted to reference the network drive
- load registry on client PCs
- add the network pc as a search drive to the client pc.

We are now experiencing problems over the WAN and looking at ways to
eliminate the Oracle dll overhead.  Short of installing Oracle on every
client PC, what are our options?

There is a reason that Oracle doesn't support configurations like
this.  There is a fair amount of chatter between an application and the
Oracle client DLL's.  When this chatter starts flying over the network
rather than merely going to a local DLL, you start to get performance 
problems.

How are your application(s) designed?  It's probably possible to tweak an
OCI application to make fewer OCI calls.  If you're using ODBC, and have
the budget, you could purchase one of the wire-protocol ODBC drivers.
Justin Cave
Distributed Database Consulting
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Justin Cave
  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).

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: david davis
 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[2]: another OCP question -- help me guys

[Jonathan Gennick]

Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael ([EMAIL PROTECTED]) wrote:
RC I successfully use drop tablespace including contents and datafiles
RC all the time. And a quick check of the docs shows that cascade
RC constraints is valid but, as Richard said, belongs at the end of the
RC statement.

I stand corrected, though I did admit up front to not
having checked the manual. I was eating breakfast at the
time, so forgive me that one lapse.

I liked Richard's point about trusting what you see. He was
spot on with that comment, at least in this context.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Problem with understanding Optimization methods.

[Goulet, Dick]

Actually from what is given I'd expect the optimizer to select a full table scan in 
anycase, there's no where clause.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 1:09 AM
To: Multiple recipients of list ORACLE-L


You can find out by employing  the event 10053, lev 8.  Looking from afar, however, it 
seems more
likely that you haven't configured your CBO properly. Here is something you can try:

Execute the following commands:

alter session set optimizer_index_caching=40;  
alter session set optimizer_index_cost_adj=25;



After that,  retry the query. If I'm correct, optimizer will now know that index I/O 
is much cheaper
then the table one and will be much more likely to select full index scan over the 
full table scan.
When you're really, really bored, you can read Practical Oracle 8i - Building 
Efficient Databases,
it has a few pages about the parameters above.  Read the Gospel of Jonathan and enjoy.



On 2004.01.07 00:29, Denham Eva wrote:
 Hello Listers,
 
 A normal sql query from a data warehouse tool called Sagent. 
 SELECT COL1, COL2, COL3
 FROM TABLE
 ORDER BY 3;
 
 The table has approximately 2 mil records.
 table has 22 indexes.
 
 The database is set up optimizer CHOOSE.
 I run DBMS_Stats.Gather_Schema_Stats('SchemaName') regularly.
 OS is Win2k
 ORACLE 81741
 
 OK, when doing a explain plan on the above sql, I get the following...
 SELECT STATEMENT Optimizer Mode=CHOOSE
 SORT ORDER BY
  TABLE ACCESS FULL  TABLENAME   -- Very slow and takes
 hours!
 
 When adding the hint /*+RULE*/ for example I get
 SELECT STATEMENT Optimizer Mode=Hint:RULE
TABLE ACCESS BY INDEX ROWID  TABLENAME
INDEX FULL SCAN   TABLE_INDEX  --
 Much faster!!!
 
 Have I given enough info that anyone can explain why the CHOOSE mode insists
 on doing a TABLE ACCESS FULL?
 Is there anything I can do to improve performance? Please remember that this
 query comes from a Data Warehouse tool and hence does not appear to accept
 hints.
 
 Any help will be much appreciated!
 Denham
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Denham Eva
   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).
 

-- 
Mladen Gogala
Oracle DBA
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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: Re[2]: another OCP question -- help me guys

[Rachel Carmichael]

I didn't mean to scold... you post way more information than I usually
do!

And I answer whilst eating breakfast at times too :)

Richard *is* right, the problem is, the sql statement is misformed but
the answer key says it will work. Which is yet another reason I dislike
the OCP exams.


--- Jonathan Gennick [EMAIL PROTECTED] wrote:
 Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
 ([EMAIL PROTECTED]) wrote:
 RC I successfully use drop tablespace including contents and
 datafiles
 RC all the time. And a quick check of the docs shows that cascade
 RC constraints is valid but, as Richard said, belongs at the end of
 the
 RC statement.
 
 I stand corrected, though I did admit up front to not
 having checked the manual. I was eating breakfast at the
 time, so forgive me that one lapse.
 
 I liked Richard's point about trusting what you see. He was
 spot on with that comment, at least in this context.
 
 Best regards,
 
 Jonathan Gennick --- Brighten the corner where you are
 http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
 Join the Oracle-article list and receive one
 article on Oracle technologies per month by 
 email. To join, visit
 http://four.pairlist.net/mailman/listinfo/oracle-article, 
 or send email to [EMAIL PROTECTED] and 
 include the word subscribe in either the subject or body.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jonathan Gennick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).

FW: Error after resize of LMT

[Sands, Robyn]

--_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/plain

We've seen this error on one of our databases (9.2.0.3 on Win2003 Server).

Haven't seen it on our other instances (9.2.0.3 on HP-UX).

Robyn

-Original Message-
Sent: Tuesday, January 06, 2004 11:50 AM
To: Multiple recipients of list ORACLE-L


I've done a LOT of resizing of LMT tablespaces (9.2.0.1) and have never
gotten that error..


--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Has anyone encountered the ORA-600[kcbnew_3] error after resizing and
 LMT in
 Oracle9i?
 
 A vendor install script created tablespaces really large, and I
 started to
 resize them smaller, but checked Metalink. There is a bug 2747978
 that says
 in versions below 9.2.0.4 you can encounter an ORA-600 error after
 resizing.
 Oracle says they were able to reproduce it. The bug report says this
 produces a severe loss of service. As a workaround it says to bounce
 the
 database after resizing. 
 
 I'm just trying to figure out how likely this error is to occur, so I
 though
 I'd ask if anyone has encountered this error. And if it occurred, how
 severe
 were the consequences? I can't apply the 9.2.0.4 patch because the
 vendor
 says they don't support that yet. Thanks.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).


 - - - - - - -  Appended by Scientific-Atlanta, Inc.  - - - - - - -  
This e-mail and any attachments may contain information which is confidential, 
proprietary, privileged or otherwise protected by law. The information is solely 
intended for the named addressee (or a person responsible for delivering it to the 
addressee). If you are not the intended recipient of this message, you are not 
authorized to read, print, retain, copy or disseminate this message or any part of it. 
If you have received this e-mail in error, please notify the sender immediately by 
return e-mail and delete it from your computer.


--_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
HTML
HEAD
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; charset=3DUS-ASCII
META NAME=3DGenerator CONTENT=3DMS Exchange Server version 5.5.2655.35
TITLEFW: Error after resize of LMT/TITLE
/HEAD
BODY

PFONT SIZE=3D2We've seen this error on one of our databases (9.2.0.3 on=
 Win2003 Server)./FONT
/P

PFONT SIZE=3D2Haven't seen it on our other instances (9.2.0.3 on HP-UX)=
./FONT
/P

PFONT SIZE=3D2Robyn/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Rachel Carmichael [A HREF=3Dmailto:[EMAIL PROTECTED]
ahoo.commailto:[EMAIL PROTECTED]/A] /FONT
BRFONT SIZE=3D2Sent: Tuesday, January 06, 2004 11:50 AM/FONT
BRFONT SIZE=3D2To: Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=3D2Subject: Re: Error after resize of LMT/FONT
/P
BR

PFONT SIZE=3D2I've done a LOT of resizing of LMT tablespaces (9.2.0.1) =
and have never/FONT
BRFONT SIZE=3D2gotten that error../FONT
/P
BR

PFONT SIZE=3D2--- DENNIS WILLIAMS lt;[EMAIL PROTECTED]gt; wrote=
:/FONT
BRFONT SIZE=3D2gt; Has anyone encountered the ORA-600[kcbnew_3] error =
after resizing and/FONT
BRFONT SIZE=3D2gt; LMT in/FONT
BRFONT SIZE=3D2gt; Oracle9i?/FONT
BRFONT SIZE=3D2gt; /FONT
BRFONT SIZE=3D2gt; A vendor install script created tablespaces really =
large, and I/FONT
BRFONT SIZE=3D2gt; started to/FONT
BRFONT SIZE=3D2gt; resize them smaller, but checked Metalink. There is=
 a bug 2747978/FONT
BRFONT SIZE=3D2gt; that says/FONT
BRFONT SIZE=3D2gt; in 

Re[1]: OCP question from Boson practice tests

[Prem Khanna J]

Hi Richard , 

Many a thanx for both of your replies . 
All my worry is :  do such questions appear in the real exams also ? 

And your reply has increased my self-confidence.
particularly the line : 
RFTrust what you *see*, not what you *read*. /RF

RFYou actually proven this yourself and yet you still have doubts? /RF
yes Richard  : (   
hope i will not repeat this as time goes and my experience grows. 
i.e., i will be more confident with my answers .

okay , coming back to the sizing of temp tablespace question . 
if suppose , such a question appears in the exam too ( my bad luck ) ,
what will be your two best answers  ?

Thanks and Regards,
Prem.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: OCP question from Boson practice tests

[Goulet, Dick]

Well, you've certainly gotten a few decent replies.  I've never used Boson so 
I can't comment on their exams, I prefer going to Oracle Press.  Anyway, sizing temp 
is a combination of things many of which are black magic at best.  Number of users is 
an interesting variable to add, but not of an extreme value since it's actually the 
number of CONNECTED users that will really affect the value arrived at.  
Sort_Area_size, Maybe.  If it's large enough it may well negate the need for temp in a 
number of cases, but don't bet on it.  Type of Tablespace management?  OK, who's 
smoking what.  That's a giveaway toss out.  DB_Block_Size, again a giveaway, it has no 
real bearing since the temp tablespace will have the same size, unless you use 9i 
features, but even then a MB is a MB.

The real answer is know what your database is suppose to be doing.  If your 
setting up an OLTP database you may well get away with a very small temp space.  On 
the other hand a data warehouse or decision support system is, by design, going to 
consume mountains of temp.  Also do not forget things like index rebuilds that you 
will need to do, they do sorts and consequently consume temp in the process.  Then 
there's always that wild user who lets loose the Cartesian product from haties that 
will blow all of your calculations off the map.  

Therefore the answer in this case is E: None of the above.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 5:44 AM
To: Multiple recipients of list ORACLE-L


Hi List, this is the question .


You are calculating the proper size for a temporary tablespace .
Which of the following are two most important factors to consider ?

A. users
B. sort_area_size
C. type of tablespace management
D. db_block_size


my choice is A  B .

but boson's choice is B  D . the explanation given by boson is :
when sizing a temporary tablespace , the formula is 
db_block_size * sort_area_size .

is it so ? do we need not take no. of users into account ?
kindly explain me .

Regards,
Prem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Goulet, Dick
  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: Last date for Oracle 8i OCP?

[Boivin, Patrice J]

8i is slated for desupport at the end of December, in any case.

Patrice

-Original Message-
Sent: January 7, 2004 9:44 AM
To: Multiple recipients of list ORACLE-L



The date has not been announced.  I contacted The OCP folks late last month
and they said that there has been no date set for ending the 8i OCP tests,
nor was he aware of anything being said about it.


 

  [EMAIL PROTECTED]

   T

  Sent by: To:   Multiple recipients
of list ORACLE-L [EMAIL PROTECTED] 
  [EMAIL PROTECTED]cc:

 

   bcc:

   Subject:
Last date for   
  01/07/2004 06:59 AM  Oracle 8i OCP?

  Please respond to

  ORACLE-L

 

 





Does any one have an idea when is the last date to complete ORACLE 8i OCP
exams?


Is there any last date announced or yet to announce for Oracle 8i OCP?


Thanks


Sanyu








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Boivin, Patrice J
  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: Book (was) oaktable people

[Gary Goodman]

We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium
speaker agreement.  I will admit that profanity from Connor does not
carry the same impact as profanity from Mogens!

Gary


-Original Message-
Connor McDonald
Sent: Wednesday, January 07, 2004 5:29 AM
To: Multiple recipients of list ORACLE-L

I'm saving that for the Hotsos symposium

 --- Daniel W. Fink [EMAIL PROTECTED] wrote: 
Who cares about the profanity
 
 Do you a) pound nails in a squirrel and b) force
 David Kurtz to consume massive amounts of gin whilst
 lobbing Fosters at the
 audience?
 
 
 Connor McDonald wrote:
 
  I have to admit I like this stuff about Connor's
  book especially since I'm only a co-author for
 the
  thing :-)
 
  (And unlike my presentations, I promise that there
 is
  no profanity in the book...)
 
  Cheers
  Connor
 
   --- Niall Litchfield
  [EMAIL PROTECTED] wrote:  I
 haven't
  read it yet, but I'd be amazed if Connor's
   book wasn't excellent.
   He is a great communicator, despite being an
 aussie
   and all.
  
   Mogens and Tony from apress are probably pretty
 busy
   with the Miracle db
   forum right now (work gloves and stuff were
   mentioned euurgh), but there are
   plans that exist in more than Mogens' head for
 an
   OakTable press sequence of
   books, with apress as publishers. Someone has to
   write the buggers though.
   Some of us have work to do.
  
   Niall
  
   Not american, but not big and not clever either.
  
-Original Message-
From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On
Behalf Of Ryan
Sent: 05 January 2004 22:34
To: Multiple recipients of list ORACLE-L
Subject: oaktable people
   
   
Conner McDonald's book just came out and it
 looks
   to be
pretty good. Any more books in the pipeline?
   
--
Please see the official ORACLE-L FAQ:
   http://www.orafaq.net
--
Author: Ryan
  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: Niall Litchfield
 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).
 
  =
  Connor McDonald
  web: http://www.oracledba.co.uk
  web: http://www.oaktable.net
  email: [EMAIL PROTECTED]
 
  GIVE a man a fish and he will eat for a day. But
 TEACH him how to fish, and...he will sit in a boat
 and drink beer all day
 
 


  Yahoo! Messenger - Communicate instantly...Ping
  your friends today! Download Messenger Now
  http://uk.messenger.yahoo.com/download/index.html
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
  --
  Author: =?iso-8859-1?q?Connor=20McDonald?=
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: Daniel W. Fink
   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

Re: Re[2]: another OCP question -- help me guys

[Ryan]

A small but growing number of employers want certification. Considering the
job market, I recommend anyone who is not at Rachel's, etc.. level to get
certified as both a developer and a DBA. I'm doing Java also, just to have
it. The java test is a total joke. You only need to get 52% right and its
just one test, but people want it. You really don't even need to know java.
Just object-oriented programming and memorize a bunch of fairly useless
information.

Getting a good salary is more about your resume and how well you speak than
it is about your skill set. I've had alot of technical interviews and they
all seem to ask the same easy questions. They are interested in: years of
experience, degree, where your degree is from, certification, and in some
cases where you worked before. There is some bias in the DC area for 'top 5'
consulting. I think that means Booz Allen, and Ernst and Young. Not sure who
the other 3 happen to be.

People don't seem to be all that interested in whether you can actually do
the job. They just assume your better than someone else if you have a nicer
resume.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:34 AM


 I didn't mean to scold... you post way more information than I usually
 do!

 And I answer whilst eating breakfast at times too :)

 Richard *is* right, the problem is, the sql statement is misformed but
 the answer key says it will work. Which is yet another reason I dislike
 the OCP exams.


 --- Jonathan Gennick [EMAIL PROTECTED] wrote:
  Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
  ([EMAIL PROTECTED]) wrote:
  RC I successfully use drop tablespace including contents and
  datafiles
  RC all the time. And a quick check of the docs shows that cascade
  RC constraints is valid but, as Richard said, belongs at the end of
  the
  RC statement.
 
  I stand corrected, though I did admit up front to not
  having checked the manual. I was eating breakfast at the
  time, so forgive me that one lapse.
 
  I liked Richard's point about trusting what you see. He was
  spot on with that comment, at least in this context.
 
  Best regards,
 
  Jonathan Gennick --- Brighten the corner where you are
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit
  http://four.pairlist.net/mailman/listinfo/oracle-article,
  or send email to [EMAIL PROTECTED] and
  include the word subscribe in either the subject or body.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jonathan Gennick
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).


 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
   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: Ryan
  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: ora1652 question...

[Norris, Gregory T [ITS]]

 1. Easier, but requires a bounce : Add the
 following event into init.ora

 event=1652 trace name processstate level 10

You should be able to set this dynamically as well (tested on 8.1.7).

SQL alter system set events '1652 trace name processstate level 10';

System altered.

Replace level 10 with off to disable it.

--
My employers like me, but not enough to let me speak for them.

Greg Norris
Sprint LTD Database Administration
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Norris, Gregory T [ITS]
  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[3]: another OCP question -- help me guys

[Prem Khanna J]

Thanx for your reply Gennick.
..and for your word of caution about partitioned tables.

Cary , sometime back said  that :

Cary
There are always two answers to a question that your 
teacher would ask at school .
First one is the right answer.
Second one is the answer that your teacher would expect.
/Cary

The second answer is the one i mostly fail to find.

Regards,
Prem.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Re[2]: another OCP question -- help me guys

[Stefick Ronald S Contr ESC/HRIDA]

Title: RE: Re[2]: another OCP question -- help me guys





Uh No one can be at Rachel's level. She's the DBA Goddess






-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: another OCP question -- help me guys



A small but growing number of employers want certification. Considering the job market, I recommend anyone who is not at Rachel's, etc.. level to get certified as both a developer and a DBA. I'm doing Java also, just to have it. The java test is a total joke. You only need to get 52% right and its just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information.

Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be.

People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:34 AM



 I didn't mean to scold... you post way more information than I usually 
 do!

 And I answer whilst eating breakfast at times too :)

 Richard *is* right, the problem is, the sql statement is misformed but 
 the answer key says it will work. Which is yet another reason I 
 dislike the OCP exams.


 --- Jonathan Gennick [EMAIL PROTECTED] wrote:
  Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
  ([EMAIL PROTECTED]) wrote:
  RC I successfully use drop tablespace including contents and
  datafiles
  RC all the time. And a quick check of the docs shows that cascade 
  RC constraints is valid but, as Richard said, belongs at the end 
  RC of
  the
  RC statement.
 
  I stand corrected, though I did admit up front to not having checked 
  the manual. I was eating breakfast at the time, so forgive me that 
  one lapse.
 
  I liked Richard's point about trusting what you see. He was spot on 
  with that comment, at least in this context.
 
  Best regards,
 
  Jonathan Gennick --- Brighten the corner where you are 
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit 
  http://four.pairlist.net/mailman/listinfo/oracle-article,
  or send email to [EMAIL PROTECTED] and include the 
  word subscribe in either the subject or body.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jonathan Gennick
  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).


 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes 
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
 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: Ryan
 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 

Re[3]: another OCP question -- help me guys

[Prem Khanna J]

Ryan People don't seem to be all that interested in
Ryan whether you can actually do the job.

Ryan , i would change your first line as Some people don't seem to ...

Because some people really DO care about what one can do.

Ryan They just assume your better than someone
Ryan else if you have a nicer resume.

I agree . Because resume is the mirror which reflects an
individual until the interview happens .

Regards,
Prem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Re[2]: another OCP question -- help me guys

[Rachel Carmichael]

Michael Abbey once said (I'm paraphrasing here) the resume and OCP get
you in the door. It's your experience that gets you the job and keeps
you there

We've had numerous discussions on this list about interview questions.
I've been on interviews where I spent an entire day (9-4) and talked to
11 different people, both non-technical questions and technical ones in
and out of my area of expertise. and this was AFTER a 90 minute phone
technical interview. I've been on interviews where there was no DBA on
site, so the  technical aspect of the interview was more an informal
consulting session (how would you handle this problem, when I could
tell it was one they were currently having)

I'm not interested in how much you've memorized. Or how well you take
standardized tests. I do ask questions that pertain to skill set and
creative thinking. 

Unfortunately these days, personnel departments do the initial
screening and they use a keyword search on college degree and OCP.
Wherever possible, I try to do the initial search and interview myself
and THEN pass a candidate along to HR. That way I can at least argue
for someone really good, even if their resume doesn't hit the keywords.

Oh yeah -- how does having a college degree in art history make a
person a better DBA? how does my degree, which is in computer science
but which is 28 years old, have anything to do with current programming
and database work?

And while we definitely need people who know a little about everything
(the primary care physician as it were) we still need experts in
specialized areas. I wouldn't necessarily urge people to study lots and
lots of things, that usually ends up meaning they do none of them well.

Okay, can you tell you poked one of my pet peeves? Off the soapbox for
now :)

my $0.02, for what it's worth (which is less and less these days!)

Rachel

--- Ryan [EMAIL PROTECTED] wrote:
 A small but growing number of employers want certification.
 Considering the
 job market, I recommend anyone who is not at Rachel's, etc.. level to
 get
 certified as both a developer and a DBA. I'm doing Java also, just to
 have
 it. The java test is a total joke. You only need to get 52% right and
 its
 just one test, but people want it. You really don't even need to know
 java.
 Just object-oriented programming and memorize a bunch of fairly
 useless
 information.
 
 Getting a good salary is more about your resume and how well you
 speak than
 it is about your skill set. I've had alot of technical interviews and
 they
 all seem to ask the same easy questions. They are interested in:
 years of
 experience, degree, where your degree is from, certification, and in
 some
 cases where you worked before. There is some bias in the DC area for
 'top 5'
 consulting. I think that means Booz Allen, and Ernst and Young. Not
 sure who
 the other 3 happen to be.
 
 People don't seem to be all that interested in whether you can
 actually do
 the job. They just assume your better than someone else if you have a
 nicer
 resume.
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 9:34 AM
 
 
  I didn't mean to scold... you post way more information than I
 usually
  do!
 
  And I answer whilst eating breakfast at times too :)
 
  Richard *is* right, the problem is, the sql statement is misformed
 but
  the answer key says it will work. Which is yet another reason I
 dislike
  the OCP exams.



__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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[2]: OCP question from Boson practice tests

[Jonathan Gennick]

Wednesday, January 7, 2004, 9:39:25 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote:
PKJ Many a thanx for both of your replies . 
PKJ All my worry is :  do such questions appear in the real exams also ? 

I think you've hit on something key here, and that is that
practice exams may not be reflective of the real thing.

One of my secrets for taking the OCP exams is that you can
sometimes play off one question against another. Sometimes
the answer to one question is part of another question.
Consider, just by way of example:

1. Which view gives you the number of blocks in a segment?

a. DBA_SEGMENTS
b. DBA_SEG_SIZE
c. DBA_SEGMENT_SIZE
d. V$SEGMENTS

Ok, say that you don't know. Just wait for awhile, and
plan to come back that question later, because later you
might run into the following:

47. How any rows will one table have in DBA_SEGMENTS?
..

The answers to question 47 don't matter here. What's
important here is that the answer to question 47 gives away
the answer to question 1. Now these are just example
questions that I made up off the top of my head, but you get
the idea. In my own actual exam taking, I've several times
gotten clues to, or even answers to, questions that I
couldn't immediately answer by reading other questions in
the exam.

Ok. I've given away my secret. Now the whole world knows:
I'm only good at taking testsgrin.

Something else I've found valuable is a good knowledge of
Oracle's architecture. If you know how Oracle is put
together, and how the different processes work, you can
often make intelligent guesses. For example (maybe not a
perfect example):

37. You created a table and specified INITIAL 65000, yet
your initial extent is actually 65536 bytes long. Why is
that?

1. Oracle rounds up to the next power of 2.
2. The tablespace actually had 65536 bytes available, so
Oracle allocated all available space.
3. Oracle's lowest unit of space allocation is the block,
and it took 8 8KB blocks to cover the space you asked for.
4. Oracle always allocates at least enough 64KB chunks to
cover the space that you ask for.

To my neighbor, who knows nothing about Oracle, all these
answers might seem plausible. But if you understand Oracle's
architecture, including the concepts of blocks, segments,
extents, tablespaces, and so forth, that knowledge might be
just enough to help you zero in on the correct answer.

I'm not sure this last was the best example I could have
come up with, but all that aside, understanding the
architecture has helped me a great deal in eliminating
spurious answers to questions. Maybe, out of four answers to
a question I didn't know, I could only eliminate two answers
for architectural reasons, but even doing that increases my
odds from guessing from 25% to 50%.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Re[2]: another OCP question -- help me guys

[Thater, William]

Rachel Carmichael  scribbled on the wall in glitter crayon:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current
 programming and database work?

it gets you past the HR department so you actually get to talk to someone.
trust me, i know all about this one having neither a degree or an OCP.  and
having lost jobs to those art history degree holders.  [and yes i have been
asked to go back to those same places as a consultant to fix the mess.  and
no i didn't.]

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

You see, wire telegraph is a kind of a very, very long cat. You pull his
tail in New York and his head is meowing in Los Angeles. Do you understand
this? And radio operates exactly the same way: you send signals here, they
receive them there. The only difference is that there is no cat. - Albert
Einstein, when asked to describe radio
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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).

Verisign and MetaLink

[Jesse, Rich]

So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy.  Anyone know
what the Verisign Certs are used for in Oracle products?  I don't think we
have any of those products, but...

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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: Verisign and MetaLink

[April Wells]

Title: RE: Verisign and MetaLink





Financials... if you use https and primarily if you are using 11i externally


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 /\
/ \
/ \
\ /
 \/
 \
 \
 \
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 9:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Verisign and MetaLink



So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy. Anyone know
what the Verisign Certs are used for in Oracle products? I don't think we
have any of those products, but...


TIA,
Rich


Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-- 
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).




The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

RE: Verisign and MetaLink

[Jamadagni, Rajendra]

You may be surprised to find that the email came from a domain hosted/owned by tucows 
... 

Domain Name: ORACLE-MAIL.COM
Registrar: TUCOWS, INC.
Whois Server: whois.opensrs.net
Referral URL: http://www.opensrs.org
Name Server: NS1.ORACLE.COM
Name Server: NS4.ORACLE.COM
Status: ACTIVE
Updated Date: 30-jan-2003
Creation Date: 27-feb-2002
Expiration Date: 27-feb-2004

I promptly deleted the mail.
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, January 07, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L


So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy.  Anyone know
what the Verisign Certs are used for in Oracle products?  I don't think we
have any of those products, but...

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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: Verisign and MetaLink

[Mercadante, Thomas F]

Jesse,

Aren't these pieces of mail great?  Talk about Spam.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, January 07, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L


So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy.  Anyone know
what the Verisign Certs are used for in Oracle products?  I don't think we
have any of those products, but...

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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: Verisign and MetaLink

[Tim Onions]

the ntoe I read talked about Oracle Wallets and SSL within Java

_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
Tel: +44.1684.312364
http://www.speechmachines.com



-Original Message-
Sent: 07 January 2004 15:34
To: Multiple recipients of list ORACLE-L


So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy.  Anyone know
what the Verisign Certs are used for in Oracle products?  I don't think we
have any of those products, but...

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Onions
  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: Hotsos' Classes

[Cary Millsap]

Interesting. Of course, Gummi's right: I blew both my course URLs in my
note. The correct URL for the PD101 coruse is
http://www.hotsos.com/courses/PD101.php, too. Slow connection; didn't
have time to check thoroughly; sorry for the inconvenience.

Thanks, Gummi.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Gudmundur Bjarni Josepsson
Sent: Wednesday, January 07, 2004 4:14 AM
To: Multiple recipients of list ORACLE-L

Venu,

I've taken both PD101 and OP101 and I can thoroughly recommend both of
them.  The sequence of those two is irrelevant in my opinion.

If you're looking to improve your tuning skills and your understanding
of Oracle performance issues I would suggest the OP101.  It has a very
good balance of lectures and hands-on, brain-heating exercises.  You
will probably scratch your head when it comes to the exercises but they
really drive home what the lecturer has been talking about.  The
exercises take at least 50% of the time but of course I don't know of
the course will develop since the first beta class.

(The correct URL for the OP101 is
http://www.hotsos.com/courses/OP101.php).

Gudmundur

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Potluri, Venu (CT Appl Suppt)
 Sent: 6. janúar 2004 19:24
 To: Multiple recipients of list ORACLE-L
 Subject: Hotsos' Classes
 
 
 Is there a proper sequence of classes to take, among those 
 offered by Hotsos? While I do use Wait events to monitor  
 tune  my Oracle Financials databases, I need more training 
 in Performance tuning. I am just dipping my toes into the 
 world of Oracle Performance Tuning. I am reading Cary's book 
 and I have used Ixora's treasure of information, quite a bit 
 in the past. 
 
 I see there are a number of classes now as opposed to a 
 clinic in the past.
 
 Performance Diagnosis 101
 SQL Optimization 101
 Hotsos Symposium 2004
 Steve Adams Seminar
 
 While I would love to take all of them, time  work schedule 
 permitting, I wouldn't want to waste time either if any of 
 the subject matter goes above my head and I spend time 
 scratching my head. God knows I might even find SQL Tuning 
 class useful to brush up little that I know. Would the Hotsos 
 Symposium be not suitable for poeple like myself who haven't 
 taken the Performance Diagnostics 101 class and aren't well 
 versed with Performance Tuning? What is expected of the 
 audience in terms of prior knowledge? Mind you, I am not an 
 expert like most of you guys. Haven't written a book or even a paper!
 
 Venu Potluri
 Oracle Financials DBA
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Potluri, Venu (CT Appl Suppt)
   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: Gudmundur Bjarni Josepsson
  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: Cary Millsap
  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: Re[2]: another OCP question -- help me guys

[Ryan]

degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp companies offer you
salary based mainly on your resume.

most technical interviews are a joke. I can make more money if I double my
experience level and have a computer science degree from harvard, while at
the same time halving my skillset and performance.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:29 AM


 Rachel Carmichael  scribbled on the wall in glitter crayon:

  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer science
  but which is 28 years old, have anything to do with current
  programming and database work?

 it gets you past the HR department so you actually get to talk to someone.
 trust me, i know all about this one having neither a degree or an OCP.
and
 having lost jobs to those art history degree holders.  [and yes i have
been
 asked to go back to those same places as a consultant to fix the mess.
and
 no i didn't.]

 --
 Bill Shrek Thater ORACLE DBA
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 You see, wire telegraph is a kind of a very, very long cat. You pull his
 tail in New York and his head is meowing in Los Angeles. Do you understand
 this? And radio operates exactly the same way: you send signals here, they
 receive them there. The only difference is that there is no cat. - Albert
 Einstein, when asked to describe radio
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Thater, William
   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: Ryan
  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: Re[2]: another OCP question -- help me guys

[Mladen Gogala]

On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current programming
 and database work?

Believe it or not, a college degree in art history really does help in two ways.
First, people exposed to sufficient quantity of art tend to be nobler and more 
spiritual, according to the popular beliefs, then cynical mathematicians and 
computer geeks like me. Being noble and spiritual means that they don't fight 
back but do as they're told which makes them into good corporate drones. Art
history is like an army boot camp for wannabe geeks. Their appearance also tends
to be much more pleasant and polished then an appearance of a hard core computer 
geek.
Second, art history majors make perfect sacrificial lambs. An art history major in 
IT department can be blamed for anything from bad weather, corrupt backup tape to 
stupid application design. My understanding is that you've moved to the management, 
which is the move that I admire and respect. As a manager, you should know the value 
of a sacrificial lamb that can be blamed for anything. If you want to make the next
step in your career, the step from management to damagement, you'll have to learn
how to play the blame shifting game. Art history majors are priceless for that.
--
Mladen Gogala
Oracle DBA
-- 
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).

Verisign and MetaLink

[Robyn Anderson Sands]

Per the doc on MetaLink, Oracle Wallet Manager and Sun Java JDK are
affected by the Verisign certs.

Here is some of the info:
VeriSign Class 2 and Class 3 PCA root certificates are included in the  
Oracle Wallet Manager as well as Sun's Java JDK.  These certificates will  
expire on January 7, 2004 and are referred to as the Expiring
certificates  
in this note.  
  
Both the Oracle Wallet Manager and Sun's Java JDK are shipped or utilized  
by the affected products listed above.  These certificates are used in  
Oracle's products to authenticate web sites and applications communicating  
over SSL using VeriSign certificates.  They are also used to digitally
sign source code and libraries as a means to validate that the libraries and  
archives have come from a trusted source. 
 
VeriSign has issued new certificates with the same public key and new  
validity periods as a replacement for the expiring certificates. The  
expiring certificates should be replaced with the new certificates
following the instructions described in this note.
---
Customers who use VeriSign Class 2 and Class3 PCA root certificates as  
trusted certificates for SSL authentication of users and servers  
(database or web server) will be affected by the root CA expiry starting  
January 8, 2004.
---
This patch will be available for the following products and versions: 
 
  o  Oracle Database Server (versions 8.1.7.4, 9.0.1.5, and 9.2.0.4) 
  o  Oracle Application Server (versions 9.0.2.3, 9.0.3.1, and 9.0.4.0)


I can send a copy of the doc if you like.  

Robyn



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robyn Anderson Sands
  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: Error after resize of LMT

[DENNIS WILLIAMS]

Robyn - Thanks for replying. So what was the consequence of the error? What
did you have to do to fix the problem?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 07, 2004 8:40 AM
To: Multiple recipients of list ORACLE-L


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/plain

We've seen this error on one of our databases (9.2.0.3 on Win2003 Server).

Haven't seen it on our other instances (9.2.0.3 on HP-UX).

Robyn

-Original Message-
Sent: Tuesday, January 06, 2004 11:50 AM
To: Multiple recipients of list ORACLE-L


I've done a LOT of resizing of LMT tablespaces (9.2.0.1) and have never
gotten that error..


--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Has anyone encountered the ORA-600[kcbnew_3] error after resizing and
 LMT in
 Oracle9i?
 
 A vendor install script created tablespaces really large, and I
 started to
 resize them smaller, but checked Metalink. There is a bug 2747978
 that says
 in versions below 9.2.0.4 you can encounter an ORA-600 error after
 resizing.
 Oracle says they were able to reproduce it. The bug report says this
 produces a severe loss of service. As a workaround it says to bounce
 the
 database after resizing. 
 
 I'm just trying to figure out how likely this error is to occur, so I
 though
 I'd ask if anyone has encountered this error. And if it occurred, how
 severe
 were the consequences? I can't apply the 9.2.0.4 patch because the
 vendor
 says they don't support that yet. Thanks.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).


 - - - - - - -  Appended by Scientific-Atlanta, Inc.  - - - - - - -  
This e-mail and any attachments may contain information which is
confidential, proprietary, privileged or otherwise protected by law. The
information is solely intended for the named addressee (or a person
responsible for delivering it to the addressee). If you are not the intended
recipient of this message, you are not authorized to read, print, retain,
copy or disseminate this message or any part of it. If you have received
this e-mail in error, please notify the sender immediately by return e-mail
and delete it from your computer.


--_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
HTML
HEAD
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; charset=3DUS-ASCII
META NAME=3DGenerator CONTENT=3DMS Exchange Server version 5.5.2655.35
TITLEFW: Error after resize of LMT/TITLE
/HEAD
BODY

PFONT SIZE=3D2We've seen this error on one of our databases (9.2.0.3 on=
 Win2003 Server)./FONT
/P

PFONT SIZE=3D2Haven't seen it on our other instances (9.2.0.3 on HP-UX)=
./FONT
/P

PFONT SIZE=3D2Robyn/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Rachel Carmichael [A HREF=3Dmailto:[EMAIL PROTECTED]
ahoo.commailto:[EMAIL PROTECTED]/A] /FONT
BRFONT SIZE=3D2Sent: Tuesday, January 06, 2004 11:50 AM/FONT
BRFONT SIZE=3D2To: Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=3D2Subject: Re: Error after resize of LMT/FONT
/P
BR

PFONT SIZE=3D2I've done a LOT of resizing of LMT tablespaces (9.2.0.1) =
and have never/FONT
BRFONT SIZE=3D2gotten that error../FONT
/P
BR

PFONT SIZE=3D2--- DENNIS WILLIAMS lt;[EMAIL PROTECTED]gt; wrote=
:/FONT
BRFONT SIZE=3D2gt; Has anyone encountered the 

RE: Re[1]: OCP question from Boson practice tests

[Cary Millsap]

My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Prem Khanna J
Sent: Wednesday, January 07, 2004 8:39 AM
To: Multiple recipients of list ORACLE-L

Hi Richard , 

Many a thanx for both of your replies . 
All my worry is :  do such questions appear in the real exams also ? 

And your reply has increased my self-confidence.
particularly the line : 
RFTrust what you *see*, not what you *read*. /RF

RFYou actually proven this yourself and yet you still have doubts?
/RF
yes Richard  : (   
hope i will not repeat this as time goes and my experience grows. 
i.e., i will be more confident with my answers .

okay , coming back to the sizing of temp tablespace question . 
if suppose , such a question appears in the exam too ( my bad luck ) ,
what will be your two best answers  ?

Thanks and Regards,
Prem.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Cary Millsap
  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: Verisign and MetaLink

[Matthew Zito]

Raj,

It seems as though all of Oracle's names are registered through tucows -
Tucows is simply the registrar, not the owner of the name.  This is not at
all uncommon, and in fact makes sense, given the large number of domain
names under management for Oracle.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Jamadagni, Rajendra
 Sent: Wednesday, January 07, 2004 10:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Verisign and MetaLink
 
 
 You may be surprised to find that the email came from a 
 domain hosted/owned by tucows ... 
 
 Domain Name: ORACLE-MAIL.COM
 Registrar: TUCOWS, INC.
 Whois Server: whois.opensrs.net
 Referral URL: http://www.opensrs.org
 Name Server: NS1.ORACLE.COM
 Name Server: NS4.ORACLE.COM
 Status: ACTIVE
 Updated Date: 30-jan-2003
 Creation Date: 27-feb-2002
 Expiration Date: 27-feb-2004
 
 I promptly deleted the mail.
 Raj
 --
 --
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !
 
 
 -Original Message-
 Sent: Wednesday, January 07, 2004 10:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 So I got two e-mails today from Oracle Support warning about 
 Verisign Certs expiring today and to check MetaLink (thanks 
 for the advanced warning guys). I've been trying for over an 
 hour now and am getting no joy.  Anyone know what the 
 Verisign Certs are used for in Oracle products?  I don't 
 think we have any of those products, but...
 
 TIA,
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 -- 
 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jamadagni, Rajendra
   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: Matthew Zito
  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).

Apple RAID marketing?

[Jesse, Rich]

So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID
with 3+TB for US $11K.  After looking at Apple's page, I poo-poo it because
it's 7.2K spin ATA/100 drives, which I figure would lead to all sorts of
problems.  I see today in Computerworld that it's being touted as blazing
with a max thruput of 210MBps.  H...I know the mid-range FAStT SAN we're
looking at is rated at about 800MBps theoretical max.

Just looking for confirmation/rebuttal that I don't think it would be wise
to load up an Xserve RAID with Oracle DBs -- even if the BAARF's nemesis is
avoided.

http://www.apple.com/xserve/raid

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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: Re[2]: another OCP question -- help me guys

[Rachel Carmichael]

I do understand, and that's why I said that I tried to bring people in
first, before HR (as you know)


--- Thater, William [EMAIL PROTECTED] wrote:
 Rachel Carmichael  scribbled on the wall in glitter crayon:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
  programming and database work?
 
 it gets you past the HR department so you actually get to talk to
 someone.
 trust me, i know all about this one having neither a degree or an
 OCP.  and
 having lost jobs to those art history degree holders.  [and yes i
 have been
 asked to go back to those same places as a consultant to fix the
 mess.  and
 no i didn't.]
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]


 You see, wire telegraph is a kind of a very, very long cat. You pull
 his
 tail in New York and his head is meowing in Los Angeles. Do you
 understand
 this? And radio operates exactly the same way: you send signals here,
 they
 receive them there. The only difference is that there is no cat. -
 Albert
 Einstein, when asked to describe radio
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Thater, William
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: Listen to Cary in Charlotte on Thursday

[Pete Sharman]

But that will
ruin Carys clean cut image forever more!
(Trust me folks, Ive heard Richard tell this one before, and I never
want to hear it again!) J







Pete



Controlling
developers is like herding cats.

Kevin Loney,
Oracle DBA Handbook



Oh no,
it's not. It's much harder than that!

Bruce Pihlamae,
long-term Oracle DBA



-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Foote
Sent: Thursday, 8 January 2004
12:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Listen to Cary in
Charlotte on Thursday





And if enough attend, Cary has
promised to related the little tale of a certain rat called Rupert.











Cary, dare ya !!











Richard ;)







- Original Message - 





From: Murali
Vallath 





To: Multiple
recipients of list ORACLE-L 





Sent: Wednesday,
January 07, 2004 10:59 PM





Subject: Listen to
Cary in Charlotte on Thursday











If you leave in and around the Charlotte area or in a
reachable distance and have not heard throughthe user
group'sregular e-mail invitations here is the opportunity. 











Cary presents for the Charlotte Oracle Users Group on
Thursday January 8th - for more details visit www.cltoug.org


















Murali Vallath





President, Charlotte Oracle Users Group.









Do you Yahoo!?
Yahoo! Hotjobs: Enter
the Signing Bonus Sweepstakes

RE: Apple RAID marketing?

[Goulet, Dick]

Jesse,

If they'll loan you one for a test period  that test works out, Maybe.  Now 
if your SAN vendor is worth his/her weight in salt then they'll have a way to connect 
that Xserve RAID system into their SAN.  That way you get the best of both worlds.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 11:00 AM
To: Multiple recipients of list ORACLE-L


So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID
with 3+TB for US $11K.  After looking at Apple's page, I poo-poo it because
it's 7.2K spin ATA/100 drives, which I figure would lead to all sorts of
problems.  I see today in Computerworld that it's being touted as blazing
with a max thruput of 210MBps.  H...I know the mid-range FAStT SAN we're
looking at is rated at about 800MBps theoretical max.

Just looking for confirmation/rebuttal that I don't think it would be wise
to load up an Xserve RAID with Oracle DBs -- even if the BAARF's nemesis is
avoided.

http://www.apple.com/xserve/raid

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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).

merant drivers on citrix

[Jeffrey Beckstrom]

Found this note on Citrix web site:

DataDirect does support the use of Connect for ODBC on Citrix Metaframe and Windows Terminal Server 
environments. Note that due to known problems with the Microsoft MSI 
Engine, the installation of Connect for ODBC is currently not 
supported through the Citrix Metaframe or 
Windows Terminal Server environments.

Therefore, if can use the driver on citrix but can't install it, how do you 
use it???




Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 
44113

RE: Re[2]: another OCP question -- help me guys

[Thater, William]

Rachel Carmichael  scribbled on the wall in glitter crayon:

 I do understand, and that's why I said that I tried to bring people in
 first, before HR (as you know)

yup, but most places don't have a Goddess on staff.;-)  and i'm seeing the
requirement for OCP being listed in consulting postings now.  but then many
of those job requirements are generated by a company's HR and then sent out
by the consulting firms.  and less and less of them are mentioning
experience.  now there's and interesting trend, we don't care how long or
even if you've done the job, just if you have a degree or an OCP.

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

The point is to develop the childlike inclination for play and the childlike
desire for recognition and to guide the child over to important fields for
society. Such a school demands from the teacher that he be a kind of artist
in his province. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: Re[1]: OCP question from Boson practice tests

[Ryan]

for performance tuning exam you have to know some garbage. 
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:59 AM


 My question, Richard, is can a person pass the exam just by studying
 what is correct? Or is it necessary to work harder to acquire some
 veneer of false knowledge specifically in order to pass the exam?
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Prem Khanna J
 Sent: Wednesday, January 07, 2004 8:39 AM
 To: Multiple recipients of list ORACLE-L
 
 Hi Richard , 
 
 Many a thanx for both of your replies . 
 All my worry is :  do such questions appear in the real exams also ? 
 
 And your reply has increased my self-confidence.
 particularly the line : 
 RFTrust what you *see*, not what you *read*. /RF
 
 RFYou actually proven this yourself and yet you still have doubts?
 /RF
 yes Richard  : (   
 hope i will not repeat this as time goes and my experience grows. 
 i.e., i will be more confident with my answers .
 
 okay , coming back to the sizing of temp tablespace question . 
 if suppose , such a question appears in the exam too ( my bad luck ) ,
 what will be your two best answers  ?
 
 Thanks and Regards,
 Prem.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Prem Khanna J
   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: Cary Millsap
   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: Ryan
  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: Rollback segment shrinkage

[Daniel Fink]

Shrinking of rollback segments may result in ORA-1555s. If you need to shrink
them, do so during a slow time.
Not shrinking rollback segments may result in ORA-1562 unable to extend rbs.


Satav, Pawan wrote:

 Hi,
   Can anyone point pros/cons of shrinking a rollback segment ? (other
 than performance overheads associated with extent allocation and
 reallocation)

   Optimal is not set for my rollback segments. Recently I shrunk a
 rollback segments which had more than 100 extents allocated to it.



  Regards
 Pawan Satav
 Database Services

 
 This message contains information that may be privileged or confidential and
 is the property of the Cap Gemini Ernst  Young Group. It is intended only
 for the person to whom it is addressed. If you are not the intended
 recipient, you are not authorised to read, print, retain, copy, disseminate,
 distribute, or use this message or any part thereof. If you receive this
 message in error, please notify the sender immediately and delete all copies
 of this message.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Satav, Pawan
   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: Daniel Fink
  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).

SAP Tablespace Conventions (WAS: Convert to LMTs)

[Hand, Michael T]

Jared,
SAP does use default tablespace names as you have stated, but will
allow you to move them to alternate locations and recommends it under
certain conditions.  We separated 10 or 12 of the tables that we
thought would grow the fastest into dedicated tablespaces when we
originally installed R/3 40B several years ago and have added to that
number over time.  SAPDBA has options to perform a move between 
tablespaces via EXP/IMP or CTAS.

As far as the impact on upgrades goes, we are migrating to SAP
Enterprise 4.7 and I have found minimal impact from the nondefault
layout.  Only 1 or 2 tables reverted to their default tablespaces 
and no errors for tables that were elsewhere.

(Nitty-gritty details if you want to read on)

Now creating new tablespaces via SAPDBA (with the PSAP prefix) is 
recommended as it modifies the SAP internal data dictionary to include 
them.  Also, the default tablespace can be changed by adding user-
defined data classes associated with the new tablespaces, then 
assigning them to the table/s in question via SE11 and the Repair/
CorrectionTransport mechanism.  We created our own data classes but 
never assigned them, leaving the original data classes in place.  
Figured it would be less of a problem than keeping track of 100 or so
Repair/Transports.  The discrepancy is only evident in the SE14 
transaction under Storage parameters between the actual values in the 
database (DBS) and expected/calculated values (CMP).

Hope this isn't more than you wanted or needed ;)

Mike Hand
Polaroid Corp.

-Original Message-
Sent: Tuesday, January 06, 2004 9:04 PM
To: Multiple recipients of list ORACLE-L


SAP expects tables to be in certain tablespaces: PSAPBTABD for instance.

Same with indexes: PSAPBTABI

The SAPDBA interactive tool is being phased out in favor of the 
command line tool brconnect.  I don't know if brconnect allows 
some flexibility in tablespace names, but I doubt it.  Just haven't
got around to that particular topic yet.

There are methods for doing fairly fast migrations should you need
it, such as changing platforms.  I would have preferred to do an
exp/imp or something like it when we moved to new servers, but in
the amount of time I had to work with, I could not come up with 
what I thought an acceptable method on windows.

On *nix there would have been more leeway.  There isn't any
native named pipe functionality that is exposed to the shell
on Win32.  On top of that, Oracle compiles the utilities such
as imp/exp with libs that prevent you from using stdin/stdout
in the manner you would on unix.

I found out too late about netcat:
(http://dbasupport.com/oracle/ora9i/resolutions.shtml) 

So, it was the mig utility for us.

Jared


On Tue, 2004-01-06 at 12:54, DENNIS WILLIAMS wrote:
 Jared - I don't know SAP, but other canned applications have a wonderful
 process they put you through every few years called an upgrade. Often you
 end up creating another database and moving the data. This is a great
 opportunity for the DBA to fix some issues like this. However, since SAP
is
 used by some REALLY large organizations with really, really large amounts
of
 data, perhaps SAP uses a different practice. I would like to know if that
is
 the case.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Monday, January 05, 2004 8:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Tanel,
 
 That's a good idea.  I briefly considered this, but
 didn't really dig into it. 
 
 The systems I need to do this on is our SAP systems, and
 downtime is a precious commodity, especially for production.
 
 I just may try this on our test system.  The problem with
 SAP of course, and many other ERP's is that there are 22k+
 tables, which could consume a bit of time.
 
 The amount of fragmented space that would be recovered is
 probably not worth the trouble of this procedure, depending
 on how much time it takes.
 
 I see that you too need to keep the original tablespace names,
 is this SAP per chance?
 
 If you have already performed a test of this, what kind of
 times are you seeing, along with relevant platform information,
 and the number of tables/indexes?
 
 Jared
 
 
 On Mon, 2004-01-05 at 16:49, Tanel Poder wrote:
  Hi!
  
   This is what I will need to use on our systems, as there are about 400
 gig
   of data and indexes.  200 gig of data is too large to export/import,
at
  least
   it is for this project.  So dbms_space_admin it will be.
  
  I'm about to do a reorg+conversion of a 250GB 8.1.6 database in next
week,
  here's what I'll do (there is practically no free space for temporary
  usage):
  
  1) Export index definitions (normal export with rows=n)
  2) Drop all indexes
  3) use alter table move with parallel 16 and nologging to move all
tables
 to
  old index tablespaces (the indexes consumed more space than tables)
  4) drop and recreate data tablespaces
  5) use alter table move again to move tables back (the segments have 

Re: Re[1]: OCP question from Boson practice tests

[Mladen Gogala]

Misconceptions, superstitions and myths are always useful to know 
and believe in. They make people better socialized and the risk
of being burnt at stake as a heretic(metaphorically, of course) 
is much lower.

On 01/07/2004 10:59:26 AM, Cary Millsap wrote:
 Or is it necessary to work harder to acquire some
 veneer of false knowledge specifically in order to pass the exam?

--
Mladen Gogala
Oracle DBA
-- 
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).

Re: Verisign and MetaLink

[Rachel Carmichael]

I got them as well and managed to get into metalink -- seems to be
connected to Advanced networking option

Rachel

--- Jesse, Rich [EMAIL PROTECTED] wrote:
 So I got two e-mails today from Oracle Support warning about Verisign
 Certs
 expiring today and to check MetaLink (thanks for the advanced warning
 guys).
 I've been trying for over an hour now and am getting no joy.  Anyone
 know
 what the Verisign Certs are used for in Oracle products?  I don't
 think we
 have any of those products, but...
 
 TIA,
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 -- 
 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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: Apple RAID marketing?

[Mladen Gogala]

But then again, the DBA can get a free iPod, which is a good thing indeed.

On 01/07/2004 10:59:50 AM, Jesse, Rich wrote:
 So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID
 with 3+TB for US $11K.  After looking at Apple's page, I poo-poo it because
 it's 7.2K spin ATA/100 drives, which I figure would lead to all sorts of
 problems.  I see today in Computerworld that it's being touted as blazing
 with a max thruput of 210MBps.  H...I know the mid-range FAStT SAN we're
 looking at is rated at about 800MBps theoretical max.
 
 Just looking for confirmation/rebuttal that I don't think it would be wise
 to load up an Xserve RAID with Oracle DBs -- even if the BAARF's nemesis is
 avoided.
 
 http://www.apple.com/xserve/raid
 
 TIA,
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 -- 
 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).
 

--
Mladen Gogala
Oracle DBA
-- 
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).

RE: Hotsos' Classes

[Potluri, Venu (CT Appl Suppt)]

Cary,

So, I don't need to be completely proficient in SQL Optimization prior to enrolling in 
Performance Diagnosis 101? When if it all do you plan to offer these classes in New 
York, NJ area?


Venu Potluri

-Original Message-
Cary Millsap
Sent: Wednesday, January 07, 2004 1:04 AM
To: Multiple recipients of list ORACLE-L


Venu,

I can't give a nonpartisan answer, but I can provide some information. I
hope this helps:

Performance Diagnosis 101 (formerly the Hotsos Clinic) - This is a
3-day course dedicated to teaching a method for diagnosing performance
problems on production (and integration-testing) systems. It's an
instructor-led course with about 70% lecture and 30% exercises and
discussion. More information, including FAQs, at
www.hotsos.com/education/PD101.php.

SQL Optimization 101 - This is a 5-day course, presently in beta
development, dedicated to teaching developers and DBAs how to optimize
inefficient SQL statements in both stock and custom applications. More
information at www.hotsos.com/education/OP101.php.

Hotsos Symposium 2004 - This is a 3-day conference that showcases lots
of speakers from all over the world. Presentations range from basic to
advanced, but everything at the event focuses on issues of Oracle system
performance. More information at www.hotsos.com/appearances/sym2004.php.
See www.hotsos.com/appearances/sym2004-papers.php for the draft of the
presentation abstract list.

Steve Adams seminar - We've invited Steve to present a one-day follow-up
seminar after our Symposium. His subject matter will be very focused and
very deep. I saw 3 days of his material last year in Denmark, and it was
phenomenal. Steve comes rarely to the USA, so we're fortunate to have
convinced him to present in conjunction with our event in Dallas. More
information at www.hotsos.com/appearances/adams2004.03.php. 


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Potluri, Venu (CT Appl Suppt)
Sent: Tuesday, January 06, 2004 1:24 PM
To: Multiple recipients of list ORACLE-L

Is there a proper sequence of classes to take, among those offered by
Hotsos? While I do use Wait events to monitor  tune  my Oracle
Financials databases, I need more training in Performance
tuning. I am just dipping my toes into the world of Oracle Performance
Tuning. I am reading Cary's book and I have used Ixora's treasure of
information, quite a bit in the past. 

I see there are a number of classes now as opposed to a clinic in the
past.

Performance Diagnosis 101
SQL Optimization 101
Hotsos Symposium 2004
Steve Adams Seminar

While I would love to take all of them, time  work schedule permitting,
I wouldn't want to waste time either if any of the subject matter goes
above my head and I spend time scratching my head. God
knows I might even find SQL Tuning class useful to brush up little that
I know. Would the Hotsos Symposium be not suitable for poeple like
myself who haven't taken the Performance Diagnostics 101
class and aren't well versed with Performance Tuning? What is expected
of the audience in terms of prior knowledge? Mind you, I am not an
expert like most of you guys. Haven't written a book or even a
paper!

Venu Potluri
Oracle Financials DBA



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Potluri, Venu (CT Appl Suppt)
  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: Cary Millsap
  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: Potluri, Venu (CT Appl Suppt)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list 

RE: Re[1]: OCP question from Boson practice tests

[Rachel Carmichael]

From past history:

I passed the 8 and 8i exams without having done any work in either
version, nor did I study for them. I used Jonathan's method of using
later questions to infer the answer to earlier ones, in part. Marlene
Theriault, an excellent DBA, took several tries to pass because she
knew the correct answers and therefore was usually wrong in the
expected answer.  :)


--- Cary Millsap [EMAIL PROTECTED] wrote:
 My question, Richard, is can a person pass the exam just by studying
 what is correct? Or is it necessary to work harder to acquire some
 veneer of false knowledge specifically in order to pass the exam?
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Prem Khanna J
 Sent: Wednesday, January 07, 2004 8:39 AM
 To: Multiple recipients of list ORACLE-L
 
 Hi Richard , 
 
 Many a thanx for both of your replies . 
 All my worry is :  do such questions appear in the real exams also ? 
 
 And your reply has increased my self-confidence.
 particularly the line : 
 RFTrust what you *see*, not what you *read*. /RF
 
 RFYou actually proven this yourself and yet you still have doubts?
 /RF
 yes Richard  : (   
 hope i will not repeat this as time goes and my experience grows. 
 i.e., i will be more confident with my answers .
 
 okay , coming back to the sizing of temp tablespace question . 
 if suppose , such a question appears in the exam too ( my bad luck )
 ,
 what will be your two best answers  ?
 
 Thanks and Regards,
 Prem.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Prem Khanna J
   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: Cary Millsap
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: Re[2]: another OCP question -- help me guys

[Rachel Carmichael]

Now I understand their use, I shall immediately go out and hire an art
history major as the deparmental sacrifical lamb (and dartboard while
we are at it)

I'm still a hands-on DBA, although I have some paperwork
responsibilities as well. Not management, other than my own work :)

Rachel

--- Mladen Gogala [EMAIL PROTECTED] wrote:
 
 On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
 programming
  and database work?
 
 Believe it or not, a college degree in art history really does help
 in two ways.
 First, people exposed to sufficient quantity of art tend to be nobler
 and more 
 spiritual, according to the popular beliefs, then cynical
 mathematicians and 
 computer geeks like me. Being noble and spiritual means that they
 don't fight 
 back but do as they're told which makes them into good corporate
 drones. Art
 history is like an army boot camp for wannabe geeks. Their appearance
 also tends
 to be much more pleasant and polished then an appearance of a hard
 core computer 
 geek.
 Second, art history majors make perfect sacrificial lambs. An art
 history major in 
 IT department can be blamed for anything from bad weather, corrupt
 backup tape to 
 stupid application design. My understanding is that you've moved to
 the management, 
 which is the move that I admire and respect. As a manager, you should
 know the value 
 of a sacrificial lamb that can be blamed for anything. If you want to
 make the next
 step in your career, the step from management to damagement, you'll
 have to learn
 how to play the blame shifting game. Art history majors are priceless
 for that.
 --
 Mladen Gogala
 Oracle DBA
 -- 
 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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: Re[1]: OCP question from Boson practice tests

[Carel-Jan Engel]

Wasn't it you, Cary, who got tought by his parents that every question has 
two answers: The right one and the one the teacher wants to hear? And you 
had to learn them both?

That's merely what OCP is about, I think. Get a certificate to get hired, 
and get the proper knowledge to remain hired ;-)

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===
At 07:59 7-1-04 -0800, you wrote:
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Prem Khanna J
Sent: Wednesday, January 07, 2004 8:39 AM
To: Multiple recipients of list ORACLE-L
Hi Richard ,

Many a thanx for both of your replies .
All my worry is :  do such questions appear in the real exams also ?
And your reply has increased my self-confidence.
particularly the line :
RFTrust what you *see*, not what you *read*. /RF
RFYou actually proven this yourself and yet you still have doubts?
/RF
yes Richard  : (
hope i will not repeat this as time goes and my experience grows.
i.e., i will be more confident with my answers .
okay , coming back to the sizing of temp tablespace question .
if suppose , such a question appears in the exam too ( my bad luck ) ,
what will be your two best answers  ?
Thanks and Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
  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: Cary Millsap
  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).
Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

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

data warehouse vs regular database??

[Janet Linsy]

Hi all,

I have been working with Oracle 92. I have no
experience with Oracle Warehouse. In my current
company, I was told the database is a warehouse.  I
can connect to it using sql plus or pl/sql developer. 
The warehouse looks the same as the database I
worked with before.  How do I tell if a database is a
warehouse or just a regular database.  What's the big
difference between the two?  

Could someone send me some link about data warehouse?

Thank you!

Janet  

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  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: Re[2]: another OCP question -- help me guys

[Loughmiller, Greg]

Title: RE: Re[2]: another OCP question -- help me guys





brutal, absolutely brutal...


Rachel, can ya out-source your sacrificial lamb for our use as well:-)


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: another OCP question -- help me guys



Now I understand their use, I shall immediately go out and hire an art
history major as the deparmental sacrifical lamb (and dartboard while
we are at it)


I'm still a hands-on DBA, although I have some paperwork
responsibilities as well. Not management, other than my own work :)


Rachel


--- Mladen Gogala [EMAIL PROTECTED] wrote:
 
 On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
 programming
  and database work?
 
 Believe it or not, a college degree in art history really does help
 in two ways.
 First, people exposed to sufficient quantity of art tend to be nobler
 and more 
 spiritual, according to the popular beliefs, then cynical
 mathematicians and 
 computer geeks like me. Being noble and spiritual means that they
 don't fight 
 back but do as they're told which makes them into good corporate
 drones. Art
 history is like an army boot camp for wannabe geeks. Their appearance
 also tends
 to be much more pleasant and polished then an appearance of a hard
 core computer 
 geek.
 Second, art history majors make perfect sacrificial lambs. An art
 history major in 
 IT department can be blamed for anything from bad weather, corrupt
 backup tape to 
 stupid application design. My understanding is that you've moved to
 the management, 
 which is the move that I admire and respect. As a manager, you should
 know the value 
 of a sacrificial lamb that can be blamed for anything. If you want to
 make the next
 step in your career, the step from management to damagement, you'll
 have to learn
 how to play the blame shifting game. Art history majors are priceless
 for that.
 --
 Mladen Gogala
 Oracle DBA
 -- 
 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).



__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
 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: Re[2]: another OCP question -- help me guys

[Goulet, Dick]

Rachel,

A few years ago I was offered a job by a defense contractor in the area who 
was looking for a DBA, but more importantly a DBA with a still active clearance.  Well 
all was well in 90% of that company, except HR.  Simple answer, no degree no job.  I 
don't have the degree so they absolutely would not let the paperwork through, end of 
conversation.  So yes it does matter even when it makes no sense.  BTW: they did fill 
the job a year later with a person who had a degree in English believe it or not.  Her 
clearance was inactive  not current as well.  Guess it's better than no clearance.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 10:29 AM
To: Multiple recipients of list ORACLE-L


Rachel Carmichael  scribbled on the wall in glitter crayon:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current
 programming and database work?

it gets you past the HR department so you actually get to talk to someone.
trust me, i know all about this one having neither a degree or an OCP.  and
having lost jobs to those art history degree holders.  [and yes i have been
asked to go back to those same places as a consultant to fix the mess.  and
no i didn't.]

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

You see, wire telegraph is a kind of a very, very long cat. You pull his
tail in New York and his head is meowing in Los Angeles. Do you understand
this? And radio operates exactly the same way: you send signals here, they
receive them there. The only difference is that there is no cat. - Albert
Einstein, when asked to describe radio
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: Goulet, Dick
  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: OCP Question (Perf Tuning)

[Tanel Poder]

 What I have heard is that all the OCP questions are taken from the Oracle
 University Student Guide. After all, you wouldn't you expect the class to
 prepare you? Someone suggested that you think like a computer. Well, for
 the philosophy behind the exam, think like an organization, namely
Oracle
 University.

We'll thats exactly what I'm doing right now, studying Oracle University
instructor guides to temporarily start thinking like OU myself again - I'll
be instructing an OCP Review course next week, meant for people who want to
pass OCP. And in order to not distract the students, I won't even mention
the real life situation too much, except in really misleading cases...

Tanel.


-- 
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: Re[1]: OCP question from Boson practice tests

[Cary Millsap]

Yes, I was the one. I was just wondering whether the OCP performance
exam was really as bad as it used to be. I haven't seen it since
whatever the things were called back in the early 90s. From some of what
I've seen here, the answer is that yes it is the same. Not just
philosophically the same, but probably some of the same release 7
questions are still on the test.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Carel-Jan Engel
Sent: Wednesday, January 07, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L

Wasn't it you, Cary, who got tought by his parents that every question
has 
two answers: The right one and the one the teacher wants to hear? And
you 
had to learn them both?

That's merely what OCP is about, I think. Get a certificate to get
hired, 
and get the proper knowledge to remain hired ;-)


Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===

At 07:59 7-1-04 -0800, you wrote:
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Prem Khanna J
Sent: Wednesday, January 07, 2004 8:39 AM
To: Multiple recipients of list ORACLE-L

Hi Richard ,

Many a thanx for both of your replies .
All my worry is :  do such questions appear in the real exams also ?

And your reply has increased my self-confidence.
particularly the line :
RFTrust what you *see*, not what you *read*. /RF

RFYou actually proven this yourself and yet you still have doubts?
/RF
yes Richard  : (
hope i will not repeat this as time goes and my experience grows.
i.e., i will be more confident with my answers .

okay , coming back to the sizing of temp tablespace question .
if suppose , such a question appears in the exam too ( my bad luck ) ,
what will be your two best answers  ?

Thanks and Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
   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: Cary Millsap
   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).

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  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: Cary Millsap
  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 

RE: Re[1]: OCP question from Boson practice tests

[Poras, Henry R.]

or from the other side: the right one, and the one pig-headed students are
convinced is right (even if you can incontrovertably demonstrate they are
wrong). Does that make three answers? or two answers with three labels?

Henry


-Original Message-
Carel-Jan Engel
Sent: Wednesday, January 07, 2004 12:05 PM
To: Multiple recipients of list ORACLE-L


Wasn't it you, Cary, who got tought by his parents that every question has 
two answers: The right one and the one the teacher wants to hear? And you 
had to learn them both?

That's merely what OCP is about, I think. Get a certificate to get hired, 
and get the proper knowledge to remain hired ;-)


Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===

At 07:59 7-1-04 -0800, you wrote:
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Prem Khanna J
Sent: Wednesday, January 07, 2004 8:39 AM
To: Multiple recipients of list ORACLE-L

Hi Richard ,

Many a thanx for both of your replies .
All my worry is :  do such questions appear in the real exams also ?

And your reply has increased my self-confidence.
particularly the line :
RFTrust what you *see*, not what you *read*. /RF

RFYou actually proven this yourself and yet you still have doubts?
/RF
yes Richard  : (
hope i will not repeat this as time goes and my experience grows.
i.e., i will be more confident with my answers .

okay , coming back to the sizing of temp tablespace question .
if suppose , such a question appears in the exam too ( my bad luck ) ,
what will be your two best answers  ?

Thanks and Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
   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: Cary Millsap
   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).

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  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: Poras, Henry R.
  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: Re[2]: another OCP question -- help me guys

[Poras, Henry R.]

what you lose in worth you gain in self-worth.

Henry


-Original Message-
Ryan
Sent: Wednesday, January 07, 2004 10:55 AM
To: Multiple recipients of list ORACLE-L


degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp companies offer you
salary based mainly on your resume.

most technical interviews are a joke. I can make more money if I double my
experience level and have a computer science degree from harvard, while at
the same time halving my skillset and performance.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:29 AM


 Rachel Carmichael  scribbled on the wall in glitter crayon:

  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer science
  but which is 28 years old, have anything to do with current
  programming and database work?

 it gets you past the HR department so you actually get to talk to someone.
 trust me, i know all about this one having neither a degree or an OCP.
and
 having lost jobs to those art history degree holders.  [and yes i have
been
 asked to go back to those same places as a consultant to fix the mess.
and
 no i didn't.]

 --
 Bill Shrek Thater ORACLE DBA
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 You see, wire telegraph is a kind of a very, very long cat. You pull his
 tail in New York and his head is meowing in Los Angeles. Do you understand
 this? And radio operates exactly the same way: you send signals here, they
 receive them there. The only difference is that there is no cat. - Albert
 Einstein, when asked to describe radio
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Thater, William
   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: Ryan
  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: Poras, Henry R.
  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: Hotsos' Classes

[Cary Millsap]

Venu,

You are correct. The outcome of many problems you'll diagnose using the
PD101 method is that you'll need to fix some SQL, but the point of PD101
is teaching you (1) how to make sure you're working on the right
problem, and (2) how to forecast what kind of performance improvement
you'll get from each reaction you might take to the problem. The end
result is that you don't waste your time working on either the wrong
problem, or even the wrong fix to the right problem.

Our schedule through the end of Q2 is set (see hotsos.com). We've always
done at least one event per year in either NY/NJ or Botson. I expect
this year we'll do one event in one of these locations sometime this
summer or fall. We'll post our Q3 calendar sometime toward the end of
Q1.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Potluri, Venu (CT Appl Suppt)
Sent: Wednesday, January 07, 2004 10:49 AM
To: Multiple recipients of list ORACLE-L

Cary,

So, I don't need to be completely proficient in SQL Optimization prior
to enrolling in Performance Diagnosis 101? When if it all do you plan to
offer these classes in New York, NJ area?


Venu Potluri

-Original Message-
Cary Millsap
Sent: Wednesday, January 07, 2004 1:04 AM
To: Multiple recipients of list ORACLE-L


Venu,

I can't give a nonpartisan answer, but I can provide some information. I
hope this helps:

Performance Diagnosis 101 (formerly the Hotsos Clinic) - This is a
3-day course dedicated to teaching a method for diagnosing performance
problems on production (and integration-testing) systems. It's an
instructor-led course with about 70% lecture and 30% exercises and
discussion. More information, including FAQs, at
www.hotsos.com/education/PD101.php.

SQL Optimization 101 - This is a 5-day course, presently in beta
development, dedicated to teaching developers and DBAs how to optimize
inefficient SQL statements in both stock and custom applications. More
information at www.hotsos.com/education/OP101.php.

Hotsos Symposium 2004 - This is a 3-day conference that showcases lots
of speakers from all over the world. Presentations range from basic to
advanced, but everything at the event focuses on issues of Oracle system
performance. More information at www.hotsos.com/appearances/sym2004.php.
See www.hotsos.com/appearances/sym2004-papers.php for the draft of the
presentation abstract list.

Steve Adams seminar - We've invited Steve to present a one-day follow-up
seminar after our Symposium. His subject matter will be very focused and
very deep. I saw 3 days of his material last year in Denmark, and it was
phenomenal. Steve comes rarely to the USA, so we're fortunate to have
convinced him to present in conjunction with our event in Dallas. More
information at www.hotsos.com/appearances/adams2004.03.php. 


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Potluri, Venu (CT Appl Suppt)
Sent: Tuesday, January 06, 2004 1:24 PM
To: Multiple recipients of list ORACLE-L

Is there a proper sequence of classes to take, among those offered by
Hotsos? While I do use Wait events to monitor  tune  my Oracle
Financials databases, I need more training in Performance
tuning. I am just dipping my toes into the world of Oracle Performance
Tuning. I am reading Cary's book and I have used Ixora's treasure of
information, quite a bit in the past. 

I see there are a number of classes now as opposed to a clinic in the
past.

Performance Diagnosis 101
SQL Optimization 101
Hotsos Symposium 2004
Steve Adams Seminar

While I would love to take all of them, time  work schedule permitting,
I wouldn't want to waste time either if any of the subject matter goes
above my head and I spend time scratching my head. God
knows I might even find SQL Tuning class useful to brush up little that
I know. Would the Hotsos Symposium be not suitable for poeple like
myself who haven't taken the Performance Diagnostics 101
class and aren't well versed with Performance Tuning? What is expected
of the audience in terms of prior knowledge? Mind you, I am not an
expert like most of you guys. Haven't written a book or even a
paper!

Venu Potluri
Oracle Financials DBA



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Potluri, Venu (CT Appl Suppt)
  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 

RE: Re[2]: another OCP question -- help me guys

[Rachel Carmichael]

I know it makes no sense... but it has something to do with a (very)
antiquated class system and the difference between white-collar
workers and blue-collar workers and salary vs hourly wages

for the non-US, the term white collar worker refers to office staff,
who would wear a white shirt and tie to the office. While blue collar
refers to the people who get their hands dirty, wearing blue denim
shirts.

Always amused me that the IBM field staff had to wear white shirts and
ties while working on machinery that had grease and carbon etc all over
it.


--- Goulet, Dick [EMAIL PROTECTED] wrote:
 Rachel,
 
   A few years ago I was offered a job by a defense contractor in the
 area who was looking for a DBA, but more importantly a DBA with a
 still active clearance.  Well all was well in 90% of that company,
 except HR.  Simple answer, no degree no job.  I don't have the degree
 so they absolutely would not let the paperwork through, end of
 conversation.  So yes it does matter even when it makes no sense. 
 BTW: they did fill the job a year later with a person who had a
 degree in English believe it or not.  Her clearance was inactive 
 not current as well.  Guess it's better than no clearance.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA
 
 -Original Message-
 Sent: Wednesday, January 07, 2004 10:29 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Rachel Carmichael  scribbled on the wall in glitter crayon:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
  programming and database work?
 
 it gets you past the HR department so you actually get to talk to
 someone.
 trust me, i know all about this one having neither a degree or an
 OCP.  and
 having lost jobs to those art history degree holders.  [and yes i
 have been
 asked to go back to those same places as a consultant to fix the
 mess.  and
 no i didn't.]
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]


 You see, wire telegraph is a kind of a very, very long cat. You pull
 his
 tail in New York and his head is meowing in Los Angeles. Do you
 understand
 this? And radio operates exactly the same way: you send signals here,
 they
 receive them there. The only difference is that there is no cat. -
 Albert
 Einstein, when asked to describe radio
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Thater, William
   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: Goulet, Dick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: data warehouse vs regular database??

[Mladen Gogala]

prank
If you enter the following query select 'Data Warehouse' from dual; 
and if the database responds with 'Data Warehouse', then your database 
is a DW database.
/prank

Data warehouses can be distinguished from their less noble cousins,
the OLTP databases, by the way they're accessed and by their business 
purpose.
If the purpose of the database is to support the ongoing business process
and to record and support ongoing business transactions (includes a lot
of inserts, updates and deletes which happen all the time) then you have
an OLTP database. 
If the database is used for reporting and trend research purposes and the 
data is added once a month and never deleted, then you have a data warehouse
database.
If the database is refreshed at least once a month and re-created as a copy
of an OLTP database, with bitmap indexes and material views added for reporting
purposes you have something called operational data store, which is used for
generating statements, printing checks, large data extractions and B2B 
communication (based on HIPAA, for instance).

I have to advise  reading of the Gospel By Jonathan for you too. Gospel by Jonathan
is also known as Practical Oracle 8i: Building Efficient Databases and can be 
purchased from Barnes  Noble, Border Books or Bookpool.

On 01/07/2004 12:04:25 PM, Janet Linsy wrote:
 Hi all,
 
 I have been working with Oracle 92. I have no
 experience with Oracle Warehouse. In my current
 company, I was told the database is a warehouse.  I
 can connect to it using sql plus or pl/sql developer. 
 The warehouse looks the same as the database I
 worked with before.  How do I tell if a database is a
 warehouse or just a regular database.  What's the big
 difference between the two?  
 
 Could someone send me some link about data warehouse?
 
 Thank you!
 
 Janet  
 
 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Janet Linsy
   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).
 

--
Mladen Gogala
Oracle DBA
-- 
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).

RE: data warehouse vs regular database??

[Goulet, Dick]

Janet,

A data warehouse is a database.  Now if the data warehouse has all of the 
data structures of the OLTP database and people are using those tables like one would 
expect, then your just using the same instance for both purposes, which is a recipe 
for disaster in my opinion.  A data warehouse is characterized by several large (both 
in width and depth) tables with somewhat demoralized and static data and/or a number 
of star schemas that have very deep fact tables.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 12:04 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I have been working with Oracle 92. I have no
experience with Oracle Warehouse. In my current
company, I was told the database is a warehouse.  I
can connect to it using sql plus or pl/sql developer. 
The warehouse looks the same as the database I
worked with before.  How do I tell if a database is a
warehouse or just a regular database.  What's the big
difference between the two?  

Could someone send me some link about data warehouse?

Thank you!

Janet  

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  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: Goulet, Dick
  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: Hotsos' Classes

[Ryan]

how much of the material from these classes are in your book? 
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:24 PM


 Venu,
 
 You are correct. The outcome of many problems you'll diagnose using the
 PD101 method is that you'll need to fix some SQL, but the point of PD101
 is teaching you (1) how to make sure you're working on the right
 problem, and (2) how to forecast what kind of performance improvement
 you'll get from each reaction you might take to the problem. The end
 result is that you don't waste your time working on either the wrong
 problem, or even the wrong fix to the right problem.
 
 Our schedule through the end of Q2 is set (see hotsos.com). We've always
 done at least one event per year in either NY/NJ or Botson. I expect
 this year we'll do one event in one of these locations sometime this
 summer or fall. We'll post our Q3 calendar sometime toward the end of
 Q1.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Potluri, Venu (CT Appl Suppt)
 Sent: Wednesday, January 07, 2004 10:49 AM
 To: Multiple recipients of list ORACLE-L
 
 Cary,
 
 So, I don't need to be completely proficient in SQL Optimization prior
 to enrolling in Performance Diagnosis 101? When if it all do you plan to
 offer these classes in New York, NJ area?
 
 
 Venu Potluri
 
 -Original Message-
 Cary Millsap
 Sent: Wednesday, January 07, 2004 1:04 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Venu,
 
 I can't give a nonpartisan answer, but I can provide some information. I
 hope this helps:
 
 Performance Diagnosis 101 (formerly the Hotsos Clinic) - This is a
 3-day course dedicated to teaching a method for diagnosing performance
 problems on production (and integration-testing) systems. It's an
 instructor-led course with about 70% lecture and 30% exercises and
 discussion. More information, including FAQs, at
 www.hotsos.com/education/PD101.php.
 
 SQL Optimization 101 - This is a 5-day course, presently in beta
 development, dedicated to teaching developers and DBAs how to optimize
 inefficient SQL statements in both stock and custom applications. More
 information at www.hotsos.com/education/OP101.php.
 
 Hotsos Symposium 2004 - This is a 3-day conference that showcases lots
 of speakers from all over the world. Presentations range from basic to
 advanced, but everything at the event focuses on issues of Oracle system
 performance. More information at www.hotsos.com/appearances/sym2004.php.
 See www.hotsos.com/appearances/sym2004-papers.php for the draft of the
 presentation abstract list.
 
 Steve Adams seminar - We've invited Steve to present a one-day follow-up
 seminar after our Symposium. His subject matter will be very focused and
 very deep. I saw 3 days of his material last year in Denmark, and it was
 phenomenal. Steve comes rarely to the USA, so we're fortunate to have
 convinced him to present in conjunction with our event in Dallas. More
 information at www.hotsos.com/appearances/adams2004.03.php. 
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Potluri, Venu (CT Appl Suppt)
 Sent: Tuesday, January 06, 2004 1:24 PM
 To: Multiple recipients of list ORACLE-L
 
 Is there a proper sequence of classes to take, among those offered by
 Hotsos? While I do use Wait events to monitor  tune  my Oracle
 Financials databases, I need more training in Performance
 tuning. I am just dipping my toes into the world of Oracle Performance
 Tuning. I am reading Cary's book and I have used Ixora's treasure of
 information, quite a bit in the past. 
 
 I see there are a number of classes now as opposed to a clinic in the
 past.
 
 Performance Diagnosis 101
 SQL Optimization 101
 Hotsos Symposium 2004
 Steve Adams Seminar
 
 While I would love to take all of them, time  work schedule permitting,
 I wouldn't want to waste time either if any of the subject matter goes
 above my head and I spend time scratching my head. God
 knows I might even find SQL Tuning class useful to brush up little that
 I know. Would the Hotsos Symposium be not suitable for poeple like
 myself who haven't taken the Performance Diagnostics 101
 class and aren't well versed with Performance Tuning? What is expected
 of the audience in terms of prior knowledge? Mind you, I am not an
 expert like most of you guys. Haven't written a book or even a
 paper!
 
 Venu Potluri
 Oracle Financials DBA
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Potluri, Venu 

RE: Hotsos' Classes

[Cary Millsap]

Ryan,

Parts of the book are based upon the PD101 course. The book goes further
in some areas than the PD101 course (queueing theory, V$ views), but
then the course goes further in some areas than the book. The course
discusses developments that have occurred since the publication of the
book, and we spend a lot more time practicing case studies in the course
than the book does.

The OP101 course and the book are almost totally independent.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Ryan
Sent: Wednesday, January 07, 2004 11:55 AM
To: Multiple recipients of list ORACLE-L

how much of the material from these classes are in your book? 
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:24 PM


 Venu,
 
 You are correct. The outcome of many problems you'll diagnose using
the
 PD101 method is that you'll need to fix some SQL, but the point of
PD101
 is teaching you (1) how to make sure you're working on the right
 problem, and (2) how to forecast what kind of performance improvement
 you'll get from each reaction you might take to the problem. The end
 result is that you don't waste your time working on either the wrong
 problem, or even the wrong fix to the right problem.
 
 Our schedule through the end of Q2 is set (see hotsos.com). We've
always
 done at least one event per year in either NY/NJ or Botson. I expect
 this year we'll do one event in one of these locations sometime this
 summer or fall. We'll post our Q3 calendar sometime toward the end of
 Q1.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Potluri, Venu (CT Appl Suppt)
 Sent: Wednesday, January 07, 2004 10:49 AM
 To: Multiple recipients of list ORACLE-L
 
 Cary,
 
 So, I don't need to be completely proficient in SQL Optimization prior
 to enrolling in Performance Diagnosis 101? When if it all do you plan
to
 offer these classes in New York, NJ area?
 
 
 Venu Potluri
 
 -Original Message-
 Cary Millsap
 Sent: Wednesday, January 07, 2004 1:04 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Venu,
 
 I can't give a nonpartisan answer, but I can provide some information.
I
 hope this helps:
 
 Performance Diagnosis 101 (formerly the Hotsos Clinic) - This is a
 3-day course dedicated to teaching a method for diagnosing performance
 problems on production (and integration-testing) systems. It's an
 instructor-led course with about 70% lecture and 30% exercises and
 discussion. More information, including FAQs, at
 www.hotsos.com/education/PD101.php.
 
 SQL Optimization 101 - This is a 5-day course, presently in beta
 development, dedicated to teaching developers and DBAs how to optimize
 inefficient SQL statements in both stock and custom applications. More
 information at www.hotsos.com/education/OP101.php.
 
 Hotsos Symposium 2004 - This is a 3-day conference that showcases lots
 of speakers from all over the world. Presentations range from basic to
 advanced, but everything at the event focuses on issues of Oracle
system
 performance. More information at
www.hotsos.com/appearances/sym2004.php.
 See www.hotsos.com/appearances/sym2004-papers.php for the draft of the
 presentation abstract list.
 
 Steve Adams seminar - We've invited Steve to present a one-day
follow-up
 seminar after our Symposium. His subject matter will be very focused
and
 very deep. I saw 3 days of his material last year in Denmark, and it
was
 phenomenal. Steve comes rarely to the USA, so we're fortunate to have
 convinced him to present in conjunction with our event in Dallas. More
 information at www.hotsos.com/appearances/adams2004.03.php. 
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Potluri, Venu (CT Appl Suppt)
 Sent: Tuesday, January 06, 2004 1:24 PM
 To: Multiple recipients of list ORACLE-L
 
 Is there a proper sequence of classes to take, among those offered by
 Hotsos? While I do use Wait events to monitor  tune  my Oracle
 Financials databases, I need more training in Performance
 tuning. I am just dipping my toes into the world of Oracle Performance
 Tuning. I am reading Cary's book and I have used Ixora's treasure of
 information, quite a bit in the past. 
 
 I see there are a number of classes now as opposed to a clinic in the
 past.
 
 Performance Diagnosis 101
 SQL 

Re: another OCP question -- help me guys

[bulbultyagi]

 Hi list , sorry to pester you with questions regarding
 boson OCP questions . i have scheduled for #1Z0-031 exam
 and so desperately need help from this list .
 please bear with me  for while . look at the 2 questions below .

Don't apologize Prem, who else are you gonna call,  ghostbusters? :)



 -
 QUESTION #1
 what happens when you issue the command below .
 drop tablespace testtbs including contents cascade constraints and
 datafiles;
 but boson's  choice is A.  i wonder how ???


Statement is incorrect, cascade constraints is placed in the end.  Fine that
explains that boson is wrong.  But if you want to prepare for ocp then , you
must also consider the possibility that a novice like me was sitting at
boson preparing these questions.  So the next time you come across a
question whose answer doesn't match yours do the following in the order
specified:

1. Assume boson is right and recheck your answer. Try it out on a test
database. (make sure you get the conditions of the question correctly
implemented).  See the docs.
2. Assume boson is right and read the solution /explanation for the answer,
then tally it with your answer and solution.
3. Still not happy ? Assume boson is right and re-read the question, there
may be one word or a comma or a full stop or a bracket ,etc that is
completly changing the meaning of the question but you may skipped it when
reading the question.  (It happens a lot to me, but then I am dumb :). Now
tally your answer with boson
4. Still not happy ? (there is no pleasing you, is there? :) ok now you can
do two things:
4a.  The question and the solution given by boson are blatantly wrong
(because of a typo or because I had set the question paper ) AND YOU ARE
ABLE TO COMPLETLY REASON OUT out what is so wrong about the question and
answer, what should it have been, what if that part of the question was
changed so , etc etc, ;  then correct the question and answer and move onto
the next one.
4b The question is still blatantly wrong but you have a nagging doubt, then
ask around .  There may be some obscure formula (which works only in OCP
exams) or the answer may be the least of all the evils given .  Either which
way time to mug it up


Now keeping in mind these policies, have another look at the two questions
you have given above and below.


 -
 QUESTION #2
 you need to determine how much space has been allocated for a table.
 which view would give you this information ?

 A. dba_extents
 B. dba_ts_quotas
 C. dba_segments

 my choice is C .
 but boson's choice is A . it says other views cannot give
 the required details .

 a metalink doc says that dba_segments.blocks gives the
 total number of blocks  allocated to the table.

 what will be the choice that you would go for ?
 -

Both A and C are right.  What will really boggle your mind is deciding what
to say if you get the exact same question in the ocp exam and you have to
make a single choice.
But relax ocp exams are not as troublesome, they are much more
professionally prepared.




 so now i have the question whether boson is reliable ?
 how many in this list have used it ?
 or am i missing something  : ((

After reading my letter I hope there is at least one thing you can say :
Boson is not reliable , but it is essential.  Remember , there is a big
difference between studying and studying for an exam .  And the only way to
ace the ocp is to do many question papers like boson.
..

-- 
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: OCP question from Boson practice tests

[bulbultyagi]

Prem ,
OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and humbly, play by its
rules.

Right now if your are serious about giving OCP exams then please
enable suspension of disbelief , don't ask why and just mug up the
following 3 (any one of them may come up in the ocp exam , though not
together) :

1.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to be a multiple of the parameter sort_area_size

2.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to be a multiple of  sort_area_size * db_block_size

3.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to ben * sort_area_size  +  db_block_size.


OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and play by its rules.
Best of luck .



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 16:14


 Hi List, this is the question .

 
 You are calculating the proper size for a temporary tablespace .
 Which of the following are two most important factors to consider ?

 A. users
 B. sort_area_size
 C. type of tablespace management
 D. db_block_size
 

 my choice is A  B .

 but boson's choice is B  D . the explanation given by boson is :
 when sizing a temporary tablespace , the formula is
 db_block_size * sort_area_size .

 is it so ? do we need not take no. of users into account ?
 kindly explain me .

 Regards,
 Prem.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Prem Khanna J
   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: data warehouse vs regular database??

[Jared Still]

The Ralph Kimball answer:

A DW is a collection of data marts.  A Data mart
is typically a fact table surrounded by a collection
of dimension tables.

The Bill Inmon answer:

A DW is a system designed to collect data from an 
enterprise for the purpose of creating data marts.

It is not normally queried by end users, that is
what the DM's are for.

Regardless of which viewpoint you hold, both are
characterized by data being time sensitive: facts
are stored with date.

Then again, there are databases that do not really 
resemble either of these, but are nonetheless used
as a DW.

Where does your database get its data from?  If it
comes from other databases and/or systems, then it
is likely a DW.

Google for data warehouse institute, Ralph Kimball
and Bill Inmon, and you will find plenty of info.

If you want to learn about DW, Kimball's The Data Warehouse
Toolkit is a good place to start.

HTH

Jared

On Wed, 2004-01-07 at 09:04, Janet Linsy wrote:
 Hi all,
 
 I have been working with Oracle 92. I have no
 experience with Oracle Warehouse. In my current
 company, I was told the database is a warehouse.  I
 can connect to it using sql plus or pl/sql developer. 
 The warehouse looks the same as the database I
 worked with before.  How do I tell if a database is a
 warehouse or just a regular database.  What's the big
 difference between the two?  
 
 Could someone send me some link about data warehouse?
 
 Thank you!
 
 Janet  
 
 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Janet Linsy
   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: Jared Still
  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: Apple RAID marketing?

[Matthew Zito]

It depends a lot on the workload - for DSS-esque systems with lots of
sequential reads/writes, etc., the performance of the individual ATA
spindles will probably be more than adequate.  As another side note, at that
price point, maybe you could afford to buy double the number of spindles you
need and double your spindle density, reducing the impact of the 7200 RPM
drives?

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Jesse, Rich
 Sent: Wednesday, January 07, 2004 11:00 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Apple RAID marketing?
 
 
 So a co-worker sends me an e-mail about Apple's 
 just-announced Xserve RAID with 3+TB for US $11K.  After 
 looking at Apple's page, I poo-poo it because it's 7.2K spin 
 ATA/100 drives, which I figure would lead to all sorts of 
 problems.  I see today in Computerworld that it's being 
 touted as blazing with a max thruput of 210MBps.  H...I 
 know the mid-range FAStT SAN we're looking at is rated at 
 about 800MBps theoretical max.
 
 Just looking for confirmation/rebuttal that I don't think it 
 would be wise to load up an Xserve RAID with Oracle DBs -- 
 even if the BAARF's nemesis is avoided.
 
http://www.apple.com/xserve/raid

TIA,
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).

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

Any good product / option for Source code control

[M Rafiq]

Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4
I am looking for any good product/option for centralized source code 
control.

Any pointer or experiences shall be appreciated.

Regards
Rafiq
_
Have fun customizing MSN Messenger — learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

--
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: Any good product / option for Source code control

[Goulet, Dick]

Source Safe

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 1:34 PM
To: Multiple recipients of list ORACLE-L


Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4

I am looking for any good product/option for centralized source code 
control.

Any pointer or experiences shall be appreciated.

Regards
Rafiq

_
Have fun customizing MSN Messenger - learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

-- 
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: Goulet, Dick
  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: Re[1]: OCP question from Boson practice tests

[Ryan]

the pl/sql exam is really bad too. It got worse from 8i to 9i. 10% of the
exam was on DBMS_LOB and no other packages were touched? I had about 6-7
questions on parameter ordering.

Its accurate, just useless.

I thought the architecture test wasn't bad at all. The 8i backup and
recovery one was 'ok' also.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:19 PM


 Yes, I was the one. I was just wondering whether the OCP performance
 exam was really as bad as it used to be. I haven't seen it since
 whatever the things were called back in the early 90s. From some of what
 I've seen here, the answer is that yes it is the same. Not just
 philosophically the same, but probably some of the same release 7
 questions are still on the test.


 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com

 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...


 -Original Message-
 Carel-Jan Engel
 Sent: Wednesday, January 07, 2004 11:05 AM
 To: Multiple recipients of list ORACLE-L

 Wasn't it you, Cary, who got tought by his parents that every question
 has
 two answers: The right one and the one the teacher wants to hear? And
 you
 had to learn them both?

 That's merely what OCP is about, I think. Get a certificate to get
 hired,
 and get the proper knowledge to remain hired ;-)


 Regards, Carel-Jan

 ===
 If you think education is expensive, try ignorance. (Derek Bok)
 ===

 At 07:59 7-1-04 -0800, you wrote:
 My question, Richard, is can a person pass the exam just by studying
 what is correct? Or is it necessary to work harder to acquire some
 veneer of false knowledge specifically in order to pass the exam?
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 1/27 Atlanta
 - SQL Optimization 101: 2/16 Dallas
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Prem Khanna J
 Sent: Wednesday, January 07, 2004 8:39 AM
 To: Multiple recipients of list ORACLE-L
 
 Hi Richard ,
 
 Many a thanx for both of your replies .
 All my worry is :  do such questions appear in the real exams also ?
 
 And your reply has increased my self-confidence.
 particularly the line :
 RFTrust what you *see*, not what you *read*. /RF
 
 RFYou actually proven this yourself and yet you still have doubts?
 /RF
 yes Richard  : (
 hope i will not repeat this as time goes and my experience grows.
 i.e., i will be more confident with my answers .
 
 okay , coming back to the sizing of temp tablespace question .
 if suppose , such a question appears in the exam too ( my bad luck ) ,
 what will be your two best answers  ?
 
 Thanks and Regards,
 Prem.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Prem Khanna J
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: Cary Millsap
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).

 Regards, Carel-Jan

 ===
 If you think education is expensive, try ignorance. (Derek Bok)
 ===

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Carel-Jan Engel
   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 

RE: Any good product / option for Source code control

[Stephen.Lee]

PVCS

http://www.softlanding.com/merant/vm.htm

I used this back when it was Intersolv that owned it.  One useful thing
about it was that the command line interface was well implemented so scripts
to automate check in, check out, software builds, etc. could be written (and
were written).

-Original Message-
I am looking for any good product/option for centralized source code 
control.

Any pointer or experiences shall be appreciated.
-- 
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: Any good product / option for Source code control

[Jamadagni, Rajendra]

We use PVCS ... oracle has SCM product ... if you intend to use source control for 
Forms/Reports etc, then I'd recommend Oracle SCM.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, January 07, 2004 1:49 PM
To: Multiple recipients of list ORACLE-L


Source Safe

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 1:34 PM
To: Multiple recipients of list ORACLE-L


Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4

I am looking for any good product/option for centralized source code 
control.

Any pointer or experiences shall be appreciated.

Regards
Rafiq

_
Have fun customizing MSN Messenger - learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

-- 
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: Goulet, Dick
  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).

**
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.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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: Any good product / option for Source code control

[Mladen Gogala]

Would it be lame if I suggested rcs or cvs? Those tools are standard.

On 01/07/2004 01:49:26 PM, Goulet, Dick wrote:
 Source Safe
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA
 
 -Original Message-
 Sent: Wednesday, January 07, 2004 1:34 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Env: Windows 2000/NT/HP-UX/Solaris/Linux
 Oracle Databases: 7.3 to 9.2.0.4
 
 I am looking for any good product/option for centralized source code 
 control.
 
 Any pointer or experiences shall be appreciated.
 
 Regards
 Rafiq
 
 _
 Have fun customizing MSN Messenger - learn how here!  
 http://www.msnmessenger-download.com/tracking/reach_customize
 
 -- 
 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: Goulet, Dick
   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).
 

--
Mladen Gogala
Oracle DBA
-- 
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).

Re: ora1652 question...

[Tanel Poder]

Fewcomments inline:

 1. Easier, but requires a bounce : Add the 
following event into init.ora  event="1652 trace name 
processstate level 10"
You can use alter system and dbms_system.set_ev in 
combination to force an event for all new and existing sessions, without a 
bounce (alter system does notset events for already existing 
sessions).

 And you can even add the following to capture 
1555 and 4031 errors  event="1555 trace name errorstack level 
3" event="4031 trace name errorstack level 3"  **BUT**, 
keep _all_ 'event' lines together in the file (just as with utl_file_dir 
entries)
Btw, you can have all needed events set with only 
one line as well, for example:

alter session set events '1555 trace name 
processstate level 10; name errorstack level 3:4031 trace nameerrorstack 
level 3';

This sets both processtate AND errorstack handlers 
(actions)for event 1555 AND an errorstack handler for event 
4031.
The colon separates events, and semicolons separate 
handlers for a specific event.

  2. Harder (requires coding/testing), 
but better control and options:  Create a System-level ON 
SERVERERROR trigger and check for 1652 (among others) and record all the 
details into either alert.log (via dbms_system.ksdwrt call), database 
table, utl_file etc.
Yep, that's a good idea. Some help for finding out 
where exactlydid the error occur, can be got by using dbms_systems 
functions format_call_stack and format_error_stack. 

Here's a simpleexample of usage:

SQL create table testtab (a 
number);

Table created.

SQL create table log (msg 
varchar2(2000));

Table created.

SQLSQL create or replace 
trigger test_trig 2 before insert on testtab 3 
declare 4 begin 5 insert into log (msg) values 
(dbms_utility.format_call_stack); 6 end; 7 
/

Trigger created.

SQLSQL create or replace 
procedure test_proc is 2 begin 3 
insert into testtab (a) values (1); 4 
commit; 5 end; 6 /

Procedure created.

SQLSQL exec 
test_proc

PL/SQL procedure successfully 
completed.

SQLSQL select * from 
log;

MSG- 
PL/SQL Call Stack - object 
line object handle number 
name2F71866C 1 
anonymous block2F743DB8 
3 
ADMIN.TEST_TRIG2F73D358 
3 procedure 
ADMIN.TEST_PROC2F6BF024 
1 anonymous block

If you start reading the stack from bottom up you 
see that I executed an anonymous block ("exec testproc" command whichis 
translated internally to"BEGIN test_proc; END;"in sqlplus). 

This command executed stored procedure TEST_PROC on 
line 1, which caused TEST_TRIG to fire on line 3. 
And TEST_TRIG caused an insert cursor to open on 
its 3rd line (although it shows just "anynymous block" in object name, you can 
verify it's a cursor using a library cache dump, field type for given object 
handle is "CRSR").

I'm not sure whether you can map the line number 
from stack with any DD objects, but at least in this test procedure lines seem 
to match with their corresponding ones from DBA_SOURCE and trigger lines match 
theirs from DBA_TRIGGERS.
SQL 
select line, text from dba_source where name = 'TEST_PROC';

 LINE 
TEXT-- 
- 
1 procedure test_proc is 2 
begin 3 
insert into testtab (a) values 
(1); 4 
commit; 5 end;

SQL set long 10SQL select trigger_body from dba_triggers where 
trigger_name = 'TEST_TRIG';

TRIGGER_BODYdeclarebegininsert 
into log (msg) values 
(dbms_utility.format_call_stack);end;


Note that format_call_stack only returns first 2000 
bytes from PL/SQL stack.

Tanel.

RE: Any good product / option for Source code control

[M Rafiq]

Hi All,

Thanks for all your replies.

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 07 Jan 2004 11:04:40 -0800
PVCS

http://www.softlanding.com/merant/vm.htm

I used this back when it was Intersolv that owned it.  One useful thing
about it was that the command line interface was well implemented so scripts
to automate check in, check out, software builds, etc. could be written (and
were written).
-Original Message-
I am looking for any good product/option for centralized source code
control.
Any pointer or experiences shall be appreciated.
--
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).
_
Have fun customizing MSN Messenger — learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

--
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: Any good product / option for Source code control

[Cary Millsap]

WinCVS has worked well for us and several of our friends. www.wincvs.org

If I recall correctly, it's free.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
M Rafiq
Sent: Wednesday, January 07, 2004 12:34 PM
To: Multiple recipients of list ORACLE-L

Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4

I am looking for any good product/option for centralized source code 
control.

Any pointer or experiences shall be appreciated.

Regards
Rafiq

_
Have fun customizing MSN Messenger - learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

-- 
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: Cary Millsap
  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: Any good product / option for Source code control

[Jeff Herrick]

PVCS is a nice tool, especially when combined with PVCSTracker for
change management. VSS (Visual SourceSafe) and PVCS offer similar
capabilities when compared side-by-side. PVCS has an (optional)
promotion model that VSS doesn't have (although VSS Labels can
'fake' it). Both tools have a command line capability contrary
to Steven's note. PVCS has an API that is callable from 'roll-your-own'
tools which is fairly cool of you want to write a lot of C/C++
code. VSS on the other hand has an exposed API that is callable
from VBScript as an Active-X objectso that you can automate
pushes through Active Server Pages and the like (been there..done
that!).

They're both nice toolsbut they're just _tools_ . You need
to figure out how to best use them before you roll them out.


HTH

Jeff Herrick

On Wed, 7 Jan 2004 [EMAIL PROTECTED] wrote:


 PVCS

 http://www.softlanding.com/merant/vm.htm

 I used this back when it was Intersolv that owned it.  One useful thing
 about it was that the command line interface was well implemented so scripts
 to automate check in, check out, software builds, etc. could be written (and
 were written).

 -Original Message-
 I am looking for any good product/option for centralized source code
 control.

 Any pointer or experiences shall be appreciated.
 --
 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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeff Herrick
  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: Progress of an index rebuild

[Craig Richards]

How about v$session_longops

Cheers

From: Daniel Hanks [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Progress of an index rebuild
Date: Tue, 06 Jan 2004 09:49:25 -0800
Is there any way to check on the progress of an index rebuild? (Oracle 8i). 
I.e., it would be nice to get some indicator as to how far an index rebuild 
has gone, something like 75% done

As a rough indicator, I've noticed when rebuilding/moving an index to a 
different tablespace, Oracle will allocate temporary extents in the 
tablespace to which the index is being moved. So, in theory, I suppose I 
could see how big (in terms of extents) the index is before moving it and 
use that as a rough indicator to see how far along the rebuild is by 
counting the number of temporary extents allocated in the new tablespace 
(taking into account the extent size in the new tablespace).

Are there better ways to see the progress of an index rebuild?

Thanks for any help.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Hanks
  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).
_
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger

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