Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Sun Legacy Management Platforms Archived Forums
N1 & Solstice
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 31, 2009 7:05 AM by
command-line cdb.ic.lbh painfully slow
Dec 30, 2009 7:54 AM
N1SPS version 6.0.4
I have an N1SPS database with a couple of hundreds of virtual hosts. The cdb.ic.lbh command takes more than 10 minutes per VH.
Is there anoter way to get the installed components per VH? In the Web UI performance is OK.
Edited by: ErwinRichard on Dec 30, 2009 5:53 AM
This content has been marked as final.
Show 1 reply
Re: command-line cdb.ic.lbh painfully slow
Dec 31, 2009 7:05 AM
in response to
Happy New Year!
After doing the following to my postgres db, return from cdb.ic.lb is instantaneous:
REINDEX DATABASE rox;
a report that took more than 3 hrs to complete, now runs in less than a Minute.