Objectives分类- 逻辑Single column or concatenaed Unique or nonunique function-based domain ( 使用比较少，索引数据库以外的数据 )- 物理 分区表 或 非分区表 B-tree : Normal or reverse ...
转载
2013-01-13 23:40:00
197阅读
2评论
目标：索引分类：B-tree索引：Bitmap索引：索引比较：创建B-tree索引：创建Bitmap索引：
转载
精选
2013-11-29 22:06:19
328阅读
ObjectivesStoring User DataRegular tablesPartitioned tablesIndex-organized tablesClustered tables普通表分区表 : 如果一个表太大了，那么就会在这个大表的基础上，在分为子表，叫做 partition. 每...
转载
2013-01-08 00:09:00
159阅读
2评论
Creating Synonyms
To create a private synonym in your own schema, you must have the CREATE SYNONYM privilege. To create a private synonym in another user's schema, you must have the CREATE ANY SYNONY
原创
2010-08-10 15:53:04
502阅读
角色是 privilege 集合 单纯的privilege使用不方便。（ 可以包括 system, object privilege, roles )Improved performance ( 另一个好处 )Dynamic : 一改全改，比如改变 role 里的部分权限，那么所有拥有该 role的...
转载
2013-01-18 14:15:00
205阅读
2评论
1 #include<bits/stdc++.h> 2 using namespace std; 3 #define FOR(i,n,m) for(int i=n;i<=m;i++) 4 //#define gc getchar() 5 inline int read();static char b ...
转载
2021-09-18 15:25:00
98阅读
2评论
1.Know your money prioritesYour focus is what’s most important in your life ,right now.2.Determine your monthly payAs the saying goes, “what gets measured, gets
原创
2022-08-03 13:39:34
116阅读
Sucurity domain : The database administrator defines the names of the users allowed to access a database. A security domain defines the settings that ...
转载
2013-01-18 09:23:00
143阅读
2评论
System : 一些特定的数据库动作，和具体的object 没有关系object : 和具体的 object 有关系，操作或访问该对象等等。System privilegesSystem Privileges:The privileges can be classified as follows:...
转载
2013-01-17 21:44:00
151阅读
Managing Infrastructure with Puppet 电子版
转载
2011-07-07 08:31:43
191阅读
http://tomcat.apache.org/tomcat-7.0-doc/monitoring.html
转载
2019-02-10 21:43:00
103阅读
2评论
SummaryConfiguration Automaitc Undo Management将undo_management设置为auto设置当前的undo tablespaceCreate an UNDO tablespaceProperly size an UND tablespaceObtain undo segment informationlittle demo查看一个事务占用了多少undo block？SQL> create table t2 as select * from all_objects where 1=0;Table created.SQL> select
转载
2013-07-16 13:06:00
45阅读
2评论
What Is a Control File?Every Oracle Database has a control file, which is a small binary file
原创
2022-09-16 12:53:10
89阅读
https://discuss.elastic.co/t/memory-usage-of-the-machine-with-es-is-continuously-increasing/23537/7 里提到ES内存缓慢上升可能是因为小文件过多（ES本身会在index时候建立大量的小文件），linux dentry 和 inode cache会增加。可以通过设置vfs_cache_pres
转载
2024-02-27 10:41:34
87阅读
16 Managing Undo 从Oracle11g开始，在默认安装中oracle会自动管理undo, 典型安装中不需要DBA介入配置，然而，如果选择了flash back特性，你就需要进行一些undo管理任务，来保证flashback特性的成功执行。 本章包含如下内容: 什么是undo 自动un
转载
2018-07-04 11:18:00
88阅读
2评论
how to write applications that have fine-grained control over their usa
原创
2023-02-16 16:17:50
76阅读
From: http://developer.android.com/training/displaying-bitmaps/manage-memory.htmlIn addition to the steps described ie garbage c
转载
2023-07-24 11:30:46
54阅读
Managing Optimizer StatisticsThis chapter explains why statisti
原创
2022-11-28 16:01:21
99阅读
Primary Key Optimization8.3.2The primary key for a table represents the column or set of columns that you use in your most vitalqueries. It has an associated index, for fast query performance. Query performance benefits fromthe NOT NULL optimizati...
翻译
2021-08-25 11:03:32
277阅读
本章提要--------------------------------------索引会影响 DML 与 select 操作, 要找到平衡点最好从一开始就创建好索引索引概述B*索引其他一些索引索引使用中的一些基本问题--------------------------------------索引概...
转载
2014-07-29 21:14:00
75阅读
2评论
