The CONNECT command in Oracle 11g SQL*Plus is enhanced to allow connecting as ASM administrator.ĬONN [
The new Oracle Cluster Time Synchronization Service is designed for organizations whose Oracle RAC. To achieve this you should have your OS configured network time protocol (NTP). New privelage SYSASM – Should be granted to user’s who perform ASM related tasks. Oracle Clusterware 11g release 2 (11.2) requires time synchronization across all nodes within a cluster when. Only one type of index on column is usable at a same time. Indexing: User can create more than one index on same column. The Invisible index feature has been implemented in Oracle 11G. Oracle Database Vault: enabled you to secure business data even from DBA’s.Ĩ. Oracle 11G: Oracle 12C: Indexing: User can create only one index on one column. This chapter describes common compatibility and interoperability considerations that you should review before installing or upgrading to Oracle Fusion Middleware 11g. SEC_MAX_FAILED_LOGIN_ATTEMPTS: drops the connection after specified number of login attempts fail for any user (Default – 10)Ħ. Compatibility and interoperability with Oracle Application Server 10g and Oracle Fusion Middleware 11g components varies by product area and version.
Over a period of time the index gets fragmented because of several DMLs running on table.
#Oracle 10g vs 11g password
SEC_CASE_SENSITIVE_LOGON: enable or disable password case sensitivity Default: True. An index is basically used for faster access to tables. New Paramaters: Memory_max_target –> sets the maximum value for Memory_Target parameter. Deprecated: iSQL*Plus, Oracle Enterprise Manager Java Console.Ĥ. VMware VMotion was used to migrate live, running database virtual machines across ESX servers. disgnostic directories such as bdump, cdump and udump is replaced with this option in 11g.ģ. ADR (Automatic Diagnostic Repository) – is a single directory location for all error and trace data in the database. by default datafiles and flash recovery options are located one level beloe the ORACLE BASE location but in 10g it is used to be saved under oracle home directory.Ģ.
0 kommentar(er)
