OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » size of segments

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

size of segments [message #272880]

Mon, 08 October 2007 02:09

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

I m using 10gR2 in solaries.
I have two machine x and y. x replicates to y.
Now I got some interesting information like different size of indexes.
SELECT SEGMENT_NAME,BYTES/1024/1024 FROM
USER_SEGMENTS WHERE SEGMENT_TYPE='INDEX'
ORDER BY 2 DESC;

can explan this???

[mod-edit] removed illiterate IM speak.

[Updated on: Mon, 08 October 2007 08:09] by Moderator

Report message to a moderator

Re: size of segments [message #272891 is a reply to message #272880]

Mon, 08 October 2007 02:22

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

Senior Member
Account Moderator

First, please read and follow OraFAQ Forum Guide, especially section about IM speak.
Then always post your Oracle version (4 decimals).

Finally, what is the question? What do you want us to explain?
How do you do your "replicates"?

Regards
Michel

[Updated on: Mon, 08 October 2007 02:23]

Report message to a moderator

Re: size of segments [message #272913 is a reply to message #272891]

Mon, 08 October 2007 02:56

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

Its a third party software named shareplex.
The given query gives different size for indexes and tables like x machine shows more size for same tables. So,is there any problem???

i using 10.2.0.2

[mod-edit] removed more illiterate IM speak.

[Updated on: Tue, 09 October 2007 07:55] by Moderator

Report message to a moderator

Re: size of segments [message #272920 is a reply to message #272913]

Mon, 08 October 2007 03:27

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

Senior Member
Account Moderator

Quote:

So,is there any problem?

Who knows?
It depends on how your software works.
It is likely not a problem unless this is a physical replication.

Regards
Michel

Report message to a moderator

Re: size of segments [message #273067 is a reply to message #272880]

Tue, 09 October 2007 00:30

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

I got some differences for Indexes. After rebuilding them,both r same. And I m using shareplex for replication.

Now..what can I do for tables...is there anything like rebuilding???

Report message to a moderator

Re: size of segments [message #273083 is a reply to message #273067]

Tue, 09 October 2007 01:19

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

Senior Member
Account Moderator

alter table move
dbms_redefinition
exp/imp

But why do you want both have same size?

Regards
Michel

[Updated on: Tue, 09 October 2007 01:20]

Report message to a moderator

Re: size of segments [message #273108 is a reply to message #272880]

Tue, 09 October 2007 02:11

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

Actually, My boss asked me 'Why the differences??' Cool

anyway..michel.

[mod-edit] removed more illiterate IM speak.

[Updated on: Tue, 09 October 2007 07:56] by Moderator

Report message to a moderator

Re: size of segments [message #273115 is a reply to message #273108]

Tue, 09 October 2007 02:20

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

Senior Member
Account Moderator

Many reasons.
Different block sizes
Different tablespace parameters
Different segment parameters
And, of course, the most important, different ways of loading the objects.

Regards
Michel

Report message to a moderator

Re: size of segments [message #273242 is a reply to message #273115]

Tue, 09 October 2007 12:32

OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico

Junior Member

Yes,

Different ways of loading objects: master database is a transactional, then indexes are constructed adding leafs one by one. What happens if replication or standby applies data in a distinct order that master, index growth will be different. Or when bulk insertion takes place.

the question is: Which is the mechanism that 3rd party software uses for replication?

Regards

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:39] by Moderator

Report message to a moderator

Previous Topic:	Partition
Next Topic:	Session Memory Usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:45:22 CST 2024