querylight.in
QueryLight: Download QueryLight.
http://www.querylight.in/p/download-application.html
QueryLight is a lightweight Oracle database client. Also featured here are tools and specific code snippets developed by owner. QueryLight is Free to download on SourceForge. It does not have any ads nor there would be in future.Leave your feedback / suggestions. Please Report Bugs if any. For Windows Download : QueryLightxxxx.paf.exe. If you do not want Windows exe or you intend to run this on linux dowload JAR file. OR Go to Project HomePage. Subscribe to: Posts (Atom). Subscribe in a reader. Oracle da...
querylight.in
QueryLight: About Me
http://www.querylight.in/p/about-me.html
QueryLight is a lightweight Oracle database client. Also featured here are tools and specific code snippets developed by owner. Technical Lead and Hobbyist Coder. 8 Years of experience in Oracle RDBMS and applications. Currently located in Indiana , USA. I enjoy playing computer games and games on Xbox. I am occasional reader. I spend a lot of time on my laptop and would love to hear from you about my applications or tools or other blog posts. Please leave your relevant comments and questions only. Oracl...
querylight.in
QueryLight: Oracle string quote escape tool for plsql and sql.
http://www.querylight.in/p/oracle.html
QueryLight is a lightweight Oracle database client. Also featured here are tools and specific code snippets developed by owner. Oracle string quote escape tool for plsql and sql. Oracle string quote escape tool : There will be a times when you are writing dynamic sql and that sql has lot of quote constants in where clause or in your select list , escaping these quotes can be quite cumbersome if you don't have the right tool. It's not ours to take. Please leave your relevant comments and questions only.
dioncho.blogspot.com
Dion Cho - Oracle Performance Storyteller: 並列MERGE文章の実行計画の解析
http://dioncho.blogspot.com/2010/12/merge.html
Dion Cho - Oracle Performance Storyteller. Sunday, December 12, 2010. SQL create table t1. 4 level as c1,. 5 level as c2,. 6 rpad('x',100) as c3. 9 connect by level. SQL create table t2. 4 level as c1,. 5 level as c2,. 6 rpad('x', 100) as c3. 9 connect by level. SQL explain plan for. 2 merge /* parallel */ into t1. 3 using (select c1, c2 from t2) t2. 4 on (t1.c1 = t2.c1). 5 when matched then. 6 update set t1.c2 = t1.c2. 7 when not matched then. 8 insert(c1, c2) values(t2.c1, t2.c2). Id Operation Name Rows.
dmitryremizov.wordpress.com
Oracle 12c pluggable and “common” directory recreation issue. | dmitry remizov's weblog
https://dmitryremizov.wordpress.com/2016/09/08/oracle-12c-pluggable-and-common-directory-recreation-issue
Dmitry remizov's weblog. Oracle 12c pluggable and “common” directory recreation issue. Oracle 12c pluggable and “common” directory recreation issue. September 8, 2016. Recently I did a stupid thing. DROP DIRECTORY DATA PUMP DIR; - issues from CDB$ROOT. Before that my PDBs was able to see this standard directory:. SELECT directory name FROM dba directories WHERE directory name='DATA PUMP DIR';. I’ve almost immediate recreate the directory as:. CREATE DIRECTORY DATA PUMP DIR as '/tmp';. SELECT directory na...
hoopercharles.wordpress.com
Blog Article Index/Archive | Charles Hooper's Oracle Notes
https://hoopercharles.wordpress.com/archived-blog-articles
Charles Hooper's Oracle Notes. Miscellaneous Random Oracle Topics: Stop, Think, … Understand. More About: Large Scale Welding Fabrication and Machining. February 20, 2016 (Last Update Date). Lost blog articles are an unfortunate side-effect of the blog environment. Below are quick reference links to older blog articles found on this site. LAG to the Rescue. Create an Auto-Scaling HTML Chart using Only SQL. Everything or Nothing in SQL. Excel Charting the Results of Oracle Analytic Functions. SQL RANK, MA...
iusoltsev.wordpress.com
12c: Automatic Dynamic Statistics | Oracle mechanics
https://iusoltsev.wordpress.com/2015/05/07/12c-automatic-dynamic-statistics
12c: Automatic Dynamic Statistics. 8212; Игорь Усольцев @ 02:50. Указал примечательный документ поддержки, уточняющий границы автоматического применения в версии 12c технологии Dynamic Sampling, реализуемого через рекурсивные запросы типа SELECT /* OPT DYN SAMP */. 8212; Dynamic Sampling Level Is Changed Automatically in 12C (Doc ID 2002108.1). Или того же через хинт DYNAMIC SAMPLING. Но и при default-ном значении OPTIMIZER DYNAMIC SAMPLING, не указанном явно/explicitly в pfile/spfile, к примеру. Возможн...
iusoltsev.wordpress.com
12c: как надёжно отключить Automatic Dynamic Statistics на уровне запроса? | Oracle mechanics
https://iusoltsev.wordpress.com/2015/07/25/12c-how-to-disable-automatic-dynamic-statistics-for-query
12c: как надёжно отключить Automatic Dynamic Statistics на уровне запроса? 8212; Игорь Усольцев @ 00:52. В предыдущей заметке 12c: Automatic Dynamic Statistics. Я сослался на документ поддержки Dynamic Sampling Level Is Changed Automatically in 12C (Doc ID 2002108.1). Рекомендующий в качестве метода отключения ADS. Использовать подсказку на следующем примере:. ADS can be disabled but setting optimizer dynamic sampling to 0 either with a parameter or using a hint. Disable for all tables:. Active Data Guar...
magnusjohanssondba.wordpress.com
ORA-02429 running an application upgrade – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/2014/08/22/ora-02429-running-an-application-upgrade
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. ORA-02429 running an application upgrade. I tested an application upgrade (QA) on one off our applications. When we ran the upgrade script, it stopped with the error ORA-02429: cannot drop index used for enforcement of unique/primary key. We checked the index and it was an invisible index created during a tuning session some time ago. Searching for the answer I came across a BUG:. SCOTT@l204 drop index idx tabtes...
