- 浏览: 257648 次
- 性别:
- 来自: 南京
文章分类
- 全部博客 (143)
- ORACLE PL/SQL Developer (5)
- ORACLE (24)
- PYTHON (1)
- 理财投资 (2)
- Cocos2d (1)
- 3D游戏引擎 (1)
- 存储 (1)
- MariaDB (1)
- LAMP (2)
- Windows 7 (8)
- Windows TIME_WAIT (1)
- ADOBE READER (1)
- OFFICE Excel 2007 WORD (1)
- Visual Studio 2013 (1)
- 百度轻应用 (0)
- Delphi7 Windows7 (1)
- ORACLE 9i 11g EXP IMP (1)
- HP-Socket (0)
- WINDOWS PHONE 8 (2)
- visual studio 2012 2013 (1)
- Windows Phone 7 (1)
- Microsoft Office (1)
- Oracle 11g (1)
- Android (3)
- 魔兽世界 (1)
- 纸牌屋 (0)
- 云主机 (1)
- WhatsApp (1)
- Windows Phone 8 SDK (1)
- Visual Studio 2012 (1)
- chromium embedded framework (1)
- 一起寻找失联马航 (1)
- Remote Desktop (1)
- Delphi 2007 (2)
- Delphi_2007_for_Win32 (0)
- 虚幻引擎4 (1)
- 技能 (1)
- WebScarab Project (1)
- OPENSSL (1)
- PHP (3)
- Burp Suite (1)
- p2p网贷 (1)
- CVE-2014-0160 (1)
- jekyll (1)
- JAVA (3)
- delphi (2)
- Ajax (1)
- wordpress (2)
- Apple Swift (1)
- 苹果产品 (1)
- 苹果设备 (1)
- Mobile Game (1)
- FileCut (1)
- Go Lang (1)
- WeebLy (1)
- Chrome (2)
- IE (2)
- Windows PATH (1)
- MinGW (1)
- VC++ 2008 (1)
- SSD (1)
- Windows IE (2)
- Android Studio (1)
- VMWARE (1)
- JAVA GUI (1)
- 鼻炎 (1)
- 电影 (1)
- VS2010 (1)
- SEP (1)
- 开源软件 (1)
- 客户经理 (1)
- SVN (1)
- 开源硬件平台 (1)
- CENTOS LINUX (1)
- GOOGLE (1)
- LINUX (4)
- HSQLDB (1)
- XBOX (1)
- VC++ (1)
- INTERNET (1)
- HARDWARE (1)
- AAR (1)
- 心理健康 (1)
- PUTTY (1)
- CLOUD (1)
- MEMO (1)
- IE 10 CSS (1)
- BAIDU (1)
- 字体 (1)
- Windows (1)
- MAC (1)
- MYSQL (2)
- bootstrap (1)
- tomcat (1)
- excel 2003 2007 (1)
- QMS (1)
最新评论
-
1036225283:
就不能截个图么
最适合程序员的字体:Yahei consolas hybrid 修正版 -
hotsmile:
不错,身体很重要!!!!!!
过敏性鼻炎的治疗方法 -
zyiqibook:
多谢分享,好
过敏性鼻炎的治疗方法 -
dbaspider:
ria2008 写道生成的文件没有办法看啊!生成的zip文件解 ...
win 7 自带神器 - psr 问题步骤记录器 -
ria2008:
生成的文件没有办法看啊!
win 7 自带神器 - psr 问题步骤记录器
SELECT SYS_CONTEXT ('USERENV', 'IP_ADDRESS') FROM DUAL;
declare
/* */
begin
dbms_auto_task_admin.DISABLE('auto optimizer stats collection', null, null);
end;
/
begin
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto space advisor', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);
end;
/
call dbms_stats.gather_database_stats_job_proc ( )
select * from DBA_AUTOTASK_OPERATION
select sysdate from dual
union all
select current_date from dual
union all
select systimestamp from dual;
select * from v$timezone_names;
ALTER DATABASE SET TIME_ZONE = '+8:00';
select * from database_properties where property_name='DBTIMEZONE';
select * from database_compatible_level;
select * from database_export_objects;
select database_name from dual;
select dbtimezone from dual;
declare
/* */
begin
dbms_auto_task_admin.DISABLE('auto optimizer stats collection', null, null);
end;
/
begin
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto space advisor', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);
end;
/
call dbms_stats.gather_database_stats_job_proc ( )
select * from DBA_AUTOTASK_OPERATION
select sysdate from dual
union all
select current_date from dual
union all
select systimestamp from dual;
select * from v$timezone_names;
ALTER DATABASE SET TIME_ZONE = '+8:00';
select * from database_properties where property_name='DBTIMEZONE';
select * from database_compatible_level;
select * from database_export_objects;
select database_name from dual;
select dbtimezone from dual;
发表评论
-
Oracle Critical Patch Update for July 2015
2015-07-15 12:39 955July 14, 2015 Oracle Critical P ... -
Oracle Security Alert CVE-2015-3456 ("Venom") was released on May 15th, 2015
2015-05-18 10:51 910Security Alert CVE-2015-3456 (& ... -
Oracle 外键查询和操作
2015-04-16 10:22 968临时禁止外键: alter table EMP modify ... -
Oracle 批量杀进程
2015-04-15 11:44 1724紧急情况下,可以用下面shell命令把所有的客户端连接进程杀掉 ... -
Oracle Critical Patch Update for April 2015
2015-04-15 11:19 891April 14, 2015 Oracle Critical ... -
Linux下Oracle系统参数设置
2015-04-13 14:06 726cat /proc/sys/vm/pagecache /et ... -
ORACLE 锁监控SQL
2015-04-09 20:07 484SELECT a.sid||decode(request,0 ... -
ORACLE 闪回误更新数据的表
2015-04-09 20:05 6721、确保数据库启用了 闪回 功能: db_recovery_ ... -
Oracle hard-parse vs. soft parse
2015-04-09 20:04 609Oracle hard-parse vs. soft pars ... -
Enq Tx - Row Lock Contention HOWTO
2015-04-09 20:01 792Troubleshooting Details List o ... -
DBA SQL TREE For Oracle
2015-02-06 12:40 669软件简介:DBA SQL TREE For Oracle ... -
Db Compare For Oracle - Oracle数据库比较程序
2014-12-12 09:49 2419“Db Compare For Oracle” 适用于以下操作 ... -
How to query the alert log using SQL?
2014-05-05 11:39 775In Oracle 11g, How to query the ... -
Oracle 11g下使用RMAN进行备份和恢复操作(二)
2014-02-24 19:20 1739这次介绍下使用rman进行全库备份,数据库处于open状态 ... -
ORA-01882 问题的解决
2014-02-21 09:24 1737【问题描述】 通过 pl sql developer 查 ... -
常用 ORACLE 技术网站
2014-02-21 09:24 622(1). ORACLE中国用户组 http://www.o ... -
ORACLE DATABASE 12c INTERACTIVE QUICK REFERENCE
2014-02-20 14:29 862Oracle Database 12c: Interacti ... -
Oracle数据库体系图
2013-12-04 19:16 698分享一份Oracle数据库体系图:包括体系结构、进程结构、 ... -
如何提升访问ORACLE SUPPORT(MOS/MetaLink)的访问速度
2013-12-02 10:55 841在hosts文件中把下面地址重定向到本机,赶紧去体验M ... -
Oracle中可创建的最大用户数量
2013-11-20 11:02 1116今天有人问这个问题,Oracle中可创建的最大用户数量 ...
相关推荐
Welcome to “Beginning SQL for Oracle Database 18C”! Thanks for picking up this book. It’s safe to say you’re interested in learning about Oracle database, as that’s what this book is about. Why ...
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. This new edition has been expanded to include AWR, Oracle 12c ...
The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle’s version of the SQL query language....
高清彩版 Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. This chapter ...
Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to ...
SQLTracker是监视使用Oracle数据库的应用程序,支持win7,win10 64位执行时对数据库进行操作的sql的工具,包含32位版和64位版,绿色软件,解压缩后就能用测试使用C/S架构的ERP程序,这个架构的好处就是局域网使用...
Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle’s specific implementation of the language, including Oracle-specific features and syntax....
Oracle SQL Developer User's Guide Release 1.5-194
language that provides procedural extensions to Oracle’s version of SQL (Structured Query Language) and serves as the programming language within the Oracle Developer toolset (most notably Forms ...
Oracle SQL PLSQL练习60题,简要如下: 1. Oracle发出下列select语句: SQL> select e.empno, e.ename, d.loc 2 from emp e, dept d 3 where e.deptno = d.deptno 4 and substr(e.ename, 1, 1) = ‘S’; 下列哪个语句...
The book's unique side by side approach makes it easy for the reader to learn three major query languages in the IT industry. The author has over 20 years of experience in database design.
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth ...
ORACLE_FAQ中是itpub高手的多年经验总结出来的oracle开发的经典资料,包括pl-sql技巧,oracle体系架构,oracle备份与恢复,oracle优化,不同O/S上的开发,网络开发等
Grammar for Oracle's SELECT statement for ANTLR v3, target C language
作者通过总结各自多年的软件开发和教学培训经验,与大家分享了掌握Oracle SQL所独有的丰富功能的技巧所在,内容涵盖SQL执行、联结、集合、分析函数、子句、事务处理等多个方面。读者可以学习到以下几个方面的技巧:...
If you’re doing database application development in the Oracle environment, you’re going to have to know PL/SQL, the company’s extended query and update language. If you want your programs to ...
Oracle 连接 SQL 详细的操作SOP