XServer on Windows 10

Recently upgrade to 64 bits windows 10.

Tried Cywin startxwin but not working, which was working on my 32bits windows7.

Luckily, MobaXterm still works well.

The other software in my mind is XMing. The installation is smooth. One thing to note is that I need to choose "No access control" as shown below (after click the XLaunch), which I guess this is the same effect to command "xhost + &"  of startxwin.

For MobaXterm, for those X11 forwarding is disabled on the SSH server end, we'll  need to export DISPLAY explicitly, After that, it works perfect.

investigating Delphix job timeout issue with inner tools

Recently we have Delphix jobs can't  complete within scheduled windows. even I separate them in more windows. 

The above three pages are handy for investigation. They tell me which databases are using the most bandwidth. From them drill down further, I identified problematic application/jobs, which should not be there. I even found  a problem in production, which does full table scan to a moderate size table. This is make the saying true that fast HW may help to hide the performance problem. 

As we use NFS to present storage to database, the network bandwidth becomes expensive for our 1GbE network interface , running on VMWare. 

From this case, we learn that for best practice, the recommend network is 10GbE. 

Best practices to improve network throughput include:

• Use 10 Gigabit Ethernet (10GbE)

• Use a dedicated storage network

And it is worth to read the Delphix performance tuning document again. 

Delphix cron

Delphix cron used by replication job is Quartz CronTrigger scheduler


And below is its format.

Format

A cron expression is a string comprised of 6 or 7 fields separated by white space. Fields can contain any of the allowed values, along with various combinations of the allowed special characters for that field. The fields are as follows as I copy it from the site. But I think there error with 5th & 6th position , which should swap the "Day of week" and "Year"

Field Name	Mandatory	Allowed Values	Allowed Special Characters
Seconds	YES	0-59	, - * /
Minutes	YES	0-59	, - * /
Hours	YES	0-23	, - * /
Day of month	YES	1-31	, - * ? / L W
Month	YES	1-12 or JAN-DEC	, - * /
Day of week	YES	1-7 or SUN-SAT	, - * ? / L #
Year	NO	empty, 1970-2099	, - * /

unto_retention=0

It is auto tuned by Oracle, if it is the retention is set to 0.

https://community.oracle.com/thread/833573?tstart=0