SQL*NET VERSION

Hi all, How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Tuning Question and Advice needed ..

Thank you Sergey .. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday,

How Oracle screwed California

http://theregister.co.uk/content/7/25055.html

RE: Re: How come I don't get postings

Yep, I've subscribed -Original Message- Sent: 27 April 2002 15:58 To: Multiple recipients of list ORACLE-L And new ones joining every day! Wow! Jim bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: oh oh, lisa has a fan club :-) with lots of members.;-) --

Re: Storing formated data in oracle table

Hmm, as CLOB like .rtf file or .xml (of course you can store it in MS Word format). JP On Sat 27. April 2002 10:23, you wrote: hi all How to store formated data(bold,italic) in oracle table. bye - Do You Yahoo!? Yahoo! Health - your guide to

RE: SQL*NET VERSION

lsnrctl stat ? - Original Message - From: Sinardy Xing [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 28 Apr 2002 23:13:17 Hi all,=0D =0D How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number=0D =0D =0D Thanks=0D Sinardy=0D --=0D --

Oracle Messaging Gateway

Hi All, Is there anybody among you who has installed and configured Oracle Messaging Gateway and if so, could you please tell me where I can get the guidelines for the same ?? Any help would b greatly appreciated. Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email :

RE: How Oracle screwed California

Yes, I hear that here too negotiations between Oracle and Canada are tough... Idon'tknowifMicrosoftnegotiates--dotheynegotiate? Usually it seems to me managers just buy Microsoft boxes one at a time, without worrying too much about the overall costs and interoperability. Just curious if

RE: Insight on oracle enterprise manager

The OEM submits code to target databases via OraTcl (possibly just straight Java now) and SNMP to the Oracle Agent, which then passes it to the DBSNMP account on the target database. From there, the DBSNMP account runs the code, be it event checks, jobs, etc. Otherwise you have to go through

Size of segment

Hi, I have segments (Tables and indexes) which go into 500 MB -- 1 GB . I intend to do a rebuild since they are fragmented. Is it beneficial to have a single extent of 500 Mb or multiple extents are ok ? (maybe 4 --5) My contention is that so long as the extents are contiguous ( I could do

bitmap indices

hi! to speed up queries i have created a bitmap index on a column that contains 2 chars as a maximum. to my surprise the bitmap index does not make the query quicker than the 'usual' B-tree index, though there are only bout 100 different values in half a million rows. has n.e.one got

RE: Size of segment

Physically No Extents, No Blocks are Contigous.. There is No Use in Bringing the Entire Table 1 or 10 Extents. If you have Used PCTIncrease in your TBS then Over Time Your Tables and Indexwes will be fragmented. My Suggestion would be to give Uniform sized Extents and move the table and Index

RE: bitmap indices

Hope you are using the CBO and not the RBO. If yu use a Bitmap Index then the Optimizer will use a CBO and if the stats are not proper then u may not get a Proper Result. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019

RE: How Oracle screwed California

Sounds like Ca. kind of did it to itself Let the buyer beware...Seems we have forgotten that old adage... -Original Message- Sent: Monday, April 29, 2002 4:33 AM To: Multiple recipients of list ORACLE-L http://theregister.co.uk/content/7/25055.html

RE: CPU Pegged at 100%

I don't think that increasing the db_writer_processes will help. NT is, as noted elsewhere, multi-threaded. Increasing the db_writer_processes will not start a new process. My experience with Oracle on NT is that when the CPU is pegged at 100% it is because the OS is constantly writing and

Re: Size of segment

On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote: My Suggestion would be to give Uniform sized Extents and move the table and Index into that tablespace. -- You are taking a preformance hit having the indexes and tables in the same tablespace, are you not?

RE: CPU Pegged at 100%

Thanks Thomas for sending this to the list. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Thomas Day [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 9:59 AM To: Multiple

RE: How Oracle screwed California

Agreed. The problem lies with DOIT, the Department of Information Technology, which was created to protect the state from such deals. Unfortunately its head was a political appointee whose selection was based on his ability to deliver votes, not to understand software contracts. The

RE: Size of segment

Sorry that I was not explicit .. If you are experiencing high Transactions You need to put the Tables and Indexes on Different Tablespaces [ again Uniformly Sized] Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019

pl/sql

Hallo, I have a package which includes 5 different procedures. I would like an exception which tells me an error message if any of the procedures fail. So if procedure 1 fails I would get an error message or if procedure number 2 would fail, or proc number 3 e tc then I would get an error

Re: Size of segment

Ray Stell wrote: On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote: My Suggestion would be to give Uniform sized Extents and move the table and Index into that tablespace. -- You are taking a preformance hit having the indexes and tables in the same tablespace, are you

RE: Size of segment

Hey and Another Thing there is No Performance Benift By Putting them on different Tablespaces. So For Easier Management the Original Poster can Put it in Different TBS and not For any performance Reasons. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP :

Re: CPU Pegged at 100%

On Mon, Apr 29, 2002 at 05:59:18AM -0800, Thomas Day wrote: I don't think that increasing the db_writer_processes will help. NT is, as noted elsewhere, multi-threaded. Increasing the db_writer_processes will not start a new process. My experience with Oracle on NT is that when the CPU

RE: SQL*NET VERSION

You can't unless you read the documentation that came with your database. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:13 AM To: Multiple recipients of list ORACLE-L Subject: SQL*NET

RE: SQL*NET VERSION

For Oracle 8i, the version of SQL*Net/Net8 should match your kernel version. It was Oracle7 that the products had different version numbers. You can also select from v$version to obtain current information. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248)

RE: How Oracle screwed California

-- Boivin, Patrice J [EMAIL PROTECTED] I don't know if Microsoft negotiates -- do they negotiate? Quite. They make Norton Simon look like a pushover. See coverage of the recent trial for examples. -- Steven Lembark 2930 W. Palmer Workhorse Computing

RE: pl/sql

I suggest you give me the name of the company you work for and also some information on their current salary rates. Can you let me know when your position becomes available. ;o) -Original Message- Sent: 29 April 2002 15:54 To: Multiple recipients of list ORACLE-L Hallo, I have a

AW: pl/sql

Hi Roland, You can implent something like this: sERROR_TEXT := 'execute P1 failed'; exec P1; --- IF SQLCODE != 0 THEN sERROR_CODE := -20005; sERROR_TEXT := 'execute P1 failed. Oracle Error Number:: ORA' || SQLCODE || '-' || SQLERRM; raise DATA_ERROR; END IF; ---

RE: Size of segment

Charlie, I think conventional wisdom suggests splitting data and index onto separate disks rather than separate tablespaces. Just to start the unsubstantiated anecdotal evidence I've seen this help on more occasions than I care to recall. I'm the first to agree though that separating data and

RE: SQL*NET VERSION

Whatever happened to the good old oraver command in 8.0 ?? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 29 April 2002 15:54 To: Multiple recipients of list ORACLE-L You can't unless you read the documentation that came with your database. Scott Shafer San Antonio, TX

Files which can be deleted from ORACLE_HOME to release space

Greetings, If I remember correctly after the install of Oracle 8i, we can delete some of the files(*O and *o) from some directory under $ORACLE_HOME. Probably from $ORACLE_HOME/bin or $ORACLE_HOME/lib or some directory. Could you please confirm this and is there any white paper any document

RE: Size of segment

The improvement is more about putting them in different tablespaces that reside on different physical disks, therefore sharing the I/O between the disks, and having the disk heads searching concurrently, rather than thrashing back and forth.. Mark

Re: Size of segment

On Mon, Apr 29, 2002 at 06:53:39AM -0800, Charlie Mengler wrote: Ray Stell wrote: On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote: My Suggestion would be to give Uniform sized Extents and move the table and Index into that tablespace. -- You are taking a

Re: Size of segment

On Mon, Apr 29, 2002 at 07:29:01AM -0800, Hately Mike wrote: Charlie, I think conventional wisdom suggests splitting data and index onto separate disks rather than separate tablespaces. Aren't the two things synonymous? How could you control the location of the index forcing it onto a

Re: Insight on oracle enterprise manager

You need to have the agent running if you want to submit jobs using OEM and it's parts like Backup Manager. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 26, 2002 8:18 PM We don't have intelligent agent running on any of

RE: RE: pl/sql

I suggest you give me the name of the company you work for and also some information on their current salary rates. Can you let me know when your position becomes available. ;o) Dumping the shares would seem wiser to me. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L

