随笔分类 - database-oracle-Application Development

Bullet:关于ORACLE中的HASH JOIN的参数变化

摘要：Oracle在7.3引入了hash join。但是在Oracle 10g及其以后的Oracle数据库版本中，优化器，实际是CBO，也是因为HASH JOIN仅适用于CBO，在解析目标SQL时是否考虑HASH JOIN受到隐含参数_hash_join_enabled，该参数在Oracle 10g以前阅读全文

posted @ 2017-02-16 13:14 syksky 阅读(417) 评论(0) 推荐(0) 编辑

Perl Connect to Database without password as sysdba

摘要：1 #!/oracle/product/11g/db/perl/bin/perl 2 use lib '/oracle/product/11g/db/perl/lib/site_perl/5.10.0'; 3 use DBI; 4 use DBD::Oracle qw(:ora_session_m... 阅读全文

posted @ 2015-09-05 05:03 syksky 阅读(389) 评论(0) 推荐(0) 编辑

Bequeath Connection and SYS Logon

摘要：The following example illustrates how to use the internal_logon and SYSDBA arguments to specify the SYS login. This example works regardless of the da... 阅读全文

posted @ 2015-09-05 05:01 syksky 阅读(438) 评论(0) 推荐(0) 编辑

Oracle query that count connections by minute with start and end times provided

摘要：数据结构类似SQL> select * from t;B E N----------------- ----------------- --------------------20150106 01:00:02 20150106 01:00:42 A20150106 01:00:02 2015010... 阅读全文

posted @ 2015-06-30 05:51 syksky 阅读(161) 评论(0) 推荐(0) 编辑