Adam Musch

731 reputation

bio	website
	location
	age
visits	member for	2 years, 1 month
	seen	yesterday
stats	profile views	31

	731 reputation	bio	website		visits	member for	2 years, 1 month
25 badges		location			seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

73 Actions

suggestions reviews revisions comments badges posts accepts all

1d	answered	what's the fastest method to export a table through sql query ? 11g - performance
May 10	comment	NLS_TIMESTAMP_FORMAT changing automatically and randomlly One can also set NLS_TIMESTAMP_FORMAT in an AFTER LOGON trigger; don't forget to check that.
May 10	answered	How to remove all hidden parameters from Oracle Database
Apr 21	awarded	Yearling
Mar 26	comment	Why can't we write ddl statement directly into the PL/SQL block Well, you can also execute DDL through `DBMS_SQL.PARSE`, but very few people do that anymore.
Feb 15	answered	are there significant differences with 500+ million row tables in Oracle?
Feb 15	answered	Updating 700 million rows to same value
Apr 21	awarded	Yearling
Apr 13	comment	How to maintain referential integrity of an object graph when a node is deleted Well, the REVOKE statement is there for a reason, after all.
Apr 12	comment	How to maintain referential integrity of an object graph when a node is deleted Partitioning the table requires both Enterprise Edition and the Partition option; both are pricey. Neither is required to implement such a solution. Further, as row movement between partitions involves an INSERT and a DELETE under the covers, one needs to test the bejeebers out of such an implementation and be aware of the consequences.
Apr 12	comment	Oracle faster overlap check @ypercube: a hex value would a hexadecimal representation of a decimal number; 0x10 would be 16, 0xFF would be 255.
Apr 12	comment	How to maintain referential integrity of an object graph when a node is deleted @onedaywhen: added answer.
Apr 12	answered	How to maintain referential integrity of an object graph when a node is deleted
Apr 11	comment	How to maintain referential integrity of an object graph when a node is deleted @onedaywhen: That's where views come in; users who need guard rails GET only the guard-railed version.
Apr 10	comment	Measuring the relative performance of queries given the assertion that “cost” isn't reliable Logical I/O's is both "db block gets" and "consistent gets". The pithy way to remember to tune them is "High LIO SQL, away"!
Apr 10	comment	What units used in DBA_TABLESPACE_USAGE_METRICS? Undo blocks are always in the default block size for the database. Undo blocks aren't "before images" - they contain records telling Oracle how to undo changes to blocks.
Apr 4	comment	Are there any benefits in certain ordering of columns when defining indexes @ConcernedOfTunbridgeWells: An alternative approach is to use index key compression, and have the less selective (fewer distinct values) columns leading. It helps lead to a smaller index, while still allowing skip-scans to function well.
Mar 30	answered	Need suggestion for placing foreign keys in the databases
Mar 30	comment	How to maintain referential integrity of an object graph when a node is deleted It's very common for such systems to have "soft" deletes - a product is deactivated so it can't be selected for new transactions, but would still exist for historical transactions.
Mar 30	comment	Separate Address Table, Latitude, Longitude Technically, any other system that uses R-tree indexes - like Oracle's spatial/locator options -- can optimize queries similarly.