Re: Suggestions Needed: Latch free - library cache

[Murali Vallath]

Rachel,

I think we had a similar situation in my previous life, when we had to get the programmers to modify their code to trace specific areas of the application. The way we went about doing this (in this case they had a concept of using a catalog.xml file where all the SQL queries got stored and the Java called specific queries identified by TAGS) is define the 10046 event in the catalog and called the on off routines using specific TAG's to trace.



query name="traceTurnOn"
sql![CDATA[ 
alter session set events '10046 trace name context forever, level 12'
]]/sql
/query

query name="traceTurnOff"
sql![CDATA[ 
alter session set events '10046 trace name context off'
]]/sql
/query
Java code snippet to invoke the trace queries:
stmt.executeUpdate(sql);
where sql is the 'traceTurnOn' or 'traceTurnOff' queries retrieved from the catalog,xml file mentioned earlier.
Rachel Carmichael [EMAIL PROTECTED] wrote:
Having worked in an environment where every user was a distinct nameduser, and I therefore could (and at points did) have something 1700distinct connections (yes, I said one thousand seven hundred).I like connection pooling. It limits the stress on the database,because the number of sessions is limited to the maximum of theconnections. And I do work with them on that.It has its drawbacks. Most notable, and one I did not get a good answerto at the Server Technology Forum at UKOUG, is that you cannot reallydo a 10046 trace on a session, as you can't distinguish sessions. Gajasays you can do that in 10g but telling me to upgrade to anot-yet-released piece of software doesn't help me now.I'm working on a way around that, I *may* have one, but it's untestedfor the moment (I have to bully the programmers into changing
 code,which is as likely to happen as it is for me to win the lottery withoutbuying a ticket). In any case, connection pooling appears to be the way of the future forforward-facing web applications, so we have to deal with itRachel--- Ryan <[EMAIL PROTECTED]>wrote: how do you feel about connection pooling? Our software engineers implemented that here? Am I wrong to be concerned about large numbers of users using the same named user?   - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 6:39 AMSteve,   By "distinct user" do you mean distinct username? Or sid/serial#  combination? In my case, we use connection pooling, while there may be  up to 300 sessions, they are all the same named user. !
;
  Rachel   --- Steve Adams <[EMAIL PROTECTED]>wrote:   Hi All, Someone has alerted me to this thread, and asked for a comment.   On a quick scan, and it seems to me that you've mostly got it right. The "problem" is that when an SQL statement that refers to its base   objects via public synonyms is shared by multiple distinct Oracle   users,   then name resolution and permission checking need to repeated for   each   distinct user, and because the results of these actions are cached on   the shared cursor, they increase the cost of subsequent such   operations.   That is, public synonyms cause extended latch retention as well as   additional latching. 
For example, if 500 distinct users share 200 SQL statements that   refer   300 times to 100 base tables via public synonyms. Then there will   also   be 100 * 500 non-existent objects in both the dictionary cache and   the   library cache; 200 * 500 cursor authorization structures; and 300 *   500   negative dependency records in the library cache. These last two   things   are cached as segmented arrays that are scanned linearly - thus the   increased latch retention. If your application doesn't have hundreds of distinct Oracle users,   or if you can afford the extra latch gets and longer latch retention,   then you will probably not notice all of this unless you start
 doing   library cache dumps. That is, the use of public synonyms is a major scalability threat,   but   does not normally cause performance problems. @ Regards,   @ Steve Adams   @ http://www.ixora.com.au/ - For DBAs   @ http://www.christianity.net.au/ - For all   --   Please see the official ORACLE-L FAQ: http://www.orafaq.net   --   Author: Steve Adams   INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com   San Diego, California -- Mailing list and web hosting services   - !
  To
 REMOVE yourself from this mailing list, send an E-Mail message   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in   the message BODY, include a line containing: UNSUB ORACLE-L   (or the name of mailing list you want to be removed from). You may   also send the HELP command for other information (like subscribing).__  Do you Yahoo!?  Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes  http://hotjobs.sweepstakes.yahoo.com/signingbonus  --  

Listen to Cary in Charlotte on Thursday

[Murali Vallath]

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

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


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

TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE

[Murali Vallath]

I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server.

for example this tnsping took about 270 ms which is strange and its consistent
Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST= myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE= SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15OK (270 msec)

and a ping to the same host 
Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms
Why could there be such a difference? 




Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square

Re: Re: 24 x 7 x 365

[Murali Vallath]

Tanel,

If this is the approach, then quite a bit of code would have to be developed on the front end to handle transaction integrity. For example when one fails and the other has completed the write successfully, they will have to be physically removed.What about if the record that is commited was already read by another session.

Basically avoiding any orphan records or avoiding data reconciliation between the two.

I also agree with Jonathan, while two phased approach is used for such kind of activities, there could be tremendous overhead depending on how intensive the transaction rates are.

Murali 


Tanel Poder [EMAIL PROTECTED] wrote:
Jonathan,Thanks for this valuable information.However, I'm using regular commits, not "distributed" two-phased ones and Ijust have simple code to handle the situation where servers return differentsuccess/error codes.Tanel. There is a problem with this approach that may only become apparent at high concurrency. Since you are operating with two-phase commits, you may come up against the case where "writers block readers". Your client issues a commit to both servers. Each server get the PREPARE message, and when both have responded, each gets the COMMIT message. Between the PREPARE and COMMIT, any blocks updated in the transaction cease to be available to ANY query that started after the PREPARE
 arrived. For the (hopefully) brief interval between the prepare and commit, neither database knows whether the transaction as a whole has prepared or committed, so any process that wants to see the current version of the data has to wait until there is a known current version. In a high-concurrency system, a problem that used to be "buffer busy waits" on updates only can turn into enqueue waits on updates and queries. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html
 UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message -  To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, December 13, 2003 8:19 PM Yep, I also think so. I'm currently developing a small prototype for this kind of transparent proxy, which I'll post here when it's stable... Tanel.  Tanel,   I think this is a good solution, provided the application can handle  two phased commit protocol across both the databases, else there  could be orphan records on one or both these databases.  --  Please see the official ORACLE-L FAQ: http://www.orafaq.net --  Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City !
