oracle profiler pl sql developer

of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from N

example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;

1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is name

\instantclient_12_2. finally download PL/SQL and install, open to Tools preferences Configuration connection file, Oracle home:d:\dev\oracle\instantclient_12_2,oci library:d:\dev\oracle \instantclient_12_2\oci.dll. The key is to configure the environment variables, tns_admin

Tags: PL/SQL Developer remote database without native Oracle clientI. Download PL/SQL DeveloperPL/SQL Developer download page, you can choos

Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the correspondin

First, download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlCurrent Latest VersionVersion 12.1.0.2.0Select the first instant Client for Microsoft Windows (32-bit) to download it,Please do not download 64bit, I have tried, can not achieve the connection.Unzip the downloaded Instantclient-basic-nt-12.1.0.2.0.zip compressed package and put it in the D:\instantclient_12_1 directory.In the environment variables, in the sy

Installing the 32-bit Oracle client Instantclient-basic-nt-12.1.0.1.0.zip: http://www.oracle.com/technetwork/topics/winsoft-085727.html Download unzip to get "instantclient_12_1" file, copy "Instantclient_12_1" to "C:\app\oracle\product\12.1.0" (can also be any path). Installing Plsql Developer: http://pan.baidu.com/s/1gdelc5d Install well open you will find that

Tags: style io ar color sp on Art BS codeHow to efficiently debug an Oracle stored procedure, especially a parent-child mesh call stored procedure1. Set breakpoints at Oracle stored procedure where breakpoints need to be setHow to set breakpoints: Click a line at the beginning of a row of Oracle stored procedures to display aMiddle toA small red circle filled wit

Label: Log in to the database you need to back up using PL/SQL developer; Select Tools, export user objects; Select the object in the object list that needs to be backed up, then select an output file of SQL type, click "Export", this is just the export data structure; Select tools, export tables; Sel

\tnsnames.ora or write one of their own content as follows:# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.5.10.252) (PORT = 1521)))(Connect_data =(service_name = ORCL)))The above three must pay attention to, in addition some Windows version of the tnsnames.ora.txt behind the txt to be removed;4, double hit open plsql point cancel650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/

1. First talk about the difference between pl/SQL and SQL * plus. For example, it is easy to understand: Pl/SQL-> C ++ LanguageSQL * plus-> Microsoft Visual C ++ 6.0 Compiler Pl/SQL is

reference check, browse reference tables, and chart types ).Performance Optimization-with PL/SQL profiler, you can view the timing information of each executed PL/SQL code line (Oracle8i or higher ), to optimize the code performance of your

total execution time of all units. When switching to the Unit module, the total execution time of the Unit module is Unit -- unit name, that is, the stored procedure of execution, including the calling process and anonymous block.Line -- code line numberTotal time -- the execution time of the line of code (the color length represents the percentage of the execution time of the line of code and the maximum code execution time)Occurrences-number of executions of this rowText-the corresponding lin

IT Ninja Turtles PL/SQL Developer tips and shortcuts, Ninja Turtles developer 1. SQL plus Window: File-> New-> Command Window. This is similar to the SQL plus client tool of oracle, but