Newsgroups: comp.databases.oracle.server Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!news.tiscali.de!newsfeed.freenet.de!newsfeed.kamp.net!newsfeed.kamp.net!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: How to achieve Parallel execution on Tables and SP's In-Reply-To: <1170397517.583914.21120@j27g2000cwj.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-76.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1170397517.583914.21120@j27g2000cwj.googlegroups.com> Mime-Version: 1.0 Date: Fri, 2 Feb 2007 15:30:42 GMT Lines: 44 Xref: news.f.de.plusline.net comp.databases.oracle.server:193505 sangu_rao@yahoo.co.in wrote: > Hi, > I want to know how Oracle will handle Parallel execution and > synchronization on Table and SP's when multiple sessions are accessing > the same object. > For example I have one SP called Test_SP and this SP gets executed by > 2 different sessions at same time. The Test_SP contains few DML > operations like Deleting rows from a table and some Inserts. In this > scenario how we can achieve parallelism and synchronization such that > multiple sessions can access them in Parallel for producing good > performance gains. Also when we use GLOBAL TEMPORARY Tables with ON > DELETE CASCADE option will it provide Synchronization and parallelism > automatically or de we need to set any parameters explicitly. Please > provide your comments, this is very much needed for my project > requirements. > > Thanks > Rao > It does not matter if the INSERT or DELETE statements are in a stored procedure or outside of one. They all follow the same transactional control rules. So a good understanding of how handles transactions is necessary. Start with the following: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm Pay close attention to Chapters 4 and 13. HTH, Brian -- =================================================================== Brian Peasland dba@nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown