Searching Oracle Trace File Analyzer Metadata

You can search all metadata stored in the Oracle Trace File Analyzer index using tfactl search -showdatatypes|-json [json_details].

You can search for all events for a particular Oracle Database between certain dates.

For example, on Linux systems:

tfactl search -json
'{
  "data_type":"event",
  "content":"oracle",
  "database":"rac11g",
  "from":"01/20/2017 00:00:00",
  "to":"12/20/2018 00:00:00"
 }'

For example, on Linux and Windows systems:

tfactl search -json
"{
   \"data_type\":\"event\",
   \"content\":\"oracle\",
   \"database\":\"rac11g\",
   \"from\":\"01/20/2017 00:00:00\",
   \"to\":\"12/20/2018 00:00:00\"
}"

To list all index events on Linux, AIX, and Solaris systems: tfactl search -json '{"data_type":"event"}'

To list all index events on Windows systems: tfactl search -json "{\"data_type\":\"event\"}"

To list all available datatypes: tfactl search -showdatatypes