Ask the Expert

Performance problems with Vignette on top of Oracle

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!

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: