12,246 reputation
12035
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 9 months
seen 8 hours ago
Oracle ACE

Jul
16
answered Dynamic permissions
Jul
11
comment Oracle average active sessions high threshold
@toddlermenot - Sure, if your sessions are mostly waiting on I/O, you can probably tolerate a larger number of average active sessions without adding wait time due to scheduler contention. But you still have, say, 7 sessions simultaneously competing for I/O requests to be serviced which tends to impact the throughput available to each session.
Jul
11
answered Oracle average active sessions high threshold
Jun
25
revised Row Level security or Multiple Tables
added 1361 characters in body
Jun
24
revised Block user access to certain tables
Since you link to the MySQL documentation, I've added the MySQL tag. Different databases will have different features
Jun
24
revised Row Level security or Multiple Tables
edited body
Jun
24
answered Row Level security or Multiple Tables
Jun
4
answered Oracle structural synchronization
May
27
answered How to reuse code in Oracle Script?
May
27
answered Invalid create index syntax
May
22
answered Alternatives for Dblink in oracle?
May
22
comment Using EXECUTE IMMEDIATE inside PL\SQL Block
Any DDL statement causes an implicit commit. Not every ALTER statement, however, is DDL so not every ALTER statement does an implicit commit. For example, ALTER SESSION SET nls_date_format = ... is an ALTER statement that is not DDL and that does not implicitly commit.
May
21
answered Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client
May
21
comment Oracle: separate column histograms for partitions
dba_tab_histograms (or all_tab_histograms) will have the table-level histograms. It sounds like you're saying those are correct. dba_part_histograms will have the partition-level histograms. Are those values accurate?
May
20
comment Oracle using index on partitioned table when full scan would have been better
@wrschneider99 - What have you set your default granularity to? Are you gathering partition-level statistics?
May
20
answered Oracle using index on partitioned table when full scan would have been better
May
2
answered Can somebody help me understanding the difference between view,materialized view and snapshot?
Apr
30
comment Problem with a trigger (Oracle 11gR2)
More fundamentally, even if you get your syntax errors resolved, a row level trigger on fin_transaction cannot generally query the fin_transaction table. You're going to get a mutating table exception at runtime. That strongly implies that you need to rethink your approach to whatever problem you're actually having.
Apr
25
comment Parking Lot table for employees
@MaxVernon - Ahh, I think I see. I was too dense last night to follow you alternate interpretation.
Apr
25
comment Parking Lot table for employees
@MaxVernon - That's why I was thinking initially that a 100 space parking lot would involve 100 rows in the ParkingSpace table. If the text of the assignment is exactly what was entered here and there is no additional context a table with 20 rows each with 5 columns does not make sense for a parking lot with 100 spaces.