Having trouble opening Server Model Diagram in Design Editor 1

[mcao]

Whenever I try to open up a server model diagram in Design Editor, it takes more than 10 minutes to open. What can be the cause of this?

 

[sem]

Performance of Designer as well as of any client/server application may depend on 3 factors: database, network, client. Your database server may be too weeak or not tuned well, network connection may be slow and at last client PC may not suit Designer's requirements. If you don't experience problems with other designer tools, it's probably your PC problems. But in any case analyzing Designers schema (you may use RAU for this) shouldn't do much harm.

Regards, Dima

 

[mcao]

Thank you, Dima, for your quick response. Your input is very helpful.

 

[mcao]

Hi,

I checked the RAU and noted that the temporary tablespace was completely maxed out. Is there a way for me to build an extension to it, another physical tablespace?

 

[sem]

Temporary tablespace (if it's really TEMPORARY) always is almost full. It's freed only on database shutdown (or startup, not sure). Though sorting in permanent tablespace may kill performance.

Regards, Dima

 

[mcao]

Hi Dima,

I restarted it and extended it (double in size) but its still telling me that I've maxed out the capacity. Is there anything else I can do?

 

[sem]

You're probably not familiar with Oracle concepts: temporary tablespace is extended by need and shrinks only on restart. So it's always full and this is not an issue.Is your SGA large enough? Have you analyzed your Designer schema? How many entities does your diagram contain?

Regards, Dima

 

[mcao]

I've restarted the system temp tablespace and it cleared up the problem, however, when I tried to do the same to the repository temp tablespace, nothings change. It still shows that the temp tablespace is maxed out. I've checked the SGA and its fairly sized. As for the entities, we have over 30. I didn't have a problem loading the ERD from the Entity Relationship Diagrammer but only with the Server Model Diagram. Do you think maybe its because of the many tables and its relationships?

 

[sem]

I don't think so, because I successfully open diagrams with compareble number of entities. Have you analyzed repository schema? BTW, I'm not sure that Repository temporary tablespace is temporary in Oracle terms: it just contains some temporary objects.

Regards, Dima