• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to check Stale statistics

January 31, 2023 by techgoeasy 8 Comments

Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: Parameter setting required to Track the table changes […]

Filed Under: Oracle, Oracle Database Tagged With: How to check Stale statistics

Java web start(JWS) in R12

January 29, 2023 by techgoeasy Leave a Comment

In this post, we will be discussing Java web start implementation in R12/R12.1 and R12.2 versions of EBS. we will see why it is important to implement it What is Java Web start? Java Web Start provides a browser-independent architecture for deploying Java technology-based applications to the client desktop. With Java Web Start, users can […]

Filed Under: Oracle, Oracle Ebuisness Suite

How to delete the archive logs in Oracle

January 29, 2023 by techgoeasy Leave a Comment

Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands to […]

Filed Under: Oracle, Oracle Database

How to generate sql monitor report in Oracle

January 25, 2023 by techgoeasy Leave a Comment

We often come across a situation where a sql statement is giving issues. SQL monitor report is a very useful tool to analyze the various operation done by the sql, wait events, bind variables, and memory details. The below statement can be used to monitor any active sql or done sql in the database SET […]

Filed Under: Oracle, Oracle Database

How to find the long running (longops session) in Oracle

January 25, 2023 by techgoeasy Leave a Comment

Many operations take time in the Database like full table scan, backup, full index scan, and joins. We can estimate the % completion or monitor the session using the v$session_longops view in Oracle. This is a very useful view and provides quite an accurate estimate. How to find the %completion for the long operation for […]

Filed Under: Oracle, Oracle Database

How to find concurrent request id from Sid or spid

January 24, 2023 by techgoeasy Leave a Comment

We often come across a situation in EBS Database, where we want to know the Concurrent request id from the given SID or SPID. Here are some queries which can be helpful in this situation How to find the concurrent request id from Sid Non-RAC set lines 2000select a.request_id ,a.os_process_id,b.sid from apps.fnd_concurrent_requests a,v$session b whereb.audsid(+)= […]

Filed Under: Oracle, Oracle Ebuisness Suite

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 113
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us