title: How to check MAX_DUMP_FILE_SIZE for my session
body: <p>I need help for gettng the TKProf of a sql query.
  The oracle <a href="http://docs.oracle.com/cd/B28359_01/server.111/b28274/sqltrace.htm#i4183" rel="nofollow">doc</a> says to check the following parameters before enabling SQL trace.</p>
  
  <pre><code>TIMED_STATISTICS, MAX_DUMP_FILE_SIZE, and USER_DUMP_DEST
  </code></pre>
  
  <p>Can someone help me how to check their value for current session, and how to set them if the are incorrect?</p>
  
  <p>I tried </p>
  
  <pre><code>show parameter max_dump;
  
  show parameter timed_statistics;
  </code></pre>
  
  <p>from sqlplus (windows), but i get the ORA-00942: table or view does not exist error.</p>
  
  <p>Also, any further help on the further steps of TKPROF will be highly appreciated.</p>