Re: Re: SUN vs. HP
HP at version 10 and better is yet another SYSVR4 system. From a users or programmers point of view it is very generic. Service Guard is HP fault tolerant solution where two boxes share disk and if one node fails the other can take over. It is fairly complex and requires a good UNIX sysadmin. Oracle runs well in this environment. Allan - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 21, 2001 12:20 PM > HI.. > can someone please tell me a 'bit more' > about HP does it follow the 'basic tenets' of UNIX > or is it a 'freak deviant' version of UNIX (like AIX!!!).. > > For starters what is service guard please? > is it a cluster software? or RAID software to handle > disk boxes? > > > How 'different' is HP unix from Solaris? > (both from a DBA's point of view and sys admin's point of view)! > > Thanks > > > - Original Message -- > "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> wrote: > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > From:"C.S.Venkata Subramanian" <[EMAIL PROTECTED]> > Date:Tue, 20 Mar 2001 20:16:34 -0800 > Subject:Re: SUN vs. HP > > I have been working with Oracle under HP, I find HP server with high fault toulerence and reliable. If we tune the OS and DB then we can get maximum performance. One word of caution is that, if u use Mc Servicegaurd then u shud go for OPS. Which works for only on RAW partitions. Administration will not be a easy job. Instead go for AutoRAID box which HP has got. It converts itself bet RAID5 and RAID1/0. > > My recomendation will be for RAID10, where u have disk mirroring,stripping and protection for Data and better performance. > > I have not worked with SUN. But i have heard that the native code,compilation and testing of oracle is in the SUN OS. > > But HP is also a good OS. > > H/w is slightly costlier in HP. > > > -- > > On Tue, 20 Mar 2001 10:31:59 > Alex Apostolopoulos wrote: > >Hi, > > > >we are currently in the process of evaluating a high availiability cluster > >for our production database. The final two solutions are: > > > >SunCluster 2x420R 2Gig 2x450Mhz > >Storage 100Gig > > > >Hewlett Packard MC ServiceGuard > >2xL-Class 2x440Mhz 2Gig > >Storage VA 7100 100Gig > > > >Based on our criterias (scalability, performance, TCO, price, reliability, > >support, in house experience ...) it looks like a dead race... > > > >Any suggestions or thoughts would be help full > > > >cheers alex > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Alex Apostolopoulos > > 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). > > > > > Get 250 color business cards for FREE! at Lycos Mail > http://mail.lycos.com/freemail/vistaprint_index.html > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: C.S.Venkata Subramanian > 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). > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > --
Re: AIX volume group backup?
As strange as it sounds, it might be that your hosting service does not understand that the Oracle backups obtained in this way are useless. On the other hand, this may be their way of getting copies of static files because they have tapes to burn. Allan - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 8:55 PM we have 2 AIX servers at a remote hosting location. The host managers insist on doing volume group backups once a month, for all volumes on each server. Why would they insist on doing this? What purpose would these volume backups serve in a recovery situation? Thx. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy II 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: Allan Nelson 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: OT: this is the last thing we need
I believe rich in the US includes all households making over $60,000.00 / yr - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 3:25 PM > > At 12:21 PM 2/16/01 -0800, you wrote: > >Yeah I don't think you will get any money due to these tax cuts..Its > >intented to rich people. I don't understand Instead of developing further of > >social net and Education system, I don't see any nice thing to cut taxes and > >draining the money from vital systems like federal spending either its > >defence,social security and education. > > > > > (disclaimer: my experience is with Canada, although I bet my comments will > be mostly true for the USA as well) > > Left/middle govts are always talking about "the rich". People complain > about tax breaks because they'll mostly benefit "the rich". I wonder how > many people realize that these govts' definition of "rich" includes > probably as much as 90% of the working population? In Canada, at least, you > are one of "the rich" if you can afford a second car (not paid for, mind > you). You are "rich" if you can afford mortgage payments or have some hope > of being able to in the future. Lest you think I'm kidding, it's not all > that long ago that our local government slapped huge tax increases on > residents of Vancouver's west end, based on the idea that "those rich > fatcats" could afford it (The West End is upscale real estate here FYI). In > fact the government reps made very heavy use of the words "they" and "we". > Trouble is, it turned out that most of the rich fatcats were seniors on > fixed incomes who'd bought their houses long before the West End became > trendy, and who now couldn't afford the taxes. The governments reply: "They > can sell their houses or get mortgages". Yeah, so much for representing > "us". The only "them" we need to be saved from are the politicians. > > In fact there is very little in the way of "they" when talking about "the > rich". It's mostly "we". And the reason is simple. Governments can get away > with a lot more if they can define an enemy to capture your attention -- > some horrible "them" who are actually responsible for all your troubles. > Trouble is, in this case, the definition of "they" has gotten so broad over > time that there is very little "not they" left. > > As to tax breaks mostly benefiting the "upper middle" income tax brackets, > why are you surprised? Sliding tax scales mean that not only are "upper > middle" earners paying more on an absolute basis, but also more as a > percentage of income. Not to mention the various "temporary surtaxes" that > have been imposed over time. It is very difficult to come up with a tax > scheme that benefits "the poor" and doesn't benefit "the rich" -- at least > one that means anything -- by playing with the income tax tables. However, > a very good plan based on guaranteed minimum income was recommended by a > government task force a few years back -- and was rejected out of hand by > our oh-so-compassionate liberal government. > > And BTW, if you're thinking of claiming that high taxes benefit "the poor", > come to Vancouver. Canada has (last time I looked) the 4th or 5th highest > marginal tax rate in the industrialized world, and we've still got > panhandlers on every street corner. In fact Canada, with one of the highest > tax rates, and the U.S. with one of the lowest, have roughly equivalent > poverty rates overall. > > As to "safety nets", if someone in my family ever gets sick, we're going > straight over the border into Seattle for treatment. The Canadian medical > system exists in name only. > > Face it -- high taxes pay for only one thing -- politicians and political > patronage. > > > > > > Dennis Taylor > > To laugh at men of sense is the privilege of fools. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dennis Taylor > 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 containin
OFF Topic: Does Anyone use Metilinx products
Hello List: My company is thinking of using a company known as MetiLinx to build a small sales data warehouse. They have two products I-System and I-Manager that they claim will manager cluster resources to the extent that hardware requirements can be reduced by up to 40%. They also claim that their software can make SQL Server 7.0 perform in a manner similar to Oracle Parallel Server by using their technology. I would deeply appreciate any feedback, positive or negative, about these products that you may have. Thanks Allan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson 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: Converting DOS batch file to UNIX script
cp, mkdir, cd, echo, rm - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 2:02 PM Hello All: We are a Windows shop developing a software product that runs on an Oracle database. Most of our clients also run Oracle on Windows. Recently, a couple of our new clients have decided to run our database on a UNIX server instead of NT server. I do not know what flavour of UNIX our clients have. I know the slashes go in the other direction in UNIX scripts, but can anybody tell me the UNIX equivalent of COPY, MKDIR, CD, ECHO, and REM? Here are a few lines of the batch file we use to install our product. Can anybody help me to convert DOS batch file commands to generic UNIX script commands? ---snip--- @ECHO OFF ECHO ³ To run this installation please type (at the CD-ROM prompt) ³ IF "==%1" GOTO NODRIVE CD\ MKDIR %1:\DB543 COPY \SERVER\SCRIPTS\Install.bat %1:\DB543\SERVER\SCRIPTS\Install.bat >NUL: :NODRIVE REM this is a remark call %1:\DB543\SERVER\Scripts\Install.bat parm1 parm2 parm3 sqlplus system/manager@db ---snip--- Thanks for your help. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma 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: Allan Nelson 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: OT:Clinton/the economy etc.
modest too! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 3:36 PM > Wow You discovered Greatest truth BTW Iam a resident of Canada. Indians > never talk about their selfish ends..They always has Big heart!! > I think for some reason you pissed off with Indians, May be fear > compition Cheer up man > > > >From: Dan Dasko <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: OT:Clinton/the economy etc. > >Date: Fri, 16 Feb 2001 13:01:25 -0800 > > > >Wow, look at all those H1s blowing Clinton's horn. > >Isn't it interesting. Not a single Indian rising to > >the GOPs defense. Could it be they're worried that > >the H1 gravy train will come screeching to an end? I > >think they're starting to believe their own press > >about how there aren't any Americans available and > >that they're all highly trained exceptional specimens > >of programming talent. Hardly. > > > >Jingo man. > > > >PS: or if they're in India, WTF are they doing > >presuming to have an opinion on the president of the > >United States of America?? > > > >PPS: Have a great day. > > > >__ > >Do You Yahoo!? > >Get personalized email addresses from Yahoo! Mail - only $35 > >a year! http://personal.mail.yahoo.com/ > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Dan Dasko > > 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). > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raghu Kota > 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: Allan Nelson 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: Urgent! Change Character Set from WE8IS088591 to UTF8
I think export and import are the only way you can do this. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 5:40 PM > I have a 8.1.6.0.0 database. > > What is the best way to change Character Set from WE8ISO8859P1 to UTF8 > > from: > NLS_CHARACTERSET WE8ISO8859P1 > > To: > NLS_CHARACTERSET UTF8 > > Thanks > > Larry > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Taylor > 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: Allan Nelson 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 vs MS Access
I don't know of any comparisons but unless you have only a very tiny amount of data and you expect only one connection to the database at a time I would not use Access. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 2:11 PM We are developing web database standards in my workplace. I need to identify advantages/disadvantages of using Oracle verses MS Access for web databases. Does anyone know of any good resources for gathering this info (web sites, articles, etc)? Any help would be greatly appreciated. Thanks Maria -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Freytag 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: Allan Nelson 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: Difference between OAS and OiAS
Different names for the same product at different time in its life - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 2:03 PM > > > Anyone have any idea what the difference between the following two products > from Oracle. > > Oracle Application Server and Oracle Internet Application Server > > > Regards, > > Murali Vallath > Oracle Certified DBA > http://www8.ewebcity.com/muralivallath/ > http://www.summerksyus.com/ > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Murali Vallath > 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: Allan Nelson 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: No recovery situation
With a corrupt system tablespace and no backups you have no further recovery options. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 6:30 AM > Hello list, > I know that the answer to my question it´s going to be a negative one, > but I have to try to do all that I can do. > Until yesterday I was doing some attempt with an Oracle installation, > without a backup copy. And, unfortunately, I had to format my computer > (!!!). > Now I have the data associated with this installation, I could save the > datafiles (*dbf). The database was in a non archivelog mode, and what is > the worst thing of all, it had some corrupt blocks in the system.dbf > file. > Could I do something with them, or are they totally unworhty? > Could anybody give me an advice? > Maybe it would be easier for me to start from the beginning again > A lot of thanks, > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Beatriz Martinez Jimenez > 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: Allan Nelson 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: Parameter obsolete
Yes, that's what the error message is all about. - Original Message - From: Beatriz Martínez Jiménez To: Multiple recipients of list ORACLE-L Sent: Thursday, February 08, 2001 11:15 AM Subject: Parameter obsolete Hello list, This question is not a matter or life or death but a curiosity I have. I´m working with Oracle 8.1.6 and NT. Each time I open the database, I get the next message in the XXXALERT.log : Obsolete system parameters with specified values: distributed_lock_timeout I included it the init.ora file following a friend advice, but i have read that it has no sense in this Oracle version, so, could anybody tell me if I can delete it? TIA -- Beatriz Martínez Jiménez [EMAIL PROTECTED] Ingeniera Informática Fundación CIDAUT Parque Tecnológico de Boecillo, parcela 209 Boecillo 47151 Valladolid tfno.983 54 80 35
Re: Pinning Tables
Use the cache parameter to the alter table command - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 12:52 PM > > > Only method (which I am aware of ) to pin objects in SGA is DBMS_SHARED_POOL > package. However, this package does not support pinning tables and views. > > I am curious if there is a way to pin a table/view. > > > Eveleen > > > > > Please respond to [EMAIL PROTECTED] > > > "Kevin Kostyszyn" <[EMAIL PROTECTED]> on 02/05/2001 09:36:13 AM > > > Message - From: "Kevin Kostyszyn" <[EMAIL PROTECTED]> on 02/05/2001 03:36 PM > GMT > > > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > cc: (bcc: Eveleen Xu/NNIB/NNNG) > > > > Subject: Pinning Tables > > > > > > > > Hi all, > I have been trying to find some reference on pinning tables in the SGA. I > haven't found anything, all that I am finding is table caching and the keep > buffer pool. Is this all that there is, can I "pin" a table in the memory? > Thanks in advance. > > Sincerely, > Kevin Kostyszyn > DBA > Dulcian, Inc > www.dulcian.com > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kevin Kostyszyn > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson 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: Patchset installation
Not a good idea. Oracle links some libs in with a direcory that is in Oracle Home. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 3:42 PM > Hi, > > I am looking into installing a patchset with minimum downtime. Standard > Oracle procedure for installing a patchset is: > 1. Shutdown the database > 2. Install the patch binaries, relink. > 3. Startup database (restrict ?), run the cat* scripts. > > I wanted to change the procedure so that instead of having the database down > during the patch install and relinking, prior to the procedure I copy the > binaries to a newly created home, install the patch on the new home, relink > the binaries under the new home, and than just restart the database from the > new home. To make sure that everything is OK, I would postpone the cat* > scripts run, for a later time, once I am sure that everything is OK. If > something goes wrong I haven't changed anything in the database, and I can > just go back to the old home. > > Has anybody tried this ? What is the significance of cat* scripts. As far > as I understand them, oracle does not use them and do not care about them, > only some apps might break (most of all DBA type of scripts). > > Thanks. > > Djordje > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Djordje Jankovic > 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: Allan Nelson 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).
