Program Resp Time against Oracle

[j33@1]

Using the corporate edition against Oracle.

The database I'm using is its own domain on a Sun E15k and all our other applications that hit this are pretty damn snappy. I verified that there aren't any backups or network issues going.

The response time is very slow. I'm talking nearly a second to create an element in a diagram or move things around.

Any suggestions on how to get response time like I get against a EAP local file?

TIA

[Bruno.Cossi]

Never had an issue like that. Did you try to do some tracing to see what exactly is happening at the database?

Using the corporate edition against Oracle.

The database I'm using is its own domain on a Sun E15k and all our other applications that hit this are pretty damn snappy. I verified that there aren't any backups or network issues going.

The response time is very slow. I'm talking nearly a second to create an element in a diagram or move things around.

Any suggestions on how to get response time like I get against a EAP local file?

TIA

[j33@1]

I had the DBA research into the issue of problems he could uncover. He increased a table growth setting and that got a little bit of speed back. Other than that he says there is nothing in logs or locks.

[j33@1]

Just to be clear. It is still too slow.
Is this a type of question I should use registered support with?

[Bruno.Cossi]

If your database is setup in such a way that modifying the auto extents creates a noticeable difference when inserting a SINGLE row into a SMALL table, I suggest your DBA may not be up to the task.
The first thing to do would be to start the db tracing. Enterprise Manager or Quest Central will help.

The registered support with Sparx would definitely be a good way to go, perhaps they have encountered the same issue before?

I had the DBA research into the issue of problems he could uncover. He increased a table growth setting and that got a little bit of speed back. Other than that he says there is nothing in logs or locks.