Ansible example of running a sql script from a shell script on target servers. 1) First setup a central Ansible control host server (if you don’t have one already). Pick a server which has a reasonably recent version of Linux OS. No need to be a dedicated server, and no need to be a physical […]
Read More Ansible Simple SQL Shell Script SetupIn Jenkins > build > Execute system Groovy script > Groovy commandPaste code like the below in the “Groovy Script” box: And for enabling Jenkins jobs would be:
Read More Groovy Script to Enable or Disable Jenkins JobsPython script to create a Confluence page, plus child pages, based on input .txt files in Confluence markup language. In my case called from Jenkins with a Jenkins parameter (p_test_description) used to name the Confluence page. Based on https://stackoverflow.com/questions/33168060/how-can-i-create-a-new-page-to-confluence-with-python
Read More Python create Confluence PageFor Jenkins running on Microsoft Windows, to run a sqlplus .sql file, can specify any of these in the Build Command: 1) PowerShell 2) Execute Windows Batch Command 3) Execute shell Or to run some sqlplus statements directly without using a separate .sql file: 4) PowerShell 5) Execute shell
Read More Call Sqlplus from JenkinsIdeally developers will set module and action to allow for easy debugging and performance monitoring in v$session, v$active_session_history, dba_hist_sqlstat, OEM screens, etc. If not, a logon trigger can be used to set these. Below does this for any tomcat sessions which still have module set to the default generic value. Pattern matching is used for […]
Read More Logon Trigger set ModuleThe broadcast parallel query distribution method can be non-optimal. Use hash distribution instead with:
Read More pq_distribute hash hash Fast Parallel OracleThese two are functionally identical: 1) Old style (+) syntax: 2) Newer ANSI join syntax:
Read More Outer Join (+) and ANSI SyntaxSimple logger.write alternative to dbms_output.put_line. Call with: logger.write ( ‘hello world!’ ) ;or even just: logger.write ; It does the dbms_output.put_line but also writes asynchronously to a log_table, and gives info on calling line number and procedure name.
Read More Logger alternative to dbms_output Oracle Log4j