Oracle tablespace users quota controls.
In some large database applications, we need to control the user or user group their disk space. It's like a file server, you need to set disk quotas for each user to prevent the depletion of hard disk space. Therefore, in the database, we also have to restrict users to use disk space. To achieve this, we could be achieved through the table space.
Oracle database, we can build a different table space to set the maximum storage capacity, then the user's table space. Case, the user storage capacity, about this issue table space size. Of course, the table space has the advantage of these companies are not only higher performance requirements for databases, database capacity or greater, the greater will be the advantage of table space.
Here, we specifically look at the approach of Oracle database table space, to see the performance and security in whether there are sufficient profits to compete with SQL Server database.
In database design, we recommend the following order to set the tablespaces the database administrator.
The first step: the formation of the Oracle user tablespaces.
In database design, the first requirement for designing the table space. We need to consider, just for the table space, or need to make some desk space, as well as the location for each table space, disk quotas and so forth.
At the end of the design of a reasonable number of table space, does not see unity, especially under the actual needs of companies to assess. If companies need to control user disk quota, you must specify the number of users tablespace. When the capacity of large corporate data, the database requirements are relatively high performance, need to do this type of data, specify a different table space, to Shuchuxingneng Tigao input.
Step Two: Create the Oracle users table space, and develop the user default tablespace.
In the formation of users, we recommend a database administrator to determine the user's default tablespace. Because we use the CREATE statement to create database objects, such as after a default database tables stored in the database, the default space today. If a particular user's default tablespace, then create the database object each time a user when the specified table space must be clear, this is absurd.
Please also note that a different table space has different access control. A space for table users with full control permissions for the table space B may only permit the examination, and even licensing link is not available. Therefore, the allocation of adequate table space for user access to database security is to improve the method.
Oracle data dictionary is a database on a very important part in providing relevant information in the database, then all users of Oracle (from the end user application, the application developer to design a database administrator) is a very important source of information. Creating a data dictionary is created in the Oracle database after running a number of related database management script to complete. When using the Oracle Unified Installer (Oracle Universal Installer) to create the database, Oracle server, dictionary views and scripts in the end will be installed automatically. But if you need to upgrade an existing Oracle database server, database administrator must manually restart the script to create views or SQL. After installing the database, Oracle database management script that is stored in the operating system. For UNIX and NT operating systems, which are located in different physical directories.
Operating system script directory site
UNIX $ ORACLE_HOME / RDBMS / admin
NT% ORACLE_HOME%
dbmsadmin
Almost all of Oracle's system management scripts are stored in the directory file, the directory contains hundreds of different file. What these files have different effects? This article will discuss in detail the composition of the naming of the Oracle database management script. So users can view the files that the file is probably the main goal. The files in that directory, in accordance with different functions can be divided into four categories, Oracle to easily distinguish between different file types, for files named to comply with certain rules. Table 2 below.
Naming functional description
cat *. sql in the catalog and data dictionary information
DBMS database *. sql in packet
prvt *. PLB code encrypted packet
UTL *. sql database tables and views of other features
The following describes in detail the four types of script functions:
1, cat *. sql script
It is used to create data dictionary views. Among them, catalog.sql script and catproc.sql is to create a database must run both scripts. Note that the function of the two scripts are shown in Table 3.
Script Script Description
catalog.sql create a system of common data view and synonyms dictionary
catproc.sql need to run server-side PL / SQL script
(1) catalog.sql
The script creates the table relative to the views of performance-based system and a dynamic view and synonyms. The script then run the script to create other objects, including:
Basic PL / SQL environments, including PL / SQL:
- Types of Data
- Use Exclusion
- Built-in procedures and functions
- SQL operations, etc.
Audit
Import / Export
SQL * Loader
Installation Options
2) catproc.sql
This script is mainly used for the formation of PL / SQL function to use environment. Also, create some PL / SQL package is used to extend the functionality of the RDBMS. This script also has the following features several RDBMS to create and view a few other packages:
Warning (Alarm)
Pipe (Pipe)
Log Analysis (LogMiner)
Large objects (large objects)
Object (Objects)
Advanced Queuing (Advanced queue)
Copy option (Replication option)
Some other built-in packages and options (other built-ins and options)
(3) Other scripts
In the directory, there are other scripts to extend the functionality of the Oracle database server. If, catadt.sql script used to create RDBMS megabytes of data used to display information in the data dictionary. catnoadt.sql this script to remove tables and views.
2, DBMS script *. sql and prvt *. PLB
Both types of scripts used to create the Oracle server to extend the object system functions that have been set some Oracle packages. These procedures are used to accomplish the tasks of database management. Most of the SQL scripts in the script catproc.sql run run. Some additional scripts for execution by the database administrator separately. For example scripts, dbmspool.sql, used to display the objects in the pool together and to reduce the size of the fragments from the pool together can be maintained in the SGA or marked as deleted.
3, UTL *. sql script
The script need only look at the other tables in the database and only needs to run. For example, utlxplan.sql script, used to create a table that is used to observe the SQL statements to run the program (Plan Implementation).
Note that most database management script must be run under the user SYS. Database Administrator If you plan to run these scripts first read the script, the best content on the information that is relevant to understanding what the user must run this script.
No comments:
Post a Comment