date:20030531

Jared,

It's rather simple.  If you follow the rules of third normal form you have a 
table with a certain number of rows, a second with a certain number of rows for each 
row in the first table.  Obviously the second table needs more space than the first.  
Now if you use Dictionary management you can set the storage parameters of each table 
individually.  But if your using local management they both have the same extent 
sizes.  This leads one to having the extent sizes smaller to accommodate the first 
table and large numbers of extents for the second table.  True fragmentation, namely 
those small useless extents that land between larger used extents, is eliminated in 
local management but then I have not had those problems with dictionary management 
either, unless someone makes the case for moving a table but that's very rare.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, May 29, 2003 8:25 PM
To: [EMAIL PROTECTED]
Cc: Goulet, Dick
Importance: High


Dick,

I'm trying to follow your line of thought, but I think I missed the path.

Objects may not have the same storage requirements, but what does that 
matter?

The only way I can make sense of what you say is if trying to have all 
objects
occupy a single extent, and there's not much point in that.

Jared






Goulet, Dick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/29/2003 03:51 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Tablespace management.


Thomas,

 With the exception of temp and rollback tablespaces I 
have not user locally managed tablespaces just because all objects must 
have the same sized extents.  I do not see most tables sharing an equal 
need for storage and using dictionary management allows one to do that, at 
a cost I'll admit, but one that is much easier to swallow.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, May 29, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L



After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
the options for tablespace management.  Does anyone have any bad
experiences with these?  AUTOALLOCATE seems to come up with extents that
are much smaller than I want and MANUAL segment management requires the 
use
of FREELISTs (and I know that there are problems with freelists freeing up
space correctly, especially in a parallel environment).

I can't find any basis for making a decision between UNDO and ROLLBACK
SEGMENTS.  Does anyone have any experience or recommendations about UNDO
usage?

The database will be a materialize view replication of a transaction 
master
that is being used for decision support and has a 15 minute update/refresh
cycle.  Basically, people can run queries against the snapshot without
impacting the master.


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




-- 
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: Parallel Query Server died

2003-05-31 Thread Mladen Gogala

Look for the files named somehing like ora_p00*.trc in your BACKGROUND_DUMP_DEST
directory. If the errors are ora-0600 or ora-7445, contact oracle support. The most
likely thing that is happening is that parallel query servers are running out of 
stack. May be you should decrease sort/hash area size?
On 2003.05.30 07:04 shuan.tay28PCI?29 wrote:
 
 
  hai
  Cause:The PMON process is cleaning up the process because a parallel query
  server terminated unexpectedly.
 
 
  Action:Check for operating system errors and retry the statement. If this
  problem persists, contact customer support.
 
 
  may not be the 100% solution please check
 
 
  manjunath
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author:
INET: [EMAIL PROTECTED]
 
 
 Dear all DBAs,
 
 I've already checked the solution by issuing oerr.
 It only suggest to check the system for anomalies and reissue the statement.
 but, mm...what statement? the SQL statement?
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?=
   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: Function Based Index - Not Used ???

2003-05-31 Thread Prem Khanna J

Tim,

First, i would like to thank U a million.
It was a real GOOD explanation.
I don't know why should you apologize for helping me.
I should be thankful to u for helping me in time.

GREAT to have guys like u in this list.
Knowing is GOOD.
but making others know it , is GREAT.

thanx for your effortsthat u took to make me understand.

once again.THANX THANX  THANX TIM.

With lots of Regards,
Jp.

2003/05/30 14:29:41, Tim Gorman [EMAIL PROTECTED] wrote:

JP,

I apologize in advance for the long email, but I think you'll find it
rewarding to read it all the way through...
.
.
.
.



-- 
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: unusable indexes.

2003-05-31 Thread Seefelt, Beth


I think the problem is skip_unusable... isn't an init.ora parameter.  At
least it wasn't in earlier versions.  You can set it at session level
'alter session set skip_unusable_indexes...'.  I ended up adding it to a
logon trigger to make it affect all sessions.

HTH.


-Original Message-
Sent: Thursday, May 29, 2003 8:20 PM
To: Multiple recipients of list ORACLE-L


hi
i am trying to figure out how unusable indexes could
help me in certain cases like bulk loading etc. i am
trying to understand how it works.

i created a table with a index and used a query which
used this index.

later i made this index unusable and unless and until 
i make this index non-existent the query always
returns a 1502 error trying to access the table thru
the unusable index when i can see that full table scan
is still an option. the init.ora parameter
skip_unusable..is set up too.

version is 9.2.0.3 on aix 5l.

can someone clarify whether this is how it is supposed
to work or am i missing something .

thanks
sai
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sai Selvaganesan
  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: Seefelt, Beth
  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: 10i

2003-05-31 Thread Farnsworth, Dave

Is that the green button that once pushed makes the database unbreakable?

-Original Message-
Sent: Friday, May 30, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L


who promoted you to traffic cop?  

this is the only way I'm able to hear about the new green gui button.

-Original Message-
Sent: Thursday, May 29, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


OK everyone.  Traffic cop time.  Everyone that is a beta partner for 10i
MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, please.  We as
partners pushed Oracle for these beta programs.  Conversations like this
only hurt the process.

Thank You

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

 -Original Message-
Sent:   Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject:10i

Got my first look at the 10i beta last night. I can't tell you much about it
except to say that looking at some of the new stuff


h

;-)


While I'm certain many of the new features will not work perfectly for
several releases afterwards, they look very cool!

RF
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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 contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Farnsworth, Dave
  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: Parallel Query Server died

2003-05-31 Thread helpdesk . hcl






yes

-- 
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: Need to Log on 2000 users

2003-05-31 Thread QuijadaReina, Julio C










Munish Bajaj,

If you want your OS users to log into your
database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracles
default is OPS$. If your OS user account is JOE. Oracle looks at this account
as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to
create the ORACLE user account that will correspond to your OS account and make
it externally identified. 

As sys do the following:

SQL create user OPS$JOE externally identified;

Bear in mind that if you have and OS group
called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put
in that group ;-- )

Regards,
Julio 

-Original
Message-
From: Munish Bajaj
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, May 30, 2003 2:05 AM
To: Multiple recipients of list
ORACLE-L
Subject: Need to Log on 2000 users

Hi Gurus,

I am facing a problem. I
need to log on 2000 users to my database via dedicated server connection on
Oracle 9iR2 running on Windows 2000 Advanced server. 

Please guide me as to
what all parameters need to be tuned to achieve the same. 

The Server is a single
CPU server with 3G RAM.

I need just to logon
2000 users. This is a load test that I need to perform.

Thanks to all

Regards 
Munish Bajaj

RE: 10i

2003-05-31 Thread Mark Leith

Or, is it the green button next to the text Order Oracle Management
Services on the Oracle website? ;)

-Original Message-
Dave
Sent: 30 May 2003 14:35
To: Multiple recipients of list ORACLE-L


Is that the green button that once pushed makes the database unbreakable?

-Original Message-
Sent: Friday, May 30, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L


who promoted you to traffic cop?

this is the only way I'm able to hear about the new green gui button.

-Original Message-
Sent: Thursday, May 29, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


OK everyone.  Traffic cop time.  Everyone that is a beta partner for 10i
MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, please.  We as
partners pushed Oracle for these beta programs.  Conversations like this
only hurt the process.

Thank You

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

 -Original Message-
Sent:   Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject:10i

Got my first look at the 10i beta last night. I can't tell you much about it
except to say that looking at some of the new stuff


h

;-)


While I'm certain many of the new features will not work perfectly for
several releases afterwards, they look very cool!

RF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  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 contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

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

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

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

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

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

Re: is this DBA's only mailing list? THANKS

2003-05-31 Thread Rodd Holman

Please don't unsubscribe.  There are tons of lurkers like myself who tune in 
to drink from the fount of knowlege that gets poured out here.  The best way 
to learn this stuff is to listen to these gurus in the informal world of this 
list.

Rodd Holman
[EMAIL PROTECTED]

On Friday 30 May 2003 02:19, Naveen Nahata wrote:
 All the very best!

 -Original Message-
 Sent: Friday, May 30, 2003 12:30 PM
 To: Multiple recipients of list ORACLE-L


 Hi

 Thanks to Dave, Naveen , Dennis Williams , Rich for replying and to Maggie
 , rgaffuri , Roy , Mladen for suggesting the ODTUG.
 And thanks to all for encouraging me to =post my questions here, and learn
 from all you gurus.
 BUT, I am not into DBA activities AS YET, and am unable to understand most
 of the things discussed here. Also, I wished to join a list where I could
 also share some of my knowledge in addition to learning from others. Here,
 I find my knowledge is almost nil (in DBA activities).

 Hence, I will join one of the lists suggested by you people, and for now, I
 will be un-subscribing from this list. But, I will try to get to your level
 of knowledge soon, and become a member of this list again
 Wish me all the best :-)

 Thanks
 Ajay


 - Original Message -
 To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 29, 2003 7:09 PM

 Yes, we even let developers use this list.  Heck, if you want to throw out
 a perl question cuz I bet you'll get an answer.

 ;o)

 Dave

 -Original Message-
 Sent: Thursday, May 29, 2003 7:46 AM
 To: Multiple recipients of list ORACLE-L


 HI everyone

 I recently joined the list, and I think it is meant only for DBAs. Is that
 true?
 Also, can anyone suggest any similar mailing list meant for Oracle
 developers (that is those working with SQL, PL/SQL, Forms, Oracle apps,
 etc.) and those who are not DBAs?

 Thanks in advance
 Ajay K. Garg

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  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: Need to Log on 2000 users


Jeremiah,

Where do you get 128Gb?  

For 2000 users that is ~65M per user, which
seems like an excessive estimate.

While I probably wouldn't want to run 2k users
on a single Windows server, I think you could 
do it for test purposes.

Use orastack to reduce the memory per thread to 500k,
set small sort_area_size, etc.  Don't see why not.

Jared


On Friday 30 May 2003 02:14, Jeremiah Wilton wrote:
 You mean 2000 concurrent sessions?  Why do you need to use dedicated
 server?  Normally, you would accomplish this with Shared Server.

 You will need 128Gb of memory for the PGAs alone.  Or you can use
 swap, but get ready to wait.  Even that will probably be so slow that
 the connections may time out, or background thread IPC will time out,
 bringing the instance down.

 This seems like a silly exercise.  Whose idea is it?

 Good luck with all that

 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton

 On Thu, 29 May 2003, Munish Bajaj wrote:
  Hi Gurus,
 
  I am facing a problem. I need to log on 2000 users to my database via
  dedicated server connection on Oracle 9iR2 running on Windows 2000
  Advanced server.
 
  Please guide me as to what all parameters need to be tuned to achieve the
  same.
 
  The Server is a single CPU server with 3G RAM.
 
  I need just to logon 2000 users. This is a load test that I need to
  perform.
 
  Thanks to all
 
  Regards
  Munish Bajaj
-- 
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: Forcing CBO to look at partition ...

2003-05-31 Thread laura pena

These are awesome suggestions .. thanks.

Creating a local index on accounts - I can do this. 
Call_id ='0' it is the number zero and considered a lead row. This row is duped and filled in with a real call_id when a call is placed. Eventually this row with call_id are removed in the archiving processes when the promotion is complete.
Naming convention- I am dealing with leagacy design. So I have no idea why event_id referes to a date datatype
Audit_table - This is an execellent point and if you have any futher insight on my problem I would greatly appreciate the following feedback:
 Iupdated this table tobe a partitioned tableand generated stats. But then queries that joined audit_table with legacytables ran very slow (no stats on legacy tables)compared towhen the audit_table was not partitioned. My suggestion was to analyzed 5% of all tables in the system. Including legacytables, since it is notknown whatother tables the audit_tablejoins with at this time.No time to do this so wekept the tableaudit_table as a standard table.Our move to 9i time frame to do this is by Q3 and we will analyze all tables... 

Many Thanks,
Lizz
Binley Lim [EMAIL PROTECTED] wrote:




Analyzing stats would be the first thing to try, but I suspect the non-elimination is the way the SQL is written. 

Assuming you did not miss any brackets around the "or call_id", the "or" part of the statement wouldcause a visit to all partitions. Re-write the "or" section as a join so the CBO will see the calldate as an elimination column. Either eliminate the "in" altogether, or if you cannot do that due to one-to-many causing duplicate rows, at least join within the "in" (...).

Your sub-hash column customerinfoId played no part in the query at all. Is it required for other queries? Otherwise, it would be better to include spare7 (interesting choice of column name), or verified, or even both as sub-hash column(s). As long as they are not too skewed.

How selective is account_no? If you have an index on this column, access could be a lot faster, as long as it is selective and not too skewed.

call_id '0' ? Is it a number or varchar2? If you are in a habit of including this in all your queries -- why load the row in the first place? Look at putting them in a different table for exception reporting.

Is audit_table partitioned? You can possibly get further benefits with partitioning. And why is "event_id" a DATE datatype? Typo?

Is the match to audit_table a common requirement? If so, time for a redesign -- look as flattening both tables into one, thus avoiding the join at query time altogether. Trade-off between space and time. There has been a lot of info regarding performance analysis and diagnosis floating around, but nothing can compensate for "inappropriate" design in the first place.

- Original Message - 
From: Arup Nanda 
To: Multiple recipients of list ORACLE-L 
Sent: Friday, May 30, 2003 10:52 AM
Subject: Re: Forcing CBO to look at partition ...


Why not just use the syntaxselect* from customerinfo partition (the_part_name)?

Much better solution, though, is to gather stats of 1% estimate and do the query. The partition elimination will automatically kick in.

Arup Nanda
www.proligence.com

- Original Message - 
From: laura pena 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, May 29, 2003 6:10 PM
Subject: Forcing CBO to look at partition ...

Hey I currently do not have stats loaded and have a composite partition table corralated with a legacy table. I am wondering if I can force the CBO to use a specific partitions index and hash via a hint.

Is this possible? (partitioned by calldate and hashed by customerinfoId)

Many Thanks,
-Lizz

Here is my sql:
select* from customerinfowhere calldate between TO_DATE('2003-05-21 00:00:00','-MM-DD HH24:MI:SS')+ 10/24 and TO_DATE('2003-05-22 00:00:00','-MM-DD HH24:MI:SS')+ 10/24 and Spare7 = '20' and verified = 'Y' and account_no ='864239913' and call_id  '0' or call_id in ( select call_id from voicelog.audit_table WHERE audit_table.event_type = 3 and event_id between TO_DATE('2003-05-21 00:00:00','-MM-DD HH24:MI:SS')+ 10/24 and TO_DATE('2003-05-22 00:00:00','-MM-DD HH24:MI:SS')+ 10/24 and call_id in (&!
amp;! nbsp; select call_id from customerinfo where calldate between TO_DATE('2003-05-21 00:00:00','-MM-H24:MI:SS') and TO_DATE('2003-05-22 00:00:00','-MM-DD HH24:MI:SS') and Spare7 = '20' and verified = 'Y' and account_no ='864239913' and call_id  '0' ) )/


Do you Yahoo!?Free online calendar with sync to Outlook(TM).
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

RE: 10i

Title: RE: 10i





[ Press Big Green Button ]


sqlplus /nolog
sql connect / as sysdba
connected
sql alter system 'immediate big green button, level push';
Button Pushed.
Connecting to internet  www.bgb.oracle.internal.com/action="">
Connected and data pushed to the server.
Disconnected.


