888 reputation
613
bio website
location Orem, UT
age
visits member for 2 years, 4 months
seen May 14 at 13:45
stats profile views 43

Nothing useful here


May
14
awarded  Caucus
Jan
5
awarded  Yearling
Dec
14
awarded  Revival
Dec
10
comment How do you document your databases?
@CarolBakerWest The question wasn't so much about file formats, but rather "What content goes into such a thing"
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@VincentMalgrat Yes
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@ik_zelf: No FKs or other referential constraints to any other tables
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@Phil: here were previously a large number of rows in the table, but these were removed by a "TRUNCATE TABLE" (which should have reset the HWM, unless I'm mistaken).
Sep
24
asked Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
Aug
27
comment Obtaining gratis copy of the SQL specification?
While I appreciate the recommendation, and I do love to read Date & Darwen, this book isn't really relevant to the question; it's not available gratis, it doesn't cover the entire specification, and what it does cover has been superseded for more than a decade.
Jun
20
awarded  Taxonomist
Jun
11
answered SQL database backups methods-tools-procedures
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jan
24
comment What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
@Phil "Timed OS Statistics" is off, but "Timed Statistics" is on; would that explain it?
Jan
24
comment What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
@LeighRiffel The column simply does not exist.
Jan
18
asked What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
Jan
5
awarded  Yearling
Nov
28
comment Role problem of PostgreSQL
ach! Ya beat me! :D
Nov
28
answered Role problem of PostgreSQL
Aug
24
comment What makes an Oracle Applications DBA different from an Oracle DBA?
That's correct - you need to be both a skilled Oracle DBA, as well as have a good knowledge of the particulars of their ERP. You can probably "get there" if you are an Apps DBA, but it's not trivial by any means.