Tblname=request ("TB")
Dim objorasession,objoradb
Dim Strdbuser,strdbpwd,strdbconn
Call Connectdb ()
Sub connectdb () ' Connect to the database
On Error Resume Next
Strdbuser = "Liujincai" ' Connection user name
Strdbpwd = "ljc1001" User
--View disk statements that consume the most disk read/write rateSELECT *From (select v.sql_id,V.child_number,V.sql_text,V.elapsed_time,V.cpu_time,V.disk_reads,Rank () Over (order by v.disk_reads Desc) Elapsed_rankFrom V$sql v) awhere Elapsed_rank -
It requires a monitoring script.
The ec01_watch.sh content is as follows (replace EC01 with customer instance name according to actual situation):
The code is as follows
Copy Code
check= '
First we unpack.
After decompression we will find a more than a folder, he is: Disk1, into the Disk1. Then perform the installation:
$./runinstaller
Execute script
#/u01/app/oracle/10.2.0/db_1/root.shRunning Oracle 10g
EXISTS
This function returnsThe index of the first element in the collection , and returns null null NULL if the collection is empty
Collection.exists (Index)
COUNT
The Function collectionNumber of elements
environment variable settings for Oracle in Window server
1. Right-click "My Computer"-> Select "Properties"-> Select "Advanced"-> Click "Environment Variables"2. Select the "Path" line, click Edit, add a semicolon ":" In the last face of the
There are a lot of things about Oracle optimization, and the concepts are complex, but you can summarize an outline as a direction to consider, and then gradually refine. Oracle optimization needs to consider design, development, and adjustment in
In the development of what you should have done similar department management such functions, in general, a department below there is the next level (sub departments), this level is similar to a tree. In this case, the parent department and the
In the development process may be declared that contains a table does not have a field cursor, to solve special problems, this article will detail this type of problem, need to know more friends can refer to the
Where data.* is a table and then
In the development process may use the Oracle Table demo Operation statement, this article will introduce this, needs the friend may refer to under
SQL code
Copy Code code as follows:
--Created on 2010/07/29 by Wangnan
Declare
--Local
Modifying the project involves modifications to many of the tables in Oracle (including adding, removing fields, modifying annotations, and so on). Because the start did not record, causing on the test machine, forget the specific changes to the
Of course, this small problem is difficult to fail US programmers, "max+1 ah", some people would say such a way. Yes, this approach is easier to achieve. Of course, you may also say that the most SQL way is to use the identity column, the increase
Resume in/etc/profile.d/oracle.sh
The following contents are set to encode in Nls_lang
Oracle_home=/usr/lib/oracle/12.1/client64
C_include_path=/usr/include/oracle/12.1/client64
LD_LIBRARY_ Path= $ORACLE _home/lib #remember This is the
client
Here we focus on how SQL Server 2005 is load-balanced.
New features of SQL Server 2005
SQL Server 2005 strengthens support for transactional replication on an end-to-end (Peer-to-peer) topology. Peer-to-peer topologies support an unlimited number
To write the connection string first
It can be written in web.config.
Copy Code code as follows:
And then call back in the background
Copy Code code as follows:
String Orclcon =
--1 The simplest stored procedure create or replace procedure Hello_proc as V_name varchar2 (20); V_age number; Begin v_name:= ' Bai '; v_age:=18; Dbms_output.put_line (' Hello ' | | v_name| | ', you this year ' | | V_age); end;--call in Plsql
First day: 1 Oracle installation A uninstall B install Server Software and database (ORCL)--ORACLESERVICEORCL C Perform network configuration--Configure listening 1521, local net service name (create 1 external connection URLs)--ORACLEHOMETN
Create a test tableCREATE TABLE T_person (ID VARCHAR2 (+) primary key, name VARCHAR2 ($), address VARCHAR2 (200)); Inserting data into the test tableInsert into T_person (id,name,address) VALUES (Sys_guid (), ' Zhangsan ', ' Beijing '); Insert
I mentioned the basic configuration precautions last time. Now I am starting to develop the oracle database.1. oracle database connectionHowever, if you have installed the oracle client, you have already specified the database server during
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service