1 2 3 4 5 6 > >>   Sort: Rank

What Is a Database Schema in Oracle
What Is a Database Schema in Oracle? A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include: tables, views, ...
2020-11-22, 841👍, 0💬

Relations of a User Account and a Schema in Oracle
What Is the Relation of a User Account and a Schema in Oracle? User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) ...
2020-11-22, 804👍, 0💬

What Is a Table Index in Oracle
What Is a Table Index in Oracle? Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster acce...
2020-11-22, 783👍, 0💬

What Is a Database Table in Oracle
What Is a Database Table in Oracle? A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, a...
2020-11-22, 781👍, 0💬

What Is a User Role in Oracle
What Is a User Role in Oracle? A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials
2020-11-22, 677👍, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle database. Here is a list of frequently asked questions and their answers on Oracle basic concepts compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is...
2020-11-11, 1497👍, 0💬

What Is a Parameter File in Oracle
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the following two types of parameter f...
2020-11-11, 1317👍, 1💬

💬 2016-12-04 mm: mm

What Is Oracle in Oracle
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while deliver...
2020-11-11, 1103👍, 0💬

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes....
2020-11-11, 1044👍, 0💬

What Is an Oracle Database in Oracle
What Is an Oracle Database in Oracle? An Oracle database is a collection of data treated as a big unit in the database server.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials
2020-11-11, 920👍, 0💬

What Is an Oracle Tablespace in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of one or more files called dataf...
2020-10-26, 916👍, 1💬

💬 2018-10-15 taj mure: Nicerere

What Is a Static Data Dictionary in Oracle
What Is a Static Data Dictionary in Oracle? Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY. Many data dictionary tables have three corresponding vi...
2020-10-26, 818👍, 0💬

What Is an Oracle Data File in Oracle
What Is an Oracle Data File in Oracle? An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials
2020-10-26, 780👍, 0💬

What Is a Recycle Bin in Oracle
What Is a Recycle Bin in Oracle? Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recycle save the same purpose as the...
2020-10-26, 753👍, 0💬

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an...
2020-10-26, 750👍, 1💬

💬 2019-10-16 Aninda: Best tutorial

Shutdown 10g XE Server in Oracle
How To Shutdown Your 10g XE Server in Oracle? If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server. Select OracleServiceXE, and use the right mouse click t...
2020-10-10, 891👍, 0💬

Start 10g XE Server from Command Line in Oracle
How To Start Your 10g XE Server from Command Line in Oracle? You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch file StartDB.bat contains: net start OracleXETNSListener net...
2020-10-10, 738👍, 0💬

Shutdown 10g XE Server from Commmand Line in Oracle
How To Shutdown Your 10g XE Server from Command Line in Oracle? You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The batch file StopDB.bat contains: net stop OracleServiceXE   ⇒I...
2020-10-10, 683👍, 0💬

Start 10g XE Server in Oracle
How To Start Your 10g XE Server in Oracle? Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.   ⇒Introduction to Oracle Database 10g Express Edition ⇒⇒Oracle Database Tutorials
2020-10-10, 676👍, 0💬

Memory Usage of 10g XE Server in Oracle
How Much Memory Your 10g XE Server Is Using in Oracle? Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM.   ⇒Introduction to Oracle Database 10g Express Edition ⇒⇒Oracle Data...
2020-10-10, 661👍, 0💬

StartDB.bat Failed to Start the XE Instance in Oracle
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not be started. One good approach to start the default instance is...
2020-09-30, 992👍, 0💬

Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle? Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount o...
2020-09-30, 867👍, 0💬

SGA Setting Is Too Low in Oracle
What Happens If You Set the SGA Too Low in Oracle? Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:80...
2020-09-30, 801👍, 0💬

Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle? Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improv...
2020-09-30, 790👍, 0💬

1 2 3 4 5 6 > >>   Sort: Rank