谁能解释一下oralce游标open原理吗？

Yong Huang

Indeed. Shared server configuration is only needed on very high concurrent systems. At least in late 2007, most of eBay's Oracle databases were still using shared server config. Since then, they gradually migrated some Oracle to MySQL. The remaining ones are likely still using shared server.

It's better to say private cursors and their related data and structures are in UGA even if you use the dedicated configuration. It's just more relevant, even though saying they are in PGA is technically correct.