A Database Limits

• Datatype Limits 
• Physical Database Limits 
• Logical Database Limits 
• Process and Runtime Limits

Coskan Gundogar = Plan stability through Upgrade to 11G-Why is my plan changed?-Auto Adjusted Dynamic Sampling

Plan stability through Upgrade to 11G-Why is my plan changed?-Auto Adjusted Dynamic Sampling

SQL Patch: Another way to change the plan without changing the code

SQL Patch: Another way to change the plan without changing the code

Indexes: Structure, Splits and Free Space Management Internals from Christian Antognini (OOW14)

Indexes: Structure, Splits and Free Space Management Internals from Christian Antognini

Adaptive Query Optimization from Christian Antognini (OOW14)

Adaptive Query Optimization from Christian Antognini

Everything That Is Really Useful in Oracle Database 12c for Application Developers (OOW 2014, CON 2394

Everything That Is Really Useful in Oracle Database 12c for Application Developers (OOW 2014, CON 2394) from Lucas Jellema

PERL = DBI::db = disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting)

1. $dbh = DBI->connect("DBI:ODBC:$dsn",$user,$password)
2. my $statement=$dbh->prepare(q{select count(*) Total from tab;});
3. $statement->execute() or  die "executing: ", $dbh->errstr;
4. my $rowq = $statement->fetchrow_arrayref->[0];
5.  
6. $dbh->disconnect;

DBI::db=HASH(0x1d56afc)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnectin
g) at chb.pl line 6.


to avoid this you should add  $statement->finish();

1. $dbh = DBI->connect("DBI:ODBC:$dsn",$user,$password)
2. my $statement=$dbh->prepare(q{select count(*) Total from tab;});
3. $statement->execute() or  die "executing: ", $dbh->errstr;
4. my $rowq = $statement->fetchrow_arrayref->[0];
5.  
6. $statement->finish();
7. $dbh->disconnect;