Considerations for new features of Oracle 11g

Source: Internet
Author: User

Considerations for new features of Oracle 11g

After upgrading from Oracle 10g to Oracle 11g, you need to understand the new features of Oracle 11G. These features may affect the application and performance and need to be adjusted.

1. Oracle11g Password Expiration Policy

In oracle11g, by default, PASSWORD_LIFE_TIME = expires 180 days later in the default profile. After expiration, the password is automatically changed, which affects applications.

SQL> alter profile default limit password_life_time unlimited;

2. Oracle11g is case sensitive to user name and password

The default username and password in Oracle11g are case-sensitive. oracle10g does not have this problem.

SQL> alter system set sec_case_sensitive_logon = false scope = spfile;

3. A blank Oracle11g table does not create a segment immediately. The default value is true. This may cause some problems in oracle11.2.0.1. The biggest problem is that the empty table does not export data during exp export. A EXP-00001 error occurs when you import a database of version 11.2.0.2 or later using the oracle11.2.0.1 exp client.

SQL> alter system set deferred_segment_creation = false scope = spfile;

To solve the problem of an empty table, locate the empty table and allocate the space immediately:

SQL> select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;

'Altertable' | TABLE_NAME | 'allocateextent ;'
-----------------------------------------------------------
Alter table C allocate extent;
Alter table B allocate extent;
Alter table A allocate extent;
Alter table ABC allocate extent;
Alter table TEST_LOCK allocate extent;

4. The audit function is enabled for Oracle11g by default. Enabling the audit function will affect the performance. You can disable it.

SQL> alter system set audit_trail = none scope = spfile;

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Install Oracle 11.2.0.4 x64 in Oracle Linux 6.5

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.