Your activity has been reported to Oracle-Big-Green-Button SWAT Team, someone will be visiting you shortly.


sql exit



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-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 30, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 10i



Is that the green button that once pushed makes the database unbreakable?



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

Need Help for 9i OCP

2003-05-31 Thread Senthil Kumar D

Hi Group,

I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).

Expecting ur help.

Thanx For All,
Senthil.

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

OT Googles cluster architecture

2003-05-31 Thread Bob Metelsky

This is off topic as far as oracle goes, however we are all interested
in storing and querying data. Here is a pdf on how Google is doing it.
Apparently they are using 15000 comodity class pcs in cluster
architecture.

It dosnt look like they are using Oracle, but seems to be a file based
system.(index.shards)
Pretty interesting stuff.

Have a good weekend all!

http://www.computer.org/micro/mi2003/m2022.pdf


Amenable to extensive parallelization, google's web search
application lets different queries run on different processors and,
by partitioning the overall index, also lets a single query use
multiple processors. to handle this workload, google's
architecture features clusters of more than 15,000 commodity-class
pcs with fault-tolerant software. this architecture achieves
superior performance at a fraction of the cost of a system built
from fewer, but more expensive, high-end servers.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  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: is this DBA's only mailing list? THANKS

Title: RE: is this DBA's only mailing list? THANKS

Ajay,

So, (using your words), if your knowledge is nil, wouldn't it be nice idea to _start_ learning?

Granted there are more questions related to database server compared to Oracle Forms/Reports on this list, but trust me, there are some plsq/ and sql wiz-kids(?) here that you will be hard-pressed to find anywhere.

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 !

[EMAIL PROTECTED]

On Friday 30 May 2003 02:19, Naveen Nahata wrote:
All the very best!

-Original Message-
Sent: Friday, May 30, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L

Thanks to Dave, Naveen , Dennis Williams , Rich for replying and to Maggie
, rgaffuri , Roy , Mladen for suggesting the ODTUG.
And thanks to all for encouraging me to =post my questions here, and learn
from all you gurus.
BUT, I am not into DBA activities AS YET, and am unable to understand most
of the things discussed here. Also, I wished to join a list where I could
also share some of my knowledge in addition to learning from others. Here,
I find my knowledge is almost nil (in DBA activities).

Hence, I will join one of the lists suggested by you people, and for now, I
will be un-subscribing from this list. But, I will try to get to your level
of knowledge soon, and become a member of this list again
Wish me all the best :-)

Thanks
Ajay

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

Re: Tablespace management.

2003-05-31 Thread Richard Foote

Hi Dick,

What do you consider to be a large number of extents in a LMT ? At what
point do you consider performance and manageability to be such that you sigh
gee, I wish I had fewer extents ? What do you consider to be the ideal
number of extents for a segment in a DMT vs. LMT that makes DMT so desirable
?

I'm really really curious.

BTW, I think 10i has some bad news in store for you ...

Cheers ;)

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 11:49 PM


 Jared,

 It's rather simple.  If you follow the rules of third normal form you have
a table with a certain number of rows, a second with a certain number of
rows for each row in the first table.  Obviously the second table needs more
space than the first.  Now if you use Dictionary management you can set the
storage parameters of each table individually.  But if your using local
management they both have the same extent sizes.  This leads one to having
the extent sizes smaller to accommodate the first table and large numbers of
extents for the second table.  True fragmentation, namely those small
useless extents that land between larger used extents, is eliminated in
local management but then I have not had those problems with dictionary
management either, unless someone makes the case for moving a table but
that's very rare.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 8:25 PM
 To: [EMAIL PROTECTED]
 Cc: Goulet, Dick
 Importance: High


 Dick,

 I'm trying to follow your line of thought, but I think I missed the path.

 Objects may not have the same storage requirements, but what does that
 matter?

 The only way I can make sense of what you say is if trying to have all
 objects
 occupy a single extent, and there's not much point in that.

 Jared






 Goulet, Dick [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  05/29/2003 03:51 PM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
 cc:
 Subject:RE: Tablespace management.


 Thomas,

  With the exception of temp and rollback tablespaces I
 have not user locally managed tablespaces just because all objects must
 have the same sized extents.  I do not see most tables sharing an equal
 need for storage and using dictionary management allows one to do that, at
 a cost I'll admit, but one that is much easier to swallow.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 3:25 PM
 To: Multiple recipients of list ORACLE-L



 After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
 the options for tablespace management.  Does anyone have any bad
 experiences with these?  AUTOALLOCATE seems to come up with extents that
 are much smaller than I want and MANUAL segment management requires the
 use
 of FREELISTs (and I know that there are problems with freelists freeing up
 space correctly, especially in a parallel environment).

 I can't find any basis for making a decision between UNDO and ROLLBACK
 SEGMENTS.  Does anyone have any experience or recommendations about UNDO
 usage?

 The database will be a materialize view replication of a transaction
 master
 that is being used for decision support and has a 15 minute update/refresh
 cycle.  Basically, people can run queries against the snapshot without
 impacting the master.


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




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

 Fat City Network Services--

Re: Oracle Data Backup


Santosh,

First off, you can make a file level backup of the directories
in the following 2 situations:

1)  your database is shutdown.  Be sure to backup *all* directories
where your datafiles are located.

2) use a hot backup script. There are lots of these available.
Check www.orafaq.com, there are some there.

You may want to learn about RMAN oracle's backup and recovery 
manager.  The following links will help:

These links require metalink access.

Oracle Backup and Recovery: http://tinyurl.com/d1p8
Oracle RMAN :http://tinyurl.com/d1pc

This link requires free OTN registration.
RMAN Manual: http://tinyurl.com/d1pk


Get Robert Freeman's book on Oracle RMAN:

You can find it at amazon.com


Jared


On Friday 30 May 2003 05:25, Santosh Varma wrote:
 Hello list,

  I am using Oracle 8.1.6 I want to take Back-Up of Application Data
 at the end of the Day.
 Which is the best suitable option for backup? any directory (for eg:
 c:\oracle\ora81\rdbms) where from i can take it directly ? like in unix we
 have directory where all the tables/indexes are located and we need to give
 that path for backup and the tables/indexes/data are backed Up.

 Ideas are welcome URGENTLY

 Thanks and regards,
 Santosh





 ---
- 


Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
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[2]: SQL Loader Concatenate date and time

2003-05-31 Thread Jonathan Gennick

Thursday, May 29, 2003, 6:00:49 PM, Bob wrote:
BM Thanks for answering my question. I diddnt realise you could
BM querry colums ahead of the current line.

As I recall, it took me a long time to realize that too.
It may help to realize that everything you type between
double-quotes (those SQL expressions) are made part of the
INSERT statement SQL*Loader uses to insert each row. By the
time that INSERT gets executed, SQL*Loader has to have
parsed the input record and isolated all the fields. Thus,
in a SQL expression, you have access to all the fields all
the time.

Related to the above, before Oracle9i, using SQL expressions
with SQL*Loader precludes doing a direct-path load. 9i
relaxed that restriction somewhat. It's been awhile though,
since I've looked at exactly what 9i allows.

You can see your SQL expressions in the INSERT statement.
Just enable SQL tracing while you run one of your loads.

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: Tablespace management.

Richard,

My troubles come mainly form PeopleSoft and some in-house created 
applications.  I'll use the in-house applications as the example since their simpler.

Our CIM system has tables that contain very few rows of data, like the 
identification information for each robot(CELLS).  Now there are only 30 robots on the 
longest/most complex line we have (BTW: due to the duhvelopers of this application 
each line needs it's own instance on it's own server, don't ask why).  Now this table 
NEVER grows beyond 512KB is size.  But each robot can have up to 1024 component slots 
(512 on each side) that need to be defined with what is in them (SLOTS).  This table 
easily gets into a couple of MB but then sits there since we do tons of updates but no 
more inserts.  If we're doing LMT's then to optimize the storage on this mess I either 
need 2 tablespace or else set the uniform extent size to 512K and allow the SLOTS 
table to have several extents.

This example is one of the simpler ones, there are a lot more that get even 
more problematic, like those for our test data.  If 10i has bad news on this front it 
may well become the straw that breaks the camel's back for Oracle around here.  
We're already toying around with DB2.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, May 30, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L


Hi Dick,

What do you consider to be a large number of extents in a LMT ? At what
point do you consider performance and manageability to be such that you sigh
gee, I wish I had fewer extents ? What do you consider to be the ideal
number of extents for a segment in a DMT vs. LMT that makes DMT so desirable
?

I'm really really curious.

BTW, I think 10i has some bad news in store for you ...

Cheers ;)

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 11:49 PM


 Jared,

 It's rather simple.  If you follow the rules of third normal form you have
a table with a certain number of rows, a second with a certain number of
rows for each row in the first table.  Obviously the second table needs more
space than the first.  Now if you use Dictionary management you can set the
storage parameters of each table individually.  But if your using local
management they both have the same extent sizes.  This leads one to having
the extent sizes smaller to accommodate the first table and large numbers of
extents for the second table.  True fragmentation, namely those small
useless extents that land between larger used extents, is eliminated in
local management but then I have not had those problems with dictionary
management either, unless someone makes the case for moving a table but
that's very rare.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 8:25 PM
 To: [EMAIL PROTECTED]
 Cc: Goulet, Dick
 Importance: High


 Dick,

 I'm trying to follow your line of thought, but I think I missed the path.

 Objects may not have the same storage requirements, but what does that
 matter?

 The only way I can make sense of what you say is if trying to have all
 objects
 occupy a single extent, and there's not much point in that.

 Jared






 Goulet, Dick [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  05/29/2003 03:51 PM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
 cc:
 Subject:RE: Tablespace management.


 Thomas,

  With the exception of temp and rollback tablespaces I
 have not user locally managed tablespaces just because all objects must
 have the same sized extents.  I do not see most tables sharing an equal
 need for storage and using dictionary management allows one to do that, at
 a cost I'll admit, but one that is much easier to swallow.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 3:25 PM
 To: Multiple recipients of list ORACLE-L



 After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
 the options for tablespace management.  Does anyone have any bad
 experiences with these?  AUTOALLOCATE seems to come up with extents that
 are much smaller than I want and MANUAL segment management requires the
 use
 of FREELISTs (and I know that there are problems with freelists freeing up
 space correctly, especially in a parallel environment).

 I can't find any basis for making a decision between UNDO and ROLLBACK
 SEGMENTS.  Does anyone have any experience or recommendations about UNDO
 usage?

 The database will be a materialize view replication of a transaction
 master
 that is being used for decision support and has a 15 minute update/refresh
 cycle.  Basically, people can run queries against the snapshot without
 impacting the master.


 --
 Please see the official ORACLE-L FAQ:

RE: unusable indexes.

2003-05-31 Thread Kirtikumar Deshpande

Doh!!  
The problem is whether there is statistics on the table or not. 
It's that RBO/CBO issue. 
This feature (skip unusable indexes) needs stats. 

To confirm it, I ran the following test on AIX 4.3.3 (should get same results on AIX 
5L) 

Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

SQL create table t1 as (select * from dba_tables);
Table created.
SQL create index t1_ndx on t1 ( owner, table_name );
Index created.
SQL set autotrace on
SQL select owner, table_name from t1 where owner = 'DBM' and table_name like 
'DBM_CUST%';

OWNER  TABLE_NAME
-- --
DBMDBM_CUSTOMERS

Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE
   10   INDEX (RANGE SCAN) OF 'T1_NDX' (NON-UNIQUE)

-- Statistics deleted to save e-mail length :)  

-- Table does not have any stats --- 

SQL alter index t1_ndx unusable;
Index altered.
SQL select owner, table_name from t1 where owner = 'DBM' and table_name like 
'DBM_CUST%';
select owner, table_name from t1 where owner = 'DBM' and table_name like 'DBM_CUST%'
*
ERROR at line 1:
ORA-01502: index 'SYSTEM.T1_NDX' or partition of such index is in unusable
state

SQL alter session set skip_unusable_indexes = true;
Session altered.


SQL select owner, table_name from t1 where owner = 'DBM' and table_name like 
'DBM_CUST%';
select owner, table_name from t1 where owner = 'DBM' and table_name like 'DBM_CUST%'
*
ERROR at line 1:
ORA-01502: index 'SYSTEM.T1_NDX' or partition of such index is in unusable
state

-- So, it appears that the feature does not work? 

-- Now, build stats on the table/index -- 
SQL alter index t1_ndx rebuild;
Index altered.
SQL analyze table t1 compute statistics;
Table analyzed.
SQL alter index t1_ndx unusable; 
Index altered.
SQL select owner, table_name from t1 where owner = 'DBM' and table_name like 
'DBM_CUST%';
OWNER  TABLE_NAME
-- --
DBMDBM_CUSTOMERS


Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=3 Card=4 Bytes=76)
   10   TABLE ACCESS (FULL) OF 'T1' (Cost=3 Card=4 Bytes=76)
SQL 

-- Now, Oracle knows that the index is unsable and it used FTS, as expected. 

HTH,

- Kirti 

 -Original Message-
 Sent: Thursday, May 29, 2003 8:20 PM
 To: Multiple recipients of list ORACLE-L
 
 
 hi
 i am trying to figure out how unusable indexes could
 help me in certain cases like bulk loading etc. i am
 trying to understand how it works.
 
 i created a table with a index and used a query which
 used this index.
 
 later i made this index unusable and unless and until 
 i make this index non-existent the query always
 returns a 1502 error trying to access the table thru
 the unusable index when i can see that full table scan
 is still an option. the init.ora parameter
 skip_unusable..is set up too.
 
 version is 9.2.0.3 on aix 5l.
 
 can someone clarify whether this is how it is supposed
 to work or am i missing something .
 
 thanks
 sai


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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).

randomly generate unique key

2003-05-31 Thread Joan Hsieh

Hi List,

Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
which is trunk id. According to the developers, if publish those
sequenced unique key, it will create some problems, since the community
can guess the next sequence # and got unnecessary info associated with
it. Now the question is how to create a random unique key? The idea is
create a function call combine the 3 components (date, time, MAC
address) to generate a random #. Does the date/time (client query system
time)can always be unique or can be duplicated? Does someone has any
idea or experience to generate those randomly unique key?

Any info would be helpful.

Thanks in advance,

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  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: Need Help for 9i OCP

Senthil
   I hope you get a reply. But I have searched for the same and I don't
think anyone will go to the trouble of creating a really good exam, then
giving it away for free. As we discussed yesterday on this list, Couchman is
a good author to use, and even he has a few glitches. But when you are to
the point of arguing with the author, you are ready to pass the exam. Trying
Jared's tiny url suggestion, otherwise go to Amazon and search for Couchman
Oracle9i.
http://tinyurl.com/d1wt

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L


Hi Group,

I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).

Expecting ur help.

Thanx For All,
Senthil.

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

Re: Need to Log on 2000 users

2003-05-31 Thread Richard Foote

As well as using orastack, go a few steps further and tune the SGA to
buggery (make it lean but keen) and set as high a pga_aggregate_target as
possible and you might make it (depending on what the 2000 users are doing
and depending on how many of them are doing what they're doing
concurrently).

As previously suggested, shared servers could be a goer but if dedicated is
a must, consider the above.