Network
 Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Tanel PoderINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail
 messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: 24 x 7 x 365

[Murali Vallath]

aining: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Tanel PoderINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Murali Vallath 
Author: Oracle Real Application Clusters Publisher Digital Press
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2V5D30UGVSisbn=182885itm=4#PU
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: 24 x 7 x 365

[Murali Vallath]

If this is the customer you are talking about, this database supports over 12 million subscribers..

Murali Tim Gorman [EMAIL PROTECTED] wrote:
As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL PROTECTED] wrote:
True 24x365 is just about impossible. No if, ands. or buts about it. Why is because of the number of factors outside your control that affect system availability. Sure your web sever and database are up 24x365, but your ISP has 1 hour down time each month for maintenance. OOPS!! from a customer point of view your NOT 24x365. Also that fiber optic cable running out of your building to the phone pole is available for some heavy equipment operator to slice through while working on the sewer system, OOPS!! So you can't have 24x365 no matter what. What you should do is try to adapt the changes you need into the downtime that's imposed on you. That's what we do  it works very nicely.Besides being completely redundant is extremely expensive, like two of everything, including building, air-conditioning, fiber !
optic
 cables, etc.Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
-Original Message-From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: 24 x 7 x 365Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the followingannotations on 12/10/2003 09:41:15
 AM--**"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."**======
Murali Vallath 
Author: Oracle Real Application Clusters Publisher Digital Press
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2V5D30UGVSisbn=182885itm=4#PU
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: what is oracle rdb?

[Murali Vallath]

Well said Mogens, I have been following your thread. 

I have worked with Rdb for several years it is an excellent product and thank GOD that they did not allove MS or CA or for that matter IBM to buy it. It would have been shot down to non-existence several years back.

Murali
Mogens_Nørgaard [EMAIL PROTECTED] wrote:
Yeah, why did they do the right thing here, but not in other places? Very good question. Oracle has bought many, many companies and products over the years...One splendid thought I just had: Because it never became something to handle high up in the organisation, hence it never became a political issue, and therefor most of the BS has been avoided.Nothing - nothing - beats leaving the folks alone to do the job. That's why the bearded fellows have kept working at the NEDC (New England Development Center), as I think it's called.MogensThater, William wrote:Mogens Nørgaard scribbled on the wall in glitter crayon: That's how I came to deliver the first-ever course at Lego in their HQin Denmark (in a town called Billund, but certainly not named afterThe
 Bill). yes i'm sure it's not named after me... oh you meant the other bill.;-) Oracle has done the right things about Rdb again and again and againafter taking over the shop from Digital. They kept the bearded,bitter, old, twisted, spec-writing folks of the New EnglandDevelopment team. They let them get on with what they did best: Writenew features for Rdb. They borrowed good ideas from them and fed itinto Oracle. They let them use good Oracle ideas in Rdb. I havenever, ever, seen any take-over work so well in the IT industry. Askthe Rdb customers (Lego, Novo, etc.) and they will tell you theystill trust Oracle and Rdb. Incredibly well done. Respect. i wonder why this one worked and the other's haven't? what made this onedifferent? i can't say the Oracle has
 exhibited this kind of integrity inother places. Jesse - was this what you wished for, or did it suck? well, i don't know about him, but i found it interesting.--Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED]SCCS, the source motel! Programs check in and never check out! - KenThompson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this
 mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Murali Vallath 
Author: Oracle Real Application Clusters Publisher Digital Press
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2V5D30UGVSisbn=182885itm=4#PU
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

BR Benchmarks

[Murali Vallath]

Does anyone have any benchmark numbers for a BR operationof a 3TB Oracle database? I understand this depends on several environmental conditions. If anyone of you has had a need to do a restore of 3-4TB Oracle database and would not mind sharing some of your thoughts that would be wonderful.

Thanks,

Murali Vallath
Murali Vallath 
"We must be the change we wish to see in the world." Mahatma Gandhi.
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

New global RAC-SIG and discussion forum

[Murali Vallath]

Hello listers,

At OW, SF RAC users, IOUG and Oracle put their heads together to launch a new RAC-SIG. 

IOUGhas started aRAC-SIG list server for its members.http://www.ioug.org/ioug_p/dynamic_pkg.show?v_name=DISPLAY_RAC_SIG

Last week the RAC-SIG took a global turn, it wasofficially launched at the OW, Paris with the help of EOUGfolks. 

With the new globalRAC-SIG, weare happy to announce the launch of a newglobal RAC-SIG discussion forum, thathas no strings attached. Its a technical forumand requires no membership. You can reach thisdiscussion forum at www.oracleracsig.org 

Regards,

Murali Vallath
President - RAC-SIGMurali Vallath 
"We must be the change we wish to see in the world." Mahatma Gandhi.
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Re: submitting statspack.snap through dbms_job

[Murali Vallath]

If you are not already aware there is an spauto.sql in the $ORACLE_HOME/rdbms/admin directory which could be modified with the following
for example:
next_date=trunc(sysdate)+10/24, interval='trunc(sysdate)+10/24'); 
Regards
Murali
Zabair Ahmed [EMAIL PROTECTED] wrote:

Quick question, I want to submit statspack.snap at 10:00am and 14:00pm through dbms_job, it's friday afternoon and my head is hurting me from a heavy night and the manuals are as clear as mud.
Thanks



Yahoo! Plus - For a better Internet experienceMurali Vallath 
"We must be the change we wish to see in the world." Mahatma Gandhi.Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

Re: SunCluster 3. 0 Veritas File system RAC

[Murali Vallath]

