Logical Standby: Included with Standard?
This URL lists "Data Guard", the umbrella name for slew of high-availability features, as Enterprise-only:http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96653/toc.htm However, it lists Standby Databases as included with Standard. The manual that documents how to set up a logical standby database, however, is called "Data Guard Concepts and Administration". So which is it!? :-) Logical Standbies are included with Standard... or not included and available only with Enterprise? Thanks,Paul
Re: Wrong Results Bug in Oracle 8.1.7.1
ainst the component tables of the
> view work fine.
>
>>--
> >>The view text is
> >>
> >>CREATE VIEW SYSADM.PS_VCHR_MM_VW
> >>AS
> >>SELECT DISTINCT A.BUSINESS_UNIT, A.VOUCHER_ID,
> A.INVOICE_ID,
> >>A.INVOICE_DT, A.PROCESS_INSTANCE,
> A.ENTRY_STATUS, A.POST_STATUS_AP,
> >>A.MATCH_ACTION, C.PPV_POST_FLG, C.ERV_POST_FLG,
> A.ORIGIN FROM
> >>SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C
> WHERE A.BUSINESS_UNIT =
> >>C.BUSINESS_UNIT_AP AND A.VOUCHER_ID =
> C.VOUCHER_ID AND
> >>A.MATCH_ACTION IN ('Y', 'E')
>
>>--
---
> >>If I run the select statement outside of the view
> and tack on the 'voucher_id = ' clause
> >>SELECT DISTINCT A.BUSINESS_UNIT, A.VOUCHER_ID,
> A.INVOICE_ID,
> >>A.INVOICE_DT, A.PROCESS_INSTANCE,
> A.ENTRY_STATUS, A.POST_STATUS_AP,
> >>A.MATCH_ACTION, C.PPV_POST_FLG, C.ERV_POST_FLG,
> A.ORIGIN FROM
> >>SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C
> WHERE A.BUSINESS_UNIT =
> >>C.BUSINESS_UNIT_AP AND A.VOUCHER_ID =
> C.VOUCHER_ID AND
> >>A.MATCH_ACTION IN ('Y', 'E')
> >>and a.voucher_id = '3394'
> >>/
> >>
> >>I get the expected results. The query plan
> matches the one for the failing statement.
>
>>--
> >>If I select more than voucher_id from the view
> with the 'voucher_id = ' predicate
> >>the other fields are projected correctly, but
> returns voucher_id as null.
>
>>==
=
> >>
> >>Ian MacGregor
> >>Stanford Linear Accelerator Center
> >>[EMAIL PROTECTED]
> >>
> >>
> >>
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Joe Testa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: MacGregor, Ian A.
> INET: [EMAIL PROTECTED]
>
=== message truncated ===
=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Barnett
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Vallee
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: so when did you switch from NT to unix for oracle
Hi Mogens, What I wouldn't do to be a fly on that wall. Oh, the interesting discussions to be had! :-) I too have thought long and hard about this industry trend, and it has remarkable ramifications that we should all be aware of. One implication that you don't mention is the clear advantages of the federated shared-nothing architecture Microsoft currently has the lead in versus the shared-disk solutions that Oracle is an expert in. With a federated approach, you can afford to use "disposable" servers and provide excellent scalability. With cheaper machines and operating systems providing fantastic performance but substandard stability, a federated approach gets you out of the woods. I am hoping Oracle picks up on this soon. However, I would like to voice my opinion that there is precious little missing from Linux. It used to be that the filesystems were lagging, but we've gotten excellent (I do not use that term lightly) performance from SGI's XFS filesystem. IBM's JFS is also available, as are some native filesystems. We run Linux in production for many customers, and where we do run into trouble, it's almost never as a result of the Linux. We do occasionally have difficulties because the hardware subsystems are not well-chosen and tuned to each other, however. Interestingly, the one company created to solve this problem, VAResearch, no longer creates hardware because it couldn't find a market. This vacuum is being quickly filled in by IBM and Dell, however. Should a company be willing to spend a comparable amount annually with their Linux provider and their hardware provider that they would give to (for instance) Sun Support, I believe they could easily achieve comparable levels of hardware and software reliability than any other commercial unix. Cheers, Paul - Original Message - From: Mogens Nørgaard To: Multiple recipients of list ORACLE-L Sent: Monday, May 27, 2002 1:18 PM Subject: Re: so when did you switch from NT to unix for oracle Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies available on the oak table: Bowmore and Ardbeg. Provocative Thoughts (aimed at generating discussion, please): Basically a P4 processor can run circles round a Unix processor today (in other words: Unix processors are loosing the battle). A customer today would get most bang for the buck by bying Intel instead of Unix processors. The problem, of course, is that you can only choose between Windows and Linux on the Intel platform. If - this is no longer a choice - you could choose Solaris on Intel, you would get so much bang for the buck that nothing could compete with it. If Intel could handle many processors that would be interesting, too.I think Unix processors are dying. I didn't like it when VMS died (because it's the best operating system that was ever built). But it died. Now what?MogensHemant K Chitale wrote: Aah ! You _are_ looking at moving out of NT.Why I don't think it is an enterprise class platform 1. Much poorer memory management [2GB, memory leaks etc]than Unix. 2. Cannot scale beyond 4 CPUs.I AM surprised that you run a 450 users SAPapplication on 4CPU, 2GB on NT. Try that withOracle Applications ! 3. Any patch (e.g. the security patches that come outfrom Microsoft) requires a reboot of the server. I canunderstand OS patches requiring a Unix reboot but apatch to MSIE/Outlook/IIS on the same NT-box as thedatabase requiring a reboot of the server ? Unacceptable. 4. I don't know how good Online Backups are on NT.Hemant K Chitalehttp://hkchital.tripod.com- Original Message -To: "Multiple recipients of list ORACLE-L" Sent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run.2) We have a few reasons to switch to another platform.I'm lobbying for Solaris with Veritas Database Edition. Manygood reasons for doing so, but I'm beginning to have mydoubts about financing it.One of our current projects is to put in place an enterpriseclass backup and recovery system. The current one is lackingin several respects.One of damagement's questions: "What happens if we do nothing?"Another was "What's the ROI?"PHB's abound.JaredOn Friday 24 May 2002 08:03, Hemant K Chitale wrote: No way ! You're pulling a lot of legs[and hurting a lot of egos who take pride inpointing out that NT is _not_ an enterprise-classplatform, me included].Hemant K Chitale- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Friday, 24 May, 2002 8:00 AM How about 250 Gig, 450 users on SAP 4.0B?4 Cpu's 2 Gig Ram.Stop making me defend NT!!Jared"Disser, Arno" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECT
Re: ioug-a question
James Morle's "Scaling Oracle8i" is my favourite book on Oracle performance, and covers the wait interface excellently. Highly recommended. Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 6:48 AM Yes, I forgot to mention Gaja's book, and there is a book out there Oracle DBA 101, that has a complete section (2nd or 3rd) about tuning by wait interface/YAPP. Anjo. Greg Moore wrote: > > 2001 - a lot of books are published with wait > > interface / YAPP methodology > > Tuning 101 gets a lot of play here, and they devote a chapter to it. Other > than that, what books cover waits in a significant way? Thanks. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Number of CPUs vs. Speed of CPUs
If pricing is a factor, and you're considering per-cpu pricing, then lean towards fewer, faster CPUs. I think Intel announced a 2Ghz processor this week... :-) Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 11:58 AM We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
Hi Richard, Consider hiring Steve Adams (Ixora) to work for you. His rates are reasonable and he has worked problems exactly like this dozens of times. He is the most competent troubleshooter of these types of problems I have ever worked with and I highly recommend you consider retaining his services. That being said... :-) Your shared pool size of 1G is ridiculous. Try 150M, unset spin_count, throw the rest in db_block_buffers, and please show us the statspack output after that. Also, go to www.ixora.com.au, and download a few scripts: latch_sleeps.sql, latch_where.sql. The output might be interesting. Finally, run a select * from v$sqlarea where version_count > 100. Any sql statement in that list is probably part of your problem, and finding out why it's getting invalidated will be part of your solution. HTH, Paul ---www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more. - Original Message - From: Paul Troiano To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 17, 2002 11:48 PM Subject: Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long) Never mind. I just saw that oracle was able to reproduce it internally. - Original Message - From: Richard Eastham To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 16, 2002 11:58 PM Subject: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long) A co-worker is having a fairly serious issue with performance tuning of a system. The system is in the stress testing phase prior to rolling out into production. I have not included all the information as so far they have exceeded three TARs and are working on the fourth one right now. Oracle has become fairly heavily involved and is sending in the Advanced services team is now involved. He has identified that the main issue is a wait after the parsing of the SQL and during the fetch portion of the execution. The short version is running the same SQL statement ( basically nothing more than a simple query against a single table) the machine starts bogging down with a simulated 20+ users sessions and the system starts to choke at 100+ user sessions. We are talking a fairly decent midrange system. The query is a select with 5 columns extracted and a where clause that uses the in clause to select the same rows for each query. The question is has anyone seen this type of behavior before? If you have seen this before what was the root cause? Did you find a solution? Oracle acknowledges that the scenario is reproducible within their test environment, but the core team is stating that it is working as designed. Oracle is working with us, but why not check with other sources. A summary of where we are at: (4th TAR) We tried to simulate the same performance degradation on an entirely different environment. We have been able to do the same. We had requested Oracle to simulate the test case in their environment. They have been able simulate the performance degradation. Their analysis is also provided in this attachment. To summarize, they have simulated where 1 user query runs in 2 seconds and 10-user query takes 7 seconds on a 4-processor server. The development team of Oracle has answered to this degradation as normal and as designed. However, the degradation is very high and is in contrast with their alleged benchmark results (67000 transactions per minute on a 8 processor hardware). For us the degradation is so high that we are not able to run 150 transactions per minute on a 4-processor server. The simulation within oracle also supports this degradation 15-APR-02 22:09:08 GMTPasting information into the tar on bug:2321553 since currently unavailable on MetaLink:"PROBLEM:Customer has a production database that was installed on a Sun Solaris 2.8. The Solaris was a fresh install. The database was a fresh install. Customer is having the following problems:.1. Performance problems with multiple users - more users more performance problems2. The query runs fine, explain plan runs fine, query just takes moer time with more users - same query3. Customer tested multi-user connection from the box via sqlplus ( no network ) - same issue4. Customer removed the application from the env and ran multi-user test - same problem.5. Customer loaded data in another 8.1.7 database on Win 2000 - same performance problem wit
Re: UNIX hardware sizing for multiple instances
Hi Peter, disk space... you'll want a healthy margin here, enough to take hot backups, keep a day's worth of archived redo, etc. The other thing when buying disk nowadays is remembering that disk storage capacity (in MB) has increased dramatically faster than disk IO capacity (in MB/minute). You'll have to ensure that however much you buy, it can handle not only your storage requirements but also your IO requirements. Some SAs have been known to only format the inside 25% of each platter because of IO needs outweighing storage capacity. physical memory... don't forget to calculate additional memory for your instance processes and background processes! number of processors... although oracle was designed to use multiple processors (or multiple threads on NT) acting simultaneously, oracle's current pricing model encourages you to use few (or one!) very fast processors instead. My understanding is that a single very fast processor can give excellent oracle performance. Interestingly, I understand that there is a significant performance advantage to using 8MB secondary caches instead of 4MB caches, as the bulk of the active oracle executable code is then op-code cached. Hope this helps, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 3:18 PM My group has requirement to run three, possibly four, instances of Oracle (8.1.7, most likely) on a UNIX server (AIX, if that matters). We are considering separate instances because the software comes from three different vendors. The fourth database will be ours and may be able to run on one of the other three instances. For determining the size of the server we are using the following guidelines: disk space = amount needed for the o/s (including virtual memory) + Oracle software + data files physical memory = amount needed for the o/s + total sizes of the SGA for all instances number of processors = at least two processor speed = somewhere in the middle range We are assuming that the processors do not have to be blindingly fast for a database server. We are also assuming that the number of processors is more important than their speed. So my questions are: 1. Are we on the right track with the physical memory calculation? 2. Should we figure in an additional amount of memory for each dedicated server process, assuming that we will not be using MTS? 3. What criteria should we use to determine number of processors? 4. Any other comments about our calculations and assumptions? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: WHICH UNIX FOR ORACLE?
Hi Raj, list Few systems running Oracle require market-leading performance to function well. (There are some, don't get me wrong.) So I believe that even if an architecture is slower it can be more appropriate if it's priced right and has other important characteristics. Also, the highest-end machines of the slowest architecture can easily stomp on the mid-range machines of the other architectures. We all agree on that. However, it's my understanding (eager to learn!) that HP is still losing in overall CPU performance to IBM, Sun and Digital/Compaq as a result of the neglect the PA-RISC architecture suffered at the hands of Rick Belluzo. I know that HP has reinvested vast sums of money into it because of the IA-64 delays, but last I heard it had improved things dramatically but not yet enough. Here are some references. Again, I'm very interested in this subject as I'm often called upon to recommend hardware purchases and platform selections. :-) >From http://www.itworld.com/Comp/2149/swol-0119-flavors/ (where the other suspects are also reviewed) Hewlett-Packard HP-UX Current release: HP-UX 11i Platform: HP 9000 servers Standard: Unix 95 Application score: 9 out of 10 Advantages: HP has a solid reputation for reliability and service; HP-UX comes with a substantial OS bundle including a Web server, C/C++, Windows networking, WAP (Wireless Application Protocol) services, Linux APIs, iPlanet directory server, and Veritas file system. Disadvantages: HP PA-RISC architecture is falling behind in performance relative to the competition. Prognosis: Hewlett-Packard is the Volvo of IT: It quietly churns out ugly, bulletproof boxes that virtually care for themselves. HP is rarely first or fastest, but it packs enormous value into its Unix products. Not surprisingly, HP-UX is almost Linux-like in its completeness, with time-proven enterprise tools and services included in the bundle. HP's inclusion of the Veritas journaling file system moves HP-UX 11i to the front of the pack. Once HP catches up to rivals' performance and certifies HP-UX as Unix 98-compliant, it could move ahead of Sun and IBM. from... http://www.chipcenter.com/eexpert/dgilbert/dgilbert050.html "Hewlett Packard was the first manufacturer to pursue the advantages of using Intel chips in both 32-bit and 64-bit system architectures, and they played a vital role in the development of the new Itanium architecture. This path was taken to get away from pouring more money into their PA-RISC chips, among other reasons. Now the only two "players" left in the 64-bit RISC game are IBM and Sun Microsystems. IBM has effectively unlimited "staying power" since they can perform all levels of chip design and production in-house. Sun Microsystems does not enjoy this autonomy since they outsource their manufacturing to Texas Instruments, and it is likely that this factor may ultimately hinder their ability to continue providing their own architecture of RISC processor for the server and workstation market. Is it just a matter of time before we are left with Intel and IBM? Will the RISC architecture be able to carry forward in the server and workstation market?" And although this following article has a IBM bias (because of the association with Apple Computer), it's an interesting read that covers the history of the PA/IA-64 fiasco well: http://www.macedition.net/soup/soup_20020318.php Cheers, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 10:48 AM Paul, I am glad you are on your way to 'controlled molecular restructuring and HP-iozation' (??!) ..;) Mind telling me What made you say HP's is losing performance race..? I am on HP mid level (N class) 4 way server 64 bit and our Database is 210 Gigs High end OLTP database with > 12 TPS and severe response time restrictions(1 sec or less.) I am beating the response time by several milliseconds and I haven't even maxed out the processors yet...!! HTH Cheers, RS --- Paul Vallee <[EMAIL PROTECTED]> wrote: > This is great information Raj. I've run a test that > is completely consistent > with this. > > For instance: Go to Metalink and click the "Patches" > item in the left menu. > Then choose product family "Oracle Server" and > product "RDBMS Server", > release "9.0.1.3". > Select the "HP9000 Series HP/UX 64-bit" platform and > choose "All Product > Patches". > > Repeat for "Sun Sparc Solaris". Although the Sun > list is quite lengthy > compared to
Re: WHICH UNIX FOR ORACLE?
This is great information Raj. I've run a test that is completely consistent with this. For instance: Go to Metalink and click the "Patches" item in the left menu. Then choose product family "Oracle Server" and product "RDBMS Server", release "9.0.1.3". Select the "HP9000 Series HP/UX 64-bit" platform and choose "All Product Patches". Repeat for "Sun Sparc Solaris". Although the Sun list is quite lengthy compared to most other platforms (7 entries), the HP list has significantly more patches (15 entries). For me, this is a significant decision influencer when choosing a platform for Oracle. However, HP is definitely losing the performance race... :-) Tough one. Thanks again, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 2:32 PM Paul , ORACLE switched from solaris to HP-UX somewhere in mid 2000 for their tier I platform. ALso I think at this time compaq and HP are the only true 64 bit architectures available. That of course swings the scale in HPs favour...:) Cheers, RS --- Paul Vallee <[EMAIL PROTECTED]> wrote: > Might as well get my two cents in... :-) > > 1. Solaris > Tied for 2... AIX, Tru64, HP/UX > > (leaving NUMA out of the equation for now. If you > like NUMA, then look into > the status of IBM's acquisition of Sequent, I'm out > of touch with that right > now.) > > Different hardware solutions from different vendors > have different > performance, stability and cost characteristics, and > so I'll assume that all > vendors have an appropriate solution on these > factors, this may not be the > case. > > With these assumptions, the primary factor for me is > the timeliness of the > availability of releases, patches and patchsets. Sun > Solaris 32-bit is the > winner on this factor on the grounds that it is > Oracle's internal > development platform. All other platforms are ported > from Sun Solaris > 32-bit. When that changes, my recommendation would > of course also change, as > it did when Oracle moved away from Digital/VMS. > > Anyone who has been in a situation where a bug was > causing service failure > and who heard that a patch was available for Solaris > but not your platform > knows where I'm coming from on this one. > > Note: for the exact same reason, never use 64-bit > Oracle on Solaris unless > you absolutely need the very-large-sga support. > 64-bit Oracle on Solaris is > slow to get patches and releases. > > Best, > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has > new services for > supplementing DBAs: get our help with monitoring, > 24x7 on-call, daily > verifications, storage management, performance and > more. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, April 04, 2002 12:48 PM > > > What are you planning..? A religious war..:) > well..here is my 2 cents,IMHO > 1. HP-UX > 2. SOlaris > 3. AIX > > in the order of preference. I have worked with all > three and I found HP machines to be reliable and > HP-UX easy to work with. This is not to say solaris > is > not but I had some nightmare stroies to tell about > the > bugs and quality of support from SUN. Again this is > only my opinion and as everybody knows OS is ,to > some > extent ,a matter of personal choice also. > ( Running to put on flame proof suit..:) ) > > Cheers, > RS > --- "Bunyamin K. Karadeniz" > <[EMAIL PROTECTED]> wrote: > > We are searching about which unix is best ? > > We will apply 9ias and 8.1.7 DB . plus Oracle > > Portal. > > Can you direct me to a link for comparison about > > SOLARIS , AIX , HP-UX for performance and other > > options .. > > Thank you ... > > > > > > Bunyamin K. Karadeniz > > Oracle DBA / Developer > > Civilian IT Department > > Havelsan A.S. Eskisehir yolu > > 7.km Ankara Turkey > > Phone: +90 312 2873565 / 1217 > > Mobile : +90 535 3357729 > > > > The degree of normality in a database > > is inversely proportional to that of its DBA. > > > > > > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://ta
Re: WHICH UNIX FOR ORACLE?
Lisa, you're right of course. I should have said: 1. Sun Solaris 32-bit 2. (Tie) HP/UX, AIX, Tru64, Sun Solaris 64-bit 3. Linux (comparable to above except lack of dependable commercial support can make it scarier. Has anyone purchased commercial support for any Linux and can they please compare it to commercial support from the other UNIX vendors for me?) 4. Windows NT. I am not against Oracle on Windows on principle or anything, but my experience is that managing Oracle on Windows is more annoying and frustrating than on any UNIX. 5. IRIX, DYNIX/ptx. Fears that these platforms are dying fast push them to the bottom of the list, even though in the past I had high hopes for them. IRIX's XFS filesystem and NUMA support promised an excellent Oracle platform, but without the sales I think it's rough. DYNIX of course is Sequent's NUMA platform, and again this had greatness potential. Oh well. :-) I should also echo another poster that in my experience the most stable hardware for the dollar is from HP. However, HP made a serious blunder by ignoring their PA-RISC chipset in favour of IA-64 that is yet to come... buying an HP server today means buying a SLOW server. I believe the same will happen to Alpha, although as of now I still think there are excellent buys there. Again, more stable hardware then Sun unless you're using DECSafe, which really should be renamed 'cause it causes many more stability problems than it fixes. ADVFS is a big bonus for Tru64 as well, with the other platforms you need to license Veritas to get a filesystem anywhere near as nice. Sun's major advantage is that it's got fast hardware and very mainstream operating system software, plust the advantages I mention in my other post. Crappy bundled filesystem means you have to give some money to Veritas though. IBM's AIX platforms are very stable, and my favourite thing about them is just how tested and trustable their OS patches are. They are easy to apply and I've never had nor heard of any ever needing to be backed out because of failure. This is not the case for any of the other OS platforms... :-) Filesystem-wise, JFS is OK. Cheers, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 1:28 PM I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP, it was Windows. Who cares that it's not as stable as I would like. You should have seen the VP grin at me with this patronizing smile when he said, "I'll approve $35,000 for this project!", like he had done me a huge favor. I wanted to growl. > -Original Message- > From: Paul Vallee [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 1:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: WHICH UNIX FOR ORACLE? > > Might as well get my two cents in... :-) > > 1. Solaris > Tied for 2... AIX, Tru64, HP/UX > > (leaving NUMA out of the equation for now. If you like NUMA, then look > into > the status of IBM's acquisition of Sequent, I'm out of touch with that > right > now.) > > Different hardware solutions from different vendors have different > performance, stability and cost characteristics, and so I'll assume that > all > vendors have an appropriate solution on these factors, this may not be the > case. > > With these assumptions, the primary factor for me is the timeliness of the > availability of releases, patches and patchsets. Sun Solaris 32-bit is the > winner on this factor on the grounds that it is Oracle's internal > development platform. All other platforms are ported from Sun Solaris > 32-bit. When that changes, my recommendation would of course also change, > as > it did when Oracle moved away from Digital/VMS. > > Anyone who has been in a situation where a bug was causing service failure > and who heard that a patch was available for Solaris but not your platform > knows where I'm coming from on this one. > > Note: for the exact same reason, never use 64-bit Oracle on Solaris unless > you absolutely need the very-large-sga support. 64-bit Oracle on Solaris > is > slow to get patches and releases. > > Best, > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new se
Re: WHICH UNIX FOR ORACLE?
Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the equation for now. If you like NUMA, then look into the status of IBM's acquisition of Sequent, I'm out of touch with that right now.) Different hardware solutions from different vendors have different performance, stability and cost characteristics, and so I'll assume that all vendors have an appropriate solution on these factors, this may not be the case. With these assumptions, the primary factor for me is the timeliness of the availability of releases, patches and patchsets. Sun Solaris 32-bit is the winner on this factor on the grounds that it is Oracle's internal development platform. All other platforms are ported from Sun Solaris 32-bit. When that changes, my recommendation would of course also change, as it did when Oracle moved away from Digital/VMS. Anyone who has been in a situation where a bug was causing service failure and who heard that a patch was available for Solaris but not your platform knows where I'm coming from on this one. Note: for the exact same reason, never use 64-bit Oracle on Solaris unless you absolutely need the very-large-sga support. 64-bit Oracle on Solaris is slow to get patches and releases. Best, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 12:48 PM What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies to tell about the bugs and quality of support from SUN. Again this is only my opinion and as everybody knows OS is ,to some extent ,a matter of personal choice also. ( Running to put on flame proof suit..:) ) Cheers, RS --- "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]> wrote: > We are searching about which unix is best ? > We will apply 9ias and 8.1.7 DB . plus Oracle > Portal. > Can you direct me to a link for comparison about > SOLARIS , AIX , HP-UX for performance and other > options .. > Thank you ... > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > The degree of normality in a database > is inversely proportional to that of its DBA. > > __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Congratulations, Ari! + FYI: 9i usage survey
> Congratulations to the winners. Michael Abbey, popular speaker, author, and > Oracle guru returns to the board. Not to mention popular Pythian DBA! :-) Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 4:34 PM Hi all, Came across this on the IOUG page: Results of the IOUG Board of Directors Election. The Winners are... 13-MAR-02 Michael Abbey - 48.5% of voters Kimberly Floss - 45.6% of voters Karen Langley - 41.5% of voters Ari Kaplan - 40.3% of voters Congratulations to the winners. Michael Abbey, popular speaker, author, and Oracle guru returns to the board. Kimberly Floss and Karen Langley were re-elected by the membership and will continue their efforts on behalf the of the Oracle user community. Ari Kaplan joins the IOUG Board of Directors for the first time. The community looks forward to his insights and contributions. JK: Congratulations, Ari! You owe us one. Results of 9i Migration Survey Completed by OTN and IOUG Members 11-MAR-00 - 20% of respondents have installed Oracle9i. This number has climbed from 10% in July to 28% in November to 43% in January 2002 - 77% of respondents plan to use Oracle9i for production applications within the next 12 months - 41% plan to move all application to 9i, while 37% plan to move some applications, and 22% plan to deploy only new applications on Oracle9i - 74% of respondents rate Oracle9i as very innovative - 52% of respondents plan to migrate non-Oracle databases to 9i John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off Topic: PGP
Hi Beth, Contrary to popular belief, open source software is usually considered _much_ more secure than the non-freeware, especially when it comes to encryption. Most of the most secure encryption algorithms are free and public, thus their strength derives from mathematical proofs and not from obscurity. If what you are looking for is commercial support for whatever software you choose, commercial support for GnuPG is available via a company founded by one of the original authors, http://www.g10code.com/. Nonetheless, there is a list of all current openpgp members available here: http://www.openpgp.org/. Some sell commercial products that you may be more comfortable with. I continue to recommend GnuPG! :-) Best regards, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 3:33 PM Ok, I did a little more research and I still need help. Our vendor would prefer we not use a freeware version, which I can understand. So I went out to pgp.com, which used to be Network Associates and is now McAfee. I tried to find a sinmple PGP product that I can use to encrypt my one file, once a month. The only think that I can find that will let you do encryption is the McAfee EBusiness Server which is $12K. Does anyone know if there is such a thing as a commercially available, simple, command-line driven pgp utility? TIA again, Beth -Original Message- Sent: Friday, March 22, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Hello, Use GPG... is a pgp clone but GNU software so no crummy licenses. www.gnupg.org. Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 11:04 AM NT freeware can be found at: http://web.mit.edu/network/pgp.html But be warned--I've heard some horror stories about the NT install. I've never had problems myself, but know of cases where machines have been rendered inoperable... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, March 22, 2002 7:03 AM To: Multiple recipients of list ORACLE-L Does anyone know of any good PGP implementations for WinNt or Openvms? Are there any free ones? TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FA
Re: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
out" overseas because of their lower rates. > It is a very > interesting situation that I am quietly observing. The world > is indeed > becoming smaller. > > I have carefully worded this email in the hopes that I do not > offend some of > the VERY talented/god-like DBAs we have on this list that > come a variety of > locations around this great planet. I hope that I have succeeded. > > -Original Message- > Sent: Monday, March 25, 2002 3:04 PM > To: Multiple recipients of list ORACLE-L > > > Yeah, does anybody know what happened to the new Internet concept of > "location doesn't matter"? I thought by now I could be sitting at home > taking DBA assignments all over the country, if not over the world? > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
ple recipients of list ORACLE-L > > > Yeah, does anybody know what happened to the new Internet concept of > "location doesn't matter"? I thought by now I could be sitting at home > taking DBA assignments all over the country, if not over the world? > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off Topic: PGP
Hello, Use GPG... is a pgp clone but GNU software so no crummy licenses. www.gnupg.org. Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 11:04 AM NT freeware can be found at: http://web.mit.edu/network/pgp.html But be warned--I've heard some horror stories about the NT install. I've never had problems myself, but know of cases where machines have been rendered inoperable... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, March 22, 2002 7:03 AM To: Multiple recipients of list ORACLE-L Does anyone know of any good PGP implementations for WinNt or Openvms? Are there any free ones? TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REDUCE DOWN TIME
This method doesn't do the defragmentation Seema is hoping for, though. Seema, you're aware that fragmentation is no longer as big an issue as it was in the olden days, right? :-) Kevin's approach here is definitely the downtime minimization king. Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 4:59 PM 2 items here: (This assumes that the Database Instance is only used for this single purpose). First, don't bother with an export. FTP the files over when the DB is down. This way you do not have to take the time of an unnecessary Export/Import. When the files are on the new server you can immediately bring it up. Point the users to this server now. But, there is a beter way to do this. STANDBY Databases. 1. Put DB on SV1 into Archive Mode. 2. Shut down DB on SV1. 3. Copy the files to an alternate local directory. 4. Bring up DB on SV1. 5. FTP the files from the alternate location to their correct location on SV2. 6. Bring up DB on SV2 into Standby Mode. 7. At different times during the day bring the Archive files from SV1 to SV2. 8. Apply these logs to DB on SV2. This can go on until you need to make the DB on SV2 active. 1. Shutdown DB on SV1. 2. Bring Archive files that are left on SV2 over to SV2. 3. Apply these logs on SV2. 4. Bring the DB on SV2 up as a normal Database. Your only down time is the initial copy of files and then a small time of copying over the last of the archive logs when you have to switch. You can even add a step at the end of the process to bring down the DB on SV2 and copy the files out before you open it up to the users. This way you can copy the files over to SV1 and get it ready as a standby to SV2. For information on this take a look in the manuals under Standby Databases. -Original Message- Sent: Friday, March 01, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Hi I want to switch from one server to another serevr with minimun down time of site.I am using export/import because removal of fragmentation. The folowing is my idea -export consistent=y on server1 -Ftp export files into serevr2 -Drop fragmenetd tablespace and recreate it -run import at schema level on server2(IMPORT is taking too much time) -Point the site to server2 But I am worry about those data which will loss during ftp time and import time.How to sync both server at particular time keeping in view with less down time of site. Can Incremental export/import help us to minimize the site down? Let me suggest please. -sEEMA _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REDUCE DOWN TIME
Hi Seema, I'll repurpose a message I sent to another list... I think it's relevant, let me know if it helps. Approach 1) One approach that might work reasonably well is to set up prebuilt-table snapshots on the 8i instance based on the 7 tables. You would have to verify that this works, but I think it might. If it does, once the snapshots are set up, and refreshing every ten minutes or so, you could halt work on the 7 database, refresh one last time, drop all the snapshots on the 8i database, and cut over (switch IP addresses if necessary, etc.) The things that can often cause this approach to fail, however, are (1) version incompatibiliy; i.e. can't do snapshot replication from 7 to 8i, and (2) inadequate horsepower on the v7 machine to sustain both the snapshot log maintenance, the snapshot refresh work, and the regular workload. If you can work through those problems, however, you can cut downtime to under 15 minutes with this method. Approach 2) Import/Export, but with a twist or two. The fun thing about this approach is that it can be highly rehearsed and tuned ahead of time. An export is essentially a read of the database coupled with a write to disk. Then you'd normally have to copy that file over to the target server, and then you'd have to read it from disk and write it to the database. That's extremely inefficient and you'd want to avoid that. Instead, set up some named pipes on the fastest server (mkfifo on sun, mknod on tru64, if I remember correctly). Then, export from the source server into the named pipe (over sql*net). Then, import from the same named pipe into the target database. Presto! The network bandwidth, the read from the source db, and the write into the target db are all done simultaneously. Now, on to tuning this approach. This will require some trial and error. Begin by separating the data from the metadata (i.e. begin with a rows only export.) This will allow you to slam the data in just as fast as it comes out. Then, build an indexfile with the metadata export (rows=n), and massage it until you like it. Run it in a session with an absurdly large sort_area_size (3G is not out of the question, alter session set sort_area_size = 30). The indexes should come out like popcorn. Finally, parallelize all of this so you're running three or more exports (to three different pipes of course), three imports, and finally three or more index builds simultaneously. Hand-tune these to go from and to different disks. With this approach, you could probably achieve downtime under 60 minutes. Both of these approaches would also benefit from a process of identifying tables that are essentially static or read-only, and moving those over ahead of time to cut them out of the final cutover. Hope this helps get the conversation going, remember to hire Pythian if you need help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 3:48 PM Hi I want to switch from one server to another serevr with minimun down time of site.I am using export/import because removal of fragmentation. The folowing is my idea -export consistent=y on server1 -Ftp export files into serevr2 -Drop fragmenetd tablespace and recreate it -run import at schema level on server2(IMPORT is taking too much time) -Point the site to server2 But I am worry about those data which will loss during ftp time and import time.How to sync both server at particular time keeping in view with less down time of site. Can Incremental export/import help us to minimize the site down? Let me suggest please. -sEEMA _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
Re: UWIN and Oracle
Hi Anjan, We did use it in the good old days... 1999 or so! :-) Although we did get those things working with uwin, it was more or less by executing "cmd" and then executing those things. Not really clean, or what you're hoping for, no doubt. However, I must warn you: we had a serious production problem that was clearly linked back to UWIN. As a result we abandoned UWIN on all production servers. Hope this helps you, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 10:23 AM Hi Gurus, Any body got any experience using UWIN on NT with oracle. I can't seem to do anything like starting sqlplus, svrmgrl or lsnrctl.. Any hints/suggestions will be most welcome. I am trying out the eval of ver2.9. Thanks Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: Group email account for exchanging files and scripts
FYI to all. There's no reason both groups shouldn't use this resource, so please join in and contribute your scripts and documents that would be too large to send as attachments. Best regards, Paul - Original Message - To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:35 PM Hello everyone, I was sad to hear that scripts needed to be deleted at the Yahoo group email account because of a lack of available space. I decided to set up and provide an account where we could exchange scripts indefinitely without the fear that they'll be deleted or that someone might change the password on us. The site is: https://webmail.pythian.com. The username is: scripts The password is: pythian To send a message, address your email to [EMAIL PROTECTED] I have taken the liberty of forwarding all of the yahoo.com messages to that account so there isn't anything you're missing if you just want to use that one right away. I encourage all of you to send any scripts you'd like there. The nice thing is that if the scripts are well described in the body of your emails, they'll be searchable via the search interface. This account is part of my company's IT infrastructure and as such it will also get backed up regularly. By the way, it's on purpose that no-one has permission to delete messages (except me of course). Cheers, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ?
Hi Bunyamin, list, We have a system that supports many tens of thousands of simultaneous users. It has 1466 sessions connected as we speak, and generally has around 100 of those sessions marked status "ACTIVE" in v$session. We do concentrate users to sessions in a web layer. We did at one time attempt MTS, however we found that we quickly went down as dispatchers failed to keep up with the load. Oracle did its best to help us tune it, and we tried half a dozen possible configurations, but eventually the attempts were causing too much downtime and we went back to dedicated session. At peak time, our call rate is 25 user calls per minute. Hope this helps, Paul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 11:08 AM Subject: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ? My question is DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ON NT ? I WILL TRY Multi Threaded Server BUT STILL I HAVE DOUBTS ? DO YOU HAVE LINKS TO ADVICE ME TO READ ABOUT THIS POINT ? ( HIGH CONNECTION/TRANSACTION NUMBER PER SECOND) THANK YOU
Re: HOW TO KNOW INDEX NOT IN USE?
Hmm... One option might be to monitor x$bh for blocks belonging to that object every ten minutes for a week. If it doesn't appear, the object can pretty conclusively be called "not in use". Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 3:31 PM Seema, It is always better to include the OS and database versions to the post :) Okay.. To answer your question.. If you are using Oracle9i you can find that by querying V$OBJECT_USAGE after turning the monitoring option for the index. If it is pre Oracle9i database there is no direct way of doing this. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Monday, February 04, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hi I there any view which can tell us which indexes are not in use? Thx -Seema also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: standby on same server
Hello DBAs, This procedure outlines how to establish a standby database on the same server as the production database. However, it naively assumes that extended production downtime is a non-issue! Is it possible to establish a standby database on the same box as the production database without incurring production downtime? If so, does anyone have the procedure available to share? Thanks, Paul ---www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more.- Original Message - From: Peter Smith To: Greg Leger ; [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 2:59 PM Subject: standby on same server http://technet.oracle.com/doc/oracle8i_816/server.816/a76995/standbys.htm#29841
Parallel export by datafile/extent
Hello all, I'm trying to generate a script that generates many export parameter files, each one of which would export a subsection of a table based on it's datafile. I think this is possible using sql-extended query export and rowid ranges. The idea of course is to then kick off each of those exports simultaneously. It'll be a small job though, and I thought I would post to see if anyone has done anything like this before? Thanks, Paul ---www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more.
Re: Trigger exception problem
If you're gonna do that, then why not:
select decode(process, process, process)
from ( select * from ( select * from v$session ) )
where decode(audsid, audsid, audsid) =
( select userenv('SESSIONID') from ( select * from dual ) );
Seriously though, why not just use
select * from v$session where AUDSID = userenv('SESSIONID')
:-)
-p
---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 1:23 PM
If you need current process:
select process from v$session where AUDSID = (select userenv('SESSIONID')
from dual);
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 12:35 PM
> I told you I knew it was something stupid. Thanks the process was it. I
got rid of the process code and the duplicate error does now populate the
exception table like I wanted!
>
> I know need to figure out how to capture the specific process. Probably
next week when hopefully my head cold is gone, my kid isn't teething and I
have had some sleep.
>
> Thanks to all and to all a good weekend!
>
> Kathy
>
> -Original Message-
> Sent: Friday, December 07, 2001 5:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Kathy,
>
> I beleive the problem is in the exception handler:
> select process into v_process from v$session...This is returning multiple
rows.
>
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> Confidential
> This e-mail and any files transmitted with it are the property
> of Belkin Components and/or its affiliates, are confidential,
> and are intended solely for the use of the individual or
> entity to whom this e-mail is addressed. If you are not one
> of the named recipients or otherwise have reason to believe
> that you have received this e-mail in error, please notify the
> sender and delete this message immediately from your computer.
> Any other use, retention, dissemination, forwarding, printing
> or copying of this e-mail is strictly prohibited.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kathy Duret
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Vallee
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: REMOTE USER CREATION
Hi Raj, What version of Oracle are they running? This can be achieved I believe in 8.0 or later via a remote execution of a procedure that uses dynamic sql to run the create user command. Something like (in 8.1 syntax) procedure createuser (for_user in varchar2, for_pw in varchar2) is begin execute immediate 'create user ' || for_user || ' identified by ' || for_pw || ' default tablespace users temporary tablespace temp ' ; execute immediate 'grant create session to ' || for_user; end; Remember, the user who runs this procedure will require an explicit (not through a role) grant of the create user privilege. HTH, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:25 AM Hi Folks, I posted this last evening and it didn't show up yet..so here we go again.. Duhvelopement Grp has decided and developed a program that is inteded to create user in remote database thru DB link. Example. The program/procedure exists in database A. They need to call a procedure in Database B to create a user in Database B. They also need to to be able to supply username and password. Well.when they attempted to do that they got the ORA error. ORA 2064 02064, 0, "distributed operation not supported" // *Cause: One of the following unsupported operations was attempted: // 1. array execute of a remote update with a subquery that references //a dblink, or // 2. an update of a long column with bind variable and an update of //a second column with a subquery that both references a dblink //and a bind variable, or // 3. a commit is issued in a coordinated session from an RPC with //OUT parameters. // *Action: simplify remote update statement Now I am stuck with 'fixing' this. Has anybody done or seen this anywhere. ANy pointer would be welcome and appreciated. TIA Cheers, RS __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA Weakest Link
Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a "DBA Weakest Link" game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for "Table or view does not exist"? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle/UNIX vs. Oracle/NT
Thank you very much to all that responded and contributed their time. I'll be saving this thread! I got more anecdotal evidence than I thought I might. Can it be true that few more-formal "reports" have been written on this subject? It sure seems like a hot-button issue. Thanks again, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 9:15 AM Patrice, Thank you very much for the time you spent putting this together. It is VERY informative, and I am keeping it forever! thanks again! Tom Mercadante Oracle Certified Professional Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle/UNIX vs. Oracle/NT
Actually, Dennis, it's currently a UNIX shop considering saving money by migrating to NT. It seems like your argument would support sticking with what they currently have. Thanks, Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 2:10 PM Paul - What is the base of experience in this shop? Is it primarily an NT shop and the Unix system is the odd one, or is it primarily a Unix shop and the NT conversion would be a first plunge? Everything I hear depends primarily on this factor. Most indications are that the Unix systems tend to be more reliable, but there are strong NT shops that seem to keep their NT reliability up, and would struggle with the odd Unix system. I assume that you are really talking Windows 2000 at this point. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hello everyone, I'm certain that this is a FAQ, but I thought I would make a request here. I have a client whose management is requesting us to make a business case for keeping our Oracle on UNIX rather than on NT. I wonder if anyone can link to or provide any of the following on this subject: * whitepapers * platform selection papers * pro/con summaries to management, no matter how informal Please help in any way you can, thanks in advance, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle/UNIX vs. Oracle/NT
Hello everyone, I'm certain that this is a FAQ, but I thought I would make a request here. I have a client whose management is requesting us to make a business case for keeping our Oracle on UNIX rather than on NT. I wonder if anyone can link to or provide any of the following on this subject: * whitepapers * platform selection papers * pro/con summaries to management, no matter how informal Please help in any way you can, thanks in advance, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Toad vs SQL Navigator
My answer is always the same... Neither! :-) Instead, try Golden from Benthic Software (www.benthicsoftware.com). It's easy to try it without buying it, just use the annoyware. Also try PLEDIT as a PL/SQL development environment. It serves our purposes very well, and at 35$ it completely demolishes it's competition for cost/benefit. Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 10:55 AM Hi All, We are looking at purchasing TOAD or SQL Navigator from Quest. I think they have purchase EZSQL also which I liked(good and cheap). I guess there goal is to eliminate the competition. I have some experience with free version of TOAD but not with SQL Navigator. Can someone share there pros/cons,why purchase one over the other, etc. if they have used both of these products? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OAS Mailing list?
Hello all, Is there a mailing list where Oracle Application Server issues are discussed? Thanks, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: schema refreshes (transport tablespace)
Title: RE: schema refreshes (transport tablespace)
An easier solution might be the use of the wait
command:
rcp srvr1:/u01/f1 srvr2:/u01/f1
&rcp srvr1:/u01/f2
srvr2:/u01/f2&
waitrcp srvr1:/u01/f3 srvr2:/u01/f3 &rcp srvr1:/u01/f4
srvr2:/u01/f4&
wait
etc.etc.
Best regards,
Paul Vallee -- [EMAIL PROTECTED] --
877-PYTHIAN
- Original Message -
From:
Aponte, Tony
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 18, 2001 3:45
PM
Subject: RE: schema refreshes (transport
tablespace)
This is a script mined from Sun Blueprints (http://www.sun.co.jp/blueprints/0300/oraclescript.pdf).
You feed the script a file name and an optional parallel degree integer.
The input file contains complete commands on each line and your original one
with 50 lines is usable as-is. I attached the script code just in case
you have a problem with the PDF file.
Tony Aponte
#! /bin/sh # #-
# message # Establish a timestamp and
echo the message to the screen. # Tee the output
(append) to a unique log file. #-
# message() { timestamp=‘date +"%D %T"‘ echo "$timestamp $*" | tee -a $logfile return }
#-
# get_shell # This function is
responsible for establishing the next # command to be
processed. Since multiple processes might # be
requesting a command at the same time, it has a built-# in locking mechanism. #-
# get_shell() { echo "‘date‘ $1 Shell Request $$" >>
$lklogfile # debug locking file while : # until a command or end do
next_shell="" # initialize command if
[ ! -s ${workfile} ] # if empty file (end) then
# break # no more commands fi
# if [ ! -f $lockfile ] # is there a lock?
then # not yet... echo $$ >
$lockfile # make one echo "‘date‘ $1 Lock Obtained $$"
>> $lklogfile #debug if
[ "$$" = "‘cat $lockfile‘" ] # double check
that then # we created it last next_shell=‘sed -e q $workfile‘ # first line of
file sed -e 1d $workfile > ${workfile}.tmp # Chop
1st line mv ${workfile}.tmp $workfile # rename to work file rm -f $lockfile # turn
off lock echo "‘date‘ $1 Shell Issued " >>
$lklogfile #debug return # done, command in
else # variable "next_shell" echo
"‘date‘ $1 Lock FAULTED $$" >> $lklogfile # debug fi # double check faulted # else # locked by
other # echo "‘date‘ $1 Lock Wait $$" >>
$lklogfile # debug fi # sleep
1 # brief pause done # try again return # only if no commands }
#-
# paresh_slave # This code is
executed by each of the slaves. It basically #
requests a command, executes it, and returns the status. #-
# paresh_slave() { shell_count=0 # Commands done by this
slave get_shell $1 # get next command to
execute while test "$next_shell" != ""
# if no command, all done do # got a
command shell_count=‘expr $shell_count + 1‘
# increment counter message "Slave
$1: Running Shell $next_shell" # message
$next_shell # execute command shell_status=$? # get exit status if [
"$shell_status" -gt 0 ] # on error then # then message message "Slave $1: ERROR IN
Shell $next_shell status=$shell_status"
echo "Slave $1: ERROR IN Shell $next_shell status=$shell_status" >> $errfile fi
# # message "Slave $1: Finished Shell
$next_shell" # message get_shell $1 # get next command done # all
done message "Slave $1: Done (Executed $shell_count
Shells)" # message return #
slave complete }
# paresh_driver # This code is
executed by the top level process only. It # parses
the arguments and spawns the appropriate number # of
slaves. Note that the slaves run this same shell file, # but the slaves execute different code, based on the # exported variable PARESH. #-
# paresh_driver() { rm -f $lklogfile # start a new log
file if [ "$1" = "" ] # first argument?
then # no? master_file="master.list"
# default value else # yes? if
[ ! -f "$1" ] # does file exist? then # no?
echo "$0: Unable to find File $1" #
say so exit 1 # quit else #
yes? master_file="$1" # use specified filename
fi fi if [
"$2" = "" ] # Second Argument? then # no?
parallel_count=4# default value else
# Yes? if [ "$2" -lt 1 ] # Less than 1?
then # Yes? echo "$0:
Re: how to make PL/SQL wait for 60 seconds
Hi John, SQL> desc dbms_lock [snip] PROCEDURE SLEEP Argument Name TypeIn/Out Default? -- --- -- SECONDSNUMBER IN Hope this helps, Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 8:46 AM I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Command History in SQL*PLUS
Hey all, There is also the generic solution to all of these problems: Use emacs. Esc-X shell. Run sqlplus, or any other command, natively. Use regular emacs editing commands to access your history, copy and paste results into other buffers, search and replace, etc.etc.etc. Even write emacs macros (easy as pie - ctrl-X ( means record, ctrl-x ) means endrecord, ctrl-x e means execute.) Digital Unix (sorry, Tru64) has emacs preinstalled by default, as does most linuxes, but you may have to get your own build on other platforms. sunfreeware.com is a good place to start for a sunpkg, can anyone else come up with a source for aix, hp/ux, etc? For those of you worried about bloat, or not having this on every platform, there's also an excellent microemacs, available from jasppa.com. It has the shell feature, but I don't know about macros. It's extremely lightweight, and there are precompiled binaries for most platforms including Windows (!) on the www.jasspa.com website. Hope this helps, Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 10:05 AM John, Yes, thanks for pointing that out. The password will be displayed when using 'ied'. I have not found any solution to that, and the way 'ied' works I doubt if there is any workaround. Sorry. The script I mentioned will suppress the password, but I think it will be displayed when recalling previous commands. I do not know if there is anything like 'ied' on Sun or AIX or any other UNIX flavour. Thanks. - Kirti > -Original Message- > From: Hallas John [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 3:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > KIrti, > That looks useful for svrmgrl but in sqlplus it shows the password as it > is being typed in > (ok if you use sqlplus internal I suppose). > Is there any fix to that. > Is there an alternative to ied for other flavours of Unix (ied does not > exist on Tru64 at least) > > JOhn > > -Original Message- > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > Sent: 18 July 01 21:07 > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > > On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied > sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set > > -o vi' in a KSH) > Check out a script #10 at <http://www.orafaq.com/faqscrpt.htm#UNIX>. It is > > wrapper for sqlplus and svrmgrl to do similar things. > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > HTH, > > Regards. > > - Kirti Deshpande > Verizon Information Services ><http://www.superpages.com> > > > -Original Message- > > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 2:36 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Command History in SQL*PLUS > > > > Sometime ago there was a post on how to get the last commands executed > > in SQL*Plus. It is very similar to doing escape from the UNIX command > > line > > > > Do you know how to scroll down the last 10-20 commands executed in > > SQL*Plus ? I am not talking about "/" which would get the last command. > > > > Rama > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
