Go to main content
1/19
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
Technical support
What's New
New features for release of SQL Developer 18.2
New features for release of SQL Developer 4.0
1
Prerequisites to using SQL Developer
Setting environment variables for TimesTen and SQL Developer
Additional prerequisites for Microsoft Windows
Additional prerequisites for macOS
Enable TimesTen client functionality
Create script that sources TimesTen environment variables
2
Working with TimesTen Scaleout
Displaying the TimesTen Grid view
Testing passwordless SSH configuration
Working with the grid
Create a grid
Create a grid with the Simple Grid Wizard
Create a grid with the New Grid option
Manage an existing grid
Shutdown a grid
Start a grid
Remove a grid from SQL Developer
Working with the grid model
Apply grid model changes to the grid
Export the grid model
Change the grid model that the grid view displays
View the changes to the grid model
Working with physical groups
Define a new physical group
Assign or remove hosts from a physical group
Delete a physical group
Working with hosts
Add a host
Add a new host
Clone a host
Edit a host
Assign hosts to data space groups
Delete a host
Execute a command on a host
Working with installations
Create a new installation
Use existing source
New source
Delete an installation
Working with management instances
Create a new management instance
Replace a management instance
Switch the active management instance
Control the standby management instance
Use the shell on the host of the active management instance
Working with data instances
Create a new data instance
New data instance wizard
New data instance on a specific host
Edit a data instance
Start or stop the instance and server
Execute a command on the host of a data instance
Delete a data instance
Working with configuration files
Import a configuration file
Export a configuration file
Working with databases
Create a database with the database wizard
Working with database definitions
Create a database definition
Create a database from a database definition
Edit a database definition
Export a database definition
Delete a database definition
Define the distribution map of a database
Perform database operations
Working with connectables
Create a connectable
Edit a connectable
Export a connectable
Delete a connectable
View active connections to the database
Destroy a database
Working with repositories
Create a repository
Detach a repository
Inspecting logs
3
Connecting to a TimesTen Database
Defining a TimesTen database named connection
DSN
Easy Client/Server
Advanced
Using an existing TimesTen database named connection
Disconnecting an existing TimesTen database connection
4
Working with TimesTen Objects
Working with tables
Create a table
Define the columns of your table
Create an index for your table
Set constraints for your table
Set the distribution method for your table
Review the DDL of the CREATE TABLE statement
Edit a table
Review the distribution of data for a TimesTen Scaleout table
Create a primary key constraint
Change the attributes of primary key
Create an index on a table
Create a foreign key constraint
Specify and display LOB data types
Specify the INLINE attribute for columns
Alter the aging properties of a table
Adding an aging policy to a table
Dropping an aging policy from a table
Changing the aging state of a table's aging policy
Changing the memory usage thresholds and LRU aging cycle
Changing the lifetime and cycle of a table's time-based aging policy
Load data into tables
Compute table size information
View the characteristics of a table
Viewing the columns
Viewing the indexes
Viewing the aging attributes
Viewing the table definition
Drop a constraint
Working with PL/SQL
Create a PL/SQL package
Define the body of a PL/SQL package
Run a PL/SQL package
Compile PL/SQL packages
Compile a specific PL/SQL package
Compile all of your PL/SQL packages
Compile invalid PL/SQL packages
Drop a PL/SQL package
Use a REF CURSOR as an OUT parameter
Working with sequences
Create a sequence
Alter a sequence
Drop a sequence
Working with views
Create a view
Drop a view
Working with materialized views
Create a materialized view
Drop a materialized view
Locating a TimesTen database object
Granting and revoking object privileges
Viewing the privileges granted on a database object
ttIsql commands in SQL worksheet
5
Working with the TimesTen Query Optimizer
Updating the table and column statistics used by the query optimizer
Exporting table statistics
Viewing the execution plan of a statement
6
Working with the TimesTen Index Advisor
Connection level capture
SQL worksheet
Including optimizer hints for Oracle BI server in a SQL worksheet
Saving index recommendations from a SQL worksheet
SQL workload script
Including optimizer hints for Oracle BI server for a SQL workload script
Database level capture
Saving index recommendations
Viewing the TimesTen index advisor capture state
7
Loading data from an Oracle database into a TimesTen database
Loading data from Oracle database tables
Advanced
Simple
Add an Oracle database schema
Remove an Oracle database schema
Apply a filter to Oracle database schema tables
Load custom query results
Select tables to load
Loading data from an Oracle database table into an existing TimesTen table
Resume loading data from Oracle database tables
8
Prerequisites to Creating and Accessing a Cache Environment
Configuring the Oracle and TimesTen databases
Set the cache administration user name and password
Start and stop the cache agent
9
Creating Cache Groups
Creating a cache group
Defining a cache group and cache table attributes
Defining the root table
Selecting the columns to cache
Specifying the table attributes
Specifying an aging policy
Verifying the root table definition
Defining the child tables
Selecting the columns to cache
Specifying the table attributes
Completing the definitions of the child tables
Verifying the cache group definition
Dropping a cache group
10
Cache Group Operations
Loading or refreshing a cache group
Unloading a cache group
Flushing a cache group
11
Cache Group and Cache Table Characteristics
Viewing the characteristics of a cache group
Viewing the cache tables
Viewing the cache group definition
Viewing the aging attributes
Altering the automatic refresh attributes of a cache group
12
Working with TimesTen Replication
Viewing the replication scheme
Viewing the details of the TimesTen subscriber databases
Viewing the store attributes of the replicated TimesTen databases
Starting the replication agent
13
Working with TimesTen Performance Metrics
Creating snapshots
Dropping snapshots
Editing the TimesTen performance metrics configuration
Creating a TimesTen performance metrics report
Saving a report
14
TimesTen Reports
Generating TimesTen Reports
About Your Database
All Objects
Cache Groups
Database Administration
Performance
PLSQL
Security
Table
Index
Scripting on this page enhances content navigation, but does not change the content in any way.