You will be better off recommending veritas file system, you can assure yourself of some good performance matrix and easy transisition and off course some good nights of sleep.
Allowing Sun to manage the file system or for that matter the raw partitions is a nightmare. I am speaking from experience. Since vertias was not available until recently went with SUN raw devices and hmmm! makes me wonder why is Sun into this clustering business.
Regards
Murali 
Vladimir Barac [EMAIL PROTECTED] wrote:




Anyone using this configuration?

Since I would like to avoid raw partitions, I was thinking of recomending Veritas File system...

Is it certified / working? Anyone working with such combo?

I will fire metalink page soon, but would like to have some input from listers!

Thanks,
Vladimir BaracMurali Vallath 
"We must be the change we wish to see in the world." Mahatma Gandhi.Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

Re: Temporary Tablespace and RAC

[Murali Vallath]

Hello Ashok

What are u seeing to make you believe that you need separate temp segements 
per instance?

Murali Vallath









Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Mar 2003 17:14:18 -0800
Is there a way in RAC that I can create 2 TEMP tablespaces which can be
explicitly assigned to separate instances of RAC. Or is there a way that to
specify the size of the instance-specific temp segments? If I have a TEMP
tablespace with a size of 10GB, how can i split it between 2 instances with
5GB each. We're using 9.2.0.2.
Are there any white papers that talk about how TEMP is managed in RAC?

As I understand it, if you have a single TEMP tablespace, there will be 2
temp segments created under the TEMP tablespace specific to each instance
and extents will be allocated from those segments to each instance's
session, but Oracle doesn't allow for TEMP space to be pre-allocated between
instances. Depending on the instance-specific TEMP segment's requirements,
it allocates and deallocates automatically between segments.




_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

fgac tracing

[Murali Vallath]

I remember seeing someone mention the event number to tracing a session to 
capture fine grained access control activity.   Does anyone remember!

Thanks

Murali Vallath







_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

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

Re: Oracle Tools - OEM 4.0

[Murali Vallath]

If you wait for another couple of months you may have OEM 4.0 which has a 
considerable amount of enhancements including supports for PDA's and the 
basic version comes with the enterprise edition.



Murali Vallath









Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 05 Mar 2003 03:49:26 -0800
Hi gurus,

Is there any Oracle tools available to use it in Handheld Computers.(like 
PDA or IPAQ)

Thks in advance



_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus

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

V$ARCHIVED_LOG question

[Murali Vallath]

Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG dictionary 
view,however there is no documentation.

For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION#

Any clues on what these columns mean.

Thanks

Murali

  DEST_IDTHREAD#  SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD# 
ACTIVATION#
-- -- -- ---   
---
1  2 48 NO 12  
3612293975
1  1116 NO 11  
3612293975
1  2 49 NO 12  
3612293975
1  1117 NO 01  
3612293975
1  2 50 NO 02  
3612293975
1  1118 NO 02  
3612293975
1  2 51 NO 02  
3612293975
1  1119 NO 02  
3612293975
1  2 52 NO 02  
3612293975



Murali Vallath





_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

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

RAC, Linux and 9 yards

[Murali Vallath]

I have finally browsed through a number of e-mails on this subject.  Let me 
add my 2Cents.

Oracle is pushing RAC on Linux pretty hard and off course its performing 
good, actually better than some of the Oracle's once preferred platforms 
such as SUN.

In the future version of Oracle the cluster ware will be bundled with RAC 
for all operating systems, thus removing the additional cost to customers 
who have to depend on the hardware and pay those extra $$$ and those 
hardware platforms that do not perform because they are new into this 
clustering technology. I am talking about the hardware company that's got a 
name of the star that rises in the East (Hint!)

Oracle just completed installation of a 20 instance RAC cluster on Linux at 
 (sorry I have a non-disclosure and I cannot reveal). I am told that 
this will eventually grow up to 200 instances probably with 10i.

While the OS plays an important role, there is even more important criteria, 
the hardware configuration better have a good HIGH SPEED interconnect. For 
example HP's new interconnect (developed with close relationship with 
Oracle's RD) that transfers data with .0005 ms latency or VI interconnect 
from HP on the intel platforms.

Regards,

Murali Vallath





_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

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

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

Implementations of VI in Oracle shops!

[Murali Vallath]

I am trying to collect some information regarding implementations of virtual 
interface (VI)  in place of UDP/TCP protocol for cluster interconnects.

If any of you have such an implementation and or know of such an 
implementation an insight regarding the hardware platforms (sun, compaq) etc 
with how it works would be really helpful.


Thanks

Murali Vallath



_
Surf the Web without missing calls! Get MSN Broadband. 
http://resourcecenter.msn.com/access/plans/freeactivation.asp

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OPS Sequences: nocache == order ??

[Murali Vallath]

I agree with Anoj, you need to talk to the business folks to remove this 
dependency. Else you may encounter waits/queues on getting the next sequence 
numbers.  One of the benfits in OPS and in RAC is the sequence cache option, 
because each instance will not have to query the Oracle's fast cache areas 
for the next sequence or wait in queue to get the next number.

Any ways if you see slowness you now where to look!


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 03 Sep 2002 15:54:06 -0800

Unfortunately, we have an application dependency and I was required
to come up with a quick  dirty fix. Thanks for your reply.


On 2002.09.03 19:10 Anjo Kolk wrote:
 
  If you run OPS and specify order, it works like no cache.
 
  My question to you: Why cripple OPS and your business performance by 
having
  this requirement ? Spending a few bucks to get rid of this dependency 
will
  improve the performance, until you run in to the next problem ;-)
 
  Anjo.



 
 
 
  On Wednesday 04 September 2002 00:00, you wrote:
   I'm managing an OPS configuration (4x HP 9000/N, HP-UX 11/64 , RDBMS
   8.1.7.1)
   and I'm having an application dependency on a temporal order of 
sequence
   numbers.
   With OPS that becomes a problem because each node caches a set of 
