Issue: dbForge Metadata Retrieval Query

Issue: dbForge Metadata Retrieval Query

Postby wi937c-amr » Wed 01 Aug 2012 20:39

Issue 1: dbForge's internal metadata retrieval query results in 100% percent utilization if sessions are Transperant Application Failover (TAF) enabled.

Issue 2: dbForge's internal metadata retrieval query does not perform well in large enterprise systems; generates an expensive execution plan, query may be improved by rewriting the query with large scale systems in mind. (Items to Note: use of * in queries, turning views into aliased sub queries unecessarily)

Observation: dbForge's assumes user has access to 'SYS' schema

Metadata Query:

Code: Select all
SELECT ao.object_id woner_id, atc.column_name, case when etc.nullable = 'y' then 1 else 0 end as is_nullable, atc.data_type, atc.data_length, etc.data_precision, etc.data_scale
FROM (select object-id, object_name, owner, object_type, generated
FROM all_objects where owner ='SYS') ao inner join
(select * from all_tab_columns where owner ='sys') atc on ao.object_name = atc.table_name and ao.owner = atc.owner where upper(ao.object_type) in ('table', 'view') and ao.generated = 'N' order by ao.object_id, ao.object_type, atc.colum_id
wi937c-amr
 
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Re: Issue: dbForge Metadata Retrieval Query

Postby alexa » Thu 02 Aug 2012 15:03

We are currently investigating this issue and will get back to you with a result as soon as possible.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Re: Issue: dbForge Metadata Retrieval Query

Postby alexa » Thu 10 Oct 2013 16:44

We would like to let you know that the release of dbForge Studio for Oracle v3.5 is already available for downloading.

If you are a registered user and your subscription is not expired, you can download it from Registered User's Area at http://secure.devart.com using the login and password received in an e-mail from Devart Sales department when purchasing the product.

If you are not a registered user, you can download dbForge Studio for Oracle, v3.5 at http://www.devart.com/dbforge/oracle/studio/download.html

Thank you for your help in improving dbForge Studio for Oracle.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle