• 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

Oracle Database Recovery various cases and solution

February 6, 2023 by techgoeasy 2 Comments

Oracle Database administrator has to prepare for the possibility of hardware, software, network, process, or system failure. If such a failure affects the operation of a database system, he must usually recover the database and return to normal operation as quickly as possible.So database recovery is very important for the organization Oracle Database Recovery should […]

Filed Under: Oracle, Oracle Database Tagged With: Database Recovery

Parallel Concurrent Processing

February 3, 2023 by techgoeasy Leave a Comment

Parallel concurrent processing

Why Concurrent Processing? what is the Business Need for Concurrent Processing We all use Concurrent Manager in Ebuiness Suite. I am reiterating the uses of it here 1) It Facilitates User Interaction2) Long running jobs are performed in the background to avoid interference with interactive operations3) Improve the efficiency of Applications4) All background processing is […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: Parallel Concurrent Processing, PCP

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

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • …
  • Page 115
  • 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 find file based on size in linux
  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database

Copyright © 2023 : TechGoEasy

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