RE: Outsourcing's dirty secret
Title: Message may best brains survive where ever it is. -Original Message-From: Anjan Thakuria [mailto:[EMAIL PROTECTED]Sent: Monday, November 03, 2003 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secret Thank you Jared. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secretThis is not appropriate for this list. Please refrain in the future. Jared hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 05:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secretHi AllDBA's all here hmm...well if i were the CFO i wouldhave been lookin for the fast=true parameter if i werebald i would have been looking for a pill or a creamthat would give me hairs overnight..the time ofinstant nirvana has come :-)..software bpo callcenteres they are all same..today the jobs are beingmoved to india becaz the CEO's see that they are ableto save 10$ on paper. or maybe just becoz yourcompetitor is doin so..capital always moves in serachof labour thats the bottom line ..:-) i read argentinaprogrammers are cheaper then indians wellhehehe..hehee ...:-)..argentians woman are they morebeautifulthe author in my opinion has provided askewewed version of outsourcing ..the real competitionfor india will come from ETHOPIA i beelive ..providedthe ethopians start learning english...:-) and willstart working for food :-)as for us we americans we can come out with a dirtytrick like not sharing information on fear of gettingsacked with indian programmers :-)regardsHrishy--- "Loughmiller, Greg"[EMAIL PROTECTED] wrote: not onlysalries, but job opportunities as well:-) greg -Original Message- Sent: Thursday, October 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L But sure as hell does drive salaries down over here. On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote: The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared "Jamadagni, Rajendra" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secret What is also unfortunate that the company X which outsourced its project to India, didn't do its job right ... If you just want the cheapest Rolex, you can't complain about its quality later on. I am not saying this couldn't have happened, whatever happened is unfortunate, but I am just saying that the company didn't understand CYA sufficiently, it is just a blame game now.C'mon ... I think that article is one side of the coin. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outso urcing.htmlDennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni,
ORA-1025??
Hi friends, When Iam exporting thru pipes and mknod, Iam getting error:- PL/SQL Release 2.3.2.0.0 - Production Export done in US7ASCII character set Note: indexes on tables will not be exported About to export specified tables via Direct Path ... . . exporting table TTFGLD410100 EXP-8: ORACLE error 1025 encountered ORA-01025: UPI parameter out of range . . exporting table TTFGLD106100 EXP-8: ORACLE error 1025 encountered ORA-01025: UPI parameter out of range Export terminated successfully with warnings. My script is looks like.. PATH=$PATH:$ORACLE_HOME/bin LOG=/data10 RBSCRIPTS=/rb/scripts/backup # Create a named pipe PIPE=/tmp/dsptab_pipe if [ -a ${PIPE} ] then rm ${PIPE} fi mknod ${PIPE} p # dd in from the named pipe and out to the tape device dd if=${PIPE} of=/dev/rmt1 cd ${RBSCRIPTS} exp file=${PIPE} parfile=dsptab ${LOG}/dsptab.log 21 TIA Raghu. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export to tape!!
Thank you so much mike!! I find it the same from asktom web site!! But If I want to restore different tables from the same export,should I able to do that?? From: Hately Mike [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: export to tape!! Date: Tue, 30 Apr 2002 02:28:27 -0800 Raghu, You can just specify the tape device as the target file. One important difference is the optional volsize parameter which allows you to specify the capacity of the tape drive. Export/import will then prompt for the next tape when required. i.e. exp username/password file=/dev/rmt0 volsize=100M other options imp username/password file=/dev/rmt0 volsize=100M other options regards, Mike Hately -- From: Raghu Kota[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Subject:export to tape!! Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Raghu Kota OCP DBA. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
what is wrong with this export?
Hi friends, Iam exporting some of tables, but keep getting error!! Could you help.. Mine is AIX415 with oracle4.3, If I want import an individual table, what is correct form of parameters? exp user/passwd tables = \ ( table1, tab2, tab3, tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130, ttdinv700040,ttdinv700061,ttdinv700110,ttdinv700120,ttdinv700130, ttfgld410210,ttfgld421010,ttfgld410060,ttfgld100010,ttfgld106060, ttfgld106100\ ) COMPRESS=N direct=Y log=fullsls.log file=fullsls.dmp Thanks in advance Raghu. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export to tape!!
Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Reorganize table
Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parallel execution question
Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parallel execution question
Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! I have 8 CPUs with 2GB RAM on AIX415. Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Tuning
Yeah its very good book!!!Especially I like that chapter Method behind madness!!..Every body should read that book. From: K Gopalakrishnan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Performance Tuning Date: Wed, 30 Jan 2002 04:30:24 -0800 Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Raghu Kota OCP DBA. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Tuning
You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Raghu Kota OCP DBA. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Archive log dest full
As a first step you can compress all archived logs first!!! Then you can do what ever u want with out bouncing database.. From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Archive log dest full Date: Tue, 08 Jan 2002 04:15:19 -0800 Backup the archivelogs on a schedule and delete them from the archivelog destination. Rman has a command to do this, if you use rman. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 6:50 AM So yesterday the archive log dest disk filled up on one of our prduction systems causing the Oracle DB to halt as it's supposed to. Disk space was tight and there was a bit of data loading done. Anyhow I freed up disk space on relevant drive and proceeded to server console to press the OK button to allow archiving to restart. However, the console was locked by a PC Anywhere session which prevented me from getting to the console window with archive dest full message. Anyhow ended up having to bounce the database. Apart from throttling the user who set the PC anywhere lock on the console and insisting it not be done again I'm wondering did I have any other options apart from a database bounce to overcome this problem?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Raghu Kota OCP DBA. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Truncated table!!index still holding space??
Hi Friends, I have two tables sized more than 2.3Gb has each index 700Mb, I truncated both tables!! I got space back of from tables, But indexes still showing its holding space(I got from dba_segments), It looks weired!! Mine is oracle7.3 in AIX. Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Truncate Index??
Hi Friends, Iam truncating some 6Gb data from 3 tables!! So I want get rid of corresponding Indexes too!! Can I truncate index?? or rebuild the index after truncating table??? Any best method?? I don't want to drop any thing!! Just want to get rid of data!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
simple SQL
Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need a listserver for :-( ms sql server
Try these... http://www.mssqlserver.com/ http://www.sqlmag.com/ http://www.swynk.com/ ---This is listserv!!! http://www.sqlteam.com/ http://www.sqlwire.com/ http://ls.swynk.com/scripts/lyris.pl - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 19:45 Hi, Anyone know of a good list for mssql? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Deleting Oracle8 on NT(cleaning Oracle8)
Hi Friends, I need to clean Oracle8 database size 3Gb on one of my NT server, Is it possible that shutdown the database and delete all datafiles and all directories??? Or Is there any other way to clean all files and directories?? I appreciate all suggestions and responses. Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Meaning of V$WAITSTAT statistics
Hi Friends My v$waitstat shows like this..I think there is no time waited..Its okay, Or any thing Iam missing here?? SQL select * from v$waitstat; CLASS COUNT TIME -- -- -- data block 335274 0 sort block 0 0 save undo block 0 0 segment header 52 0 save undo header0 0 free list 0 0 system undo header 0 0 system undo block 0 0 undo header 322 0 undo block419 0 Thanks Raghu. From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Meaning of V$WAITSTAT statistics Date: Wed, 03 Oct 2001 07:05:20 -0800 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
New disks on AIX, things to monitor/checks??
Hi Friends, We are going to add new disks other than existing disks!! My front end is baan, my system is AIX 4.1.5 with 200Gb data( I think its before AIX 4.3 version). My task is to test new disks performance like is it viable or not!! So what are the things I need to monitor?? or any checks I have to do?? I appreciate any light on this?? TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Optimizing the query to increase performance??
Hi Friends, I had a query running longer time!!, what is best way to optimize this query?? Or can I break this query for 5000 records each..Any ideas and suggestions?? SELECT DISTINCT CC.CUST_NO, CF.DISBURSE_CUST_NO FROM CUSTOMER_CODE CC, CUSTOMER_FINANCE CF WHERE CC.CUST_NO = CF.BILL_CUST_NO(+) AND CC.CUST_NO BETWEEN 1 AND 99 AND (CF.EFF_START_DATE = '16-SEP-2001' AND CF.EFF_STOP_DATE = '16-SEP-2001') Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Optimizing the query to increase performance??
Hi Kevin Thanks for quick reply..Its normally taking 2-4min to show whole data, my cc has 18179 rows, and cf has 51513 rows..Here is explain 18179 rows selected. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1866 Card=46885 Byte s=3188180) 10 SORT (UNIQUE) (Cost=1866 Card=46885 Bytes=3188180) 21 NESTED LOOPS (Cost=36 Card=46885 Bytes=3188180) 32 TABLE ACCESS (FULL) OF 'CUSTOMER_FINANCE' (Cost=36 Car d=50409 Bytes=2217996) 42 INDEX (UNIQUE SCAN) OF 'PK_CUSTOMER_CODE' (UNIQUE) From: [EMAIL PROTECTED] (kevin edwards) To: [EMAIL PROTECTED] (Raghu Kota),[EMAIL PROTECTED] (LazyDBA.com Discussion) Subject: RE: Optimizing the query to increase performance?? Date: Wed, 26 Sep 2001 14:21:40 -0400 withoust seeing an explain plan this is just a guess SELECT CC.CUST_NO, CF.DISBURSE_CUST_NO FROM CUSTOMER_CODE CC,CUSTOMER_FINANCE CF WHERE CC.CUST_NO = CF.BILL_CUST_NO(+) AND CC.CUST_NO BETWEEN 1 AND 99 and CF.BILL_CUST_NO BETWEEN 1 AND 99 AND (CF.EFF_START_DATE = to_date('16-SEP-2001 00:00:00','dd-mon- hh24:mi:ss') AND CF.EFF_STOP_DATE = to_date('16-SEP-2001 23:50:00','dd-mon- hh24:mi:ss') ) group by CC.CUST_NO, CF.DISBURSE_CUST_NO Raghu Kota [EMAIL PROTECTED] wrote: Hi Friends, I had a query running longer time!!, what is best way to optimize this query?? Or can I break this query for 5000 records each..Any ideas and suggestions?? SELECT DISTINCT CC.CUST_NO, CF.DISBURSE_CUST_NO FROM CUSTOMER_CODE CC, CUSTOMER_FINANCE CF WHERE CC.CUST_NO = CF.BILL_CUST_NO(+) AND CC.CUST_NO BETWEEN 1 AND 99 AND (CF.EFF_START_DATE = '16-SEP-2001' AND CF.EFF_STOP_DATE = '16-SEP-2001') Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Sr. DBA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test schema from prod
Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time. TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test schema from prod
Hi Friends, Great input and wonderful info guys!! Thanks to all. Its always nice to see different view points. Thanks again Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
what is wrong with this timestamp??
set timing on; SELECT SUM(orig_transac_amt), COUNT(1) FROM dsg.ar_open_items WHERE timestamp_date between '06-sep-01 21:22:34' and '06-sep-01 22:01:57' AND user_id_no = 0; Ora-1830?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what is wrong with this timestamp??
Thank you nick!!!Its great help. From: Nick Wagner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what is wrong with this timestamp?? Date: Wed, 12 Sep 2001 13:45:18 -0800 try this where clause WHERE timestamp_date between to_date('06-sep-01 21:22:34','DD-mon-YY HH24:MI:SS') and to_date('06-sep-01 22:01:57','DD-mon-YY HH24:MI:SS') AND user_id_no = 0; Nick -Original Message- Sent: Wednesday, September 12, 2001 2:25 PM To: Multiple recipients of list ORACLE-L set timing on; SELECT SUM(orig_transac_amt), COUNT(1) FROM dsg.ar_open_items WHERE timestamp_date between '06-sep-01 21:22:34' and '06-sep-01 22:01:57' AND user_id_no = 0; Ora-1830?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Interesting News..
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allen R. Lucas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
to Arich Henneman....
Oh, stop!! too many msgs. From: Arich Henneman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Alter tablespace add datafile Date: Wed, 05 Sep 2001 19:45:34 -0800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Center monitoring
Hi Gurus, I have number of Oracle8i instances on HP-Ux in a 400 servers Data center!! I want valuble suggestions from Gurus and who maintaining their real Data ceners.. I appreciate your help. Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Center monitoring
Dear Friends Thank you somuch for your valueble input for my job. I leared alot from these lists!! Thankyou all. Raghu. From: Deshpande, Kirti [EMAIL PROTECTED] To: Raghu Kota [EMAIL PROTECTED],LazyDBA.com Discussion [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: RE: Data Center monitoring Date: Mon, 27 Aug 2001 16:25:52 -0500 Raghu, We use BMC - PATROL for database monitoring. However, we removed all the out-of-box actions by it, and replaced those with our own where ever needed. We do not let Patrol change anything in the database (for example, allocating space when it detects extent problems). Instead, it e-mails and pages the responsible DBA by running our scripts that figure out who is the responsible DBA. We also use only about 15 or so parameters for Patrol monitoring (I think patrol has about 50 or so). It's an expensive solution for the things we currently do with it, but does it solve the problem of keeping up with scripts etc for new servers and databases. We have a very dynamic environment with 100s of databases on multiple platforms (VAX VMS/Alpha, SUN, HP, AIX etc).. Patrol is a right solution for it. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 2:16 PM To: LazyDBA.com Discussion Subject:Data Center monitoring Hi Gurus, I have number of Oracle8i instances on HP-Ux in a 400 servers Data center!! I want valuble suggestions from Gurus and who maintaining their real Data ceners.. I appreciate your help. Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
autoextent??
Hi Friends Which data dictionary view will tell, Whether my tablespace datafiles are AUTOEXENTD OR NOT?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-600 ..sort extent pool??
Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-600 ..sort extent pool??
Thankyou very jon. From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 ..sort extent pool?? Date: Sat, 04 Aug 2001 14:40:18 -0800 Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The 510 indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 4:55 PM Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-600 ..sort extent pool??
Thankyou very much jon. From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 ..sort extent pool?? Date: Sat, 04 Aug 2001 14:40:18 -0800 Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The 510 indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 4:55 PM Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Management server??
Hi Friends When Iam starting my Enterprise Manger console, Its asking Oracle Management server??? What is that?? I tried with giving host name, But it did't work?? How to connect my EPM?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter index??
Hi Friends What is the best way of rebuilding of following Index?? Index has total size 5.8Gb But lot of deletions, may be the real data around 2.5Gb has initial extent 71M, next 197M. So How my doubt which is best way for setting initial=next or give more space for initial for putting more data in initial itself and keep next as it is??? Any ideas??? Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deletion of data from a large table
Rukmini If you have good PCTUSED you are safe!! The space will be reused, Other wise You have to reorganize table!! From: Rukmini Devi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: deletion of data from a large table Date: Thu, 26 Jul 2001 04:35:48 -0800 This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: effect of Initial and Next exents...
Thanks Lisa, and all who responded. Yeah I find that document interesting... From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: effect of Initial and Next exents... Date: Thu, 26 Jul 2001 07:47:07 -0800 Raghu, There are differing opinions regarding multiple extents. I subscribe to the belief that multiple extents are not a bad thing. The latency between the extent reads is not a factor until the number of extents reaches ~4000. I remember reading a white paper on this topic, however I can't tell you exactly where it is off the top of my head. If I was the dba for this database, I would be more concerned with fragmentation and size of extents than the number of extents. If you understand your data thoroughly, have fairly accurate estimates for growth and understand the application it is supporting, you can choose your extent sizes properly and won't have the problem of 4000+ extents. Uniform extent sizes are optimal to avoid fragmentation. My choice to avoid fragmentation is the method in the white paper entitled 'How to Stop Defragmenting and Start Living'. I don't know about LMT's, haven't read up on them, but just from the discussions I've seen on the list about them, it looks like may be an implementation of this idea. Here's another way to look at it: If you think multiple extents are bad, are you going to create a tablespace with a 6gb datafile for your 6gb 1-extent index and hope it doesn't grow? With larger databases this idea breaks down very quickly. HTH, and list, correct me if I am wrong about LMT's. I can always blame it on the pain killers. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Subject:effect of Initial and Next exents... Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance and rectification??... TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
effect of Initial and Next exents...
Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance and rectification??... TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Temp tablespace issue
Y'day I got this errors, I tried to resize the file, But I could't succeed! Later I did wakeup SMON and tried with alter tablespace temp ..(pctincrease 0)..But still I getting ora-600 with ora-01114/ora-07376 errors..Then I put that particular temp file in offline!!..I problems increased!! Then I try to put online..It asked recovery .I applied the recovery..Problem is gone!! My space is okay. But I find for simple temp space insuffcient, just wake up SMON!! Its works well. But any ora-600 problems..STILL PUZZLE?? Mon Jul 23 08:26:13 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_65640.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 Thanks Raghu. From: Deshpande, Kirti [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: Temp tablespace issue Date: Tue, 24 Jul 2001 08:52:53 -0500 If your are getting ORA-600 error for seemingly simple operations, I think it is time to get Oracle Support involved as soon as possible. Good Luck. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Pankaj Behl [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:37 AM To: LazyDBA.com Discussion Subject:Temp tablespace issue Hi Guru's Today seems to be the day for awakenings! Our temp tablespace is about 10GB and the application uses up to about 3.5 GB. We had a space issue on the development box and i tried to reclaim some space by resizing the temp tablespace. But..when i tried to resize the TEMP tablespace i had ORA-600 errors reported in the log files and i had to kill the sql session that was performing the resize. I have not noticed any problems since. I also tried to drop the temp tablespace with similar problems. What all am i missing? Would appreciate any help in this regard as we are still up and running and still need to tackle the space issue. Thanks and Regards, Pankaj Behl __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Temp problem
Hi friends I had following error in my alert log file, Any ideas why its happening?? Mine is AIX ,oracle7. Mon Jul 23 08:53:43 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_96526.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent..RE: Temp problem
It seems for me the block 134552 was corrupted!!.I think I have option to repair that block or drop temp tablespce!! So How can I drop temp tablespce in production!!! and If you any body to repair that block let me know..Thanks to all TIA Raghu. From: Hitchman, Peter [EMAIL PROTECTED] To: 'Raghu Kota' [EMAIL PROTECTED], LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: Temp problem Date: Mon, 23 Jul 2001 15:38:30 +0100 Hi, I have no experience of AIX, but to me the error message indicates that you are creating data files that are too large. Assuming that you are on a 32 bit system, make sure that each datafile is = 2Gb. So if you require tablespaces greater than 2Gb, you create many datafiles per tablespace. Regards Pete [END] -Original Message- From: Raghu Kota [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 3:23 PM To: LazyDBA.com Discussion Subject: Temp problem Hi Friends I have problem with TEMP tablespace!! I tried to resize my datafile,But that too giving errors!! So I shutdown my production database and restarted still getting same errors??..Any Ideas why even after shudown??? Mon Jul 23 08:53:30 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_44226.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent..RE: Temp problem
Thankyou all people!! From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Urgent..RE: Temp problem Date: Mon, 23 Jul 2001 10:20:24 -0800 Raghu, I would try and create a new tablespace (name it TEMP1, type=temporary) while running, and alter the user's accounts to point to the new tablespace. Wait awhile, and try and drop the old TEMP tablespace. Seems to me that if there are temporary segments in use, Oracle will not let you drop the tablespace. If all else fails, kick the users off, drop and re-create the TEMP tablespace. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 23, 2001 1:35 PM To: Multiple recipients of list ORACLE-L It seems for me the block 134552 was corrupted!!.I think I have option to repair that block or drop temp tablespce!! So How can I drop temp tablespce in production!!! and If you any body to repair that block let me know..Thanks to all TIA Raghu. From: Hitchman, Peter [EMAIL PROTECTED] To: 'Raghu Kota' [EMAIL PROTECTED], LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: Temp problem Date: Mon, 23 Jul 2001 15:38:30 +0100 Hi, I have no experience of AIX, but to me the error message indicates that you are creating data files that are too large. Assuming that you are on a 32 bit system, make sure that each datafile is = 2Gb. So if you require tablespaces greater than 2Gb, you create many datafiles per tablespace. Regards Pete [END] -Original Message- From: Raghu Kota [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 3:23 PM To: LazyDBA.com Discussion Subject: Temp problem Hi Friends I have problem with TEMP tablespace!! I tried to resize my datafile,But that too giving errors!! So I shutdown my production database and restarted still getting same errors??..Any Ideas why even after shudown??? Mon Jul 23 08:53:30 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_44226.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
BaanIVc with Oracle
Hi Friends What is highest version of Oracle with BaanIVc4?? Any ideas? We are thinking to upgrade our Baan and Oracle7 on AIX v4.3 Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
temp resize?
Hi Friends I need to rebuild the Indexe of 6Gb size. For that When Iam doing rebuild option Its saying temp space insufficent!! So right now my temp tablespace size 1.75Gb spreading around 4 datafiles across two disks, I can't touch theose disks because of full. So I need to add another datafile/files to support my rebuild for that I need to increase temp tablespace, But can I bring it back to orignial 1.75Gb??? of temp tablespace after my rebuild is completed. Thanks for your responses. Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: temp resize?
Yeah I tried to wake up smon, by giving this statement alter tablespace temp storage(pctincrease 0); But no use..Still I getting problem when I rebuilding it. Thanks again to all. From: Mohammad Rafiq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: temp resize? Date: Tue, 03 Jul 2001 10:58:19 -0800 Have you tried to put temp tablespace offline(at off-peak time) and put it back on line to get released space without database is rebounced. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 03 Jul 2001 08:36:47 -0800 Raghu, You should be able to bring it back to original size if the segments in that part are not in use. Oracle8i does not release the temp segments once used until the database is shutdown(someone please correct me coz we have had this situation). Also if you add any file for the increasing the size then you won't be able to drop the same without droping the tablespace. Shailesh -Original Message- Sent: Tuesday, July 03, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hi Friends I need to rebuild the Indexe of 6Gb size. For that When Iam doing rebuild option Its saying temp space insufficent!! So right now my temp tablespace size 1.75Gb spreading around 4 datafiles across two disks, I can't touch theose disks because of full. So I need to add another datafile/files to support my rebuild for that I need to increase temp tablespace, But can I bring it back to orignial 1.75Gb??? of temp tablespace after my rebuild is completed. Thanks for your responses. Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
temp problem when rebuilding Index
Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespaceTEMP Any Ideas?? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: temp problem when rebuilding Index
Yeah I can't do parition, I think I have increase TEMP. But How much can I increase?? Is there any measurement?? Thanks to all responses. From: Gregory Conron [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: temp problem when rebuilding Index Date: Sat, 30 Jun 2001 14:41:01 -0800 On June 30, 2001 06:35 pm, Raghu Kota wrote: Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP You need to either partition your table or increase the size of temp. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Latchs
Oracle8i Internal Sevices by steve Adams. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Latchs Date: Tue, 19 Jun 2001 02:55:21 -0800 Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very much in advence. Regards. Miguel. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: arguments in ora-600
*; 17990 - 17999 reserved for PL/SQL; = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Index Tree dump??
Hi Friends Can some one tell me how can I do correct Tree dump for Index??? TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PCTUSED??
Greg My concern is How can I reuse the deleted space, I have 20Gb Table with 15Gb Indexes, So I may not touch the table due to massiveness, I can do atleast indexes rebuild for availing 3-4Gb back. So in that regard pct_used has greater significance for reusing the space for future insertions. Thank you all for your responses and valueble input. Thanks Raghu. From: Greg Moore [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: PCTUSED?? Date: Wed, 06 Jun 2001 15:56:25 -0800 I have big growing tables has default PCT_USED 40%, But we delete data some times one year or 2yrs data. What is optimum value for this parameter?? I may consider my database is oltp. So how can decide a correct value for this??? PCT_USED might not have any effect for you at all. If you keep inserting rows by date, the blocks will fill with rows where the date is the same for every row in the block, or close. Then if the only time you delete is when you delete an entire year's worth of data, entire blocks will become empty. That's going to cause them to go on the free list no matter what you set PCT_USED to. As the other reply implied, your main concern may be tables where, after the mass deletes, there are many blocks below the high water mark that are completely empty. This would take up a little disk space until they are filled, but the main concern would be that full table scans would take as long after the deletes as before, due to the need to read all blocks up to the high water mark (empty or full). So if that is a concern you could reorg the table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TWO-TASK SERVER ????
Hi Friends Iam getting this error frequently..So could you guys explain what's about it?? and What I need it do?? Mine is oracle8 on NT *** 2001.06.01.19.48.37.703 *** SESSION ID:(89.7330) 2001.06.01.19.48.37.703 FATAL ERROR IN TWO-TASK SERVER: error = 12571 *** 2001.06.01.19.48.37.703 ksedmp: internal or fatal error Current SQL information unavailable - no session. - Call Stack Trace - TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tree dump
Hi Gurus, My one of Index tree dump shows like this, I did't understand Where is leaves??? and what it means??? Wed Jun 6 12:59:58 2001 *** SESSION ID:(92.6948) 2001.06.06.12.59.58.000 - begin tree dump branch: 0x160105c4 369165764 (0: nrow: -24458, level: 70) - end tree dump TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PCTUSED??
Hi Gurus I have big growing tables has default PCT_USED 40%, But we delete data some times one year or 2yrs data. What is optimum value for this parameter?? I may consider my database is oltp. So how can decide a correct value for this??? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-600
Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
who locked table??
Hi Friends Does any body have script to see who locked the table and subsequently If needy to kill the user?? I had it but I want to update mine. TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: who locked table??
Thankyou very much Bala!! for your time and help. I will change my script, yeah I want to know in the same script who locked it and get sid and serial# too. Thankyou all who responded. From: Kumanan Balasundaram [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: who locked table?? Date: Fri, 1 Jun 2001 17:41:41 +0100 I created this statement to get all important details - use SID and Serial# to kill. Kumanan SELECT dbo.OWNER||'.'||dbo.OBJECT_NAME Object, dbo.OBJECT_TYPE, vs.SID, vs.SERIAL#, p.SPID OS_PROCESS, lo.PROCESS, lo.ORACLE_USERNAME, lo.OS_USER_NAME, vs.MACHINE, vs.PROGRAM, vs.SQL_ADDRESS FROM v$locked_object lo, dba_objects dbo, v$session vs, v$process p where lo.object_id = dbo.object_id and lo.SESSION_ID = vs.sid and vs.PADDR = p.ADDR order by sid -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: 01 June 2001 15:55 To: Multiple recipients of list ORACLE-L Subject:who locked table?? Hi Friends Does any body have script to see who locked the table and subsequently If needy to kill the user?? I had it but I want to update mine. TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Size, what is it?
I have 160Gb database size doing great with 150Mb of SGA, You are saying 700Mb SGA to support 150Gb database size?? Is there any white paper available for any criteria??? Let me know If you got any stuff. Thanks Raghu. From: Dave Morgan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Size, what is it? Date: Fri, 01 Jun 2001 09:41:11 -0800 Hi All, Being able to lift my head from the problems at my new job finally. I would like to get some definitions of what is a large database and the hardware that it is running on. There are multiple different types of large, transactions, physical size, number of objects, number of connections, SGA size, etc. My current database is a heavy transaction site but small in other respects. Oracle 8.1.7, 150GB physical size, 700MB SGA, 10 GB per day redo, 300-700 OLTP connections at any time all on a SUN E450, 2 CPU's, 4 GB RAM, Baydel disk array (RAID 3). The machine is relativiely idle, or I/O bound, memory starts becomming a limit above 700 connections. A previous large database was Oracle 8.0.5, 50 GB physical, associated with 4 TB of image files on the filesystem, 350 GB SGA, 2 GB per day redo, 100 DSS connections, all on a SUN E5000, 6 CPU's 6 GB RAM, many hardware RAID arrays, machine was CPU bound almost all the time. Most of the database I have seen have been on machines that are grossly over powered for the work that they do so I am hoping I can determine some figures for hardware vs workload based on real data. Your assistance would be appreciated. Please include as many details as possible including why you think it is a large database and machine utilization. Also, does anyone have experience with Baydel disk arrays. They seem to be a happening setup even if they are hardwired RAID 3 :( TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Restore from hot backup question
How about restoring your files from backup and recover database until time(befor loading) ?? From: Spragg, Mike [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Restore from hot backup question Date: Fri, 01 Jun 2001 10:41:15 -0800 I have an 8.0.5 data warehouse database in archivelog mode. We run a hot backup nightly and afterwards we run data loads. Last nights loads corrupted the database. I want to restore the database to the point immediately after last nights hot backup. I have never had to do this type of restore. Can I simply restore all the datafiles, redo logs control files from last nights backup and restart the database? Or is there more to it than that? Thanks - Mike Spragg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Spragg, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rebuilding indexes(simple way)
Hi Friends I have 20Gb Table with 3 indexes each 3,6,6Gb size. Recenly we deleted some 2 yrs data from it. So I want to rebuild the Indexes..Iam planning add some datafiles to it and just rebuild it, so that the new and old indexes fits easily. Is there any better way??? Thanks Raghu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Analyze table and locking
Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. Raghu. From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Analyze table and locking Date: Wed, 30 May 2001 03:21:46 -0800 All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
redo copy latch low??
Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: redo copy latch low??
Thanks jared!! and who responded. From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED], Raghu Kota [EMAIL PROTECTED] Subject: Re: redo copy latch low?? Date: Mon, 28 May 2001 10:22:41 -0700 Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May 2001 10:25, Raghu Kota wrote: Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Again Recovery
Hi Friends I want to test recovery on my AIX test box, Iam planning full recovery from Y'day night backup including Operating system. Next scenario is only Database recovery by restoring datafiles!! Could you shed some light on both scenarios, steps and precautions to take. I appreciate your comments very much. I have oracle version7.3 and AIX4.3 TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
recovery
Hi Friends I want to test my recovery on full backup on sunday, so My backup will be completed on sunday 9am, Iam recovering at 10.30, Then If I restore my full backup including operating system, So between 9-10.30am as Iam restoring from 9am backup, its going to overwrite the online redo's is it not?? am I able to restore full recovery or any problems??? Is any other scenario's to test backup?? Please respond.. TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tivoli??
Hi Friends Could you people shed some light on tool Tivoli, Like what is functionality,purpose and more. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
estimate of deleted data???
Hi Friends How can I estimate the how much data was deleted from a table correctly?? I have massive table from that application team will delete according to their invoices closing. So Is it better to take snapshot that table before and after deletion of data?? Is there any other better way to eastimate exactly how many bytes were deleted?? thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Windows vs. UNIX
Hi Roy There was whitepater on this, I forgot exact name, May be other members have it!! The paper name looks like ux-vs-nt!! I read once!! From: Roy Ferguson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Windows vs. UNIX Date: Mon, 30 Apr 2001 10:45:51 -0800 this is not to bring up a heated debate over the two platforms... I am making a proposal to move the current access 97 databases to an oralce platform running solaris I would like to put in the proposal a brief reason why a UNIX platform will be better than a Windows platform. the current environment: MS Access 97 databases running on Compaq server. Databases are about 20GB in size... proposed solution: Sun E3500 T3 Storage Array Solaris 8 Oracle 8i Just need a couple FACTS as to why one would choose UNIX over Windows Thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - temp tablespace growing constantly
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question on lists
Yeah for DB2 List go here and get register!!! http://www.ryci.com/db2-l. Best of luck Raghu. From: "Sharpe, Richard" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Question on lists Date: Thu, 19 Apr 2001 10:15:58 -0800 Hi I was wondering if anyone here knows of a DB2 list like this one, my company is getting a DB2 server running on OS390, so now I will have to support DB2 in addition to Oracle, Sybase and MS sqlserver this gets quite festive when you are the lone DBA. Thanks Rich Richard A Sharpe DBA Amherst Corporate Computer Sales and Solutions 40 Continental Blvd Merrimack, NH 03054 Phone: (603) 579-6180 / 800-431-8031 Fax: (603) 578-1072 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sharpe, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
purged data??
Hi Friends How can I calculate How much data is purged from a table?? TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Table rows??
Hi Friends I calculated the size of Table and HWM. How can I caluculate each row in bytes and total rows in bytes?/ How can I calculate holes in it due deletetion of sum rows TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
purged data??
Hi Friends How can I calculate How much data is purged from a table?? TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Deallocate unused??
Dear Friends For getting my space back from Big Tables Iam using ALTER TABLE table_name DEALLOCATE UNUSED. So my question is what exactly above HIGHWATERMARK and below HWM??? One table I got 300mg back and some 20mg, Could some body throw light on it. TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PCTUSED??
Hi Friends I am wondering you people can give me indepth about How storage is manipulated in frequent inserts and occationally mass delete!! works. My problem here is I have 20G table with 15G Indexes!!! We deleted 98,99 data!! So I want to avail that deleted space. How can I do that with out Export or any reoraganization??? Right now Iam using 40% as PCTUSED, SO last time I deleted some data, I used some space from deleted rows?? Actually what space Iam using Is it really using from deleted according to Oracle If its fall below PCTUSED and blocks referencing freelist so on???BTW my version is 7.3.4 on AIX. I appreciate your comments very much. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle start/stop scripts on AIX
AIX has same startup and shudwon scripts like Solaris. From: "Ruth Gramolini" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle start/stop scripts on AIX Date: Mon, 02 Apr 2001 08:35:22 -0800 I just use dbstart, the one that comes with Oracle. It works for us on AIX 4.2.1. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02, 2001 11:50 AM Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux, and Solaris. All of these support some form of automatic shutdown/startup scripts found in rc.d directorires, etc. I can not believe IBM AIX uses the /etc/inittab for the startup and you have to create a wrapper script for the shutdown. I found documentation on metalink note: 1019817.6, that describes this format. Has anyone found a better way, maybe to emulate the System V method? Thanks. Gene Sais -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- Canada and U.S. (was: oracle and America)
Excellent insite my friend, Your postive attitude helps many people in the country. From: "Boivin, Patrice J" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT -- Canada and U.S. (was: oracle and America) Date: Wed, 14 Mar 2001 12:21:38 -0800 Well, that's a bit of a flame, also coming from an anonymous Hotmail account I see. (Hotmail is always anonymous, although I believe the accounts can be traced) When I lived in Ottawa I used to know someone from Spain who talked about Canadians not being aggressive enough, people should fight their government, etc. etc. but look at the result - bombings, etc. and for many years, a dictatorship. Life is short, why waste time bashing each other over the head. Do what you can to leave a good mark, while you can. Violence doesn't solve anything, but I agree that sometimes situations are unbearable. Work through them. Economic disparities can cause major problems, I agree that's pretty obvious. But there are a lot of factors at _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
I agree with Kimberly, I don't why Canada simply following US?? I think Canada has every capacity to emerge as powerful nation. Simply following with out any backbone creates lot of problems in economy and society too. From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle and America Date: Wed, 14 Mar 2001 08:16:25 -0800 The sad part is the Canadian government feels compelled to follow the Americans are replacing some of their apps that ran on Unix to Windows. Actually, the app is an American one that they let us use. A lot of critical stuff is still on Unix. Then again, ours ships really don't need reliable stuff as we don't do anything except support:-) -Original Message- Sent: Tuesday, March 13, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Holy mackerel! I hope there isn't some rogue nation buying all our old VAX clusters to run their navy. We'll get our behinds kicked! - Jerry - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 10:06 AM On Tue, 13 Mar 2001, Boivin, Patrice J wrote: I thought I heard a story about a U.S. Navy ship that was towed to port because its systems ran on WindowsNT... Maybe it was an urban myth. I was glad to hear that the Boeing planes run on UNIX. ; ) Patrice Boivin Systems Analyst (Oracle Certified DBA) No myth this. ( yeth? ;) Here's a reference: http://www.gcn.com/archives/gcn/1998/july13/cov2.htm Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: quotes
Diana Yeah If you knew the fundamentals You can manage any thing, DB2 is cool, I worked as programmer before in Mainframes, Now Iam working as Oracle DBA, Iam much happier to work as Db2 DBA. Mainframes like a elephant, You can ride with stability!! Its wonderful environment. Another way you can switch either way some times Oracle and DB2 to explore more about yourself. Raghu. From: Diana Duncan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: quotes Date: Tue, 13 Mar 2001 07:25:41 -0800 Maybe now that I've become a damager and have a budget, I'm seriously considering kicking the Oracle habit. I think they and their ilk helped put a lot of dot-com's out of business through their predatory pricing. DB2 is looking very attractive...and I'm having tons of fun with Postgres at home. ;-) The thing is, there is no point in becoming married to any technology. Things change...and a good designer, programmer or DBA can transfer their skills easily, because to be GOOD you have to understand the fundamentals. Sorry, feeling philosophical today... Diana -Original Message- Sent: Tuesday, March 13, 2001 9:27 AM To: Multiple recipients of list ORACLE-L Isn't that utterly ridiculous. If you didn't call the 2nd server a "failover" server and just manually moved over the filesystems and net address, you wouldn't need a 2nd license! But if you automate the process with failover software, you do! The database and software are only ever going to be on one server at a time so what's the big deal? Oracle licensing has gotten so ridiculous that at our shop they've pretty much priced themselves out of the picture for all new databases. I suspect my managers aren't the only ones looking more seriously at SQL 2000 these days either. I'd look for Oracle to lose market share over the next 18 months. Not because SQL is better (it isn't), but the price performance ratio is much more acceptable. Dennis Taylor [EMAIL PROTECTED] wrote: Just got my oracle quote back. I had asked about backup servers and failover. To quote the salescritter, "In most cases where an environment requires a standby failover server, a license will be required..." Dennis Taylor The light at the end of the tunnel is the headlamp of an oncoming train. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or th! ! e 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! http://auctions.yahoo.com Auctions - Buy the things you want at great prices! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE[2]: Re-claiming the space from Table after deletion
Rafi Never cross PCTUSED + PCTFREE = 100%(Imporatant Rule), Ideally it should be below 75%. PCTUSED helps How your data is inseted?? If Insert oriented database, If your database is insert and Update oriendted You have to strike a balance between both of these parameters!! Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE[2]: Re-claiming the space from Table after deletion Date: Mon, 12 Mar 2001 02:30:20 -0800 Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: "Alex Hillman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: Discount for register the exam
You have to mention at the time of registring your exam the code "S36" and ask for concession, Then they will charge you instead of 125 usd, 100 usd. Raghu. From: "Gupta, Brijesh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Discount for register the exam Date: Mon, 12 Mar 2001 07:40:25 -0800 At the time of registration just mentioned that you are OTN member, thus eligible of discount. They will give it. But you will have to mention it. Thanks -Original Message- Sent: Sunday, March 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L I'd like to know the same thing as well. By the way, how do you get get the 20% OTN discount you mentioned? Thanks --- WENDY YUE [EMAIL PROTECTED] wrote: Hi, Gangs: I'm planning to take DBA Exam soon. Does anyone know how to get extra discount (besides 20% OTN discount) when register an exam? Thanks - Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re-claiming the space from Table after deleteion
Hi Rafi This is the problem many big databases facing!!If you clean up the database every year and reorganizing the database You would't have see this scenario. For the matter fact iam also facing same problem, My one table grown like 22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for getting what ever space I can avail. As you said you deleted 40% of data!! You can reorganize your Indexes to avail some space. Other wise Export to Tape and reimport it, But here again problem when you say compress=y, due to heavy data Its another big headche?? May be our friends give some ideas??? Thanks Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 01:56:07 -0800 Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: No record in import help me please :..(
Yeah, Its simple the two paramets giving you trouble!! show=y (it won't import any thing, It just show you it can work or not!!) destroy=y(Once you imported it, It will destroy the data of that copy) That is reason you can see the skipping...due to show=y Raghu. From: "John Hallas" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: No record in import help me please :..( Date: Mon, 05 Mar 2001 08:10:21 -0800 I believe the SHOW=Y parameter is causing the problem. That does not do an import but rather lists the table/index/grants etc details held on the export.dmp REmove that parameter and try the fromuser to user parameters or the full =y parameter John -Original Message- [EMAIL PROTECTED] Sent: 05 March 2001 14:45 To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y I export with this params.dat : exp sun/solaris parfile=/export/home/dba/myemp.dmp I've got messsges : . . exporting table EMP 7 rows exported 5. I check the file is exist and with -rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp 6. I chmod a+x myemp.dmp 7. teddy delete emp table : delete emp 7 rows deleted 8. when as sun I try to import : inside my imp_params.dat : FILE=/export/home/dba/myemp.dmp SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Expert Info???
Hi Friends Does any body can shed light on Oracle Expert??? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Baan with Oracle
Hi Friends The error is 2001-03-02[11:27:20]sfkecper: *** S T A R T of Log message *** 2001-03-02[11:27:20]sfkecper: Log message called from /port.6.1b.05.01/vobs/tt/l ib/al_1/al_strm.c: #495 keyword: strm 2001-03-02[11:27:20]sfkecper: Pid 107992 Uid 508 Euid 508 Gid 125 Egid 125 2001-03-02[11:27:20]sfkecper: user_type N language 2 user_name sfkecper tty ote locale ISO88591/NULL 2001-03-02[11:27:20]sfkecper: Errno 9 (Bad file number) bdb_errno 509 (Bad memor y cursor; bad table pointer specified) 2001-03-02[11:27:20]sfkecper: Log_mesg: sflush(): write error 2001-03-02[11:27:20]sfkecper: ** E N D of Log message ** Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBWR slaves in NT???
Hi Friends I have toad tool for my NT database DBWR Average Scan Depth 1024 **Number of DB_Files too high?? I got doubt due to from v$waitstat I got data block waits some time 8000 and some times higher number. How can I increase the DBWR slaves on NT?? although I set in development box, How can I see as background process really working for me?? I have my datafile and indexes same on E disk drive, My hit ratios are okay, My import is killing me. Any help appreciated. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBWR slaves in NT???
Hi Jesse Your insight is good, But due to all these problems(One controller) we could't enable archiving. So we are trying to reduce the overhead !! So the what ever minimum LGWR work will done okay...I think Iam correct Any way thanks to all people for understanding my problem Raghu. From: "Jesse, Rich" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: DBWR slaves in NT??? Date: Thu, 01 Mar 2001 12:27:14 -0800 H...I don't know how pounding a single drive with two threads instead of one would help, but it could be tried. I would think that the LGWR would be the big complainer in a 1-disk config, instead of the DBWR. Or at least I think LGWR would complain more often... My post was simply to point out that the error message in TOAD about "Number of DB_FILES set too high" was inaccurate. And as the "Tuning" stuff in TOAD has been redone, at least in the latest TOAD v7 Beta, this error message won't be a hassle too much longer. Long live Toadman Jim! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 14:09 To: Multiple recipients of list ORACLE-L Subject: RE: DBWR slaves in NT??? If I am completely off the wall here just slap me around a little bit. But couldn't you play with the init parameteres DBWR_IO_SLAVES or DB_WRITER_PROCESSES to help improve write performance? I mean, I agree with Ross, there is only one disk, but maybe it could help a little to help simulate asynchronous I/O? Kev Just thinkin out loud again! -Original Message- Sent: Thursday, March 01, 2001 2:31 PM To: Multiple recipients of list ORACLE-L Actually, that message is invalid for Oracle8 DBs. From what I can gather, the DB_FILES init.ora parameter only potentially affected DBWR performance in Oracle7. In Oracle8, it ain't true. Remember, the DBWRs write dirty buffers (data in memory that has been modified from it's counterpart in a datafile) from the buffer cache (memory) to the datafiles (disk). In O7, the DBWR I/O clump size, or how many dirty blocks could be written at once (also sometimes referred to as the DBWR's "internal write batch size"), was calculated as: DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2. In O8, the DBWR I/O clump size is static, and is different from platform to platform. Thus, for Oracle8, the advise to change DB_FILES is bogus. HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: After taking the Oracle8 Perf Tuning class, I think I know more than I do. Don't blame me for your (in)actions based on my opinion! -Original Message- Sent: Thursday, March 01, 2001 12:27 To: Multiple recipients of list ORACLE-L not a dbwriter problem. on a "single-disk wonder", your best bet is to DUMP all indexes on loadable tables, then load your data, then rebuild the indexes. of course, that might take just as long. any possiblity of getting more disk? like, several? a raid controller? mit gluck! -Original Message- Sent: Thursday, March 01, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Hi Friends I have toad tool for my NT database DBWR Average Scan Depth 1024 **Number of DB_Files too high?? I got doubt due to from v$waitstat I got data block waits some time 8000 and some times higher number. How can I increase the DBWR slaves on NT?? although I set in development box, How can I see as background process really working for me?? I have my datafile and indexes same on E disk drive, My hit ratios are okay, My import is killing me. Any help appreciated. Thanks Raghu. __ ___ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message has been scanned for viruses wit
STS software for oracle8
Hi Friends Does any body have STS software for oracle8, Please kindly send to this email address [EMAIL PROTECTED] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: obj$ table -- type column
a-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: this is the last thing we need
Yeah I don't think you will get any money due to these tax cuts..Its intented to rich people. I don't understand Instead of developing further of social net and Education system, I don't see any nice thing to cut taxes and draining the money from vital systems like federal spending either its defence,social security and education. From: Regina Harter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: this is the last thing we need Date: Fri, 16 Feb 2001 11:40:35 -0800 At 09:20 AM 2/16/01 -0800, you wrote: FLAME: ON "Bushy economy"? Give me a freaking break. At least now I have a chance to get MY money back. No more waiting *EIGHT* years for that "middle-class tax cut" that We were promised on TWO elections. Oh wait. I forget. I'm bad for wanting MY money back. I'm bad for wanting to buy a house to raise children in. I'm bad for wanting two vehicles so my wife doesn't have to drive me to/from work everyday. I'm a Conservative so naturally I want to "kill your babies" as the Democrats so eloquently put it. FLAME: OFF FLAME a little higher What makes you think you are going to get any money from that "BUSHY" tax cut? As far as I can tell, I'm going to get back that same $20 he is going to eliminate as federal taxes for the family of 4 making $26,000 a year. At that rate, we should have that 2nd car in about 50 years. FLAME off to save on the gas bill vent vent fume -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shutdown Abort...Open normal??
Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT:Clinton/the economy etc.
Wow You discovered Greatest truth BTW Iam a resident of Canada. Indians never talk about their selfish ends..They always has Big heart!! I think for some reason you pissed off with Indians, May be fear compition Cheer up man From: Dan Dasko [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT:Clinton/the economy etc. Date: Fri, 16 Feb 2001 13:01:25 -0800 Wow, look at all those H1s blowing Clinton's horn. Isn't it interesting. Not a single Indian rising to the GOPs defense. Could it be they're worried that the H1 gravy train will come screeching to an end? I think they're starting to believe their own press about how there aren't any Americans available and that they're all highly trained exceptional specimens of programming talent. Hardly. Jingo man. PS: or if they're in India, WTF are they doing presuming to have an opinion on the president of the United States of America?? PPS: Have a great day. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Dasko INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Indexes calculation??
Hi Gurus I have a big fat Indexes, I need to recalculate their storage clauses, What is best approach to calculate next extent, min extents and other stuff like pctfree and pctused. I hope mine is insert based database with 150gigs data, I need to set up pctused @30-40. Any body can threw light on it?? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sgadefbaanIV.dbf
Hi Gurus I don't know How this file generated by database, What is significance of this file?? Can I delete this file??? Is there any use ??? Thanks in advance Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: sgadefbaanIV.dbf
Thank you so much to all Gurus for indepth info. From: "Mohammad Rafiq" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: sgadefbaanIV.dbf Date: Fri, 09 Feb 2001 08:32:58 -0800 shutdown abort also removes in case your database crash ,connect internal and shutdown abort will remove it or alternately deletion is the only option. If it remains there, database will not start. Regards Rafiq To: "Mohammad Rafiq" [EMAIL PROTECTED],Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 9 Feb 2001 11:22:10 -0500 One other point, If you manually delete this file the DB will crash. To some good degree it totally disappears in 8i. Dick Goulet Reply Separator Author: "Mohammad Rafiq" [EMAIL PROTECTED] Date: 2/9/2001 7:35 AM No removal is required. It is generated as a result of your database and goes away when you shutdown database. Oracle uses this file in it dbstart script to check whether database is up or not. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 09 Feb 2001 06:31:11 -0800 Hi Gurus I don't know How this file generated by database, What is significance of this file?? Can I delete this file??? Is there any use ??? Thanks in advance Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
for SCSA
Hi Guys I want prepare for SCSA, Could you recommend any specific books for These two papers?? Thanks in advance Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix SysAdmin Book??
Hi Guys Could you suggest any Best book for System Administration and Shell Scripting for Solaris. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).