- 博客(32)
- 收藏
- 关注
RSS订阅转载 .Net 中读写Oracle数据库的两种方式
昨天晚上往Oracle数据库里面保存一幅图片，算是很稀松平常的大字段操作，搞了半天就是没存进去，提示是 “System.Data.OleDb.OleDbException: ORA-01008: 并非所有变量都已关联”。...
2005-03-21 17:43:48
121
转载 Oracle Temporary Tablespace
SQL> alter tablespace temp add tempfile '/data/oradata/devdb3/temp01.dbf' size 50m autoextend on;SQL> alter...
2005-03-17 18:00:43
113
转载 Relocated Data file
SELECT * FROM DBA_DATA_FILESselect * from dba_temp_filesSQL> alter tablespace my_TABLESPACE read only;SQL>...
2005-03-17 16:05:33
107
转载 Shared_Pool
v$sgastat 中shared pool miscellaneous 值每天都在增长相应shared pool free 的值一直在减少，造成最后没有free 空间，没发连接数据库的情况。 The most com...
2005-02-22 01:21:50
200
转载 WEB SITE
http://security.zz.ha.cn/http://www.linuxeden.comhttp://www.xfocus.net[@more@] ...
2005-02-16 17:02:15
94
转载 Network:Tools: netsh
在DOS命令行状态下，输入字符串命令“netsh -c interface dump>c:net1.txt”，单击回车键后，当前工作站的网络配置信息，就全部被保存到C盘net1.txt文件中了（该文件保存着网络1环境中的上...
2005-02-16 16:37:44
109
转载 Solaris:Freeware:Download
http://www.download-ftp-center.com/http_repository_access/mirrors/sunfreeware.com/pub/freeware/http://www.download...
2005-02-16 15:53:35
145
转载 Solaris cmd: find
find /path/dir1 -name "xxxx.yyy" -exec mv {} ./path/dir2 ; find ./ -mtime +1 -print find /path/dir1 -mtime +46 -ex...
2005-02-16 14:14:36
131
转载 Solaris平台下的硬盘增设方法
Solaris平台下的硬盘增设方法大致如下: 1. 关闭系统,进入PROM状态 % init 0 ok (PROM状态提示) 2. 在PROM状态提示符下确认当前系统所连接的SCSI设备状况 ok probe-scsi 或 ok...
2005-02-16 14:13:51
120
转载 Solaris CPU offline/ online
psrinfo -vpsradmpsrsetprsradm -f procid 将处理器procid设为离线.-n 让指定处理器在线.-a 作用于所有处理器.-v 对每次操作尝试的结果显示一条信息.只有超级用户和系统管理员才能执...
2005-02-15 17:33:52
200
转载 SQL Tuning
select sql_text from v$sqltext a where a.hash_value = (select sql_hash_value from v$session b where b.sid='&si...
2005-02-14 17:32:34
73
转载 Analysing locking issues with LOGMINER
Deadlock example ---------------- One process does the following: SQL> update dept set dname = 'dqkl' where...
2005-02-14 17:17:06
87
转载 Temporary Tablespace
Creation of a TEMPORARY Tablespace----------------------------------SQL> create TEMPORARY tablespace temp_tem...
2005-02-11 15:56:10
83
转载 UltraEdit: config as PL/SQL code editor
Advanced -> Configration -> Syntax HighlightingAppend below to file C:Program FilesUltraEditwordfile.txt/L...
2005-02-07 10:55:37
106
转载 Oracle10g: New Features for Administrators
Chapter 1 - Installation1. Installation New Feature Support:1.1. Database storage operations - file system -...
2005-01-18 02:11:46
83
转载 Solaris System Commands
1. Check for CPU type and speed root@mumu# psrinfo -vStatus of processor 0 as of: 10/18/04 14:08:38 Processor ...
2005-01-12 14:35:03
143
转载 resize Online Redo Logfile
sql> startup open restrict;sql> select group#, bytes, status from v$log;sql> select group#, member from v...
2005-01-12 14:26:13
81
转载 turn Archiving ON or OFF
turn on:1. Enabling Automatic Archiving1a. alter system archive log start;1b. alter system set log_archive_start...
2005-01-11 13:41:37
89
转载 Function Based Index
Function Based Index Step by Step alter session set query_rewrite_enabled=true; alter session set query_...
2005-01-10 18:41:01
95
转载 Connecting to Oracle through JDBC - Oracle 9i Java Programming
DBConnection.javaimport java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException;import ja...
2005-01-09 03:50:33
73
转载 Solaris v9 x86
Solaris (x86 Platform) Hardware Compatibility Lists:http://www.sun.com/bigadmin/hcl/#S8http://www.chinaunix.net/...
2005-01-08 03:21:12
69
转载 Oracle 10G
version: 10.1.0.2.0emcanetcahttp://localhost:5500/emhttp://lcoalhost:5562/isqlplus Oracle Enterprise Manager:...
2005-01-07 03:49:10
63
转载 LogMiner
$ORACLE_HOME/rdbms/admin/dbmslogmnrd.sql$ORACLE_HOME/rdbms/admin/dbmslogmnr.sql$ORACLE_HOME/rdbms/admin/prvtlogm...
2005-01-05 17:54:38
73
转载 utl_file_dir
SQL> CREATE DIRECTORY log_dir AS '/appl/gl/log'; SQL> GRANT READ ON DIRECTORY log_dir TO DBA; [@more@] ...
2005-01-05 16:52:20
82
转载 OEM
oemctl start oms dbsnmpagentctl start agentconsider the personal firewall. [@more@] ...
2005-01-03 17:50:54
84
转载 Java Environment Preparing - Oracle 9i Java Programming I
$ORACLE_HOME/sqlplus/admin/glogin.sqldefine _editor=vi -- can set as notepad, emacs ...set serverouput on size 1...
2005-01-02 01:35:30
66
转载 Alter Sequence
The sequences that need to reset the start number to 0 at the first day of new year. create sequence: CREATE SEQUE...
2004-12-31 12:41:24
240
转载 ORA-12541: TNS:no listener
App developer report that Ora-12541 appear. On clinet side, sqlplus can connect to all the instances, can all data...
2004-12-28 17:17:22
72
转载 def$_aqcall on Advanced Replication Environment
System tablespace is increased to almost 100% of storage, after check the dba_segments view, find that the size ...
2004-12-27 14:09:21
82
转载 OPatch
1. where to get the OPatch patch number: 2617419 note: 224346.1 189489.1@metalink2. How to install OPatch ...
2004-12-26 14:19:06
66
转载 Merry Christmas !!
Merry Christmas !! This is the first post for my blog ... ;)[@more@] ...
2004-12-25 03:42:14
98
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人