OraFAQ Forum: Server Administration » "How to test row movement" & "partition issue" merged

Home » RDBMS Server » Server Administration » "How to test row movement" & "partition issue" merged (11.2.0.1.0 Windos XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"How to test row movement" & "partition issue" merged [message #522142]

Tue, 06 September 2011 20:37

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
How to test row movement? I want to a row data reside in two different blocks. how to do the test?

[Updated on: Wed, 07 September 2011 03:59] by Moderator

Report message to a moderator

Re: How to test row movement [message #522143 is a reply to message #522142]

Tue, 06 September 2011 20:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://forums.oracle.com/forums/thread.jspa?threadID=2279392&tstart=0

Report message to a moderator

partition issue [message #522144 is a reply to message #522142]

Tue, 06 September 2011 21:22

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I was confused by table partition, does a same blocks can contain two differrent partition-key rows?

Report message to a moderator

Re: partition issue [message #522145 is a reply to message #522144]

Tue, 06 September 2011 21:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I was confused by table partition, does a same blocks can contain two differrent partition-key rows?
I am confused by question.
A block can only exist within single segment.

Report message to a moderator

Re: partition issue [message #522146 is a reply to message #522145]

Tue, 06 September 2011 21:47

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
There a partition table,the partition-key is id,my issue is whether a block can restore two rows of different id?
That means: Does partition table can isolate blocks(means block-partition)?

Report message to a moderator

Re: partition issue [message #522147 is a reply to message #522146]

Tue, 06 September 2011 22:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post DDL for partitioned test table
post DML for test data
dump data blocks so see answer yourself.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to test row movement [message #522155 is a reply to message #522142]

Wed, 07 September 2011 00:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Explain your question.
Which issue are you trying to solve?

Regards
Michel

Report message to a moderator

Re: partition issue [message #522156 is a reply to message #522146]

Wed, 07 September 2011 01:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

There a partition table,the partition-key is id,my issue is whether a block can restore two rows of different id?

Yes or no, depending on your partition definition.
A block can contains rows of the same partition (which is the same segment) but not 2 rows of different partitions (which are 2 different segments).

Regards
Michel

Report message to a moderator

Re: How to test row movement [message #522157 is a reply to message #522155]

Wed, 07 September 2011 01:08

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
I just want to know whether it is correct: partitioned table means the blocks have partitioned? A sanme block can not restore two different partition-key rows?

Report message to a moderator

Re: How to test row movement [message #522163 is a reply to message #522157]

Wed, 07 September 2011 01:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

partitioned table means the blocks have partitioned?

No, it means the table is partitioned.

Quote:

A sanme block can not restore two different partition-key rows?

I answered this in this other topic you created in the end for the same question.

Regards
Michel

Report message to a moderator

Re: How to test row movement [message #522190 is a reply to message #522163]

Wed, 07 September 2011 03:58

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks a lot!

Report message to a moderator

Re: partition issue [message #522349 is a reply to message #522144]

Thu, 08 September 2011 14:45

msol25
Messages: 396
Registered: June 2011

Senior Member

Dear Huang,

I think you are not correct on this point because one extent can maintain multiple transactions but single block can be used by one transaction only.

Regards
Saurabh Mittal
Mahindra British Telecom

Report message to a moderator

Re: partition issue [message #522350 is a reply to message #522349]

Thu, 08 September 2011 14:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I think you are not correct on this point because one extent can maintain multiple transactions but single block can be used by one transaction only.
WRONG!
Single block can support more than one transaction at a time.
Just UPDATE different rows.

Report message to a moderator

Re: partition issue [message #522352 is a reply to message #522349]

Thu, 08 September 2011 14:50

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

msol25 wrote on Thu, 08 September 2011 21:45

Dear Huang,

I think you are not correct on this point because one extent can maintain multiple transactions but single block can be used by one transaction only.

Regards
Saurabh Mittal
Mahindra British Telecom

This is the fourth answer from you today and this is the fourth wrong answer.
Please take care of what you post.
A single block can be used by several transactions, this is the purpose of INITRANS and (obsolete) MAXTRANS parameters. You should read about them.

Regards
Michel

[Updated on: Sun, 30 March 2014 10:08]

Report message to a moderator

Previous Topic:	Added lots of space to a tablespace
Next Topic:	how to compress table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:34:36 CST 2024