2377648 - Slowness when modifying Physical Options (Common) of Oracle 12c PDM - SAP PD | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2377648 - Slowness when modifying Physical Options (Common) of Oracle 12c PDM - SAP PD

Symptom

  • Selecting or deselecting some options in the Physical Options (Common) tab is very slow when the Physical Data Model (PDM) targets Oracle 12c.
  • When Not clustered is deselected, the Output displays the following in the Script tab:

GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:Start
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:end; value=
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:Start
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:end; value=
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:Start
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:end; value=
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:Start
GetEx_ORA12C_Table_IsClustered__Crit___PhysicalPropertiesClusterColumn:end; value=

  • Response times are a lot better and the Output remains empty when the target DBMS is Oracle 11g.

Read more...

Environment

  • SAP PowerDesigner (PD) 16.6 SP01
  • Oracle Version 12c

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6

Keywords

perf, performance, quick, fast, responding, 802783, CR802783, CR#802783 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.