Performance Tuning on RAC with Digital Unix
We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3 Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Select from Long Datatype Field to INSERT into a Varchar2 Datatype Field
Qs How is Select of Data from a Long Datatype Field to INSERT into a Varchar2 Datatype Field in another Table possible ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database Analyst Tasks
Hi all! Can you guys, clear me up about what are the tasks of a database analyst. I mean something like a job description. I know they are likely to be different from case to case but just to make an ideea. Thanks in advance. Iulian Ilies ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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).
ANALYZE question
Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (memes) not making much headway with critiquing elitist dba
DBO, its not about a smell. On 23 Jul 2002 at 10:28, Mercadante, Thomas F wrote: ... (you lost me at hallo) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shutdown abort / startup restrict / shutdown vs. shutdown imm
long response My opinion that shutdown abort is totally safe is based on this: The only thing that matters in the database is redo logs. Everything else is optional - ie it could be recovered albeit with difficulty (eg you can recreate a controlfile from scratch if you really have to, and datafiles can be recovered as long as you have all of the required redo stream). In fact, datafiles themselves can be thought of as simply performance enhancement - ie you could (theoretically) run all your queries by trawling through all the redo that has even been recorded in the db; the datafiles simply are an aid to improve the performance of this. And redo log operations are synchronous and atomic from Oracle's perspective - something is either in them or its not, there is no maybe. shutdown abort has no bearing on the synchronicity of redo operations and hence is totally safe... ...BUT...does this mean 'abort' mode should be for every shutdown - well this depends on your circumstances. Most cluster software will deem 'shutdown abort' as catastrophic and invoke all sorts of failover routines - so maybe abort is not the way to go in these cases. Similarly, the cold backups around a db upgrade should not be done via shutdown abort, because those redo logs (which are so critical) might undergo a structure change. So my 'mandate' (for lack of a better term) is for those rare occasions when you actually need to shutdown a database, you should issue a checkpoint, then a shutdown abort hth connor --- kkennedy [EMAIL PROTECTED] wrote: I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site is significantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than I've been doing this for years and it has always worked? Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 23, 2002 4:04 PM To: Multiple recipients of list ORACLE-L imm I would have to agree with Rich ... For years I have been using startup force restrict, shutdown normal prior to cold backups with the assumption that I want a completely 'static' and normal shutdown prior to the backup. Because of applications that maintain persistent connections, daemons that re-connect, etc. etc. that do not 'let loose' of the database . I have on numerous occasions had shutdown immediate 'hang'. I believe the operative process is the startup force restrict that enables auto-recovery and then the normal shutdown. I have never had an subsequent problems. Why chance any anomalous conditions that could be introduced to the recovery process or rebuild of a database. -Original Message- Rich Sent: Tuesday, July 23, 2002 1:21 PM To: Multiple recipients of list ORACLE-L imm You are assuming that shutdown immediate is a fix amount of time. If there is a lot to rollback it may take longer to rollback (via shutdown immediate) than the parallel crash recovery (the startup after a shutdown abort). It depends on the system. The question was why is immediate better than abort? I wanted to challenge the assumption that it is not safe to do an abort. You are relying on Oracle's recovery mechanisms which I have to assume are reliable. It is after all one of the reasons I prefer Oracle. - Rich -Original Message- Sent: Tuesday, July 23, 2002 3:34 PM To: Multiple recipients of list ORACLE-L imm Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced
Re: Windohs client problems
are you talking about reinstalling windows, or oracle? did you take it down to bare metal, and remove all oracle products, including following the instructions from oracle tech support for doing a manual cleanout? do you have a production db installed on that box? backups? On 23 Jul 2002 at 13:34, Jesse, Rich wrote: OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a second ORACLE_HOME. I've been using this setup fine and well until I installed Oracle Warehouse Builder into a separate ORACLE_HOME, then de-installed it after finding out it needs 9iAS. Then Quest products started flaking out, so Quest had me fiddle with the LAST_HOME registry entry. After that, the Microslop ODBC for Oracle driver fails to find the Oracle driver, stating: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr) And now, after uninstalling the 8.1.7 client, cleaning the registry, reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. The other half I get a TNS-12154, net name not found error. I'm using ONames for names resolution, but I don't understand what the hell is going on here. And seeing that it'll take me days to uninstall, reinstall, and reconfig I'd just as soon not do it. Anyone else have to deal with this hoo-ha that has a solution? I'd rather be at home diazinoning earwigs... sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANALYZE question
An export has default parameter of STATISTICS=ESTIMATE. If such an exported file is imported , the default import parameter ANALYZE=Y will result in the import utility executing the analyze stmts in dump file. -Original Message- Sean Sent: Wednesday, July 24, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
Ross, Not sure if original mail got through (looked garbled on Fatcity website) so here goes again You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: 24 July 2002 01:33To: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonablyconfident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site issignificantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than "I've been doing this for years and it has always worked?" Kevin KennedyFirst Point Energy Corporation ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. **
RE: Unix Q: ksh scripting
Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix Q: ksh scripting
print conn / as sysdba select some_stuff.. exit | sqlplus /nolog | tail -1 hth connor --- Ross Collado [EMAIL PROTECTED] wrote: Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ANALYZE question
dbms_stats --- O'Neill, Sean [EMAIL PROTECTED] wrote: Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Myers-Briggs - Too many off topic topics!
what is dual? On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote: ... The rest of us are just goofs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
I get the following output: spauser sh kev.sh + sh kev.sh SQL*Plus: Release 3.3.2.0.0 - Production on Wed Jul 24 09:22:05 2002 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.2.3.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.2.3.0 - Production SQL SYSDATE - 24-JUL-02 SQL Disconnected from Oracle7 Server Release 7.3.2.3.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.2.3.0 - Production spauser So it would appear that your -x will only show the last command from the command line and that was the execution of the shell script. Do you get the same output. K. -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANALYZE question
No Impact. Analyze would just collect the latest statistics for the concerned table and the next time any query gets fired on this table the optimizer (CBO) would generate the execution plan based on these statistics. I also believe that this would be healthier sign as the CBO is generating plans as per the latest what is available and not on the stale ones. Moreover, it would be good that instead of Using Analyze you should use DBMS_STATS.gether_table_statistics stored procedure as it : 1) DBMS_STATS can run in parallel mode and hence would be faster than Analyze (which is a serial operation) 2) Only if the statistics are stale the DBMS_STATS would execute. 3) You can always Export/Import/Set the statistics from one db to another db. Thanks, Vikas Khanna -Original Message- Sent: Wednesday, July 24, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bind Variables in VB
All, Can anyone provide examples of how to issue an SQL statement in VB using Bind Variables (using DAO or ADO). Many thanks for any responses. Dave Leach Technical Services Claybrook Computing Internal ext * 4992 Phone * 01293 604992 Fax 01293 604029 E-Mail * [EMAIL PROTECTED] The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00600: ???
Leslie, It appears that there is an action occuring on your database at 18:20 each day that needs the tablespace that was deleted. It might be a scheduled job or an application that is external to the server. try restoring the tablespace from your backup and see if the errors continue. I also would start investigation the reason for the ALTER and DROP commands. An ITAR would help speed up the process. Ron [EMAIL PROTECTED] 07/23/02 07:09PM Hi Ron, Thank you! Actually the Dropping TS only happened on 7/15. There are no other special actions since 7/15. And after 7/15, the error shows after alter database open. Sorry didn't make it clear. --- Ron Rogers [EMAIL PROTECTED] wrote: Leslie, You say the message appears at 18:20 each day. Check and see what jobs have been added to the system since 7/15 that would effect the database. Perhaps an erronious, undocumented action has been added that is altering your system and dropping a critical tablespace. Why would you want to drop a tablespace the same time every day? Are you using partitioning and used the wrong command to drop the partition? Just a thought. Ron ROR mô¿ôm [EMAIL PROTECTED] 07/23/02 04:21PM open an iTAR. Reply Separator Author: Leslie Lu [EMAIL PROTECTED] Date: 7/23/2002 11:54 AM Hi all, I have a 817 db on NT. In the alter log, I have the following error since 7/15. (The error repeats about 30 times.) Mon Jul 15 16:11:32 2002 Errors in file D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: ORA-00600: internal error code, arguments: [18062], [], [], [], [], [], [], [] The actions before the error were ALTER SYSTEM SET global_names=FALSE; and drop a tablespace. And after 7/15, the same message shows every day around 18:20pm.(The error repeats about 30 times.) in the related trace file, I got: *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 *** 2002-07-15 16:15:01.156 ksedmp: internal or fatal error What does this mean and what I should do? The metalink doesn't help too much. Thank you. Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Netw ork Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the
RE:
Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANALYZE question
A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject:RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Myers-Briggs - Too many off topic topics! MUST READ CAREFULLY
Dual is a dummy table which oracle has provided to retrieve the values of Environment Variables. eg. Select user from dual; Select sysdate from dual; and many other manipulations like Select 12 * 12 + 3 from dual; As the ANSI/SQL syntax requires FROM Clause so that's the reason Oracle has given you this table to retrieve exactly one row whenever required. as Select 12 * 12 + 3; would certainly give you error. You can also give : - Select 12 * 12 + 3 from emp but it would provide 14 rows instead of just one row having results as : 147 147 147 147 147 147 147 147 147 147 147 147 147 147 14 rows selected -Original Message- Sent: Wednesday, July 24, 2002 3:08 PM To: Multiple recipients of list ORACLE-L what is dual? On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote: ... The rest of us are just goofs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: locking issues in web based applications
Dennis , thanks for your suggestions. It seems detection is the only viable option to avoid locking. i'll try to get the suggested book from somewhere . ratnesh -Original Message- WILLIAMS Sent: Tuesday, July 23, 2002 9:08 PM To: Multiple recipients of list ORACLE-L Ratnesh I assume you are using the JDBC interface, rather than J2EE. You may want to consider buying the book Java Programming with Oracle JDBC by Donald Bales. He devotes a chapter to this subject. One issue he raises that will limit your options is whether you have other applications besides your Web-based application accessing this database. If not, that gives you additional flexibility. Bales distinguishes between locking and detection. He contends that locking alone does not solve the problem of multiuser data access integrity, and offers several examples to support his contention. He then outlines 3 methods for employing detection. He defines detection as the ability to detect if data you are about to modify has changed since the point when you selected it to be updated. 1. Pessimistic. Use an updatestamp 2. Pessimistic. Compare all the columns in the table or attributes of an object with their original values. 3. Optimistic. Compare only modified columns or attributes in a WHERE clause. I wish I could speak from experience, but I think this author has studied this issue in more detail than I could. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 8:53 AM To: Multiple recipients of list ORACLE-L Hi I'm not very familiar with web based application development. One of our programmers has asked me a question regarding locking issues in web based applications.In a typical scenario , users access the oracle database thro a browser via app-svr/web-svr . Connection pooling is implemented on the web-svr to support large no of users. If a user locks some objects via updates or deletes , then kills his browser , the objects remains locked. The question is how to design the system such that abnormal client browser termination does not lock any objects.One solution is not to lock objects at all , and commit immediately after update if the object timestamp has not changed .But this approach is suitable only for short sweet transactions. Connection timeout is too time-taking for intensive applications to be of any use. There must be other better ways of doing this. I need your suggestions. TIA, ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MUST read Oracle Architecture - Abrief Intro
Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: View error msg
Title: RE: View error msg Take a look at Note:93516.1 on Metalink (Can a View be Created That Allows Insert of Records into the View and Base Table). Make sure that one table has a primary key that is reference by a fk in the other table. Without the relationship, it won't work, hence the error msg. -Original Message- From: Vandana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:33 PM To: Multiple recipients of list ORACLE-L Subject: View error msg Hi, I created a view as a join of two tables, each of which has a primary key defined on it. When I am trying to insert values into the view I see the following error msg, ORA-01779: cannot modify a column which maps to a non key-preserved table What could the error be? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vandana INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: View error msg
Does the WHERE clause on your view contain all of the fields from both primary keys? Maybe you should post the table/view definitions. Beth -Original Message- Sent: Tuesday, July 23, 2002 11:33 PM To: Multiple recipients of list ORACLE-L Hi, I created a view as a join of two tables, each of which has a primary key defined on it. When I am trying to insert values into the view I see the following error msg, ORA-01779: cannot modify a column which maps to a non key-preserved table What could the error be? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vandana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: MUST read Oracle Architecture - Abrief Intro
yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: Oracle on Linux ..... Red Hat vs. Suse
On Tue, Jul 23, 2002 at 10:38:18PM -0800, Gogala, Mladen wrote: No, it's not certified, but I know the guy who successfully installed 9.2 on the cooker. Certificates are of limited value in the Linux world. Production support might be of interest, someday, in the linux world. I'd hate to explain to customers that I won't be bringing a service up because I decided to run on an unsupported platform. You will need to be getting this in the linux world. A product can be certified and yet you may suffer when installing. We're still living in the early days of linux. Later on, RH will become another Microsoft and we'll have 2 Behemoth companies instead of one. -Original Message- Sent: Monday, July 22, 2002 11:23 PM To: Multiple recipients of list ORACLE-L On Mon, Jul 22, 2002 at 03:04:03PM -0800, ltiu wrote: Mandrake 8.1/8.2 works really well with Oracle 9i Release 2. but is not certified by Oracle. It's RH compatible, meaning applications are numerous but it does not have the faulty compiler and it's still free unlike Suse. Downloads are easy to get at as well. A lot easier than RH and Suse. ltiu Quoting Gogala, Mladen [EMAIL PROTECTED]: Well, I switched from RH 6.2 to SuSE 7.2 (now I'm running 8.0) and here are my impressions: 1) RH was using a proprietary compiler (gcc 2.96) and libraries were incompatible with many independent pieces of software. In particular, Oracle installation was a genuine nightmare. No way I'm going back to RH while they're using that @#$! compiler. 2) Availability of software for SuSE is very poor. Nothing on the rpmfind.net, their website is lousy and they are working very hard to make it even worse. In particular, they used to have a subdirectory called full-names where one could find all rpm packages that were officially available for a given release. That was far too easy, so they removed that directory and replaced it with the file INDEX.gz which you are supposed to download, zgrep for the given package and then download it from it's location. 3) SuSE technical support is bad and less then useless. RH wasn't a shining example of customer service either, but SuSE really shows you what the word untermensch really means. 4) SuSE kernel is tainted and is not reporting version the way it's supposed to. That confuses the heck out of the utilities like OSS sound drivers. When I asked SuSE for help they told me to use ALSA (I've paid for OSS and with ALSA my mic was dead as dodo). When further pressed, they told me that kernel relinking is for gurus only and to stay away from that nasty stuff. Eventually, I downloaded a standard kernel, linked it to fit my HW, installed OSS and it worked perfectly. SuSE kernel has completely unexpected dependencies and cannot be compiled easily without the help from SuSE. The latter is impossible to get. 5) Software is installed in curious places (xmms is installed under /usr/X11 so that you cannot use plugin rpms) and is always at least a version behind. Ximian GNOME doesn't work quite well and one needs an expert to do so, otherwise, only KDE is left. 6) SuSE has memory test as one of the booting options which was an extremely convenient thing when I was installing additional memory and my DIMM was bad. 7) The latest RH betas are done with gcc 3.1 which is an official gcc release. As soon as that hits production, I'm switching back to RH, especially now when RH and Oracle Corp. resolved their differences. Mladen Gogala Oracle DBA Phone: (203) 459-6855 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle on Linux . Red Hat vs. Suse -- Christopher Royce [EMAIL PROTECTED] on 07/22/02 08:53:32 -0800 Have been unable to arrive at a definitive position There isn't one. There are tradeoffs between the two distro's. Most of it comes down to which one you are more comfortable with or which one does more things (including the installation) that you cannot fathom. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Unix Q: ksh scripting
Title: RE: Unix Q: ksh scripting With the addition of the extra quote...this worked fine for me. Kevin, try running it using the korn shell ( ksh instead of sh - bourne shell). If you're just trying to grab the date, though, I'd do it like this: #!/bin/ksh THE_DATE=`sqlplus -s / EOF set heading off set pagesize 0 select sysdate from dual; exit EOF` echo $THE_DATE If you really want the last line, maybe sysdate was just for kicks, you could spool a file before the select, spool off after it, then do a tail -1 on the spool file followed by cleaning it up OR leave it around (i.e. remove the file at the start, rather than at the end) until the next run just in case you have problems you can always go back to see what was there the last time it was run. HTH -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix Q: ksh scripting Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
It works for me. Using the following code: #!/bin/ksh #set -x sqlplus / EOF | tail -1 select sysdate from dual; exit EOF I get: $ test.sh JServer Release 8.1.7.0.0 - Production $ With -x flag set: $ test.sh + tail -1 + sqlplus nri/nri + 0 /tmp/sh27884.2 JServer Release 8.1.7.0.0 - Production $ As previously mentioned, to get the last row of the actual output you need to use the '-s' flag, move the pipe to the command line and get rid of the blank lines: #!/bin/ksh set -x sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF $ test.sh + sqlplus -s / + sed -n $p + grep -v ^$ + 0 /tmp/sh28234.2 24.07.2002 $ or - without the -x flag (which I presume is the desired result): $ test.sh 24.07.2002 $ Chris -Original Message- Sent: 24 July 2002 12:18 To: Multiple recipients of list ORACLE-L Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Windohs client problems
BTW, 9iAS is not required for OWB. I'm running it on a 9.0.1 database with no 9iAS. You lose a couple of features, but nothing major. Beth -Original Message- Sent: Wednesday, July 24, 2002 5:58 AM To: Multiple recipients of list ORACLE-L are you talking about reinstalling windows, or oracle? did you take it down to bare metal, and remove all oracle products, including following the instructions from oracle tech support for doing a manual cleanout? do you have a production db installed on that box? backups? On 23 Jul 2002 at 13:34, Jesse, Rich wrote: OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a second ORACLE_HOME. I've been using this setup fine and well until I installed Oracle Warehouse Builder into a separate ORACLE_HOME, then de-installed it after finding out it needs 9iAS. Then Quest products started flaking out, so Quest had me fiddle with the LAST_HOME registry entry. After that, the Microslop ODBC for Oracle driver fails to find the Oracle driver, stating: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr) And now, after uninstalling the 8.1.7 client, cleaning the registry, reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. The other half I get a TNS-12154, net name not found error. I'm using ONames for names resolution, but I don't understand what the hell is going on here. And seeing that it'll take me days to uninstall, reinstall, and reconfig I'd just as soon not do it. Anyone else have to deal with this hoo-ha that has a solution? I'd rather be at home diazinoning earwigs... sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: ANALYZE question
On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: type of join in sql
The optimizer will use the availability of indexes in deciding which type of join to use. no indexes = merge join indexes = nested loops, although the optimizer may dynamically choose to perform a hash join. Your tweaking of the join conditions is what causes the different joins to be used. HTH p.s. See the "Database Performance Guide and Reference" section of the docs. for more info. -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 9:59 PMTo: Multiple recipients of list ORACLE-LSubject: type of join in sql can some body shed some light on how does the optimizer decides to choose the kindof join i.e. nested loop, sort merge or hash join . In one of queries if i tweak the join condition it changes the type of join and start using index , otherwise it doesn't . I thought it depends on statistics .. if optimize finds that are more qualifying records in inner table then it will prefer to go for sort merge and will do full scan of inner table , but if it thinks there are less records in inner table it will user nested loop . am I correct ? TIA , bp
RE: Unix Q: ksh scripting
Title: RE: Unix Q: ksh scripting I also assumed you may want the last line (rather than just sysdate) - grep -v ^$ | sed -n '$p' solution works for last line too :) -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: 24 July 2002 14:49To: Multiple recipients of list ORACLE-LSubject: RE: Unix Q: ksh scripting With the addition of the extra quote...this worked fine for me. Kevin, try running it using the korn shell ( ksh instead of sh - bourne shell). If you're just trying to grab the date, though, I'd do it like this: #!/bin/ksh THE_DATE=`sqlplus -s / EOF set heading off set pagesize 0 select sysdate from dual; exit EOF` echo $THE_DATE If you really want the last line, maybe sysdate was just for kicks, you could spool a file before the select, spool off after it, then do a tail -1 on the spool file followed by cleaning it up OR leave it around (i.e. remove the file at the start, rather than at the end) until the next run just in case you have problems you can always go back to see what was there the last time it was run. HTH -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix Q: ksh scripting Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Converting Longs
Title: RE: Converting Longs Jay, Well since he says Oracle recommends not using Longs but Oracle itself uses Longs, have the luser submit a TAR or give him Uncle Larry's email address. Should be good for a laugh or two. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Jay [SMTP:[EMAIL PROTECTED]] Hello: Since everyone has forwarded a comment about their war stories I would like to offer up my Monday. The a programmer on a client I am working at asked me to convert all of the long data types since Oracle recommends that you do not use them. Since we use no longs I asked what he was referring to. He said please run a DESC on ALL_TRIGGERS, Then commented that I do not know my database. ALTER SYSTEM DROP STUPID_USER user does not seem to be working in this situation any ideas?
RE: Windohs client problems
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Subject: Re: Windohs client problems are you talking about reinstalling windows, or oracle? did you take it down to bare metal, and remove all oracle products, including following the instructions from oracle tech support for doing a manual cleanout? do you have a production db installed on that box? Just Oracle. I don't have an instance running, but I don't fancy attempting to uninstall/delete/reinstall/reconfigure 9i, because I'm running OEM (server and client w/remote repository) and an ONames backup. According to Oracle Support, I should just be able to nab the .ora files before the uninstall to maintain the config of OEM, but this isn't true. The GUI settings appear to be local to the client, especially the Groups settings (e.g. background images). ONames is a little simpler. The last time I wiped Oracle and reinstalled on Windohs, it took a few *days*. Hell, even with the supremely icky Oracle installs on VMS I could have that done in a couple of hours. sigh Perhaps I just bite the bullet and reinstall. To do this correctly on WinTuke, I have a few questions: 1) If more than one ORACLE_HOME is required (in my case, due to differences in 8i/9i), is the order of installation important? Should I install 8.1.7 client before or after 9i EE? Or doesn't it matter? 2) From a Registry monitor program, I saw that the MS ODBC for Oracle driver only looked at HKLM/SOFTWARE/ORACLE/ORACLE_HOME for it's ORACLE_HOME. This key doesn't change it's value when the active ORACLE_HOME is changed thru Oracle Home Selector. So, how do I get the MS ODBC driver to point to other ORACLE_HOMEs? And what exactly does the Oracle Home Selector change? How should a client program identify the current ORACLE_HOME? WHY THE HELL IS THIS SO FREAKING COMPLEX? K.I.S.S.! grumble grumble Maybe I need to start a rant-rant-rant thread? ;) backups? Backups of my PC? Ha! At the very least I should be getting an Winders box for testing Oracle stuff now that this has happened a few times. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
I get no hits when I try to see bug 203003.996 in Metalink. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 10:55 AM To: Multiple recipients of list ORACLE-L Subject:Re: ANALYZE question This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open it using a viewer that can display the original character set. File: message.txt -- 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).
RE: Using GFS for 9i RAC
OK, I posted this Monday, went fishing yesterday and figured I'd hear something about this today but nothing... has anyone even heard of GFS? Sistina? Raw? Cluster File Systems? :-) -Original Message- Sent: Monday, July 22, 2002 6:18 PM To: Multiple recipients of list ORACLE-L Anyone using Sistina GFS for Oracle 9i RAC implementations? It obviates the need for raw, has a volume manager, and provides direct I/O support. Can't find any info on Metalink/OTN. Looks intriguing for RAC on Linux and there's no mention from the Oracle propagandists? http://www.sistina.com/products_gfs_Oracle.htm http://www.supercomputingonline.com/article.php?sid=2132 Where's Veritas? Curiouser... Steve Orr Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Q: ksh scripting
I'd just do: $ date ;o) -Original Message- Sent: 24 July 2002 14:49 To: Multiple recipients of list ORACLE-L With the addition of the extra quote...this worked fine for me. Kevin, try running it using the korn shell ( ksh instead of sh - bourne shell). If you're just trying to grab the date, though, I'd do it like this: #!/bin/ksh THE_DATE=`sqlplus -s / EOF set heading off set pagesize 0 select sysdate from dual; exit EOF` echo $THE_DATE If you really want the last line, maybe sysdate was just for kicks, you could spool a file before the select, spool off after it, then do a tail -1 on the spool file followed by cleaning it up OR leave it around (i.e. remove the file at the start, rather than at the end) until the next run just in case you have problems you can always go back to see what was there the last time it was run. HTH -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 24, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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 http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Q: How to Find Cursor Size
Hello: Is there anyway to find the size of a cursor in bytes? We are attempting to implement ADO returning Oracle cursors and want to make sure we are not returning more then the 64k limit. Thank you in advance, Jay _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
On the subject on analyzed: We are doing analyze compute statistics and it takes about an hour. Do you know of ways to speed it up? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:54 PM On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: Unix Q: ksh scripting
# !/bin/ksh # set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 The close needs to be on a line by itself: ( foo - BAR stuff here BAR ) | tail -1; will do what you want. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance Tuning on RAC with Tru64 Unix - Any Docs , Links ?
We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3 Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Select from Long Datatype Field to INSERT into a Varchar2 Dat atype Field
Srinath,List Can you give some Detail ? Thanks to All -Original Message- Sent: Wednesday, July 24, 2002 12:31 PM To: LazyDBA.com Discussion Dat atype Field You can do this in PL/SQL, not in SQL/Plus -Original Message- From: Ganesh Raja [SMTP:[EMAIL PROTECTED]] Sent: 24 July, 2002 12:12 PM To: LazyDBA.com Discussion Subject:RE: Select from Long Datatype Field to INSERT into a Varchar2 Dat atype Field No That is Not Possible.. Another reason to move to Clob... HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:11 AM To: LazyDBA.com Discussion Subject: Select from Long Datatype Field to INSERT into a Varchar2 Datatype Field Qs How is Select of Data from a Long Datatype Field to INSERT into a Varchar2 Datatype Field in another Table possible ? Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is Statspack a Security Problem?
To wit: $grep -i grant spctab.sql grant select on STATS$SNAPSHOT_ID to PUBLIC; grant select onSTATS$DATABASE_INSTANCE to PUBLIC; grant select onSTATS$SNAPSHOT to PUBLIC; grant select onSTATS$FILESTATXS to PUBLIC; grant select onSTATS$TEMPSTATXS to PUBLIC; grant select onSTATS$LATCH to PUBLIC; grant select onSTATS$LATCH_CHILDREN to PUBLIC; grant select onSTATS$LATCH_PARENT to PUBLIC; grant select onSTATS$LATCH_MISSES_SUMMARY to PUBLIC; grant select onSTATS$LIBRARYCACHE to PUBLIC; grant select onSTATS$BUFFER_POOL_STATISTICS to PUBLIC; grant select onSTATS$ROLLSTAT to PUBLIC; grant select onSTATS$ROWCACHE_SUMMARY to PUBLIC; grant select onSTATS$SGAto PUBLIC; grant select onSTATS$SGASTAT to PUBLIC; grant select onSTATS$SYSSTAT to PUBLIC; grant select onSTATS$SESSTAT to PUBLIC; grant select onSTATS$SYSTEM_EVENT to PUBLIC; grant select onSTATS$SESSION_EVENT to PUBLIC; grant select onSTATS$BG_EVENT_SUMMARY to PUBLIC; grant select onSTATS$WAITSTAT to PUBLIC; grant select onSTATS$ENQUEUESTAT to PUBLIC; grant select onSTATS$SQL_SUMMARY to PUBLIC; grant select onSTATS$SQLTEXT to PUBLIC; grant select onSTATS$SQL_STATISTICS to PUBLIC; grant select onSTATS$LEVEL_DESCRIPTION to PUBLIC; grant select onSTATS$IDLE_EVENT to PUBLIC; grant select onSTATS$PARAMETER to PUBLIC; grant select onSTATS$STATSPACK_PARAMETER to PUBLIC; --- Notice the grants on stats$sqltext and stats$sql_summary. Should anyone who logs into the database be able to see nearly SQL run against it. Oracle appears to truncate alter user statements so that one cannot find 'alter user blatz identified by password;' but one may stumble on update sal_table set sal = 100 where empoyee_id = 5;' or something to that effect. 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 Help: estimating size for materialized view Question
Hi I am trying to find estimated size for a view using DBMS_OLAP.ESTIMATE_SUMMARY_SIZE package. Using the following sql (logged in as SYS). I am new to materialized views and DBMS_OLAP.ESTIMATE_SUMMARY_SIZE usage. I am doing this through SQL*Plus logged in as SYS. I also set SERVEROUTPUT ON and VAR num_bytes NUMBER VAR num_rows NUMBER at SQL prompt in SQL*Plus. Can someone help me how to find the estimated size before creating a materialized view for the following syntax for the following. thanks, Srinivas exec DBMS_OLAP.estimate_summary_size('test_est_size', 'SELECT empno, ename, dname, loc FROM scott.emp, scott.dept where emp.deptno=dept.deptno', :num_rows, :num_bytes) This is the output I got : SQL set SERVEROUTPUT ON SQL show serveroutput serveroutput ON size 2000 format WORD_WRAPPED SQL VAR num_rows number SQL var num_bytes number SQL var variable mv_size datatype NUMBER variable num_bytes datatype NUMBER variable num_rows datatype NUMBER SQL exec DBMS_OLAP.estimate_summary_size('test_est_size', 'SELECT empno, ename, dname, loc FROM scott.emp, scott.dept where emp.deptno=dept.deptno', :num_rows, :num_bytes) PL/SQL procedure successfully completed. SQL print :num_rows NUM_ROWS -- SQL print :num_bytes NUM_BYTES -- __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shutdown abort / startup restrict / shutdown vs. shutdown imm
That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/02 4:09 AM Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message- Sent: 24 July 2002 01:33 To: Multiple recipients of list ORACLE-L imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site is significantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than I've been doing this for years and it has always worked? Kevin Kennedy First Point Energy Corporation ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
On Wed, Jul 24, 2002 at 06:53:34AM -0800, Boivin, Patrice J wrote: I get no hits when I try to see bug 203003.996 in Metalink. I do, try the advanced search, maybe. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 10:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: ANALYZE question This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open it using a viewer that can display the original character set. File: message.txt -- 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shutdown abort / startup restrict / shutdown vs. shutdown imm
If you don't mind, under what version/os did this take place? On Wed, Jul 24, 2002 at 07:28:40AM -0800, April Wells wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/02 4:09 AM Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message- Sent: 24 July 2002 01:33 To: Multiple recipients of list ORACLE-L imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site is significantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than I've been doing this for years and it has always worked? Kevin Kennedy First Point Energy Corporation ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
Listener Log Aging Script
Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Explain Plan and SQL Text Length
What is the longest SQL statement that can be analyzed via explain plan. Is it the maximum length equal to the maximum length of a varchar2. Does the new virtual explain view have any problems with the length of the statement? 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).
RE: Rant-Rant
I think they may have some flawed processes because my wife received one piece of mail from them and we are more than a few years younger than 50. But Rachel, in my mind there's no way you would be even close to qualifying for their benefits. Stephen [EMAIL PROTECTED] 07/23/02 11:38AM what a nice way to put that :) maybe they are taking mental age into account and so think I'm about 16? either that or they have you confused with someone else, it was my understanding that they tag you as soon as you hit 50 --- Toepke, Kevin M [EMAIL PROTECTED] wrote: Hmmm... thats intersting. I'm somewhat your junior and I've been getting their propaganda for a couple of years already. -Original Message- Sent: Tuesday, July 23, 2002 9:34 AM To: Multiple recipients of list ORACLE-L so sweet. so deluded. I'm one of the chronological seniors here.. not the oldest I've found but close on the other hand, AARP (American Association of Retired People) hasn't started sending me their propaganda yet --- [EMAIL PROTECTED] wrote: I didn't know that they gave Managers jobs to people under 20 :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L The only problem with your idea that I see is that a typical organization will only keep one (or so) DBA on staff per project - they rarely have excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: OMG! A Socialist in the group! I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help our entire society better transition to the information era and not marginalize a bunch of great people in the process. The only problem with your idea that I see is
RE: 9i RAC on NetApp
Upgrades? We don't need no stinking upgrades... because this is a test setup. I'd figured on making ORACLE_HOME local for production for that same reason. The NetApp install doc makes it sound like an absolute requirement without explaining the reasoning. Always the documentation critic... Steve -Original Message- Sent: Tuesday, July 23, 2002 8:33 AM To: Multiple recipients of list ORACLE-L It makes it possible to upgrade without bringing the entire cluster down. Erik -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 7:54 PM To: Multiple recipients of list ORACLE-L Subject: 9i RAC on NetApp I'm looking at the NetApp install procedure for 9i RAC and it says that $ORACLE_HOME is not to be shared across the cluster nodes. Why? Is this really impossible? I understand that the files under the $ORACLE_BASE/admin/ORACLE_SID/?dump directories (and other files) should not be shared but is there any REAL reason the executables can't be shared? Has anyone done this on NetApp? Curious. Steve Orr Bozeman, Montana (P.S. Walt and I are playing together on a NetApp 820c eval box for a month so we're RAC'ing on the toaster too.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Tuning on RAC with Tru64 Unix - Any Docs , Links
Vivek - Hopefully you will receive some replies from someone with RAC experience. However, since RAC is so new, the information on tuning it may be pretty slim. Since RAC is based on Oracle Parallel Server, you might consider searching for tips on OPS. Some tips might apply to RAC. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:59 AM To: Multiple recipients of list ORACLE-L We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3 Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MUST read Oracle Architecture - Abrief Intro
I think that you will understand it better if you consider 2 scenario's: 1) RMAN backup from time 13:00 is newer then the backup taken at 13:45. 2) You get Enron accounting when the feds discover that invoice number 123 was issued after invoice 124. There are a lot of things, application and / or system, that can go wrong in this situation. To be on the safe side shut the database down for 1.25 hours. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:38 PM yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
system tablespace with oracle software on same
Hi Oracle gurus: Old db question: best db file layout accross filesystems/disks. (unix - Solaris 2.8, Oracle 8.1.7.4) I have inherited a db file layout recommendation that says to put oracle software and db system tablespaces on the same filesystem /u00/ This is for a production system and it doesnt seem ok to me. What experiences do you have in your environments with this? Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener Log Aging Script
Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Log Aging Script
I posted this answer once before. How about wrapping this is a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.log mv listener.log $ARCHIVE_LISTENER_FILENAME mv listener2.log listener.log lsnrctl set log_file listener.log gzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. HTH, John [EMAIL PROTECTED] 07/24/02 08:50AM Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
Yechiel Consider ANALYZE TABLE ESTIMATE STATISTICS. If you consider sampling theory, with larger tables you shouldn't need to inspect each row. You can vary the number of rows that are sampled. We had a good discussion on this topic on this list awhile back. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:59 AM To: Multiple recipients of list ORACLE-L On the subject on analyzed: We are doing analyze compute statistics and it takes about an hour. Do you know of ways to speed it up? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:54 PM On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Explain Plan and SQL Text Length
Ian: Any valid SQL statement can be explained. I've explained queries that were well over 4k -- even when you excluded the whitespace! Kevin -Original Message- Sent: Wednesday, July 24, 2002 11:50 AM To: Multiple recipients of list ORACLE-L What is the longest SQL statement that can be analyzed via explain plan. Is it the maximum length equal to the maximum length of a varchar2. Does the new virtual explain view have any problems with the length of the statement? 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: Toepke, Kevin 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).
RE: Listener Log Aging Script
Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Myers-Briggs - Too many off topic topics! MUST READ CAREFULLY
what is dummy? On 24 Jul 2002 at 4:54, Vikas Khanna wrote: Dual is a dummy table ... -Original Message- Sent: Wednesday, July 24, 2002 3:08 PM To: Multiple recipients of list ORACLE-L what is dual? On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote: ... The rest of us are just goofs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MUST read Oracle Architecture - Abrief Intro
Shut the database DOWN for 1.25 hours? Who in the heck can afford THAT! You are *way* off base my friend. If I suggested to my client that they need to shut the database down because of a time change, they would send me out on a rail - and I would deserve it. Bad idea. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 24, 2002 12:08 PM To: Multiple recipients of list ORACLE-L I think that you will understand it better if you consider 2 scenario's: 1) RMAN backup from time 13:00 is newer then the backup taken at 13:45. 2) You get Enron accounting when the feds discover that invoice number 123 was issued after invoice 124. There are a lot of things, application and / or system, that can go wrong in this situation. To be on the safe side shut the database down for 1.25 hours. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:38 PM yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: ANALYZE question
I looked into the same thing some time ago. I found Oracle papers that recommend using estimate 25% on the tables and a full analyze on the indexes. I wrote the script below to generate a script with all the analyze statements I needed for the schema to be analyzed. I added date and time displays so I could see how far along I am while the script is processing. I run the output script on a weekly basis. Ron Smith set feedback off; set heading off; set pagesize 0; set linesize 120; set heading off; set feedback off; set show off; spool analyze2.sql select 'set feedback off;'|| CHR(10) || 'set heading off;' || CHR(10) || 'set pagesize 0;' || 'set linesize 80;'|| CHR(10) | | 'set heading off;' || CHR(10) || 'set feedback off;' || CHR(10) || 'spool analyze_schema2.lst;' from dual / select 'select ' || || object_type || ' ' || object_name || ||', to_char(sysdate, ''MM/DD/ HH24:MI'') from dua l;'|| CHR(10) || 'analyze '|| object_type || ' ' || owner || '.' || object_name || ' estimate statistics sample 25 percent f or table;' from dba_objects where object_type in('TABLE') and owner = 'PROD' order by object_type desc / select 'select ' || || object_type || ' ' || object_name || ||', to_char(sysdate, ''MM/DD/ HH24:MI'') from dua l;'|| CHR(10) || 'analyze '|| object_type || ' ' || owner || '.' || object_name || ' compute statistics;' from dba_objects w here object_type in('INDEX') and owner = 'PROD' order by object_type desc / This is what part of the output script looks like: set feedback off; set heading off; set pagesize 0; set linesize 80; set heading off; set feedback off; spool analyze_schema2.lst; select 'TABLE DIST', to_char(sysdate, 'MM/DD/ HH24:MI') from dual; analyze TABLE PROD.DIST estimate statistics sample 25 percent for table; select 'TABLE EXCEPTIONS', to_char(sysdate, 'MM/DD/ HH24:MI') from dual; analyze TABLE PROD.EXCEPTIONS estimate statistics sample 25 percent for table; Ron Smith -Original Message- Sent: Wednesday, July 24, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Yechiel Consider ANALYZE TABLE ESTIMATE STATISTICS. If you consider sampling theory, with larger tables you shouldn't need to inspect each row. You can vary the number of rows that are sampled. We had a good discussion on this topic on this list awhile back. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:59 AM To: Multiple recipients of list ORACLE-L On the subject on analyzed: We are doing analyze compute statistics and it takes about an hour. Do you know of ways to speed it up? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:54 PM On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
How to read client characterset in logon trigger?
Help me out here, is there a procedure or statement I can use to record client character set settings in a logon trigger? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener Log Aging Script
exactly. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 10:43 AM Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix Q: ksh scripting
OR # !/bin/ksh # set -x sqlplus / EOF | tail -1 select sysdate from dual; exit EOF Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Unix Q: ksh scripting 07/24/02 07:53 AM Please respond to ORACLE-L # !/bin/ksh # set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 The close needs to be on a line by itself: ( foo - BAR stuff here BAR ) | tail -1; will do what you want. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: system tablespace with oracle software on same
Nah wouldn't do it! Ideally you separate everything that improves performance and recovery chances in the event of a failure and I don't like the idea of having code and data on the same volume spindles. Remember that Oracle has to access the admin part of the tree to write trace files and alert log and probably at time access code that resides on the disk and along with that you want it to keep the dictionary up to date in the system table. I see a potential conflict with that. My 0.02c US today Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-07-2002 09:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:system tablespace with oracle software on same Hi Oracle gurus: Old db question: best db file layout accross filesystems/disks. (unix - Solaris 2.8, Oracle 8.1.7.4) I have inherited a db file layout recommendation that says to put oracle software and db system tablespaces on the same filesystem /u00/ This is for a production system and it doesnt seem ok to me. What experiences do you have in your environments with this? Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is Statspack a Security Problem?
Sounds like yet another good reason for using bind variables 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 24, 2002 8:23 AM To: Multiple recipients of list ORACLE-L To wit: $grep -i grant spctab.sql grant select on STATS$SNAPSHOT_ID to PUBLIC; grant select onSTATS$DATABASE_INSTANCE to PUBLIC; grant select onSTATS$SNAPSHOT to PUBLIC; grant select onSTATS$FILESTATXS to PUBLIC; grant select onSTATS$TEMPSTATXS to PUBLIC; grant select onSTATS$LATCH to PUBLIC; grant select onSTATS$LATCH_CHILDREN to PUBLIC; grant select onSTATS$LATCH_PARENT to PUBLIC; grant select onSTATS$LATCH_MISSES_SUMMARY to PUBLIC; grant select onSTATS$LIBRARYCACHE to PUBLIC; grant select onSTATS$BUFFER_POOL_STATISTICS to PUBLIC; grant select onSTATS$ROLLSTAT to PUBLIC; grant select onSTATS$ROWCACHE_SUMMARY to PUBLIC; grant select onSTATS$SGAto PUBLIC; grant select onSTATS$SGASTAT to PUBLIC; grant select onSTATS$SYSSTAT to PUBLIC; grant select onSTATS$SESSTAT to PUBLIC; grant select onSTATS$SYSTEM_EVENT to PUBLIC; grant select onSTATS$SESSION_EVENT to PUBLIC; grant select onSTATS$BG_EVENT_SUMMARY to PUBLIC; grant select onSTATS$WAITSTAT to PUBLIC; grant select onSTATS$ENQUEUESTAT to PUBLIC; grant select onSTATS$SQL_SUMMARY to PUBLIC; grant select onSTATS$SQLTEXT to PUBLIC; grant select onSTATS$SQL_STATISTICS to PUBLIC; grant select onSTATS$LEVEL_DESCRIPTION to PUBLIC; grant select onSTATS$IDLE_EVENT to PUBLIC; grant select onSTATS$PARAMETER to PUBLIC; grant select onSTATS$STATSPACK_PARAMETER to PUBLIC; --- Notice the grants on stats$sqltext and stats$sql_summary. Should anyone who logs into the database be able to see nearly SQL run against it. Oracle appears to truncate alter user statements so that one cannot find 'alter user blatz identified by password;' but one may stumble on update sal_table set sal = 100 where empoyee_id = 5;' or something to that effect. 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: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener Log Aging Script
It keeps the file handle to the inode not the filename so when you mv filea fileb the listener is still writing to the inode which now belongs to fileb so if you want to move it you need to do the set listener. On the other hand if you cp filea to fileb then the listener is stilled pointed at inode in filea so if you intend to truncate then the cat /dev/null cleans out file a whilst all contents up to that point are now in fileb. i think most unixes allow filea to delete its contents HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Erik Williams [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-07-2002 09:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Listener Log Aging Script Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To:Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: Listener Log Aging Script
See John Carlson's answer. You could shut down the listener and delete or rename the file but why bother when you can just /dev/nulllistener.log -Original Message- Sent: Wednesday, July 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MUST read Oracle Architecture - Abrief Intro
I imagine it would depend on the application. Some people are stuck working on 24x7 databases, others are lucky enough to have a life. :) --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, July 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Shut the database DOWN for 1.25 hours? Who in the heck can afford THAT! You are *way* off base my friend. If I suggested to my client that they need to shut the database down because of a time change, they would send me out on a rail - and I would deserve it. Bad idea. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 24, 2002 12:08 PM To: Multiple recipients of list ORACLE-L I think that you will understand it better if you consider 2 scenario's: 1) RMAN backup from time 13:00 is newer then the backup taken at 13:45. 2) You get Enron accounting when the feds discover that invoice number 123 was issued after invoice 124. There are a lot of things, application and / or system, that can go wrong in this situation. To be on the safe side shut the database down for 1.25 hours. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:38 PM yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 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: Explain Plan and SQL Text Length
Oracle Apps r10.7 and r11.0 had some SQL statements from PRO*C batch programs that are over 20K in length. Utterly astounding! Since VARCHAR2 variables can be up to 32767 in PL/SQL, I've written PL/SQL packages that used string variables of that length for automating EXPLAIN PLAN execution and storing the output for analysis, and ran this package in OraApps environments for months... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 10:33 AM Ian: Any valid SQL statement can be explained. I've explained queries that were well over 4k -- even when you excluded the whitespace! Kevin -Original Message- Sent: Wednesday, July 24, 2002 11:50 AM To: Multiple recipients of list ORACLE-L What is the longest SQL statement that can be analyzed via explain plan. Is it the maximum length equal to the maximum length of a varchar2. Does the new virtual explain view have any problems with the length of the statement? 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: Toepke, Kevin 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANALYZE question
At the last Open World I attended a couple of sessions where the general advice for 9i DB is to use ANALYZE ESTIMATE without specifying ANY value. A few brief comparision tests did show that it got better results than the alternatives tested. As always, YMMV HTH HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IO wait
Jack, Surprisingly, vmstat provides some idea of OS Waits - look under the 'procs - r b w' columns (running, blocked, swapped). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jack Silvey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Subject: IO wait All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: How to read client characterset in logon trigger?
SELECT SUBSTR(sql_text, 1, 2000) FROM sys.V_$OPEN_CURSOR WHERE UPPER (sql_text) LIKE 'ALTER SESSION%' with appropriate sid. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 24, 2002 1:05 PM To: Multiple recipients of list ORACLE-L Help me out here, is there a procedure or statement I can use to record client character set settings in a logon trigger? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: RE: Why Multiple Parses in Trace ?
If you don't want to change your application, get the application booster from oraperf. That will do it for you ;-) Setting up one environment variable and run again, this time much faster .. Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 8:08 AM If this statement is a loop and the counter works atleast twice, it would show 2 parse calls and 2 executions. You should basically put this statement in the main class and just bind the variables in the callable classes and just execute the statement. In this way it would be 1 parse call and many executions. Anyway a soft parse is not too bad as compared to Hard parse and the applications have proved them to be reasonable functioning well. The CPU and the memory consumed is significantly just 1% what was compared with the hard parse. Vikas Khanna -Original Message- Sent: Tuesday, July 23, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Change the application so that it doesn't parse twice. See www.hotsos.com/dnloads/1.Holt,Millsap2000.03.01-Scaling.pdf for details. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on Oracle(r) System Performance, Feb 9-12 Dallas -Original Message- Sent: Monday, July 22, 2002 10:43 PM To: Multiple recipients of list ORACLE-L Cary Millsap$B!$(B As for the soft parse, it also consumes cpu , how can we eleminate the softparse? Thanks. 2002-07-22 08:58:00 You wrote: ...Because the application requested two parse calls for this statement from the server. The first one was a hard parse (server had never seen the statement before), and the second one was a parse call that did not result in a hard parse. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- VIVEK_SHARMA Sent: Monday, July 22, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Qs Why is Parse = 2 in the following Query ? Solaris 8 Oracle 8.1.7 SGA = 60 MB shared_pool_size = 30 MB *** * select mesg, lchg_user_id, TO_CHAR(lchg_time,'DD-MM- HH24:MI:SS'), rcre_user_id, TO_CHAR(rcre_time,'DD-MM- HH24:MI:SS'), tran_id, TO_CHAR(tran_date,'DD-MM- HH24:MI:SS'), NVL(ts_cnt,0), sol_id, contra_acid, tran_amt||'!'||tran_crncy_code, TO_CHAR(value_date,'DD-MM- HH24:MI:SS'), tran_crncy_code, central_or_local_code, req_advc_ind, sys_gen_flg, rowid FROM TBA_REF_TRN_TBL WHERE cmd = :1 AND cust_or_card_id = :2 AND system_date_time = TO_DATE( :3 ,'DD-MM- HH24:MI:SS') AND dcc_id = :4 AND sno = :5 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse2 0.06 0.07 1 0 1 0 Execute 2 0.00 0.00 0 0 0 0 Fetch2 0.00 0.02 3 6 0 0 --- -- -- -- -- -- -- total6 0.06 0.09 4 6 1 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 40 (TBAGEN) Rows Row Source Operation --- --- 0 TABLE ACCESS BY INDEX ROWID REF_TRN_TBL 1 INDEX UNIQUE SCAN (object id 6561) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS (BY INDEX ROWID) OF 'REF_TRN_TBL' 1INDEX (UNIQUE SCAN) OF 'IDX_REF_TRN_TBL' (UNIQUE) *** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL
RE: Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2
Last try -Original Message- Sent: Tuesday, July 23, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Hello Listers, We are about to call veritas for a netbackup businessserver solution for our databases on hp k570 10.2 boxes A Veritas Vendor is proposing Netbackup BusinessServer 4.5 on hp 10.2 Any of ull implemented ver Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2 ? Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using GFS for 9i RAC
Interesting... According to the white papers at their web site it is not yet certified w/Oracle (they are working on it). Appears to have been originally developed for some massive NASA requirement (this is a hunch after reading their white papers and having some experience with NASA) like storing satelite data. I wouldn't think the locking mechanisms touted by GFS would bennefit Oracle as Oracle already implements it's own locking scheme. You would simply be using the shared filesystem. Could probable get similar results with any old NAS solution. Anyway, this is what I gather from reading the white papers. Don't have any direct experience with it. Just lots of OPS/RAC experience on more traditional systems. Bill --- Orr, Steve [EMAIL PROTECTED] wrote: OK, I posted this Monday, went fishing yesterday and figured I'd hear something about this today but nothing... has anyone even heard of GFS? Sistina? Raw? Cluster File Systems? :-) -Original Message- Sent: Monday, July 22, 2002 6:18 PM To: Multiple recipients of list ORACLE-L Anyone using Sistina GFS for Oracle 9i RAC implementations? It obviates the need for raw, has a volume manager, and provides direct I/O support. Can't find any info on Metalink/OTN. Looks intriguing for RAC on Linux and there's no mention from the Oracle propagandists? http://www.sistina.com/products_gfs_Oracle.htm http://www.supercomputingonline.com/article.php?sid=2132 Where's Veritas? Curiouser... Steve Orr Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Windohs client problems
Dude, Tisk, tisk, sounds like you didn't read all 25,000 pages of documentation before starting your install/deinstall/reinstall hell. VAX?! Well, the versions of early Oracle products were quite simple back then, no? Installing Oracle stuff on Netware or DOS/Windows back in the old days was pretty easy too. The kind of complex combo you are attempting is probably inherently going to be problematic, and I would definitely have asked Oracle tech support about install sequence issues (as well as the ODBC problems, etc.). My assumption is that the earlier product(s) should be installed first, but that may or may not be much of a factor. You've got a lot of stuff to tease out to find the real problem. I would go through separate clean installs of each pair of programs, looking for glitches, then add anothe component, etc. (probably more time consuming than a complete reinstall?) fwiw, I'm currently working a somewhat simpler juggling act with Dev6i products and the 3.x installer and the 8.1.7.x client components installed with the 8.1.7 OUI. Don't forget that after reinstalling/installing 8.1.7 stuff, you need to repatch it. I still can't understand why you have the Oracle9 EE db installed (but I'm not an OEM person), do you need it there for OEM to work?. fwiw, someone I know had a complete freeze trying to install both the Oracle9i db and 9iAS on a Windows laptop with 512MB RAM (sandbox machine). The test machine idea is good. (The following is not intended to be comprehensive, just some random stuff that I came across. ) Anyways, here are the official manual cleanup instructions for WinNT/2000: From the Oracle 8.1.7.0.0 EE install cd d:\welcome.html: (also see file:///E:/doc/Output/deinstal.htm#1088513 Deinstalling Oracle Components with Oracle Universal Installer) ---excerpt--- file:///E:/doc/Output/deinstal.htm#1096331 Manually Removing All Oracle Components and Services from Your Computer In rare situations, you may want to correct serious system problems by completely removing Oracle components from the computer. Remove all Oracle components from your computer only as a last resort, and only if you want to remove all Oracle components from your system. Note: You can also use the ORADIM utility to manually deinstall a database and registry entries. See the following documentation for information: READMEDOC.HTM or READMEDOC.PDF located in the \DOC directory of the component CD-ROM Chapter 6, Post-Installation Database Creation of Oracle8i Administrator's Guide for Windows NT --- Removing Components on Windows NT To remove all Oracle components from a computer on Windows NT: --- Caution: These instructions remove all Oracle components, services, and registry entries from your computer. In addition, any database files under ORACLE_BASE\ORADATA\DB_NAME are also removed. Exercise extreme care when removing registry entries. Removing incorrect entries can break your system. --- Ensure you are logged in as a user with Administrator privileges. Stop all Oracle services (if any are running): Choose Start Settings Control Panel Services. If any Oracle services (their names begin with Oracle) exist and have the status Started, select the service and choose Stop. Choose Close to exit the Services window. Start the registry at the MS-DOS command prompt: C:\ REGEDT32 Go to HKEY_CLASSES_ROOT. Delete any key that starts with Oracle or ORCL. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. Delete the ORACLE key. Delete the Oracle ODBC Driver key under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and remove all keys under here that begin with ORACLE. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \EventLog\Application, and remove all keys under here that begin with ORACLE. Go to HKEY_CURRENT_USER\SOFTWARE\ORACLE. Delete keys that start with Oracle or ORCL (if any exist). Go to HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBCINST.INI. Delete any Oracle keys (if any exist). Close the registry. Go to Start Settings Control Panel System Environment tab. Choose the system variable path and modify the Path variable. Remove any Oracle entries from the path. For example, if JRE was installed by Oracle, remove the %ORACLE_HOME%\BIN path and the JRE path. You may see a path similar to this one: C:\ORACLE\ORA81\BIN;G:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN Exit the Control Panel. Go to SYSTEM_DRIVE:\WINNT\PROFILES\ALL USERS\START MENU\PROGRAMS. Delete the following icons: Oracle - HOME_NAME Oracle Installation Products
RE: How to read client characterset in logon trigger?
I suppose that would work if an alter session is used but what if the client is simply set up to use a different character set, for example if NLS_LANG is set to something other than the database character set. export NLS_LANG=Blah sqlplus foo/bar Now what character set is being used? I presume Blah. Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Wednesday, July 24, 2002 12:36 PM To: Multiple recipients of list ORACLE-L SELECT SUBSTR(sql_text, 1, 2000) FROM sys.V_$OPEN_CURSOR WHERE UPPER (sql_text) LIKE 'ALTER SESSION%' with appropriate sid. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IO wait
kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32 0 2 754461 3195 0 0 0 00 0 503 1672 123 0 0 99 0 0 2 754461 3195 0 0 0 00 0 509 787 125 0 0 99 0 0 2 754461 3171 0 0 0 00 0 540 830 148 0 1 98 1 0 2 754461 3167 0 0 0 00 0 503 783 120 0 0 99 0 John, I think I recall some references in the past that would state that what you see above is a problem (the 2 blocked processes in the b column). However we are not suffering any type of obvious problems that I am aware of. Is there a way to determine what these processes are? Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Wednesday, July 24, 2002 12:36 PM To: Multiple recipients of list ORACLE-L Jack, Surprisingly, vmstat provides some idea of OS Waits - look under the 'procs - r b w' columns (running, blocked, swapped). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle DB Crash
To ALL, I'm going to ask if anyone on the list has seen the following, and if so, what did you do about it if anything. First environment: Oracle 8.1.7.4.0 on HP-UX 11.0 both in 64 bit. OCI interface programs to the database. Various interfaces done by database links into other Oracle databases. Problem: Right out of the clear blue the database crashes with an ORA-00600[1158] and a trace file. Opened an iTAR with Oracle sending them the alert log and trace file. Their response is that it's a lock issue with an enqueue resource caused by reco while trying to recover/rollback a remote database update. According to Oracle this has only happen twice now in the entire 8.1.7 install base. This has become a rather important item in my daily life, as I've a manager in another department who is becoming a pain in the side wanting me to do something. Thanks in advance. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windohs client problems
Just in case it might matter: Also note that the Oracle 8.1.7 install docs say under Deinstalling with the OUI that it is possible for the OUI inventory to get trashed, and OUI will be confused about what is and isn't installed. Not sure if that is the same for the 9.x OUI. regards, ep (also see file:///E:/doc/Output/deinstal.htm#1088513 Deinstalling Oracle Components with Oracle Universal Installer) ... file:///E:/doc/Output/deinstal.htm#1096331 file:///E:/doc/Output/ch2.htm#1093249 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: (memes) not making much headway with critiquing elitist dba
EP, What I cannot understand is why you left the fertilizer industry. Based on your commentary and the state of the economy I suspect demand could not keep up with your supply. Just kidding your posts are quite amusing. Eric D. Pierce eric_d_pierce@pa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cbell.net cc: Sent by:Subject: (memes) not making much headway with critiquing elitist [EMAIL PROTECTED] dba 07/23/2002 01:13 PM Please respond to ORACLE-L Robert, I got into computers after being in the fertilizer industry, a segue which has many times seemed quite apt. A year or two ago, I noticed that Oracle Education had a training/certification track for something they called Database Operator (DBO) that was quite similar to what you are talking about. The trainee was to know how to conduct routine, basic tasks under the supervision of a senior dba (on big databases), or would be a SA running a 3rd party type application that ran on top of Oracle where the 3rd party app people would provide dba technical consulting/support, or a SA that was running a small/non-critical database, etc. (the web site education.oracle.com doesn't seem to be working right now, so I can't confirm if they still have a DBO track.) Re: critiquing of the cultish/elitist mentality that predominates in DBA circles? ha haaa haa. The thing is to make crucial distinction between: good elitism: - high level specialization, - expertise required, - capacity of an individual to absorb tecnical complexity/theory and learn to apply it to problem solving, etc. and: bad elitism: - arrogant/selfish attitude, greedy, etc. Presumably the worst case scenario is having a person that exhibits bad elitism with little or no sign of any of the attributes of good elitism. I support your efforts at articulating a more populist scenario for defining technical job positions. You of course realize that any sort of populist argument, libertarian or otherwise, will get caught in the hellish middle of a cultural landscape that is mainly defeined by snobby *ssholes in either the politically correct (liberal) or country club (conservative) camps. Besides retreating to a libertarian position (which I think is an honorable approach, if somewhat stasist), there is also another alternative: embrace a holistic, integrative (transcendant/universal) paradigm that recognises the evolutionary limits (and evils) of both classic liberalism and conservatism. http://members.ams.chello.nl/f.visser3/wilber/mgm2.html Explanation of color schemes used in Spiral Dynamics type Memetic theory: http://members.ams.chello.nl/f.visser3/wilber/wilber_sd.html regards, ep On 22 Jul 2002 at 9:23, Robert Monical wrote: ... It seems that the implicit expectation is that every DBA should be or should aspire to be a Master Technical DBA. I have a slightly different take on the situation. It is a little convoluted but I believe that the DBA world needs some additional job classifications. In a decent sized organization, the day to day management functions should be accomplished by an Admin DBA who might be someone who was perfectly happy spending his/her working career operating a precision milling machine at Boeing. Since the machinist jobs are going away, I see no reason why a competent machinist could not become a competent admin DBA. Such a person is not suited by aptitude or disposition to become a Master Technical DBA, but would do a great job at the admin level. I'll extend the analogy a little more: the manufacturing
RE: How to read client characterset in logon trigger?
I have seen forms do this all the time, i.e. without actually issuing the 'alter session ...' command, you can see they being done. I think it must be something to do with sqlnet. Have you tried it yet? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 24, 2002 2:07 PM To: Multiple recipients of list ORACLE-L I suppose that would work if an alter session is used but what if the client is simply set up to use a different character set, for example if NLS_LANG is set to something other than the database character set. export NLS_LANG=Blah sqlplus foo/bar Now what character set is being used? I presume Blah. Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Wednesday, July 24, 2002 12:36 PM To: Multiple recipients of list ORACLE-L SELECT SUBSTR(sql_text, 1, 2000) FROM sys.V_$OPEN_CURSOR WHERE UPPER (sql_text) LIKE 'ALTER SESSION%' with appropriate sid. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: MUST read Oracle Architecture - Abrief Intro
In general, I agree with the majority opinion that seems to be saying that Oracle chugs along perfectly happy when the date changes. Time based recovery might have some issues, so I'd run a hot after the change so I could use it as my basis in a restore. The real question in my mind is ... What does the APP do with the dates. If you've got a time finder type app, you may need some data cleanup scripts to make sure calculations done on the stored data come out rightperson clocks in at 7:00 and out at 5:00, that 7 may need to be brought forward to get the overtime off the clock, for instance. Someone else mentioned an accounting issue if invoice 2 goes out before invoice 1. These sorts of issues need to be discussed with power users. It may not be an issue at all. If it IS a serious issue, you need to be thinking about DST (on and off) as well. If it's a big enough issuedo you have ANY maintenance windows? Maybe things could happen then so the data is static and available while fixes associated with the change are also run. Just my $0.02. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, July 24, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Shut the database DOWN for 1.25 hours? Who in the heck can afford THAT! You are *way* off base my friend. If I suggested to my client that they need to shut the database down because of a time change, they would send me out on a rail - and I would deserve it. Bad idea. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 24, 2002 12:08 PM To: Multiple recipients of list ORACLE-L I think that you will understand it better if you consider 2 scenario's: 1) RMAN backup from time 13:00 is newer then the backup taken at 13:45. 2) You get Enron accounting when the feds discover that invoice number 123 was issued after invoice 124. There are a lot of things, application and / or system, that can go wrong in this situation. To be on the safe side shut the database down for 1.25 hours. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:38 PM yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED]
RE: Is Statspack a Security Problem?
Why not just backup the spctab.sql script and then in vi do a g:/PUBLIC/s//DBA or whatever role you choose to play with statspack before running. Although bind vars are still appropriate too. Rodd Holman On Wed, 2002-07-24 at 12:23, kkennedy wrote: Sounds like yet another good reason for using bind variables 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 24, 2002 8:23 AM To: Multiple recipients of list ORACLE-L To wit: $grep -i grant spctab.sql snip grant select on STATS$SQLTEXT to PUBLIC; grant select onSTATS$SQL_STATISTICS to PUBLIC; grant select onSTATS$LEVEL_DESCRIPTION to PUBLIC; grant select onSTATS$IDLE_EVENT to PUBLIC; grant select onSTATS$PARAMETER to PUBLIC; grant select onSTATS$STATSPACK_PARAMETER to PUBLIC; --- Notice the grants on stats$sqltext and stats$sql_summary. Should anyone who logs into the database be able to see nearly SQL run against it. Oracle appears to truncate alter user statements so that one cannot find 'alter user blatz identified by password;' but one may stumble on update sal_table set sal = 100 where empoyee_id = 5;' or something to that effect. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED]
RE: IO wait
Hi Ethan, I assume this is from an AIX box (right?) Some remarks: (not an answer!) The first line of vmstat/iostat output is an average since restart. The 'wa' is 32 and you have 4 processes blocked on average. Was there a problem (or a large load) since your last restart that was since solved? If not, this may just be the average load... On the other hand, you aren't currently paging in/out nor have an abnormal amount of context switches (cs) or system calls (sy), so why should two processes be blocked for resources I/O, paging, and so forth (as per man page). Worth investigating! Unfortunately, *NIX does not provide the equivalent of V$ views so we really cannot dig into the details. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: IO wait kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32 0 2 754461 3195 0 0 0 00 0 503 1672 123 0 0 99 0 0 2 754461 3195 0 0 0 00 0 509 787 125 0 0 99 0 0 2 754461 3171 0 0 0 00 0 540 830 148 0 1 98 1 0 2 754461 3167 0 0 0 00 0 503 783 120 0 0 99 0 John, I think I recall some references in the past that would state that what you see above is a problem (the 2 blocked processes in the b column). However we are not suffering any type of obvious problems that I am aware of. Is there a way to determine what these processes are? Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Wednesday, July 24, 2002 12:36 PM To: Multiple recipients of list ORACLE-L Jack, Surprisingly, vmstat provides some idea of OS Waits - look under the 'procs - r b w' columns (running, blocked, swapped). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
OT: multi-processor top for slowaris
Linux has a top that displays load for each processor. Is there a solaris version that anyone has seen? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
reorg and rebuild
Hi Friends, Iam reorganizing my tables thru copy(CTAS), So when Iam re-inserting data into my Original table Will the indexes will build automatically or I have to rebuild?? Here Iam not doing for indexes anything i.e Iam not disabling it. I want to create table thru CTAS, truncate original table, copy back data into original table from duplicate table. So that I can pack data and get back my space back. My environment is v7.3 on AIX. Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: multi-processor top for slowaris
You can download top (and other goodies) from http://www.sunfreeware.com. Ray Stell wrote: Linux has a top that displays load for each processor. Is there a solaris version that anyone has seen? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to read client characterset in logon trigger?
select sys_context('USERENV','LANGUAGE') FROM DUAL ??? -Original Message- Sent: Wednesday, July 24, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Help me out here, is there a procedure or statement I can use to record client character set settings in a logon trigger? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Converting Longs
Depending on whether you wish to humiliate and demoralize the duhveloper, or you think there may be hope and you wish to educate him, one of the following may work. 1. Show him the the sys.trigger$ table and point him at documentation that will help him convert the WHENCLAUSE column to a CLOB 2. Privately point out to him that this is part of the data dictionary, and that making changes to this will likely cause him grief and anxiety such as he has never known. Jared Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/23/2002 07:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Converting Longs Hello: Since everyone has forwarded a comment about their war stories I would like to offer up my Monday. The a programmer on a client I am working at asked me to convert all of the long data types since Oracle recommends that you do not use them. Since we use no longs I asked what he was referring to. He said please run a DESC on ALL_TRIGGERS, Then commented that I do not know my database. ALTER SYSTEM DROP STUPID_USER user does not seem to be working in this situation any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IO wait
Jack, TOP adds %wio and %idle together. Use 'sar -u' instead. Jared Jack Silvey [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/23/2002 08:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:IO wait All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OEM changes
Well, it's not exactly a secret that our friend Gaja is now working for Oracle as a Director of Systems Management Tools ( I think the title is correct ), and that that title would include oversight of OEM, so I think we can expect good things to happen with OEM. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/23/2002 08:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: OEM changes not often... but there were at least 8 or 10 people there who were DBAs and this party was the thank goodness the darned book is done party so we started talking about writing books and someone said something about OEM 101 and I'm usually the one at the party saying (screaming?) NO MORE GEEK TALK :) --- Conboy, Jim [EMAIL PROTECTED] wrote: Now please, please tell me you don't REALLY talk about this geeky stuff at parties! Jim -Original Message- Sent: Monday, July 22, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Wish I could. This was at a party, and the person speaking was an Oracle employee. We were talking/ranting about how often Oracle changes things and he mentioned that OEM was changing AGAIN. That's all he said Rachel --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Rachel, Could you shed any light on the changes they are proposing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Windohs client problems
-Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: Windohs client problems Dude, Tisk, tisk, sounds like you didn't read all 25,000 pages of documentation before starting your install/deinstall/reinstall hell. 25K pages is a lot of time in the bathroom... VAX?! Well, the versions of early Oracle products were quite simple back then, no? Installing Oracle stuff on Netware or DOS/Windows back in the old days was pretty easy too. Nay, my good man. I stated VMS, which != VAX. One of our Oracle servers here is an Alpha running VMS (or OpenVMS as the marketing cronies call it). And my other workstation, also an OpenVMS/Alpha runs 9.0.1 quite happily. Oracle won't let me D/L 9iR2 for VMS yet (they say it's a space issue on OTN), but when I can, I'll install that for testing, too. Or I could just order it. (eh.) The kind of complex combo you are attempting is probably inherently going to be problematic, and I would definitely have asked Oracle tech support about install sequence issues (as well as the ODBC problems, etc.). My assumption is that the earlier product(s) should be installed first, but that may or may not be much of a factor. You've got a lot of stuff to tease out to find the real problem. I would go through separate clean installs of each pair of programs, looking for glitches, then add anothe component, etc. Yeah, I know I need to place a TAR. But the last one I placed was a *dream*, thanks to Cathy@Oracle. Not only did she actually e-mail me directly (as opposed to only updating the TAR), but she even called to see that her fix actually worked. And it did (STATSPACK install f'ed up a couple dozen SYS packages)! I closed the TAR pleading that she forward my comments to her super because this was the way a TAR should be handled. I guess I'm afraid to try for another TAR because I know it'll be back to The Old Way of handling a TAR. BTW, I've installed the 9i EE S/W in order to get the ONames Server and not to run a DB. I also wanted the ability to build a quick test DB for OiD if needed. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).