the size of tempfile?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: the size of tempfile?

  1. #1
    Join Date
    Dec 2005
    Posts
    1

    the size of tempfile?

    when i apply "alter database tempfile /path_to_temp01/temp01.dbf resize 500M;" command, i can see via oem that the size takes a value what i set. But in the operating system environment (which is linux) i can not see the changed size with du -ha command. it remains constant. what is the reason of this? will this situation be a problem for the temp file? and How can i calculate the ideal size of this file?

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by dervisali
    when i apply "alter database tempfile /path_to_temp01/temp01.dbf resize 500M;" command, i can see via oem that the size takes a value what i set. But in the operating system environment (which is linux) i can not see the changed size with du -ha command. it remains constant. what is the reason of this? will this situation be a problem for the temp file? and How can i calculate the ideal size of this file?

    you would see them when the objects occupy the resized space.
    Generally you would see them immediately (as in Soalris).
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    Sizing of temp depends entirely on your application. DDS / Data whse type stuff, usually requires a larger temp. Straight OLTP - probably smaller temp is fine. Depends on size of data.

    See v$sort_usage and v$sort_segment for usage. I monitor mine, so I can tell who is running large sorts.
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

Posting Permissions

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


Click Here to Expand Forum to Full Width