WTK870424-CSDN博客

转载 Google网站管理员工具删除网址功能一定要慎用

由于网站改版，以前GOOGLE收录的网址不想要了，前段时间通过GOOGLE管理员工具删除了所有网址，想让GOOGLE重新收录，结果改版完了导致GOOGLE一个多星期不收录我的站。以上是四天百度和GOOGLE收录数量记录，前几天的查不到了，改版前谷歌收录大概是7000左右。以下是改版完以后的操作与大家分享一下：因为怕网站未改版期间未完成的页面被收录，所以在网站根目录上

2013-06-20 22:06:37 1576

转载从Sql server 2000往Oracle 10g数据库迁移遇到的问题

从Sql server 2000往Oracle 10g数据库迁移遇到的问题博客分类：eclipse rcp SQL ServerSQLOracleHibernateStruts真没劲，又干这种没技术含量的活了！把客户一个用了N年的数据库（Sql Server 2000）要迁移到我们系统的数据库中来（选用的是Oracle 10g）。比较犹豫怎么导的问题，要么写个小JDBC程序

2013-03-04 13:25:08 1580

转载 SQL Server直接执行.sql文件

SQL Server直接执行.sql文件客户的数据库数据被篡改，利用Log Explorer工具根据日志生成的回滚脚本有200多M，不可能一下子扔到查询分析器里去执行，于是想是否SQL Server是否可以像Oracle那样直接执行.sql文件。讲过查资料，测试，发现可以在cmd窗口中执行如下命令执行Sql文件： osql -S 127.0.0.1 -U sa -

2013-02-01 15:18:18 1500

转载 Oracle学习系列—Oracle透明网关 for SQL Server

ORACLE实现异构服务的技术叫做透明网关（Transparent Gateway），利用透明网关可以实现和SQL SERVER、SYBASE、DB2等多种数据库的互联。因此透明网关也是Oracle数据仓库和数据迁移中的一个重要组成部分。透明网关的体系结构也很简单，在ORACLE和SQL SERVER之间使用ORACLE透明网关服务器实现互连互通，其中透明网关服务器可以与ORACL

2013-01-31 08:53:52 1037

转载 How to Retrieve AccessID & AccessPWD for a PeopleSoft Environment

Most of us follow the waterfall model of SDLC within the organizations we work. Various teams are involved at various stages of the model. Each Team has their set of environments where they are the

2013-01-19 20:35:17 1608 2

转载简单介绍join,outer-join,semi-join,anti-join的区别

表连接的方式如join ,semi -join ,outer-join ,anti-join ；表连接的实现方式如nested loop,merge,hash.本文简单的介绍表连接的方式join ,semi -join ,outer-join ,anti-join 和适用情景。假设２个数据源(row source)．Emp(id pk,ename,deptno) Dep

2012-10-15 20:15:00 975

转载 dbms_system

http://blog.csdn.net/robinson1988/article/details/505844010g以前，对别的session做10046跟踪,sql_trace跟踪需要用到dbms_system这个包，可以我在10gR2官方文档上面没有找到这个包的解释，然而这个包很重要，下面收集一些有用的过程，有备无患。dbms_system.get_env(var

2012-10-14 16:52:23 1068

转载 PeopleSoft Configuration Settings for Tracing

mybasicknowledge.comOriginal PagePeopleSoft Configuration Settings for TracingRead Later•Set the following in psappsrv.cfg, or for a single user session in PIA using trace=y“31

2012-10-03 20:29:35 1242

转载 Oracle Shared pool 详解

Oracle Shared pool 详解分类： Oracle PerformanceOracle Advanced Knowledge 2011-06-22 14:302529人阅读评论(0)收藏举报一. Shared Pool 概述在之前的blog对Oracle 的内存架构也做了一个概述，参考：

2012-09-26 20:45:54 1456

转载 Oracle 从缓存里面查找真实的执行计划

Oracle 从缓存里面查找真实的执行计划分类： Oracle Performance 2011-06-20 17:481090人阅读评论(0)收藏举报有关Oracle 的执行计划说明，参考我的Blog： Oracle Explain Plan http://blog.csdn.net/tianles

2012-09-25 22:06:33 1354

转载浅谈Oracle学习方法

移动开发者大会最新议题发布，八折抢票！ 2013年1月微软MVP申请开始啦！ “第一次亲密接触”—有奖征文活动浅谈Oracle学习方法分类： EssayMy Blog Summary 2010-04-03 23:2010786人阅读评论(74)收藏举报玩Oracle也快2年了，一直都是在整理O

2012-09-25 21:11:54 1387

