RE: Disk Names - sdXX vs. cXtXdXsX

Is there a method or utility to translate disk names reported by sar from the sdXX format to the cXtXdX format? I'm on a Sun platform. If you look in /dev there are links from sd* to dsk/c*t*d*s*. I've got a little perl script to do the translation (see below), but its a bit rough-and-ready.

Re: Delete followed by Select Count(1) - SLOW

See my website: Index of topics - Miscellaneous - Block Cleanout Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L

Re: is C compiler a must for oracle UNIX installations ?

All UNIX OS's come with a rudimentary C compiler and linker, mainly for the purpose of rebuilding the kernel. What Oracle needs is the make utility and the linker. Unfortunately, this is not true ... In SCO Open Server (5.x) you NEED to install a C-compiler before Oracle installation,

RE: OT - Vaccines

Linda, I don't mean to be flippant but I am almost positive in about 13-16 years in the future there will be times when you will look back on those moments with EXTREME fondness Lee -Original Message- Sent: 16 August 2001 21:13 To: Multiple recipients of list ORACLE-L Thanks for the

table create vs alter

Hi, Does anyone know if the end result of these two statements is actually any different? CREATE TABLE mytable ( mycol1 NUMBER, mycol2 VARCHAR2(40), mycol3 VARCHAR2(30)); and CREATE TABLE mytable ( mycol1 NUMBER); ALTER TABLE mytable ADD (mycol2 VARCHAR2(40));

RE: Splitting a database: pro and cons

Title: RE: Splitting a database: pro and cons I would be tempted to leave them in the same instance, but use resource consumer groups to control them. Also, I would have their schemas (and associated objects) in different tablespaces, just to make management easier too, for things like

Dynamic cursor in PL/SQL

Title: Dynamic cursor in PL/SQL Hi gurus, I have to do a stored proc to compare the data of two tables in different schemas. I want to use a dynamic cursor and select the content of a table passed in argument. I saw in a document that I can work with REF CURSOR like this instance:

Two (probably simple) questions, function based index and table p

Hello folks! I need to create a function based index, but when I do this, Oracle gives me the message ORA-00439, function not installed, so I have tried and tried to figure out how to install this function, but I have failed, therefore this e-mail. I have looked in ORACLE_HOME/rdbms/admin and

Export

Hi Can you please tell me if there is a way of exporting select rows from a given table in 8.1.6.2??? Thanks in advance Rgds Fawzia This message is confidential and is intended for the addressee only; unless clearly stated that this disclaimer should not apply, this e-mail is not intended

RE: Two (probably simple) questions, function based index and table p

What version of Oracle are you using? Function based indexes only work in EE. Rick -Original Message- Sent: Friday, August 17, 2001 6:46 AM To: Multiple recipients of list ORACLE-L p Hello folks! I need to create a function based index, but when I do this, Oracle gives me the message

RE: Dynamic cursor in PL/SQL

Try: - schema_table := 'DIFF'; open schema_comp for 'select * from ' || schema_table; HTH David Lord -Original Message- Sent: 17 August 2001 11:46 To: Multiple recipients of list ORACLE-L Hi gurus, I have to do a stored proc to compare the data of two tables in different

RE: Openworld Abstracts

Project u - what is that?? .NOW - that has to be a jab at .NET. Couldn't find any white papers though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics

NT backup script question

I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from someone who has already done this ? Thanx

SV: Two (probably simple) questions, function based index and tab

Forgott to mension Oracle verson, 8.1.7.1.3 on a Windows 2000 advanced server /Jonas -Ursprungligt meddelande- Från: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Skickat: den 17 augusti 2001 12:08 Till: [EMAIL PROTECTED]; [EMAIL PROTECTED] Ämne: RE: Two (probably simple) questions,

Recovering WITHOUT tablespaces

Hi I need to recover the database with only a number of tablespaces from HOT backup. I know I can drop it from system later on, but will it cause any problems in applying archive logs with recover database statement? Any experiences/issues? Thanks Kumanan

RE: Export

In NT/2000 EXP username/password file=... tables=... query=where condition log=exp.log That is 3 double quotes with NO spaces surrounding them UNIX exp demo/demo query=\where lname like \'FRAN%\'\ tables=emp file=exp.dmp log=exp.log Rick -Original Message- Sent:

RE: Comment on 'Practical Oracle 8i'

It's not actually too difficult to do this, if you have some hardware with lots of CPUs. With Solaris 8, you can create processor sets, grouping a number of CPUs together, then running processes on those CPUs, they will not get any cycles scheduled on other CPUs in the system. This is different

