hank4ever
- 浏览: 88332 次
- 性别:
- 来自: 深圳
-
最新评论
-
guji528：
可以这样监控某Oracle用户已执行的sql：
--TEST用 ...
v$sql,v$sqlarea,v$sqltext区别 -
xiaoliu216：
印象深刻。。。
爱情守则
文章列表
Understanding the types of failures that can occur in the database is critical to deciding the type of action required to recover from the failure. We reviewed the six types of failures in a database: statement, user process, network, user errors, instance, and media.
至此，11章的SG view结束~~
- 2008-09-27 15:31
- 浏览 773
- 评论(0)
The control files contain the metadata about every other structure in the database. The online redo log files provide performance benefits
to ongoing transactions and ensure that no committed transactions are lost after an instance failure; being able to change the number of redo log groups and the n ...
- 2008-09-27 15:30
- 浏览 800
- 评论(0)
Oracle 10g provides many tools for proactively identifying and fixing potential performance and management problems in the database. At the core of the monitoring system is the Automatic Workload Repository (AWR), which uses the MMON background process to gather statistics from the SGA and store them ...
- 2008-09-24 16:11
- 浏览 822
- 评论(0)
A profile
serves two purposes: first, it can limit the resource usage of some resources, and second, it can
enforce password-management rules.
The default profile is appropriately named default. To explicitly assign a profile to a user,
include the keywords PROFILE profile_name in the CREATE USER or ...
- 2008-09-19 15:04
- 浏览 969
- 评论(0)
select sum(value) "Max MTS Memory Allocated"from v$sesstat ss, v$statname st where name = 'session uga memory max'and ss.statistic# =st.statistic#;
Max MTS Memory Allocated
------------------------
244416
- 2008-09-19 09:35
- 浏览 794
- 评论(0)
世界上有两种人：一种是带着别人跑的人，另一种是永远跟着别人跑的人，你是哪种人，就看你的长远的眼光和一个选择决定！ 李嘉诚说过：“在别人都没明白的时候你明白了你就赢了,当别人都明白的时候你已经掌握了一切”。我们需要在市场尚未成熟的时候去把握他的发展方向和趋势！ 什么是机会-- 机会就是在一片反对声中开始，一片议论声中进行，一片鲜花和掌声中结束；机会就是当别人还不明白，还不理解，甚至误解我们时，我们明白我们在作什么，我们理解我们想要什么．当别人明白时，我们已经成功了．当别人理解时，我们已经富有了；机会像小偷，来的时候悄无声息，走的时候让你损失惨重！！
- 2008-09-18 12:10
- 浏览 840
- 评论(0)
Oracle Net manages the flow of information from client computers to Oracle servers and forms the foundation of all networked computing in the Oracle environment. Oracle Net provides services that can be divided into five main categories: connectivity, directory services, scalability, security, and ac ...
- 2008-09-18 12:06
- 浏览 1102
- 评论(0)
1.在 Ubuntu 中激活root 帐号：
a. 在终端执行 sudo passwd root 指令后，系统将会提示你设置一
个新的 root 帐号密码。
b. 点击 System -> Preferences -> Login Window 菜单，并切换
到 Security 选项页，然后选中其下的“Allow local system
administrator login”选项。
执行上述两步后，你便可以使用 root 帐号登录 Ubuntu 系统了。
2.网络设置
在WM下 虚拟机菜单栏里 虚拟机 --设置--点击以太网-选择仅
...
- 2008-09-16 14:55
- 浏览 1098
- 评论(0)
Heterogeneous Services provide the ability to communicate with non-Oracle databases and services.
These services allow organizations to leverage and interact with their existing data stores
without having to necessarily move the data to an Oracle server.
The suite of Heterogeneous Services comprises ...
- 2008-09-16 12:12
- 浏览 864
- 评论(0)
CREATE DATABASE TEST
CONTROLFILE REUSE
LOGFILE
GROUP 1 'C:\ORADATA\TEST\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORADATA\TEST\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\ORADATA\TEST\REDO03.LOG' SIZE 10M
DATAFILE 'C:\ORADATA\TEST\SYSTEM01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOC ...
- 2008-09-14 10:09
- 浏览 789
- 评论(0)
Starting with the highest level of Oracle disk-space management are tablespaces. Drilling down,you find segments that can reside in only one tablespace. Each segment is constructed from one or more
extents. Each of these extents can reside in only one datafile. Thus, for a segment to straddle multipl ...
- 2008-09-13 21:34
- 浏览 988
- 评论(0)
If you are running in a Windows environment and shut down the database
using either the Database Control or SQL*Plus tools, the Oracle Service will continue to run. Even though the Oracle Windows service is running, the database is not available until a subsequent startup command is issued.
- 2008-09-13 14:00
- 浏览 894
- 评论(0)
今天新装了linux系统 ,认真彻底的装了一遍jdk:
1．安装JDK (我想将它安装在 /usr 目录中)
.bin包：#chmod a＋x jdk1.5.0.bin // a表示对所有用户授予执行权限
将 .bin包 拷贝到/usr目录中
在/usr目录中 #./ jdk1.5.0.bin //进行安装
2．配置JDK环境变量(JDK文件安装在 /usr/jdk1.5.0)
#vi /etc/profile //编辑profile，加入如下语句
export JAVA_HOME=/usr/jd ...
- 2008-09-11 18:06
- 浏览 1711
- 评论(0)
数据库的备份与恢复
逻辑备份方式：
数据导出
c:/exp qqq/qqq123@orcl
5000(设置大小)
>c:\mybak.dmp(导出存储位置)
>E/U/T
>yes
>yes
>table_name
数据恢复
c:/>inp qqq/qqq123
>c:\mybak.dmp(备份存储位置)
>yes
>yes
>yes
>yes
物理备份方式：
冷备份/脱机备份
SQL>shutdown immediate （必须是管理员）
拷贝走相应的文件
热备份/联机备份
日志改为归档模式
SQL&g ...
- 2008-09-05 09:08
- 浏览 823
- 评论(0)
去年学习linux时做过的部分笔记，浅显易懂，比较简单
//////////////////////////////////////////////
shell脚本
与windows 批处理相似 功能更加强大 已经是一门编程语言了
为了使用bash shell来执行脚本magic，其命令是:
$bash magic 或 $ ./magic
$为终端提示符（普通用户）
shell可以起任何名字，为了规范，使用 .sh后缀
echo命令
用于在屏幕上显示信息
例如: $echo "This is an example"
# 注释符号
linux中所有的变量都被挡作字 ...
- 2008-09-05 08:51
- 浏览 1062
- 评论(0)