Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Warning 6226: Ignoring value requested for first connection attribute 'TempSize'

1611275Feb 10 2014 — edited Feb 11 2014

Hi

Was trying to load, here is what I see. Appreciate your help.

con1: Command> load cache group g_sdata_awt commit every 1000 rows;

5056: The cache operation fails: error_type=<TimesTen Error>, error_code=<3407>, error_message: [TimesTen]TT3407: Cannot allocate space to store ownership information for global cache groups because temporary data partition free space is below the minimum threshold of 3000000 bytes - from grid member DDGRID_DD_TTDB_1

The command failed.

con1: Command>

[timesten@timesten101 info]$ ttisql -connstr "dsn=DD_TTDB;tempsize=4096";

Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.

Type ? or "help" for help, type "exit" to quit ttIsql.

connect "dsn=DD_TTDB;tempsize=4096";

Warning  6226: Ignoring value requested for first connection attribute 'TempSize' -- value currently in use: 32, requested value: 4096

Connection successful: DSN=DD_TTDB;UID=timesten;DataStore=/home/timesten/TimesTen/ttdev/DD_TTDB;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/ttdev/lib/libtten.so;LogDir=/home/timesten/TimesTen/ttdev/logs/DD_TTDB;PermSize=8196;TempSize=4096;TypeMode=0;OracleNetServiceName=VIS1;

(Default setting AutoCommit=1)

Command>

I tried :

HOWTO : Understand Modifying TimesTen PermSize And TempSize First Connect Database Attributes (Doc ID 1081008.1)

It did not help! Thanks a lot.

Anil

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2014
Added on Feb 10 2014
4 comments
3,097 views