RE: database hanging during mount
bin laden : you are right about drink and cd but now a days they tell you to open a metalink tar. unless this is production. seriously : is nfs mounted volume supported. on nt it does not recognize non local drives. Mladen Gogala [EMAIL PROTECTED] wrote: Get a drink, put some nice CD in the player and call (800) 223-1711. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank KesselSent: Friday, August 08, 2003 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: database hanging during mountI am running Oracle 8.1.7.4 on Solaris 8. I recently decided that I needed more space on the disk partitions that hold my Oracle databases. The machine I am running on didn't have room for more disks so I decided to nfs mount partitions from another machine. I backed up the existing partitions resized the one partition that I have locally and nfs mounted the other 3 partitions and restored all the partitions.The problem is when I try to STARTUP the database it hangs during the mount of the database. I am able to successfully STARTUP NOMOUNT. The instance starts then ! on the mount I receive the following in my trc file:ORA-00600: internal error code, arguments: [2116], [900], [], [], [], [], [], []ORA-00600: internal error code, arguments: [2116], [900], [], [], [], [], [], []From what I can determine this indicates that ORACLE is unable access the control file...permissions appear to be correct. Any suggestions on what I need to check? Any known problems with control files over a nfs mount?Thank youFrank 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. Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
Re: possible Bug in Oracle 9.2.0.2
Can you please list select emplid, empl_rcd, effdt, effseq, empl_status from ps_job where emplid = '3442' At 03:34 PM 8/6/2003 -0800, you wrote: 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.EngThis 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). Wolfgang Breitling 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: Standby database ORA-16016
Hi! I think archive log gap management is a new feature in 9i Data Guard. Check 9i's docs. You might have to build custom scripts for gap management in 8i. Also, I recommend you to use documentation from authentic location, http://tahiti.oracle.com Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 08, 2003 10:59 PM ORA-16016 archived log for thread string sequence# string unavailable Hello All I have a standby database oracle 8.1.7.4 on win2k running in managed recovery mode. NET8 have been transferring logs untill somehow the primary or standby server must have rebooted and I have now have sequence gaps. This doc seems to be everything you ever wanted to know about standby databses http://www.cs.rose-hulman.edu/docs/oracle-817/server.817/a76995/standbyc .htm#29765 But does not seem to address my problem. I would think... The primary database, would be sure to send *any* logs it has not sent. How can I be sure the primary sends all logs? Ive performed a log switch and the missing logs do not get sent. Does anyone have any suggestions to correct this? I would be very thankful. have a good weekend all! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: drop user
Everything looks like a big hammer to you, doesn't it Stephen? ;) On Mon, 2003-08-04 at 17:54, Stephen Lee wrote: Much faster: SQL select file_name from dba_data_files where tablespace_name = 'SYSTEM'; SQL !rm file_name POOF!! User gone. Very fast. -Original Message- Personnaly, I like to write a short script to generate the SQL to drop all the users tables with the 'cascade constraints' option. I then do a 'drop user cascade;' If there are a lot of tables/indexes, the recursive SQL can take awhile, assuming a fair number of extents per object. Then again, if you're using LMTs, then the recursive SQL shouldn't be too bad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Opatch
Looks like PERL5LIB is not set in your environment. If perl is installed under /usr/local, the libraries are located in PERL5LIB=/usr/local/perl/lib/perl ver# Regards, Sten -Original Message- Sent: Monday, August 04, 2003 7:34 PM To: Multiple recipients of list ORACLE-L I'm trying to use opatch and receive the following error [EMAIL PROTECTED] $ opatch apply PERL5LIB=; export PERL5LIB /usr/local/bin/perl /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat ch/opatch.pl apply Can't call method build_option_details on an undefined value at /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_module s/Apply.pm line 2299. ORACLE_HOME is correctly set, PATH is correct as well. Any idea what the problem may be. Every opatch command fails with the above error including such things as opatch -version. Ian MacGregor Stanford Linear Accelerator Center -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rognes, Sten INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Tim, Are you using 9i? If so create a parent_t object type with the common attributes. Create child object types UNDER parent_t. You can then define a table of type parent_t able to accept rows of all types. Cheers, John Thomas In message [EMAIL PROTECTED], Vernaillen Tim [EMAIL PROTECTED] writes sorry, misunderstood Invoices: - Origin - Form Template ID - AWB - Bill To Customer - Bill To Customer Name - Invoice # - Invoice date - customs Entry # - entry date - query handling (boolean) - cash application (boolean) - credit collection (boolean) - text search (boolean) - shipment folder (boolean) Customs Document: - AWB - Clearance # - Customs Entry # - Entry date - deferement # Cash batches: - query handling (boolean) - cash application (boolean) - credit collection (boolean) So, you could see, we've more than 50 type of documents and in total those have more than 70 different attributes (some are the same). There is not one attribute that appears on every document type!!! I would create so 50 tables (for each document type 1), but if someone has another suggestion, I would like to do it in an other way. -Original Message- Sent: donderdag 7 augustus 2003 16:59 To: Multiple recipients of list ORACLE-L attributes Just one or two examples, please. Vernaillen Tim tim.vernaillen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @xgs.be cc: Sent by: Subject: RE: Implementing different document types with different attributes ml-errors 08/07/2003 10:44 AM Please respond to ORACLE-L attribute is a specific part of an index-file, but those attributes are different for all document types -Original Message- Sent: donderdag 7 augustus 2003 16:15 To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vernaillen Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Corrupt Inactive RedoLog Goup.
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: 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).
ODBC Problem with @ sign
Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith
RE: It's an Oracle Fun Friday!
Title: RE: It's an Oracle Fun Friday! or Stephen - something even worse -Original Message- From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: 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).
Change based recovery
Hi Guys and Gals, We are currently doing some testing to enable us to move our production database from one unix box to another. We are running a 7.3.4 db in archivelog mode. The approach that management want to use is to restore the database on the new server from a backup and then roll it forward using the archived redo logs. I have a full cold back up from last Friday. I have restored the datafiles, controlfiles and redo logs onto our test server from the backup tape, and then ftp'd the archived logs over. I then do - SVRMGR startup mountORACLE instance started.Total System Global Area 258304260 bytesFixed Size 45092 bytesVariable Size 126925024 bytesDatabase Buffers 131072000 bytesRedo Buffers 262144 bytesDatabase mounted.SVRMGR recover database until change 10349;Media recovery complete. I would have expected it to display the names of the logs, butit doesn't, and when I check the alert log it shows 'No Media Recovery required'. Where am I going wrong? I can't understand why it won't apply the archived logs. (Too hot today and brain not working properly!) TIA. Lisa Dobson Database Analyst Home Group Ltd This message is intended only for the use of the person(s) ("Intended Recipient") to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk
RE: 9i - Dynamic SGA - SGA_MAX_SIZE
Mladen, But then again, shmget and shmat use malloc/calloc internally, it just differs in that shmget/shmat create the memory space and then make a public handle so that multiple processes can access the memory allocated. (Very simplisticly put) So in a certain sense it is more than just a similar mechanism. What was this discussion about anyway ;) -Mensaje original- De: Mladen Gogala [mailto:[EMAIL PROTECTED] Enviado el: viernes, 08 de agosto de 2003 16:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: 9i - Dynamic SGA - SGA_MAX_SIZE BTW, my debate of this issue was completely incorrect. As a colleague from This list has noted, SGA is created using shmget and shmat, not malloc and calloc. The only explanation might be that the mechanism is similar to the one of malloc. -- Mladen Gogala Oracle DBA -Original Message- Jessica Mao Sent: Tuesday, August 05, 2003 6:34 PM To: Multiple recipients of list ORACLE-L don't know if it's still true, i played with sga_max_size and db_cache_size a year ago on 9.0 Solaris8 F15k w/o much luck. when sga_max_size = 64G and db_cache_size = 32G, db started impressingly fast. but db server cpu sys% jumped up to 90+ during warming-up tests, leaving usr% close to 0. tests never finished. reduced sga_max_size = 40G and db_cache_size = 32G, db cpu still around 50% sys. sga_max_size = 18G and db_cache_size = 16G, db performing ok. after that gave up sga_max_size, increased db_cache_size to 24G (sga_max_size was then auto set to 24G). db performing ok. db_cache_size = 32G (= sga_max_size). took 32 min to start db. db performing ok. db_cache_size = 40G (just curious), took 40min to start db. db performing ok. -Jessica --- Mohammed Shakir [EMAIL PROTECTED] wrote: Kirti Thanks for the info. I could not raise dynamically the size of db_cache_size and did not know why, until I noticed the new parameter sga_max_size. Anyway, I tried to lower the size of db_cache_size dynamically and I did not have a problem. So sgma_max_size does play its role in db_cache_sizing. I have not tested where I increase the size of sga_max_size using init.ora and then try to increase the size of db_cache_size dynamically by the same size as the increase in sga_max_size. That is the test for coming weekend. --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: SGA_MAX_SIZE was introduced in 9i to allow dynamic sizing of SGA (Dynamic Sizing feature) components such as, shared pool, large pool, buffer cache etc. In versions up to 8i, such changes required bouncing the instance. This parameter assumes the value of the SGA at instance startup. Various components of the SGA can then be increased/reduced as and when needed. The total SGA, thus, can reach a maximum value set by SGA_MAX_SIZE (if set in the init.ora file). That's the idea. However, the implementation is different on various platforms. With ISM, and DISM, on Solaris, there are other issues when it comes to using Dynamic SGA. You may want to search Metalink for specific notes/articles for Solaris. On AIX 5L as I found out, Oracle uses SGA_MAX_SIZE, if set in init.ora, at the instanace startup, and allocates the excess (difference in computed SGA value and set SGA_MAX_SIZE) to 'variable size'. Hence there is no room for any dynamic sizing (upward) of any SGA component. I did not try to downsize shared pool first, and 'upsize' buffer cache later. May be that would work, but that is not the intention of using this parameter. PGA_AGRREGATE_TARGET is completely different from this parameter. It sets an instance-wide upper limit for the memory used by sorting, hashing processes. Hope this helps.. - Kirti __ 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: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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
Re: RE: why does block cleanout incur redo?
Excerpts from one of my notes, collated from excellent papers or websites by Steve Adams, Jonathan Lewis, and KGopal. The first block of every rollback segment, also called the segment header, has a structure called the transaction table, which keeps track of all the active transactions in that rollback segment. Transactions that use a rollback segment first register themselves in the transaction table using their transaction id. Also, each data block has one or many slots for an Interested transaction List, also called the ITL, in its header. Any transaction which modifies a row in a datablock must first get an ITL slot in that datablock. Each ITL consists of a transaction id, an address to the transaction table in the rollback segment, where the undo is located, a flag to indicate if the transaction is open, committed or pending for a cleanout, and the commit SCN. The ITL is contained in the transaction layer of an Oracle block header. Apart, from this, the cache layer of the oracle block header, also has an SCN which represents when the block was last changed. When a transaction issues a commit, Oracle marks the transaction as commited in the transaction header table of the corresponding rollback segment. Also, the changes in the log buffer are written to disk. However, the transaction entry in the ITL of the data block may or may not be commited. Before Oracle 7.3, Oracle never marked any of the changed data blocks as commited. Any subsequent transaction that needs to read the changed block, would be directed to check the rollback segments to see if the transaction is commited, and would then update the block headers with the commit SCN, close the ITL, and would tidy up the data block by writing it to disk. This process is called a 'delayed block cleanout'. Staring with Oracle 7.3, Oracle introduced a fast commit mechanism, whereby it does mark some of the changes as commited, depending on if your transaction is a short one or a long one. The threshold value which decides if a transaction is a long one or a short one is 10% of the value for db_block_buffers. Also, the affected data blocks should be in the buffer cache. Thus, if the number of blocks that is modified by a transaction does not exceed 10% of the number of blocks in the database buffer cache, and all of affected data block are still in the buffer cache, Oracle will indeed perform a 'commit cleanout'. Else, the next transaction reading the affected data blocks will perform a 'delayed block cleanout'. [EMAIL PROTECTED] net To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: RE: why does block cleanout incur redo? ity.com 08/07/2003 07:24 AM Please respond to ORACLE-L thanks... I have jonathan lewis's book on my list to read. The transaction table is what is modified with the initrans and maxtrans setting. I get it now. when you perform block clean out you modify the block and state that it is no longer being used in this transaction. when the blocks are flushed by DBWR, the transaction table needs to be modified so that the number of transactions that is occurring is known. this causes redo. so that if you have to recover, the transaction table in each block can be accurate. Am I correct? From: Cary Millsap [EMAIL PROTECTED] Date: 2003/08/06 Wed PM 11:29:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: why does block cleanout incur redo? It's because flush doesn't
RE: 9i - Dynamic SGA - SGA_MAX_SIZE
To continue down the Stephen's path, shutdown abort will complete very quickly and will drastically decrease the size of SGA. What is more, the very busy environment Will not be very busy any more. Perhaps very loud, but not very busy. -- Mladen Gogala Oracle DBA -Original Message- Kirtikumar Deshpande Sent: Tuesday, August 05, 2003 12:35 PM To: Multiple recipients of list ORACLE-L U R Welcome. Although, reducing SGA size is technically possible, it can be a very expensive operation in a busy environemt and can take a long time to complete. I have not run any specific tests to see how long it takes to reduce SGA by a certain amount, but you can imagine what must be done (find least used blocks/age out blocks, keep them from re-use, and finally 'detach' them etc..) - Kirti --- Mohammed Shakir [EMAIL PROTECTED] wrote: Kirti Thanks for the info. I could not raise dynamically the size of db_cache_size and did not know why, until I noticed the new parameter sga_max_size. Anyway, I tried to lower the size of db_cache_size dynamically and I did not have a problem. So sgma_max_size does play its role in db_cache_sizing. I have not tested where I increase the size of sga_max_size using init.ora and then try to increase the size of db_cache_size dynamically by the same size as the increase in sga_max_size. That is the test for coming weekend. --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: SGA_MAX_SIZE was introduced in 9i to allow dynamic sizing of SGA (Dynamic Sizing feature) components such as, shared pool, large pool, buffer cache etc. In versions up to 8i, such changes required bouncing the instance. This parameter assumes the value of the SGA at instance startup. Various components of the SGA can then be increased/reduced as and when needed. The total SGA, thus, can reach a maximum value set by SGA_MAX_SIZE (if set in the init.ora file). That's the idea. However, the implementation is different on various platforms. With ISM, and DISM, on Solaris, there are other issues when it comes to using Dynamic SGA. You may want to search Metalink for specific notes/articles for Solaris. On AIX 5L as I found out, Oracle uses SGA_MAX_SIZE, if set in init.ora, at the instanace startup, and allocates the excess (difference in computed SGA value and set SGA_MAX_SIZE) to 'variable size'. Hence there is no room for any dynamic sizing (upward) of any SGA component. I did not try to downsize shared pool first, and 'upsize' buffer cache later. May be that would work, but that is not the intention of using this parameter. PGA_AGRREGATE_TARGET is completely different from this parameter. It sets an instance-wide upper limit for the memory used by sorting, hashing processes. Hope this helps.. - Kirti __ 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: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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
test message eom
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Tim, As soon as I sent this I saw my mistake. There's got to be one more table. Doc_Types and Doc_Attributes stay, but Documents gets changed and Document_Attributes gets created. Actually, if you wanted you could make a single integer PK column for Doc_Type_Attributes and use that as the FK in Document_Attributes. Table Documents Doc_ID NumberPK ,Doc_DescrVarChar2(100) ,Doc_Body BLOB(store this segment out-of-line somewhere) (other Document columns) Table Document_Attributes Doc_ID NumberPK and FK to Documents ,Doc_Type_IDNumberPK and part of FK to Doc_Type_Attributes ,Doc_Attrib_ID NumberPK and part of FK to Doc_Type_Attributes Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Jack Applewhite To: [EMAIL PROTECTED] 08/07/2003 01:16 cc: PM Subject: Re: Implementing different document types with different attributes (Document link: Jack Applewhite) Tim, How about this? Table Doc_Types Doc_Type_IDNumberPK ,Doc_Type_Descr VarChar2(100) Table Doc_Attributes Doc_Attrib_ID NumberPK ,Doc_Attrib_Descr VarChar2(100) Table Doc_Type_Attributes (Intersect table of the above two) Doc_Type_IDNumberPK and FK to Doc_Types ,Doc_Attrib_ID NumterPK and FK to Doc_Attributes Table Documents Doc_ID NumberPK ,Doc_Type_IDNumberpart of FK to Doc_Type_Attributes ,Doc_Attrib_ID Numberpart of FK to Doc_Type_Attributes ,Doc_DescrVarChar2(100) ,Doc_Body BLOB(store this segment out-of-line somewhere) This way you can have as many Doc Types and Attributes as you want and never have to modify table designs if you add or remove some. Also, no blank columns. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Vernaillen Tim [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] gs.be cc: Sent by: Subject: Implementing different document types with different attributes [EMAIL PROTECTED] .com 08/07/2003 08: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
RE: IMP-00020: long column too large for column buffer size (22)
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).
Re: Oracle and Windows 2000 SP4 - any experiences to share
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).
RE: Multiple Datafiles and performance?
1). I don't know. But I always try to create datafile with same size (2G) and it is easier to estimate how many datafiles I can fit into one disk. 2). If all datafiles are on 1 disk, then 4 1G datafiles vs 2 2G. should not make much difference. If you could spread 4 1G datafiles into 4 different disks (mount points), then it is better. 3). I seem to read it from somewhere that Win2K has problem to handle datafile larger than 2G. Guang -Original Message- Dave Phillips Sent: Thursday, August 07, 2003 11:25 AM To: Multiple recipients of list ORACLE-L ... 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 multiple datafiles have on performance? For example, if I have one 2.5g datafile, and three 1g datafiles, and I need more space, would it be better to increase the size of the 1g to 2g or add another 1g datafile?. Is it better to keep them all uniform in size? I would think having multiple datafiles that could be spread across drive volumes would be beneficial, am I wrong? (Wouldn't be the first time :) TIA David Phillips Support DBA Gasper Corp. BAARF member #30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: 100 instances on same server !!!
Hi! Disk IO: Providing, that idle Oracle accesses all controlfiles every three seconds, then with 100 instances/databases, you'll have about 33 random IOs per second. Can your disks. If you got three controlfiles per database, then it means 100 IOs/sec, which gives 10ms per access, otherwise you'll overload your IO. And this is an idle database. In reality (even with idle db) you got much more IOs going on. Disk space: 3GB per database * 100 = 300GB. Memory:, an 8.1.7 instance takes at least 50MB of memory. Multiply it by 100 - 5GB. Without OS (and file system cache) memory requirements. CPU: will probably get quite loaded as well, because for each user, there's a separate DBWR, LGWR, CKPT, monitor, queue, etc.. processes. OS resources: you could very well run out of semaphores, file handles, shmseg's etc.. Maintenance: Hey man, you'll have 100 different databases with 100*100 of different problems! So, unless you got a powerful server and write caching IO subsystem and you want to waste all of it for nothgint, the answer is no, you can't have 100 databases in one server. Go with logon triggers, and row level security. You don't even haveto duplicate schemas, your packaged app doesn't even have to know, that it's running on same table set with others, and it's really simple to set up.As abonus, when granting excempt_access_policy privilege to a user, you can run reports over all 100 user's data, but "normal" users don't have slightest idea, that there could be any other data in table in addition to theirs. The downside is, that you should add some kind of org_id or user_id columns to your tables, on which the row level security will work. Search for fine grained access control in docs. Tanel. - Original Message - From: Dilip Patel To: Multiple recipients of list ORACLE-L Sent: Friday, August 08, 2003 1:54 AM Subject: 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
Re: SharePlex
I could access oraclestore today and didn't see neither DataGuard nor Streams in database additions section (where RAC, Data Mining and others are). Then did a product search on dataguard, data guard, standby - got no positive results... But maybe the sales guys have other story... I've luckily managed not to deal with licensing issues for past few years now. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 10, 2003 4:34 AM On 2003.08.09 09:39, Tanel Poder wrote: MessageHi! Mladen, does DG really have additional fee when using EE? I tried to check from oraclestore, but got - instead: Tanel, my @#$%! Adelphia Cable connection is down more or less throughout the day today, so I cannot check at the Oracle Store, but I'm reasonably certain that both Data Guard and Oracle Streams are sold separately. As for this email, I'm using my local sendmail, which will deliver the message whenever the connection is restored. -- 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). -- 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).
Comparison between Oracle 9i SE SqlServer 2000 SE
Hello fellow Oraclers, Has any of you done a comparison study on Oracle 9i SE Sql Server 2000 SE??? If yes, will it be possible for you to share your findings with me. In case any of you know of a web link that provides an unbiased comparison study that too would be wonderful if you could send me the link. Thanks Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arif Khan (GWL) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
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.txtType: Plain Text (text/plain) Encoding: 7bitbegin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard
RE: [stupid] vi question
There's the :set list and :set nolist commands. But in your case, I think you got ahold of a MSDOS/Windows text file. -Original Message- Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help with 9iAS on Linux 8
Hello List, Has anyone successfuly installed Oracle 9iASrelease 2 (9.0.2.1) on Linux 8 i.e. SLES8 (Suse Linux Enterprise Server 8) Can you please provide me with basic (initial) settings for the installation. Any help in this will be highly appreciated. Thanks in advance. Nikunj Add photos to your messages with MSN 8. Get 2 months FREE*. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: H elp_me INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).