Re: First version with multiple archiver processes?

Kirti From version 7.x you can manually start multiple archive processes by using the archieve log start to destnation and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple processes the answer is 8.1.3 :-) Deshpande, Kirti wrote: I can

Antwort: SAN, Heterogenous environments, Backups

Hemant, have you considerd HP Openview Omniback or related products form Veritas ?? cheers alex Hemant K Chitale

Re: First version with multiple archiver processes?

Kirti In v.7 the archiver is called ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: Kirti From version 7.x you can manually start multiple archive processes by using the

Re: Determine how many used and free blocks in an extent.

dbms_space may provide some of the info you want. It won't tell you if the blocks are contiguous. On Wednesday 05 February 2003 12:09, [EMAIL PROTECTED] wrote: Does any have a script that shows actual # of used and free blocks in an extent? I would like to determine the maximum # of

Dump table to file, edit and reimport

In Sybase's ASA there was an unload command which wrote to a text file the SQL to recreate a table, along with all it's data which running the SQL then imported. This allowed you to very easily dump a table, edit it's structure and suck the data back in. The closest thing I've found in Oracle is

Re: First version with multiple archiver processes?

Sorry Kirti, that was meant for Peter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Feb 2003, Jeremiah Wilton wrote: Kirti In v.7 the archiver is called ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton

RE: Partition and primary key

Title: RE: Partition and primary key thank U Johnattan, which book are you talk about ? (isbn) -Message d'origine- De: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Date: mercredi 5 février 2003 19:20 À: Multiple recipients of list ORACLE-L Objet: Re: Partition and primary key First

Re: Hot backups vs RMAN, the rebuttal

I think your list of reasons for using RMAN is incomplete. The database backup window may need to be shrunk not because the database is so big, but because there are a lot of systems to backup, and they use a lot of time and tape. RMAN backs up blocks, hot backup backs up files. Also, finding

Re: Oracle DB License - Named User Multi Server

We also have named user multi server. Oracle no longer sells those licenses. Jared On Wednesday 05 February 2003 20:48, Hemant K Chitale wrote: When you buy a Named User license do you generally buy a Named User Single Server license or a Named User Multi Server license for the Oracle

RE: Dump table to file, edit and reimport

use toad and export the table to a text file. Also u could use the command line export/import utility. But setting up oem is not that dificult. Regards Paulo -Original Message- Sent: quinta-feira, 6 de Fevereiro de 2003 9:34 To: Multiple recipients of list ORACLE-L In Sybase's ASA there

RE: Oracle Migration Workbench for Sybase

Do you have a Sybase Open Client CD ? The odbc drivers are usually on there. From my Sybase years I recall that the ODBC drivers were sourced from Merant, now DataDirect technologies, might be worth looking there. Personally I'd go for the bcp out/SQL*Loader in scenario. Ade -Original

OT: hw info on Tru64 system

Good day to everyone How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? Thanks in advance, Vladimir Barac

RE: Oracle Migration Workbench for Sybase

Hello Listers, Anyone used this tool? What was your experience like? I am planning on using it to move about 20GB of data from a Sybase 11.x database to Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') is the alternate solution. I would like see if we

iAS (9.0.2.0.1) R2 install on RedHat 7.2 make ins_oemagent.mk error!

Hi, I am installing 9iAS( 9.0.2.0.1) Infrastructure on RedHat Linux 7.2. During the installation, I get the Error in invoking target install of makefile ins_oemagent.mk during linking some lines from install/make.log file regarding this problem are as : /usr/bin/make -f ins_oemagent.mk

Re: Partition and primary key

Practical Oracle 8i Addison Wesley; ISBN: 0201715848 Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th

multiple oracle homes

Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ:

Re: oracle log file at redhat 7.3

Pomin, The log is usually located in the bdump location defined in the initSID.ora file for your instance. The name will be something like alert_SID.log. Ron [EMAIL PROTECTED] 02/05/03 09:38PM hi all, how I know where the log directory in oracle on redhat 7.3 ? because I have a problem with my

RE: Drop datafile.

encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

RE: VMware

I agree with Richard. We used VMware in our development environment to consolidate servers. I will say - unless you have a substantial amount of hardware, there is going to the inevitable temptation to add that one extra VM instance that's just one too many and performance suffers. But, if

RE: Partition and primary key

Title: RE: Partition and primary key Jared, UNABLE TO EXTENT TEMP SEGMENT BY ... -Message d'origine- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Date: mercredi 5 février 2003 21:50 À: Multiple recipients of list ORACLE-L Objet: Re: Partition and primary key What is the exact

RE: Oracle Migration Workbench for Sybase

Thanks for your response. This morning I was informed that there is a Sybase Open Client CD that I can use (if they could find it :) We do have a few Sybase products, so we have support, licenses etc We will be exploring both known avenues to get the data into Oracle database. Sybase bcp

RE: Oracle Migration Workbench for Sybase

Kirti, I am no Sybase expert, but I am staring at a Sybase to SQL Server migration, and I installed the Sybase client tools on my machine and it gave me Sybase Adaptive Server ODBC driver Release 3.50.00.10. Unfortunately I can't tell you if my version is newer or yours is (50 is bigger than

Re:Re: Oracle License for Training

I would be pleased to be informed - privately or via the list - about further progress. Oracle is a fine thing - not judging just giving away my sympathy - and hopefully you can get more people on the Oracle path. Fence the w..dogs off - sorry, couldn't resist to temptation. Apologies for

Re: Antwort: SAN, Heterogenous environments, Backups

Thanks for the heads-up. I did some looking around at the HP and Veritas websites and came up with information for my managers. Hemant At 12:48 AM 06-02-03 -0800, you wrote: Hemant, have you considerd HP Openview Omniback or related products form Veritas ?? cheers alex

AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place,

RE: Problem with LONG column

Hi allThank you very much for all your suggestions.I already experimented with copy command. But I failed Following is the output..SQL copy from qest/qest@ndlp to scott/tiger@test1 - append contacts_new using select * from contacts;Array fetch/bind size is 15. (arraysize is 15)Will commit

RE: First version with multiple archiver processes?

No problem, Jeremiah. I never could open Peter's e-mails due to some error stating 'Your Digital ID name can not be found by the underlying security system'. I saw what he posted in your message. I was not aware of this Oracle7 'feature'... Sounds like an un-documented trick :) Thanks, -

RE: java

Stephan, Thanks for the reply. You were right, it had nothing to do with java 3D. I just wish I knew what caused the problem, but with the lack of controls around here it is tough to test. I noticed the error consistently appeared in one of two spots, so I set up 4 scenarios to test (different

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Lisa There is no harm in using TIMED_STATISTICS=TRUE. I was using that on same environment thanks Banarasi -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 7:54

RE: Problem with LONG column

Babu - I don't know how large your tables are, but you should consider committing during the copy. This is a parameter available to COPY. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 06, 2003 8:34 AM To: Multiple

Disaster Recovery

We're in the process of updating our DR plan and adding some more detail G!. So I've been racking the auld grey matter and trying to identify a list of useful hardcopy documents which would be really useful for DR. The type of documents you store in a folder at home and bring along should the

AW: java

Hi Henry So, it's basically working now ? Or are you still trying to figure out the why part ? What does this setup.aix do ? Is it an executable that execs a java process starting setup.jar ? Or is it a script you could post here so I can take a look at it ? Regarding the logs, usually, if a java

Re: Dump table to file, edit and reimport

hi! unload and load work like that SQL exp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable) SQL imp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable) but i don't think you will have a good time editing the file. if you want a | delimited file, you should use spool and

RE: hw info on Tru64 system

Vladimir - Quick answer, look in the message file that was created the last time the system was booted up. There is also a command you can enter, I just don't know what it is. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February

RE: hw info on Tru64 system

psrinfo -v vmstat -P -Original Message- How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Hanging query puzzle

Kirti, I've been searching on the IBM site for aiostat without much luck. What kind of information does it give you? (if I'm going to convince my SA to call IBM about this I'll need a very good argument. I'm still working on getting the rights to use sar). Henry -Original Message- Kirti

