Oracle Performance

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 ??? Software/Hardware used:...

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

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: system...

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?

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...

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 turn it off...

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...

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 regards.

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 ?

performance and tuning examination guides

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

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 4 SAS 72 GB HDD RAID 5. Wetried...

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 Specific...

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 server affect...

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?.

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 environments (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...