Latest Answer : Characteristics of a Data File :
- A Data file can be associated with only one tablespace.
- Once created, a datafile can be increased or decreased in size with RESIZE
command. Example: ALTER database datafile '/u03/oradata/dev01/users_02.dbf'
RESIZE ...
A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The
Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ...
It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary
Latest Answer : Server process writes the data block it read from the database to the buffer. DBWR process writes data from buffer to database. ...
Latest Answer : DBWR only writes to the data files. So the answer is Server Process. ...
You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using: 1) select * from dba_data_files; 2) select * from v$logfile; 3) select * from v$controlfile;
Latest Answer : In Oracle 10g, there is a new command to drop an entire database.Startup restrict mount;drop database ; ...
query v$log
Latest Answer : select sum(bytes)/1024/1024 size_in_mb from v$log; ...
The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical
Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ...
These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide
Latest Answer : The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creation tasks you would normally perform manually are performed ...
