hank4ever
- 浏览: 84260 次
- 性别:
- 来自: 深圳
-
文章分类
最新评论
-
guji528：
可以这样监控某Oracle用户已执行的sql：
--TEST用 ...
v$sql,v$sqlarea,v$sqltext区别 -
xiaoliu216：
印象深刻。。。
爱情守则
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 LOCAL
SYSAUX DATAFILE 'C:\ORADATA\TEST\SYSAUX01.DBF' SIZE 250M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'C:\ORADATA\TEST\TEMP01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8000M
UNDO TABLESPACE undo
DATAFILE 'C:\ORADATA\TEST\undo01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
USER SYS IDENTIFIED BY SOUPERSEEKRET
USER SYSTEM IDENTIFIED BY MYSEEKRET
;
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 LOCAL
SYSAUX DATAFILE 'C:\ORADATA\TEST\SYSAUX01.DBF' SIZE 250M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'C:\ORADATA\TEST\TEMP01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8000M
UNDO TABLESPACE undo
DATAFILE 'C:\ORADATA\TEST\undo01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
USER SYS IDENTIFIED BY SOUPERSEEKRET
USER SYSTEM IDENTIFIED BY MYSEEKRET
;
分享到：
发表评论
-
Hp unix中问题解决方案讲解
2010-08-13 18:29 1062当我们经常操作Hp unix的时候，就会遇到在操作系统上rm掉 ... -
HP-UX下删除文件无法释放空间
2010-08-13 18:28 24901 引言 很多人会遇到在操作系统上rm掉一个大的文件，以解决 ... -
v$sql,v$sqlarea,v$sqltext区别
2009-12-17 13:11 3064v$sqltext 存储的是完整的SQL,SQL被分割 SQ ... -
oracle SYS_CONTEXT列表
2009-10-16 10:27 940select SYS_CONTEXT('USERENV', ... -
Oracle CONNECT BY 循环 错误
2009-10-10 23:16 1610java.sql.SQLException: ORA-0143 ... -
Oracle创建索引要做到三个适当
2009-09-28 11:59 2383在Oracle数据库中，创建 ... -
分布式oracle中databaselink
2009-09-21 20:31 1151数据库链接定义从一个Oracle数据库到另一个数据库的单行通信 ... -
oracle：java stored procedure or function
2009-09-20 14:35 1136--java source hasn't return val ... -
create oracle package
2009-09-20 14:15 4255一、程序包的相关知识 1.定义与说明 a. 相关对象的封装 ... -
Procedure to kill a session
2009-09-07 22:31 1004On the Oracle-L mailing list a ... -
oracle 动态SQL
2009-09-06 19:47 747sql_update := 'update ' || tabl ... -
1.Oracle游标大全;2.分析Oracle日志文件
2009-07-17 16:28 13031.Oracle游标大全 SELECT语句用于从数据库 ... -
PI 实时数据库系统
2009-07-17 10:21 2320PI 实时数据库系统(Plant Information Sy ... -
rlwrap使用方法
2008-12-04 15:45 1126在Windows操作系统上,当在DOS命令窗口中运行SQL*P ... -
recovery
2008-09-27 15:31 704Understanding the types of fail ... -
backup
2008-09-27 15:30 758The control files contain the m ... -
Database Maintenance
2008-09-24 16:11 771Oracle 10g provides many tools ... -
Assigning a Profile to a User
2008-09-19 15:04 924A profile serves two purposes: ... -
Sizing the Large Pool
2008-09-19 09:35 707select sum(value) "Max MTS ... -
Oracle Net manages
2008-09-18 12:06 1062Oracle Net manages the flow of ...
相关推荐
fields indexes with descending, ascending, case-sensitive and insensitive options Shareable tables Default values support Min, max and not null constraints on field values Export to SQL script ...
Create the program of the database deployment by BDB. Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. 3.The database auto-update. ...
Create the program of the database deployment by BDB. Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. 3.The database auto-update. ...
1. database design, database deployment: support forward engineering and reverse engineering with the database. Through BDB, you can design a new database, automatically create or renew to an entity ...
1. database design, database deployment: support forward engineering and reverse engineering with the database. Through BDB, you can design a new database, automatically create or renew to an entity ...
Create the program of the database development by BDB. Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. 3.The database auto-update....
•Create your own database from a model, or a model from your existing database with the Database Designer, including layers, subject areas, autoroute, notation format, and much more. •Comprehensive...
2) Run applicationCreator for each chapter (this will create the compile scripts with your environment in them) applicationCreator com.gwtapps.tutorial.client.Hangman applicationCreator ...
Create the program of the database deployment by BDB. Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. 3.The database auto-update. ...
The tool allows to create and execute queries, develop and debug routines, automate database object management in the convenient environment. dbForge Studio also provides utilities to compare, ...
Script Utilities lets you create hi-performance log files, works with binary data, you can download multiple files with zip/arj compression, work with INI files and much more with the ASP utility.
Create the program of the database development by BDB. Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. 3.The database auto-update....
We’ll begin by exploring how to create and run a Python script. This chapter focuses on basic Python syntax and the elements of Python that you need to know for later chapters in the book. For ...
SQL Multi Script - allows you to quickly and easily create complex scripts for SQL Server. SQL Refactor - helps the user to automatically format your SQL code and database objects that provides a ...
8. Create database and database user. Import the database dump from /sql/clipshare.sql with phpmyadmin 9. Access your ClipShare Admin Panel at http://www.yourdomain.com/siteadmin/ Default admin user ...
Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter....
The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source. 5. Display and edit data in the grid, including BLOB and image fields. Currently ...
4. The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source. 5. Display and edit data in the grid, including BLOB and image fields. Currently ...
4. The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source. 5. Display and edit data in the grid, including BLOB and image fields. Currently ...
Create the program of the database deployment by BDB. 创建程序数据库部署bdb 。 Besides the normal envocation, BDB supply the support of outer command line invoking the database auto-installation. ...