Techgoeasy

27 oracle dba scripts for Oracle Database for Administration and Monitoring

We often need to monitor the oracle database session for performance reason, check for locks,get location of datafiles, redo files , get the information about db_links .Here are Top oracle dba scripts for Oracle Database for Administrative and Monitoring purpose Script to find the sid of the session you are logged in as select distinct(sid) …

27 oracle dba scripts for Oracle Database for Administration and Monitoring Read More »

Oracle 23c/23ai Database New Features

Oracle, Oracle Database

Oracle 23c is the latest Release of the Oracle Database. This is also a Long term release. It is also called Oracle 23ai given the focus on AI in it. Oracle has introduced a lot of new features in it. Here are the Top Features Augmenting a new generation of AI models Asking questions naturally …

Oracle 23c/23ai Database New Features Read More »

How FNDFS (Oracle Report Review agent) works in EBS environment

Oracle, Oracle Ebuisness Suite

What is FNDFS Explaining how FNDFS working (1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ (2) The file name and node name are selected from the database.Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes …

How FNDFS (Oracle Report Review agent) works in EBS environment Read More »

How to create tablespace in Oracle

Oracle, Oracle Database, Oracle Sql

We will be discussing Oracle create tablespace statement/oracle create tablespace 11g/12c/19c in detail in this post. I will through light on all the option on create tablespace statement.I would also be discussing ,how to alter the tablespace to read-only, offline the tablespace,how to move tablespace to another location,drop the tablespace. Apart from that, how you …

How to create tablespace in Oracle Read More »

How To Retrieve Instance Metadata from Server

Oracle, Oracle cloud

We can retrieve Instance Metadata like OCID, Display Name, Region, Availability Domain, Fault domain, Compartment OCID, Instance shape, Subnet CIDR, etc in three ways. Using oci-metadata #oci-metadata Instance details: Display Name: tech Region: uk-london-1 Canonical Region Name: us-ashburn-1 Availability Domain: DSdu:US-ASHBURN-1-AD-3 Fault domain: FAULT-DOMAIN-1 OCID: ocid1.instance.oc1.us-ashburn-1.abwgiljrfu6w22gihsxj4h6m6ybabv3mb23edmqhj4kamvv2sdodk7voplfq Compartment OCID: ocid1.compartment.oc1..aaaaaaaamlbsubwajqyvzyrqas6e6sbl3iqp55u6yloyxmg4muaks5xvxbuq Instance shape: VM.Standard2.1 Image ID: ocid1.image.oc1.uk-london-1.aaaaaaaavrftjg3fa2uw5ndqin3tjme3jc4vpxnsysoxetlswsr6aqlfwurq …

How To Retrieve Instance Metadata from Server Read More »

How to generate tkprof in EBS in 19c

Oracle, Oracle Ebuisness Suite

EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that the apps is …

How to generate tkprof in EBS in 19c Read More »