RE: No TNSListner service after intall 8.1.7 on Win 2k

Thanks Bruce. That ifile part was the part I was missing. (looks like the the closest I can get to a unix link) I like the ifile implementation better than having two copies of the init.ora. Babette -Original Message- Bruce (CALBBAY) Sent: Friday, August 17, 2001 12:21 AM To: Multiple

RE: OT - Vaccines

Hi Ross - you wrote - ...Children who have evidence of immunity as demonstrated by laboratory confirmation of immunity or a reliable medical history of disease are exempt from such requirement || This says, basically, that is it really ambiguous.lol Actually, they're

Re: Export

exp help=y look at the bottom of the list, query option. joe Malik, Fawzia wrote: Hi Can you please tell me if there is a way of exporting select rows from a given table in 8.1.6.2??? Thanks in advance Rgds Fawzia

RE: OT - Vaccines

From: MacGregor, Ian A. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT - Vaccines Date: Thu, 16 Aug 2001 17:28:10 -0800 However, it was decided to allow the stocks of vaccines with thimerosal to be used rather than

Re: Recovering WITHOUT tablespaces

Kumanan: Where I work, our databases are so big that we do it this way all the time. You need to restore the SYSTEM tablespace, at least one rollback tablespace, and any tablespaces you're interested in recovering from. You'll also need to have a copy of a 'backup controlfile to trace'

RE: Export

Title: RE: Export thanks all I found it in the online docs, but do appreciate all the responses... -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: 17 August 2001 13:24To: Multiple recipients of list ORACLE-LSubject: RE: Export Hi Fawzia,

Re: linux for oracle

Uma: From what I've seen and used myself, SuSE seem to be officially endorsed distro. I've heard of people installing on RedHat, but I've also heard (especially concerning 9i) that it is a pain in the a__ to get working--if at all. Jon Walthour From: Rao, UmaSankara S (CAP) [EMAIL

but will it run windows?

[EMAIL PROTECTED]: ** The World's Fastest Computer (This Week) Scientists at the Lawrence Livermore National Laboratory in Livermore, Calif., held a coming-out party this week, but it wasn't for a debutante--it was to dedicate the world's fastest computer, a silicon belle named ASCI White. And

RE: OT -- training

WHAT??? ECO went under? When did that happen. (man am I ever out of the loop!!) - Babette -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Monday, August 13, 2001 3:31 PMTo: Multiple recipients of list ORACLE-LSubject: Re:

PHP on Linux with Oracle

We've a Problem with PHP4 OCIFetch and varchar2 ! OCHIFetch with number or date Filed it work's fine but when i'll fetch a varchar2 Filed then i've no output in the browser ! When i dump the array then i see the character is 20 Bytes my field is 10 bytes i suppose so the character is unicode

RE: No TNSListner service after intall 8.1.7 on Win 2k

Babette, Bruce has the answer right-on regarding how NT starts Oracle services. Another way to accomplish this is to use ORADIM to point to the %oracle_home%\database\ directory. This is what I do so that I have one place to look for the init.ora file. I personally do not like the -ifile

Re: linux for oracle

If you need 24/7/365 server, install on kernel 2.2. Jan Pruner Dne pá 17. srpen 2001 14:23 jste napsal(a): Hi Gurus, Can u please tell me the most stable version of Linux on which I can install Oracle 8i? Thanks in advance Uma -- Please see the official ORACLE-L FAQ:

RE: table create vs alter

g, why not try it the answer is - no difference. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 17, 2001 6:01 AM To: Multiple recipients of list ORACLE-L Hi, Does anyone know if the end result of these two statements is actually any

RE: Which view maintain droped constraint record?

Generally, unless you use auditing, Oracle will not keep anything dropped in the data dictionary, hense drop. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone:

Re:but will it run windows?

Obviously not, it would take a single computer that powerful just to make Windows run in a meaningful way. Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 8/17/2001 5:15 AM [EMAIL PROTECTED]: ** The World's Fastest Computer

RE: OT - Vaccines

I wonder if there is a link between all of these vaccines that are forced upon our children and the increase in childhood illnesses, such as asthma and allergies and ADHD and ...?? Something has changed. With our new improved health care system, I believe on average children are sicker than they

RE: OT - Vaccines

Linda, I agree with Lee. My kids are 11,12 and 15. It is hard to remember when they were 4 months old. When I see small children now, I can't help but smile and laugh. It is absolutely amazing to watch small children learn and accomplish the smallest things - like rolling over and crawling!

