Ayumie

摘要： https://technology.amis.nl/2011/04/02/oracle-forms-10g-tuning-tips/ Although there are quite some new screenbased application techniques, a lot of com 阅读全文

摘要： ------sql plans(plan_hash_value) select ss.plan_hash_value phv, to_char(s.begin_interval_time, 'DD-MON HH24:MI') snap_time, ss.executions_delta execs, ss.buffer_gets_de... 阅读全文

摘要： SQL调优工具包DBMS_SQLTUNE的使用方法 http://blog.chinaunix.net/uid-23284114-id-4192029.html oracle 提供了优化建议功能包DBMS_SQLTUNE，该包可以帮助我们分析SQL，并提供优化建议。 原有执行计划alter sess 阅读全文

摘要： 查询Flash Recovery Area和归档信息 SQL> show parameter db_recovery_file_dest NAME VALUE db_recovery_file_dest E:\oracle\product\10.2.0\flash_recovery_area db_ 阅读全文

摘要： ORA-00265: instance recovery required, cannot set ARCHIVELOG mode 一、故障现象： SYS@PROD>alter database archivelog; alter database archivelog * ERROR at lin 阅读全文

摘要： RMAN 备份脚本 -->注意格式的写法\\IP\Shared_folder\ ( 试验有问题) run{ allocate channel ch1 device type disk; allocate channel ch2 device type disk; backup database fo 阅读全文

摘要： dba_jobs:This view lists all jobs inthe database. dba_scheduler_jobs:Job scheduler job detail. http://www.dba-oracle.com/t_dbms_job_scheduler.htm I do 阅读全文

摘要： http://www.dba-oracle.com/job_scheduling/dbms_job_scheduler.htm This section will introduce options available for migrating jobs from the dbms_job pac 阅读全文

摘要： http://www.vitalsofttech.com/ora-12537-tnsconnection-closed/ Question: When trying to establish a sqlplus connection to the database, I get the “ORA-1 阅读全文

摘要： Cause - Failed to access the temporary location.Action - Ensure that the current user has required permissions to access the temporary location.Additi 阅读全文