Home » RDBMS Server » Performance Tuning » Oracle Segment Tuning (Oracle10g)
Oracle Segment Tuning [message #441588] Tue, 02 February 2010 00:57 Go to next message
Messages: 26
Registered: December 2009
Location: Thailand
Junior Member
Hi, All

I had new assigment to verify the DB and do some DB tuning.

First of all I kinly to say that. I have a bit knowlage about DBA, but I've the guidline to take a look in the information from AWR report (Automatic Workload Repository report) witch gennerated by oracle. Also focus on "Segment tuning".

I've gone through the net, some expertice said to using following command

SQL> alter table temp shrink space compact;
SQL> alter table temp shrink space;

But, I'm not clear about that, I need more detail as following issue.

1. what should I do in Segment tuning?.
2. how to do that
3. what's the meaning of above command?

Thank you in advance.

New DBA.

Re: Oracle Segment Tuning [message #441589 is a reply to message #441588] Tue, 02 February 2010 01:04 Go to previous messageGo to next message
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member


the above will help you.

Read the performance tuning guide from http://tahiti.oracle.com/
Aslo see the performance section(sticky) in performance forum.

Good luck

sriram Smile

[Updated on: Tue, 02 February 2010 01:07]

Report message to a moderator

Re: Oracle Segment Tuning [message #441611 is a reply to message #441589] Tue, 02 February 2010 02:59 Go to previous message
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Good link Sriram Cool
Previous Topic: Heap size exceeds warning notification in alert.log
Next Topic: Function Based Indexes
Goto Forum:

Current Time: Sun Oct 23 01:22:02 CDT 2016

Total time taken to generate the page: 0.07884 seconds