OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Data Block

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

Oracle Data Block [message #328459]

Fri, 20 June 2008 04:40

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

Can an Oracle block hold rows of more than one table?If it's so,based on which table's PCTFREE & PCTUSED value that block's free space management will be carried out?

Thanks...

Report message to a moderator

Re: Oracle Data Block [message #328466 is a reply to message #328459]

Fri, 20 June 2008 04:57

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

Senior Member
Account Moderator

Quote:

Can an Oracle block hold rows of more than one table?

Yes in cluster.

Quote:

If it's so,based on which table's PCTFREE & PCTUSED value that block's free space management will be carried out?

The one of the cluster. Tables in cluster can't have these parameters.

Regards
Michel

Report message to a moderator

Re: Oracle Data Block [message #328514 is a reply to message #328459]

Fri, 20 June 2008 06:40

gajini
Messages: 262
Registered: January 2006

Senior Member

Thanks Michel...

Report message to a moderator

Previous Topic:	change in nls_length_semantics parameter
Next Topic:	logminer issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:23:25 CDT 2024