Release Number Format To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release 10.1.0.2.3”. 10 – Major Database Release Number The first digit is the most general identifier. It represents a…
Identifing Linux disks
Identify scsi disk paths – Mapping Devices for disk in ‘/dev/sd*[a-z]’; do printf “%s %s\n” “$(basename $disk)” “$(scsi_id -p 0x83 -gs /block/$(basename $disk))” done
Listing tables in DB
User tables select distinct owner from dba_objects; If you logged in as Normal User without DBA permission you may uses the following command to see your own schema’s all tables and views. select * from tab; it will show all…