-
-
22:35
»
Ask Tom MOST RECENT ARTICLES
<code>Hi tom,
we have a desing problem ...
we have a table of products like this
PRODUCT
------------------------------
PROD_ID VARCHAR2(15)
PROD_DESC VARCHAR2(30)
PROD_TYPE VARCHAR2(15)
PROD_COST NUMBER(14,5)
PROD_LEVEL NUM...
-
22:35
»
Ask Tom MOST RECENT ARTICLES
<code>Hi again Tom,
I have tried to use the v$session_longops view to track database operations, but I've noticed that only some kinds of them really appear.
Besides, for example, the CREATE INDEX statement is split into multiple sub-operation...
-
22:35
»
Ask Tom MOST RECENT ARTICLES
<code>Dear Mr. Tom,
1) First of all when I tried creating an INSTEAD OF Trigger
it gave me
ORA-00439: feature not enabled: error
Kindly explain why so....?
2) Where exactly would u advise me to use Instead Of trigger...
-
22:35
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
I work with a modelers group, who would like to define every varchar2 field with the maximum length. Which means that a table with 20 varchar2 fields will all be defined with a maximum of 2000 or 4000 bytes.
I tied to talk to him about...
-
22:35
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
I just read the article entititled 'Insisting on Indexes' on oramag's home page. Here is a copy of some of the text from the article
"When your WHERE clause uses a function on a column, the Oracle optimizer won't use an index to eval...
-
16:06
»
Ask Tom MOST RECENT ARTICLES
<code>Tom:
I was interested in using the multi-table insert feature in 9i but am stumped by the restriction that the subquery can't contain a sequence. I use a sequence to assign a Primary Key in one of the tables that is the target of the multi-t...
-
16:06
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
Could you please explain the logic behind the FLASHBACK_TRANSACTION_QUERY view, or even better could you please point me to the documentation page with explanation ? I wasn?t able to find any.
I would like to know how exactly oracle g...
-
16:06
»
Ask Tom MOST RECENT ARTICLES
<code>Sir,
recently in one book i read,
"In the old days, it was up to the developers to build applications
which relied upon sql statements which contained bind variables.
This forced the Oracle kernel to avoid caching similar sql statemen...
-
16:06
»
Ask Tom MOST RECENT ARTICLES
<code>Dear tom,
please let me know how can i update a record in the primary key field which behaves as a foreign key to other tables without altering (disabling) the primary/foreign constraint???? please reply sooon
yours faithfully,
SACHIN...
-
16:06
»
Ask Tom MOST RECENT ARTICLES
<code>Hello Sir,
I am using parallel server with dual Compaq Tru64 unix with 8.1.7 as the database.Some of the frequently used tables gets locked by one of the instance. Due to this other session are just in waiting mode.
In one of your reply I...
-
-
9:47
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom
I am trying to write some triggers for some security purposes so I have been reading chapter 13 in Application Development Fundamentals from Oracle 8.1.7 documentation (working with system events)
I have some questions regarding Sy...
-
9:47
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
I've got a mutating table problem... I have a table with two status fields: 'loaded_status' and 'processed_status'. When the 'loaded_status' column is updated to 'C' (complete) I want to fire off a trigger that passes the ID value for the...
-
9:47
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom,
Thanks a lot for answering previous questions.
Appreciate if you could help in the following questions:
1. Is there a big difference between a global temporary table with on commit preserve rows and a global temporary ta...
-
-
18:38
»
Ask Tom MOST RECENT ARTICLES
<code>How to trigger email sending to clients while using Forms of Dev 2K? Or from database?
Thanks a lot.
Steven
</code>
-
18:38
»
Ask Tom MOST RECENT ARTICLES
<code>Hi tom
Information As you required.
Hi Tom
Think, i have not furnished details properly. Sorry for that.
This is My FACT Table
Create table Sbib_Ownr.Sbib_dochdr
(Carnumcod Varchar2(4) Not null,
Docnum Number(10) ...
-
18:38
»
Ask Tom MOST RECENT ARTICLES
<code>hi tom,
i have seen lot of answers from you regarding sql trace and tkprof for sql performance tuning.but i am still not clear with few things.
i hope you will explain me clearly those things
1.how does this sql trace and tkprof differ f...
-
-
2:55
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom
Feels good to post a question after quite some time.
Look at the following :
SQL> desc dual
Name Null? Type
----------------------------------------- -------- ---------------------...
-
2:55
»
Ask Tom MOST RECENT ARTICLES
<code>I run a script from NT using plus80.exe, in this script it combines several steps including procedures, sqls. After it run about 7-8 min
I got this error ORA-20000 ORU-10027 buffer overflow, limit of 1000000 bytes, and then the step aborted.
...
-
2:55
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
How do you initialize a PL/SQL table of records in the Declaration section of a PL/SQL block?
In the following snippet, I can successfully initialize a normal scalar PL/SQL table but am unsuccessful initializing a table of records. ...
-
2:55
»
Ask Tom MOST RECENT ARTICLES
<code>Hi tom,
I am in the process of testing a web application. However
I am trying to use your example about DBMS_OBFUSCATION_TOOLKIT but
you used bind variables. So, I am running into a problem. I need to incrypt and most important descrypt t...
-
2:55
»
Ask Tom MOST RECENT ARTICLES
<code>Please Sir , I need to Know how can I get and the comments on tables or columns from the data dict.
with respect
</code>
-
-
17:37
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom,
I having problems in calling a 'C' ext proc in my plsql procedure.
The EXT proc requires char(10000) as one of the parmeter.
If i declare char(10000) in the calling plsql proc then
i am getting a 'unable to read memory error'
I...
-
17:37
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom
When I say direct=y in the export the processing is much faster.
What r the scanerious where i should not use direct=y
Regards
</code>
-
17:37
»
Ask Tom MOST RECENT ARTICLES
<code>Tom
I need to gather the TPS(transactions per second)of my database.
I used two methods below to find the SCN
1) Prior to 9i
alter system checkpoint
select checkpoint_change# from v$database
2) Oracle 9i
select dbms_flashback.get_s...
-
17:37
»
Ask Tom MOST RECENT ARTICLES
Tom,
I have this table with around one million records. The table has the potential to grow to 2 million, 3 million or even more...
I am planning on partitioning this table using hash partitioning on the most queried column. A few questions:
...
-
-
19:47
»
Ask Tom MOST RECENT ARTICLES
<code>Tom
How is it possible that we avoid a softparse?
My understanding is that when the first time a query is given it is hard parsed i.e. it reads the disk. But after that every time you give that query it is read from memory i.e. softparsed...
-
19:47
»
Ask Tom MOST RECENT ARTICLES
We used the export function of Toad to get a large table out of production to load to our dev database. Unfortunately, the thing exported all 6 million rows as insert statements instead of just data. So to load it, I'm using SQL+ in 'run a script f...
-
19:47
»
Ask Tom MOST RECENT ARTICLES
Hi Tom, if possible could you please explain the advantages and dis-advantages of storing files within an Oracle database. We are currently using 9.2 and 10g. We have no immediate plans to move to 11g. Thanks, we all appreciate your answers!
-
19:47
»
Ask Tom MOST RECENT ARTICLES
<code>Tom,
I just wanted to ask a question and get your opinion or some links to some good sources for information that you may know of. The company I am working for we have an application where 90% of the business logic is in the database and the r...
-
19:47
»
Ask Tom MOST RECENT ARTICLES
I'm using an "ALTER ADD TABLE ADD COLUMN..." command to add multiple columns to a table. Is the order of new columns in the altered table determined by the order in the statement, or is does the database do some optimization, potentially leading to d...
-
-
18:50
»
Ask Tom MOST RECENT ARTICLES
<code>How do you interpret LAST_CALL_ET field from the v$session view? What is the significance of this number field?
Can I get the execution time by getting the difference between LOGON_TIME and SYSDATE?
How do I find the buffer_gets,logica...
-
18:50
»
Ask Tom MOST RECENT ARTICLES
Hello Tom, I found your side an I am sure you can give me an neutral answer...
I use oracle since about one year, it's really the best database I found.
I am also programming Visual C++ since years, so that I access to Oracle with the OCI, not ...
-
18:50
»
Ask Tom MOST RECENT ARTICLES
I work with Oracle-based case management systems, and I've been asked to create a query that shows an inventory of case rows still open at the end of each day in a month.
Each row in the table I'm querying (called ISSUE) has a 'open' date called D...
-
18:50
»
Ask Tom MOST RECENT ARTICLES
<code>Hi Tom,
I have faced a problem with NUMBER datatype. Currently I am
working on a code dump from Finland. The dump contains
the command "REPLACE(total_sum,'.',',')". This code works in Finland.
But it does not work when I import the d...
-
-
17:46
»
Ask Tom MOST RECENT ARTICLES
Dear Tom,
With 11g Oracle now seems to use dbms_epg as the default engine for APEX.
Could you elaborate a little on the differences and give us some hints on if and how to migrate existing Apache/mod_plsql (but not APEX) application to dbms_epg.
...
Database
(1495 unread)
DBA's notes (111 unread)
$Pete Finnigan's Oracle security weblog
(56 unread)
Databases News (83 unread)
Eddie Awad's Blog (31 unread)
FeuerThoughts (36 unread)
Oracle HTML DB Studio Recent Additions (20 unread)
Oracle Security Alerts (2 unread)
Published Security Alerts
The Dizwell Blog
The Tom Kyte Blog (18 unread)