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