Archive for the ‘Oracle’ Category
Improving SQL*Loader’s Performance
Posted by: hernk on: 29 January 2009
- In: Oracle| Programming
- 2 Comments
# by Sanjay Mishra
Drop indexes before loading data
If you are loading a substantial amount of data, I recommend dropping the indexes on the target table before doing the load. Index maintenance takes time, and it generates extra disk I/O.
Each time a new row is inserted into a table, all the indexes for the table must [...]
How to check Oracle Instance is Up or Down
Posted by: hernk on: 22 December 2008
- In: Oracle
- 2 Comments
Here is the simplest way how to know whether oracle instance is up or down :
1. Try to connect to oracle using sqlplus /nolog
2. And then put code conn /as sysdba
3. Let see in v$instance using query : select status from v$instance;
If the result is OPEN, it means that the Oracle is already up but [...]
Mencari software terbaik di dunia pengganti TOAD
Posted by: hernk on: 17 May 2008
- In: Oracle| PL/SQL| Programming| Technology
- 3 Comments
TOAD – Tools of Oracle developer memang tools terbaik yang pernah saya gunakan untuk pl/SQLnya oracle, namun salah satu kelemahan dari TOAD adalah harga licence-nya yang cukup mahal – denger-denger sih bisa mencapai $800/licence. So, daripada beli mahal-mahal mencari tools pengganti TOAD adalah salah satu alternatif terbaik. Dari hasil bertanya kepada paman Google beberapa tools [...]
Deadlock detected while waiting for resource
Posted by: hernk on: 26 January 2008
A deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing.
Oracle automatically detects deadlocks and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that [...]
ORACLE 9i and MySQL eWeek Benchmarks
Posted by: hernk on: 10 July 2007
February 2002 eWeek Benchmarks
In a February 2002 database benchmark test performed by Ziff Davis Media Inc., the company behind PC Magazine, eWeek and other well-known publications, the MySQL database server stands out as a winner. The MySQL server is presented as having the overall best performance and scalability along with Oracle9i. Also, the MySQL server [...]
Recent Comments