sequence
   numbers
   (20 by default). Oracle has an option, specifically for that situation,
   namely ORDER.
   My question is whether ORDER is the same thing as NOCACHE and whether 
it is
   possible
   to have a NOCACHE sequence which will return numbers in an incorrect 
order
   (larger number
   before the smaller one).
   Please, o OPS gods and godesses, help me out and I'll sacrifice you a 
beer
   when I see you.
   Mladen Gogala
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Anjo Kolk
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 

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

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

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





Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

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

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

Check who is coming to Charlotte!! NC

[Murali Vallath]

Charlotte Oracle Users Group
Covers: 'Oracle Performance Management - A Radical Approach'
(Performance Tuning One day Seminar)
By: Gaja Krishna Vaidyanatha
When:   Thursday, August 29th 2002 Between 07:30 AM and 05:30 PM

To Register: Please visit www.cltoug.org to download the forms and to learn 
more about this seminar.

What do you get for attending!
   Meet and learn from the Expert!
   No better learning opportunity!
   Great agenda of performance tuning areas covered.
   Attend and receive a FREE copy of the Oracle 101 performance tuning book 
(signed by the author himself on request)
   Non-members receive membership for 2002

Want more.. HURRY, seats are limited.

DOWNLOAD REGISTRATION FORMS AT WWW.CLTOUG.ORG

Regards,

Murali Vallath
President, Charlotte Oracle Users Group.










_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Re: WebLogic, Oracle JDBC related

[Murali Vallath]

 kinds of questions about Listener problems. The Vendor is 
suggesting
   to increase the QueueSize for the listener. They have already created
   multiple listeners in vain.
  
   I think the Appl code is to blame. I do not know much about Java/EJB 
etc..
   but my hunch is that this EJB container stuff does not smell good. For 
all I
   know it could be making a db connection for every single thing and
   disconnecting.
  
   Anyone dealt with similar issues?
   All tips are welcome and appreciated.
  
   All right, the preferred vendor is AMDOCS. Anyone running any of their 
Web
   Applications?  If so, can you please contact me off-list?
  
   Thanks.
  
   - Kirti
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Deshpande, Kirti
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Suzy Vordos
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author:
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
   INET: [EMAIL PROTECTED]

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

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





Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Re: Exp Imp User ?

[Murali Vallath]

RTFM


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 18 Jun 2002 20:33:20 -0800

I want to know the export and import commands(SYNTAX).

Then i want to know what are all the steps(commands) to be done
for creating a new user such that after creating i have to use the
above two commands and to take a dump of scott user , then that
scott dump should be incorporated into the new user i have
created.

i want to know all the steps clearly for the above task...


Kindly Help

Regards,
[EMAIL PROTECTED]


_
Click below to visit monsterindia.com and there is always a
better job for you at http://monsterindia.rediff.com/jobs

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

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

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





Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Re: TAF

[Murali Vallath]

Exactly that is what my benchmarks have also noticed.

Couple of other points...

1. Since the PRECONNECT always maintains a connection with the secondary 
instance, there is a 2% overhead compared to the BASIC option.
2. I don't and did not see the need for a PRECONNECT option. Off course like 
Tim indicates there is potential traffic jam situation in the case of the 
BASIC option and there could be small delay. Unless your application is 
being developed for the Stock Exchange or for the space station (where such 
an application may not be useful anyways) I mean machine critical nature you 
should not have to worry.
3. You could use the RETRY/DELAY option combined with the BASIC option to 
cover for any failures/timeouts when the jam occurs.

I had a paper presented on this very subject at the 2001 Open world. You 
should find it on the Oracle website.

Regards

Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 07 Jun 2002 05:18:27 -0800

Fawzia,

PRECONNECT establishes the second/failover database connection along with
the first/primary, so your client-server database connection is really
client-server1/server2.  Should the first/primary connection fail, then you
failover to the second.

BASIC establishes only the first/primary database connection but has the
information available to establish the second/failover connection should the
first/primary fail.

PRECONNECT will failover faster, as the second/failover connection has
already been established.  In a large environment (i.e. hundreds of database
connections) full of BASIC connections, you can expect the mass exodus from
one database instance to the failover to cause BASIC connections to wait a
noticeable amount of time.

One problem with PRECONNECT that I've noticed is the scenario where the
second/failover instance is terminated for some reason first.  Let's say a
bunch of PRECONNECT TAF connections are working away happily via their
first/primary connection to the primary database instance, and there is some
reason to terminate the second database instance or some/all of the
second/failover database connections to the second database instance.  In
this case, PRECONNECT will not notice the loss of the second/failover
database connection, allowing the first/primary connection to continue
working happily away.  But after bringing the second database instance back
online, if the first database instance should now fail, then all those
PRECONNECT sessions will simply fail.

Upshot:  BASIC is more robust, because it fails over only when it needs
to, but you can get caught in a traffic jam in the event of failover.
PRECONNECT can fail over faster because of previously established failover
connections, but if anything happens to that second connection after the
time it is established, then you'll be out of luck.

Hope this helps...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 5:43 AM


 
  Hi ,
 
  I am configuring TAF on oracle 8.1.7 (solaris). I was just wondering if
  anyone on the list has had experience on this and can give me any advice-
  more specifically on the the method- preconnect and basic. Are there any
  significant benefits of having the preconnect setting set?
 
  Any input would be really appreciated..
 
  Rgds
 
  Fawzia
 
 
  **
  Information in this email is confidential and may be privileged.
  It is intended for the addressee only. If you have received it in error,
  please notify the sender immediately and delete it from your system.
  You should not otherwise copy it, retransmit it or use or disclose its
  contents to anyone.
  Thank you for your co-operation.
  **
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Malik, Fawzia
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).

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

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

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

Re: Oracle RDB vs. Plain Oracle

[Murali Vallath]

