| Ask Tom HOT ARTICLES |
| Put this feed on your website |
| Description: |
These are the questions on Ask Tom that have the most comments |
| Format: |
RSS 0.91 |
| Url: |
http://asktom.oracle.com/pls/ask/ask_tom.hot.rss?p_count=20 |
| |
| Latest headlines |
Ask Tom HOT ARTICLES
|
Cursor FOR loops optimization in 10g
2008-09-30
Is it true that Oracle Database 10g will automatically optimize the cursor FOR loops to perform at speeds comparable to BULK COLLECT?
I just got curious after reading in one question on PL/SQL best practices on Oracle Magazine March/April 2008.
Lin...
|
COMPATIBLE PARAMETER after upgrade from 9208 to 11.1.0
2008-09-30
If I upgrade from 9208 to 11.1.6
Compatible parameter changes from its initial value of 9.2.0.0.0 to 10.1.0.
1) Under what circumstances is it advisable to leave this parameter value to
10.1.0. or to upgrade it to 11.1.0. I do want to use all ...
|
Placement of DBAs within an organization.
2008-09-29
At the company I have just joined the database group happens to fall under the applications department. This is in stark contrast to every other place I have been where the DBAs were a part of the infrastructure group. I feel that an important streng...
|
Performance - inline views vs indexing
2008-09-29
Hi Tom, thanks for your time.
My question is in regards toward creating a temporary table and indexing it, vs using an inline view.
Consider:
Process 1:
<code>SELECT <stuff>
FROM a,
b,
(SELECT <more stuff>) c
WHERE <join>
AND...
|
Multiplexed REDO and a few misc questions....
2008-09-29
Tom,
I have a few 'simple' misc. questions please...
1) What is your philosophy of multiplexing ONLINE redo logs?
2) What is your philosophy of multiplixing ARCHIVED redo logs?
On the above two questions, I am in process of trying to convin...
|
Keeping QA Tables in Sync with PROD
2008-09-26
Hi Tom,
Our Developers want an automatic way to (re)synchronize certain tables in QA environment with production data.
I haven't gotten all requirements yet, but it looks like they are wanting to get the data in sync on QA (after changing credi...
|
pragma autonomous_transaction within procedure before creating synonyms
2008-09-17
Hi Tom,
I have created a stored procedure with in oracle package which creates list of synonyms depending upon the change of dblink server name. I need to execute this procedure to create/replace synonym pointing to another dblink server. My quest...
|
Overuse of cursors?
2008-09-17
Tom,
This really isn't a standard question, but given your experience I was hoping you could answer it for me.
In my current job, standard practice is to do <b>everything</b> in the form:
<code>Declare
Cursor <what we want to insert/update/...
|
Constraints on partitions.
2008-09-17
Hi Tom,
Can constraints be enabled or applied on partitions of a table instead of the entire table? I tried searching the docs but couldn't find anything.
Tried my own tests as well but they didn't work either, though that doesn't mean that thi...
|
question on rownum
2008-09-04
when I have a query of the form
<code>select rownum rn, x.*
from
(select ...
from ...
order by ...
) x
</code>
is it guaranteed that the output is ordered by rn
(without explicitly telling Oracle to order it by rn) ?
|