Re: SQL

Lots of emails were sent yesterday, so in case if any kind soul had missed my request (which didn't bear any result), I am posting this again. Please help if you can. Thanks. -- On Wed, 05 Feb 2003 09:59:29 waseem khan wrote: Folks, Is there a much better way of writing the following SQL

Oracle 9i Lite - any help please?

Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa, When I first got to URI (8.1.7 4.3.3) timed_statistics were also set to false. I changed them to true and have had no problems with it. I have also found that a lot of PeopleSoft setups aren't installed by experienced

Re: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Lisa, I have had TIMED_STATISTICS set to true on 5 different 8.1.7 databases (4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers for some timewith no perceived problems. These servers are either at AIX maintenance level 9 or 10. I have struggled with swap space

Looking for simple monitor script dbup.bat

Good morning everyone Win2k pro, oracle 8.17 Ive been investigating a simple monitor script which will email me if the database is not available. I need this to be as simple as possible (ideally a batch file) Ive come across this on orafaq http://www.orafaq.net/scripts/win/isdbup.txt But dosnt

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa, We have several databases on AIX 4.3.3/8.1.7.x. All of them have TIMED_STATISTICSset to TRUE. Not problems havebeenencountered. And about that tuning question: May bethose are all dedicated connections, if so check what's

RE: Oracle Migration Workbench for Sybase

Reed, Thanks. I do not know what we may have. They (Sybase DBAs) are still looking for the CD for me. May be this newer release of the driver might work with OMWB... - Kirti -Original Message- Sent: Thursday, February 06, 2003 7:49 AM To: Multiple recipients of list ORACLE-L

RE: hw info on Tru64 system

Look for sys_check.tar in the Compaq web. It do a full test and audit of your system. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de DENNIS WILLIAMS Enviado el: jueves, 06 de febrero de 2003 15:59 Para: Multiple recipients of list ORACLE-L Asunto: RE: hw

Re: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa, We've been using timed_statistics=true at our site for over a year, without any problems. ed - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday,

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit. Lisa, Be aware that there are some issues with ML9 as I am finding out with swap. We are planning on going to ML10 which should fix the problem as well as using vmtune command

RE: Disaster Recovery

-I'm thinking some type of crib sheet with useful commands for that DR -situation might be useful too. This is one of my main ways that I survive, I really like cheat sheets. Also have a $50 bill in the folder to go buy beer afterwards, you'll need it. ;o) Dave -Original Message-

OAUGNet OAUGNet-DBA list servers from OAUG.COM

Hi, Is any one getting emails from OAUGNet OAUGNet-DBA list servers (WWW.OAUG.COM)? For some reason, I am not getting emails for the last one week. Thanks Bob __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

RE: Windows 2000 Cluster on oracle

Quoting Bernardus Deddy Hoeydiono [EMAIL PROTECTED]: I suggest if your O/S (Win2K) running well ,please don't apply the service if not necessary. Perhaps this is the advice most people followed that's why that Slammer worm took off. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ:

RE: RMAN - questions.. Rob Freeman?

This is ok for tape restores but not for disk restore...but thanks Rob. Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 4:36 PM To: Multiple recipients of list ORACLE-L Take a look at this link, it might be helpful...

Update NT to 2000 Server

Hello, I'd like to update my server (Windows NT) to Windows 2000 Server. I have a Oracle Database 9i in this machine. Does anyone know any kind of problem in this operation (database compatible) ? Thank. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares

Re: SQL

Could you post execution plan, statistics? Concatenated index on (TEST_DATE,TEST_VAL) might help, as well as increasing the size of sort_area (if you find, that it uses disk for sorting). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list

RE: Windows 2000 Cluster on oracle

I had to apply the SP1 for Oracle to run. I built the PC from all off-the-shelf inexpensive parts ;) I will now let my Win NT4.0 Server die on its own... - Kirti -Original Message- Sent: Thursday, February 06, 2003 12:09 AM To: Multiple recipients of list ORACLE-L upto you if you're

