Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!j27g2000cwj.googlegroups.com!not-for-mail
From: sangu_rao@yahoo.co.in
Newsgroups: comp.databases.oracle.server
Subject: How to achieve Parallel execution on Tables and SP's
Date: 1 Feb 2007 22:25:18 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <1170397517.583914.21120@j27g2000cwj.googlegroups.com>
NNTP-Posting-Host: 59.160.136.226
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170397523 9013 127.0.0.1 (2 Feb 2007 06:25:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 06:25:23 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j27g2000cwj.googlegroups.com; posting-host=59.160.136.226;
   posting-account=DClaMA0AAACDZOdfX9k3HcXfDfPvopR0
Xref: news.f.de.plusline.net comp.databases.oracle.server:193483

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