how to detect and improve oracle database performance issues?
361517
well thats a huge question.....there are literally books on this topic....\n\nread oracle 9i performance tuning tips and techniques by richard niemiec\n\nbut u can start with this...\n\nrun statspack on ur database for the high load periods\nrun tracing on the main sessions at level 12 \nsee explain plans of the queries those sessions are executing.\nsee v$session_wait for any waits
461228
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=58
484774
Query the RDBMS's internal schema for that information. Also can check data types using regex on values, as well as defining meta-data for test you want to run, and a utility script to use it against defined tables.  (If the database is set up correctly, you shouldn't experience anomalies in the first place.)
539222
http://asktom.oracle.com\n\nThis is one of the best site for all types of your Oracle9i Queries. This has the information with some of the examples.\n\nhttps://cwisdb.cc.kuleuven.ac.be/ora10doc/appdev.101/b10807/loe.htm\n\nhttp://www.ss64.com/ora/
37804
There is two way to solve this problems:\n1)Close some unwanted application that is running time error is occur.\n2)second way is increase the virtual memory there is three option\n  i)Custom Size: in that we provide size depand upon system drive size\n ii) System Manage Size: this is best option for most os(Recommanded)\n iii) No page file\n\nSO according to your requirement you can set your virtual memory if you don't know how much memory you want to require then go with "system manage size" .
196431
Oracle is a Client/Server database system. Where do you live?
1007417
Hi..\nCheck out the following page...this might provide your some insight on Query Optimizations...\nhttp://www.sqlsummit.com/Optimization.htm
499628
To improve performance of the server, perform all validation which can be done from the client and sends refine data to server which reduces worden on the server,  increase performance and make client free from irritation.
623284
I would recommend Oracle Application Development Framework (ADF) and JDeveloper as a tool.  Oracle have done all the hard work!
872510
your internet server is most likely too slow
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
1122852
Try here:\n\nhttp://www.oraclesource.net/index.php
1132129
Read this short review:\nhttp://en.wikipedia.org/wiki/DBMS
433780
If you are looking to fix errors beyond disk cleanup and defrag, try uniblues registry booster. Alot of problems in windows get bloated from daily installs and downloads. It's amazing how fast a new cpu can become filled with deadends.\nA good well designed registry checker really cleans up alot of loose ends.\nHope this helps.
1078970
use jasperreports these are free and best\n\nget it from sourceforge.org
117633
I'm only answering this because I haven't seen anyone else.  I'm not an Oracle DBA, but I have extensive experience in SyBase.\n\n1) Look through your doc for a thing called sqlloader - this is the thing Oracle provides to do the job.  Basically, unloading a table using sqlloader takes the data in your table and writes it in a format that sqlloader can rewrite.\n\n2) If you are really good at PL/SQL, you can write you own unload/reload process (this is what I have to do to move data from one RDBMS to another, like from Oracle to Sybase).  Write a program that generates as output the SQL Insert statements needed to load your data.  In other words, it writes on Insert statement for every row that already exists.
334376
ARE U going for oracle 11i or 10g?