Politechnika Śląska - strona 118

Switching a Log File

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 609

Switching a Log File When a log switch occurs, the log writer (LGWR) process stops writing to the current online redo log group and starts writing to the next available redo log group. After a log switch, the current online redo log group becomes inactive, and the next available online redo log ...

Switching Undo Tablespaces

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 483

Switching Undo Tablespaces You can switch from one undo tablespace to another. To switch the undo tablespace: 1. Go to the Undo Management Details page, as described in "Viewing Undo Information" on page 6-20. 2.

SYS and SYSTEM Users

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 497

SYS and SYSTEM Users The following administrative user accounts are automatically created when you install Oracle Database. They are both created with the password that you supplied upon installation, and they are both automatically gran...

SYSDBA and SYSOPER System Privileges

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 448

SYSDBA and SYSOPER System Privileges SYSDBA and SYSOPER are administrative privileges required to perform high-level administrative operations such as creating, starting up, shutting down, backing up, or recovering the database. The SYSDBA system privilege is for fully empowered database adminis...

System Global Area

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 462

System Global Area The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background p...

Tablespace Status

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 595

Tablespace Status You can set tablespace status as follows: ■ Read Write Users can read and write to the tablespace after it is created. This is the default. ■ Read Only If the tablespace is created Read Only, then the tablespace cannot be written to until its status is changed to Read Write. ...

Tablespace Types

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 616

Tablespace Types There are three types of tablespaces: ■ Permanent You use permanent tablespaces to store your user and application data. Oracle Database uses permanent tablespaces to store permanent data, such as system data. Each user is a...

Test the new KING

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 567

Test the new KING_VIEW view: 1. In the Connections navigator, navigate to the Views node in the HR schema and find the KING_VIEW, by following the instructions in "Displaying Views" on page 8-25. Managing Program Code Stored in the Database Managing Schema Objects 8-27 2.

The DDL Tab

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 581

The DDL Tab You can create and manipulate schema objects with SQL or with SQL Developer. When creating schema objects using SQL Developer, you can click the DDL tab to display the SQL statement that is the equivalent of the schema object properties that you specified with the graphical user inte...