u are the best judge,
Vikas Khanna
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, November 07, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an ind
ACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
e new datafiles to expand your database. Never the
parameter db_files can be more that the MADATAFILES declared in your
controlfile;
Thanks
Vikas Khanna
-Original Message-
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
George:
If you want to recrea
to bind.
But in the case of DSS applications yes I do agree that these bind variables
are problematic as the data is in abundance and we have to use the data
skewness and its other credentials for the optimizer best to use as we are
playing with abundance of data.
Thanks
Vikas Khanna
10% is spent actually DOING it. If you use bind variables --
very little time will be spent parsing (you can get that statement to
execute in 1/10 of the time). Not only that -- but the concurrency and
scalability of your database will go WAY up.
This is the root cause of your issues, this must be
not Interested in Bind Variables then, For single Quotation marks use
Chr(39) || '1234' || Chr(39) in your SQL statement to solve the problem.
Vikas Khanna
-Original Message-
Sent: Wednesday, July 31, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
i presume the stat
Yes. You can do that when you are creating an instance, define the parameter
nls_date_format in the init.ora file as per your requirement, then the
nls_date_format for the Instance would be as supplied by you.
Alter Session/Alter System would do the same at the time so defined.
Vikas Khanna
from the Export file in an array thus boosting the perf.
Thanks
Vikas Khanna
-Original Message-
Sent: Monday, July 29, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
Hi,
We are importing a large amount of data and uit is generating a huge amount
of redo..is there any way of
this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (li
(like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet acce
operation)
2) Only if the statistics are stale the DBMS_STATS would execute.
3) You can always Export/Import/Set the statistics from one db to another
db.
Thanks,
Vikas Khanna
-Original Message-
Sent: Wednesday, July 24, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Apart from
If 64 bit then
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
else
Oracle9i Enterprise Edition Release 9.0.1.2.0
end if;
Vikas Khanna
-Original Message-
Sent: Tuesday, July 23, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L
Just log into the
doing an update of 1/2 a million rows !!! (how would these
parameters help?)
> --
> From: Vikas Khanna[SMTP:[EMAIL PROTECTED]]
>
> No, Instance recovery has to take place internally, SMON has to recover
> the
> committed transactions which were left hanging in t
quite often, this would open the
instance under crash quite fast as it has to perform less work. But more the
checkpoints initiated more the performance degradations as B'ground
processes would be under tremendous work.
Hope it clarifies.
Vikas Khanna
-Original Message-
Sent: Tu
many executions. Anyway a soft
parse is not too bad as compared to Hard parse and the applications have
proved them to be reasonable functioning well.
The CPU and the memory consumed is significantly just 1% what was compared
with the hard parse.
Vikas Khanna
-Original Message-
Sent
the load among
the various datafiles.
If you
have one hard disk then it would not matter at all between the two different
scenarios.
Vikas
Khanna
-Original Message-From: Denham Eva
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 16, 2002 1:53
PMTo: Multiple recipients of
Use need to use pmap feature of Unix in order to see the real RAM associated
with the processes.
Vikas Khanna
Oracle - DBA
-Original Message-
Sent: Wednesday, June 26, 2002 5:45 PM
To: Multiple recipients of list ORACLE-L
Need a little assistance on some "concepts", s
table specifying
the created_Date as sysdate().
This would continuously prop up the table data wrt this column. And then you
could do order by on this column to get the desired result.
Regards,
Vikas Khanna
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 11:38
Select a.id,a.amount,ccinlineview.bamt from bb a,(Select
id,sum(b.amount) bamt from cc b group by id) ccinlineview where a.id = ccinlineview.id
ID
AMOUNT BAMT
-- -- --
1
1000
1000
1 row selected.
-Original Message-From: sul
wonder is , if I set it up automatic , is the archive log files
automatically copied to standby server , or do I move it manually .
???[Vikas
Khanna] You have do transfer them manually to the standy by server. OR
you can write automated scripts to do the job for
you.
And my
d then also the object would be imported into the
designated tablespace.
Regards,
Vikas Khanna
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Hi
It is Possible to import from NT to Solaris. The table space
21 matches
Mail list logo