- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Keep / recycle / default and different block size
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2004 09:41 PM
тАО04-08-2004 09:41 PM
I'm working on a datawarehouse (700 Go) base on a classic star schema. The DB BLOCK SIZE is 8k wich is a shame, but when the project started the standard were 8k for all DB, OLTP or Datawarehouse. It sucks but we can find the time or money to make a reorganisation.
The facts table are partionned on a time field.
You have worked on the buffer management in the following way :
- fact table segment are too large to be kept in the buffer, so thoses segments are flagged recycle
- the last period segements are queried very frequently, so there flagged keep
...
You get the picture.
Now, a DBA have suggested to create a TEMPORARY TABLESPACE with 16k or 32k block size + to enlarge the cache.
==> My question : does the buffer management policy is compatible with different block size on the data DBF and the TEMPORARY TABLESPACE ?
Thanks for you comments,
Nicolas
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2004 10:00 PM
тАО04-08-2004 10:00 PM
Re: Keep / recycle / default and different block size
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2004 10:11 PM
тАО04-08-2004 10:11 PM
Re: Keep / recycle / default and different block size
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2004 01:02 AM
тАО04-09-2004 01:02 AM
Re: Keep / recycle / default and different block size
This is a healthy mechanism, while allowing a competition of the members and a constant improvement of the knowledge which the communaut├Г┬йe shares
That's the way thing goes
W
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2004 01:30 AM
тАО04-09-2004 01:30 AM
Re: Keep / recycle / default and different block size
Regarde mon profil, a chaque reponses recues des points ont ete affectees.
C'est pourquoi ta reponse sera recompensee par x point (o├Г┬╣ x prend la valeur 0). Je te filerai bien dix mais ca va se voir :-D
ad'taleur
n i
c
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2004 07:55 AM
тАО04-09-2004 07:55 AM
SolutionThe "create temporary tablespace" cannot specify a block size.
In 9i, you need to move away from the db_block_buffers, and start using the db_cache_size setting. This will allow you to specify db_XXk_cache_size setting, where XX is the block size of the tablespace that you are creating. This space will be subtracted from the available db_cache_size which is primarily your default buffer area.
Also, the db_keep_cache_size is set for your default block size as well.
This functionality is only true in 9i+, not 8i.
Let me know if you have any questions.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 08:20 PM
тАО04-12-2004 08:20 PM
Re: Keep / recycle / default and different block size
Thank you very much for your answer.
My question isn't well formulated, I'm working on the subject.
Cheers,
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 09:39 PM
тАО04-12-2004 09:39 PM
Re: Keep / recycle / default and different block size
My understanding is as under:
Two tablespaces SYSTEM and TEMP will always have primary block size as defined by DB_BLOCK_SIZE.
In 9i db_cache_size determines the size of the default buffer pool for buffers with the primary block size as defined by DB_BLOCK_SIZE.
db_nk_cache_size (where n=2, 4, 8, 16, 32): If nKB is not the primary block size, db_nk_cache_size specifies the size of the buffer chache for segments with a nKB block size.
db_cache_size does not include db_keep_cache_size, db_recycle_cache_size, db_nk_cache_size.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-13-2004 01:08 AM
тАО04-13-2004 01:08 AM