Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Technology Stocks : Oracle Corporation (ORCL) -- Ignore unavailable to you. Want to Upgrade?

To: Rick Kupcunas who wrote (10115)	3/15/1999 9:20:00 AM
From: Michael Olin	Read Replies (1) \| Respond to of 19080

Purely technical database stuff follows. You have been warned: The post scripts about tuning and certification were mine. As far as the testing goes, I'm not so sure that having to figure out what the wrong answers are is the best way to "certify" this type of knowledge. What if the "certified" DBA, trying to recover a database at work, without the benefit of 4 options listed so that the three wrong ones can be eliminated, cannot come up with the correct technique on his/her own? You should be able to recognize the "right" answer as being "right", not as simply being "not wrong". Regarding tuning: One of the nice features coming from Oracle is the ability to tune the SQL in packaged applications where you may not have access to the source code. This feature will allow you to store hints in the database that provide an optimized execution plan to SQL statements coming from your packaged apps. I'm told that the mechanism for matching SQL with their stored execution plan will be similar to the way that the shared SQL pool works in the SGA (character-by-character comparison, with an exact match required). If the packaged application is written reasonably intelligently (does it use static SQL with bind variables or does it generate SQL dynamically and include literals as selection criteria? It's a good first test.) you can optimize its performance to match the dynamics of your own particular site (lots of orders, few SKUs or lots of SKUs, few orders or lots of both, for example). It is a much better approach than actually going into the application and changing code that may come back to bite you with the next release. -Michael