• December 29, 2005 29 Dec'05

    Best organization of files on disks?

    I have a server with three disks (all in raid1). What is the best organization of the files (system, data, indexes, log, backup, etc.) on the disks to improve performance?  Continue Reading

  • December 29, 2005 29 Dec'05

    Can we improve the performance of a tool by eliminating joins?

    We have an SQL statement that selects data from four tables by performing a join operation. The number of rows in each table is in the millions. The query is being fired from one tool written in C++ . Since the query is taking a lot of time to ...  Continue Reading

  • December 29, 2005 29 Dec'05

    Keeping data recovery site active

    My current environment is 9i release 2 on AIX 5.3. I have an OLTP database with heavy trans rate, average 300 transactions per sec. The application type is online banking, responsible for buying and selling stocks online to thousands of users via ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close