- 综合排序
- 最热优先
- 最新优先
- 来自专栏bisal的个人杂货铺
COST值相同？是真是假？
select owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate select owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate / owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate */ owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate / owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate
67220发布于 2020-12-18 - 来自专栏bisal的个人杂货铺
COST值相同？是真是假？
select owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate select owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate / owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate */ owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate / owner,object_name,created from t1 where object_name like 'DBA_HIST%' and owner='SYS' and created>sysdate
56920发布于 2021-09-06 - 来自专栏公众号：Lucifer三思而后行
Oracle RMAN删除归档日志脚本
; delete noprompt archivelog until time '(sysdate-7)'; delete noprompt force archivelog until time 'SYSDATE
2K11发布于 2021-09-23 - 来自专栏杨建荣的学习笔记
增量数据丢失的原因分析(三)(r8笔记第91天)
select log_date,owner,job_name,status,ADDITIONAL_INFO from DBA_SCHEDULER_JOB_LOG where log_date>sysdate log_date,owner,job_name,status,ADDITIONAL_INFO from DBA_SCHEDULER_JOB_RUN_DETAILS where log_date>sysdate
1.2K40发布于 2018-03-19 - 来自专栏从ORACLE起航，领略精彩的IT技术。
RMAN备份策略与异机恢复一例
%T.ARC'; crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate-10'; delete %T.ARC'; crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate-10'; delete
93740发布于 2019-05-24 - 来自专栏Oracle DBA
Oracle truncate hang 怎么说？
decode(to_char(completion_time,'HH24'),'23',1,0)) as "h23" from v$archived_log where first_time > trunc(sysdate 1024/1024) as MB ,sum(blocks*block_size)/1024 as KB from v$archived_log where first_time > trunc(sysdate
20900编辑于 2025-01-14 - 来自专栏从ORACLE起航，领略精彩的IT技术。
Oracle ADG环境下的RMAN备份策略
%T.ARC'; crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate-10'; delete %T.ARC'; crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate-10'; delete
1.1K41编辑于 2023-03-06 - 来自专栏杨建荣的学习笔记
闪回区空间不足引发的SQL问题分析（r10笔记第32天）
crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog until time "sysdate
83370发布于 2018-03-19 - 来自专栏杨建荣的学习笔记
巧用分析函数循序渐进解决实际问题 (r4笔记第10天)
SUSPEND',sysdate -6); insert into test values(1,'RESUME',sysdate-3); insert into test values(2,'SUSPEND',sysdate
61270发布于 2018-03-15 - 来自专栏杨建荣的学习笔记
增量数据丢失的原因分析(二)(r8笔记第76天)
SQL>select log_date,owner,job_name,status,ADDITIONAL_INFO from DBA_SCHEDULER_JOB_LOG where log_date>sysdate
88080发布于 2018-03-19 - 来自专栏杨建荣的学习笔记
巧妙使用exchange partition的一个案例(r6笔记第1天)
insert into tab_part select *from test_tab01 where col>sysdate-10; 最后为了把exchange partiton的一个精髓突出出来和在线重定义区分开了
87340发布于 2018-03-16 - 来自专栏DATABASE
RMAN 脚本定时备份数据库
delete noprompt archivelog until time 'sysdate-7';" echo "delete noprompt force archivelog until time 'SYSDATE
1.4K20编辑于 2022-06-28 - 来自专栏开源部署
Oracle知识集锦：对Oracle数据库进行监控检查
，否则会提示找不到表 显示在前面的结果为最新的操作 将scott用户的test表恢复到10分钟前的数据 flashback select * from scott.test to timestamp sysdate
1.4K10编辑于 2022-08-16 - 来自专栏乐沙弥的世界
SQL基础-->过滤和排序
select sysdate + 10 from dual; SYSDATE+10 ---------- 2010-04-07 SQL> select sysdate - 10 from dual; SYSDATE
94720发布于 2018-08-07 - 来自专栏杨建荣的学习笔记
百倍性能的PL/SQL优化案例(r11笔记第13天)
SQL> select count(*)from card_new where DRAWDATE>sysdate-10; COUNT(*) ---------- 78174 如此一来就抓住了问题的本质
95090发布于 2018-03-21 - 来自专栏Java架构师必看
Oracle索引知识学习笔记
sorts (disk) 0 rows processed SQL> 范围查询，发现不走反向索引查询 SQL> select * from t where created>= sysdate
85330编辑于 2022-03-12 - 来自专栏开源部署
Oracle数据库之单行函数详解
：查询出每个雇员的到今天为止的雇佣天数，以及十天前每天雇员的雇佣天数 SELECT empno 雇员编号, ename 雇员姓名, SYSDATE-hiredate 雇佣天数, (SYSDATE 结果有小数点，可以用 TRUNC() 截取小数点 SELECT empno 雇员编号, ename 雇员姓名, TRUNC(SYSDATE-hiredate) 雇佣天数, TRUNC((SYSDATE
3.2K10编辑于 2022-08-18 - 来自专栏Nicky's blog
Oracle索引知识学习笔记
sorts (disk) 0 rows processed SQL> 范围查询，发现不走反向索引查询 SQL> select * from t where created>= sysdate
83320发布于 2019-06-17 - 来自专栏Nicky's blog
Oracle SQL调优系列之索引知识学习笔记
sorts (disk) 0 rows processed SQL> 范围查询，发现不走反向索引查询 SQL> select * from t where created>= sysdate
73810编辑于 2022-05-07 - 来自专栏JiekeXu之路
一线运维 DBA 五年经验常用 SQL 大全（二）
redo 每天切换次数 select trunc(FIRST_TIME,'dd'),count(1) from v$log_history where trunc(FIRST_TIME,'dd')>sysdate log_history b where b.recid = a.recid+1 and to_char(a.first_time,'yyyy-mm-dd hh24:mi:ss') >=to_char(sysdate
1.2K10发布于 2021-03-15
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号