Home » RDBMS Server » Server Administration » Oracle Data Block
Oracle Data Block [message #328459] Fri, 20 June 2008 04:40 Go to next message
gajini
Messages: 259
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...
Re: Oracle Data Block [message #328466 is a reply to message #328459] Fri, 20 June 2008 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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


Re: Oracle Data Block [message #328514 is a reply to message #328459] Fri, 20 June 2008 06:40 Go to previous message
gajini
Messages: 259
Registered: January 2006
Senior Member

Thanks Michel...
Previous Topic: change in nls_length_semantics parameter
Next Topic: logminer issue
Goto Forum:
  


Current Time: Sun Dec 04 22:59:42 CST 2016

Total time taken to generate the page: 0.23235 seconds