Help: could not resolve service name error

Oracle 9i on XP Prof. on DELL PC. I created a test DB on my PC and when I try to log into SQL I get this error: ORA-12154: TNS: could not resolve service name. How do I fix this? Thanks, Ken Janusz, CPIM

Oracle Financials Sys Admin. Needed in South Carolina

Company located in Spartanburg, South Carolina with a small IT shop needs an Oracle Financials System Adminsitrator to join its IT team. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send

export to tape!!

Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos:

Re: bitmap indices

Generate an access path plan for each as well as checking some tkprof output and you'll see why this is the case. hth connor --- Daniel Wisser [EMAIL PROTECTED] wrote: hi! to speed up queries i have created a bitmap index on a column that contains 2 chars as a maximum. to my surprise

RE: Size of segment

Ray, The 2 things aren't at all synonymous; it's quite possible to split objects across tablespaces while keeping them on one disk. You mean that one requires the other and on the whole you're right. I agree that sensibly you need to split them across tablespaces to achieve disk separation but

RE: Help: could not resolve service name error

At the risk of stating the obvious, is your tnsnames.ora file set up correctly ?? Regards Lee -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: 29 April 2002 17:41To: Multiple recipients of list ORACLE-LSubject: Help: could not resolve service name error

Database Metrics

Title: Database Metrics Hi, I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time. These metrics should be simple enough as the management is not Oracle savvy. Thanks