Oracle has two database products, Oracle RDBMS, (or oracle oracle) and 
Oracle Rdb. Both of them are relational databases. However, Oracle Rdb only 
supported on Open VMS.

Oracle purchased Oracle Rdb (previously called DEC Rdb) from Digital 
equipment corporation several years before. this is a great production and 
scales pretty well. Many of the large OLTP implementations use Rdb, eg.. 
Australian Stock Exchange, Korean Stock Exchange, Mercantile Bank, DIRECTV, 
etc to name a few.

Many of the features you are seeing today with Oracle, existed in Rdb for 
several years now (partitioning, multi block format) etc. and have moved 
into the Oracle space from Oracle Rdb after Oracle purchased this product. 
Actually the cost based optimizer is another good example, and Oracle 
Expert, new features in Data guard etc.

Need more specifics visit http://www.oracle.com/rdb

Regards,

Murali Vallath




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 16 May 2002 18:58:24 -0800

Hello,

What are the differences between the two?
Thanks.

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

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

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





Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

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

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

SMON reports Dead Transactions - Not seen this before

[Murali Vallath]

Hello list

I am for the first time seeing a message like this in the SMON trace file.
---
Using 1 slaves for 1 dead transactions
Recovered xid: 0x000e.00a.4971 in 20 milliseconds; nchk=0, size=2327
---
I have not seen this message before, any ideas ...

Murali Vallath

_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

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

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

RAID-1 PLUS from SUN

[Murali Vallath]

SUN 9960 storage system comes with RAID-1 PLUS. Any ideas on what kind of 
RAID this is. Not heard of RAID-1 plus.


Regards,

Murali Vallath




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Calling Presenters for 2002

[Murali Vallath]

If you have experience and experiences that would benefit other users, seize 
this opportunity to share your ideas in 2002

Engage your colleagues with fresh approaches.
Excite your peers with innovative techniques.
Intrigue your associates with cutting edge topics.
Sign-up for a presentation on any topic of your expertise,
Show Charlotte your talent, knowledge and experience.

Charlotte Oracle Users Group is calling the talented minds to come and share 
their knowledge in the following areas

Oracle Database Administration
PL/SQL, Java, JDBC, JDeveloper, SQLj Development
Oracle Database Performance and Tuning
Oracle Objects
VLDB'S
WebDB/Portal
Oracle Application Servers
Oracle Parallel Server/Oracle Real Application Clusters
Oracle Designer
Oracle Developer

The process is simple,

Send in a topic of interest,
·A brief abstract on the topic,
·A brief biological information about you and
·A month convenient for your presentation

Information should be sent to [EMAIL PROTECTED]

For more information about the meeting dates and timings please visit our 
website at www.cltoug.org

Regards,

Murali Vallath
President, Charlotte Oracle Users Group

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

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

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

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

Longest SQL statements!!!

[Murali Vallath]

Are there any implications on how long the SQL statement is? The current SQL 
statements that I am inheritting, is really long. tons of embedded sub 
queries etc.

My first question is are there any known issues with haveing very long SQL 
statements and if yes what has been a good length other than the fact that 
it may depend on your SGA.

Thanks

Murali




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

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

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

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

List users planning to meet during Open world

[Murali Vallath]

Hi everyone,

Are we planning any LIST USERS meeting (like at the IOUGa LIVE) during open 
world?

Regards,

Murali

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

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

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

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

JDBC connections and SQL netTraffic

[Murali Vallath]

Can someone provide some education.

The application uses JDBC thin driver to make a connection to the database, 
with WEBlogic the connection pooling (similar to MTS) is also implemented.

Why would  one see a large number of SQL*NET traffic?  Any ideas?

Thanks

Murali Vallath

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

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

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

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

I forget the sight!!!

[Murali Vallath]

I have not used it for a while and inbetween switching jobs I missed it.

What's the site that formats your statspack and estat/bstat reports.



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

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

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

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

RE: Surrogate keys

[Murali Vallath]

True and not true,

If the database is partitioned and using a local index. then you may want to 
use the business key as a prefixed index. This way you could avoid the 
additional index on the table.

NOTE: The table is partitioned by the surrogate key and the all foreign keys 
in the child tables are the database generated primary keys. So when the 
application fetches the primary table wit the business key gets the 
corresponding surrogate key and navigates through other tables to retrieve 
data.

Now another important factor that should be considered while using surrogate 
keys is using REVERSE key indexes. When you have high volume inserts, the 
leaf block contention of using sequence generated keys is quite extensive.

Regards,

Murali Vallath



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 12 Jun 2001 05:45:23 -0800

Rick,

I use surrogate keys when the obvious primary key value has the possibility
of being updated by the application.

For example, you would think that a Social Security number might be a
candidate for use as a primary key in a college database.  What we found
upon study is that, the Soc Sec # provided at college application time is
sometimes the parents number, rather than the student's number.  So, it
changes about 10% of the time.

Of course, the cons of primary keys are that you probably will need an
additional index on the table to allow lookup by a secondary value.  In the
above case, the primary key was a surrogate value supported by a sequence,
with a secondary index on the soc-sec column.  The cost of using the
surrogate primary key was the additional index.

My current database that I am designing is only using surrogate keys.  It
provides a level of comfort in that we don't ever have to worry about the
primary key being changed - it never will.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 12, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Can someone explain pros/cons to using surrogate keys(i.e.,sequences) vs
non-surrogate keys?

Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

MTS and Java applications

[Murali Vallath]

Anyone using MTS with java applications with weblogic servers and JDBC 
drivers.

We are not using this at the moment, but I am unable to track any 
information about this configuration and the architecture of MTS with JDBC, 
NET8 etc.

Regards,


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

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

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

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

Oracle's Market share

[Murali Vallath]

Where can one find some information about Oracle's market share in the 
various O/S markets. Like, UNIX,LINUX,NT etc.


Regards


Murali Vallath


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

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

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

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

Re: OPS, TAF and jAVA

