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-- 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: 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, April 27, 2002 6:28 AM Hello Bunyamin, 1) These values are values between starting utlbstat and utlestat (not from database startup). 2) It's impossible to make all wait events=0. Importance of different events depends on what database you have (OLTP, DSS, mixed). Optimims for wait events are zero wait time :-) You should query another views for identifying are these values optimal. For example for Latch Free event you should do the following query: select name, sleeps/gets from v$latch where name='cache buffers lru chain'; sleeps/gets should be 99% or you have to increase DB_BLOCK_LRU_LATCHES (default value for this parameter should be num_cpu*1.5 maximum value not greater then num_cpu*6) So for another events. Your values are normal for approx 10 Gb database with hundred or more concurrent sessions (working hard). Saturday, April 27, 2002, 2:18:32 AM, you wrote: BKK Dear Gurus , I need your help .. BKK I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as internal and look at the report.txt generated ... BKK On report.txt , I see that BKK System wide wait events for background processes: BKK System wide wait events for non-background processes : BKK Latch statistics BKK Statistics on no_wait gets of latches BKK Sum IO operations over tablespaces BKK and other things also is in the report. BKK Question 1) BKK What I wonder is BKK Are these values between the start and end times of scripts. BKK What I mean is , for example Is the wait events for non-background processes list in report are the wait events occured between UTLBSTAT script run time T1 and UTLESTAT script run time T2 ? BKK or are they total wait events from the startup of database ? BKK Question 2) BKK I see lots of wait events occur .. BKK What will I give importance to ? BKK will I try to make 0 wait event in report. What are the optimums of wait events. ? BKK For example I see BKK Latch free event occured for 3015 times , BKK control file sequential read occured for 182 times , BKK log file sync occured for 1756 times BKK direct path read occured for 11000 times BKK direct path write occured for 6000 times BKK Are these values normal ? Will I try to make them 0 in the tomarrows report ? BKK How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? BKK Thank you... BKK Bunyamin K. Karadeniz BKK Oracle DBA / Developer BKK Civilian IT Department BKK Havelsan A.S. Eskisehir yolu BKK 7.km Ankara Turkey BKK Phone: +90 312 2873565 / 1217 BKK Mobile : +90 535 3357729 -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov 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: Bunyamin K. Karadeniz 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).
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.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. On a clear disk you can seek forever. -Computerworld button -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 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 health and wellness -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 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 : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: 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 there are negotiations like this between Microsoft and the state governments, for example. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Nicolai Tufar [mailto:[EMAIL PROTECTED]]Sent: Monday, April 29, 2002 5:33 AMTo: Multiple recipients of list ORACLE-LSubject: How Oracle screwed California http://theregister.co.uk/content/7/25055.html
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 SQL*Worksheet or some of the other GUI tools, I think. You might be able to shutdown and restart databases via the console or DBA Studio. First you have to log into the database by double-clicking in the navigator pane on databases that you placed there manually and configured to connect as SYSDBA. The SQL that is submitted through most of the GUI tools is just SQL via SQL*Net, it's not through SNMP and the Oracle Agent. That's why it's important to change the DBSNMP password! If you leave the Oracle Agent running, and you ran the catsnmp.sql script, your dbsnmp account is open to the world. Check MetaLink for info on how to change dbsnmp passwords. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, April 26, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Subject:Re: Insight on oracle enterprise manager We don't have intelligent agent running on any of our database servers, and OEM (Solaris version) works fine. I *think* the agent is only needed for monitoring with OEM. Bob Metelsky wrote: Hi all New to the list... beeen lurking for about a week. Ive recently been interested in using OEM Ive installed it on my server with one database, the questions is,how can I acccess the other dbs that dont have intellegent agents I cant seem to add the dbs manually thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Suzy Vordos 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: Boivin, Patrice J 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).
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 a rebuild) the number do not matter so long as they are not too high. Any suggestions ? Thanks shreepad -- 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).
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 experience with bitmap indices? are there any further poosibilities to adapt them when creating??? tia bye daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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: 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 into that tablespace. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 4:43 PM To: Multiple recipients of list ORACLE-L 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 a rebuild) the number do not matter so long as they are not too high. Any suggestions ? Thanks shreepad -- 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: Ganesh Raja 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: 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 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 4:43 PM To: Multiple recipients of list ORACLE-L 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 experience with bitmap indices? are there any further poosibilities to adapt them when creating??? tia bye daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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: Ganesh Raja 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: 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 http://theregister.co.uk/content/7/25055.html -- 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: (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: 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 fetching the contents of RAM to the swapfile. Meghraj Thakkar from Quest has a good paper on running Oracle 9i on Windows NT/2000. A search on Yahoo will probably find it for you. I don't have the URL. The following points are taken from that paper. Decrease the size of SGA so that all of the SGA and the OS will fit in physical RAM. This will decrease the use of the swapfile. Choose Maximum throughput for network applications in the control panel. Oracle does it's own memory management. Trying to let Windows memory manage on top of that adds to swapfile use. From the Services panel, disable all unneeded services. This includes License logging service, plug and play, remote access autodial manager, remote access connection manager, remote access server, and telephony service. You should not touch alerter, browser, eventlog, messenger, Oracle Service, Oracle TNSListener, Server, spooler and workstation. If you have 9i, set PRE_PAGE_SGA = TRUE. This tells Windows to keep the SGA in physical memory (RAM) as much as possible. It will get paged out --- that's the nature of Windows --- but not as often. Windows does IO buffering. However, Oracle does its own IO buffering apart from the OS. Performance can be increased and more of the RAM made available to the SGA by using REGEDIT and editing the registry. Go to \HKEY_LOCAL_MACHINE\Control\SessionManager\MemoryManagement and setting LargeSystemCache to 0. Be sure to back up the Registry before editing. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: 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? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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 recipients of list ORACLE-L Subject: 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 fetching the contents of RAM to the swapfile. Meghraj Thakkar from Quest has a good paper on running Oracle 9i on Windows NT/2000. A search on Yahoo will probably find it for you. I don't have the URL. The following points are taken from that paper. Decrease the size of SGA so that all of the SGA and the OS will fit in physical RAM. This will decrease the use of the swapfile. Choose Maximum throughput for network applications in the control panel. Oracle does it's own memory management. Trying to let Windows memory manage on top of that adds to swapfile use. From the Services panel, disable all unneeded services. This includes License logging service, plug and play, remote access autodial manager, remote access connection manager, remote access server, and telephony service. You should not touch alerter, browser, eventlog, messenger, Oracle Service, Oracle TNSListener, Server, spooler and workstation. If you have 9i, set PRE_PAGE_SGA = TRUE. This tells Windows to keep the SGA in physical memory (RAM) as much as possible. It will get paged out --- that's the nature of Windows --- but not as often. Windows does IO buffering. However, Oracle does its own IO buffering apart from the OS. Performance can be increased and more of the RAM made available to the SGA by using REGEDIT and editing the registry. Go to \HKEY_LOCAL_MACHINE\Control\SessionManager\MemoryManagement and setting LargeSystemCache to 0. Be sure to back up the Registry before editing. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 state is doing away with DOIT. When that was first announced, the head of DOIT was pleading with software companies for funds to fight the department's closure! Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 6:13 AM To: Multiple recipients of list ORACLE-L 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 http://theregister.co.uk/content/7/25055.html -- 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] 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: 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 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 6:23 PM To: Multiple recipients of list ORACLE-L 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? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Ganesh Raja 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).
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 message, which tells me which procedure that fails. I tried this, but didnt work. Just give me an easy example on this. I tried to look it up in the manual but didnt get it work. Should I put the exception after each procedureis finished. Like this: And should I name the exceptions in different ways, for instance givethem the names EXCEPTIONS1, EXCEPTIONS2 etc. p1 exception p2 exeption p3 exception p4 exception p5 exception Thanks in advance Roland -- 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).
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 not? There is/was a recent and active discussion of this topic in the Oracle Server Usenet forum. While it has long been recommended that tables indexes be placed in separate tablespaces, the current conventional wisdom disputes the claim that performance can/will be enhanced by separating data and indexes into different tablespaces. If anybody can produce recent benchmark results which shows that separating index data into different tablespaces improves performance, I'd like to see the details behind the benchmark and the results. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: 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 : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 6:23 PM To: Multiple recipients of list ORACLE-L 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? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Ganesh Raja 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: 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 is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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 VERSION Hi all, How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number -- 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).
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) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Subject: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 VERSION Hi all, How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number -- 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: 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 Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: 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 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 message, which tells me which procedure that fails. I tried this, but didnt work. Just give me an easy example on this. I tried to look it up in the manual but didnt get it work. Should I put the exception after each procedureis finished. Like this: And should I name the exceptions in different ways, for instance givethem the names EXCEPTIONS1, EXCEPTIONS2 etc. p1 exception p2 exeption p3 exception p4 exception p5 exception Thanks in advance Roland -- 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: Thomas, Kevin 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).
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; --- --- error handling --- EXCEPTION WHEN DATA_ERROR THEN --- INSERT INTO ERRORS ( ERROR_CODE, ERROR_TEXT, ADD_DATE) VALUES (sERROR_CODE, sERROR_TEXT,SYSDATE); --- WHEN OTHERS THEN --- Oracle Erros sERROR_CODE := 'ORA' || SQLCODE; sERROR_TEXT := sERROR_TEXT || ' ' || SQLERRM; --- INSERT INTO ERRORS ( ERROR_CODE, ERROR_TEXT, ADD_DATE) VALUES (sERROR_CODE, sERROR_TEXT, SYSDATE); --- HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 29. April 2002 16:54 An: Multiple recipients of list ORACLE-L Betreff: 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 message, which tells me which procedure that fails. I tried this, but didnt work. Just give me an easy example on this. I tried to look it up in the manual but didnt get it work. Should I put the exception after each procedureis finished. Like this: And should I name the exceptions in different ways, for instance givethem the names EXCEPTIONS1, EXCEPTIONS2 etc. p1 exception p2 exeption p3 exception p4 exception p5 exception Thanks in advance Roland -- 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: 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: 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 indexes into separate tablespaces won't help if they're on the same disks. It will make them easier to split in future though. Regards, Mike Hately -Original Message- Sent: Monday, April 29, 2002 3:54 PM To: Multiple recipients of list ORACLE-L 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 not? There is/was a recent and active discussion of this topic in the Oracle Server Usenet forum. While it has long been recommended that tables indexes be placed in separate tablespaces, the current conventional wisdom disputes the claim that performance can/will be enhanced by separating data and indexes into different tablespaces. If anybody can produce recent benchmark results which shows that separating index data into different tablespaces improves performance, I'd like to see the details behind the benchmark and the results. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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: 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 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 VERSION Hi all, How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
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 from Oracle, where it specifies about this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: 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 === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Mengler Sent: 29 April 2002 15:54 To: Multiple recipients of list ORACLE-L 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 not? There is/was a recent and active discussion of this topic in the Oracle Server Usenet forum. While it has long been recommended that tables indexes be placed in separate tablespaces, the current conventional wisdom disputes the claim that performance can/will be enhanced by separating data and indexes into different tablespaces. If anybody can produce recent benchmark results which shows that separating index data into different tablespaces improves performance, I'd like to see the details behind the benchmark and the results. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Mark Leith 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: 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 preformance hit having the indexes and tables in the same tablespace, are you not? There is/was a recent and active discussion of this topic in the Oracle Server Usenet forum. While it has long been recommended that tables indexes be placed in separate tablespaces, the current conventional wisdom disputes the claim that performance can/will be enhanced by separating data and indexes into different tablespaces. If anybody can produce recent benchmark results which shows that separating index data into different tablespaces improves performance, I'd like to see the details behind the benchmark and the results. -- Cool! Would love to see this data, also, because it doesn't make any logical sense to me, unless the index and table ts are on the same disk, I suppose. I love it when I open can-o-worms. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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 different disk without having a seperate ts/datafile? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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 our database servers, and OEM (Solaris version) works fine. I *think* the agent is only needed for monitoring with OEM. Bob Metelsky wrote: Hi all New to the list... beeen lurking for about a week. Ive recently been interested in using OEM Ive installed it on my server with one database, the questions is,how can I acccess the other dbs that dont have intellegent agents I cant seem to add the dbs manually thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Suzy Vordos 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: Ruth Gramolini 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: 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 FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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).
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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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).
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: http://photos.msn.com/support/worldwide.aspx -- 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).
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 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 experience with bitmap indices? are there any further poosibilities to adapt them when creating??? tia bye daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: 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 the point I was making was that the disk placement is the important point rather than the tablespace name. BTW This is how could you control the location of the index forcing it onto a different disk without having a separate ts/datafile? Mind you, I'll agree you'd have to be mad to do it. =) create tablespace disks_and index datafile '/disk1/disks_and index01.dbf' size 51m, '/disk1/disks_and index01.dbf' size 51m; create table mike01 ( x varchar(10) ) storage (initial 50m) tablespace disks_and index; create table mike01_ix on mike01(x) storage (initial 50m) tablespace disks_and index; Regards, Mike Hately -Original Message- Sent: Monday, April 29, 2002 5:20 PM To: Multiple recipients of list ORACLE-L 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 different disk without having a seperate ts/datafile? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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: 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 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 The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
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 in advance! Yuval. Sr. DBA - WWF
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 disks_and index; create table mike01_ix on mike01(x) storage (initial 50m) tablespace disks_and index; Mike -Original Message- Sent: Monday, April 29, 2002 6:05 PM To: Multiple recipients of list ORACLE-L 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 the point I was making was that the disk placement is the important point rather than the tablespace name. BTW This is how could you control the location of the index forcing it onto a different disk without having a separate ts/datafile? Mind you, I'll agree you'd have to be mad to do it. =) create tablespace disks_and index datafile '/disk1/disks_and index01.dbf' size 51m, '/disk1/disks_and index01.dbf' size 51m; create table mike01 ( x varchar(10) ) storage (initial 50m) tablespace disks_and index; create table mike01_ix on mike01(x) storage (initial 50m) tablespace disks_and index; Regards, Mike Hately -Original Message- Sent: Monday, April 29, 2002 5:20 PM To: Multiple recipients of list ORACLE-L 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 different disk without having a seperate ts/datafile? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. --
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: (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: 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 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: Monday, April 29, 2002 5:53 PM 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 is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 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 Intelligence www.advanceddb.com.br Fone/Fax (51) 3328 9064 Ramal 26 Celular (51) 9114 1006 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Sartori 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: 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 times during the day. Plot the run results and provide an average run time report and graphed plots. Problem/on-call reports with problem summaries (this can be real telling)... Average backup run time for the week. Plot the following: number of active users for database. HWM concurrent users connected for each day. HWM for concurrent transactions for each day. -Original Message- Sent: Monday, April 29, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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 in advance! Yuval. Sr. DBA - WWF -- 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: (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 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert 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: 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. Karadeniz To: Multiple recipients of list ORACLE-L bunyamink [EMAIL PROTECTED] @havelsan.comcc: .tr Subject: Re: CPU Pegged at 100% Sent by: root 04/29/2002 01:39 PM Please respond to ORACLE-L 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 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: Monday, April 29, 2002 5:53 PM 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 is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Bunyamin K. Karadeniz 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: Thomas Day 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: 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 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 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: Monday, April 29, 2002 5:53 PM 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 is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Bunyamin K. Karadeniz 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: Freeman, Robert 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: 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 . -name *Z -print 1stdout.log 2PIPE Brian P. MacLean Oracle DBA, OCP8i Mohammed.Ahsanuddin@VerizonWi reless.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] cc: Subject: RE: Unix - Writing stderr to a file and stdout 04/26/02 12:04 PM Please respond to ORACLE-L Hi, I think I did not explain my request properly..let me try again. Is it possible to write stderr to stdout and to another file simultaneously..? For Ex: ls -l outfile 21 will get me command output and diagnostics info in the same file which is outfile. However, I am trying to get the diagnostics info into outfile as well as into another file (say errfile). Would that be possible? I was not able to do it with tee either.. Thanks Mohammed Ahsanuddin Oracle DBA Verizon Wireless Work : 845 365 7203 Pager : 800 366 2337 pin : 16040 -Original Message- Sent: Friday, April 26, 2002 1:56 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] But of course find . -print | xargs grep hoser This will generate errors on directories Make the errors disappear: find . -print | xargs grep hoser 2/dev/null Now send the standard output to a file. Make sure the file is outside the directory structure you are searching. find . -print | xargs grep hoser 2/dev/null 1/tmp/hoser.txt Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/26/2002 11:30 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Unix - Writing stderr to a file and stdout Hi, Is it possible to write stderr to stdout and to another file simultaneously..? Thanks in advance. Mohammed Ahsanuddin Oracle DBA -- 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: 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
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) tablespace disks_and index; create table mike01_ix on mike01(x) storage (initial 50m) tablespace disks_and index; I'm speachless, I am without speach. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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 compares - Keeps a LOG of all executions - change management Keith Peterson Date: Fri, 26 Apr 2002 16:53:19 -0800 To: Multiple recipients of list ORACLE-L Reply-to: [EMAIL PROTECTED] DB Organization: Fat City Network Services, San Diego, California Thanks Charlie, this was a good suggestion. I downloaded and tried it out, and it works across Oracle and SQLServer. This is good. Ray From: Charlie Mengler To: Ray Gordon Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB - DBArtisanDate: Fri, 26 Apr 2002 13:14:43 -0700 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 list ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert 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: Jenkins, Michael - EDS 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 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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
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 Message- Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502
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 Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729
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 doesn't want to expend the effort to fix it. However, the application does write statistics to a log, so I load those values into an Oracle table and report the results to the management. They feel it works as an indicator for many other factors. Basically a canary in a coal mine. Because it is an indicator that means something to them and they can relate to, it is worth expending a fair amount of effort. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 12:44 PM To: Multiple recipients of list ORACLE-L 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 times during the day. Plot the run results and provide an average run time report and graphed plots. Problem/on-call reports with problem summaries (this can be real telling)... Average backup run time for the week. Plot the following: number of active users for database. HWM concurrent users connected for each day. HWM for concurrent transactions for each day. -Original Message- Sent: Monday, April 29, 2002 1:23 PM To: Multiple recipients of list ORACLE-L 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 in advance! Yuval. Sr. DBA - WWF -- 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 connection. The servlet uses one connection that remains open during the servlet's entire lifetime and is shared by all users of the servlet. 3. Session connection. Store the connection in an HTTP session object, from which it can be retrieved and used by the other method calls invoked in the same user session. 4. Cached connection. Use a connection pool to minimize the total number of connections that are open at any one time. That is a very fast overview, Don has an entire chapter on this subject. Oracle has pinned its future on the success of Java. I think we DBAs are going to need to understand these issues much better in the future in order to communicate with our Java programmers. Bottom line is that I think that when application servers are involved, the issue becomes more complex than just persistent vs. login/logout. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 12:40 PM To: Multiple recipients of list ORACLE-L 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 running oracle v8.1.6. 2. The listener service on the server is running. 3. Am able to connect using the same string on the server. 4. The SQLNET trace file reveals the following: niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.118.51)(PORT= 1521)))(CONNECT_DATA=(SERVICE_NAME=cde)(CID=(PROGRAM=C:\Oracle\Ora81\bin\SQL PLUS.EXE)(HOST=CMT01)(USER=jkelton))(SERVER=dedicated))) . . . nttbnd2addr: entry nttbnd2addr: port resolved to 1151 nttbnd2addr: using host IP address: 127.0.0.1 nttbnd2addr: exit . . . nttcnp: Validnode Table IN use; err 0x0 nttcnp: creating a socket. nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err: entry ntt2err: soc 204 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: entry nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 nsopen: unable to open transport . . . nioqper: error from nscall nioqper:nr err code: 0 nioqper:ns main err code: 12541 nioqper:ns (2) err code: 12560 nioqper:nt main err code: 511 nioqper:nt (2) err code: 61 nioqper:nt OS err code: 0 niomapnserror: entry niqme: entry niqme: reporting NS-12541 error as ORA-12541 niqme: exit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kelton, John 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 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 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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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:
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. -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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services
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 way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 tnsnames file. lanier/lanier@cde mailto:lanier/lanier@cde ? ^ I don't understand what the underlined portion means lanier/lanier@cde Looks correct bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 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 Jim.Conboy@tTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rw.com cc: Sent by: Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina root@fatcity. com 04/29/2002 02:48 PM Please respond to ORACLE-L 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 Message- Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of all phases of ORACLE FINANCIALS including system
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 resident (which is actually the case in Alaska). Doubtful at best. Does anybody know if SC is a tax-free state like Texas and Tennessee? I can see using a salary calculator to convince your spouse that it is a good idea to move. Otherwise I don't they relect real life. Just my 2 cents. -Original Message- Sent: Monday, April 29, 2002 2:48 PM To: Multiple recipients of list ORACLE-L 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 Message- Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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
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] cc: Subject: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 fetching the contents of RAM to the swapfile. Meghraj Thakkar from Quest has a good paper on running Oracle 9i on Windows NT/2000. A search on Yahoo will probably find it for you. I don't have the URL. The following points are taken from that paper. Decrease the size of SGA so that all of the SGA and the OS will fit in physical RAM. This will decrease the use of the swapfile. Choose Maximum throughput for network applications in the control panel. Oracle does it's own memory management. Trying to let Windows memory manage on top of that adds to swapfile use. From the Services panel, disable all unneeded services. This includes License logging service, plug and play, remote access autodial manager, remote access connection manager, remote access server, and telephony service. You should not touch alerter, browser, eventlog, messenger, Oracle Service, Oracle TNSListener, Server, spooler and workstation. If you have 9i, set PRE_PAGE_SGA = TRUE. This tells Windows to keep the SGA in physical memory (RAM) as much as possible. It will get paged out --- that's the nature of Windows --- but not as often. Windows does IO buffering. However, Oracle does its own IO buffering apart from the OS. Performance can be increased and more of the RAM made available to the SGA by using REGEDIT and editing the registry. Go to \HKEY_LOCAL_MACHINE\Control\SessionManager\MemoryManagement and setting LargeSystemCache to 0. Be sure to back up the Registry before editing. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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).
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 profit margin on groceries is about 2% I suspect we all pay about the same amount unless you shop in a Kwikie Mart. The only bright spot is gasoline costs $1.109 at Kroger! Money is as money does. -Original Message- Sent: Monday, April 29, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 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. -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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
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. If you wish to get a job in Western Europe, then you would need to review the market there. Look at job advertisements and see whether they mention certification. Your best certification is the on-the-job experience you are currently receiving. You might also take these exams and let them show you what areas in Oracle you need to learn more. This topic was discussed on this group recently, so you may be able to get some ideas from the archives. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 1:59 PM To: Multiple recipients of list ORACLE-L 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 exams is cheaper price .. 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 rural area they were from. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, April 29, 2002 3:19 PM To: Multiple recipients of list ORACLE-L 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 list ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert 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: Jenkins, Michael - EDS 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:
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 command(On Solaris) is used to find latest biggest files on particular disk partition? Thx -seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: 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 understand. select TO_CHAR(Created, 'MM') MonthCreated, Count(TO_CHAR(Created, 'MM')) TablesCreated from dba_objects where object_type = 'TABLE' group by TO_CHAR(Created, 'MM') order by 1; select TO_CHAR(LAST_DDL_TIME, 'MM') MonthModified, Count(TO_CHAR(LAST_DDL_TIME, 'MM')) Tables DDL'ed from dba_objects where object_type = 'TABLE' group by TO_CHAR(LAST_DDL_TIME, 'MM') order by 1; Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Yuval Arnon [SMTP:[EMAIL PROTECTED]] 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 in advance! Yuval. Sr. DBA - WWF
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, 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 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: Monday, April 29, 2002 5:53 PM 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 is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Bunyamin K. Karadeniz 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: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. Experience upgrading to ORACLE 11i is desirable. What happened to the need for a DBA instead of an IT shop in one person? Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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 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 NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF
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 Wyoming. In addition, New Hampshire and Tennessee limit state income tax to dividends and interest income only. In these two states, the bulk of most people's income -- i.e., salary or wages -- goes untaxed. ---Chris -Original Message- From: Jenkins, Michael - EDS [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:28 PM To: Multiple recipients of list ORACLE-L Subject: 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 resident (which is actually the case in Alaska). Doubtful at best. Does anybody know if SC is a tax-free state like Texas and Tennessee? I can see using a salary calculator to convince your spouse that it is a good idea to move. Otherwise I don't they relect real life. Just my 2 cents. -Original Message- Sent: Monday, April 29, 2002 2:48 PM To: Multiple recipients of list ORACLE-L 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 Message- Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Geographic region affects pay scale just as much as years of experience, I think. Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of 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. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone
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 calculators needs their head examined. But they can in fact provide useful information. $75K in Spartanburg doesn't look to be below-market. Jim -Original Message- Sent: Monday, April 29, 2002 3:28 PM To: Multiple recipients of list ORACLE-L 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 resident (which is actually the case in Alaska). Doubtful at best. Does anybody know if SC is a tax-free state like Texas and Tennessee? I can see using a salary calculator to convince your spouse that it is a good idea to move. Otherwise I don't they relect real life. Just my 2 cents. -Original Message- Sent: Monday, April 29, 2002 2:48 PM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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).
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 tested it. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WHich Unix 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) 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 way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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).
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: http://www.orafaq.com -- Author: Smith, Ron L. 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).
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 ideas as I have tried all I know but still get the same error. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Subject: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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 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 raise. Bull. Dade and Broward county are so built up that the cost of housing is skyrocketing, even with yards the size of a half postage stamp. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Jenkins, Michael - EDS [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: 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 profit margin on groceries is about 2% I suspect we all pay about the same amount unless you shop in a Kwikie Mart. The only bright spot is gasoline costs $1.109 at Kroger! Money is as money does. -Original Message- Sent: Monday, April 29, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 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. -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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of all phases of ORACLE FINANCIALS including system administration, RDBMS tuning, application tuning, DBA/Unix back-up administration, user training, report development utilizing
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 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: 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. 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 . -name *Z -print 1stdout.log 2PIPE Brian P. MacLean Oracle DBA, OCP8i Mohammed.Ahsanuddin@VerizonWi reless.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] cc: Subject: RE: Unix - Writing stderr to a file and stdout 04/26/02 12:04 PM Please respond to ORACLE-L Hi, I think I did not explain my request properly..let me try again. Is it possible to write stderr to stdout and to another file simultaneously..? For Ex: ls -l outfile 21 will get me command output and diagnostics info in the same file which is outfile. However, I am trying to get the diagnostics info into outfile as well as into another file (say errfile). Would that be possible? I was not able to do it with tee either.. Thanks Mohammed Ahsanuddin Oracle DBA Verizon Wireless Work : 845 365 7203 Pager : 800 366 2337 pin : 16040 -Original Message- Sent: Friday, April 26, 2002 1:56 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] But of course find . -print | xargs grep hoser This will generate errors on directories Make the errors disappear: find . -print | xargs grep hoser 2/dev/null Now send the standard output to a file. Make sure the file is outside the directory structure you are searching. find . -print | xargs grep hoser 2/dev/null 1/tmp/hoser.txt Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/26/2002 11:30 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Unix - Writing stderr to a file and stdout Hi, Is it possible to write stderr to stdout and to another file simultaneously..? Thanks in advance. Mohammed Ahsanuddin Oracle DBA -- 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: 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: 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: 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 over and use them. I think you are blocked on this idea unless someone that has actually done this can explain how they accomplished it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 3:36 PM To: Multiple recipients of list ORACLE-L 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 tested it. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 raise. Bull. Dade and Broward county are so built up that the cost of housing is skyrocketing, even with yards the size of a half postage stamp. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Jenkins, Michael - EDS [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: 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 profit margin on groceries is about 2% I suspect we all pay about the same amount unless you shop in a Kwikie Mart. The only bright spot is gasoline costs $1.109 at Kroger! Money is as money does. -Original Message- Sent: Monday, April 29, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 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. -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 Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L 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 to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L 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 your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please.
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 findn find files created/accessed in the last day findo find open files function findc { find . -name *${1}* -print 2/dev/null | more } function findl { OPT_d=. OPT_s=1 OPT_n=38,12 while getopts d:ns:h option do case ${option} in d) OPT_d=${OPTARG} ;; n) OPT_n=63,60 ;; s) OPT_s=${OPTARG} ;; h | \?) echo usage: findl [-h] [-d starting directory] -n [-s size_meg] echo-d defaults to the current directory echo-n default sort is by size, if -n is specified then the sort is by path and name echo-s list files greater than or equal to 'n' meg, defaults to 1 return;; esac done DMY=$(echo ${OPT_s} | tr [0-9] [\0*10]) if [ ${#DMY} -ne 0 ] then echo Invalid value for option -s; return fi [ ${OPT_s} = ] v_size=1048576 || v_size=$((${OPT_s} * 1048576)) find ${OPT_d} -size +${v_size}c -type file 2/dev/null | \ xargs -n 20 ls -Fla {} 2/dev/null | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) }' 21 | \ sort -k .${OPT_n} } function findn { find . -name *${1}* -ctime -1 -type f -print | sort | while read F do echo $(ls -Fla ${F}) $(fuser ${F} 2/dev/null | cut -c1-60) done | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s %s %s %s %s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) }' 21 | sort -k .38,12 } function findo { find . -name *${1}* -ctime -1 -type f -print | sort | while read F do v_CNT=$(fuser ${F} 2/dev/null | wc -w) if [ ${v_CNT} -ne 0 ] then echo $(ls -Fla ${F}) $(fuser ${F} 2/dev/null | cut -c1-60) fi done | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s %s %s %s %s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) }' 21 | sort -k .38,12 } Brian P. MacLean Oracle DBA, OCP8i Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.com cc: Sent by: Subject: WHich Unix command [EMAIL PROTECTED] om 04/29/02 12:08 PM Please respond to ORACLE-L 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 way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to:
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 Subject: 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 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).
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. Rebman Oracle Database Administrator R.R. Donnelley Sons Lancaster, PA Smith, Ron L. [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Compare Schemas 04/29/2002 04:23 PM Please respond to ORACLE-L 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: http://www.orafaq.com -- Author: Smith, Ron L. 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).
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 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 over and use them. I think you are blocked on this idea unless someone that has actually done this can explain how they accomplished it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 3:36 PM To: Multiple recipients of list ORACLE-L 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 tested it. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest 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: 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] 04/29/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: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 Subject: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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).
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 PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Oracle instance, but here's some tips I got when I was new to the NT/2000 world from Novice DBA. I've sent this before, but you should take a look at your registry settings, they're probably the key to your problem and this document will help you know what to look for: Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C:\program files\oracle Note:- This clears off information about any other Oracle utility installed on that system. Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This clears off information about any other Oracle utility installed on that system and you may not be able to run those programs again. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with a prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke registry editor and not regedit. You will have to use the security menu and give permissions to yourself before deleting these entries. Else it will not work . It is to be noted that there are three control sets and all the three (in reality any 2) need to be cleared off these un-necessary entries. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix 'Oracle'. Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ORA-27101 Shared Memory Realm Does Not Exist om
RE: CPU Pegged at 100%
That's not the one that I was using but it is a very good and useful presentation. Murray, MargaretTo: Multiple recipients of list ORACLE-L mamurray[EMAIL PROTECTED] @husseyseatincc: g.com Subject: RE: CPU Pegged at 100% Sent by: root 04/29/2002 04:43 PM Please respond to ORACLE-L 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 Subject: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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: Thomas Day 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: 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! Alan Koivu, Lisa lisa.koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: PATCH? [EMAIL PROTECTED] 04/29/02 02:53 PM Please respond to 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 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).
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 something on the Oriole site (written by Simon Maxen), http://www.oriole.com/scripts/dbupgrade.tar.Z for Unix and http://www.oriole.com/scripts/dbupgrade.zip for Windows and assimilated. It gets the difference and, if I remember well, also generates the script to bring both schemas in line. -- Regards, Stephane Faroult Oriole Software -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).