RE: Size of segment

Damn! Spot the typo. Blame it on the 4am start today. I meant : create tablespace disks_and index datafile '/disk1/disks_and index01.dbf' size 51m, '/disk2/disks_and index01.dbf' size 51m; create table mike01 ( x varchar(10) ) storage (initial 50m) tablespace

persistent connections vs. login/logout white papers anyone?

Looking for any white papers on the above topic with business cases, testing results, etcAnyone know of any...? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: CPU Pegged at 100%

I have 5 DBWR processes according to INIT.ORA on NT .. I see them on V$SESSION but There is only one process ORACLE.EXE in the processes list of NT still. I do not understand the behaviour of ORacle on NT neither the Oracle I think. Bunyamin K. Karadeniz Oracle DBA / Developer

Oracle Express with +4 million rows on fact table

Friends: I obtain to have a good performance using the Oracle Express 6.x with a table fact of +4 millions of rows? Which would be the ideal configuration for the server? Please it enters in contact... Obrigado, -- Alexandre Sartori Advanced Database Consultoria e Sistemas Equipe Business

RE: Database Metrics

A few idears... Summarize total database size growth (growth of the actual data, not the object) and deltas by tablespace. Summarize actual object growth (object as opposed to size, contrast against overall total tablespace space) and deltas. Create a benchmark query that runs at various

RE: Oracle Financials Sys Admin. Needed in South Carolina

Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. I'm wondering what frequent means...? Am I the only one that thinks the pay scale is a bit low, with this caveat? To me, the paradigm seems

Re: CPU Pegged at 100%

The DBWRs are implemented as threads inside the ORACLE process (multi-threaded). This is beginning to sound like a Pern novel. Bunyamin K.

RE: CPU Pegged at 100%

oracle.exe spawns out threads, which you will not see running in the task manager. Each DBWR process then will be a thread of oracle.exe. RF -Original Message- Sent: Monday, April 29, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I have 5 DBWR processes according to

RE: Unix - Writing stderr to a file and stdout

Does this do it? STDOUT is directed to stdout.log. STDERR is directed to the stdout.log and stderr.log. I did it using dtksh shell but should work in standard ksh shell. #!/usr/dt/bin/dtksh rm PIPE stdout.log stderr.log mknod PIPE p touch stdout.log tee -a stdout.log PIPE 1stderr.log find

Re: Size of segment