Cheers

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 12:54 AM



 Jeremiah,

 Where do you get 128Gb?

 For 2000 users that is ~65M per user, which
 seems like an excessive estimate.

 While I probably wouldn't want to run 2k users
 on a single Windows server, I think you could
 do it for test purposes.

 Use orastack to reduce the memory per thread to 500k,
 set small sort_area_size, etc.  Don't see why not.

 Jared


 On Friday 30 May 2003 02:14, Jeremiah Wilton wrote:
  You mean 2000 concurrent sessions?  Why do you need to use dedicated
  server?  Normally, you would accomplish this with Shared Server.
 
  You will need 128Gb of memory for the PGAs alone.  Or you can use
  swap, but get ready to wait.  Even that will probably be so slow that
  the connections may time out, or background thread IPC will time out,
  bringing the instance down.
 
  This seems like a silly exercise.  Whose idea is it?
 
  Good luck with all that
 
  --
  Jeremiah Wilton
  http://www.speakeasy.net/~jwilton
 
  On Thu, 29 May 2003, Munish Bajaj wrote:
   Hi Gurus,
  
   I am facing a problem. I need to log on 2000 users to my database via
   dedicated server connection on Oracle 9iR2 running on Windows 2000
   Advanced server.
  
   Please guide me as to what all parameters need to be tuned to achieve
the
   same.
  
   The Server is a single CPU server with 3G RAM.
  
   I need just to logon 2000 users. This is a load test that I need to
   perform.
  
   Thanks to all
  
   Regards
   Munish Bajaj
 --
 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).




-- 
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: Online index creation on 9.2

2003-05-31 Thread Stephen Lee


Good old corporate politics here.  So some of this is just fishing to see to
if anyone knows of anything that has changed from 8.1.7.4 to 9.2.0.3 with
online index creation ... OR ... has there been a change made in the
application (unbeknownst to us) that will crash into an online index
creation.  We're pretty sure the app doesn't try to do anything like grab a
table lock ( ... we think ...), but it will certainly try to grab some
reasonable ( ... we think ... ) row locks. There was no particular wait
that was obvious during all the hullabaloo.

When this kind of thing is going on, you try to consult your Ouija board,
examine the tea leaves, and shake the Magic 8 Ball in an attempt to get some
gut feeling about what is going on without knowing exactly what the
application is trying to do.  The gut feeling I got was that whatever the
app was doing to grab some rows was failing -- not just running slow or
waiting, but failing.  So either the app would loop around and try it again,
or the app users were just banging away on some kind of retry button
compounding the problem, and all of this grew into a big nasty snotball
until the index creation was either killed, or got past its info gathering
stage, after which things started working again.

So there is some effort here to determine if there has been some change in
the way 9.2.0.3 does online index creation, or can we say absolutely,
positively it's exactly like 8.1.7.4; thus the problem must be a collision
between the app and the index build; and it always would have been a
collision both now and in the past.  That way, we can focus on what the
collision is and see if we can deal with it.

 -Original Message-
 
 
 I see, you can't find ot the waits because you don't want to ruin the
 performance again on purpose.  That makes sense!
 
 Online index rebuild has been problematic WRT the journal application
 phase (among other problems such as abandoned journal segments after
 cancel or failure) since it was introduced.  On highly transactional
 systems, a variety of waits, mostly library cache related, can occur
 at the end of the index rebuild.  Many more such problems are
 addressed (fixed) in 9.2.0.3 than were in 8.1.7.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  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: Tablespace management.

2003-05-31 Thread Wolfgang Breitling

So what is wrong with having the SLOTS table occupy several hundred 
extents? If it grows to 500MB it will occupy 1000 extents, so what. If it 
were to grow into GB I'd probably make the extents 1MB and swallow the 
wasted .5M in the CELL extent - what is half a meg when you're in the GB.

As for Peoplesoft, I manage Peoplesoft systems as well and I have separated 
the tables into tiny (extent size 16K, tables do not have more than 1 block 
- ~90%-95% of all tables in the system, most of them even empty), small 
(extent size 64K), medium, large, and XXL plus one for the active _TMP, 
_WRK, and _TAO tables, and then the same for the indexes. Works like a 
charm. The only tablespaces I have to worry about are the large and xxl 
table and index tablespaces. Everything else is pretty much static.

At 07:59 AM 5/30/2003 -0800, you wrote:
Richard,

My troubles come mainly form PeopleSoft and some in-house created 
applications.  I'll use the in-house applications as the example since 
their simpler.

