Displaying 4 results from an estimated 4 matches for "_catalog".
Did you mean:
catalog
2006 Feb 07
5
OCI adapter slowdown on dictionary access
Hi,
after some experience with Rails on MySQL databases I gave it a try on one
of our larger Oracle database.
I was facing a problem when Rails tried to detect the columns for a
model/table. The appropriate statement ran about 1 min which led to a
timeout.
Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t
helped, he said the only remaining chance is to use a
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
...as to run this query
for each view
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 user_catalog cat, user_synonyms syn, all_tab_columns col
where cat.table_name = ''USERS''
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, user)
I am assuming that this is because development mode can'...
2012 Feb 29
4
Windows Puppet 2.7.12rc1-7-g281901e hands at end of run
...esource.rb:282:in
`new''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource.rb:282:in
`to_ral''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:
618:in `s
end''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:
618:in `t
o_catalog''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:
596:in `e
ach''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:
596:in `t
o_catalog''
C:/Dev/tools/Ruby187/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:
521:in `t
o_ral'...
2006 Mar 23
11
ActiveRecord: Oracle metadata loading slow on large database
...thod generates the following SQL:
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 user_catalog cat, user_synonyms syn, all_tab_columns col
where cat.table_name = ''#{NAME_OF_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, user)
At first glance, the query looks okay. Oracle sho...