Re: Oracle AS 10g
Anyone know if this includes the new OEM 4.0 ? mvg/regards Jo "Boivin, Patrice J" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/09/2003 18:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle AS 10g Has been posted for HP/UX and Solaris on OTN. http://otn.oracle.com/software/products/ias/devuse.html I don't see Windows in their certification matrix, but they mention Red Hat linux 2.1. No SuSE. http://otn.oracle.com/software/products/ias/files/as-certification-904.html Maybe they will update this later. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NT -> Win2K causes performance degradation..
Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size & db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was "it was 7 out of 10, and is now 3 out of 10"..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope that someone has experienced some relatively similar experiences. Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rebuilding indexes - sure to cause a ruckus
Thanks Raj, Unfortunately, in my rush to get the kids to school in time, I stuffed the formatting when my cut 'n' pasting got converted to plain text. Hope you found it all useful. Cheers Richard - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 2:49 AM > Richard's explanation and example from c.d.o.s now has a permanent tinyurl link ... http://tinyurl.com/yflq if anyone is interested ... this might be better for bookmarks. > > Raj > -- -- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -Original Message- > Sent: Monday, December 08, 2003 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Hi Yong, > > Saying there are a "few" errors is being a little kind to Don's "Inside Oracle Indexing" article. > > [ rest snipped ] > > > ** > This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. > **5 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
I don't know why they favor MS AD. As a replacement for tnsname.ora the OID works very well. We didn't take it because the 3 developers know how to use the tnsnames.ora, the clients are all but 3 webbased for html, forms or reports. reports are partially created into files than can be downloaded as .pdf's. the 3 other clients were once configured manually and left unchanged ever since. MR >>> [EMAIL PROTECTED] 12/09 5:49 >>> Markus - Thanks for your ideas. Basically our issue isn't Oracle logins, but Oracle connections (replacing tnsnames.ora). For us, the user doesn't directly log into Oracle, but the application handles the login for them. However, I was searching for an alternative to maintaining tnsnames.ora on each client. I considered the Oracle Names server, but Oracle has announced this is going away in favor of OID. But my network guys favor MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 10:09 AM To: Multiple recipients of list ORACLE-L NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files. We had it once, but this was rather tricky to get it working at that time. Especially the uploading of certificates thet we made ourselves ... - but we had already a solution to update the OID on a daily/hourly basis for user authentication. We then decided not to use/need it, because we only need IAS authentication for users who have an NOVELL account - about thousand people like employees, students, parttimers... MS AD: we don't have it. may I propose: you need an interface or procedure - possibly java or even c. Then configure ORACLE to use this procedure, and update e.g. on an hourly basis. You must make up your mind who (MS or OID) administers - esp changes - passwords. kr MR >>> [EMAIL PROTECTED] 12/09 3:59 >>> Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr >>> [EMAIL PROTECTED] 12/09 1:54 >>> You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 1:54 PM > we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. > BUT: we taylored it to our needs - and do NOT use OID at all. > kr > mr > > >>> [EMAIL PROTECTED] 12/09 9:59 >>> > IIRC Oracle is going to support only OID as LDAP. > You need to set up OID and use a product like DIRXML to propagate updates > from Novell to OID. > > Yechiel Adar > Mehish > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, December 08, 2003 4:34 PM > > > > Hi, > > > > We are in the preliminary analysis of implementing an assurance package > (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web > Services and Forms on AIX 5.2). > > > > We are using Novell eDirectory as our LDAP. > > > > I looked on Metalink but did not find much thing. The way I understand it > is that you must load the LDAP info into Oracle Internet Directory. > > > > Am I right ? > > > > Anybody using Novell eDirectory integrated with Oracle ? > > > > TIA > > > > > > Stephane Paquette > > Administrateur de bases de donnees > > Database Administrator > > Standard Life > > www.standardlife.ca > > Tel. (514) 499-7999 poste 7470 > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephane Paquette > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be remo
Re: leaf node 90-10 splits
Hi Tanel, I have no idea but if you currently have 9 entries in a leaf block and the 10th entry you're about insert causes this type of split, then 9 entries (the 90% currently in the existing leaf node) remain and the new entry (10%) goes into the new leaf node. A 90-10 (%) split. Possible with small blocks (say 2K) and large index entries (200ish bytes) when 2K blocks ruled the Oracle seas. Like I said I have no real idea but it's my theory and makes a good bed-time story. Cheers ;) Richard - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 12:24 AM > Hi! > > I wonder why does statistic "leaf node 90-10 splits" imply that right-hand > index leaf block is split as 90-10, not 100-0 as it really is. (tested on > 9.2.0.4 W2k). > > Historical reasons? > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antw: RE: PERL?
experienced the following things useful - on unix/bsd/linux - sqlplus / << EOF connect sys as sysdba startup EOF things like that can be put into shell scripts - eg as startup scripts, for cron jobs doing e.g. reports into .pdf's to store on a webserver, perl's expect will most likely work like the unix expect. consider autoexpect as a beginner. we have oracle on NT as well. but it will be migrated to solaris and shut down within weeks. basically everything that works on unix/linux works in MS as well. if you can and want you can install cygwin or unixtools for nt. OR you use perl altogehter - but won't find to many tested ready scrits for it. my 5c. kr MReger >>> [EMAIL PROTECTED] 12/09 10:29 >>> On Tue, 9 Dec 2003, Yong Huang wrote: > Speaking of Perl versus shell, Perl may still be quite primitive in supporting > two-way communication with an external program e.g. sqlplus. (I have an example > at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus > using IPC::Open2). But I think a KornShell coprocess (not a here document) does > it nicely, i.e. piping a SQL command in and reading the result back, piping > another command in, reading again, without exiting your sqlplus session. If you > use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you > can send any arbitary SQL command such as explain plan, shutdown... and read > its output. I think Perl with Expect.pm could likely do this without much effort. Expect allows you to interact with just about anything that uses a terminal. One fun case comes to mind. We have this LED sign (think large rectangular array of LEDs), with an undocumented serial interface protocol. All that came with it to control it was this old DOS program which would talk to the sign over a serial port. So I whipped up a Perl script which used Expect to interact with dosemu (a Linux DOS emulator) to run the program, which interacted with the sign, all running on Linux. Works pretty good. Expect.pm is also nice to interact with network hardware that offers telnet/shell command interfaces. Interacting with sqlplus via Expect.pm would be pretty easy as well, I would think. It basically works like this: - Spawn the program you want to interact with - Expect a particular regex of output from the spawned process - Act based on that output (send commands, run processes, annoy the NT admin with net send packets, etc) - Wash, rinse, repeat. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
The interesting fact of course is that the beta program of 10g was "announced" in newsgroups AFTER it had closed for all intents and purposes to the general public... And quite frankly, Oracle could do a LOT WORSE than let "customers" like Mogens definitely join. Just a feeling, mind you. If Oracle thinks the "good old days" of in-house elites are back, they're dead wrong. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > Generally, the announcements are made at events like OracleWorld, > through OTN and so forth that the beta program is open. Depending on > the release, the program may not even get announced unless it's big > enough. IIRC, the beta program for 9.2 was open to only a small number > of customers and wasn't announced to the world at large, whereas the 10g > program was announced (again IIRC - it's 4 am for me and I haven't had > my first coffee yet!) at OracleWorld in San Fran in September? Of > course, there are some companies that are almost always invited to join > the beta program for the database because of the type of customer they > are and the type of work they do - customers like Amazon, for example, > may fall into that category. Customers like Mogens definitely don't. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
Amen... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > I really do not intend to go with the flow. Fortunately, there are other databases > and oracle's behavior is motivating me to start giving them serious considerations. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
Isn't that what Oracle has always done? I've got a funny feeling it's gonna start biting back really hard... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > guys decide to put out a limited production version? Prolonging the hype > would not serve any useful purpose, except may be, to further annoy your > customers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NT -> Win2K causes performance degradation..
Hi Mark, no thoughts specific to Oracle, but I'd recommend using the principle of "change only one element at a time". I'd say they were unwise to upgrade to W2K, and at the same time change their Oracle parameters. If possible, I'd advise they set all their Oracle parameters back to their pre-upgrade values, then carry out the same performance measures they used to arrive at their "was 7/10, is now 3/10" comment. If the degradation still exists to the same extent, then, yes, it must be the upgrade that produced the problems, and it needs investigating in that light. If they still get "7/10", then it must have been the changes to the Oracle parameters, not the W2K upgrade, that caused the problem. Changing too many elements simultaneously makes it impossible (or much more difficult) to isolate the cause, so you change one element at a time. Basic engineering principle! Paul -Original Message- Mark Leith Sent: 10 December 2003 09:04 To: Multiple recipients of list ORACLE-L Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size & db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was "it was 7 out of 10, and is now 3 out of 10"..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope that someone has experienced some relatively similar experiences. Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Hmm, so you're telling me you want me to let Larry know your views on this? Not this bunny! :) The problem in putting out a limited production release is not so much in putting it out - that's dead easy. It's in the expectation that some form of support comes with it usually, and limited production code is usually limited because it's still beta - hence bugs and so on that need support resources to address. Of course, we don't have bugs in our Production code! :) However, I will raise your comments with the Product Management team so they're aware of them. Can't promise that will mean anything in the way of results of course! As for when you'll see the software, what Larry said at OracleWorld is still the only official date I've heard. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Wednesday, December 10, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Second, I don't see why would putting a limited production version out for people to learn the new features be so much work. Third, inviting distinguished 10g users and allowing them early access would be fair and acceptable to me if it didn't last too long, thus making the advantage too large. Having this early start for this long is an annoying blunder, pure and simple. Oracle either shouldn't have announced the product that early or should have provided some software. Articles, white papers and veiled testimonies by the privileged ones are not enough. I believe you when you say that you don't have much influence because you really are a nice guy. Nevertheless, someone should tell the big guys that putting out some limited production version would be a good thing to do. If not that, then please tell us when can we expect to see the software. On 2003.12.09 14:39, Pete Sharman wrote: > Well, as you'd suspect I don't have any control over these sorts of > decisions! > > I didn't actually see the announcement on OTN, so I'm not sure who the > email would have gone to. There was a way Oracle employees could invite > customers to be part of the beta program, sp presumably your sales rep > didn't think you were important enough to be on the program. ;) > > Seriously, before Jared tells us to take this conversation offline, let > me make a couple of final points on this: > > 1. From Oracle's perspective, the beta program is an enormous amount of > work, and requires a lot of ongoing management of the customers > involved. For that reason, the beta program is not really designed to > be open to everyone. > > 2. If you think you really have a valid interest in being on the beta > program for future releases and are prepared to put in the work that's > involved with the beta program (logging bugs, testing new functionality > and so on), let me know and I can send you information on how to join > future beta programs as they occur. Since the beta proposals are > actually voted on, a compelling case will help with actually getting on > the beta program. > > 3. If you are simply interested in playing with the new features, > rather than seriously stress testing them, then I probably can't help > you. Decisions on "early adopter" sorts of programs that are set up to > handle people who want to "play" are beyond my level at Oracle. > > As for Mogens, I know he's on the beta program. I got him there, along > with a few of the other Oakies. It was a suggestion I came up with > because if we can get people like Mogens, Cary, Jonathan and Steve (who > are the four I suggested to Development) to say what a wonderful product > 10g is, then that's a really telling statement. I'm not sure that any > of them have said it yet, though! :) > > Pete > > "Controlling developers is like herding cats." > > Kevin Loney, Oracle DBA Handbook > > "Oh no, it's not. It's much harder than that!" > > Bruce Pihlamae, long-term Oracle DBA > > > -Original Message- > Mladen Gogala > Sent: Wednesday, December 10, 2003 5:40 AM > To: Multiple recipients of list ORACLE-L > > There was an announcement on the OTN, but nobody replied to email. > When reading this list, I get impression that quite a few people > were able to get the software so far and that the shroud of secrecy > over the whole thing is maintained in order for them to gain advantage > over the rest of customers. Anyway, Christmas is almost here. When do > the rest us, not so important customers, get to see 10g? Speaking of > Mogens, I believe that he has 10g. > Whatever the intention was, it was a marketing blunder. As a customer, > I'm > less then happy with the impossibility of getting to know 10g despite > the > multitude of materials pos
Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
Re: rebuilding indexes - sure to cause a ruckus
Hi Yong, One thing I should have mentioned when I posted my "epic" is that it not only attempts to correct the numerous technical errors in the article but also attempts to answer the various questions the article raises but totally fails to address. What I find most astonishing about the article is that the author confesses at the conclusion he has no idea when and why an index rebuild is beneficial. And as the author doesn't know, then surely it must all be so difficult, a "scientific-less phenomenon". If I can convince anyone who makes it through my email that this isn't rocket science, then it's been worth the bandwidth. BTW, does anyone know what a rocket scientist refers to when they say "Hey, this is all quite easy, it sure ain't ?" ? Cheers ;) Richard - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 5:44 AM > Thanks, Richard. I'll read your long message more carefully later. I like your > statement that rebuilding an index or not is not rocket science. One needs to > measure the performance before and after the rebuild and make a conclusion > himself. Many times we discuss performance issues and get very technical and > sophisticated, without showing experimental results! Having been a science > researcher before, I'd like to emphasize that facts speak louder than theories. > There may be 10,000 24x7 databases in the world that don't easily allow even > testing an index rebuild. But there may be 100 times more production databases > in the world that are not 24x7. The individual DBA needs to do his control > study and conclude, using experts' opinions as reference. > > Yong Huang > > > > __ > Do you Yahoo!? > New Yahoo! Photos - easier uploading and sharing. > http://photos.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
Re: rebuilding indexes - sure to cause a ruckus
Richard: I think that is the simple way of questioning other person's capacity. Remember this statment (borrowed from some one !!) "If you are telling something is simple, you are questioning the other person's intelligence !!' KG -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A brief detour....;-)
So much printing ... no wonder we have a lot of dead trees now !!! Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, December 09, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Back in the early 80's at school we had a towers of hanoi running in PL/1 On Nixdorf 8820, a teletype with matrix printer, printing out the full configuration after every move you made Regards, Carel-Jan ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rebuilding indexes - sure to cause a ruckus
Richard, I found it immensely useful, that's why I created the tinyurl and went to c.d.o.s and read the whole thread, from first to last post. (man those people need to learn to weed out old comments in the replies). This is what I love about this forum, it comes with huge amount of knowledge, eager members who are ready to educate and learn, add a dash of rhetoric and a right amount of fun. In other words a perfect combination. Thanks for your explanation. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 4:15 AM To: Multiple recipients of list ORACLE-L Thanks Raj, Unfortunately, in my rush to get the kids to school in time, I stuffed the formatting when my cut 'n' pasting got converted to plain text. Hope you found it all useful. Cheers Richard ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Re: Re: rebuilding indexes - sure to cause a ruckus
Hi Richard, I think, there are 2 candidates for an answer. 1life (nothing is more difficult) 2...love (ever tried to read your madam's thoughts?) ;-) Corrections welcome (as always). Cheers, Guido >>> [EMAIL PROTECTED] 10.12.2003 11.39 Uhr >>> (snip) If I can convince anyone who makes it through my email that this isn't rocket science, then it's been worth the bandwidth. BTW, does anyone know what a rocket scientist refers to when they say "Hey, this is all quite easy, it sure ain't ?" ? Cheers ;) Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rebuilding indexes - sure to cause a ruckus
Terse ? You haven't heard me terse until you hear me trying to get the kids to sleep at night. Don got it easy ;) - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 8:14 AM Subject: Re: rebuilding indexes - sure to cause a ruckus And in case you miss it in Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform operations that modify the index(es), and perform block dumps of the index as you go. You can see exactly what Oracle is doing with the index. Jared Yong Huang <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/09/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: rebuilding indexes - sure to cause a ruckusThanks, Richard. I'll read your long message more carefully later. I like yourstatement that rebuilding an index or not is not rocket science. One needs tomeasure the performance before and after the rebuild and make a conclusionhimself. Many times we discuss performance issues and get very technical andsophisticated, without showing experimental results! Having been a scienceresearcher before, I'd like to emphasize that facts speak louder than theories.There may be 10,000 24x7 databases in the world that don't easily allow eventesting an index rebuild. But there may be 100 times more production databasesin the world that are not 24x7. The individual DBA needs to do his controlstudy and conclude, using experts' opinions as reference.Yong Huang__Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing.http://photos.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Yong Huang INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Oracle AS 10g
OTN seems to say that it will be in the Database 10g, not in OAS 10g. I'm curious about the new OEM as well, given the chats on the list about it. I notice they posted Developer Server 10g, and a preview of Jdeveloper 10g this morning. Patrice. -Original Message- Sent: December 10, 2003 4:44 AM To: Multiple recipients of list ORACLE-L Anyone know if this includes the new OEM 4.0 ? mvg/regards Jo "Boivin, Patrice J" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/09/2003 18:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle AS 10g Has been posted for HP/UX and Solaris on OTN. http://otn.oracle.com/software/products/ias/devuse.html I don't see Windows in their certification matrix, but they mention Red Hat linux 2.1. No SuSE. http://otn.oracle.com/software/products/ias/files/as-certification-904.html Maybe they will update this later. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle AS 10g
Here I am correcting myself again... The full-edition of OAS includes the OEM. Patrice. -Original Message- Sent: December 10, 2003 8:29 AM To: '[EMAIL PROTECTED]' OTN seems to say that it will be in the Database 10g, not in OAS 10g. I'm curious about the new OEM as well, given the chats on the list about it. I notice they posted Developer Server 10g, and a preview of Jdeveloper 10g this morning. Patrice. -Original Message- Sent: December 10, 2003 4:44 AM To: Multiple recipients of list ORACLE-L Anyone know if this includes the new OEM 4.0 ? mvg/regards Jo "Boivin, Patrice J" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/09/2003 18:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle AS 10g Has been posted for HP/UX and Solaris on OTN. http://otn.oracle.com/software/products/ias/devuse.html I don't see Windows in their certification matrix, but they mention Red Hat linux 2.1. No SuSE. http://otn.oracle.com/software/products/ias/files/as-certification-904.html Maybe they will update this later. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rebuilding indexes - sure to cause a ruckus
Hi KG, O, you've got me thinking here !! I'm not too sure that I've really questioned anyone's "intelligence". I've always measured someone's intelligence by: 1. How quickly the can learn and absorb new information 2. How much they know and appreciate the work of David Bowie A quick check of the Oxford Dictionary describes the word intelligence as "mental ability to learn and understand things" (although interestingly, there's no mention of DB). I guess the issue I have is that if intelligent people are told and feed incorrect information (and Don's article has it's share of incorrect information) then fundamentally it's one's "knowledge" that I begin questioning. Unfortunately, I believe there are a lot of intelligent people in the Oracle community who have a questionable knowledge of Oracle (or aspects of Oracle) as a direct result of the poor quality of information that people absorb (be it books, training courses, web-articles, etc..). And undoubtedly many of these people that write substandard materials in turn have picked up flawed knowledge due to the quality of their readings, education and lack of proper research. As I mentioned "Knowledge is the key that unlocks the door of doubt". If you have no doubts about something, it by definition becomes simple !! Unfortunately, if you're presented with the wrong information, you get access to the wrong key ;) Cheers Richard - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 10:09 PM > Richard: > > I think that is the simple way of questioning other person's capacity. > > Remember this statment (borrowed from some one !!) > > "If you are telling something is simple, > you are questioning the other person's intelligence !!' > > > KG > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: K Gopalakrishnan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle8i and oracle9i in the same machine
Oracle use the selected home as default. You can see you default home in: start->programs->oracle installation products->home selector. If you want to run scripts on the other home you need to add: set oracle_home=c:\oracle\ora92 (for example) at the start of your script. Yechiel AdarMehish - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 12:29 AM Subject: Oracle8i and oracle9i in the same machine Hi everybody I have been running oracle817 since long time on WindowsNTNow I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
RE: Creating the Java System
Mark & Mike, Thanks for the replies. They both were right on the mark. The full removal did the trick. thanks again Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Thomas, This error seems to vaguely ring a bell. You may try: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_ database_id=NOT&p_id=209870.1 Hope that's helpful. -Mark -Original Message- Sent: Tuesday, December 09, 2003 4:19 PM To: Multiple recipients of list ORACLE-L gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing "create database controlfile reuse datafile.logfile..." command before "initjvm" and everything will work. On 12/09/2003 03:44:26 PM, "Mercadante, Thomas F" wrote: > All, > > I am attempting to install the Java system in a 9.2 database on Sun Solaris. > This is a db that I migrated up to 9.2 from 8.1.7. > > I am getting the following: > > SQL> create or replace java system > 2 / > create or replace java system > * > ERROR at line 1: > ORA-00604: error occurred at recursive SQL level 2 > ORA-01422: exact fetch returns more than requested number of rows > ORA-06512: at line 11 > > I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. > > Thanks for any ideas. > > Tom Mercadante > Oracle Certified Professional > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
tuning for throughput vs. tuning for response time
Has anyone else notice that these two can be somewhat different? In a high transaction system, I typiucal try to reduce LIOs when I write queries. For last 6-8 months, Ive been doing alot of ETL and nightly batch data loads. Ive found that there are times when I can improve response time by 20-30%(which can be significant in a batch process) and at the same time increasing LIOs by the same amount. Ive found this to be the case with large index fast full scans. Unfortunately, I forgot to save the test cases. Im not concerned about scaling up users here. Has anyone else noticed this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Documenting databases
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09, 2003 7:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Documenting databases The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [Shrek] and produces nice pretty html pages that damagement can look at in their browser. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Breakthrough: It finally booted on the first try.
RE: rebuilding indexes - sure to cause a ruckus
Richard Foote scribbled on the wall in glitter crayon: > BTW, does anyone know what a rocket scientist refers to when they say > "Hey, this is all quite easy, it sure ain't ?" ? the only two i know use theoretical physics.;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Nothing can move faster than light. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Documenting databases
Alan, When I started working at my present job there was zip,nada,zilch.. for database documentation. I started with the basics of: describe every table. describe the table data source location and provider and method of loading the data into the table. describe who or how the data in the table is used. document the database creation (create scripts to create the database, tablespaces,tables,triggers,etc..) and keep the scripts updated as conditions change. I periodically burn a CDROM with the scripts in case of a hardware failure and after a lot of changes in the scripts ( like year end work for the next year's tables) Describe the packages and objects that are used in the database (non Oracle created). create a daily/weekly/monthly(as you feel you are comfortable with) tablespace usage report to plan on new storage needs. In all cases document every thing. or CYA I hope this will get you started and remember that database documentation is an ever ending task. Ron >>> [EMAIL PROTECTED] 12/09/2003 5:49:25 PM >>> Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 brief detour....;-)
Good morning all: Well some good news, especially for April Wells. I could not find the TSO/CLIST version of the workshop (we removed it from the class and replaced it with another complicated workshop from the Data Structures and PL/I Exercise handbook), however, I think I found the PL/I version. I will have to wait until next week when our instructors are back from Europe and I will ping them. Jared: Given that we don't like attachments, any ideas on how to post this thing? Reply direct to me. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Carel-Jan Engel Sent: Tuesday, December 09, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Subject:RE: A brief detour;-) Back in the early 80's at school we had a towers of hanoi running in PL/1 On Nixdorf 8820, a teletype with matrix printer, printing out the full configuration after every move you made Regards, Carel-Jan -- There will always be another 10 last bugs -- At 07:24 9-12-03 -0800, you wrote: >Hate to say this but you are a bit late. I had my students at University >and here at Compuware create three to four different versions of the Tower's >of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, >recursion (yes it can be done), and others. I also had (yep had - lost >this) one for both PL/I and TSO/CLIST Dialog Manager & VMS DCL. I actually >created screens where you could dynamically choose the number of pegs and >pieces. It also verified that you were putting smaller pieces on top of >larger ones (one of the core rules for Tof H). > >Isn't programming great? > >Thank You > >Stephen P. Karniotis >Technical Alliance Manager >Compuware Corporation >Direct: (313) 227-4350 >Mobile: (248) 408-2918 >Email: [EMAIL PROTECTED] >Web:www.compuware.com > > -Original Message- >Bobak, Mark >Sent: Monday, December 08, 2003 4:19 PM >To: Multiple recipients of list ORACLE-L >Subject:A brief detour;-) > >So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has >over 100 different implementations of the Towers of Hanoi solution, each in >a different language. Since he didn't have one in PL/SQL, I decided to >write one. > >Here it is: >create or replace package hanoi >is >from_peg constant number := 1; >to_pegconstant number := 3; >using_peg constant number := 2; > >procedure play(n number); > >end hanoi; >/ >create or replace package body hanoi >is > >procedure do_hanoi(n number, from_peg number, to_peg number, using_peg >number) >is >begin > if(n > 0) then > do_hanoi(n-1,from_peg, using_peg, to_peg); > dbms_output.put_line('move '||from_peg||' --> '||to_peg); > do_hanoi(n-1, using_peg, to_peg, from_peg); > end if; >end; >procedure play(n number) >is >begin > do_hanoi(n, from_peg, to_peg, using_peg); >end; >end; >/ > >This concludes this public service announcement. We now return you to our >regularly scheduled programming. > >-Mark > >PS Yes, it's a slow day;-) >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Bobak, Mark > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > >The contents of this e-mail are intended for the named addressee only. It >contains information that may be confidential. Unless you are the named >addressee or an authorized designee, you may not copy or use it, or disclose >it to anyone else. If you received it in error please notify us immediately >and then destroy it. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Karniotis, Stephen > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-5
RE: A brief detour....;-)
Apologies.. Carel-Jan -- There will allways be another 10 last bugs -- > So much printing ... no wonder we have a lot of dead trees now !!! > > > Raj > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -Original Message- > Sent: Tuesday, December 09, 2003 5:09 PM > To: Multiple recipients of list ORACLE-L > > > Back in the early 80's at school we had a towers of hanoi running in PL/1 > On Nixdorf 8820, a teletype with matrix printer, printing out the full > configuration after every move you made > > Regards, Carel-Jan > > > ** > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. If > you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) 766-2000 > and delete this e-mail message from your computer, Thank you. > **5 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NT -> Win2K causes performance degradation..
Mark, I have not done a MicroSlop upgrade, but I have in the past upped the SGA size and gotten when I really did not want, which was database performance degradation. You might ask them to check the pagefile size. If it's system maintained or too small funny things do happen. BTW: My rule of thumb with Win2K is pagefile size = physical memory *1.5. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 10, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size & db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was "it was 7 out of 10, and is now 3 out of 10"..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope that someone has experienced some relatively similar experiences. Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT -> Win2K causes performance degradation..
Mark, This is pure speculation, as you didn't provide any particulars. Upgrading to Win2k is not likely the culprit, or at least, I have experienced any kind of problem in moving a database from NT -> Win2k. When they upgraded the memory, by just now much did they increase db_block_buffers? If increased too much, they could be spending a lot of time waiting on latches, as there may be too much memory to search through. As always, excellent advice may be had from Steve Adams: http://www.ixora.com.au/q+a/pool.htm Also, when upgrading to 4G of memory, did they set the /3GB switch? Unless you do, there is only 2G of memory available to Oracle, and if you increase the size of the SGA too much and start excessive paging... HTH Jared On Wed, 2003-12-10 at 01:04, Mark Leith wrote: > Hi All, > > We've been asked a question from one of our clients that I'm a little > stumped on. > > They run an OLTP database (Oracle 8.1.7), and have recently upgraded their > NT machine to Windows 2000, they were running with 2gb of memory, and > upgraded that to 4gb in the process. As they increased physical memory, they > also increased their SGA size & db_block_buffers. > > Since they've upgraded they have noticed a significant decrease in > performance (the way it was described to me was "it was 7 out of 10, and is > now 3 out of 10"..). > > Has anybody else done a system upgrade of this nature that has caused less > than desirable effects? Any pointers as to what to look at? We've requested > some stats (top wait stats etc.) and I'll feed these back as and when I get > them - but I thought I'd throw this out to you guys in the vague hope that > someone has experienced some relatively similar experiences. > > Cheers! > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windows clustering???
Now you've got me going, Rich. After 15 years of VMS we're being forced to use UNIX (HP-UX 11i) just because the application we want to use doesn't run on VMS. (Developers needed to re-write the app for VMS. Marketing needed so the developers will be paid and the company will be profitable.) It's taking me a little while to become accustomed to CaSe SenSiTIvitY. (VMS's revenge on case sensitivity? Font-size *and* font-set sensitivity!) Clustering is just something we've taken for granted. We do run Oracle on VMS (since 1999) and have not had the up-time mentioned in that INQ article. Keeping the cluster up is a lot easier than keeping an instance up! Nelson -Original Message- Sent: Tuesday, December 09, 2003 3:14 PM To: Multiple recipients of list ORACLE-L I'm guessing they're not running Oracle on this VMS cluster. I really liked the part about "the most difficult part was explaining to managers why it was unnecessary to shut systems down, even during the physical relocation." http://www.theinquirer.net/?article=13002 Imagine if DEC had any marketing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Documenting databases
Alan, The IT departments of several sites, hitherto fairly independent, have all been brought under a single roof at one of my customers and as a result a lot of databases have fallen into the herd of databases we had to manage there. IMHO the key point to inventory is automation; if you don't automate, it will never stay up-to-date. First of all, get hold of some platform for scripting. I don't know perl, I don't even plan to learn it any soon and as I feel comfortable with ksh, sed, awk and the like I jumped on a Unix platform, but your choice may be different. The first challenge in our case was to build an inventory of databases (asking people is totally unreliable); I have used scripts from Tim Gorman which you will find on his site (http://www.evdbt.com) - from a security paper, which I have reworked to suit my case. The idea was to probe the network (fortunately all servers are supposed to follow a special address pattern) and check for listeners, and send the lsnrctl stat command. This helps you identify servers, listeners, and instances. A suitable schema was built into a database (Oracle, but see below) to store this; note that relationships are sometimes not very simple, since a same instance can be served by several listeners. Next step was to secure a foothold into each database to execute inventory queries (it has been a good opportunity to check security too). DBSNMP/DBSNMP is a good bet. Actually, we created a special MONITOR account on each database, with only the minimum rights required. Everyday a script runs, which checks V$DATABASE, V$INSTANCE, V$LICENCE, V$VERSION (the only place BTW when you find some indication about which OS you are running on), getting information and updating it if required. Storage is of course checked as well. Database links are collected too. We have a PHP application displaying all the information (with the refresh date), conveniently crossed (for instance, we list for each database the dblinks to the database as well as the dblinks from the database). We have some summary PDF reports (storage, databases per OS, per version, etc.) which are printed every week. We are also linking to a (static) inventory of applications. It's still work in progress. We have recently added a connection test every 15mn to check database availability (trying a non-existent user. If we don't get ORA-1917 we try to ping the server and tnsping the listener to pinpoint the reason for the problem - of course we skip the other databases on the server if we can't ping it) and compute some availability percentage figure. We also intend to collect some metrics at regular intervals to have an idea about the load. I have nothing against using Access to store the data; in fact, some of the ideas were borrowed from another customer where the repository is a Sybase database (TCL scripts do a full inventory of both the Sybase and Oracle databases - several hundreds of them). But, once again, do it AUTOMATICALLY. HTH Stephane Faroult >- --- Original Message --- - >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 09 Dec 2003 15:34:32 > > > > > >Dan, > >That's a good idea for documenting structures >inside the database. >However, my database manager wants more high level >info: database name / >host, oracle version, listeners, applications that >use it, cron job >descriptions and times, main schemas and what they >are used for, lists of >developers names that access the databse, etc... > >Alan > > > > > > > Daniel Hanks > > > <[EMAIL PROTECTED] To: > Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> > c.com> cc: > > > Sent by: >Subject: Re: Documenting databases > > [EMAIL PROTECTED] > > > .com > > > > > > > > > 12/09/2003 04:09 > > > PM
RE: Documenting databases
Alan - First the bad news. Obviously you can't automatically get all that information, but then you knew that. The good news. I think you'll find that information to be very valuable. I try to collect that myself. A spreadsheet or Access database is probably as good a way as any. If you have a help desk, they may be able to store this information as a configuration (or CI) in their tool. Another piece of data to consider is the database links. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> c.com> cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: > Recently our database manager has asked us to do the unthinkable > document our databases! To make matters worse, and without our input, he > went ahead and created a schema and put it in an Access database (using > tables to make it look like a speadsheet). Either we use his idea or come > up with something else. > So, I thought I'd ask everyone on the list how you do it. Text files? > In a database (oracle, or other)? Spreadsheets? What are the pros and > cons? Etc > How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Message Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
RE: NT -> Win2K causes performance degradation..
Might also be they bumped shared_pool way up and they aren't using bind variables? > -Original Message- > > When they upgraded the memory, by just now much did they increase > db_block_buffers? > > If increased too much, they could be spending a lot of time > waiting on latches, as there may be too much memory to > search through. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
How are you resolving your aliases on the unix box and on your client? Are you using onames for both (check your sqlnet.ora at both locations) or are you using local copies of tnsnames.ora? (or some other method). "Hybart, Clive" @metoffice.com> cc: Sent by: Subject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid ml-errors 12/10/2003 05:39 AM Please respond to ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: leaf node 90-10 splits
Hi, Tanel, Where do you see this statistic? I only see "leaf node splits" in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang > I wonder why does statistic "leaf node 90-10 splits" imply that right-hand > index leaf block is split as 90-10, not 100-0 as it really is. (tested on > 9.2.0.4 W2k). > > Historical reasons? > > Tanel. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PERL?
Dan, If I were to use Expect.pm in Perl, I would program in Expect directly. If we can have one less layer of wrapping, why not? On the other hand, sqlplus is not an application that insists on terminal input as telnet does. So you can use a shell here document or coprocess to talk to it; Expect is an overkill. (Some people use Expect to simply ftp files without knowing that ftp -n allows you to use a here document; an Expect ftp script is necessary only if you need to respond differently to each of the ftp errors). Yong Huang Daniel Hanks wrote: I think Perl with Expect.pm could likely do this without much effort. Expect allows you to interact with just about anything that uses a terminal. One fun case comes to mind. We have this LED sign (think large rectangular array of LEDs), with an undocumented serial interface protocol. All that came with it to control it was this old DOS program which would talk to the sign over a serial port. So I whipped up a Perl script which used Expect to interact with dosemu (a Linux DOS emulator) to run the program, which interacted with the sign, all running on Linux. Works pretty good. Expect.pm is also nice to interact with network hardware that offers telnet/shell command interfaces. Interacting with sqlplus via Expect.pm would be pretty easy as well, I would think. It basically works like this: - Spawn the program you want to interact with - Expect a particular regex of output from the spawned process - Act based on that output (send commands, run processes, annoy the NT admin with net send packets, etc) - Wash, rinse, repeat. -- Dan __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PERL?
Jared, Thanks for correcting me that shutdown is a sqlplus command. I wanted to make the point that piping strings to sqlplus can do more than Perl DBI can. (But Perl DBI has advantages in many cases) Yong Huang [EMAIL PROTECTED] wrote: All *SQL* commands will work work with the DBI. 'SHUTDOWN' is not a SQL command, it is a sqlplus command, and therefor will not work with the DBI. This has been checked into, and Oracle does not make this functionality available via OCI, so shutting down and starting a database on *nix requires sqlplus. Here is one of the few instances where Win32 makes things easier than on *nix: Oracle can be stopped and started via a service, which means you can easily shut it down via the command line, and via the Win32 Perl module Win32::Service. If you want in depth discussion on this check the archives for the dbi-users list. I don't recall where the archives are, but the list is found at lists.perl.org. Jared __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Documenting databases
I used to document database objects (including columns) with the COMMENT commands. I stopped doing that because I think it unnecessarily increases the size of data dictionary. It's just a little, though. Yong Huang Daniel Hanks wrote: How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Data Guard
Hi, Guang, Look up SDU and TDU in Oracle documentation Network configuration. You set them in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to modify some procotol-specific parameters. In addition, in your client application, you can choose a sensible array fetch size, such as arraysize in sqlplus (in fact, sqlplus arraysize changes more than just network data chunk size). You can't magically increase the network transfer rate by lowering network latency. But you can indirectly increase the rate by other means, such as buffering slightly more data in one chunk. Yong Huang Guang Mei wrote: I have never worked on Network stuff. But is there any easy parameters we could set in sqlnet.ora so that we could increase the DB performance by increase the network transfer rate (without doing anything else)? BTW my sqlnet.ora (on a Sun Box) has only two lines: ... NAMES.DEFAULT_DOMAIN = incyte.com NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) Guang __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
char is going away?
Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: char is going away?
Gene Was another part of the rumor that Oracle was going to retire SQL standard compatibility? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
Gene, I remember Oracle saying that char was going away - about 6 years ago. That's when they created varchar and varchar2. Is this a new rumor? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 10, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: char is going away?
Not as long as DB2 has it. Oracle needs to be compatible, in order for the people to convert. In addition to that, CHAR has some properties which VARCHAR2 does not. CHAR is fixed size, blank padded and oracle probably wouldn't want to break ancient mainframe COBOL programs, because people would stick to DB2 because of that. I believe that is a malicious rumor spread by the panicking liberals. On 12/10/2003 11:09:27 AM, Gene Gurevich wrote: > Hi all: > > Someone told me that Oracle is planning to retire char > variable and therefore they need to be replaced by > varchar2. Has anyone heard anything about it? > > thanks > > Gene > > __ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gene Gurevich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: char is going away?
Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
-Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
24 x 7 x 365
Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** ==
RE: char is going away?
Jonathan My understanding is that VARCHAR2 is not even a SQL standard, and some databases don't handle VARCHAR very efficiently, so if you are trying to sell a product that can adapt to several databases besides Oracle, you might stick to CHAR. If your application is COBOL-based, using CHAR simplifies things quite a bit. Especially if you sell your application to many sites that want to use Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah it wastes a bit of disk space. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Documenting databases
Alan, That sounds like a good candidate for a simple database application written in PL/SQL. Create a schema and model your app. It shouldn't require too many tables. Since you have Oracle and non-oracle information to store, most of the Oracle information could be extracted from the data dictionary automatically to update your app. You would only have to manually update the non-Oracle information. Mike Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: accounting software
Grace Take a look at Lawson Software -- http://www.lawson.com Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 9:34 PM To: Multiple recipients of list ORACLE-L can anyone recommend accounting software for mid-range distribution company that uses oracle as database? Best Regards, Grace Lim Suy Sing Comm'l Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 24 x 7 x 365
Well, first thing that needs to be noted is that “24 x 7 x 365” indicates uptime for 7 years, which always gives me a chuckle when people say it. Mind you, I’ve been guilty of saying it too! J And probably the second thing that needs to be said is that no single product addresses true HA requirements. RAC is no different to that. It provides machine failover capability, and while it can be stretched to a certain extent to give the illusion of site failover capability, you would still need someone like DataGuard to address issues such as human error correction. And probably the third thing that needs to be said is that it’s not just a technology thing. If you don’t have robust change control, for example, a simple coding error can ensure you don’t meet your availability requirements. And probably the fourth thing that needs to be said is that it’s all covered in one of my papers at RMOUG Training Days next February, Real Business Continuity with Oracle10g . J Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Rahmlow Sent: Thursday, December 11, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Subject: 24 x 7 x 365 Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** ==
RE: char is going away?
You mean you still need a DBA in 9i?!!? :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 3:35 AM To: Multiple recipients of list ORACLE-L Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Could not run export utility from cron job
-Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M > Sent: Wednesday, December 10, 2003 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: Could not run export utility from cron job > I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to > run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. > $exp user/password tables.dmp > Thanks, > David I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: leaf node 90-10 splits
On 9i: select * from v$statname where name like '%leaf%'; Yong Huang <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: leaf node 90-10 splits Hi, Tanel, Where do you see this statistic? I only see "leaf node splits" in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang > I wonder why does statistic "leaf node 90-10 splits" imply that right-hand > index leaf block is split as 90-10, not 100-0 as it really is. (tested on > 9.2.0.4 W2k). > > Historical reasons? > > Tanel. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Documenting databases
Indeed, my todo list includes an item for automating RDA on several servers. The problem is, that RDA is rather difficult to automate, at least on Windoze. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 05:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Documenting databases Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called "RDA" (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> | cc: | Subject: Re: Documenting databases |Dan, | That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | <[EMAIL PROTECTED] To: Multiple |recipients of list ORACLE-L <[EMAIL PROTECTED]> | c.com> cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: |> Recently our database manager has asked us to do the unthinkable |> document our databases! To make matters worse, and without our input, |he |> went ahead and created a schema and put it in an Access database (using |> tables to make it look like a speadsheet). Either we use his idea or |come |> up with something else. |> So, I thought I'd ask everyone on the list how you do it. Text |files? |> In a database (oracle, or other)? Spreadsheets? What are the pros and |> cons? Etc |> |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | INET: [EMAIL PROTECTED] |Fat City Network Services -- 858-538-5051 http://www.fatcity.com |San Diego, California -- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: | INET: [EMAIL PROTECTED] |Fat City Network Services -- 858-538-5051 http://www.fatcity.com |San Diego, California -- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). Content-type: text/html; charset=us-ascii The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 03:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Documenting databases Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name
Re: NT -> Win2K causes performance degradation..
Mark, My guess is, that the new OS re-instated the file system caching. By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver (and domain controller, web server, print server, etc) until you tell it otherwise. This is much improved in w2k3 server - where you tell it what you want it to be. A good sysadmin would have set the OS to "optimize throughput for network applications" which would have turned off the filesystem caching. Ok, its only one radio button to select, so an MSCE could set it also. Surprisingly enough, in W2K Server - changing this setting does not require a reboot, although I don't know if the changes take effect until after a system restart. That's not the sort of thing that I usually test, as NT4 had me trained to reboot afterwards. the other thing may be, that the boot.ini no longer supports the /3GB or /PAE switches as Jared mentioned - but that should not cause the symptoms you are reporting. hth. PaulMark Leith <[EMAIL PROTECTED]> wrote: Hi All,We've been asked a question from one of our clients that I'm a littlestumped on.They run an OLTP database (Oracle 8.1.7), and have recently upgraded theirNT machine to Windows 2000, they were running with 2gb of memory, andupgraded that to 4gb in the process. As they increased physical memory, theyalso increased their SGA size & db_block_buffers.Since they've upgraded they have noticed a significant decrease inperformance (the way it was described to me was "it was 7 out of 10, and isnow 3 out of 10"..).Has anybody else done a system upgrade of this nature that has caused lessthan desirable effects? Any pointers as to what to look at? We've requestedsome stats (top wait stats etc.) and I'll feed these back as and when I getthem - but I thought I'd throw this out to you guys in the vague hope thatsomeone has experienced some relatively similar experiences.Cheers!Mark===Mark Leith | T: +44 (0)1905 330 281Sales & Marketing | F: +44 (0)870 127 5283Cool Tools UK Ltd | E: [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising throughput & performance---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mark LeithINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Ma! il messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: char is going away?
On 12/10/2003 12:44:26 PM, "Jesse, Rich" wrote: > Did I mention that this application also RELIES on the OCI bug that allows a > date column to contain a zero (as opposed to the zero-date) that can't be > done thru normal SQL? That is, probably, because your application supports conversion to stardate. Beam me up, Rich. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pipelined functions
Title: Pipelined functions I have a question related to pipelined functions ... I have a function which performs a task in a loop. I have piped messages at the beginning and end of the loop and expect them to appear as soon as they are piped. But there seems to be a difference of opinion between oracle's and my definition of "as soon as". I see these messages appear after 2/3 loops instead of each loop. Does anyone know why this should happen? Any way to trace the piped messages? 10046 doesn't cut it for me. BTW this is 9202. I did search for Metalink for bugs but didn't find any obvious ones. Anyone know the internals (or heard any rumors) of pipelining ... like is there a buffer size, when reached messages are output? something like that? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
They will think differently after Mogens comes out with the "Do you really need 10g" presentation ;) -- Denny Koovakattu Quoting Nuno Souto <[EMAIL PROTECTED]>: > The interesting fact of course is that the beta program > of 10g was "announced" in newsgroups AFTER it had closed > for all intents and purposes to the general public... > > And quite frankly, Oracle could do a LOT WORSE than let > "customers" like Mogens definitely join. Just a feeling, > mind you. If Oracle thinks the "good old days" of in-house > elites are back, they're dead wrong. > > Cheers > Nuno Souto > [EMAIL PROTECTED] > - Original Message - > > > Generally, the announcements are made at events like OracleWorld, > > through OTN and so forth that the beta program is open. Depending on > > the release, the program may not even get announced unless it's big > > enough. IIRC, the beta program for 9.2 was open to only a small number > > of customers and wasn't announced to the world at large, whereas the 10g > > program was announced (again IIRC - it's 4 am for me and I haven't had > > my first coffee yet!) at OracleWorld in San Fran in September? Of > > course, there are some companies that are almost always invited to join > > the beta program for the database because of the type of customer they > > are and the type of work they do - customers like Amazon, for example, > > may fall into that category. Customers like Mogens definitely don't. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nuno Souto > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
long raw risk
Group, I have just been given a project / database where a vendor will implement a table with a LONG RAW field in it. Oracle manuals state clearly that this datatype is outdated and should be replaced by BLOB, I quoted the manuals to vendor-support, but they will not move on this. >From the looks of it, the table with the LR field will become the largest table in the system, with well over a billion records in it after the 1st yr. My main worry is inefficiency in retrieving records from the table, and most importantly, I cannot partition a table with long/longraw columns in it. On first tests, the LRs are >1K, whereas the record-without-LR is avg 66 bytes. In real-life, the LR is probably bigger still. Quesions: - Is there a real performance-risk ? Up to now, I always managed to offload LONG/BLOBs into separate tables or into LOB-storage clauses, but I see now way to do that here. - Given the LongRaw datatype, what are my best defences against (potential) performance problems. Anyone been-there-done-that ? Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: char is going away?
Dennis, According to my copy of 'A Guide To SQL Standard (Author: C. J. Date), 4th ed, pp292, section 19.4" CHARACTER(n) - fixed length string of exactly n characters (n > 0) VARYING(n) - varying length string of up to n characters (n > 0) So, I guess it is. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Jonathan My understanding is that VARCHAR2 is not even a SQL standard, and some databases don't handle VARCHAR very efficiently, so if you are trying to sell a product that can adapt to several databases besides Oracle, you might stick to CHAR. If your application is COBOL-based, using CHAR simplifies things quite a bit. Especially if you sell your application to many sites that want to use Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah it wastes a bit of disk space. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
How's about applications written in ancient awful 4GLs like PowerHouse that do not handle variable length fields (aka "columns") in their own files, and therefore do not directly support them in relational DBs either? Did I mention that this application also RELIES on the OCI bug that allows a date column to contain a zero (as opposed to the zero-date) that can't be done thru normal SQL? SELECT TO_CHAR(lastused,'') FROM mytables; TO_CHAR( - 2003 2003 2002 H...I forgot about that in testing our 9i upgrade... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parentheses and joins
I looking for a good, simple example of when parentheses matter when writing a join query using the new, SQL92 join syntax. For example, I could write: SELECT * FROM county y JOIN city c ON y.county_id = c.county_id JOIN attraction a ON c.city_id = a.city_id; and I could use parens to clarify the join order: SELECT * FROM (county y JOIN city c ON y.county_id = c.county_id) JOIN attraction a ON c.city_id = a.city_id; I could even force a different join order: SELECT * FROM county y JOIN (city c JOIN attraction a ON c.city_id = a.city_id) ON y.county_id = c.county_id; I'm struggling to come up with a good example of when you might *need* to use parens. I'm not having a really good day today. In fact, I'm having a really, really bad day, so maybe I'm not thinking too clearly, but so far I'm unable to come up with a good example to demonstrate the necessity of parentheses. Can anyone help me out with this? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: char is going away?
DW> If your application is COBOL-based, using CHAR DW> simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DW>My understanding is that VARCHAR2 is not even a SQL standard The keyword VARCHAR2 is not in the standard, but a variable-length type is. I think the standard uses CHARACTER VARYING, or something like that. I don't have time to look it up right now. DB2 uses VARCHAR, without the "2". I'm not sure why Oracle is so outspoken against that same keyword. I'd be interested in finding out. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Could not run export utility from cron job
Ken: When running from cron the user's .profile does not get executed. So your ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment. So on the line that you want to execute the export. Before the exp command add ". ~/.profile &&" (without the double quotes) exp user/password tables.dmp. This will execute the .profile first, set your environments and then do the export. Ron *** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 *** -Original Message- Sent: Wednesday, December 10, 2003 12:39 PM To: Multiple recipients of list ORACLE-L -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M > Sent: Wednesday, December 10, 2003 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: Could not run export utility from cron job > I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to > run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. > $exp user/password tables.dmp > Thanks, > David I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Cetnar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: char is going away?
Oracle has varchar and varchar2 both ... The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm#10824 HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 1:55 PM To: Multiple recipients of list ORACLE-L DW> If your application is COBOL-based, using CHAR DW> simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DW>My understanding is that VARCHAR2 is not even a SQL standard The keyword VARCHAR2 is not in the standard, but a variable-length type is. I think the standard uses CHARACTER VARYING, or something like that. I don't have time to look it up right now. DB2 uses VARCHAR, without the "2". I'm not sure why Oracle is so outspoken against that same keyword. I'd be interested in finding out. Best regards, Jonathan Gennick --- Brighten the corner where you are ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Could not run export utility from cron job
Simpson, Ken wrote: I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken How about adding the line: source /.(bash_)profile to the shell script that runs exp? Unfortunately, I'm not in a position to test this where I am right this minute. -- PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Could not run export utility from cron job
How about setting it up to execute in 10 minutes? Testing things this minute isn't exactly the point with cron. On 12/10/2003 02:09:24 PM, Bricklen Anderson wrote: > Simpson, Ken wrote: > > > > I'm pretty sure that jobs running out of cron do not source in .profile > > so you probably don't > > have the Oracle environment set and therefor exp is not in your PATH. > > > > Ken > > How about adding the line: > source /.(bash_)profile > to the shell script that runs exp? > > Unfortunately, I'm not in a position to test this where I am right this > minute. > > -- > PresiNET Systems > http://www.PresiNET.com > Online Demo: https://www.presinet.com/secure/login > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bricklen Anderson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 24 x 7 x 365
Title: RE: 24 x 7 x 365 As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-) Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: 24 x 7 x 365 Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks
Could not run export utility from cron job
Title: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp user/password tables.dmp Thanks, David
Re:Re: two oracle pl/sql programmers needed (50k/yr)
In Austin, Texas -- Original Message Date: Tue, 09 Dec 2003 06:14:30 -0800 >System Manager: > >Where are these positions located geographically? > >Me > > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Tuesday, December 09, 2003 7:44 AM > > >> >> please send an email to me,if you're interested. >> >> _ >> Free email with personality! Over 200 domains! >> http://www.MyOwnEmail.com >> Looking for friendships,romance and more? >> http://www.MyOwnFriends.com >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: system manager >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- 858-538-5051 http://www.fatcity.com >> San Diego, California-- Mailing list and web hosting services >> - >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: KENNETH JANUSZ > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Configuring Veritas Netbackup Question
I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a couple years without a problem. We recently purchased the license for the Oracle module and installed (activated) it (actually, the SA did this while I watched). The database server is a separate Linux (same version) box and the client seems to have been installed. Anyway, I go through the steps to configure Netbackup (setting up a policy, media, etc). All looks good. I create a test script for rman (based on one I know works). When I attempt to run a test backup and I get the message 'Unable to get data from client polar from server phoenix. status 104'. What am I missing? How do I access the client from the host? I noticed the host server does not have Oracle installed (tnsnames, etc.) so my first thought was to do that but wanted to make sure I was right before I went to the SA to do this. Thanks for your help! Sign, Dwayne aka Frustrated One -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: char is going away?
On 12/10/2003 11:34:36 AM, "Jamadagni, Rajendra" wrote: > Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. > > Raj And it became reality. DBA jobs were outsourced. The only necessary people belong to the damagement. Oracle 10g will create the need for fewer IS professionals and more magazine reading damagers. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
I think he's skipping that one to go direct to "Do you really need Oracle?" :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Denny Koovakattu Sent: Thursday, December 11, 2003 4:04 AM To: Multiple recipients of list ORACLE-L They will think differently after Mogens comes out with the "Do you really need 10g" presentation ;) -- Denny Koovakattu Quoting Nuno Souto <[EMAIL PROTECTED]>: > The interesting fact of course is that the beta program > of 10g was "announced" in newsgroups AFTER it had closed > for all intents and purposes to the general public... > > And quite frankly, Oracle could do a LOT WORSE than let > "customers" like Mogens definitely join. Just a feeling, > mind you. If Oracle thinks the "good old days" of in-house > elites are back, they're dead wrong. > > Cheers > Nuno Souto > [EMAIL PROTECTED] > - Original Message - > > > Generally, the announcements are made at events like OracleWorld, > > through OTN and so forth that the beta program is open. Depending on > > the release, the program may not even get announced unless it's big > > enough. IIRC, the beta program for 9.2 was open to only a small number > > of customers and wasn't announced to the world at large, whereas the 10g > > program was announced (again IIRC - it's 4 am for me and I haven't had > > my first coffee yet!) at OracleWorld in San Fran in September? Of > > course, there are some companies that are almost always invited to join > > the beta program for the database because of the type of customer they > > are and the type of work they do - customers like Amazon, for example, > > may fall into that category. Customers like Mogens definitely don't. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nuno Souto > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 24 x 7 x 365
You mean 2004/02/31, the 31st of February? On 12/10/2003 02:19:34 PM, Whittle Jerome Contr NCI wrote: > As 2004 is a Leap Year, in February you have a one day window of opportunity to do > upgrades. ;-) > > Jerry Whittle > ASIFICS DBA > NCI Information Systems Inc. > [EMAIL PROTECTED] > 618-622-4145 > > > -Original Message- > > From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED] > > Sent: Wednesday, December 10, 2003 10:44 AM > > To: Multiple recipients of list ORACLE-L > > Subject:24 x 7 x 365 > > > > > > Hello, > > Our company would like to know whether or not Oracle supports true 24x7x365 > > availability for an oltp database. We currently are using the 8.1.7 enterprise > > edition. Does an architecture exist whereby we can upgrade the database and/or > > operating system and not cause an outage? Will RAC solve this issue? Are there > > any other areas of concerns that I should be thinking about? For example, > > analyzing with the validate clause and its impacts on the transaction system. > > Thanks > > > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Could not run export utility from cron job
Title: Could not run export utility from cron job You need to load user's .profile in your cronjob (to set ENVs), becuase the unix user who executes cronjob does not have it's profile loaded. HTH. Guang -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David MSent: Wednesday, December 10, 2003 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp user/password tables.dmp Thanks,David
RE: Could not run export utility from cron job
Title: Could not run export utility from cron job Make sure that you source your environment variables in the script. At the least, set the $PATH variable to include the Oracle bin directory. Jobs executing from CRON do not automatically source the .profile when they kick off. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David MSent: Wednesday, December 10, 2003 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp user/password tables.dmp Thanks,David
Re: char is going away?
Probably by Howard Dean and Bertie Gore. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 10:34 AM > Not as long as DB2 has it. Oracle needs to be compatible, in order > for the people to convert. In addition to that, CHAR has some properties > which VARCHAR2 does not. CHAR is fixed size, blank padded and oracle probably > wouldn't want to break ancient mainframe COBOL programs, because people would > stick to DB2 because of that. I believe that is a malicious rumor spread by > the panicking liberals. > > On 12/10/2003 11:09:27 AM, Gene Gurevich wrote: > > Hi all: > > > > Someone told me that Oracle is planning to retire char > > variable and therefore they need to be replaced by > > varchar2. Has anyone heard anything about it? > > > > thanks > > > > Gene > > > > __ > > Do you Yahoo!? > > Free Pop-Up Blocker - Get it now > > http://companion.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Gene Gurevich > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: long raw risk
The reason that vendors often use LONG RAW is that that datatype meets the ANSI SQL standard, while BLOB doesn't. That way, they can use the same DDL against most SQL databases. Sometimes you can modify the vendor's DDL before or during installation. Sometimes you can re-create a table right after installation, as long as the columns have the same name and a compatible datatype (and BLOB is somewhat compatible with LONG RAW) - but I'd test this thoroughly before I'd go production. There is a performance risk, but it can be minimized, especially if your vendor lets you change what tablespace will be used for the table and its indexes. I'd put it in a tablespace away from the rest of the tables. -Original Message- Sent: Wednesday, December 10, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Group, I have just been given a project / database where a vendor will implement a table with a LONG RAW field in it. Oracle manuals state clearly that this datatype is outdated and should be replaced by BLOB, I quoted the manuals to vendor-support, but they will not move on this. >From the looks of it, the table with the LR field will become the largest table in the system, with well over a billion records in it after the 1st yr. My main worry is inefficiency in retrieving records from the table, and most importantly, I cannot partition a table with long/longraw columns in it. On first tests, the LRs are >1K, whereas the record-without-LR is avg 66 bytes. In real-life, the LR is probably bigger still. Quesions: - Is there a real performance-risk ? Up to now, I always managed to offload LONG/BLOBs into separate tables or into LOB-storage clauses, but I see now way to do that here. - Given the LongRaw datatype, what are my best defences against (potential) performance problems. Anyone been-there-done-that ? Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rogue SYS connections
Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue connections as SYS from several remote databases. The os_user of the remote system is always oracle and there are several different remote hosts involved. I can't figure out how they are gaining access this way. Our SYS password is set to a random string, not the default, and we change it frequently. There are no corresponding telnet sessions indicating access is local from our server, and we also change our oracle password frequently. I know the listener has vulnerabilities and we should apply those patches, but want to be sure we don't have an obvious configuration problem that is allowing these connections. Any ideas? -- init.ora remote_login_passwordfile=NONE remote_os_authent=FALSE -- sqlnet.ora sqlnet.authentication_services=(NONE) Here is a snippet from the audit trail: -- sys.aud$ select timestamp#, userid, userhost, terminal, action# returncode, comment$text from sys.aud$ where userid = 'SYS'; DEC-09-03 15:13:10 SYS UNKNOWN 101 Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.19 2.236)(PORT=63519)) -- dba_audit_session select username,os_username,action_name action,terminal,timestamp,returncode from dba_audit_session where username = 'SYS'; USERNAME OS_USERNAME ACTION TERMINAL TIMESTAMP RETURNCODE -- -- -- -- SYS oracle LOGOFF UNKNOWNDEC-09-03 15:13:10 0 -- listener log 09-DEC-2003 15:13:10 * (CONNECT_DATA=(SID=mnet03bP)(CID=(PROGRAM=)(HOST=hpcad200)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.192.236)(PORT=63519)) * establish * mnet03bP * 0 Thanks, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vordos, Suzy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Could not run export utility from cron job
have you _sourced_ your .profile? cron won't do it automatically for you. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 24 x 7 x 365
i was at an oracle group meeting and one of the RAC specialists at oracle was talking. he said that that kind of thing 'can' be done, but is incredibly expensive. you need redundancy and fail safes like crazy. any time you do an upgrade, bad things may happen. > > From: "Tracy Rahmlow" <[EMAIL PROTECTED]> > Date: 2003/12/10 Wed AM 11:44:25 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: 24 x 7 x 365 > > Hello, > Our company would like to know whether or not Oracle supports true > 24x7x365 availability for an oltp database. We currently are using the > 8.1.7 enterprise edition. Does an architecture exist whereby we can > upgrade the database and/or operating system and not cause an outage? Will > RAC solve this issue? Are there any other areas of concerns that I should > be thinking about? For example, analyzing with the validate clause and > its impacts on the transaction system. Thanks > American Express made the following > annotations on 12/10/2003 09:41:15 AM > -- > ** > > "This message and any attachments are solely for the intended recipient and may > contain confidential or privileged information. If you are not the intended > recipient, any disclosure, copying, use, or distribution of the information included > in this message and any attachments is prohibited. If you have received this > communication in error, please notify us by reply e-mail and immediately and > permanently delete this message and any attachments. Thank you." > > ** > > > == > > Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** ==
Re: Configuring Veritas Netbackup Question
Dwayne, Doesn't the Veritas backup exec Oracle client perform a "HOT" backup of the database? If that is the case then the RMAN backup is performed differently that the hot backup. Read the script that the Oracle client uses to see what is happening. I may be off base with this version of backup exec but it is as I understood the client. Ron >>> [EMAIL PROTECTED] 12/10/2003 2:24:33 PM >>> I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a couple years without a problem. We recently purchased the license for the Oracle module and installed (activated) it (actually, the SA did this while I watched). The database server is a separate Linux (same version) box and the client seems to have been installed. Anyway, I go through the steps to configure Netbackup (setting up a policy, media, etc). All looks good. I create a test script for rman (based on one I know works). When I attempt to run a test backup and I get the message 'Unable to get data from client polar from server phoenix. status 104'. What am I missing? How do I access the client from the host? I noticed the host server does not have Oracle installed (tnsnames, etc.) so my first thought was to do that but wanted to make sure I was right before I went to the SA to do this. Thanks for your help! Sign, Dwayne aka Frustrated One -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parentheses and joins
Jonathan, I didn't realize that parentheses would affect to optimizer to change the join order. A little experimentation shows that it can indeed be done. For anyone that wants to see it, the joins are below. I learn something every day around here. Jared select e.ename , e.empno , d.dname , m.ename from scott.emp e join scott.dept d on d.deptno=e.deptno join scott.emp m on m.empno=e.mgr / select e.ename , e.empno , d.dname , m.ename from scott.dept d join (scott.emp e join scott.emp m on m.empno=e.mgr) on d.deptno = e.deptno / select e.ename , e.empno , d.dname , m.ename from scott.emp m join (scott.emp e join scott.dept d on e.deptno=d.deptno) on m.mgr = e.empno / Jonathan Gennick <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 10:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Parentheses and joins I looking for a good, simple example of when parentheses matter when writing a join query using the new, SQL92 join syntax. For example, I could write: SELECT * FROM county y JOIN city c ON y.county_id = c.county_id JOIN attraction a ON c.city_id = a.city_id; and I could use parens to clarify the join order: SELECT * FROM (county y JOIN city c ON y.county_id = c.county_id) JOIN attraction a ON c.city_id = a.city_id; I could even force a different join order: SELECT * FROM county y JOIN (city c JOIN attraction a ON c.city_id = a.city_id) ON y.county_id = c.county_id; I'm struggling to come up with a good example of when you might *need* to use parens. I'm not having a really good day today. In fact, I'm having a really, really bad day, so maybe I'm not thinking too clearly, but so far I'm unable to come up with a good example to demonstrate the necessity of parentheses. Can anyone help me out with this? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rogue SYS connections
Suzy, Do you use RMAN to perform backups? Do you use a catalog with RMAN? Rman uses sys to perform the connections to the target database. Just a thought, Ron >>> [EMAIL PROTECTED] 12/10/2003 3:09:33 PM >>> Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue connections as SYS from several remote databases. The os_user of the remote system is always oracle and there are several different remote hosts involved. I can't figure out how they are gaining access this way. Our SYS password is set to a random string, not the default, and we change it frequently. There are no corresponding telnet sessions indicating access is local from our server, and we also change our oracle password frequently. I know the listener has vulnerabilities and we should apply those patches, but want to be sure we don't have an obvious configuration problem that is allowing these connections. Any ideas? -- init.ora remote_login_passwordfile=NONE remote_os_authent=FALSE -- sqlnet.ora sqlnet.authentication_services=(NONE) Here is a snippet from the audit trail: -- sys.aud$ select timestamp#, userid, userhost, terminal, action# returncode, comment$text from sys.aud$ where userid = 'SYS'; DEC-09-03 15:13:10 SYS UNKNOWN 101 Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.19 2.236)(PORT=63519)) -- dba_audit_session select username,os_username,action_name action,terminal,timestamp,returncode from dba_audit_session where username = 'SYS'; USERNAME OS_USERNAME ACTION TERMINAL TIMESTAMP RETURNCODE -- -- -- -- SYS oracle LOGOFF UNKNOWNDEC-09-03 15:13:10 0 -- listener log 09-DEC-2003 15:13:10 * (CONNECT_DATA=(SID=mnet03bP)(CID=(PROGRAM=)(HOST=hpcad200)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.192.236)(PORT=63519)) * establish * mnet03bP * 0 Thanks, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vordos, Suzy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Configuring Veritas Netbackup Question
You can get some better diagnostic information by doing the following on the client box: cd /usr/openv/netbackup/logs ./mkdirs.sh if the following directories were not created by the script, create them: /usr/openv/netbackup/logs/user_ops/dbext/oracle /usr/openv/netbackup/logs/user_ops/dbext/logs The oracle directory will have some logs with detailed info. If you just created the directories, you will of course need to make another backup attempt first. HTH Jared Dwayne Cox <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/10/2003 11:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Configuring Veritas Netbackup Question I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a couple years without a problem. We recently purchased the license for the Oracle module and installed (activated) it (actually, the SA did this while I watched). The database server is a separate Linux (same version) box and the client seems to have been installed. Anyway, I go through the steps to configure Netbackup (setting up a policy, media, etc). All looks good. I create a test script for rman (based on one I know works). When I attempt to run a test backup and I get the message 'Unable to get data from client polar from server phoenix. status 104'. What am I missing? How do I access the client from the host? I noticed the host server does not have Oracle installed (tnsnames, etc.) so my first thought was to do that but wanted to make sure I was right before I went to the SA to do this. Thanks for your help! Sign, Dwayne aka Frustrated One -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 24 x 7 x 365
Tracy, both OPS (8i) and RAC (9i)support independent node shutdown. Both support listener based load balancing so that incoming connections will be evenly spread on all nodes. That still doesn't give you the true 24 x 7 x 365 availability. For that, you need two replicated copies of the database, both in OPS/RAC mode. The problem with a single OPS/RAC database is that it has to be shut down for the database upgrade. You cannot have both 8i and 9i instances accessing the same database at the same time, which means that in the case of the database upgrade, all databases in the cluster must be brought down. The only way for production database to remain available after all clustered instances have been brought down is the existence of another copy of your production database, on separate cluster. It is foreseeable that there will be some data discrepancies after the primary configuration is upgraded and brought back online, which means that you must have symmetric replication set up in such a way that your instances can be quickly synchronized. Please, be aware that both configurations, the primary and secondary one must be clustered, because if the secondary database is not clustered, then the instance accessing it becomes the single point of failure, which is what needs to be avoided at all costs. Also, you may decide to limit the meaning of "24 x 7 x 365 availability" and decide that the spare configuration will be available in read-only mode while you are upgrading the primary configuration. That would be the case for a physical standby and playing with EMC BCV-s. In that case, you do not need to set up symmetric replication, because there are no data changes (database is in the read-only mode) but the guys doing upgrade are limited by the time that business may tolerate the database being in the read-only mode. Given the organization you work for, I surmise that a) your database is larger then 10MB and b) that you need it to be fully accessible to the fullest extent of the "24 x 7 x 365" phrase. That probably means that having read-only database for the full two hours is not acceptable. You will need replication. Those two databases should be physically separated in case of catastrophic failure (things that never happen, like big power-grid blackouts, passenger jets crashing into skyscrapers or forest wildfires scorching suburb or two of a major urban area). Of course, network connections must be redundant as well. That would be the true "24 x 7 x 365 availability", but the price tag is really a major number, much more then most companies are willing to spend. Given all the infrastructure and real estate, the price tag probably comes close to 8 zeros range, which is probably what those guys that were hand-picked to test 10g make annually. On 12/10/2003 11:44:25 AM, Tracy Rahmlow wrote: > Hello, > Our company would like to know whether or not Oracle supports true > 24x7x365 availability for an oltp database. We currently are using the > 8.1.7 enterprise edition. Does an architecture exist whereby we can > upgrade the database and/or operating system and not cause an outage? Will > RAC solve this issue? Are there any other areas of concerns that I should > be thinking about? For example, analyzing with the validate clause and > its impacts on the transaction system. Thanks > American Express made the following > annotations on 12/10/2003 09:41:15 AM > -- > ** > > "This message and any attachments are solely for the intended recipient and may > contain confidential or privileged information. If you are not the intended > recipient, any disclosure, copying, use, or distribution of the information included > in this message and any attachments is prohibited. If you have received this > communication in error, please notify us by reply e-mail and immediately and > permanently delete this message and any attachments. Thank you." > > ** > > > == > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual
Re: Configuring Veritas Netbackup Question
Brian, Netbackup does indeed have to be linked to Oracle. I performed this and it seemed to go well (no obvious error messages). -DC- Spears, Brian wrote: Dwayne Cox, Don't know if this is the same problem, but I did run into this and the there had to be a re-linking and a softlink set for a library if I remember correctly. Just an idea to check. I know this stuff is a bugger till you get it working. Brian -Original Message- Dwayne Cox Sent: Wednesday, December 10, 2003 2:25 PM To: Multiple recipients of list ORACLE-L I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a couple years without a problem. We recently purchased the license for the Oracle module and installed (activated) it (actually, the SA did this while I watched). The database server is a separate Linux (same version) box and the client seems to have been installed. Anyway, I go through the steps to configure Netbackup (setting up a policy, media, etc). All looks good. I create a test script for rman (based on one I know works). When I attempt to run a test backup and I get the message 'Unable to get data from client polar from server phoenix. status 104'. What am I missing? How do I access the client from the host? I noticed the host server does not have Oracle installed (tnsnames, etc.) so my first thought was to do that but wanted to make sure I was right before I went to the SA to do this. Thanks for your help! Sign, Dwayne aka Frustrated One -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: char is going away?
Raj, Jonathan 1. I have heard rumors that in other databases the VARCHAR performance isn't good. In fact, some people that are converting from other databases to Oracle are pleasantly surprised that Oracle handles VARCHAR well. 2. I have been curious about Oracle's statement that you should use VARCHAR2. If I was a suspicious person I would say that sounded like a vendor's attempt to encourage proprietary coding, but I'm not suspicious, no way. My point isn't that VARCHAR isn't there, of course it is, but if you were developing an application to sell and support on several different databases, you might consider CHAR as a safer bet. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Oracle has varchar and varchar2 both ... The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types .htm#10824 HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 1:55 PM To: Multiple recipients of list ORACLE-L DW> If your application is COBOL-based, using CHAR DW> simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DW>My understanding is that VARCHAR2 is not even a SQL standard The keyword VARCHAR2 is not in the standard, but a variable-length type is. I think the standard uses CHARACTER VARYING, or something like that. I don't have time to look it up right now. DB2 uses VARCHAR, without the "2". I'm not sure why Oracle is so outspoken against that same keyword. I'd be interested in finding out. Best regards, Jonathan Gennick --- Brighten the corner where you are ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring Veritas Netbackup Question
Dwayne Cox, Don't know if this is the same problem, but I did run into this and the there had to be a re-linking and a softlink set for a library if I remember correctly. Just an idea to check. I know this stuff is a bugger till you get it working. Brian -Original Message- Dwayne Cox Sent: Wednesday, December 10, 2003 2:25 PM To: Multiple recipients of list ORACLE-L I apologize for this *basic* question but I have searched the manuals, Robert Freeman's RMAN book and MetaLink as well as Googled and cannot find the answer. I know its something simple. We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been backing up our netowrk for a couple years without a problem. We recently purchased the license for the Oracle module and installed (activated) it (actually, the SA did this while I watched). The database server is a separate Linux (same version) box and the client seems to have been installed. Anyway, I go through the steps to configure Netbackup (setting up a policy, media, etc). All looks good. I create a test script for rman (based on one I know works). When I attempt to run a test backup and I get the message 'Unable to get data from client polar from server phoenix. status 104'. What am I missing? How do I access the client from the host? I noticed the host server does not have Oracle installed (tnsnames, etc.) so my first thought was to do that but wanted to make sure I was right before I went to the SA to do this. Thanks for your help! Sign, Dwayne aka Frustrated One -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rogue SYS connections
Thanks Ron. No, we use SQL-Backtrack instead of RMAN. However SQL-Backtrack does show a diff flavor of rogue connections of ###NOBODY. The remote database systems that are connecting to our database as SYS are not ones we support. What is common about these databases is they do have logins to our database. Those logins have only 'create session' privileges with select grants on views we created for our application. Suzy -Original Message- Ron Rogers Sent: Wednesday, December 10, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Suzy, Do you use RMAN to perform backups? Do you use a catalog with RMAN? Rman uses sys to perform the connections to the target database. Just a thought, Ron >>> [EMAIL PROTECTED] 12/10/2003 3:09:33 PM >>> Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue connections as SYS from several remote databases. The os_user of the remote system is always oracle and there are several different remote hosts involved. I can't figure out how they are gaining access this way. Our SYS password is set to a random string, not the default, and we change it frequently. There are no corresponding telnet sessions indicating access is local from our server, and we also change our oracle password frequently. I know the listener has vulnerabilities and we should apply those patches, but want to be sure we don't have an obvious configuration problem that is allowing these connections. Any ideas? -- init.ora remote_login_passwordfile=NONE remote_os_authent=FALSE -- sqlnet.ora sqlnet.authentication_services=(NONE) Here is a snippet from the audit trail: -- sys.aud$ select timestamp#, userid, userhost, terminal, action# returncode, comment$text from sys.aud$ where userid = 'SYS'; DEC-09-03 15:13:10 SYS UNKNOWN 101 Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.19 2.236)(PORT=63519)) -- dba_audit_session select username,os_username,action_name action,terminal,timestamp,returncode from dba_audit_session where username = 'SYS'; USERNAME OS_USERNAME ACTION TERMINAL TIMESTAMP RETURNCODE -- -- -- -- SYS oracle LOGOFF UNKNOWNDEC-09-03 15:13:10 0 -- listener log 09-DEC-2003 15:13:10 * (CONNECT_DATA=(SID=mnet03bP)(CID=(PROGRAM=)(HOST=hpcad200)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.192.236)(PORT=63519)) * establish * mnet03bP * 0 Thanks, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vordos, Suzy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vordos, Suzy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: char is going away?
Yes, they keep saying that varchar may change in future releases, so use varchar2. Maybe they'll finally use it. But for what I don't know. -Original Message- Sent: Wednesday, December 10, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Raj, Jonathan 1. I have heard rumors that in other databases the VARCHAR performance isn't good. In fact, some people that are converting from other databases to Oracle are pleasantly surprised that Oracle handles VARCHAR well. 2. I have been curious about Oracle's statement that you should use VARCHAR2. If I was a suspicious person I would say that sounded like a vendor's attempt to encourage proprietary coding, but I'm not suspicious, no way. My point isn't that VARCHAR isn't there, of course it is, but if you were developing an application to sell and support on several different databases, you might consider CHAR as a safer bet. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Oracle has varchar and varchar2 both ... The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types .htm#10824 HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 1:55 PM To: Multiple recipients of list ORACLE-L DW> If your application is COBOL-based, using CHAR DW> simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DW>My understanding is that VARCHAR2 is not even a SQL standard The keyword VARCHAR2 is not in the standard, but a variable-length type is. I think the standard uses CHARACTER VARYING, or something like that. I don't have time to look it up right now. DB2 uses VARCHAR, without the "2". I'm not sure why Oracle is so outspoken against that same keyword. I'd be interested in finding out. Best regards, Jonathan Gennick --- Brighten the corner where you are ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e
Re: Windows clustering???
Maybe you all already know that, but HP is planning to support OpenVMS on their Itanium servers :) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 10:14 PM > I'm guessing they're not running Oracle on this VMS cluster. I really liked > the part about "the most difficult part was explaining to managers why it > was unnecessary to shut systems down, even during the physical relocation." > > http://www.theinquirer.net/?article=13002 > > Imagine if DEC had any marketing... > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 24 x 7 x 365
Hi, Unfortunately I'm gonig to add the negative view, like several others have... True 24x7x365 (good pick-up Pete on the 7 year thing) will be limited by much more than database and operating system availability. We just did a major software upgrade last weekend and part of the upgrade involved the conversion of 250+ million records in the database - that takes time no matter what. Yes, with unlimited budget and time constraints we could get the outage down to nothing but at the end of the day it's easier for the business to manage an outage. Our system was offline for a total of about 10 hours yet traffic drives on our tollroad all the time so: The roadside is designed to backlog transactions for several days, our system has capacity to catch up backlogs fairly fast (within a day we had caught up again), we have an alternative front-end system that can backlog feeds, and finally we designed our conversion process to do as much as possible before the outage. We are also on 8.1.7 enterprise and don't use OPS/RAC - instead we have the alternative processes in place to ensure the business can function. Perhaps your company can consider a similar alternative? As others have said - it can be VERY difficult to remove every possible outage and it can be much easier to manage a small outage every few months. Regards, Mark. "Tracy Rahmlow" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> xp.com> cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED] .com 11/12/2003 03:44 Please respond to ORACLE-L Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** == <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy t
Re: leaf node 90-10 splits
Hi! SQL> select * From v$sysstat where name like '%split%'; STATISTIC# NAME CLASS VALUE -- -- -- 195 leaf node splits 128612 196 leaf node 90-10 splits 128209 197 branch node splits 128 3 I did a little test few days ago (using stats & treedumps): If you insert an equal or larger key to the current max value in a full leaf block *within the transaction which filled the block*, just a new leaf block is added to index and "leaf node 90-10 splits" statistic is incremented. If you commit in the meantime, before "overflowing" the block, then the leaf block is split 50-50 and "leaf node splits" stat is incremented. So, Oracle 9.2 cares about transactions as well, in addition to checking key values... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 5:39 PM > Hi, Tanel, > > Where do you see this statistic? I only see "leaf node splits" in 8.1.7 and 9.2 > documentation. If the index is on strictly monotonically increasing numbers, > won't a new node be added to the right without a block split? > > Yong Huang > > > I wonder why does statistic "leaf node 90-10 splits" imply that right-hand > > index leaf block is split as 90-10, not 100-0 as it really is. (tested on > > 9.2.0.4 W2k). > > > > Historical reasons? > > > > Tanel. > > __ > Do you Yahoo!? > New Yahoo! Photos - easier uploading and sharing. > http://photos.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).