(Hemant K Chitale) 11g allows definition of tracing by SQL_ID as well.
Tag: Oracle
Finding Columns
(Jeff Smith) One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010.
Row transposition
(connormcdonald) Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:
Trace Files — 3 : Tracing for specific SQLs
(Hemant K Chitale) 11g allows definition of tracing by SQL_ID as well.
Use Case of Auto Re-Execute Functionality in ADF BC
(Andrejus Baranovskis) There are use cases, when data in DB is changed by background processes and we would like to display to the user latest data available. Very common implementation for this use case is to re-execute ADF iterator and VO each time when Task Flow or UI screen is accessed.
Index Advanced Compression: Multi-Column Index Part I (There There)
(Richard Foote) I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with 12.1.0.2, that not only makes compressing indexes a much easier exercise but also enables indexes to be compresse
ORA-01440
(Andrew Reid) I was asked to run some SQL today and it generated an ORA-01440. I did not remember having seen this error before so I decided to check it out in an Oracle 11.2 database. First I created a table and added a row of data to it:
Use Case of Auto Re-Execute Functionality in ADF BC
(Andrejus Baranovskis) There are use cases, when data in DB is changed by background processes and we would like to display to the user latest data available. Very common implementation for this use case is to re-execute ADF iterator and VO each time when Task Flow or UI screen is accessed.
Index Advanced Compression: Multi-Column Index Part I (There There)
(Richard Foote) I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with 12.1.0.2, that not only makes compressing indexes a much easier exercise but also enables indexes to be compresse
ORA-01440
(Andrew Reid) I was asked to run some SQL today and it generated an ORA-01440. I did not remember having seen this error before so I decided to check it out in an Oracle 11.2 database. First I created a table and added a row of data to it: