 | | | Oracle List | | Dick
Have I got a function for you
Function Second_Convert(in_sec in number)
return varchar2 is
hrs number
lmin number
sec number
ret_string varchar2(40)
--in_sec number 3670
I generated some scipts with 10.2.0.1 to see what they looked like.
I posted this at metal ink and got no response.
dbca generated scripts used to use the CREATE DATABASE command. I was looking aHi Riyaj
The case we encountered was not due to gathering statistics.
Vendor used index_desc hint to "derive " a result set.
There was a block corruption on the index and it was recreated with a Hi all
Does anyone faced problem with message "App-26265 the inventory
controls entered for this delivery line are invalid or do not exist. " in
Oracle Application ?
The issue occurs whenHi all
Does anyone faced problem with message "App-26265 the inventory
controls entered for this delivery line are invalid or do not exist. " in
Oracle Application ?
The issue occurs when Quoting Riyaj Shamsudeen <rshamsud@(protected) >
>
> I don 't think it is a good idea to detect the false information without
> correcting some of the fundamental CBO discrepancies. In few cases All
I 'm attempting to download a 9.2.0.7 patch for NT. The McAfee virus
scan failed on my machine because of a stupid time limit setting. I
tried downloading thru Metalink.
Is there an Ftp site w > tried. didn 't work. I can see 2 archivers busy (v$archive_processes) but
> only one (last) sequence is shown in v$archive_dest
truss/strace
Regards
Dimitre
--
http //www.freelists.org/webpageHello all
I 've created an interesting entry in my (newly created) blog and would very
much appreciate some input
http //ora.kicks-ass.net/blog/2006/05/application-express-search-for-user.html
ReKirti
So they want something entirely outside Oracle that can track every single
action performed within Oracle no matter what the access method? Wow I 'd
like to see that one as well.
I 'm assu
Don
a few links to Dizwell.com.
Howard used to have a pretty good article on how he got about 30% (I
thinnk) better performance on Linux compared to Windows but I can 't
find it anymore. He change > > > > when network failures occur no "third party " can choose which node
> > > > should survive. So a manual failover is the only solution. Only a
> > > > third site will give you enough "quorum " to providAnd how about the data pump transformations? REMAP_TABLESPACE
transformation?
On 5/18/06 Christo Kutrovsky <kutrovsky.oracle@(protected) > wrote
>
> You have table called BIGTABLE in tablespace USERS.Hi everybody
Can somebody provide any good Siebel Link as I had to work on Siebel in the coming Week and had to understand various component. I am going to have Database in Oracle and look ing tI 'm about to open an SR on a situation I 've got with a RENAME hanging on event 'library cache pin ' but thought I 'd bounce it off all of you first in case anyone 's got any helpful suggestions on how Take a look at this
http //www.imperva.com/products/securesphere/database_security_gateway.h
tml
Not cheap but it will capture everything going to the Db. Not sure
about an encryption solution.
I think the best way to perform it is using a grammar parser. Otherwise you
have a very very tough project.
I usually use "antlr " (http //www.antlr.org/). It 's quite good. In the
website you can finYes the answer is
1) Because by equal cost of many indexes the CBO is using the first
one in alphabetital order
The RBO used "least recently created " as a tiebreak between indexes
the CBO uses awhat I fail to understand is why would you use aud$ table when all the
information you need is available inside the trigger?
check http //download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/
You 're paying the cost of using exotic platforms. I sincerely doubt that anybody will
be able to respond to your question.
--
Mladen Gogala
http //www.mgogala.com
--
http //www.freelists.org/webpI 'm curious if anyone is intentionally using the dbms_stats.gather_database_stats_job_proc scheduled in 10g. Has anyone replaced the job because of limitations with it? From what I 've read it looks re <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " >
<html >
<head >
<meta content "text/html charset ISO-8859-1 " http-equiv "Content-Type " >
<title > </title >
</head >
<body bgcolor "#ffffff10g just looks at mount options for NFS mounts so any NFS
will do... but only OSCP certified NAS offerings are supported for
production
submitted by joze senegacnik title is "cbo 's costing of pl-sql functions "
Raj
On 5/18/06 Schultz Charles <sac@(protected) > wrote
> Remember which paper?
>
> -----Original Message-----
> From rMy application with numerous PUBLIC SYNONYMS and PLSQL objects has always
compiled great after builds (Oracle 9i) using utlrp.sql. However I am
trying to get the same to work in 10Gr2 and I run into I also found dg easy to setup. My problems come from configuring dgmgrl.
Getting the network configuration syntactically correct is difficult.
Which is why the documentation on the subject is sparseOh come on isn 't anyone old enough to remember TechGnosis SequeLink?
http //newssearch.looksmart.com/p/articles/mi_m0SMG/is_n9_v11/ai_1097569
2
It sure beat SQL*Calc -)
<!DOCTYPE HTML PUBLIC I ran into a problem a few weeks back where the ASM archive
destination filled up.
I wrote a sql script to test the freespace in the disk groups against
some thresholds and create a logfile. sqlpDear Oracle Experts
I 'm running into issues copying my ASM RAC database from a 2 node 10G RAC
(ASM/OMF) Rel. 2 on RHEL4 U2 EM64T to a single node standby 10G ASM DB
(ASM/OMF). I 've all the identicalHi List
SELECT *
2 FROM tab1 t1
3 tab2 t2
4 tab3 t3
5 WHERE t1.id t2.id
6 AND t2.id t3.id
7 AND t1.type IN
8 ( 'A ' 'B ' 'C ')
9 AND t3.type 'A '
10* |
|
|
