Performance of different Oracle client and Oracle versions

Performance of different Oracle client and Oracle versions

**************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216069

Deep Blue blog: http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************

1. 10g Client Login 11g library Phenomenon

[Oracle @ org54 ~] $ Sqlplus scott/tiger@10.53.105.65/hyl

-- Sqlplus user name/password @ host name/Database Service name

SQL * Plus: Release 10.2.0.1.0-Production on Sun Sep 7 08:57:23 2014

Copyright (c) 1982,200 5, Oracle. All rightsreserved.

Connectedto:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

Withthe Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select comp_name, version, status from dba_registry;

-- Check that the database version is 11.2.0.4.0, and the client corresponding to logon is 10.2.0.1.0.

SQL> quit

-- When you exit the database, the database version is displayed.

Disconnectedfrom Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64 bitProduction

Withthe Partitioning, OLAP, Data Mining and Real Application Testing options

Add: How to allow other users to access the data dictionary

SQL> show parameter o7

NAME TYPE VALUE

-----------------------------------------------------------------------------

O7_DICTIONARY_ACCESSIBILITY boolean FALSE

SQL> alter system set O7_DICTIONARY_ACCESSIBILITY = true scope = spfile;

SQL> show parameter o7

NAME TYPE VALUE

-----------------------------------------------------------------------------

O7_DICTIONARY_ACCESSIBILITY boolean TRUE

2. 11g Client Login 10g library Phenomenon

Summary:

Use sqlplus to log on to the database. Do not confuse sqlplus with the database version. The two are different concepts. 3. supplemented knowledge: Database Authentication format

1. operating system authentication: by default, the local server logs on to the Oracle database and uses operating system authentication without entering the database username and password,

Login Format: SQL> sqlplus/as sysdba

2. User Password Authentication: when a user remotely connects to the database, the user name and password must be used for authentication before login,

For example: SQL> sqlplus scott/tiger as sysdba

**************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216069

Deep Blue blog: http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************