• 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

Query to check languages installed in oracle apps

July 6, 2022 by techgoeasy Leave a Comment

We can have different languages installed in Oracle apps. Here is the Query to check languages installed in oracle apps select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’); The Installed_Flag has 3 values I- InstalledB- BaseD- Disabled Example sqlplus apps/<apps pass>select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’);LANG_____USDFR Important Points The above query […]

Filed Under: Oracle, Oracle Ebuisness Suite

putty key format too new

July 3, 2022 by techgoeasy Leave a Comment

We will be looking at one of the common errors face”putty key format too new” while using the putty tool Problem Many times, we may get the below error while connecting using putty putty key format too new This happens as the Putty version used by the user is older than the version of the […]

Filed Under: Oracle

How to export/import Putty Sessions

July 3, 2022 by techgoeasy Leave a Comment

We may need to export/import Putty sessions when we are moving to another laptop or system. How to export Putty Sessions Here are the simple steps Step 1: Launch RunStep 2: Type regeditStep 3: Navigate to,HKEY_CURRENT_USER\Software\SimonTathamStep 4: Right-click on ‘SimonTatham’ key (directory icon), select Export Give the file a name (say) putty.reg and save it […]

Filed Under: Oracle

Shared Pool in Oracle and Shared pool flush in Oracle database

July 3, 2022 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 convert private key to ppk( Putty Format)

July 2, 2022 by techgoeasy 2 Comments

Many times, you get the private key from the cloud provider to connect to the Virtual machine. Generally, the keys will be in OpenSSH format. If you directly try to use that key with Putty to connect to the VM machine, you will get a failure. we need to convert the private key into ppk […]

Filed Under: Oracle

27 oracle dba scripts for Oracle Database for Administration and Monitoring

July 2, 2022 by techgoeasy 2 Comments

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) […]

Filed Under: Oracle, Oracle Database Tagged With: Database Useful scripts, Top useful scripts for Monitoring Oracle Database

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

  • srvctl commands
  • how to check db size in oracle
  • How to access oracle cloud compute instance(Linux/Window)
  • size of schema in oracle
  • Pagination in Oracle

Copyright © 2022 : TechGoEasy

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