Query User Details

Setting ORACLE_SID

The Oracle System ID ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID

Oracle SQL Developer: Can't edit in SQL Worksheet

Problem: In SQL Worksheet you cant edit or use back space. This may happen on newly installed Oracle SQL Developer. Solution: Go to Tools | Preferences | Accelerators and press Load Preset . Then it'll l oad the default preset. Then try again to edit.

How to Check SGA size in Oracle Database

Use below sql statements to check the SGA size of a Oracle Database. sql> SHOW SGA; or sql> SELECT name,value/1024/1024 "SGA (MB)" "FROM v$sga; You can check the Total SGA size from below sql statement. sql> SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga;

Pubudu: Data and Decisions

Search This Blog