Purpose of Query
The purpose of this page is to provide a query to provide a list of complex objects in the CAST Central database
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.2.x |  |
| 8.1.x | |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
SELECT o.object_id "Object ID" ,
o.object_name "Object Name",
CASE dmr.metric_num_value
WHEN 2
THEN 'HIGH'
WHEN 3
THEN 'VERY HIGH'
END "Object Cost",
dmr.snapshot_id
FROM dss_objects o,
dss_metric_results dmr
WHERE o.object_id = dmr.object_id
AND
--dmr.snapshot_id = 9 and
dmr.metric_id = 65005
AND dmr.metric_num_value IN(2,3)
ORDER BY o.object_id;
Query result example
500;"xhr";"HIGH";12
811;"execOptions";"VERY HIGH";11
Query result interpretation
The query will list HIGH and VERY HIGH complexity objects and provide the associated object id, object name and snapshot id for these complex objects.
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Query for SQL server
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages
