Topic: Performance & Tuning >> Load of packages in SGA
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Load of packages in SGA |
| csk |
Posted: May 19, 2003 04:29:00 AM |
Total Post: 1
Joined: Jan, 2003
|
i want to know if packages are loaded in SGA by every user who call the package or the package is loaded only once when the first user call it and it is shared by all users (all sessions) ?
best regards
AN
|
|
|
 uadmin |
| Posted: May 19, 2003 09:37:00 PM |  |
|
Total Post: 6
Joined: Jan, 2003
|
Package code is loaded in the library cache of shared pool. This code is loaded into library cache when user makes first call and stored in it until you flushed the shared pool or instance restarted. If other requests that are coming from other users for the same code then those request will use the same code. It will not be reloaded again.
You can also pin a pl/sql objects and that can be share among users. Read about dbms_shared_poll package.
Regards,
Rob
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 268 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
