RE: Storage Parameters Calculation

Thanks for everyone replied to my question. Lucia, Mary and Ruth. I really appreciate you help. I have asked Ruth to send me the white paper, though.

Thanks much agin

Mukesh

• Ron Rogers <RROGERS_at_galottery.org> wrote:
  > If you search for "stop defragmenting" on metalink
  > you should find the paper that has"paper#711" in the
  > lower right corner. It was thete last week.
  > ROR
  >
  > >>> ldemeester_at_nm2.com 09/12/00 02:30PM >>>
  > Please send this documenet via email. The document
  > on openworld/whitepapers
  > is not available anymore.
  >
  > Thanks!!
  > Lucia
  >
  > -----Original Message-----
  > A (CAP, CDI)
  > Sent: Thursday, September 07, 2000 1:41 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Mukesh:
  > Have you read this paper on fragmentation yet ?
  > I found it very useful.
  > www.oracle.com/openworld/white_papers/711.pdf
  >
  > Mary Ruiz
  > Atlanta GA
  > -----Original Message-----
  > Sent: Thursday, September 07, 2000 3:56 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Hello Gurus
  >
  > I am posting this question again, in anticipation
  > of
  > that some ideas would come over.
  >
  > I have a question that how do I calculate the
  > required initial and next extent on a tablespace and
  > a
  > table. The scenario is I have a tablespace which is
  > fragmented a lot and have many data files. This
  > tablespace has many tables with different sizes. Now
  > I
  > want to export the tablespace with compress=y option
  > and want to import them in a big datafiles of 2gig
  > each.
  >
  >
  > In order to do that I want to have a different set
  > of
  > storage parameters.
  >
  > I have the query for used extents and available
  > extents on table and fragmentation on tablespoace.
  >
  > What would be an appropriate calculation ??
  >
  >
  >
  > Thanks much
  >
  > MCG
  >
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Yahoo! Mail - Free email you can access from
  > anywhere!
  > http://mail.yahoo.com/
  > --
  > Author: Mukesh Ghildiyal
  > INET: mcgoracle_at_yahoo.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  > --
  > Author: Ruiz, Mary A (CAP, CDI)
  > INET: Mary.Ruiz_at_gecapital.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  >
  > --
  > Author: Lucia DeMeester
  > INET: ldemeester_at_nm2.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Author: Ron Rogers
  > INET: RROGERS_at_galottery.org
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).