Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Considerations for what's New in Oracle11g

2025-02-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

After upgrading from oracle10g to oracle11g, you need to understand the new features of oracle11g, which may have an impact on application and performance and need to be adjusted.

1. Oracle11g password expiration policy

By default, oracle11g sets PASSWORD_LIFE_TIME=180 to expire in the default profile, and the password will be changed automatically when it expires, which will affect the application.

SQL > alter profile default limit password_life_time unlimited

2. Oracle11g is sensitive to the case of username and password

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

SQL > alter system set sec_case_sensitive_logon=false scope=spfile

3. Oracle11g empty table will not create segment immediately, default is true. In oracle11.2.0.1, this will cause some problems, the biggest problem is that when exp exports, empty tables will not export data. An EXP-00001 error occurs when importing a database later than 11.2.0.2 using the oracle11.2.0.1 exp client.

SQL > alter system set deferred_segment_creation = false scope=spfile

After testing using 11.2.0.4 exp export empty table, now import can be imported. If you use expdp, impdp import and export, there is no problem.

The solution to the problem that the table is already empty is as follows: find the table empty and allocate 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 An allocate extent

Alter table ABC allocate extent

Alter table TEST_LOCK allocate extent

4. Oracle11g enables the audit feature by default. Enabling the audit feature will have an impact on performance, so you can consider disabling it.

SQL > alter system set audit_trail=none scope=spfile

This parameter defaults to DB, which means that the audit data is stored in the AUD$ table in the system tablespace. The new takeover of the production warehouse caused a failure of full SYSTEM table space. The warning log is as follows.

ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

Thu Dec 10 08:47:13 2015

ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

Thu Dec 10 08:47:13 2015

ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

Finally, get rid of it directly:

Truncate table sys.aud$

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report