;) |
| In this Issue | |
| From the Editor: | |
by Tim DiChiara, Site Editor
Performance tuning is perennial favorite topic among searchDatabase.com members, for good reason: it's one of the major responsibilities of a DBA. The Oracle RDBMS is obviously a very sophisticated, highly flexible, and eminently tunable product. There are a myriad of tuning methods and scripts out there, but they all have two basic goals: decrease the time end-users spend waiting for a response (in decision support applications), and maximize throughput (in OLTP systems). In both these cases, poor Oracle performance ultimately translates into decreased productivity and thus money down the drain. I can already hear the DBA's protesting: But wait! We aren't the only ones who have a role in tuning! Yes, it's true: multiple groups of people in the organization must cooperate and communicate to achieve maximal performance. Business execs must clearly define business rules. Application designers must avoid performance bottlenecks. Developers must implement efficient SQL statements. And, of course, the DBA must monitor and correct problems with system performance. Then there are the network admins, and the.... Wouldn't it be easier if Oracle tuned itself? That is the precisely the goal that the company is striving toward. In 9i, self-tuning is becoming easier and more effective than ever before. This week, searchDatabase is presenting an excellent opportunity to pose your Oracle self-tuning questions to one of the world's top Oracle experts. Don Burleson has more than 20 years of full-time DBA experience, has written a dozen books -- including Oracle high-performance SQL tuning -- published more than 60 articles in national magazines, serves as Editor-in-Chief of Oracle Internals magazine, and is owner of BEI Oracle Consulting. Join us on Wednesday, Feb. 27 for what's sure to be an educational event! Till next time, Tim DiChiara, Editor |
| Featured Topic: | |
Tuning Oracle
by Tim DiChiara, Site Editor
A slow database is not only annoying to users, it can also affect your company's bottom line. The collection of Oracle tuning tips and advice inside will help you achieve maximal speed and reliability for your Oracle system.
Read more about this topic
|
| Expert Technical Advice: | |
Featured Expert: Jorge Cano, Industrial Technology Consultant, Jeld-Wen
Category: SQL Server
Jorge has extensive client/server design, development and implementation experience and is a Microsoft Certified Professional and Microsoft Certified Trainer in SQL Server 7.0, MS VB 5/6 and MS Access 97/2000. Ask Jorge your toughest SQL Server questions!
View all of Jorge's answers |
| This Week: In the forums |
| >> |
Migrate queries from Access to MySQL
Member "Tsi Lok" has been trying to migrate his database from Access 97 to MySQL. Since MySQL doesn't have stored procedures, is it possible to to store the Access queries in MySQL? Go to our "Database-web connectivity" forum if you can lend Tsi Lok a hand. |
| >> |
SQL Server 2000 RAID set
Member "Karthik" is using SQL Server 2000 on Win2000, with two I/O controllers with dual bus (channel). He wants to know if the data sets transferred will be split across two channels (in a controller) in a balanced way to get a maximum throughput. Any help out there? If so, go to our "Database-web connectivity" forum. |
| Tip of the Week: |
| This SQL Server batch file demonstrates the power of both OSQL and Windows command extensions. It is used to calculate the size of user tables -- very useful in big databases. |
| >> |
Estimate table size using command extensions |
| Site Highlights | |
|
|
| Attend IOUG Live! |
| IOUG Live! 2002, April 14 - 18 in San Diego is THE Education Conference for Oracle Users by Oracle Users. Visit the IOUG web site to review session abstracts and register. |
| Register Today |
|
| Business Continuity |
| This workbook provides a guide to a topic more relevant now than ever. Click for details and ordering information. |
| Click Here! |
|
| iSeries 400 Advice |
| Whether you're an iSeries 400 programmer, administrator, or busy maximizing WebSphere's potential, search400 offers FREE tech tips from top iSeries 400 Experts. |
| Sign Me Up! |
|
|
|
