Forum: Ruby on Rails RE: OCI adapter slowdown on dictionary access

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
60e38de043848f82392062088f191213?d=identicon&s=25 Hogan, Brian P. (Guest)
on 2006-02-07 17:23
(Received via mailing list)
That /*+ RULE */  is a hint to the optimizer that tells Oracle to
actually bypass the optimizer.



Try this too.. This statement will work:

	          table_cols = %Q{
	            select column_name, data_type, data_default,
nullable,
	                   decode(data_type, 'NUMBER', data_precision,
	                                     'VARCHAR2', data_length,
	                                      null) as length,
	                   decode(data_type, 'NUMBER', data_scale, null)
as scale
	              from (select table_name from #{scope}_catalog
where table_name = #{table}) cat,
	                   (select * from #{scope}_synonyms where
synonym_name = #{table}) syn,
	                   (select * from all_tab_columns) col
	             where cat.table_name = #{table}
	               and syn.synonym_name (+)= cat.table_name
	               and col.table_name = nvl(syn.table_name,
cat.table_name)
	               and col.owner = nvl(syn.table_owner, #{(scope ==
"all" ? "cat.owner" : "user")}) }


Works for us here. I had an initial fix but it failed for synonyms.
Then I tried EXACTLY what you tried and it didn't work for various
permissions.
This topic is locked and can not be replied to.