Re:Oracle8i features

Roby, We wish to use Oracle 8i features like partitioning and global and local indexes in our datawarehousing project. ans - Partitioning is only available as an add on to Enterprise edition, so make sure your licensed appropriately. We have the following doubts regarding these: 1)Does usage

Oracle8i features

We wish to use Oracle 8i features like partitioning and global and local indexes in our datawarehousing project. We have the following doubts regarding these: 1)Does usage of local index make inserts,updates and deletes slower as compared to global index? 2)When is the use of Bitmap index

RE: Comment on 'Practical Oracle 8i'

LOL A neighbor of mine had an original IBM PC, 64K RAM, 160Kbyte single-sided floppy, and the cassette port on the back so you could hook up a cassette recorder/play for data storage and retrieval, BASIC on EPROM. He wondered if the Smithsonian was interested. An old college classmate happened

RE: but will it run windows?

Yeah, wasn't this the only computer that MS could use with SQL Server to beat Oracle's benchmark... -Original Message- Sent: Friday, August 17, 2001 9:16 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]: ** The World's Fastest Computer (This Week) Scientists at the

RE: Recovering WITHOUT tablespaces

So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it will be fine to apply archive redo logs of the DB? If so, that will be great. Thanks Kumanan -Original Message- From: Jon Walthour [SMTP:[EMAIL PROTECTED]] Sent: 17 August 2001 14:16 To: Multiple

RE: but will it run windows?

No actually they did it with signigicantly less. Although they kind of cheated. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707)

Oracle Performance in Unix machine with hardware Raid 5

Hi Guru, We will be implementing Oracle in unix machine with Hardware Raid 5. We can't implement Raid 1 as we do not have sufficient disk space. Initially, we thought of having many mount points .ie. 1 mount point for data files, another for index files, other mount points for redo log,

Re: PHP on Linux with Oracle

you should probably mail this to [EMAIL PROTECTED] George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 17, 2001 9:45 AM We've a Problem with PHP4 OCIFetch and varchar2 ! OCHIFetch with number or date Filed it work's fine but

Converting EBCDIC to ASCII

I may be moving data from an IMS db which is stored in EBCDIC. Oracle stores data in ASCII format. How do I go about converting EBCDIC to ASCII to store the data in Oracle (8.1.?)? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

RE: Comment on 'Practical Oracle 8i'

Title: Message I have been collecting commodores and Apples for a while to keep in my own PC museum. I have been looking for a good working TRS-80. -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Friday, August 17, 2001 8:31 AMTo: Multiple

RE: Allow only certain ports for sql*net traffic

Yes, that is dynamic port allocation. There is a parameter to stop that, I believe if I remember correctly it is in the listener.ora. I had to worry about this when working with a firewall before. Do not criticize someone until you walked a mile in their shoes, that way when you criticize

RE: linux for oracle

We're running two production 8.1.7 databases on Red Hat 6.2 here, will be bringing up a couple more in a few weeks. It's very stable, although there are a few annoying Oracle bugs peculiar to Linux that we've had to work around. We also have quite a few test databases running on Red Hat. Again,

RE: but will it run windows?

steps on the soap box And that is why 30 million people run windows. Yup, windows is completely useless. Get rid of it. It crashes every 1 second. I am no microsoft fan, but I have my laptop which I reboot once/3 months. I close it, which puts it in standby and I take it home, it

Re: NT backup script question

Check "COMPACT /C [filename]" command on NT. If you specify your 'backup' directory as [filename], then it will be marked as "compressed" directory, so that files added afterward (during your cold backup) will be compressed automatically while being copied. Igor Neyman, OCP DBAPerceptron,

RE: Oracle Performance in Unix machine with hardware Raid 5

Raid 5 will degrade performance, not many mount points. You will have contention, but that is not because of mount points or because of the lack of them. It is due to the fact that everything is running on the same set of disks. Raid 5 takes a big hit on performance, but if that is your only

Re: but will it run windows?

Not everyone can throw money/hardware at an OS's deficiencies. Windows has a great interface, if it would only work as advertised. I think the big desire is to see M$ tighten up their codebase, i.e., make everything work better and more reliably rather than packing in additional features that

Global Temporary Tables

Hi all, Where do I find more info, tricks, tips, when-to-use, when-not-to-use about global temp tables? I have already been through the FMs, but would like to find out more information. I have a process that is executed hundreds of times by multiple users on a daily basis. We are using pl/sql

