• 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

Shared Pool in Oracle and Shared pool flush in Oracle database

February 3, 2023 by techgoeasy 2 Comments

shared pool

A shared pool is an important memory structure in Oracle database system global area(SGA) What is Shared Pool in Oracle The shared pool in the Oracle database is the place where Oracle caches the SQL, PL/SQL and dictionary data. Whenever we parse a query, the parsed representation is cached there and it is shared also. Oracle […]

Filed Under: Oracle, Oracle Database Tagged With: Dictionary cache, library cache, shared pool, shared pool flush

How to use sed to remove comments and blank lines

February 2, 2023 by techgoeasy Leave a Comment

As an administrator on the Unix system, we may encounter situations where we must remove the blank lines from many files. Similar is the case comments also, we may need to remove from a lot of files. Doing this using vi or nano editor is going to be lengthy and very tedious. This is also […]

Filed Under: Unix command and scripts

How to recover database using RMAN

February 2, 2023 by techgoeasy Leave a Comment

Recover database is an important part of Oracle database administration. Here in this post,I will try to cover scenario’s on How to recover database using RMAN Case 1: Loss of a datafile We often get the scenario where we lost the data file because of a hard disk crash and we get to restore the […]

Filed Under: Oracle, Oracle Database Tagged With: How to recover database using RMAN

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

  • « Previous Page
  • Page 1
  • …
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • …
  • Page 116
  • 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

  • find segment name from block in oracle
  • How the sql query is executed in Oracle
  • How to do sql query tuning in Oracle
  • How to enable 10053 trace in Oracle
  • How to find the bind variable of the sql id

Copyright © 2023 : TechGoEasy

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