Oracle performance Questions

1

Strange Oracle 9i behaviour
We are seeing some very strange behaviour in the performance of a query on our database. We have run the same query on the actual database server (s1) using sql+, and on a server (s2) 1 hop away (taking out network performance). The exact same queries, without any bind variables, are kicked off at exactly the same time. The [...]

Answer Question   |  March 28, 2011  1:43 PM
Oracle 9i, Oracle 9i performance, Oracle performance, Solaris 10, SQL Plus
asked by:
765 pts.

Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement
asked by:
5 pts.

Tunning and Performance in Oracle 8i
we have a 20 users accessing application of vb and database is oracle 8i from morning server runs fine till after noon it slow down then we need ot restart the database then again for an hour it works fast but again it gets slow donw can you please suggest what to do ???

Answer Question   |  August 15, 2009  2:31 PM
Oracle 8i, Oracle performance, Tunning and Performance
asked by:
16,755 pts.

asked by:
5 pts.

Windows performance setting for Oracle
We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I’m looking at at the OS level is: - Paging: [...]

Answer Question   |  May 13, 2009  5:17 PM
BMC, BMC Remedy, Oracle 10g, Oracle Database, Oracle performance, Windows Performance
asked by:
5 pts.

How number of processors correlated to Oracle database size
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?

Answer Question   |  April 27, 2009  9:16 PM
Oracle on Linux, Oracle performance, Unix Server sizing, Unix Servers
asked by:
626
25 pts.

Oracle SQL*Loader (sqlldr) performance tuning
Good day, I try to optimize sqlldr, but don’t know how to set the parameters. I am trying to load 21,000,000 records per day, but currently don’t manage to load all data in time. The loading is always 1 day behind. I am using conventional loading (I cannot disable indexes before and after loading, because [...]

Answer Question   |  December 11, 2008  6:48 AM
Oracle DBA, Oracle performance, Oracle SQL*Loader, Oracle sqlldr, SQL*Loader
asked by:
15 pts.

Oracle Statspack
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I’d turn is off at 5pm the next day. I did not [...]

Answer Question   |  December 4, 2008  8:26 PM
Oracle 9, Oracle 9.2.0.7, Oracle administration, Oracle Database, Oracle performance, Oracle Statspack
asked by:
10 pts.

Need to update nearly 3cr rows in Oracle table
HI , My database is oracle 8.0 vesion.i need to update the customer_id in in table with new_customer_id. for the smaller table my simple update is working fine .. when i fired the same update for the big tables ( 30000000 rows), its running for 10 hrs and failing with rollback segments. can any one [...]

Answer Question   |  November 13, 2008  2:14 AM
Oracle 8, Oracle 8 performance, Oracle performance, Oracle Table
asked by:
35 pts.

Oracle9i Performance Issue
I got Oracle9i R2 database running on windows 2003. On a very busy day I got very bad performance with Average Disk Queue Length very high on the performance monitor. There is heaps of free RAM and I am running Raid 10. I am still new to Oracle, so I need some help. Thanks and [...]

Answer Question   |  November 20, 2008  11:15 PM
Average Disk Queue Length, Oracle 9i, Oracle 9i performance, Oracle performance
asked by:
15 pts.

Insert Speed
I want to insert 2MB of data into an oracle database in 1 second. Is it possible?. How much data can be inserted/sec ?

Answer Question   |  August 25, 2008  4:49 AM
Oracle performance
asked by:
5 pts.

performance and tuning examination guides
What would you recommend as good study guides for performance and tuning 9i exam

Answer Question   |  August 21, 2008  3:35 PM
Oracle 9i, Oracle performance
asked by:
5 pts.

Report taking long time before opening
Hi All We are running Oracla based ERP solution. 9i , D2K and JVM. Everyday after 6 PM all the reports are taking long time before opening I am using HP Proliant DL 380 G5 server with 2 GB RAM having 2 partitions . C mirrored 2 x 72 GB SAS HDD. D drive with [...]

Answer Question   |  August 14, 2008  3:25 PM
D2K, ERP, JVM, Oracle 9i, Oracle Developer 2000, Oracle performance
asked by:
5 pts.

Oracle Database’ Optimization Criteria
Hi ALL, I want to know – - What are the Criteria upon which one can say that Oracle Database is Designed, Set Up and is Running Optimally ? - Beside BRTOOLS ( in SAP on Oracle Db), is there any other Tool through which we can Validate the Oracle Database Structure ? ( Any [...]

Answer Question   |  August 7, 2008  9:05 PM
Oracle database design, Oracle performance
asked by:
5 pts.

DNS Server change effect on oracle connections
Hello, There is going to be a change in DNS server at our site. Also, there is going to be migration from Static to DHCP IP, but it has been assured to us that IP address will not change. All our databases are accessed via DNS alias entries in TNSNAMES.ora. Will a change in DNS [...]

Answer Question   |  August 8, 2008  11:39 AM
DHCP, DNS, Oracle performance
asked by:
5 pts.

Oracle/Unix What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.
What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.

Answer Question   |  July 8, 2008  3:29 PM
Oracle, Oracle performance, Unix, Unix Solaris
asked by:
5 pts.

Oracle performance under NT versus Linux environments
When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec. When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec – nearly 100% drop in performance. The explain plans are the same for both [...]

Answer Question   |  May 23, 2008  3:21 PM
Linux, Oracle, Oracle performance, Windows NT
asked by:
190 pts.

performance tunning
Dear sir/mam, From last 2 weeks,ur database performance id very slow.plz guide me how to solve the problem. i giving ddetails of spreports,it may be help to resolve the problems. give me solutions as soon as possible. STATSPACK report for DB Name DB Id Instance Inst Num Release OPS Host ———— ———– ———— ——– ———– [...]

Answer Question   |  March 27, 2008  2:47 AM
Oracle, Oracle performance
5 pts.

1