DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Pct_free

Threaded View

  1. 11-11-2010, 01:51 AM #1
    vnktummala's Avatar
    vnktummala
    vnktummala is offline Senior Advisor
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Pct_free

    Hi,

    quick question.

    In a data warehouse DB, If i know that in any given table only insert operations happens, is it feasible to set pctfree to 0 to save some storage?

    I know depends on block size and row length there is a chance of row chaining. I am monitoring the table regularly. Also, want to see the comments about the same here.

    Thanks,
    Last edited by vnktummala; 11-11-2010 at 02:08 AM. Reason: typo
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width