Tags: size reliable moderator large online benefits audit security soft
High reliability. The ability to place server failures, site failures, and human errors wherever possible.
High security information. Data security and compliance can be ensured with a comprehensive meeting of row-level security, fine-grained auditing, transparent data encryption, and data
----------------------------------------------------------------------------------------------------Predicate Information (identified by operation id ):---------------------------------------------------2-filter ("COL1" = 1)Note------Dynamic sampling used for this statement (level = 2)Statistics----------------------------------------------------------5 recursive cballs0 db block gets15 consistent gets0 physical reads0 redo size385 bytes sent via SQL * Net to client338 bytes encoded ed via SQL
--------------------------------------
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Notes on installing Oracle 11g R2 in
, check the EMP table.
If you have a query that shows the data, Oracle installation is successful!
Finally, because Oracle services are very memory-intensive, we set up Oracle's two services to be manual and then reopen when we need to use the Oracle database!
, and in Oracle 10g, binding variables are relatively simple, and when SQL that uses a binding variable executes for the first time, a hard resolution is made to generate plan and cursor. In this process, Oracle uses bind peeking to bring the value of the bound variable into, thus selecting the optimal plan. This plan is used for each subsequent execution.
In future executions, if the cursor is not reusable
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp in the Development Library
, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine
the changed Blocks During the standby managed recovery. In this way, the block tracking of the standby database can be uninstalled, and the same fast Incremental Backup can use the change tracking files available on the primary database. This feature allows you to perform Incremental backup at a faster speed than the previous version in a physical backup database. You can use the RECOVER command (previous BLOCKRECOVER command) to restore a single data
process unknown ospid (17662) as a result of ORA-28
Tue Sep 13 17:58:06 2011
Opidcl aborting process unknown ospid (9702) as a result of ORA-604
Ii. Problem Analysis:
2.1 opiodr aborting process unknown ospid (924) as a resultof ORA-28
In Oracle 11.1.0.6 and 11.1.0.7, there is a bug: 6377339. It will display the following information in Alert Log:
ORA-28: opiodr aborting process unknown ospid (21016_3086862016)
This prompt information may cause
Installing Oracle 11g R2 in LinuxI. installation environment
Linux Server: CentOS 6.4 64-bit
Oracle Server: Oracle 11gR2 64-bitIi. System Requirements
Requirements for installing Oracle in Linux
System Requirements
Description
Memory
Physical memor
Tags: revert to my many help summary pen. NET Preparation SpecialTransferred from: https://www.jb51.net/article/52269.htm This article mainly introduces the Oracle 11g Dataguard parameters in detail, including the independent parameters, the main library parameters, the library parameters detailed description, the need for friends can refer to. Note: This article is translated from
Following Oracle's release of the new database software 11g last month, IBM also today released the database software Informix Dynamic Server (IDS) 11, code-named Cheetah, Microsoft SQL The server is also expected to launch a new version early next year. IBM Software PRODUCT Manager Lin Shiwei says Oracle's 11g and Informix 11 also emphasize high availability and data
an instance in memory.(3) Execute the CREATE DATABASE command, and the result will generate at least one control file, two online redo log files, two data files for system and Sysaux tablespace, and a data dictionary.(4) Run SQL script to generate a data dictionary view with supplemental PL/SQL packages.(5) Run the SQL script to generate the Enterprise Manager d
corner, select Oracle, and then press fillNote: IP boycott fill in 127.0.0.1 and localhost are ok, under normal circumstances, if not, Exchange tryService name or SID this entry must be filled with XE, this is necessary. Can't changeThe user name and password are the one created in the previous step and are created according to your personal circumstances.Then click "Connect Test"A successful connection is no problem, you can log into the database wi
or ASM. Block devices and bare devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group
$.password or user$. SPARE4, but the two differ in the size of the password, the specific test is as follows:
Create a test user Xifenfei[Oracle@localhost ~]$ SSSql*plus:release 11.2.0.4.0 Production on Fri APR 10 16:00:03 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Produc
Why cannot I enable ADG for Oracle 11g slave database?
Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby database was in the mount stage. This was a 11gR2 database, and it was a waste of time without ADG. I felt too much to do this.So I tried to start the open stag
Tags: target theory ora add dictionary delete loop System Management Redo log: Network Disk DownloadContent EssentialsThis book is written for Oracle 11g, the latest large database management system from Oracle, and the basics of Oracle are presented in a circular, progressive way. Its content includes four parts: Basi
Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget
Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux:
[oracle@hosta ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.
Label:Under the Linux operating system, the increase in Oracle DB 11g Memory_max_target and Memory_target should be noted: [[emailprotected] ~]$ sqlplus/as sysdba sql*plus:release 11.1.0.7.0-production on Tue Jul 01:12:24 Co Pyright (c) 1982, D, Oracle.
All rights reserved. Connected to:oracle Database 11g Enterpris
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.