RE: Oracle Reports!
Hi Sesi, BEFORE_REPORT_TRIGGER is fired before sql statement is executed, so you can't abort your report execution here by using that trigger. HTH, Sony -Original Message- From: Sesi Odury [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Reports! Hi List, I need to abort the report execution, if the query generating report returns no rows. I tried to do this using the report trigger 'before report'. I have written code like this Function BEF_REP_TRG return boolean is begin return (true); Exception when no data found return (false); end; But ,it is displaying rep-1825 Before Report trigger returned false . Can we remove this??? Thanks Sesi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sesi Odury INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tech Support
You think that's good? Try this one... Me --- RedHat Linux 7.2 Oracle 9.2.0.2 dbca *always* hangs at 41% - Creating and starting Oracle instance. No background process ever gets started - no pmon, no smon, nothing. This is regardless of kernel parameters, memory or any other such stuff. Running a script to create an *identical* database works every time. Support -- Are there any error messages reported in the database alert.log file? Please upload alert.log file for more investigation. Thanks. Me --- New info : There are no messages in the alert log - except for the shutdown abort after I cancel dbca. Prior to that, there is nothing. It is empty. Support Can you please upload the alert.log file? Why do you think DBCA is hanging? Maybe it was running catalog.sql , catproc.sql and other scripts. These might take some time. This is normal. Can you see log files are switching in the alert.log file before you abort? Have you connected and checked from v$session_wait to see whether sessions are moving or not? See Note:68738.1 Hang or Spin?. column sid format 990 column seq# format 0 column wait_time heading 'WTime' format 0 column event format a30 column p1 format 90 column p2 format 90 column p3 format 9990 select sid,event,seq#,p1,p2,p3,wait_time from V$session_wait / Me --- New info : Perhaps I need to be more explicit... Here is the *entire* alert log immediately before canceling dbca (after it sat there motionless for over an hour): --- Start of alert log End of alert log - Here is the *entire* alert log after I cancelled dbca: --- Start of alert log Fri Feb 14 09:54:03 2003 Shutting down instance (abort) End of alert log - Kind of ironic isn't it - saying that it is aborting an instance that never existed? I think that dbca is hanging because it *IS* hanging - no background processes *EVER* get started. (No pmon, no smon, nada... nothing.) catalog.sql was not running. catproc.sql was not running. No other scripts were running. One has to have an instance running before one can run any SQL. v$session_wait is inaccessible - there are no background processes and no instance. It is going to be difficult to run any SQL when there are no background processes and no instance is running. Support -- Sorry for misunderstanding the problem. Since dbca hangs at 41% , I guessed that instance was started. That is strange. You said that the problem does not occur when you manually create the database using scripts. So this should be a problem within the DBCA Java program. I have done some search and I found followings : Bug:2461946 Abstract: CREATE DATABASE HUNGS UP WHEN WE SET DISK_ASYNCH_IO TRUE O/S: 46 Intel Based Server LINUX Status: 95,Closed, Vendor OS Problem The problem is identified as being OS configuration. Workaround : echo 1048576 /proc/sys/fs/aio-max-size and reboot. -- Note:160891.1 NETCA, DBCA, EMCA hangs and spins CPU in Oracle 9.0.1 on RedHat Linux 7.1 Solution: Use JRE not JDK. Me --- Guessed? No pmon, no smon, nothing seems to indicate no instance. I'm using Linux 7.2, not 7.1. I have Oracle 9.2.0.2, not 9.0.1 /proc/sys/fs/aio-max-size is a problem as there is no fs aio in RH 7.2. However, on our RH AS 2.1 machine, also with Oracle 9.2.0.2, dbca hangs also - and aio-max-size is already 1M. CPU was sleepy, not spinning (evidently in wash cycle). J-R-E J-D-K ... M-O-U-S-E Solution: Resurrect orainst /c Please close this TAR! I can't take any more! Thanks for your help! - TAR status is now SOFT CLOSED --- -- epilog -- I realize that this was a bit sarcastic, but... Every time I file a TAR anymore, I get this are you sure its plugged in? sort of treatment. I've been tempted several times to ask them: If there is a CUSTOMER_IS_A_BOZO flag somewhere in your database, could you please set it to FALSE - the default must be TRUE. I finally just stopped using Metalink months ago because it is so entirely useless and a huge waste of time. I thought this one might be easy though. Evidently, I was wrong. [It couldn't really be a problem with the DBCA Java program could it? Nah! Not from a company famous for its unbreakable software! And all their other Java-based GUI tools have always been flawless. ;-] I filed a TAR about 5 months ago about a 9i bug - extremely slow queries against v$datafile (select name from v$datafile). After jumping through entirely irrelevant hoops at support's request for a month, I just let the TAR die. Nobody was bothering to take anything I said seriously. I had uploaded a '10046' level 8 trace on my own initiative, ran tkprof against the query on both 8.1.7.4 (0.01 sec) and 9.2.0.2 (6.86 sec), uploaded both the .trc and the tkprof output for both, wrote up a detailed description of the differences (few except for time), and still got the idiot treatment. I said it was a bug and nobody would even consider the possibility. For about twelve
Re: Ref Cursor
Did you try with a 10046 trace? Could it be an array vs. non-array fetch thing? Which client environment are you using to fetch the rows from the ref cursor? There is no init.ora involved with this. /Bjrn. Bahar, Rivaldi (BBASSI-CHQ) wrote: Hi Listers, Is there any specific parameters (init.ora, etc) or tricks for Ref Cursor ? Applications that using Ref Cursor running very slow but those don't use Ref Cursor are running fast. Tia. -Riv- This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Bjrn Engsig, Miracle A/S Member of Oak Table Network [EMAIL PROTECTED] - http://MiracleAS.dk
Snapshot Too Old Error on Export !!!
Hi all I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error. I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours. The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day. Could somebody help me here, this is very critical to be running production without proper backups .! Thanx ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FYI: Installing Oracle Apps 11i on Linux
Hello AllThe link below contains a summary of my experiences in installingOracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1Professional).I'm posting it because I would really have appreciated being able to read something like this prior tostarting my installation :-)http://databee.com/apps11i_install.htmRegards- Dale-Need databases for development and test? You need DataBee - the low-hassle way to create, maintain and refresh test and development databases. http://www.DataBee.com
ORA-02046
I'm getting the following error while trying to select from table using dblink: ORA-02046 distributed transaction already begun Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing Oracle Apps 11i on Linux
Dale, thanks for sharing, this is going to be pretty useful in the future. I read the warnings and had a copy of Suse 7.0 at home so I've only ever installed it onto the recommended platform. Armed with your summary I may have a shot at installing it on 8.1. Cheers, Mike -Original Message- Sent: 21 February 2003 10:34 To: Multiple recipients of list ORACLE-L Hello All The link below contains a summary of my experiences in installing Oracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1 Professional). I'm posting it because I would really have appreciated being able to read something like this prior to starting my installation :-) http://databee.com/apps11i_install.htm Regards - Dale - Need databases for development and test? You need DataBee - the low-hassle way to create, maintain and refresh test and development databases. http://www.DataBee.com ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Snapshot Too Old Error on Export !!!
Jackson, As you have discovered , the issue is that other transactions are overwriting your read consistent view of the tables. Options could include 1) Running the export at a quite time (sounds like you have tried that but with only partial suucess) 2) Taking a direct export which reduces the time very considerably (especially if you do it at weekend) 3) Take subsets of the data using either a parameter file with export with a list of tables you are interested in and multiple exports (different parameter files of course) 4) Using the query option of export to again take subsets of data from the biggest tables Using options 3+ 4 means you need to put in some sort of means of capturing changes ( a IUD trigger to capture rowid's) but it will be very difficult to ensure integrity. Your last sentence is very worrying, I hope you are not using export as a means of backing up the database because from what you have said that is totally unreliable. Out of the above options only 1) will give you any sort of consistent view of the tables. John -Original Message- Sent: 21 February 2003 10:00 To: Multiple recipients of list ORACLE-L Hi all I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error. I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours. The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day. Could somebody help me here, this is very critical to be running production without proper backups .! Thanx ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i hanging when linking during install !!!
Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: REQUEST FOR BUSINESS RELATIONSHIP / NEXT OF KIN
Now I know where they got my e-mail... Pat. -Original Message- Sent: Thursday, February 20, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Sorry all, this was supposed to go to the OT list!! Mark -Original Message- Sent: 20 February 2003 09:22 To: Multiple recipients of list ORACLE-L Yay, I'm hitting one a day now!! I won't forward anymore, I could become the king of spam myself! ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: GRRRRR OWS
Title: Message Perhaps because no matter how many courses people attend, they won't learn how Oracle works without administering it in a real environment for a prolonged period of time. No database of previously reported cases can make technicians learn how to troubleshoot -- they must have been in situations where they were forced to find answers by themselves. Even if the helpdesk technician has a flawless memory, and memorized all the cases, he/she still won't be able to treat new cases. Not everyone can do that, and this is where the good DBAs get separated from the bad ones. Until such a trial occurs, then you get a mixed bag of technicians. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message-From: Charu Joshi [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 7:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: GR OWS in general since they moved most support to India you get analysts that are more interested in playing the blame game than solving problems. Being an Indian I am sad to hear this, but I have to admit there's some truth in it. It is difficult to analyze why it should be so, but it tallieswith my experience (albeit little) so far. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nelson, AllanSent: Wednesday, February 19, 2003 7:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: GR OWS Yes, in general since they moved most support to India, you get analysts that are more interested in playing the blame game than solving problems. Sigh, I miss the Aussies. I sometimes used to wait to submit a TAR until they were on shift just because I got better. faster solutions. I find that I generally know more about what's going on than the new first tier support people. Allan *DisclaimerThis message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of thismessage, or the taking of any action based on it, is strictly prohibited.*Visit us at http://www.mahindrabt.com
AW: Endianness using External Tables
Title: RE: Endianness using External Tables Hi Melissa Yes, I tried to do the same on a Windows PC today, but the results are the same (wrong byte order). Any other ideas ? I already reached the point, where I wrote a function, that converts the wrong integers back to hex and these back to the correct integer. Shouldn't be the way to go. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 20. Februar 2003 17:22An: Stefan JahnkeBetreff: RE: Endianness using External Tables Stefan, Just as a test, have you tried this to a different OS system besides LINUX? -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Endianness using External Tables Hi everybody I'm experiencing some problems with the endian byte order parameter while processing data files from a mainframe platform (OS/390). The data contains integers (smallint, 2 bytes long), which come in big endian format (high byte first). I'm importing the data on a Linux (PC) platform (Oracle 9.2.0.1.0 on SuSE 7.2). I used the following parameters: -- TDOMAIN: DROP TABLE SHINFRA.X_TDOMAIN; CREATE TABLE SHINFRA.X_TDOMAIN ( ZID_DOMAIN NUMBER (15,0), ZHI_ORGEINHEIT NUMBER (15,0), ZHI_SYSEINDAT CHAR (26), ZHI_SYSERSDAT CHAR (26), ZHI_SYSGUADAT DATE, ZHI_SYSGUBDAT DATE, ZHI_SYSMSGNR CHAR (26), ZHI_STATUS INTEGER, ZID_DOMAINBEZ NUMBER (15,0), ZDOMAINNAME CHAR(14) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY SHINFRADATA ACCESS PARAMETERS ( RECORDS FIXED 138 CHARACTERSET='WE8EBCDIC500' "DATA IS BIG ENDIAN" FIELDS REJECT ROWS WITH ALL NULL FIELDS ( ZID_DOMAIN POSITION(1:8) DECIMAL(15,0), ZHI_ORGEINHEIT POSITION(9:16) DECIMAL(15,0), ZHI_SYSEINDAT POSITION(17:42) CHAR(26), ZHI_SYSERSDAT POSITION(43:68) CHAR(26), ZHI_SYSGUADAT POSITION(69:78) CHAR(10) DATE_FORMAT DATE MASK "DD.MM.", ZHI_SYSGUBDAT POSITION(79:88) CHAR(10) DATE_FORMAT DATE MASK "DD.MM.", ZHI_SYSMSGNR POSITION(89:114) CHAR(26), ZHI_STATUS POSITION(115:116) INTEGER, ZID_DOMAINBEZ POSITION(117:124) DECIMAL(15,0), ZDOMAINNAME POSITION(125:138) CHAR(14) ) ) LOCATION ('TDOMAIN') ) REJECT LIMIT UNLIMITED; The field of interest here is ZHI_STATUS. If it is let's say 00 01 in Hex format in the original data file, I'll get a 256 decimal in the Oracle database, which points to a byte order problem, because that would be 01 00. I tried all combinations like DATA IS BIG ENDIAN, LITTLE ENDIAN or nothing. I get the following log file entries, but the result remains the same (256 instead of 1): LOG file opened at 02/20/03 13:53:53 Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file is in big endian format Reject rows with all null fields Fields in Data Source: ... LOG file opened at 02/20/03 13:54:33 Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file is in little endian format Reject rows with all null fields Fields in Data Source: ... LOG file opened at 02/20/03 13:55:26 Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file has same endianness as the platform Reject rows with all null fields Fields in Data Source: It looks like the DATA IS ENDIAN parameter doesn't do anything. Is there a mistake / misunderstanding on my side ? I already checked Metalink, but couldn't find anything pointing to a bug related to external tables and endianness or sql*loader and endianness. Any ideas ? I'm getting pretty desperate here. TIA, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201
Testing database links
Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HPUX SCSI Performance
Title: RE: HPUX SCSI Performance It turns out it's a bug with vxfs on all Itanium system's HP is starting to work on a patch for it hopefully it'll be out soon Thanks for the input though. David Hill -Original Message- From: Rich Holland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 9:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance Have you checked the queue depths? There are several parameters your admin can use to tune SCSI performance, but this is typically the first place to start with OLTP systems. You might also look at your buffer cache settings (HP-UX ships with these set at 10-20% I believe; in an Oracle environment, smaller cache often makes sense (anything from 2-10 depending on your I/O patterns). Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of david hill Sent: Wednesday, February 05, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance HPUX 11i version 1.6 for itanium on vxfs -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance What OS? What filesystem? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 05, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i hanging when linking during install !!!
I logged a TAR on Tuesday for the 9.2.0.2.0 patch on Tru64, same error -- turns out there is a shell memory allocation limit being reached. 161328.1 Relinking Oracle 9i on True64/HP-UX/Sun Fails With Out of Memory 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: Friday, February 21, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i hanging when linking during install !!!
Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit, maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is too low, and hence 'Out of Memory'. Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values for these parameters. Kernel rebuilding and rebooting of the server will be needed :( - Kirti -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication
Title: Message I was asked of a problem in a friend's site about replication. The problem. They implemented replication using Materialized Views with an refresh update of ON DEMAND and some immediate. It works for some days and suddenly some MV stop replicating. He has checked metalink, but can't open a TAR. Is there any recommendation that you can give him to check. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
JDBC driver parameters
Hello, We have an Java application wich is establish a database connection via JDBC driver, by using a parameter file: --- #JDBC_Driver=oracle.jdbc.driver.OracleDriver #JDBC_URL=jdbc:oracle:thin:@chicago.eos.elro:1521:dgesten #JDBC_User=... #JDBC_Password=... --- Sometime the connection time is very long. In the same time, if I try to connect via SQLPLUS, the connection is immediate ... Questions: 1. Is it possible to give SDU and TDU parameters on the JDBC connect string ? (tnsname isn't used by JDBC, true ?) I have SDU=32767 and TDU=32767 in my tnsnames.ora. It is quick, but it is a correct setting ? 2. Are response time given by wait_event view, like event="SQL*Net..." including JDBC connections ? 3. Is a big value in the event field time_waited (for SQL*Net ...) necessarily mention a network problem, or a bad parameter connection ? About wait_events, what do you think about this statspack ouptut ? Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn -- --- -- -- ... ... SQL*Net break/reset to clien 2 0 0 0 0.0 SQL*Net message from client 51,171 0 6,502,293 1271 40.5 SQL*Net more data from clien 81 0 14 2 0.1 SQL*Net message to client 51,171 0 9 0 40.5 Thanks for your help, have a nice week-end and ... I hope you will understand my english wich is so ugly :-( Jean -- Jean Berthold EOS - energie ouest suisse Chemin de Mornex 10 , CP 570 CH-1001 Lausanne , Switzerland Tel. : +41 (0)21 341 24 58 Fax : +41 (0)21 341 20 49 E-Mail : [EMAIL PROTECTED] ...Unix is like a wigwam - no windows, no gates, apache inside...
RE: ORA-02046
If on UNIX, running the oerr utility can be helpful to quickly find a bit more information about ORA errors: (I do not know, what's available on Windows). df2hp105 [oracle] = oerr ora 2046 02046, 0, distributed transaction already begun // *Cause: internal error or error in external transaction manager. // A server session received a begin_tran RPC before finishing // with a previous distributed tran. Check if there are any trace files generated to find any clues, else, open an iTAR (??). - Kirti -Original Message- Sent: Friday, February 21, 2003 5:19 AM To: Multiple recipients of list ORACLE-L I'm getting the following error while trying to select from table using dblink: ORA-02046 distributed transaction already begun Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Reports!
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: Veritas Agent for Oracle / incremental backups vs. hot
that's it. Thanks Jared. Pat. -Original Message- Sent: Friday, February 21, 2003 2:34 AM To: Multiple recipients of list ORACLE-L Not necessarily. If you're backing up vxfs with Veritas Netbackup and also have someother component from Veritas that I can't recall at the moment, filesystem incrementals are made at the FS block level. You only backup new blocks, or blocks that have been touched. Jared On Wednesday 19 February 2003 12:09, Nelson, Allan wrote: Actually assuming you checkpoint or commit at least once between backups it would not make any difference at all. An incremental backup catches changed files since the last backup which will typically be all your data files. SCN's get updated in all headers if any thing changes. Allan -Original Message- Sent: Wednesday, February 19, 2003 1:25 PM To: Multiple recipients of list ORACLE-L My manager asked me to assess how much smaller our backups would be if we were doing incremental backups of our database files, instead of the usual hot backups. We are running 8i on UNIX. I know that the answer is it depends and you can't really know 'till you try, but we are just looking for a ballpark figure, perhaps in percentages. Our databases are between OLTP and DSS, closer to DSS environment, this being a scientific site. Thanks. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Order of Redo log use
Jared, No they do not have to begin with 1 and in fact my 10 groups are currently 11 - 20. I too have rearranged/reorg'ed redo logs while the database was up. Mostly with success, but in one case linesize was too short when I built my script and production (V7.3) was briefly left with only one redo log. It also seems that my current conundrum is due to insufficient controls while adding new redo log groups to a live database in the past. Downtime is mostly for segment/tablespace reorg (no, not to compress extents ;-) ). Mike -Original Message- Sent: Thursday, February 20, 2003 4:02 PM To: Multiple recipients of list ORACLE-L Mike, Is there any reason your redo logs must begin with 1? You don't need to take the database down to do this, just start with a higher number. Or, if you insist on consecutive numbers starting with 1, just create a temp set of redo, drop the old ones, recreate them, then drop the temp set. I've done this a few times to resize/reorg redo on disk without taking the database down. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle unauthenticated remote system compromise (
Hi Kirti, We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to apply the 8.1.7.4 patch? Sometimes just read the note is very confusing, so just apply this patch to upgrade to 8.1.7.4? Joan Deshpande, Kirti wrote: Hello All, If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX 11.0, please let me know. It seems that the patch is not able to find a couple of required lib files. Nothing found on the Metalink of any help... (I will log an iTAR soon). No problem on AIX, though. Thanks. - Kirti -Original Message- Sent: Thursday, February 20, 2003 4:01 PM To: Multiple recipients of list ORACLE-L ) This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify me immediately. - Forwarded by Jared Still/Radisys_Corporation/US on 02/20/2003 01:58 PM - NGSSoftware Insight Security Research [EMAIL PROTECTED] 02/17/2003 02:09 PM To: [EMAIL PROTECTED] cc: Subject:Oracle unauthenticated remote system compromise (#NISR16022003a) NGSSoftware Insight Security Research Advisory Name:Oracle unauthenticated remote system compromise Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release 1, 8i, 8.1.7, 8.0.6 Severity: Critical Risk Category: Remote System Buffer Overrun Vendor URL: http://www.oracle.com Author: Mark Litchfield ([EMAIL PROTECTED]) Date: 16th February 2003 Advisory number: #NISR16022003a Description *** Oracle is the leader in the database market with a 54% market share lead under ERP (Enterprise Resource Planning). The database server is vulnerable to a remotely exploitable buffer overflow vulnerability. What exacerbates this problem is that no valid User ID or password is required by an attacker. Details *** There is a remotely exploitable buffer overflow vulnerability in the authentication process with the Oracle Database Server. By supplying an overly long username when attempting to log onto the database server an attacker can overflow a stack based buffer overwriting the saved return address. Any arbitrary code supplied by an attacker would execute with the same privileges as the user running the service; this account is typically Oracle on linux/unix based platforms and Local System on Windows based operating systems such as NT/2000/XP. As such this allows for a complete compromise of the data stored in the database and possibly a complete compromise of the operating system. As most client applications for Oracle will tuncate the length of the username that can be supplied to the database an attacker would need to write their own Oracle Authenticator to exploit this issue. That said, NGSSoftware has found one client application that will allow longer usernames so to test if you are vulnerable to this issue, use the LOADPSP utility usually found in bin directory found under the OracleHomeInstallDirectory. On Windows, for example, run: C:\ora9ias\BINloadpsp -name -user LONGUSERNAME/tiger@iasdb myfile Fix Information *** NGSSoftware alerted Oracle to this vulnerability on 30th September 2002. Oracle has reviewed the code and created a patch which is available from: http://otn.oracle.com/deploy/security/pdf/2003alert51.pdf NGSSoftware advise Oracle database customers to review and install the patch as a matter of urgency. A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite http://www.ngssoftware.com/software/squirrelfororacle.html It is further recommend that Oracle DBAs have their network/firewall administrators ensure that the database server is protected from Internet sourced traffic. Further Information *** For further information about the scope and effects of buffer overflows, please see http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf About NGSSoftware * NGSSoftware design, research and develop intelligent, advanced application security assessment scanners. Based in the United Kingdom, NGSSoftware have offices in the South of London and the East Coast of Scotland. NGSSoftware's sister company NGSConsulting, offers best of breed security consulting services, specialising in application, host and
Partition recovery question
I lost a data file that contained the tablespace for an empty partition. I dropped the datafile from Oracle, and the table itself seems okay, but I'm wondering what I can do with that partition. Can I simply merge that partition with another partition? Any ideas especially if you've encountered a similar situation would be welcome. Oracle 8.1.6 Alpha Tru64 Range partitions Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do you calcuate the temp space needed for view?
You might not have to increase the tablespace size. Maxextents = 121 is likely to be a bigger part of the problem. Query dba_tablespaces and look at your intial and next values as well as your maxextents parameter. You might find you have enough datafile space and are choking on the default storage clause for this TS. Alter tablespace default storage (initial XXX next XXX maxextents (505 or unlimited or whatever seems right to you) pctincrease (0 if you are using a uniform allocation strategy)) will get you out of this problem. Even adding datafiles will not help you with this specific problem as you are trying to sort something larger than the default storage clause for temp will allow. Allan -Original Message- Sent: Thursday, February 20, 2003 7:09 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I issue the following command select count(*) from view1 and encounter the following error ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP. I think I need to increase the tablespace TEMP but how do I calculate the temporary space needed ? Assuming view1 is select * from table1, table2 where table1.Col1=table2.Col1 Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * (table 2 row-length * table 2 total number of rows ) ? Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Snapshot Too Old Error on Export !!!
You might try running hot backups at the OS level instead. It sounds like your export is just taking too long. To get it to work with active users on board you might have to increase your rollback segments to truly ridiculous levels especially if you have large batches running while the export is running. To really understand the issue go to http://www.ixora.com.au and look at Steve Adams' material on snapshot too old. Allan -Original Message- Sent: Friday, February 21, 2003 4:00 AM To: Multiple recipients of list ORACLE-L Hi all I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error. I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours. The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day. Could somebody help me here, this is very critical to be running production without proper backups .! Thanx ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Teradata baned from IOUG???
go get'm big dawg In all honesty, this was educational to me as I'm not sure that a lot of people understand the process for the selection.. I have learned something today. And once that's accomplished, I need to celebrate.. So now I can go home and drink beer for the rest of the day:-) Matt-I65 was really ugly last weekend with the Sunday Ice:-) -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Teradata baned from IOUG??? Alright, Mogens. I'll stand up here. I'm one of the two DBA focus area managers (FAMs) for IOUG 2003. My fellow FAM and abstract reviewers (3 of them) and I are the ones who choose this presentation (along with all the others in the DBA track). None of us are employed by TUSC or by Oracle. You statement: "how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through." is technically accurate. The only other presentation with the word "ratio" in the title was rejected.However, there are a number ofotherspresentations that fall within this specific area oftuning by a number of people, including Roger Schrag, Cary Millsap,Jonathan Lewis, I cannot and will not go into the particulars of why a specific presentation was chosen, but I can tell you that no weight was given to the employer of the speaker. Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through. Funny how an abstract like the following nonsense makes it through the process. Just downright funny, strange and not very convincing... who in their right mind said this was a professional presentation that would be of interest to any serious optimiser guy or girl? Somebody must have said Aye to this. Are you ready? Here we go:"Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego).I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently.Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be
Re: Replication
Title: Message Is the MV set up for FAST REFRESH or COMPLETE? If FAST REFRESH, check to see if the tablespace of MV Log table, named MLOG$_tablename where tablename is the first 20 characters of the table on which the log is based, has enough space for the mlog$ to grow. If complete refresh, do it manually from command line exec DBMS_SNAPSHOT.REFRESH('tablename,'CF') and see what error message is given. A few things come to my mind (1) not enough temp space for the sorting to occur for he MV (2) not enough rollback segment space. Either way, you will see the exact error it fails on. HTH. Arup Nanda - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, February 21, 2003 8:19 AM Subject: Replication I was asked of a problem in a friend's site about replication. The problem. They implemented replication using Materialized Views with an refresh update of ON DEMAND and some immediate. It works for some days and suddenly some MV stop replicating. He has checked metalink, but can't open a TAR. Is there any recommendation that you can give him to check. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
recursive calls and DBMS_JOB
I'm trying to isolate high CPU consumers in a stressed application, and have noticed that I'm spending a lot of time doing recursive calls. Specifically, a high percentage of recursive calls and recursive CPU usage come from the following anonymous block: DECLARE job BINARY INTEGER :=job; next_date . My question is this: Are the recursive cpu/call stats that are accumulating a result of the procedures scheduled within DBMS_JOB (there are a handful of these procedures), or is this likely due to DBMS_JOB (and whatever logic it uses to keep itself doing what it should) itself? Thanks John Clarke Oracle DBA Centroid Systems, Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Clarke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. Allan -Original Message- Sent: Thursday, February 20, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing Oracle Apps 11i on Linux
No problem. If you can figure out a way to install it without using that ugly little adcrdb.sh hack that I had to do I would really appreciate you telling me. Except for that bit the install isn't too bad. Cheers - Dale thanks for sharing, this is going to be pretty useful in the future. I read the warnings and had a copy of Suse 7.0 at home so I've only ever installed it onto the recommended platform. Armed with your summary I may have a shot at installing it on 8.1. The link below contains a summary of my experiences in installing Oracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1 Professional). I'm posting it because I would really have appreciated being able to read something like this prior to starting my installation :-) http://databee.com/apps11i_install.htm Regards - Dale - Need databases for development and test? You need DataBee - the low-hassle way to create, maintain and refresh test and development databases. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Partition recovery question
Dennis, Why not just drop the partition? Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 9:19 AM I lost a data file that contained the tablespace for an empty partition. I dropped the datafile from Oracle, and the table itself seems okay, but I'm wondering what I can do with that partition. Can I simply merge that partition with another partition? Any ideas especially if you've encountered a similar situation would be welcome. Oracle 8.1.6 Alpha Tru64 Range partitions Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i hanging when linking during install !!!
It is likely that you will have to rebuild your kernel. If you start sam as root and go to kernel confiuration - configurable parameters you will find parameters named maxssiz and maxssiz_64bit. Adjust them to allow the stack enough space to perform your link. Note that you will only need to adjust one of them depending on whether you are 32 or 64 bit. We are on HP-UX 11i and maxssiz is set to about 8M. Caveat: We have not installed 9i on this box. On another 11i box where 9i has been installed (not by me) I find maxssize set to about 134M and maxssiz_64Bit set to about 1G. Hope this helps. Allan -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
Re: Testing database links
Charu, The view V$DBLINK can show you if the link is in use. select open_cursors, in_transaction from v$dblonk where db_link = 'mylink' HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 8:03 AM Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
need to compare long data against varchar2
Title: need to compare long data against varchar2 I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA
RE: Testing database links
V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Hey, just a minute - aren't you forgetting Dos... ? peter Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. Allan -Original Message- Sent: Thursday, February 20, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Teradata baned from IOUG???
If there is a demand, I will be happy to expound at some length on the processes by which the papers for our track were chosen, but I do believe that a different forum might be appropriate, as we are getting a bit far off the main topic of how to manage Oracle technology. We spent last weekend in Gatlinburg/Pigeon Forge The drive on I-75 from Knoxville, TN up to Lexington, KY and then I-64 over to Louisville was quite a drive as well. Send me an e-mail offline next time your going to be in the area and I'll introduce to the very fine products of the Bluegrass Brewing Company. Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]]Sent: Friday, February 21, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Teradata baned from IOUG??? go get'm big dawg In all honesty, this was educational to me as I'm not sure that a lot of people understand the process for the selection.. I have learned something today. And once that's accomplished, I need to celebrate.. So now I can go home and drink beer for the rest of the day:-) Matt-I65 was really ugly last weekend with the Sunday Ice:-) -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Teradata baned from IOUG??? Alright, Mogens. I'll stand up here. I'm one of the two DBA focus area managers (FAMs) for IOUG 2003. My fellow FAM and abstract reviewers (3 of them) and I are the ones who choose this presentation (along with all the others in the DBA track). None of us are employed by TUSC or by Oracle. You statement: "how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through." is technically accurate. The only other presentation with the word "ratio" in the title was rejected.However, there are a number ofotherspresentations that fall within this specific area oftuning by a number of people, including Roger Schrag, Cary Millsap,Jonathan Lewis, I cannot and will not go into the particulars of why a specific presentation was chosen, but I can tell you that no weight was given to the employer of the speaker. Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through. Funny how an abstract like the following nonsense makes it through the process. Just downright funny, strange and not very convincing... who in their right mind said this was a professional presentation that would be of interest to any serious optimiser guy or girl? Somebody must have said Aye to this. Are you ready? Here we go:"Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego).I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently.Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry
RE: Oracle 9i hanging when linking during install !!!
There's a note on metalink that covers some of the relevant parameters: 68105.1 'Commonly Misconfigured HP-UX Kernel Parameters'. 9i is a lot more resource hungry than 8i, and you need to make sure you have the right HP-UX patchsets. Cheers Simon Anderson Deshpande, Kirti [EMAIL PROTECTED]@fatcity.com on 21/02/2003 13:58:49 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit, maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is too low, and hence 'Out of Memory'. Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values for these parameters. Kernel rebuilding and rebooting of the server will be needed :( - Kirti -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN gui...in OEM 9.x i
I will echo Joe's sentiments on knowing the command line. It has the added benefits of not doing things you were unaware of after pushing the 'go' button, as the much better understanding of RMAN you will attain by learning to do it from the keyboard. Jared I'll echo Jared's comments here. I've basically taught myself RMAN this week - all via the console - and don't regret a minute of it. Don't be scared ... you can start with commands as simple as 'BACKUP DATABASE;' and 'RESTORE DATABASE; RECOVER DATABASE;' and build up from there (at least in 9.x). Another advantage of the console is the status messages provided during backup and recovery ... better than watching spinning wheels or an hour-glass in a GUI! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Snapshot Too Old Error on Export !!!
I would echo a previous post that you can't backup a database with the export utility. I suspect you get your error because you are using consistent=y in the export. The database is trying to give you data as of the time you started the export. The fact that you are getting the snapshot too old message is evidence that the data is changing while you are exporting -- to the extent that the database is eventually unable to keep doing it -- but these data changes will not be in the export file. A genuine backup using rman or the old alter tablespace begin backup method is the only proper backup. If you are trying to get production data to move into a test/development database schema, then export is certainly the most convenient way of doing it. If you are, in fact, trying to backup the database, here is something to get you started. If the filesystem to which your export file is going is big enough, consider using that filesystem to store a database backup instead of an export. Assuming it is /where/it/goes, try the following: Make sure sys (or system, if you prefer) has been granted sysdba in the database. Create two files with text similar to the following: for file named backup_database.rcv: -- snip - run { allocate channel ch1 type disk format '/where/it/goes/%U_DATA'; set command id to 'rman'; backup tag backup_db_full (database include current controlfile); release channel ch1; } - snip -- This will backup the database. for file named backup_arch.rcv - snip run { allocate channel ch1 type disk format '/where/it/goes/%U_ARCH'; set command id to 'rman'; change archivelog all crosscheck; backup (archivelog all delete input); backup ***This line and the next if you are duplexing archived logs*** (archivelog like '/directory/where/duplexed/archivelogs/are/%' delete input); release channel ch1; allocate channel ch1 type disk format '/where/it/goes/%U_CONTROL'; backup current controlfile tag='backup'; release channel ch1; sql ALTER DATABASE BACKUP CONTROLFILE TO ''/where/it/goes/CONTROL_FILE.BAK'' REUSE; } snip This will backup the archived logs and the control file. Note that the last command tells the database to make a physical copy of the control file. The reason for this is that rman has been writing backup info to the control while the backup is running. So you make a copy of it after the backup has completed in case you lose all copies of your control files. If your database and all control files got completely blown away, you can copy the control file copy back to where it was and start restoring. You might note that I backup the control file ... and back it up ... and back it up. That's just paranoia. You can put the whole thing into one file. The reason for having them separate is in case you need to free up space in the archive_log_dest by backing up just the archived logs. To run a backup, type in the following commands: rman nocatalog connect target sys/qwerty@DBNAME @backup_database.rcv @backup_arch.rcv exit Now, make sure you backup /where/it/goes directory to tape with whatever operating system backup utility you are using. One thing that can be added, if you want to be extra thorough, is to put in a log switch followed by an archive log current, after you run the archivelog backup. Then you run ANOTHER archivelog backup. In the world of Murphy's Law, you do it this way because your archive_log_dest will, some day, at the worst possible time, be unable to accommodate a log switch and archive log current. So you clean it out first prior to the log switch. It might be useful to know how to restore the database ... that's just something I saw written on a toilet stall wall. It seems reasonable. (... He who reads these words of wit, eats those little balls of ... ) I think the subject is probably more extensive than can be covered in a simple e-mail; so I won't try to cover it all. But, in it's simplest form, a recovery looks like: If the last rman backup has been deleted from /where/it/goes, restore those files from tape. startup mount the database (assuming the control file is NOT the thing you are restoring) rman nocatalog connect target sys/qwerty@DBNAME allocate channel ch1 type disk; restore database; restore archivelog all; recover database; release channel ch1; open the database. See, rman isn't so bad. It's biggest problem is that, if you start to like it, then it can lead to other things such as liking vi, growing a beard, and wearing suspenders. (Obviously, I have a rare day here where I don't have a lot to do. Hence, the verbose reply.) -Original Message- Could somebody help me here, this is very critical to be running production without proper backups .! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Oh Where Oh Where Is My Redo Coming From
Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oh Where Oh Where Is My Redo Coming From
Ethan - 28-gig GAAAK! Ideas: 1. Sample your SQL buffer to start getting some ideas. 2. Use LogMiner to read some of the archive logs to see the DML statements. You can also directly see how much redo is being generated by each statement. I think you have the right idea, probably some inefficient updates. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 21, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i hanging when linking during install !!!
Jackson, I can't say it for HP-UX, but in Tru64 Unix, a cousin-in-law of HP-UX, the error can occur if the ulimit is set too low. Check MetaLink Note 166350.1 for information on how to check and set the ulimit. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 6:58 AM Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep 64 /dev/null ; \ then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M ; \ else echo ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o /dev/null 21 ; then echo -loraolap9 ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep kxmnsd.o /dev/null 21 ; then echo ; else echo -lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o /dev/null 21 ; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-02046
check dba_2pc_pending, there may be entries in there. Oracle follows the 2-phase commit method when queries are submitted from stored programming units, it is default behaviour that cannot be changed. We ran into this with a Web application that was doing remote querying, and Oracle said the only workaround for queries is issue a set transaction read only before the query is submitted. (though maybe this isn't the problem at all for your situation... ) HTH 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: Friday, February 21, 2003 10:04 AM To: Multiple recipients of list ORACLE-L If on UNIX, running the oerr utility can be helpful to quickly find a bit more information about ORA errors: (I do not know, what's available on Windows). df2hp105 [oracle] = oerr ora 2046 02046, 0, distributed transaction already begun // *Cause: internal error or error in external transaction manager. // A server session received a begin_tran RPC before finishing // with a previous distributed tran. Check if there are any trace files generated to find any clues, else, open an iTAR (??). - Kirti -Original Message- Sent: Friday, February 21, 2003 5:19 AM To: Multiple recipients of list ORACLE-L I'm getting the following error while trying to select from table using dblink: ORA-02046 distributed transaction already begun Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: need to compare long data against varchar2
Title: FW: need to compare long data against varchar2 This worked for me. I got the getlong code from a post by ORACLEtune on expertsexchange. select object_name from dba_objects where object_id in (select obj# from sys.view$ where getlong('sys.view$','text',rowid) like '%table_name%') ~~ create or replace function getlong( p_tname in varchar2, p_cname in varchar2, p_rowid in rowid ) return varchar2 as l_cursor integer default dbms_sql.open_cursor; l_n number; l_long_val varchar2(4000); l_long_len number; l_buflen number := 4000; l_curpos number := 0; begin dbms_sql.parse( l_cursor, 'select ' || p_cname || ' from ' || p_tname || ' where rowid = :x', dbms_sql.native ); dbms_sql.bind_variable( l_cursor, ':x', p_rowid ); dbms_sql.define_column_long(l_cursor, 1); l_n := dbms_sql.execute(l_cursor); if (dbms_sql.fetch_rows(l_cursor)0) then dbms_sql.column_value_long(l_cursor, 1, l_buflen, l_curpos , l_long_val, l_long_len ); end if; dbms_sql.close_cursor(l_cursor); return l_long_val; end getlong; -Original Message- From: Markham, Richard Sent: Friday, February 21, 2003 10:20 AM To: oracle-l ([EMAIL PROTECTED]) Subject: need to compare long data against varchar2 I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA
Re: Programming languages that make DBA's lives easier
Add me to the count. Though, I was making rubles not $$$ using it -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 9:49 AM FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: need to compare long data against varchar2
It wouldn't be too difficult to craft a solution using the to_lob function, global temporary tables and the owa_pattern package. Read the docs on to_lob, and you'll see that it's functionality is limited to use with inserts, hence the use of the global temporary table, though not strictly necessary. A regular table would work as well. Jared On Friday 21 February 2003 07:19, Markham, Richard wrote: I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA Content-Type: text/html; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Yeah Yeah Yeah ! peter . FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Endianness using External Tables
Title: RE: Endianness using External Tables It's pretty inconsistent. Using just "DATA IS BIG ENDIAN" and "BYTEORDERMARK NOCHECK", it usually doesnn't work, but I also got cases, where it actually did work. The DDL scripts are generated and the data looks the same. I used SQL*LOADER now and it works. I guess we will raise a tar and before that isn't completely solved, we'll just go with loader again. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Gesendet: Freitag, 21. Februar 2003 15:06An: Stefan JahnkeBetreff: RE: Endianness using External Tables Did you try changing the characterset to UTF16? The only other thing I can think of is to try another datatype instead of integer try smallint, byteint, zoned or something to see if it will convert appropriately. -Original Message-From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]Sent: Friday, February 21, 2003 8:15 AMTo: Godlewski, MelissaCc: Oracle List Fatcity (E-Mail)Subject: AW: Endianness using External Tables Hi Melissa Yes, I tried to do the same on a Windows PC today, but the results are the same (wrong byte order). Any other ideas ? I already reached the point, where I wrote a function, that converts the wrong integers back to hex and these back to the correct integer. Shouldn't be the way to go. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 20. Februar 2003 17:22An: Stefan JahnkeBetreff: RE: Endianness using External Tables Stefan, Just as a test, have you tried this to a different OS system besides LINUX? -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Endianness using External Tables Hi everybody I'm experiencing some problems with the endian byte order parameter while processing data files from a mainframe platform (OS/390). The data contains integers (smallint, 2 bytes long), which come in big endian format (high byte first). I'm importing the data on a Linux (PC) platform (Oracle 9.2.0.1.0 on SuSE 7.2). I used the following parameters: -- TDOMAIN: DROP TABLE SHINFRA.X_TDOMAIN; CREATE TABLE SHINFRA.X_TDOMAIN ( ZID_DOMAIN NUMBER (15,0), ZHI_ORGEINHEIT NUMBER (15,0), ZHI_SYSEINDAT CHAR (26), ZHI_SYSERSDAT CHAR (26), ZHI_SYSGUADAT DATE, ZHI_SYSGUBDAT DATE, ZHI_SYSMSGNR CHAR (26), ZHI_STATUS INTEGER, ZID_DOMAINBEZ NUMBER (15,0),
Autoextend on Oracle 7.3.4.5.0
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4: SQL desc dba_data_files Name Null? Type --- FILE_NAME VARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) SQL Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend? Thank-you, SB
RE: RMAN gui...in OEM 9.x i
RMAN is cool. Especially in 9i since everything is automated, as in channel allocation and such. RMAN in 8i was a bit painfull since a couple of steps were manually necessary. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Automatic Segment Space Management
It's interesting you should mention the 'select for update' in this context. I'm still working on a puzzle where I do: create table t1 (n1 number); insert into t1 values (0); insert into t1 values(1); commit; select rowid from t1 where n1 = 0; for i in 1..1000 loop update t1 set n1 = n1 + 1 where n1 = i; end loop;-- updates the '1' row 1,000 times. / Now, without committing - start another session that does: select n1 from t1 where rowid = '{value seen above for n1 = 0} for update; Repeat the experiment, but the second time do: update t1 set n1 = 99 where rowid = '{value seen above for n1 = 0}; Why does one of these statements to 1000 CR gets, whilst the other does none ? How different are they - they both put an ITL entry on the block, and change the row content - they both need to be able to lock the row. I think this may have some bearing on your 'large number of CR reads' - I too have seen sites where the numbers got very large (in part because the CR limit doesn't seem to be considered if there are free blocks (state = 0) around to be used). But if the code does 'select for update, update' - then it takes a long time to make a CR copy in a busy enviornment, so if concurrency is high on that block, then I guess the evolving (or is that devolving) CR block is pinned for a long time - allowing lots more CR blocks to be created. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 February 2003 20:58 Stephan just passed this on to me... Cary, I really must subscribe to this mail list, but until I do, maybe you can pass this on. You are correct, the _db_block_max_cr_dba parameter is just a guide. I believe that when needing to create a new CR copy and this limit has been reached Oracle tries to place any older CR buffers (not sure if it does all of them or oldest found) to the cold end of the LRU ready to leave the cache at the next possible opportunity. If the buffer has any users or waiters (can be seen in x$bh), then the CR buffer will remain in cache until next time. When a new CR buffer is created, and an older CR buffer no longer has users or waiters, it should be aged out of the cache as soon as possible. I hope this helps, Stephan Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -Original Message- Millsap Sent: Thursday, February 20, 2003 1:41 PM To: Multiple recipients of list ORACLE-L Anjo personally saved my bacon when I was at a site in Dallas with this problem. This particular problem was a vendor application ported from Sybase and thus used select from blah_id for update; update blah; commit; instead of Oracle sequences. These guys had 1,200+ CR copies of each little 1-row-1-column id table in their system. In the end, the vendor repaired its app to use sequence numbers (within the week, actually!), and the problem which had caused daily shutdown/restarts ended instantly. The 42 patch, as it was called at the time, would have helped reduce the severity of the problem, but it wouldn't have solved it. I was pretty proud of myself when the engagement was done, but a monkey could have probably executed my part in the project if the monkey had known how to call Anjo. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -Original Message- Sent: Thursday, February 20, 2003 1:04 PM To: Multiple recipients of list ORACLE-L The _db_block_max_cr_dba parameter was put in to fix this problem with massive number of CR copies (segment header blocks mostly). I remember seeing a test case that had 1500+ CR copies of the segment header block. So the fix was to limit the number of CR copies. The parameter _db_block_max_cr_dba had initially a default value of 42 (really). And worked perfectly, but it was brok in Parallel Server, the reason for it not working was very funny. While scanning the hash chain for the right (tsn, rdba) the CR code may already stop if it finds the best fit and never scan all the buffers and there it can't enforce the limit of 6. Another reason could be that the buffers are pinned (in use), but they should be flushed out later if the same buffer hash chain is scanned again for the (tsn, rdba). In version8 I have seen a particular test case with over 60+ CR copies of a index root block (running many processes doing
Re: Oracle unauthenticated remote system compromise (
On Fri, Feb 21, 2003 at 06:43:48AM -0800, Joan Hsieh wrote: Hi Kirti, We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to apply the 8.1.7.4 patch? Sometimes just read the note is very confusing, so just apply this patch to upgrade to 8.1.7.4? Frankly, I don't think it matters what version you run. If Oracle support is inadequate what difference does it make if you run supported or not? 1. 8.1.7.4 is a supported product, but there will be no fully tested patchset for the product (tar 2917445.999). You have to apply the one-off patches, the ones they suggest you not apply (Doc ID: 189489.1). Read: 8i isn't supported anymore in practice. 2. I opened a tar last week asking if the patches for alerts # 48-51 would be included in the 9.2.0.3 patchset. Still no answer, still no patchset. Read: Your last line of defense has moved out from Oracle software to the firewall. Skip Oracle support and verify your firewalls are functioning well. Install host based firewalls such as iptables or ipfilters. Sun has something called Sunscreen. This should be done whether Oracle figures out their mess or not. Joan Deshpande, Kirti wrote: Hello All, If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX 11.0, please let me know. It seems that the patch is not able to find a couple of required lib files. Nothing found on the Metalink of any help... (I will log an iTAR soon). No problem on AIX, though. Thanks. - Kirti -Original Message- Sent: Thursday, February 20, 2003 4:01 PM To: Multiple recipients of list ORACLE-L ) This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify me immediately. - Forwarded by Jared Still/Radisys_Corporation/US on 02/20/2003 01:58 PM - NGSSoftware Insight Security Research [EMAIL PROTECTED] 02/17/2003 02:09 PM To: [EMAIL PROTECTED] cc: Subject:Oracle unauthenticated remote system compromise (#NISR16022003a) NGSSoftware Insight Security Research Advisory Name:Oracle unauthenticated remote system compromise Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release 1, 8i, 8.1.7, 8.0.6 Severity: Critical Risk Category: Remote System Buffer Overrun Vendor URL: http://www.oracle.com Author: Mark Litchfield ([EMAIL PROTECTED]) Date: 16th February 2003 Advisory number: #NISR16022003a Description *** Oracle is the leader in the database market with a 54% market share lead under ERP (Enterprise Resource Planning). The database server is vulnerable to a remotely exploitable buffer overflow vulnerability. What exacerbates this problem is that no valid User ID or password is required by an attacker. Details *** There is a remotely exploitable buffer overflow vulnerability in the authentication process with the Oracle Database Server. By supplying an overly long username when attempting to log onto the database server an attacker can overflow a stack based buffer overwriting the saved return address. Any arbitrary code supplied by an attacker would execute with the same privileges as the user running the service; this account is typically Oracle on linux/unix based platforms and Local System on Windows based operating systems such as NT/2000/XP. As such this allows for a complete compromise of the data stored in the database and possibly a complete compromise of the operating system. As most client applications for Oracle will tuncate the length of the username that can be supplied to the database an attacker would need to write their own Oracle Authenticator to exploit this issue. That said, NGSSoftware has found one client application that will allow longer usernames so to test if you are vulnerable to this issue, use the LOADPSP utility usually found in bin directory found under the OracleHomeInstallDirectory. On Windows, for example, run: C:\ora9ias\BINloadpsp -name -user LONGUSERNAME/tiger@iasdb myfile Fix Information *** NGSSoftware alerted Oracle to this vulnerability on 30th September 2002. Oracle has reviewed the code and created a patch which is available from: http://otn.oracle.com/deploy/security/pdf/2003alert51.pdf NGSSoftware advise Oracle database customers to review and install the patch as a matter of urgency. A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool
Re: Oh Where Oh Where Is My Redo Coming From
Hi, The simpler approach is to check the user level redo (or session level redo) using the v$sysstat,sesstat views and you can find the programmes associated with those huge (!) redo. Dumping the redologs and analyzing is just complex when you have a simple solution ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oh Where Oh Where Is My Redo Coming From
It might work to turn on monitoring on the tables. alter table xyz monitoring; Then periodically check dba_tab_modifications. -Original Message- The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How do you calcuate the temp space needed for view?
There are 2 issues here. First the error. What version of Oracle are you using? Is the TEMP tablespace set up as TEMPORARY? What block size are you using (impacts max extents on older versions of Oracle)? If you are not the only user on the system, you must also account for other sorts that are occuring at the same time. Second, the calculation. The calculation you put forward would be reasonably accurate if you were performing a cartesian product. In the case of the view, how many rows match the criteria. If each table has 1,000,000 rows and the average row length is 1k, then each table consumes roughly 1,024,000,000 bytes. If we plug this into your formula.. (1024 * 100) * (1024 * 100) = 102400 * 102400 = 1048576 or 931 petabytes (1024 gig = 1 petabyte). (Note to self, buy EMC stock). A more accurate method would be to determine how many records will be returned by the query (each table can be queried independently). For each record in table1(parent), how many records will be returned in table2(child)? Get an average, say that for each record in table1, an average of 2 records in table2 will be returned. At this point you need to reverse the numbers for the calculation. Why? Each child will 'attach' to its own copy of the parent record. So, take the size of table2 (# of rows * row length) and add it to the size of table1 (# of rows * row length) * the average number of children. This calculation is not exact and does not account for overhead, hwm, etc. But I have used it in some data warehousing systems (back when disk was not so cheap) and it worked out reasonably well. Dan Fink CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, I issue the following command select count(*) from view1 and encounter the following error ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP. I think I need to increase the tablespace TEMP but how do I calculate the temporary space needed ? Assuming view1 is select * from table1, table2 where table1.Col1=table2.Col1 Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * (table 2 row-length * table 2 total number of rows ) ? Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Name Server questions
Hi DBAs, Oracle 8.1.6 WinNT I am trying to understand how Oracle Names is configured. We have a Oracle Names database on server 1. We also have 2 other oraclenames services on server 2 and 3. I understand how server 1 was created and works. What I do not understand is the services on server 2 and 3. How they got created,etc. Server 2 and 3 are in the sqlnet.ora file. My question is what oracle utility is used to create those services and how they are configured to work with the database on server 1? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier I much pefer Oberon or Scheme. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Weiss, Rick [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? oops.. Just talked with the good old Veritas/Sun boys the software would need to be there to handle and configure the inter-connoect:-) -Original Message- From: Loughmiller, Greg Sent: Friday, February 21, 2003 12:20 PM To: '[EMAIL PROTECTED]' Subject: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Subject: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle unauthenticated remote system compromise (
Joan, You may want to log in an iTAR to find out if this patch can be applied to 8.1.7.2. The note said it was for 8.1.7.4 and I have been applying it to only 8.1.7.4 software on our servers. Other lower versions of 8.1.7.x are not patched, as we are upgrading those databases to 8.1.7.4. HTH, Regards, - Kirti -Original Message- Sent: Friday, February 21, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Hi Kirti, We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to apply the 8.1.7.4 patch? Sometimes just read the note is very confusing, so just apply this patch to upgrade to 8.1.7.4? Joan Deshpande, Kirti wrote: Hello All, If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX 11.0, please let me know. It seems that the patch is not able to find a couple of required lib files. Nothing found on the Metalink of any help... (I will log an iTAR soon). No problem on AIX, though. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oh Where Oh Where Is My Redo Coming From
Which version of Oracle ? Has someone switched on supplemental logging at the database level, perhaps ? Have you got dbms_job kicking in every 5 seconds with job_queues set to 10 ? (Honest, I have seen it happen, and the effect on redo was astonishing - and there was only one job actually ever available to run). Does the application use lots of transient tables which it fills and then deletes / rolls back. Is the volume of redo very much larger than the volume of UNDO, as this may indicate table creation, index rebuilds, mass inserts rather than update activity (which would tend to leave the redo in the ballpark of double the undo). Are there any files with an extreme number of writes (other than temporary tablespace files of course) - as you might want to track the objects in those files rather than trying to monitor the whole database. Are there any files with lots of multiblock writes - (apart from temp) as this tends to indicate table moves, index rebuilds, as well as direct mode inserts. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 21 February 2003 17:35 Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Testing database links
Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Autoextend on Oracle 7.3.4.5.0
Title: Message IIRC, you needed FILE$ or FILEXT$ - something like that anyway (those brain cells are long gone, I'm afraid!) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sam BootsmaSent: Friday, February 21, 2003 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: Autoextend on Oracle 7.3.4.5.0 We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4: SQL desc dba_data_files Name Null? Type --- FILE_NAME VARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) SQL Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend? Thank-you, SB
AW: Programming languages that make DBA's lives easier
Is it smiliar to FORTKNOX ? I heard that there are also big bucks to make. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Weiss, Rick [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 21. Februar 2003 15:49 An: Multiple recipients of list ORACLE-L Betreff: RE: Programming languages that make DBA's lives easier FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
Re: Veritas Agent for Oracle / incremental backups vs. hot
You're welcome. Since you're interested in that, Veritas can also backup databases in the same way, though we don't have the product for that. Block level incrementals without RMAN. Pretty cool stuff if you ask me, provided recovery is as simple as it is with RMAN. They can work magic when they own the filesystem. ( vxfs ) Jared On Friday 21 February 2003 05:29, Boivin, Patrice J wrote: that's it. Thanks Jared. Pat. -Original Message- Sent: Friday, February 21, 2003 2:34 AM To: Multiple recipients of list ORACLE-L Not necessarily. If you're backing up vxfs with Veritas Netbackup and also have someother component from Veritas that I can't recall at the moment, filesystem incrementals are made at the FS block level. You only backup new blocks, or blocks that have been touched. Jared On Wednesday 19 February 2003 12:09, Nelson, Allan wrote: Actually assuming you checkpoint or commit at least once between backups it would not make any difference at all. An incremental backup catches changed files since the last backup which will typically be all your data files. SCN's get updated in all headers if any thing changes. Allan -Original Message- Sent: Wednesday, February 19, 2003 1:25 PM To: Multiple recipients of list ORACLE-L My manager asked me to assess how much smaller our backups would be if we were doing incremental backups of our database files, instead of the usual hot backups. We are running 8i on UNIX. I know that the answer is it depends and you can't really know 'till you try, but we are just looking for a ballpark figure, perhaps in percentages. Our databases are between OLTP and DSS, closer to DSS environment, this being a scientific site. Thanks. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AIX question
Title: AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Subject: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Veritas Agent for Oracle / incremental backups vs. hot
FYI... I think BLIB is the tool you're thinking of... It stands for Block Level Incremental Backup... Tim -Original Message- Sent: Friday, February 21, 2003 1:34 AM To: Multiple recipients of list ORACLE-L Not necessarily. If you're backing up vxfs with Veritas Netbackup and also have someother component from Veritas that I can't recall at the moment, filesystem incrementals are made at the FS block level. You only backup new blocks, or blocks that have been touched. Jared On Wednesday 19 February 2003 12:09, Nelson, Allan wrote: Actually assuming you checkpoint or commit at least once between backups it would not make any difference at all. An incremental backup catches changed files since the last backup which will typically be all your data files. SCN's get updated in all headers if any thing changes. Allan -Original Message- Sent: Wednesday, February 19, 2003 1:25 PM To: Multiple recipients of list ORACLE-L My manager asked me to assess how much smaller our backups would be if we were doing incremental backups of our database files, instead of the usual hot backups. We are running 8i on UNIX. I know that the answer is it depends and you can't really know 'till you try, but we are just looking for a ballpark figure, perhaps in percentages. Our databases are between OLTP and DSS, closer to DSS environment, this being a scientific site. Thanks. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
I believe this is true for Linux platform only. -Original Message- Sent: Friday, February 21, 2003 8:16 AM To: Multiple recipients of list ORACLE-L I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Whoever told you that must have been on some new form of drug. RAC runs on top of cluster software from the vendors. The cluster needs to be working before you can install RAC. How you do that without the OS cluster software is beyond me. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Sent: Friday, February 21, 2003 8:16 AM To: Multiple recipients of list ORACLE-L I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Snapshot Too Old Error on Export !!!
In addition to the other comments about export not being a backup, let me add a few things. Managing the trade off between many rollback segments (good for oltp performance) and large rollback segments (necessary to avoid 1555) is often a tough one. As somebody else said, you can optimize export performance by doing direct path, but besides that, the time it takes to export each individual table (that would be the entire export if consistent=yes) must be smaller than the time it takes for any rollback segment to wrap (note, this is not the WRAP column of v$rollstat, rather you should compare the growth of the WRITES column with the RSSSIZE column). If need an idea on a running system about how long the longest query can be without running into 1555, the attached can be used. It basically looks at v$rollstat twice with 10 seconds between them, and estimates how many hours it will take for the most rapidly used rollback segment to wrap. On a less busy system, you may want to modify the 10 seconds to something larger. BTW, at a ct. I was working on, we had to go to 100 segments (due to OLTP requirements) of 1GB each (due to requirements to allow 4-5 hour queries to run without 1555 risk). Yes, this is 100Gb of rollback:-) /Bjørn. Jackson Dumas wrote: Hi all I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error. I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours. The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day. Could somebody help me here, this is very critical to be running production without proper backups .! Thanx ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Bjørn Engsig, Miracle A/S Member of Oak Table Network [EMAIL PROTECTED] - http://MiracleAS.dk rem before running this, do rem SQL create table temprollstat as select * from v$rollstat where 1=42 rem variable varchar2(100); insert into temprollstat select * from v$rollstat / exec : := to_char(sysdate,'DD-MON- HH24:MI:SS'); prompt hang on, waiting 10s to inspect undo bytes written... host sleep 10 select l.usn, t.writes - l.writes byteswritten, to_char((sysdate-to_date(:,'DD-MON- HH24:MI:SS'))*24*t.rssize/( t.writes - l.wr ites ), '99.9') hoursbeforewrap from temprollstat l, v$rollstat t where l.usn = t.usn and t.writes != l.writes order by byteswritten / rollback /
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier For some reason http://mindprod.com/unmain.html comes to my mind. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *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.*1
RE: Oh Where Oh Where Is My Redo Coming From
Ethan, monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. Note that the amount of redo does not depend on the average row size. It depends on the amount of _change_ (+ some overhead). This argument might skew the situation towards a table that has a large row size but that does not have that many updates... I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. What you _do_ need to do is to use this SQL to detect the SIDs performing redo: select sid, name, value from v$statname n, v$sesstat v where v.statistic# = n.statistic# and name like 'redo size' and value 10 order by value desc You can then look at V$OPEN_CURSORS for those SIDs... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: need to compare long data against varchar2
Title: need to compare long data against varchar2 Mark Not that I have an answer for you, but what about synonyms to tables / views being referenced ? Ferenc MantfeldDreaming costs you nothing. Not dreaming costs you everything. - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Saturday, February 22, 2003 2:19 AM Subject: need to compare long data against varchar2 I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA
Re: Programming languages that make DBA's lives easier
LOL - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 8:39 AM Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oh Where Oh Where Is My Redo Coming From
So here are two takes at the problem, one takes a look at costly (in regards to amount of redo) tables and the other indexes. Note this is only a way to guestimate this information. select owner, table_name, round((ratio_to_report(ttl) over ()) * 100, 1) as percent_ratio from ( select (m.inserts+m.deletes+m.updates)*t.avg_row_len ttl, t.owner, t.table_name from dba_tables t, all_tab_modifications m where t.table_name=m.table_name and t.owner=m.table_owner ) order by 3 desc; select owner, table_name, round((ratio_to_report(ttl) over ()) * 100, 1) as percent_ratio from ( select count(*)*sum((m.inserts+m.deletes+m.updates)) ttl, i.owner, i.table_name from all_indexes i, all_ind_columns c, all_tab_modifications m where i.index_name=c.index_name and i.table_name=c.table_name and i.owner=m.table_owner and i.table_name=m.table_name group by i.owner, i.table_name ) order by 3 desc; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication
Title: Message Thks Arup, I'll let him know those points. Tks -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent: Friday, February 21, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Replication Is the MV set up for FAST REFRESH or COMPLETE? If FAST REFRESH, check to see if the tablespace of MV Log table, named MLOG$_tablename where tablename is the first 20 characters of the table on which the log is based, has enough space for the mlog$ to grow. If complete refresh, do it manually from command line exec DBMS_SNAPSHOT.REFRESH('tablename,'CF') and see what error message is given. A few things come to my mind (1) not enough temp space for the sorting to occur for he MV (2) not enough rollback segment space. Either way, you will see the exact error it fails on. HTH. Arup Nanda - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, February 21, 2003 8:19 AM Subject: Replication I was asked of a problem in a friend's site about replication. The problem. They implemented replication using Materialized Views with an refresh update of ON DEMAND and some immediate. It works for some days and suddenly some MV stop replicating. He has checked metalink, but can't open a TAR. Is there any recommendation that you can give him to check. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Oh Where Oh Where Is My Redo Coming From
Title: RE: Oh Where Oh Where Is My Redo Coming From Ethan, I think focusing on which transaction generates more redo will be more helpful than which object ... right? Let me know if I didn't understand your question completely ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Oh Where Oh Where Is My Redo Coming From Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: Oh Where Oh Where Is My Redo Coming From
Indexes on such tables which has DML... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 21 Feb 2003 07:44:18 -0800 Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Name Server questions
Rick, NAMESCTL is your best friend here. Look up notes 113036.1 and 60535.1 on Metalink (I have stopped referring to ML as MetaStink and MetaBlink!) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Subject: Name Server questions Hi DBAs, Oracle 8.1.6 WinNT I am trying to understand how Oracle Names is configured. We have a Oracle Names database on server 1. We also have 2 other oraclenames services on server 2 and 3. I understand how server 1 was created and works. What I do not understand is the services on server 2 and 3. How they got created,etc. Server 2 and 3 are in the sqlnet.ora file. My question is what oracle utility is used to create those services and how they are configured to work with the database on server 1? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
select * from filext$; AFAIK an entry here means this file is now in auto-extend mode. HTH YMMV HAND! Sam Bootsma [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .on.ca cc: Sent by: Subject: Autoextend on Oracle 7.3.4.5.0 [EMAIL PROTECTED] 02/21/2003 07:44 AM Please respond to ORACLE-L We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4: SQL desc dba_data_files NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER BLOCKS NUMBER STATUS VARCHAR2(9) SQL Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend? Thank-you, SB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
I think thats the goal of .NET CLI. Write in anything ... mix and match. On Fri, 21 Feb 2003, Nelson, Allan wrote: Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. Allan -Original Message- Sent: Thursday, February 20, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Programming languages that make DBA's lives easier
Does Oracle have punch cards with their logo on them? How do we order some? We need some for our Fortran applications... ; ) Pat. -Original Message- Sent: Friday, February 21, 2003 10:49 AM To: Multiple recipients of list ORACLE-L FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Your Oracle sales person is incorrect. I would ask him to see if he can actually prove it. Oracle provides clustering components for Linux and NT only at this time. Oracle does provide a RACpatch for SC2.2 and 3.0 with 9iR2 and that patch needs to be installed after you install SC and before install RAC. Hope this helps, Scott --- dist cash [EMAIL PROTECTED] wrote: I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oh Where Oh Where Is My Redo Coming From
Ethan, v$sess_io will provide a list of the sessions generating block changes and, therefore, redo. Link this back to v$session, etc. for the 'offending' sessions, sql. I've used this several times with great success. Sometimes it was a data load, others it was bad sql. When you change a block (insert/update/delete), you also generate changes to indexes, undo segments (1 change for each row and 1 change for each index affected) and perhaps the data dictionary for space management. Dan Fink Post, Ethan wrote: Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this redo without going through the hassle of mining a bunch of log files. It occurred to me that if table monitoring is active and my stats are up to date I should be able to multiply the total number of updates, inserts and commits by the average row size and get a rough % of what objects are generating the most redo. I am sure there are a number of other factors I need to consider, any ideas what they are? * Should I weight inserts, updates and deletes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Greg, Sorry to be picky but you can still use raw Devices with Veritas DBE/AC 3.5 if you don't want to use thier CFS. If you use SC then your only choice is raw and you probably will need Veritas to manage you LVM's anyway. Scott --- Loughmiller, Greg [EMAIL PROTECTED] wrote: news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oh Where Oh Where Is My Redo Coming From
Yes, that is what I was saying, however large rows or tables with a lot of indexes would also be prone to generate more redo, that is why I suggest joining DBA_TAB_MODIFICATIONS to DBA_TABLES to get avg_row_len and DBA_IND_COLUMNS to get the total # of columns indexes on the table, the thought being the more columns the more likley updates, inserts and deletes will cause index generated redo. See my other post for the solution (SQL) I came up with. - Ethan -Original Message- Sent: Friday, February 21, 2003 10:44 AM To: Multiple recipients of list ORACLE-L It might work to turn on monitoring on the tables. alter table xyz monitoring; Then periodically check dba_tab_modifications. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Snapshot Too Old Error on Export !!!
Stephen, My understanding is having consistent=y uses no rollback, since the changes occurring during the export are not being captured in the export dump. on few occasions i've still got the spurious ora-1555(snap shot too old)error on exporting a 80GB highly transactional database which terminates the export. am i thinking wrong?? help!! Sunil Nookala DBA 3-4502 907-9255(pager) -Original Message- Sent: Friday, February 21, 2003 10:35 AM To: Multiple recipients of list ORACLE-L I would echo a previous post that you can't backup a database with the export utility. I suspect you get your error because you are using consistent=y in the export. The database is trying to give you data as of the time you started the export. The fact that you are getting the snapshot too old message is evidence that the data is changing while you are exporting -- to the extent that the database is eventually unable to keep doing it -- but these data changes will not be in the export file. A genuine backup using rman or the old alter tablespace begin backup method is the only proper backup. If you are trying to get production data to move into a test/development database schema, then export is certainly the most convenient way of doing it. If you are, in fact, trying to backup the database, here is something to get you started. If the filesystem to which your export file is going is big enough, consider using that filesystem to store a database backup instead of an export. Assuming it is /where/it/goes, try the following: Make sure sys (or system, if you prefer) has been granted sysdba in the database. Create two files with text similar to the following: for file named backup_database.rcv: -- snip - run { allocate channel ch1 type disk format '/where/it/goes/%U_DATA'; set command id to 'rman'; backup tag backup_db_full (database include current controlfile); release channel ch1; } - snip -- This will backup the database. for file named backup_arch.rcv - snip run { allocate channel ch1 type disk format '/where/it/goes/%U_ARCH'; set command id to 'rman'; change archivelog all crosscheck; backup (archivelog all delete input); backup ***This line and the next if you are duplexing archived logs*** (archivelog like '/directory/where/duplexed/archivelogs/are/%' delete input); release channel ch1; allocate channel ch1 type disk format '/where/it/goes/%U_CONTROL'; backup current controlfile tag='backup'; release channel ch1; sql ALTER DATABASE BACKUP CONTROLFILE TO ''/where/it/goes/CONTROL_FILE.BAK'' REUSE; } snip This will backup the archived logs and the control file. Note that the last command tells the database to make a physical copy of the control file. The reason for this is that rman has been writing backup info to the control while the backup is running. So you make a copy of it after the backup has completed in case you lose all copies of your control files. If your database and all control files got completely blown away, you can copy the control file copy back to where it was and start restoring. You might note that I backup the control file ... and back it up ... and back it up. That's just paranoia. You can put the whole thing into one file. The reason for having them separate is in case you need to free up space in the archive_log_dest by backing up just the archived logs. To run a backup, type in the following commands: rman nocatalog connect target sys/[EMAIL PROTECTED] backup_database.rcv backup_arch.rcv exit Now, make sure you backup /where/it/goes directory to tape with whatever operating system backup utility you are using. One thing that can be added, if you want to be extra thorough, is to put in a log switch followed by an archive log current, after you run the archivelog backup. Then you run ANOTHER archivelog backup. In the world of Murphy's Law, you do it this way because your archive_log_dest will, some day, at the worst possible time, be unable to accommodate a log switch and archive log current. So you clean it out first prior to the log switch. It might be useful to know how to restore the database ... that's just something I saw written on a toilet stall wall. It seems reasonable. (... He who reads these words of wit, eats those little balls of ... ) I think the subject is probably more extensive than can be covered in a simple e-mail; so I won't try to cover it all. But, in it's simplest form, a recovery looks like: If the last rman backup has been deleted from /where/it/goes, restore those files from tape. startup mount the database (assuming the control file is NOT the thing you are restoring) rman nocatalog connect target sys/[EMAIL PROTECTED] allocate channel ch1 type disk; restore database; restore archivelog all; recover database; release channel ch1; open the database. See, rman isn't so bad. It's biggest problem is that, if you
Re: need to compare long data against varchar2
richard, select name from user_dependencies where referenced_name = table_name and type = view chaim Ferenc Mantfeld [EMAIL PROTECTED]fatcity.com on 02/21/2003 01:14:00 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Mark Not that I have an answer for you, but what about synonyms to tables / views being referenced ? Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, February 22, 2003 2:19 AM I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oh Where Oh Where Is My Redo Coming From
Sure that is the way I would typically do it, but in this case I have an application that is running 8000 batch processes per day, redo is very consistent for most of the 24 hours. I asked myself what is the simplest way to figure out which objects likely generate all of this redo. Monitoring sesstat is not going to be the most efficient and accurate method in this case. As it turns out the results (based on the SQL I posted) show the F0911 (JDE Oneworld GL Ledger) table likely produces at least 70-80% of the redo. During the batch job tuning process I will focus on tuning jobs that effect this table. There are also a ridiculous # of indexes on this table, over 120 columns involved in all of the indexes, I am sure many are redundant. Since redo log contention is one of the primary issues with this database I should see some dramatic improvements once a few of the jobs are tuned. - Ethan -Original Message- Sent: Friday, February 21, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hi, The simpler approach is to check the user level redo (or session level redo) using the v$sysstat,sesstat views and you can find the programmes associated with those huge (!) redo. Dumping the redologs and analyzing is just complex when you have a simple solution ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
That feature is not available until 8.0 or 8i, forget which. Jared Sam Bootsma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 07:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Autoextend on Oracle 7.3.4.5.0 We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4: SQL desc dba_data_files NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER BLOCKS NUMBER STATUS VARCHAR2(9) SQL Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend? Thank-you, SB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
storing credit card numbers in a database
Title: storing credit card numbers in a database I've been asked to find out a way to encrypt credit card numbers and store that encrypted string in the database. ...any oracle functions or functionality to do this? or would we have to encrypt the numbers in the application and then pass that string to the database? We don't want anyone to be able to get to the numbers even if they have access to the table in which it is stored. Thanks for any input chris
RE: AIX question
Title: AIX question Lisa; Here is a set of 3 scripts that I used to map our disks on an IBM S70a with a large SSA Disk set that used the AIX Logical Disk Manager. You might be able to glean all the commands from the scripts or just use them yourself if they work on your system. The get_info.sh script calls the procedure that the included sql script creates. A sample output is in the info.dat file. Any questions, contact me off list . Kevin -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). diskinfo.sh Description: Binary data get_info.sh Description: Binary data info.sh Description: Binary data mount_points.sql Description: Binary data info.dat Description: Binary data
RE: RAC recomended books
I believe that there is a RAC book in the works. I don't know what the expected publish date is... I'll contact the author and find out. RF --- Broodbakker, Mario [EMAIL PROTECTED] wrote: Vladimir, The official manuals do a good job. Besides from that The O'Reilly Oracle Parallel Processing book is quite OK, but it repeats a lot of the info in the manuals. There happens to be a book called: Tru64 Unix Oracle9i CLuster quick reference (Digital Press) written by Tim Donar. It does a good job on the Tru64 specifics: Advfs, LSM and SAN part. Check out James Morle's Scaling Oracle8i: although 8i, it also contains good OPS info applicable to 9i too. Also Steve Adam's Oracle Internals has a very good (very 'dense', hard to read: it reads like there's enough info to fill a book crammed in 1 chapter..) part on OPS (7-8), but a lot is still very applicable. Again: don't miss the manuals.. regards, Mario -Original Message- Sent: donderdag 20 februari 2003 15:04 To: Multiple recipients of list ORACLE-L What books are recomended reading for RAC? Especially Tru64 based RAC? Beside paper books, are there any good web pages (beside metalink, of course) that are dealing with RAC? Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Sheraton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AIX question
And, though I'm not sure if you need root to run it, I remember smitty was a wonderful little menu-driven tool for finding such information. And you hit a key combo that would show you the actual command for future reference. You'll have to forgive the vagueness, it's been quite some time since I had to use AIX. (Ah, the party we had when they took that RS6000 out of here) -Candi On Fri, 2003-02-21 at 13:39, Gene Sais wrote: Everything in IBM land is 'ls...' something. I think lscfg should give you more info, not sure of all the switches. Gene [EMAIL PROTECTED] 02/21/03 12:19PM AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do you calcuate the temp space needed for view?
There is no set formula to assess temp table space for a given query. If your query resulting in Cartesian Join, even temp space of 8-10GB my be insufficient. As I have no 7.3.3.6 database available to test but you can check compatible parameter in your initSID.ora file. and set it to 7.3.3.6 if different and try maxextents script. Clean shutdown and rebounce of database is required to change this param to come into effect. What is your initial and next extent size? Are you creating new temp tablespace? Try initial and extent extent 10M or larger. As your db_block_size is 2K,allowable maxextents are 121 if you are unable to make it maxextents. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 20:08:46 -0800 Hi Rafiq, My database version is 7.3.3.6.0, so I cannot set the maxextents unlimited. I added another datafile and increase initial extent and next extent much larger for this tablespace. My user still encountered the error. I would like to know how much space is needed for selecting the view. Any advice ? TIA. Regds, New Bee -Original Message- From: M Rafiq [mailto:[EMAIL PROTECTED] Sent: Friday, February 21, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject:Re: How do you calcuate the temp space needed for view? Your database having db_block_size 2K so max extents are 121. You may alter your temp tablespace by alter tablespace temp default storage(maxextents unlimited); then alter tablespace temp coalesce; and try your query. If space is not sufficient in temp ts then message will come with ORA-1652. In that case you have to increase size of temp tablespace by resizing extisting file or adding another datafile. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 17:08:49 -0800 Hi Gurus, I issue the following command select count(*) from view1 and encounter the following error ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP. I think I need to increase the tablespace TEMP but how do I calculate the temporary space needed ? Assuming view1 is select * from table1, table2 where table1.Col1=table2.Col1 Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * (table 2 row-length * table 2 total number of rows ) ? Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California