On Mon, Apr 29, 2002 at 09:29:31AM -0800, Hately Mike wrote: create tablespace disks_and index datafile '/disk1/disks_and index01.dbf' size 51m, '/disk2/disks_and index01.dbf' size 51m; create table mike01 ( x varchar(10) ) storage (initial 50m)

Re: Active Compare - Oracle/Sqlserver - COMPARE WIZ

You might want to look at this: http://www.iraje.com/acc_comparemain.htm In addition to identifying the diffs, generating the diff reports alter scripts, it also: - executes the consolidation SQL realtime- Active - supports compares across ORACLE and SQLSERVER - allows rules: for conditional

RE: Oracle Financials Sys Admin. Needed in South Carolina

You've hit the nail on the head there. They're looking for something for nothing. If they get somebody at this price I suspect that the town is near and dear to them. I wonder what the relo is? 2k? -Original Message- Sent: Monday, April 29, 2002 1:58 PM To: Multiple recipients of

RE: Oracle Financials Sys Admin. Needed in South Carolina

This job sounds like a nightmare! A one-person show. I can't think of a situation that could possibly be more stressful. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject:

RE: Oracle Financials Sys Admin. Needed in South Carolina

As evidence of this, HomeFair.com's salary calculator says a salary of $100,000 in Manhattan is equivalent to $32,000 in Spartanburg. Doubt this is accurate to the penny, but if even close it sounds like $75K has you living like a king (or queen) in Spartanburg. Jim -Original

Certification of Brainbuzz and BrainBench

Dear Gurus , I want to take a certification and I wonder if brainbench and brainbuzz certifications will help me in my job search. Are these really as valuable as to write to the CV. Do you recommend them ? Why I prefer these examsis cheaper price .. Bunyamin K. Karadeniz

RE: Database Metrics

Robert - Excellent ideas! To bounce off your ideas, one thought is to find out what matters most to the users and create some statistics based on that. For example, one of our applications has a process that performs really badly during the peak season. Some fixes have been tried, but management

RE: persistent connections vs. login/logout white papers anyone?

Robert - Don Bales in his recent book Java Programming with Oracle JDBC (O'Reilly) describes 4 strategies for Java servlet database connections: 1. Per-transaction connection. Each method opens and closes the connection. Most CGI programs use this and it is the least efficient. 2. Dedicated

PATCH?

Hi How to install hp-ux patch before installing oracle on HP9000 server(based on PA Risk)? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ:

ORA-12541: TNS:no listener

Do you know where I can get an answer to the following question: Why do I get the following error: ORA-12541: TNS:no listener on my win 2000 professional client when trying to connect using SQLPLUS lanier/lanier@cde mailto:lanier/lanier@cde ? 1. The client is a separate box from the server

RE: Oracle Financials Sys Admin. Needed in South Carolina

Try being the same thing, and being the primary one resposible for the implimentation as well... with an end to end time line of 10 weeks... =) Stress doesn't begin to describe it! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/29/02 1:38 PM This job sounds like

RE: Oracle Financials Sys Admin. Needed in South Carolina

Oh come on! Things are so much more relaxed in the deep south. -Original Message- Sent: Monday, April 29, 2002 1:38 PM To: Multiple recipients of list ORACLE-L This job sounds like a nightmare! A one-person show. I can't think of a situation that could possibly be more stressful.

WHich Unix command

Hi Which unix command(On Solaris) is used to find latest biggest files on whole server? or Which unix command(On Solaris) is used to find latest biggest files on particular disk partition? Thx -seema _ MSN Photos is the easiest

RE: ORA-12541: TNS:no listener

Asuming your database is where the cleints tnsnames file has it, then it's a possibility the 1 Database isnt running on the server (go to server and lsnrctl status 2 The port is wrong in the tnsnames file Can you tnsping yourinstance ? If you cant chances you have incorrect syntax in the

RE: Oracle Financials Sys Admin. Needed in South Carolina

I don't know...I would think $100,000 in Manhattan you would be sharing a studio apartment with 10 others. Conboy, Jim

RE: Oracle Financials Sys Admin. Needed in South Carolina