RE: Oracle Performance in Unix machine with hardware Raid 5

We raid 5 on an AIX box, we have 89 mount points for database files (data and or index) as well as mount points for different kinds of scripts and files, redo and archival. We had one problems with Fork Function Failed for a while, Oracle said it was AIX, IBM said it was Oracle. We upped the

Re: RE: Recovering WITHOUT tablespaces

Yes. From: Kumanan Balasundaram [EMAIL PROTECTED] Date: 2001/08/17 Fri AM 10:11:10 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Recovering WITHOUT tablespaces So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it will be fine to

RE: Converting EBCDIC to ASCII

We do not pull data directly from IMS but load it in batch jobs. Our mainframe guy either dumps the data report-style (ASCII) or copies records in native EBCDIC to files on the mainframe. We ftp them to the Oracle side (binary mode to EBCDIC files) and use sql loader to move into Oracle. On

Re: Converting EBCDIC to ASCII

If you export the IMS data out to flat textfiles, and then transfer them via ftp in ASCII mode, the conversion will be done automagically for you. Alternatively if on Unix the dd utility will do the conversion for you. HTH YMMV! [EMAIL PROTECTED] wrote: I may be moving data from an IMS db

RE: table create vs alter

Thanks Tom. I know that logically the schema would be the same, I was just wondering if the underlying physical storage set up by Oracle would in some way be suboptimal in the second case. But if they're identical, that's great, because it means I don't need to worry about patching schemas :0)

RE: but will it run windows?

Not everyone can throw money/hardware at an OS's deficiencies. Os deficiencies? It takes $60,000 server to run Solaris OK. In NT you get the same performance at about $5,000. Most of the deficiences are to the poor performance of the intel processor in comparison to the 64bit risc

RE: but will it run windows?

I've been discussing with someone else that perhaps they use 92 processes to run Windows and the 8,100 to monitor for errors and do an auto restart... We started with only 2 process to run windows, but then we thought about Office and upped it to 92... Mike Kline -Original Message-

RE: OT - Vaccines

Over here in the UK, we have our children done in two stages. They have the first at around 4 months, then go back 2/3 months later for the second. There was actually a story on the news a week or so back about a doctor being had up for offering the choice to parents to have the jab all in one.

Re: Comment on 'Practical Oracle 8i'

On Fri, Aug 17, 2001 at 06:36:42AM -0800, Kevin Lange wrote: I have been collecting commodores and Apples for a while to keep in my own PC museum. I have been looking for a good working TRS-80. -- Speaking of museums, I took my daughter to the National Museum of American History a few

RE: OT - Vaccines

I just meant I hate the vaccinations. They are a necessary evil for me as I have to take him to day care. I do give him the infant Tylenol. But how can I explain this to him when he is uncontrollably sobbing from the shots? Don't get me wrong...this age I love. Every day is a new

Re: but will it run windows?

So you're saying, unless you run only M$ products it still sucks. They need to tighten up and open up the API's. Then windows would be great. --Scott Christopher Spence wrote: I am much a unix person over M$, but the simple fact is Win32 serves many purposes. And it crashing all the

Re: NT backup script question

Mark Leith wrote: Try PKZIP, this has a command line interface.. You can most probably find it with a search for the name on the web.. HTH Mark Hi. You could try PowerArchiver - at http://www.powerarchiver.com Version 6.1 of the GUI was free (as in beer) - but the new version is

RE: but will it run windows?

And what are you going to run the 8,100 processers in, linux? Perhaps it would be better to get a better NT admin, and actually use the 8,100 processors. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their

Re: Converting EBCDIC to ASCII

Thanks for the info. The Oracle DB will be on W/2000. Ken Janusz, CPIM If you export the IMS data out to flat textfiles, and then transfer them via ftp in ASCII mode, the conversion will be done automagically for you. Alternatively if on Unix the dd utility will do the conversion for

Re: OT - Vaccines

Kathy Duret wrote: I just meant I hate the vaccinations. They are a necessary evil for me as I have to take him to day care. I do give him the infant Tylenol. But how can I explain this to him when he is uncontrollably sobbing from the shots? *** You don't. You comfort them and they

Oracle and MC/Serviceguard

We are implementing MC/Serviceguard here for failover, and I have some questions about configuration/placement of Oracle files. Our Oracle environment: Oracle 8.1.6 (64-bit) HP-UX 11.0 (64-bit) We are not running OPS. The shared disks are on HP AutoRaid. Do all Oracle files need to be on the

