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 […]
putty key format too new
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 […]
How to export/import Putty Sessions
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 […]
Shared Pool in Oracle and Shared pool flush in Oracle database
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 […]
How to convert private key to ppk( Putty Format)
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 […]
27 oracle dba scripts for Oracle Database for Administration and Monitoring
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) […]