Solaris 2.6 (105181-21)
Can anyone help out with this one?
Our development staff are running a 4ge to extract various types/amounts of
data into a couple of temp tables, one of which has a row size of 1041
bytes. We have 3 temp dbspaces configured, each 1Gb in size. These are
specified in the ONCONFIG parameter as DBSPACETEMP
tmpdbs01:tmpdbs02:tmpdbs03. The temp tables are being created in the code
using the CREATE TEMP TABLE statement (WITH NO LOG).
From previous usage of temp tables, I thought that the server would
distribute the data evenly over these temp dbspaces, e.g. the number of free
pages shown within each temp dbspace when running onstat -d would go down
evenly across the 3 dbspaces as the program ran and populated the temp
table. However, what seems to be happening is that the temp table with
rowsize 1041 bytes is being stored exclusively in the first temp dbspace.
Once it reaches 509670 records, it continues to process but doesn't insert
any more records into the temp table (this figure matches the number of free
pages in tmpdbs01 before the program starts). The temp table doesn't expand
into either of the remaining temp dbspaces.
Is this right?
I was going to suggest changing the structure of the table to try and get
the row size under 1000 bytes to allow at least 2 rows per page. Would this
We're going to be doing a lot of large data extracts of this type, so this
is a problem that we'll probably hit again if we don't get it right this
If you need any further information, let me know. Any help/advice you can
offer will be greatly appreciated.
Scottish Friendly Assurance Society Limited
Scottish Friendly House, 16 Blythswood Square, Glasgow G2 4HJ
Customer Enquiries: 08456 00 54 33 Switchboard: 0141 275 5000
Fax: 0141 221 4864 Internet: www.scottishfriendly.co.uk
The Scottish Friendly Group of Companies is
regulated by the Financial Services Authority.
Member of ABI and AFS
Internet communications are not secure and therefore
the Scottish Friendly Group of Companies does not
accept legal responsibility for the contents of this message.
Any views or opinions presented are solely those of the
author and do not necessarily represent those of
the Scottish Friendly Group of Companies.
All emails entering and leaving the Scottish Friendly Group of
Companies are scanned to ensure they are free from all