The only problem with this line of thinking is the federal government. They seem to take out the same amount for federal taxes as well as social security no matter where I live. If this is truly reflective of the cost of living there then I better automatically receive a check just for being a

RE: CPU Pegged at 100%

Thomas, If you could locate that paper, we would all be grateful. I have been unable to find it. Thanks, Jared Thomas Day [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/29/2002 06:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Oracle Financials Sys Admin. Needed in South Carolina

Yeah, pass me a sweet tea and a piece of straw to pick my teeth with! There's just as much stress here in the Atlanta area as anywhere else I've ever lived. And, NO, the cost of living is not any lower than anywhere else contrary to what recruiters and hiring managers will tell you. Since the

RE: Certification of Brainbuzz and BrainBench

Bunyamin - The value of an exam is in the eye of the person that might hire you. I can't personally advise you about the job market in Turkey. If you can talk to other managers that hire people like yourself, you might be able to get an idea. You could also talk to some recruiters and ask them.

RE: Oracle Financials Sys Admin. Needed in South Carolina

Here in Nova Scotia years ago I worked in a lab where the lab techs (who all had B.Scs in chemistry and organic chemistry) were getting paid less per hour than the factory workers who stuffed pies across the street. The lab techs kept coming to work though, because they didn't want to leave the

RE: WHich Unix command

Du disk use Df disk free Check man du so you can get only files n bob -Original Message- Sent: Monday, April 29, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Hi Which unix command(On Solaris) is used to find latest biggest files on whole server? or Which unix

RE: Database Metrics

Title: RE: Database Metrics I use these two to show the number of tables created and tables modified by month. In our case, the number of new tables and DDLs has been climbing as the database is getting more complex. On a graph, the lines are climbing upward which is something management can

Re: persistent connections vs. login/logout white papers anyone?

Robert, I am just writing a paper on that. It is called Application Efficiency and there some interesting results on this. IIt has great impact on the amount of CPU used and response time. Anjo. Freeman, Robert wrote: Looking for any white papers on the above topic with business cases,

RE: CPU Pegged at 100%

All background processes are threads within the oracle.exe process on NT/2000 platform. -Original Message- Sent: Monday, April 29, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I have 5 DBWR processes according to INIT.ORA on NT .. I see them on V$SESSION but There is

RE: Oracle Financials Sys Admin. Needed in South Carolina

Robert et:all Have you noticed a trend in the hiring today? The potential employer wants All phases of ORACLE FINANCIALS including system administration, RDBMS tuning, application tuning, DBA/Unix back-up administration, user training, report development utilizing SQL*Plus and Reports 2.5.

RE: Oracle Financials Sys Admin. Needed in South Carolina

Title: RE: Oracle Financials Sys Admin. Needed in South Carolina Robert, Sounds like a Catch-22. If you take this job, the frequency of your job changes has increased therefore you can't have this job. They want someone who doesn't change jobs to change jobs. Jerry Whittle ACIFICS DBA

RE: Oracle Financials Sys Admin. Needed in South Carolina

Title: RE: Oracle Financials Sys Admin. Needed in South Carolina From: http://ask.yahoo.com/ask/20011231.html According to the Federation of Tax Administrators, the following states impose no income tax on state residents: Alaska, Florida, Nevada, South Dakota, Texas, Washington, and

RE: Oracle Financials Sys Admin. Needed in South Carolina

Michael- 'Taint no tax free states, sometimes they just hide it better how they get you (sales tax, property tax, personal property tax, gasoline tax, etc.) Except for maybe Alaska, as long as the oil keeps flowing. But I know what you mean. Anybody who moves based solely on these

Quick one about Standby database

I've read that Oracle does not advise (or may be support) to have a standby database on a plataform different to the original one. I have a database on Solaris and I'd like to create a standby for this db over HP. Can that be done? I KNOW IT'S NOT SUPPORTED. All I want to know is if anyone has

RE: WHich Unix command

I suggest looking for large directories, and then follow up from there. You should look at the man page on du. That should do the trick. Steve McClure -Original Message- Sent: Monday, April 29, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Hi Which unix command(On Solaris)

Compare Schemas

I need to compare the schemas for two databases. I tried Toad, which will tell me there are differences but it won't say what the differences are. Does anyone have a script that will show the differences in detail? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ:

ORA-27101 Shared Memory Realm Does Not Exist

I just installed Oracle 9i on a WinNT 4 server. It already had 8.1.6. I installed Oracle 9 into a different home. The service/instance starts. When I try to connect via sqlplus / to create a database I get ORA-27101 Shared Memory Realm Does Not Exist . I have the oracle_sid set correctly. Any

RE: CPU Pegged at 100%

Try http://www.quest.com/presentations/pdfs/MT_maxprod9i.pdf or the link is on http://www.quest.com/presentations/openworld_2001.asp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:29 PM To: Multiple recipients of list ORACLE-L

RE: Oracle Financials Sys Admin. Needed in South Carolina

I have been told that Atlanta is the New York of the south. The cost of living in Atlanta is NOT cheap due to the cost of utilities (mostly power) and housing. And don't let anyone tell you that about Florida, either. They will tell you that not paying state tax is like getting a 8% pay

PATCH?

How to give birth? Please advise. Thx. --Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Unix - Writing stderr to a file and stdout

Brian, That did it..Thanks a lot for the trick.. Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Monday, April 29, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Does this do it? STDOUT is directed to stdout.log. STDERR is directed to the stdout.log and stderr.log.

RE: Quick one about Standby database

Pablo - Usually you create the standby database by copying all the data files from the production system. Then it is an identical system, so you can apply the archive logs from production. With different systems, you couldn't copy the data files. I'm not even sure you could move the archive logs

RE: Oracle Financials Sys Admin. Needed in South Carolina

I'm sure it's cheaper than here in Boston! Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Monday, April 29, 2002 4:49 PM To: Multiple recipients of list ORACLE-L I have been

Re: Which Unix command

I build/keep several functions in my .profile file (see below). They are all simple enough to call at anytime. Have fun Function Description findc find files findl find large files

RE: PATCH?

Title: RE: PATCH? EPIDURAL.. advice from the recently hatched (eight month old little girl:) -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED] Sent: Monday, April 29, 2002 4:54 PM To: Multiple recipients of list ORACLE-L