Oracle DBA -Albany, New York

Healthcare solutions company in Albany, New York needs an Oracle DBA to join it's I.T. team. This company provides technical solutions to pharmacy, HMO and hospital clients. They are calling it a Developmental DBA: You will be responsible for all facets of development related to the logical

RE: OT - Vaccines

sicker? possibly. But the infant mortality rate has dropped. From: Babette Turner-Underwood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT - Vaccines Date: Fri, 17 Aug 2001 05:36:53 -0800 I wonder if there is a link

RE: NT backup script question

PowerArchiver is another good one, I know a couple of the people on the list use it to compress their NT backup sets From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: NT backup script question Date: Fri, 17

Re: but will it run windows?

The win comment was just a joke, having just installed w2k and patches. Later, I hit the error, not being able to install office because of the patches. My associate said, oh yes, you have to install office first, then patch. I sat there in wonder, and read about 12.3 teraflops machine.

Re: Converting EBCDIC to ASCII

I did it by creating flat files containing only character data (no packed fields), and using sqlloader to load the data. I think the only thing Oracle didn't know how to convert was the verticle bar ( | ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J

RE: Database upgrade w/ standby

Rachel, The rebuild process is very painful. The database is 560Gb and getting the backup tapes to the DR site and getting the standby instance built before there are too many redo logs (for the I/O channel) to apply can be problematic. However, the more I think about it, the more a rebuild

Re: but will it run windows?

I was thinking more along the lines of FreeBSD as optimal cost/benefit ratio. Now, if you can throw the Winders gui over a freeBSD codebase... Oh, wait, there is Mac OS... Scott Shafer San Antonio, TX Christopher Spence wrote: Not everyone can throw money/hardware at an OS's deficiencies.

Re: Database upgrade w/ standby

Michael, Why not just rebuild the standby database from a backup of the upgraded production database? Or am I missing something here? Rachel From: Hand, Michael T [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database

RE: but will it run windows?

FreeBSD has some of the worst multiple processor thread support of all the linuxes, although it's IO if I remember well is pretty good. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R.

Database using 100% of CPU

We are having a problem with our database - it is using 100% of the CPU. This has only started happening recently, and restarting the database temporarily stops it happening - it usually recurrs a few hours later. There are no jobs running, and at the moment there are no active connections.

OT - Vaccines

Lisa, Thanksbtw, my original message should have been caveat'ed with ..in my area... but I guess my thinking was better than my typing. In any case thanks for the additional numbers. In recent years ( see, AAPS for starters ) the CDC has come under attack for shoddy reporting, inflating

Re: linux for oracle

other mailing lists ORACLE-LINUX-L its at fatcity SuSE-Oracle e-mail: [EMAIL PROTECTED] Micheal Hasenstein of SuSE Linux mentioned on the SuSE-Oracle list Even the very latest 2.4 kernel is not as stable as 2.2.19.SuSE. So I'd recommend SuSE 7.1 with a 2.2.19 kernel for Oracle 8.1.7 and

RE: Diffs in SQL*Plus formatting between 8/8i

Title: RE: Diffs in SQL*Plus formatting between 8/8i I noticed this same difference between versions 8.1.5 and 8.1.7. In 8.1.5, the substr() function (ie. select substr(column1,1,10) works just fine.but in 8.1.7 it seems to be ignored. Defining the column seems to take care of it. Lisa

RE: OT - Vaccines

The interesting thing about this thread is the fact that most of the childhood diseases our children get shots to prevent still exist in most third-world countries. The last I heard smallpox has been eliminated from North America, not the world. Now, if the shots were doing no good and the

Re: linux for oracle

its a pain to get working(ok so it took some tweaking of the OS, some compat libs, etc) but if you want hopefully plug and pray use windoze :) forcing the square peg in a round hole is part of the fun. joe [EMAIL PROTECTED] 08/17/01 09:16AM Uma:From what I've seen and used myself, SuSE

RE: but will it run windows?

Title: RE: but will it run windows? I gotta disagree with you on one particular point here. When an application gets a error and OS crashes, it IS the OS fault. The OS should be written in such a way that when an application error occurs, the OS doesn't have to be rebooted. I believe it IS

RE: Database using 100% of CPU

How much memory is being used, vs. available physical RAM? Check Task Manager | Performance tab, compare Commit Charge Total (LL corner) vs. Physical Memory Total (UR corner). You should stay below physical RAM as much as possible, because Oracle really does not like NT virtual memory.

OT - Vaccines

I know a guy who had polio too. He's a poor soul, but not because of polio. ;-) (He just a pain in the ass sometimes) He has been a personal bodyguard, is a certified, practicing Doctor of Chiropractic, and holds several advanced black belts in a variety of disciplines. Polio most

RE: Database upgrade w/ standby

Upgrading with a standby is simple. Upgrade the primary as usual. When the standby complains it cannot read the log format of the new version, shut it down and restart it on the new version's binaries (new ORACLE_HOME). If you don't have room for a new ORACLE_HOME, then stop the standby, copy

RE: OT - Vaccines

Title: RE: OT - Vaccines YOU GUYS ARE SCARING ME OUT OF HAVING CHILDREN! How on earth can a parent make the right decisions?? All the information flying around on the list is pretty unnerving. Sure the numbers may be very low but the #1 thing I worry about (and most other expectant parents)

Re: but will it run windows?

Adams, Matthew (GEA, 088130) wrote: I gotta disagree with you on one particular point here. When an application gets a error and OS crashes, it IS the OS fault. The OS should be written in such a way that when an application error occurs, the OS doesn't have to be rebooted. I believe

RE: OT - Vaccines

Lisa, we have to go batty, part of being a parent. Joe One who is 40 next jan with an 11 and 5 year old, with an 8 month old tagging along, am i insane?? [EMAIL PROTECTED] 08/17/01 02:08PM YOU GUYS ARE SCARING ME OUT OF HAVING CHILDREN! How on earth can a parent make the right

RE: Database using 100% of CPU

It is nt, it is because it is unstable and crashes every 1 second, you just haven't noticed it. Seriously though, first verify the processes are oracle and not something else using task manager. Then if they are oracle. Look into v$session and find active sessions. Trace them back with their

OT - Vaccines

Hey man, good logical thinking, and text deconstruction! Eric Pierce would be proud. :) -Original Message- Sent: Friday, August 17, 2001 2:01 PM To: Multiple recipients of list ORACLE-L On Fri, 17 Aug 2001, Jenkins, Michael wrote: The interesting thing about this thread is the fact