Our CIM system has tables that contain very few rows of data, 
like the identification information for each robot(CELLS).  Now there are 
only 30 robots on the longest/most complex line we have (BTW: due to the 
duhvelopers of this application each line needs it's own instance on it's 
own server, don't ask why).  Now this table NEVER grows beyond 512KB is 
size.  But each robot can have up to 1024 component slots (512 on each 
side) that need to be defined with what is in them (SLOTS).  This table 
easily gets into a couple of MB but then sits there since we do tons of 
updates but no more inserts.  If we're doing LMT's then to optimize the 
storage on this mess I either need 2 tablespace or else set the uniform 
extent size to 512K and allow the SLOTS table to have several extents.

This example is one of the simpler ones, there are a lot more 
that get even more problematic, like those for our test data.  If 10i has 
bad news on this front it may well become the straw that breaks the 
camel's back for Oracle around here.  We're already toying around with DB2.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: Need to Log on 2000 users

2003-05-31 Thread QuijadaReina, Julio C

Sorry Munish, I misinterpreted your question. But Jared's suggestion is
a good one. You can use orastack to set parameters to maximize memory
use for your test database. And too, 128Gb sounds like a pretty large
number for 2000 users!

Julio

-Original Message-
Sent: Friday, May 30, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Jeremiah,

Where do you get 128Gb?  

For 2000 users that is ~65M per user, which
seems like an excessive estimate.

While I probably wouldn't want to run 2k users
on a single Windows server, I think you could 
do it for test purposes.

Use orastack to reduce the memory per thread to 500k,
set small sort_area_size, etc.  Don't see why not.

Jared


On Friday 30 May 2003 02:14, Jeremiah Wilton wrote:
 You mean 2000 concurrent sessions?  Why do you need to use dedicated
 server?  Normally, you would accomplish this with Shared Server.

 You will need 128Gb of memory for the PGAs alone.  Or you can use
 swap, but get ready to wait.  Even that will probably be so slow that
 the connections may time out, or background thread IPC will time out,
 bringing the instance down.

 This seems like a silly exercise.  Whose idea is it?

 Good luck with all that

 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton

 On Thu, 29 May 2003, Munish Bajaj wrote:
  Hi Gurus,
 
  I am facing a problem. I need to log on 2000 users to my database
via
  dedicated server connection on Oracle 9iR2 running on Windows 2000
  Advanced server.
 
  Please guide me as to what all parameters need to be tuned to
achieve the
  same.
 
  The Server is a single CPU server with 3G RAM.
 
  I need just to logon 2000 users. This is a load test that I need to
  perform.
 
  Thanks to all
 
  Regards
  Munish Bajaj
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: QuijadaReina, Julio C
  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: Tablespace management.

2003-05-31 Thread Cary Millsap

The whole point of ULMT is that you simply don't need to think about this
stuff anymore. It may not seem comfortable at first if your brain has the
multiple extents are bad circuitry wired into it, but it really shouldn't
matter if you have gazillions of uniformly-sized extents. The test I
described in the prior mail note will reveal the truth.


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

Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedule details...


-Original Message-
Sent: Friday, May 30, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L

Richard,

My troubles come mainly form PeopleSoft and some in-house created
applications.  I'll use the in-house applications as the example since their
simpler.

Our CIM system has tables that contain very few rows of data, like
the identification information for each robot(CELLS).  Now there are only 30
robots on the longest/most complex line we have (BTW: due to the duhvelopers
of this application each line needs it's own instance on it's own server,
don't ask why).  Now this table NEVER grows beyond 512KB is size.  But each
robot can have up to 1024 component slots (512 on each side) that need to be
defined with what is in them (SLOTS).  This table easily gets into a couple
of MB but then sits there since we do tons of updates but no more inserts.
If we're doing LMT's then to optimize the storage on this mess I either need
2 tablespace or else set the uniform extent size to 512K and allow the SLOTS
table to have several extents.

This example is one of the simpler ones, there are a lot more that
get even more problematic, like those for our test data.  If 10i has bad
news on this front it may well become the straw that breaks the camel's
back for Oracle around here.  We're already toying around with DB2.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, May 30, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L


Hi Dick,

What do you consider to be a large number of extents in a LMT ? At what
point do you consider performance and manageability to be such that you sigh
gee, I wish I had fewer extents ? What do you consider to be the ideal
number of extents for a segment in a DMT vs. LMT that makes DMT so desirable
?

I'm really really curious.

BTW, I think 10i has some bad news in store for you ...

Cheers ;)

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 11:49 PM


 Jared,

 It's rather simple.  If you follow the rules of third normal form you have
a table with a certain number of rows, a second with a certain number of
rows for each row in the first table.  Obviously the second table needs more
space than the first.  Now if you use Dictionary management you can set the
storage parameters of each table individually.  But if your using local
management they both have the same extent sizes.  This leads one to having
the extent sizes smaller to accommodate the first table and large numbers of
extents for the second table.  True fragmentation, namely those small
useless extents that land between larger used extents, is eliminated in
local management but then I have not had those problems with dictionary
management either, unless someone makes the case for moving a table but
that's very rare.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 8:25 PM
 To: [EMAIL PROTECTED]
 Cc: Goulet, Dick
 Importance: High


 Dick,

 I'm trying to follow your line of thought, but I think I missed the path.

 Objects may not have the same storage requirements, but what does that
 matter?

 The only way I can make sense of what you say is if trying to have all
 objects
 occupy a single extent, and there's not much point in that.

 Jared






 Goulet, Dick [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  05/29/2003 03:51 PM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
 cc:
 Subject:RE: Tablespace management.


 Thomas,

  With the exception of temp and rollback tablespaces I
 have not user locally managed tablespaces just because all objects must
 have the same sized extents.  I do not see most tables sharing an equal
 need for storage and using dictionary management allows one to do that, at
 a cost I'll admit, but one that is much easier to swallow.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Thursday, May 29, 2003 3:25 PM
 To: Multiple recipients of list ORACLE-L



 After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
 the options for tablespace management.  Does anyone have any bad
 experiences with these?  AUTOALLOCATE seems to come up with extents that
 are much smaller than I want and

SAN configurations for Oracle

Folks,

We're headed into the Storage Area Network(SAN) world and have been hearing 
from two primary vendors, HP and EMC, on how they recommend setting things up.  Now 
without letting the cat out of the bag I'd appreciate hearing how those of you who are 
on either an EMC or HP SAN and running Oracle on HP-UX have things set up and what the 
gotcha's are.  If you want you can reply to me privately which is probably the best 
route so as not to over pollute the list.

Thanks in advance.

Dick Goulet
[EMAIL PROTECTED]
Senior Oracle DBA
Oracle Certified 8i DBA 
-- 
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: Tablespace management.

2003-05-31 Thread Cary Millsap

Wow.

Maybe someone on the list has the time and motive to construct a test to
determine how many extents for a segment in a ULMT are bad. My guess from
some tests we did a couple of years ago is that it will take hundreds of
thousands of extents before even DROP performance will suffer. And I can't
think of *anything* that would make having even hundreds of millions of
extents a bad idea for INSERTs, UPDATEs, MERGEs, or DELETEs. The only
possible downsides of huge numbers of extents that I can think of are
perhaps:

* During the INSERT, UPDATE, or MERGE, what is the overhead of the actual
allocation of the ULMT extent? (This actually may have nothing to do with
how many extents are already there.)

* During checkpoints on RAC systems, does the number of extents matter the
way it did when Jonathan Lewis showed a problem with DMT and OPS a few years
ago?

* Does a huge bitmap section in the head of a data file cause any
performance problems for backup and recovery?

Aside from that, I can't imagine any more downside of huge numbers of ULMT
extents than there is from having the Unix filesystem extents that most of
us have right now and never notice.


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

Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedule details...


-Original Message-
Sent: Friday, May 30, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L

Jared,

It's rather simple.  If you follow the rules of third normal form
you have a table with a certain number of rows, a second with a certain
number of rows for each row in the first table.  Obviously the second table
needs more space than the first.  Now if you use Dictionary management you
can set the storage parameters of each table individually.  But if your
using local management they both have the same extent sizes.  This leads one
to having the extent sizes smaller to accommodate the first table and large
numbers of extents for the second table.  True fragmentation, namely those
small useless extents that land between larger used extents, is eliminated
in local management but then I have not had those problems with dictionary
management either, unless someone makes the case for moving a table but
that's very rare.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, May 29, 2003 8:25 PM
To: [EMAIL PROTECTED]
Cc: Goulet, Dick
Importance: High


Dick,

I'm trying to follow your line of thought, but I think I missed the path.

Objects may not have the same storage requirements, but what does that 
matter?

The only way I can make sense of what you say is if trying to have all 
objects
occupy a single extent, and there's not much point in that.

Jared






Goulet, Dick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/29/2003 03:51 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Tablespace management.


Thomas,

 With the exception of temp and rollback tablespaces I 
have not user locally managed tablespaces just because all objects must 
have the same sized extents.  I do not see most tables sharing an equal 
need for storage and using dictionary management allows one to do that, at 
a cost I'll admit, but one that is much easier to swallow.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, May 29, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L



After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
the options for tablespace management.  Does anyone have any bad
experiences with these?  AUTOALLOCATE seems to come up with extents that
are much smaller than I want and MANUAL segment management requires the 
use
of FREELISTs (and I know that there are problems with freelists freeing up
space correctly, especially in a parallel environment).

I can't find any basis for making a decision between UNDO and ROLLBACK
SEGMENTS.  Does anyone have any experience or recommendations about UNDO
usage?

The database will be a materialize view replication of a transaction 
master
that is being used for decision support and has a 15 minute update/refresh
cycle.  Basically, people can run queries against the snapshot without
impacting the master.


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

RE: Tablespace management.

2003-05-31 Thread Steve Rospo


I think you're missing the point of the last message.  What's wrong with
multiple extents if the extent size is a multiple of a multiblock read?
What's wrong with having two tablespaces?  I'd definitely suggest reading
How to Stop Defragmenting and Start Living: The Definitive Word on
Fragmentation. (http://otn.oracle.com/deploy/availability/pdf/defrag.pdf)
No one is suggesting *everything* should have a single extent size but
everything in a tablespace should.

LMT is the future and dovetails nicely with a lot of the functionality
we've seen added in recent releases.  What good are online table/index
rebuilds if the space reclaimed is far outweighed by the space wasted by
the fragmentation left behind?

S-

On Fri, 30 May 2003, Goulet, Dick wrote:

 Richard,

   My troubles come mainly form PeopleSoft and some in-house created
 applications.  I'll use the in-house applications as the example since
 their simpler.

   Our CIM system has tables that contain very few rows of data, like
 the identification information for each robot(CELLS).  Now there are
 only 30 robots on the longest/most complex line we have (BTW: due to the
 duhvelopers of this application each line needs it's own instance on
 it's own server, don't ask why).  Now this table NEVER grows beyond
 512KB is size.  But each robot can have up to 1024 component slots (512
 on each side) that need to be defined with what is in them (SLOTS).
 This table easily gets into a couple of MB but then sits there since we
 do tons of updates but no more inserts.  If we're doing LMT's then to
 optimize the storage on this mess I either need 2 tablespace or else set
 the uniform extent size to 512K and allow the SLOTS table to have
 several extents.

   This example is one of the simpler ones, there are a lot more that
 get even more problematic, like those for our test data.  If 10i has bad
 news on this front it may well become the straw that breaks the camel's
 back for Oracle around here.  We're already toying around with DB2.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Friday, May 30, 2003 11:30 AM
 To: Multiple recipients of list ORACLE-L


 Hi Dick,

 What do you consider to be a large number of extents in a LMT ? At what
 point do you consider performance and manageability to be such that you sigh
 gee, I wish I had fewer extents ? What do you consider to be the ideal
 number of extents for a segment in a DMT vs. LMT that makes DMT so desirable
 ?

 I'm really really curious.

 BTW, I think 10i has some bad news in store for you ...

 Cheers ;)

 Richard
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, May 30, 2003 11:49 PM


  Jared,
 
  It's rather simple.  If you follow the rules of third normal form you have
 a table with a certain number of rows, a second with a certain number of
 rows for each row in the first table.  Obviously the second table needs more
 space than the first.  Now if you use Dictionary management you can set the
 storage parameters of each table individually.  But if your using local
 management they both have the same extent sizes.  This leads one to having
 the extent sizes smaller to accommodate the first table and large numbers of
 extents for the second table.  True fragmentation, namely those small
 useless extents that land between larger used extents, is eliminated in
 local management but then I have not had those problems with dictionary
 management either, unless someone makes the case for moving a table but
 that's very rare.
 
  Dick Goulet
  Senior Oracle DBA
  Oracle Certified 8i DBA
 
  -Original Message-
  Sent: Thursday, May 29, 2003 8:25 PM
  To: [EMAIL PROTECTED]
  Cc: Goulet, Dick
  Importance: High
 
 
  Dick,
 
  I'm trying to follow your line of thought, but I think I missed the path.
 
  Objects may not have the same storage requirements, but what does that
  matter?
 
  The only way I can make sense of what you say is if trying to have all
  objects
  occupy a single extent, and there's not much point in that.
 
  Jared
 
 
 
 
 
 
  Goulet, Dick [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
   05/29/2003 03:51 PM
   Please respond to ORACLE-L
 
 
  To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
  cc:
  Subject:RE: Tablespace management.
 
 
  Thomas,
 
   With the exception of temp and rollback tablespaces I
  have not user locally managed tablespaces just because all objects must
  have the same sized extents.  I do not see most tables sharing an equal
  need for storage and using dictionary management allows one to do that, at
  a cost I'll admit, but one that is much easier to swallow.
 
  Dick Goulet
  Senior Oracle DBA
  Oracle Certified 8i DBA
 
  -Original Message-
  Sent: Thursday, May 29, 2003 3:25 PM
  To: Multiple recipients of list ORACLE-L
 
 
 
  After reading the documents I've

RE: randomly generate unique key

Title: RE: randomly generate unique key





12:38:08 SQL SELECT SYS_GUID() FROM DUAL; 


SYS_GUID()

BEE5518CD34A8048E033800135428048


12:39:20 SQL 


supposed to be pretty unique ... http://tinyurl.com/d28a


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-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 30, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Subject: randomly generate unique key



Hi List,


Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
which is trunk id. According to the developers, if publish those
sequenced unique key, it will create some problems, since the community
can guess the next sequence # and got unnecessary info associated with
it. Now the question is how to create a random unique key? The idea is
create a function call combine the 3 components (date, time, MAC
address) to generate a random #. Does the date/time (client query system
time)can always be unique or can be duplicated? Does someone has any
idea or experience to generate those randomly unique key?


Any info would be helpful.


Thanks in advance,


Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
 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.*1

Re: RE: Tablespace management.

2003-05-31 Thread rgaffuri

i read some oracle documentation that recommends you keep the number of extents below 
1024.

do you feel that this is inaccurate in an LMT? What if Im stuck with dictionary 
tablespacse and am not allowed to change? Does it matter? I do keep all my extents 
uniform. I thought there were issuse with contention on FET$ and UET$ in dictionary 
managed tablespaces for a transaction database? 

or am I just wrong? 
 
 From: Cary Millsap [EMAIL PROTECTED]
 Date: 2003/05/30 Fri PM 12:55:06 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Tablespace management.
 
 Wow.
 
 Maybe someone on the list has the time and motive to construct a test to
 determine how many extents for a segment in a ULMT are bad. My guess from
 some tests we did a couple of years ago is that it will take hundreds of
 thousands of extents before even DROP performance will suffer. And I can't
 think of *anything* that would make having even hundreds of millions of
 extents a bad idea for INSERTs, UPDATEs, MERGEs, or DELETEs. The only
 possible downsides of huge numbers of extents that I can think of are
 perhaps:
 
 * During the INSERT, UPDATE, or MERGE, what is the overhead of the actual
 allocation of the ULMT extent? (This actually may have nothing to do with
 how many extents are already there.)
 
 * During checkpoints on RAC systems, does the number of extents matter the
 way it did when Jonathan Lewis showed a problem with DMT and OPS a few years
 ago?
 
 * Does a huge bitmap section in the head of a data file cause any
 performance problems for backup and recovery?
 
 Aside from that, I can't imagine any more downside of huge numbers of ULMT
 extents than there is from having the Unix filesystem extents that most of
 us have right now and never notice.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Sent: Friday, May 30, 2003 8:50 AM
 To: Multiple recipients of list ORACLE-L
 
 Jared,
 
   It's rather simple.  If you follow the rules of third normal form
 you have a table with a certain number of rows, a second with a certain
 number of rows for each row in the first table.  Obviously the second table
 needs more space than the first.  Now if you use Dictionary management you
 can set the storage parameters of each table individually.  But if your
 using local management they both have the same extent sizes.  This leads one
 to having the extent sizes smaller to accommodate the first table and large
 numbers of extents for the second table.  True fragmentation, namely those
 small useless extents that land between larger used extents, is eliminated
 in local management but then I have not had those problems with dictionary
 management either, unless someone makes the case for moving a table but
 that's very rare.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 Sent: Thursday, May 29, 2003 8:25 PM
 To: [EMAIL PROTECTED]
 Cc: Goulet, Dick
 Importance: High
 
 
 Dick,
 
 I'm trying to follow your line of thought, but I think I missed the path.
 
 Objects may not have the same storage requirements, but what does that 
 matter?
 
 The only way I can make sense of what you say is if trying to have all 
 objects
 occupy a single extent, and there's not much point in that.
 
 Jared
 
 
 
 
 
 
 Goulet, Dick [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  05/29/2003 03:51 PM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc: 
 Subject:RE: Tablespace management.
 
 
 Thomas,
 
  With the exception of temp and rollback tablespaces I 
 have not user locally managed tablespaces just because all objects must 
 have the same sized extents.  I do not see most tables sharing an equal 
 need for storage and using dictionary management allows one to do that, at 
 a cost I'll admit, but one that is much easier to swallow.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 Sent: Thursday, May 29, 2003 3:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
 the options for tablespace management.  Does anyone have any bad
 experiences with these?  AUTOALLOCATE seems to come up with extents that
 are much smaller than I want and MANUAL segment management requires the 
 use
 of FREELISTs (and I know that there are problems with freelists freeing up
 space correctly, especially in a parallel environment).
 
 I can't find any basis for making a decision between UNDO and ROLLBACK
 SEGMENTS.  Does anyone have any experience or recommendations about UNDO
 usage?
 
 The database will be a materialize view replication of a transaction 
 master
 that is being used for decision support

RE: Tablespace management.

Steve,

I'm not sure I'd call all of the functionality that has been added over the 
years worth it.  Way too many of them have caused more trouble than their worth, like 
descending indexes.  And given the drivel that I've seen from many a third party 
vendor in the past (PeopleSoft and their damned 16K extents) this can certainly get 
turned into another nightmare.  As far as fragmentation is concerned, I've NOT had to 
do any in the last few years, mainly due to spending a lot of time  effort to get 
computing storage needs into an exact science around here.  That has been due to disk 
storage space not being an invisible cost item, but instead a significant one that 
we're constantly battling with.  Sure they've become cheaper, but when our buying GB's 
of the stuff, mirrored, from a reliable vendor those half MB's wasted begin to add up 
FAST.  Therefore I still contend that everything inside a single tablespace does not 
need a uniform extent size.  If one size fits all was absolutely !
true there would be a lot less problems in this world.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, May 30, 2003 1:06 PM
To: Multiple recipients of list ORACLE-L



I think you're missing the point of the last message.  What's wrong with
multiple extents if the extent size is a multiple of a multiblock read?
What's wrong with having two tablespaces?  I'd definitely suggest reading
How to Stop Defragmenting and Start Living: The Definitive Word on
Fragmentation. (http://otn.oracle.com/deploy/availability/pdf/defrag.pdf)
No one is suggesting *everything* should have a single extent size but
everything in a tablespace should.

LMT is the future and dovetails nicely with a lot of the functionality
we've seen added in recent releases.  What good are online table/index
rebuilds if the space reclaimed is far outweighed by the space wasted by
the fragmentation left behind?

S-

On Fri, 30 May 2003, Goulet, Dick wrote:

 Richard,

   My troubles come mainly form PeopleSoft and some in-house created
 applications.  I'll use the in-house applications as the example since
 their simpler.

   Our CIM system has tables that contain very few rows of data, like
 the identification information for each robot(CELLS).  Now there are
 only 30 robots on the longest/most complex line we have (BTW: due to the
 duhvelopers of this application each line needs it's own instance on
 it's own server, don't ask why).  Now this table NEVER grows beyond
 512KB is size.  But each robot can have up to 1024 component slots (512
 on each side) that need to be defined with what is in them (SLOTS).
 This table easily gets into a couple of MB but then sits there since we
 do tons of updates but no more inserts.  If we're doing LMT's then to
 optimize the storage on this mess I either need 2 tablespace or else set
 the uniform extent size to 512K and allow the SLOTS table to have
 several extents.

   This example is one of the simpler ones, there are a lot more that
 get even more problematic, like those for our test data.  If 10i has bad
 news on this front it may well become the straw that breaks the camel's
 back for Oracle around here.  We're already toying around with DB2.

 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA

 -Original Message-
 Sent: Friday, May 30, 2003 11:30 AM
 To: Multiple recipients of list ORACLE-L


 Hi Dick,

 What do you consider to be a large number of extents in a LMT ? At what
 point do you consider performance and manageability to be such that you sigh
 gee, I wish I had fewer extents ? What do you consider to be the ideal
 number of extents for a segment in a DMT vs. LMT that makes DMT so desirable
 ?

 I'm really really curious.

 BTW, I think 10i has some bad news in store for you ...

 Cheers ;)

 Richard
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, May 30, 2003 11:49 PM


  Jared,
 
  It's rather simple.  If you follow the rules of third normal form you have
 a table with a certain number of rows, a second with a certain number of
 rows for each row in the first table.  Obviously the second table needs more
 space than the first.  Now if you use Dictionary management you can set the
 storage parameters of each table individually.  But if your using local
 management they both have the same extent sizes.  This leads one to having
 the extent sizes smaller to accommodate the first table and large numbers of
 extents for the second table.  True fragmentation, namely those small
 useless extents that land between larger used extents, is eliminated in
 local management but then I have not had those problems with dictionary
 management either, unless someone makes the case for moving a table but
 that's very rare.
 
  Dick Goulet
  Senior Oracle DBA
  Oracle Certified 8i DBA
 
  -Original Message-
  Sent: Thursday, May 29, 2003 8:25 PM
  To: [EMAIL PROTECTED]
  Cc:

RE: Bulk collect got truncated? RESOLVED

2003-05-31 Thread Gorbounov,Vadim

Bug. 

Has been resolved by 

_table_lookup_prefetch_size=0 
_multi_join_key_table_lookup=FALSE 

credits to Jamadagni, Rajendra.

Thanks a lot for all your help. 
Vadim


-Original Message-
Sent: Wednesday, May 28, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L


Mark, 

No chance I'm running out of memory. I checked max PGA for the session, it
was around 26M after successful execution, what is not something completely
unbareable, and didn't climb up after next executions.

We can probably workaround  this issue, thanks for suggestion.

Regards
Vadim

-Original Message-
Sent: Wednesday, May 28, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L


Is it possible that you are running out memory on the OS?

A different question I have is why bulk collect such a large amount at once.
Why not do a cursor with a limit on the fetch? This would allow you to
process in smaller batches instead of one gigantic fetch and insert.

Mark

-Original Message-
Sent: Wednesday, May 28, 2003 11:07 AM
To: Multiple recipients of list ORACLE-L



Hi dear listers, 

Some of you may still remember this thread, bulk collect truncated to 65535
records sometimes.
I've got this case reproduceable and tried all suggestions , 

In a brief, 
 SELECT returns 318847 rows, 
 INSERT INTO FROM SELECT - 318847 rows, 
 PL/SQL plain FOR cr IN (select ..) LOOP - - 318847 rows
 PL/SQL with BULK COLLECT many different code versions - sometimes  returs
65535 records instead, the rest is truncated

What might be interesting, in case when it fails, it doesn't retrieve
requiered rows from disk. I can judge it by much shorter responce time and
10046 trace doesn't show db file sequential read events what always showup
when number of rows is correct.

10046 trace provides interesting details,  65535 records is approximately
the point (=/- 50 records) where it usually does first db file sequential
read in case of successful execution.

So Waleed, apparently there is a problem here, 9.0.1.4 Solaris. Time to TAR
now.

Below is the spool from my recent session.

Have a good day, 
Vadim

set serveroutput on
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
318847


PL/SQL procedure successfully completed.

Elapsed: 00:00:12.03
SQL alter session set events = '10046 trace name context forever, level 8';

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
65535


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL alter session set events = '10046 trace name context off';

Session altered.

Elapsed: 00:00:00.00
SQL alter session set sql_trace= true;

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
65535


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL alter session set sql_trace= false;

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
65535


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL SELECT /*+ index(p

Re: Parallel Query Server died

2003-05-31 Thread Rajesh . Rao


How about writing an eulogy now for ORA-600 [ 12235 ]: Oracle process has
no purpose in life?



   

Joe Testa  

[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
.comcc:   

Sent by: Subject: Re: Parallel Query Server died   

[EMAIL PROTECTED]  
   
om 

   

   

05/30/2003 

07:24 AM   

Please respond 

to ORACLE-L

   

   





hahaha, that parallel query server was my friend, we knew each other
many cpu cycles, he helped after the loss of another PQS, number 5.

We all knew him from a long time ago when he used to help out others in
doing large queries and sometimes would just hang around after
completing his work for fun. Its a shame he had to go at such a young
age, when the database has only been restarted 20 mins ago. He leaves
behind siblings but no children due to processes being maxed out for
that instance. His parent, oracle binary still lives and hopefully will
be upgraded soon to avoid the unnecessary dying of future parallel query
servers.

May he rest in peace.

Joe

Vladimir Barac wrote:

 *Kool, now some cyber funeral will take place...*

 - Original Message -
 *From:* shuan.tay(PCI¾G¸R³Ô) mailto:[EMAIL PROTECTED]
 *To:* Multiple recipients of list ORACLE-L
 mailto:[EMAIL PROTECTED]
 *Sent:* Friday, May 30, 2003 11:19
 *Subject:* Parallel Query Server died

 Dear all DBAs,
 What should i check for this error?
 ORA-12805: parallel query server died unexpectedly
 The SQL statement was running well before.
 There's nothing in the alert log about this error.
 I'm using Oracle 8.1.6 on Redhat 7.2.
 Thanks and have a nice day.

-- 
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: randomly generate unique key

Joan
Okay, a coworker has experience in this area and provided an education on
this that may benefit me some day. He wants 50% royalty.

 - Add a check digit to your existing number. This will be an easy solution
for you, not requiring much change. The extra digit will foil someone just
trying to create their own number by simply incrementing an existing number.
 - Here is a simple formula for your check digit. You may choose something
simpler or more bulletproof.

Let's say my original number is 123456789.
First, I multiply each digit by a weight. Let's say my weight is 137. So I
multiply each digit as follows:

1  2  3  4  5  6  7  8  9 (original number)
1  3  7  1  3  7  1  3  7 (weight)
1  6 21  4 15 42  7 24 63 (product)

Now, add each of the digits of the product

1+6+2+1+4+1+5+4+2+7+2+4+6+3 = 48

Now we use a mod operation on the result (48). Usually this is 10 or 11. If
we chose mod 10, then our check digit is 8. So our new number is 1234567898.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L


Hi List,

Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
which is trunk id. According to the developers, if publish those
sequenced unique key, it will create some problems, since the community
can guess the next sequence # and got unnecessary info associated with
it. Now the question is how to create a random unique key? The idea is
create a function call combine the 3 components (date, time, MAC
address) to generate a random #. Does the date/time (client query system
time)can always be unique or can be duplicated? Does someone has any
idea or experience to generate those randomly unique key?

Any info would be helpful.

Thanks in advance,

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

RE: randomly generate unique key

2003-05-31 Thread Pardee, Roy E

There's an optional db package called dbms_random that you can use to get
random numbers.  Dig it:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=77326.1

There's also a sql function (in 9i only?) called sys_guid() that returns a
globally unique identifier--big ugly things.  See that at:

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90125/
functions122a.htm#84836

I think I'd try dbms_random first--keep using your sequence, but 'salt' the
actual identifier by concatenating 3 or 4 random digits at the beginning or
end of the sequence value.  That way the sequence will guarantee uniqueness,
but the numbers should not be guessable.  Plus these would be numbers that
human beings can reasonbly be expected to remember--I can't imagine asking
people to remember the GUID I assign them...

HTH,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, May 30, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L


Hi List,

Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
which is trunk id. According to the developers, if publish those
sequenced unique key, it will create some problems, since the community
can guess the next sequence # and got unnecessary info associated with
it. Now the question is how to create a random unique key? The idea is
create a function call combine the 3 components (date, time, MAC
address) to generate a random #. Does the date/time (client query system
time)can always be unique or can be duplicated? Does someone has any
idea or experience to generate those randomly unique key?

Any info would be helpful.

Thanks in advance,

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  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: Pardee, Roy E
  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: Tablespace management.

2003-05-31 Thread Wolfgang Breitling

What Oracle documentation would that be?

At 09:39 AM 5/30/2003 -0800, you wrote:
i read some oracle documentation that recommends you keep the number of 
extents below 1024.

do you feel that this is inaccurate in an LMT? What if Im stuck with 
dictionary tablespacse and am not allowed to change? Does it matter? I do 
keep all my extents uniform. I thought there were issuse with contention 
on FET$ and UET$ in dictionary managed tablespaces for a transaction database?

or am I just wrong?
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: Tablespace management.

2003-05-31 Thread Kirtikumar Deshpande

Additional downside item:

 * Queries against DBA_EXTENTS will take a bit longer to return. 


- Kirti 
 
--- Cary Millsap [EMAIL PROTECTED] wrote:
 Wow.
 
 Maybe someone on the list has the time and motive to construct a test to
 determine how many extents for a segment in a ULMT are bad. My guess from
 some tests we did a couple of years ago is that it will take hundreds of
 thousands of extents before even DROP performance will suffer. And I can't
 think of *anything* that would make having even hundreds of millions of
 extents a bad idea for INSERTs, UPDATEs, MERGEs, or DELETEs. The only
 possible downsides of huge numbers of extents that I can think of are
 perhaps:
 
 * During the INSERT, UPDATE, or MERGE, what is the overhead of the actual
 allocation of the ULMT extent? (This actually may have nothing to do with
 how many extents are already there.)
 
 * During checkpoints on RAC systems, does the number of extents matter the
 way it did when Jonathan Lewis showed a problem with DMT and OPS a few years
 ago?
 
 * Does a huge bitmap section in the head of a data file cause any
 performance problems for backup and recovery?
 
 Aside from that, I can't imagine any more downside of huge numbers of ULMT
 extents than there is from having the Unix filesystem extents that most of
 us have right now and never notice.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Sent: Friday, May 30, 2003 8:50 AM
 To: Multiple recipients of list ORACLE-L
 
 Jared,
 
   It's rather simple.  If you follow the rules of third normal form
 you have a table with a certain number of rows, a second with a certain
 number of rows for each row in the first table.  Obviously the second table
 needs more space than the first.  Now if you use Dictionary management you
 can set the storage parameters of each table individually.  But if your
 using local management they both have the same extent sizes.  This leads one
 to having the extent sizes smaller to accommodate the first table and large
 numbers of extents for the second table.  True fragmentation, namely those
 small useless extents that land between larger used extents, is eliminated
 in local management but then I have not had those problems with dictionary
 management either, unless someone makes the case for moving a table but
 that's very rare.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 Sent: Thursday, May 29, 2003 8:25 PM
 To: [EMAIL PROTECTED]
 Cc: Goulet, Dick
 Importance: High
 
 
 Dick,
 
 I'm trying to follow your line of thought, but I think I missed the path.
 
 Objects may not have the same storage requirements, but what does that 
 matter?
 
 The only way I can make sense of what you say is if trying to have all 
 objects
 occupy a single extent, and there's not much point in that.
 
 Jared
 
 
 
 
 
 
 Goulet, Dick [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  05/29/2003 03:51 PM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc: 
 Subject:RE: Tablespace management.
 
 
 Thomas,
 
  With the exception of temp and rollback tablespaces I 
 have not user locally managed tablespaces just because all objects must 
 have the same sized extents.  I do not see most tables sharing an equal 
 need for storage and using dictionary management allows one to do that, at 
 a cost I'll admit, but one that is much easier to swallow.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 Sent: Thursday, May 29, 2003 3:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
 the options for tablespace management.  Does anyone have any bad
 experiences with these?  AUTOALLOCATE seems to come up with extents that
 are much smaller than I want and MANUAL segment management requires the 
 use
 of FREELISTs (and I know that there are problems with freelists freeing up
 space correctly, especially in a parallel environment).
 
 I can't find any basis for making a decision between UNDO and ROLLBACK
 SEGMENTS.  Does anyone have any experience or recommendations about UNDO
 usage?
 
 The database will be a materialize view replication of a transaction 
 master
 that is being used for decision support and has a 15 minute update/refresh
 cycle.  Basically, people can run queries against the snapshot without
 impacting the master.
 
 
 

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services--

Installing Mysql

2003-05-31 Thread Harvinder Singh

Hi,

We had a project where i have to install mysql on linux. My only experiece so far is 
with oracle on sun/ibm unix.
Can someone point me to document/book/web site that explains mysql/linux combination?


Thanks
--Harvinder

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Harvinder Singh
  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: Bulk collect got truncated? RESOLVED

2003-05-31 Thread Khedr, Waleed

Is it a bug or a feature?

Waleed

-Original Message-
Sent: Friday, May 30, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L


Bug. 

Has been resolved by 

_table_lookup_prefetch_size=0 
_multi_join_key_table_lookup=FALSE 

credits to Jamadagni, Rajendra.

Thanks a lot for all your help. 
Vadim


-Original Message-
Sent: Wednesday, May 28, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L


Mark, 

No chance I'm running out of memory. I checked max PGA for the session, it
was around 26M after successful execution, what is not something completely
unbareable, and didn't climb up after next executions.

We can probably workaround  this issue, thanks for suggestion.

Regards
Vadim

-Original Message-
Sent: Wednesday, May 28, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L


Is it possible that you are running out memory on the OS?

A different question I have is why bulk collect such a large amount at once.
Why not do a cursor with a limit on the fetch? This would allow you to
process in smaller batches instead of one gigantic fetch and insert.

Mark

-Original Message-
Sent: Wednesday, May 28, 2003 11:07 AM
To: Multiple recipients of list ORACLE-L



Hi dear listers, 

Some of you may still remember this thread, bulk collect truncated to 65535
records sometimes.
I've got this case reproduceable and tried all suggestions , 

In a brief, 
 SELECT returns 318847 rows, 
 INSERT INTO FROM SELECT - 318847 rows, 
 PL/SQL plain FOR cr IN (select ..) LOOP - - 318847 rows
 PL/SQL with BULK COLLECT many different code versions - sometimes  returs
65535 records instead, the rest is truncated

What might be interesting, in case when it fails, it doesn't retrieve
requiered rows from disk. I can judge it by much shorter responce time and
10046 trace doesn't show db file sequential read events what always showup
when number of rows is correct.

10046 trace provides interesting details,  65535 records is approximately
the point (=/- 50 records) where it usually does first db file sequential
read in case of successful execution.

So Waleed, apparently there is a problem here, 9.0.1.4 Solaris. Time to TAR
now.

Below is the spool from my recent session.

Have a good day, 
Vadim

set serveroutput on
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
318847


PL/SQL procedure successfully completed.

Elapsed: 00:00:12.03
SQL alter session set events = '10046 trace name context forever, level 8';

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
65535


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL alter session set events = '10046 trace name context off';

Session altered.

Elapsed: 00:00:00.00
SQL alter session set sql_trace= true;

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12 dbms_output.put_line(esubsvcid.count);
 13  end;
 14  /
65535


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL alter session set sql_trace= false;

Session altered.

Elapsed: 00:00:00.00
SQL DECLARE
  2 TYPE t_sub_svc_id IS TABLE OF CBQA4SP.sub_svc.sub_svc_id%TYPE index
by binary_integer;
  3 TYPE t_subsvcext_key IS TABLE OF CBQA4SP.sub_svc_parm.val%TYPE index
by binary_integer;
  4 esubsvcid   t_sub_svc_id;
  5 evalt_subsvcext_key;
  6  BEGIN
  7 SELECT /*+ index(p sub_svc_parm_ix2) */
  8sub_svc_id, val
  9   BULK COLLECT INTO esubsvcid, eval
 10   FROM CBQA4SP.sub_svc_parm p
 11  WHERE parm_id =10;
 12

RE: randomly generate unique key

2003-05-31 Thread Mark Moynahan

One way to get around this issue is to continue to use the sequence and
concatenate some random numbers. The random generated number could look
something like this  sequence.nextval||to_char(sysdate,'DDDS').

Mark 


-Original Message-
Sent: Friday, May 30, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L


Hi List,

Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
which is trunk id. According to the developers, if publish those
sequenced unique key, it will create some problems, since the community
can guess the next sequence # and got unnecessary info associated with
it. Now the question is how to create a random unique key? The idea is
create a function call combine the 3 components (date, time, MAC
address) to generate a random #. Does the date/time (client query system
time)can always be unique or can be duplicated? Does someone has any
idea or experience to generate those randomly unique key?

Any info would be helpful.

Thanks in advance,

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  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: Mark Moynahan
  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: Need to Log on 2000 users

Munish - Don't forget to change the init.ora parameter PROCESSES greater
than 2000. I didn't see where anyone mentioned that.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 4:15 AM
To: Multiple recipients of list ORACLE-L


You mean 2000 concurrent sessions?  Why do you need to use dedicated
server?  Normally, you would accomplish this with Shared Server.

You will need 128Gb of memory for the PGAs alone.  Or you can use
swap, but get ready to wait.  Even that will probably be so slow that
the connections may time out, or background thread IPC will time out,
bringing the instance down.

This seems like a silly exercise.  Whose idea is it?

Good luck with all that

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 29 May 2003, Munish Bajaj wrote:

 Hi Gurus,
 
 I am facing a problem. I need to log on 2000 users to my database via
 dedicated server connection on Oracle 9iR2 running on Windows 2000
Advanced
 server. 
 
 Please guide me as to what all parameters need to be tuned to achieve the
 same. 
 
 The Server is a single CPU server with 3G RAM.
 
 I need just to logon 2000 users. This is a load test that I need to
perform.
 
 Thanks to all
 
 Regards 
 Munish Bajaj 
 
 
 

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

Oradesigner9i ERD Diagrams

2003-05-31 Thread Mercadante, Thomas F

All,

Does anybody know how to, instead of printing ERD diagrams to a printer, to
send the output to an electronic file, preferrably something like a PDF or
HTML format?

I find it pretty amazing that we only have one option here - to print it on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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: use of reverse key index,cost based optimizer

helpdesk
   I don't see where anyone responded. If you look up reverse key index in
the documentation, it says something about if you have a column where most
of the values have leading values that are close. Reverse key will help the
btree of the index be more balanced. That helps on queries. And on inserts
you aren't continually hitting the same block, but spreading the inserts.
   Oracle has two SQL optimizers, rule-based and cost based. The cost based
is more sophisticated. You first populate statistics on your tables. When
creating an execution plan for your SQL the CBO will consider those
statistics. Does that answer your questions?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 1:25 AM
To: Multiple recipients of list ORACLE-L






hai gurus

please tell use of using reverse key index
and what exactly cost based optimizer
 thanks in advance
manjunath

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

performance of sql loader

2003-05-31 Thread rgaffuri

I was talking to some colleagues and they did the following tests. I was wondering if 
anyone else had similiar results or maybe they just didnt do it properly. 

They are using standard SQLLOADER. No direct path inserts and doing some SQL data 
manipulation of the files. They found the following:

1. SQLLOADER with the SQL manipulation is much slower than 
Direct Path SQLLOADER to a staging table, then insert,update, and delete to the master 
table. 

2. As they increased the Array size or the commit size, the performance degradated 
rapidly. 

This sounds odd. Anyone else notice this? Or did they just do something wrong. Dont 
know what they did. They tried it before I started, I just have hearsay to go on. 
Sorry about the lack of details. 

-- 
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: RMAN - Remote vs Local Backups

Walter - This is a common question about RMAN. The Oracle response has been
not a significant amount. I haven't noticed anything, but haven't
specifically tried to measure it. As I mentioned, there are only a few
commands going B - A and some status information going A - B. The actual
backup itself occurs entirely on A. If this is unacceptable, then consider
using the RMAN control file configuration. Then only A is involved. I
wouldn't recommend putting the RMAN catalog on A, because that introduces
vulnerabilities and the reason for moving to RMAN is to reduce
vulnerabilities.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, May 29, 2003 6:05 PM
To: Multiple recipients of list ORACLE-L


In my scenario, target DB to be backed up on box A and rman database/catalog
on Box B, I can run the backup from A or from B no problem. But, what I'm
trying to get at is it better, worse or indifferent to run the backup from
B or A. I would think there is extra network traffic to run the backup
from B.

DENNIS WILLIAMS [EMAIL PROTECTED] wrote: 

Walter - What you describe is the standard RMAN configuration. Box B
contains the RMAN catalog, therefore it must command the backup. And so the
cron job must run on Box B. But the actual backup occurs on the target
machine (A in your example). If you back up to tape, you must have an MML
(Media Management Library). You can also back up to disk (that is what I
do).
Since the actual backup occurs on the target machine, not much network
traffic is involved. RMAN sends some commands, the target sends some status
back, and that is about it.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Thanks Tim, Dennis and Ron for your feedback. I appreciate it.

Let me clarify what I'm seeking! . In my example, I am using a centralized
catalog which is on its own dedicated database/server and backups are to
tape. BCV's are not involved.

Normally, in my experience, RMAN backups are initiated from the target
server via a cron job. But, I've seen a case where a cron job for an RMAN
backup was run from a box that was different from the database server
machine. I find this configuration strange and confusing because it implies
this was done for a reason and makes life difficult to find out where all
the backups are running from.

In the scenario of backing up the database on box A via an rman/cron job on
box B, is this particular configuration more network resource intensive and
therefore slower versus the backup being initiated from the same machine as
the database? If not, could someone explain why?

Does this make sense?

Thanks again.
-w




DENNIS WILLIAMS wrote:
Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think
Oracle viewed RMAN as a high-level feature that would help you manage the
backups for large server farms. They emphasized that the catalog was the way
to go. With the catalog on another box, if the server was toasted, you could
slide another system into that spot and with a couple of RMAN commands you
could have that up and going again. Obviously if you use the catalog method
on the box you are backing up, you must have a second instance, and even
then you introduce more vulnerabilities than the configuration where the
catalog is on another server.
With Oracle9i, Oracle added many of the features that were only
available in the catalog method to the control-file method. According to my
Oracle Education Instructor John Hibbard who is pretty plugged into these
things, Oracle is trying ! to emphasize that the catalog method may not suit
everyone's situation and the c! ontrol file method may best suit your needs.
As others on this list have pointed out, not all conference speakers have
gotten that message.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Hi,

Can anyone think of a reason(s) why one WOULD want to backup a database from
a box other than the database box itself? Are there any advantages to this
kind of configuration?

For example:

Box-A (production db server)
Box-B (rman db server)

A cron job runs on Box-B which backups up the database from Box-A.


Thanks in advance!

-w

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

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

RE: Bulk collect got truncated? RESOLVED

Title: RE: Bulk collect got truncated? RESOLVED





Sorry, can't take the whole credit ... but if you are giving the credit for looking it up first on the Metablick, sure, I'll take it.

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-
From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 30, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulk collect got truncated? RESOLVED



Bug. 


Has been resolved by 


_table_lookup_prefetch_size=0 
_multi_join_key_table_lookup=FALSE 


credits to Jamadagni, Rajendra.


Thanks a lot for all your help. 
Vadim



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

RE: RMAN - Remote vs Local Backups

Jared - Excellent point. My understanding is that the RMAN catalog must run
on an Oracle version equal or greater than the target instances. Has anyone
found this requirement to be a big pain? I am looking to configuring RMAN on
another set of servers, but they are Oracle 9.2 and my current RMAN server
is 8.1.6, and would need an O.S. upgrade to move to 9.2.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, May 29, 2003 8:20 PM
To: Multiple recipients of list ORACLE-L


Dennis,

The cron job can run on B only if it is the same version of Oracle that is 
on A. 

Jared








DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/29/2003 03:14 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: RMAN - Remote vs Local Backups


Walter - What you describe is the standard RMAN configuration. Box B
contains the RMAN catalog, therefore it must command the backup. And so 
the
cron job must run on Box B. But the actual backup occurs on the target
machine (A in your example). If you back up to tape, you must have an MML
(Media Management Library). You can also back up to disk (that is what I
do).
   Since the actual backup occurs on the target machine, not much network
traffic is involved. RMAN sends some commands, the target sends some 
status
back, and that is about it.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Thanks Tim, Dennis and Ron for your feedback. I appreciate it.
 
Let me clarify what I'm seeking. In my example, I am using a centralized
catalog which is on its own dedicated database/server and backups are to
tape. BCV's are not involved.
 
Normally, in my experience, RMAN backups are initiated from the target
server via a cron job. But, I've seen a case where a cron job for an RMAN
backup was run from a box that was different from the database server
machine. I find this configuration strange and confusing because it 
implies
this was done for a reason and makes life difficult to find out where 
all
the backups are running from.
 
In the scenario of backing up the database on box A via an rman/cron job 
on
box B, is this particular configuration more network resource intensive 
and
therefore slower versus the backup being initiated from the same machine 
as
t




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

RE: C++ Issues

Ethan - Is this a technical issue or a licensing issue?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 12:30 AM
To: Multiple recipients of list ORACLE-L


 From the Oracle C++ Call Interface Programmer's Guide Release 2 (9.2):

Oracle C++ Call Interface (OCCI) is an application program interface (API)
that provides C++ applications access to data in an Oracle database. OCCI
enables C++ programmers to utilize the full range of Oracle database
operations, including SQL statement processing and object manipulation.

The Net Services 9.0.1 client included with the Oracle 9i Developer Suite
can still connect to Oracle 7.3.4 databases.

Note: although Oracle 7.3.4 is not supported on Windows 2000, it can
be installed 1st (in default home using a Y2K compliant installer)
then peacefully coexist with later Oracle versions.

Have Fun :)

Post, Ethan wrote:

I am trying to track this down for a buddy, any ideas, I know nothing about
C++.

Thanks,
Ethan

===
=


Our application currently has presentation programs written in Microsoft
Visual C++ that read Oracle Version 7.3.4 databases.  We have Oracle
Professional/2000 installed on 1 machine.  The Pro*C/C++ pre-compiler
provided by Oracle is the method we use to pre-compile our program.  This
pre-compile converts the EXEC SQL commands into C++ calls to incorporate
the
Oracle Database functions into the programs.  Other methods I have found in
research is to use OCI or ODBC calls.  However everything I look at
indicates that we would need to rewrite our applications to utilize
additional include libraries as well as modify our  SQL calls to wrap them
with the appropriate language elements.

We wish to fully utilize the functionality of the Microsoft Visual C++
Professional Edition environment to allow each developer to use their own
machine to compile and unit test these programs.  However, I am unable to
get the pre compile process to work.  Pro C will not run on our machines if
it is not installed.  We get a Incorrect environment variable.  Please
reinstall Pro*C/C++ message version error if we try to run the copy that
is
on the compiler machine from our machine.  However, I can not install it
because Oracle 7.3.4 does not support Windows 2000 and the installation
process abends whenever I try to run it.  

What we are looking for is a method to compile, debug, and unit test using
C++ on our machine without getting rid of Pro*C/C++ and yet utilize each
developer's machine more to remove the load from our compiler machine.
  




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

RE: RE: Tablespace management.

2003-05-31 Thread Jesse, Rich

The How To Stop Defragmenting... paper says it in section 2.1.4.


Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA


 -Original Message-
 From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 30, 2003 1:15 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: RE: Tablespace management.
 
 
 What Oracle documentation would that be?
 
 At 09:39 AM 5/30/2003 -0800, you wrote:
 i read some oracle documentation that recommends you keep 
 the number of 
 extents below 1024.
 
 do you feel that this is inaccurate in an LMT? What if Im stuck with 
 dictionary tablespacse and am not allowed to change? Does it 
 matter? I do 
 keep all my extents uniform. I thought there were issuse 
 with contention 
 on FET$ and UET$ in dictionary managed tablespaces for a 
 transaction database?
 
 or am I just wrong?
 
 Wolfgang Breitling
-- 
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: Installing Mysql

The Linux Database Bible from Hungry Minds inc.  ISBN 0-7645-4641-4 $49.99US

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, May 30, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L


Hi,

We had a project where i have to install mysql on linux. My only experiece so far is 
with oracle on sun/ibm unix.
Can someone point me to document/book/web site that explains mysql/linux combination?


Thanks
--Harvinder

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Harvinder Singh
  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: 10046 tracing in PRO C programs?

2003-05-31 Thread Post, Ethan

I have seen this when I have created a logon trigger which activates trace
but the owner of the trigger did not have ALTER SESSION granted directly to
it (instead it was through a role).  Sessions logging on ended up creating a
trace file but nothing was in it but TRACE DUMP CONTINUED FROM FILE

- Ethan

-Original Message-
Sent: Thursday, May 22, 2003 5:18 PM
To: Multiple recipients of list ORACLE-L


Glenn,

I think the TRACE DUMP CONTINUED FROM FILE message occurs because file is
actually opened by the SET TRACEFILE_IDENTIFIER command, and then
re-opened by the SET EVENTS command. I see this all the time, except that
after the *** line, there's a whole trace file full of stuff.

Please forgive me if the following question seems impertinent (you seem to
well know what you're doing)... Are you sure that in your test situation,
your code actually makes database calls that should show up in your trace
data?

Aside from that, you can try leaving out the SET TRACEFILE_IDENTIFER out and
seeing what happens. This will at least get rid of the TRACE DUMP CONTINUED
FROM FILE message.


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

Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedule details...


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  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: Oradesigner9i ERD Diagrams

2003-05-31 Thread Igor Neyman

I'm not sure specifically about Designer 9i.
But in most ERD tools you could copy the diagram (Edit/SelectAll, then
Edit/Copy), and then paste it let's say into Word.
Then, you could save it in any format you wish.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Mercadante, Thomas F
Sent: Friday, May 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L

All,

Does anybody know how to, instead of printing ERD diagrams to a printer,
to
send the output to an electronic file, preferrably something like a PDF
or
HTML format?

I find it pretty amazing that we only have one option here - to print it
on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  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: Installing Mysql

2003-05-31 Thread Stahlke, Mark

Try the MySQL web site for starters. http://www.mysql.com/documentation/

Cheers,
Mark Stahlke

-Original Message-
Sent: Friday, May 30, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


Hi,

We had a project where i have to install mysql on linux. My only experiece
so far is with oracle on sun/ibm unix.
Can someone point me to document/book/web site that explains mysql/linux
combination?


Thanks
--Harvinder

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Harvinder Singh
  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: Stahlke, Mark
  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: Oradesigner9i ERD Diagrams

2003-05-31 Thread Mercadante, Thomas F

Igor,

thanks, tried that.  it works *some* of the time.  

but for busy diagrams, things get truncated.  I would have to re-draw
everything smaller to get it to fit.

thanks again.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, May 30, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L


I'm not sure specifically about Designer 9i.
But in most ERD tools you could copy the diagram (Edit/SelectAll, then
Edit/Copy), and then paste it let's say into Word.
Then, you could save it in any format you wish.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Mercadante, Thomas F
Sent: Friday, May 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L

All,

Does anybody know how to, instead of printing ERD diagrams to a printer,
to
send the output to an electronic file, preferrably something like a PDF
or
HTML format?

I find it pretty amazing that we only have one option here - to print it
on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  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: Oradesigner9i ERD Diagrams

2003-05-31 Thread Gogala, Mladen

You can always print it to a file and then look at the file 
with Ghostview or Aladdin.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 30, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


All,

Does anybody know how to, instead of printing ERD diagrams to a printer, to
send the output to an electronic file, preferrably something like a PDF or
HTML format?

I find it pretty amazing that we only have one option here - to print it on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  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: Tablespace management.

2003-05-31 Thread Wolfgang Breitling

To quote the paper:

Oracle supports an unlimited number of extents in a segment. The 
performance for DML operations is largely independent
of the number of extents in the segment. However, certain DDL operations 
such as dropping and truncating of segments are
sensitive to the number of extents. Performance measures for these 
operations have shown that a few thousand extents can be
supported by Oracle without a significant impact on performance. A 
reasonable maximum has been determined to be 4096.
The goal of our recommended algorithm is to keep the number of extents 
below 1024 which is well within the range that
Oracle can efficiently handle. When a segment reaches 1024 extents it is a 
candidate to be moved to the next larger extent
size tablespace. The segment does not necessarily have to be moved 
immediately or at all. The segment may be near its peak
steady state size, in which case even if it has a few thousand extents, it 
should be left where it is. It is only the segments which
are growing that have to be targeted and potentially moved to tablespaces 
with larger extents.

A few comments:

- This was written in the days of DMTs, so not everything that is said 
applies to LMTs. The nr of extent stuff certainly does not.

- Event within the confines of DMTs it clearly states that only drop and 
truncate are sensitive to the nr of extents (because of the necessary DML 
to FET$ and UET$).

- And even then, 1024 is not really a limit, just a recommended comfort 
level: The goal of our recommended algorithm is to keep the number of 
extents below 1024 which is well within
 the range that Oracle can efficiently handle and  The segment does not 
necessarily have to be moved immediately or at all

At 11:59 AM 5/30/2003 -0800, you wrote:
The How To Stop Defragmenting... paper says it in section 2.1.4.

Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: Oradesigner9i ERD Diagrams

2003-05-31 Thread Pardee, Roy E

See the below message from the Designer list.

(Also, if you've got acrobat distiller (a windows printer driver that
generates pdf files) consider using that.)

[EMAIL PROTECTED]   

 From: Peter Koletzke 
 Date: Mon, 03 Apr 2000 11:48:17 -0700
 Subject: Re: Publishing Designer ERD's to the Web

Dave,

Yes, this works like a dream regardless of window size. It is not a
screen shot, but a copy of the graphical objects. The resolution is as
good as the format that you save it in. I'm sure it is a similar
mechanism (abeit a manual as opposed to programmatic one) to what
Publisher 2000 used.

David Wendelken wrote:

 Does that work if the whole diagram won't fit into one window at a
readable
 size?

 - Original Message -
 To: Multiple recipients of list ODTUG-DES2K-L 
 Sent: Saturday, April 01, 2000 3:42 PM

  Hi,

  What I did in a project last year was to display the ERD, Edit-Copy it
  to the clipboard, open a new graphics file in Adobe (I think it was
  Photoshop), Paste from the clipboard, and save as a JPG. I then had a
  link on a web page to that JPG file. Really low tech but we only had
  about 8 table diagrams and it didn't take long to do that for the
  entire set even when they were updated. This strategy saved a lot of
  Can you give me a copy of the latest ERD? questions.

  Bill Wheeling wrote:

   All,

   Is there an inexpensive, or free, solution to publishing Designer
ERD's
 to
   the web?  I need a way to distribute the ERD's to people who do not
have
   Designer.  Any ideas?

   TIA

   Bill Wheeling
   PRC, Inc.

   --
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

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

Igor,

thanks, tried that.  it works *some* of the time.  

but for busy diagrams, things get truncated.  I would have to re-draw
everything smaller to get it to fit.

thanks again.

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Friday, May 30, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L

I'm not sure specifically about Designer 9i.
But in most ERD tools you could copy the diagram (Edit/SelectAll, then
Edit/Copy), and then paste it let's say into Word.
Then, you could save it in any format you wish.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]

