How to generate 1…

Generate 10046 trace when you mount database and open database:

1)

SQL>startup nomount
SQL>connect username/password
SQL>alter session set timed_statistics = true;
SQL>alter session set statistics_level=all;
SQL>alter session set max_dump_file_size = unlimited;
SQL>alter session set events '10046 trace name context forever, level 12';
SQL>alter database mount;
SQL>alter database open;
SQL>alter session set events '10046 trace name context off';

2)
Format your 10046 trace file:
$tkprof