Earlier oracle client versions cause bad SQL and oraclebad
Environment:
The production system is a 10 k OLAP system for online users (11 gb rac dual-node). One day, user units found that scanning programs were slow.
View monitoring,Node1, high IO and high heartbeat traffic
Start analysis now:
1. All production clients are linked to node1. some clients are Failover and Node2 is abnormal;
2. On Node1, kill the session client that causes high IO, and notify the user organization not to enable it for the time being;
3. Kill the user on Node2. We recommend that you re-open the program and the exception disappears.
Cause analysis: The Bad SQL of Node1 caused resource shortage. Some users cannot be responded to by node1. Failover to node2. at this time, DRM takes effect and scanning is slower!
Final Solution: the problem must be solved at the client. Similar to a normal client, the client is found to be 9i, and then the on-site engineer upgrades the client to 11g to solve the problem;
Root case: the SQL encapsulated by the client program. bad SQL appears on the 9i client.
Event Summary: 11g Enterprise Edition Software is better to use 10g or more client software to access!
When the oracle client is installed and the installation and selection type is instantclientpl/SQL, an error is reported, as shown in. How can this problem be solved?
Although not necessarily 64-bit, you can refer to this:
Use PL/SQL Developer to connect to OracleX64:
• 1. Download the 32-bit Oracle InstantClient and expand it to a directory, such as C: \ instantclient-basic-nt-11.2.0.2.0;
• 2. Copy the system tnsnames. ora to this directory;
• 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools configure Preferences configure Oracle connector Connection:
Oracle_Home: C :\ instantclient-basic-nt-11.2.0.2.0
OCI Library: C :\instantclient-basic-nt-11.2.0.2.0 \ oci. dll
• 4. Edit the following bat file in the PLSQL Developer directory, replace the shortcut, and start PLSQL Developer:
@ Echo off
Set path = C: \ instantclient-basic-nt-11.2.0.2.0
Set ORACLE_HOME = C: \ instantclient-basic-nt-11.2.0.2.0
Set TNS_ADMIN = C: \ instantclient-basic-nt-11.2.0.2.0
Set NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Start plsqldev.exe
Which of the following oracle client tools enforce SQL statements faster?
These tools have the same speed. The execution efficiency and speed depend on your code quality and database optimization. In addition, if you write a stored procedure on sqlplus and a stored procedure on PL/SQL Dev, which one do you think is faster?
Step 4: Even if sqlplus is a database connection tool that comes with oracle, it is assumed that the execution will be slightly faster than a few minutes. How long will it take you to save enough time for one day, and rest?