-Original Message-
Mercadante, Thomas F
Sent: Friday, May 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L

All,

Does anybody know how to, instead of printing ERD diagrams to a printer,
to
send the output to an electronic file, preferrably something like a PDF
or
HTML format?

I find it pretty amazing that we only have one option here - to print it
on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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).

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

RE: Need Help for 9i OCP

2003-05-31 Thread M Rafiq

Dennis,

You are right. Nothing is free if t has a quality. Best option is to buy sts 
question which cosr normally $99 but they also offer sometimes at 25-30% 
discount. Alternately buy Daniels 9i new features comes with test question 
CD. I rather suggest Senthil to buy sts eaxm questions and they worth it.

Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 30 May 2003 07:54:52 -0800
Senthil
   I hope you get a reply. But I have searched for the same and I don't
think anyone will go to the trouble of creating a really good exam, then
giving it away for free. As we discussed yesterday on this list, Couchman is
a good author to use, and even he has a few glitches. But when you are to
the point of arguing with the author, you are ready to pass the exam. Trying
Jared's tiny url suggestion, otherwise go to Amazon and search for Couchman
Oracle9i.
http://tinyurl.com/d1wt
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 30, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
Hi Group,

I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).
Expecting ur help.

Thanx For All,
Senthil.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
  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: 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).
