statspack snippets

How to generate an Oracle statspack report and an explain plan for a query

Tagged oracle, explain plan, statspack  Languages sql
-- Connect

sqlplus <username>/<password>@<database>

-- Generate statspack report


-- Find execution plan for a specific query

Specify the Begin and End Snapshot Ids
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End   Snapshot Id specified: 2

Specify the Hash Value
Enter value for hash_value: 2967942512
Hash Value specified is: 2967942512