2024年4月28日发(作者：)

TimesTen Training(1)--体系架构

开始为期4天的TimesTen培训。

简单记下每天的日记，督促自己。

point files:

Checkpoint files contain an image of the

database on disk. TimesTen uses dual

checkpoint files for additional safety,

in case the system fails while a

checkpoint

operation is in progress. Changes to

databases are captured in transaction

logs

that are written to disk periodically. If

a database needs to be recovered,

TimesTen merges the database checkpoint

on disk with the completed

transactions that are still in the log files.

Each data store has two checkpoint files named

DataStoreName

.ds0 and

DataStoreName

.ds1.

A checkpoint operation writes a copy of an in-memory data store to a

checkpoint file and deletes unneeded transaction log files. Checkpoint

operations can be configured to automatically occur based on a time

frequency and a transaction log file volume.

A checkpoint operation updates the file other than the most recent

consistent one to ensure that a valid checkpoint file always exists on

disk.

A data store is loaded into memory by reading the most recent consistent

checkpoint file, and then applying the log records from the transaction

log files that were generated from the time the checkpoint file was last

updated.

ction log buffer:

Each data store has one or more transaction log files. These files are

named

DataStoreName

.log

n

, where

n

is an integer starting at 0 and is

incremented each time a new log file is created. The log files contain

a log record for each data store update, commit, and rollback operation.

e Space Files:

Each data store has three reserve space files. These files are named

DataStoreName

.res0,

DataStoreName

.res1, and

DataStoreName

.res2. The

reserve space files are used to roll back transactions if the disk that

the transaction log files reside on is full. Note that transaction log

records are generated when a transaction is being rolled back.

TimesTen Training(2)--Command

TimesTen一些管理命令:

onadmin 启停服务

C:Documents and SettingsChenLi>ttdaemonadmin -stop

TimesTen Data Manager 11.2.1 服务正在停止...

TimesTen Data Manager 11.2.1 服务已成功停止。

C:Documents and SettingsChenLi>ttdaemonadmin -start

TimesTen Data Manager 11.2.1 服务正在启动 .

TimesTen Data Manager 11.2.1 服务已经启动成功。

datastoreName 登录dataStore

C:Documents and SettingsChenLi>ttisql test

Copyright (c) 1996-2009, Oracle. All rights reserved.

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

connect "DSN=test";

Connection successful:

DSN=test;UID=ChenLi;DataStore=F:TimestenDataSoreTEST;

……

--内部用户登录：

C:Documents and SettingsChenLi>ttisql "dsn=test;uid=tt;pwd=tt"

Copyright (c) 1996-2009, Oracle. All rights reserved.

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