1
  • Oracle perfomance tuning

    How to tune Oracle SQL queries. Please tell me step-by-step.

    QgyOgtX5 pointsBadges:
  • 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 the...

    Garimapawa5 pointsBadges:
  • 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...

    Darryn765 pointsBadges:
  • 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?

    Liveena5 pointsBadges:
  • 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 ???

    ITKE346,465 pointsBadges:
  • 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

    DBASAB5 pointsBadges:
  • 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...

    NormD5 pointsBadges:
  • 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?

    62625 pointsBadges:
  • 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,...

    Ws8oBPSQ15 pointsBadges:
  • 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 and...

    Jwwolff10 pointsBadges:
  • 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.

    Stecjohn15 pointsBadges:
  • 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...

    AGDAVA35 pointsBadges:
  • 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 ?

    Gopas5 pointsBadges:
  • performance and tuning examination guides

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

    Cece5 pointsBadges:
  • 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 changing...

    Vksumanlal5 pointsBadges:
  • 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 Parameters to...

    Eklavya5 pointsBadges:
  • 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?.

    Newbietech5 pointsBadges:
  • 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 and...

    OracleATE190 pointsBadges:
  • 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...

    PERFORMANCE TUNNING5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following