Read about oracle 12c database new features for dba, The latest news, videos, and discussion topics about oracle 12c database new features for dba from alibabacloud.com
Label:The following error occurred with the installation of Oracle Database 12c on Windows 7 64bit: Workaround: First step: Control Panel > All Control Panel Items > Administrative Tools > Services >server Startup Step two: Control Panel > All Control Panel Items > Administrative Tools > Computer Management > System Tools > Shared Folders > Sharing right-cl
Oracle 11g on July 11, 2007 11 O'Clock (Beijing time 11th 22 o'clock) officially released, 11g is Oracle 30 years to release the most important version of the database, according to the needs of users to achieve information lifecycle management (information Lifecycle Management) and many other innovations.
I. Outline of new
Oracle DBA Database Senior Engineer Training Upper (project implementation + Backup Recovery + foundation depth)Purchase Address:Http://edu.51cto.com/pack/view/id-739.html
DescribeOracle DBA Database Senior Engineer Training course is the wind brother alone research and
Oracle uses Incomplete Database-level recovery to solve the logical errors caused by data loss or human error before 10 Gb. After 10 Gb, RMAN introduces a new feature called "tablespace point-in-time recovery", TSPITR for short, which can actually achieve Incomplete recovery at the tablespace level, of course we know that after 10 Gb, the flashback feature can al
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
=650; "src=" Https://s2.51cto.com/wyfs02/M00/9B/EB/wKiom1lolBvzpb9HAADC9Ottv-Q060.png "style=" float : none; "title=" 3.PNG "alt=" Wkiom1lolbvzpb9haadc9ottv-q060.png "/>Install DB on top of three hosts with RAC installed in front650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/9B/EA/wKioL1lolBzhaAt-AADSjInNZds381.png "style=" float : none; "title=" 4.PNG "alt=" Wkiol1lolbzhaat-aadsjinnzds381.png "/>Choose to install the Enterprise Edition database650) this.width=650; "src=" Https://s1
New Features of Oracle 11g
(36 in total)
I. Database Management
·1. Database Replay)
This feature can capture the load of the entire data and pass it to a test database created from the backup or standby
Oracle
Introduction to the new features of Oracle 10G I release (next)
by Fenng 2003-07-10
NOTE: Recently Oracle has officially announced that this version of Oracle named 10G, where G is the meaning of the grid. hereby correct.
many connections are established, the resources of the database are consumed. At the same time, some "hang dead" connections may require manual cleanup by the DBA.
The following SQL statement lists the sessions established by the current database:
Select Sid,serial#,username,program,machine,status
From V$session;
which
The ID number of the SID conversation
This is a sophomore writing in the QQ space in an article, I remember that the problem took me the whole day to fix it, so experienced quite deep, so at that time deliberately recorded the process of the settlement, and today suddenly have the interest to find out a few college writing in the spaces in the article and share with you, In case something like that happened to me, it would take a lot of time, and the following is the full contents of the record:Today login with the user Scott landed
ORA_PSP0_RACG1
Oracle 26477 1 0 15:02:44? 0:00 ORA_RECO_RACG1
Oracle 26475 1 0 15:02:44? 0:00 ORA_SMON_RACG1
Two. ORACLE11G the functionality of a new background process
The new many background processes are: ORA_DBRM_ORCL,ORA_DIA0_ORCL,ORA_PSP0_ORCL,ORA_SMCO_ORCL,ORA_VKTM_ORCL,ORA_W000_ORCL,
The functions of these
default, both attributes are set to 10.1. to use new features, you must promote these attributes.
Setting the compatibility attribute to an earlier version allows the client to access a later version of the disk group. For example, the Oracle 10g client can access the Oracle 11g ASM disk.
The Compatibility attribute s
also the entire RAC (that is, the database level). In addition, some instructions (Directive) can be added to the ADDM to ignore information that you don't care about.
12, AWR Baseline (Awrbaselines)
The AWR baseline has been expanded. You can automatically create baselines for some other features that you use. The Dian Cun Zhang Line is created by default.
Second, Plsql part
1, result set cache (resul
oracle| Data | database
Original Author: Sameer Wadhwa
Pause (quiescing) A database is a powerful new feature that allows DBAs to complete some of the operations that a database is in restricted mode (restricted modes). With this feature, the
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.