JD Edwards CNC

 Oracle has renamed the tools release naming convention and new release 22 was released recently. Below are some of the highlights Enhanced Browser Support for Grid Import and Export   This quick tour describes the functionality of importing and exporting EnterpriseOne grid data on all JD Edwards supported browsers   Rich Formatting of Orchestration and Notification Messages   Rich formatting carries information beyond the words and numbers in the message. With rich formatting, not only are your messages accurate and timely, they are also easily understood by their recipients. They communicate your company's brand to your customers and partners. This quick tour shows how   easy it is to create well-formatted messages from the intuitive user interface within Orchestrator Studio. Please refer below link for more information on this release: https://docs.oracle.com/cd/E84502_01/learnjde/automate-optimize-transform.html#april-2022      

  SQL Script to find sessions consuming lot of CPU in the DB col program form a30 heading "Program" col CPUMins form 99990 heading "CPU in Mins" select rownum as rank, a.* from ( SELECT v.sid, program, v.value / (100 * 60) CPUMins FROM v$statname s , v$sesstat v, v$session sess WHERE s.name = 'CPU used by this session' and sess.sid = v.sid and v.statistic#=s.statistic# and v.value>0 ORDER BY v.value DESC) a where rownum < 11;

  OCI announced their Bastion service which is great addon! Now you don’t need that server provisioned anymore, or you don’t need a public subnet. You have possibility to use either managed session or port forwarding session to connect to servers. Managed sessions requires Agent enabled on the compute and ssh port forwarding requires IP on your subnet where you’re connecting to and port. OCI documentation says on new compute instances Agent should be enabled by default but you’ll see further down that I had to enable the agent. How it works? In short everything is controlled through OCI and you can manage who can do what via normal IAM policies. What you’ll need first is an Bastion “resource”. Resource defines name, VCN and subnet (where you’re connecting to) and who can login from which IP addresses to Bastion.    After you have Bastion created you need to create a session. If you’re using managed SSH session then you need to define SSH key (for the session!), usern...

  Use below query to get the size of a database. col "Database Size" format a20 col "Free space" format a20 col "Used space" format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size" , round(sum(used.bytes) / 1024 / 1024 / 1024 ) - round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space" , round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space" from (select bytes from v$datafile union all select bytes from v$tempfile union all select bytes from v$log) used , (select sum(bytes) as p from dba_free_space) free group by free.p / Database Size Used space Free space -------------------- -------------------- -------------------- 8 GB 5 GB 3 GB  To Check the database size physical consume on disk. select sum(bytes)/1024/1024/1024 size_in_gb from dba_data_files;   SIZE_IN_GB ---------- 32.1853638   Check the total space used by the data. select sum(bytes)/1024/10...

  Scheduling tasks on Linux with cron Cron is a daemon used to execute scheduled commands automatically. Learning how to use cron required some reading and experimenting, but soon I was using cron to shut down our email server, back up the data in a compressed tar file, then restart the email service at 3AM. The commands for a cron job are stored in the crontab file on a Linux system, which is usually found in /etc/crontab. Display the contents of your crontab file with   $ crontab -l . Edit the crontab file with   $ crontab -e . Some systems default to the   Vi editor   for cron editing. You can override this setting using   environment variables : $ EDITOR = nano crontab -e This allows you to use the   nano editor   to edit your personal crontab (if you don't have one yet, one is created automatically for you). All crontab commands have parameters denoted by an asterisk until you insert an integer value. The first represents minutes, then hours...