Q

Performance problems with Vignette on top of Oracle

We are using Vignette IDM 19.2 on top of Oracle 9.2 i. Vignette creates a table to store references of documents. In our case we end up with a table containing several bilion rows, thus adding new documents to the IDM storage becomes slower and slower. Would you have any advice on this subject?

We are using Vignette IDM 19.2 on top of Oracle 9.2 i. Vignette (ex Tower) creates a table to store references of documents. In our case we end up with a table containing several bilion rows, thus adding new documents to the IDM storage becomes slower and slower. We have tried to create an IDM application in a standard way, drop the table and re-create it as a partitioned table. Unfortunately, for reasons which even Vignette is not...

(yet?) able to explain, the table is not recognized by the IDM application.

We are thus looking for other ways of dealing with such a large table (still growing). Would you have any advice on that subject? Any guidance would be very much appreciated!

What do you mean by "the table is not recognized by the IDM application"? I'd certainly want to get that resolved, as partitioning is probably your best bet here. Is there a privilege issue? Does the IDM application connect to Oracle as the schema owner, or as some other user? If it's the latter, log in to Oracle as the user that IDM uses to connect, and try to query the table -- there may be a grant missing, or perhaps a synonym is required. If you haven't already resolved the problem, please post the results and let's go from there.
This was first published in December 2005

Dig deeper on Oracle data and application integration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close