[Murali Vallath]

 at using TAF (never used before) for application fail 
over.
  First, any guidelines we should be aware of in general.
  Second any specific concerns using TAF with applications using JAVA.
  Any stuff on how does TAF and OPS work in harmony?
 
  Regards
 
  Murali Vallath
 
  _
  Get your FREE download of MSN Explorer at http://explorer.msn.com
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Murali Vallath
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 taf-1.rtf 

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

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

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

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

OPS, TAF and jAVA

[Murali Vallath]

We are looking at using TAF (never used before) for application fail over.
First, any guidelines we should be aware of in general.
Second any specific concerns using TAF with applications using JAVA.
Any stuff on how does TAF and OPS work in harmony?

Regards

Murali Vallath

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

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

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

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

RE: Oracle vs DB2

[Murali Vallath]

Boivin,

Not true, when Oracle purchased Rdb from Digital 10 years ago. This was the 
talk, Rdb will die in 7 years.

Today it is being enhanced every version/release.

SO DON'T KNOW, what IBM will do.

Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 24 Apr 2001 08:45:27 -0800

Well,

This is on topic - www.wired.com http://www.wired.com  today has an
article re. IBM announced that it is buying Informix for $1Billion.

Ah, if only I had that kind of money myself - I could take more Oracle
courses!

I don't know what will happen with Informix then, does that mean they will
gobble it up and DB2 will be the only option in a couple of years?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 24, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Oracle vs DB2

Disclaimer: I am *not* trying to start a religious war, and I am
*not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs
SQLServer
to determine our future direction. Here's a datum that makes a
significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet
through
a web page, you have to buy an unlimited-user enterprise license. We
had a
senior sales person in our office yesterday, and we asked this
question a
number of different ways. He bobbed and he weaved, but he did not
deny it.
And the quote he supplied afterwards does not address the issue at
all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition
(1
user), and something called WE Internet Access, for a total price of
$6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line
with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

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

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

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

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

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

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

Insert Cardinalities into the data dictionary directly

[Murali Vallath]

I am trying again

--

To obtain a good analysis of a SQL statement especially in a new development 
environment, based on the environment that it is to be deployed on, it would 
  good to sometime reflect/simulate the production volume.

Is there a way to input table cardinalities directly into the data
dictionary so that the Optimizer could be made to act like in production.

I am aware that if this is was an environment with good cardinalities, these 
  values could be exported and imported into another environment.

My question is this possible from scratch?

Regards,

Murali Vallath

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

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

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

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

RE: Insert Cardinalities into the data dictionary directly

[Murali Vallath]

Thanks for the feedback, I am coming from the Oracle Rdb world, where these 
row counts/cardinialities could be inserted into the data dictionary to 
simulate the optimizer behaviour similar to a production environment.

I see your point, this could be a negative impact to the optimizer.

Thanks for the input.]

Murali


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 18 Apr 2001 09:15:23 -0800

Take a look at dbms_stats.set_column_stats and dbms_stats.set_table_stats.  
The latter allows you to
set the number of rows, the size of the table and such ; the first allows 
you to set the number of distinct values for a column the number of nulls, 
etc.

I'm not sure what you are trying to accomplish with this.  Is simply 
changing the cardinalities of a the columns enough?  What about the 
distribution of those values?  If the changes result in a different query 
path, and your queries run more slowly, does that mean they will do so when 
the statistics truly reflect the database.  Perhaps they are running more 
slowly because you lied to the optimizer.


"I am aware that if this is was an environment with good cardinalities, 
these
   values could be exported and imported into another environment."

Cardinality reflects the ratio of distinct values to the  total number of 
values in the database.
I can think of scenarios where cardinality might change significantly for a 
time.  But I would think   in most cases it would remain fairly constant.

FYI, if statements which assert something contrary to fact are subjunctive 
not conditional.

"If this WERE an environment with good  cardinalities"

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]





-Original Message-
Sent: Wednesday, April 18, 2001 8:06 AM
To: Multiple recipients of list ORACLE-L


I am trying again

--

To obtain a good analysis of a SQL statement especially in a new development
environment, based on the environment that it is to be deployed on, it would
   good to sometime reflect/simulate the production volume.

Is there a way to input table cardinalities directly into the data
dictionary so that the Optimizer could be made to act like in production.

I am aware that if this is was an environment with good cardinalities, these
   values could be exported and imported into another environment.

My question is this possible from scratch?

Regards,

Murali Vallath

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

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

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

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

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

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

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

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

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

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

Re: Meeting at IOUG - LOCATION CONFIRMATION

[Murali Vallath]

Since I started this thread. Let me call for a closer. I think this 
suggestion is great. Let confirm this.

Murali Vallath

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 17 Apr 2001 10:53:57 -0800

Glad to see so many people wanting to get together. I would like to
propose a time and place...

Tuesday night is the "big bash", and Wednesday night is a "Pleasure
Island" event. There is a Monday night welcome reception in the exhibit
hall until 7:45.

So, I think the best time is Monday at 8pm, somewhere in the Swan
and Dolphin complex (not knowing the Orlando area personally).
http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D
views). My vote is Juan  Only's - "A perfect place to enjoy moderately
priced southwestern cuisine. Stop by the bar for the best margaritas in
town! Open for dinner." for its bar and not super-loud setting so we can
talk.

- Ari Kaplan

On Tue, 17 Apr 2001, Stephen Andert wrote:

  I'll be there and would like to meet as many of you as possible.  If 
anyone who knows the ropes can suggest a time/place, that would be great.  
As this is my first IOUG event, I don't have any ideas on where/when, so 
it's up to all you "veterans".
 
  Keep this thread going.
 
 
  Stephen Andert
 
 
   [EMAIL PROTECTED] 04/16 8:15 PM 
  don't know that any meeting has been scheduled, I do know that a number 
of
  the members of the list are presenting and I intend to be at most of 
