RE: VC++ to Oracle connectivity without installing client
Hrm. But that's why everyone is doing web-based(three-tier) applications to avoid doing that kind of thing. Even if you manage to include Oracle client into your app, you will still face the challenge of rolling your app on 1000 PCs. Plus subsequent fixes, new versions. -Original Message- Sent: Friday, November 08, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Hello Gurus, I would like to program our VC++ application to directly connect to Oracle database using OO4O or OCI. But the problem is this VC++ app is gonna run on 1000s of desktops where we may have to install Oracle client which will be a time consuming in-efficient process. I am trying to see if the required client dlls and other files can be combined in the VC++ package itself and delivered to those 1000s of desktops. Can any of you give some insight into this, please? Any help would be highly appreciated. Thanks, Muru __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muru INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shareplex core dumps - help
Hi all, We are having a shareplex issue and I am hoping someone here with shareplex knowledge can help me out. I don't know much about shareplex. Basically we are replicating to a target table which is partitioned by date. And partitions that are 3 days old will be set to read-only because there are not suppose to be anything new. But occasionally, some record with timestamp older than 3 days creep up, so of course shareplex couldn't put the record into the target partition because it's read-only. Now the problem is shareplex core dumps when this happens. I am very surprised that we couldn't have a rule that tells shareplex if you can't replicate then either discard the record or put it elsewhere. Core dump seems to be a extreme reaction to this. unfortunately this is hosted and ran by a hosting company and I have no shareplex here to test or verify. Any help is appreciated. Thanks Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: urgent help: replication, shareplex
Oh, and I forgot to add that the table that's being replicated is partitioned in the repository database. with local indexes. Each partition holds a day worth of volume. > -Original Message- > From: Ji, Richard > Sent: Monday, September 30, 2002 12:08 PM > To: Multiple recipients of list ORACLE-L (E-mail) > Subject: urgent help: replication, shareplex > > Hi All, > > I needed some help here involving shareplex. > > We run two databases (an OLTP type, and a repository type) on the same > E10K domain > which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is > being used > to replicate a table from the OLTP type to the repository. The current > volume we are getting > is about 40 inserts per second to the OLTP. And at this rate shareplex is > lagging behind > doing the replication, for 24 hours now. And I see the shareplex process > running at 10% > while all Oracle processes are below 1% of the CPU. > > The situation is complicated, because it involves a hosting company. For > instance, I would > like to run the two databases on two separate domains but they chose not > to. So they > are blaming our application for doing commit on every insert being the > problem. I agree that > (and I will make the change) to commit every 1000 inserts or so. However, > I don't believe > that's the root of the problem. From what I understand, shareplex is log > based replication > and should not be as resource instensive. And 40 per/second isn't a huge > volume per se > and I am sure shareplex can handle a lot more than that. > > So any suggestions, feedbacks are welcome. > > Thanks > > Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
urgent help: replication, shareplex
Hi All, I needed some help here involving shareplex. We run two databases (an OLTP type, and a repository type) on the same E10K domain which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is being used to replicate a table from the OLTP type to the repository. The current volume we are getting is about 40 inserts per second to the OLTP. And at this rate shareplex is lagging behind doing the replication, for 24 hours now. And I see the shareplex process running at 10% while all Oracle processes are below 1% of the CPU. The situation is complicated, because it involves a hosting company. For instance, I would like to run the two databases on two separate domains but they chose not to. So they are blaming our application for doing commit on every insert being the problem. I agree that (and I will make the change) to commit every 1000 inserts or so. However, I don't believe that's the root of the problem. From what I understand, shareplex is log based replication and should not be as resource instensive. And 40 per/second isn't a huge volume per se and I am sure shareplex can handle a lot more than that. So any suggestions, feedbacks are welcome. Thanks Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC (Real Application Clusters)
Dennis, True, a 2/3 node clusters ain't that cheap. But to achieve high availability the other choice is to buy a high end server like Sun E10k or the newer ones. And I think the 2/3 node clusters are cheap compare to those big iron boxes and you get a very good availability and scalability from clusters. I think that's the selling point of RAC. You can cluster bunch of cheaper Intel based machines running Linux cluster and run RAC on it. Richard -Original Message- Sent: Thursday, September 26, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Glenn - I have a question you could ask. Oracle talks about how RAC will allow Oracle to make better use of cheap computers. To me the weak point is how much bandwidth you have between the nodes. If you have a gigabit fiber optic connection between the nodes, it might work well, but suppose you have a shared LAN? To me, RAC would work quite nicely in a clustered server, but then we've strolled away from cheap, haven't we? This point is keeping my hardware people from buying into the concept. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Thursday, September 26, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can you suggest some burning questions I can pose to Oracle when we get the demos? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recover an unrecoverable database
Correct me if I am wrong, I don't think anybody has a copy. Oracle will run it for you and bill you for it. -Original Message- Sent: Wednesday, September 11, 2002 8:53 PM To: Multiple recipients of list ORACLE-L If you can't recover it, Oracle has, or had, a utility called DUL (Data UnLoader ???) that will read the datafiles and create files usable by sqlldr. I haven't used it, but I heard about it several times. It's still urban legend until I get a copy :) Anybody have a copy I can borrow for AIX or NT??? Steve - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 5:54 PM > I have a colleague working the 'Official' approach with Oracle support. I am > not certain what he will learn nor how quickly, so I'm taking the shotgun > approach. > > Dan > > -Original Message- > Sent: Wednesday, September 11, 2002 3:26 PM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > > > Dan - May be a good Oracle Support question. I've had pretty good luck with > them on really challenging recoveries. My suggestion would be to try again. > Load the files again from tape, but allow recovery when the database comes > up. Since the database was shutdown abort, Oracle will want to automatically > recover the database when it tries to start. The recovery information is > probably in the redo logs (good reason to back them up). > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -Original Message- > Sent: Wednesday, September 11, 2002 5:19 PM > To: Multiple recipients of list ORACLE-L > > > Here's the scenario - A backup was done of a database that had been shutdown > with the abort option. The redo logs (no archiving) are also backed up. The > controlfiles have since been lost. > Business request - Retrieve a schema that has since been dropped from the > database. > > Attempted solution - restore the backups, open the db without performing > recovery (resetlogs and readonly corruption allowed). Unfortunately, this > resulted in an ORA-00600 when it attempted to read the SYSTEM datafile. > > Does anyone have any ideas of how to open this db so we can get the data out > of the schema? We don't care if it is not consistent. > > All assistance is appreciated. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Fink, Dan > 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: Steve Perry 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: Ji, 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).
RE: Oracle Version on Unix
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Misinformation Ranting
I feel your pain. I just got off a call which the hosting company blamed Solaris kernel panic on my "resource intensive query" that's doing the "full table scan". It turned out to be a NFS bug that's shown clearly in both core dumps. But NO, they don't trust the core dump, they think it's the query. Sigh. Richard Ji -Original Message- Sent: Tuesday, September 10, 2002 4:29 PM To: Multiple recipients of list ORACLE-L I've just spent 30 minutes with our SAP administrator trying to convince her that we really don't need to reorganize the tables in our production SAP database. Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' I think, she is equating number of extents with fragmentation. The text she referred me to is in fact discussing 'migrated rows' though that term is never used. She has become convinced that if the extents allocated for tables are not all in contigous space, some very nasty fragmentation will occur. I tried taking it down to disk and explaining that an OLTP system with hundreds of users won't really see much benefit from this, but she wasn't really ready for that. :) Her concern is that there are 29000 extents in an index tablespace. This might have something to do with there being 3400 indexes in said tablespace. Total 'wasted' ( honeycomb ) space in this 250 gig DB is < 20 meg. Not much to gain there. The text of the book states that you should expect a '10 to 20 percent performance increase' by reorganizing the tables/indexes. No data to back it up of course. This is on a database that performs very well most of the time, outside of a couple of custom reports that run too long. No complaints from users about slowness. Arrghhh! I just had to vent to the list, cuz there's no one here that understands. <\RANT> Jared -- 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: Ji, 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).
RE: Cursor : please help
What type of JDBC driver are u using? I haven't used 9i yet. But some 8i OCI drivers caches the cursor even if you close the ResultSet, Statement object. Thus you will see it increments. You will have to close the Connection object which is not good like your situation since you are pooling them. No to doubt your programming ability but you should also check to see how and where the ResultSet and Statement are closed. I have gone through codes that the developer claim that they closed everything, but if the statement is not at the right place, just having a closed statement doesn't necessarily means it will get closed. Richard Ji -Original Message- Sent: Tuesday, September 10, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Hi All, I ve a JSP application. Each time I query database ( oracle 9i) from the page, I see that the no.of cursors increments by one. I m accessing database using JDBC, I close resultset and statement objects after query. But I m not closing Connection object since I use a Connection Pool. Can anyone tell why the no,of cursors increasing each time ? Thanks in advance Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C 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: Ji, 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).
RE: 9ir2 Install on Linux
How about the oraInventory? -Original Message- Sent: Tuesday, September 10, 2002 12:18 PM To: Multiple recipients of list ORACLE-L I am attempting to install 9ir2 on a Red Hat 7.2 Linux box. Part way through the first attempt I decided to changed the Oracle home value. I stopped the install, deleted the previous Oracle home directory tree, built the new directory and restarted the install. Oracle has stored the value of the old Oracle home somewhere. The install is now crashing because the old Oracle home does not exist. Any idea where it is store and who owns the file? I have already deleted the install files in /tmp. The .bash_profile has the correct Oracle home. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: Ji, 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).
dbwr high count of threads
Hi all, I noticed the dbwr process on Solaris has a very high number of threads (258). To me this is not a problem since I am seeing this on my small development box too. But we recently had some server crash and the consultant is saying Oracle is consuming a lots of resource, citing the high number of Oracle thread count from the core dump analysis. I don't believe this lead to the crash because the core stack trace points to NFS calls in both times. However, I don't know how to explain the high number thread count mostly from the dbwr process. Is this normal? I mean, it looks like it's normal since I see this on all of my instances. How do I convince him that this is ok? Thanks for your help. Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Recreate database script
Yeah, you can use Visio. I used it when I need to quickly generate an ER diagram from a schema. -Original Message- Sent: Monday, September 09, 2002 1:09 PM To: Multiple recipients of list ORACLE-L > Could anyone here suggest a software package that can create an ER > diagram by simply connecting to an Oracle database, reverse engineer > it to see the schema in an ER diagram - instead of in a file with > ddl/dml statements. I haven't tested it, but Microsoft Visio 2000 claims to be able to reverse engineer a database. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Ji, 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).
RE: java stored procedures
Not saying it's a good thing to do. You mentioned thin driver doesn't work with MTS which is not true. Just want to point it out. Best Regards -Original Message- Sent: Thursday, September 05, 2002 5:39 PM To: Multiple recipients of list ORACLE-L >From aesthetic point of view, writing the whole TNS descriptor into the code is completely and utterly disgusting, something like mandatory cavity searches as a part of improved airport security. > -Original Message----- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 4:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > No, besides the hostname:sid:port syntax, you can also use > the long connect > string "jdbc:oracle:thin:@(description=(address=(host= ..." syntax. > > And it works with both MTS and dedicated server. > > Richard Ji > > -Original Message- > Sent: Thursday, September 05, 2002 3:24 PM > To: Multiple recipients of list ORACLE-L > > > Last time I checked, it was using the old SQL*Net 1.1 syntax, > namely hostname:sid:port and the server was always a dedicated > one, especially if the connection pooling was turned on. > > > -Original Message- > > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 1:29 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: java stored procedures > > > > > > >b) The thin driver can only use dedicated server connection > > which does > > >miracles for load balancing. > > > > Where did you get that? Thin driver works with MTS. There are > > configuration > > issues working with MTS that only thin driver encounters. > > > > Richard Ji > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ji, 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: Gogala, Mladen > 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: Ji, 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: Gogala, Mladen 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: Ji, Richard INET: [EMAIL PROTECTED] Fat City Netwo
RE: java stored procedures
No, besides the hostname:sid:port syntax, you can also use the long connect string "jdbc:oracle:thin:@(description=(address=(host= ..." syntax. And it works with both MTS and dedicated server. Richard Ji -Original Message- Sent: Thursday, September 05, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. > -Original Message----- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > >b) The thin driver can only use dedicated server connection > which does > >miracles for load balancing. > > Where did you get that? Thin driver works with MTS. There are > configuration > issues working with MTS that only thin driver encounters. > > Richard Ji > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, 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: Gogala, Mladen 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: Ji, 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).
RE: java stored procedures
>b) The thin driver can only use dedicated server connection which does >miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: ssh client for Windoze
SecureCRT is good. You can also check out putty (free) as your SSH client. I am happy with both. -Original Message- Sent: Wednesday, September 04, 2002 1:24 PM To: Multiple recipients of list ORACLE-L > Has anyone used an Windows ssh client in a large environment (50 +/- > Unix servers, 300+ instances) that they would recommend? SecureCRT at http://www.vandyke.com. $50.00/license for 200 to 499 users. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Ji, 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).
RE: SQL*Plus in 10i
No it doesn't. oradim is used to create/start/stop oracle services. There is no such thing as NT services on Unix. -Original Message- Sent: Friday, August 30, 2002 10:23 PM To: Multiple recipients of list ORACLE-L does oradim work in Unix boxes? I've never used it And it took a LOT of releases and warnings before they got rid of svrmgr.. they started saying it was going away in version 7 I believe. --- ltiu <[EMAIL PROTECTED]> wrote: > oradim -startup -sid -pfile ??? > > They got rid of SVRMGR. > > ltiu > > On Friday 30 August 2002 11:08, you wrote: > > How do they expect you to start and stop the database if it goes > away? > > and please don't say OEM... > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > RF > > > > > > Robert G. Freeman - Oracle OCP > > > Oracle Database Architect > > > CSX Midtier Database Administration > > > Author > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > Oracle9i New Features (Oracle Press) > > > Mastering Oracle8i (Sybex) > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Freeman, Robert > > > 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!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > -- > 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). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: woo hoo
Congratulations! Richard Ji -Original Message- Sent: Friday, August 30, 2002 10:18 PM To: Multiple recipients of list ORACLE-L MY SISTER IS PREGNANT!!! Early days yet, and she will be very very very careful for a long time yet but she's pregnant! Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: TOAD ?
Are u running into a specific problem or you just don't know how to set it up? -Original Message- Sent: Friday, August 30, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.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: Ji, 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).
RE: working with datafile > 2Gb in HadHat 7.3
Nope. -Original Message- Sent: Thursday, August 29, 2002 7:47 PM To: Multiple recipients of list ORACLE-L If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: >There is no such hardware limitation like that. Those are the OS i.e. >software limitations. For instance, the 2gb file size limit is because of >the >32 bit OS, actually, to be more specific, it's the 32 bit file system. >You can have a 32bit OS kernel, but if your file system supports 64bit, then >you can support >2gb files. Same thing for the memory. > >Richard Ji > >-Original Message- >Sent: Thursday, August 29, 2002 5:59 PM >To: Multiple recipients of list ORACLE-L > > >OK. I stand corrected. You do need third party tools though. But I >suppose engineers can always hack their way through hardware limitations >to make thing work. Like the >4GB memory limit of intels - this is not >more since I believe Windows 2K and XP have this feature(in software?) >where it can access greater than 4GB memory.. > >Philip Douglass wrote: > > > >>Uh... don't think so! -- we're running UnixWare 7 on Intel hardware >>(Xeons) and large file support is a matter of enabling the largefiles >>option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig >>datafiles because it seems foolhardy to me to use >2Gig datafiles unless >>you have an obvious need for them. And if you do, then test it a lot! And >>make sure all of your programs support large files too (some versions of >>tar/cpio/gzip don't) >> >>-- Philip >> >>- Original Message - >>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >>Sent: Thursday, August 29, 2002 2:43 PM >> >> >>It doesn't really matter what OS you have. Intel hardware can only >>handle 2Gb files sizes max. Even if the hardware can support large >>files, it is still recommended that you do not have large datafiles. You >>need to partition your tablespaces into multiple datafiles. This >>facilitates backups and restores and you can put the datafiles into >>different hard drives increasing i/o performance. >> >>ltiu >> >>Adriano Freire wrote: >> >> >> >> >> >>>Ok ltiu, >>>REDHAT 7.3 kernel-2.4.18-10 >>> >>>- Original Message - >>>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >>>Sent: Thursday, August 29, 2002 1:18 PM >>> >>> >>> >>> >>> >>> >>> >>> >>>>What's HadHat 7.3? >>>> >>>>A new Linux distro pattered after RedHat 7.3? >>>> >>>>ltiu >>>> >>>>Adriano Freire wrote: >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>>>Gurus, >>>>> >>>>>I've some problems with datafiles > 2Gb in HadHat 7.3. I'm using >>>>>datafile type ext3 and >>>>>when i try create a datafile with 2Gb the database is catching. >>>>>Anybody have the some problem? >>>>>any suggestion? >>>>> >>>>>Thanks >>>>> >>>>>Adriano. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>-- >>>>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). >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >>> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: ltiu >> INET: [EMAIL PROTECTED] >> &
RE: SQL*Plus in 10i
Are you kidding? So what do we use to startup and shutdown db? OEM? I don't think there is any truth to this one. Richard -Original Message- Sent: Friday, August 30, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ji, 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).
RE: proc. being exeucted from open_cursors
That's because it's 120 open cursors per session. So when you have multiple sessions, you will see the total from v$open_cursor greater than 120. v$open_cursor doesn't always tell u exactally the number of open cursors that's counting toward the limit. It's better to check v$sesstat for statistic#=3. Richard Ji -Original Message- Sent: Friday, August 30, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Hi all, DB: 817 can somebody tell me how to find out whether a package/procedure being executed. I checked v$open_cursor.sql_text. But similar text is existing in multiple procedures. from where can I get a particular procedure being executed ? 1 more Q: In one of the production instances open_cursors values is 120. But when I checked from v$open_cursor there are more than 120 existing. I checked distinct sid and distinct hash_value. am I missing something in my select statement, to get exact open_cursors. can somebody through somelight on this. thanx in advance, srinivas __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa 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: Ji, 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).
RE: basic Unix question ???
try: uname -a for version information. ksh is usually under /usr/bin/ksh Not every Unix comes with top, you will have to install it. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 7:10 PM To: Multiple recipients of list ORACLE-L Hi all, I have two questions. First, how to find out information about my unix box, like version, etc. In my box, I can use hostname to get the machine name. I remember there is a command called version, but I got "Ksh: version: not found." Any other useful commands to know about my machine? Actually when I use top, it also returns "ksh: top: not found." My second question is where does ksh usually reside, which value should I set for PATH. Thank you in advance. Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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: Ji, 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).
RE: Select count(name) from table group by name where count(name)
You use "having count(name)=1" instead of "where count(name)=1". -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about "distinct" and "unique", but this is not what I want. All I want is to be able to fish out the names of the people who have only one and exactly only one entry in the list. I do not want the names of those people who have more than one entry in the list. Could one of you do me a huge favor give me some hints as to how to contruct the select statement for this. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: working with datafile > 2Gb in HadHat 7.3
There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support >2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the >4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: >Uh... don't think so! -- we're running UnixWare 7 on Intel hardware >(Xeons) and large file support is a matter of enabling the largefiles >option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig >datafiles because it seems foolhardy to me to use >2Gig datafiles unless >you have an obvious need for them. And if you do, then test it a lot! And >make sure all of your programs support large files too (some versions of >tar/cpio/gzip don't) > >-- Philip > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, August 29, 2002 2:43 PM > > >It doesn't really matter what OS you have. Intel hardware can only >handle 2Gb files sizes max. Even if the hardware can support large >files, it is still recommended that you do not have large datafiles. You >need to partition your tablespaces into multiple datafiles. This >facilitates backups and restores and you can put the datafiles into >different hard drives increasing i/o performance. > >ltiu > >Adriano Freire wrote: > > > >>Ok ltiu, >>REDHAT 7.3 kernel-2.4.18-10 >> >>- Original Message - >>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >>Sent: Thursday, August 29, 2002 1:18 PM >> >> >> >> >> >> >>>What's HadHat 7.3? >>> >>>A new Linux distro pattered after RedHat 7.3? >>> >>>ltiu >>> >>>Adriano Freire wrote: >>> >>> >>> >>> >>> >>>>Gurus, >>>> >>>>I've some problems with datafiles > 2Gb in HadHat 7.3. I'm using >>>>datafile type ext3 and >>>>when i try create a datafile with 2Gb the database is catching. >>>>Anybody have the some problem? >>>>any suggestion? >>>> >>>>Thanks >>>> >>>>Adriano. >>>> >>>> >>>> >>>> >>>-- >>>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). >>> >>> >>> >>> >> >> >> >> > > > >-- >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). > > > > -- 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 --
RE: ROWNUM strangeness?
Hi Paul, How's going? Maybe there are other criteria's that limits the result set to only return 24 rows? Richard Ji -Original Message- Sent: Thursday, August 29, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM < n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM < 50, the query returns 24 rows. If we add WHERE ROWNUM < 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM < 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Ji, 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).
RE: Fail Over Options
___ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: DENNIS WILLIAMS 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: Ji, 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).
RE: Fail Over Options
Peter, That sounds pretty strange that they only support thin but not the OCI driver. Anyhow, the bottom of this page seems to have OCI on the support list. http://www-3.ibm.com/software/webservers/appserv/doc/v35/java.htm Richard Ji -Original Message- Sent: Tuesday, August 27, 2002 6:49 PM To: Multiple recipients of list ORACLE-L Dennis, This is a auite of products. The prime offender is WebSphere, an IBM product. The IBM consultants have been particularly difficult to deal with. According to them, nothing Oracle ever produced works. The project specifications call for transparent fail over which is possible using Oracle's thick client. Unfortunately, WebSphere does not seem to be able to use anything but jdbc thin client. If we can't get this to work, we will likely go to something like Veritas Cluster Server. Replication provided a solution that had already paid for. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Peter - Have you looked at Oracle Standby Server? > Which App server are you > using? Most of them claim to help you with this. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, August 27, 2002 3:38 PM > To: Multiple recipients of list ORACLE-L > > > We are looking at fail over options for databases in > a > 7x24 e-commerce environment. > > Currently, we are using advanced replication. It > works but it is labor intensive. We have also > discovered that the application can only use jdbc > rather than the Oracle thick client. In essence, > this > replication is now manual fail over. > > Would someone who has made java and the thick client > work provide some pointers to getting it to work? > > > Thanks, > > > > = > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Peter Barnett > 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: DENNIS WILLIAMS > 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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: Ji, 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).
RE: Fail Over Options
>We have also discovered that the application can only use jdbc >rather than the Oracle thick client. Can you explain it in a little detail? Do you mean you can only use JDBC Thin but not JDBC OCI? What do u mean by you can only use jdbc rather than the Oracle thick client? Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Out of Memory
Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL> startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Hot Backup using EMC /BCV splits
Maybe my knowledge on EMC/BCV is outdated. But as I remember, for Hotbackup you don't split BCV for control files and online redo logs as they are not useable. Richard -Original Message- Sent: Thursday, August 15, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Yes, BCV is also split for control file and online redo logs. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:58 AM > You are right that the BCV split should occur at step 2. > Ask him what's the point for step 1 - 3 if he split BCV at step 4. > > Is he also splitting the BCV for control file and online redo logs? > > Richard > > -Original Message- > Sent: Thursday, August 15, 2002 10:59 AM > To: Multiple recipients of list ORACLE-L > > > Hello, > > We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the > backups for the database in following sequence to do the Hot backup. > > 1. Put all tablespaces in the database in Hot backup mode > 2. Sleep 5 > 3. Put all the tablespaces back into normal mode > 4. Split the BCV's > 5. Mount on another machine and backed up from it. > > What I am concerned is with step 4. Split BCV's should be done at step 2 > instead of step 4. > According to our Unix Admin, EMC takes care of consistency and there is no > need for any concern. As per him the split is instant split and EMC > guarantees consistency. > > What do you all think. What is the recommended procedure. > > TIA, > > Nate > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nat > 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: Ji, 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: Nat 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: Ji, 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).
RE: Hot Backup using EMC /BCV splits
You are right that the BCV split should occur at step 2. Ask him what's the point for step 1 - 3 if he split BCV at step 4. Is he also splitting the BCV for control file and online redo logs? Richard -Original Message- Sent: Thursday, August 15, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Ji, 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).
RE: Apple rack-mounted servers
When Larry tried the Network Computer concept again a couple of years ago, they switched to Linux, StarOffice etc instead of the FreeBSD, NetBSD, Oracle's own HatTrick Office Suite. Richard -Original Message- Sent: Tuesday, August 13, 2002 3:44 PM To: Multiple recipients of list ORACLE-L First? Are you implying the next generation will be something else? Just curious. I believe Apple's decision to go with UNIX is an excellent one. For once, I am tempted to buy an Apple. And after all these years Apple's graphics are still better then MSs. -Original Message- Sent: Tuesday, August 13, 2002 3:29 PM To: Multiple recipients of list ORACLE-L The first generation of Oracle's Network Computer are based on FreeBSD and NetBSD. Richard -Original Message- Sent: Tuesday, August 13, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Yes, FreeBSD... Since when do Oracle products work on FreeBSD? -Joe --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > It is based on some *NIX variant...was it FreeBSD? __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Ji, 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: Grabowy, Chris 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: Ji, 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).
RE: Apple rack-mounted servers
The first generation of Oracle's Network Computer are based on FreeBSD and NetBSD. Richard -Original Message- Sent: Tuesday, August 13, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Yes, FreeBSD... Since when do Oracle products work on FreeBSD? -Joe --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > It is based on some *NIX variant...was it FreeBSD? __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Ji, 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).
RE: Cache' Database
Title: Cache' Database Ivan, Please search the archive of this list. I have post a question about cache before and got some good replies. Richard -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Cache' Database Hello all, I am getting a new contract that will be dealing solely with cache database management. Does anyone out there have any experiences with cache that they wouldn't mind sharing? Pro's and con's, good stories, horror stories anything and everything is welcomed. I'd like to see what other oracle dba's have thought about it. I also would like to know if there are any list groups like this for Cache and/or any good websites besides the intersystems site? Thank you all very much. Ivan
RE: Transferring data from one table to another
r: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Oracle 9i, tomcat
Joshy, In some versions of 8i there were bug related to OCI driver where closing Statements and ResultSet aren't enough, you have to close Connection which is obviously not good for connection pooling. Not sure if 9i could have this problem too. Also, check on how you close the Statements and ResultSets. Are they closed in the Finally clause so no matter what happens they get closed. And I have found out people claim to close them but close it the wrong way. i.e. after ResultSet rs gets reassigned they tried to close it. Richard Ji -Original Message- Sent: Wednesday, July 31, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Hi Neyman, Thanks for your quick response. I use connection pool. Initially it makes 25 connection objects and put in the pool and they are reused. Not closed. But I close prep statements and resultset after using it, but to no avail. Any idea? Thanks Joshy -Original Message- Sent: Wednesday, July 31, 2002 10:04 PM To: Multiple recipients of list ORACLE-L Most probably, it's not Oracle, it's your application, that does not allow oracle to release memory. Are you closing your connections properly? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 11:33 AM > Hi All, > > Can anyone help me. This is very urgent. > > I have a ticker application written in Java, that accesses oracle 9i > database in Linux. It gets data from database in every 2 minutes. When as > many as 10 ticker clients are accessing database together for 30 minutes, > oracle eventually dies. > > Ticker gets data from database thru Tomcat, on examination I found that each > time memory utilization for Oracle increases with database access. It starts > with 5% mem utilizations and increases - in every 2 minutes - 6%, 7% etc, > for each database access from clients. When it reaches some 30% oracle slows > down and ticker apllication also slows down. > > Does anyone of you have a quick solution - Also why oracle not relasing > memory after database access ? > > Thanks in Advance > Joshy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: JOSHY MON M C > 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: Igor Neyman 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: JOSHY MON M C 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: Ji, 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).
RE: GZip/WinZip...hot backups...
You are welcome. :) -Original Message- Sent: Thursday, July 18, 2002 10:28 AM To: Multiple recipients of list ORACLE-L My humble apologies to the list... He checked the backup script... host gzip -cf1 /disk2/oradata/rcdc/system.dbf > /disk1/orabkup/rcdc/system.gz Good call Richard... There was a junior DBA that he was training that had setup the backup script. Oh well. Sorry for wasting everyone's time. A beer for everyone at the next IOUG...Jared is buying -Original Message- Sent: Wednesday, July 17, 2002 3:24 PM To: Multiple recipients of list ORACLE-L A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: Ji, 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).
RE: GZip/WinZip...hot backups...
If you gzip a .dbf file, you get .dbf.gz extension. Is that what he was doing? What's the full filename after gzipped? Richard -Original Message- Sent: Wednesday, July 17, 2002 3:24 PM To: Multiple recipients of list ORACLE-L A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Ji, 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).
RE: a couple of questions
No problem running 64bit Oracle on 64bit Solaris so far. But 64 bit has it's own set of bugs from 32 bit. I am sure you will test it before deployment. :) Richard Ji -Original Message- Sent: Wednesday, July 17, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but first: has anyone heard of any problems with 64-bit Oracle on a Solaris 64-bit OS? second (and this one confuses me a bit)... I've been asked if Oracle9i supports a "variant" datatype -- they are not familiar with oracle but are familiar with SQL Server and say that there is a datatype called "variant" there where you can basically overload the column with whatever datatype you want (string, number, date) and the database knows what type of data it is storing within the column. They referred me to C++ and Java, neither of which I know. Can anyone point in the right direction to start researching this? Thanks! Rachel __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: (Fwd/2)
>There are those that argue Apple provided competition >to Microsoft. Not very good competition, but competition >nonetheless and so the monopoly argument goes out >the window. Only because years ago, MS put money in it (100 mill?) and promised to port MS Office and IE to Mac to keep it alive, so there appears to be competition. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: RE: a couple of questions
Some times I get a thin CD pack which only has 32bit. I will have to ask Oracle to ship me the 64bit version. -Original Message- Sent: Wednesday, July 17, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Dennis, I'm not sure your referring to the message I posted a couple of weeks ago, but the labeling on the CD's from Oracle can be deceiving. Each CD pack ships with both the 32 and 64 bit versions of Oracle, one of which is labeled with the bit value). Make sure you've got the right one. If memory is serving correctly 'variant' in MicroSlop maps somewhat to raw in Oracle. Dick Goulet Reply Separator Author: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 7/17/2002 9:33 AM Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far, but not much mileage on either. The one thing that came up is that you must be careful because you seem to get 32-bit Oracle by default. Someone on this list suggested running "file oracle". Oracle does have user-defined data types if that helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 17, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but first: has anyone heard of any problems with 64-bit Oracle on a Solaris 64-bit OS? second (and this one confuses me a bit)... I've been asked if Oracle9i supports a "variant" datatype -- they are not familiar with oracle but are familiar with SQL Server and say that there is a datatype called "variant" there where you can basically overload the column with whatever datatype you want (string, number, date) and the database knows what type of data it is storing within the column. They referred me to C++ and Java, neither of which I know. Can anyone point in the right direction to start researching this? Thanks! Rachel __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Ji, 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).
RE: a couple of questions
How do u get 32 bit by default? The 32bit and 64bit Oracle came as separate CDs. Am I missing something? Richard -Original Message- Sent: Wednesday, July 17, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far, but not much mileage on either. The one thing that came up is that you must be careful because you seem to get 32-bit Oracle by default. Someone on this list suggested running "file oracle". Oracle does have user-defined data types if that helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 17, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but first: has anyone heard of any problems with 64-bit Oracle on a Solaris 64-bit OS? second (and this one confuses me a bit)... I've been asked if Oracle9i supports a "variant" datatype -- they are not familiar with oracle but are familiar with SQL Server and say that there is a datatype called "variant" there where you can basically overload the column with whatever datatype you want (string, number, date) and the database knows what type of data it is storing within the column. They referred me to C++ and Java, neither of which I know. Can anyone point in the right direction to start researching this? Thanks! Rachel __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Ji, 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).
RE: killing sessions
You can write a stored procedure that does the kill of a session and grant them execute only privilege to the stored procedure. -Original Message- Sent: Thursday, July 11, 2002 2:51 PM To: Multiple recipients of list ORACLE-L We have developers who occassionally want to be able to kill their sessions in a dev instance. We are concerned about giving them alter system priviledge and were wondering what people do about this. Is there any other way they can do this? Do some shops allow certain users to do this with some training? Thanks. Joe [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Armstrong-Champ 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: Ji, 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).
RE: runInstaller
- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > === > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ray Stell > > 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: Grabowy, Chris > 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: Yechiel Adar 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: Grabowy, Chris 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: Ji, 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).
RE: runInstaller
PROTECTED] (note EXACT spelling of 'ListGuru') > and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You > may > > > > also send the HELP command for other information (like > subscribing). > > > > > > -- > > > === > > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Ray Stell > > > 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: Grabowy, Chris > > 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: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > === message truncated === __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: table size.
500 mill? How did you do your export? Try compress=n -Original Message- Sent: Monday, July 08, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both table is the same: pct10,pctused 40. any idea. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: Ji, 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).
RE: JDBC
Stefan, Agreed. I am merely pointing out one can call anonymous block. Packages is the way to do it. Richard -Original Message- Sent: Monday, July 08, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Hi Richard You can do that. But I think it is recommandable to wrap up the PL/SQL and put it into packages. This way, your code is much better organized than having anonymous blocks throughout your Java code. Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: Ji, Richard [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 8. Juli 2002 17:38 An: Multiple recipients of list ORACLE-L Betreff: RE: JDBC Maybe I misunderstood what you guys are talking about. And sorry if that's the case. But you can call anonymous block and return data from Oracle to Java: CallableStatement stmt = conn.prepareCall( "begin " + "open ? for select ename from emp;" + "end;"); stmt.registerOutParameter(1,OracleTypes.CURSOR); stmt.execute(); Richard -Original Message- Sent: Monday, July 08, 2002 6:23 AM To: Multiple recipients of list ORACLE-L Hi Antje Eventhough I never migrated Sybase (or SQL Server) code (JDBC/Java) to Oracle, maybe that helps anyway: In Transact SQL, you can actually return data from an anonymous block, that's correct. An equivalent to do this in PL/SQL might be the use of OUT parameters within stored procedures. That means that you just have to write wrappers for your T-SQL blocks (put them into PL/SQL stored procs). Done that, you can communicate from Java with the procedure through the OUT parameter, once you registered the proc with it's OUT parameters within the Java context. After binding the parameter to Java variables, the data will be transferred to those variables (when the proc is executed) for your further use within the Java context. Nothing new, actually. A problem might be the syntactical difference between T-SQL and PL/SQL, eventhough Oracle is able to handle more of the syntax you encounter in T-SQL like CASE or ANSI SQL joins. Hope that helps a little bit. If not, pipe it to /dev/null ;) Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73! Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Sackwitz, Antje [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 5. Juli 2002 17:13 An: Multiple recipients of list ORACLE-L Betreff: JDBC Hi, gurus, collegues of mine told me, that Sybase can return information from anonymous blocks. When I do not want to use SQLJ, but only JDBC what is the best way to migrate the Sybase code to Oracle. Any tips appreciated, Regards, Antje Sackwitz Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
RE: JDBC
Maybe I misunderstood what you guys are talking about. And sorry if that's the case. But you can call anonymous block and return data from Oracle to Java: CallableStatement stmt = conn.prepareCall( "begin " + "open ? for select ename from emp;" + "end;"); stmt.registerOutParameter(1,OracleTypes.CURSOR); stmt.execute(); Richard -Original Message- Sent: Monday, July 08, 2002 6:23 AM To: Multiple recipients of list ORACLE-L Hi Antje Eventhough I never migrated Sybase (or SQL Server) code (JDBC/Java) to Oracle, maybe that helps anyway: In Transact SQL, you can actually return data from an anonymous block, that's correct. An equivalent to do this in PL/SQL might be the use of OUT parameters within stored procedures. That means that you just have to write wrappers for your T-SQL blocks (put them into PL/SQL stored procs). Done that, you can communicate from Java with the procedure through the OUT parameter, once you registered the proc with it's OUT parameters within the Java context. After binding the parameter to Java variables, the data will be transferred to those variables (when the proc is executed) for your further use within the Java context. Nothing new, actually. A problem might be the syntactical difference between T-SQL and PL/SQL, eventhough Oracle is able to handle more of the syntax you encounter in T-SQL like CASE or ANSI SQL joins. Hope that helps a little bit. If not, pipe it to /dev/null ;) Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73! Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Sackwitz, Antje [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 5. Juli 2002 17:13 An: Multiple recipients of list ORACLE-L Betreff: JDBC Hi, gurus, collegues of mine told me, that Sybase can return information from anonymous blocks. When I do not want to use SQLJ, but only JDBC what is the best way to migrate the Sybase code to Oracle. Any tips appreciated, Regards, Antje Sackwitz Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: Stefan Jahnke 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: Ji, 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:
RE: HELP! ora-12560 ???
How about sqlplus? Does it give you the same error? -Original Message- Sent: Wednesday, July 03, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Hi, I believe this has been posted many times, well, I cannot fix it, and metalink doesn't help. I got ora-12560 for a 817 database on Win2000. H:\>set ORACLE_SID=dlylastg (SID set correctly) H:\>svrmgrl ORA-12560: TNS:protocol adapter error SVRMGR> Any suggestion? Thank you! Leslie __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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: Ji, 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).
RE: Count rows in textfile
Title: RE: Count rows in textfile He is probably on holiday already. :) -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 03, 2002 5:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Count rows in textfile I guess, Jared allows this thread to continue only because it's pre-holiday :-) Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 03, 2002 4:49 PM Subject: RE: Count rows in textfile Something like Schrodinger's Cat! Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Fink, Dan [SMTP:[EMAIL PROTECTED]] We are all missing the point. Without opening the file, it must be observed from the outside. As such, from this observation point, it contains no rows. Thus, the method is irrelevant as the answer will always be 'NONE'. -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]] If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem. Jerry WhittleACIFICS DBANCI Information Systems Inc.[EMAIL PROTECTED]618-622-4145 -Original Message-From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] gee, for simplicity's sake, I usually just count tails :) --- Tim Gorman <[EMAIL PROTECTED]> wrote:> Count the eyes and divide by 2...>> - Original Message -> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>>> > Roland,> >> > How about counting black cats in the dark room without turning on> the light?> >> > Igor Neyman, OCP DBA> > [EMAIL PROTECTED]> >> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> >> > > Anyone whom has a good example on how to check "how many rows> (without opening the file) does a text file consists of?> > > What is the command?> > >> > > Thanks in advance> > >> > > Roland
RE: Count rows in textfile
You are assuming: 1) All cats are looking at you. 2) They all sitting still. 3) None of them are alseep. :) -Original Message- Sent: Wednesday, July 03, 2002 1:33 PM To: Multiple recipients of list ORACLE-L > How about counting black cats in the dark room without turning on the light? You'll probobly see the reflextions of the cats eyes, even in the dark. 1) Count the number of eyes you see. 2) Divide that number in two. Very easy. :) -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= 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: Ji, 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).
RE: RE: WebLogic, Oracle JDBC related
UNSUB ORACLE-L > >>(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: Warren Lindsey > 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: Molina, Gerardo > 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: Brian McGraw > 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: Ji, 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: 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: Ji, 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).
RE: the ora certified masters cert, yet again
eir next position and were > forced > to settle for a less-attractive job because of it. > > Dennis Williams > DBA, 20% OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -Original Message- > Sent: Tuesday, June 25, 2002 10:09 AM > To: Multiple recipients of list ORACLE-L > > > okay, I realize this won't work for everyone on this list but... > > I hand them my resume. the third page of which is FILLED with lists > of > presentations I have given, awards I have gotten for presentations I > have given and books I have written > > if they STILL want me to have OCP on my resume after that, I don't > want > to work there anyway > > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > The question is, are you going to allow your > > clearminded moral stance and total disdain for a > > thinly veiled DBA tax to interfere with your pursuit > > of filth lucre? *I* ain't! > > > > ;) > > > > It is just another hoop to jump through so that a > > hring manager can say "that is an impressive hoop you > > jumped through" and you can respond "yes, and I can > > jump through some hoops for you too" and allow them to > > say "here is an outrageous sum of money to work on our > > computers." > > > > I love this job. > > > > jack silvey > > ocp 7.3, 8.0, 8i, 9i > > > > > > --- Don Granaman <[EMAIL PROTECTED]> wrote: > > > They aren't - unless it exceeds a non-trivial > > > percentage (6%? 7%? more? I > > > can't remember now...) of their income and is > > > "required" (?). > > > > > > This new requirement for OCP is just another in a > > > long line of > > > propaganda/baloney from Oracle in its never-ending > > > attempts to suck up every > > > buck it possibly can. [Oracle likes $. HR > > > likes mindless checklist > > > items. It is a match made in heaven.] I thought > > > that the "need practically > > > any two ILT classes, no matter how irrelevant" 9i > > > OCM was going to be the > > > limit of extending the the greedy grab for OCP bucks > > > - for 9i at least. > > > This isn't about certification anymore (as if it > > > ever was), its about > > > revenue. > > > > > > Since this "new requirement" (for the moment at > > > least) doesn't apply to > > > upgrade from an 8i certification, does anyone know > > > if there is (or soon will > > > be) a new constraint/surprise/ambush limiting that > > > to 8i OCP obtained prior > > > to, oh say, June 15, 2002? September 2002? > > > > > > Don Granaman > > > [OraSaurus - with more disdain than ever for the > > > evil vampire Larry's OCP > > > DBA tax] > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" > > > <[EMAIL PROTECTED]> > > > Sent: Friday, June 21, 2002 12:23 AM > > > > > > > > > > I thought employees were not allowed to write > > > things off as business > > > > expenses... > > > > > > > > Confusedly yours, > > > > Patrice Boivin > > > > Systems Analyst (Oracle Certified DBA) > > > > > > > > -Original Message- > > > > Sent: Thursday, June 20, 2002 10:13 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: the ora certified masters cert, yet > > > again > > > > > > > > Are you trying to promote it? > > > > > > > > -Original Message- > > > > Sent: Thursday, June 20, 2002 6:50 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > I am seriously considering pursuing one, since it > > > can > > > > be sold to hiring managers as a sign of > > > professional > > > > competence. > > > > > > > > Look at it from a cost/benefit ratio standpoint. > > > Will > > > > someone with this cerifification make $2000 more > > > over > > > > her professional life than she would without? > > > > > > > > So it takes a round trip ticket and three days of > > > > vacation. Get the company to pay for it or write > > > it > > > > off as
RE: Unix related - need some info
On Solaris ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM -opmem,pcpu,user,args use: psrinfo -v prtconf | grep Mem format uname -a HTH Richard -Original Message- Sent: Saturday, June 22, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by "ps", but what aditional parameters I have to provide? At a first glance, output of "man ps" vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: Ji, 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).
RE: 8.1.7.4 patch for Linux
Good catch. That was the problem. Thanks a lot.
-Original Message-
Sent: Friday, June 21, 2002 2:32 PM
To: Multiple recipients of list ORACLE-L
Richard,
The glibc patch has to be applied during every patchset application as the
patchset may overwrite the relinking makefiles.
Alessandro Guimarães
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 10:57 AM
> After installing the patch, Oracle ask you to put
> _system_trig_enabled=false in your init.ora
> before you run catalog catproc etc.
>
> I took it out and still have the problem.
>
> I also compared the init parameter values in alerg.log
> before and after applying the patch. Nothing's changed.
>
> I even tried to create a new instance with only 15mb SGA
> and still won't startup nomount.
>
> I traced the startup, and saw pmon comes up and goes down.
> Found this message though:
>
> 1272 open("/dev/null", O_RDONLY) = 2
> 1272 dup(2)= 13
> 1272 setsid() = -1 EPERM (Operation not
permitted)
> 1272 chdir("/d00/app/oracle/product/8.1.7/dbs") = 0
> 1272 shmget(2567278436, 0, 0) = 163841
> 1272 shmctl(163841, SHM_LOCK, 0) = -1 EPERM (Operation not
permitted)
> 1272 SYS_199(0x404f4828, 0x1, 0x404f54a0, 0x28001, 0x404f2fd0) = 59
> 1272 shmctl(163841, 0x102 /* SHM_??? */, 0xbfffd54c) = 0
> 1272 --- SIGSEGV (Segmentation fault) ---
>
> It then left the shared memory segment and semaphores which I
> have to manually remove.
>
> -Original Message-
> Sent: Friday, June 21, 2002 12:31 PM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
>
>
> Unless I am having a senior moment, won't Oracle put some changes into
your
> init.ora file for you when installing/upgrading Oracle 8i. I am sure I was
> bitten with this a few months back. Get a copy of your old init.ora file
(if
> you have it )or at least check through you init.ora file for a comment
line
> saying "line inserted by Oracle Installer" or something like that.
>
> Then again I could be talking c**p
>
> HTH
>
> Lee
>
> -Original Message-
> Sent: 21 June 2002 18:07
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all,
>
> Anyone patched their Oracle on Linux with 8.1.7.4 patch?
> I patched my 8.1.7.0.0 on SuSE 7.2 to 8.1.7.4 and can't startup
> the database anymore.
>
> Keep getting ORA-24323 but I didn't change anything in my init.ora file.
>
> Richard
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ji, 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).
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ji, 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: Alessandro Guimaraes
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
RE: 8.1.7.4 patch for Linux
After installing the patch, Oracle ask you to put
_system_trig_enabled=false in your init.ora
before you run catalog catproc etc.
I took it out and still have the problem.
I also compared the init parameter values in alerg.log
before and after applying the patch. Nothing's changed.
I even tried to create a new instance with only 15mb SGA
and still won't startup nomount.
I traced the startup, and saw pmon comes up and goes down.
Found this message though:
1272 open("/dev/null", O_RDONLY) = 2
1272 dup(2)= 13
1272 setsid() = -1 EPERM (Operation not permitted)
1272 chdir("/d00/app/oracle/product/8.1.7/dbs") = 0
1272 shmget(2567278436, 0, 0) = 163841
1272 shmctl(163841, SHM_LOCK, 0) = -1 EPERM (Operation not permitted)
1272 SYS_199(0x404f4828, 0x1, 0x404f54a0, 0x28001, 0x404f2fd0) = 59
1272 shmctl(163841, 0x102 /* SHM_??? */, 0xbfffd54c) = 0
1272 --- SIGSEGV (Segmentation fault) ---
It then left the shared memory segment and semaphores which I
have to manually remove.
-Original Message-
Sent: Friday, June 21, 2002 12:31 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Unless I am having a senior moment, won't Oracle put some changes into your
init.ora file for you when installing/upgrading Oracle 8i. I am sure I was
bitten with this a few months back. Get a copy of your old init.ora file (if
you have it )or at least check through you init.ora file for a comment line
saying "line inserted by Oracle Installer" or something like that.
Then again I could be talking c**p
HTH
Lee
-Original Message-
Sent: 21 June 2002 18:07
To: Multiple recipients of list ORACLE-L
Hi all,
Anyone patched their Oracle on Linux with 8.1.7.4 patch?
I patched my 8.1.7.0.0 on SuSE 7.2 to 8.1.7.4 and can't startup
the database anymore.
Keep getting ORA-24323 but I didn't change anything in my init.ora file.
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ji, 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).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ji, 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).
8.1.7.4 patch for Linux
Hi all, Anyone patched their Oracle on Linux with 8.1.7.4 patch? I patched my 8.1.7.0.0 on SuSE 7.2 to 8.1.7.4 and can't startup the database anymore. Keep getting ORA-24323 but I didn't change anything in my init.ora file. Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Something that may be of interest
Well, you could run Linux as the primary OS and use VMware for Linux to run Outlook/Exchange and other Windows only app. I am currently doing the same thing as you do, but I am thinking about doing the above. -Original Message- Sent: Tuesday, June 18, 2002 1:19 PM To: Multiple recipients of list ORACLE-L I run Linux on the laptop using VMware. Works great but I still have Win2K as the primary O/S. The only thing keeping me enslaved the the MS Monopolistic Meast is a dependence on Outlook/Exchange. Since Lindows claims to be able to run Outlook my interest is piqued. Oh yeah, another dependence on the MacroHard Monopolistic Beast is IE because they stole and now own the browser that many web apps support exclusively. Sigh... -Original Message- Sent: Monday, June 17, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Jared & All, My apologies for posting something that is a little off topic, but at least I'm short on words. Check out <http://lindows.com/walmart>. Now I wonder when we'll have an Oracle client for this?? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Ji, 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).
RE: Erwin - Does this thing work?
In our case, we had to add the following: In Windows settings, control panel, system, advanced, environment variables, add: Variable = NLS_LANG Value = American_America.UTF8 Rich -Original Message- Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L There is a way around that pesky FK problem. Unfortunately we are using it... No FK's. And they wonder why they have data problems... -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:43 AM To: Multiple recipients of list ORACLE-L > Hi Lisa, > > Yes. But its a little convoluted. It took me quite some time to do it. Depends what you want included. IE. storage paramters etc. > > This is the product I use to generate all of our models and YES, it drives me nuts. They had a bug in the last version that didn't allow the FK constraints ddl to be generated properly! I am still having alot of issues with it but it has the company's STAMP OF APPROVAL, so its what I need to use . > > Anyway, I use the OPTIONs under Forward Engineer and Created Several Templates (forget what THEY call'em). First I generate scripts for the tables with named PKs. Then the named FKs, then finally the indexes. THis way I can review them in a reasonable way instead of just spewing them all out there. > > Feel free to shoot me any specific questions. > > Hannah > > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Koivu, Lisa" <[EMAIL PROTECTED]> > Sent: Monday, May 06, 2002 12:44 PM > To: Multiple recipients of list ORACLE-L > Subject: OT: Erwin - Does this thing work? > > Hello all, > > I spent the weekend screwing around with Erwin. What a waste. I could not > believe how poorly it generated DDL. Has anyone gotten this product to > generate DDL in a readable, logical manner? > > I am using Version 4.0, SP1 > > Lisa Koivu > Oracle Database Big Baby Oven > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, Lisa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Paging problem in SunOS
My guess is that Mitra is not experience memory shortage if he has 1/2gb of ram and Oracle is the only thing running on it with SGA 50M. To verify, check whether the paging is actually doing swapping. Look for scan rate when doing vmstat. If it's not memory shortage then the high paging activity is probably because the SAG is too small and oracle has to go to disk constantly to fetch data. Hence, Paul suggestes to increase the SGA size. Rich -Original Message-From: Kimberly Smith [mailto:[EMAIL PROTECTED]]Sent: Friday, May 03, 2002 8:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Paging problem in SunOS He is having paging problems and you are recommending that he increase his SGA? Could you explain how you feel that will solve his problem please? Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul LiSent: Friday, May 03, 2002 6:48 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Paging problem in SunOS I think your SGA is too small. It should be around 200-250MB totally. -Original Message-From: Pradyut Mitra [mailto:[EMAIL PROTECTED]]Sent: Friday, May 03, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: Paging problem in SunOS Hi,I am experiencing a massive performance problem due tohigh page-in operation In Sun OS 5.6/Oracle 8.1.7.The RAM is 512 M and SGA is around is 50M and no otherprocess is running on that m/c. Any suggestions. Thanks in advance. Pradyut Do You Yahoo!?Yahoo! Health - your guide to health and wellness *** This electronic mail transmission contains confidential and/or privileged information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. ***
RE: CPU Pegged at 100%
All background processes are threads within the oracle.exe process on NT/2000 platform. -Original Message- Sent: Monday, April 29, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I have 5 DBWR processes according to INIT.ORA on NT .. I see them on V$SESSION but There is only one process ORACLE.EXE in the processes list of NT still. I do not understand the behaviour of ORacle on NT neither the Oracle I think. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 5:53 PM > On Mon, Apr 29, 2002 at 05:59:18AM -0800, Thomas Day wrote: > > > > I don't think that increasing the db_writer_processes will help. NT is, as > > noted elsewhere, multi-threaded. Increasing the db_writer_processes will > > not start a new process. > > > > My experience with Oracle on NT is that when the CPU is pegged at 100% it > > is because the OS is constantly writing and fetching the contents of RAM to > > the swapfile. > > > -- > > If this is the case for this problem, we have found that changing > the location of the os paging file onto another disk and controller > can help performance. See your windows clicking friends to find > out where to click. It is somewhere under my computer...read > the man page on it ;) > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > 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: Bunyamin K. Karadeniz 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: Ji, 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).
RE: monitoring multiple databases using PL/SQL
Well, that's why you should monitor your monitoring server. -Original Message- Sent: Tuesday, April 23, 2002 1:53 PM To: Multiple recipients of list ORACLE-L >From 'Oracle Database Monitoring for the Beginner' (pdf) - Chris Grabowy "In a centralized configuration, the monitoring software scripts reside on one server. This obviously makes maintenance easier, but if the hosting server fails then there is no (more) monitoring of the databases" regards Madhu >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: monitoring multiple databases using PL/SQL >Date: Tue, 23 Apr 2002 08:00:33 -0800 > >Greetings - >I am planning to centralize our Oracle monitoring process by using one >PL/SQL procedure to query database extents, invalid objects, alert logs etc >through database links. I wonder if anybody has done it before and if there >is any cons with it. The pros would be ease of administration, ease of >standardization etc. > >TIA > >Dennis > >-- >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). _ 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: Madhusudhanan Sampath 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: Ji, 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).
RE: executing a stored procedure at a certain time
Title: executing a stored procedure at a certain time You can schedule it as a database job. Look into the dbms_job package and section about database jobs in the admin guide. -Original Message-From: Nelson Flores [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53 PMTo: Multiple recipients of list ORACLE-LSubject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl ---
RE: DBMS_SHARED_POOL.KEEP
You
are calling a PL/SQL package from PL/SQL. Just get rid of all the execute
immediate
exec
stuff and call the package directly :
sys.dbms_shared_pool.keep();
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
4:28 AMTo: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN
tab_cur LOOP--EXECUTE
IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it
impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB ,
It did not work too.
How can I do this?
Bunyamin K.
Karadeniz
Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S.
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 /
1217Mobile : +90 535 3357729
The degree of normality in a database is
inversely proportional to that of its
DBA.
Oracle on Solaris Memory question
Hi all, I have 1gb physical memory and over 2gb swap space on my Solaris box (Solaris 8). My SGA is about 300mb. When I startup my instance (8.1.7) the amount of free memory (physical ram) dropped as expected but the swap usage also increased by 300mb. I am little puzzled over this as I don't expect the swap used to increase since my physical memory can accommodate the SGA. Below is a snapshot of TOP showing the memory: Database up == last pid: 23317; load averages: 0.25, 0.09, 0.09 23:14:25 74 processes: 73 sleeping, 1 on cpu CPU states: 97.6% idle, 1.4% user, 0.5% kernel, 0.5% iowait, 0.0% swap Memory: 1024M real, 341M free, 490M swap in use, 2319M swap free Bring down the database, and see the free memory goes up and swap used decreases. == last pid: 23317; load averages: 0.31, 0.12, 0.10 23:14:56 52 processes: 50 sleeping, 1 running, 1 on cpu CPU states: 84.1% idle, 4.9% user, 7.2% kernel, 3.8% iowait, 0.0% swap Memory: 1024M real, 728M free, 87M swap in use, 2722M swap free Startup the DB again, and see the free memory descreases and swap used increases. == last pid: 23339; load averages: 0.34, 0.14, 0.11 23:15:26 58 processes: 55 sleeping, 2 running, 1 on cpu CPU states: 62.1% idle, 10.9% user, 17.9% kernel, 9.2% iowait, 0.0% swap Memory: 1024M real, 353M free, 466M swap in use, 2344M swap free So with over 300MB of physical ram still being free, why is the swap in use so high? Thanks. Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Seeking opinions
Tom, I am not oppositting the idea of standard. I implement OFA and other stuff, and everywhere I go the first I do is establish standards. The problem is even with standard in place one should not assume everything will be in place as is should be. Which is the problem I see as Paul described. People are relying on standard more than data dictionary. And like you said when a file is in the wrong place it will stand out like a sore thumb. But the bigger question is what will the other 15 DBAs do about it? If they trust the standard so much they will think it shouldn't be there and without querying data dictionary to confirm it some one might go ahead and delete it. And yes the chance are very small but I don't like to risk it. Richard -Original Message- Sent: Tuesday, April 02, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Richard, In a busy shop, I would think that there is a *less* chance of a DBA making a mistake if all databases across all platforms conformed to the same directory standard. Can you imagine how long it would take to diagnose and fix a problem if every database was set up to a different standard? Mistakes can happen, but at least with standards, if a file is in the wrong place, it would stand out like a sore thumb. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 02, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) "taken to the next level". I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). "System" datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. "User" datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Ji, 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
RE: Seeking opinions
Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) "taken to the next level". I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). "System" datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. "User" datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Ji, 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).
RE: Off Topic: PGP
I think Network Associates has dropped PGP development and will provide support only now. Rich -Original Message- Sent: Wednesday, March 27, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Ok, I did a little more research and I still need help. Our vendor would prefer we not use a freeware version, which I can understand. So I went out to pgp.com, which used to be Network Associates and is now McAfee. I tried to find a sinmple PGP product that I can use to encrypt my one file, once a month. The only think that I can find that will let you do encryption is the McAfee EBusiness Server which is $12K. Does anyone know if there is such a thing as a commercially available, simple, command-line driven pgp utility? TIA again, Beth -Original Message- Sent: Friday, March 22, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Hello, Use GPG... is a pgp clone but GNU software so no crummy licenses. www.gnupg.org. Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 11:04 AM NT freeware can be found at: http://web.mit.edu/network/pgp.html But be warned--I've heard some horror stories about the NT install. I've never had problems myself, but know of cases where machines have been rendered inoperable... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, March 22, 2002 7:03 AM To: Multiple recipients of list ORACLE-L Does anyone know of any good PGP implementations for WinNt or Openvms? Are there any free ones? TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E 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: Paul Vallee 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: Seefelt, Beth 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: Ji, 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).
RE: NUMBER of PROCESS
If you are on Unix, there are OS related parameters with semaphores that you might need to increase. Please provide detailed information such as the platform, the error messages that you got. Richard Ji -Original Message- Sent: Wednesday, March 27, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi, When I change the number of process, I mean increase it is there are any other paramter related to this one or not, becaz after i changed it try to open database and it couldn't open, so i put it back & open it. Any Idea Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ji, 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).
RE: How to duplicate production database onto development box
Title: How to duplicate production database onto development box I use a hot backup to create a standby database then apply logs to the point I want to get a copy of production of a specific time. Then you can rename the database if you want to. -Original Message-From: Guerra, Abraham J [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 26, 2002 9:18 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to duplicate production database onto development box Just copy the files over and recreate the control file. Abraham -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 26, 2002 7:48 AMTo: Multiple recipients of list ORACLE-LSubject: How to duplicate production database onto development box Hi! We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;) Would transportable tablespaces be the way to go? This is 8.1.7 on Sun Solaris. Thanks, Helmut
FYI
Just want to pass this on in case you haven't read about this yet. http://www.theregister.co.uk/content/53/24559.html Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: Partitioning question
You are right. Partitioning can still make your job as a DBA easier. You can purge data (assuming the purge key is the same as partition key) by dropping partition, etc. -Original Message- Sent: Thursday, March 14, 2002 12:33 PM To: Multiple recipients of list ORACLE-L I am new to the world of partitioning. 816 on W2K. In a white paper on metalink "How to Implement Partitioning in Oracle Versions 8 and 8i " it states that "The RULE-based optimizer does not take the partitioning of tables and indexes into account." My question is - if your application is still rule based is there any value to partitioning? Some of the tables are over 30 million rows and 5G. If my understanding is correct I wouldn't see any performance improvement but would make maintenance simpler. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 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: Ji, 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).
RE: cursor not closing
Identify all the codes where ResultSet, Statement are used and make sure they are closed after it's done. -Original Message- Sent: Friday, March 08, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Hi, We have a Application that user JDBC thin client connecting to Oracle database. It seems like java code is opening the cursor , running some sql but not closing the cusrsor. Now the number of open_cursor reached 3568 . Is there any way we can close cursor from sqlplus. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Ji, 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). <>
RE: Excel's Oracle connectivity
In the older version of MS Office (the one before 95) there is a utility called MS Query. I don't know if it's still there or maybe under a different name. -Original Message- Sent: Monday, March 11, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!) TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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: Ji, 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).
RE: view other people's TAR
Thanks Kirti. That's what I thought, but from time to time people would post TAR numbers as if others can view them. So I was wondering about that. Thanks for verifying my doubts. Rich -Original Message- Sent: Saturday, March 09, 2002 7:13 PM To: Multiple recipients of list ORACLE-L TAR info contains the CSI number, and thus viewing other people's TAR won't be possible. - Kirti -Original Message- Sent: Saturday, March 09, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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: 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: Ji, 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).
view other people's TAR
Hi All, How do I look up other people's TAR such as the one posted by Ron Yount 1921166.995? I tried to search for it which yielded no results. I then tried to view a single TAR by number under the TAR menu but got the following message: You have insufficient privileges to enter this section of MetaLink. If you feel like this privilege should have been granted to you, please send a feedback request to our administration team. Thanks for your help. Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: cursor not closing
Are u using the JDBC OCI driver or the Thin driver? And which version? I know the "feature" you described exists for JDBC OCI driver but not for JDBC Thin driver. -Original Message- Sent: Friday, March 08, 2002 10:23 PM To: Multiple recipients of list ORACLE-L In the for what it is worth department, I had similiar issues. After the developers knocked themselves out looking for code that was not closing the cursor, I opened a tar: In a nutshell: yet another "feature" that cursors "even though closed by the session that opened them" remain available this is touted as a feature since there may be a session later that could benefit from a previous cursor... this behavior will continue until max_cursors is reached and then you are done...:-( You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true init parameter. If you are interested in more detail... my tar number is: 1921166.995 HTH, -Ron- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > Sent: Friday, March 08, 2002 6:23 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: cursor not closing > > > Identify all the codes where ResultSet, Statement are used and make sure > they are closed after it's done. > > -Original Message- > Sent: Friday, March 08, 2002 4:48 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > We have a Application that user JDBC thin client connecting to Oracle > database. > It seems like java code is opening the cursor , running some sql but not > closing > the cusrsor. > Now the number of open_cursor reached 3568 . > Is there any way we can close cursor from sqlplus. > > Thanks > --Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder 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: Ji, 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: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: cursor not closing
Identify all the codes where ResultSet, Statement are used and make sure they are closed after it's done. -Original Message- Sent: Friday, March 08, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Hi, We have a Application that user JDBC thin client connecting to Oracle database. It seems like java code is opening the cursor , running some sql but not closing the cusrsor. Now the number of open_cursor reached 3568 . Is there any way we can close cursor from sqlplus. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Ji, 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).
RE: Unix shell Question
Title: Unix shell Question Not easily. I wrote a script to do that. Let me know if you want it. -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 4:38 PMTo: Multiple recipients of list ORACLE-LSubject: Unix shell Question Hi, Need help in Unix shell. Is there a way to compute the previous date (similar to sysdate - 1 in SQL) using the date expression?? So if my date is 3/1/2002 I will get 2/28/20002. TIA Yuval.
RE: max open cursors exceeded
Title: max open cursors exceeded There is a bug(well, it's a feature actually) that if you uses JDBC even if you close all of your resultsets and statements, the cursors remain open by Oracle unless you close the Connection. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: max open cursors exceeded -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 3:28 AMTo: Multiple recipients of list ORACLE-LSubject: max open cursors exceeded a) MAX_OPEN_CURSORS is set to 1000 - when exceeding that threshold, we're experiencing problems; how can we monitor which users uses up all the cursors (and how many). By monitoring v$open_cursor b) What exactly is displayed when querying v$open_cursor? - I know htat there are parsed statements of the user/session - but this should be more than just a PL/SQL "declare cursor... open...fetch...close cursor", right? What about statements issued in SQL*Plus or through JDBC etc.? v$open_cursor displays ALL the cursors for a given session, not just the explicite PL/SQL or PRO*C stuff.A cursor is needed for EVERY SQL STATEMENT. The only cursor not displayed by v$open_cursor is the DBA himself/herself, especially if he has to support tools that do their own multiplexing, like Forte. c) The results from v$open_cursor is equivalent to the currently running transaction, right? So when are those entries removed again? When the transaction commits or when the sessions ends? Or when issuing a PL/SQL "close cursor". Or are those entries overwritten? by whom? when? An implicit cursor is closed when another statement is opened and re-parsed. If you take a look at v$session, you'll find that is contains the "current SQL" address. That is, basically, the open cursor that the session is currently executing. When the next SQL comes in, this cursor will be closed, SQL put in the library cache and a new cursor will be allocated. d) what does querying "select * from v$sql_cursor" return? That query will usually return enough information for your screen to join it's ancestors and will leave you wandering why is that SQL*Plus does not have "clear" or "cls" command. Any ideas? Yes. I want to win a lottery jackpot and start my own business in close proximity to the Waikiki beach.
RE: RE: Manager decrees "his" data warehouse design. Help!
www.kx.com -Original Message- Sent: Wednesday, February 27, 2002 2:38 PM To: Multiple recipients of list ORACLE-L By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a database out there a while back promoted by Joe Celko called KillerDB that does this but the data is still stored in rows. It was used for very large decision making systems. I can't find the site anymore so perhaps just another .com gone bust. - Ethan -Original Message- Sent: Wednesday, February 27, 2002 12:59 PM To: Multiple recipients of list ORACLE-L I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope you're being facetious with the statement that "queries run so much faster if you take all the joins out" 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Ji, 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).
RE: Options instead of ODBC + MS-Access [Slightly? Off-topic]
BRIO -Original Message- Sent: Thursday, February 21, 2002 8:53 AM To: Multiple recipients of list ORACLE-L lots of vendors in that marketspace. a few of the heavy hitters are: Actuate Software Corporation - e-reporting suite Seagate - crystal reports Cognos - impromptu -Original Message- Sent: Thursday, February 21, 2002 6:48 AM To: Multiple recipients of list ORACLE-L A developer here has put together a reporting package which uses ODBC to interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to extract data and generate nice GUI final presentation of data. The data extracted has various computations performed. The developer has asked what other Oracle or 3rd party options might be used to realise the same end results perhaps in a more efficient manner. Their concern is that as data volumes grow the performance will degredate substantially. Anyone any ideas?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: STEVE OLLIG 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: Ji, 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).
RE: JDBC problem
What kind of problems are you encountering? -Original Message- Sent: Wednesday, February 20, 2002 1:53 AM To: Multiple recipients of list ORACLE-L Hi, I am new to this group as well as to Oracle. I have installed Oracle 8.1.5 & Java 1.3.1_02 on Solaris system. My question is whatever JDBC drivers that are installed by default supports the java version 1.3.1_02 or i have to install JDBC drivers seperately.I am facing lot of problems in connecting to Database from java script.Please clarify my doubt. Thanks & Regards, Sankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar 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: Ji, 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).
RE: Oracle Advanced Replication
Title: RE: Oracle Advanced Replication Nick, Does SharePlex support user defined object types? Richard -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Advanced Replication All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: DENNIS WILLIAMS 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: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet acces
RE: White space compression in Oracle
Title: White space compression in Oracle Note VARCHAR and CHAR uses different comparison semantics. With CHAR the shorter one is padded with spaces up to the same length as the longer one and a byte by byte comparison is used. VARCHAR uses a none padded method. -Original Message-From: Marc Perkowitz [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 4:40 PMTo: Multiple recipients of list ORACLE-LSubject: Re: White space compression in Oracle Beth, Actually, varchar2 is char with the trailing spaces removed. What's the difficulty with switching to varchar2? Does RDB regenerate the white spaces when retrieving the data or something? Generally, everyone uses varchar2 in Oracle. Marc PerkowitzSenior ConsultantTWJ Consulting, LLC 847-256-8866 x15www.twjconsulting.com - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Monday, February 11, 2002 12:48 PM Subject: White space compression in Oracle Hi everyone, I hope this isn't a silly question, but is there any way to make Oracle compress white space in tables. I come from an RDB environment, and when you have a char(x) field in RDB, you can set the compression attribute on the table and any trailing white space in the char(x) column is compressed. I've found when moving some tables with long char fields to Oracle, the tables take up much more space, I suspect because Oracle is not compressing trailing spaces. Because of other constraints, I'm not able to change the fields to varchar2. Thanks for your help, Beth
RE: Unorthodox 8i install/upgrade
I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need to phone up a DC operator and have the CD put into the tray. Richard -Original Message- Sent: Thursday, February 07, 2002 12:33 PM To: Multiple recipients of list ORACLE-L I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went to patch 8.1.7, I untarrred the patch onto my NFS mount, then I could apply the patch to any of my systems from one central location. Darren -Original Message- Sent: February 6, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage & ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, 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).
RE: svrmgrl
You should use sqlplus instead of svrmgrl now. -Original Message- Sent: Wednesday, February 06, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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: Ji, 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).