Re: but will it run windows?

You guys are arguing over the wrong stuff. The real question is - Imagine a Beowulf cluster of these ... :) Paul Ray Stell wrote: [EMAIL PROTECTED]: ** The World's Fastest Computer (This Week) Scientists at the Lawrence Livermore National Laboratory in Livermore, Calif., held a

Re: Oracle Performance in Unix machine with hardware Raid 5

multiple mount points on the same RAID volume on the same controller will mean that different sections of the RAID volume have been allocated to different mount points. If you were going to use all of the space on the RAID volume, then multiple mount points doesn't necessarily degrade

Re:Oracle and MC/Serviceguard

Riley, Having done this a couple of years ago: Put EVERYTHING on the shared disks. The major reason for this is that any temporary files created by our good friend Oracle to detect what has happen will be in $ORACLE_HOME/dbs by default. Failure to do so may cause your db to act very

Re: but will it run windows?

M$ seems to like its TCP/IP stack ... Christopher Spence wrote: FreeBSD has some of the worst multiple processor thread support of all the linuxes, although it's IO if I remember well is pretty good. Do not criticize someone until you walked a mile in their shoes, that way when you

RE: NT backup script question

If you look in the WinZip help files, it can be used for this. It has it's own command line switches for creating archives from scripts also. -::YEX::- ))) -Original Message- Sent: Friday, August 17, 2001 12:25 PM To: Multiple recipients of list ORACLE-L PowerArchiver is another good

Re: table create vs alter

For all intensive purposes the table will be created the same. But, and someone with the ability to read the block data please check it out. There are my own thoughts In method 1 the block data is set up to have 3 columns per table. In method 2 the table is set up to have 1 column and the

Re: OT - Vaccines

Lisa, chill. grin You by definition get batty the minute you have kids. All the rest is details. You've seen my brood, briefly, so you know how nuts it can get (I had to throw out the boots BTW evil grin). A lot of the info comes from the net, with suspect sources. Believe it if you will.

Re: Converting EBCDIC to ASCII

If you export the IMS data out to flat textfiles, and then transfer them via ftp in ASCII mode, the conversion will be done automagically for you. Alternatively if on Unix the dd utility will do the conversion for you. One problem that we encountered with using dd to convert EBCDIC to

DBA tasks

Hi... I'am searching for a oracle dba task guide. A doc that especifi all the task of a oracle dba. javs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jairo Villalobos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

  1   2   >