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
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
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
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
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
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
How to determine the number of concurrent processes in Oracle 10g
How can I find out the number of concurrent processes at any point of time in 10g database
Answer Question
| June 9, 2009 10:50 AM
Benchmarking oracle db, Oracle 10g, Oracle 10g administration, Oracle 10g concurrent processes, Oracle 10g performance, Oracle performance
How can I find out the number of concurrent processes at any point of time in 10g database
Answer Question
| June 9, 2009 10:50 AM
Benchmarking oracle db, Oracle 10g, Oracle 10g administration, Oracle 10g concurrent processes, Oracle 10g performance, Oracle performance
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1
