R
Rob Fitzpatrick
Guest
> I think that one of the challenges we're running into with OEE is the use of its internal VST's I don't use OEE much and I don't use OEM at all, but I doubt this is enough to cause a simple query to take a couple of minutes to complete. The most egregious thing you can do with the VSTs is write a bad _Lock query and in 11.6.3 even that should be quick. If you have a large schema and a large user count then you can have a lot of records in _UserTableStat and _UserIndexStat. It's certainly possible to write inefficient queries on these tables that do table scans, but even for that two minutes sounds like an awful lot. So if you run ProTop (which I recommend) or your own queries against the VSTs then you won't have a performance problem.
Continue reading...
Continue reading...