813 reputation
618
bio website
location Atlanta, GA
age 30
visits member for 2 years, 4 months
seen yesterday

Oracle DBA

Creative Director Highlands Church

Some pictures I've done


Oct
14
awarded  Notable Question
Sep
24
awarded  Autobiographer
Jul
11
awarded  Yearling
Jul
2
awarded  Curious
Jun
26
awarded  Popular Question
Jun
5
comment Why can't I drop this Oracle datafile - even though it seems empty?
Definitely cannot drop the tablespace - there's tons of data in other data files for the same table
Jun
5
comment Why can't I drop this Oracle datafile - even though it seems empty?
Can you elaborate on why I need to do that?
Jun
5
asked Why can't I drop this Oracle datafile - even though it seems empty?
Mar
12
comment Choosing a database for big data
What kind of queries are you going to be asking it? Analytics, primary key lookups, etc
Mar
12
comment Dynamically change schema to accommodate custom fields!
EAV is a bad thing when you have better choices, it doesn't sound like you do here.
Mar
12
comment Changes access method for non-correlated subquery
Nope, I tried. Because you still have to SELECT to get the value out and the moment its a SELECT there, it seems to lose the index.
Mar
12
comment Changes access method for non-correlated subquery
Hmm I'll see if put together more of an example.
Mar
12
comment Changes access method for non-correlated subquery
Nope, same issue.
Mar
12
comment Changes access method for non-correlated subquery
Hmm i feel like I tried that, but let me test
Mar
11
revised Changes access method for non-correlated subquery
deleted 9 characters in body
Mar
11
revised Changes access method for non-correlated subquery
deleted 9 characters in body
Mar
11
asked Changes access method for non-correlated subquery
Jan
23
awarded  Notable Question
Jan
9
comment Two different databases on the same RAC cluster
No, they don't share diskgroups.
Jan
9
asked Two different databases on the same RAC cluster