| Information regarding dml operations [message #320877] |
Fri, 16 May 2008 09:55  |
swas_fly
Messages: 150
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  |
Michel Cadot
Messages: 17605
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
swas_fly
Messages: 150
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 |
anacedent
Messages: 6182
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
|
undo segments <> rollback segments
|
|
|
|
| Re: Information regarding dml operations [message #321258 is a reply to message #320877 ] |
Mon, 19 May 2008 12:04 |
swas_fly
Messages: 150
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 |
swas_fly
Messages: 150
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 |
Michel Cadot
Messages: 17605
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
swas_fly
Messages: 150
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 |
anacedent
Messages: 6182
Registered: July 2005
Location: surf meets turf in 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 |
Michel Cadot
Messages: 17605
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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
|
|
|
]
Members
Search
Help
Register
Login
Home
