TimesTen in memory database Creation

+++++++++++++++++++++++++++++++++++++++
++ +  Create a TimesTen in memory database    +++
+++++++++++++++++++++++++++++++++++++++
 
Assumption: TimesTen database software has been installed

Oracle user has been used for TimesTen installed. So OS user Oracle is the administrator user for creating TimesTen database.

1. Define a Data Source Name (DSN)
==============================
DSN defines the configuration of the database and must be defined before creating Database.

 
 
Modify the sys.odbc.ini [Add DSN anywhere in the ODBC DATA Sources section]
 
2. Specify New data Source definition
===================================
edit sys.odbc.ini to add source definition and save
  • Driver - location of the TimesTen direct linked ODBC driver
  • DataSource - location and name of the database files
  • LogDir - directory for the transaction logs
  • PermSize - Permanent partition of the database size in MB
  • TempSize -Temporary partition of the database size in MB
  • DatabaseCharacterSet - Character Set of the database 
 
 
 
 
3. Verify that database daemon is running
================================

 
 
 
4. ttisql to connect database and create the database store
============================================
 
 
 
 
 
So mono_ttdb database has been created and loaded into memory.
Check the TimesTen in memory Database status
+++++++++++++++++++++++++++++++++++++
[oracle@cloud bin]$ ./ttstatus
TimesTen status report as of Tue Nov 19 05:09:33 2013
Daemon pid 4161 port 53396 instance tt1122
TimesTen server pid 4170 started on port 53397
------------------------------------------------------------------------
Data store /u01/app/ttdata/datastores/mono_ttdb
There are no connections to the data store
Replication policy  : Manual
Cache Agent policy  : Manual
PL/SQL enabled.
-----------------------------------------------------------------------
Accessible by group dba
End of report
[oracle@cloud bin]$ ./ttisql mono_ttdb
Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=mono_ttdb";
Connection successful: DSN=MONO_TTDB;UID=oracle;DataStore=/u01/app/ttdata/datastores/mono_ttdb;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/home/oracle/TimesTen/tt1122/lib/libtten.so;LogDir=/u01/app/ttdata/logs;PermSize=40;TempSize=32;TypeMode=0;
(Default setting AutoCommit=1)
 
Current size of the permanent and temporary data stores
+++++++++++++++++++++++++++++++++++++++++
Command> dssize
  PERM_ALLOCATED_SIZE:      40960
  PERM_IN_USE_SIZE:         9389
  PERM_IN_USE_HIGH_WATER:   9389
  TEMP_ALLOCATED_SIZE:      32768
  TEMP_IN_USE_SIZE:         9442
  TEMP_IN_USE_HIGH_WATER:   9505
Create a user and then object under that user
=================================
 
 
Now check the DataStore and LogDir
============================
[oracle@cloud datastores]$ ls -ltra
total 56224
drwxr-xr-x 2 oracle dba     4096 Nov 19 04:39 mono_ttdb
drwxr-xr-x 4 oracle dba     4096 Nov 19 04:40 ..
drwxr-xr-x 3 oracle dba     4096 Nov 19 05:02 .
-rw-rw---- 1 oracle dba 28733432 Nov 19 05:18 mono_ttdb.ds0
-rw-rw---- 1 oracle dba 28758536 Nov 19 05:20 mono_ttdb.ds1
 Note: TimesTen maintain two complete images on the disk and known as checkpoints
 Transaction logs for recovery
======================
[oracle@cloud logs]$ ls -ltra
total 212348
drwxr-xr-x 4 oracle dba     4096 Nov 19 04:40 ..
-rw-rw---- 1 oracle dba 67108864 Nov 19 05:02 mono_ttdb.res0
-rw-rw---- 1 oracle dba 67108864 Nov 19 05:02 mono_ttdb.res1
-rw-rw---- 1 oracle dba 67108864 Nov 19 05:02 mono_ttdb.res2
drwxr-xr-x 2 oracle dba     4096 Nov 19 05:02 .
-rw-rw---- 1 oracle dba 15880192 Nov 19 05:20 mono_ttdb.log0

Comments

Post a Comment

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== +     On Primary             + ==================  SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 ACTIVE          2       ...
Read more

Exadata - Smart Scan Testing

Image
Exadata - SMART SCAN testing -------------------------------------------- Samrt scan works with cell offloading which relate to offloaded the sql processing from the database layer to the cell (storage) layer. Smart scan is the access mechanism to offload data from storage layer. For example passing only required data blocks after applying predicate filters at the cell layer instead of sending every possible blocks from cell server to database server.                           Figure 1: Traditional Database Storage I/O and SQL Processing Model   Process Steps: ------------------- 1.    The client issues a SELECT statement . 2.    The database kernel maps this request to the database files and extents which contain the table data. 3.    The database kernel issues the I/Os to read all the table bloc...
Read more

Exadata Flash Cache - Management

Total size of Flash CellCLI>  list flashcache attributes effectiveCacheSize          5.82122802734375T Flashcache Mode:  [root@Cellc01-adm ~]# su - celladmin cellcli CellCLI>  list cell attributes flashCacheMode,status          WriteThrough    online > list celldisk where disktype=flashdisk > list physicaldisk FLASH_1_1 detail List PhysicalDisk for FlashCache: CellCLI> list physicaldisk attributes name, disktype, makemodel, physicalrpm, physicalport, status      8:0           HardDisk      "HGST    H7240AS60SUN4.0T"                              normal      8:1  ...
Read more