Virtual Private Database (VPD) with Oracle Apps

Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) is an Oracle database security technology, enabling row level access control. With VPD we are able to control users access to data related to them only and preventing from them to access data they are not authorized…

|

Unix Command’s for DBA’s

Unix Command’s for DBA’s Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command lists all files and directories in the specified directory. If no location is defined it acts on the current directory: root> ls root> ls /u01 root> ls -al The “-a” flag lists hidden “.” files….

How Recovery Works ?

Normally recovery happens as follows: In the controlfile is recorded the current log sequence number the database is working with, and – I think_- the current scn. If one of the datafiles has an older seq# or scn in its header, that file must first be recovered up to the current scn before it can…

Oracle DBA Checklist

Oracle DBA Checklist Version 1.7 Generic This document is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. For a copy of the GNU General Public License write to…