转载 Oracle SQL优化总结

Oracle SQL优化总结分类： Oracle Performance My Blog Summary 2011-11-24 17:05 6216人阅读评论(9)收藏举报目录(?)[+]一.SQL 编写注意事项SQL 编写的具体注意事项多表关联方式二. 相关理论说明Oracle 优化器：CBO 和 RBO软解析和硬解析

2012-09-25 19:53:00 1220

转载 Setting Up AUTOTRACE in SQL*Plus

Setting Up AUTOTRACE in SQL*PlusAUTOTRACE is a facility within SQL*Plus that shows you the explain plan of the queries you’ve executed and the resources they used. This topic makes extensive use

2012-09-24 22:03:44 840

转载 Oracle学习笔记：INITRANS和MAXTRANS参数的作用

每个块都有一个块首部。这个块首部中有一个事务表。事务表中会建立一些条目来描述哪些事务将块上的哪些行/元素锁定。这个事务表的初始大小由对象的INITRANS 设置指定。对于表，这个值默认为2（索引的INITRANS 也默认为2）。事务表会根据需要动态扩展，最大达到MAXTRANS 个条目（假设块上有足够的自由空间）。所分配的每个事务条目需要占用块首部中的23～24 字节的存储空间。注意，对于Orac

2012-09-24 21:53:38 942

转载 Oracle 常见的33个等待事件 .

Oracle 常见的33个等待事件分类： Oracle Performance 2010-08-12 19:555132人阅读评论(1)收藏举报之前整理过一篇文章： Oracle 等待事件 http://blog.csdn.net/tianlesoftware/archive/2010/05/31/5635

2012-09-23 15:01:50 1394

转载 Oracle Latch 说明

Oracle Latch 说明分类： Oracle PerformanceOracle Advanced Knowledge 2010-01-27 22:121589人阅读评论(1)收藏举报一. Latch 说明 1.1 Latch在之前的一篇文章里的第四部分对Latch 有了说明，参考：锁死锁阻

2012-09-23 14:55:25 1075

转载 CR (consistent read) blocks create 说明

CR (consistent read) blocks create 说明分类： Oracle Basic Knowledge 2011-06-07 13:391390人阅读评论(1)收藏举报网上google的资料，翻墙之后的结果，翻墙之前网页打不开： The CR blocks created： Oracle metric is

2012-09-23 14:42:17 1177

转载 datafile block

datafile block block size :8192Offset0123456789abcdef 00014000 06 A2 00 00 0A 00 40 01 0E 89 43 00 00 00 05

2012-09-23 14:14:45 869

转载 Orace ITL(Interested Transaction List) 说明

Orace ITL(Interested Transaction List) 说明分类： Oracle Advanced Knowledge 2011-06-29 00:571551人阅读评论(1)收藏举报目录(?)[-]四. ITL 信息的相关说明 ITL 中SCN 和 FSC 的区别ITL 状态说明一. ITL 说

2012-09-23 14:13:29 1179

转载 Oracle oradebug 命令使用说明

Oracle oradebug 命令使用说明分类： Oracle Performance 2011-06-04 00:382110人阅读评论(0)收藏举报在之前的HangAnalyze 中有使用oradebug命令，在这篇文章里，我们主要是重点看一下这个oradebug命令： Oracle HANGANALYZE功能诊断

2012-09-23 12:36:50 1158

转载 Oracle datafile block 格式说明

Oracle datafile block 格式说明分类： Oracle Advanced Knowledge 2011-08-02 18:401958人阅读评论(1)收藏举报目录(?)[-]一. DUMP DatafileBlock 示例二.Datafile Block 格式说明三. block坏掉了还可以报如下的错误

2012-09-23 12:11:41 897

转载数据块（Data Block）原理深入剖析

数据块（Data Block）原理深入剖析什么是数据块（Data Block）数据块（Oracle Data Blocks），本文简称为“块”，是Oracle最小的存储单位，Oracle数据存放在“块”中。一个块占用一定的磁盘空间。特别注意的是，这里的“块”是Oracle的“数据块”，不是操作系统的“块”。Oracle每次请求数据的时候，都是以块为单位。也就是说，Oracle每次请求的

2012-09-23 12:07:50 1057

转载 bitmap索引的深入研究

位图（bitmap）索引是另外一种索引类型，它的组织形式与B树索引相同，也是一棵平衡树。与B树索引的区别在于叶子节点里存放索引条目的方式不同。从前面我们知道，B树索引的叶子节点里，对于表里的每个数据行，如果被索引列的值不为空的，则会为该记录行在叶子节点里维护一个对应的索引条目。而位图索引则不是这样，其叶子节点里存放的索引条目如下图所示。假设某个表T里所有的记录在列C1上只具有三

