SAME and separating disk and index tablespaces
Guys, Does it make sense to separate data and index segments into separate tablespaces if you create a single logical volume and all files are striped using the SAME methodology ? Thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAME and separating disk and index tablespaces
Thanks Gaja ! Does it also make sense from a performance perspective (I/O issues due to concurrent access of index and data ) to separate them or is that point moot once you apply the SAME methodology ? -Original Message- Gaja Krishna Vaidyanatha Sent: Wednesday, October 08, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Vikas, The answer is an enthusiastic yes. This is purely from an administrative and manageability standpoint. For example, if you have INDEX and DATA segments separated in 2 different tablespaces, the backup of these tablespaces can be done INDEPENDENTLY. This is relevant, as if you were to rebuild your indexes using the NOLOGGING option between 2 backup jobs. If that were the case, then all you will need to do after the rebuild is complete, is to backup only the INDX tablespace. This is a best practice (if not a requirement) in most production shops, unless you think you can re-re-build your indexes in the event of media failure and you lose your INDX tablespace. Hope that helps, Gaja --- vikas kawatra [EMAIL PROTECTED] wrote: Guys, Does it make sense to separate data and index segments into separate tablespaces if you create a single logical volume and all files are striped using the SAME methodology ? Thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] = Gaja Krishna Vaidyanatha Principal Technical Product Manager, Application Performance Management, Veritas Corporation E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 Website: http://www.veritas.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAME and separating disk and index tablespaces
, as if you were to rebuild your indexes using the NOLOGGING option between 2 backup jobs. If that were the case, then all you will need to do after the rebuild is complete, is to backup only the INDX tablespace. This is a best practice (if not a requirement) in most production shops, unless you think you can re-re-build your indexes in the event of media failure and you lose your INDX tablespace. Hope that helps, Gaja --- vikas kawatra [EMAIL PROTECTED] wrote: Guys, Does it make sense to separate data and index segments into separate tablespaces if you create a single logical volume and all files are striped using the SAME methodology ? Thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] = Gaja Krishna Vaidyanatha Principal Technical Product Manager, Application Performance Management, Veritas Corporation E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 Website: http://www.veritas.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gaja Krishna Vaidyanatha Principal Technical Product Manager, Application Performance Management, Veritas Corporation E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 Website: http://www.veritas.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Hau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fast Refresh of Materialized views
We've noticed that our fast refresh takes longer than complete refresh - and that's puzzling .We have MV logs based on the PK of the FACT table - and the MV's are JOIN ONLY . Any suggestions would be welcome ! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Fast Refresh of Materialized views
How do I find out if that is the case .The no of new inserts/updates is much lesser than the total no of rows in the tables.So why would the fast refresh take longer . Can we index the MV logs to speed up the process. vikas -Original Message- Sent: Tuesday, August 28, 2001 4:11 PM To: Multiple recipients of list ORACLE-L It may be that your fast refresh is actually doing a lot of work. This would happen if many rows in the source table were changed. If 99% of the rows changed, then a complete refresh will be faster, because you don't have the added overhead of reading the logs to determine which rows to refresh - you just refresh them all. If only 1% of the rows changed then the fast refresh will indeed be fast - faster than a complete refresh. Somewhere in between there's a break even point. It may be that many rows have changed - enough to take you past the break even point. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 3:00 PM We've noticed that our fast refresh takes longer than complete refresh - and that's puzzling .We have MV logs based on the PK of the FACT table - and the MV's are JOIN ONLY . Any suggestions would be welcome ! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: linux Oracle -- best combination
We're trying to re-write some SQL such that the index on columns in the where clause is used.Logically ,the query is as below .But this query does not use the Index .However ,if we re-write it as below(see 2nd query) - the index is used :but the query returns incorrect results .Can you suggest any changes to the original query? note : 1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date 2)We want to return rows from the table even if all columns in where clause are NULL Thanks vikas SELECT friendly_session_id, cmm_id, cust_id, hold_amount, virtual_balance_amount, creation_date, session_id FROM sals_session WHERE ( CMM_ID = '101' or cmm_id IS NULL ) AND ( CUST_ID =101 or cust_id IS NULL ) AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL ) AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between '21-JUN-2001' and '21-AUG-2001'); SELECT friendly_session_id, cmm_id, cust_id, hold_amount, virtual_balance_amount, creation_date, session_id FROM sals_session WHERE cmm_id = nvl(cmm_id,0) AND cust_id = nvl(cust_id,0) AND friendly_session_id =nvl(friendly_session_id ,0) AND (creation_date is NULL OR loc_to_utc(creation_date) between '21-JUN-2001' and '21-AUG-2001'); -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Setting PCTFREE PCTUSED in a Datawarehouse
I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Setting PCTFREE PCTUSED in a Datawarehouse
Thanks Lisa ! -Original Message- Sent: Friday, June 29, 2001 10:21 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Hi Vikas, The docs should have discussed the reason why. High pctused can lead to a block going on and off the freelist frequently as deletes/inserts are processed, and also can leave the amount of free space inadequate for a new insert (your avg_rowlen comes into play here). So what you'd end up with is several blocks on the freelist that don't have enough free space for an insert, and every time an insert is processed it goes thorugh the freelist and checks for space in the block. The performance hit comes when too many blocks have to be checked for adequate space. Does that make sense? Now some people on this list have debated that PCTFREE/PCTUSED is so low level and that performance really is not affected that much. Of course Ross was one of those people (amen, my brother) HTH Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Friday, June 29, 2001 11:42 AM To: Multiple recipients of list ORACLE-L I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Vikas Kawatra 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: Vikas Kawatra 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).
Scripts to monitor databases
I'm trying to compile a set of scripts for daily health check of all our databases .I would like to set these up as jobs in OEM or as cron jobs to run every morning. I am sure many of you have scripts that WORK - such as for tablespace storage /fragmentation , user audit , poor SQL , database performance stats etc - Can you guys recommend good scripts /URL's etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Scripts to monitor databases
I'm trying to compile a set of scripts for daily health check of all our databases .I would like to set these up as jobs in OEM or as cron jobs to run every morning. I am sure many of you have scripts that WORK - such as for tablespace storage /fragmentation , user audit , poor SQL , database performance stats etc - Can you guys recommend good scripts /URL's etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Moving tablespace across disks
Do I need to make the tablespace READONLY before cpying it to another disk location - ora can I simply - take the file offline - and copy the file across -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Migration of a database from MS Access to ORACLE
Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE objects which need to be moved too. Any help would be appreciated ! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Listener problem
I was wondering if you could help me debug a problem. I have the following tnsnames on an app server. And when the primary listener is down it does not attempt to connect to the second address. was.world= (description = (load_balance=off) (failover=on) (address=(protocol=tcp)(port=1521)(host=tpdapp2)) (address=(protocol=tcp)(port=1521)(host=tpdweb2)) (connect_data=(service_name=was.world)) ) Doing a tnsping from an appserver reports: Attempting to contact (address=(protocol=tcp)(port=1521)(host=tpdapp2)) TNS-12541: TNS:no listener But yet from that same appserver I can connect to the database on the second server by fully qualifying the connect string: (tpdapp1)# sqlplus ejsadmin/ejsadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tpdweb2)(PORT=15 21))(CONNECT_DATA=(SERVICE_NAME=WAS.world))) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Migrating from 8.1.6 to 8.1.7
I get an error when migrating from 8.1.6 to 8.1.7 on a Sun box. After editing the /var/opt/oracle for the fbs to the new Oracle Home - when I attempt to start svrmgrl - i get an error below: ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol kgsmp789_compat_: referenced symbol not found Killed the .profile for the oracle user - is as below. Can some one help thanks vikas PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:.:/usr/openwi n/bin export PATH # # - Oracle related items go here - assume ksh on export command. Keep version neutral! # export ORAENV_ASK=NO export ORACLE_SID=APSVt3 . oraenv export ORAENV_ASK=YES export CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/assista nts/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/owm/jlib:$ORACLE_HOME/plsq l/jlib:$ORACLE_HOME/rdbms/jlib export ORACLE_BASE=/u01/app/oracle export LD_LIBRARY_PATH=$ORACLE_HOME/lib export TNS_ADMIN=$ORACLE_HOME/network/admin export ORATAB=/var/opt/oracle # # OWA Server (oracle stub - not a databse home) # export ORAWEB_BASE=/u06/app/oracle export ORAWEB_HOME=/u06/app/oracle/product/8.1.6 export ORAWEB_ADMIN=/u06/app/oracle/product/8.1.6/listener export ORAWEB_HOME=/u06/app/oracle/product/8.1.6 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: OEM 2.1 cannot contact agent on a node
* Stop the agent on the remote node * delete all the q files * on the OEM side , remove all the databases from the node in question. * start agent on the remote node * rediscover the node on OEM The steps above should solve the problem vikas InnoVentry Inc 680 2nd Street San Francisco CA -94107 Tel: 415-972-1045 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: How to prevent oracle from committing a transaction?
What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Vikas Kawatra 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: On the question of What is a Large Database Anyway ?
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Vikas Kawatra 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).
Point in Time recovery required !!
Our developers need the dbs to be restored to 6 am today morning - as they deleted some important table. Now we have no EXPORTS , the dbs is in archive mode - so we though it would be easy to restore and do a point in time recovery - only to find that our backup guy had configured the tapes to be overwritten - so we have no HOT backup now ... We have no cold backups - I'm trying to figure out if we can use the LOGMINER - to do any recovery !! Any Suggestions /help would be welcome !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: On the question of What is a Large Database Anyway ?
Thanks for the offer to help ! I just completed log mining the data successfully - from the archive logs - I was able to generate the UNDO SQL and execute it on the dbs to bring it to a state prior to the updates/deletes etc on the table thanks vikas -Original Message- Sent: Friday, June 01, 2001 5:06 PM To: Multiple recipients of list ORACLE-L I just got back from a little seminar from Quest with Gaja Krishna Vaidyanatha and if he was dead (he's not that I'm aware of) he would be rolling in his grave about your comments on hit rates and SGA sizes. His new book 101 Oracle Performance Tuning will stress that you abandon those hit rates and focus on V$SYSTEM_EVENT, V$SESSION_EVENT and V$SESSION_WAIT in combination with CPU and IO stats. He states that Oracle is rather well designed for physical IO. His presentation was great and I'm definatley going to buy his book because I can learn something from this guy. So maybe those small SGA's aren't so bad after all :) http://www.amazon.com/exec/obidos/ASIN/0072131454/o/qid=991436418/sr=2-1/ref =aps_sr_b_1_1/002-4814740-2092864 - Ethan Post -Original Message- Sent: Friday, June 01, 2001 4:35 PM To: Multiple recipients of list ORACLE-L As most everyone has said so far Its all subjective. What is large to me is a dinky little thing to someone else. Right now at my current job we have around 37 instances on 4 mchines with 2 GB or less of memory and 2 - 4 processors each. These DBs range from a 10 MB to a 70 MB SGA (yes, sounded real small to me when I got here also). These databases are all in the realm of 60 - 100 GB of data each. My last job we had 2 machines running 4 instances. These DBs had SGAs from 350 MB to 980 MB in size with 4 CPUs using 4 GB of memory. As far as size goes, we had upwards of a Terrabyte of data. To me, I have found that I have to treat both setups the same. They really do have the same problems (space, hit rates, drive failures, hardware failures, etc.) You just have to pay closer attention to certain aspects of them differently. With the small SGAs we have to look real close at hit rates and all the Memory Dependent aspects of the DB. With the large amount of data on the other DB we had to look more closely at Data and file related problems. All I am trying to say is . its all subjective. Kevin -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Vikas Kawatra 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: Point in Time recovery required !!
The issue was not dropping of tables - but DML on the tables - I was able to generate the UNDO SQL and execute it on the dbs to bring it to a state prior to the updates/deletes etc on the table thanks vikas -Original Message- Sent: Friday, June 01, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Vikas, re-reading your note, it appears you have tables that were dropped? logminer will not help you in that respect(at least not until 9i, when you have undo tablespaces and query flashback). joe Vikas Kawatra wrote: Our developers need the dbs to be restored to 6 am today morning - as they deleted some important table. Now we have no EXPORTS , the dbs is in archive mode - so we though it would be easy to restore and do a point in time recovery - only to find that our backup guy had configured the tapes to be overwritten - so we have no HOT backup now ... We have no cold backups - I'm trying to figure out if we can use the LOGMINER - to do any recovery !! Any Suggestions /help would be welcome !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Replicating data from SYBASE to ORACLE
Thanks I have been reading up on the sybase replication I am not very hopeful though ! Concerns include the maturity of the product for replicating to 8.1.6 ,performance ,complexity etc vikas -Original Message- Sent: Thursday, May 31, 2001 12:01 AM To: Multiple recipients of list ORACLE-L You really should check into Sybase Replication. Very powerful ( and complex ) replication product. It can replicate Sybase to Oracle. Jared On Wednesday 30 May 2001 18:25, Vikas Kawatra wrote: Anyone have any ideas about replicating data from SYBASE tables to ORACLE in real-time - We have two systems running in parallel - an old SYBASE system - along side a new (pilot) sytem in oracle .We 're trying to figure out the best way to replicate transactions that get recorded in the sybase database -to the oracle database- to keep them in synch. I've heard of a dbQueue messaging system in SYBASE - which may be a way to do this - I have limited SYBASE exp - so I was wondering if there are any ideas out there thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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 NAMES /LDAP
Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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 NAMES /LDAP
Thanks ! A very useful link ! -Original Message- Sent: Thursday, May 31, 2001 7:07 AM To: Multiple recipients of list ORACLE-L Vikas Kawatra wrote: Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas Check out the latest Oracle Magazine for an article by Jonathan Gennick on using Oracle Names as an LDAP proxy. Its available at http://www.oracle.com/oramag/oracle/01-may/index.html?o31ldap.html hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Vikas Kawatra 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).
Installing Oracle on UNIX
We have oracle 8.1.6 installed on our SUN server .As part of the upgrade process to 8.1.7 (we decided to install into a new HOME)- I staged the 2 CD's into one of our free disks (not the existing oracle home) .Now to run the Installer - I took the following steps: cd $ORACLE_HOME ( obviously the existing home 8.1.6) ./runInstaller This brings up the installer - but when I get to the screen where I need to select the source and the destination for the new oracle home - It doesn't allow me to select the NEW staging area or the NEW Oracle Home destination - where I want the new software .I cannot even browse to the new source /destination locations ?? Any help to figure this out will be appreciated !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Installing Oracle on UNIX
Thanks Holman ! I was able to rsolve it by running the installer from the staging area on DISK -where I copied the 8.1.7 CD .I was running the installer from my 8.1.6 HOME - and hence the problems -Original Message- Sent: Wednesday, May 30, 2001 4:10 PM To: Multiple recipients of list ORACLE-L You need to execute the runInstaller.sh script from a location other than the CD. ie: /export/home/oracle$ /cdrom/runInstaller.sh Your device is locked since you are physically in the device where you started from. This is documented in Metalink, but not in the readme docs that come with the CD. HTH Rodd Holman -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/30/01 5:29 PM We have oracle 8.1.6 installed on our SUN server .As part of the upgrade process to 8.1.7 (we decided to install into a new HOME)- I staged the 2 CD's into one of our free disks (not the existing oracle home) .Now to run the Installer - I took the following steps: cd $ORACLE_HOME ( obviously the existing home 8.1.6) ./runInstaller This brings up the installer - but when I get to the screen where I need to select the source and the destination for the new oracle home - It doesn't allow me to select the NEW staging area or the NEW Oracle Home destination - where I want the new software .I cannot even browse to the new source /destination locations ?? Any help to figure this out will be appreciated !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Holman, Rodney 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: Vikas Kawatra 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: NOLOGGING/LOGGING
Thanks Rajaram ! Here's the bottom line : NOLOGGING doesn't apply to conventional DML at all ! It applies only to CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader or INSERT as SELECT -Original Message- Sent: Monday, May 14, 2001 10:56 AM To: Multiple recipients of list ORACLE-L There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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: Vikas Kawatra 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).
Reverse key indexes
Reverse key indexes are good for columns populated by sequence no's Does that mean that for surrogate Primary key's on OLTP systems - which are populated by sequences - performance could be enhanced by creation reverse key indexes - rather than using the B*Tree unique indexes which are automatically created by Oracle. vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Reverse key indexes
Thanks Jared ! What I read makes a lot of sense- But what suprises me is - that I haven't come across anyone really using Reverse key indexes for Synthetic (surrogate Primary keys). Have you ? vikas -Original Message- Sent: Friday, May 11, 2001 11:42 PM To: [EMAIL PROTECTED]; Vikas Kawatra Rather than re-invent the wheel, I'll let Steve Adams explain it. Besides, his explanation is better than the one I was going to give. :) http://www.ixora.com.au/tips/design/synthetic_keys.htm Jared On Friday 11 May 2001 23:55, Vikas Kawatra wrote: Reverse key indexes are good for columns populated by sequence no's Does that mean that for surrogate Primary key's on OLTP systems - which are populated by sequences - performance could be enhanced by creation reverse key indexes - rather than using the B*Tree unique indexes which are automatically created by Oracle. vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Turning off redo logging
If I use NOLOGGING as part of a CREATE TABLE or INDEX - it means that I don't want the creation of these objects logged. However , say I want to turn off the logging for conventional Inserts - through transactions - how can I do that ? vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
Updating a table :Using dynamically generated table_Names
can someone tell me a way to select all tables from multiple schemas -
and then update records in each of these tables based on a certain criterea.
I wrote a script below - which explains logically what I need to do - but I
don't think I can use a cursor output in the UPDATE as I have below.
Suggestions ?
thanks
vikas
DECLARE
CURSOR cuTab IS
SELECT table_name,column_name
FROM dba_tab_columns
WHERE column_name ='END_DATE'
AND owner='CIS';
recCuTab cuTab%ROWTYPE;
BEGIN
FOR recCuTab IN cuTab LOOP
UPDATE recCuTab.table_name --Get an error here !!
SET end_date = TO_DATE('4712-12-31','-MM-DD')
WHERE end_date TO_DATE('12-31-4712','mm-dd-')
AND end_date
TO_DATE('1-1-4712','mm-dd-');
END LOOP;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Kawatra
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: Cool way to crash an Oracle database, any time, any place
What the heck do the following commands do ?? -Original Message- Sent: Wednesday, May 09, 2001 9:01 AM To: Multiple recipients of list ORACLE-L You want to crash the server? On any Unix box, execute the following four commands: echo './t.sh ' t.sh echo './t.sh ' t.sh chmod 777 t.sh ./t.sh Don't even need special privileges to ruin everyone's day... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- Sent: Tuesday, May 08, 2001 11:23 AM To: Multiple recipients of list ORACLE-L Back a few years ago I remember being able to crash a NetWare server (4.x I think) running an early version of Oracle7 just by running some syntactically incorrect SQL. Yup, that not only crashed the database, but also the server. Henry -Original Message- Sent: Tuesday, May 08, 2001 9:37 AM To: Multiple recipients of list ORACLE-L Hi Jared, Nope, not direct mode. The table contains a couple of CLOB columns. Haven't heard back from Oracle yet, but you're right, it is kind of scary. We were planning on using this environment for hosting some of our more active web sites. --Walt -Original Message- Sent: Monday, May 07, 2001 5:59 PM To: [EMAIL PROTECTED]; Weaver, Walt Walt, What's scary about this is not just that you've managed to crash the database by very innocent means, but we don't know how else this bug can be invoked. It could be something equally innocuous. Q: Are you loading in direct mode? Jared On Monday 07 May 2001 16:20, Weaver, Walt wrote: Just thought I'd share what I learned today with everyone. This is Oracle 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from MySQL to Oracle, using Sqlloader to load the data into Oracle. In one table I have the following column: C$NOTES VARCHAR2(4000) In my Sqlloader script I have an entry: C$NOTES CHAR(4000) When I ran Sqlloader about 130 out of 35,000 rows were not loaded due to a inserted value too large for column error on C$NOTES. So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(4). When I run Sqlloader for the table with this value, it crashes the database every time with an ORA-600 [4620] [] [] [] [] [] error. Every dang time. Pmon just gives up the ghost, man. Shuts the door and turns off the lights. Dies a horrible death. Now, obviously I created this problem myself, but it seems to me that Oracle should be able to handle this a bit more gracefully than it does. :) Anybody else ever see this? I've logged an iTar on MetaMidget to inform the authorities of the problem. My cursory search on MetaMidget uncovered absolutely no evidenct that anyone knows about this. --Walt Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Henry Poras 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: Norrell, Brian 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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Inserts slowing down on OLTP systems
What specific events should I look for in these tables ! - atleast the imp ones - And What's a block split ? vikas -Original Message- Sent: Tuesday, May 08, 2001 6:32 AM To: Multiple recipients of list ORACLE-L instead of checking hit ratios, try looking at wait events in v$session_event, v$system_event and v$session_wait. also -- how many indexes are on these tables? How much data is in the tables? If the indexes are doing constant block splits on the insert you are basically rebuilding the index each time.. this can have a major impact on performance. Rachel From: Vikas Kawatra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Inserts slowing down on OLTP systems Date: Mon, 07 May 2001 16:55:28 -0800 Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: 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: Vikas Kawatra 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).
Inserts slowing down on OLTP systems
Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
