OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » How to tune

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

How to tune [message #382869]

Sun, 25 January 2009 23:52

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

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

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

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

jolly_makkar
Messages: 63
Registered: March 2008

Member

good...

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

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 04:38:43 CDT 2024