3 Replies Latest reply: Dec 11, 2012 11:58 PM by 914264 RSS

    How to generate AWR report by using ttStats?

      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.

        • 1. Re: How to generate AWR report by using ttStats?
          AWR Support in not available in Oracle Timesten
          • 2. Re: How to generate AWR report by using ttStats?
            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.

            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
            Note: setting this lower can negatively impact

            -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?
              thanks stevenlc, I will try that.