All geek questions in one place

Oracle 10g - slow metadata requests

We recently upgraded to 10g, and I noticed that metadata requests seem to take an extremely long time (assuming 2-5 times slower than 9i). Has anyone else noticed this? Any suggestions on how to fix this problem (tweaks / fixes / spells)?

Thank.

+3
source share
1 answer

If you have access to Oracle Metalink (MyOracleSupport, or what they call today), find bug # 2475998, DRAMATIC DROP IN PERFORMANCE, USING SYNONYMS BY SETINCLUDESYNONYMS. The applicant reported a 60-fold deterioration in the performance of DatabaseMetadata.getColumns () when synonyms exist. Oracle recommends getting the metadata in some other way, for example. execute a dummy request and get ResultSetMetaData.

Also see Jack Shirazi Java Performance Tuning , which has a section for retrieving database metadata . (link to extract from Google Books)

Bottom line: do not use DatabaseMetadata.getColumns ().

+2
source

Source: https://habr.com/ru/post/1728542/

More articles:


All Articles