We can have both Linux and Windows compute instances in the Oracle Cloud. Let’s learn about how to login to both the Linux and Window compute instance/how to access oracle cloud compute instance Linux Compute Instance We first need to make sure, we have the public IP associated with the Compute instance and security list …
How to access oracle cloud compute instance(Linux/Window) Read More »
We often need to find out what all patches are applied to the EBS instance. Now, this varies as per the EBS instance version. We have different queries for R12.1 and R12.2.Let’s find out the Query to check the patch applied in R12/R12.1 and Query to check patch applied in R12.2 Query for R12/R12.1 ad_bugs …
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 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 …
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 »
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 »
