I am developing software and administering database of CET (Common Entrance Test) Exams in one of the province on India. Hardware and platform I am using are:
- HP PIV machine as a server (1.6 GHz)
- 384 MB RAM
- Windows 2000 Advanced Server
- Oracle 8i (8.1.7)
How is your SGA configured? In other words, how did you allocate shared_pool_size, db_block_buffers, log_buffer and java_pool_size? You can get the total by typing in SHOW SGA in SQL*Plus while logged in as a DBA user. It sounds like you may need to look into your configuration.
Another thing to consider is that since you used SQL*Loader to bring the data in, you may need to gather statistics so the optimizer has "good" data on which to base execution plan decisions. Use either ANALYZE TABLE or the DBMS_STATS package to collect statistics on all the tables. This may help.
Did you look in v$session_wait when things bogged down to see what exactly was being waited on? This information is needed so you can know exactly what Oracle was doing. Until you know what is going on, you'll have a hard time "guessing" how to fix it.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.