11,403 reputation
11832
bio website ddbcinc.com
location Rochester Hills, MI
age 37
visits member for 3 years, 3 months
seen 15 hours ago
Oracle ACE

Jan
29
revised Change all datatypes in a table
added 90 characters in body
Jan
29
awarded  oracle-10g
Jan
27
comment Change all datatypes in a table
@Phil - If there can be xx char columns, I'd prefer to use the char_used column. Updated my answer.
Jan
27
revised Change all datatypes in a table
Add the `char_used` predicate
Jan
27
answered Change all datatypes in a table
Jan
24
answered Is it important to design the database the right way from the beginning?
Jan
24
answered Return a fully dynamic table from an Oracle function
Jan
22
answered Database Configuration In DB2 and Oracle
Jan
20
answered How to run procedure in Oracle SQL developer
Jan
19
awarded  Yearling
Jan
13
comment In Oracle, why would an OR / LIKE(A,B) take far longer than running the same query for each condition separately and unioning
What are the query plans? Are the queries actually using literals 1 and 3? Or are the queries actually using bind variables. Assuming the query plans are different, my first guess would be that statistics on some object were not representative but there are any number of other possibilities.
Jan
9
comment Making data from one schema available to another schema
@polle - That completely changes the question that you're asking. I've rewritten the question based on the new information, please verify that our new understanding is correct.
Jan
9
revised Making data from one schema available to another schema
deleted 170 characters in body; edited title
Jan
9
answered Making data from one schema available to another schema
Jan
6
comment How Oracle DB maintains client identification
What "client identification" are you referring to?
Jan
1
comment Unclear oracle problem with getting response of query
How many rows does the query return? In PL/SQL Developer, are you measuring the time required to fetch the first row? Or to fetch the last row? Is your application logging something when the first row is returned? Or when the last row is returned? Are you certain that the query you are running in PL/SQL Developer has the same sql_id, that it uses bind variables in the same way that your application does, etc.?
Dec
17
answered saving all action in database
Dec
16
answered Maximum dataset size for a well-performing SQL Server 2012?
Dec
10
comment Internal query on CDEF$ and CON$ very CPU bound
OK, so applying patchsets is not allowed then? Have you gathered statistics on dictionary objects? Are those statistics accurate?
Dec
10
comment Internal query on CDEF$ and CON$ very CPU bound
@eppesuig - Is there a reason that you are running a base release rather than applying the most recent patchset? Most folks are well down the path of upgrading 10.2 databases to 11.2 if they're not already there-- running the terminal 10.2 patchset would be a good idea for a variety of reasons.