Re: Set Autotrace on

From: William Dong <William_Dong_at_nylim.com>
Date: Wed, 14 Feb 2001 11:16:23 -0800
Message-ID: <F001.002B460F.20010214105627@fatcity.com>

Sorry the sql file should be in this directory: $ORACLE_HOME/sqlplus/admin/plustrce.sql

|--------+------------------------>


|        |          "William Dong"|

|        |          <William_Dong@|

|        |          nylim.com>    |

|        |                        |

|        |          02/14/01 12:56|

|        |          PM            |

|        |          Please respond|

|        |          to ORACLE-L   |

|        |                        |

|--------+------------------------>
  >----------------------------------------------|
  |                                              |
  |       To:     Multiple recipients of list    |
  |       ORACLE-L <ORACLE-L_at_fatcity.com>        |
  |       cc:     (bcc: William Dong/New York    |
  |       Life Asset Management)                 |
  |       Subject:     Re: Set Autotrace on      |
  >----------------------------------------------|

Eriovaldo:

If you don't have the PLUSTRACE role, you may get the excution plan but you can not get the statisic report. To make the autotrace fully function, you need to be granted the "plustrace role". If this role is not created yet, connect internal and run the $ORACLE_HOME/sqlplus/plustrce.sql file. Then grant the role to whoever pemitted to use autotrace.
Hope this can help

William Dong

|--------+----------------------->


|        |          "Eriovaldo do|

|        |          Carmo        |

|        |          Andrietta"   |

|        |          <eca_at_widesoft|

|        |          .com.br>     |

|        |                       |

|        |          02/14/01     |

|        |          10:30 AM     |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------|
  |                                              |
  |       To:     Multiple recipients of list    |
  |       ORACLE-L <ORACLE-L_at_fatcity.com>        |
  |       cc:     (bcc: William Dong/New York    |
  |       Life Asset Management)                 |
  |       Subject:     Set Autotrace on          |
  >----------------------------------------------|

Friends :

I have created the table Plantable on the schema and tryed the command bellow .
I received the error message but it works the plan of execution.

What can I do for don Received on Wed Feb 14 2001 - 13:16:23 CST