Reputation
15,393
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 28 42
Newest
 Nice Answer
Impact
~1.0m people reached

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.
Dec
10
comment Internal query on CDEF$ and CON$ very CPU bound
Exactly what version of Oracle are you using? I know you said 10.2 but what patchlevel? Have you gathered statistics on dictionary objects? Are those statistics accurate?
Nov
25
revised Normalization: 'zip code' as a primary key
added 206 characters in body
Nov
25
comment Normalization: 'zip code' as a primary key
At least in the United States, ZIP codes do change pretty regularly. And the ZIP code for an address will change somewhat commonly as subdivisions are built out. But more importantly, ZIP codes cross city, county, and state lines. So if you wanted to have something like this, you'd need zip_code, city, and state to be the composite primary key of your mapping table and have those three columns in the address table as well. That might still make sense for validation purposes, but ZIP code is not part of the geography hierarchy. oseda.missouri.edu/jgb/ZIP.resources.html
Nov
25
answered Normalization: 'zip code' as a primary key
Nov
20
answered Oracle Logical IO / Consistent Reads inconsistent?
Nov
19
answered Oracle 11g INDEX_SS Hint
Nov
18
answered Combine 2 SQL Queries
Nov
17
answered Oracle 10 column name resolution