RE: Financials and APPS password
April, Apart from the issues already pointed out, here are two more - 1. You basically have zero change control in production - anybody can log in with tthe APPS account and make any changes without prior approval or testing, and, even worse, without any audit trail. This obviously is a big no-no in any instance, let alone production. 2. From a Sarbannes-Oxley and auditors perspective, you will necessarily have to change the APPS password and keep it confidential. At Cummins, the APPS password for all instances is known only to the DBAs. Read-only accounts are available for DEV and QA instances, but not in Prod. All custom code is housed in custom schemas and all changes to QA and Prod must go thru Change Control. The Examine feature is only available in DEV and is turned on in QA or Prod at the User/Resp level only to troubleshoot specific issues. HTH Srini Chavali Oracle DBA Cummins Inc John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 11:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Financials and APPS password April, Mike is right, but this also allows users to use the 'Examine' feature without knowing the APPS password - they can then make *data* changes *directly* to the database - a very strict Oracle Support no-no and a bigger problem. The issue with using a Non-APPS user is that APPS uses a ton of stored procs/pkgs which work only when used as APPS - this includes packages that set and use the ORG Id. I developed an alternative of allowing a set of users and developers to get to traces without the APPS password by setting the Utilities:Diagnostics to Yes at Responsibility or User level rather than at the Database level. This way, you can both *limit* the number of people that can damage the system while still not giving out the APPS password. For the Senior Developers/Team leads/Support folks that *do* need the APPS password for sure, you can still build in a Database level DDL trigger that detects and records *any* DDL changes made. Use this to rap any knuckles connected to fingers that stray! Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Financials and APPS password I could be missing something here. If you set the profile option Utilities:Diagnostics to YES users are allowed to enable trace on a session without having to provied the APPS password. Cheers, Mike Hately -Original Message- Sent: 15 October 2003 14:29 To: Multiple recipients of list ORACLE-L April, We lost this battle with our developers - they have the password, along with strict instructions to behave. Nobody else should have the password to any of the schemas (APPS, GL, INV, etc.). We create logins for users that need them and grant the necessary rights to objects. As you know, APPS can do just about anything in the database, so you're asking for trouble if you let the whole company in there. Chances are you already have some objects in that schema like MICROSOFTDTPROPERTIES. Jay [EMAIL PROTECTED] 10/15/03 08:39AM Okay, anyone using Financials... E-Business suite... Oracle 11i... whatever you want to call it... I am trying to apply SOME kind of security to my databases. It appears that it is critical for everyone to be able to access production using the APPS id Finance and accounting people, developers, everyone. What does everyone else do in their setups? The newest reason is the need to run the new Mass Additions Trace which apparently requires that you use the apps id. We have found a way to set up any user with a read only version of what APPS has (since they have to be able to compile reports in production and access production data live rather than a month old clone), but Oracle says that you need to run Mass Additions Trace as apps. Does anyone let the entire company have the production apps user's password? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 *** * E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended
RE: Oracle9iR2 - temporary tablespace usage error
Mladen, It's not buggy - I have used it without any side effects on 8.1.6 and 8.1.7. Works as advertised - for a change ! Srini Chavali Oracle DBA Cummins Inc Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2003 10:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle9iR2 - temporary tablespace usage error You can always try DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL. I've never tried it, it might be buggy, but in theory, the procedure would go like this: 1) Create locally managed tablespace 2) Read the manual/ 3) Migrate the tablespace local - dictionary. 4) Start wondering why did you do it. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April Wells Sent: Friday, September 05, 2003 10:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle9iR2 - temporary tablespace usage error you can't have any dictionary managed tablespaces that are open for write operations... dictionary managed read only tablespaces will still work. I think you're right, temp isn't being freed up... or is something else using it, or is the index creation just that huge? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: laura pena [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: Oracle9iR2 - temporary tablespace usage error HI all, I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace. Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index: ERROR at line 1: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01 Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me): select tablespace_name, file_id,bytes_used,bytes_free from v$temp_space_header; SQL select tablespace_name,file_id,bytes_used,bytes_free 2 from v$temp_space_header; TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE -- -- -- -- TEMP01 2 2146435072 Thanks in advance. Lizz Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: V$LOCK definition
Note 223146.1 on MetaLink. HTH Srini Chavali Oracle DBA Cummins Inc Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/16/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:V$LOCK definition Folks, Question here, the CTIME column in V$LOCK is expressed in what? Seconds, milli-seconds, What?? Anyone know? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: discoverer 3i to 4i upgrade
Jeff, Not sure which version of 3i you are on, but we are using 3.1.36 and there is an option to save to file system. It can be enabled/disabled for individual users using the Admin version. HTH Srini Chavali Oracle DBA Cummins Inc Jeffrey Beckstrom [EMAIL PROTECTED]@fatcity.com on 01/30/2003 02:52:44 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: when we rolled out discoverer last year, we used the 3i version and not the 3.1 client/server version. Now planning upgrade to 4i. One step is to save the 3i workbooks prior to dropping the current EUL. Since 3i does not have a save to file system option, short of having to now roll-out the client server version, how can I save the current workbooks. Even if I wanted to save them myself I can't since would need to login as the workbooks owner. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- 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).
RE: ORA-1410 Silliness
Lisa, I am joining this thread late - so apologies if my suggestion has already been looked into ! The first error message is ORA-01001 (Invalid Cursor). There is an article on MetaLink (1007395.6) about the various causes for this error. Have you read this article and verified that the common causes in this note have been eliminated as a possible source of this error ? HTH Srini Chavali Oracle DBA Cummins Inc Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 12/31/2002 12:48:42 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of. SQL desc vegas_mart Name Null? Type - -- ID NOT NULL NUMBER(38) CONTRACT_NUMBER NOT NULL NUMBER(9) LOAD_JOB_ID NOT NULL NUMBER(12) JULIAN_RUN_DATE NOT NULL NUMBER(12) FAC_CODE VARCHAR2(1) OWNER_LAST_NAME VARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY VARCHAR2(18) OWNER_STATE VARCHAR2(2) OWNER_ZIP VARCHAR2(9) NET_PURCHASE_PRICE NUMBER(11,2) ORIGINAL_DOWN_PAYMENT NUMBER(11,2) TOTAL_DOWN_PAYMENT NUMBER(11,2) CR_BAL NUMBER(11,2) INTEREST_RATE NUMBER(5,2) FIRST_PAYMENT_DATE DATE QUALIFICATION_CODE VARCHAR2(1) PAYMENT_AMOUNT NUMBER(9,2) PAYMENT_FREQUENCY VARCHAR2(1) AGING_10_TO_30_DAYS_DUE NUMBER(9,2) AGING_31_TO_60_DAYS_DUE NUMBER(9,2) AGING_61_TO_90_DAYS_DUE NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP VARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT VARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALE VARCHAR2(1) UDI_SALE VARCHAR2(1) PHASE_NUMBER VARCHAR2(6) FAIRSHARE_PLUS_MEMBER VARCHAR2(1) POINTS_OWNED NUMBER(7) DEED_DATE DATE PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1) RESERVATION_CODE VARCHAR2(4) INTERNATIONAL_CODE VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE VARCHAR2(1) AGING_0_TO_90_DAYS_DUE NUMBER(9,2) AGING_91_TO_120_DAYS_DUE NUMBER(9,2) AGING_121_TO_150_DAYS_DUE NUMBER(9,2) AGING_151_OVER NUMBER(9,2) LOT_LOCATION VARCHAR2(12) PAYMENTS_MADE NUMBER(3) SUPPRESSION_CODE VARCHAR2(1) ACCRUED_INTEREST_BAL NUMBER(9,2) PAC_FREEZE_CODE VARCHAR2(1) CREDIT_CARD_FREEZE_CODE VARCHAR2(1) ASSOCIATION_NUMBER VARCHAR2(4) RFS_ASSIGNMENT_DATE DATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDING VARCHAR2(1) CREDIT_REPORTING_CODE VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE VARCHAR2(2) EQUITY_IN NUMBER(9,2) DATE_CODED_7 DATE ADJUSTABLE_RATE_MORTGAGE VARCHAR2(1) NUMBER_OF_PAYS_LEFT NUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTS NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS NUMBER(5) LAST_PAYMENT_DATE DATE NEXT_PAYMENT_DATE DATE PAC_DUE_DATE DATE EFT_ROUTING_NUMBER VARCHAR2(8) EFT_ACCOUNT_NUMBER VARCHAR2(30) EFT_MANUAL_NUMBER VARCHAR2(30) BANK VARCHAR2(35) STATUS_CHANGE_DATE DATE ASSIGNED_LOAN_REP VARCHAR2(2) CREDIT_CARD_PAC_ACCOUNT VARCHAR2
FAILED_LOGIN_ATTEMPTS
All, I have implemented FAILED_LOGIN_ATTEMPTS in one of my database profiles - and it works beautifully ! However - is there a way to trace or capture the incorrect password (and machine name) that trips this counter ? I am interested in finding out who (and from where) tried to connect unsuccessfully. TIA Srini Chavali Oracle DBA Cummins Inc -- 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: My TAR button disappeared from MetaLink
This usually happens if you have not paid your support bill. Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 07/12/2002 12:24:21 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember there being one there but my memory may be wrong... ??? I submitted MetaLink feedback. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: _tru64_directio_disabled param Value on Digital Tru64 Unix
Quote from a person who has had researched this thoroughly at our site - Oracle 8.1.6 and later releases check to see if they are running on Tru64 5.0a or later operating system revision.If so, the RDBMS automatically uses the directio mode to open the database files. Directio bypasses the operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT to DMT
Beth/Joan,
Pretty simple actually !
Just run dbms_space_admin.tablepsace_migrate_from_local
('tablespace_name') as system.
Does not take long to run !
HTH
Srini Chavali
Oracle DBA
Cummins Inc
Seefelt, Beth [EMAIL PROTECTED]@fatcity.com on 02/13/2002
03:53:36 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Sorry, I can't answer you're question, but I'm curious - why do you want
to revert back to DMT? Just for my own edification... since I'm in the
process of converting to LMT myself.
-Original Message-
Sent: Wednesday, February 13, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
How to convert the locally management tablespace back to dictionary
management tablespace? I used dbms_space_admin migrated all the
tablespaces to LMT. Now I want convert back on some tablespaces, I
remember I read the notes indicate step to step how to do this. Just
can't find it anymore. Could you please give me some light on this?
Another question I posted yesterday, but no replied so far. I post here
again. Thanks,
JOan
I am looking for a solution to zip all the backup files into one
backupset.zip file on NT. I have trouble to find the dos command line to
do this.(pkzip or winzip command line? should executed in a batch file
after backup) Can you share this info with us? This should be a very
easy thing to do. NT comand compact /C is not what I want. Thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: Seefelt, Beth
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: sniped sessions
To clean up the sniped sessions faster, you can also use the IMMEDIATE clause (new with 8i, I believe) in the ALTER SYSTEM KILL SESSION command. See docs for details. HTH Srini Chavali Oracle DBA Cummins Inc [EMAIL PROTECTED]@fatcity.com on 01/15/2002 02:05:23 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: appreciate you help guys.. -Original Message- Sent: Tuesday, January 15, 2002 9:06 AM To: Multiple recipients of list ORACLE-L Attached are the scripts we use to kill sniped sessions. This is part of a series of monitoring scripts we developed for our Oracle databases. The scripts are scheduled through Cron and run every 15 minutes. A logonid or an email address is passed to the scripts for either paging or email. In this case an accum of sniped sessions is maintained on a 'flat' file just so we can go back and check to see how many sniped sessions are being killed. I will attach a zip file. If that doesn't get through I will also list the scripts below. Ron Smith Kerr-McGee Corp SNIPED.SH #! /bin/sh # DBA MONITORING SCRIPTS # ** # # Author: Ron Smith # Date: 06/18/98 # Funtion:Checks for sessions that have been Sniped. # # ** # # CHANGE HISTORY # # DATEWHO Reason for Change # 03/03/00Ron Smith New Prog # # ** # # FUNCTION # # This script calls sniped.sql. # The function of this script is to report sessions that have # been sniped by Oracle through the use of resource limits. # # If the id of the DBA is a Zid, a page will be sent. If the # id of the DBA is an email address (determined by looking for # an @ ) , an EMAIL will be sent. # # ** # # PREREQUISITES # # The OPS$ORACLE user must exist in the instance. This can be # created by running the opsuer.sql script in SQLPLUS while # logged on as SYSTEM. # # The cdmonitoring script must exist in the home/oracle # directory. # # ** # # RUN SYNTAX # # sniped.sh (sid) (oncall dba) # # # ** # cd to the monitoring script directory . $HOME/cdmonitoring.sh ORACLE_SID=$1 export ORACLE_SID DBA=$2 export DBA echo $DBA ATCNT=`echo $DBA | grep @ | wc -l` export ATCNT ORACLE_HOME=`grep ^$ORACLE_SID: /etc/oratab | head -1 | cut -d: -f2` export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:. export PATH # Delete the old list file if it exists if [ -e sniped_$ORACLE_SID.lst ] then rm sniped_$ORACLE_SID.lst fi # Delete the old error file if it exists if [ -e sniped_$ORACLE_SID.err ] then rm sniped_$ORACLE_SID.err fi # Delete the old kill file if it exists if [ -e sniped_kill_$ORACLE_SID.sh ] then rm sniped_kill_$ORACLE_SID.sh fi # If sending to EMAIL address, run sql with headings on else run with headings off if [ $ATCNT -gt 0 ] then sqlplus / @sniped.sql on else sqlplus / @sniped.sql off fi # If there is anything in the lst file then kill the user processes and send a message if [ -s sniped_$ORACLE_SID.lst ] then cat sniped_$ORACLE_SID.lst sniped_accum.lst sqlplus / @sniped2.sql if [ -s sniped_kill_$ORACLE_SID.sh ] then chmod +x sniped_kill_$ORACLE_SID.sh; cat sniped_kill_$ORACLE_SID.sh sniped_kill_accum.lst ./sniped_kill_$ORACLE_SID.sh; fi echo -DBA- Sniped sessions killed sniped_$ORACLE_SID.err echo SID= $ORACLE_SIDsniped_$ORACLE_SID.err cat sniped_$ORACLE_SID.lst sniped_$ORACLE_SID.err if [ $ATCNT -gt 0 ] then echo email sent elm -s -DBA- $ORACLE_SID Sniped sessions exist $DBA sniped_$ORACLE_SID.err else LC=`cat sniped_$ORACLE_SID.lst | sed -e 's/ */ /g' | wc -c` echo $LC if [ $LC -gt 160 ] then echo Sniped sessions killed. Check sniped_$ORACLE_SID.lst sniped_$ORACLE_SID.err else cat sniped_$ORACLE_SID.lst sniped_$ORACLE_SID.err fi echo page sent pager $DBA `cat sniped_$ORACLE_SID.err` fi fi SNIPED.SQL set pause off SET ECHO off set verify off set feedback off set linesize 132 set heading 1 col User Name format a10; alter session set nls_date_format = 'dd-MON- hh24:mi:ss'; spool sniped_$ORACLE_SID.lst select s.username User Name, s.osuser OS User, s.status Status, s.logon_time Connect Time, p.spid, p.pid, si.sid from sys.v_$sess_io si, sys.v_
Re: VNI-2015 LInux server / winNT station / Linux server
Joe/Kim, It *is* a security risk. See Note 167001.1 on MetaLink. HTH Srini Chavali Oracle DBA Cummins Inc Joe Testa [EMAIL PROTECTED]@fatcity.com on 12/21/2001 07:00:17 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: well if it is owned by oracle then only oracle type jobs can be executed by the (un)intelligent agent), if you needed to run a job that needed privileges outside of oracle, it wont run, hence the reason it needed to be owned and setuid of root. is it a security risk, no doubt, would i run it on my prod machines, probably not but for development, i would. joe Kimberly Smith wrote: Well, if root is suppose to own it then how come when it was changed it to oracle it worked? I must say, I never looked but I installed the 9i OEM and did not run root.sh after and it still worked. Since I don't have root access I don't see how it could be owned by root. That was on HP. Just confused. -Original Message- Sent: Friday, December 21, 2001 1:35 PM To: Multiple recipients of list ORACLE-L because root is supposed to own it. root.sh sets it, last i checked, joe Kimberly Smith wrote: How did root end up owning it??? -Original Message- Sent: Friday, December 21, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/ a 85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe
Re: Off Topic: Australian Visa
Try http://www.immi.gov.au/ Srini Chavali Oracle DBA Cummins Inc Diego Cutrone [EMAIL PROTECTED]@fatcity.com on 12/04/2001 02:10:19 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sorry for the off-topic. I'm from Argentina, and I'm finding out what the steps I should follow to get a visa (for working) or may be a sponsor in Australia. (A friend of mine told me that Oracle proffesionals have a good chance of getting a job in this country) I hope that someone can help me (may be some Australian) by pointing me where should I be searching for an Australian Sponsor (something like www.dbajobs.com) or Jobs offers. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fixing a DB
Ken, I don't think you will need steps 2 thru 5. After step 1, just write sql that will spool out alter index blah rebuild tablespace new_tablspace run the resulting sql. Will that work ? HTH Srini Chavali Oracle DBA Cummins Inc Ken Janusz [EMAIL PROTECTED]@fatcity.com on 11/21/2001 08:25:34 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: We have a DB that is currently in more-or-less development mode for a state government client. The DB has been created (11,300 lines of SQL*Plus code) with the tables and indexes stored in the permanent tablespace (SOS2_TBLSPC). There is no separate tablespace for indexes. The DB currently holds test data. I think the process to correct this would be: 1. Determine the size, etc. of the INDEX tablespace, write the script and then run it to create the tablespace. 2. Go through the DDL SQL script for OKSOS (state gov. office name abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX tablespace name. 3. Then run the DDL SQL script to create the new DB. 4. Then do and Export of the data from the old DB and Import it into the new DB. 5. Then I think I have to regenerate your indexes. I'm not clear on this point. Will the Export/Import process may take care of this? Is there anything I have missed? I'm sure there is. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: applying patch 2032040 to Oracle Purchasing
Try clicking Technical Libraries, then Applications Install Upgrade under ERP Applications, then click Documentation link and viola ! HTH Srini Chavali Oracle DBA Cummins Inc Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on 11/21/2001 08:30:24 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I looked in metalink and maybe I'm just blind, but I don't find a 'Maintaining Oracle Applications' manual. URLs would be greatly apprecieated. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: applying patch 2032040 to Oracle Purchasing Matt, I think you should get to read the 'Maintaining Oracle Applications' manual - all the ad utilities are described therein. My understanding is that the install progress is recorded in the FND_INSTALL table and a restart will look up this and decipher what else needs to be done. As far as your error goes, the solution is to open an iTar and sit back until you get called... As I said before, Patching is the bane of an Apps DBA! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Tuesday, November 20, 2001 6:00 AM To: Multiple recipients of list ORACLE-L After applying the c.drv portion of the patch, I'm attempting to apply the d.drv portion of patch the patch above and adwork1 is failing applying the d.drv file. In the adwork1.log file I see, jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail -thin -user USERNAME/PASSSWORD@host:port:SID /opt/oracle/testappl/admin/test/out/p01ldjva.jar followed by a ton of ORA-03115 unsupported network/data/type or representation and ORA-29509 incorrectly formed Java binary class definition errors. I suspect that the file /opt/oracle/testappl/admin/test/out/p01ldjva.jar was taken from new xmlparserv2.zip file that is present in the patch. Being the relative newcomer at this, my question is what do I do now? It's already got part way through applying the d.drv file, which means (if i understand this correctly) that I cannot un-patch. I have to recover from the backup. What can I do to try to move this forward rather than recovering and starting over? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TNS Listener service question
Patrice, SqlPlus uses the Bequeath protocol to access local databases if the @ is omitted in the connect string. If the @ is present (i.e. connect scott/tiger@db) then it uses Net8. See Note 118381.1 on Metalink. HTH Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 11/21/2001 10:05:21 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I noticed that if I leave the TNS Listener service stopped on my NT workstation, I can't access anything using the GUI tools. But my script that runs command line can successfully login to the remote databases to verify that they are accessible. It uses c:\oracle\ora81\bin\sqlplus.exe. Do the command-line utilities bypass the NT TNSListener service? Just curious, I am leaving the service up now... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Odd Listener.ora Stanza
Ross, It's CORBA stuff. See note 69043.1 on Metalink. HTH Srini Chavali Oracle DBA Cummins Inc Mohan, Ross [EMAIL PROTECTED]@fatcity.com on 11/21/2001 10:15:27 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Anyone seen this fecality in their listener.ora? It's a new one on me, but then again, what with all the newfangled features in this here product, I am probably just losing track.. (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Discoverer on Citrix
Anybody successfully running the above combo without any major issues ? If so, what versions of Discoverer/Citrix/Oracle DB, what are your hardware specs and how many concurrent users ? TIA Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 11.5.5 on Tru64
Bambi, John is right ! You'll get better response to Apps questions on the Apps list. We have a 11.5.5 test instance (upgraded from 11.5.4) running on Compaq TRU64 4.0F. The upgrade was not pretty, but so far we have not found any major issues. Did you have any specific questions about 11.5.5/Compaq ? Srini Chavali Oracle DBA Cummins Inc John Kanagaraj [EMAIL PROTECTED]@fatcity.com on 10/29/2001 06:25:19 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Bambi, I think this will be better answered on the OAUGnet-DBA list at http://www.oaug.org http://www.oaug.org Sorry - you will have to monitor another list too! As for Tru64, I think it is on its way out. I don't know of anyone of 11.5.5 on Tru64. Btw, 'clean' and 'latest' don't go together, esp. in Apps 11i! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, October 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Hi Everybody! Is anyone running 11.5.5 on Tru64? Is it clean? What's this about a single Apache server? How do I even check to see how many Apache servers I have? TIA! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora_i201_SID process ?
What does the ora_i201_SID process do ? I just upgraded from 8.1.6.0.0 to 8.1.7.1 on Compaq TRU64 and found this process. I got no hits on tahiti.oracle.com or on Steve Adams' website. Just curious ! TIA Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle/Server Audit
Jared, Does this help ? http://www.auditnet.org/asapind.htm Srini Chavali Oracle DBA Cummins Inc [EMAIL PROTECTED]@fatcity.com on 09/24/2001 02:27:31 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: how to zip email?
Close, but no cigar ! It's an outlook export file extension. (Dunno if you were being sarcastic ;-)) Srini Gogala, Mladen [EMAIL PROTECTED]@fatcity.com on 09/17/2001 04:35:55 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Pacific Standard Time? -Original Message- From: Christopher Spence [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: OT: RE: how to zip email? Just create a PST, and then zip that. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 17, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Hi all, This is not an Oracle question, but thought peoele on this list might know: I saved many emails about Oracle, Unix in the Microsoft Outlook, and I like to send these information esle where. I'd like to know where are these emails stored in the local or network directory, so I can make a zip. (NT 4.0, Microsoft Outlook 97). Thank you! Andrea __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Concepts Manual
Try http://tahiti.oracle.com HTH Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 09/10/2001 03:20:49 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Am I blind, or did Oracle omit the Concepts Manual from http://docs.oracle.com? I am going to do a search in Technet. Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 to check in alert.log
Our scripts also look for Warn and Fail. HTH Srini Deshpande, Kirti [EMAIL PROTECTED]@fatcity.com on 09/05/2001 09:01:36 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I also add 'corrupt' in the list by Jared. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: what to check in alert.log Alex, Here's what I currently look for: At the begging of a line ORA or TNS Anywhere in the line 'crash' or 'recovery'; Sometimes generates more mail than I care for. :) Jared Hillman, Alex Alex.Hillman@usmint. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] treas.gov cc: Sent by:Subject: what to check in alert.log [EMAIL PROTECTED] 09/05/01 08:51 AM Please respond to ORACLE-L Any suggestions what to check for in alert.log besides ORA- ? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: negative value for buffer cache hit ratio
Kirti, Audrey, I was under the impression that negative numbers are caused by the numbers wrapping around i.e., the database has been up for a while and the statistics pile up and eventually exceed the defined format (e.g. value of 1000+ for a format of 9(3) - to use old COBOL representation !). Makes sense ? I have seen his before. If you bounce the database, all will be well ! Srini Chavali Oracle DBA Cummins Inc Deshpande, Kirti [EMAIL PROTECTED]@fatcity.com on 08/07/2001 01:13:52 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Andrey, I am not into cache hit ratios, but got curious about your negative value. So I casually searched Metalink for 'negative value for hit ratio'. And got a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread. You may want to check it out, there seems to be a new formula for hit ratio computation in 8i/9i. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: negative value for buffer cache hit ratio Dear gurus ! I have a negative value for buffer cache hit ratio in my DB which is up for some 4 months . Any ideas why ? Thanks in advance. SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) / 2 (SUM(DECODE(a.name,'consistent gets',value,0)) + 3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit ratio 4 FROM v$sysstat a; buffer cache hit ratio -- -52.99284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Applying Patchsets ? Learn This Parameter _SYSTEM_TRIG_ENABL
I was going thru the 8.1.7 install manual and this is documented in it. FYI Srini Chavali Oracle DBA Cummins Inc Christopher Spence [EMAIL PROTECTED]@fatcity.com on 08/06/2001 01:21:43 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Much thanks for sharing this with us. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, August 06, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Last Thursday I attempted to take apply the 8.1.6.3 patchset on top of a small 8.1.6.0 database. I had done this many times before; the four hours I alloted to backing up the system and applying the patch were an hour more than I needed. The patch installed without incident, but when I ran catalog.sql it hung. I checked v$session_wait, but for some reason didn't check the alert log which would have told me what was wrong. Time was running out. I called Oracle told them my problem. Explained that this was a downed production database, but the call screener made it priority 2. I called the analyst and kept on getting a message saying he was either on the phone or simply gone. I did not know the screener had made it a priority 2 problem, and thought, Perhaps he was on the phone discussing the problem. My phone began to ring off the hook with people asking, Where's the database? I had backed up all the software as well as the database files. I began the restore saying to replace all the files. However when the restore go to an uneeded file, one of the .aud files in rdbms/audit, it hung. I needed to resintall the software from CD. The database base was recovered without incident. A few hours after it had been promised but unpatched. What was the problem? I use triggers on such system events as servererror to send pages and record informatiuon in a log table. These triggers can interfere with the running of scripts such as catalog.ora. The solution is to set the initilization parameter _SYSTEM_TRIG_ENABLED to false during an upgrade. My fun for the week was not over. This weekend we moved a large number of servers to a new UPS including all the Oracle servers. When I attempted to bring up the main database, a cannot stat file message was received. I called the sysadmin who had brought up the system. He said the file system was gone. I explained that it was there when the system was shutdown the night before. He asked for details so that he could recreate it. Luckily a more senior sysadmin looked at the problem and found that the raid configuration had a mismatch on which controller was assigned to the file system, straigtened that out, and the database came up without incident. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Brain dead Friday question
Folks, How can I determine rowids of rows locked by a given SID using V$ or DBA* or X$ views ? Can't think anymore today :-) DB Version is 8.1.6. TIA Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tracing
Ivo, See Metalink Note 1058210.6 for more details on ORADEBUG. HTH Srini Chavali Oracle DBA Cummins Inc Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 07/16/2001 09:45:36 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to implement and use DBMS_STATS?
Steve,
Good stuff !
What's the overhead incurred in monitoring the tables ? Is that
quantifiable ?
The reason I ask is because I am currently gathering statistics weekly on
all tables, but would much rather use the monitoring/stale route. I assume
that the overhead would be less than gathering stats for all tables.
TIA
Srini Chavali
Oracle DBA
Cummins Inc
Orr, Steve [EMAIL PROTECTED]@fatcity.com on 07/06/2001 02:42:03 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
OK, here's an excerpt from our DBA Cookbook
Optimizer Statistics
We are using the cost-based optimizer for our implementation so it is
important that we keep optimizer statistics up-to-date. But computing these
statistics can be very resource intensive requiring lots of CPU and a
tablespace for temporary sorts of up to 1.25 times the size of the largest
table being analyzed. To minimize resource usage we use the new DBMS_STATS
Oracle supplied package.
Here are the steps:
1. First we gather complete statistics on a schema:
SQL execute DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA', -
null,null,null,null,null,TRUE);
2. Next we alter the tables to implement statistical monitoring:
SQL alter table SCHEMANAME.TBLNAME monitoring;
3. Finally, on a periodic basis, we refresh the statistics. The first two
steps above only need to be done once after database/schema creation. The
following step should be performed periodically or as needed:
SQL execute DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA', -
null,FALSE, 'FOR ALL COLUMNS SIZE 1',null,'DEFAULT', -
TRUE,null,null,'GATHER STALE');
By putting the tables in monitor mode, Oracle tracks statistical changes
whenever any DML is executed. If data changes are such that it could affect
optimization, Oracle marks the table or index as stale. When we perform
step 3 above, we are only recomputing statistics on the objects that need
it. This saves computing resource in a 24X7 environment. For more
information see the Automated Statistics Gathering section of the Oracle
Tuning manual. Also, reference the Oracle packages documentation for
information on DBMS_STATS.
Here's some sample contents of a cron job script:
#!/usr/bin/ksh
# File:getstats.sh, Steve Orr, 5/21/01
# Purpose: Oracle maintenance, recompute stats.
# Usage: getstats.sh SCHEMA_OWNER_NAME
. /usr/bin/dbaenv
LOGFILE=$LOGDIR/stats.log
if [ $1 ]
then DASCHEMA=$1
else echo You must supply an argument for the schema.
exit 1
fi
echo Calculating statistics, please wait...
getstats()
{
echo ---
echo `date` -- Compute Stats.
ORACLE_SID=WHATEVER;export ORACLE_SID
sqlplus -s internal/oracle or whatever user/pw EOSQL
execute DBMS_STATS.GATHER_SCHEMA_STATS( -
ownname= '$DASCHEMA' , -
method_opt = 'FOR ALL INDEXED COLUMNS SIZE 64' , -
cascade= TRUE , -
options= 'GATHER STALE' ) ;
exit;
EOSQL
echo `date` -- Done recomputing stats on $DASCHEMA
}
getstats | tee $LOGFILE
Well, that should get you started,
Steve Orr
-Original Message-
Sent: Friday, July 06, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
OK, enough is enough. For a month now, I've been researching on how one is
supposed to implement and use the DBMS_STATS package. The FMs I R'd,
Oracle
8.1.7's Designing and Tuning for Performance and Supplied PL/SQL
Packages
Reference, give the syntax and some very weak and incomplete examples, but
fail to define how a DBA is actually supposed to USE the package in
day-to-day operation.
And Oracle Support just keeps pointing me back to inane and unrelated
articles in MetaClink.
Can anyone point out a website or a good book with a chapter on using
DBMS_STATS for CBO? Specifically, some good examples, some definitions
(when are stats considered stale?), what is the scope of
GATHER_DATABASE_STATS (does it stat SYS???), under what circumstances
GATHER_TABLE, GATHER_SCHEMA, and GATHER_DATABASE are to be used, and
generally how the hell one goes about implementing this. I've now got less
than two weeks to figure it out!
And if you know this, where did you learn it? Even my Oracle Perf Tuning
Class student guide mentions the package, says to use it, but then points
to
the syntax-only Oracle docs for more info. sigh
Frustratedly yours,
Rich Jesse System/Database Administrator
(wannabe?)
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
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
SOLVED !!! - RE: Need help tuning FTS
All, Thanks for your help - the issue is now resolved. The culprit was not the 3 million row table but the smaller table (CECO_INTERFACE_KEYS). The selectivity of the PK index on this table in prod was very poor (the PK has 3 columns whereas the select is using just the first column) and the result was almost like a cartesian product. The selectivity is much much better in our QA instance (the data is slightly older) and hence the process runs much faster. We solved it by creating another index with better selectivity and ran the process in under two minutes in prod. Thanks again ! Srini Chavali Oracle DBA Cummins Inc Mohammad Rafiq [EMAIL PROTECTED]@fatcity.com on 06/07/2001 01:37:45 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Can you compare indexes on both the boxes for tables involved... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 06 Jun 2001 13:07:29 -0800 Yosi, Thanks for your input ! No, there is no reference to a sequence. The offending statement is SELECT SUBSTR(INTERFACE_LINE_ATTRIBUTE6,1,LENGTH(INTERFACE_LINE_ATTRIBUTE6)-4), SUBSTR(INTERFACE_LINE_ATTRIBUTE7,1,LENGTH(INTERFACE_LINE_ATTRIBUTE7)-4), LTRIM( TO_CHAR( RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT, 'S0.999')), RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE14 FROM AR.RA_CUSTOMER_TRX_LINES_ALL, FNDC.CECO_INTERFACE_KEYS WHERE RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE14 = 'ADJUSTMENT' AND SUBSTR(INTERFACE_LINE_ATTRIBUTE6,1,LENGTH(INTERFACE_LINE_ATTRIBUTE6)-4) = CECO_INTERFACE_KEYS.ATTRIBUTE1 AND SUBSTR(INTERFACE_LINE_ATTRIBUTE7,1,LENGTH(INTERFACE_LINE_ATTRIBUTE7)-4) = CECO_INTERFACE_KEYS.ATTRIBUTE2 AND INTERFACE_PGM_NAME = 'CEP-SUBLEDGER' AND STATUS = 'PENDING_ENGINE_INFORMATION_CREATION' [EMAIL PROTECTED]@fatcity.com on 06/06/2001 02:47:28 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Wild guess, way out of left field, is there a sequence in the select statement, that might have a high cache value in QA, but a low cache value in prod? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Subject: Need help tuning FTS All, I need some help in tuning a select statement that performs a FTS. (The FTS is deliberate !) It takes over 5 hours to run in our prod instance, but takes less than 10 min in our QA instance. The QA instance was copied from prod about 6 weeks ago and is identical to prod, except for db_block_buffers whose value is 2 in prod and 15000 in QA. The instances run on identical hardware (Compaq TRU 64, 8 Gig RAM 8 cpus). The table in question has 3 million rows in prod and 2.8 million rows in QA. Explain plans are identical. DB version in both is 8.1.6.0 and both are using RBO. While running in prod, I took a level 12 trace and here is a snippet form the trace file - WAIT #1: nam='latch free' ela= 2 p1=17190174328 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190304728 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189692728 p2=66 p3=0 WAIT #1: nam='dbfile scattered read' ela= 1 p1=12 p2=266267 p3=16 WAIT #1: nam='latch free' ela=2 p1=17189819928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 27 p1=17190272728 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 0 p1=12 p2=266269 p3=15 WAIT #1: nam='latch free' ela= 3 p1=17189935928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189917528 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 5 p1=12 p2=266804 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266820 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266836 p3=16 WAIT #1: nam='db file scattered read' ela= 4 p1=12 p2=266852 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266868 p3=16 WAIT #1: nam='latch free' ela= 5 p1=17190273528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190310328 p2=66 p3=0 WAIT #1: nam='latch free' ela=1 p1=17189831128 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 3 p1=17190166328 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266884 p3=16 WAIT #1: nam='db file scattered read' ela= 3 p1=12 p2=266900 p3=16 WAIT #1: nam='latch free' ela= 2 p1=17190259928 p2=66 p3=0 I see a lot of time is spent in waiting for latch #66 (cache buffer chains) - Metalink states that this could be because of a *very* hot block being accessed frequently, further snooping (via x$bh) shows that there is no such contention. Can
RE: Need help tuning FTS
Yosi, Thanks for your input ! No, there is no reference to a sequence. The offending statement is SELECT SUBSTR(INTERFACE_LINE_ATTRIBUTE6,1,LENGTH(INTERFACE_LINE_ATTRIBUTE6)-4), SUBSTR(INTERFACE_LINE_ATTRIBUTE7,1,LENGTH(INTERFACE_LINE_ATTRIBUTE7)-4), LTRIM( TO_CHAR( RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT, 'S0.999')), RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE14 FROM AR.RA_CUSTOMER_TRX_LINES_ALL, FNDC.CECO_INTERFACE_KEYS WHERE RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE14 = 'ADJUSTMENT' AND SUBSTR(INTERFACE_LINE_ATTRIBUTE6,1,LENGTH(INTERFACE_LINE_ATTRIBUTE6)-4) = CECO_INTERFACE_KEYS.ATTRIBUTE1 AND SUBSTR(INTERFACE_LINE_ATTRIBUTE7,1,LENGTH(INTERFACE_LINE_ATTRIBUTE7)-4) = CECO_INTERFACE_KEYS.ATTRIBUTE2 AND INTERFACE_PGM_NAME = 'CEP-SUBLEDGER' AND STATUS = 'PENDING_ENGINE_INFORMATION_CREATION' [EMAIL PROTECTED]@fatcity.com on 06/06/2001 02:47:28 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Wild guess, way out of left field, is there a sequence in the select statement, that might have a high cache value in QA, but a low cache value in prod? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Subject: Need help tuning FTS All, I need some help in tuning a select statement that performs a FTS. (The FTS is deliberate !) It takes over 5 hours to run in our prod instance, but takes less than 10 min in our QA instance. The QA instance was copied from prod about 6 weeks ago and is identical to prod, except for db_block_buffers whose value is 2 in prod and 15000 in QA. The instances run on identical hardware (Compaq TRU 64, 8 Gig RAM 8 cpus). The table in question has 3 million rows in prod and 2.8 million rows in QA. Explain plans are identical. DB version in both is 8.1.6.0 and both are using RBO. While running in prod, I took a level 12 trace and here is a snippet form the trace file - WAIT #1: nam='latch free' ela= 2 p1=17190174328 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190304728 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189692728 p2=66 p3=0 WAIT #1: nam='dbfile scattered read' ela= 1 p1=12 p2=266267 p3=16 WAIT #1: nam='latch free' ela=2 p1=17189819928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 27 p1=17190272728 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 0 p1=12 p2=266269 p3=15 WAIT #1: nam='latch free' ela= 3 p1=17189935928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189917528 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 5 p1=12 p2=266804 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266820 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266836 p3=16 WAIT #1: nam='db file scattered read' ela= 4 p1=12 p2=266852 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266868 p3=16 WAIT #1: nam='latch free' ela= 5 p1=17190273528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190310328 p2=66 p3=0 WAIT #1: nam='latch free' ela=1 p1=17189831128 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 3 p1=17190166328 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266884 p3=16 WAIT #1: nam='db file scattered read' ela= 3 p1=12 p2=266900 p3=16 WAIT #1: nam='latch free' ela= 2 p1=17190259928 p2=66 p3=0 I see a lot of time is spent in waiting for latch #66 (cache buffer chains) - Metalink states that this could be because of a *very* hot block being accessed frequently, further snooping (via x$bh) shows that there is no such contention. Can anybody help ? Thanks much ! Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Need help tuning FTS
Chris, Thanks for your input ! One difference between our prod and QA instances is that the QA instance is relatively idle - while average load on the prod instance is about 175 users, with less than 5% hitting the database hard at any given point in time. I am unable to figue out why there is such a big difference in the times between the two instances. The explain plan in both instances is pretty straightforward - SELECT STATEMENT Optimizer=RULE NESTED LOOPS TABLE ACCESS (FULL) OF 'RA_CUSTOMER_TRX_LINES_ALL' TABLE ACCESS (BY INDEX ROWID) OF 'CECO_INTERFACE_KEYS' INDEX (RANGE SCAN) OF 'CECO_INTERFACE_KEYS_PK' (UNIQUE) Srini PS - You are correct in stating that the default value of _DB_BLOCK_HASH_LATCHES is 1024 for values of DB_BLOCK_BUFFERS between 2000 and some higher number ( I think in the region of 13). My understanding about _DB_BLOCK_HASH_BUCKETS in 8.1.6 is that the default value is twice the number of DB_BLOCK_BUFFERS. Christopher Spence [EMAIL PROTECTED]@fatcity.com on 06/06/2001 03:03:17 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I would recommend uping the parameter _DB_BLOCK_HASH_LATCHES by default after I believe 2000 block buffers, it defaults to 1024 all the way up to 10 blocks buffers if i remember correctly. This will generate alot of the #66 latch contention. This shouldn't equate to 6 hours compared to 10 minutes, but would certainly slow it down a bit. Most databases with more than 2,000 block buffers should probably increase this parameter or the other parameter _db_block_hash_buckets. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, June 06, 2001 2:47 PM To: Multiple recipients of list ORACLE-L All, I need some help in tuning a select statement that performs a FTS. (The FTS is deliberate !) It takes over 5 hours to run in our prod instance, but takes less than 10 min in our QA instance. The QA instance was copied from prod about 6 weeks ago and is identical to prod, except for db_block_buffers whose value is 2 in prod and 15000 in QA. The instances run on identical hardware (Compaq TRU 64, 8 Gig RAM 8 cpus). The table in question has 3 million rows in prod and 2.8 million rows in QA. Explain plans are identical. DB version in both is 8.1.6.0 and both are using RBO. While running in prod, I took a level 12 trace and here is a snippet form the trace file - WAIT #1: nam='latch free' ela= 2 p1=17190174328 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190304728 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189692728 p2=66 p3=0 WAIT #1: nam='dbfile scattered read' ela= 1 p1=12 p2=266267 p3=16 WAIT #1: nam='latch free' ela=2 p1=17189819928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 27 p1=17190272728 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 0 p1=12 p2=266269 p3=15 WAIT #1: nam='latch free' ela= 3 p1=17189935928 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189917528 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 5 p1=12 p2=266804 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266820 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266836 p3=16 WAIT #1: nam='db file scattered read' ela= 4 p1=12 p2=266852 p3=16 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266868 p3=16 WAIT #1: nam='latch free' ela= 5 p1=17190273528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17190310328 p2=66 p3=0 WAIT #1: nam='latch free' ela=1 p1=17189831128 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 2 p1=17189801528 p2=66 p3=0 WAIT #1: nam='latch free' ela= 3 p1=17190166328 p2=66 p3=0 WAIT #1: nam='db file scattered read' ela= 1 p1=12 p2=266884 p3=16 WAIT #1: nam='db file scattered read' ela= 3 p1=12 p2=266900 p3=16 WAIT #1: nam='latch free' ela= 2 p1=17190259928 p2=66 p3=0 I see a lot of time is spent in waiting for latch #66 (cache buffer chains) - Metalink states that this could be because of a *very* hot block being accessed frequently, further snooping (via x$bh) shows that there is no such contention. Can anybody help ? Thanks much ! Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Need help tuning FTS
John, Thanks for your input ! Unfortunately, this issue seems too weird ! (I know, I know, I shouldn't be saying that as a DBA !!). We have run that process three times today in prod in an effort to try and isolate the issue. We have run it when only one other user was hitting the prod database heavily using a select stmt on unrelated tables - but the problem still persists. There were no concurrent requests running at the time. The issue does not seem to be related to contention of resources. I have tried to figure out what the hot blocks are (via x$bh) but have come up empty-handed. I replied to Chris Spence's suggestions where I posted the query the explain plan - they look pretty simple. I'm trying to figure out why this behavior is not evidenced in QA. Any help would be appreciated !! I will post a solution/cause when I crack this case ! Thanks ! Srini John Kanagaraj [EMAIL PROTECTED]@fatcity.com on 06/06/2001 05:47:24 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Srini, I am sure you have lots of users in Prod compared to QA :) Anyway, the point is that you are suffering from hot block contention which reflects itself in latch waits on 'cache buffer chain'. I remember that Steve Adams has a SQL at his site that identifies blocks that are 'hot' - I have used a modified version of that to identify objects that are hot. If I know that there are corresponding Conc. Manager jobs that are accessing that part of the Apps, then I know that this is due to contending reports I have managed to reduce this by rebuilding stale indexes as heavy inserts/updates/deletes also add to this. Short of re-scheduling jobs and playing around with _DB_BLOCK_HASH_LATCHES, I don't see any solutions. Do post us if you manage to reduce contention using the _ parameter as we have a similar problem. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bumper Stickers [Re: Bumoer Stickers [RE: Rebuilding indexes]]
My two favorites - 1. My karma ran over my dogma. 2. Save wildlife - party naked. Srini Chavali Oracle DBA Cummins Inc Jim Hawkins [EMAIL PROTECTED]@fatcity.com on 06/01/2001 03:33:11 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: My bumper sticker: If you make it idiot-proof, they will build a better idiot. (Note: can be paraphrased with the word developer) Jim It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT Don't forget HELP - Kirti -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rebuilding indexes On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: I don;t quite understand you quoting Once the indexes have all been rebuilt nologging into the original tablespace, all that's left is to refresh the datafiles for that tablespace onto the primary. Is primary a typo error (i.e. standby)? Argh! It was a typo. Of course, after doing many unrecoverable operations, you should refresh the affected datafiles from the primary to the standby. Vadim Gorbounov mentioned the column 'unrecoverable_change#' in v$datafile. This looks like an SCN, not a count of unrecoverable changes. Either way, it seems like a useful way to decide if a datafile shoule be refreshed onto the standby. I can even imagine improving a standby log applier that could be made to refresh such files from the primary automatically. On another topic, I believe I qualify for some sort of award as uber geek. This week I obtained the Washington State license plate ORA DBA for my '74 Volvo. It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-6508 using Citrix/NT2000, Forms 6.0.8
Oweson, Check MetaLink for Doc # 1626.997. It might help ! Srini Chavali Oracle DBA Cummins Inc Oweson Flynn [EMAIL PROTECTED]@fatcity.com on 05/03/2001 10:51:12 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, (I apologise for cross-posting, but we are totally stuck ...) Our Environment: Oracle 7.3.4 database (on Solaris) Forms 6.0.8 Citrix 1.8 Metaframe (on Win NT/2000 sp1) We get 'ORA-06508 PL/SQL: could not find program unit being called' errors on a regular basis recently. We are trying very hard to isolate the cause, without much luck. We cannot re-produce the error consistently, and cannot cause it to happen on demand - it seems to happen at random. We have checked - all stored program units (in the database) are valid and accessible. It has only been happening (or at least, it has only been noticed), since we upgraded to Developer/6 and Citrix 1.8. (At least the upgrade to Oracle 8 hasn't happened yet, so IT can't be blamed ...) We THINK that it only seems to happen when in a Citrix session - nobody can recall it occurring using a 'direct' connection. It happens in various forms, and other users can use those forms simultaneously, without an error occurring. We have been investigating things like the timeouts, memory leaks (in Citrix) but without luck. We logged a TAR, but as we can't give them a reproducible case, they have closed it. Citrix say it's an Oracle problem. Microsoft say 'change to SQL Server' (just joking ...) Anybody got any ideas / had a similar experience? Regards Oweson Flynn -- Certifiable - Oracle DBA Developer The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Services and Oracle Startup - WIN2000
Works fine with ftp://oracle-ftp.us.oracle.com HTH Srini Chavali Oracle DBA Cummins Inc Apps Sol [EMAIL PROTECTED]@fatcity.com on 04/02/2001 12:37:06 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: trying to connect to the oracle ftp site for bugs and it's giving me a timeout.. using this address 203.227.44.220 . is this the right none ..? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02, 2001 12:20 PM It's a bug. Refer to note 132086.1 on Metalink. -Original Message- Sent: Monday, April 02, 2001 10:31 AM To: Multiple recipients of list ORACLE-L I have this small situaltion I try to start my database from command line in win2k , I get the following error C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-12560: TNS:protocol adapter error SVRMGR exit Server Manager complete. C:\ But , If I go to services and start the service for starting the database I get this C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR select * from v$database; select * from v$database * ORA-01034: ORACLE not available But If I do a startup from command line in win2000 it's starts and looks perfect . SVRMGR SVRMGR startup ORACLE instance started. Total System Global Area419173644 bytes Fixed Size 70924 bytes Variable Size 110940160 bytes Database Buffers308084736 bytes Redo Buffers77824 bytes Database mounted. Database opened. SVRMGR SVRMGR exit Server Manager complete. Any ideas why it's doing this. I have all my required varibles set in my system. Rk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why can't I find bug 909635 ?
Cherie, This in itself is a bug ! I asked the same question at an Oracle education class about 18 months ago and was told that the default visibility when creating an entry in the bug database is "internal" - i.e. not visible outside of Oracle. Analysts have been asked to set visibility to global when logging bugs in the database, but if they forget to do so, you will not be able to search for it. I cannot understand why the visibility cannot be changed after the bug is created as "internal". Go figure ! HTH Srini Chavali Oracle DBA Cummins Inc [EMAIL PROTECTED]@fatcity.com on 03/19/2001 08:50:22 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I have an error on an 8.1.5 export/import. Metalink shows a reference to bug 909635. When I search the bug database putting the bug number 909635 in the bug number field and pressing search, the search engine replies that there were no hits. How can this be? If a bug is identified in the knowledge base, it must exist and be searchable in the bug database. Sometimes I get so frustrated with Metalink. We pay so many hundreds of thousands of dollars for support and I can't even search Metalink, much less get a person to tell me the answers to questions that I have. Can anyone tell me what I might be doing wrong or forward any information on this bug to me? Thanks, Cherie Machler Gelco Information Network "djordjej" [EMAIL PROTECTED]@fatcity.com on 03/19/2001 07:26:34 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Here is the document from Metalink regading this error: HTH. Djordje * Doc ID: Note:49946.1 Subject: OERR: ORA 27072 skgfdisp: I/O error Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 21-NOV-1997 Last Revision Date: 08-JUN-1999 Language: USAENG Error: ORA-27072 Text: skgfdisp: I/O error --- Cause: read/write/readv/writev system call returned error, additional information indicates starting block number of I/O Action: check errno *** Important: The notes below are for experienced users - See [NOTE:22080.1] Explanation: This error was introduced in Oracle8. The error is raised in port specific code so the exact system calls preceeding the error can vary between platforms. The error indicates that a read or write call either: a) returned an error or b) returned a value indicating that the number of bytes read/written does not match the number of bytes we asked to read/write Hence the error number reported may or may not be meaningful. If the read/write returned an error then the ERRNO reported corresponds to the actual read/write call used. If the read/write returned a different number of bytes to that expected then ERRNO is just the left over error from some previous system call and should be ignored. Additional information is the first BLOCK NUMBER being read/written in the named file. Diagnosis: 1. 2Gb limits (or other limits) can cause this sort of error so check if the filename reported in the corresponding error is a large file. The block number in the additional information can help show if you are close to this limit. 2. It is helpful to know the system call which caused the error so exact version information is important. If the error is repeatable at will then TRUSS or similar may help identify the call raising the error. 3. Determine if the file/s are on raw devices / logical raw volumes or file system files. References / Known Bugs etc.. ~ There are several known issues that can cause this error, plus it can be a non-Oracle problem so it is important to collect all the information: 2Gb or not 2Gb - file limits in Oracle [NOTE:62427.1] See the above article as an anchor point for 2Gb issues on various platforms. Eg: Solaris 2Gb issue [BUG:774252] Backup of RAW controlfile[NOTE:60953.1] Sequent AIO issue[NOTE:64632.1] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 19, 2001 3:05 AM Hello All, J ust now i got a error select count(*) from s_org_ext. SQLWKS select c
Re:RE: RE: Oracle DBA evolution path - please share your opi
Amen !! [EMAIL PROTECTED]@fatcity.com on 03/16/2001 10:26:43 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Jacques, First things first, DON'T TAKE THIS PERSONAL. I am not trying to brow beat anyone, just venting a common problem I have with third party software applications. I've had a couple interactions with Quest which for the most part have been uneventful. Over the last 5 years I've had run-ins with a lot of third party applications, like PeopleSoft, Support Magic, Etrade, and now CoCreate. To say the least they all have NOT been pleasant, actually some are down right too painful and really get my blood pressure up. Around here we build a lot of software for in house use I have always mandated that the applications "behave" themselves as users, not abusers of the database. That means in a nutshell that they are clients of MY database and no developer can expect more than that. They get one or more tablespaces as the two of us jointly decide and some public privileges, like "create public synonym". Note they do not get "drop public synonym". The application is also not created to be platform specific from a database view. In other words they can be installed into a database on any platform so long as we can access the required client tools. Today's install may be on Unix from an NT client, tomorrow's could be in reverse. Keep it generic simple. This I know is not the case at all third party shops, actually I've talked to an Oracle DBA at Support Magic who was informed by the CTO that he could either "do as the developers want or clean out your desk". I've also had the unpleasant experience of talking to one of those developers. At the end of the conversation, if you want to call it that it was more of a lecture from his end, I informed him I wanted to know when his funeral was and was hoping it would be sooner(like tomorrow) vs. later. Why? you'll ask. The reason was that according to this particular duhveloper all of the database instance was his to manipulate as he desired without regards for the consequences. I quote: "Recovery of a failed database is your task, not mine. And if I did something that makes that task harder on you that it should, tough s^t". Not an attitude that I appreciate, but then I did not appreciate the sales person either when he said "if you don't like our installation method, go somewhere else. I've other things to do." An attitude that was recently featured in ComputerWorld saying that many software vendors see a sale as a one off item or as the author put it "a drive by sale". You know, something like a "drive by shooting". One other reason that has been raised is that the "application was ported from name of a data management scheme". In this case you can replace the with either AllBase, Xbase, flat files, etc In any case porting is in my mind a VERY poor excuse for a bad DB implementation. Lets face facts, we're buying the software from you because we can't/don't want to create it or try re-inventing your wheel. Therefore I expect that a good DB development job was done. Lets just say that those expectations have been very heavily dashed. Also, I recently (like a month ago) rejected a job offer at a third party shop mainly because they did not feel it was their place to consider how those who support the product look at it. Now I understand that some shops work on the premise that "the client will not have a trained Oracle staff". All well and good, yes it would be good in these cases to have the appropriate scripts in hand to handle that, but if they have why "impose" your views on the in place folks. Give them the system requirements (Tablespaces, Names, sizes) get out of Dodge. Why does this rattle my cage so badly, Lets look at some of that CoCreate recently (like two weeks ago) did: First they asked that I run orainst let it create the basic database. OK then they went in created some tablespaces on their own as follows: TABLESPACE_NAME FILE_NAME ALLOCATED FREE_BYTES --- -- -- RBS_HP_DMS /users/cocreate/database/wm_rbs_.dat 2 1 ROLLBACK_SEGS /ora2/roll01.dbf100 92 SYSTEM /ora2/system01.dbf 100 58 TEMP/ora2/temp.dbf 150 150 TOOLS /ora2/tools.dbf 15 15 USERS /ora2/users01.dbf75 75 WM_ARCHIVEFS/users/cocreate/database/wm_arch_.dat12 12 WM_CLASSINFOS /users/cocreate/database/wm_eles_.dat24 24 - /users/cocreate/database/wm_erels_.dat 24 23 - /users/cocreate/database/wm_files_.dat 20 20 -
