James Reid

7 Flips | 2 Magazines | 1 Following | 15 Followers | @JamesReid66ir | Keep up with James Reid on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “James Reid”

LOGICAL_READS_PER_SESSION

One of the resources you can limit in a profile is called <i>logical_reads_per_session</i>. According to the Oracle documentation, it is used to:<p><i>Specify the</i> …

ORA-01166

We have some jobs which copy the datafiles from 1 database to another then recreate the control file to give the output database a new name. Some of …

Setting NUMWIDTH in PL/SQL Developer

This post is based on a problem I was asked to look at recently.<p>A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 …

db_writer_processes

I wrote the first part of this example in 2012.<p>The database writer copies data blocks from the buffer cache onto disk. The <i>db_writer_processes</i> …

O7_DICTIONARY_ACCESSIBILITY

Long ago, in Oracle 7 I believe, a user with the <i>SELECT ANY TABLE</i> privilege could access tables and views owned by <i>SYS</i>. Also, a user with the <i>EXECUTE</i> …

4-Step Crash Course in How to Differentiate

<b>1, What is the point?</b><p>Do you remember the first graph you ever drew? It was probably the graph of . By now you should be familiar with the notation . …

Mathematics