Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 357
Note:If the table name is lower case, do not use the describe 
command. Instead, use desc as follows:
desc
 table_name
3  
Enter quit 
The system exits the sqlplus session.
Table Searches
Think of a database table as a book. If you want to find information on a 
subject, you must search the book to find it. However, checking the index first 
helps you to locate the...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 358
If FIELD1 has an index created for it in the database, all records that match 
the criteria specified in the select statement are located much faster than if 
there is no index.
FIELD1 is a key field in this example because it is the field used to specify 
selection criteria. Indexes only decrease read time when they are created on 
key fields.
An SQL statement may...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 359
Use the following procedure to create a unique index on a field called 
FIELD1 
in a table called 
table_name
.
1  
At the 
Console Login:
 prompt, enter root
The system prompts you for a password.
2  
Enter your root password.
The system displays the system prompt 
#.
3  
Enter sqlplus sti/sti
The system starts a sqlplus session.
4  
Enter
create unique index...

6  
Database Administration  Database Interface Process
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 360
Use the following procedure to create non-unique indexes on fields called FIELD1
 and 
FIELD2
 in a table called 
table_name
:
1  
At the 
Console Login:
 prompt, enter root
The system prompts you for a password.
2  
Enter your root password.
The system displays the system prompt #.
3  
Enter sqlplus sti/sti
The system starts a sqlplus session.
4  
Enter...

6  
Database Administration  Database Interface Process
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 361
Database DIP Timeout
The voice system and remote database ORACLE connection is established 
when the voice system starts. After the connection is established, the voice 
system does not keep track of status changes on the remote machine. The 
connection between it and the voice system is dropped if the remote machine 
is turned off or rebooted. If the remote...

6  
Database Administration  Database Interface Process
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 362
The 45- and 300-seconds timeout values can be altered in /vs/data/ldbdip.rc
 
file. This file is included with the generic package and contains the following 
default values:
FIRST_TMOUT=45
SECOND_TMOUT=300
You may change these default values to any number that is appropriate for 
your database and applications. If the ldbdip.rc file is missing, the DIP uses...

6  
Database Administration  Database Interface Process
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 363
The number of cursors is tunable in the /oracle/dbs/initA.ora file 
(open_cursors is a tunable parameter). At least 500 cursors are supported 
in the Intuity CONVERSANT system. Once the limit of cursors is reached, 
database transactions do not complete successfully; that is, table reads may 
fail and inserts or updates may not occur.
Database Cursor...

6  
Database Administration  Database Interface Process
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 364
•
If you have a 24-channel system running an application that performs four 
read table operations on four different tables per channel, the calculation 
is:
24 ´
 4 ´
 1 = 96
Since 96 is less than 500, the database operations proceed properly.
•
If you have a 36-channel system running an application that performs four 
read table operations on a single...

6  
Database Administration  Increase Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 365
•
An application developer wants to develop an application to run on 72 
channels simultaneously:
500 / (72 ´
 1) = 6.94
Therefore, the application can perform up to six read table operations on 
up to six different tables per channel before it encounters database 
access problems.
Increase Database Storage Size
The amount of storage space needed for the...

6  
Database Administration  Increase Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 366
3  
Enter /vs/bin/util/dbfrag
The system displays the number of free database blocks.
4  
Multiply the number of free database blocks by 4 to get the actual number 
of free 512-byte blocks.
5  
Enter df /oracle
The system displays the number of free blocks available in the /oracle file 
system.
6  
Determine the number of bytes to add to the database by...