Home » SQL & PL/SQL » SQL & PL/SQL » Information regarding dml operations (oracle 10g,win xp)
Information regarding dml operations [message #320877] Fri, 16 May 2008 09:55 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Hi All

Can anyone tell me


1. what is the use of set transaction use rollback segment
2. I want to use parallel dml and ddl in some create index,create table,deleet and update statements but how can i exactly figure out
what degree of parallelism and instance to use
to keep in mind the tables do not contain any partitions.

Many thanks.
Re: Information regarding dml operations [message #320880 is a reply to message #320877] Fri, 16 May 2008 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1. SET TRANSACTION
It should be no use in 10g as you should use undo tablespace.

Regards
Michel
Re: Information regarding dml operations [message #320885 is a reply to message #320877] Fri, 16 May 2008 10:34 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
It should be no use in 10g as you should use undo tablespace.

Can you be a bit more specif,i can't figure out the exact meaning of the above statement.why it cannot be useful in oracle 10g??

what will benifit from undo tablespace
Re: Information regarding dml operations [message #320886 is a reply to message #320877] Fri, 16 May 2008 10:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
undo segments <> rollback segments
Re: Information regarding dml operations [message #320887 is a reply to message #320885] Fri, 16 May 2008 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Concepts
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Segments
Subsection Introduction to Automatic Undo Management

Regards
Michel
Re: Information regarding dml operations [message #321258 is a reply to message #320877] Mon, 19 May 2008 12:04 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Many thanks for the above information.

Can anyone tell me about the 2nd point that i had asked?

2. I want to use parallel dml and ddl in some create index,create table,deleet and update statements but how can i exactly figure out
what degree of parallelism and instance to use
to keep in mind the tables do not contain any partitions.


Thanks
Re: Information regarding dml operations [message #321279 is a reply to message #321258] Mon, 19 May 2008 13:38 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Hi All,apologies for repeating the question,but why i am not getting any response in this?
Re: Information regarding dml operations [message #321281 is a reply to message #321279] Mon, 19 May 2008 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You did not get any answer because it depends on so many parameters then there is no answer.
disks, disk controller, cpu, memory, worload, concurrent transactions, concurrent programs are some of the parameters.

Regards
Michel
Re: Information regarding dml operations [message #321330 is a reply to message #320877] Mon, 19 May 2008 21:38 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
So in that case can a degree 4 and instance 1 be specified in general and all cases
Re: Information regarding dml operations [message #321332 is a reply to message #320877] Mon, 19 May 2008 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can a degree 4 and instance 1 be specified in general and all cases
Rather than simply using arbitrary values, why don't you run some actual benchmark test runs to determine measurable results.
Re: Information regarding dml operations [message #321358 is a reply to message #321330] Tue, 20 May 2008 01:03 Go to previous message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
swas_fly wrote on Tue, 20 May 2008 04:38
So in that case can a degree 4 and instance 1 be specified in general and all cases

No, the definitive value is 42.

Regards
Michel

Previous Topic: chr() + tab space + xls file format
Next Topic: ORA-22160: element at index [2] does not exist
Goto Forum:
  


Current Time: Sat Nov 09 15:51:12 CST 2024