|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE. ... 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 ; ... You can query dba_data_files and dba_temp_files Latest Answer : At oracle level query data files + tempfilesAt OS level use df -k or du -h ... 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
