Politechnika Śląska - strona 281

Connection Requests - opracowanie

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

Connection Requests Users initiate a connection request by providing a connect string. A connect string includes a user name and password, and a connect identifier. This connect identifier can be the connect descriptor itself, or a name that resolves to the connect descriptor using mapping infor...

Conventions - wykład

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

Conventions The following text conventions are used in this document: Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. italic Italic type indicates book titles, emphasis, or placeholder var...

Creating the Backup Script - wykład

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

Creating the Backup Script—UNIX and Linux This backup script implements the Oracle suggested backup strategy, enabling quick recovery to any time in the preceding 24 hours. To create the backup script for UNIX and Linux: ■ Start a text editor and create and save a file with the following content...

Custom - opracowanie

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

Custom—This method requires more configuration than the Typical option, but gives you more control over how the database instance uses system memory. This option is meant for more experienced database administrators. You can directly specify memo...

Diagnosing Performance Problems Using ADDM - wykład

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

Diagnosing Performance Problems Using ADDM At times, database performance problems arise that require your diagnosis and correction. Usually, these problems are brought to your attention by ADDM, which analyzes data for different time period...

Dropping a Tablespace - wykład

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

Dropping a Tablespace After a tablespace has been dropped (deleted), the objects and data in it are no longer available. To recover them can be a time-consuming process. Oracle recommends performing a backup before and after dropping a tablespace. To drop a tablespace: 1. In EM Express, from th...

Dynamic Performance Views - opracowanie

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

Dynamic Performance Views Dynamic performance views monitor ongoing database activity. They are available only to administrators. The names of dynamic performance views start with the characters V$. For this reason, these views are often ref...

Compressed Tables Table Compression is suitable - wykład

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

Compressed Tables Table Compression is suitable for both OLTP applications and data warehousing applications. Compressed tables require less disk storage and result in improved query performance due to reduced I/O and buffer cache requirement...

Local Naming - opracowanie

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

Local Naming The local naming method stores connect descriptors, identified by their net service names, in a client configuration file named tnsnames.ora. This file is located in the ORACLE_HOME/network/admin directory. When you create a database using Oracle Database Configuration Assistant (DB...