Best practice for backing out of Application Patches
Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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: Best practice for backing out of Application Patches
Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best practice for backing out of Application Patches
Thanks to Thomas Mercadante, Stephen Lee and Rick Cale for their responses. I think it's pretty unanimous that if this needs to be done, I would just restore to the point in time taken right before the patches were installed. Either I could do an export/restore/import or refresh from the production Database (As long as the problem was caught before getting put on the production Database). I just want to be covered from all angles before this application goes into production. Thanks again! -Scott Stefick At 12:14 PM 12/3/02 -0800, you wrote: Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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: Best Practice - Partitioned object, one partition per tablespace,
That is the recommended way. I have a 6 partition table with each partition in a different tablespace and each table space on a different drive. It's working well! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:48 PM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Ruth Gramolini 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: Best Practice - Partitioned object, one partition per tablesp
For any indexes on the table ,LOCAL prefixed indexes (b*tree/bitmap) is the preferred way to go ! -Original Message- Sent: Friday, September 27, 2002 7:18 AM To: Multiple recipients of list ORACLE-L tablespace, That is the recommended way. I have a 6 partition table with each partition in a different tablespace and each table space on a different drive. It's working well! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:48 PM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Ruth Gramolini 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.com -- Author: Kawatra V (Vikas) at Aera 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: Best Practice - Partitioned object, one partition per tablesp
Title: RE: Best Practice - Partitioned object, one partition per tablespace, exactly - in the warehouse I am working on we have so much data over so many partitioned ranges (for the benefits of partition elimination) that it didn't make sense to create a separate part. in each tablespace plus at some point there are limits to datafiles - so grouped partitions based on access/modifications expected (for readonly benefits) - etc. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 1:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: Best Practice - Partitioned object, one partition per tablespace, Another approach is to partition according to your load strategy, but make them reside in tablespaces according to how you want to set them to READ ONLY. For example, if you load daily, partition daily. But if you want to set the data into READ ONLY to reduce backup volumes on a quarterly basis, then put all of those daily partitions into quarterly tablespaces. So, each tablespace will have roughly 90-91 partitions for each table... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:48 AM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best Practice - Partitioned object, one partition per tablespace,
We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Best Practice - Partitioned object, one partition per tablesp
Title: RE: Best Practice - Partitioned object, one partition per tablespace, BTW, moving partitions from one tablespace to another is quick and easy so if later you have a real reason to have more tablespaces you can create them - our I/O configuration and access path did not warrant it at this time. -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Best Practice - Partitioned object, one partition per tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Best Practice - Partitioned object, one partition per tablesp
Robert - That is how I've generally done it. If you are partitioning because the table is very large, then separate tablespaces gives you the flexibility to place these partitions on separate devices so you can get some parallel I/O going. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablespace,
That's the way I've done it. It let's you drop a partition and drop the tablespace so nothing is left. --- Freeman, Robert [EMAIL PROTECTED] a écrit : We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Best Practice - Partitioned object, one partition per tablespace,
it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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: Best Practice - Partitioned object, one partition per tablesp
Title: RE: Best Practice - Partitioned object, one partition per tablespace, What if working on limited I/O so that striping is done at the OS level mostly. In this case there is no advantage to one partition - one tablespace and if there are many partitions it just gets hard to maintain. Partition elimination without separate I/O is the advantage of partitioning along with local indexes which is not dependent on the partitions tablespace. Therefore, I have grouped historical partitions into one tablespace then created separated tablespace on the most accessed partitions - say last 10 years. I find this easier to manage. -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Best Practice - Partitioned object, one partition per tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Best Practice - Partitioned object, one partition per tablesp
That's the strategy I have followed in my databases. Each table partition and each index partition is in its own tablespace. Helps me a lot when I do any maintenance operations. Partitioning is by 4 digit calendar year. - Kirti -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Deshpande, Kirti 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: Best Practice - Partitioned object, one partition per tablesp
Exactly the way we do it as well. Each table and index partition are in their own tablespaces (indexes are local and not global) Regards Lee -Original Message- Sent: 25 September 2002 20:54 To: Multiple recipients of list ORACLE-L tablespace, it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablespace,
We have a database which stores 5 years data with most of the tables partitioned on year_month. We have three tablespces each for each table, with tablespace_1 having 01,04,07,10 months and tablespace_2 having 2,5,8,11 and tablespace_3 having 3,6,9,12 --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Best Practice - Partitioned object, one partition per tablesp
placing them in different tablespaces also allows you to place older tablespaces into READ ONLY mode and reduce the volume of backups. also permits moving less-frequently accessed tablespaces to near-line storage, such as tape-based file-systems or CDROM... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:38 PM Robert - That is how I've generally done it. If you are partitioning because the table is very large, then separate tablespaces gives you the flexibility to place these partitions on separate devices so you can get some parallel I/O going. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablespace,
Another approach is to partition according to your load strategy, but make them reside in tablespaces according to how you want to set them to READ ONLY. For example, if you load daily, partition daily. But if you want to set the data into READ ONLY to reduce backup volumes on a quarterly basis, then put all of those daily partitions into quarterly tablespaces. So, each tablespace will have roughly 90-91 partitions for each table... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:48 AM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: What is best practice - differenet schema/different d
Mike, If that's the worst you guys/gals call me I'll be extremely flattered. Over the years I've had names tossed at me that are not normally usable in impolite society! :-) Dick Goulet Reply Separator Author: "Lanteigne; Mike" [EMAIL PROTECTED] Date: 3/28/2001 9:45 AM Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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). -- 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).
RE: What is best practice - differenet schema/different dbs
Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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).
RE: What is best practice - differenet schema/different dbs
Just my $.02. I agree separate tbs for different app schema's. However, I would separate applications to their own db, especially if they are 3rd party apps. You have much less control on COTS. Some run their install scripts as sys. I don't agree w/ it, but I am not going to rewrite their code, too many impt things to do. The additional db resources required for separate databases for different apps is worth it. If management wants more apps, then you tell them to buy more hardware. Now if you have complete control of all the apps (i.e. you develop them), then maybe I would put them in the same db. Big maybe :) Gene [EMAIL PROTECTED] 03/28/01 08:35AM Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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). -- 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).
RE: What is best practice - differenet schema/different dbs
Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, 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).
What is best practice - differenet schema/different dbs
List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each customer on the same machine or to create all the customers as different schema in one single database? What are the pros and cons. I am specifically looking at performance and security issues. Environment: This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7 with 4 CPUS. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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 best practice - differenet schema/different dbs
Hi Maheswara, I would think seperate databases would be the way to go, if for no other reason, you can bring one customer offline without affecting the others. -Rocky --- "Rao, Maheswara" [EMAIL PROTECTED] wrote: List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each customer on the same machine or to create all the customers as different schema in one single database? What are the pros and cons. I am specifically looking at performance and security issues. Environment: This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7 with 4 CPUS. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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 email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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 best practice - differenet schema/different dbs
Having separate databases gives you some flexibility. You can manage them separatly, for instance you can upgrade the database to a newer version in phase. Also, if you lose a database only one customer is affected. Do all the customers always use the same application (same version)? If one customer wants to use the latest version of the application (perhaps for a feature they have long been waiting for) when it become available and requires the latest version of Oracle and the rest of the customers want to stick with the old version, then you have to put them into separate databases. On the other hand, separate databases means more database to manage. So the answer is depends on your situtaion. Richard --- "Rao, Maheswara" [EMAIL PROTECTED] wrote: List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each customer on the same machine or to create all the customers as different schema in one single database? What are the pros and cons. I am specifically looking at performance and security issues. Environment: This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7 with 4 CPUS. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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 email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: Richard Ji 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 best practice - differenet schema/different dbs
Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet Reply Separator Author: "Rao; Maheswara" [EMAIL PROTECTED] Date: 3/27/2001 8:15 AM List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each customer on the same machine or to create all the customers as different schema in one single database? What are the pros and cons. I am specifically looking at performance and security issues. Environment: This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7 with 4 CPUS. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: 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: Best Practice ?
Hi ! It all depends on your OPTIMIZER_MODE. I guess you will be using CHOOSE and if that is the case I would recommend analyzing the tables indexes (or ANALYZE_SCHEMA) for + or - 10 % change. - Original Message - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 5:48 PM For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ? Should the Tables be Analyzed OR Not ? This is a Application with More OLTP than Batch ( Banking Product ) Think you know someone who can answer the above question? Forward it to them! 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 _ 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).
Best Practice ?
For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ? Should the Tables be Analyzed OR Not ? This is a Application with More OLTP than Batch ( Banking Product ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).