[原创]Linux 删除大量文件报错-[Argument list too long]
一个目录下面有上千上万个日志文件,通过通配符*匹配删除,碰到-[Argument list too long]错误。
如下
$ls -lrt| wc -l
250,213
$
大概有250k的文件个数,这个时候通过rm删除,报错
$ rm *.env
ksh: rm: /bin/rm: cannot execute [Argument list too long]
$
通过变通方法删除,如下
$find ./ -name "*.log" -delete
[原创]Linux更新python版本
Linux默认版本2.6,更新2.7版本的简单汇总
[原创]PPT瘦身工具
有时写的ppt文档大小很大,发送邮件或者移动端打开多少会浪费时间和流量。找了这个可以瘦身的Macro工具,可以删除ppt里面不必要的模板。
[原创]ipmitool命令
ipmitool Oracle Exadata IPMI — Intelligent Platform Management Interface, an interface standard that allows remote management, of a server from another, using standardized interface and to check status of components.
[原创]Oracle 11g之后内存管理
Oracle 11gR之后内存管理的初始化参数追加了以下参数:
MEMORY_TARGET
MEMORY_MAX_TARGET
[原创]Oracle Autonomous Databas 简单介绍
什么是Oracle Autonomous Databas?自治数据库?全球首款自治数据库?
[原创]Oracle DBSAT简单介绍
The Oracle Database Security Assessment Tool (DBSAT) is a command line tool focused on detecting areas of potential security vulnerabilities or misconfigurations and providing recommendations on how to mitigate those potential vulnerabilities. The DBSAT focuses on the database but also examines surrounding database related system components including OS and network (listener). The tool provides a view into the current status, users, roles and policies in place, with the goal of promoting successful approaches to mitigate potential security risks.
The DBSAT has two components: the Collector and the Reporter. The Collector is responsible to collect raw data from the target database by executing SQL queries and OS commands. The Reporter will read the collected data, analyze it and produce reports with the findings. The Reporter outputs three reports in Text, HTML, and XLS formats.
[原创]Oracle12cR2_创建公用用户
在CDB模式下,公用用户(Common User)和本地用户(Local User)两个概念被引入进来,
公用用户可以在CDB和PDB中同时存在,能够连接ROOT和PDB进行操作;而本地用户则只在特定的PDB中存在,也只能在特定的PDB中执行操作;
在PDB中不能创建公用用户,而在CDB中(CDB$ROOT中)同样不能创建本地用户。
[原创]Oracle12cR2_测试在线移动表
Oracle 12cR2 之后 通过
ALTER TABLE...MOVE [PARTITION|SUBPARTITION]
语句容许移动表,分区到另外物理存储空间,或者更改压缩属性等。
更重要的是支持在线-online ,即容许在操作对象在DML操作下也可以实现, 也可以不需要rebuild index等操作了,方便很多。
详细的细节如下:
Moving a table changes the rowids of the rows in the table. If you move a table and include the ONLINE keyword and the UPDATE INDEXES clause, then the indexes remain usable during the move operation. If you include the UPDATE INDEXES clause but not the ONLINE keyword, then the indexes are usable immediately after the move operation. The UPDATE INDEXES clause can only change the storage properties for the global indexes on the table or storage properties for the index partitions of any global partitioned index on the table. If you do not include the UPDATE INDEXES clause, then the changes to the rowids cause the indexes on the table to be marked UNUSABLE, and DML accessing the table using these indexes receive an ORA-01502 error. In this case, the indexes on the table must be dropped or rebuilt.
[原创]Oracle12cR2_通过控制文件查看cdb的结构
通过trace控制文件可以清楚了解CDB的结构
[原创]Oracle12cR2_创建PDB
PDB创建有很多方法,下面介绍一下比较常用的创建方法
[原创]Oracle12cR2_手工创建CDB
Oracle12cR2创建CDB有很多方法:
常用有 DBCA创建CDB 和 手工创建CDB 两种方法,以下是手工创建CDB的步骤。