In my previous post, I discussed with you how to installing SQLcl 18.1.1 on your machine or system. Once you have deployed this funny tool on your machine, next you’re necessary to discover some new feature from there. About “SET SQLFORMAT” is a very interesting function. Here’s the operation steps connecting to my Oracle Database test server via SQLcl 18.1.1,

Continue reading


Installing SQLcl 18.1.1

A the end of last month I posted 2 questions of “how to generate some big test tables and rapidly export their SQL data” on Oracle Ask TOM. Apart from Connor McDonald (a significant member of AskTOM teams) answered my first question on my post first time (afterwards I replied to Connor, I also had submitted this issue with the topic – “test table *test1* has generated and how to export pure data via *CSV* rapidly”) at the same time another reviewer Rajeshwaran Jeyabal from American Samoa (also known as Eastern Samoa) replied my second question as well. His nice review attracted my attention and he introduced 2 options to generate CSV output. One method is using Oracle 12.2 and another is SQLcl. I never heard of SQLcl than before. Just for curiosity’s sake so I wanna try to use the interesting and funny tool. It’s also the reason why I write this post.

Continue reading

Unified and standard writing format on my post

These days I re-read my a number of posts on WordPress and occasionally discover that there is several different writing format on those posts. At least I haven’t become aware of  this significance of standard writing format on my post heretofore (up to now). Therefore I must draw up some basic regulations to come into being a unified and standard writing format.

After considering again and again, I make a decision that I will adopt following 7 points as a unified and standard writing format from now on (before this post I’ve also proofread the content and corrected some mistakes of all of my previous posts).

Continue reading

some feelings and experiences of participating in the event which has been organized by “OCMU”

Yesterday afternoon I was honored to take part in the event which has been organized by OCMU. The entire meeting had chiefly total 3 themes and its agenda was as follows:

  • Experts of OCM had shared 2 cases (they’re all come from Production Environment) with others
    • 14:00 – 14:50 Haihua Mao, Rewriting thirteen scalar subquery via left join clause – making the elapsed time of a little complex SQL statement be reduce to 2 seconds from 200 seconds
    • 15:00 – 15:50 Pengju Lan, A weird trouble-shooting process of connecting to oracle database server via client
  • 15:50 – 16:00 Pengju Lan, the experiences of my Oracle DBA‘s professional career
  • 16:10 – 17:00 Shengwen Hou, Leading everyone to read and practice the New Features of the official documentation of Oracle 18c and MOS (My Oracle Support)

Continue reading

Some approach about saving the value of min(sample_time) or max(sample_time) from “ASH” to a variable

Oracle DBA, exactly, operating post could be divided into “Devs DBA” and “Ops DBA”. Nevertheless, as far as I know that’s some discussing ideas 3 years ago at least. Currently there is a very common parlance on IT industry. It highly suggests that it should combine “Devs DBA” and “Ops DBA” to become “DevOps DBA” (It means that “Devs + Ops”).

The following are a couple of links which come from Wikipedia. Continue reading

Switching to use oracle on multiple versions – 2

You who have seen the content of my blog regularly maybe notice that I have published an original article about Switching to use oracle on multiple versions a few days ago last month. Recently I think that some details which is important hasn’t been mentioned, hence I’ll explain it clearly on this post.

By the way, I have upgraded to Windows 10 from Windows 7 previous on my laptop during the Chinese New Year (02/15/2018 – 02/21/2018). And then I have installed 3 versions of oracle – (it’s different than 4 versions last time). Continue reading