14.5 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
Parent topic: Using On-Demand Diagnostic Collections