<code>Hello Tom,
I know this is my second question in a span of a few minutes. I wanted to get a feel from the user community of the best practices in laying out a SAN for the database. Where do the redo logs go? Does one set stay on the SAN an…
Link to [...]
<code>Hi Tom,
In one of your followup, you had mentioned that you need to look for queries that perform a large number of logical I/Os. But my understanding is that an I/O is considered as logical I/O if I/O involves a memory access and not a disk…
Link to the original site
<code>Tom,
Is it possible to move a table partition from one tablespace to another in the same way it is now possible to move a table from one tablespace to another ?
</code>
Link to the original site
Hi Tom,
One more interview question. To you it may sound amusing but I was very much confused.
Here goes the question…
There is a large database say, Terrabytes in size. Select query has started executing say, sharp at 10 AM.. simple selec…
Link to the original site
<code>I have a trigger for insert on a table.
The trigger works like this:
if inserting in the id range of 1000000,
insert the same line with an id of 20000000.
for example:
table named test with columns id, notes.
id is a primary key and n…
Link to the original site
<code>Tom,
what’s the difference between ‘gather stale’ and ‘gather auto’? How does auto determine which objects to analyze? Is the *_tab_modifications still being used? Auto seems to pick up on changes much faster than stale…
If all tables are…
Link to the original site
<code>Dear Tom,
we have different Oracle RDBMS version – production, testing, developing. In this situation we use only Oracle 7.3.4 features, nothing extra. We would like to move data between Oracle 7.3.4, Oracle 8.0.5 and Oracel 8.1.6R2. How do …
Link to the original site
Hi.
Some data in the first record of my text file (a date), has to be inserted in all rows of the table.
How do I create a CTL file for this?
The first row of the text-file goes e.g. HEAD20091001. The date (2009-10-01) relates to all the rest of t…
Link to the original site
<code>Tom,
I am required to run a procedure "analyze_user" at 9 AM every morning. For this I am submitting a job as shown below.
BEGIN
DECLARE
v_JobNum NUMBER;
BEGIN
DBMS_JOB.SUBMIT(v_JobNum,’analyze_user;’,sysdate,’sysdate +1′);
c…
Link to the original site
<code>Hi Tom,
I am using the oracle hot backup facilty in ARCHIVELOG mode. I would like some advice/guidance on a particular matter .
Currently I am performing a hot backup every day as follows :
1. Copy each tablespace in turn by setting ta…
Link to the original site