| jayesh |
Posted: Jan 07, 2008 09:00:48 AM |
Total Post: 60
Joined: Jan, 2008
|
| how can i keep procedure in memory which is called oftenly. |
|
|
 Mohammed Taj |
| Posted: Jan 07, 2008 09:41:20 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
dbms_shared_pool.keep package.procedure will help you.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221
|
|
|
|
|
| jayesh |
| Posted: Jan 07, 2008 09:52:08 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
thanx for guidance but can u pls explained it in detail. i checked the link but still .........
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 07, 2008 10:42:05 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
what part of link you didn't understand ?
http://www.psoug.org/reference/dbms_shared_pool.html
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
