Home » RDBMS Server » Server Administration » size of segments
size of segments [message #272880] Mon, 08 October 2007 02:09 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: size of segments [message #273067 is a reply to message #272880] Tue, 09 October 2007 00:30 Go to previous messageGo to next message
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???
Re: size of segments [message #273083 is a reply to message #273067] Tue, 09 October 2007 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
Actually, My boss asked me 'Why the differences??' Cool 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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: size of segments [message #273242 is a reply to message #273115] Tue, 09 October 2007 12:32 Go to previous message
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:
  


Current Time: Sun Dec 04 00:24:01 CST 2016

Total time taken to generate the page: 0.19413 seconds