RE: Overhead Associated with Signon Audit in Financials 11.0
Hi Vicki, We're not running 11.03 (we're on 10.7) and we have auditing running for sign-on audit set for Responsibility (so we get recorded what responsibility they're using). We were running it set for User so that the DBAs could use that information to get back who was running what. In both cases we didn't see an appreciable decrease in performance, though we have less than 100 users who only change responsibilities a couple of times a day (at most). We are running the "Purge Signon Audit data" concurrent manager program daily to keep the FND tables reasonable size but we run a custom program to move some of the data to custom tables for analysis. When we researched it, the consensus at the time was User is best, Responsibility is OK, but turning it on for Forms is a major impact (we didn't test as we didn't need to know which forms people were using). HTH Margaret -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003 2:54 PMTo: Multiple recipients of list ORACLE-LSubject: Overhead Associated with Signon Audit in Financials 11.0Does anyone have any statistics about overhead associated with using the Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3 environment. We are using full installs of AP, GL, FA and CE. Size of the production database is 100G. Can't tell you exactly what we'd be auditing; we are under siege by Internal Audit at the moment - they've raised the "database audit" flag, but have not started dictating what they want audited. I am trying to get some real-world statistics to arm myself with when the day comes . I have heard that the overhead is significant - is this true, in your experience? Vicki PierceDatabase Administrationx2401
RE: 'Test' Note on Metalink...
Or that the developers test in production! -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: 'Test' Note on Metalink... Just proves, what's TEST today is Production tomorrow. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murray, Margaret 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: ORA-01041: internal error. hostdef extension doesn't exist
Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleServiceSID are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01041: internal error. hostdef extension doesn't exist Hi All, I have the following environment variable set ORACLE_HOME ORACLE_SID TNS_ADMIN init.ora file = REMOTE_LOGIN_PASSWORDFILE=NONE sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm getting the following error. What could be wrong? SQL connect / as sysdba ERROR: ORA-01041: internal error. hostdef extension doesn't exist Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Murray, Margaret 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 Query Help
Add group by ID; as in: SELECT ID,MAX(LastModDate) FROM Tab group by ID; -Original Message- From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 8:15 PM To: Multiple recipients of list ORACLE-L Subject: SQL Query Help i have a query that returns 2 rows with one column being id and the other being date-time stamp. i want to select the row with the latest timestamp among those two records.they have difference id values SELECT ID,LastModDate FROM Tab IDLastModDate ----- 2 1/20/2003 2:56:18 AM 1 4/23/2003 10:26:42 PM I want to modify the above query to return the row with id=1 which has the latest timestamp I tried this SELECT ID,MAX(LastModDate) FROM Tab getting this error OERR: ORA 937 not a single-group group function how do i get this work. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murray, Margaret 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).
OT: Oracle workers need stress management??
http://news.lycos.com/news/photo.asp?from=mylycosphotosection=BreakingPhoto sphotoId=amdf319368 Or for the full story :http://news.lycos.com/news/story.asp?section=Breakingpitem=ODD%2DLIFE%2DJA PAN%2DDOG%2DDCrev=20030206pub_tag=REUTGfrom=photodetail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murray, Margaret 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: strange behaviour of sequence
Jp: Is the sequence cached? Check out Note:62002.1 on Metalink - Applications which use Oracle sequences which have the CACHE option enabled will often 'skip' values. This article discusses the cache option, why numbers can be lost and how to minimize this occurrance. You'll either want to pin it using DBMS_SHARED_POOL.KEEP (depending on your version of Oracle you may need a patch to enable pinning of sequences) or not cache it. Margaret -Original Message- From: oraora oraora [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: strange behaviour of sequence Guys, one of my developers is using sequence to auto-increment the value of a column while inserting. he has created a sequence like this. SQL create sequence testseq start with 1; and then uses a INSERT statement as below in a JSP. insert into testtab values ('BREAD'||testseq.nextval); after some inserts .when he does SELECT from TESTTAB...he finds the values as : BREAD1 BREAD2 BREAD3 BREAD4 BREAD21 BREAD22 it should increment by 1.but it is not so ? any hint/clue Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Murray, Margaret 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).
OT: Metalink patch searches rant
All, I'm so frustrated that I had to rant to the list - my co-workers don't have much sympathy. I haven't been searching Metalink for patches in the last two weeks, but the new search functionality really sucks. When trying to search for Linux patches, I must put in Linux Operating System Family which promptly makes the ONLY release RedHat Advanced Server 2.0. Not right when I want to search certified SuSE SLES7 (or even if I had RedHat, 2.0 is only certified on 9i, not 8i!). Must mean there are only patches for RedHat 2.0 on 9i? Yeah, right. Urrgh! Plus, in the new Beta search, drop downs are a thing of the past - just about every field must be queried separately (those lovely pop-up windows), though supposedly the searches can be saved (haven't tried that yet, no reason to!). I'm sure there are tons of other limiting features to the new search, but I did get a huge laugh when I queried RDBMS 8.1.7 and got 500 patches returned (there are more but it only returned 500) - if you ever wanted an idea of how many patches are out there, there's a good indication. There's only 12 patchset/minipacks, though (lots of patches rolled into one, I guess). I did notice the new Beta search doesn't have an easily found feedback button (it's back on page one), but I did fill out a long gripe to them :) Enough ranting, back to trying to get around the search engines (both newly-fixed-old and new-Beta-2.0) to find the patches I need. Margaret -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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 apps documentation
Metalink - top tech docs (left menu) - E-business Suite ERP - module - Documentation (there are also other paths to follow to get to the same place). You'll find user guides and most TRMs Alsocheck out AppsNet: http://www.oracle.com/appsnet/content.html -Original Message-From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 5:02 PMTo: Multiple recipients of list ORACLE-LSubject: oracle apps documentation can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks , oramagic Do you Yahoo!?Y! Web Hosting - Let the expert host your web site
RE: Oracle to publish pricing guide on Sept. 3
Not there yet - promises, promises: Oracle Software Investment Guide -- Available September 6, 2002 Visit http://www.oracle.com/corporate/pricing on Friday, September 6th to see the Oracle Software Investment Guide. Shall we start a pool of what the likely date will be? Maybe a delay of another week and it's Friday Sept 13th -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to publish pricing guide on Sept. 3 Oracle has moved the release date from Aug. 28 to Sept. 3. All will be revealed . . . http://www.eweek.com/article2/0,3959,491399,00.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HIPAA compliance and Win2k
Speaking of bashing, you can't watch Larry's presentation without the latest version of Real Player - which is 155M!!! On our T1 that's an hour of download time... what an oinker. If it EVER finishes downloading and (miracle of miracles) the behemoth actually works when installed, I'll be amazed. So far I've never had it work properly (that's why I don't have the latest version). I knew there was a reason I have a prejudice against Real Player... -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 8:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: HIPAA compliance and Win2k I don't know if you saw the Larry Ellison presentation to the LINUX convention... www.oracle.com, there is a link near the bottom. The beginning is funny, with the penguin being driven around in a limo and eating with executives. Larry says in passing that OTN is running on LINUX now. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, August 28, 2002 7:03 PM To: Multiple recipients of list ORACLE-L Subject: Re:HIPAA compliance and Win2k AH YES, more Micro$oft bashing!! What fun. Long live the Penguin. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 8/28/2002 9:33 AM Sure to start a discussion. ;) http://ask.slashdot.org/askslashdot/02/08/27/2030205.shtml?tid=109 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HIPAA compliance and Win2k
Actually, that's what was the 155M - Oracle's version of the latest Real Player. That didn't work, nor did downloading it from the Real Player site directly. I did find out the reason - Real Player doesn't work through our (or any?) corporate proxy server for it's final part of the install (just get Connecting... until it times out 15-20 minutes later). So no viewing of Larry's speech, oh well. Thanks anyway! -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: HIPAA compliance and Win2k Speaking of bashing, you can't watch Larry's presentation without the latest version of Real Player - which is 155M!!! On our T1 that's an hour of download time... what an oinker. If it EVER finishes downloading and (miracle of miracles) the behemoth actually works when installed, I'll be amazed. So far I've never had it work properly (that's why I don't have the latest version). I knew there was a reason I have a prejudice against Real Player... I didndt find watching or listening to it any problem at all. We have dsl and a pretty crappy connection at that. The real player Streams and buffers so you don't really download the file but rather watch it in streams. Maybe you need a newer version of realy player... Im on w2kpro using real player 8 basic build 6.0.9.380 It is much the same as listening to the radio online (not that I do that at work.) The presentation was pretty cool and worth looking into. Apparently Oracle is going to be big on running clustering Linux servers Where you hook a bunch of machines togother to spread out the processing Overall Larry sounded anti everything/body except Linux eehh bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reasons to upgrade from Oracle 7.3.4 to 8i
Not completely unsupported - plenty of old patches exist and can be downloaded and applied. There's tons of support docs on solving issues aside from applying patches. If the DB crashes (which doesn't happen often as the databases are usually stable and the hardware unchanging) support will work with you to get it back up. BUT if you do have to change hardware or OS, and the DB doesn't work with it, you are SOL (and will get the song and dance from support about only option is upgrade). Many companies are unwilling to invest the money, time and effort to upgrade the DB and application for a stable system, unless they see a ROI that isn't solely related to desupport of the DB. Other reasons to upgrade: ability to upgrade OS and hardware, tools that only work on newer versions, index options (bitmap, etc.). Margaret -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Reasons to upgrade from Oracle 7.3.4 to 8i How about the fact You are completely unsupported by Oracle in that version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: trial version of Oracle Financial ??
Ron, That's fine for everything BUT E-Business Applications (and isn't that what most people want?) from the web page - * We do not offer trial licenses for our E-Business Suite Applications. Leslie, Be prepared to spend at least $40 and LOTS of learning time to install to try. I don't think trial versions come with support - and I'm not sure it can be done without patches and many (sometimes hundreds, depending on how many and which modules) iTars. The Vision database is the seeded database with somewhat useful data. Margaret -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: trial version of Oracle Financial ?? Leslie, Go to the Oracle web site and click on the store icon and check out the CDPACKS for $40 each. You can get anything for your own play evaluation purposes. Ron ROR mô¿ôm [EMAIL PROTECTED] 06/03/02 04:58PM Hi, Does anyone know where to get a trial version of Oracle Financial, or other components of 11i? Thank you! Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CPU Pegged at 100%
Try http://www.quest.com/presentations/pdfs/MT_maxprod9i.pdf or the link is on http://www.quest.com/presentations/openworld_2001.asp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: CPU Pegged at 100% Thomas, If you could locate that paper, we would all be grateful. I have been unable to find it. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlplus Auto-trim Whitespace???
Walter, set trimspool ON (or set trimsp on or set trims on) you can also use show all at the sqlplus prompt to get an idea about what other options have been set (if you don't remember the command). Margaret -Original Message- From: Walter K [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Sqlplus Auto-trim Whitespace??? Hi, A co-worker of mine is trying to remember how to have trailing whitespace automatically removed from each COLUMN in the output of a query within SQL*Plus. He said he saw the tip in a book a couple years ago and can't remember for the life of him how he went about it. I have poured through the docs myself and other references and can't seem to find a way to do this. The objective is to set the COLSEP to say '|' and then be able to perform something like a SELECT * FROM table such that the output/display is variable length for each column. The solution we're looking for is purely within SQL*Plus, not doing something with PL/SQL. Also, the solution should not involve using the COLUMN command to control the formatting of each column literally. Anyone know how to do this? Does anyone remember the tip and possibly the name of the book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TFM
April, You can also purchase the Oracle book Oracle Applications Performance Tuning Handbook by Andy Tremayne ISBN: 0-07-212549-7 ($59.99 US). I've found a few interesting things in it; it covers tuning of the database and the tiers, but not install and setup. Also check out Apps Net for some white papers he's written for the OAUG conferences (and Apps World?). The other Oracle Financials book (no idea of the title or ISBN #) I found very high level and not useful. Margaret -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L Subject: TFM We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01000: maximum open cursors exceeded
Dave, When I ran into this error using AP Oracle Applications, I was told this could be set as high as I wished with no performance hit up front (the cursors are not allocated, only allowed). In fact, the support analyst couldn't come up with a good reason why it shouldn't be set to the maximum for the platform (on Solaris at the time it was 1000). I suspect there is a reason, but getting the transactions through AP far outweighed the potential performance impact ;) (I didn't see any, but was really chasing other, larger performance issues at the time). Margaret -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01000: maximum open cursors exceeded We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unbreakable Oracle - Metaslink
Can't get in either. Been trying for a couple of hours (it's not 10:50 am) with no luck. So much for checking on my tars... -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unbreakable Oracle - Metaslink It was up and running earlier on (8am-1pm GMT) -Original Message- Sent: 30 January 2002 13:15 To: Multiple recipients of list ORACLE-L Seems to be down this morning must be the flu ... Raj __ Rajendra JamadagniMIS, 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metaslink is back up
Yes, but without iTAR access - it's not even on my menu! If I try to access the tar directly I get Insufficient Privileges : You don't have Tar Access Privilege. 'Course I do have access to the silly How to Ensure Uninterrupted MetaLink Access. News Notes ;) Margaret -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 2:31 PM To: Multiple recipients of list ORACLE-L Subject: Metaslink is back up Raj __ Rajendra JamadagniMIS, 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sorta OT: Metalink Humor
Listers, Does anyone else see the humor in this? From the Metalink web site, the top two New Notes topics are this: How to Ensure Uninterrupted MetaLink Access. 17-JAN-2002 N Temporary Interruption in iTAR functionality: US, Canada and Latin America Only! 14-JAN-2002 N And topic How to ensure uninterrupted MetaLink access? has the first line of: The easiest way to ensure uninterrupted access to MetaLink is to use MetaLink. REALLY?? Access is that easy? When it's down, USE it? Hmm Hey, can I try it at 2am this Sunday? No? Oh that's right, the iTar piece is down. But if I use it, it's there, right? Something is missing in logic here... Thank you for using MetaLink! The MetaLink Team Now that I've had my giggle for the day, it's back to work. Margaret -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle/Server Audit
Jared, You might take a look at https://www.ecora.com/ecora/products.asp. Doesn't look like they cover everything on your list (and more than one module covers what you stated), but I saw an early demo that looked good. Margaret -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:28 PM To: Multiple recipients of list ORACLE-L Subject: Oracle/Server Audit First off, let me state that this post is NOT referring to Oracle Database Auditing. That may be one of the criteria in the audit I'm referring to, but is only peripherally relevant to my question. What I need is a document that can be used to audit a server that one or more Oracle databases are on, audit the setup and configuration of the database itself, as well as an audit of operational items. Here are examples: System: OS version Physical/Logical volume layout. Is it local, SAN, NAS or something else? Backup hardware, software and capabilities. There can be OS specific sections: Unix: Oracle database owner. location of oratab NT: Domain: Failsafe in use? Details if so. Oracle: Have default passwords been changed? Who has DBA access? Who requires DBA access? Is Archiving on? If so, is it setup properly? Operational: OS monitoring, backup and deletion of archive logs? OS level monitoring in place. e.g. disk space, alert.log monitoring, sniped session monitor, etc. Backup/recovery tested? Documented? And lastly, a section with recommendations for all of the above. All comments, suggestions and recommendations are welcome. URL's to document(s) with a fair amount of this already in place are especially welcome, and will be rewarded with a virtual beer, or beverage of your choice. :) Or if I see you at IOUG, a real one. Thanks Jared -- 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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle's Pricing Change...
http://www.computerworld.com/storyba/0,4125,NAV47_STO61402,00.html Quote Every year, we lower our prices, and we sell more software, Ellison said. This is, in fact, a price reduction from [the power-unit model]. For some configurations, according to figures posted on Oracle's online store, the new per-processor scheme will cut prices by anywhere from 15% to 18% compared with the UPU approach. I thought that was the line when they introduced power-unit pricing ;) Margaret Murray Sr. Oracle DBA Hussey North Berwick 207-676-0330 or 207-676-2271 x330 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle's ftp site
Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Again
Sure am!! Can't search - AGAIN. For months now, the search and advanced buttons have not worked (I click on the button, the screen gets busy and 2-15 minutes later it refreshes - no change in the screen - ARG!). My solution has been to go into Forums and use the advanced search link there, but now it reports: "There are no Technical Forums available yet. Try again later or contact us." Anyone else have other work arounds to search?? Margaret Murray Sr. DBA Hussey Seating Company -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Metalink Again Is anyone else having problems with Metalink today? Todd Carlson Oracle 8i Certified DBA Bunge Corporation -- 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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).