Label: Before 11g, when the data volume of the table was changed beyond 10% of the total amount of data, the statistics were collected at the end of the night. How to infer 10%. Previous posts have been researched: the principles and experiments of Oracle's own active statistics collection. This stale_percent=10% can not be changed, assuming that the table is ver
Tags: Oracle 11g database management Data 11g DBA1. Oracle Database Overview1.1. Structure and compositionOracle Database 11G has a total of 4 versions, Enterprise, standard, standard 1, and personal.1.1.1, Enterprise EditionAdvan
Oracle 11g Alert Log location Oracle 11g Alert Log location 1. Obtain ADR-related information by querying the v $ diag_info View
ADR(Automatic Diagnostic Repository)--> A a file-based hierarchical data store for managing diagnostic information, including network tracing and
location:Oracle Base:/u01/app/oracleSoftware Location:/u01/app/oracle/product/11.2.0/gridFill in the Create inventory:Inventory Directory:/u01/app/orainventoryOrainventory Group Name:oinstallAfter installation is completeRunning in R1/u01/app/orainventory/orainstroot.shRunning in R2/u01/app/orainventory/orainstroot.shRunning in R1/u01/app/11.2.0/grid/root.shRunning in R2/u01/app/11.2.0/grid/root.sh16. Install the databaseFirst, make sure all the impo
Oracle 11g Release 1: http://www.oracle.com/technology/software/products/database/index.html RHEL5 under the ASMLib2.0: http://www.oracle.com/groovy/global/cn/tech/linux/asmlib/index.htmlopen the page, will find a Red Hat Enterprise Linux 4 AS (x86) Link, click it, the new page contains the Red Hat Enterprise Linux 5 AS download link. Read more: Install Oracle
First, IntroductionThe importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. The environment for this installation test is as follows:Operating system: CentOS 6.5 X64Database: Oracledatabase 11g Release 2 (11.2.0.1.0) for Linux x86-
Tags: style color io strong data for AR CTIAdding a NOT null field before 11g is very slow, very fast after 11g, let's do a test first and then explore the principle.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1
, there is an error saying/etc/oratab read errors, can ignore. after waiting for 55 minutes, the database is created and then clicked, as shown in 3.1png below : 4, verify 2 Oracle Instances[Email protected] admin]$ sqlplus/as sysdba sql*plus:Release 11.2. 0. 1. 0Production onFri May A -: Geneva: - -Copyright (c)1982, the, Oracle. AllRights reserved. Connected to: Ora
Nothing's going on today. Installed Oracle database, but in this process encountered a lot of problems, here want to share with you.At first I installed the Oracle 12c, but this installation does not matter, Ann me a full half a day is not well, in the configuration of Security window there is no time, the current user does not have access to the temporary folder permissions, at that time, Baidu has a lot o
Http://meandmyubuntulinux.blogspot.com/2012/05/installing-oracle-11g-r2-express.html
The Installer released by Oracle are only meant for 64-bit (x86_64) systems. If you are wish to install the 32-bit version, and the installing Oracle XE on Ubuntu 32-bit
It'll consume, at most, processing resources equivalent to on
In Oracle 11g RAC, it is found that both the Solaris and GSD services are in the offline status, which is the default situation of Oracle 11g RAC. Even so, the use of the database is not affected, because the resource for the WLM is used, WLM is available in 11.2.0.2. GSD is used to support interaction tools such as db
1. Check the system version number:uname-aLinux node2 3.10.0-123.el7.x86_64 #1 SMP Mon June 12:09:22 UTC x86_64 x86_64 x86_64 gnu/linuxCat/etc/redhat-release#CentOS Linux release 7.0.1406 (Core) Comment out the previous version numberRedhat-7 manually added2. Create users and GroupsGroupadd OinstallGroupadd dbaUSERADD-G oinstall-g dba-m Oraclepasswd OracleCreate home directories, data catalogs, and dictionary directories and authorizemkdir-p/01/app/
stuff is already installed, you can check it with Nslookup. The DNS server in the test environment is a separate machine, not the same machine as the two RAC machines. Before the exam, I did not prepare for DNS, ready to use the Hosts file to install the RAC environment.5. Do I need additional installation packages, such as various RPM?The answer is no, the exam environment is 32-bit Oracle Linux, the database requires the package has been installed,
execution of query data, if there is Chinese characters, may appear garbled, the solution is as follows: The character set is divided into server-side character sets and client character sets. 1, the server-side character set general installation of the Oracle database will choose the Chinese character set, if not, it can only be modified by other methods. This case assumes that the server-side character s
Oracle 11g audit files
Audit:
The audit option enabled by default for Oracle 11g. The default value of AUDIT_TRAIL is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in the database. In Orac
> list datafilecopy all; rman> Delete Expired backupcopy; Rman> crosscheck datafilecopy All; rman> Delete Expired backupcopy;If this is due to the Flash recovery area capacity limit, you can modify the path and capacity of the flash recovery area:Sql> alter system set db_recovery_file_dest= '/data/app/oracle/test ';Sql> alter system set db_recovery_file_dest_size=10g;Rman Incremental BackupWhen you use Back
.');
11
END;
12
13
INSERT INTO READ_ONLY_TABLE
14
VALUES (1);
Run this script and you will get the error message:
ORA-20001, Table is read only table.
2-check Constraints
Use the following SQL statement:
1
CREATE TABLE READ_ONLY_TABLE2 (COL1 NUMBER);
2
3
ALTER TABLE READ_ONLY_TABLE2 ADD CONSTRAINT READ_ONLY_CONST CHECK(0=0) DISABLE VALIDATE;
4
target/ rman>sql ' alter system archive log current '; Rman>backup database include current controlfile for standby plus archivelog;After the backup is complete, the backup files are produced in the flash back area.3Standby Library Configuration3.1create the appropriate file directoryIncludes dump file directory, flashback area, data file directory, can be viewed via show parameter dest command [Email protected]~] $mkdir-P/home/
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.