Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
N1 & Solstice
Oracle Technology Network Community (OTN)
Sun Legacy Management Platforms Archived Forums
N1 & Solstice
This discussion is archived
on Dec 31, 2009 1:05 PM by 807567
command-line cdb.ic.lbh painfully slow
Dec 30, 2009 1:54 PM
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 1:05 PM
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.