those
  sessions :)
 
  on the other hand, Gaja's sessions tend to draw EVERYONE so you can be 
sure
  of meeting others on the list there
 
 
  From: "Murali Vallath" [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: Meeting at IOUG
  Date: Mon, 16 Apr 2001 18:30:43 -0800
  
  
  Are any of the floks from the list meeting during the IOUG-A live in
  Florida.
  
  I am attending and would like to join the meeting.
  
  Murali Vallath
  _
  Get your FREE download of MSN Explorer at http://explorer.msn.com
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Murali Vallath
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
  _
  Get your FREE download of MSN Explorer at http://explorer.msn.com
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Stephen Andert
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 

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

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

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

Input Cardinalities into dictionary for Optimizer Behaviour

[Murali Vallath]

To obtain a good analysis of a SQL statement especially in a new development 
environment, based on the environment that it is to be deployed on, it would 
good to sometime reflect/simulate the production volume.

Is there a way to input table cardinalities directly into the data 
dictionary so that the Optimizer could be made to act like in production.

I am aware that if this is was an environment with good cardinalities, these 
values could be exported and imported into another environment.

My question is this possible from scratch?

Regards,

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

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

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

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

Meeting at IOUG

[Murali Vallath]

Are any of the floks from the list meeting during the IOUG-A live in 
Florida.

I am attending and would like to join the meeting.

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

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

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

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

RE: Database Cache of Oracle9ias

[Murali Vallath]

I have a TAR open on this subject with Oracle suport since Feb 11th. Unable 
to configure database cache. It fails after completing about 26% every time.

This installation is on Compaq TRU64




Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 13 Apr 2001 14:20:42 -0800

Hi Kevin,

The Database Cache Assistant works fine till it
reaches
the last part where it tries to export some User
data..

The error which it gives is "Unable to export User
privileges" and then it fails and moves onto
installing
other components, I tried to install Oracle DB 8.1.7
and Oracle 9iAS on the same server. The configuration
reaches the last part of the Database Cache
configuration screen.

Moreover once I sucessfully installed Oracle 8.1.6 DB
and Oracle 8iAS (Earlier version) on the same server..

Thanks..

Sushant

--- Kevin Tsay [EMAIL PROTECTED] wrote:
  What's the problems you have ?
 
  --Kevin
 
  -Original Message-
  Sent: Thursday, April 12, 2001 3:55 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi all,
 
  Has anybody installed Oracle Database Cache of
  Oracle
  9iAS sucessfully..
 
  Thanks in advance...
 
 
  Sushant
 
  --- TARUN SHARMA [EMAIL PROTECTED]
  wrote:
   Hi,
 Yes u can install oracle 8i DB and 9iAS on the
   same machine.
  
  
   On Wed, 11 Apr 2001, Seema Singh wrote:
  
Hi DBAs
Can I install Db server and Oracle9iAS on same
   M/C.
Thanks
-Seema
   
  
 
_
Get your FREE download of MSN Explorer at
   http://explorer.msn.com
   
--
Please see the official ORACLE-L FAQ:
   http://www.orafaq.com
--
Author: Seema Singh
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051
   FAX: (858) 538-5051
San Diego, California-- Public Internet
   access / Mailing Lists
   
  
 

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

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

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

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


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
   INET: [EMAIL PROTECTED]

Fat Ci

Re: Issues with Oracle on a Compaq Tru64 5.1 Cluster

[Murali Vallath]

We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some 
all files and had to apply some O/S level patches.
We followed the instructions in the following TAR#  13320267.600. You may 
want to do a dbv on certain files to ensure there is not corruption.

Again we did not notice these problems until RMAN complained of corruption. 
And we noticed corruption in the redo logs.


Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 27 Mar 2001 08:47:20 -0800

   We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 
patchkit 1.  We have had Oracle running for almost 2 months.  For the last 
several days, we have been experiencing severe I/O issues.  The databases 
will freeze-up and claim that they can't access certain files.  
Occassionally even 'ls' commands will lock up to, but only when accessing 
certain sub-directories of file systems.
   Naturally, we are trying to figure out what has changed in the last few 
days.  We know that the Legatto Networker client was installed, and we also 
had a UPS failure.  In an attempt to isolate the problem, we have removed 
the Legatto Networker client.  Our sysadmins are not seeing any problems at 
the hardware level.  We have completed powered the cluster down and brought 
it back up.  When the databases begin locking up, we do see error messages 
related to various file systems come across the console.  For a few days, we 
thought it might be RMAN, but I haven't used it in the last 2 days and the 
problems are still occurring.
   So, my question is - are any of you folks on a Tru64 5.1 cluster and if 
so, have you seen similar problems?  The systems include 3 GS80s, an ES40, 
and a Storage Area Network for the disks.  We are not running OPS and we are 
not using raw devices.

Thank you,
Jay Hostetter

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

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

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

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

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

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

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

Re: DBMS_REPAIR package usage

[Murali Vallath]

Hi Yong,

How does one subscribe to this ?

Murali Vallath

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sat, 24 Mar 2001 05:05:21 -0800

Hi, Winnie,

How did you find the file# to be 9 (unless you messed with your original 
error
message)?

I suggest you post your message to news:comp.databases.oracle.server (or
http://news.interbulletin.com/cgi-bin/ibwrn/post/comp.databases.oracle.server
if your company doesn't have a news server). Hopefully it will attract
attention of Jonathan Lewis, the Oracle 8i expert, and several (former) 
Oracle
employees such as Kyle Hailey, Howard Rogers and Anjo Kolk. The good thing
about that newsgroup is nobody is audacious enough to post spam messages 
like
"tomorrow I'll post the chocolate recipe here".

Yong Huang
[EMAIL PROTECTED]

--- [EMAIL PROTECTED] wrote:
 
 
  Yong,
 
  Thanks a lot for all the research! :D
 
  The file# that actaully contains this block is 9. My database is not that
  big at all.
 
  I did do some research myself and some Oracle analysts in the World Wide
  Support does suggest that the influxed blocks are very likely to be a
  fractured block. But I reallly have no idea how it got in there... .
 
  Winnie
 
 
 
 
 
  yong huang [EMAIL PROTECTED] on 03/23/2001 04:01:21 PM
 
  To:   [EMAIL PROTECTED]
  cc:   [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
 
  Subject:  Re: DBMS_REPAIR package usage
 
 
  Hi, Winnie,
 
  Just a little more research. I wonder how you can have an rdba that big,
  0x24070020, which is 604438560 in decimal.
 
  SQL var a number;
  SQL exec :a := dbms_utility.data_block_address_file(604438560);
 
  PL/SQL procedure successfully completed.
 
  SQL print
 
  A
  -
144
 
  SQL exec :a := dbms_utility.data_block_address_block(604438560);
 
  PL/SQL procedure successfully completed.
 
  SQL print
 
  A
  -
 458784
 
  This is done on 8.1.6. It says the block is in file 144, block 458784. 
Why
  does
  your error say file=0? Anyway, in case you do have a file numbered 144,
  check
  to see if there's an object there. If it's indeed file 0, the dba should 
be
  the
  same as block#, 458784, or 0x70020. DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS
  can
  confirm this. However, that file# 0 may be just an indicator that that
  information is lost, as multiple other 0's look like.
 
  I believe dbv reports an error when it encounters a fractured block, 
i.e.,
  the
  first two bytes of tail (0003 in your case) does not match the last two
  bytes
  of rdba (0020). We know how a fractured block is created during hot 
backup.
  But
  I don't understand why an offlined datafile (as you said in another 
email)
  can
  contain fractured blocks. Maybe Jeremiah Wilton can give a better answer.
 
  Yong Huang
  [EMAIL PROTECTED]
 
  you wrote:
 
  I have a datafile in my production box (a user data tablespace), when I 
run
  dbv against it, it showed that 5 blocks are "influxed"
 
  Page 458784 is influx - most likely media corrupt
  ***
  Corrupt block relative dba: 0x24070020 file=0. blocknum=458784.
  Fractured block found during dbv:
  Data in bad block - type:0. format:0. rdba:0x
  last change scn:0x. seq:0x0 flg:0x00
  consistancy value in tail 0x0003c204
  check value in block header: 0x0, check value not calculated
  spare1:0x0, spare2:0x0, spare2:0x0
 
  We can copy this file to tape, dd this file. On the OS disk level, the OS
  does
  n
  ot treat this as corrupted. But it is corrupted on the oracle
  (software) level.
 
  I've checked and can't find any object associate with these 5 corrupted
  blcok.
 
  That means that there is no data inside those blocks.
 
  Since the tablespace is about 12 GB on a highly active system (which only
  got 3
  hours maintance window each month), export/import (then drop the
  tablespace)
  which Oracle support suggested is mostly out of the question. 
(Especially,
  it
  is
   very hard for me to convince the sysadmin that the blocks are
  corrupted
  as they don't see any I/O error associate with this file and the 
developers
  don'
  t see any problem with the application either!)
 
  I am currently thinking about upgrading this database to 8.1.6 to make 
use
  of
  th
  e DBMS_REPAIR package to make those blocks as "unusable". But I
  am not sure that if the DBMS_REPAIR package can run against the blocks
  which do
  not belong to any objects!! Can someone  give me some
  guidences?
 
  thanks
 
  Winnie
 
 
  __
  Do You Yahoo!?
  Get email at your own domain with Yahoo! Mail.
  http://personal.mail.yahoo.com/
 
 
 
 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
   INET: [EMAIL PROTECTED]

Fat City Network Services  

Physical Design Standards

[Murali Vallath]

Any suggestions /books whitepapers on Database Physical Standards

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

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

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

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

RE: Someone changed INTERNAL password SOLVED..

[Murali Vallath]

We do not have a practice to give password for the internal account. So when 
it promoted it sounded like someone had assigned a password. Apparently 
there was a parameter

SQLNET.AUTHENTICATION_SERVICES parameter added to the sqlnet.ora file. when 
I commented this out. It worked.

Thanks for your help

Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: 'Murali Vallath ' [EMAIL PROTECTED]
Date: Tue, 20 Mar 2001 10:30:16 -0600

  Hi!

If you are using windows nt...

use orapw to re-change it...

if you are using unix:
you connect with svrmgrl!!!

Hope this help!



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/20/01 8:17 AM

URGENT,

Someone changed the internal password. How do you connnect or change the

internal password, if not able to find it?

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

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

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

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

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

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

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

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

ODS

[Murali Vallath]

Hello Everyone,

This new term Operational Data Store(ODS) has many definitions, like staging 
area to the data warehouse, data mart, A data warehouse or reporting 
database,  a archive area etc etc. updated almost real time.

From your experience, is this being used in the Oracle world. What size are 
these databases? What configuration is this on? What is the uptime?

I have a requirement that this should be a 24*7 database. Anyone would like 
to share their experiences.

Regards,

Murali Vallath

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

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

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

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

24*7 Operation using Compaq TRU64

[Murali Vallath]

Hello everyone,

I am trying to collect some information on using Compaq TRU64 for a 24*7 
high volume, machine critical application using Oracle 8i. Basically, 
gathering information about howmany of us are using this and what is the 
typical configuration.


Murali Vallath

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

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

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

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

ORA-00200 (control file creation error)

[Murali Vallath]

OS COMPAQ TRU 64 Version 5.1 with OS clustering option enabled
Oracle Version 8.1.7


I am trying to create a new database OPS database/instance. While running 
the script using SVRMGRL get the following messages..

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/dev/disk/dsk19a'
ORA-27038: skgfrcre: file exists

Any ideas, the sys ops say everything is OK.


Regards,

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

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

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

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