, Configuration Tnsnames.ora Save the new Tnsnames.ora file in Notepad under this path: C:\instantclient_11_2_x86\NETWORK\ADMIN\tnsnames.ora The content reference is configured below: My_xxxserver =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.199.200.102) (PORT = 1521))(Connect_data =(SID = ORAVM)(SERVER = dedicated))) 4, extract PL/SQL to the target machine, such as: C:\Program Files (x86) \plsql D
as select rownum as id, object_name from dba_objects;Table created.SQL> create index t_ind on t (id );Index created.SQL> alter session set tracefile_identifier = 'mysession ';Session altered.The path of the generated trace file is the $ Oracle_BASE/admin/SID/udump directory.The preceding statement allows the production trace file name to include mysession. In this exampleD: \ Oracle \ product \ 10.2.0 \ ad
full table scanning by reading multiple data blocks at a time. b. you can use ROWID-based access to access a table through ROWID to improve the efficiency of table access. ROWID contains the physical location information recorded in the table .. ORACLE uses indexes to establish a connection between data and the physical location where data is stored (ROWID. generally, indexes provide a quick way to access ROWID, so those queries based on index column
Oracle is not installed, and pl/SQL is directly used to connect to oracle server in 3 minutes. Many people, especially those who do not like oracle, must learn from oracle and think that oracle occupies a lot of memory. I do not l
Tools, tick Window List 3. Close the PL/SQL tool and reopen the PL/SQL tool. You will see the window List automatically open. 4.window List window closed: Tools-Preference Key Configuration, File close (only the current windowlist window is closed) File Close all (closes all windowlist windows) F8 is the execution query Default automatically check my Objects after loginBy default, after Plsql is logged i
Oracle sqlplus login. SQL settings, sqlpluslogin. SQL
Sqlplus automatically runs two scripts at startup: glogin. SQL and login. SQL.
The execution order is
1. The glogin. SQL file is searched for and executed in the $ ORACLE_HOME/
To put it a little bit, pl/SQL developer needs to install the local Oracle client to connect to remote oracle before using the client configuration. Due to the bloated client, oracle now provides green and small solutions. The following is a detailed description.
Environment: xp, pl/
Use PL/SQL to connect to Oracle without installing the Oracle client
Want to connect to the Oracle database? Install the client. OH ~ NO !, A few hundred megabytes are missing. Now you only need to download a software named Instant Client Package from Oracle. You only need t
Tags: path install bracket can identify share Ann SQL ONSThe following prompts appear when Plsql is installed:According to the error message prompt, initially thought oarcle because the installation path problem causes the recognition not to be able to identify, later discovered. is the Plsql installation path with par
Tags: integer table can also be between output UI sha off row migration[ Oracle-based SQL Optimization ] Oracle-based SQL optimization "Bo Master" Gao Ruilin "Blog Address" http://www.cnblogs.com/grl214
A. Written Intent Description
In the early stage of the system development, due to les
database objects such as synonyms, sequences, and so on are not known to Oracle. I don't know how to write it. What they are used for is the use of these objects through this big assignment. And the meaning and use of these objects are well known. The OEM has a new understanding, learned the simple use. The data is exported in EXPDP, first creating a directory object before using the EXPDP program, and the object's read. The Write permission is gr
been known, do not know how to write, what they use, through this big job will use these objects, and the meaning of these objects and the use of familiar. The OEM has a new understanding, learned the simple use. The data is exported in EXPDP, Creating a directory object before using the EXPDP program and granting the user Read,write permission to the object. EXPDP was not used before, but after experimental operation, it learned to use it easily. (PS: the teacher to the PPT is very detailed,
to knock on the SQL statement ......)
Below is the installation process, because it is free of installation, You need to configure some environment variables and files by yourself, it is more troublesome ......
First, extract the downloaded Oracle client package to a path and decompress it to E: \ OracleClient on the local machine. Therefore, the actual
, especially for aggregate operations such as sum and avg, because to obtain results, most data rows on the table must be readCache. SQL tuning experts should reasonably evaluate each full table scan and verify whether the index can improve the performance.In most Oracle Systems, SQL statements retrieve only a subset of table data. The
the path of the tnsnames. ora file.
5. Open PL/SQL and click Cancel to go to the main interface. Select Preference in Tools and set Oracle Home to C: \ plsql \ odac_client, and OCI Library to C: \ plsql \ odac_client \ oci. dll.
6. Restart PL/SQL after the configuration is complete.
7. garbled characters may occur. Yo
trace_file_nameFrom v $ instance I,V $ session s,V $ process p,V $ px_process pp,V $ shared_server ssWhere s. PADDR = p. ADDRAnd s. SID = pp. SID (+)And s. PADDR = ss. PADDR (+)And s. TYPE = 'user'And s. SID = 'your Sid'Order by s. SID
Replace the above 'your Sid' with your session sid to find out the name of the trace file generated by the specified session. The session sid is obtained in the v $ session view, or directly query the sid of the current session:
?
1
Select usere
Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are
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.