Home » RDBMS Server » Performance Tuning » Oracle Segment Tuning (Oracle10g)
Oracle Segment Tuning [message #441588] Tue, 02 February 2010 00:57 Go to next message
salora
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;
then
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
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.oracle-base.com/articles/10g/SpaceObjectTransactionManagement10g.php#segment_advisor


http://www.oracle.com/technology/oramag/oracle/05-may/o35tuning.html

the above will help you.

Read the performance tuning guide from http://tahiti.oracle.com/
Aslo see the performance section(sticky) in performance forum.
http://www.orafaq.com/forum/mv/msg/84315/246965/136607/#msg_246965

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
rahulvb
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 Sep 25 19:42:12 CDT 2016

Total time taken to generate the page: 0.24164 seconds