2006年11月_jiawancai

转载 Rename DB with NID

Rename Database 9i and above Check the Db name SQL> select name from v$database; NAME --------- SUN START : 1.shutdown immediate 2.startup mount 3.$nid target=sys as sysdba dbname=orcl setname=yes OUT

2006-11-24 12:45:00 698

转载 Improving SQL efficiency using CASE

IntroductionSome time ago I wrote "The Power of Decode", a paper on using the DECODE function to improve report performance. I was aware at the time that DECODE was being replaced by CASE but wanted

2006-11-24 12:43:00 562

转载 Reducing CPU problem caused due to high buffer gets (after large delete)

Reducing CPU problem caused due to high buffer gets. Couple of month’s back I was working on tuning one of the telecom databases which was occupying almost 90% of the CPU in peak times. While interpre

2006-11-14 13:16:00 683

转载 using INSTR function for obtaining data from a table, based on a selection from the master table (FK relation)

Suppose that we have a departments table (dep_id, dep_name,...) and another table with persons from every department (person_id, dep_id,...). If many operations are required on the data from the perso

2006-11-14 13:14:00 546

原创常用网址

1. http://www.embhelp.com/download/嵌入式系统文档及程序下载2.http://www.smartchaps.com/articles.htmlArticles, presentations, whitepapers and scripts written by Tanel are featured here.Most of these materia

2006-11-12 13:55:00 574

转载 arm开发

第一章 STARTUP 1 ARM的启动一般的嵌入式系统在主程序执行之前都需要执行一些初始化的过程以创造嵌入式程序运行的环境，尤其是一些高级的嵌入式系统，由于核心芯片使用内存映射、内存保护等机制以及编程使用高级语言C,C++甚至JAVA语言，都需要先创建一个适合程序运行的硬件环境，然后初始化或者配置或者剪裁run-time library, 这些工作都必须在主程序运行前完成，所以一个startu

2006-11-12 13:45:00 600

原创建立针对arm-linux的交叉编译环境

交叉编译环境介绍交叉编译是嵌入式开发过程中的一项重要技术，它的主要特征是某机器中执行的程序代码不是在本机编译生成，而是由另一台机器编译生成，一般把前者称为目标机，后者称为主机。采用交叉编译的主要原因在于，多数嵌入式目标系统不能提供足够的资源供编译过程使用，因而只好将编译工程转移到高性能的主机中进行。 linux下的交叉编译环境重要包括以下几个部分：针对目标系统

2006-11-12 13:16:00 965

转载 Locks tree sessions

This script displays information on all database sessions with the username column displayed as a heirarchy if locks are present. It is assumed that the user running the script has access to the V$ vi

2006-11-04 21:58:00 523

转载 estimate table size after reorg (using dbms_space)

When table had huge amount of records deleted, you may need a reorg to lower the high water mark and improve full scan performance. If using ASSM, you may use dbms_space.space_usage to estimate the em

2006-11-04 21:51:00 709

转载 Comparison of Oracle, MySQL and PostgreSQL DBMS

http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html

2006-11-04 21:48:00 520

转载 Amazing Oracle 10g benchmark with a terabyte of RAM

http://www.tpc.org/results/FDR/TPCC/IBM_595_32_20050412_FDR.pdf

2006-11-04 21:47:00 614

转载 27 FAQs on Oracle loading data and exporting data

http://dba.fyicenter.com/faq/oracle/oracle_loading_exporting_data.html

2006-11-04 21:44:00 431

转载 Checkpoint Tuning and Troubleshooting

PurposeThis article provides the Database Administrator a better understanding of checkpoint processing and a description of four key initialization parameters used for checkpoint tuning:

2006-11-04 21:42:00 672

原创 Deleting duplicate indexes to improve performance and space

Deleting duplicate indexes to improve performance and space. If 2 indexes ( INDX1 INDX2 )are created for a table and the number of columns in Index INDX1 is less or equal to the number of column in in

2006-11-04 21:23:00 396

转载 Keep track of

# File : /soft/oracle/DBA/scr/save_crontab.ksh# Creation: 23-JAN-2001 Bruno Vroman Last modif.: 29-MAY-06 Bruno Vroman# Object : Save crontab entries, keeping a few versions# Modifications:# 3

2006-11-04 21:12:00 797

转载 finding lock details on database

set echo offcol sid form 9999col id1 form 9999999999col id2 form 999999999col lmode head "Lock Held" form a14col request1 head "Lock Request" form a16col type head "Lock Type" form a15col ctime head "

2006-11-04 21:04:00 440

oursoft的专栏