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

  • Partitioned vs. non-partitioned tables

    I'm attempting to address some performance issues by using list partitioning. As an experiment I created two small tables (with about 1,000 rows) of vehicle maintenance data, one with no partitions and the other partitioned by vehicle type. Queries ...  Ask the Expert

  • Slow for loop cursor

    I have three tables, A, B and C. Table A has 450,000 records, and B has 80,000. I have created a for loop cursor on table A and check B in that loop. If a record is found in B then I want it to be inserted in table C. But I waited eight hours for it...  Ask the Expert

  • Slow "create table" statement

    I have two servers; one is Oracle 8.1.7.4 on Unix, the other is Oracle 9.2.0.1 on Windows. I tried this SQL command: "create table xx as select * from table1@server2." This statement is very slow (43 seconds), but the query is very fast (0 to 1 secon...  Ask the Expert

  • Database fully utilized with hang

    Our database is Oracle 9.2.0.4 running on Linux AS 3.0. Our database is around 110GB and has 16GB RAM. Even though we have set the parameters in SGA_MAX_SIZE to 12G, shared pool size as 2G, db_cache as 4G and pga_aggregate as 800m (changed to differe...  Ask the Expert

  • Improving performance of inserts

    First we read records from three different tables and insert into a temp table. From the temp table I fetch the records one by one, do some calculations and insert into another table if the record is new. If it already exists then I update the final...  Ask the Expert

  • Determining a query's response time

    How do we determine a query's performance (response time)? Can you please tell me the steps?  Ask the Expert

  • Defragmenting schemas with LMT

    We have Oracle 9i databases using bitmap tablespaces (LMT). Now it's time to defragment a few schemas, because few tables have more than 60 extents; how could we do that? I know the normal export (compress=y) and import will not work on LMT.  Ask the Expert

  • Oracle unveils free SQL Developer: Has Toad met its match?

    Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.  Article

  • Function index for column with 80% unique records

    I am having problems indexing a column where 80% of the 65,000 records are unique. Four times a day we get a data feed and insert, update and delete 2,000 records from the table. The particular column is a VARCHAR2(21). I have a query that takes 10 ...  Ask the Expert

  • Faster reading of tables with many rows

    I have two tables; one is a header and the other is a detail. The header table has nearly 400,000 rows, whereas the detail table contains 1,200,000 rows. At any given time there will be around 60 users connecting to the server through a VPN. My prob...  Ask the Expert

Back to top