Home » RDBMS Server » Performance Tuning » How to tune
How to tune [message #382869] Sun, 25 January 2009 23:52 Go to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
how to tune Segment with >100 extent

Report message to a moderator

Re: How to tune [message #382871 is a reply to message #382869] Sun, 25 January 2009 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how to tune Segment with >100 extent
no

The number of segments is not material to reality.

Does the world end when segments exceed 100?

Why is 100 the "magic number"?
Why not 50 or 500?

Please provide test case to substantiate your claim.

Report message to a moderator

Re: How to tune [message #382877 is a reply to message #382871] Mon, 26 January 2009 00:55 Go to previous messageGo to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
hi..i am taking health report from toad

which shows under red light that

LOBSEGMENT xxx.SYS_xxxxxxxxxxxx 458 extents

HOW to tune this kind of large segment

Report message to a moderator

Re: How to tune [message #382879 is a reply to message #382869] Mon, 26 January 2009 00:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
TRUNCATE

Report message to a moderator

Re: How to tune [message #382881 is a reply to message #382879] Mon, 26 January 2009 01:02 Go to previous messageGo to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
good... Mad thts the best advise i ever got.....

how can i truncate critical data in table

Report message to a moderator

Re: How to tune [message #382882 is a reply to message #382869] Mon, 26 January 2009 01:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

Report message to a moderator

Re: How to tune [message #382883 is a reply to message #382877] Mon, 26 January 2009 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
..i am taking health report from toad

which shows under red light that

quoting Ana (anacedent):
Those who live by the GUI, die by the GUI.

Regards
Michel

Report message to a moderator

Re: How to tune [message #382894 is a reply to message #382869] Mon, 26 January 2009 02:51 Go to previous messageGo to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
Could you Please give some hints what should we do if segment will increase extents..as for me extents are 400+ .I appreciate any sort of help...Thanks

Report message to a moderator

Re: How to tune [message #382895 is a reply to message #382894] Mon, 26 January 2009 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Nothing should be done if you use LMT (Locally Managed Tablespace).

Regards
Michel

Report message to a moderator

Re: How to tune [message #382900 is a reply to message #382895] Mon, 26 January 2009 03:29 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If you just want that message to go away, use
ALTER TABLE tname MOVE TABLESPACE tsname
to move it to a tablespace with larger extents.

It won't improve performance any (unless it is fragmented or suffering from HWM), but it will reduce your stress levels because TOAD will stop nagging you.

Here is the link to the manual.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2081902
Ross Leishman

Report message to a moderator

Re: How to tune [message #382901 is a reply to message #382900] Mon, 26 January 2009 03:33 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Quote:
it will reduce your stress levels because TOAD will stop nagging you.

Laughing

Report message to a moderator

Previous Topic: Not sure what is causing the slow performance
Next Topic: Going for full table scan
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 01:37:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.