< 1 2   Sort: Rank

How To Find Out What Privileges a User Currently Has
How To Find Out What Privileges a User Currently Has? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on tho...
2007-05-01, 5419👍, 0💬

What Is Open Database Communication (ODBC)
What Is Open Database Communication (ODBC)? - Oracle DBA FAQ - Oracle Basic Concepts ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow ...
2007-04-22, 4721👍, 0💬

What Is Transport Network Substrate (TNS)
What Is Transport Network Substrate (TNS)? - Oracle DBA FAQ - Oracle Basic Concepts TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.
2007-04-22, 5153👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Oracle Basic Concepts SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user inter...
2007-04-22, 5345👍, 0💬

What Is a Recycle Bin
What Is a Recycle Bin? - Oracle DBA FAQ - Oracle Basic Concepts 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 recyc...
2007-04-22, 4519👍, 0💬

What Is a Dynamic Performance View
What Is a Dynamic Performance View? - Oracle DBA FAQ - Oracle Basic Concepts 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 upda...
2007-04-22, 4558👍, 0💬

What Is a Static Data Dictionary
What Is a Static Data Dictionary? - Oracle DBA FAQ - Oracle Basic Concepts 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 tab...
2007-04-22, 4568👍, 0💬

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Oracle Basic Concepts 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.
2007-04-22, 4455👍, 0💬

What Is a Table Index
What Is a Table Index? - Oracle DBA FAQ - Oracle Basic Concepts 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 Databa...
2007-04-22, 4522👍, 0💬

What is a Database Schema
What is a Database Schema? - Oracle DBA FAQ - Oracle Basic Concepts 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 S...
2007-04-21, 4827👍, 0💬

What Is a Database Table
What Is a Database Table? - Oracle DBA FAQ - Oracle Basic Concepts 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, su...
2007-04-21, 4595👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Oracle Basic Concepts 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.
2007-04-21, 4690👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Oracle Basic Concepts 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 table...
2007-04-21, 4606👍, 0💬

What is Program Global Area (PGA)
What is Program Global Area (PGA)? - Oracle DBA FAQ - Oracle Basic Concepts A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies t...
2007-04-21, 4872👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Oracle Basic Concepts A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for ...
2007-04-21, 4534👍, 0💬

What Is a Initialization Parameter File
What Is a Initialization Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on...
2007-04-21, 4694👍, 0💬

What is System Global Area (SGA)
What is System Global Area (SGA)? - Oracle DBA FAQ - Oracle Basic Concepts The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. The SGA is allocated in memory when an Oracle database instance is s...
2007-04-21, 4947👍, 0💬

What Is a Server Parameter File
What Is a Server Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored ...
2007-04-21, 4589👍, 0💬

What Is a Parameter File
What Is a Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts 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 fol...
2007-04-21, 4869👍, 0💬

What Is an Oracle Database
What Is an Oracle Database? - Oracle DBA FAQ - Oracle Basic Concepts An Oracle database is a collection of data treated as a big unit in the database server.
2007-04-21, 4436👍, 0💬

What Is an Oracle Instance
What Is an Oracle Instance? - Oracle DBA FAQ - Oracle Basic Concepts 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 start...
2007-04-21, 4466👍, 0💬

What Is Oracle
What Is Oracle? - Oracle DBA FAQ - Oracle Basic Concepts 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 thi...
2007-04-21, 5011👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Oracle Basic Concepts 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...
2007-04-16, 4571👍, 0💬

< 1 2   Sort: Rank