2012-09-23 11:39:20 725

转载 From Process To Peoplesoft Page

Last week we discussed finding the best Peoplesoft page, and the menu path to that page, for viewing and updating a particular database table. We have a similar need to find the menu path to the run

2012-09-08 15:36:24 750

转载 The Bug in Every Peoplesoft SQR Program

I shouldn’t claim that this bug appears in every SQR program written for the Peoplesoft environment. It’s not even in every SQR program that takes run control parameters. But I bet it is in most of

2012-09-08 15:31:07 757

转载 8 Special And Great SQR Features

1. Easy, In-Line Integration With SQLThe begin-execute, begin-select, and begin-sql commands support any SQL statement, using SQL syntax. The execute (for a stored procedure in Sybase and Micro

2012-09-08 15:02:20 1028

转载 How to Turnoff/Disable a PeopleSoft Workflow Event?

How to Turnoff/Disable a PeopleSoft Workflow Event?How to disable a PeopleSoft Workflow?How to disable a particular PeopleSoft Workflow Activity/Event?This solution is applicable for

2012-09-06 19:27:05 1111

转载 Skilling up for Oracle Fusion

Hopefully you know that:PeopleSoft is now owned by OracleOracle are developing the next generation of enterprise applications collectively known asFusion applications.Oracle have already sta

2012-09-05 21:59:35 793

转载 PeopleSoft upgrade: a job well done!

PeopleSoft upgrade: a job well done!Upgrading from one version of PeopleSoft to another one is a complex job. This post gives an overview for a practice case of an upgrade from HRMS v8.3 to HCM v8.9

2012-07-19 22:52:12 1343

转载 Pointers for developing selfservice in PeopleSoft

Pointers for developing selfservice in PeopleSoftMore and more companies use selfservice funcionality. PeopleSoft deliveres some out-of-the-box selfservice functionality, but what if you want to dev

2012-07-19 22:50:00 601

转载 Integration Peoplesoft HCM – Tasper

Integration Peoplesoft HCM – TasperTasper is a Dutch application in which employee’s can choose their own package of secondary conditions of labour. For clients it can be interesting to bye a packag

2012-07-19 22:49:12 958

转载 Generic prompting PeopleTools 8.50

Generic prompting PeopleTools 8.50As of PeopleTools 8.50, Oracle introduced Generic Prompting for process definitions. With this feature the creation of runcontrol pages has become obsolete. Peopl

2012-07-19 22:47:38 654

转载 The problem of waiting time when launching a unix shell command from an application engine

The problem of waiting time when launching a unix shell command from an application engineWe made a unix shell script that would wait for a certain unknown amount of files to be downloaded, which ta

2012-07-19 22:45:09 833

转载 Migrating HR data

Migrating HR dataDuring the last year I was involved in a project that had to migrate HR data from one system (SAP) to another (PeopleSoft) because of a merger. In many data migration projects where

2012-07-19 22:44:16 871

转载 PeopleTools 8.50 Hints & Tips: Configuring Report Manager

PeopleTools 8.50 Hints & Tips: Configuring Report ManagerThis posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.Configuring Report Man

2012-07-19 22:40:10 810

转载 Setup Manager revisited

Setup Manager revisitedPeopleSoft Setup Manager has replaced the manual table loading sequence since PeopleSoft version 8.9. However, there are still some people reluctant to use it. For this reason

2012-07-19 22:29:00 762

转载 PeopleSoft and RSS feeds

PeopleSoft and RSS feedsSince PeopleSoft is an Internet architecture one suspects that it should support the commonly used RSS feeds that are available through internet. And guess what: it does!

2012-07-19 22:25:28 848

转载 A best practice vs a best system.

A best practice vs a best system.As information technology is here to stay in HR and its role in future HR execution will increase evermore, I thought it might be a good idea to add a blog every now

2012-07-19 22:21:17 811

转载 Extending SmartHire (Template Based Hire) with custom Field Change & Field Prompt Events

Extending SmartHire (Template Based Hire) with custom Field Change & Field Prompt Events ‘Hiring new employees or adding contingent workers into the system is one of the most time-consuming ta

2012-07-19 22:18:14 1267

转载 Using RTE enabled fields in BI Publisher with PeopleTools 8.52

Using RTE enabled fields in BI Publisher with PeopleTools 8.52In PeopleTools 8.50 adding a Rich Text Editor to Long fields was introduced. With this RTE users are able to actually format text like

2012-07-19 22:08:36 2160