Antwort: Re: Dump table to file, edit and reimport

hi aidan, the following script will create .ctl and .dat files for each table of OWNER. These files can then be used with sqlldr. HTH alex #!/bin/ksh ### # # Desc: create CTL and DAT files for sqlldr usage #

RE: Disaster Recovery

Sean - I could probably be of more help if you could describe something about how you propose to recover the system. Do you have a recovery site? Have assurance from your vendor that they could provide a comparable system somewhere in a reasonable frame of time? Another item to consider would

RE: SQL Tuning Help

Dennis, I tend to treat use of hints for exceptional cases only. With collections CASTed as tables, I seem to have a generalized problem of tables involved being scanned FULL (not using the available indexes) and query response being slow. I can't seem to build a query with collections and have

Re: hw info on Tru64 system

Kool! Thanks... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 16:33 psrinfo -v vmstat -P -Original Message- How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? --

RE: RMAN - questions.. Rob Freeman?

Thanks Dennis... Ya.. its all on disk and problably only a test with some tuning is going to give me realistic picture. I am going to try it on NETAPPS new disaster recovery SAN solution Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 3:50 PM To: Multiple recipients

RE: hw info on Tru64 system

Vladimir, You can also try these: sizer -p (# of processors) sizer -v (full version string i.e. 5.1A where uname -a says 5.1) HTH Stephen [EMAIL PROTECTED] 02/06/03 08:33AM psrinfo -v vmstat -P -Original Message- How do I find hardware info on Tru64 machine? Available RAM,

RE: Looking for simple monitor script dbup.bat

Bob, I have a very simple script which checks to see if the database is up and open. I've emailed you the script. Orysia Husak Database Management Services PEROTSYSTEMS (602) 307-2896 cell: (602) 300-9752 -Original Message- Sent: Thursday, February 06, 2003 9:00 AM To: Multiple

Freeware reverse engineer ER diagram from ODBC connection

Hello guys, I remember seeing a freeware software that can connect to a database through ODBC on Windows, then reverse engineer the ER diagram from the database. Could someone on this list email me or us the link to get this software? Thank you very much. -- Lyndon Tiu -- Please see the

RE: RMAN - questions.. Rob Freeman?

Thanks Peter... Ya, I will be moving it between Netapp san and EMC disk. Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L You will only know what your system is capable of It is very dependant on the disk arrays and no

RE: Windows 2000 Cluster on oracle

Precisely. Our partner's SA also followed this idea and that's why his Sun server crashed due to a NFS bug. Unfortunately, my database was on it. :( Richard -Original Message- Sent: Thursday, February 06, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Quoting Bernardus Deddy

RE: java

It worked once and I'm not going to try it again (why bother?). The setup.aix is just an executable that execs a java process using setup.jar. I'm not really happy and this system is pretty unstable, but so it goes. I'm still struggling with igoring the problems I see or I wouldn't get anything

RE: Hanging query puzzle

Henry, I got aiostat from IBM Support when I bugged them about how to monitor AIO. Not sure if aiostat is readily available as a download from their Web site or in/for the newer versions of AIX. It works similar to vmstat and iostat, showing number of pending AIO requests at the time of

RE: Looking for simple monitor script dbup.bat

Title: RE: Looking for simple monitor script dbup.bat Hi Bob, Check out Steve Adams' script (www.ixora.com.au). It's written in ksh and will need a little modification to send emails, but it's bulletproof. Also others on the list have mentioned Cygwin (?) the Windows-ksh to allow this to

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Ethan, Thanks so much for your reply. I'll have to check which patch level we are on. Have a great day! Lisa -Original Message-From: Post, Ethan [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003

Re: Hot backups vs RMAN, the rebuttal

Hi Jared, Responses in line. Jared Still wrote: I think your list of reasons for using RMAN is incomplete. The database backup window may need to be shrunk not because the database is so big, but because there are a lot of systems to backup, and they use a lot of time and tape.

Oracle Training

I have been told that I will finally get a budget for some training and want to get some in Oracle. I see that Learning Tree has some classes. Do you guys have any recommendations to links to point me to other sources for classes. Everything I have learned has been from RTFM and books from

Re: Oracle 9i Lite - any help please?

Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If

RE: DB character set

Hrm, how about UTF8? -Original Message- Sent: Wednesday, February 05, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Dear List, Life was pretty easy here before they came up with this euro symbol :-( We had WE8ISO8859P1 (the default I bevieve) as a char set on all Unix and MS

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Henry, OS isn't paging when I've looked. But with the memory this low it seems to me paging could happen pretty darn quick. There are a couple of logins that can run reports. These aren't big databases but as you know a

Re: Looking for simple monitor script dbup.bat

Could you post it to the list? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 12:14 PM Bob, I have a very simple script which checks to see if the database is up and open.

Re: Update NT to 2000 Server

First off, I am not an NT/Win2k admin, and don't even play one on TV. The advice from every SA I've asked about this, and from searching the web, is don't do it. Rebuild the box. There are remnants of NT left if you do an upgrade, and you don't really want that, do you? Jared Breno A.

Re: Oracle DB License - Named User Multi Server

The Oracle Software Investment Guide should be downloaded about every two weeks according to my friends in Oracle Legal, because things change rather often. The SIG is about 70-80 pages, by the way. There are cpu licenses and Named User Plus (NUP) liceneses available now. That's it. Mogens

RE: Partition and primary key

Well, you're getting close. The full message looks like this: ORA-01652, unable to extend temp segment by %s in tablespace %s The interesting part of the message appears where the '%s' are. Jared NGUYEN Philippe (Cetelem) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2003 05:43

Re: Oracle License for Training

When Klaus Andersen (the guy who hired me into Oracle Denmark in 1990, and now is Managing Director of Microsoft Denmark) was head of Oracle Education world-wide he put into the standard license terms that you cannot use Oracle software for training of 3rd parties. Klaus is a very smart guy.

RE: windows application to show sql being executed by a client

Title: RE: windows application to show sql being executed by a client If anything it will be incorporated into an existing Quest Product. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Pretty cool... A future Quest product ??? ;) Just wondering... :)

RE: windows application to show sql being executed by a client pr

Title: windows application to show sql being executed by a client program Looks pretty nice. Real similar in concept to TOAD's SQL Monitor, but adds the option of seeing the values of bind variables, formatting the SQL, watching processes, etc. Worth the download, IMHO. Dave

RE: Oracle Training

Hey Dave, In Madison, Greenbrier Russell -- I believe they were the first Oracle Certifed Partner -- has many Oracle classes. I've been happy with the Milwaukee-area classes. http://www.gr.com/what/classhtml/coursesbylocation_madison.asp HTH! GL! :) Rich Rich Jesse

RE: Update NT to 2000 Server

First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the partition and start from zero, you'll be happy you did. Scott First off, I am not an NT/Win2k admin, and don't even play one on TV. The advice from every SA I've asked about this, and from searching the web, is

RE: Oracle Training

Consider TUSC for your training needs. We offer all sorts of Oracle classes. www.tusc.com. Robert G. Freeman Technical Management Consultant TUSC - www.tusc.com Author of several books you can buy on Amazon.com! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/6/2003

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Lisa, Try oslevel -r at the command promt. It should tell you. -Scott At 09:49 AM 2/6/03 -0800, you wrote: Hi Ethan, Thanks so much for your reply. I'll have to check which patch level we are on. Have a great day! Lisa -Original Message- From: Post, Ethan [mailto:[EMAIL

RE: windows application to show sql being executed by a client pr

Title: RE: windows application to show sql being executed by a client pr Well I guess the cat is out of the bag! I didn't think that TOAD with SQL Monitor had been released yet. Yes, an (earlier?) version of his app was chosen to be incorporated in TOAD. -Original Message- From:

Anybody using Mercury WinRunner?

Hi all - We are thinking about using Mercury WinRunner to load test our 11 to 11i upgrade and wondering if anybody has experience using this before. How steep the learning curve, how reliable and how 'real' the load is comparing to the production load. Any other feedbacks are also welcome. Thanks

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Sorry to contact u of list. Do happen to know how to install rpm packages in aix? I downloaded c 5.1 from ibm (in rpm) wich is necessary to install 9ir2 but i don't know how to install rpm in aix 4.3.3. Could u help me??? Thanks in advance Paulo -Original Message-From: Scott

Re: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

By the way, Lisa. AIX 4.3.3 is being desupported. We are testing 9i on AIX5.2 as I write this. I could not get the powers that be to move away from 8.0.x and now we are jumping right to 9i. I did install 8.1.7 and use OEM2.2, but that won't support a 9i database. I will install the new OEM

RE: Oracle Training

Yet another choice: www.thinkspark.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

I am not currently working in an AIX environment; but when I did (and it was 4.3 with 8.1.6/7) we always set timed_statistics=true with no adverse effects. -Original Message- Sent: Thursday, February 06, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Good morning everyone -

RE: Hanging query puzzle

Kirti, Just took another look at our kproc processes. What is weird is that we have 26 of them, 9 are owned by oracle the rest are root (huh?). All of them started at system boot. Also, almost all of the CPU is used by the top four (current %CPU and total over the life of the process) with the

RE: Oracle Training

And the teachers at the Madison GR training center are frequently either Oracle contractors or ex-oracle employees. April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Thursday, February 06,

RE: Update NT to 2000 Server

I agree with Jared and Scott that's the best way to do it. -Original Message- Scott Sent: Thursday, February 06, 2003 1:39 PM To: Multiple recipients of list ORACLE-L First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the partition and start from zero, you'll be

RE: Looking for simple monitor script dbup.bat

Title: RE: Looking for simple monitor script dbup.bat If I understand you correctly, the problem is that you don't get an ERRORLEVEL set when you are unable to connect to a database. Have you tried sqlplus/nolog? (Ignore the french text, I have Oracle installed in french on my PC) D:\sqlplus

Maximum enabled roles

Does the max_enabled_roles initialization parameter have to be set for an instance? If it is not set is the limit the default of 20 or do you have unlimited enabled roles. I have looked through the docs and I only find the upper limit for max_enabled_roles is 148. Thanks Don Bricker Database

OT: Oracle workers need stress management??

http://news.lycos.com/news/photo.asp?from=mylycosphotosection=BreakingPhoto sphotoId=amdf319368 Or for the full story :http://news.lycos.com/news/story.asp?section=Breakingpitem=ODD%2DLIFE%2DJA PAN%2DDOG%2DDCrev=20030206pub_tag=REUTGfrom=photodetail -- Please see the official ORACLE-L FAQ:

Re: OAUGNet OAUGNet-DBA list servers from OAUG.COM

Bob, They switched to a different list server provider and there were numerous problems. They may have unsubscribed you. Here's a quick list of email addresses for the OAUGNet-DBA list. I assume the OAUGNet list email addresses would be similar. To unsubscribe, E-mail to: [EMAIL PROTECTED]

Re[2]: Update NT to 2000 Server

OK. And about the Oracle compatible. Only create a new windows 2000 service is necessary, any upgrade of database is require. Is it Correct ? -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Thursday, February 06, 2003, 4:39:17 PM, you

Trolling for ideas

I have a developer that wrote a VB program using ADO, connecting to Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for hours each night, and sometimes receives an ORA-03113 end-of-file on communication channel. Not consistently, just sporadically, and at varying amounts of time. I

RE: multiple oracle homes

Ray - Since I don't see where anyone replied, I think the problem is your stress on well documented. Might have scared people off. The basic procedure is to use separate ORACLE_HOME for each version. Make sure each version doesn't share anything you don't want them to. Most Unix systems require

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

OMG are you KIDDING Do you know when?? I just found out (as you may remember from my "Just Shoot Me" post) that IBM's version of desupport is "don't even ask us". Thank you so much Ruth for pointing this out. Have a great day. Lisa -Original Message-From: Ruth Gramolini

  1   2   >