Interesting procedure which can expand your query to a more complicated structure but closer to the CBO’s one, unfortunately not the same:)
Continue reading “Expand SQL queries using dbms_utility.expand_sql_text”
Today I’ll show you a small simple function to convert values from LONG to CLOB in SQL queries.
I’ve seen many articles where authors create their convert fuctions or create a table and insert the LONG value via INSERT INTO SELECT statement.
Oracle has also made its own, so we don’t need to create our own:)
Continue reading “Convert values from LONG to CLOB using dbms_metadata_util.long2clob in SQL queries”
After migration from 220.127.116.11. to 18.104.22.168 I discovered an interesting thing. I’ve read a lot about the new features and I was particularly interested in the Scalar Subquery Unnesting transformation. After a few tests, however, I found something that I hadn’t really expected 🙂
Continue reading “Oracle 12c: Scalar Subquery Unnesting and ROWNUM”
Probably most of you have access to AWR report or have your own scripts to find TOP SQL statements in your database.
But if you don’t and you don’t have access to dbms_workload_repository and you don’t have permission to run awrrpt.sql script and you don’t like Enterprise Manager (yuck) or you just want to add some information to existing AWR report (e.g. plan_hash_value ), you should read this article 🙂
Continue reading “AWR – SQL Statistics”