This discussion is archived
3 Replies Latest reply: Dec 11, 2012 9:58 PM by 914264 RSS

How to generate AWR report by using ttStats?

914264 Newbie
Currently Being Moderated
Hi all,are there any links or documents to show how to use ttStats toolkit to generate a report like Oracle AWR report?
If no links or document available, could you tell me how to use it?
In fact I want to know how to do a performance analysis for my application and perform some tune.
If any other toolkits are more suitable please let me know and of course the guide that how to use them is much welcome.


Thanks.
  • 1. Re: How to generate AWR report by using ttStats?
    hitgon Expert
    Currently Being Moderated
    AWR Support in not available in Oracle Timesten
  • 2. Re: How to generate AWR report by using ttStats?
    820658 Newbie
    Currently Being Moderated
    The ttStats executable can be found in the <TimesTen_home>/support directory. Before you can run the executable within a command prompt, you'll need to source the ttenv.* file in the <TimesTen_home>/bin directory.

    The output of ttStats -h is as follows:

    ttStats [-latchstats on|off] [-display-options] [-xml file]
    [-statlevel level] <dsn or connstr>
    ttStats -s[napshot] [-latchstats on|off] -xml <file> <dsn or connstr>
    ttStats -report <xmlfile1> <xmlfile2> <-text|-html> <report_file>
    Where parameters in <> are required, and in [] are optional.

    -display-options:
    This option only works in monitoring mode as
    screen filtering. ttStats only displays on the
    screen statistics with specified prefixes.
    Available prefix options include:
    -cg, -ckpt, -conn, -db, -grid, -lock, -log, -repl,
    -stmt, -txn, -xla, -zz, where the naming of prefixes
    conforms to naming of statistics in TimesTen
    sys.systemstats table. If no display option
    is specified, all statistics are displayed
    by default. For example, run command
    ttStats -cg -stmt dsn=TptbmData
    to display only cache group and statement
    related statistics.

    -h[elp] Print help message and exit.

    -interval <secs> Collect a set of statistics every <secs> seconds
    (default=10).
    Note: setting this lower can negatively impact
    performance

    -xml <file> Write statistics to <file> in XML format. All
    statistics will be written to <file> no matter
    whether they are displayed on screen or not.
    For example ttStats -xml mon.xml dsn=TptbmData
    and ttStats -xml mon.xml -cg dsn=TptbmData
    write the same file even if the latter only
    shows cache related statistics on the screen.

    -snapshot One snapshot of all statistics are saved to disk
    in the specified file format, then the program
    exits. This option should be used together with
    the -xml option.
    -statlevel <level>
    Set the SysStats level, this value of level only
    applies to sys.systemstats table.
    -report <xmlfile1> <xmlfile2> <-xml|-text|-html> <report_file>
    Compare two snapshots, and generate an AWR like
    report. At present, each XML file contains only
    one snapshot. The difference is computed as the
    absolute value of statistic value in <xmlfile2>
    minus that in <xmlfile1>. The result can be
    written in HTML and plain text formats. XML is
    not supported as output format at present.

    As an example, you can run the utility as the instance admin user by doing something like:
    ./ttStats -s -xml tmp.xml <DSN>
    You can then open tmp.xml with a web browser and see statistics about the database.

    You can also compare two previously captured snaps by doing something like:
    ./ttStats -report tmp1.xml tmp2.xml -html tmpReport.html
  • 3. Re: How to generate AWR report by using ttStats?
    914264 Newbie
    Currently Being Moderated
    thanks stevenlc, I will try that.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points