Zmrss Reader » Ask Tom HOT ARTICLES

« Expand/Collapse

Ask Tom HOT ARTICLES (10 unread)

September 01, 2009
0:00
Code Reviews between Java Developers and DBA
» ‎ Ask Tom HOT ARTICLES

Hi Tom, This is a somewhat 'mature' shop, but we are just now in the process of establishing policies, etc. regarding the DBA role in code reviews (and design reviews) with the Java Developers. It is a given that the DBA's should review all the...
0:00
Rownum quey with sorting
» ‎ Ask Tom HOT ARTICLES

Hi Tom, I have a query which return millions of record,(as a result of inner join). I am not sure whether the client application will be able to handle these many records at once. I want to partition the query result in a few sets, and re...
August 31, 2009
0:00
embedding a variable in a string
» ‎ Ask Tom HOT ARTICLES

After running a proc I wrote I get this error: ORA-01756: quoted string not properly terminated I am writing SQL as a string so that I can embed variables into the the string, like: v_sql := 'insert into... select... etc'; I then execute thi...
August 07, 2009
0:00
What is the meaning of SQL*Net message from client
» ‎ Ask Tom HOT ARTICLES

Can you please help interpreting this output? OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------...
August 06, 2009
0:00
Object relational impedance mismatch
» ‎ Ask Tom HOT ARTICLES

What are your thoughts on the so called "object relational impedance mismatch"? http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch This seems to fuel the mentality that for an object oriented application to work people need to...
0:00
Balancing Instances and schemas
» ‎ Ask Tom HOT ARTICLES

Dear Tom, In your literature I have read "each box deserves its own database", meaning is better to have a single instance running in a box than more. Is it safe to generalize that if I have say 100 schemas, it is better to have a single instan...
0:00
Rolling count of difference
» ‎ Ask Tom HOT ARTICLES

<code>I have a table: create table t ( b date, c varchar2(30) ); with this data in it: insert into t values ( to_date( '01-jan-2004'), 'XXX' ); insert into t values ( to_date( '01-jan-2004'), 'YYY' ); insert into t values ( to_date(...
0:00
PI and CR image of datablocks
» ‎ Ask Tom HOT ARTICLES

Hi Tom, When does Oracle Instance create a Past Image of a datablock and when CR image of datablock in its buffer cache ? Would you please explain it with a small example? Thanks Sukhendu
0:00
internal logic of distinct clause
» ‎ Ask Tom HOT ARTICLES

I have 2 questions for you TOM: 1. ) when a query has a distinct clause on a clomun and the same column is used in the order by clause, will oracle order the data first and eliminate the duplicate or will it eliminate the duplicate records and the...
August 05, 2009
0:00
Multiple production databases in a RAC cluster,
» ‎ Ask Tom HOT ARTICLES

Hello, Our management is inclining towards sharing two production databases on a 3-node RAC cluster. Each node is very powerful in terms of capacity (like memory and CPU). The intention is to have RAC capabilities for both the databases. Each d...

← Ask Tom MOST RECENT ARTICLES Ask Tom MOST POPULAR →

Zmrss Reader » Ask Tom HOT ARTICLES

Feeds

Ask Tom HOT ARTICLES (10 unread)