RE: cdump, bdump, udump
Hi All, Thank you Rachel, David, Christopher and all DBAs and SAs May I know where to find documents that explain all those stuff with some information how managed them I tried ora816 document, but no much info there. It only tells the description, I also read my initSID.ora. Thank you for your time Sinardy -Original Message- Carmichael Sent: Tuesday, 24 April 2001 9:21 PM To: Multiple recipients of list ORACLE-L Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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: sort_area_size + temp tablespace extent sizing
Hi Ade and list, This is folk lore. Please see http://www.ixora.com.au/q+a/0103/27075321.htm for the explanation. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 25 April 2001 1:01 To: Multiple recipients of list ORACLE-L Hi List, Quick question regarding temp tablespace extent sizing. I have always assumed that the extent size for a temporary tablespace needs to be equal to the size that sort_area_size is set to. A sort that can't fit into memory then goes and grabs temp tablespace extents of a size equal to sort_area_size. However, I have read somewhere that the extent size should be equal to sort_area_size + block size (the block being used for header infomation or something like that) eg. 8k block size and 64k sort area size results in 72K temp tablespace extent size. So, assume I have a sort area size of 128K and block size of 8k, do I need to set temp tablespace extent sizes to 128K or 136K, or doesn't it really matter. Thanks, Ade -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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 Adams 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: Perl DBA Tools
John, Im my script for managing the listener.log, I copy the listener to an archive area and then cat /dev/null to to current one. Will this have the same effect as moving as in your example ? Do I need also to force the listener to point to a different log file ? Maybe I need to test some more !! Regards Lee Robertson -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: 24 April 2001 19:47To: Multiple recipients of list ORACLE-LSubject: Re: Perl DBA Tools How about wrapping this is a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John [EMAIL PROTECTED] 04/24/01 10:20AM On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: truncating listener logs -- or even starting a secondary listener, stopping the one with the log that is too large and removing the log, then restarting the original listenerGood idea. Thanks RachelJared-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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.
Re: Listener.log
Hello, Thank you very much for your responses. What i wanted to do was compressing the listener.log. It works fine as below : cp listener.log listener.log.$(date +%y%d%m) cat /dev/null listener.log compress listener.log.$(date +%y%d%m) Regards, Nguyen Thanh-truc - Original Message - From: John Carlson To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 1:45 AM Subject: RE: Listener.log For those of you who did not see my response in the thread of "Perl DBA Tools" I will repeat it here, it answers this thread as well. Also, there is no need to shutdown the database to bounce the listener. How about wrapping this in a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John
RE: ORA-04030
Title: RE: ORA-04030 Thanks for response!! But I still have a problem. I'm tring to install Advanced Replication Option on database. It fails on creating of package body. It was working on another computer with same configuration (Oracle 8.1.7 and 128 MB) but it have Windows NT on it. Maybe it depends on OS? Now I'm try to use Windows 2000. Shared pool size is about 50 MB. But changing of it size doesn't solve the problem. Anton (junior Oracle DBA).
async I/O with DB writer and LOG writer
Dear list, I recently discussed the effect of using async I/O with DB writer and LOG writer with someone, I was told that async I/O is more beneficial to DB writer than LOG writer, what is your opinion?? Can the difference be quantify?? I thought aysnc I/O with DB writer can be compensated by multiple DB writers, is there any comparison between the two?? KC
Re[2]: Oracle vs DB2
Tim, Thanks for the copy of the marketing speil, I had not heard that one before. But, I'll take great exception to the claim that: It would make sense to select a database product based on price alone if database products were the predominant part of the overall information technology expenditures But this is simply not the case. Software costs (including upgrades and technical support) typically represent less than 15% of an IT budget and are small compared to the overall costs of hardware, operations and maintenance, consulting and training. I don't know about the remainder of you, but the cost of Oracle's software is quickly eclipsing the cost of everything else. Hence the beginnings of this post, which I agree with. In our company our yearly Oracle Support Agreement renewal is the #3 cost item and the cost of a new Oracle license exceeds the cost of the server it's going on. Someone PLEASE give these guys a reality check or else a good swift kick in the pants!! Dick Goulet -- 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 vs DB2
We run our web servers on Oracle Standard Edition. 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] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 6:00 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle vs DB2 I just bought 3 STANDARD UPC server licenses for our site. We saved 275K by not using Enterprise. Email me if you want the details. Walt is right, they are lying to you. (The concept of trusting salespersons for technical issues is inherently wrong.) HTH, Todd Carlson Oracle 8i Certified DBA Bunge Corporation Weaver, WaltTo: Multiple recipients of list ORACLE-L wweaver@righ[EMAIL PROTECTED] tnow.comcc: Sent by: Subject: RE: Oracle vs DB2 root@fatcity. com 04/24/2001 03:16 PM Please respond to ORACLE-L That's absolutely not true, Dennis. We've purchased Oracle Standard Edition for serving web pages, and no one at Oracle told us we could not. I think you need to find some other salescritters. You're being taken for a ride. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Tuesday, April 24, 2001 1:46 PM To: Multiple recipients of list ORACLE-L At 01:13 PM 4/24/01 -0400, you wrote: But, I believe your comparing apples to oranges. DB2 UDB Workgroup is not the equal of Oracle Enterprise. If you want to compare apples apples, try Yes, but in order to put an Oracle database on the web, I HAVE TO USE ENTERPRISE EDITION! The salescritters say so. It has to be unlimited users. To repeat: I cannot (legally) put an Oracle database on an internet-accessible web page unless it is an unlimited-user (power-units-based) Enterprise edition version of Oracle. Let me put it another way: I HAVE TO USE ENTERPRISE EDITION! Now, it may be that every salescritter I've talked to is wrong about that, but if so, what can I do? Reach through the phone, grab them by the throat, and demand answers? (Not to say I don't *want* to) I'm not actually comparing apples to oranges if you look at it from my POV: I'm comparing the lowest cost to do what I want using Oracle, to the lowest cost to do what I want using DB2. If Oracle demands that I use Enterprise Edition with unlimited users, then that's their price. Dennis Taylor Beware of false economies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: Weaver, Walt 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: set dml_lock value without bouncing db?
dml_locks is not modifiable with and alter system or alter session command. You can check parameter for these attributes from v$parameter. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:35 AM What was your exact error? Guang Mei wrote: Is this possible? Our 8.0.5 Oracle db (on Sun box) is 7x24. I got error saying Maximum number of DML exceeded. I tried alter system set dml_lock = 300 but it did not work. TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei 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: David A. Barbour 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: Physical Data Layout
Hi, I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's. Offcourse reading is slower but writing is faster. From your given information, I can see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk. same ways index and data should not be clubbed together. I have seen RAID 1 and 0 gives better performance than RAID 5 and also improved performance if we distribute I/O with different RAID controllers. HTH -- On Tue, 24 Apr 2001 23:45:20 Saumya99 wrote: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Saumya99 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Physical Data Layout
Hi, I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's. Offcourse reading is slower but writing is faster. From your given information, I can see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk. same ways index and data should not be clubbed together. I have seen RAID 1 and 0 gives better performance than RAID 5 and also improved performance if we distribute I/O with different RAID controllers. HTH -- On Tue, 24 Apr 2001 23:45:20 Saumya99 wrote: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Saumya99 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b
The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their database software at a reduced cost with the same restriction. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] Original Message- Sent: Tuesday, April 24, 2001 11:05 PM To: Multiple recipients of list ORACLE-L b I'm really sorry, but with these restrictions, they should be able to install it in a business week or less. what losers! -- 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: This maybe interesting
I'll actually be a customer of the system, but unfortunately don't know a whole lot about it's implementation or tuning or anything like that. The system I maintain will have an interface to this new system so that we can keep our system updated with real-time information from their system through a view, but that's going to be about as close as I get to seeing how they have it setup. You're right though, it should be very interesting to see how it works performance-wise. I can only hope it works better than some of the other Air Force wide systems that have been used recently. I was involved with an Air Force wide quality-of-life survey they did a little over a year ago that was available for use to ALL AF personnel, both military and civilian, worldwide. That's a fairly good number of users to be hitting an app at the same time at peak times. The performance of that system was unbelievably pathetic. It was comparable to MetaLink's performance in recent months of that gives you any idea ;-). So yes, it should be very interesting to see how things turn out. I for one plan on going down to the Personnel Office and making sure I get hard copies of all of my records prior to the launch date of this new system. I'd hate to lose anything in the transition and not have it when I need it for my separation in seven months. =) -Original Message- Sent: Wednesday, 25 April, 2001 12:56 PM To: Multiple recipients of list ORACLE-L TO ALL, I got the following in my daily copy of the Air Force News. It may be of interest to the group as a whole, since this if Oracle's HR application that's getting deployed, around the world. I hope at lease one person on the list is associated with this deployment as the tuning implications would be of great interest to us all, I'd think. 0553. New personnel data system coming soon RANDOLPH AIR FORCE BASE, Texas (AFPN) -- The Air Force will begin using a new personnel data system, MilMod, May 1. After more than five years of production, 20 years since the last major system update and nearly $60 million on production costs, Air Force officials have given the green light to turn on the new system. The switch to MilMod, which stands for military modernization, replaces the 1970s technology, which will continue as the system of record until June 1. We are extending the turn-off date to allow a longer and more graceful transition to the new system, said Lt. Gen. Donald L. Peterson, Air Force deputy chief of staff for personnel. The new system will support all life cycle personnel management functions from recruiting through job assignment and ultimately separation or retirement, said Lt. Col. Ed Oliver, MilMod program manager at the Air Force Personnel Center here. It will provide real-time updating and reporting capabilities that are not available in today's personnel data system. All personnel records, including Guard, Reserve and active duty, will be at AFPC and serviced from the field. It will allow more than 15,000 users real-time access to the Air Force's personnel database of 1.7 million records and eliminate duplicate data entry, that under the current system could cause major delays in the completion of a single personnel action. Today's automation technology is being leveraged to improve support at all levels and is the foundation for building a robust integrated personnel system for the total force, Oliver said. We've also standardized the support we're providing to the total force. This will improve system support to the Air National Guard and Air Force Reserve personnel processes. In the future, the MilMod system may even enhance the enlisted testing program. We believe as MilMod goes on line, it will become much easier for us to make needed improvements, said Chief Master Sgt. Greg Haley, chief of AFPC's enlisted promotion and testing branch. For now, we will continue to look at shortening the wait time between when someone tests for promotion and when they get the results. MilMod will give us instant access to the very latest promotion eligibility status entered into the system by our base-level technicians. We remain optimistic that MilMod is going to do a lot of good over the long haul for the Air Force's enlisted promotion system. For more information, visit the MilMod home page at http://www.afpc.randolph.af.mil/modern. (Courtesy Of AFPC News Service) -- 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
Temorary tablespace problem
Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.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).
RE: sort_area_size + temp tablespace extent sizing
Hi Luc, It depends on the size of your sorts. You can check the extents column in v$sort_usage, if it's always bigger than 1, it means the extent size is too small. --- DEMANCHE Luc (Cetelem) [EMAIL PROTECTED] a écrit : Stephane, What situation would make you choose a certain value (i.e.: using '3' versus '4.5')? -Message d'origine- De: paquette stephane [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Date: Tuesday, April 24, 2001 6:03 PM À: Multiple recipients of list ORACLE-L Objet: Re: sort_area_size + temp tablespace extent sizing The extent size of the temp tablespace should be a multiple of the sort_area_size parameter + 1 block. If your sort_area_size is 128K and if you need to go to temp tablespace that means that 128K is not enough so you should allocate for more than 128K. temp extent = (sort_area_size*n)+ 1 block where n goes from 2 to usually 4,5 depending on your situation --- Adrian Roe [EMAIL PROTECTED] a écrit : Hi List, Quick question regarding temp tablespace extent sizing. I have always assumed that the extent size for a temporary tablespace needs to be equal to the size that sort_area_size is set to. A sort that can't fit into memory then goes and grabs temp tablespace extents of a size equal to sort_area_size. However, I have read somewhere that the extent size should be equal to sort_area_size + block size (the block being used for header infomation or something like that) eg. 8k block size and 64k sort area size results in 72K temp tablespace extent size. So, assume I have a sort area size of 128K and block size of 8k, do I need to set temp tablespace extent sizes to 128K or 136K, or doesn't it really matter. Thanks, Ade -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Adrian Roe 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access
This maybe interesting
TO ALL, I got the following in my daily copy of the Air Force News. It may be of interest to the group as a whole, since this if Oracle's HR application that's getting deployed, around the world. I hope at lease one person on the list is associated with this deployment as the tuning implications would be of great interest to us all, I'd think. 0553. New personnel data system coming soon RANDOLPH AIR FORCE BASE, Texas (AFPN) -- The Air Force will begin using a new personnel data system, MilMod, May 1. After more than five years of production, 20 years since the last major system update and nearly $60 million on production costs, Air Force officials have given the green light to turn on the new system. The switch to MilMod, which stands for military modernization, replaces the 1970s technology, which will continue as the system of record until June 1. We are extending the turn-off date to allow a longer and more graceful transition to the new system, said Lt. Gen. Donald L. Peterson, Air Force deputy chief of staff for personnel. The new system will support all life cycle personnel management functions from recruiting through job assignment and ultimately separation or retirement, said Lt. Col. Ed Oliver, MilMod program manager at the Air Force Personnel Center here. It will provide real-time updating and reporting capabilities that are not available in today's personnel data system. All personnel records, including Guard, Reserve and active duty, will be at AFPC and serviced from the field. It will allow more than 15,000 users real-time access to the Air Force's personnel database of 1.7 million records and eliminate duplicate data entry, that under the current system could cause major delays in the completion of a single personnel action. Today's automation technology is being leveraged to improve support at all levels and is the foundation for building a robust integrated personnel system for the total force, Oliver said. We've also standardized the support we're providing to the total force. This will improve system support to the Air National Guard and Air Force Reserve personnel processes. In the future, the MilMod system may even enhance the enlisted testing program. We believe as MilMod goes on line, it will become much easier for us to make needed improvements, said Chief Master Sgt. Greg Haley, chief of AFPC's enlisted promotion and testing branch. For now, we will continue to look at shortening the wait time between when someone tests for promotion and when they get the results. MilMod will give us instant access to the very latest promotion eligibility status entered into the system by our base-level technicians. We remain optimistic that MilMod is going to do a lot of good over the long haul for the Air Force's enlisted promotion system. For more information, visit the MilMod home page at http://www.afpc.randolph.af.mil/modern. (Courtesy Of AFPC News Service) -- 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: cdump, bdump, udump
Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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: REP: Locally Managed Tablespaces
Thanks Mark. -Original Message- Sent: Wednesday, April 25, 2001 12:56 PM To: Multiple recipients of list ORACLE-L I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the tablespace will adere to those extent sizes no matter what you specifiy in the INITIAL storage parameter. I have a LMT already created with a UNIFORM extent size of 128k: SQL select tablespace_name, 2 initial_extent, 3 next_extent, 4 extent_management 5 from DBA_TABLESPACES 6 where tablespace_name = 'LOCAL'; TABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT EXTENT_MAN -- -- --- -- LOCAL 131072 131072 LOCAL I created a table in LOCAL as follows: SQL select table_name, 2 tablespace_name, 3 initial_extent, 4 next_extent 5 from DBA_TABLES 6 where table_name = 'EXTENT_TEST'; TABLE_NAMETABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT - -- -- --- EXTENT_TEST LOCAL 1048576131072 You notice that DBA_TABLES *DOES* report that this table does in fact show extent sizes of 1MB. Now, I have a tool that can show a tablespace map of both dictionary and locally managed tablespaces, this reported that the table EXTENT_TEST has a total of 8 extents each at a size of 128K - indicating that Oracle seems to take the initial extent size given by the create table statement, and makes up that initial extent with a number of the uniform extents. I also took Jared's statement, and if I am correct this will give you a row for each extent allocated (correct me if I'm wrong Jared), so based on this I did the following; 1 select count(*) from (select /*+ ordered use_nl(e) use_nl(f) */ 2 ds.owner, ds.segment_name, ds.partition_name, 3 ds.segment_type, ds.tablespace_name, 4 e.ktfbueextno, f.file#, e.ktfbuebno, 5 e.ktfbueblks * ds.blocksize, 6 e.ktfbueblks, e.ktfbuefno 7 from sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f 8 where e.ktfbuesegfno = ds.relative_fno 9 and e.ktfbuesegbno = ds.header_block 10 and e.ktfbuesegtsn = ds.tablespace_id 11 and e.ktfbuesegtsn = f.ts# 12 and e.ktfbuefno = f.relfile# 13 and bitand(NVL(ds.segment_flags, 0), 1) = 1 14 and ds.segment_name = 'EXTENT_TEST' 15* ) SQL / COUNT(*) -- 8 The tool that I use does not show any other extent sizes other than than 128K. This pretty much seems to that LMT's with UNIFORM extent sizes actually DO stick that uniform size. Sorry for the long reply.. I had a bit of spare time :) HTH Mark -Original Message- Sent: Tuesday, April 24, 2001 10:46 To: Multiple recipients of list ORACLE-L I haven't tried it, but I recall hearing that all extents really are 1M, it is just the data dictionary displays that are confusing. If you create a table with initial=next=1.5M, I believe dba_tables will show the create parameters, while dba_extents will show the actual extent sizes. I don't have a good test database right now to try this. Maybe I have the dictionary tables wrong (I guess I could check their sources). Henry -Original Message- Sent: Tuesday, April 24, 2001 4:47 PM To: Multiple recipients of list ORACLE-L I am doing some research on locally managed tablespaces prior to using them. Looking for problems, etc. This is the first negative response I have heard about them. Perhaps, storage parameters were specified on the create table? Patricia -Original Message- Sent: Tuesday, April 24, 2001 12:52 PM To: Multiple recipients of list ORACLE-L A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later they notice that not all extents are 1M. Thanks, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote: On Monday 23 April 2001 11:40, The Oracle DBA wrote: Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Do you have a source for this information? A number of us have been using LMT's with uniform extents, and have not seen that. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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
RE: ORA-04030
Title: RE: ORA-04030 Hi All ! Thanks for help, I think i solve the problem, but I don't understand why it began work. I increased size if shared poll up to 100MB, butpart of script doesn''t began work in SQL Plus but it starts work in SQL Navigator!!! So I run whole script in svrmgrl and it's didn't show me an error May be some one know why it happend??? Thanks a lot. Anton. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, April 23, 2001 5:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-04030 Hi Anton - The error is exactly what it says it is. The OS is out of memory to allocate to this once process. Are you using PL/SQL tables or anything that could go wild with memory in your PL/SQL scripts? I've had this happen before when I first started messing with PL/SQL tables. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Dorozhkin, Anton [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 8:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-04030 I've got a such error when run a PL/SQL scripts on Windows 2000, Orcale 8.1.7 with 128MB memory ORA-04030: out of process memory when trying to allocate 257280 bytes (PLS non-lib hp,PAR.C:parchk:ptb) I've tried to change settings in init.ora but this didn't help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dorozhkin, Anton 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: Oracle vs DB2
So isn't PostGres, but neither is a close competitor. Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/24/2001 1:28 PM hmmm, mysql is free, best price of all. [EMAIL PROTECTED] 04/24/01 04:27PM At 10:46 AM 4/24/01 -0800, you wrote: Not true. You can use the Standard Edition for serving web pages. We're doing it. Yep. I've corrected myself on that in another email. One thing I don't get: it's $6,000 Cdn for a 1-user license, right? How is a 1-user license going to do you any good if you're serving web pages? Just interested in how the WE Internet Access works. The 1-user license + WE = a legal DB2 web-database. This according to the IBM salescritter. Got it on paper, too. :-) We had some IBM guys in here late last year, and they couldn't give us any better pricing than what we could get Oracle Standard Edition for. Times change. My salescritter is saying that in some cases, IBM is *giving* DB2 away, if there's enough ancilliary business (hardware, consulting, etc). I guess I should add a disclaimer to my rant at this point. We are a small shop. I mean *SMALL* shop. 30 people in the company. 30K for a web database may be peanuts for a fortune 500 company, but for us, it's significant. YMMV. Dennis Taylor Beware of false economies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: Gene Sais 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).
ORA-12500
Hi All, I have seen the error-manual for above Error message, but it really doesn't state anything clearly. Env is Oracle 8.0.5 on NT 4.0. This problem is not persistent and it comes intermittently. And it has come when I try to shutdown a Production through an automated script before backup (of course automated). Due to this, the backup doesn't happen and also Media recovery is required further to open the database. I have checked the env. variables, they look OK to me(most of the times it work). The similar script works fine with Demo Database. Any experience on this issue? Please suggest some solution. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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[2]: Oracle vs DB2
I too would love to see somebody give Oracle a reality check in regards to the prices of their software, but as much as I hate to say it, I just don't see it happening. Why? Because the ONLY reality check that Oracle is going to actually LISTEN to and do something about would be for people to stop using/buying their products. And I just don't see that happening either. In the enterprise data market, Oracle has the best product available (IMHO), and I think most people, and especially including Oracle Corp., know this. Based on that information alone, I just don't see them backing down their prices when, as much as people hate paying, they still will, because it's the best. =( -::YEX::- ))) -Original Message- Sent: Wednesday, 25 April, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Tim, Thanks for the copy of the marketing speil, I had not heard that one before. But, I'll take great exception to the claim that: It would make sense to select a database product based on price alone if database products were the predominant part of the overall information technology expenditures But this is simply not the case. Software costs (including upgrades and technical support) typically represent less than 15% of an IT budget and are small compared to the overall costs of hardware, operations and maintenance, consulting and training. I don't know about the remainder of you, but the cost of Oracle's software is quickly eclipsing the cost of everything else. Hence the beginnings of this post, which I agree with. In our company our yearly Oracle Support Agreement renewal is the #3 cost item and the cost of a new Oracle license exceeds the cost of the server it's going on. Someone PLEASE give these guys a reality check or else a good swift kick in the pants!! Dick Goulet -- 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: Yexley Robert D SSgt AFIT/SCA 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: REP: Locally Managed Tablespaces
And what is x$ktfbue and how it is maintained if there is no info in data dictionary? Alex Hillman -Original Message- Sent: Tuesday, April 24, 2001 9:20 PM To: Multiple recipients of list ORACLE-L On Tuesday 24 April 2001 14:24, Henry Poras wrote: Isn't it also in sys.uet$? Oops, that's for dictionary managed, not locally managed. You're right. But isn't there a way to see locally managed extents? Yes, they show up in dba_extents, but it doesn't come from sys.uet$. Here's the view as of 8.1.7. Extents in LMT's are retrieved by the second SELECT statement in the SQL. select ds.owner, ds.segment_name, ds.partition_name, ds.segment_type, ds.tablespace_name, e.ext#, f.file#, e.block#, e.length * ds.blocksize, e.length, e.file# from sys.uet$ e, sys.sys_dba_segs ds, sys.file$ f where e.segfile# = ds.relative_fno and e.segblock# = ds.header_block and e.ts# = ds.tablespace_id and e.ts# = f.ts# and e.file# = f.relfile# and bitand(NVL(ds.segment_flags,0), 1) = 0 union all -- get the LMT extents select /*+ ordered use_nl(e) use_nl(f) */ ds.owner, ds.segment_name, ds.partition_name, ds.segment_type, ds.tablespace_name, e.ktfbueextno, f.file#, e.ktfbuebno, e.ktfbueblks * ds.blocksize, e.ktfbueblks, e.ktfbuefno from sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f where e.ktfbuesegfno = ds.relative_fno and e.ktfbuesegbno = ds.header_block and e.ktfbuesegtsn = ds.tablespace_id and e.ktfbuesegtsn = f.ts# and e.ktfbuefno = f.relfile# and bitand(NVL(ds.segment_flags, 0), 1) = 1 / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Hillman, Alex 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: Perl DBA Tools
Hi Jared, A few things we use Perl for: - watchfs.pl This thing monitors db related file systems and alerts (via our NOC) if thresholds are exceeded. Thresholds managed in dynamic config file. - process_ora_trace.pl A one off that helped us w/a vendor. Takes trace output files for a database (ie: entire db in trace mode), scans through em', figures out who's executing what (uid) and lists the SQL statements by user. - watchdbms.pl Daemon checking database services - check_dbup.pl Tool used by our Unix gang in outages when they restart nodes and need to verify database services. - baseline_main.pl (and various sub-programs) Performance tool that works on deltas (ie: run it once to capture beginning stats and again for end stats. Similar in concept to utlestat/bstat). Nitty gritty detail down to waits, latches, buffer pools, blah blah. Output is in html w/a table of contents. Very handy. Delta info stored into a repository instance. - dbmonitor.pl Takes capacity stats captured by a ksh script (using dbms_space) and creates html tables showing growth for objects and at tablespace level. ksh is cool and we have tons of structured scripts for all else we need - but Perl is just so much more fun. HTH, Casey ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke 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).
Buffer busy waits -- p3=1012 and 1016
Hi list,I'm analyzing parameter "p3" from trace 10046 level 8 and I've got some doubts about it.What is the difference between p3=1012 and p3=1016?According to some docs I've read, 1012="A modification is happening on a XCUR (or SCUR)buffer and it has not yet completed" (and I think thatthe session suffering the wait needs the block inCURRENT mode, thats because it has to wait)1016="The session wants the block in SCUR or XCURmode"(And I think that the session that wants the block hasto wait because the block has been modified by another session)Aren't these two p3 values the same?The only difference seems to be that in the first casethe block is *currently* being modified by anothersession, while in the second case it has already beenmodified.am I right? Please someone correct me if I'm wrong.TIAPD: Some examples below:SOURCE P1,P2,P3 OWNER SEGMENT_NAME SEGMENT_TYPEp1=2 p2=1887 p3=1012 SYS R10 Rp1=2 p2=1887 p3=1016 SYS R10 Rp1=2 p2=19697 p3=1016 SYS R08 Rp1=42 p2=16853 p3=0 GL GL_JE_LINES_N1 Ip1=42 p2=22492 p3=0 GL GL_JE_LINES_N1 Ip1=43 p2=68119 p3=0 GL GL_JE_LINES TWhat about this P3=0 case ?I think it means that the block wanted by the session. A is being read by another session (say B) from diskto the SGA. So session A has to wait for the read to complete. What can I doto eliminate (or at least improve) this wait?(may be to cache these table blocks in the SGA??)thanks
RE: REP: Locally Managed Tablespaces
Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the tablespace will adere to those extent sizes no matter what you specifiy in the INITIAL storage parameter. I have a LMT already created with a UNIFORM extent size of 128k: SQL select tablespace_name, 2 initial_extent, 3 next_extent, 4 extent_management 5 from DBA_TABLESPACES 6 where tablespace_name = 'LOCAL'; TABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT EXTENT_MAN -- -- --- -- LOCAL 131072 131072 LOCAL I created a table in LOCAL as follows: SQL select table_name, 2 tablespace_name, 3 initial_extent, 4 next_extent 5 from DBA_TABLES 6 where table_name = 'EXTENT_TEST'; TABLE_NAMETABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT - -- -- --- EXTENT_TEST LOCAL 1048576131072 You notice that DBA_TABLES *DOES* report that this table does in fact show extent sizes of 1MB. Now, I have a tool that can show a tablespace map of both dictionary and locally managed tablespaces, this reported that the table EXTENT_TEST has a total of 8 extents each at a size of 128K - indicating that Oracle seems to take the initial extent size given by the create table statement, and makes up that initial extent with a number of the uniform extents. I also took Jared's statement, and if I am correct this will give you a row for each extent allocated (correct me if I'm wrong Jared), so based on this I did the following; 1 select count(*) from (select /*+ ordered use_nl(e) use_nl(f) */ 2 ds.owner, ds.segment_name, ds.partition_name, 3 ds.segment_type, ds.tablespace_name, 4 e.ktfbueextno, f.file#, e.ktfbuebno, 5 e.ktfbueblks * ds.blocksize, 6 e.ktfbueblks, e.ktfbuefno 7 from sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f 8 where e.ktfbuesegfno = ds.relative_fno 9 and e.ktfbuesegbno = ds.header_block 10 and e.ktfbuesegtsn = ds.tablespace_id 11 and e.ktfbuesegtsn = f.ts# 12 and e.ktfbuefno = f.relfile# 13 and bitand(NVL(ds.segment_flags, 0), 1) = 1 14 and ds.segment_name = 'EXTENT_TEST' 15* ) SQL / COUNT(*) -- 8 The tool that I use does not show any other extent sizes other than than 128K. This pretty much seems to that LMT's with UNIFORM extent sizes actually DO stick that uniform size. Sorry for the long reply.. I had a bit of spare time :) HTH Mark -Original Message- Sent: Tuesday, April 24, 2001 10:46 To: Multiple recipients of list ORACLE-L I haven't tried it, but I recall hearing that all extents really are 1M, it is just the data dictionary displays that are confusing. If you create a table with initial=next=1.5M, I believe dba_tables will show the create parameters, while dba_extents will show the actual extent sizes. I don't have a good test database right now to try this. Maybe I have the dictionary tables wrong (I guess I could check their sources). Henry -Original Message- Sent: Tuesday, April 24, 2001 4:47 PM To: Multiple recipients of list ORACLE-L I am doing some research on locally managed tablespaces prior to using them. Looking for problems, etc. This is the first negative response I have heard about them. Perhaps, storage parameters were specified on the create table? Patricia -Original Message- Sent: Tuesday, April 24, 2001 12:52 PM To: Multiple recipients of list ORACLE-L A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later they notice that not all extents are 1M. Thanks, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote: On Monday 23 April 2001 11:40, The Oracle DBA wrote: Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Do you have a source for this information? A number of us have been using LMT's with uniform extents, and have not seen that. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ --
Virtual circuits
I just switched on of my databases to MTS and noticed I have a 75% miss rate when looking at the virtual circuit latches. Anyone dealt with this before and have any suggestions? Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner 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: cdump, bdump, udump
Nope. That's the way the listener.log works, but the alert log will be recreated if deleted or moved. -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
running oidadmin
Title: running oidadmin I'm having problems getting the OID admin (v2.0.6) utility to run under hp-ux 11. When I try to start it, it get a java error no nldapj8 in shared library path The libnldapj8.sl file is in $ORACLE_HOME/network/admin and this directory is in the $SHLIB_PATH environmental variable. I have found one possible related bug on metalink, but it is not conclusive. Has anybody got this to work in the past? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.
Re: Temorary tablespace problem
Someone may be doing a large sort. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:30 PM Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.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). -- 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).
Column positionning in the table
Hi, I just want to make sure of something, since with Oracle 8i, some old habits are no longer needed. On Oracle 816 is the position of a column in a table important ? A lot of tables will change and most of the PK also. I will test the drop column a lot ;-) and I'll add some fields who will now be part of the PK, does it matter if some mandatory fields are the last fields of a table ? Even with non-mandatory fields before them ? No flame please, this phase was the last one under the duhveloppers responsability . = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: cdump, bdump, udump
Yep, Oracle just keeps on chugging along. When it needs to write to the alert log it will create a new one if it needs to. On Wed, 25 Apr 2001, Ron Rogers wrote: Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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). -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L
RE: Listener.log
Thank you, John.The best solution. Vadim -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 7:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log For those of you who did not see my response in the thread of "Perl DBA Tools" I will repeat it here, it answers this thread as well. Also, there is no need to shutdown the database to bounce the listener. How about wrapping this in a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John [EMAIL PROTECTED] 04/24/01 02:28PM You can shutdown/start the Database and start listener would solve ur problem.-SeemaFrom: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: RE: Listener.logDate: Tue, 24 Apr 2001 11:16:49 -0800No, you do not have to restart the listener.touch the listener.log file (we do a 'cp /dev/null$ORACLE_HOME/network/log/listener.log)and the listener will start writing to it again.R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.-Original Message-Sent: Tuesday, April 24, 2001 12:28 PMTo: Multiple recipients of list ORACLE-LHello,You have to restart your listener. It continues to write to "invisible" file(inode without any reference from directories). Welcome to UNIX.HTHVadim GorbounovOracle DBA-Original Message-Sent: Tuesday, April 24, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LHello everyone,After moving the listener.log and compressed, there is no more log for thelistener. Could anyone help me please ? Thanks.Nguyen_Get your FREE download of MSN Explorer at http://explorer.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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Anyone using Peoplesoft Financials 7.x on Oracle 8.0.x?
Hi Nuno, I'm new to the wonderful world of PeopleSoft, so I probably can't provide much insight. Why keep the discussion off list? Keeping it on the list helps us other newbies and allows the more experienced PS DBAs (Dick et al) a chance to comment on any replies you get. Just my 2 cents Mike -Original Message- From: Nuno Souto [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:56 PM To: Multiple recipients of list ORACLE-L Subject: Anyone using Peoplesoft Financials 7.x on Oracle 8.0.x? If so, please ping me via e-mail. Use address below. I need to ask a coupla questions re maintenance/versions. OT to this list, so I won't bother the others here with them. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Lanteigne, 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).
memory
Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cdump, bdump, udump
It seems to work different for me. For the last 2 years, I have been deleting the old file and a new one appears with the very next message to be written. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 9:39 AM Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: Oracle vs DB2
You are absolutely correct. Oracle's getting this price because they can. I wonder how much market share they will lose before Larry switches things around? When I asked my salescritter about this he said Well we sure are selling alot of licenses - Go figure... Thanks, Frank -Original Message- Patrice J Sent: Tuesday, April 24, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Well, This is on topic - www.wired.com http://www.wired.com today has an article re. IBM announced that it is buying Informix for $1Billion. Ah, if only I had that kind of money myself - I could take more Oracle courses! I don't know what will happen with Informix then, does that mean they will gobble it up and DB2 will be the only option in a couple of years? 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] mailto:[EMAIL PROTECTED] -Original Message- From: Dennis Taylor [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Subject:Oracle vs DB2 Disclaimer: I am *not* trying to start a religious war, and I am *not* trying to advocate DB2. I am simply offended. Thus this post. As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer to determine our future direction. Here's a datum that makes a significant difference to us, dollar-wise. With Oracle, in order to make a database accessible to the internet through a web page, you have to buy an unlimited-user enterprise license. We had a senior sales person in our office yesterday, and we asked this question a number of different ways. He bobbed and he weaved, but he did not deny it. And the quote he supplied afterwards does not address the issue at all. Cost of unlimited-user Enterprise version for our installation (your mileage may vary) = Approx $160,000 Cdn. IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1 user), and something called WE Internet Access, for a total price of $6000 Cdn. I have a written quote from an IBM salescritter to this effect. $6000. $160,000. $6000. $160,000. Hm. Let me think. I respectfully submit that Oracle's pricing structure is out of line with market realities, and may have to undergo significant revision. Dennis Taylor Don't be fooled by old cliches - He who laughs last may have just figured out the joke. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank N. Pettinato 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: DBA_FREE_SPACE - Problem gone
Well, this makes me really uncomfortable but the problem went away by itself. Dba_free_space is now showing the correct free space. -Original Message- Sent: Monday, April 23, 2001 5:19 PM To: Multiple recipients of list ORACLE-L One of the other DBAs here called me over to look at a weird situation. We resized some datafiles, the size of the datafiles increased on the OS and in dba_data_files but there are no entries for that tablespace in dba_free_space. Currently: DBA_DATA_FILES - 11451M total size of datafiles (this agrees with OS) DBA_SEGMENTS DBA_EXTENTS - 10752M total size of extents/segments DBA_FREE_SPACE - no entries Oracle 8.1.5.1.0 Solaris 2.6 Any idea what might cause this? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Miller, Jay 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: cdump, bdump, udump
I tend to agree with you. I feel MUCH more comfortable reading paper. Terry [EMAIL PROTECTED] wrote: Wow. I feel just the opposite. When I had the paper docs, I could take one on the train, take it home, know what I read, feel like I'd accomplished something when I'd read a chunk, etc. I had a relationship with the books, my tuning guide had a corner bent, the app dev guide was missing a cover. With this electronic stuff, I can't 'sit down and study', I find its hard to get a feel of what I should read because it all looks and feels the same. I really miss the hard copy docs. My two pence. Yosi -Original Message- From: Joseph S. Testa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: Terry Ball 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: spool command: echo not work
Thanks all for replay. I knew echo should work, but for some reason it does not. SQL set echo off SQL set hea off SQL spool test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off SQL !more test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off Any ideas? Thanks. Greg. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Hazelton Sent: Tuesday, April 24, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: spool command SET ECHO OFF Original Message Follows Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 24 Apr 2001 12:12:16 -0800 This is a multi-part message in MIME format. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Hazelton 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: Gregory Faktor 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: Physical Data Layout
Hi, I'm also looking for RAID / SAN / NAS technology used with databases. Do you know any recommended readings ? Saumya99 schrieb: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Saumya99 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 Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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).
MTS
Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it good idea to configure MTS in such conditions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
monitoring listener.log
Title: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
RE: Oracle vs DB2
Greetings Friends in California! If you felt the earth shake, don't worry. It's not an earth quake, it just Larry Ellison's reaction to the IBM-Informix deal. The man needs to spend a lot less time picking fights with Bill and a lot more time paying attention to his market, and from being end-runned. MS has money, but IBM prints the stuff. Cheers! -Original Message- Sent: Tuesday, April 24, 2001 8:50 PM To: Multiple recipients of list ORACLE-L trying again... From: Eric D. Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Tue, 24 Apr 2001 14:56:08 -0700 Subject: RE: Oracle vs DB2 Reportedly what IBM did here some years ago, was sell a mainframe hardware package (for a COBOL/VSAM package) within the University system's budget constraints. Turned out that to actually run the application, several millions of $ of additional goodies were needed. But, they got the original bid. Dealing with IBM mainframe sales critters (apparently recruited directly from some boot camp for counter terrorism?) was not exactly the same as dealing with DEC sales critters. On 24 Apr 2001, at 13:00, [EMAIL PROTECTED] wrote: It's that ancillary business you better watch out for!! IBM is using DB2 as their Loss-Leader. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Sharpe, 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).
Multimaster Replication setup
Hi I am trying to setup multimaster replication environment. I have two machines. On on windows NT and one on linux. I followed all the steps listed in oracle8i Api reference manuals till chapter 3. But when I update emp table. It corresponding updations are not reflected in second database. Can anyone please help me in setting up of replication server. Also can anyone tell me sites giving Complete steps for setting up replication server. I am here not going for snapshot site I am just trying for multimaster replication Regards Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal 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).
FW: REP: Locally Managed Tablespaces
I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the tablespace will adere to those extent sizes no matter what you specifiy in the INITIAL storage parameter. I have a LMT already created with a UNIFORM extent size of 128k: SQL select tablespace_name, 2 initial_extent, 3 next_extent, 4 extent_management 5 from DBA_TABLESPACES 6 where tablespace_name = 'LOCAL'; TABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT EXTENT_MAN -- -- --- -- LOCAL 131072 131072 LOCAL I created a table in LOCAL as follows: SQL select table_name, 2 tablespace_name, 3 initial_extent, 4 next_extent 5 from DBA_TABLES 6 where table_name = 'EXTENT_TEST'; TABLE_NAMETABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT - -- -- --- EXTENT_TEST LOCAL 1048576131072 You notice that DBA_TABLES *DOES* report that this table does in fact show extent sizes of 1MB. Now, I have a tool that can show a tablespace map of both dictionary and locally managed tablespaces, this reported that the table EXTENT_TEST has a total of 8 extents each at a size of 128K - indicating that Oracle seems to take the initial extent size given by the create table statement, and makes up that initial extent with a number of the uniform extents. I also took Jared's statement, and if I am correct this will give you a row for each extent allocated (correct me if I'm wrong Jared), so based on this I did the following; 1 select count(*) from (select /*+ ordered use_nl(e) use_nl(f) */ 2 ds.owner, ds.segment_name, ds.partition_name, 3 ds.segment_type, ds.tablespace_name, 4 e.ktfbueextno, f.file#, e.ktfbuebno, 5 e.ktfbueblks * ds.blocksize, 6 e.ktfbueblks, e.ktfbuefno 7 from sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f 8 where e.ktfbuesegfno = ds.relative_fno 9 and e.ktfbuesegbno = ds.header_block 10 and e.ktfbuesegtsn = ds.tablespace_id 11 and e.ktfbuesegtsn = f.ts# 12 and e.ktfbuefno = f.relfile# 13 and bitand(NVL(ds.segment_flags, 0), 1) = 1 14 and ds.segment_name = 'EXTENT_TEST' 15* ) SQL / COUNT(*) -- 8 The tool that I use does not show any other extent sizes other than than 128K. This pretty much seems to that LMT's with UNIFORM extent sizes actually DO stick that uniform size. Sorry for the long reply.. I had a bit of spare time :) HTH Mark -Original Message- Sent: Tuesday, April 24, 2001 10:46 To: Multiple recipients of list ORACLE-L I haven't tried it, but I recall hearing that all extents really are 1M, it is just the data dictionary displays that are confusing. If you create a table with initial=next=1.5M, I believe dba_tables will show the create parameters, while dba_extents will show the actual extent sizes. I don't have a good test database right now to try this. Maybe I have the dictionary tables wrong (I guess I could check their sources). Henry -Original Message- Sent: Tuesday, April 24, 2001 4:47 PM To: Multiple recipients of list ORACLE-L I am doing some research on locally managed tablespaces prior to using them. Looking for problems, etc. This is the first negative response I have heard about them. Perhaps, storage parameters were specified on the create table? Patricia -Original Message- Sent: Tuesday, April 24, 2001 12:52 PM To: Multiple recipients of list ORACLE-L A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later they notice that not all extents are 1M. Thanks, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote: On Monday 23 April 2001 11:40, The Oracle DBA wrote: Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Do you have a source for this information? A number of us have been using LMT's with uniform extents, and have not seen that. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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
Re: Listener.log
reboot listener with LSNRCTL |+ || Ruth Gramolini | || [EMAIL PROTECTED]| || ate.vt.us| ||| || 04/24/01 01:55 PM | || Please respond to | || ORACLE-L | ||| |+ ---| | | | To: Multiple recipients of list ORACLE-L| | [EMAIL PROTECTED] | | cc: (bcc: William Dong/New York Life| | Asset Management) | | Subject: Re: Listener.log | ---| When the listener needs to make a log entry he will create a new log. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:47 AM Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Dong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs DB2
|| When I asked my salescritter about this he said Well we || sure are selling alot of licenses - Go figure... LoL...you know what I think? I think there was an INTERNAL memo circulated around Oracle sales that basically acknowledged the problem, and decided that DAMAGE CONTROL would be to give each complainant the FALSE IMPRESSION that they were the only one with a complaint. This would tend to ISOLATE the customer, and make them more likely to pay up than buck what they were being told was the industry trend. || || Thanks, || Frank || || -Original Message- || Patrice J || Sent: Tuesday, April 24, 2001 9:45 AM || To: Multiple recipients of list ORACLE-L || || || Well, || || This is on topic - www.wired.com http://www.wired.com today has an || article re. IBM announced that it is buying Informix for $1Billion. || || Ah, if only I had that kind of money myself - I could take || more Oracle || courses! || || I don't know what will happen with Informix then, does that || mean they will || gobble it up and DB2 will be the only option in a couple of years? || || 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] mailto:[EMAIL PROTECTED] || || || -Original Message- || From: Dennis Taylor [SMTP:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 12:57 PM || To: Multiple recipients of list ORACLE-L || Subject:Oracle vs DB2 || || Disclaimer: I am *not* trying to start a religious war, and I am || *not* || trying to advocate DB2. I am simply offended. Thus this post. || || As some may remember, I'm doing an evaluation of Oracle || vs DB2 vs || SQLServer || to determine our future direction. Here's a datum that makes a || significant || difference to us, dollar-wise. || || With Oracle, in order to make a database accessible to || the internet || through || a web page, you have to buy an unlimited-user || enterprise license. We || had a || senior sales person in our office yesterday, and we asked this || question a || number of different ways. He bobbed and he weaved, but || he did not || deny it. || And the quote he supplied afterwards does not address || the issue at || all. || || Cost of unlimited-user Enterprise version for our || installation (your || mileage may vary) = Approx $160,000 Cdn. || || IBM, for the same purpose, will sell you DB2 UDB || Workgroup edition || (1 || user), and something called WE Internet Access, for a || total price of || $6000 || Cdn. I have a written quote from an IBM salescritter to || this effect. || || $6000. $160,000. $6000. $160,000. Hm. Let me think. || || I respectfully submit that Oracle's pricing structure || is out of line || with || market realities, and may have to undergo significant revision. || || || || Dennis Taylor || || Don't be fooled by old cliches - He who laughs last may have || just figured out the joke. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Dennis Taylor ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || San Diego, California-- Public Internet access / Mailing || Lists || || || To REMOVE yourself from this mailing list, send an || E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of || 'ListGuru') and in || the message BODY, include a line 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). || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Frank N. Pettinato || INET: [EMAIL PROTECTED] || || Fat City Network Services
RE: Oracle vs DB2
This sorta reminds me of the answer I got when I asked why Oracle thought that they deserved all the extra money they were going to get from increasing annual support costs during the Oracle6 - Oracle7 days (aprx. 50% increase each year for at least a couple of years). Oracle said that someone has to pay for all the extra development costs for Oracle7. I suggested that besides the Oracle6 customers (some of whom weren't even using Oracle7 yet), perhaps the *investors* would also be a good source for such funding. (duh?) They didn't know about that! :) ep On 25 Apr 2001, at 6:49, (Frank N. Pettinato [EMAIL PROTECTED]) scribbled with alacrity and cogency: Date sent: Wed, 25 Apr 2001 06:49:43 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California You are absolutely correct. Oracle's getting this price because they can. I wonder how much market share they will lose before Larry switches things around? When I asked my salescritter about this he said Well we sure are selling alot of licenses - Go figure... ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b
May I ask, just what type of restrictions do you envision when the database software is made available at a reduced cost? - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Subject: RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their database software at a reduced cost with the same restriction. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] Original Message- Sent: Tuesday, April 24, 2001 11:05 PM To: Multiple recipients of list ORACLE-L b I'm really sorry, but with these restrictions, they should be able to install it in a business week or less. what losers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Physical Data Layout
Without trying to offend anyone, I personally believe that any recommendation about data, indexes, temp being separate is missing the original point about what is actually being sought after - namely, even distribution of IO across all of the disks. All of the current theories (SAME, data separate from indexes, etc etc) are all about achieving that. For example, you could probably get away with a big chuck on rarely accessed data on the same disks as redo logs, similarly, a single table might need to be striped across 10 disks because it gets pounded by everything... I would forget about data and indexes and look more at whats hot and cold (from an IO perspective) and try to work from there... hth connor --- C.S.Venkata Subramanian [EMAIL PROTECTED] wrote: Hi, I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's. Offcourse reading is slower but writing is faster. From your given information, I can see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk. same ways index and data should not be clubbed together. I have seen RAID 1 and 0 gives better performance than RAID 5 and also improved performance if we distribute I/O with different RAID controllers. HTH -- On Tue, 24 Apr 2001 23:45:20 Saumya99 wrote: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Saumya99 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some
Re: Physical Data Layout
Hi, I think, "don't use RAID for..." is not a good approach. If there is no IO related wait event or there is no huge CPU cycles for software raids, it's not a problem to use RAID or not to use. There is an excellent paper of Carry Millsap who is a philosopher of Oracle+ComputerSciences. You can download it at www.hotsos.com Stefan Jahnke wrote: Hi, I'm also looking for RAID / SAN / NAS technology used with databases. Do you know any recommended readings ? Saumya99 schrieb: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Saumya99 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: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs DB2 - Oracle lost on cost
The client I work for (for the next 2 weeks at least) just made the decision to use UDB over Oracle due to the price of licenses from Oracle. And this is a startup with a big ol' pile of capital. Go figure, I thought startup's always picked the most expensive stuff. They must be saving on the DB for the skating rink. - Brian --- Henry Poras [EMAIL PROTECTED] wrote: I guess they can make their money by targeting the high end and having a few high paying customers, or be more reasonable and have a broader base. I get the feeling that Larry's ego (psychoanalysis from a distance, ain't it wonderful) would drive him to both the $ and the broad base. If you are competing against Bill Gates, you not only need the money, but also the exposure. Everyone knows Windows, you can't have just the elite knowing about Oracle. So where does that put us in 6 months? Henry __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski 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: cdump, bdump, udump
With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle needs to write to one. Terry Ron Rogers wrote: Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball
Re: ORA-12500
Hi, ora-12500 is not a good error to diagnose. is there any error in alert.log ? Rajesh Dayal wrote: Hi All, I have seen the error-manual for above Error message, but it really doesn't state anything clearly. Env is Oracle 8.0.5 on NT 4.0. This problem is not persistent and it comes intermittently. And it has come when I try to shutdown a Production through an automated script before backup (of course automated). Due to this, the backup doesn't happen and also Media recovery is required further to open the database. I have checked the env. variables, they look OK to me(most of the times it work). The similar script works fine with Demo Database. Any experience on this issue? Please suggest some solution. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: Danisment Gazi Unal (Unal Bilisim) 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: memory
Jeez it took all day for that to get out! No, it would just suck up 100 percent of both processors and then a gig of ram. Figured out what it was, one of the developers had sort of an infinite loop in his code. A beleive it was a procedure that kept calling itself, all fixed now. But what I don't understand is why it sucked up more memory than was allocated to the SGA? Kev -Original Message- Sent: Wednesday, April 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Kev, What exactly do you mean by all hell breaks loose.? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed 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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Fwd) Oracle Application Development Tools - Statement of Dire
--- Forwarded message follows --- Date sent: Wed, 25 Apr 2001 12:25:47 -0800 T o : Multiple recipients of list ODTUG-DEV2K-L F r o m : William Dwight w i l l i a m . d w i g h t @ o r a c l e . c o m Oracle Application Development Tools Statement of Direction, April 2001 Oracle9i is the first complete and integrated software solution for developing and deploying the next generation of Internet applications that can be delivered as online services. Oracle9i consists of the Oracle9i Database, the Oracle9i Application Server, and the Oracle9i Developer Suite. Oracle9i offers unified support for Java, XML, HTML, SQL, and PL/SQL. It supports all of the latest J2EE APIs - such as Servlets 2.2, JSP 1.1, JMS 1.0.2 and EJB 1.1 - and all the latest XML standards - such as XML Schema, DOM and SAX 2.0, and SOAP 1.1. Oracle9i Developer Suite In keeping with the overall Oracle9i strategy, Oracle9i Developer Suite provides the most complete and integrated development environment for building Internet web applications and services. Oracle9i Developer Suite includes the following components: Application Development - Oracle JDeveloper - Oracle Forms Developer - Oracle Designer Business Intelligence - Oracle Discoverer Administration Edition - Oracle Reports Developer Enterprise Portals - Oracle Portal Software Configuration Management - Oracle Repository Application Development From an application development perspective, the strategic direction is to provide a single Integrated Development Environment (IDE) that offers complete support for: Any language - Java, XML, HTML, SQL, PL/SQL Any operating system - Windows, Unix, Linux Any development style - UML modeling, RAD/4GL, component-based, 3GL Any of the latest Internet standards - J2EE, XML, SOAP Any phase of the development lifecycle - Design, implementation, compilation, debugging, deployment, performance and memory tuning, monitoring, application integration, and configuration management In addition, for productivity and performance, Oracle9i Developer Suite offers a common component-based framework for defining reusable transactional business logic. The framework deploys to the standard J2EE platform. Starting with Oracle9i Developer Suite, Oracle JDeveloper serves as the basis for the common IDE, and Business Components for Java (BC4J) provides the common transactional business logic framework. Highlights of new application development capabilities in Oracle9i Developer Suite include: - 100% Java IDE available on Windows, Unix, and Linux - Integrated UML modeling with automated synchronization between diagrams and code - Schema driven XML editing - SQL and PL/SQL development support - Integrated Java performance and memory profiling To maximize the level of integration, all new application development offerings will be part of the common IDE and will fully leverage BC4J. As a result of this strategic direction, Oracle has decided not to release Project Cherokee as a standalone product in either Oracle9i Developer Suite or Oracle9i Application Server. Instead, the Cherokee technology, ideas, expertise, and RAD development style will be folded into the common IDE and tightly integrated with BC4J. Oracle Forms is the leading 4GL tool, used by hundreds of thousands of developers all around the world. Oracle Forms provides the underlying infrastructure for Oracle's ERP application suite - Oracle E-Business Suite, and the recent availability of Release 11i is evidence of the incredible power and robustness of Oracle Forms. Oracle will continue to enhance Oracle Forms and support its large installed base. Oracle Designer provides an intuitive environment to model applications and databases. Oracle Designer automatically generates Oracle Forms-based applications from these models enhancing developer productivity. Leveraging Oracle Repository, Oracle Designer enables collaborative development enhancing team productivity. Oracle will continue to enhance Oracle Designer and support its large installed base. The Oracle9i integrated approach stands in stark contrast to the alternatives available elsewhere: complex and expensive multi-vendor kit approaches that require multiple standalone tools and servers for different languages, operating systems, development styles, and phases of the software development lifecycle. With Oracle9i, Oracle offers a more complete, integrated, and standards-based software infrastructure than any other vendor. William Dwight Vice President Application Development Tools Oracle Corporation [EMAIL PROTECTED] --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: spool command: echo not work
Greg - When I'm doing this sort of thing I run the following: set echo off termout off heading off verify off feedback off newpage none set echo - controls whether or not the command is displayed when the command is run by START or @ set termout - controls whether or not the output is displayed when the command is run by START or @ set heading - turns off headers set verify - controls whether or not the bind variable replacements are displayed (that is the line before the replacement is made and the line after) set feedback off - turns off the number of rows returned newpage - sets number of lines printed at the top, before the title But the most important part is running 'sqlplus -s'. This causes sqlplus to run in silent mode and suppresses all the sqlplus info, commands, banner, etc. set echo and set termout won't work for you unless you are running a command file. HTH Linda -Original Message- Sent: Wednesday, April 25, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Thanks all for replay. I knew echo should work, but for some reason it does not. SQL set echo off SQL set hea off SQL spool test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off SQL !more test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off Any ideas? Thanks. Greg. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Hazelton Sent: Tuesday, April 24, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: spool command SET ECHO OFF Original Message Follows Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 24 Apr 2001 12:12:16 -0800 This is a multi-part message in MIME format. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Hazelton 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: Gregory Faktor 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: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:OT RE: HYPER VOLUMES - RE: Never split index and data fi
Vena Babe Rules!!! -- 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).
Off Topic: OracleTuning.com call for papers
Greeting List, OracleTuning.com is a free Oracle Fan and Resource site. If you submit an article, script or whitepaper and we publish it on our site you will be listed as a contributor. Additionally, you will have the option of loading a personal web page on the site where you can detail your background and abilities. This is a great oppurtunity as the job market softens. Best, Scott Tiger www.OracleTuning.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OracleTuning Staff 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).
Statspack
While trying to understand the Statspack reports I read in a doc published by ORACLE 'If the average time per read in the IO sections is large, and the OS statistics indicate high service times or queue lengths, there is an IO problem'. My question is since large is a relative term how do I know what number can be considered as large?. Any ideas? thanks in advance. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Temorary tablespace problem
could be concurrent multiple sort operations... -Original Message- Sent: Wednesday, April 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.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). -- 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: memory
Kev, What exactly do you mean by all hell breaks loose.? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed 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: running oidadmin
The sl file is in the admin directory? Shouldn't it be in the lib dir? Also, I thought that the LD_LIBRARY_PATH env var needed to include $ORACLE_HOME/network/lib dir. HTH! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, April 25, 2001 09:50 To: Multiple recipients of list ORACLE-L I'm having problems getting the OID admin (v2.0.6) utility to run under hp-ux 11. When I try to start it, it get a java error no nldapj8 in shared library path The libnldapj8.sl file is in $ORACLE_HOME/network/admin and this directory is in the $SHLIB_PATH environmental variable. I have found one possible related bug on metalink, but it is not conclusive. Has anybody got this to work in the past? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
Oracle's pricing
I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but I sure would not be able to run the fab on it. You simply can't compare one thing to another thing and say they do the same thing. Now I would do a small application that is not critical in SQL Server if there was no Oracle in house already. As for DB2, it has a few issues where if you try and do certain things you really do end up very close to an Oracle price. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: spool command: echo not work
You can't test the spool that way. Make a file of commands containing the following set echo off set hea off spool test.sql select sysdate from dual; spool off exit Now go into sqlplus and connect then execute the script by issuing the following command. This assumes that the above commands were placed into the file test.sql @test.sql; Your problem is that when the spool command is issued, everything including what you type in will be placed into the file. [EMAIL PROTECTED] 04/25/01 11:15AM Thanks all for replay. I knew echo should work, but for some reason it does not. SQL set echo off SQL set hea off SQL spool test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off SQL !more test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off Any ideas? Thanks. Greg. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Hazelton Sent: Tuesday, April 24, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: spool command SET ECHO OFF Original Message Follows Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 24 Apr 2001 12:12:16 -0800 This is a multi-part message in MIME format. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Hazelton 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: Gregory Faktor 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: William Beilstein 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: Perl DBA Tools
Hi, well, what we are actually using right now is this: (Korn Shell): create 2 named pipes. create a sql*plus and redirect input/output to the pipes. have monitoring scripts sending sql requests to the input pipe. have reporting scripts reading the output from the output pipe. I tried to start this in pipe, but I already went nuts about named pipes in perl (blocking). So, due to lack of time, I gave up on it. Another nice thing would be to have a simple Tk-GUI to remote control SQL*PLUS via named pipes. Problem is ... I hardly know Perl ;) That makes things a little bit difficult (I usually stick to Shell and Java right now). Jared Still schrieb: Hello List, For those of you that use Perl or would like to use Perl for your regular DBA tasks, I have a request. Do you have any tasks you perform with a series of SQL scripts, shell scripts, etc, that you feel are somewhat of a kludge? Have you every asked yourself There must be a better way to do this? Or do you just have a wishlist of tools that would make day to day DBA life easier, but feel that it's too complex or unwieldy to tackle with PL/SQL and SQL*Plus? I'm looking for just those kinds of ideas for a project I'm working on. No ideas too silly or complicated. Granted, they may be too silly or complicated to actually implement, but you never know. No idea is a bad idea until it's thought through. Come to think of it, the same holds true for good ideas also. Anyway, let's hear it! Some examples of tools that I have used in Perl: * Create multiple users from a CSV file generated from MS Excel. Works great when someone asks for 100 users to be created. * Monitor databases for SNIPED sessions then KILL them. * Monitor the alert.log for Errors and mail to DBA's and or selectect other individuals. Errors can be filtered by type and selectively mailed. I've used this for duhvelopers that don't want to be bothered with error trapping and send hundreds of emails to the DBA's due to their error messages. Que's up messages for 5 minutes or 100 messages, whichever comes first ( avoids swamping the mail server in a crisis ) * How about a way to serve up passwords to users for use with command line utilities in a secure manner? Oh wait, I don't have that one yet. As you can see, I have a wishlist too. Lemme hear what you would like! TIA Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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 Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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[2]: Oracle vs DB2
I guess they can make their money by targeting the high end and having a few high paying customers, or be more reasonable and have a broader base. I get the feeling that Larry's ego (psychoanalysis from a distance, ain't it wonderful) would drive him to both the $ and the broad base. If you are competing against Bill Gates, you not only need the money, but also the exposure. Everyone knows Windows, you can't have just the elite knowing about Oracle. So where does that put us in 6 months? Henry -Original Message- Sent: Wednesday, April 25, 2001 2:05 PM To: Multiple recipients of list ORACLE-L I too would love to see somebody give Oracle a reality check in regards to the prices of their software, but as much as I hate to say it, I just don't see it happening. Why? Because the ONLY reality check that Oracle is going to actually LISTEN to and do something about would be for people to stop using/buying their products. And I just don't see that happening either. In the enterprise data market, Oracle has the best product available (IMHO), and I think most people, and especially including Oracle Corp., know this. Based on that information alone, I just don't see them backing down their prices when, as much as people hate paying, they still will, because it's the best. =( -::YEX::- ))) -Original Message- Sent: Wednesday, 25 April, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Tim, Thanks for the copy of the marketing speil, I had not heard that one before. But, I'll take great exception to the claim that: It would make sense to select a database product based on price alone if database products were the predominant part of the overall information technology expenditures But this is simply not the case. Software costs (including upgrades and technical support) typically represent less than 15% of an IT budget and are small compared to the overall costs of hardware, operations and maintenance, consulting and training. I don't know about the remainder of you, but the cost of Oracle's software is quickly eclipsing the cost of everything else. Hence the beginnings of this post, which I agree with. In our company our yearly Oracle Support Agreement renewal is the #3 cost item and the cost of a new Oracle license exceeds the cost of the server it's going on. Someone PLEASE give these guys a reality check or else a good swift kick in the pants!! Dick Goulet -- 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: Yexley Robert D SSgt AFIT/SCA 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: Henry Poras 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: Perl DBA Tools
If you are keeping any kind of statistics on connections using the listener.log, you have the potential of missing records between the time you copy it andempty it to /dev/null. With my method, you won't loose any records. The choice is yours. HTH, John [EMAIL PROTECTED] 04/25/01 12:55AM John, Im my script for managing the listener.log, I copy the listener to an archive area and then cat /dev/null to to current one. Will this have the same effect as moving as in your example ? Do I need also to force the listener to point to a different log file ? Maybe I need to test some more !! Regards Lee Robertson -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: 24 April 2001 19:47To: Multiple recipients of list ORACLE-LSubject: Re: Perl DBA Tools How about wrapping this is a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John [EMAIL PROTECTED] 04/24/01 10:20AM On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: truncating listener logs -- or even starting a secondary listener, stopping the one with the log that is too large and removing the log, then restarting the original listenerGood idea. Thanks RachelJared-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.
Re: REP: Locally Managed Tablespaces
-- 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).
Database and System Throughput
I have been tasked with gathering statistics which will detail the throughput on our Database Servers. In addition to 'performance' metrics, I am looking for scripts/commands in both the database and on unix (solaris) which will show me my system's potential. Things like 'io per hour', 'transactions per second/minute', 'active sessions per x', things which will document how much the system (database and unix) is doing. Obviously this is for future growth concerns. I am soliciting this list to see if anyone can point me to the appropriate commands (unix) and scripts (tables) in Oracle to gather this information. FYI: I have run utlbstat and will run utlestat to get numbers this utlity provides. On unix, I am running sar (5 second intervals). Is there anywhere else I can gather throughput information? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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).
Solaris Tuning
I am about to install Oracle 8i on an Ultra 10 with 2 9Gb Dirves and 512Mb ram runing Solaris 8. This will be for some very small development databases. Any tuning tips for Solaris or Oracle I should be aware of? Thanks Daniel Curry IT/Systems Adminstator [EMAIL PROTECTED] åy«±ç ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+ ©âzP®®¼4DÝjw.®¼Ø¦yÊ«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ§' ¥ú+¹¹bpíz¹Þµ§zË?1¨¥xËlND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×·'(z-xEÀ ;)zYb .+-êîjwbØ^ë,j86Énuæ¥w¢{Zx§CRP Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
CPU/Parse Time Reported by SQL Trace
While working on application performance issues, I noticed significant discrepancy in time reported by SQL Trace and actual time taken by the application. Total Elapsed time reported by SQL Trace was 180 seconds, but it took 500 seconds to run it. (It was a PL/SQL procedure. I just measured the time to run the PL/SQL procedure.) Parse Elapsed Time reported by SQL Trace is 90 seconds, but V$SESSTAT reported parse time elapsed of only 15 seconds. Parse CPU Time reported by SQL Trace is 60 seconds, but V$SESSTAT reported parse time CPU of only 14 seconds. Any explanations on why such a big discrepancy on reported time? Thanks in advance, Jay This electronic message contains information from CTIS, Inc., which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipients named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Mehta 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: Oracle vs DB2
I agree, MySQL is a good way to start out. That's what we did here. It's fast and free. Our product runs with MySQL, SQL Server, and Oracle. The MySQL version allows us to sell to companies that want to use our product but could never afford an Oracle license. But, when it comes to larger companies (such as Toyota, Motorola, Swissair, etc.) that generate a lot of customer traffic with our product MySQL just doesn't scale well. Data corruption is a constant problem, and that's where Oracle comes in. It's stable, reliable, and the large companies that need the reliability can actually afford the licensing. :) We also use Postgres here for some internal applications and it works very well. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Wednesday, April 25, 2001 8:50 AM To: Multiple recipients of list ORACLE-L true, but when cost is the decisive factor w/ a startup, go with the one of the freebies. if the company was too cheap to buy the right product, time to find a company w/ deeper pockets. now w/ ibm buying informix, merging w/ db2, they will have a new product called db4mix :). the free db's are fun to play with but their skills don't pay the bills. [EMAIL PROTECTED] 04/25/01 08:36AM So isn't PostGres, but neither is a close competitor. Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/24/2001 1:28 PM hmmm, mysql is free, best price of all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: MTS
It is a good idea, becuase you'll save a lot of memory. -Original Message- Sent: Wednesday, April 25, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it good idea to configure MTS in such conditions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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: Gogala, Mladen 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's pricing
I don't think your far from the mark. SQL Server is cheaper and on paper functionally equivalent to Oracle. But, for implementations of over 25 users you must buy a processor license for SQL Server, a license for which there is no upgrade path. So when MS pushes out SQL Server 2000 (already on the market) and then SQL Server 200x, and SQL Server yo-yo, while dropping support for Server 2000. You must upgrade at $20k a processor, so after 5 years MS has as much of your money as Oracle, they were just sneaker about it. For small work group use, SQL Server beats Oracle price wise, but if you need lots of users online, the pricing equals out. From looking over MS pricing model, it seems to me that SQL Server is really priced toward organizations that have out grown Access. But MS markets it as an equivalent product to Oracle. Maybe just more MS FUD? Kimberly Smith - [EMAIL PROTECTED] on 4/25/2001 5:33 PM writes us: I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but I sure would not be able to run the fab on it. You simply can't compare one thing to another thing and say they do the same thing. Now I would do a small application that is not critical in SQL Server if there was no Oracle in house already. As for DB2, it has a few issues where if you try and do certain things you really do end up very close to an Oracle price. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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). -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Script for reversing a string? - FYI
FYI: Apparently the reverse function exists in SQL Plus but not in PL/SQL (I couldn't compile a function that referenced it). utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK'))) worked perfectly though. -Original Message- Sent: Tuesday, March 13, 2001 3:46 AM To: Multiple recipients of list ORACLE-L SQL select reverse('abc') from dual; REV --- cba --- Miller, Jay [EMAIL PROTECTED] wrote: Before I reinvent the wheel, I was wondering if anyone has written a function that will reverse a string? Our auditors are requiring that Oracle passwords not contain the reverse of the user name and I was about to start writing this function when I decided to check here first. Thanks! Jay Miller -Original Message- Sent: Friday, March 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L It hasn't caused me any problems - have only tried it on this test server so far, and on my workstation. The workstation has Oracle 7.3. and 8.0.4 on it they have been running for over a year. I wouldn't try this on a production system! These are test databases only. I am just curious why the files are so fragmented. 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] mailto:[EMAIL PROTECTED] -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Does NT write to random locations on disk? I wouldn't think you would want to reorg an Oracle tablespace with an NT defrag utility. You would corrupt the data. Ron Smith Database Administration [EMAIL PROTECTED] -Original Message- Sent: Friday, March 09, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Using a little utility called contig I noticed that the Oracle 8.1.6 datafiles on my test NT server are quite fragmented, an average of 177 fragments per file, 118 fragments for the OEM repository datafile. The poor utility couldn't do anything with the database files, they are too large perhaps. These were created on an empty server, 8i release 2 went on it after a defrag, then the OEM. This is on a hard disk with 1.2G of free space, none of the datafiles come close to that. Why so many fragments? Oracle created those files in one pass, does NT write randomly to disk or what? Won't this have an impact on my NT database's performance? Oracle says tablespace fragmentation is not a big deal, but fragmentation at the OS level matters. Supposedly that's why NT and WndowsXX came with defragmentation tools. ??? Is there a registry setting somewhere to tell NT to write contiguously to disk? TIA 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] mailto:[EMAIL PROTECTED] -- 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). -- 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
OT: Reading the Oracle Tea Leaves
I foresee the database being sold as a turn key product configured by Oracle at a reduced price. In order to receive the discount the purchaser would have to agree not to mess with the initSID.ora parameters, nor take any action which would enable or disable any database options. What?!, not change init.ora parameters, you scoff. Remember that Oracle 9i has some autotuning capability. I expect, at first, autotuning will not work as advertised, but over time will mature into a powerful product. Ian MacGregor -Original Message- Sent: Wednesday, April 25, 2001 2:06 PM To: Multiple recipients of list ORACLE-L b May I ask, just what type of restrictions do you envision when the database software is made available at a reduced cost? - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Subject: RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their database software at a reduced cost with the same restriction. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] Original Message- Sent: Tuesday, April 24, 2001 11:05 PM To: Multiple recipients of list ORACLE-L b I'm really sorry, but with these restrictions, they should be able to install it in a business week or less. what losers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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:Oracle's pricing
Kimberly, I'd whole heartedly agree with you, except that there are a lot of Pointy Haired ones (Dilburt style managers) out here who do look at that one item first. Dick Goulet Some mistakes are too much fun to only make once. Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 4/25/2001 1:33 PM I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but I sure would not be able to run the fab on it. You simply can't compare one thing to another thing and say they do the same thing. Now I would do a small application that is not critical in SQL Server if there was no Oracle in house already. As for DB2, it has a few issues where if you try and do certain things you really do end up very close to an Oracle price. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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's pricing
Well that is very true but I feel its within my contract to kill them all off. Only a few left to go. Isn't that why they pay me the big bucks? -Original Message- Sent: Wednesday, April 25, 2001 2:25 PM To: Kimberly Smith; Multiple recipients of list ORACLE-L Kimberly, I'd whole heartedly agree with you, except that there are a lot of Pointy Haired ones (Dilburt style managers) out here who do look at that one item first. Dick Goulet Some mistakes are too much fun to only make once. Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 4/25/2001 1:33 PM I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but I sure would not be able to run the fab on it. You simply can't compare one thing to another thing and say they do the same thing. Now I would do a small application that is not critical in SQL Server if there was no Oracle in house already. As for DB2, it has a few issues where if you try and do certain things you really do end up very close to an Oracle price. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Kimberly Smith 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).
(Fwd) RE: Oracle Application Development Tools - Statement of
--- Forwarded message follows --- Date sent: Wed, 25 Apr 2001 13:57:43 -0800 T o : Multiple recipients of list ODTUG-DEV2K-L F r o m : Openshaw, Michael [EMAIL PROTECTED] Thanks for a little clarity, Bill; even if it's overloaded with Marketing-speak. Of course, this is the line of the time; in 6 months, who knows. Quick summation and filtering of marketing-speak: 1) Cherokee is dead; quit dreaming. It goes to the same graveyard as Sedona. 2) Java and XML are it; Forms lives only for Apps (Big O hasn't figured out how to convert themselves). The Forms and PL/SQL skillsets will fade to black (albeit slowly in App shops; Apps will probably fade faster). [P.S. Forms 7 is slated *not* to support Client-server deployment; be ready out there!] 3) Given this, you *will* have to 'take control' of the client browser, to ensure they are up-to-date (but not too up-to-date) to handle your applications, whether Jar files or XML implementations. 4) Generation of applications from Designer is on the way out; modeling only. Back to the great dis-association of the functional models from the actual application code. 5) The repository's future purpose will be as a high-dollar replacement for PVCS, SourceSafe, etc. All of this wouldn't bother me as much if I'd heard of *one* major internet site primarily done with either Forms and/or JDeveloper. And, as far as I know, the ODTUG site has the most complete Portal implementation to date outside of Oracle. I hope somebody will alleviate my ignorance if this is not true, and list real sites who are currently using this stuff (outside of Oracle itself). -Original Message- From: William Dwight [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:26 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: Oracle Application Development Tools - Statement of Direction Oracle Application Development Tools Statement of Direction, April 2001 ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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's pricing
so much of venting goin around here Why dont we folks (who get their paychecks for hving oracle db skills) instead of praising/*#@^ Oracle for its pricing start sending CC's for each pricing rant mail to larry/oracle marketing/oracle sales. Or write an open letter to larry. something to vent our frustration in a productive way. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar 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 communication errors
We have many NT servers communicating with our Oracle 8 database (running on a SUN platform). The traffic is Net8 traffic, specifically SQL traffic over TNS over TCP (I was told). When we do sniffer traces of converations with our Oracle database server, we notice that on a regular basis, our NT servers never get a response from the Oracle server for anywhere up to 4 minutes on many occasions. During those moments, we notice there are TONS of the following error messages coming from the Oracle server (as seen in the sniffer traces): Basic operation=4 Error return status Does anyone know what these errors mean? Does anyone know why the Oracle server doesn't respond on a regular basis and how we might look into resolving this? Thanks! Paul
orapwd - osoper help needed
My goal is to have Oracle user JOHNQPUBLIC bounce a database from the local host or remotely. Any UNIX account for that user would NOT be part of the DBA group. I performed the following steps: orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY $ ls -l -rwSr- 1 oracle dba 1536 Apr 25 09:10 orapwXXX $ grep exclusive initXXX.ora remote_login_passwordfile=exclusive In sqlplus: grant SYSOPER to JOHNQPUBLIC; shutdown immediate startup From the local AIX UNIX host: $ ps -ef | grep pmon oracle 33628 1 0 09:16:37 - 0:00 ora_pmon_XXX $ sqlplus /nolog SQL connect JOHNQPUBLIC/hispassword as SYSOPER SP2-0614: Server version too low for this feature Connected to an idle instance. From client PC (same result): click SQL*Plus system ** XXX SQL*Plus: Release 8.1.6.0.0 - Production on Wed Apr 25 09:10:24 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SQL connect JOHNQPUBLIC/hispassword as SYSOPER SP2-0614: Server version too low for this feature Connected to an idle instance. The instance is up. Why idle? What am I missing? Thanks, Alan Martin Oracle DBA - GMAC Insurance Winston-Salem, NC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin, Alan 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).