Most WEB applications today need to adopt at least some basic security policy. For example, a Web site that provides password-protected content, only Web sites with admin backend, blogs and personal magazines, E-commerce sites, intranet, and so on.
Whether you are developing a DBA or maintaining a DBA, you are always more or less encountering SQL execution efficiencies or SQL tuning issues, and it is necessary to view the execution plan. Generally we can view in 3 ways:
First, explain plan
Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the
1. Backup is more important than anything
We need to know that the system is always going to crash, there is no valid backup just waiting for the day to die! I often joke that the only thing that will wake the DBA in a dream is that there is no
Oracle
Introduction to the new features of Oracle 10G I release (i)
by fenng
2003-6-8
Oracle (www.oracle.com) has long claimed that Oracle 9i databases are only a transitional product, and that real technological innovation is likely to be in
This article mainly introduces the installation of Oracle database and the creation of database in silent way. Create users, user groups and environment settings and graphical installation is the same, the specific setting of the way please refer to
In most cases, modifications to the primary database will be propagated to the physical standby database and applied without the need for additional operations on the physical standby side, except that, depending on the actual configuration, some
J2ee
Two: Creating a DatabaseSmall test Oracle 8i (by the way we practice practicing) (for convenience, I will Oracle 8i abbreviated 8 i)8i and 9i are indeed somewhat different, but in the interface is not very different, or to my Oracle 8i as an
oracle| Skills | data | Database in an Oracle database, DBAs can make possible adjustment decisions by observing a certain table or view to see how the current space is being used.
I. Free space in the table space
By observing the free space of
As an Oracle DBA, a number of problems with character sets are frequently dealt with at work. But when you really want to write something about it, you suddenly don't have a clue. After a half-day, or decided to use the two character set as an
If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is absolutely suitable for you.
On the database backup recovery principle, we are more or less familiar with.
The implementation of MySQL master-slave replication
1, the implementation of MySQL replication principle
MySQL supports one-way, bidirectional replication, asynchronous replication, one server acting as the primary server during the replication
Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool
oracle| Data Author: anon Source: InterNet Add Time: 2003-7-20
The following table collects almost all the views or aliases in the Oracle data dictionary, and for each view or alias field, use the ' Describe ' statement to query.
Name Description:
This article summarizes the database backup process of all possible errors, you can refer to the following. If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is
Oracle
Oracle DAB two day crash course
The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and
This example, run in MySQL5.0 and above version.
The simple format that MySQL gives user permission commands can be summarized as:
Grant permission on database object to user
One, grant ordinary data user, query, insert, UPDATE, delete all
Solve the problem ORA-01157 problem how to solve?
Environment: Redhat 9 + Oracle 817
Question: After yesterday's sudden power off, the database was prompted for this error after it was started. The data is not archived, and the data file is also
Experiment content: The Redo Log Content format of the DML statement produced in the non-IMU mode is interpreted, the database version: 11.2.0.4
The most detailed explanation is update.
Experimental environment Preparation
The IMU feature is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.