Oracle database performance problems and tuning

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Questions about plan stability

    Plan stability is a major concern for me right now. Frequently when I update stats, a plan(s) changes and I get into hot water. I'm investigating stored outlines, but I have some concerns.  Ask the Expert

  • What criteria determines when code should be pinned?

    What criteria determines when code should be pinned? Using the following SQL do I pin those with the most loads? Runs? Or some other criteria?  Ask the Expert

  • Performance probem with INSERT statement

    I am facing a performance problem with an INSERT statement inserting records in one transaction table. The table has around 20 columns and all are NOT NULL columns. It has seven indexes and many constraints. There are many concurrent inserts happenin...  Ask the Expert

  • Performance problems with Vignette on top of Oracle

    We are using Vignette IDM 19.2 on top of Oracle 9.2 i. Vignette creates a table to store references of documents. In our case we end up with a table containing several bilion rows, thus adding new documents to the IDM storage becomes slower and slowe...  Ask the Expert

  • Best organization of files on disks?

    I have a server with three disks (all in raid1). What is the best organization of the files (system, data, indexes, log, backup, etc.) on the disks to improve performance?  Ask the Expert

  • Developing a performance monitoring tool

    I want to develop a performance monitoring tool for Oracle. What are the important parameters I should consider? This tool must be independent of any platform. Which language would you suggest to use?  Ask the Expert

  • Problem with quick generation of archive log files

    I am using Oracle 9i release 2 with patch 5 as my production database in archive log mode. Yesterday users complained that performance are going down. I checked the database and found that archive log files are generating very quickly, nearly two arc...  Ask the Expert

  • Can we improve the performance of a tool by eliminating joins?

    We have an SQL statement that selects data from four tables by performing a join operation. The number of rows in each table is in the millions. The query is being fired from one tool written in C++ . Since the query is taking a lot of time to execut...  Ask the Expert

  • Wily bridges gap between apps managers and DBAs

    A new tool from Wily Technology Inc. aims to bridge the technological divide between applications managers and DBAs.  Article

  • Design help for Oracle Roles when front-end application is not Oracle

    I am maintaining a client/server application written in Delphi 7 using an Oracle 9i database (we are using Direct Oracle Access components to do the Delphi to Oracle connection) and I would like to get some menu control design suggestions. The curren...  Ask the Expert

Back to top