[no subject]
help
Re: RE: oracle or mssql
they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What's your opinion: ALL_ROWS vs FIRST_ROWS
I guess that's why when I take a look at the initialization files of databases in large shops where it's expected the DBAs know what they're doing, by and large the databases are running in CHOOSE (all rows if there are sufficient statistics) mode. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:19 AM We have an OLTP system that I thought will benefit from first rows. The sad fact is that when I set optimization to first rows the response sucks. Do some testing, as you can change this anytime. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 11:13 PM We're moving from RBO to CBO. For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? And why? My thinking is if it's a database where most of the querying is done on small sets of records, then we may want to use FIRST_ROWS. On the other hand, if our database is used to generate sizable reports, we might use ALL_ROWS. I also understand that we can always change it per session (with alter session) and per query (with hints). Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Internals course
No. Scott said he's been to a number of Pacific Ocean countries to teach the course. I suspect those courses where hosted by a company which had offered enough internal enrollment. As I recall, there's another instructor who also teaches the Internals, Crashes/Dump/Traces and Backup/Recovery seminars. Be careful of all Oracle courses. Some of them are subcontracted out. I don't warn you to put down consultants. But this thread has been about Scott and his internals course. Scott's the star. If you really want to make sure Scott's going to teach your course, phone him up or drop him an email. Don't expect him to respond the same day you try to contact him. When he's teaching, he's tied up through lunch and dinner and sometimes even on the ride to the airport. Many people go to the course with specific questions they want answered. Scott often handles those during out of class hours. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 5:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots
Re: List of Rows Updated
Title: RE: List of Rows Updated Gosh. I wish I worked in your shop. I'm typically asked to produce an audit report for yesterday on a table I didn't even know existed. "What do you mean you can't do that? Aren't you an Oracle DBA?" - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 5:58 AM Subject: RE: List of Rows Updated Auditing is much simpler and usable than logminer for *this purpose*. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message----- From: Tom Pall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated Logminer comes to mind. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:23 PM Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj.
Re: Oracle Internals course
Title: Message Oracle didn't start offering instruction directly at your desktop or urge you to open up an iTAR instead of talking to a Customer Service person for nothing. People are expensive. - Original Message - From: Bob Metelsky To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 8:33 AM Subject: RE: Oracle Internals course It is just me or does 500-2000 per day seem a little "steep"? Oracle8i: Everything You Always Wanted to Know about the Optimizer Instructor-Led inClass US$ 500 1 Day English English OR INTRODUCTION TO ORACLE9I: SQL (ILT) BLOOMFIELD, CT 02-DEC-02 US$2000 Remove from Shopping Cart INTRODUCTION TO ORACLE 8I: SQL AND PL/SQL (ILT) BLOOMFIELD, CT 17-FEB-03 US$2000 Remove from Shopping Cart ADVANCED PL/SQL (ILT) BLOOMFIELD, CT 07-NOV-02 US$1000 Remove from Shopping Cart
Re: RE: oracle or mssql
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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Convert DM TSP to LM TSP w/ lots of data
of extents doesn't happen in the blink of an eye but doesn't lock out all other space allocation as UET/FET weren't constantly in use and the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Software Raid
Ah yes. The eternal argument between the DBA, who likes things separate,and the SA, who likes big smears (But it's mirrored!).- Original Message -From: [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, October 29, 2002 3:43 PMSubject: Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes ofSoftware Raid I would go with 3 RAID 1's given the choice. Not necessarily for performance though. This would allow you to have 3 control files on separate drives. It would also allow soft mirroring of the redo logs. And before someone jumps in with "But you don't need to mirror them on RAID 1", I *like* having them in 2 locations. :) As for performance, it is nice to separate the redo as much as possible. Jared "VIVEK_SHARMA" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/11/2002 06:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L[EMAIL PROTECTED] cc: Subject: 1 Volume of Software RAID 1+0 versus MultipleVolumes of Software Raid 1 ? For performance , Which Option is better :- Given 6 Internal FCAL Hard Disks ? 1) Creating 1 Volume with Software RAID 1+0 OR 2) Creating 3 Volumes of Software RAID 1 , Each Volume Containing 2 Disks Manually Spreading the Database across the 3 Volumes ? Solaris 8 Machine V880 model -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mixing OLTP with DSS
Oracle 8i uses a different aging algorithm than before. It waits for blocks to be accessedseveral times before considering keeping them around. That way the full scan of a big table won't push other tables out. If aging becomes a problem, remember you can now size a keep and recycle buffer pool (The names only suggest the buffers' intended purposes. Each follows the same aging algorithm.) and can alter table/index/partition to assign it a new buffer cache online. If the data OLTP and DSS don't have to be accessed in the same query, it makes sense to create a new database to contain the OLTP data. Not only will the caches be separate, their rollback, redo and process will be separate as well. Plus, you'll be able to backup or take one down without bothering the other one. If the data has to be accessed together, you'll have to weigh the impact using database links in with the other pros and cons of creating a separate database. - Original Message - From: Rick Stephenson To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 12:19 PM Subject: Mixing OLTP with DSS Am I looking for trouble by mixing an OLTP type database with a DSS type database? I currently have a relatively small database that is used for quick lookup type actions. The company wants to add a much bigger and constantly growing application for historical reporting on the same machine. Should I create another instance or keep it in the same instance? Keeping it in the same instance would seem to defeat having anything cached seeing that the large reports will flush out the cache each and every time. I am running Oracle 8.1.7, on Solaris 2.8. Any suggestions would be helpful. Thanks, Rick Stephenson
Re: Experience with Quest Shareplex
I did some investigation into SharePlex a few years ago. I tried for months to get someone to respond to email and voicemail messages to the vendor that I want to buy SharePlex and I have the money. Eventually I got the software for evaluation. I found once again that replication isn't easy, no matter which approach or vendor you use. My own playing around with SharePlex, talks with noted Oracle book authors and email exchanges with SharePlex users who responded to my query on this listserver privately honed in on one problem: getting synchronized and ready to start replicating. SharePlex would synch up table after table, find one it couldn't synch up and fail. Like anything with Oracle, see if Oracle's solution fits your needs first. It's nice only having to go to one vendor for support. SharePlex costs a lot of money. Make sure you've got your requirements firm. After all of my investigating, the company I did the work for decided they could live with reporting databases created by breaking a third mirror, exporting the filesystems from the production box, importing them into the reporting box. If you really need the capability of SharePlex, well, it does have a lot of happy customers. Be prepared, as they were, to spend lots of time getting it right. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:13 AM Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BUG 2632931 on 9.2.0.2
Title: RE: BUG 2632931 on 9.2.0.2 "C" what side effects you have to consider when choosing a programming language? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 12:38 PM Subject: RE: BUG 2632931 on 9.2.0.2 What's new in Oracle processes leaking memory ...? Looks like they shouldn't follow microslop in this regards at-least. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: BUG 2632931 on 9.2.0.2 Excuse my French but that !!@@# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: BUG 2632931 on 9.2.0.2 native_threads process associated with 9.2.0 OEM OMS is leaking memory. Process starts out about 8 MB and keeps growing. Up to 28.93 MB after less than 1 hour. Workaround: None
Re: Oracle Internals course
I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. 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] -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:[Q] what kind of documents shoud contractor provide to m
Do some checking. These are typical deliverables. The key is whether or not the documentation is AS DESIGNED or AS DELIVERED. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM Only those listed as deliverables. Now you should have listed a database design document, data dictionary, users manuals, maintenance manuals, and commented code. Dick Goulet Reply Separator Author: dist cash [EMAIL PROTECTED] Date: 10/28/2002 10:13 AM We have a application use ORACLE 8.1.6 and Forms 6i. This project going to finish soon. Can anyone tell me what kind of documents should contractor provide to us before they leave? Thanks. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of Trace file
Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Productionon Microsoft Window 2000 5.00.2195 Service Pack 3.I have no registry entry for a pfile or ifile. Since I have no ifile, thequeryShow parameter ifilereturns a null string.oracle\ora92\database contains the file SPFILETOM.ORA (this is 9i,remember).oracle\admin\tom\pfile contains init.ora.9212002185826.TOM is the database sid.It looks like the Oracle installer for 9i did away with the single linepfile it created in Oracle 8i. It also looks like Oracle expects to findthe spfile ORACLE_HOME\database. ORACLE_HOME is defined in the registry.- Original Message -From: "Yechiel Adar" [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Monday, October 28, 2002 12:25 PMSubject: Re: Location of Trace file I just built a new database for 8.1.6 on win2000. In oracle\ora81\database there is initsid.ora file for the database. This file contains only ifile=\oracle\admin\sid\pfile\initsid.ora. But - The registery entry for pfile point directly to: \oracle\admin\sid\pfile\initsid.ora so ifile value is empty. If you are on windows check that values in the registery for oracle home. Look for name=ora_sid_pfile. The value points to the pfile. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 26, 2002 5:43 PM My query was executed on an Oracle installed, Oracle created Oracle 9i version 2 database on Windows 2000. Oracle really started following OFA on Windows starting with version 8i. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, October 25, 2002 1:04 PM If you follow OFA, it works for NT ;-) "Tom Pall" tpall@realti To: Multiple recipientsof list ORACLE-L [EMAIL PROTECTED] me.net cc: Sent by: Subject: Re: Location of Trace file root@fatcity. com October 25, 2002 12:58 PM Please respond to ORACLE-L Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL show parameter ifile NAME TYPE VALUE --- --- --- ifile file SQL show parameter background_dump_dest NAME TYPE VALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, October 25, 2002 4:12 AM Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXAC
Re: Oracle Internals course
Title: RE: Oracle Internals course That rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely notall the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the "instructors's instructor" he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PMI just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. 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]-- 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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!?
Re: Oracle Internals course
Title: RE: Oracle Internals course
Meaning you're not planning on letting your DBA go
because Oracle now has now no initialization parameters to tweak (Wrong!), is
self configuring, self maintaining, self tuning, self repairing?
- Original Message -
From:
Khedr,
Waleed
To: Multiple recipients of list ORACLE-L
Sent: Monday, October 28, 2002 6:58
PM
Subject: RE: Oracle Internals
course
I
think the external visible Oracle stuff are enough to keep any DBA busy these
days:)
-Original Message-From: Tom Pall
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 5:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Oracle Internals course
That rumor's been going on for versions
now. As has been Scott's desire to offer a two week internals
course. Course participants would sign all sorts of non-disclosure
forms then get a scaled down version of what's taught to Customer Support.
Wait a minute! Customer Support takes these courses? Surely
notall the Silver Support people I've called. A difficulty with
a two week course is that the very DBAs most likely to benefit from the
course are the ones least likely to be let free for two weeks.
The internals course is slated to be yanked
every time a new version of Oracle comes out. Why teach internals when
there are no initialization parameters and the database maintains and tunes
itself? There's been an economic downturn and Oracle DBAs have lost
their jobs. But anybody know an Oracle DBA who lost his job because a
later version doesn't require a DBA? Oracle on CDs 1,2 and 3,
huh? I think if I dig enough I can find that old version of Oracle I
had that came on a single diskette.
Scott says the internals course is purposely
hidden. You have to call Oracle directly and ask for it. A
number of people registered for the course from the paper or online
catalogs, showed up then complained that they weren't about to get anything
out of the course..
- Original Message -
From:
Nick
Wagner
To: Multiple recipients of list
ORACLE-L
Sent: Monday, October 28, 2002 3:23
PM
Subject: RE: Oracle Internals
course
rumor has it that this course is not going to be
offered/modified for the 9.2 release of Oracle. Can anyone confirm
or deny it?
Nick
p.s. Had a close friend take this class, and they also
came back extremely pleased with it.
-Original Message- From:
Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course
Scott is the "instructors's instructor"
he learns the new features, then teaches them to the
instructors so they can teach them to you
I had the pleasure of taking those classes with Scott a
few years ago as well. He's a great
teacher.
If he is ever presenting at any conference you go to, GO
SEE HIM
--- Tom Pall [EMAIL PROTECTED] wrote:
I took that very course with Scott a few years
ago. Yup, Scott flies through the
Internals and Dump/Traces courses with lots of extra material to spare. It's
really refreshing to hear him tell the class how the developers documented something
then tell how it's actually built. He keeps a database running in his notebook
to prove what he says. Scott's one great teacher. - Original Message
- To: "Multiple recipients of list
ORACLE-L" [EMAIL PROTECTED] Sent:
Monday, October 28, 2002 12:53 PM
I just wanted to
say... If you
have a chance to take the Oracle Internals course with Scott
Gossett at Oracle, I
highly recommend it. I wish I knew half of what he knows! The course isn't included in the
OCP tracks, I think it should be given
a higher profile though. 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]--
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 http://www.fatcity.com San
Diego, California -- Mailing
list and web hosting services
-
To REMOVE yourself from this mailing list, send an
E-Mail message
Re: Oracle Internals course
Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. 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] -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Re: Convert DM TSP to LM TSP w/ lots of data
I triedhaving Oracle convert DMT to LMTout a few times on 10 GB tablespaces. Whether or not that's a lot of data depends on you. Worked like a champ. And this was in the early days of LMT. People who pay a lot of attention to the internals will warn you that converting a DMT to LMT is not optimal. Your bitmaps wind up at the end of the files instead of the headers. I've read posts here and elsewherewhere people worried about the same issues as they did with DMT. They wanted to limit the number of extents segments grew to by creating tablespaces with different sized fixed extents. A DBA I worked with pointed out how very easy and quickly things worked with letting Oracle automatically size the next extent. I've gone that way whenever possible and have never regretted it. I've not done a rigorous benchmark but can tell you from casual observation dropping an object with lots of extentsdoesn't happen in the blink of an eye butdoesn't lock out all other space allocation as UET/FETweren't constantly in useand the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM Subject: Convert DM TSP to LM TSP w/ lots of data I am reposting this. Has anyone tried to convert a dictionary managed table space containinglots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind
Re: List of Rows Updated
Logminer comes to mind. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:23 PM Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus COPY error
I've not seen this particular error. Over the years I've found SQL*Plus COPY to be buggy. I just did a search on Metalink for sqlplus copy error. Your problem is not addressed directly, but other problems point to bugs in the GUI version of SQL*PLUS. Oracle's advice is to use the command line, non-GUI version of SQL*Plus for COPY. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 12:54 PM I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of Trace file
My query was executed on an Oracle installed, Oracle created Oracle 9i version 2 database on Windows 2000. Oracle really started following OFA on Windows starting with version 8i. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 1:04 PM If you follow OFA, it works for NT ;-) Tom Pall tpall@realtiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] me.net cc: Sent by: Subject: Re: Location of Trace file root@fatcity. com October 25, 2002 12:58 PM Please respond to ORACLE-L Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL show parameter ifile NAME TYPEVALUE --- --- --- ifile file SQL show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 4:12 AM Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of Trace file
SQL select name, value from v$parameter where name='user_dump_dest'; NAME VALUE -- user_dump_dest C:\oracle\admin\tom\udump - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 3:08 AM Hi , I want to know the location of trace file.I do not know location of init.ora. How to get it. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of Trace file
Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL show parameter ifile NAME TYPEVALUE --- --- --- ifile file SQL show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 4:12 AM Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of Trace file
The most common reason is that you are not logged on the system as the user and group that owns the $ORACLE_HOME/bin/oracle executable. You also need to have ORACLE_HOME and ORACLE_SID set appropriately. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 4:43 AM Hi, when I connect to internal using svrmgrl,it asks for password. I do not know the password. Regards, Manoj. -Original Message- Sent: Friday, October 25, 2002 1:44 PM To: ORACLE-L Cc: oraoraora; Manoj, COSLTEMP-G Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
set nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYSTEM TABLESPACE IS SO HUGE ?
You've already been given the best and simplest method to defragment the SYSTEM tablespace: export, recreate with locally managed tablespaces, do a full import. You _could_ take a look at which SYS objects have many extents and edit sql.bsq **caution**caution**caution** before recreating your new database. Before you do that, figure out if the tablespace is really fragmented or just heavily used. Each version of Oracle has required more SYSTEM tablespace. Oracle Apps could be filling it up. Or you could just have lots and lots of source code. Take a look at dba_extents and dba_free_space to see if you have lots of unusable space. It's pretty conceivable, since Oracle likes to put a 50% increase on many of its segment definitions. If the tablespace has lots of unusable free space, you could possibly try reclaiming the space the way I've often had to reclaim space in a live database with no downtime allowed. If Oracle will allow alter index rebuild and alter table move on the objects (I've never tried to move anything belonging to SYS), you could construct a tablespace map showing where each extent begins and ends. Hopefully you'll have an overextended index or table sitting at the bottom of a datafile. With nobody else able to access the database, do an alter index rebuild or alter table move, perhaps with new storage parameters. With luck, you'll now have a more compressed segment and space freed at the end of the file. Resize the data file to reclaim the space. Make sure your boss knows you might have to restore and do a point in time recovery if something goes wrong. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 2:18 PM Yes Steve, System tablespace was fragmented heavily and that's why its taking 10 Gig . The database size is 75 gig , and would you suggest me to take Full database EXPORT and import it back after creating a new database with same structure ?? or is there any best or simple way ?? Thanks Madhu -Original Message- Sent: Thursday, August 15, 2002 1:51 PM To: Multiple recipients of list ORACLE-L 10G? Must have a lot of objects not belonging to sys/system in there. (Unless someone turned auditing on and forgot about it.) I'd say the system tablespace must be so fragmented that it's best to create another database and recreate the users and import their data with default and quota set to locally managed tablespace(s). -Original Message- Sent: Thursday, August 15, 2002 12:07 PM To: Multiple recipients of list ORACLE-L Hello Listers, We have a database for which the SYSTEM tablespace size is nearly 10 gig , Now I have a plan to reduce the size of it . And database is running on 8.1.7.2. What would be the best and faster way to do it. Your ideas will be very much appreciated !! Thank in advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall
Sessions Hang When Not Being Traced/Unhang When Being Traced
Anybody seen this before? Running 8.1.5.0 on Solaris. We have a third party product written in java which runs for a certain amount of time then hangs. I don't see any locks or waits for the applications sessions. This does not happen if I put sql_trace=true in the init file and bounce the database. I can unhang and hang the application sessions using ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL whatever/ORADEBUG EVENT 10046 TRACE NAME CONTEXT OFF. I've searched Metalink's bug database and haven't found any bugs that apply yet.
RE: Another NT question
-Original Message- Sent: Tuesday, June 26, 2001 5:12 PM To: Multiple recipients of list ORACLE-L Does it matter NT/Alpha or NT/Intel? -Original Message- Sent: Tuesday, June 26, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that they can handle a large system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8.1.6 vs 8.1.7
We're in the process of migrating all of our 8.0.5 to 8.1.6 databases over to 8.1.7.1. We'll be done in a few weeks. We used 8.1.7.0 on our reporting and other non-money making databases since it was released. The few cosmetic issues we had with 8.1.7.0, like v$buffer_pool_statistics being broken, appear fixed in 8.1.7.1. 8.1.7 fixed an almost endless number of bugs we encountered in 8.1.5 and 8.1.6. Sun/Sparc 2.7. -Original Message- Sanmarti Sent: Thursday, April 05, 2001 5:21 PM To: Multiple recipients of list ORACLE-L Hello, I was wondering how stable the Oracle 8i release 3 is. We plan to move our DB in production to the latest version. Has anybody had problems migrating it? I was told by colleges that release 2 looks more stable than the other. How true is that? Any comments ? Thanks in advance, Jordi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jordi Sanmarti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQLServer vs. Oracle Papers Needed
I need pointers to papers/studies that compare and contrast SQLServer vs. Oracle. I'm specifically looking for studies which appear impartial and conclude that Oracle is the better choice. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
Please send me ([EMAIL PROTECTED]) a fax number. Too much to type in, don't have ready access to a scanner. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 12, 2001 2:45 PM I've continued to research this error and found several references on various search engines. The most promising seems to point this book by O'Reilly "Oracle8i Internal Services for Waits, Latches, Locks, and Memory". There is a section (4.4, pg. 42) which talks about enqueue locks, but I cannot see the text. If anyone has this book, could you give the above section a quick read and let us know what it says about enqueue locks and possible resource limits/settings for init params. THANKS! For Kenneth; My version is; Oracle 8.1.6.0.0 and sun Solaris 2.6, as stated in my original post. -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 11:16 AM To: Oracledba@Lazydba. Com; [EMAIL PROTECTED] Subject: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 The system was not too busy. Processes running were materialized view refreshes (stored procs doing rollups, joins, etc...). The system was then locked up. Some queries could be run, others couldn't. Refreshes never completed. I had to alter system kill to release the hang. Here are the errors: From the alert file; WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 From the udump dir; *** SESSION ID:(37.4) 2001-02-11 22:55:18.638 WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! row cache enqueue: session: 8c184270, mode: N, request: X row cache parent object: address=8ac94c10 type=8(dc_objects) transaction=8c4b78e4 mode=X flags=002a status=VALID/UPDATE/-/-/-/-/-/- data= ... waiting for 'library cache lock' blocking sess=0x0 seq=8105 wait_time=0 handle address=8b27869c, lock address=8c629710, 10*mode+namespace=15 - Metalink is pretty vague and not much help with this error (some say it is a VMS enqlm problem, others say it was a bug in v7 and early 8.0). I am running 8.1.6 on Solaris 2.6. As always, any insight would be greatly appreciated. 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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
