Reputation
13,110
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 23 37
Newest
 Enlightened
Impact
~652k people reached

Aug
28
comment Find who will change a record in oracle DB
@Kiranshell - If you don't have access to create triggers, does that imply that you also don't have access to enable and configure auditing and that you don't have access to the historical redo logs? If you just have privileges to query the data, you can't get privileges to be able to record who is updating rows, and the people that do have those privileges aren't able to help you, you're probably out of luck.
Aug
28
answered Find who will change a record in oracle DB
Aug
28
revised Why not use a table instead of a materialized view?
added 733 characters in body
Aug
28
answered Why not use a table instead of a materialized view?
Aug
28
awarded  Enlightened
Aug
28
awarded  Nice Answer
Aug
27
comment Querying a database efficiently for a huge chunk of data
@Kraken - Updated my answer
Aug
27
revised Querying a database efficiently for a huge chunk of data
added 478 characters in body
Aug
27
comment Querying a database efficiently for a huge chunk of data
@Kraken - What sort of process are you passing the data to? Are you passing the data to some other process in the database? Are you shipping it over the network to an application server? What language/ API are you using?
Aug
27
answered Querying a database efficiently for a huge chunk of data
Aug
27
comment Querying a database efficiently for a huge chunk of data
Based on the presence of rownum, I assume this is an Oracle-specific question.
Aug
27
revised Querying a database efficiently for a huge chunk of data
edited tags
Aug
26
answered Size of an empty database
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - Yes, if you use different hard-coded literals, you'll get multiple entries in v$sql assuming that cursor_sharing is not set to force.
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - Just posted a quick demonstration that there is only one row in v$sqlarea
Aug
25
revised How far should bind variables go in Oracle?
added 2282 characters in body
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - The guideline I'd give to users is that is a value might ever change, it should be a bind variable. If it's a simple hard-coded value that will never change, it should be a literal.
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - If the status will always be 2, every instance of the query will have the same sql_id and will appear once in the cache (barring cases where Oracle has two different plans for the same SQL statement). There won't be any benefit to converting status to a bind variable in that case.
Aug
25
answered How far should bind variables go in Oracle?
Aug
25
answered Estimate a Database Size