RE: last column in a table is added with a DEFAULT
Title: RE: last column in a table is added with a DEFAULT David, The best way to see if this works is to create a test table. populate it with some data. Add a column with a default value. and observer what happens. best way to learn. Tom Mercadante Oracle Certified Professional -Original Message-From: Ehresmann, David [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 3:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: last column in a table is added with a DEFAULT I understand that part. What the programmer is saying that you can not add the last column to a table with a default value. Does that sound reasonable? thanks, Raj. David. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: last column in a table is added with a DEFAULT as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value. 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: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some packages to go invalid. "The error seems to be related to a bug in oracle caused when the last column in a table is added with a default." 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: Implementing different document types with different attributes
What do you have as an example of an attribute? Vernaillen Tim tim.vernaillen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @xgs.be cc: Sent by: Subject: Implementing different document types with different attributes ml-errors 08/07/2003 09:34 AM Please respond to ORACLE-L Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, because more than the half (35) of the attributes are not always used for each document type. This will have to much disk space for each record, if most of the fields are just blank. Has anyone suggestions how to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 100 instances on same server !!!
Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I dont have solid answer. Just on side note, canI ask, What is the maximum number of instances anyone has ever worked/heard being installedwith in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended for Data Modeling ? 100 instances woh . If you are in 9i look at possibilities like contextor label security . or creating another schema .-ak- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 9:24 PM I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundredtrainees at a time. For this he wants to install hundred database instances onsame server machine, which *each* will be accessed simultaneously from 100different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each roundof training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardwareneeded for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AK INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: More On 10G
Heard an Oracle rep last week say that 10G was mostly hype. If you want to watch what's for real at Oracle it's Linux. Only time will tell if he is right, but he has a better inside track to the Oracle gossip that I do. --- [EMAIL PROTECTED] wrote: Could someone reach over and turn the Grid hype knob up to 11 for me, oops, sorry, already there. Sure smells like an IBM SP2 environment to mesomeone light a match or open a windowplease Jay Wade [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: More On 10G [EMAIL PROTECTED] .com 08/04/2003 10:24 AM Please respond to ORACLE-L Came across this article thought the group might be interested. Any ideas on a release date for 10G, I know they are going to unveil it at OpenWorld, any quess on the release date? http://www.eweek.com/article2/0,3959,1209597,00.asp _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
How do I create a temp table with no logging?
Hello, I am trying to make a temp table with no logging as select * from table. Does anyone have a good example? THanks a ton! Jake __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake 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: last column in a table is added with a DEFAULT
I know, with earlier version of Oracle, columns likely to have null values were placed at the end of the table, to save on some minuscle bytes of space. If the null columns fall between columns with data values, then one byte is used for their storage. Else, they require no storage. But no, there is no bug related to the last column having a default value. Raj Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: last column in a table is added with a DEFAULT Sent by: [EMAIL PROTECTED] y.com 08/07/2003 03:19 PM Please respond to ORACLE-L David, Nope. Your programmer is wrong. Tom Mercadante Oracle Certified Professional -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: last column in a table is added with a DEFAULT I understand that part. What the programmer is saying that you can not add the last column to a table with a default value. Does that sound reasonable? thanks, Raj. David. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: last column in a table is added with a DEFAULT as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value. 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: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some packages to go invalid. The error seems to be related to a bug in oracle caused when the last column in a table is added with a default. David Ehresmann -- 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: Oracle Security Best Practices
if this is 9i, anyone with DBA privs can grant access... grant select, update, delete, insert on table_owner.table_name to grantee; we have a hosting company that manages the staging and production databases. I do not hard-code passwords into scripts when I pass them to the hosting company. They do not give me the password to SYSTEM. But I can and do code (at the beginning of every script): prompt please enter the passwords and connect string as [EMAIL PROTECTED] prompt accept sysconn prompt system password and connect string: set echo on term on verify off connect system/sysconn in my scripts and then do the grants and whatever else I need as system if you aren't on 9i... well option 1 below was documented (with a script so you don't have to write the encrypted password down!) in Kevin Loney's 7.3 version of the DBA Handbook. I don't know (latest versions are at home) if he kept it in the later versions of the book or not) --- Jose Luis Delgado [EMAIL PROTECTED] wrote: --- [EMAIL PROTECTED] wrote: We are having problems creating the objects and granting the access. We figured out that our problem is granting ... because the only one that can grant access to the object is the owner, correct? How do you (as DBA) create objects and give its permissions? With the owner's login? Sandro... you have at least two choices: 1.- a) select encrypted password from dba_users write it on your notebook. b) alter the user password to whatever you want. c) connect as the user d) perform the grant e) alter the password back to the original value using alter user xxx identified by values 'old_password' where old_password = the one that you wrote on the notebook 2.- create a procedure to do the grant... a) create or replace procedure whatever_user.grant(priv varchar2) is begin execute immediate priv; end; b) exec whatever_user.grant('grant select on emp to Sandro'); HTH JL __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- 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).
tivoli/oracle monitoring
is anyone using tivoli to do oracle monitoring, good/bad, etc. thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC interconnects
Title: RAC interconnects Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? 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 ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Multiple Datafiles and performance?
As for the datafiles and indexfiles being distributed over different physical disks, well I can not confirm you are wrong, in our site id DID boost the performance, and specially if you locate in separate physical drives your redologs and datafiles (both indexes or data). Of course it depends on the server's work load and how many people are simultaneously accesing data and indexes. I can understand what you say but if many different users are accesing the same table via indexes and both the table's data and the indexes are on the same physical drive I think performance should be worst than if they were separated, right or wrong? ... Wrong, because in multi-user environment, disk reading heads will never be physically be in same place where you left them. (Well, almost never, depending on your IO queue length). Are you comparing oranges with oranges here - if you got one disk in your server and get performance boost by buying another disk in and putting some files (doesn't matter which files) on new disk, then you are comparing 1 disk vs. 2 disks, and that doesn't have anything to do with the type of segments in the 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).
RE: possible Bug in Oracle 9.2.0.2
Title: Message I already have :) -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug in Oracle 9.2.0.2 Tell them ... 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: Browett, Darren [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug in Oracle 9.2.0.2 That fixed it, thank you. I still haven't heard from oracle support yet. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 4:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug in Oracle 9.2.0.2 You it is a bug alter session|system set "_unnest_subquery"=false / 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: Browett, Darren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 06, 2003 7:34 PM To: Multiple recipients of list ORACLE-L Subject: possible Bug in Oracle 9.2.0.2 While I am waiting for oracle support to respond to my tar update (2nd callback) I am just wondering if anybody has found this problem. We have the following select query (from a peoplesoft implementation) SELECT a.emplid, a.effdt FROM PS_JOB A WHERE A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A.EMPLID = A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A1.EFFDT = SYSDATE) AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD = A2.EMPL_RCD AND A.EFFDT = A2.EFFDT) AND A.EMPL_STATUS = 'A' and a.emplid='3442' when we run the query we get one row back, but when we replace the field names with count(*), the resulting answer back is "2". We have tested it in 8.0.5.1.1 and we get the correct results, 1 row, and a count of 1. Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Backup piece being placed in wrong directory
Title: Message Doh! Thanks for pointing out the obvious to me. I'm sure that will work. I'll go crawl back in my cave now :ol Thanks Tom! -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RMAN Backup piece being placed in wrong directory Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile
RE: Multiple Datafiles and performance?
The benefits of spreading the data over as many physical access paths ( ~ disks ) using multiple datafiles notwithstanding, there is always the case of too much. Keep in mind that at checkpoint time the DBWR need to visit the header of every ( non read-only ) datafile. That's unlikely to be an issue for a few dozen datafiles, but if you are getting into hundreds of them, keep that in mind. If you can get the striping done without multiple datafiles you get the best of both worlds. I am just suffering that exact issue on a test system for an upgrade with an extremely poor IO subsystem where bottlenecks like this get magnified. At 07:24 AM 8/7/2003 -0800, you wrote: Gee, that question sounded a whole lot better when I wrote it yesterday than it did this morning when I saw it. :) Maybe I should be a little more vague.:) The problem is there are a couple of things I am trying to accomplish. We have clients that use our application that have specific performance issues which I am working to improve. The other issue is to provide recommendation to development/tech staff on initial setup of database/tablespaces/datafiles etc.., along with hardware recommendations for our application. So, that being said, I'll try and ask better questions. The environment is W2K, Oracle 8.1.7.2 or higher All tablespaces are LMT Most disk config's are 1 (or 2) Raid 1 along with a Raid 5 for basic systems. Most operate application 24/7 Questions: 1) Is there any advantage to uniform datafile sizes? 2) Is there any advantage/disadvantage for say 4 1G datafiles vs 2 2G. (Other than time to recover from datafile loss) It is probably safe to assume that the datafiles exist on a RAID 5. (for now) 3) Why the recommendation to take a Win2k datafile to just over 2G? For future apps I am pushing for optimal recommendations that go for more raid 1 sets or raid 10 over the Raid 5. This should allow for more flexibility for spreading out the i/o. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Corrupt Inactive RedoLog Goup.
Sorry, I skipped mentioning that, but we did try it, for the members. Got an ORA-01514: error in log specification. No such log. ORA-01517: log member: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' When we used the group number, we got an: ORA-00261: log 3 of thread 1 is being archived or modified ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' Regards Raj Tanel Poder tanel.poder.00 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: Sent by: Subject: Re: Corrupt Inactive RedoLog Goup. [EMAIL PROTECTED] ty.com 08/08/2003 01:04 PM Please respond to ORACLE-L Hi! I think the command was alter database clear unarchived logfile 'xxx'; IIRC, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 08, 2003 7:54 PM Members, Production 8.1.6.3 database on Windows NT 4.0. We noticed an entry in the alert log, citing that a log group could not be archived since the 25th of July.. We have 3 log groups with 2 members each. I notice that the 3rd redolog group has a status of Inactive with Archived=No. This group has a sequence# of 745, while the other two have advanced to 1073 and 1074 now. We have had too many log switches since then, and Oracle has chosen to ignore using this corrupt redo log group. The database gets bounced daily, and opens without a problem, since this group is not needed for instance recovery. I tried manual archiving. SQLWKS alter system archive log group 3; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' SQLWKS alter system archive log logfile 'F: \ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' 2 ; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' SQLWKS alter system archive log logfile 'G: \ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' 2 3 ; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' Similarly, it does not allow me to drop this member, saying it has not been archived. Can I fake a recovery using cancel. and then open resetlogs? Or if I put the database in noarchivelog mode, will Oracle let me drop this corrupt redolog group? Thanks Raj -- Please see the official ORACLE-L FAQ:
Re: Implementing different document types with different attributes
Title: Implementing different document types with different attributes Hi! FlexFields are used in Oracle E-Business Suite, they aren't nothing else than varchar2 fields where you can configure Apps to write your custom data (either one logical field by database column, or several fields separated by colon). For your case, if you add 70 varchar2 or number columns to your table, these columns which have null values will take only 1 byte (for column length which will be 0). Also,if you have let say 20 last columns as NULL for particular row, then even this 1 byte for last 20 null columns is omitted (column count for row is decreased instead).But as soon as you got some non-null value in your last colum of row, then allcolumns have to be stored in row. You could add a column doctype (which you probably already have), use few attribute columns and use decode or some application side construct to translate appropriate columns to appropriate attribute values for current doctype. Let say I got doc types: doc mp3 zip For all types ATTR1 stores document size in bytes, but ATTR2 is word count for doc, duration in seconds for mp3 and uncompressed size for zip: And table contains: ID | DOCTYPE | ATTR1| ATTR2 | 1 | doc |154332|8850 | 2 | mp3 | 128000| 16 | 3 | zip |32768| 55980 | And query or application takes doctype into account: selectattr1 as bytes, decode(lower(doctype), 'doc', 'Word Count:', 'mp3', 'Minutes:', 'zip', 'Uncompressed size:', 'Unspecified') as custom, ATTR2 from my_table; Also, you can combine boolean values to number or varchar and use bitand function or substr function depending on data type. Also, function based indexes come handy whenyour wantto index these columns... Tanel. - Original Message - From: Vernaillen Tim To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 4:34 PM Subject: Implementing different document types with different attributes Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, because more than the half (35) of the attributes are not always used for each document type. This will have to much disk space for each record, if most of the fields are just blank. Has anyone suggestions how to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim
Re: Oracle and Windows 2000 SP4 - any experiences to share
Hi! Just stop and disable the service Automatic Updates under Control Panel - Adiministrative Tools - Services. Also, a service called Background Intelligent Transfer Service appeared, which is able to transfer files in *background* i.e. without you knowing about it, for automatic update and some mystic MSN Explorer. WTF :| Stop and disable that one as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 08, 2003 7:39 PM I'm sure many of us would love to know how to disable that thing. I know I would. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2003 04:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle and Windows 2000 SP4 - any experiences to share Hi! Btw, after installing SP4, a service Automatic Updates has appeared and is active by default (without even asking from me!). I just figured it out disabled it instantly. I have W2k professional. Could you verify, whether you also do have this service installed automatic or is it just me? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:34 PM FWIW, I installed it on my P4 at work and it's caused no problems yet. 8.1.7.4 as well. But in my Athlon XP at home, it's made the system so unstable I had to upgrade all sorts of drivers! There you go, 6 of 1... Hi! I've used SP4 on Athlon XP for a week now (with Oracle 9.2.0.1). So far have seen no problems.. 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). -- 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). -- 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: 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: Multiple Datafiles and performance?
Gee, that question sounded a whole lot better when I wrote it yesterday than it did this morning when I saw it. :) Maybe I should be a little more vague.:) The problem is there are a couple of things I am trying to accomplish. We have clients that use our application that have specific performance issues which I am working to improve. The other issue is to provide recommendation to development/tech staff on initial setup of database/tablespaces/datafiles etc.., along with hardware recommendations for our application. So, that being said, I'll try and ask better questions. The environment is W2K, Oracle 8.1.7.2 or higher All tablespaces are LMT Most disk config's are 1 (or 2) Raid 1 along with a Raid 5 for basic systems. Most operate application 24/7 Questions: 1) Is there any advantage to uniform datafile sizes? 2) Is there any advantage/disadvantage for say 4 1G datafiles vs 2 2G. (Other than time to recover from datafile loss) It is probably safe to assume that the datafiles exist on a RAID 5. (for now) 3) Why the recommendation to take a Win2k datafile to just over 2G? For future apps I am pushing for optimal recommendations that go for more raid 1 sets or raid 10 over the Raid 5. This should allow for more flexibility for spreading out the i/o. Thanks for your patience and all the help. David Phillips Support DBA BAARF Member #30 -Original Message- Sent: Thursday, August 07, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Win2K. If you decide to increase the filesize, do it to more than 2G (doesn't have to be by much). Of course, you didn't mention autoextend so this may not be an issue. Also, just how many physical disks do you have? Logical disks are not the issue. If you're going to get any increased performance you should be putting the second datafile on a second physical disk. Any how come you're not using some sort of RAID device (or don't you have your logical drives striped across your physical drives)? There is no easy answer to your question without an understanding of the reality of your disk layout. Fermin Bernaus fbernausTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @sammic.com cc: Sent by: Subject: RE: Multiple Datafiles and performance? ml-errors 08/07/2003 08:05 AM Please respond to ORACLE-L In my experience, spreading datafiles across volumes (specially if you are careful not to locate the a table's datafiles and its indexes datafiles in the same drive) greatly increases performance. As for the file size, I can not say because I have not tested it, but I think it should have no real impact compared to splitting it. Reorganizing the database regularly is a better way to optimize performance. .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -Mensaje original- De: Dave Phillips [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 06 de agosto de 2003 22:14 Para: Multiple recipients of list ORACLE-L Asunto: Multiple Datafiles and performance? Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead
Re: Multiple Datafiles and performance?
At 09:59 AM 8/7/2003 -0800, you wrote: Hi! The benefits of spreading the data over as many physical access paths ( ~ disks ) using multiple datafiles notwithstanding, there is always the case of too much. Keep in mind that at checkpoint time the DBWR need to visit the header of every ( non read-only ) datafile. That's unlikely to be an The number of files had some impact in older Oracle versions (7.x). Starting from 8.0 I believe, this issue is somewhat relieved, as you probably know. Not all file headers are updated together and the update doesn't have to go to disk immediately (this goes for checkpoints caused by log switches). Actually I didn't or else I wouldn't have made the point. I guess that is how myths start and get perpetuated: by no keeping up with changes. Also, in older versions db_files parameter affected DBWR batch size and some buffer cache structures as well, IIRC. The biggest number of files I've had in a production database is about 1150, 960MB each. On WindowsNT4... =8´o Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tables and views
Title: Message Join TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only columns that belong to tables. You should also set _disable_suboptimal_app_design to TRUE --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: Friday, August 08, 2003 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: tables and views How to diiferentiate views and tables in all_tables and all_tab_columns . which column and what criteria can return only tables ?? -ak Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Downloading patchests from Metalink
Over 600KBytes/s from: http://oracle-updates-west.conxion.com:8000/ARUConnect/dGREMDJJdVRxZGtxQjdNT Ud1UHFxUTo0MDE5OTI4OnAyNzYxMzMyXzkyMDNfSFA2NC56aXA6UVRJREJBOjE2MS40OS4yMS40M joxMDYwMDk4OTczOk5PX1BBU1M@/p2761332_9203_HP64.zip Get yerself a new pipe. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, August 05, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Has anybody been able to download a patch from Metalink? I'm getting an error saying that The opration timed out when attempting to contact oracle-updates-west.conxion.com. Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been refusing any contact with me for two days now. -- Mladen Gogala Oracle DBA -- 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: It's an Oracle Fun Friday!
Interesting web site that bigip... Picture of Larry with the annotation -- Coming Soon. Does this mean that Larry truly does not exist yet??? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 08, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Just looking at netcraft.com to see what Oracle's running these days, when I noticed their netblock is owned by Oracle Datenbanksysteme GmbH. German Oracle First move before the SAP AG hostile takeover bid? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Record breaking query
Title: RE: Record breaking query Thanks Wolfgang, our retention time is 21600 seconds ... and this one bailed out in half the time ... Oh well ... we need to fix few more things .. 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: Wolfgang Breitling [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 5:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Record breaking query I know what the message says. Do you believe everything you see printed? Or expressing is differently: how many error/diagnostics messages have you seen that are more misleading than helpful. At 01:24 PM 8/8/2003 -0800, you wrote: but message says it is in seconds ... anf yes it is 92 ... Thanks 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: Wolfgang Breitling [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Record breaking query Is that an Oracle 9 system and the time is in microseconds rather than seconds? At 10:39 AM 8/8/2003 -0800, you wrote: Yeah, but think of the uptime! One helluva MTBF on that server... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, August 08, 2003 12:49 PM To: Multiple recipients of list ORACLE-L TICK : Fri Aug 8 09:06:03 2003 SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489 ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec, SCN: 0x0011.05e003c2): TICK : Fri Aug 8 09:06:03 2003 SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT, VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER, TYPENAME, UNDERLEN, UNDERCLAUSE FROM SYS.EXU8VEW WHERE VOWNERID != :SYS_B_0 ORDER BY VLEVEL, VOWNER, VOBJID according to this error message this query has been running for close to 33 years. appears to be a export running for 33 years. I am clusless Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.nethttp://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.comhttp://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.comhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.nethttp://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.comhttp://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have
RE: IMP-00020: long column too large for column buffer size (22)
Thanks for all those who responded my mail. When there was buffer parameter or record length parameter, It did not work. Instead of importing the full dmp file, If I try to import one table, it is working okay. I still have to try couple of alternatives and let the List Group know the outcome. Best Regards, Prasad 860 843 8377 Odland, Brad [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] orld.comcc: Sent by: Subject: RE: IMP-00020: long column too large for column buffer size (22) [EMAIL PROTECTED] .com 08/07/2003 04:09 PM Please respond to ORACLE-L What about that buffer setting in imp...?? DOn't you have to set that higher than default when importing data that has binary fields? The exp file might be okay. THis is the BUFFER input parameter to imp. Brad O -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Hi All, One of our developer ftp'ed the export (dmp) file from UNIX to NT in ASCII mode. He didn't know that it supposed to be done in BINARY mode. Now, he ftp'ed the dmp file back to UNIX in ASCII mode and tried doing the import. Looks like dmp file has been corrupted and Import is giving the following error. IMP-00020: long column too large for column buffer size (22) IMP-00028: partial import of previous table rolled back: 16380 rows rolled back/ Is there any way to fix the dmp file. Any ideas? I searched the metalink and looks like there is no way to correct it. It is on HP-UX and oracle 8.1.7.4 I appreciate your help. Thanks. Best Regards, Prasad 860 843 8377 -- 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: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: SharePlex
Title: SharePlex it is _supposed_ to work that way ... close to production. But last time we looked at it, there were too many limitations relates to IOT, VARRAYS etc and it wasn't ready for our platform and version . but it is supposed to be good ... I have heard similar things about dataguard as well, but that is only if you are on 9i. 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: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, running Financials 11.5.7. We are interested in this for HA and for reporting instance use. rant We use Cognos as our query tool and the owners of this product tells me that we can't tune the SQL it emits. It makes pretty poor choices, which is not surprising for a gooey, sticky tool designed for end users. It is sort of pretty and if you can drool you too can generate cross products. Anyway , I'd like to get them off the production box. rant/ Does SharePlex allow you to stay close to the production instance in time? Does the store and forward work well? Do you love it? Hate it? Anything you'd like to say about this product I'd like to hear Thanks in advance Allan L. NelsonOracle DBA M-I L.L.C.(832) 295-2238 office(832) 351-4180 fax[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Record breaking query
Title: RE: Record breaking query 12GB only 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: Daniel Fink [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Record breaking query WOW! How many googolbytes do you have devoted to your Undo Tablespaces? Jamadagni, Rajendra wrote: TICK : Fri Aug 8 09:06:03 2003 SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489 ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec, SCN: 0x0011.05e003c2): TICK : Fri Aug 8 09:06:03 2003 SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT, VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER, TYPENAME, UNDERLEN, UNDERCLAUSE FROM SYS.EXU8VEW WHERE VOWNERID != :SYS_B_0 ORDER BY VLEVEL, VOWNER, VOBJID according to this error message this query has been running for close to 33 years. appears to be a export running for 33 years. I am clusless 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 ! Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txt Type: Plain Text (text/plain) Encoding: 7bit This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Oracle and Windows 2000 SP4 - any experiences to share
after installing SP4,even MS-Office troubled me a lot. .came back to SP3 again. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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).
Implementing different document types with different attributes
Title: Implementing different document types with different attributes Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, because more than the half (35) of the attributes are not always used for each document type. This will have to much disk space for each record, if most of the fields are just blank. Has anyone suggestions how to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim
RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
Yes, V$OPEN_CURSOR is instance-wide, but each row in the view sure looks like it can be attributed to a specific session via SADDR/ID/USERNAME. And the count of those rows for each session doesn't match the corresponding row/attribute in V$SESSSTAT. Erm, I'll leave off the product name here since this is the only DB problem I've seen with it, but I will say that it's a bug tracking package. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR v$open_cursors is all open cursors in the instance v$sesstat is just open cursors in the session. what 3rd party product is that? is it cross platform? Ill make sure not to buy it. really bad code to get too many open cursors. From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/08/07 Thu PM 04:14:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR No takers on this from the perf tuning gurus? Please don't make me open a TAR. Think of the children... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in the init.ora -- should be more than generous for a tiny app on a tiny DB -- we started looking into how many cursors the app actually has open at any given time. While investigating this, I see that the number of rows in V$OPEN_CURSORS isn't consistent with the value of stat 3 (opened cursors current) of V$SESSSTAT. Of the two processes I looked at, each had a V$SESSSTAT value of 3 for stat 3, while the first had a single entry in V$OPEN_CURSOR and the second had four. Should these values match? I looked on Metalink but was unable to find any reference to the relationship between these, other than a forum article where the OraSupport person was extraordinarily unhelpful. TIA, 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: URGENT: Trying to duplicate database from cold backup - auxi
Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database. Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the backup controlfile to trace file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -Original Message- mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -Original Message- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -Original Message- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
Corrupt Inactive RedoLog Goup.
Members, Production 8.1.6.3 database on Windows NT 4.0. We noticed an entry in the alert log, citing that a log group could not be archived since the 25th of July.. We have 3 log groups with 2 members each. I notice that the 3rd redolog group has a status of Inactive with Archived=No. This group has a sequence# of 745, while the other two have advanced to 1073 and 1074 now. We have had too many log switches since then, and Oracle has chosen to ignore using this corrupt redo log group. The database gets bounced daily, and opens without a problem, since this group is not needed for instance recovery. I tried manual archiving. SQLWKS alter system archive log group 3; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' SQLWKS alter system archive log logfile 'F: \ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' 2 ; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' SQLWKS alter system archive log logfile 'G: \ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' 2 3 ; ORA-16038: log 3 sequence# 745 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' Similarly, it does not allow me to drop this member, saying it has not been archived. Can I fake a recovery using cancel. and then open resetlogs? Or if I put the database in noarchivelog mode, will Oracle let me drop this corrupt redolog group? Thanks Raj -- 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).