| Recent News |
|---|
| Date |
Title & Source |
| 10-MAR-10 |
Pfile or SPFile (Ask Tom )
|
| |
<code>Hello Sir
Is there any view avaiable through which we can know from which file our instance has started.Is it pfile or spfile.Without making any changes to file and then seeing it by opening it.
Thanks
</code>
|
| 10-MAR-10 |
Undo tablespace keeps growing (Ask Tom )
|
| |
<code>Tom,
I created an undo tablespace with a single datafile as
AUTOEXTEND ON MAXSIZE UNLIMITED.
The undo related init parameters are:
undo_management string AUTO
undo_retention integer 90...
|
| 10-MAR-10 |
Full Database export and import : v8.1.6 (Ask Tom )
|
| |
<code>
Hi Tom,
I have a question about full export/import of database (I have
only used export/import of specific schemas before).
I have a script to do a full export of the database. It does
the following :
$SQLPLUS /nolog <<EOF >> $LOGF...
|
| 10-MAR-10 |
Partitioning question (Ask Tom )
|
| |
<code>Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a
table that assigns one or more industry codes to each doc:
create table doc_ind
( doc_id integer,
ind_co...
|
| 10-MAR-10 |
SGA size (Ask Tom )
|
| |
<code>Hi Tom,
Can you give us an idea as to how to estimate size of SGA? An experienced dba told me that the best way to estimate size for SGA is to set aside 40% of memory for sga i.e for 2gb memory 800mb is sufficient. Is this correct?
If yes, th...
|
| 10-MAR-10 |
Multilingual Database and UTF-8 (Ask Tom )
|
| |
<code>Greetings Tom !!
I am always here when I need to get that 100% right answer and so here is my question .
The existing Database (WE8ISO8859P1 Char Set) needs to cater to English ,Chinese,Japanese and Korean as well .
Before I opt to ha...
|
| 10-MAR-10 |
Constraints (Ask Tom )
|
| |
<code>Tom,
Are the following a full list of all possible user constraint_types
P - primary key?
C - check?
R - foreign key?
U - unique ?
And what are their full meanings?
Are the dab constraint_types the same?
Thanks
Brian
</code>
|
| 10-MAR-10 |
SQL Query (Ask Tom )
|
| |
<code>Hi Tom,
I have a table like this
create table temp1
(f_name varchar2(100),
f_date date,
f_amount integer
);
Records in this table will be like this:
Ajay 15-JUL-02 500
Bhavani 15-JUL-02 700
Chakr...
|
| 10-MAR-10 |
CURSOR (Ask Tom )
|
| |
<code>Hi Tom,
I want to declare multiple cursors based on the values
passed through a procedure ie, only where conditions of the
cursors will change. The body of the procedure is
same for all the cursors.
Pls. suggegst a solution.
Than...
|
| 10-MAR-10 |
SQL Tuning (Ask Tom )
|
| |
<code>I am new in tuning sql statements. Can u give a methodology of tuning
the sql statements.
</code>
|
| 10-MAR-10 |
ANSI Join, Questions on (Ask Tom )
|
| |
Hi Tom
All the queries (involving SCOTT.EMP and SCOTT.DEPT) given below are giving the same results.
So, I would like to know what that makes the "ON" clause special ...
Please teach me.
Thanks in Advance.
select emp.ename from emp join ...
|
| 10-MAR-10 |
How does buffer access happens for a particular table's buffers? (Ask Tom )
|
| |
Hi sir,
When for a table, a select command is issued, how does the lookup happens? I am aware that in the buffer cache, the buffers are managed by the DBA but how the buffer lookup happens? I mean to say, for example, I ran a query like 'select *...
|
| 10-MAR-10 |
Asynchronous Process (Ask Tom )
|
| |
Hi Tom
I Know that a Job can be used like an asynchronous Process, but i would like to Know if there is another way to implement an asynchronous process.
All that I want is Just a PL/SQL Block that call another one and immediately finish withou...
|
| 10-MAR-10 |
noresetlogs (Ask Tom )
|
| |
<code>hello tom
I don't understand why after recovering the database using a backup control file, the database must be open with resetlogs options?
And in what other ocasion i must utilises this option?
thanks a lot,
razvan
</code>
|
| 10-MAR-10 |
SQLLoader (Ask Tom )
|
| |
<code>Hi Tom,
I need to load the data from text file into multiple tables.
In each row, the first, second, fourth fields should go into
table"A", third, sixth fields should go into table"B" and
fifth field should go into table "C".
The fields...
|
| 10-MAR-10 |
checkpoint not complete, cannot allocate new log (Ask Tom )
|
| |
<code>Tom,
I am receiving the following message in my alert log and can find
no documentation explaining what this error means or how to correct it.
Sun Feb 13 03:30:26 2000
>>>>>Thread 1 cannot allocate new log, sequence 41801
>>>>>Checkpoint ...
|
| 10-MAR-10 |
The Troubles of Korea???s Influential Economic Pundit | Magazine (Wired News)
|
| |
... in the blanks. The result is a sort of virtual superhero, an oracle more accurate than any mortal could hope to be. Compared to ...
|
| 09-MAR-10 |
11g FOR UPDATE SKIP LOCKED (Ask Tom )
|
| |
Hello Tom,
In 11g, there is a new clause added to SELECT called, FOR UPDATE SKIP LOCKED. Some people used this clause in 9i and 10g when it was not documented. Now that it is documented in 11g I have a question on it.
You have said in the past ...
|
| 09-MAR-10 |
Interpreting the Statspack report. (Ask Tom )
|
| |
<code>Tom,
I am running Oracle 9.2.0.4 on ALPHA OPEN VMS with 2 CPU's.
I was reading this STATSPACK report, Could you please help me
interpret this
See the snippets of this report.
DB Name DB Id Instance I...
|
| 09-MAR-10 |
Row chaining (Ask Tom )
|
| |
<code>Tom,
Let's say I have a table T with the following columns(field1 to field20). Now, as part of a requirement I have to add some 20 odd columns(lets' say each varchar2(15)). What steps I would require to take to find out that the table doesn'...
|
Serving 20,000+ Oracle technology professionals with access to 10+ SIGs, multiple regional groups and thousands of online resources
