摘要：1、web服务器负载均衡 nginx软件负载均衡2、数据库服务负载均衡，如oracle的RAC技术3、服务器故障转移集群 3.1、连接时故障转移集群3.2、非连接时故障转移集群(Data Guard技术) 阅读全文

摘要：ARP2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 182.168.1.173)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =... 阅读全文

摘要：--1、查看表在那个表空间 selecttablespace_name,table_namefromuser_talbeswheretable_name='test';--2、获取用户的默认表空间 selectusername,DEFAULT_TABLESPACEfromdba_userswhereusername='MXH';--3、查看表空间所有的文件 select*fromdba_data_fileswheretablespace_name='USERS';--4、查看表空间使用情况：SELECTtbs表空间名,sum(totalM)总共大 阅读全文

摘要：select * from v$datafile 阅读全文

摘要：package com.westsoft;import java.sql.*;public class Main { /** * @throws SQLException * @throws ClassNotFoundException * @param args * @throws */ public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connecti. 阅读全文

摘要：beginsavepoint aaa; update ZDCOLUMNVALUE set ZDCOLUMNVALUE.TEXTVALUE=( select substr(content,instr(CONTENT,'src="/zcms/wwwroot/DWRCB/upload/logo/',1,1)+25,30) from ZCARTICLE where ZCARTICLE.SITEID=239 and ZCARTICLE.CATALOGID=9502 and ZCARTICLE.content like '%src="/zcms/wwwroot/ 阅读全文

摘要：INSERT INTO tablename(ID, SITEID, NAME, DATABASEID, TABLENAME, CATALOGID, ARTICLESTATUS, PATHREPLACEPARTOLD, PATHREPLACEPARTNEW, NEWRECORDRULE, SQLCONDITION, STATUS, MAPPINGCONFIG, MEMO, PROP1, PROP2, PROP3, PROP4, ADDUSER, ADDTIME, MODIFYUSER, M... 阅读全文

摘要：--1.如果已经还原过,则清理数据和用户SQL> drop user lxyweb cascade;用户已删除。SQL> drop tablespace lxyweb;SQL> create user lxyweb identified by lxyweb default tablespace users temporarytablespace temp;用户已创建。SQL> grant connect,resource,dba to lxyweb;授权成功。SQL> create smallfile tablespace "LXYWEB" d 阅读全文