Latest Answer: When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in ...
This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is
Latest Answer: better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold ...
How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?
Latest Answer: The storage array should contain one or more spare disks (often called hot spares). When a physical disk starts to report errors to the monitoring infrastructure, or fails suddenly, the firmware should immediately restore fault tolerance by mirroring ...
One DDL SQL script that has kept at certain location should be run on multiple servers to keep database synchronize. This task has to do in oracle database and this should be done as a job from scheduler. How will you do it?
Latest Answer: Initialization Parameter file.... ...
Latest Answer: Often the word "lock" is synonymous to enqueue. In this document, "enqueue" will be used for the locking mechanism that you can find in V$LOCK. "locking" will be used when talking about requesting an enqueue, waiting on an ...
When a user comes to you and asks that a particular SQL query is taking more time. How will you solve this?
Latest Answer: I assume you already figured this out, but if notsimplyuse dbNamegodrop table table1, table2, table3 ...
Latest Answer: snapshots can't upated. While MV can be updated contantley. ...
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>
Go Top