Re: Compare Schemas

Ron, You can use Oracle's Change Manager to compare schemas for two different databases. It has a nice feature that will even let you compare two schemas in different databases with different names. I have used the tool, and it shows all the differences with drill down detail. Traci L.

RE: Quick one about Standby database

You can try. I use the XP as the primary and Win2000 as the standy database machine. It works fine. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Pablo - Usually you create the standby database by copying all the data files from the production system. Then it is an identical system, so you

RE: CPU Pegged at 100%

Thanks for the link. This is not actually a paper though, just a high level power point presentation in a PDF file. It is lacking a lot of detail. It also perpetuates some tuning myths, thereby contributing to CTD. Jared Murray, Margaret [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: PATCH?

LIsa - Please to adopt. Thx. -Original Message- Sent: Monday, April 29, 2002 3:54 PM To: Multiple recipients of list ORACLE-L How to give birth? Please advise. Thx. --Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL

Re: ORA-27101 Shared Memory Realm Does Not Exist

Rick, Are you trying for two seperate versions of Oracle on the box, or did you remove the 8.1.6 to install 9i? If you did the latter, I'm afraid your uninstall did not go properly and your service isn't pointing to the right place. Oradim is the supported method for removing (renaming?) an

RE: CPU Pegged at 100%

That's not the one that I was using but it is a very good and useful presentation. Murray,

Re: PATCH?

Lisa, Instead of a patch, I'd say it's more like a core dump. :-) Although, a core dump usually frees up resources, but in this particular case the resource load will only continue to go up over time. Maybe it's closer to a forked process in either case, good luck and congrats!

RE: Schema comparison

Smith, Ron L. wrote: I need to compare the schemas for two databases. I tried Toad, which will tell me there are differences but it won't say what the differences are. Does anyone have a script that will show the differences in detail? Ron Smith DBA Kerr-McGee Corp There is

  1   2   >