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…
HOW TO HIRE (OR BE HIRED AS) AN ORACLE DBA Over the last year I have interviewed several dozen candidates for Oracle related positions. The positions ranged from entry level developer to senior level DBA. Many of the interviews were for DBA level positions. In this period I learned that it is very difficult to…
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….
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…
A Day in the Life of an Enterprise DBA With systems-management tools such as Oracle Enterprise Manager, DBA s can manage the enterprise from home. Sit in on a day with OEM. Thanks for coming over to the office. We’ll go through a typical day of database administration. Today’s to-do list covers a variety of…
Top Five Cool Features of Oracle9i 1 Flashback Query Ever wanted to run a query against your data as it appeared last month? You can, and much more, using Oracle9i Flashback Query. 2 Access External Files No more work-arounds for accessing data not in your database. Now you can query data that’s kept in files…
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…
This are the Responsibilities for DBA. Top 99 Responsibilities of a DBA Database Architecture Duties 1. Planning for the database’s future storage requirements 2. Defining database availability and fault management architecture 3. Defining and creating environments for development and new release installation 4. Creating physical database storage structures after developers have designed an application 5….