Search Results

if you changed your nls_date_language variable would you also change the amount of padding? Yes, you would. http://sqlfiddle.com/#!4/007bd/49

Hmmm, well that's unlike any fact table I've ever seen or used. This sort of complex line-by-line processing is best done during data load, and these relationships probably ought to be embedded in a …

I suspect that the query optimiser is applying a transformation to your first query that eliminates product_id from the inline view, then merging the inline view into the main query to that it execute …

You need to shrink the data files, which can be tricky. However, possibly the easier method to describe and implement is to create a new tablespace of approximately the right size, use ALTER TABLE to …

WEST_EUROPEAN would seem to be the obvious choice, but there is no default that lets you avoid setting it on an individual language basis.

Log file sync occurs when a commit is made and the redo buffer needs to be flushed to disk. The session has to wait for that to happen. An increase in the number of log file syncs generally means tha …

The best check for memory allocations is the buffer advisories. These estimate the impact on caching effectiveness of modifying the cache sizes, so you know whether you have the sizes of the PGA and S …

You just need to start by collecting data. There are a few different valid ways of judging the size of the database -- number of rows in each table, size of table and index extents, size of data file …

If your DBA's won't allow you to even explore the benefits in a proof of concept, time to move companies. External tables go back to version 10.1 at least, so they're not cutting edge technology. The …

Query the DBA_EXTENTS view to see what objects are present towards the end of the data files. It is possible that they are not system objects, or are system objects which can be safely modified so tha …

Typically I think that systems would select the ora_rowscn value when they read the data, and when they write it back they would specify that value as part of the update statement. If no rows are upda …

The performance benefits of partition pruning depend on the proportion of rows being selected from the table and the efficiency with which the rows can be isolated to their own partition(s). If you a …

I wonder if finding the new value might be better with: update z_test_one a set a.bop = (select t.bop from z_test_one t where t.col_id = a.col_id orde …