ppt课件-p l q enhancementsin database11g oracle（ p l s q l enhancementsin oracle database11g）.pptVIP

* Could use to identify pl/sql function result cache candidates. Used to improve APEX by 15% in 11g test lab Reports … number of calls to the subprogram time spent in the subprogram itself time spent in the subprograms subtree detailed parent-children information * * * Most of our XDB customers are using O-R storage, which works very well for suitable cases Where it does not work, customers use LOB storage, where the entire document is stored and retrieved In 11g, we have improved O-R storage and made LOB more functional * 90% XML is in collections stored as nested tables 10.2 no way to equ