• September 08, 2006 08 Sep'06

    What is an instance?

    What is an instance? Can we open more than one instance in a machine?  Continue Reading

  • September 08, 2006 08 Sep'06

    How to query a query

    I am using two functions in a Select statement. Let's say A and B are functions which contain large code, and both functions return a numeric data type only. In the Select statement, I want to subtract those two functions.  Continue Reading

  • September 08, 2006 08 Sep'06

    Long-running query causes "snapshot too old" error

    I have a production database and I am receiving the "ORA-1555: Snapshot too old" error when a long-running query is executed. I tried changing the UNDO_RETENTION to 40,000 seconds (as the query takes more than 24 hours to complete processing). The ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close