<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csqm87956的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csqm87956</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csqm87956]]></copyright><item><title><![CDATA[技术重要但是要用心更重要。]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270517</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270517</guid><author>csqm87956</author><pubDate>Sat, 13 Jul 2019 13:57:05 +0800</pubDate><description><![CDATA[每天上班，回家，睡觉。 生活单调无聊没有生趣。无聊的我又玩起了，无聊的网络游戏。游离在虚拟的网络与现实之间。感觉自己变的非常的浮躁，没办法静下心来好好做事情。心里隐隐有一种不安的预感，但是我依然浑浑噩噩的生活在这样的日子。白天接...]]></description><category></category></item><item><title><![CDATA[谁能说说user_tables中的各项的意思吗？]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270509</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270509</guid><author>csqm87956</author><pubDate>Sat, 13 Jul 2019 07:42:06 +0800</pubDate><description><![CDATA[OWNER VARCHAR2(30) NOT NULL Owner of the table TABLE_NAME VARCHAR2(30) NOT NULL Name of the table TABLESPACE_NAME ...]]></description><category></category></item><item><title><![CDATA[ORACLE表连接方式分析及常见用法 【转贴】]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270519</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270519</guid><author>csqm87956</author><pubDate>Sat, 13 Jul 2019 07:30:09 +0800</pubDate><description><![CDATA[摘要: 针对在数据仓库环境下,由于超大数据量的处理而产生的效率问题，本文深入分析了ORACLE表的几种连接方式、特点、适用范围,以及对于如何使用和优化做了详细的探讨。
关键字： 数据仓库 ORACLE 表连接 
一 引言
...]]></description><category></category></item><item><title><![CDATA[refresh for database]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270514</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270514</guid><author>csqm87956</author><pubDate>Fri, 12 Jul 2019 19:51:06 +0800</pubDate><description><![CDATA[prepare for this project,checked the environment 1. Check object counts of SYSADM.
SQL&gt; select owner, object_...]]></description><category></category></item><item><title><![CDATA[Ask Tom之中文化20060113——Consistent Gets（一）]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270507</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270507</guid><author>csqm87956</author><pubDate>Fri, 12 Jul 2019 16:39:04 +0800</pubDate><description><![CDATA[Ask Tom之中文化20060113——Consistent Gets（一）
译者说明：这篇至今长达4.3年的帖子相当之冗长，其中有不少详尽的解释。长度决定无法一次性译完，也无法全部翻译。因此下文中有部分内容是译者自...]]></description><category></category></item><item><title><![CDATA[Oracle DBA Interview Questions By B G(zhuan)]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270512</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270512</guid><author>csqm87956</author><pubDate>Fri, 12 Jul 2019 11:51:04 +0800</pubDate><description><![CDATA[Oracle DBA Interview Questions By B G1. How many memory layers are in the shared pool?2. How do you find out from ...]]></description><category></category></item><item><title><![CDATA[如何读取EXCEL文件到内表]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270516</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270516</guid><author>csqm87956</author><pubDate>Thu, 11 Jul 2019 10:18:07 +0800</pubDate><description><![CDATA[1 定义内表data: gt_data type alsmex_tabline occurs 0 with header line.2 定义文件参数parameters: p_file like rlgrap-filename...]]></description><category></category></item><item><title><![CDATA[关于sap的字段和对象修改记录的查找]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270513</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270513</guid><author>csqm87956</author><pubDate>Wed, 10 Jul 2019 16:33:07 +0800</pubDate><description><![CDATA[sap的字段和对象的修改都会保存旧值，数据保存在CDHDR和CDPOS表中，对于提取旧值你可以采用两种方法
1)使用sap的标准函数CHANGEDOCUMENT_READ_HEADERS和CHANGEDOCUMENT_RE...]]></description><category></category></item><item><title><![CDATA[Temp tablespace been  fill up and with error ORA-1652]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270508</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270508</guid><author>csqm87956</author><pubDate>Wed, 10 Jul 2019 11:48:08 +0800</pubDate><description><![CDATA[CAUSE DETERMINATION===================--) When the temporary tablespace fills, any statement that requires additio...]]></description><category></category></item><item><title><![CDATA[SAP默认用户和默认口令]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270504</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270504</guid><author>csqm87956</author><pubDate>Wed, 10 Jul 2019 07:15:05 +0800</pubDate><description><![CDATA[lients
000
000
066
066
New Clients

User ID
DDIC
SAP*
SAP*
EarlyWatch
(SAP*)

Pass Word
19920...]]></description><category></category></item><item><title><![CDATA[BASIS-如何删除SAP在用户修改表结构时创建的临时表]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270510</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270510</guid><author>csqm87956</author><pubDate>Tue, 09 Jul 2019 15:54:06 +0800</pubDate><description><![CDATA[当用户修改表结构时，sap会自动创建临时表，临时表的名称为:'QCM'+表名。这个临时表用于先将需要改变结构的表数据保存下来，当新表结构完成后，系统会将临时表的数据拷贝回数据表。
临时表在sap3.0版本前始终保存在数据库中...]]></description><category></category></item><item><title><![CDATA[SAP Basis来由]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270544</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270544</guid><author>csqm87956</author><pubDate>Tue, 09 Jul 2019 12:45:06 +0800</pubDate><description><![CDATA[SAP Basis就是SAP系统管理员。 
SAP系统管理员为什么要称BASIS,因为在WAS出现入之前,SAP即以Basis Kernel 作为系统核心的名称,久而久之,大家都称SAP系统管理员为Basis.其实翻回SAP ...]]></description><category></category></item><item><title><![CDATA[一份DBA的面试题]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270511</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270511</guid><author>csqm87956</author><pubDate>Tue, 09 Jul 2019 07:57:05 +0800</pubDate><description><![CDATA[1.请说明实例与数据库的关系;表空间和数据文件的关系2.请阐述同议词的作用.你认为情况下要使用同义词.3.varchar2,char两种数据类型有什么区别,如果库表某字段输入"ABC"后储存,该 字段数据类型分别为varchar...]]></description><category></category></item><item><title><![CDATA[SAP CLIENT拷贝详细说明 相关的事物代码:]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270503</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270503</guid><author>csqm87956</author><pubDate>Mon, 08 Jul 2019 20:06:04 +0800</pubDate><description><![CDATA[SCC3 (集团拷贝时查看日志) SCC4 (配置全部集团的目录) SCC5 (集团删除) SCCL (执行集团拷贝) 
Client(集团)拷贝操作步骤: 1.用scc4在集团管理目录里添加一个目的Client(集团). 城...]]></description><category></category></item><item><title><![CDATA[关于sap的Logon的几个参数]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270505</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270505</guid><author>csqm87956</author><pubDate>Mon, 08 Jul 2019 19:42:06 +0800</pubDate><description><![CDATA[1 Authorization updates completed without logging offauth/new_buffering to 该参数设为4,权限的修改将立即起作用,不用用户重新登录. 如果有其他疑问请...]]></description><category></category></item><item><title><![CDATA[诊断并解决ORA-04031 错误【转帖】]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270497</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270497</guid><author>csqm87956</author><pubDate>Mon, 08 Jul 2019 19:36:09 +0800</pubDate><description><![CDATA[诊断并解决ORA-04031 错误 对于大多数应用来说，共享池的大小对于Oracle 性能来说都是很重要的。共享池中保存数据字典高速缓冲 和完全解析或编译的的PL/SQL 块和SQL 语句。 当我们在共享池中试图分配大片的连续内...]]></description><category></category></item><item><title><![CDATA[IDOC 相关程序和事务]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270501</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270501</guid><author>csqm87956</author><pubDate>Mon, 08 Jul 2019 08:21:06 +0800</pubDate><description><![CDATA[程序：RBDMIDOCIDOC生成，根据IDOC类型对修改过的数据生成IDOCRWDIDOCSL按日期、SITE、商品编号、IDOC号码查看I...]]></description><category></category></item><item><title><![CDATA[关于SAP安装过程中的几个问题的TCODE]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270495</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270495</guid><author>csqm87956</author><pubDate>Sun, 07 Jul 2019 16:18:07 +0800</pubDate><description><![CDATA[拟将生产机PRD(sapprd)拷贝到测试机DEV(sapdev)，步骤如下： 


1. 生产机PRD 

# su – prdadm 

# stopsap r3 

# exit 

# ...]]></description><category></category></item><item><title><![CDATA[SAP. T-Code: su01用户维护 sap学习手册I]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270506</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270506</guid><author>csqm87956</author><pubDate>Sun, 07 Jul 2019 10:54:08 +0800</pubDate><description><![CDATA[1 Basis
1. Unix操作
更改口令 passwd eg. passwd orap34看当前路径 pwd 看sap或者oracle的进程 eg. ps -ef|grep sap或者 ora看命令的使用方法，相当于...]]></description><category></category></item><item><title><![CDATA[Oracle 性能优化的基本方法概述[ZT]]]></title><link>https://blog.youkuaiyun.com/csqm87956/article/details/100270500</link><guid>https://blog.youkuaiyun.com/csqm87956/article/details/100270500</guid><author>csqm87956</author><pubDate>Sun, 07 Jul 2019 08:42:05 +0800</pubDate><description><![CDATA[1）设立合理的性能优化目标。2）测量并记录当前性能。3）确定当前Oracle性能瓶颈（Oracle等待什么、哪些SQL语句是该等待事件的成分）。4）把等待事件记入跟踪文件。5）确定当前的OS瓶颈。6）优化所需的成分（应用程序、数...]]></description><category></category></item></channel></rss>