This discussion is archived
1 Reply Latest reply: Nov 19, 2012 8:25 AM by 914264 RSS

I have to set a very large size for temp space, why?

948372 Newbie
Currently Being Moderated
Hi teachers,

For my TT database, this is the configuration:

[atf]
UID=cacheadm
PWD=cacheadm
Driver=/home/tta/TimesTen/tt112241/lib/libtten.so
DataStore=/home/tta/ttdata/atf/database/atf_ttdb
LogDir=/home/tta/ttdata/atf/logs
PermSize=12000
TempSize=4000
DatabaseCharacterSet=US7ASCII
OracleNetServiceName=norcl

When reading the documents, which says, the temp size can be 1/8 of the PermSize.

My sutiation:
I have two tables in oracle: one contains 30,000,000 rows (tableA below), and the other contains about 50,000,000 records (tableB below).

I loaded the entire tableA (by calling load cache group xxx commit every 10000 rows), then the perm size was about 4.5GB, and the Temp size was about 1.5GB, I got this message from dssize.
Then I tried to load tableB, when the perm size was close to the upper limit, the temp size was being insufficient!
dssize again, found that, perm size 11GB+, temp size is very very close to 4GB.

To my knowledge, the cursor, the prepared statements, and the complex SQL statments could use the temp space. But I hadn't done any SQL statements (or even actions) other than "load cache group ...".
Why there are so much data in temp size? How to release them?

From the stuff I read, it seems that I have to disconnect all the connections (they are subdaemon of timesten and cache agent processes) found by ttstatus, but is there any difference between disconnect all of them and stop the timesten daemon?

Could you please provide some advice? THANKS IN ADVANCE!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points