RE: Configuring RMAN
Hi list, Recalling the yesterday problem, here is my profile, what arrangement should I do To make RMAN work from the ORACLE_HOME/bin without to specify the path. Kind of new in UNIX/LINUX. TIA, export EDITOR=vi export TERM=xterm #* # Variables de Oracle | #* export ORACLE_SID=BDRP export ORACLE_BASE=/u01/oracle/product export ORACLE_HOME=/u01/oracle/product/8.1.7 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 export ORACLE_TERM=xterm #* # Variables de Linux| #* export LD_ASSUME_KERNEL=2.2.5 #source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh export JAVA_HOME=/usr/local/java export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jlib:$ORACLE_ H OME/rdbms/jlib:$ORACLE_HOME/network/jlib:.:$ORACLE_HOME/JRE Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 2:05 PM To: Multiple recipients of list ORACLE-L your path could still be pointing elsewhere first and not the current directory. $ORACLE_HOME/bin/rman joe Ramon E. Estevez wrote: Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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
RE: Configuring RMAN
Title: Message Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Configuring RMAN
Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Ramon E. Estevez 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: Configuring RMAN
Thanks Mladen, But the same result --- -- --- - -- 1 BDRP LOBO 8.1.7.4.0 01-SEP-03 OPENNO 1 STARTED ALLOWEDNO ACTIVEPRIMARY_INSTANCE 1 row selected. SVRMGR exit Server Manager complete. [EMAIL PROTECTED] oracle]$ rman catalog=rman/[EMAIL PROTECTED] rman: can't open catalog=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ rman target=rman/[EMAIL PROTECTED] rman: can't open target=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ sqlplus rman/[EMAIL PROTECTED] SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 16 10:42:15 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Mladen Gogala Sent: Tuesday, September 16, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Probably because you need correct command argument. Try rman catalog= mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: Configuring RMAN
That was it. Thanks a lot to everybody that answer, thanks to you I learn something new every day. [EMAIL PROTECTED] bin]$ $ORACLE_HOME/bin/rman Recovery Manager: Release 8.1.7.4.0 - Production RMAN Tks. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Tanel Poder Sent: Tuesday, September 16, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi! cd'ing to a directory doesn't help in unix unless directory . in PATH is before /usr/bin or whereever the redhat linux rman is located. Type which rman in your prompt and you'll see which rman is being used. You have to run $ORACLE_HOME/bin/rman if you want to get right rman. Or modify your path variable to have $ORACLE_HOME/bin before other linux bin directories (btw, I wouldn't do that, I believe system bin dirs should always be first in path) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 7:34 PM Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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
Configuring RMAN
Title: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Difference in Performance in two schemas in the same BD
597373 0 16971 --- -- -- -- -- -- -- total 33943 14.91 15.49 5622 597467 2 16971 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 (FBDIN) (recursive depth: 1) Rows Row Source Operation --- --- 16971 SORT AGGREGATE 0 NESTED LOOPS 214942 TABLE ACCESS BY INDEX ROWID TCON_TRANSA 610884 INDEX RANGE SCAN (object id 11250) 0 TABLE ACCESS BY INDEX ROWID TCON_DESTRAN 395942 INDEX UNIQUE SCAN (object id 11196) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 16971 SORT (AGGREGATE) 0 NESTED LOOPS 214942 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_TRANSA' 610884 INDEX (RANGE SCAN) OF 'FK_CF02CON_TSA' (NON-UNIQUE) 0 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_DESTRAN' 395942 INDEX (UNIQUE SCAN) OF 'CP01CON_DST' (UNIQUE) TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Difference in Performance in two schemas in the same BD
Tks Wolfang I have read the paper. db_file_multiblock_read_countinteger 32 hash_area_size integer 4194304 sort_area_retained_size integer 1048576 sort_area_size integer 2097152 hash_multiblock_io_count integer 0 optimizer_index_caching integer 90 optimizer_index_cost_adj integer 30 Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Wolfgang Breitling Sent: Wednesday, September 10, 2003 9:10 PM To: Multiple recipients of list ORACLE-L There could be many reasons why the CBO does not use an index and a NL join like the RBO. The predicate columns could have skewed data distribution in which case gathering histograms on those columns might help, even though you're using bind variables. The index(es) could have a rather high clustering factor, turning the CBO off. In this case you could try deleting the statistics on the index. The default clustering factor of 800 for an index without statistics is likely to make the index much more attractive. Also, what is your setting for db_file_multiblock_read_count? A high value there can pull the CBO towards full table scans and hash joins. Likewise, a high value for sort_area_size or hash_area_size and hash_multiblock_io_count will cause the CBO to favour hash joins. Finally, you can experiment with optimizer_index_cost_adj and optimizer_index_caching. Read Tim Gorman's paper 'The Search for Intelligent Life in the Cost-Based Optimizer (www.evdbt.com). At 03:34 PM 9/10/2003 -0800, you wrote: Hi list, I had two schemas in the same BD with the same data FBDI WITH STATISTICS FBDIN NO STATISTICS The one without statistics run in less than 4 minutes The one with statistics run in like 30 minutes Any Help would be very, very appreciated as always. I already bought the book from Gaja and Kirti, by recommendation of Madlen and Stephane, but hasn't arrived to my country yet, Dominican Republic, and need to improve this process ASAP. Applied the EVENT TRACE 10046 and this is the result of the schema with stats (FBDI). *** * SELECT B.MATHOPERATOR,B.MAPACCOUNTLOCAL,A.PRINTORDER,B.SEQUENCE FROM TEQUIVACCOUNT A,TEQUIVACCOUNTDETAIL B WHERE A.REPORTCODE = B.REPORTCODE AND A.CODE = B.CODE AND A.REPORTCODE = 'BDI01' ORDER BY A.PRINTORDER, B.SEQUENCE call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.04 0.09 9187 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 5658 0.57 0.70154152 8 5657 --- -- -- -- -- -- -- total 5660 0.61 0.79163339 8 5657 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 20 (FBDI) Rows Row Source Operation --- --- 5657 SORT ORDER BY 5657 HASH JOIN 46TABLE ACCESS FULL TEQUIVACCOUNT 5657TABLE ACCESS FULL TEQUIVACCOUNTDETAIL Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 5657 SORT (ORDER BY) 5657HASH JOIN 46 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'TEQUIVACCOUNT' 5657 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'TEQUIVACCOUNTDETAIL' *** * SELECT MAX(A.ACM_FECACUM),NVL(A.ACM_ACUMDBANT,0) - NVL(A.ACM_ACUMCRANT,0) + NVL(A.ACM_ACUMDB,0) - NVL(A.ACM_ACUMCR,0) FROM TCON_ACUM A,(SELECT ACM_OFICINA,ACM_MONEDA,NVL(MAX(TRUNC(ACM_FECACUM)), TO_DATE('2001/01/01','/MM/DD')) MAXFECACUM FROM TCON_ACUM WHERE ACM_CODIGO = :b1 AND ACM_SUCURSAL = :b2 GROUP BY ACM_OFICINA,ACM_MONEDA ) T WHERE A.ACM_CODIGO = :b1 AND A.ACM_SUCURSAL = :b2 AND T.ACM_OFICINA = A.ACM_OFICINA AND T.ACM_MONEDA = A.ACM_MONEDA AND TRUNC(A.ACM_FECACUM) = T.MAXFECACUM GROUP BY NVL(A.ACM_ACUMDBANT,0),NVL(A.ACM_ACUMCRANT,0), NVL(A.ACM_ACUMDB,0),NVL(A.ACM_ACUMCR,0) call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.03 1 3 0 0 Execute 16971 7.95 9.13 0 0 0 0 Fetch16971 2.18 2.58113 62981 0 5770 --- -- -- -- -- -- -- total33943 10.14 11.74114 62984 0 5770 Misses in library cache during
DBAssist hangs
Title: DBAssist hangs Hi list, I installed 8.1.7 on RH AS 2.1, applied 8.1.7.4 patch, the glibc patch and when trying to create a DB dbassist hangs. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
DBASSIST HANGS
Title: DBASSIST HANGS Hi list, I manage to install 8.1.7 on RH AS 2.1. From Note 230693.1 I downloaded the jre118_v3 patch from blackdown, applied and the dbassist start, but I'm getting ORACLE NOT AVAILABLE. No more in metalink. TIA Note: Why to deal with Linux is so difficult. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Partitions in RH AS 2.1
Title: Partitions in RH AS 2.1 Hi list, New in linux. I configured a RAID 0 in a Dell Server and installed RH AS 2.1. Now as a result I have a /dev/sda4 of 200 GB. I used fdisk and made 3 partitions that became /dev/sda9, /dev/sda10, /dev/sda11. Now I want to make the file systems and mount the partitions and haven't been able to do it. Any help would be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Move selected tables
What about this SELECT 'CREATE TABLE NEWUSER.'||TABLE_NAME ||' TABLESPACE NEWTBS AS SELECT * FROM '||TABLE_NAME ||';' FROM USER_TABLES WHERE TABLE_NAME LIKE 'ABC_%' / Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Smith, Ron L. Sent: Monday, August 04, 2003 12:14 PM To: Multiple recipients of list ORACLE-L I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Ramon E. Estevez 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: 9i-OCP Question
I would say 4. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Senthil Kumar Sent: Wednesday, July 30, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks Q does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar 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: Ramon E. Estevez 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: Performance
Stephane, I continue having the same problem, in LAB 2 minutes and in PRODUCTION forever. I made the changes you indicate me. This is the explain plan in LAB, NO STATISTICS with data from yesterday Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (GROUP BY) 21 NESTED LOOPS 32 VIEW 43 SORT (GROUP BY) 54 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 65 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) 72 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 87 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) Statistics -- 0 recursive calls 0 db block gets 311 consistent gets 0 physical reads 0 redo size 353 bytes sent via SQL*Net to client 1159 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed - This the explain plan in PRODUCTION. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=9 Card=1 Bytes=53) 10 SORT (GROUP BY) (Cost=9 Card=1 Bytes=53) 21 NESTED LOOPS (Cost=7 Card=1 Bytes=53) 32 VIEW (Cost=6 Card=1 Bytes=15) 43 SORT (GROUP BY) (Cost=6 Card=1 Bytes=26) 54 TABLE ACCESS (FULL) OF 'TCON_ACUM' (Cost=4 Card=1 Bytes=26) 62 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' (Cost=2 C ard=1 Bytes=38) 76 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) (Co st=3 Card=1) Statistics -- 0 recursive calls 4 db block gets 108 consistent gets 0 physical reads 0 redo size 245 bytes sent via SQL*Net to client 981 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Tuesday, July 01, 2003 4:16 PM To: Multiple recipients of list ORACLE-L Ramon, I have had a closer look at your coe. My gut feeling is that SELECT MAX(A.ACM_FECACUM), Nvl(A.ACM_ACUMDBANT,0) - nvl(A.ACM_ACUMCRANT,0) + nvl(A.ACM_ACUMDB,0)- nvl(A.ACM_ACUMCR,0) into vFechaIni, vSaldoAnt from tcon_acum A, (select ACM_Oficina, ACM_Moneda, nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') MAXFECACUM FROM TCON_ACUM WHERE Acm_codigo = pCuenta AND ACM_Sucursal = i GROUP BY ACM_Oficina, ACM_Moneda) T where A.acm_codigo= pCuenta AND A.acm_sucursal = i AND T.ACM_Oficina = A.ACM_Oficina AND T.ACM_Moneda = A.ACM_MOneda AND TRUNC(A.ACM_FECACUM) = T.MAXFECACUM GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0), nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); would return the same thing as what you have, only faster. On first readin I had not noticed that you IN (SELECT ...) was correlated. Ouch. If ACM_CODIGO and ACM_SUCURSAL are indexed (and the index is discriminant enough), and if (ACM_OFICINA, ACM_MONEDA) are also separately indexed (with the same restriction as before), it should run reasonably fast. Ramon E. Estevez wrote: Tks Stephane and Madlen, Still the same problem. I added the hint /*+ FIRST_ROWS */ to the query that invoke the function and it changed from FTS to use Index but still have the same problem. I added the same hint to the function and Nothing. I checked the v$session_wait during the execution of the procedure and the only thing that Was waiting was SQL NET TO CLIENT MESSAGE. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Friday, June 27, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Ramon, This is not a strange case at all; I find quite customary to see dazzling fast queries in a development environment crawl pathetically in production. My Spanish being reduced to some vague remnants of Latin (and just enough to understand the promotion of Mexican holiday resorts) I must confess
RE: Performance
Tks Stephane and Madlen, Still the same problem. I added the hint /*+ FIRST_ROWS */ to the query that invoke the function and it changed from FTS to use Index but still have the same problem. I added the same hint to the function and Nothing. I checked the v$session_wait during the execution of the procedure and the only thing that Was waiting was SQL NET TO CLIENT MESSAGE. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Friday, June 27, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Ramon, This is not a strange case at all; I find quite customary to see dazzling fast queries in a development environment crawl pathetically in production. My Spanish being reduced to some vague remnants of Latin (and just enough to understand the promotion of Mexican holiday resorts) I must confess to some difficulty in understanding your code. Anyway, CBO seems to be the culprit, isn't it? What is the main behavioural difference between CBO and RBO? Primarily, CBO doesn't shy as much of full table scans, and disdain indices much more often, jumping for the (usually quite efficient) hash join instead. When stats slow down a query, it usually means that nested loops were efficient, and in that case hash joins are not. To put the CBO back on tracks, /*+ FIRST_ROWS */ is usually enough. If it isn't, list the tables in the FROM clause in the order you know to be suitable (the table for which you feed the most selective values in the query first) and add ORDERED to the hint to ram the message home. I have found this to be efficient in most cases. HTH, Stephane Faroult Ramon E. Estevez wrote: Hi list, SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2 PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UX B.11.00 I have this strange case, I have this query that generate a text file and in the PRODUCTION environment ran for about 30 minutes. When running the same query in LAB ran in about 2 minutes. The 2 instances have the same parameters setted and the same amount of data, the Lab DB is updated every night with the production data throught IMP/EXP procedure. Trying to solve the problem, today I ran statistics in LAB and the query lasted more than in PRODUCTION and before was about 2 minutes. TIA -* -- Here is the code of the CODE in the form and the function. PROCEDURE genera_archivo IS vcOutFile varchar2(30) := 'c:\pruebas\archivo.txt'; hOutFiletext_io.file_type; cursor cuentas is select b.MATHOPERATOR, b.MAPACCOUNTLOCAL, a.PRINTORDER, b.sequence from tequivaccount a, tequivaccountdetail b where a.REPORTCODE = b.REPORTCODE and a.CODE = b.CODE and a.reportcode = 'BDI01' order by a.PRINTORDER, b.sequence ; vSaldo number; vCuenta varchar2(14); BEGIN set_application_property(CURSOR_STYLE,'BUSY'); hOutFile := text_io.fopen(:nombre_plano,'w'); text_io.put_line(hOutFile,to_char(:fecha_fin,'ddmm')||'cifrado'); for i in cuentas loop IF C.MATHOPERATOR = '+' THEN VSALDO := bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_Fin,:suc_ini,:suc_fin) ELSE VSALDO := bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_fin,:suc_ini,:suc_fin)* -1 )); END IF; if nvl(vSaldo,0) 0 then text_io.put_line(hOutFile,rpad(i.MAPACCOUNTLOCAL,14,' ')||' 000 '||to_char(round(vsaldo,2),'999.99')); end if; end loop; set_application_property(CURSOR_STYLE,'DEFAULT'); END; -* This the function *-- PROMPT CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha (pCuenta in char,pFecha in date, pSucIni in number, pSucFin in number) return number is --- --- Devuelve el Saldo de una cuenta contable a la fecha pasada en pFecha. --- vSaldo number; vDebito number; vCreditonumber; vSaldoAnt number; vFechaIni date ; vMoneda number; vLinea varchar2(150); vdate1 date; vdate2 date; vdate3 date; vdate4 date; begin --delete log_batch; --commit; for i in pSucIni .. pSucFin loop vDebito := 0; vCredito:= 0; vSaldoAnt := 0; begin SELECT MAX(A.ACM_FECACUM), Nvl(A.ACM_ACUMDBANT,0) - nvl(A.ACM_ACUMCRANT,0) + nvl(A.ACM_ACUMDB,0)- nvl(A.ACM_ACUMCR,0) into vFechaIni, vSaldoAnt from tcon_acum A where A.acm_codigo= pCuenta AND A.acm_sucursal = i AND TRUNC(A.ACM_FECACUM
RE: Drop Tablespace
There's a new feature in 9i that can remove the os file also Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Jose Luis Delgado Sent: Tuesday, July 01, 2003 5:13 PM To: Multiple recipients of list ORACLE-L It dissappered from the data dict... but it should exist at os level... you need to rm it... check it... HTH JL --- Hamid Alavi [EMAIL PROTECTED] wrote: Hi List, Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the data file also disappeared from the list of datafiles, as I know the datafile must be removed manually Any idea? I am using 9.0.1 on solaris 2.8 Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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: Ramon E. Estevez 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).
Performance
Hi list, SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2 PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UX B.11.00 I have this strange case, I have this query that generate a text file and in the PRODUCTION environment ran for about 30 minutes. When running the same query in LAB ran in about 2 minutes. The 2 instances have the same parameters setted and the same amount of data, the Lab DB is updated every night with the production data throught IMP/EXP procedure. Trying to solve the problem, today I ran statistics in LAB and the query lasted more than in PRODUCTION and before was about 2 minutes. TIA -*-- Here is the code of the CODE in the form and the function. PROCEDURE genera_archivo IS vcOutFile varchar2(30) := 'c:\pruebas\archivo.txt'; hOutFiletext_io.file_type; cursor cuentas is select b.MATHOPERATOR, b.MAPACCOUNTLOCAL, a.PRINTORDER, b.sequence from tequivaccount a, tequivaccountdetail b where a.REPORTCODE = b.REPORTCODE and a.CODE = b.CODE and a.reportcode = 'BDI01' order by a.PRINTORDER, b.sequence ; vSaldo number; vCuenta varchar2(14); BEGIN set_application_property(CURSOR_STYLE,'BUSY'); hOutFile := text_io.fopen(:nombre_plano,'w'); text_io.put_line(hOutFile,to_char(:fecha_fin,'ddmm')||'cifrado'); for i in cuentas loop IF C.MATHOPERATOR = '+' THEN VSALDO := bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_Fin,:suc_ini,:suc_fin) ELSE VSALDO := bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_fin,:suc_ini,:suc_fin)*-1 )); END IF; if nvl(vSaldo,0) 0 then text_io.put_line(hOutFile,rpad(i.MAPACCOUNTLOCAL,14,' ')||' 000 '||to_char(round(vsaldo,2),'999.99')); end if; end loop; set_application_property(CURSOR_STYLE,'DEFAULT'); END; -* This the function *-- PROMPT CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha (pCuenta in char,pFecha in date, pSucIni in number, pSucFin in number) return number is --- --- Devuelve el Saldo de una cuenta contable a la fecha pasada en pFecha. --- vSaldo number; vDebito number; vCreditonumber; vSaldoAnt number; vFechaIni date ; vMoneda number; vLinea varchar2(150); vdate1 date; vdate2 date; vdate3 date; vdate4 date; begin --delete log_batch; --commit; for i in pSucIni .. pSucFin loop vDebito := 0; vCredito:= 0; vSaldoAnt := 0; begin SELECT MAX(A.ACM_FECACUM), Nvl(A.ACM_ACUMDBANT,0) - nvl(A.ACM_ACUMCRANT,0) + nvl(A.ACM_ACUMDB,0)- nvl(A.ACM_ACUMCR,0) into vFechaIni, vSaldoAnt from tcon_acum A where A.acm_codigo= pCuenta AND A.acm_sucursal = i AND TRUNC(A.ACM_FECACUM) IN (select nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') FROM TCON_ACUM T WHERE T.Acm_codigo = A.acm_codigo AND T.ACM_Sucursal = A.ACM_SUcursal AND T.ACM_Oficina = A.ACM_Oficina AND T.ACM_Moneda = A.ACM_MOneda) GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0), nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); exception when no_data_found then vSaldoAnt := 0; when others then dbms_output.put_line((pCuenta)); end; vFechaIni := vFechaIni + 1; begin SELECT SUM (DECODE(T.TSA_TIPO, 'D', NVL(T.TSA_VALOR,0))) , SUM (DECODE(T.TSA_TIPO, 'C', NVL(T.TSA_VALOR,0))) into vDebito, vCredito FROM TCON_TRANSA T, TCON_DESTRAN D WHERE T.TSA_SUCURSAL = I AND T.TSA_CUENTA = pCuentaAND D.DST_NUMTRAN = T.TSA_NUMTRAN AND D.DST_SUCURSAL = T.TSA_SUCURSAL AND D.DST_FECHA BETWEEN vFechaIni and pFecha AND D.DST_CUADRA = 'S' ; exception when no_data_found then vDebito := 0; vCredito := 0; when others then null; end; vSaldo :=nvl (vSaldo,0) + (nvl(vSaldoAnt,0) + nvl(vDebito,0) - nvl(vCredito,0)) ; end loop; return vSaldo ; end; / Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http
RE: Inverse 9i Question
I would go with A and C Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- CP Sent: Friday, June 13, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: Robert If I am not wrong..without looking at your book or any 9i doc...The answer is a. The ability to Rename a Column Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 13 Jun 2003 12:09:54 -0800 Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP 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: Ramon E. Estevez 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-03113 After Pathc 8.1.7.4
That's it. I ran it again and everything ok. Tks Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Richard Ji Sent: Friday, June 06, 2003 8:54 PM To: Multiple recipients of list ORACLE-L Did you re-run the glibc stub patch after applying 8.1.7.4? Richard -Original Message- Sent: Friday, June 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Platform suse linux professional 7.2 Sorry :-( Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: Richard Ji 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: Ramon E. Estevez 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: inline views
What I remember from an old post regarding this issue, You don't have to create another object, view, to workaround your requirement. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- VIVEK_SHARMA Sent: Friday, June 06, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Where are they advantageous to use where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Ramon E. Estevez 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).
ORA-03113 After Pathc 8.1.7.4
Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: ORA-03113 After Pathc 8.1.7.4
Platform suse linux professional 7.2 Sorry :-( Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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 9IAS
Hi list, I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing comes up when clicking the setup button. Checked in metalink and nothing related to it. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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 9IAS
Ah! The old trick of the symjitc.dll. It's working now. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Estevez Sent: Saturday, May 31, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Hi list, I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing comes up when clicking the setup button. Checked in metalink and nothing related to it. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: Ramon E. Estevez 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: Force to use a tablespace
Roland, Don't know if I understand you correctly, my english is not good, but what if you specify the tbs to use at the moment of the creation of the table CREATE TABLE mitabla ( CODE NUMBER(4)) TABLESPACE mitbs Suerte Ramon -Original Message- [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 6:54 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who knows how to force a table to use a special tablespace? Thanks in advance. Roland -- 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: Ramon E. Estevez 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: DEFAULT ROLE ALL
Title: Message That all the roles that the user has assigned get enabled when he logs on. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edouard DormidontovSent: Wednesday, March 12, 2003 8:39 AMTo: Multiple recipients of list ORACLE-LSubject: DEFAULT ROLE ALL Hi World! What this mean: ALTER USERusername DEFAULT ROLE ALL; Thanks Ed Dorma
RE: Oracle Performance Tuning Exam
. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Yeah, if you've taken the performance exam, you must now unlearn what you have learnt, to quote from Starwars. I've considered creating a one- or two-day class that would put people into the right track of thinking after having studied and passed that exam. The other exams are more or less fine. The tuning one really - ahm - could be improved... Mogens [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Guys, I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the oracle 8 tuning - read through once and not every item (not 8i class) - where the heck was statspack in the examm, btw? I took it in 20 minutes. Only the network one to go. Can't wait to get this done so can do the 9i upgrade exam - then wishing to concentrate on certification relating to 9ias - is there such a beast? -Original Message- mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, June 11, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Arslan - I'm hoping you get some good replies since I plan to take this exam next. I just took the BR last week. The resource that helped me the most is: Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60Z MKA1 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60 ZMKA 1 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60Z MKA http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60 ZMKA 1 Jisbn=0072133414 (hopefully this link will work, it will be broken into two lines which you must patch back together). Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 7:38 AM To: Multiple recipients of list ORACLE-L I will enter my last exam at next week. Could DBAs which have this exam give some advice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: Error pinning PKS in shared pool
Thanks Suzy, Waleed, John, Richard, Connor, Jonathan, for your help. Out of shape on sundays :-) TKS -Original Message- Vordos Sent: Sunday, February 23, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Don't think you need to use execute immediate. Try this (should be run as SYS): CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON DATABASE BEGIN dbms_shared_pool.keep('DBMS_ALERT'); dbms_shared_pool.keep('DBMS_DDL'); dbms_shared_pool.keep('DBMS_DESCRIBE'); dbms_shared_pool.keep('DBMS_LOCK'); dbms_shared_pool.keep('DBMS_OUTPUT'); dbms_shared_pool.keep('DBMS_PIPE'); dbms_shared_pool.keep('DBMS_SESSION'); dbms_shared_pool.keep('DBMS_SHARED_POOL'); dbms_shared_pool.keep('DBMS_STANDARD'); dbms_shared_pool.keep('DBMS_UTILITY'); dbms_shared_pool.keep('STANDARD'); dbms_shared_pool.keep('BUSCA_SECUENCIA'); END; / Ramon E. Estevez wrote: Sorry, new DB and hadn't execute the Dbmspool.sql script. CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON DATABASE BEGIN exec immediate dbms_shared_pool.keep('DBMS_ALERT'); exec immediate dbms_shared_pool.keep('DBMS_DDL'); exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE'); exec immediate dbms_shared_pool.keep('DBMS_LOCK'); exec immediate dbms_shared_pool.keep('DBMS_OUTPUT'); exec immediate dbms_shared_pool.keep('DBMS_PIPE'); exec immediate dbms_shared_pool.keep('DBMS_SESSION'); exec immediate dbms_shared_pool.keep('DBMS_SHARED_POOL'); exec immediate dbms_shared_pool.keep('DBMS_STANDARD'); exec immediate dbms_shared_pool.keep('DBMS_UTILITY'); exec immediate dbms_shared_pool.keep('STANDARD'); exec immediate dbms_shared_pool.keep('BUSCA_SECUENCIA'); END; I am getting this error, tried with users SYS and SYSTEM 12/11PLS-00103: Encountered the symbol DBMS_SHARED_POOL when expecting one of the following: := . ( @ % ; tia Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos 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: Ramon E. Estevez 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).
Listener
Title: Message Hi list, I have my DB server with 2 network card and I want to split theconnections between the users to balance the load. I addedLOAD_BALANCE=ON in the listener.ora and another line with the new ip address with the port 1526. Now all the connections are managed with the new address and the port 1526. (ADDRESS_LIST= (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.10)(PORT=1521) (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.11)(PORT=1526) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.10)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.11)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) Any suggestions, comments will be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
DBMS_SHARED_POOL
Title: Message Which one is the substituion procedure for DBMS_SHARED_POOL in 9i ? Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Error pinning PKS in shared pool
Title: Message Sorry, new DB and hadn't execute the Dbmspool.sql script. CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON DATABASE BEGIN exec immediate dbms_shared_pool.keep('DBMS_ALERT'); exec immediate dbms_shared_pool.keep('DBMS_DDL'); exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE'); exec immediate dbms_shared_pool.keep('DBMS_LOCK'); exec immediate dbms_shared_pool.keep('DBMS_OUTPUT'); exec immediate dbms_shared_pool.keep('DBMS_PIPE'); exec immediate dbms_shared_pool.keep('DBMS_SESSION'); exec immediate dbms_shared_pool.keep('DBMS_SHARED_POOL'); exec immediate dbms_shared_pool.keep('DBMS_STANDARD'); exec immediate dbms_shared_pool.keep('DBMS_UTILITY'); exec immediate dbms_shared_pool.keep('STANDARD'); exec immediate dbms_shared_pool.keep('BUSCA_SECUENCIA');END; I am getting this error, tried with users SYS and SYSTEM 12/11 PLS-00103: Encountered the symbol "DBMS_SHARED_POOL" when expecting one of the following: := . ( @ % ; tia Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
DBMS
Title: Message I erased the exec clause and it worked. Sorry and tks Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
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
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: Where is the sql stored for a stored procedure?
Bob, Take a look at USER_SOURCE -Original Message- Metelsky Sent: Wednesday, February 19, 2003 5:03 PM To: Multiple recipients of list ORACLE-L Im mucking about in the user_ views... Im seeing dba_objects type = 'procedure'; but need to find the sql Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Ramon E. Estevez 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: DBMS_JOB : Can submit but does not execute
You have to give commit after submit the job. -Original Message- Ling Catherine (CSC) Sent: Tuesday, February 18, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I have submitted a job but it does not execute. Why? Does the owner require any privileges ? However, I can use DBMS_JOB.CHANGE command to execute immediately. I would like the job to execute on a daily basis. Any advice ? TIA -- -- Submit a job -- 1 DECLARE 2job BINARY_INTEGER; 3 BEGIN 4DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1'); 5DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB)); 6* END; SQL / 1 PL/SQL procedure successfully completed. SQL COMMIT; Commit complete. -- -- Execute the job -- 1 begin 2 DBMS_JOB.CHANGE(1, 3 ' PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDA TE+1'); 4* END; SQL / PL/SQL procedure successfully completed. SQL COMMIT; Commit complete. -- -- Check whether the job is submitted -- SQL SELECT * FROM DBA_JOBS JOB LOG_USER PRIV_USER - -- -- SCHEMA_USERLAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME B -- - - - -- - INTERVAL FAILURES - WHAT NLS_ENV MISC_ENV INSTANCE - 1 USER1 USER1 USER1 17-FEB-03 20:01:20 18-FEB-03 08:00:00 16 N SYSDATE+1 0 PROCEDURE_NAME; NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUME RIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 01020002 0 Regds, Catherine -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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: Question about log files
Title: Message Tks Arup -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent: Wednesday, February 19, 2003 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Question about log files From the Fine Manuals Theoperating systemfiles are deleted too, when an Oracle Managed logfile grup or member is dropped. HTH. Arup Nanda - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 19, 2003 9:59 AM Subject: Question about log files Reading the DBA manual in the chapter 7 refers that * When an online redo log file group is dropped, the operating system files are not deleted. * When an online redo log file member is dropped, the operating system file is not deleted if you are not usingOMF feature. What happens when drop the log file group if using the OMF feature, the files will be deleted also ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: When were Locally Managed Tablespaces introduced?
Lmt were introduced in 8i -Original Message- Allen Sent: Monday, February 17, 2003 11:54 AM To: Multiple recipients of list ORACLE-L I'm not having much luck - I thought it was with 9i, but the new features guide doesn't list it. So now I'm trawling through old new features guides ... and thought some bright people out there might remember (faster than I can find it in a bunch of pdfs, web pages, etc.). 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: Ramon E. Estevez 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: Count(*) last 30 seconds
Title: Message Tks Herman, will make that change. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: Thursday, February 13, 2003 10:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Count(*) last 30 secondsLet's see ...Your DB_CACHE_SIZE is 16MB == 2048 blocksThe table is approx 14,677 blocksThe record-size is something like 800bytesEach multiblock read call will read 32-blocksYour DB_CACHE will be filled in less than 64 read-calls and will have less than 1/7th of the table.Your server will certainly be very busy doing physical reads for aFull-Table-Scan of this table alone.Now, the only thing I can suggest is to increase your DB_CACHE_SIZE significantly.16MB is too low for any activity in Oracle.HemantAt 09:54 AM 12-02-03 -0800, you wrote: Hermant and Chitale,DB_FILE_MULTIBLOCK_READ_COUNT=32DB_CACHE_SIZE big integer 16777216DB_BLOCK_BUFFERS = 0Tablespace is LMT with a uniform size of 128 MB, DB not in archive mode is for a DW system.The time for the first run and the re-run last the same.To my understanding the table has only one extent. This query runs in about 7 seconds. In my production DB runs inmediately that is in NT also but 8.1.7.SELECT TABLESPACE_NAME, EXTENT_ID, BYTES/1048576, BLOCKSFROM DBA_EXTENTSWHERESEGMENT_NAME = 'DM_VENTAS'TABLESPACE_NAME EXTENT_ID BYTES/1048576 BLOCKS-- -- - --DTMVENTAS 0 128 16384TKS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K Chitale Sent: Wednesday, February 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Count(*) last 30 seconds That's approx 100 records per blocks. What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ? Also, what is the elapsed time for the query if you re-run the query immediately ? [the first run fetched everything in physical reads, the second run should still find some or most blocks in the SGA, unless the DB_CACHE_SIZE or DB_BLOCK_BUFFERS is very small]. Hemant At 05:18 AM 12-02-03 -0800, you wrote: Hermant, Sergey The table has 13 columns, the PK is formed for the first 11. There is no deletion nor update, just inserts in the table. I had truncated the tables sometimes testing the procedure that load the rows. This is the result with an auto trace. COUNT(*) -- 1466196 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=896 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196) Statistics -- 0 recursive calls 0 db block gets 14677 consistent gets 14644 physical reads 0 redo size 386 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K Chitale Sent: Tuesday, February 11, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Count(*) last 30 seconds You are doing Full-Table-Scans. 1. What's the average row length ? How many columns does the table have ? 2. How many "consistent gets" does the count(*) cause ? [ie, how many blocks does it actually have to read ?] 3. Are all these Physical Reads ? Is the DB_CACHE_SIZE large enough to hold most of the blocks ? What is the query-run-time if you re-run the query immediately again ? Hemant At 08:19 AM 11-02-03 -0800, you wrote: Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED]
RE: Count(*) last 30 seconds
Title: Message Hermant, Sergey The table has 13 columns, the PK is formed for the first 11. There is no deletion nor update, just inserts in the table. I had truncated the tables sometimes testing the procedure that load the rows. This is the result with an auto trace. COUNT(*)-- 1466196 Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=896 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196) Statistics-- 0 recursive calls 0 db block gets 14677 consistent gets 14644 physical reads 0 redo size 386 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: Tuesday, February 11, 2003 10:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Count(*) last 30 secondsYou are doing Full-Table-Scans.1. What's the average row length ? How many columns does the table have ?2. How many "consistent gets" does the count(*) cause ? [ie, how many blocks does it actually have to read ?]3. Are all these Physical Reads ? Is the DB_CACHE_SIZE large enough to hold most of theblocks ? What is the query-run-time if you re-run the query immediately again ?HemantAt 08:19 AM 11-02-03 -0800, you wrote: Hi list,I issue a select count(*) from mytable and last 30 seconds.The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space.I consider that time exagerated.The TBS is LMT with a Uniform size of 128 MB.The block size is 8MB, version 9.2.0.1.0 in Windows 2000.Where should I start looking ???TIARamon E. Estevez[EMAIL PROTECTED]809-565-3121 Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Count(*) last 30 seconds
Title: Message Hermant and Chitale, DB_FILE_MULTIBLOCK_READ_COUNT=32 DB_CACHE_SIZE big integer 16777216 DB_BLOCK_BUFFERS = 0 Tablespace is LMT with a uniform size of 128 MB, DB not in archive mode is for a DW system. The time for the first run and the re-run last the same. To my understanding the table has only one extent. This query runs in about 7 seconds. In my production DB runs inmediately that is in NT also but 8.1.7. SELECT TABLESPACE_NAME, EXTENT_ID, BYTES/1048576, BLOCKSFROM DBA_EXTENTSWHERESEGMENT_NAME = 'DM_VENTAS' TABLESPACE_NAMEEXTENT_ID BYTES/1048576BLOCKS-- -- - --DTMVENTAS 0 128 16384 TKS -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: Wednesday, February 12, 2003 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Count(*) last 30 secondsThat's approx 100 records per blocks.What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ?Also, what is the elapsed time for the query if you re-run the query immediately ?[the first run fetched everything in physical reads, the second run should stillfind some or most blocks in the SGA, unless the DB_CACHE_SIZE or DB_BLOCK_BUFFERSis very small].HemantAt 05:18 AM 12-02-03 -0800, you wrote: Hermant, SergeyThe table has 13 columns, the PK is formed for the first 11.There is no deletion nor update, just inserts in the table. I had truncated the tables sometimes testing the procedure that load the rows.This is the result with an auto trace. COUNT(*)-- 1466196Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=896 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)Statistics-- 0 recursive calls 0 db block gets 14677 consistent gets 14644 physical reads 0 redo size 386 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K Chitale Sent: Tuesday, February 11, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Count(*) last 30 seconds You are doing Full-Table-Scans. 1. What's the average row length ? How many columns does the table have ? 2. How many "consistent gets" does the count(*) cause ? [ie, how many blocks does it actually have to read ?] 3. Are all these Physical Reads ? Is the DB_CACHE_SIZE large enough to hold most of the blocks ? What is the query-run-time if you re-run the query immediately again ? Hemant At 08:19 AM 11-02-03 -0800, you wrote: Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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
Count(*) last 30 seconds
Title: Message Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded witha batch process, so they are in a countinous space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Count(*) last 30 seconds
Title: Message Tks to all of you for your help. The table has a PK that is formed by 11 fields of 13 that the table has. This table is for a DW system. This the only one in the table. I analyze the table again, had done it before using dbms_stats.gather_schema_stats, and the time went down to 7 seconds. And there is no difference between count(*) and count(1), the same results with both of them. tks to all -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Koivu, LisaSent: Tuesday, February 11, 2003 11:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Count(*) last 30 seconds well, have you traced the statement yet? That's where to start, with autotrace. My count(*) which executesa FTS (in a load to mitigate any ORA-1555 error) takes 15 minutes to count 50 million rows. Lisa KoivuTired, Tired, Tired. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 2003 11:19 AMTo: Multiple recipients of list ORACLE-LSubject: Count(*) last 30 seconds Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded witha batch process, so they are in a countinous space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Update NT to 2000 Server
I agree with Jared and Scott that's the best way to do it. -Original Message- Scott Sent: Thursday, February 06, 2003 1:39 PM To: Multiple recipients of list ORACLE-L First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the partition and start from zero, you'll be happy you did. Scott First off, I am not an NT/Win2k admin, and don't even play one on TV. The advice from every SA I've asked about this, and from searching the web, is don't do it. Rebuild the box. There are remnants of NT left if you do an upgrade, and you don't really want that, do you? Jared Breno A. K. Magnago [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2003 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Update NT to 2000 Server Hello, I'd like to update my server (Windows NT) to Windows 2000 Server. I have a Oracle Database 9i in this machine. Does anyone know any kind of problem in this operation (database compatible) ? Thank. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hayes, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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).
Internet Site
Title: Message I got this from this site www.diccionarios.com Warning: OCISessionBegin: ORA-00020: maximum number of processes (150) exceeded in /usr/sunone/webserver/docs/diccionarios/classic/include/sql.inc on line 106Interesting. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Feliz Navidad
Title: Message Hi lists Happy holidays from the warm Dominican Republic. Thanks for all your help throught the year. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Help with Query
Title: Message Hi list I need some help with a query. I have 3 tables ORIGINALES, CAMBIOS_ORIGINALES, DATOS_FABRICANTES, I have to be able to query an article for whatever code the user provide, ex: (NUMERO_ORIGINAL, CAMBIO_ORIGINAL, NUMERO_FABRICANTE). The 3 tables have a common column, NUMERO_ORIGINAL. When he type a code, no matter which one, I have to display the NUMERO_ORIGINAL, CAMBIO_ORIGINAL(s), NUMERO_FABRICANTE(s) and the DESCRIPTION of the article. I merged the 3 codes in the CODIGO_ARTICULO column to make the join for that column, but I can't get the DESCRIPTION of the article. Any help would be appreciated, SQL DESC ORIGINALESName ---GRUPO COMPANIA NUMERO_ORIGINAL NRO_DESCRIPCION SQL DESC CAMBIOS_ORIGINALESName GRUPO COMPANIA NUMERO_ORIGINAL CAMBIO_ORIGINAL SERIE SQL DESC DATOS_FABRICANTESName ---GRUPO COMPANIA NUMERO_ORIGINAL NUMERO_FABRICANTE LOCALIDAD *** This is what I came up with CREATE OR REPLACE VIEW V_ARTICULOS AS SELECTO.NUMERO_ORIGINAL CODIGO_ARTICULO, O.NUMERO_ORIGINAL, D.DESCRIPCION, ' ' CAMBIO_ORIGINAL, ' ' NUMERO_FABRICANTE FROM ORIGINALES O, DESCRIPCIONES D WHERE D.NRO_DESCRIPCION = O.NRO_DESCRIPCIONUNIONSELECTC.CAMBIO_ORIGINAL CODIGO_ARTICULO, ' ', ' ', C.CAMBIO_ORIGINAL, ' ' NUMERO_FABRICANTE FROM CAMBIOS_ORIGINALES CUNIONSELECTD.NUMERO_FABRICANTE CODIGO_ARTICULO, ' ', ' ', ' ', D.NUMERO_FABRICANTE FROM DATOS_FABRICANTES D / CODIGO_ARTICULO NUMERO_ORIGINAL DESCRIPCION CAMBIO_ORIGINAL NUMERO_FABRICANTE -- 1 1 DESCRIPCION UNO101-122519C1020 12251-PC1-020 101-122519C1020101-12251PC1000 12251-PC1-020 101-12251PC100010A 10A DESCRIPCION UNO10 10A 1010ABC 10A 10ABC12251-PC1-020 12251-PC1-020 JUNTA DE CULATA12345 12345 DESCRIPCION UNO12345A 12345 12345A12345AA 12345 12345AA1414-TT-1414-BR 3 1414-TT-1414-BR147 147 DESCRIPCION UNO Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Oracle Log Miner Question
Title: Message Enterprise Manager -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, November 26, 2002 10:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Log Miner QuestionDear All, Does anybody know if there is a front end tool available for the Oracle Log Miner...? Prem
RE: login trigger
Title: Message CREATE OR REPLACE TRIGGER sys.XXX_onlogon AFTER LOGON ON DATABASE DECLARE USUARIOW VARCHAR2(25) := ''; COMPUTADORAW VARCHAR2(25) := ''; BEGIN SELECT OSUSER, MACHINE INTO USUARIOW, COMPUTADORAW FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID'); INSERT INTO SYSTEM.CONTROL_USUARIOS (USUARIO, USUARIO_OS, FECHA, COMPUTADORA) VALUES (ORA_LOGIN_USER, USUARIOW, SYSDATE, COMPUTADORAW); END; You add whatever you need more !! Luck !! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Leonard, GeorgeSent: Tuesday, October 22, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: login trigger Hi all I need to record the time, sun process id and oracle proc id when a user connects. This needs to be done via a trigger, does someone have something like this handy, I am battling trying to find out in a trigger what the user's information is. thx George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
RE: Multiple Listeners
You are right Kirti This is a new feature of 8i. It also does it in 9i. Ramon -Original Message- Kirti Sent: Wednesday, October 16, 2002 3:15 PM To: Multiple recipients of list ORACLE-L That's because of the new feature of Auto Registration with Listener... I guess, it's about time to review docs for changes in 8i Release 2 (8.1.7)... there could be more such surprises :) - Kirti -Original Message- Sent: Wednesday, October 16, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Hmm, The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. Still thinking.I am. - Original Message - To: 'Rachna Vaidya' [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:33 PM again, I think its better to use one listener. Unless you have some reason for needed two of them. just me 2 cents :-) nabil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Ramon E. Estevez 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: Controlling Users Logons
Kirti, I used this to control users not to connect using SQLPLUS, TOAD, NAVIGATOR, etc. Try it to check if it works for you. -- Start of DDL Script for Trigger SYS.LOGON_AUDIT_T -- Generated 20-May-2002 05:31:48 p.m. from U20188@PROD CREATE OR REPLACE TRIGGER sys.logon_audit_t after logon on database declare user_name varchar2(30); program_name varchar2(40); machine_name varchar2(40); user_number number; logon_date date; contador integer; contador1 integer; external_tool boolean := false; cursor c1 is select username, program , machine, sysdate from v$session where audsid=userenv('sessionid'); begin open c1; fetch c1 into user_name, program_name, machine_name, logon_date; close c1; insert into logon_audit values(user_name, program_name,machine_name, logon_date); commit; select count(*) into contador1 from v$session where username = user_name andmachine = machine_name; select user# into user_number from sys.user$ where name = user_name; select count(*) into contador from user$ where type# = 0 and user# in (select privilege# from sysauth$ where grantee# = user_number and privilege# in (select user# from user$ where type#=0 and name in ('DBA_JUNIOR','DBA_SENIOR'))); if ( (upper(program_name) LIKE ('%PLUS%') or upper(program_name) LIKE ('%TOAD%') OR upper(program_name) LIKE ('SQLNAV%')) ) then external_tool := true; end if ; if (external_tool) and (contador=0) then raise_application_error(-20001,'No puede conectarse utilizando esta aplicacion'); end if; if (contador=0) and (contador1=0) then raise_application_error(-20001,'No puede conectarse desde esta terminal'); end if; exception when others then raise_application_error(-20001,'No puede ningun privilegio asignado, contacte del depto de seguridad de sistemas'); end; / Luck, Ramon -Original Message- Kirti Sent: Friday, October 11, 2002 10:14 AM To: Multiple recipients of list ORACLE-L They can come in from various 'machines'. - Kirti -Original Message- Sent: Friday, October 11, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Modify init.ora
Title: Message Yes, the process parameter will be increased to the value you changed. The Init.ora, parameter file, is used anytime you start your DB. Probably you should check the parameters for the SGA. Luck -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of shuan.tay(PCI¾G¸R³Ô)Sent: Tuesday, October 08, 2002 8:24 AMTo: Multiple recipients of list ORACLE-LSubject: Modify init.ora Hi! DBAs, If I modify the "Process" in init.ora after database was created and running for quite a long while, is it true that the maximum of the process will increase as what i changed? do i need to change anything? init.ora will be used everytime the database start, right? or just for the initialization for db creation? thanks in advance.
Re: ORA-03113 with dbms_output and sysdate
SET SERVEROUTPUT ON BEGIN dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); END; / WED, SEP 25 10:20:10002 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:38 AM Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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: cobol-oracle
If you just want a numeric field of 10 positions fieldpic 9(10). -- 10 numeric positions 0123456789 fieldpic 9(10)V99 -- 10 numeric positions plus 2 decimals 0123456789.12 in your definition s means sign field comp-5 means a compressed field. luck Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 3:23 AM hi all how to define a number(10) oracle datatype in microfocus cobol. when we code it as pic s9(10) comp-5 we get an error message PCC-0026 Undeclared host variable name at line num in file name with a number(5) datatype and a cobol definition pic s9(5) comp-5 we don't get the error message. i read in the oracle manuals that there is no representation for the NUMBER datatype in COBOL. Anyone with an explanation ? with regards g.g. kor rdw ict groningen holland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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: Listener load balance
TKS Yechiel for your help, Two more questions. Is there any way I can find out which one of the 2 addresses I am using ? Which isbetter solution this method or add another listener ? Tks for your help TIA Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 4:09 AM Subject: Re: Listener load balance Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have to put this address in the added line in listener.ora and add (load_balance=on). (ADDRESS_LIST = (load_balance=on) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = newnetwork card address)(PORT = 1526)) --- Added ) In the tnsnames you have to use load_balance=on and put both addresses and ports in the address list: (description= (address list= (load_balance=on) (address=(protocol=TCP,host=225.125.110.5,port=1521)) (address=(protocol=TCP,host=newnetwork card address,port=1526)) This way the clients will use both address. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port. I am using local names. (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Listener load balance
Thanks Yechiel and Madlen I was afraid that spreading the IP addresswas going to be the solution !!! Tks again Ramon. - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 11:48 AM Subject: Re: Listener load balance I do not know if you can know which connection the user use. However, these changes apply only to the initial connection. After the user connect he gets a new port number that connect directly to his thread, so I would not worry about the load on the listener. You can use a different tnsnames for each half of you company, One that use the current IP address and one that use the new one. This way you can be sure that the load is spread through both cards. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 5:33 PM Subject: Re: Listener load balance TKS Yechiel for your help, Two more questions. Is there any way I can find out which one of the 2 addresses I am using ? Which isbetter solution this method or add another listener ? Tks for your help TIA Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 4:09 AM Subject: Re: Listener load balance Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have to put this address in the added line in listener.ora and add (load_balance=on). (ADDRESS_LIST = (load_balance=on) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = newnetwork card address)(PORT = 1526)) --- Added ) In the tnsnames you have to use load_balance=on and put both addresses and ports in the address list: (description= (address list= (load_balance=on) (address=(protocol=TCP,host=225.125.110.5,port=1521)) (address=(protocol=TCP,host=newnetwork card address,port=1526)) This way the clients will use both address. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port. I am using local names. (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1
Listener load balance
Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Listener load balance
Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port. I am using local names. (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Oracle 9.2 - MS PROXY 2.0
Hi experts, I had installed in the same server Oracle 8.1.6 and MS Proxy Server 2.0 and worked fine. On monday I deinstalled 8.1.6 from a W2K server, made my backup, erased everything related to Oracle and booted the server. I installed Oracle 9.2.0.1.0 and the Proxy stop working, I deinstalled Oracle HTTP Server, reinstalled the proxy softwarechanged the port number, previously 80, and the problem continued. Stopped the Oracle Services booted the server and the Proxy started again. Did a little research in Metalink and couldn't fine something that could help me. Can anyone of you throw some light about my problem. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Question about database and service name
Hi list, Reading the OU manuals Oracle 9i DBA Fundamentals II , in chapter 2 page 12, found 1-) An oracle database is represented to clients as a service. 2-) A database can have one or more services associated with it. 3-) A database can be presented as multiple services and a service can be implemented as multiple database instances. For the No. 2 : I interpret that I can have 2 or 3 or 4 services for just ONE DB. Is that correct ?. How can I do that ? For the No. 3: I interpret that I can refer to the same DB with differents names. As far as I understand, the DB instance name is unique, it can't be changed. So how can I create several services names for one DB. Or is just a trick in the TNSNAMES.ORA and LISTENER.ORA files. Please can anyone give some light in that, I am totally confused !!! Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Question about database and service name
Thanks a lot, Paul, Stephen, Reginald, Jared and Bob, for clearing my doubts, did the Jared's test and it worked, something new for me I will keep reading the FM, Tks Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 12:13 PM You can easily create more than one service name for a database in TNSNAMES.ORA: just create different names with the same definition. I'm aware that a service can consist of multiple databases, but I've never implemented it and am not sure how it's done. --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Hi list, Reading the OU manuals Oracle 9i DBA Fundamentals II , in chapter 2 page 12, found 1-) An oracle database is represented to clients as a service. 2-) A database can have one or more services associated with it. 3-) A database can be presented as multiple services and a service can be implemented as multiple database instances. For the No. 2 : I interpret that I can have 2 or 3 or 4 services for just ONE DB. Is that correct ?. How can I do that ? For the No. 3: I interpret that I can refer to the same DB with differents names. As far as I understand, the DB instance name is unique, it can't be changed. So how can I create several services names for one DB. Or is just a trick in the TNSNAMES.ORA and LISTENER.ORA files. Please can anyone give some light in that, I am totally confused !!! Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Great SQL Tuning Book
I agree with you Dennis, I've already bought it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 12:34 PM I stumbled on this new book the other day and bought it. I think it is terrific. We DBAs are often asked to help tune SQL statements. This book offers lots of ideas for fixing SQL statements. Most thorough explanation of how the rule-based and cost-based optimizers work that I have encountered. Even provides a chart of the most common causes of bad SQL for each optimizer, and solutions for these problems. A valuable resource for every Oracle DBA. http://www.oreilly.com/catalog/orsqltunpr/ http://www.oreilly.com/catalog/orsqltunpr/ http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1 J http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA 1Jisbn=0596002688 isbn=0596002688 Oracle SQL Tuning Pocket Reference Mark Gurry (Co-authored Oracle Performance Tuning way back in 1993 and updated since) O'Reilly $12.95 U.S. (at this price you might buy copies for some of your developers) Edited by Jonathan Gennick who is kind enough to answer questions on this list now and then. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Great SQL Tuning Book
I agree with you Dennis, I've already bought it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 12:34 PM I stumbled on this new book the other day and bought it. I think it is terrific. We DBAs are often asked to help tune SQL statements. This book offers lots of ideas for fixing SQL statements. Most thorough explanation of how the rule-based and cost-based optimizers work that I have encountered. Even provides a chart of the most common causes of bad SQL for each optimizer, and solutions for these problems. A valuable resource for every Oracle DBA. http://www.oreilly.com/catalog/orsqltunpr/ http://www.oreilly.com/catalog/orsqltunpr/ http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1 J http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA 1Jisbn=0596002688 isbn=0596002688 Oracle SQL Tuning Pocket Reference Mark Gurry (Co-authored Oracle Performance Tuning way back in 1993 and updated since) O'Reilly $12.95 U.S. (at this price you might buy copies for some of your developers) Edited by Jonathan Gennick who is kind enough to answer questions on this list now and then. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL Editor
Take a look to TORA, I prefer it over Toad and has a free version too. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 9:18 AM we're currently looking into this, too Our developers like TOAD, but the licensing cost is pretty steep - $700 a pop for the most pared down version. Quest was willing to offer us a one-time half-price offer, but for the 50 users we were considering it still comes out to over $15,000. PL/SQL Developer does basically everything TOAD does (that our developers do, at least) - explain plans, autotrace, stats, etc. - but with a price cap of $3,000 for unlimited user license it's very attractive. Their email support is pretty good, too - never wait more than a few hours for a response, usually by the same guy. All in all pretty good bang for the buck, and we'll probably end up purchasing it this week or next. I've also looked at Embarcadero's Rapid SQL, which I personally prefer over all the others, but the price is in the same league as TOAD. BMC has product that I haven't really looked into, but I think pricewise it's up there. One note about the Freeware version of TOAD - it has some internal thing that limits it to 5 concurrent connections to the same db, which is a problem for us in a dev shop. -bill -Original Message- Sent: Wednesday, August 28, 2002 8:18 AM To: Multiple recipients of list ORACLE-L PL/SQL Developer. http://www.allroundautomations.nl/plsqldev.html very very good. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel Enviado el: miércoles, 28 de agosto de 2002 9:13 Para: Multiple recipients of list ORACLE-L Asunto: RE: PL/SQL Editor Try free Toad at http://www.toadsoft.com/downld.html regards Ofer Harel DBA team Barak ITC [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Hi All, which is the best PL/SQL editor available as a trial version . the editor should support Oracle sql,PL/SQL and may or may not support debugging. The tool should be support Win 9X OS and provide best performance . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 example scripts
Thanks Joe. - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 14, 2002 9:58 AM Subject: RMAN example scripts http://www.oracle-dba.com/rman joe
Re: Simple question on logging..
ALTER TABLE yourtable NOLOGGING - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 4:33 PM Hi Gurus, How can I turn off logging for a table in Oracle7.3 database. Iam planning to reorg thru ctas and want to use append hint for loading data. SQL alter table tt unrecoverable; alter table tt unrecoverable * ERROR at line 1: ORA-01735: invalid ALTER TABLE option SQL alter table tt nologging; alter table tt nologging * ERROR at line 1: ORA-01735: invalid ALTER TABLE option TIA peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Procedure Execution time
Atin, Include in your procedure some code to insert into a table the start and end time of the execution of the procedure. You can add more functionality like records processed, etc. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 8:23 AM I want to know is there any way I can find out ,when particular procedure is executed.?? Thanks regards, --- Atin Kumar Jain OCP 8i DBA IBM Global Services SO Jamshedpur 0657- 424478 [EMAIL PROTECTED] [EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ATIN KUMAR JAIN INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Free ware databases: which are worth the money?
Mark, My recommendation is Interbase, very good DB. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 5:33 AM Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Don, What are you using for deploy the applications ?? I am interested in this topic too. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 10:33 AM Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
tks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:39 AM The application will be developped in ASP, the deployed version would juste be a lighter version of the main application. --- Ramon E. Estevez [EMAIL PROTECTED] a écrit : Don, What are you using for deploy the applications ?? I am interested in this topic too. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 10:33 AM Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: extremely high number of executions
Jared, What do you think of those values, what should I pay attention ? tia Ramon EVENTTOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- -- --- db file sequential read 113400 0 277.22 .244462081 db file scattered read67216 0 302.23 .449639967 smon timer4618 4610 1416823.33 30680.4532 pmon timer 461116 4603571416861.73 307.267961 rdbms ipc message 1464153 1390637 8499583.86580.512 SQL*Net message from client 7010003 0 17798435.8 253.900545 control file parallel write460820 0 2.01 .000436179 control file sequential read 3959 0 7.95 .200808285 log file sync 19345 0 16.43 .084931507 log file sequential read2427 0 17.56 .723526988 direct path write 145205 0112.74 .077641954 direct path read 251233 0190.41 .075790203 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 4:13 PM What does this tell you? select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / Johnson Poovathummoottil [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/2002 01:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:extremely high number of executions Hi All, We have an application which executes one sql statement more than 10 million times a day. Everything is good about the sql, well tuned, uses indexes, parse only once, etc. The number of concurrent users in this database seems to around 60, but we see an average 1500 executions/sec. We questioned the developers about the sql as we had seen 80% to 95% latch sleeps on library cache constantly. They seem to be hitting the database every time a page is refreshed instead of storing the retrieved data some where for later use. The developers are of the opinion that cookies and session variables are considered #34;the much detested and reviled Satan and Lucifer of all #34;stateful#34; web apps#34;. Any comments/opinion? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Oracle 8i on Windows XP?
Easier , RH, easier ??? Are you kidding. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 2:48 PM On 2002.07.27 14:49 Eric D. Pierce wrote: JUST SETUP A DUAL BOOT OF WINDOWS 2000 PRO AND WINDOWS XP PRO AND MAKE YOUR LIFE EASIER!!! And then reformat all your disks, install Red Hat 7.3 and make your life still easier. No dual boot required. Keep your system Micros*t free. --- Remember, Windows .NET Server 2003 (the precise term used by Bill Gates recently) is the next evolution of the kind of production platform that Oracle server needs to run on, Yes. The most significant advance is that the blue screen of death will be replaced by the green one, to signify Microsoft's concerns for our environment. Microsoft is famous for the stability of its products, particularly the Exchange. Microsoft is really something that you want your production database to be running on. Does the .net part mean that a database running on a MS sever will be vulnerable to any damned virus there is on the (.)net? -- NOT XP (which is a desktop platform)!!! Not on my desk! XP is the desktop Whistler, whereas Windows .NET Server 2003 is the server version of Whistler. Oracle will probably have the same problem with Longhorn, which will be the next evolutionary step in the desktop Since when is return to the dinosaurs called evolution? progression after XP. Donward progression, that is. Just press Ctrl-Alt-Del. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: dblink problem ( ORA-02019)
Check the parameter GLOBAL_NAMES, the best if have them FALSE in both instances. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 5:28 AM Hi thanks for your mail. Dick , I checked out , both db's are 8.1.7.2 and have same db_domain as world. i also tried out Suzy Vordos' suggestion : selected name,value,ismodified from v$paramater for both databases , but the result for both is same . So change in init.ora or alter system after db startup does not seem likely. regards Ratnesh -Original Message- Sent: Tuesday, July 16, 2002 6:57 PM To: Ratnesh Kumar Singh; Multiple recipients of list ORACLE-L Folks, Since I recently slammed into this unexpected wall I'll pass along the experience. A couple of weeks ago I upgraded an 8.0.5.2.1 instance to 8.1.7 and subsequently at OTS's request to 8.1.7.4. To make a long story short most things with database links worked OK, but a describe across one did not (ORA-02019). The problem ended up being a small error in Oracle's INIT parameter documentation. Back in 8.0.5.2.1, due to a bug introduced, you needed to have DB_DOMAIN=.WORLD or DB_DOMAIN=.VICR.COM. Note the '.' before the domain. Well in 8.1.7, or sometime before that, they fixed the bug, but forgot about those of us who don't always follow the 'yellow brick road'. So if your having problems with ORA-02019's take a second and check this parameter in your init.ora. I changed mine the problems went away. Dick Goulet - Original Message - From: Ratnesh Kumar Singh To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X from B to X. The syntax for dblink creation is exactly same for both dblinks. I am able to query from dblink A-X as select * from user.table@dblinkAX but when i try to query from dblink B-X as select * from user.table@dblinkBX i get the foll error Error: ORA-02019: connection description for remote database not found When i modify my query by suffixing '.world' as select * from [EMAIL PROTECTED] , the query works fine. I have compared the entries in init,sqlnet,tnsnmames,listener files on both A B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Import Error
Hamid, try setting NLS_CHAR=WE8ISO8859P1 in the session doing the import. HTH Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:38 AM Hi List, This morning I try to import a dump file from another database(oracle 8.1.6) to my database(oracle 8.17.4 sun solaris )but I got the following error, after I check the error message it said it is an internal error, What do you think: import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) IMP-00069: Could not convert to environment national character set's handle Is there any solution. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where is Oracle 9.2 init.ora?
Kirti, I am using Red Hat 7.1, I will test it in W2K - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 15, 2002 3:53 PM Ramon, I can not explain that. What platform are you on? May be this is another bug with SPFILE. - Kirti -Original Message- From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: Re: Where is Oracle 9.2 init.ora? Hi Kirti I have something to add to the topic. I could edit the spfile with VI and add a parameter with a value of 20, later add the same parameter to the init file with a value of 30, bounce the DB and it worked very fine. SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL SHOW PARAMETER JOB NAME TYPEVALUE --- --- --- job_queue_processes integer 20 -- spfile SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL show parameter job NAME TYPEVALUE --- --- --- job_queue_processes integer 30 -- init SQL SQL Could you explain me that ??? Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 5:58 PM All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL conn / as sysdba Connected to an idle instance. SQL startup using spfile ORACLE instance started. Total System Global Area 72273416 bytes Fixed Size 437768 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 33554432 SQL !mv spfileKED9.ora spfileKED9.ora.bak -- hide the spfile SQL !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora SQL alter system set db_cache_size=10M scope=both; -- try to set a new value System altered. --- No problem? SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 12582912 -- New value in effect. SQL !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora -- Still no SFILE -- Now, why would not Oracle tell us that there was no spfile to process SCOPE=BOTH ? SQL c/both/spfile 1* alter system set db_cache_size=10M scope=spfile SQL / alter system set db_cache_size=10M scope=spfile * ERROR at line 1: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3 --This is what should have happened with SCOPE=BOTH as well, or at least a warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no SPFILE available. I would not have objected if Oracle re-recreated SPFILE in the default location and told me so! If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I would like to know the source of that information. I have searched Metalink, Google but have not come across any. I have created an iTar with OWS. Thanks. As I said before, SPFILE has some things that need to be made fool proof. This time I did not drink prior to doing this 'scary' stuff !!;-) Regards, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City
Re: Where is Oracle 9.2 init.ora?
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 12, 2002 8:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora? Some of us have been around the block a few times. :) Editing binary files is no big deal. You neophytes are all the same. Jared ltiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/12/2002 04:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Where is Oracle 9.2 init.ora? You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Active sql
Jamadagni, Tks for the help. After creating the xviews it worked fine for function, packages, procedures. I want to include SQL statements also. Was checking but just return numbers, that explain the decode. select distinct kglobtyp from X_$KGLOB KGLOBTYP -- 0 1 2 3 4 5 6 7 8 9 10 What is the number for SQL statements ??? or Which one is the table of description for the numbers in the X_$KGLOB view ? TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 3:26 PM http://www.ixora.com.au/scripts/sql/create_xviews.sql Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 03, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Jamadagni I am getting an error sys.X_$KSUSE s * ERROR at line 12: ORA-00942: table or view does not exist Tested on 8.1.7 and 9.0.1 and the same error. What script should I run to create that table or view ? TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 1:13 PM prompt Currently Executing Packages SELECT substr(DECODE(o.kglobtyp, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, 'CLASS'),1,15) TYPE, substr(o.kglnaown,1,30) OWNER, substr(o.kglnaobj,1,30) NAME, s.indx SID, s.ksuseser SERIAL FROM sys.X_$KGLOB o, sys.X_$KGLPN p, sys.X_$KSUSE s WHERE o.inst_id = USERENV('Instance') AND p.inst_id = USERENV('Instance') AND s.inst_id = USERENV('Instance') AND o.kglhdpmd = 2 AND o.kglobtyp IN (7, 8, 9, 12, 13) AND p.kglpnhdl = o.kglhdadr AND s.addr = p.kglpnses ORDER BY 1, 2, 3 / Courtsy of Steve Adams. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 03, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Hi gurus, Is there any way to know which SQL statement or procedure or package is running actually. I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Active sql
Thanks very much Jamadagni, It works fine. Another question, I issued a huge select, ran the script and it appeared. I cancelled the select and it still showed up in the result script like for more than 3 minutes, exited the session and dissapeared. Is this the normal behavior ?? Tks I am satisfied with the solution. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 1:00 PM decode(kglobtyp,0,'CURSOR',7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE', 11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY','OTHER') Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, July 11, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Jamadagni, Tks for the help. After creating the xviews it worked fine for function, packages, procedures. I want to include SQL statements also. Was checking but just return numbers, that explain the decode. select distinct kglobtyp from X_$KGLOB KGLOBTYP -- 0 1 2 3 4 5 6 7 8 9 10 What is the number for SQL statements ??? or Which one is the table of description for the numbers in the X_$KGLOB view ? TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 3:26 PM http://www.ixora.com.au/scripts/sql/create_xviews.sql Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 03, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Jamadagni I am getting an error sys.X_$KSUSE s * ERROR at line 12: ORA-00942: table or view does not exist Tested on 8.1.7 and 9.0.1 and the same error. What script should I run to create that table or view ? TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 1:13 PM prompt Currently Executing Packages SELECT substr(DECODE(o.kglobtyp, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, 'CLASS'),1,15) TYPE, substr(o.kglnaown,1,30) OWNER, substr(o.kglnaobj,1,30) NAME, s.indx SID, s.ksuseser SERIAL FROM sys.X_$KGLOB o, sys.X_$KGLPN p, sys.X_$KSUSE s WHERE o.inst_id = USERENV('Instance') AND p.inst_id = USERENV('Instance') AND s.inst_id = USERENV('Instance') AND o.kglhdpmd = 2 AND o.kglobtyp IN (7, 8, 9, 12, 13) AND p.kglpnhdl = o.kglhdadr AND s.addr = p.kglpnses ORDER BY 1, 2, 3 / Courtsy of Steve Adams. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 03, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Hi gurus, Is there any way to know which SQL statement or procedure or package is running actually. I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
Re: How to?
Nguyen, 1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio' 2) Create the dictonary file Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio'); 3) Reset the list and create a new one Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log', dbms_logmnr.new); 4) Add more redos to analyze Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log', dbms_logmnr.addfile); 5) Perform the analysis Execute DBMS_LOGMNR.START_LOGMNR(dictionary='d:\directorio\dictionary'); 6) Do a select from the V$LOGMNR_CONTENTS HTH Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 12:48 PM Using LogMiner to read redo log, how do I tell a transaction is modified by which user and where user logins from like what columns in LogMiner should tell me this kind of information? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: runInstaller -- Linux help?
from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Copy
Yechiel, No, it is available at 8.1.7 also, it worked through a dblink. I thought it will do it thru the local tnsnames. tks Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, July 07, 2002 7:33 AM Subject: Re: Copy I checked the docs for 8.1.6 and 9.0.1. I think that the copy command is new in 9i. make sure that you are logged on to 9i sqlplus when you issue this command. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 10:08 PM Subject: Copy Hi list, I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB 8.1.7 on NT using this statement COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT * FROM DATOS_BALANCES; ERROR at line 1:ORA-00900: invalid SQL statement Do I need a DBLINK, if yes, is it obligatory ? TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Copy
Rachel, Joe, Anjo and for all that reply, The only way it worked for me was using a dblink. As always tks for your comentaries !!! Tks Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 07, 2002 8:23 AM copy has been around for a lng time from the 8.1.7 docs COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)] USING query and the example SQL COPY FROM SCOTT/TIGER@HQ - CREATE SALESMEN (EMPNO,SALESMAN) - USING SELECT EMPNO, ENAME FROM EMP - WHERE JOB='SALESMAN' if you are copying within the same database you can leave out the from/to clause. If you are logged onto one of the two databases, you can leave out the from or to clause --- Yechiel Adar [EMAIL PROTECTED] wrote: I checked the docs for 8.1.6 and 9.0.1. I think that the copy command is new in 9i. make sure that you are logged on to 9i sqlplus when you issue this command. Yechiel Adar Mehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 10:08 PM Subject: Copy Hi list, I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB 8.1.7 on NT using this statement COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT * FROM DATOS_BALANCES; ERROR at line 1: ORA-00900: invalid SQL statement Do I need a DBLINK, if yes, is it obligatory ? TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Increase size of REDO log
First, Check for the one that is not the current one. Select * from V$log; ALTER DATABASE DROP LOGFILE '/u01/oradata/orcl/redo01.log'; delete the file manually ALTER DATABASE ADD LOGFILE '/u01/oradata/orcl/redo01.log' size 30M; Change your size to your desire one. For the other ones do the same. To change the active one. ALTER SYSTEM SWITCH LOGFILE; hth Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:33 AM How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reset Sequence code
Nice trick Joe !!! - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 8:48 AM Subject: Reset Sequence code NO, you dont need to DROPthe sequence, here is demo code i used to reset a sequence(this resets it back to 1). SQL drop sequence test_seq; Sequence dropped. SQL create sequence test_seq; Sequence created. SQL SQL declare 2 seq_hold_var number; 3 begin 4 for i in 1 .. 10 loop 5 select test_seq.nextval into seq_hold_var from dual; 6 end loop; 7 end; 8 / PL/SQL procedure successfully completed. SQL SQL select test_seq.nextval from dual; NEXTVAL -- 11 SQL SQL alter sequence test_seq increment by -10; Sequence altered. SQL SQL select test_seq.nextval from dual; NEXTVAL -- 1 SQL SQL alter sequence test_seq increment by 1; Sequence altered.
Copy
Hi list, I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB 8.1.7 on NT using this statement COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT * FROM DATOS_BALANCES; ERROR at line 1:ORA-00900: invalid SQL statement Do I need a DBLINK, if yes, is it obligatory ? TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Active sql
Hi gurus, Is there any way to know which SQL statement or procedure or package is running actually. I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Active sql
Jamadagni I am getting an error sys.X_$KSUSE s * ERROR at line 12: ORA-00942: table or view does not exist Tested on 8.1.7 and 9.0.1 and the same error. What script should I run to create that table or view ? TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 1:13 PM prompt Currently Executing Packages SELECT substr(DECODE(o.kglobtyp, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, 'CLASS'),1,15) TYPE, substr(o.kglnaown,1,30) OWNER, substr(o.kglnaobj,1,30) NAME, s.indx SID, s.ksuseser SERIAL FROM sys.X_$KGLOB o, sys.X_$KGLPN p, sys.X_$KSUSE s WHERE o.inst_id = USERENV('Instance') AND p.inst_id = USERENV('Instance') AND s.inst_id = USERENV('Instance') AND o.kglhdpmd = 2 AND o.kglobtyp IN (7, 8, 9, 12, 13) AND p.kglpnhdl = o.kglhdadr AND s.addr = p.kglpnses ORDER BY 1, 2, 3 / Courtsy of Steve Adams. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, July 03, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Hi gurus, Is there any way to know which SQL statement or procedure or package is running actually. I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: V9.2 SGA
Joe, what happened with your weekly tip about 9i ? Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 9:58 PM For those who dont know(and might not care), OLD: db_block_buffers NEW: db_cache_size OLD: buffer_pool_keep NEW: db_keep_cache_size OLD: buffer_pool_recycle NEW: db_recycle_cache_size NEW: db_2K_cache_size NEW: db_4k_cache_size NEW: db_8k_cache_size NEW: db_16K_cache_size NEW: db_32K_cache_size NEW: sga_max_size Joe Jared Still wrote: Try shared_pool_size, large_pool_size, java_pool_size and shared_pool_reserved size. This is from 8i, there may be additional ones on 9i, or 1 or 2 of those I mentioned may be deprecated. Jared On Monday 24 June 2002 15:05, Charlie Mengler wrote: Yes, I know I need to RTFM, but if some kine soul has a quick answer for me, I'd appreciate it. startup ORACLE instance started. Total System Global Area 168788768 bytes Fixed Size 729888 bytes Variable Size 100663296 bytes Database Buffers 33554432 bytes Redo Buffers 33841152 bytes Database mounted. Database opened. exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production oracle@actaeon:CAN# I just got done upgrading two V7.3.4.5 instances to V9.2 on a sandbox which has only 256MB RAM. Both SGAs are currently sized the same way. The OS is paging/swapping like carzy because SGA1+SGA2256MB. :-( Which initSGA.ora parameters control the Variable Size piece of the 9i SGA? I'd like to shrink this total to around 32MB. TIA HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: recording SQLPlus activity
Ray, You can make ddl trigger at db level and capture the computer name and the osuser from the v$session and insert into a table the result of this. I have a little example of this if you want it I can send you directly. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 1:23 PM Craig, This relates to SQLPLUS. A majority of our developers use sqlplus. There are 2 choices: (a) separate environments for each developer using GRANTS, etc. (b) one single application owner account, where all the developers work. Now, (b) is several hundred times more efficient, and I am looking for input on how to make (b) work for me, not (a). What I would like, ideally speaking: 1. Users log into SQLPlus into the same account. They get tagged. All actions are recorded, especially DDL. Who, When, What SQL, 2. No direct SQLPlus access, i.e. not without being tagged. 3. Restrictions: Only specific users (identified by tags) are to be allowed alter/drop table, etc. Thus, everyone works in the same area, but I'm watching and controlling. 1. PUPBLD does not cut it since its not at the object level 2. Redo logs: One problem is that if everyone is working in the same user, we cant tell who. 3. Audit: what audit can I turn on? thanks. Ray From : Craig Munday [EMAIL PROTECTED] Reply-To : [EMAIL PROTECTED] To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject : RE: recording SQLPlus activity Date : Mon, 24 Jun 2002 18:08:20 -0800 Ray, Why would you want to record every SQL statement that your developers issue? Are they just using SQL*Plus or some other language? Cheers, Craig. -Original Message- Sent: Tuesday, 25 June 2002 10:53 AM To: Multiple recipients of list ORACLE-L I have just been moved to a group with several hundred developers, and to say the least the environment is chaotic. Without putting limits on my developers (such as via READONLY user, etc.), is there some way that every command that a developer executes using SQLPlus gets recorded (by userid and time)? Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: V9.2 SGA
Ok. Joe Good luck !!! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 3:45 PM Ramon, it all depends on my workload and its been a bit much lately, i'm hoping to test logical standby after i get thru studying for 9i upgrade exam and take the test on mid july. joe Ramon E. Estevez wrote: Joe, what happened with your weekly tip about 9i ? Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 9:58 PM For those who dont know(and might not care), OLD: db_block_buffers NEW: db_cache_size OLD: buffer_pool_keep NEW: db_keep_cache_size OLD: buffer_pool_recycle NEW: db_recycle_cache_size NEW: db_2K_cache_size NEW: db_4k_cache_size NEW: db_8k_cache_size NEW: db_16K_cache_size NEW: db_32K_cache_size NEW: sga_max_size Joe Jared Still wrote: Try shared_pool_size, large_pool_size, java_pool_size and shared_pool_reserved size. This is from 8i, there may be additional ones on 9i, or 1 or 2 of those I mentioned may be deprecated. Jared On Monday 24 June 2002 15:05, Charlie Mengler wrote: Yes, I know I need to RTFM, but if some kine soul has a quick answer for me, I'd appreciate it. startup ORACLE instance started. Total System Global Area 168788768 bytes Fixed Size 729888 bytes Variable Size 100663296 bytes Database Buffers 33554432 bytes Redo Buffers 33841152 bytes Database mounted. Database opened. exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production oracle@actaeon:CAN# I just got done upgrading two V7.3.4.5 instances to V9.2 on a sandbox which has only 256MB RAM. Both SGAs are currently sized the same way. The OS is paging/swapping like carzy because SGA1+SGA2256MB. :-( Which initSGA.ora parameters control the Variable Size piece of the 9i SGA? I'd like to shrink this total to around 32MB. TIA HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Log file synch / direct path writes
Jared, Just to clear my thoughts, doubts and keep learning from the list. What implications can cause having a big log buffer. As I can remember, LGWR copy data from the log buffer to the redo logs when log buffer is 1/3 full, timeout, commit and a few more. So it will fire when the first one occurs, base on that theory, what matters if the log buffer is 1mb, 10mb, 100mb. Anyway LGWR will copy the data to the redo logs. I had some problems of performance the last week and some of you got surprised because I had a log buffer of 100MB. I have never read some documentation, obviously have to read more and I am doing it believe me, that tells not to do it. I would like some comentaries or your considerations about this, TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 1:33 PM Just how large is your overly large log buffer? 10 meg? 100 meg? 1 Gig??? ( ok, I've never heard of one this big, but you never know ;) Jared On Friday 21 June 2002 12:48, Erik Williams wrote: I have an instance that is waiting on log file synchs. I suspect that the waits are a result of a overly large redo log buffer. There are also considerable waits on direct path writes. The redo logs are on QuickIO, so I assume that the writes LGWR is writing asynchronously and not a source of the log file synchs. I want to be sure that the log file synchs and direct path writes are not related before I begin to experiment with the size of the redo log buffer. How can I be sure that the waits are being caused by DBWR and not LGWR? What are possible fixes for the direct path writes if it is the DBWR causing them? Multiple DBWR? The datafiles are not on QuickIO, just the redo. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Log file synch / direct path writes
Dennis, 100MB archive log size. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:03 PM Ramon, along the lines of Beth's idea here, how large are the archive logs you are producing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 24, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Ramon, For one thing, LGWR will write the log buffer when it is 1/3 full, or if it reaches 1MB. So, its useless to have the log buffer more than 3MB. The space beyond 3MB could never possibly be used. My .02 Beth -Original Message- Sent: Monday, June 24, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Jared, Just to clear my thoughts, doubts and keep learning from the list. What implications can cause having a big log buffer. As I can remember, LGWR copy data from the log buffer to the redo logs when log buffer is 1/3 full, timeout, commit and a few more. So it will fire when the first one occurs, base on that theory, what matters if the log buffer is 1mb, 10mb, 100mb. Anyway LGWR will copy the data to the redo logs. I had some problems of performance the last week and some of you got surprised because I had a log buffer of 100MB. I have never read some documentation, obviously have to read more and I am doing it believe me, that tells not to do it. I would like some comentaries or your considerations about this, TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 1:33 PM Just how large is your overly large log buffer? 10 meg? 100 meg? 1 Gig??? ( ok, I've never heard of one this big, but you never know ;) Jared On Friday 21 June 2002 12:48, Erik Williams wrote: I have an instance that is waiting on log file synchs. I suspect that the waits are a result of a overly large redo log buffer. There are also considerable waits on direct path writes. The redo logs are on QuickIO, so I assume that the writes LGWR is writing asynchronously and not a source of the log file synchs. I want to be sure that the log file synchs and direct path writes are not related before I begin to experiment with the size of the redo log buffer. How can I be sure that the waits are being caused by DBWR and not LGWR? What are possible fixes for the direct path writes if it is the DBWR causing them? Multiple DBWR? The datafiles are not on QuickIO, just the redo. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself
Re: Log file synch / direct path writes
Tks Dennis, Beth, Madhavan for your answer. Now I get it. Learned something new today about Oracle, that's my goal. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 1:53 PM Hi Ramon, On Mon, 24 Jun 2002 09:28:21 -0800, Ramon E. Estevez [EMAIL PROTECTED] said: What implications can cause having a big log buffer. You want to check the tip from Steve Adams to understand how log buffer works and the implications of a big log buffer http://www.ixora.com.au/tips/tuning/log_buffer_size.htm Hope this helps. Regards, Madhavan http://www.dpapps.com -- Madhavan Amruthur DecisionPoint Applications -- http://fastmail.fm - 100% lightning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Log file synch / direct path writes
That was my point. It doesn't matter that log_buffer = 100MB, if every 3 seconds LGWR will fire anyway even the buffer had only used 1k. tks Andrew - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 3:23 PM Don't forget, LGWR also flushes the buffer every 3 seconds. Think about your transaction rate and whether you will make use of a large buffer space. My $0.02, Andy. -- Andrew Sit Systems Engineer DataMirror Corporation + 1 905 415 0310 (O) + 1 416 839 9908 (M) -Original Message- Sent: Monday, June 24, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Ramon, For one thing, LGWR will write the log buffer when it is 1/3 full, or if it reaches 1MB. So, its useless to have the log buffer more than 3MB. The space beyond 3MB could never possibly be used. My .02 Beth -Original Message- Sent: Monday, June 24, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Jared, Just to clear my thoughts, doubts and keep learning from the list. What implications can cause having a big log buffer. As I can remember, LGWR copy data from the log buffer to the redo logs when log buffer is 1/3 full, timeout, commit and a few more. So it will fire when the first one occurs, base on that theory, what matters if the log buffer is 1mb, 10mb, 100mb. Anyway LGWR will copy the data to the redo logs. I had some problems of performance the last week and some of you got surprised because I had a log buffer of 100MB. I have never read some documentation, obviously have to read more and I am doing it believe me, that tells not to do it. I would like some comentaries or your considerations about this, TIA Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 1:33 PM Just how large is your overly large log buffer? 10 meg? 100 meg? 1 Gig??? ( ok, I've never heard of one this big, but you never know ;) Jared On Friday 21 June 2002 12:48, Erik Williams wrote: I have an instance that is waiting on log file synchs. I suspect that the waits are a result of a overly large redo log buffer. There are also considerable waits on direct path writes. The redo logs are on QuickIO, so I assume that the writes LGWR is writing asynchronously and not a source of the log file synchs. I want to be sure that the log file synchs and direct path writes are not related before I begin to experiment with the size of the redo log buffer. How can I be sure that the waits are being caused by DBWR and not LGWR? What are possible fixes for the direct path writes if it is the DBWR causing them? Multiple DBWR? The datafiles are not on QuickIO, just the redo. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Sit INET: [EMAIL PROTECTED] Fat
Re: Free buffer requested
DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block size 8K I started a process and checked the V$sysstat and get those values are extremely high free buffer requested 28938, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: Free buffer requested
I executed the process using b/e/stat Statistic Total --- - Per TransactionPer Logon Per Second --- redo blocks written 1169331 146166.38 86617.11 794.92 redo buffer allocation retries 776 9757.48 .53 redo entries 382054 47756.75 28300.3 259.72 Statistic Total --- - Per TransactionPer Logon Per Second --- redo log space requests 25 3.13 1.85 .02 redo log space wait time 2189 273.63 162.15 1.49 redo ordering marks 190 23.7514.07 .13 Statistic Total --- - Per TransactionPer Logon Per Second --- redo wastage 130984 16373 9702.5289.04 redo write time 116751 14593.88 8648.2279.37 redo writer latching time 1 .13 .070 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 8:53 PM Ramon - Just to follow that thought, and I apologize if you've responded to this already, how is the disk I/O? Are the controllers very busy? What is the I/O distribution across devices? Is it RAID5? If so, how much RAM does the RAID controller have? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 19, 2002 8:28 PM To: Multiple recipients of list ORACLE-L Igor, Online redologs are 100MB size and in a different disk. Database is NOT in archive. Log switches are ocurring each 2 minutes. I am getting to the conclusion that the processing power of the computer is by far more than the disks can manage. Tks, Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Igor Neyman [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 5:30 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Free buffer requested Ramon, Describing your file allocation, you don't tell, where your online RedoLogs. Also, are you running in archived mode? How often log switches occur? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 4:33 PM Anjo, Igor Apologies, didn't make myself clear. Redo log space wait time has a value of 58,554 Redo buffer allocation retries 18 The another wait statistics where either 0 or pretty close to 0. With this value, I check the Performance manual, PDF version and in chapter 19 page 7 makes reference to this statistic. I incremented the value and nothing happened, initially was 50 MB, for that reason I stopped and ask for help. HTH Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 1:53 PM Hi, I get easily confused, but you mention that 3 statistics are extremely high. Oracle has 200+ statistics, so the others are ok ? Why do you focus on these 3 ? You even fail to mention what you are doing in these tests, so how can we tell you what to do ? Identify the symptoms (these processes need to run 3 times faster, for example) Investigate the symptoms Formulate the root cause fix the the root cause I think that you are skipping a couple of stages in the problem solving process, Anjo. [EMAIL PROTECTED] wrote: Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1 disk DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block size 8K I started a process and checked the V$sysstat and get those values are extremely high free buffer requested 28938, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: Free buffer requested
a process and checked the V$sysstat and get those values are extremely high free buffer requested 28938, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
Re: sequence question
Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
Re: sequence question
Bill, When you do an export you have sequence numbers in cache. Ramon - Original Message - From: Magaliff, Bill To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 10:53 AM Subject: RE: sequence question what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
Re: sequence question
Acording to the manuals SEQUENCE_CACHE_ENTRIES is an obsolete parameter for 8.1.7 Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 12:49 PM Subject: Re: sequence question while going throgh oracle manuals I found saying number of sequence cached is governed by init parameter SEQUENCE_CACHE_ENTRIES . Does it mean that this value should be set = 'number of sequence I want to cache' ...and what happens if a sequence gets aged out from sequence pool . Am I going to loose numbers ? Did any of you guys tried caching high number such as 1 or 100 . Thanks , Bp - Original Message - From: Magaliff, Bill To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 8:53 AM Subject: RE: sequence question what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp