Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / Oracle
Showing: 1-10 of 45    »»
Articles
 
document What are the basic element of Base configuration of an oracle Database ?
It consists of one or more data files. one or more control files. two or more redo log files. The Database contains multiple users/schemas one...
07 Oct, 2007 Views: 695 Comments: 35
document What is a Schema ?
The set of objects owned by user account is called the schema. 
07 Oct, 2007 Views: 651 Comments: 47
document What is Parallel Server ?
Multiple   instances   accessing  the  same  database  (Only  In  Multi-CPU environments) 
07 Oct, 2007 Views: 617 Comments: 46
document What is a Database instance ? Explain
A  database  instance  (Server) is a set of memory structure and background processes that access a set of database files. The...
07 Oct, 2007 Views: 659 Comments: 37
document How can you gather statistics on a table?
The ANALYZE command.
07 Oct, 2007 Views: 636 Comments: 49
document Oracle PL/SQL - Introduction
02 Aug, 2011 Views: 579 Comments: 0
document How can you enable a trace for a session?
Use the DBMS_SESSION.SET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;
07 Oct, 2007 Views: 620 Comments: 39
document What is the difference between the SQL*Loader and IMPORT utilities?
These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced...
07 Oct, 2007 Views: 625 Comments: 34
document Name two files used for network connection to a database.
TNSNAMES.ORA and SQLNET.ORA
07 Oct, 2007 Views: 601 Comments: 38
document How do you add a data file to a tablespace?
ALTER TABLESPACE <tablespace_name> ADD DATAFILE <datafile_name> SIZE <size>
07 Oct, 2007 Views: 641 Comments: 34


RSS
Powered by KBPublisher (Knowledge base software)