OraFAQ Forum: Performance Tuning » PCTFREE AND PCTUSED

Home » RDBMS Server » Performance Tuning » PCTFREE AND PCTUSED

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

PCTFREE AND PCTUSED [message #479608]

Mon, 18 October 2010 09:18

sunayana_girl
Messages: 4
Registered: October 2010
Location: united states

Junior Member

SUPPOSE YOU ARE CONFIGURING BLOCK SPACE UTILIZATION ON AN ORACLE TABLE.WHICH OF THE FOLLOWING CHOICED IDENTIFIES BLOCK SPACE UTILIZATION SETTINGS THAT ARE NEVER APPROPRIATE UNDER ANY CIRCUMSTANCES?PLEASE EXPLAIN THE REASON AS WELL.

1.PCTFREE 5,PCTUSED 90

2.PCTFREE 15,PCTUSED 80

3.PCTFREE 20,PCTUSED 70

4.PCTFREE 10,PCTUSED 40

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479609 is a reply to message #479608]

Mon, 18 October 2010 09:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479613 is a reply to message #479609]

Mon, 18 October 2010 09:29

sunayana_girl
Messages: 4
Registered: October 2010
Location: united states

Junior Member

Thanks:-))

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479639 is a reply to message #479608]

Mon, 18 October 2010 10:06

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

In order to answer your homework questions, we recommend you re-read the appropriate chapter in your text book and/or consult the fine Oracle® Database Concepts manual.

[Updated on: Mon, 25 October 2010 09:28] by Moderator

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479640 is a reply to message #479608]

Mon, 18 October 2010 10:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not post in UPPER.

All of them are inappropriate when you use ASSM because PCTUSED is meaningless in this case.

Regards
Michel

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479814 is a reply to message #479639]

Tue, 19 October 2010 09:19

sunayana_girl
Messages: 4
Registered: October 2010
Location: united states

Junior Member

Well...Thanks for your advise..But it is not homework. Razz

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479816 is a reply to message #479814]

Tue, 19 October 2010 09:29

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

You're telling us a multiple choice question isn't homework?
Your definition of homework must be different to ours.

Report message to a moderator

Re: PCTFREE AND PCTUSED [message #479941 is a reply to message #479816]

Wed, 20 October 2010 06:22

sunayana_girl
Messages: 4
Registered: October 2010
Location: united states

Junior Member

May be...

Report message to a moderator

Previous Topic:	PX Deq: Execute Reply
Next Topic:	Difference in query performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 17:19:31 CST 2025