Re: ORACLE-L Digest -- Volume 2003, Number 328
Thank you very much Regards Vaishali On Mon, 24 Nov 2003, Oracle RDBMS Community Forum wrote: ORACLE-L Digest Mon, 24 Nov 2003 Volume 2003, Number 328 In This Issue: Subject Author --- Re: Oracle 8i installation Yechiel Adar [EMAIL PROTECTED] Re: Oracle and Firewall Tanel Poder [EMAIL PROTECTED] Initalization files, etc VirVit [EMAIL PROTECTED] Re: Initalization files, etc Mladen Gogala [EMAIL PROTECTED] Re: Initalization files, etc VirVit [EMAIL PROTECTED] AW: Any articles/books that take relational Stefan Jahnke [EMAIL PROTECTED] VirVit [EMAIL PROTECTED] From: Yechiel Adar [EMAIL PROTECTED] Date: Sun, 23 Nov 2003 17:59:05 +0200 Subject: Re: Oracle 8i installation This is a multi-part message in MIME format. --=_NextPart_000_028C_01C3B1EB.7C53BF40 Content-Type: text/plain; charset=windows-1256 Content-Transfer-Encoding: quoted-printable First I second Mladen recommendation to install 9.2. IIRC there is one KIT file on the installation disk that you need to = rename for the installation to succeed. Also you can use lsnrctl to install the listener service. do: lsnrctl start listener and it will install the service for you (if = the service does not exist, at least in 9i). Yechiel Adar Mehish - Original Message -=20 From: Mohamed Kamal=20 To: Multiple recipients of list ORACLE-L=20 Sent: Sunday, November 23, 2003 10:44 AM Subject: Oracle 8i installation Hi Group, I'm trying to install Oracle 8i in my computer (Windows 2000),after = installtion it gives me this error=20 jrew.exe has generated errors and will be close by woindows java.exe has generated errors and will be close by woindows=20 and i can't found listener service in services so i can't conect to = the database =20 can you help me ? thanks M.Kamal --=_NextPart_000_028C_01C3B1EB.7C53BF40 Content-Type: text/html; charset=windows-1256 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dwindows-1256 META content=3DMSHTML 6.00.2800.1106 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArialFirst I second Mladen recommendation to install=20 9.2./FONT/DIV DIVFONT face=3DArialIIRC there is one KIT file on the installation = disk that=20 you need to rename for the installation to succeed./FONT/DIV DIVFONT face=3DArialAlso you can use lsnrctl to install the listener = service./FONT/DIV DIVFONT face=3DArialdo: lsnrctl start listener and it will install = the service=20 for you (if the service does not exist, at least in 9i)./FONT/DIV DIVnbsp;/DIV DIVYechiel AdarBRMehish/DIV BLOCKQUOTE dir=3Dltr=20 style=3DPADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=3DFONT: 10pt arial- Original Message - /DIV DIV=20 style=3DBACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = blackBFrom:/B=20 A [EMAIL PROTECTED] = href=3Dmailto:[EMAIL PROTECTED]Mohamed=20 Kamal/A /DIV DIV style=3DFONT: 10pt arialBTo:/B A = [EMAIL PROTECTED] href=3Dmailto:[EMAIL PROTECTED]Multiple recipients of list = ORACLE-L/A=20 /DIV DIV style=3DFONT: 10pt arialBSent:/B Sunday, November 23, 2003 = 10:44=20 AM/DIV DIV style=3DFONT: 10pt arialBSubject:/B Oracle 8i = installation/DIV DIVBR/DIV DIVFONT face=3DArial size=3D2Hi Group,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial (Arabic) size=3D2I'm trying to install = Oracle 8i in my=20 computernbsp;(Windows 2000),after installtion it gives me this error=20 /FONT/DIV DIVFONT face=3DArial (Arabic) size=3D2jrew.exe has generated = errors and will=20 be close by woindows/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial (Arabic) size=3D2java.exe has generated = errors and will=20 be close by woindows /FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial (Arabic) size=3D2and i can't found listener = service in=20 services so i can't conect to the databasenbsp; /FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial (Arabic) size=3D2can you help me = ?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial (Arabic) size=3D2thanks/FONT/DIV DIVFONT face=3DArial (Arabic) size=3D2M.Kamal/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BLOCKQUOTE/BODY/HTML --=_NextPart_000_028C_01C3B1EB.7C53BF40-- -- From: Tanel Poder [EMAIL PROTECTED] Date: Sun, 23 Nov 2003 19:44:40 +0200 Subject: Re: Oracle and Firewall If you specify
Anybody familiar with OWB setup and config out there?
Hi! Is anybody out there familiar with OWB setup an config? We are having problems with the OWB-specific-listener required for OWB. This is OWB 9.0.4 on HP-UX 11.11 Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: what is oracle rdb?
I heard that Lego is one a big user of RDB. Don't know if it's true. Patrice. -Original Message- Sent: Monday, November 24, 2003 6:04 PM To: Multiple recipients of list ORACLE-L I believe it *is* still sold; it is certainly still supported. As to why you would buy it, I don't know why anyone would have bought it when Digital was at its prime. I've never liked it. But, it is secure. As of 1993, it was rated B1, when no other database was higher than C2 (they were bound to the operating system to provide security). I think Oracle ingested Rdb's internals and it became Trusted Oracle; but, if you want the Real McCoy, you want Rdb. Of course, if you *really* want the Real McCoy, you need VMS, too (which is rated in the A's with the duplicate password and the generate password and the min password length features). Due to a sudden reversal of earth and sky, VMS is available exclusively from HP. Bambi. -Original Message- Sent: Monday, November 24, 2003 3:30 PM To: Multiple recipients of list ORACLE-L does oracle still sell it? why would you buy it over the rdbms? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:59 PM RDB was bought from Digital Corporation many years ago. Supposedly a lot of the CBO was lifted from it. -Original Message- [EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:49 PM To: Multiple recipients of list ORACLE-L I see it referred to on metalink alot. I know its seperate from the rdbms. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson 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: Ryan 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: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Experiences with Oracle and MS .Net data providers
Hi Some coworkers implemented an application using C# and the MS .NET provider for Oracle (9.0.1 DB). One thing I can remember: Mapping C#'s float datatype to Oracle FLOAT (or NUMBER(...)) somehow didn't work that great. Another thing was that they could not use transaction processing via the underlying COM+ components correctly. Something with the threading went wrong. It did work though for SQL*Server, so they assumed the MS provider for Oracle screwed up. Switching to the Oracle provider wasn't an option anymore either, since the interfaces weren't 100% compatible. I don't know about that since I don't know .NET, but I was surprised that that could be the case. I thought it would work like in Java, where the JDBC driver supplier just implements a certain set of interfaces. If you don't downcast an ResultSet into for example an OracleResultSet and stick to the methods the standard inteface provides, ... no probs. How is it, that data providers can be in incompatible in .NET ? Stefan -Ursprungliche Nachricht- Von: Grant Allen [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 06:59 An: Multiple recipients of list ORACLE-L Betreff: Experiences with Oracle and MS .Net data providers Hi all, Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.). We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling). Anyway, any comments about your use, likes and dislikes of either would be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX OT: exclude files in tar
It doesn't use the exclude, but it would do what you want: cd /home/user01 tar -cvf /dev/rmt0 mark01 mark02 where /dev/rmt0 is your tape device, or you can substitute a disk destination. HTH, Mike Ross Collado [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hpac.comcc: Sent by: Subject: UNIX OT: exclude files in tar [EMAIL PROTECTED] .com 11/25/2003 12:24 AM Please respond to ORACLE-L Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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: Michael Boligan 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).
WebSphere and Oracle
All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Re[2]: what is oracle rdb?
And then Tanel wrote: TP BTW, you can do this in 9i as well... Really? I think when you get down to it, there are some prerequisites to worry about. I just tried the following: C:\Documents and Settings\Jonathansqlplus /nolog SQL*Plus: Release 10.1.0.0.0 - Beta on Mon Nov 24 21:07:30 2003 Copyright (c) 1982, 2003, Oracle Corporation. All rights reserved. SQL create database; SP2-0640: Not connected Ok, it's not as simple as with RDB... You still need to start the instance. I was talking about that novadays you don't have to specify system tablespace nor redolog locations when creating a database, defaults can also be used (even without Oracle Managed Files). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Move datafiles, but can't delete them
Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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).
FW: RMAN Script
Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
IOUG 2004
Title: RE: RE: Development vs. Production DBA I was informed last night that they accepted my seminar proposal, I will be doing an introductory session on how to administer Oracle databases. Hope to see many of you in Toronto next April. In the meantime if there are questions you would like me to cover, send them on -- I will only have an hour but the more relevant the presentation can be, the better. Patrice.
RE: Move datafiles, but can't delete them
Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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: Move datafiles, but can't delete them
Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: 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[2]: what is oracle rdb?
Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: BPJ I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. Heh, I just spent the better part of my Sunday afternoon buying compartmentized boxes and helping my son sort all his legos. When I was a kid, back when the dinasaurs roamed, I had perhaps a dozen distinct Lego shapes to worry about. Now there are so many that I'm sometimes at a loss as to how to categorize and sort them. The worst is when my son pulls out instructions for some Lego toy he bought a year ago, points to his bin with a full Gigablock of Legosgrin, and wants me to help him put together whatever it is. Hence, I've decided to help him sort things out a bit. He might even have a Terablock, I'm afraid to count. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Move datafiles, but can't delete them
Luc, Its weird. I've seen it both ways. Sometimes, Windows releases the lock and allows you to delete the file, and sometimes it doesn't. Bouncing the database always allows you to do it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:43 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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[4]: what is oracle rdb?
Tuesday, November 25, 2003, 8:04:25 AM, Tanel Poder ([EMAIL PROTECTED]) wrote: TP Ok, it's not as simple as with RDB... You still need to start the instance. You'd need to create a control file first, wouldn't you? Or would all that default as well. Hmmm I should probably try it some time. I have to admit, for a long time now I've been taking the lazy way out by using dbca. It's been a long time since I've written a CREATE DATABASE statement by hand. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: what is oracle rdb?
list lurker off Same opinion here, my company is in the process of migrating our software to run on Oracle 9iR2. Currently, we have over 325 production sites that have RDB databases running. RDB is a single schema database so each customer site has multiple databases running. Very easy to manage, backup and yes recover. RDB has always had the cost based optimizer. Logminer has been around for a long time and the backup utility (RMU) supposedly has links to RMAN. As with everything Digital, great technology, crappy marketing, sold to someone who wants the technologies. If it weren't limited to the VMS platform (no flames, I love VMS) it would have a much bigger installation base. Back to the grind...(What was that Unix/Oracle command to...) /list lurker on Scott Graves Sr. Systems Programmer NISC RDQ-STP Email: [EMAIL PROTECTED] Phone: 636-922-9122 x7616 Fax: 636-922-2080 -Original Message- Jonathan Gennick Sent: Monday, November 24, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Monday, November 24, 2003, 3:49:26 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: rcn I see it referred to on metalink alot. I know its seperate from the rdbms. Rdb was the database I cut my teeth on. So easy to use. As I recall, you could create a database with just the following: CREATE DATABASE; Everything, including the database name, would default. It was great, especially for learning on. Digital's online help was unsurpassed too. I learned a lot from that, and from their Rdb manual set. All Rdb's commands worked consistently and logically, and everything was so orthogonal. Heck, if you wanted to see what a table looked like, you just issued commands such as: SHOW TABLE SHOW TABLE /CONSTRAINTS (to see constraints too) SHOW TABLE /INDEXES /CONSTRAINTS SHOW TABLE /ALL (to see everything) I recall beginning my database education by tying HELP RDB at the operating system, and then progressing from there. Typing HELP from within RDB's interactive-SQL utility was sheer joy. One of the first things I did when I made the move to Oracle was to fire up SQL*Plus and issue the SHOW TABLE command to see the structure of a table I was trying to insert into. I was baffled that there was no such command. HELP SHOW didn't help much either, because I discovered that SHOW seemed to show a whole bunch of things I didn't care about and nothing that I did care about. I was even more astounded when I discovered DISPLAY, which didn't, and still doesn't, even begin to give you the information you needed in order to be able to get work done with a table. It took me over a day, as I recall, before I managed to find someone who could show me how to look at constraints on a table. I'd heard all these great and wonderful things about Oracle, that it was *the* database to learn. Well, from a career standpoint that's probably true, Oracle was the database to learn, but certainly not from a usability standpoint. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Scott Graves 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: Re[2]: what is oracle rdb?
Jonathan Gennick scribbled on the wall in glitter crayon: Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. AFAIK, it's THE largest user of RDB. but that was a few years ago, so i'm not sure now. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] I never think of the future. It comes soon enough. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Move datafiles, but can't delete them
What is most likely happening is that a server, as in client dedicated, has an interest in those files consequently Windoze won't let you delete then until the end user terminates their session. Now while Unix won't give you an error in this situation you'll notice that you don't get the disk space back immediately. Also on Unix, provided you have a helpful SA, you can run an fuser on the files to find out who is using them. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Experiences with Oracle and MS .Net data providers
On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are compatible and standards, which are used much in the same way as the phrase zum Donnerwetter is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Move datafiles, but can't delete them
.. and the reason you don't get the space back immediately is because the file is still open, and not actually deleted yet. Jared On Tue, 2003-11-25 at 06:24, Goulet, Dick wrote: What is most likely happening is that a server, as in client dedicated, has an interest in those files consequently Windoze won't let you delete then until the end user terminates their session. Now while Unix won't give you an error in this situation you'll notice that you don't get the disk space back immediately. Also on Unix, provided you have a helpful SA, you can run an fuser on the files to find out who is using them. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WebSphere and Oracle
The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move datafiles, but can't delete them
In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - XCTEND rlbk=1, rd_only=1
hmmm... I think I meant OCITransCommit() there, not OCITransRollback(). Nobody caught that? :) Jared On Mon, 2003-11-24 at 18:29, Jared Still wrote: OCI defaults to rollback on transactions on disconnect if OCITransRollback() has not been called. Don't ask me for too much detail, as I'm not an OCI programmer, I just pulled this straight from The Fine Manual. Jared On Mon, 2003-11-24 at 16:54, Boris Dali wrote: I've got a third party package that connects to Oracle via OCI and works in HTTP-like (stateless) fashion. Reviewing raw SQL trace output I don't see a single commit or rollback there, but there are plenty of XCTEND tx markers with rlbk=1 (after about every SELECT statement). Is this normal? Does this mean that this app rollbacks (implicitly?) after each of those selects? Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG 2004
Title: RE: RE: Development vs. Production DBA It occurred to me that there probably aren't many new DBAs on the list... LOL Patrice. -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 25, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: IOUG 2004 I was informed last night that they accepted my seminar proposal, I will be doing an introductory session on how to administer Oracle databases. Hope to see many of you in Toronto next April. In the meantime if there are questions you would like me to cover, send them on -- I will only have an hour but the more relevant the presentation can be, the better. Patrice.
AW: Experiences with Oracle and MS .Net data providers
Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's Hailstorm - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or maybe I have to keep playing with MONO. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are compatible and standards, which are used much in the same way as the phrase zum Donnerwetter is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX OT: exclude files in tar
I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (*.pl) { if (/connect/) {print $_\n;}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each and every time. That is precisely why Unix is such a great OS and Slowaris definitely is Unix, unless SCO has revoked the license. On 11/25/2003 12:24:26 AM, Ross Collado wrote: Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: what is oracle rdb?
I've said it before and I'll say it again...coding for RDB was a dream. Instead of having to rely on a preparser, there was a separate compiler that tokenized your SQL code into a object module to be linked with your program(s). Aside from making program maintenance potentially easier, it also allowed language independant so you could code in MACRO, BLISS, Ada, BASIC, C, FORTRAN, or even Mladen's favorite, COBOL. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, November 24, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Monday, November 24, 2003, 3:49:26 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: rcn I see it referred to on metalink alot. I know its seperate from the rdbms. Rdb was the database I cut my teeth on. So easy to use. As I recall, you could create a database with just the following: CREATE DATABASE; Everything, including the database name, would default. It was great, especially for learning on. Digital's online help was unsurpassed too. I learned a lot from that, and from their Rdb manual set. All Rdb's commands worked consistently and logically, and everything was so orthogonal. Heck, if you wanted to see what a table looked like, you just issued commands such as: SHOW TABLE SHOW TABLE /CONSTRAINTS (to see constraints too) SHOW TABLE /INDEXES /CONSTRAINTS SHOW TABLE /ALL (to see everything) I recall beginning my database education by tying HELP RDB at the operating system, and then progressing from there. Typing HELP from within RDB's interactive-SQL utility was sheer joy. One of the first things I did when I made the move to Oracle was to fire up SQL*Plus and issue the SHOW TABLE command to see the structure of a table I was trying to insert into. I was baffled that there was no such command. HELP SHOW didn't help much either, because I discovered that SHOW seemed to show a whole bunch of things I didn't care about and nothing that I did care about. I was even more astounded when I discovered DISPLAY, which didn't, and still doesn't, even begin to give you the information you needed in order to be able to get work done with a table. It took me over a day, as I recall, before I managed to find someone who could show me how to look at constraints on a table. I'd heard all these great and wonderful things about Oracle, that it was *the* database to learn. Well, from a career standpoint that's probably true, Oracle was the database to learn, but certainly not from a usability standpoint. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WebSphere and Oracle
Thanks Dick. I agree it's not a database problem, but they try and push it my way because it's Oracle. I'm pushing back. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 9:50 AM To: Multiple recipients of list ORACLE-L The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Re[2]: what is oracle rdb?
Where's our Award-Winning Educator and former Lego DBA, Mogens? If there is one dream job for me, it would be an Oracle DBA at Lego. And I was upset to find that someone took my legoman username from my ISP at home. :( Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, November 25, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: BPJ I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. Heh, I just spent the better part of my Sunday afternoon buying compartmentized boxes and helping my son sort all his legos. When I was a kid, back when the dinasaurs roamed, I had perhaps a dozen distinct Lego shapes to worry about. Now there are so many that I'm sometimes at a loss as to how to categorize and sort them. The worst is when my son pulls out instructions for some Lego toy he bought a year ago, points to his bin with a full Gigablock of Legosgrin, and wants me to help him put together whatever it is. Hence, I've decided to help him sort things out a bit. He might even have a Terablock, I'm afraid to count. Best regards, Jonathan Gennick --- Brighten the corner where you are -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PowerPoint and Oracle
A wild one here - but has anyone stuffed PowerPoint files into Oracle, together with associated metadata? Either complete (the easier solution) or decomposed for easier review. thanks, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Experiences with Oracle and MS .Net data providers
Actually, it was a deliberate word play, just to remind you that not all MS projects are successful. They were talking about porting .NOT to Unix, but gave up. It's a MS-only world. On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote: Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's Hailstorm - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or maybe I have to keep playing with MONO. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are compatible and standards, which are used much in the same way as the phrase zum Donnerwetter is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Re: UNIX OT: exclude files in tar
tar cvf /tmp/test1.tar `perl -e 'foreach On 11/25/2003 12:24:26 AM, Ross Collado wrote: Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt Here is how to do it: Create script called /tmp/tmp1.pl containing the following: #!/usr/bin/perl open FL,find /home -print|||die Cannot open file:$!\n; $pattern=\/mark03\/; while (FL) { chomp; if (/$pattern/) { next; } print $_\n; } Purists will cringe when seeing a script without use strict and executing find but it's short and it works. Next, you chmod /tmp/tmp1.pl to 700 and do tar cvf /mydir/myfile.tar `/tmp/tmp1.pl` It works each and every time. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
SUN question
Does anybody know what the SZ is represents(SUN SOLARIS) ps -efly | egrep 'ora|SZ' bach# ps -efly | egrep 'oracle|SZ' S UID PID PPID C PRI NI RSS SZ WCHANSTIME TTY TIME CMD S oracle 27845 1 0 77 20596552 617600? 02:00:04 ?0:26 oracleTRACS (DESCRIPTION=(LOCAL=no) S oracle 27169 1 0 51 20599536 631296? 23:14:36 ?0:53 oracleTRACS (DESCRIPTION=(LOCAL=no) S oracle 521 1 0 53 202968 9528? Oct 04 ? 1:30 /dbopt/app/oracle/product/817/bin/t man pages states(-y converts it to Kb instead of pages): SZ (l) The total size of the process in virtual memory, including all mapped files and devices, in pages. See pagesize(1). What does this mean? Does this mean that peocess 27845 is using 617600Kb of RAM? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa 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).
insert in batch loading
Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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: insert in batch loading
How big are yor redo logs? How many o them do you have? On 11/25/2003 10:29:37 AM, David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Move datafiles, but can't delete them
Side note on this - while you can delete files that are in use by Oracle on UNIX, you have not actually deleted them until there are no processes accessing that file anymore. The file will no longer be there to other applications, but the space used by that now-deleted file will not be released until all of the processes accessing it close their file descriptors. Lsof and fuser are useful tools to track un-reclaimed space due to processes still accessing deleted files. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jared Still Sent: Tuesday, November 25, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move datafiles, but can't delete them In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- 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: Mercadante, Thomas F 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services--
RE: [***SPAM***] - Experiences with Oracle and MS .Net data providers - Found word(s) to be removed remove based list e-mail in the Text body.
We are using the latest ODP.net provider and up until we upgraded to 92040 had few and minor problems with it. Mostly it was differences between all of the different drivers that our programmers were using based on either the cycles of the moon or which team won the World Series. Since we went to ODP.NET things are much smoother and I dont hear any complaining about things WAY out of my control. When we upgraded to 92040 something changed where one column in one database is now appearing to have a different numeric format than prior to the upgrade. I think that there is this issue with this one column(which is set up in a way that I cant recreate ) and we will fix it soon but overall it is working very well. -Original Message- Sent: Monday, November 24, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Hi all, Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.). We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling). Anyway, any comments about your use, likes and dislikes of either would be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- 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: Tony Johnson 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[2]: what is oracle rdb?
Tuesday, November 25, 2003, 10:04:39 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote: JR Instead of having to rely on a preparser, there was a separate compiler JR that tokenized your SQL code into a object module to be linked with your JR program(s). Yeah, the module compiler was cool. I once wrote a SQL module that let a program hit a database, and also C module with an identical interface that let the same program hit some indexed files on the filesystem. With a simple relink, I could switch between using tables and using files. I guess you could do that without the SQL Module compiler too, but I really liked using the module compiler. It seemed a better way to organize SQL, and it probably forced me to put a bit more thought into the SQL that I wrote for an application. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Experiences with Oracle and MS .Net data providers
I have to remember that as a good example for my wife's German classes. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 16:20 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers Actually, it was a deliberate word play, just to remind you that not all MS projects are successful. They were talking about porting .NOT to Unix, but gave up. It's a MS-only world. On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote: Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's Hailstorm - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or maybe I have to keep playing with MONO. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are compatible and standards, which are used much in the same way as the phrase zum Donnerwetter is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail
Re: insert in batch loading
David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx Hi! If you do incremental commits the batch will run slower or not at all (ora -01555). Have you checked how much redo your insert statement generates? You might have missed something. If you have indexes on the table you will have to set them unusable and alter session set skip_unusable_indexes=true Rebuild the indexes after the load with nologging. Janne! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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: UNIX OT: exclude files in tar
Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print -Original Message- I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move datafiles, but can't delete them
If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. oh yeah. working on another DBA's databases (he was out ill), and rushed in the wrong directory when gzipping and moving files to free up space. Because Unix keeps the pointers while the file is open, moving the temp tablespace datafiles away (oops!) and back (phew!) did NOT crash the database. --- Jared Still [EMAIL PROTECTED] wrote: In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: UNIX OT: exclude files in tar
You can use the -L option and have a file listing everything you want ie, ls file edit file and remove the dir you don't want tar files with the -L option and the file you created above. never done this myself -Original Message- [EMAIL PROTECTED] Sent: 25 November 2003 16:44 To: Multiple recipients of list ORACLE-L Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print -Original Message- I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe 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: insert in batch loading
We have 5 groups of redo log. Each group has two members. Each member is 100 MB. David From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 07:44:33 -0800 How big are yor redo logs? How many o them do you have? On 11/25/2003 10:29:37 AM, David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Need a shot of Hank Williams or Patsy Cline? The classic country stars are always singing on MSN Radio Plus. Try one month free! http://join.msn.com/?page=offers/premiumradio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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: insert in batch loading
Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo log size (100 MB) dominates the checkpoint frequency. The table has two indexes. We don't set them to unusable during inserting. David From: Jan Korecki [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 08:19:26 -0800 David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx Hi! If you do incremental commits the batch will run slower or not at all (ora -01555). Have you checked how much redo your insert statement generates? You might have missed something. If you have indexes on the table you will have to set them unusable and alter session set skip_unusable_indexes=true Rebuild the indexes after the load with nologging. Janne! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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). _ online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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).
RMAN Script
Title: RMAN Script Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Beginning of a global unravelling?
Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the beginning of a bring the tech jobs back trend. This may imply that we are [temporarily] moving away from a globalized technical labor force (and therefore global wage equilibrium). Of course, it could mean nothing beyond what it says. Time will tell. In the meantime, here's the link. Enjoy! Bambi. http://www.cnn.com/2003/TECH/biztech/11/24/dell.call.centers.ap/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: WebSphere and Oracle
Absolutely. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Thanks Dick. I agree it's not a database problem, but they try and push it my way because it's Oracle. I'm pushing back. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 9:50 AM To: Multiple recipients of list ORACLE-L The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - recursive relationships
Boris, Cary is correct. It gets a little confusing, especially with pl/sql involved. It also helps to remember to differentiate between database calls (parse/execute/fetch) and other events (wait/stat). Using your example below, I'll attempt an explanation inline. Daniel Fink Boris Dali wrote: Reading Cary's Optimizing Oracle Performance, page 91 it says: A database call with dep=n+1 is the recursive child of the first SUBSEQUENT (empasis mine) dep=n database call listed in the SQL trace data stream Does this apply to the SQL issued from PL/SQL? I am looking at the simple packaged stored proc: PACKAGE BODY nav_tree_pkg is PROCEDURE GET_NAV_PARENT_NODE_ID ( p_NodeId IN NUMBER, p_ParentNodeId OUT NUMBER) IS BEGIN SELECT PARENT_NAV_NODE_ID INTO p_ParentNodeId FROM NAV_NODE WHERE NAV_NODE_ID = p_NodeId; EXCEPTION WHEN NO_DATA_FOUND THEN p_ParentNodeId := -1 ; END; -- Procedure END; ... and here's what I see in the trace (sorry the lines are probably wrapped): = PARSING IN CURSOR #1 len=94 dep=0 uid=83 oct=47 lid=83 tim=1617285502494 hv=1138148843 ad='605d0998' BEGIN nav_tree_pkg.get_nav_parent_node_id( :p_nodeid, :p_parentnodeid ); END; END OF STMT PARSE #1:c=0,e=141,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1617285502483 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=48 offset=0 bfp=83fbc005ff80 bln=22 avl=01 flg=05 value=0 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=24 bfp=83fbc005ff98 bln=22 avl=00 flg=01 = Here, the pl/sql block is parsed. The next step in the statement process is to execute the statement (parse/execute/fetch). However, notice that EXEC #1 is not the next database call. PARSING IN CURSOR #2 len=68 dep=1 uid=98 oct=3 lid=98 tim=1617285503241 hv=1778717541 ad='606795e8' SELECT PARENT_NAV_NODE_ID FROM NAV_NODE WHERE NAV_NODE_ID = :b1 END OF STMT PARSE #2:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1617285503230 BINDS #2: bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=4001 size=24 offset=0 bfp=83fbc005f660 bln=22 avl=01 flg=05 value=0 Okay, here we parse the sql statement inside the block. In the next couple of db calls, we do the execute/fetch of Cursor #2. EXEC #2:c=0,e=151,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1617285503563 FETCH #2:c=0,e=40,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1617285503648 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 EXEC #1:c=0,e=1037,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=4,tim=1617285503786 Here is the execute database call for the block. It is the execution of the block that motivates the parse/execute/fetch of the inner statement. WAIT #1: nam='SQL*Net message from client' ela= 2470 p1=1413697536 p2=1 p3=0 = ... Totaly different calls = So here it looks like the child CURSOR #2 with dep=1 is emitted AFTER the parent (CURSOR #1, dep=0) Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: IOUG 2004
Title: RE: RE: Development vs. Production DBA If I was doing a introductory administration session, I'd emphasize the right way of thinking the most. That is 1) Always make sure that you know what you're doing and what are the potential consequences of your doings 2)Do not do extensive maintenance tasks during peak hours (yes, for some people it is no problem to take down the database server during the most active usage period) 3) Every security hole willbe used eventually 4) A backup strategy is only as good as it's corresponding recovery strategy :) Btw, I'll be presenting 1-2 sessions there too, so see you there. Tanel. - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 25, 2003 3:19 PM Subject: IOUG 2004 I was informed last night that they accepted my seminar proposal, I will be doing an introductory session on how to administer Oracle databases. Hope to see many of you in Toronto next April. In the meantime if there are questions you would like me to cover, send them on -- I will only have an hour but the more relevant the presentation can be, the better. Patrice.
RE: Beginning of a global unravelling?
Bambi, I'm afraid I read something different in that story, but equally pleasant. Like a lot of things in this world sometimes we need to push the press-to-test button and see how the shoe fits before making up our minds. Companies I believe needed to do the same thing with offshoring their IT activity. I've no doubt that a fair amount of application development will remain offshore just like manufacturing jobs are, but that support and infrastructure jobs that have been previously offshored will come back. I'll put it this way, I support a remote site right now that's 3000 miles away. When the crap hits the fan it can easily take 3 times as long to fix as it does when your right there. It was also the reason I recently spent 2 weeks on the road namely down range at that site. Now if all you want to do is monitor the site from India, sure you can do that. But until they invent a way for me to instantiounsly physically access the tape library or cdrom out there from her! e it ain't happening. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the beginning of a bring the tech jobs back trend. This may imply that we are [temporarily] moving away from a globalized technical labor force (and therefore global wage equilibrium). Of course, it could mean nothing beyond what it says. Time will tell. In the meantime, here's the link. Enjoy! Bambi. http://www.cnn.com/2003/TECH/biztech/11/24/dell.call.centers.ap/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - XCTEND rlbk=1, rd_only=1
Jared, actually your initial post made sense anyway - since you can't roll back committed transactions anyway. Also, rollback is done on session end if you haven't done the rollback manually ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:54 PM hmmm... I think I meant OCITransCommit() there, not OCITransRollback(). Nobody caught that? :) Jared On Mon, 2003-11-24 at 18:29, Jared Still wrote: OCI defaults to rollback on transactions on disconnect if OCITransRollback() has not been called. Don't ask me for too much detail, as I'm not an OCI programmer, I just pulled this straight from The Fine Manual. Jared On Mon, 2003-11-24 at 16:54, Boris Dali wrote: I've got a third party package that connects to Oracle via OCI and works in HTTP-like (stateless) fashion. Reviewing raw SQL trace output I don't see a single commit or rollback there, but there are plenty of XCTEND tx markers with rlbk=1 (after about every SELECT statement). Is this normal? Does this mean that this app rollbacks (implicitly?) after each of those selects? Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: SUN question
man pages states(-y converts it to Kb instead of pages): SZ (l) The total size of the process in virtual memory, including all mapped files and devices, in pages. See pagesize(1). What does this mean? Does this mean that peocess 27845 is using 617600Kb of RAM? The process has mapped this amount of RAM. Oracle is using shared memory, so several processes may map and use the same virtual memory segment. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Beginning of a global unravelling?
i heard it was just the corporate call centers coming back? not the private call centers? dell tech support isnt any good no matter where it is. its just an entry level position. The guys who get good move up or on to other things. gateway is bad too. From: Bellow, Bambi [EMAIL PROTECTED] Date: 2003/11/25 Tue PM 12:49:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Beginning of a global unravelling? Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the beginning of a bring the tech jobs back trend. This may imply that we are [temporarily] moving away from a globalized technical labor force (and therefore global wage equilibrium). Of course, it could mean nothing beyond what it says. Time will tell. In the meantime, here's the link. Enjoy! Bambi. http://www.cnn.com/2003/TECH/biztech/11/24/dell.call.centers.ap/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX OT: exclude files in tar
This approach might cause problems, if you have really lots of files - your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:54 PM I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (*.pl) { if (/connect/) {print $_\n;}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each and every time. That is precisely why Unix is such a great OS and Slowaris definitely is Unix, unless SCO has revoked the license. On 11/25/2003 12:24:26 AM, Ross Collado wrote: Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tanel Poder 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: UNIX OT: exclude files in tar
Then I'll pipe it to cpio -H tar, which will solve the problem. On 11/25/2003 01:24:26 PM, Tanel Poder wrote: This approach might cause problems, if you have really lots of files - your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:54 PM I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (*.pl) { if (/connect/) {print $_\n;}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each and every time. That is precisely why Unix is such a great OS and Slowaris definitely is Unix, unless SCO has revoked the license. On 11/25/2003 12:24:26 AM, Ross Collado wrote: Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tanel Poder 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or
Active Directory and ORACLE passwords
Title: Active Directory and ORACLE passwords Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the password would be valid and then pass off to the ORACLE database that password. Any information would help. Thanks in advance David
Oracle networking temp files in /tmp
Hey all, Running Oracle 9.2.0.4 on Linux, I've noticed several files in /tmp owned by the oracle user: BEQ10202 DCE10202 DEC10202 I1S2 ISPX10202 ITCP10202 LU6210202 NMP10202 RAW10202 SPX10202 TCP10202 TCPS10202 US10202 VI10202 BEQ29871 DCE29871 DEC29871 I2S4 ISPX29871 ITCP29871 LU6229871 NMP29871 RAW29871 SPX29871 TCP29871 TCPS29871 US29871 VI29871 It would appear that these files may be related to networking based on the filename prefixes, but I can't find anything about them in the docs nor Metalink. The only files with anything in them are the BEQ*, TCP*, and US* ones, which coincides with the installed networking protocols, except for the US* ones. It appears that those contain some sort of dump or trace. For example, the file TCPS29871 starts off with: ntz.o: d NZPKCS12_MAGIC_NUM U _GLOBAL_OFFSET_TABLE_ U calloc U free t gcc2_compiled. U lxmcpen U lxsCmpStr U memcpy U nldsfprintf U nldtotrc U nlepeget U nlhthfre U nlhthget U nlnvcrb U nlnvdeb U nlnvfbp U nlnvgap U nlpagbp U nlpagsp U nlpagvc U ntctst U ntpafind 6d00 T ntzAllocate 7040 t ntzCheckServerDN 1120 t ntzConfigure 24c0 t ntzConvertToNumeric 6860 t ntzCreateCipherSpec 08e0 t ntzCreateConnection Anyone know what these might be? Since this is my desktop, I'm really tempted to just blow them away and see what happens, but if nothing happens it won't be much fun. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Beginning of a global unravelling?
Does that mean that we will not have to replace ourselves with the cheap labor from Elbonia? On 11/25/2003 12:49:31 PM, Bellow, Bambi wrote: Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the beginning of a bring the tech jobs back trend. This may imply that we are [temporarily] moving away from a globalized technical labor force (and therefore global wage equilibrium). Of course, it could mean nothing beyond what it says. Time will tell. In the meantime, here's the link. Enjoy! Bambi. http://www.cnn.com/2003/TECH/biztech/11/24/dell.call.centers.ap/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: UNIX OT: exclude files in tar
On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: Maybe can use -prune option of find to send file list to tar: Why do it in a simple way when there is an opportunity to (ab)use perl? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Valid Packages/Procedures/Triggers that are NOT
We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401
ora 8176
Hi all. Two users have received ora-8176 error while running their reports today. These reports have been accessing the tables against which an alter table exchange partition command was performed possibly while the reports were being executed. Based on what I read about the 8176 error on metalink, I think this could be the explanation. Does that make sense? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Olga Gurevich 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: Active Directory and ORACLE passwords
David - I hope you get some good replies. I asked about this awhile back and there didn't seem to be any sites getting MSAD and Oracle LDAP working. Part of the problem is that the world's #1 and #2 software companies don't talk much. I think your first obstacle is finding out the LDAP information and format that Oracle is expecting (I think this is an LDIF). One idea would be to install Oracle LDAP as a test and see if you can export the LDIF and import it into MSAD. Then the next obstacle is how to keep the information maintained in MSAD. Of course you will have to change the Oracle client to point to MSAD, but that seems well documented. For the Oracle connection information (what is in tnsnames.ora), one possibility I saw was to configure Oracle cman, which is pretty trivial. Cman has the capability to import a tnsnames.ora file. It also has the capability to export an LDIF. So in theory you could import your tnsnames.ora file into cman and export an LDIF which you could import into MSAD. Again, I sincerely somebody that has actually tried this will reply. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 25, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the password would be valid and then pass off to the ORACLE database that password. Any information would help. Thanks in advance David -- 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).
8i to 9i import
List, Has anybody seen this behavior or know the work around. I am doing a full import into a 9i (9.2.0.1.0) database from an Oracle 8i (8.1.7.4.0) database. The users are not pre-created and anytime it wants to import a user who owns objects it fails and gives: . importing USER's objects into USER ALTER SESSION SET CURRENT_SCHEMA= USER IMP-3: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-0: Import terminated unsuccessfully If you stop, manually create the user and assign a default tablespace the import will work until it hits another user who owns objects. I have seen notes on metalink that it might be the user and/or tablespace assignment. Is there a solution for this, besides pre-creating the users in the 9i instance? One note on metalink stated: You will encounter this when using a pre-9.2 dmp file into a 9.2 database. The following should work. 1) import with show=Y log= 2) edit that script and change the tablespaces to an existing tablespace for the create statements 3) pre-create the objects using the above script 4) import with ignore = Y Are you forced to pre-create the users when going from pre-9.2 into 9.2? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Beginning of a global unravelling?
if you work for a PHB, then yes. We will miss you Mladen ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, November 25, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Does that mean that we will not have to replace ourselves with the cheap labor from Elbonia? ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: Valid Packages/Procedures/Triggers that are NOT
db will _try_ to recompile any code that is encountered after it gets marked as invalid. So, it may not be a bug after all. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 25, 2003 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: Valid Packages/Procedures/Triggers that are NOTWe had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki PierceDatabase Administrationx2401**This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: IOUG 2004
Good points, Tanel. More to the point, forget about formulating a backup strategy. Focus on a recovery strategy. RE: RE: Development vs. Production DBAIf I was doing a introductory administration session, I'd emphasize the right way of thinking the most. That is 1) Always make sure that you know what you're doing and what are the potential consequences of your doings 2) Do not do extensive maintenance tasks during peak hours (yes, for some people it is no problem to take down the database server during the most active usage period) 3) Every security hole will be used eventually 4) A backup strategy is only as good as it's corresponding recovery strategy :) Btw, I'll be presenting 1-2 sessions there too, so see you there. Tanel. - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 25, 2003 3:19 PM Subject: IOUG 2004 I was informed last night that they accepted my seminar proposal, I will be doing an introductory session on how to administer Oracle databases. Hope to see many of you in Toronto next April. In the meantime if there are questions you would like me to cover, send them on -- I will only have an hour but the more relevant the presentation can be, the better. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Valid Packages/Procedures/Triggers that are NOT
We have been seeing this ever since we went to 9i and in multiple calls to Oracle support they have not been of much help. Most of the time we get an error dump in udumo and things go on there merry way. A couple of times the packages go invalid and wont work but when looking at them thru OEM or other ways they all appear to be vaild. We do a complete recompile of everything and we are back up and running. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, November 25, 2003 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: Valid Packages/Procedures/Triggers that are NOTWe had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki PierceDatabase Administrationx2401
Re: Valid Packages/Procedures/Triggers that are NOT
Hi Victoria Are you sure that nobody alter some table or view include in these pkgs ??. Mariano Database Administrator. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Valid Packages/Procedures/Triggers that are NOT Date: Tue, 25 Nov 2003 11:34:29 -0800 We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401 _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mar666 mar666 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: 8i to 9i import
I just did one of those this weekend (from 8.1.6 to 9.2.0.1). I created an empty 9i database with all the tablespaces before starting the import. The full=y errored out , but it did create the users before it died. I had to go back and do schema imports for each user. Vicki Pierce Database Administration x2401 Ehresmann, David [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2003 02:54 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject 8i to 9i import List, Has anybody seen this behavior or know the work around. I am doing a full import into a 9i (9.2.0.1.0) database from an Oracle 8i (8.1.7.4.0) database. The users are not pre-created and anytime it wants to import a user who owns objects it fails and gives: . importing USER's objects into USER ALTER SESSION SET CURRENT_SCHEMA= USER IMP-3: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-0: Import terminated unsuccessfully If you stop, manually create the user and assign a default tablespace the import will work until it hits another user who owns objects. I have seen notes on metalink that it might be the user and/or tablespace assignment. Is there a solution for this, besides pre-creating the users in the 9i instance? One note on metalink stated: You will encounter this when using a pre-9.2 dmp file into a 9.2 database. The following should work. 1) import with show=Y log= 2) edit that script and change the tablespaces to an existing tablespace for the create statements 3) pre-create the objects using the above script 4) import with ignore = Y Are you forced to pre-create the users when going from pre-9.2 into 9.2? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Valid Packages/Procedures/Triggers that are NOT
Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are quie a few others, not listed here. There was probably a SYS-owned object left invalid during upgrade, which caused dependency problems. Solution is to upgrade to 9.2.0.4 now that you've already upgraded to 9.2.0.1 and run $ORALCE_HOME/rdbms/utlirp to recompile all invalid objects in the database. It's always advised to so after any upgrade or patching of the database. On 11/25/2003 02:34:29 PM, [EMAIL PROTECTED] wrote: We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: insert in batch loading
What does it mean that redo log size dominates checkpoint frequency? It brings to mind cases of Edmund Blackadder and Baldrick or Ace Rimmer and Lister Kryten, both very clear cases of domination. I'm sure that J. Lewis, as a Britt, can tell you more about Black Adder and Red Dwarf, despite the fact that he missed those two subjects in his book. Redo logs of 100M are not really large. You, basically, have two choices: a) Increase redo logs to decent size (500M) b) Disable indexes during load. The third choice (out of two) would be to use _disable_logging parameter, recently mentioned by Mr. Anjo Kolk. Now, that would be practical, don't you think? On 11/25/2003 11:59:26 AM, David Boyd wrote: Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo log size (100 MB) dominates the checkpoint frequency. The table has two indexes. We don't set them to unusable during inserting. David From: Jan Korecki [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 08:19:26 -0800 David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx Hi! If you do incremental commits the batch will run slower or not at all (ora -01555). Have you checked how much redo your insert statement generates? You might have missed something. If you have indexes on the table you will have to set them unusable and alter session set skip_unusable_indexes=true Rebuild the indexes after the load with nologging. Janne! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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). _ online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL
ows, oas, ias product names
Oracle has gone back to Oracle Application Server as the name for iAS, it seems. Oracle Web Server 3.0.1.1 (1998 says the manual) Oracle (Web) Application Server 4.0 (? 1999 ?) Oracle Application Server 4.0.8.2 (May 2000 for Windows) Oracle Internet Application Server 8i 1.0.1 (August 2000 for Windows) (ref. http://otn.oracle.com/documentation/ias_arch_8i.html ) 9iAS 1.0.2 (October for unix/linux, November 2000 for windows) (concurrent with Oracle 8i database releases) iAS 9.0.2 (May 2002) (concurrent with Oracle 9i releases) Oracle Appliation Server 10g (2003) They skipped the OWS name, if their intention was to go around in circles. I had never heard of iAS 8i, you learn something every day. It seems to have only lasted a couple of months (?). Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: insert in batch loading
What I meant is that checkpoint occurs only when redo log switches. We set log_checkpoint_interval = 21 and our OS block size is 512. If I increase the size of redo log to 500 MB, checkpoint will occur before log switching. Will the transaction wait until checkpoint complete during checkpoint? Thanks for your inputs. David From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 12:49:28 -0800 What does it mean that redo log size dominates checkpoint frequency? It brings to mind cases of Edmund Blackadder and Baldrick or Ace Rimmer and Lister Kryten, both very clear cases of domination. I'm sure that J. Lewis, as a Britt, can tell you more about Black Adder and Red Dwarf, despite the fact that he missed those two subjects in his book. Redo logs of 100M are not really large. You, basically, have two choices: a) Increase redo logs to decent size (500M) b) Disable indexes during load. The third choice (out of two) would be to use _disable_logging parameter, recently mentioned by Mr. Anjo Kolk. Now, that would be practical, don't you think? On 11/25/2003 11:59:26 AM, David Boyd wrote: Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo log size (100 MB) dominates the checkpoint frequency. The table has two indexes. We don't set them to unusable during inserting. David From: Jan Korecki [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 08:19:26 -0800 David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx Hi! If you do incremental commits the batch will run slower or not at all (ora -01555). Have you checked how much redo your insert statement generates? You might have missed something. If you have indexes on the table you will have to set them unusable and alter session set skip_unusable_indexes=true Rebuild the indexes after the load with nologging. Janne! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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). _ online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose,
analyze after truncate
Hello All, We have a huge table both is terms of number of columns and rows. It is list partitioned. it has 7 mill rows and its avg row length is 600 bytes. One of the developers has come up with a method of truncating and reloading the table on a daily basis thorough sqlloader. everyday there are about 50,000 rows insert and 100,000 rows update. My question is do i need to reanalyze this table on a daily basis. Even though we truncate the table the statistics still stays on with the table and since the table goes thorugh only minimal change, is it advisable to analyze it on a daily basis or can i analyze it on a weekly basis. Please advice.. Thanks, Sat. -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [***SPAM***] - Re: Valid Packages/Procedures/Triggers that are NOT - Found word(s) to be removed remove home list error e-mail in the Text body.
The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in the database, nothing happening except the normal day-to-day operation of the system. We have seen this happening since 8i. We recently upgraded to 92040 and I have seen it once in the last week where it produced a dump - I dont know how many times it happened where no dump was produced. In 92021 we could see it multiple times in a day. There is a problem out there that Oracle can't seem to recreate. -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 1:44 PM To: Multiple recipients of list ORACLE-L NOT - Found word(s) to be removed remove home list error e-mail in the Text body. Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are quie a few others, not listed here. There was probably a SYS-owned object left invalid during upgrade, which caused dependency problems. Solution is to upgrade to 9.2.0.4 now that you've already upgraded to 9.2.0.1 and run $ORALCE_HOME/rdbms/utlirp to recompile all invalid objects in the database. It's always advised to so after any upgrade or patching of the database. On 11/25/2003 02:34:29 PM, [EMAIL PROTECTED] wrote: We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tony Johnson 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: insert in batch loading
Hi! I suggest you set up a test where you check the redo. For example: - start test SQL select LOG_MODE from v$database; LOG_MODE ARCHIVELOG SQL create table append_test as select * from all_objects where 1=2; Table created. SQL create index append_test_ind on append_test(owner); Index created. SQL alter table append_test nologging; Table altered. SQL alter index append_test_ind nologging; Index altered. SQL analyze table append_test compute statistics for table for all indexes for all indexed columns; Table analyzed. SQL set serveroutput on size 10 SQL set autotrace on STATISTICS SQL insert /*+ append */ into append_test select * from [EMAIL PROTECTED]; 35605 rows created. Statistics -- 1213732 redo size 35605 rows processed SQL rollback; Rollback complete. SQL alter index append_test_ind unusable; Index altered. SQL alter session set skip_unusable_indexes=TRUE; Session altered. SQL insert /*+ append */ into append_test select * from [EMAIL PROTECTED]; 35605 rows created. Statistics -- 1172 redo size 35605 rows processed end test This works well with a non-unique index. If the index is unique or you have primary key/unique constraint you will run into problem because you cannot use +append with a unusable unique index. You have 2 choices. 1) have the constraints set to deferreble and disble them before load, set the unique index to unusable, load, rebuild index nologging, enable constraints 2) if you dont want to have the constraints deferrable- drop indexed before load and create them afterwards with nologging. Even if you do 2) you will save a lot of time and have a lot less redo. Regards, Janne! David Boyd wrote: Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo log size (100 MB) dominates the checkpoint frequency. The table has two indexes. We don't set them to unusable during inserting. David From: Jan Korecki [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 08:19:26 -0800 David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes are in nologging mode. We have /*+append*/ hint in the insert statement. We have 5 redo groups with member of 100 MB. Some tables have more than 1 million records. I was wondering if any body knows a method that forces a commit after every 1000 records inserted, which is like delete_commit procedure. David _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx Hi! If you do incremental commits the batch will run slower or not at all (ora -01555). Have you checked how much redo your insert statement generates? You might have missed something. If you have indexes on the table you will have to set them unusable and alter session set skip_unusable_indexes=true Rebuild the indexes after the load with nologging. Janne! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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). _ online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Korecki 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
RE: Move datafiles, but can't delete them
When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=279331.996. From the note below, you should exit your tool (eg SQLPLus) and then wait a bit. Also see note 222033.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=222033.1 which says: fact: Oracle Server - Enterprise Edition 8.1.5 fact: MS Windows NT symptom: Unable to delete datafile from OS after drop tablespace symptom: Cannot delete %s: There has been a sharing violation symptom: Error deleting OS file cause: Bug:480928 OPEN HANDLE TO OFFLINE DATAFILES Fixed in ver. 8.1.6 and higher. fix: After issuing a DROP TABLESPACE command the corresponding datafile is still locked on OS level and not possible to remove. Workaround: Disconnect from the session and exit the tool (Server Manager or SQL*Plus) you were running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 26 November 2003 1:49 AM To: Multiple recipients of list ORACLE-L In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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: Valid Packages/Procedures/Triggers that are NOT ...
Have you tried checking dba_dependencies for the objects that go invalid? You may see a pattern. Jared On Tue, 2003-11-25 at 13:34, Tony Johnson wrote: The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in the database, nothing happening except the normal day-to-day operation of the system. We have seen this happening since 8i. We recently upgraded to 92040 and I have seen it once in the last week where it produced a dump - I dont know how many times it happened where no dump was produced. In 92021 we could see it multiple times in a day. There is a problem out there that Oracle can't seem to recreate. -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 1:44 PM To: Multiple recipients of list ORACLE-L NOT - Found word(s) to be removed remove home list error e-mail in the Text body. Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are quie a few others, not listed here. There was probably a SYS-owned object left invalid during upgrade, which caused dependency problems. Solution is to upgrade to 9.2.0.4 now that you've already upgraded to 9.2.0.1 and run $ORALCE_HOME/rdbms/utlirp to recompile all invalid objects in the database. It's always advised to so after any upgrade or patching of the database. On 11/25/2003 02:34:29 PM, [EMAIL PROTECTED] wrote: We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tony Johnson 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: Move datafiles, but can't delete them
Bruce, Thank you, the problem is not when I dropped the tablespace but want I moved datafiles. I will bounce the database. Luc -Original Message- [mailto:[EMAIL PROTECTED] Sent: November 25, 2003 5:02 PM To: Multiple recipients of list ORACLE-L When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=279331.996. From the note below, you should exit your tool (eg SQLPLus) and then wait a bit. Also see note 222033.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=222033.1 which says: fact: Oracle Server - Enterprise Edition 8.1.5 fact: MS Windows NT symptom: Unable to delete datafile from OS after drop tablespace symptom: Cannot delete %s: There has been a sharing violation symptom: Error deleting OS file cause: Bug:480928 OPEN HANDLE TO OFFLINE DATAFILES Fixed in ver. 8.1.6 and higher. fix: After issuing a DROP TABLESPACE command the corresponding datafile is still locked on OS level and not possible to remove. Workaround: Disconnect from the session and exit the tool (Server Manager or SQL*Plus) you were running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 26 November 2003 1:49 AM To: Multiple recipients of list ORACLE-L In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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). application/ms-tnef
Re: analyze after truncate
Presumably, after you truncate the huge table, it's no longer a huge table. DBMS_STATS will run much faster after you truncate the table. You've just discovered a great optimization. That's exactly what I've been saying for a long time: my database would work extremely fast, if there weren't any users or data. Now read the BOFH manual to learn how to deal with users and you are done with tuning. On 11/25/2003 04:34:43 PM, [EMAIL PROTECTED] wrote: Hello All, We have a huge table both is terms of number of columns and rows. It is list partitioned. it has 7 mill rows and its avg row length is 600 bytes. One of the developers has come up with a method of truncating and reloading the table on a daily basis thorough sqlloader. everyday there are about 50,000 rows insert and 100,000 rows update. My question is do i need to reanalyze this table on a daily basis. Even though we truncate the table the statistics still stays on with the table and since the table goes thorugh only minimal change, is it advisable to analyze it on a daily basis or can i analyze it on a weekly basis. Please advice.. Thanks, Sat. -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - XCTEND rlbk=1, rd_only=1
Thanks, Jared, Tanel. I was a little supprised to see a combination rlbk=1,rd_only=1. Why read-only bit is set here if it rolls back anyway? So I thought may be they mark their tx explicitly as read-only (aka set transaction read-only). Reveiwing OCI fine manual there seemed to be an option of doing just that with the OCITransStart() call and setting some flags... But than simple test-case of tracing commit and rollback in SQL*Plus disproved the theory about read-only tx, as normal commit/rollback produce this combination regardless of the tx type: commit - XCTEND rlbk=0, rd_only=1 rollback - XCTEND rlbk=1, rd_only=1 set transaction read only commit - XCTEND rlbk=0, rd_only=1 rollback - XCTEND rlbk=1, rd_only=1 So much for my theory :-( Another question I had here is whether or not having so many (implicit?) rollbacks on about every SELECT statement all over my trace file bears any overhead and proves deficiency of a stateless architecture used by this application - but again reviewing v$sesstat before and after I see user rollbacks count incremented, but no additional redo vectors generated. I guess I can try Tom Kyte's test harness, but it just doesn't sit well with me that 30 selects are as cheap as 30 selects with 30 rollbacks. Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: analyze after truncate
You are truncating a table so as to add another 0.7% of its size in inserts, and to update 1.4% of the rows? My first thought would be to stop doing that. Modify the extent sizes (if needed) so that your 50k rows fairly fill up the extents allocated on the insert ( so as to avoid wasting space needlessly ) and use insert..append. Updating 100k row should not be too painful. Truncating the table for this process seems rather extreme. Re the analyze for your current situation, you could always use stored outlines between periods that you wish to run the analyze command. You would of course need to test this first in a non-production environment. Jared On Tue, 2003-11-25 at 13:34, [EMAIL PROTECTED] wrote: Hello All, We have a huge table both is terms of number of columns and rows. It is list partitioned. it has 7 mill rows and its avg row length is 600 bytes. One of the developers has come up with a method of truncating and reloading the table on a daily basis thorough sqlloader. everyday there are about 50,000 rows insert and 100,000 rows update. My question is do i need to reanalyze this table on a daily basis. Even though we truncate the table the statistics still stays on with the table and since the table goes thorugh only minimal change, is it advisable to analyze it on a daily basis or can i analyze it on a weekly basis. Please advice.. Thanks, Sat. -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Script
Hi Ramon, I guess you are on 8i : your setsize and fileperset specs should be inside the backup command not outside i.e. something like this : backup fileperset 2 setsize 2000 database
Re: sql trace - XCTEND rlbk=1, rd_only=1
Using a slightly modified version of run_stats to return timings in 1/1 of a second, the timing of 1000 iterations of a loop executing noop vs. 1000 doing rollback: .0005 secs .0354 secs Here are the stats that were different between the two, kind of what you would expect: LATCH.cache buffers chains 11313320 STAT...redo size 27160 27648 488 STAT...user rollbacks 0 1000 1000 LATCH.enqueues0 1001 1001 LATCH.shared pool 3 1004 1001 LATCH.session idle bit0 1001 1001 STAT...execute count 3 1004 1001 LATCH.library cache pin 13 2014 2001 LATCH.session allocation 0 2002 2002 STAT...recursive calls4 2008 2004 LATCH.library cache 14 3018 3004 On Tue, 2003-11-25 at 14:14, Boris Dali wrote: Thanks, Jared, Tanel. I was a little supprised to see a combination rlbk=1,rd_only=1. Why read-only bit is set here if it rolls back anyway? So I thought may be they mark their tx explicitly as read-only (aka set transaction read-only). Reveiwing OCI fine manual there seemed to be an option of doing just that with the OCITransStart() call and setting some flags... But than simple test-case of tracing commit and rollback in SQL*Plus disproved the theory about read-only tx, as normal commit/rollback produce this combination regardless of the tx type: commit - XCTEND rlbk=0, rd_only=1 rollback - XCTEND rlbk=1, rd_only=1 set transaction read only commit - XCTEND rlbk=0, rd_only=1 rollback - XCTEND rlbk=1, rd_only=1 So much for my theory :-( Another question I had here is whether or not having so many (implicit?) rollbacks on about every SELECT statement all over my trace file bears any overhead and proves deficiency of a stateless architecture used by this application - but again reviewing v$sesstat before and after I see user rollbacks count incremented, but no additional redo vectors generated. I guess I can try Tom Kyte's test harness, but it just doesn't sit well with me that 30 selects are as cheap as 30 selects with 30 rollbacks. Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX OT: exclude files in tar
I like that logic! I might just start (ab)using Perl now. Thanks to all replies. Now I've got a few options to play around with to do this 'exclude files' and not necessarily tar . Rgds, Ross -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 November 2003 6:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: UNIX OT: exclude files in tar On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: Maybe can use -prune option of find to send file list to tar: Why do it in a simple way when there is an opportunity to (ab)use perl? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ross Collado 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).
test
Yahoo! Personals - New people, new possibilities. FREE for a limited time!
Re: AW: Experiences with Oracle and MS .Net data providers
Several of the Miracle guys are getting ready to be certified in SQL Server. They have a ball with the 1000-page books, which talk about alternative operating systems - meaning Windows 95, Windows X, Windows y, :;-) Stefan Jahnke wrote: Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's Hailstorm - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or maybe I have to keep playing with MONO. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are compatible and standards, which are used much in the same way as the phrase zum Donnerwetter is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?KOI8-R?Q?Mogens_N=3Frgaard?= 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: what is oracle rdb?
As the AWE (Award-Winning Educator) of the year, I have a huge responsibility placed on my shoulders: I have to answer questions regarding Rdb truthfully. So here we go... Back in the year 1994, Digital very discreetly asked their three biggest customers (including Lego) what they thought of the idea of Digital selling Rdb and other stuff to Oracle. This was before Oracle was asked, mind you. At the time, Lego had 700+ Rdb databases running. The three big ones answered back that if Oracle was the safe bet for securing their product for the next five to ten years, then fine. Then Digital went to Oracle and sold the stuff for at cheap price. I remember the Digital CEO asking the Oracle folks kindly to please treat their old, beloved customers nicely. It was - Goddamn it! - actually a quite touching moment, if you had any ideas back then about the level of integrity and support in the Digital community. That's how I came to deliver the first-ever course at Lego in their HQ in Denmark (in a town called Billund, but certainly not named after The Bill). Why did I deliver an Oracle course there, when they had Rdb already (and working like a charm, mind you)? Because all of the Rdb customers concluded this: We'll run all our old systems on Rdb for many years to come, but we'll base all our new systems on Oracle. Oracle has done the right things about Rdb again and again and again after taking over the shop from Digital. They kept the bearded, bitter, old, twisted, spec-writing folks of the New England Development team. They let them get on with what they did best: Write new features for Rdb. They borrowed good ideas from them and fed it into Oracle. They let them use good Oracle ideas in Rdb. I have never, ever, seen any take-over work so well in the IT industry. Ask the Rdb customers (Lego, Novo, etc.) and they will tell you they still trust Oracle and Rdb. Incredibly well done. Respect. Oh, and many years later my guys in Premium Services were among the first five people to know about Lego's desire to change from SAP to Apps. Those were the days: We had so much Lego Mindstorm stuff (for the very cheap company price) available we didn't know what to do. Of course the whole thing failed, and they went back to SAP, but the guys still talk about the Lego sets... but not about the project itself. I think that Lego today is moving as fast as possible towards SQL Server and a general Windows strategy. These days, you don't get fired from choosing Microsoft. Jesse - was this what you wished for, or did it suck? Mogens Jesse, Rich wrote: Where's our Award-Winning Educator and former Lego DBA, Mogens? If there is one dream job for me, it would be an Oracle DBA at Lego. And I was upset to find that someone took my legoman username from my ISP at home. :( Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, November 25, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: BPJ I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. Heh, I just spent the better part of my Sunday afternoon buying compartmentized boxes and helping my son sort all his legos. When I was a kid, back when the dinasaurs roamed, I had perhaps a dozen distinct Lego shapes to worry about. Now there are so many that I'm sometimes at a loss as to how to categorize and sort them. The worst is when my son pulls out instructions for some Lego toy he bought a year ago, points to his bin with a full Gigablock of Legosgrin, and wants me to help him put together whatever it is. Hence, I've decided to help him sort things out a bit. He might even have a Terablock, I'm afraid to count. Best regards, Jonathan Gennick --- Brighten the corner where you are -- Please see the official ORACLE-L FAQ: 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 San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - recursive relationships
Thanks for your reply, Daniel. Yes, it makes sense for the EXEC calls, but it doesn't explain the PARSEs, does it? PARSING IN CURSOR #1 len=94 dep=0... PARSE #1:c=0,e=141,p=0,cr=0,cu=0,mis=0,r=0,dep=0... PARSING IN CURSOR #2 len=68 dep=1... PARSE #2:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=1... Here I presume elapsed time of the PL/SQL call is 141-60=81 microsec, but it doesn't follow the same rule of parent db call following the recursive/child one - it is out of sequence. It is even more interesting with FETCHes. I can't seem to find FETCH call for the parent anywhere in the trace file. Maybe it makes sense to omit this call altogether as time tallied against PL/SQL proc call goes to EXEC anyway, but than again it breaks the rule. And no, I don't think it is a trace activation/data collection error as these parent-child cursors appear in the middle of the trace. Thanks again, Boris Dali. --- Daniel Fink [EMAIL PROTECTED] wrote: Boris, Cary is correct. It gets a little confusing, especially with pl/sql involved. It also helps to remember to differentiate between database calls (parse/execute/fetch) and other events (wait/stat). Using your example below, I'll attempt an explanation inline. Daniel Fink Boris Dali wrote: Reading Cary's Optimizing Oracle Performance, page 91 it says: A database call with dep=n+1 is the recursive child of the first SUBSEQUENT (empasis mine) dep=n database call listed in the SQL trace data stream Does this apply to the SQL issued from PL/SQL? I am looking at the simple packaged stored proc: PACKAGE BODY nav_tree_pkg is PROCEDURE GET_NAV_PARENT_NODE_ID ( p_NodeId IN NUMBER, p_ParentNodeId OUT NUMBER) IS BEGIN SELECT PARENT_NAV_NODE_ID INTO p_ParentNodeId FROM NAV_NODE WHERE NAV_NODE_ID = p_NodeId; EXCEPTION WHEN NO_DATA_FOUND THEN p_ParentNodeId := -1 ; END; -- Procedure END; ... and here's what I see in the trace (sorry the lines are probably wrapped): = PARSING IN CURSOR #1 len=94 dep=0 uid=83 oct=47 lid=83 tim=1617285502494 hv=1138148843 ad='605d0998' BEGIN nav_tree_pkg.get_nav_parent_node_id( :p_nodeid, :p_parentnodeid ); END; END OF STMT PARSE #1:c=0,e=141,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1617285502483 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=48 offset=0 bfp=83fbc005ff80 bln=22 avl=01 flg=05 value=0 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=24 bfp=83fbc005ff98 bln=22 avl=00 flg=01 = Here, the pl/sql block is parsed. The next step in the statement process is to execute the statement (parse/execute/fetch). However, notice that EXEC #1 is not the next database call. PARSING IN CURSOR #2 len=68 dep=1 uid=98 oct=3 lid=98 tim=1617285503241 hv=1778717541 ad='606795e8' SELECT PARENT_NAV_NODE_ID FROM NAV_NODE WHERE NAV_NODE_ID = :b1 END OF STMT PARSE #2:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1617285503230 BINDS #2: bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=4001 size=24 offset=0 bfp=83fbc005f660 bln=22 avl=01 flg=05 value=0 Okay, here we parse the sql statement inside the block. In the next couple of db calls, we do the execute/fetch of Cursor #2. EXEC #2:c=0,e=151,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1617285503563 FETCH #2:c=0,e=40,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1617285503648 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 EXEC #1:c=0,e=1037,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=4,tim=1617285503786 Here is the execute database call for the block. It is the execution of the block that motivates the parse/execute/fetch of the inner statement. WAIT #1: nam='SQL*Net message from client' ela= 2470 p1=1413697536 p2=1 p3=0 = ... Totaly different calls = So here it looks like the child CURSOR #2 with dep=1 is emitted AFTER the parent (CURSOR #1, dep=0) Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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).
how to send messages to other users
hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to send messages to other users
BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in advance and put the maintenance times on your internal web page. The chosen times should be offpeak so that the normal business can continue. When you inform everybody and schedule downtime in advance, then you simply shut the database down, say, on Saturday, 18:00 hours. In other words, your problem is organizational, not technical. If you need to shut the database down immediately for whatever reason there is a gadget called a telephone. It works like this: every company has a person called CIO (stands for Career Is Over). When you need to shut down a database that is critical for business during the working hours then you tell your boss to call the CIO, and if he's not around, you tell your boss/director to page him (they usually cary beepers). He will then either inform his peers in the business process or schedule a conference call to pass the good news to the business. You are probably going to be on that conference call so better be prepared to argue why is shutting down the database critical or you will be in a very bad predicament. After that, no further information is necessary. You just do what needs to be done. In other words, shutting down an important database is not a DBA decision but a decision made by people who manage the normal business process. Those people are sometimes referred to as management. They are the ones who make decisions and define schedule. On 2003.11.25 20:49, [EMAIL PROTECTED] wrote: hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Linking to a SQL Server
Hi All, Has any of you had an exprience in accessing SQL Server data from Oracle database. I am woking on Oracle 9i on RH Linux 9. Does it work?? If so can you please list the steps that I need to try to do the same. Also wanted to clarify if generic connectivity is supported on Linux. Oracle documentation seems to have only examples on Unix and NT. Thanks ShivaM DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, save, disclose, distribute, copy, print or relay this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shiva Maran 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).