Latest Answer: 1)Â connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need server reboot.3) SGA is dynamic i.e buffer cache and ...
Latest Answer: Isolated join is a join which is not connected to any of the context. ...
What is your server configration ?What is your SGA size ?what is Shared pool size ?How much size have you configured for oracle_block ?
Latest Answer: A materialized view (MV) is similar to a view but the data is actually stored on disk (view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system. A ...
Latest Answer: Truncate is faster because in case of truncate oracle don't create images in rollback segments i.e. it reduces the time of rollback segments ...
Latest Answer: When any DML operation is taking long time which may lead reuse of datablocks of undo segment by another DML, in this case oracle will throw snapshot too old error.For any DML oracle stores the undo image in rollback segment, suppose transaction A is ...
Latest Answer: Select command executes and retrieves all of the coulumns values are in table EMP. means you will see columns name and related data for every column from the table EMP ...
Latest Answer: REF CURSOR - This cursor could be used for processing more than one SELECT query. NORMAL COUSIR - This cursor could be ...
View page << Previous 3 4 5 6 [7]
Go Top