_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

--
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: RMAN - Remote vs Local Backups

2003-05-31 Thread MacGregor, Ian A.

You can initiate backups from any machine.  Here is a cold backup  script to 
illustrate backing up from a database server  connecting to a rman catalog on another 
machine.

#!/bin/sh
ORACLE_HOME=/opt/oracle/dbserver/9.0.1
export ORACLE_HOME
ORACLE_SID=XXX
export ORACLE_SID
NLS_DATE_FORMAT=DD-MON-:HH24:MI:SS
export NLS_DATE_FORMAT
$ORACLE_HOME/bin/rman EOF
connect target /
shutdown immediate
startup mount
connect catalog XX/[EMAIL PROTECTED]
run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=512M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup database;
backup current controlfile;
release channel c1;
}
alter database open;
exit
EOF

-Original Message-
Sent: Thursday, May 29, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L


Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN 
catalog, therefore it must command the backup. And so the cron job must run on Box B. 
But the actual backup occurs on the target machine (A in your example). If you back up 
to tape, you must have an MML (Media Management Library). You can also back up to disk 
(that is what I do).
   Since the actual backup occurs on the target machine, not much network traffic is 
involved. RMAN sends some commands, the target sends some status back, and that is 
about it.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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


Thanks Tim, Dennis and Ron for your feedback. I appreciate it.
 
