Latest Answer: Segments The level of logical database storage above an extent is called a segment. A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace. For example, each table's ...
Latest Answer: Edit itit.ora file after shutdown the data base, set path for another control file in the parameter setting. then copy the control file to the desired location where the path is setting, then start the database. ...
Latest Answer: Better performance, proper use of space . ...
Latest Answer: PCTFREE : This clause is used for future updation, If you increase PCTFREE value, There will be less rows inserted in block ...
Latest Answer: Alter table < Table_Name> move tablespace ; Alter index rebuild tablespace ; ...
Latest Answer: It Sotres the Oracle Data Dictionery ...
Answered by: Lachi on 2005-06-08 07:28:04For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name'
Latest Answer: In above answer one correction is there, For perticular transaction we can use fallowing syntax. >set transaction use rollback segment 'name' ...
Latest Answer: The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is ...
Latest Answer: PGA - Program Global Area or the Process Global Area is a memory region that contains data and control information for a single server process or a single background process. The PGA is allocated when a process is created and deallocated ...
Latest Answer: Answer: Shared Pool Comprises library cache and dictionary cache.Library Cache stores and shares sql statements,where as pl/sql procedure in memory.And the Default size is 8mb. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