Let me clarify what I'm seeking. In my example, I am using a centralized catalog which 
is on its own dedicated database/server and backups are to tape. BCV's are not 
involved.
 
Normally, in my experience, RMAN backups are initiated from the target server via a 
cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box 
that was different from the database server machine. I find this configuration strange 
and confusing because it implies this was done for a reason and makes life difficult 
to find out where all the backups are running from.
 
In the scenario of backing up the database on box A via an rman/cron job on box B, is 
this particular configuration more network resource intensive and therefore slower 
versus the backup being initiated from the same machine as the database? If not, could 
someone explain why?
 
Does this make sense?
 
Thanks again.
-w
 
 


DENNIS WILLIAMS [EMAIL PROTECTED] wrote:

Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed 
RMAN as a high-level feature that would help you manage the backups for large server 
farms. They emphasized that the catalog was the way to go. With the catalog on another 
box, if the server was toasted, you could slide another system into that spot and with 
a couple of RMAN commands you could have that up and going again. Obviously if you use 
the catalog method on the box you are backing up, you must have a second instance, and 
even then you introduce more vulnerabilities than the configuration where the catalog 
is on another server. With Oracle9i, Oracle added many of the features that were only 
available in the catalog method to the control-file method. According to my Oracle 
Education Instructor John Hibbard who is pretty plugged into these things, Oracle is 
trying ! to emphasize that the catalog method may not suit everyone's situation and 
the control file method may best suit your need!
s. As
others on this list have pointed out, not all conference speakers have gotten that 
message.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Hi,

Can anyone think of a reason(s) why one WOULD want to backup a database from a box 
other than the database box itself? Are there any advantages to this kind of 
configuration?

For example:

Box-A (production db server)
Box-B (rman db server)

A cron job runs on Box-B which backups up the database from Box-A.


Thanks in advance!

-w

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

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: DENNIS

RE: RE: Tablespace management.

2003-05-31 Thread Jesse, Rich

Wolfgang,

I agree.  I wasn't arguing a point, but merely pointing out a possible
source of the information you had requested.

Have a weekend!  :)


Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA


 -Original Message-
 From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 30, 2003 4:00 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: RE: Tablespace management.
 
 
 To quote the paper:
 
 Oracle supports an unlimited number of extents in a segment. The 
 performance for DML operations is largely independent
 of the number of extents in the segment. However, certain DDL 
 operations 
 such as dropping and truncating of segments are
 sensitive to the number of extents. Performance measures for these 
 operations have shown that a few thousand extents can be
 supported by Oracle without a significant impact on performance. A 
 reasonable maximum has been determined to be 4096.
 The goal of our recommended algorithm is to keep the number 
 of extents 
 below 1024 which is well within the range that
 Oracle can efficiently handle. When a segment reaches 1024 
 extents it is a 
 candidate to be moved to the next larger extent
 size tablespace. The segment does not necessarily have to be moved 
 immediately or at all. The segment may be near its peak
 steady state size, in which case even if it has a few 
 thousand extents, it 
 should be left where it is. It is only the segments which
 are growing that have to be targeted and potentially moved to 
 tablespaces 
 with larger extents.
 
 A few comments:
 
 - This was written in the days of DMTs, so not everything 
 that is said 
 applies to LMTs. The nr of extent stuff certainly does not.
 
 - Event within the confines of DMTs it clearly states that 
 only drop and 
 truncate are sensitive to the nr of extents (because of the 
 necessary DML 
 to FET$ and UET$).
 
 - And even then, 1024 is not really a limit, just a 
 recommended comfort 
 level: The goal of our recommended algorithm is to keep the 
 number of 
 extents below 1024 which is well within
   the range that Oracle can efficiently handle and  The 
 segment does not 
 necessarily have to be moved immediately or at all
 
 At 11:59 AM 5/30/2003 -0800, you wrote:
 The How To Stop Defragmenting... paper says it in section 2.1.4.
 
 
 Rich
 
 Rich JesseSystem/Database Administrator
 [EMAIL PROTECTED]   Quad/Tech International, 
 Sussex, WI USA
 
 Wolfgang Breitling
 
-- 
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: HELP URGENT RMAN FAILS - FILE?????

2003-05-31 Thread Paula_Stankus

Title: RE: HELP URGENT RMAN FAILS - FILE?





Guys,


Running Oracle 8.1.7
RMAN with automated backups - no problem
Wish to recover 
recovered controlfile from backup then issued following:


 
MAN run {execute script alloc_all_tapes; 
 restore database; 
 recover database noredo; 
 execute script rel_all_tapes;} 
 


It failed with:


RMAN-03002: failure during compilation of command 
RMAN-03013: command type: restore 
RMAN-03002: failure during compilation of command 
RMAN-03013: command type: IRESTORE 
RMAN-06026: some targets not found - aborting restore 
RMAN-06023: no backup or copy of datafile 173 found to restore 
 


Yet, when I query the target database mounted and look for 


 1* select file#,ts#,status,name from v$datafile 
SQL i 
 2 where file#=173; 
 
no rows selected 
 


MAKES NO SENSE AT ALL!!! WHERE IS IT COMING FROM WITH FILE#173 - IF THE MOUNTED TARGET DATABASE DOESN'T LIST 173 FROM V$DATAFILE OR V$RECOVER_FILE!!!

RE: HELP URGENT RMAN FAILS - FILE?????

2003-05-31 Thread Paula_Stankus

Title: RE: HELP URGENT RMAN FAILS - FILE?





methinks resync - could I be write? I had taken a tablespace offline and had not resynched with catalog - kind of makes sense.

-Original Message-
From: Stankus, Paula G 
Sent: Friday, May 30, 2003 5:34 PM
To: '[EMAIL PROTECTED]'
Subject: RE: HELP URGENT RMAN FAILS - FILE?



Guys,


Running Oracle 8.1.7
RMAN with automated backups - no problem
Wish to recover 
recovered controlfile from backup then issued following:


 
MAN run {execute script alloc_all_tapes; 
 restore database; 
 recover database noredo; 
 execute script rel_all_tapes;} 
 


It failed with:


RMAN-03002: failure during compilation of command 
RMAN-03013: command type: restore 
RMAN-03002: failure during compilation of command 
RMAN-03013: command type: IRESTORE 
RMAN-06026: some targets not found - aborting restore 
RMAN-06023: no backup or copy of datafile 173 found to restore 
 


Yet, when I query the target database mounted and look for 


 1* select file#,ts#,status,name from v$datafile 
SQL i 
 2 where file#=173; 
 
no rows selected 
 


MAKES NO SENSE AT ALL!!! WHERE IS IT COMING FROM WITH FILE#173 - IF THE MOUNTED TARGET DATABASE DOESN'T LIST 173 FROM V$DATAFILE OR V$RECOVER_FILE!!!

archiving data

2003-05-31 Thread Sai Selvaganesan

hi there is this project that is going on for
archiving old data from oltp system that is older than
12 months and then purging them in the main db.

the tables that are to be archived are with long rows.
they cannot be converted to lobs since this is a third
party application. here is where the problem lies.
oracle support when contacted says either mv to lobs
to make this move easier or use oci ..blah.blah.. to
get this working if you want to remain in longs.

there are some options i have though about:
1. export /import ..but should make this highly
automated since the main db and archival db will be on
different hosts, this will not be monitored and import
has to go thru w/o issues etc.
2. create snapshot - but they dont work with
long..hence not an option.
3. getting sqlldr to work but i think it has that 32k
column size limitation.


so can you please suggest me whetehr there is
something else i can do or option 1 is the best given
the environment. the oracle is 8.1.7.2 on sun 2.8.

thanks
sai
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sai Selvaganesan
  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: archiving data

2003-05-31 Thread Joe Testa

how do you define older than 12 months??

are you using enterprise edition and is it feasible to use 
partitioning?,  if you partition on the field that defines older than 
12 months, its easy enough to drop a partition(or exchange a partition 
with a non-partitioned table, export that and drop it.

joe

Sai Selvaganesan wrote:

hi there is this project that is going on for
archiving old data from oltp system that is older than
12 months and then purging them in the main db.
the tables that are to be archived are with long rows.
they cannot be converted to lobs since this is a third
party application. here is where the problem lies.
oracle support when contacted says either mv to lobs
to make this move easier or use oci ..blah.blah.. to
get this working if you want to remain in longs.
there are some options i have though about:
1. export /import ..but should make this highly
automated since the main db and archival db will be on
different hosts, this will not be monitored and import
has to go thru w/o issues etc.
2. create snapshot - but they dont work with
long..hence not an option.
3. getting sqlldr to work but i think it has that 32k
column size limitation.
so can you please suggest me whetehr there is
something else i can do or option 1 is the best given
the environment. the oracle is 8.1.7.2 on sun 2.8.
thanks
sai
 

--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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: archiving data

2003-05-31 Thread Paula_Stankus

Title: RE: archiving data





I/O failure this week. Productional system restore/verified and backed up - fully operational once I/O subsystem rebuilt in 2.5 hours - required full restore because key datafiles corrupted - system, redos, control. Waiting for I/O took longest didn't see kids all night.

Was supposed to take off today.


Working as technical architect on SQL Server Vital Stats. COTS, project planning, setting up processes for releases and standard forms, data migration/cleansing, QA plan. 

Another test database recovery tonight.


I miss my little boys.


I want to escape.


I want to eat an entire French Silk Pie


-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 30, 2003 7:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: archiving data



how do you define older than 12 months??


are you using enterprise edition and is it feasible to use 
partitioning?, if you partition on the field that defines older than 
12 months, its easy enough to drop a partition(or exchange a partition 
with a non-partitioned table, export that and drop it.


joe



Sai Selvaganesan wrote:


hi there is this project that is going on for
archiving old data from oltp system that is older than
12 months and then purging them in the main db.

the tables that are to be archived are with long rows.
they cannot be converted to lobs since this is a third
party application. here is where the problem lies.
oracle support when contacted says either mv to lobs
to make this move easier or use oci ..blah.blah.. to
get this working if you want to remain in longs.

there are some options i have though about:
1. export /import ..but should make this highly
automated since the main db and archival db will be on
different hosts, this will not be monitored and import
has to go thru w/o issues etc.
2. create snapshot - but they dont work with
long..hence not an option.
3. getting sqlldr to work but i think it has that 32k
column size limitation.


so can you please suggest me whetehr there is
something else i can do or option 1 is the best given
the environment. the oracle is 8.1.7.2 on sun 2.8.

thanks
sai
 



-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
 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: archiving data

2003-05-31 Thread Arup Nanda

For situations like this you have the COPY command of SQL*Plus.

Remember, it's a SQL*Plus comamnd like set, btitle, etc. not a sql command
you can embed inside a pl/sql block. You could create a table similar in
structure to main table and then polulate the data

SQL SET LONG 99
-- this is neededto set the max size of the long data; otherwise it gets
truncated.

COPY FROM SCHEMA_NAME/[EMAIL PROTECTED] -
APPEND HOLDINGTABLE -
USING SELECT * FROM MAINTABLE WHERE DATE_COL  SYSDATE - 12*30

Note the use of hyphens after the lines. SQL*PLus commands are expected to
be in one line. Since I am continuing on to the next, I used the
continuation character hyphen.

This by default commits after all the rows are loaded. You can control the
commit frequency by specifying two parameters

-- sets 100 records per array
SET ARRAYSIZE 100
-- sets a commit to occur after every 200 batches, or 20,000 records
SET COPYCOMMIT 200

This process is fairly simple and can be easily automated using a shell
script. Any error raised by the sql block can be checked.

Hope this helps.

Arup Nanda
www.proligence.com



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 7:04 PM


 hi there is this project that is going on for
 archiving old data from oltp system that is older than
 12 months and then purging them in the main db.

 the tables that are to be archived are with long rows.
 they cannot be converted to lobs since this is a third
 party application. here is where the problem lies.
 oracle support when contacted says either mv to lobs
 to make this move easier or use oci ..blah.blah.. to
 get this working if you want to remain in longs.

 there are some options i have though about:
 1. export /import ..but should make this highly
 automated since the main db and archival db will be on
 different hosts, this will not be monitored and import
 has to go thru w/o issues etc.
 2. create snapshot - but they dont work with
 long..hence not an option.
 3. getting sqlldr to work but i think it has that 32k
 column size limitation.


 so can you please suggest me whetehr there is
 something else i can do or option 1 is the best given
 the environment. the oracle is 8.1.7.2 on sun 2.8.

 thanks
 sai
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Sai Selvaganesan
   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: Arup Nanda
  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: Oradesigner9i ERD Diagrams

Tom,

I've done this in the past by setting up a PostScript printer in windows, 
and sending
the output to a file, then using the file to generate PDF's from 
GhostScript.

HTH

Jared






Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/30/2003 12:04 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oradesigner9i  ERD Diagrams


All,

Does anybody know how to, instead of printing ERD diagrams to a printer, 
to
send the output to an electronic file, preferrably something like a PDF or
HTML format?

I find it pretty amazing that we only have one option here - to print it 
on
paper.

I know somebody figured this out once by installing a print driver that
saved the result to an image file of some kind, but I cant find the
reference for it.

thanks

PS.. I'm using version 9.02

thanks again

Tom Mercadante
Oracle Certified Professional
-- 
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).




-- 
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: Tablespace management.

Personally, I think the issue of tablespace fragmentation has always been 
highly overrated.

I'll use one of our databases as an example.  It's a 3rd party app, and 
has had only a little
maintence on the extent sizes.  When I catch one growing quickly, I will 
increase the next_extent
size.

This was until recently an 8.0.4 database.  I had considered reorging to 
make the extents
more uniform, but only briefly.  I'm going to try and migrate to LMT later 
this year when it
gets upgraded to 9i.

( see numbers below )
Used_bytes is all space consumed by the schema.

Free bytes is all chunks of free space greater than 8m (1024 blocks) in 
size.

Frag_bytes is all chunks of space = 8m, and may or may not get used.

Next_extent are all distinct values for NEXT_EXTENT on tables and
indexes for the schema.  Though there are next_extent sizes less than
8m, I'm not looking at which tablespace they are in and am just making
a blanket assumption that chunks  1024 blocks will not get used.

Even with this extent management free for all, the database has ~30m of
unusable space.  ~30m of unusable space out of 366g is 0.008% wasted 
space.

It's up to the individual DBA  to determine if s/he wants to remove all 
possibilty 
of fragmentation to avoid wasted space.

I just can't see where it's really worth the effort.

As as I'm concerned, the advantage of LMT's is not to reduce 
fragmentation,
cuz frankly, I don't care.  The advantages are avoiding possible 
contention
on the ST latch, ( and that was mostly eliminated with true temporary temp
tablespaces ), and eliminating the huge amount of recursive SQL that is
generated by truncating or dropping an object with many extents.


Jared


  USED_BYTES

 366,830,100,480

1 row selected.


  FREE_BYTES

 110,213,046,272

1 row selected.


  FRAG_BYTES

  29,548,544

 NEXT
EXTENT
--
16,384
40,960
81,920
   163,840
   516,096
   655,360
 1,048,576
 2,088,960
 2,621,440
 3,145,728
 4,194,304
 5,242,880
 6,291,456
10,485,760
12,582,912
15,728,640
18,874,368
20,971,520
26,214,400
31,457,280
41,943,040
52,428,800
62,914,560
83,886,080
94,371,840
   104,857,600
   115,343,360
   241,172,480
   314,572,800

29 rows selected.






Goulet, Dick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/30/2003 10:39 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Tablespace management.


Steve,

 I'm not sure I'd call all of the functionality that has 
been added over the years worth it.  Way too many of them have caused more 
trouble than their worth, like descending indexes.  And given the drivel 
that I've seen from many a third party vendor in the past (PeopleSoft and 
their damned 16K extents) this can certainly get turned into another 
nightmare.  As far as fragmentation is concerned, I've NOT had to do any 
in the last few years, mainly due to spending a lot of time  effort to 
get computing storage needs into an exact science around here.  That has 
been due to disk storage space not being an invisible cost item, but 
instead a significant one that we're constantly battling with.  Sure 
they've become cheaper, but when our buying GB's of the stuff, mirrored, 
from a reliable vendor those half MB's wasted begin to add up FAST. 
Therefore I still contend that everything inside a single tablespace does 
not need a uniform extent size.  If one size fits all was absolutely
  !
true there would be a lot less problems in this world.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, May 30, 2003 1:06 PM
To: Multiple recipients of list ORACLE-L



I think you're missing the point of the last message.  What's wrong with
multiple extents if the extent size is a multiple of a multiblock read?
What's wrong with having two tablespaces?  I'd definitely suggest reading
How to Stop Defragmenting and Start Living: The Definitive Word on
Fragmentation. (http://otn.oracle.com/deploy/availability/pdf/defrag.pdf)
No one is suggesting *everything* should have a single extent size but
everything in a tablespace should.

LMT is the future and dovetails nicely with a lot of the functionality
we've seen added in recent releases.  What good are online table/index
rebuilds if the space reclaimed is far outweighed by the space wasted by
the fragmentation left behind?

S-

On Fri, 30 May 2003, Goulet, Dick wrote:

 Richard,

My troubles come mainly form PeopleSoft and some in-house 
created
 applications.  I'll use the in-house applications as the example since
 their simpler.

Our CIM system has tables that contain very few rows of 
data, like
 the identification information for each robot(CELLS).  Now there are
 only 30

Re: Need to Log on 2000 users

D'oh!

I was thinking 8i.  My mind hasn't really gotten into 9i mode yet.

pga_aggregate_target is indeed the way to allocate PGA memory.

Jared






Richard Foote [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/30/2003 08:54 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: Need to Log on 2000 users


As well as using orastack, go a few steps further and tune the SGA to
buggery (make it lean but keen) and set as high a pga_aggregate_target as
possible and you might make it (depending on what the 2000 users are doing
and depending on how many of them are doing what they're doing
concurrently).

As previously suggested, shared servers could be a goer but if dedicated 
is
a must, consider the above.

Cheers

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 12:54 AM



 Jeremiah,

 Where do you get 128Gb?

 For 2000 users that is ~65M per user, which
 seems like an excessive estimate.

 While I probably wouldn't want to run 2k users
 on a single Windows server, I think you could
 do it for test purposes.

 Use orastack to reduce the memory per thread to 500k,
 set small sort_area_size, etc.  Don't see why not.

 Jared


 On Friday 30 May 2003 02:14, Jeremiah Wilton wrote:
  You mean 2000 concurrent sessions?  Why do you need to use dedicated
  server?  Normally, you would accomplish this with Shared Server.
 
  You will need 128Gb of memory for the PGAs alone.  Or you can use
  swap, but get ready to wait.  Even that will probably be so slow that
  the connections may time out, or background thread IPC will time out,
  bringing the instance down.
 
  This seems like a silly exercise.  Whose idea is it?
 
  Good luck with all that
 
  --
  Jeremiah Wilton
  http://www.speakeasy.net/~jwilton
 
  On Thu, 29 May 2003, Munish Bajaj wrote:
   Hi Gurus,
  
   I am facing a problem. I need to log on 2000 users to my database 
via
   dedicated server connection on Oracle 9iR2 running on Windows 2000
   Advanced server.
  
   Please guide me as to what all parameters need to be tuned to 
achieve
the
   same.
  
   The Server is a single CPU server with 3G RAM.
  
   I need just to logon 2000 users. This is a load test that I need to
   perform.
  
   Thanks to all
  
   Regards
   Munish Bajaj
 --
 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).




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




-- 
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: use of reverse key index,cost based optimizer

Dennis,

My understanding of B*tree is that it is always balanced.  Monotonically 
increasing
keys will create a right hand index, but nonetheless balanced. 

If wrong, I'm sure to be corrected.  :)

Also, I don't believe the reverse key index will help queries any.  I'm 
guessing that under
normal circumstances it would increase the number of index blocks that 
needed to be
cached.

In the case of a range scan, it would definitely not perform as well, and 
increase the likelihood
of a FFS or FTS, depending on the queries normally used in a system.

The primary purpose of these was to reduce block pings on OPS IIRC, which 
would also reduce
block contention on inserts as you said.


Jared








DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 05/30/2003 12:09 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: use of reverse key index,cost based optimizer


helpdesk
   I don't see where anyone responded. If you look up reverse key index in
the documentation, it says something about if you have a column where most
of the values have leading values that are close. Reverse key will help 
the
btree of the index be more balanced. That helps on queries. And on inserts
you aren't continually hitting the same block, but spreading the inserts.
   Oracle has two SQL optimizers, rule-based and cost based. The cost 
based
is more sophisticated. You first populate statistics on your tables. When
creating an execution plan for your SQL the CBO will consider those
statistics. Does that answer your questions?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, May 30, 2003 1:25 AM
To: Multiple recipients of list ORACLE-L






hai gurus

please tell use of using reverse key index
and what exactly cost based optimizer
 thanks in advance
manjunath

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




-- 
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: 10i

Don't worry about the lid being off of 10i.
We will be doing an overview presentation of Oracle 13
this fall at the local user group. :-)

- Babette

-Original Message-
Thomas F
Sent: Friday, May 30, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L


who promoted you to traffic cop?

this is the only way I'm able to hear about the new green gui button.

-Original Message-
Sent: Thursday, May 29, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


OK everyone.  Traffic cop time.  Everyone that is a beta partner for 10i
MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, please.  We as
partners pushed Oracle for these beta programs.  Conversations like this
only hurt the process.

Thank You

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

 -Original Message-
Sent:   Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject:10i

Got my first look at the 10i beta last night. I can't tell you much about it
except to say that looking at some of the new stuff


h

;-)


While I'm certain many of the new features will not work perfectly for
several releases afterwards, they look very cool!

RF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  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 contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babette Turner-Underwood
  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: 10i

2003-05-31 Thread Mladen Gogala

Oracle 13? Probably nicknamed something like Jason is back version?
It would be appropriate to have such a presentation on Friday the 13th.
On 2003.05.30 23:09 Babette Turner-Underwood wrote:
 Don't worry about the lid being off of 10i.
 We will be doing an overview presentation of Oracle 13
 this fall at the local user group. :-)
 
 - Babette
 
 -Original Message-
 Thomas F
 Sent: Friday, May 30, 2003 9:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 who promoted you to traffic cop?
 
 this is the only way I'm able to hear about the new green gui button.
 
 -Original Message-
 Sent: Thursday, May 29, 2003 5:10 PM
 To: Multiple recipients of list ORACLE-L
 
 
 OK everyone.  Traffic cop time.  Everyone that is a beta partner for 10i
 MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, please.  We as
 partners pushed Oracle for these beta programs.  Conversations like this
 only hurt the process.
 
 Thank You
 
 Stephen P. Karniotis
 Product Architect
 Compuware Corporation
 Direct:   (248) 865-4350
 Mobile:   (248) 408-2918
 Email:[EMAIL PROTECTED]
 Web:  www.compuware.com
 
  -Original Message-
 Sent: Thursday, May 29, 2003 11:55 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  10i
 
 Got my first look at the 10i beta last night. I can't tell you much about it
 except to say that looking at some of the new stuff
 
 
 h
 
 ;-)
 
 
 While I'm certain many of the new features will not work perfectly for
 several releases afterwards, they look very cool!
 
 RF
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Freeman Robert - IL
   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 contents of this e-mail are intended for the named addressee only. It
 contains information that may be confidential. Unless you are the named
 addressee or an authorized designee, you may not copy or use it, or disclose
 it to anyone else. If you received it in error please notify us immediately
 and then destroy it.
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Karniotis, Stephen
   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).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Babette Turner-Underwood
   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

RE: Oracle 11i new features




UNLESS 
Oracle decides to skip Oracle 10i and go directly to Oracle 
11i.

They 
did something similar to bring the numbers for Oracle 
Database
and 
Oracle Designer and Oracle Application Servers all up to 9i
(9iDB, 
9iAS, Designer 9i. . . .)

After 
all, they must have introduced enough new features and bugs
to 
skip a number or two?!?!

- 
Babette

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Mark LeithSent: 
  Wednesday, May 28, 2003 8:05 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Oracle 11i new features
  Oracle 11/11i:
  
  http://www.vapourware.com
  
  Oracle Apps 11/11i
  
  http://www.oracle.com/appsnet/content.html
  http://www.oaug.org/
  http://www.appsdba.com
  
  
  HTH
  Mark
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Ajay K. GargSent: 28 
May 2003 11:08To: Multiple recipients of list 
ORACLE-LSubject: Oracle 11i new features
Hi

Can anybody tell me a website where I can know 
about new features in Oracle 11/11i?

Thanks in Advance
Ajay K. 
Garg

RE: Oracle Untested Infuriator

Title: RE: Oracle Untested Infuriator



I 
understand that in Oracle 11i, Oracle OEM will introduce 
a new 
"mauve" button to auto irritate the DBA. 

You 
can set this to be random or regular intervals 
and 
the annoyance levels are configurable ;-)

- 
Babette

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, 
  RajendraSent: Thursday, May 22, 2003 12:32 PMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: Oracle Untested 
  Infuriator
  Ruth, you are right ... but then you still would need the 
  "auto update" functionality introduced in OEM 4.0, to update the bug list on a 
  daily basis.
  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- From: Ruth 
  Gramolini [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, May 22, 2003 10:53 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Untested Infuriator 
  I love it when you think it is your stupidity so you try 
  something 5 times, finally call Support, and they say 
  "Oh, you found the xyz bug! You have to patch 
  xyz to xyza." If it's a known bug, at least put a note on the 
  disk, "don't use this until you have patched it" or 
  something like that. A yellow sticky note would 
  save hours of valuable time!!! 
  End rant, Ruth

RE: OUI: Oracle Untested Infuriator

You might enjoy knowing that OUI is not used
on the mainframe. Just old fashioned JCL and tapes
and CLISTs for Oracle 9.2

BUT for Oracle 10i, there are rumors that Oracle
will provide a CD that will be used for installation
that will use OUI 

And you thought using the XServer stuff on 
UNIX was distracting, We can't mount the CD on
the mainframe directly, will be ftping the whole
thing across and then trying to get it working
on the USS side of the mainframe...

NO, NO, NO, NOoo

- Babette


-Original Message-
Litchfield
Sent: Saturday, May 24, 2003 11:42 AM
To: Multiple recipients of list ORACLE-L


Hi Dennis

If only Oracle were as easy to install as Microsoft products we might be
getting somewhere. (Of course UNinstalling MS products is problematic -
I don't think Bill can conceive that one would wish to). OUI is not
nearly as easy and straightforward to use as the MS installer. 

Niall 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 DENNIS WILLIAMS
 Sent: 23 May 2003 20:22
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OUI: Oracle Untested Infuriator
 
 
 Dick
In order to sell to a lot of sites, Oracle must be as 
 user-friendly to install as Microsoft products are. I totally 
 agree that doesn't seem fair, but I don't think Oracle can 
 change that rule. The future will be controlled by people 
 that think you must have a mouse to control a computer.
 
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 
 -Original Message-
 Sent: Friday, May 23, 2003 12:17 PM
 To: Multiple recipients of list ORACLE-L
 
 
 My only gripe about OUI is: Why did they spend soo much on a 
 tool we use soo seldomly and why did they have to make it so 
 that I have to have an Xterminal or emulator.  The old 
 character based one was just jim dandy  it worked fine 
 especially from home.  (OK, so I have 2 gripes).
  
 Dick Goulet
 
   -Original Message- 
   From: Vladimir Barac [mailto:[EMAIL PROTECTED] 
   Sent: Fri 5/23/2003 5:06 AM 
   To: Multiple recipients of list ORACLE-L 
   Cc: 
   Subject: Re: OUI: Oracle Untested Infuriator
   
   
 
   Ok, we all agree about OUI... but, real questions are:
   
   Why does oracle insist on such crappy product? WHO is 
 making such stupid
   decisions within Oracle? After all, making installer 
 work is not rocket
   science at all?
   
   Another rant... pointless, of course...
   
   Beside OUI, why did they port OEM to java? I have 
 fairly good PC (512MB RAM,
   733MHx PIII, fast HD, etc. etc.) but oem works slooow, 
 to slow. I rememebr
   OEM in Oracle 8.0.5 that was VC++ app, and it rocked.
   
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Vladimir Barac
 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).
 -- 
 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).
 

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

Re: performance of sql loader

On Friday 30 May 2003 12:20, [EMAIL PROTECTED] wrote:
 1. SQLLOADER with the SQL manipulation is much slower than
 Direct Path SQLLOADER to a staging table, then insert,update, and delete to
 the master table.

Sounds about right.  It's been awhile since making heavy use
of SQL Loader, but DIRECT is very fast.  Not surprising that 
manipulation could be done after loading a temp table and still
be faster than normal SQL Loader.


 2. As they increased the Array size or the commit size, the performance
 degradated rapidly.

 This sounds odd. Anyone else notice this? Or did they just do something
 wrong. Dont know what they did. They tried it before I started, I just have
 hearsay to go on. Sorry about the lack of details.

Not enough information.  Increased from what?  To what?  If you
increase the array size enough to start swapping, it may have
a negative impact on performance.  ;)

Jared
-- 
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: RMAN - Remote vs Local Backups