. Oracle9i SQL Reference Release 2 (9.2)
Schema Object Naming Rules
Schema Object Naming Examples
The following examples are valid schema object names:
last_name
horse
hr.hire_date
EVEN THIS THAT!
a_very_long_and_valid_name
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
why oracle-l is a technical mailing list, and it's not about who
is who, who should use what oem or command line, windows not unix.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Joe Testa wrote:
Please unless
to the double quotes. That's the only thing I
wanted to tell :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL
= a.x(+)
/
SELECT a.*
, b.*
FROM (SELECT dummy x FROM dual WHERE 1 = 2) a
, (SELECT dummy x FROM dual) b
/
You join empty result set of table a, with some rows from table b.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
select recid,creator from v$archived_log where recid 55;
RECID CREATOR
- ---
56 ARCH
57 ARCH
58 FGRD
59 FGRD
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see
;-) I don't see too many practical
applications. ;-)
I did not want to discuss this particular case. It's a good one.
Good as an example.
There was/is a practical application of recursive solution ( 9i) --
check standard.replace which is not so nice if it's heavily used.
regards,
--
Vladimir Begun
Tanel Poder wrote:
Ouch, I gotta take a day off to read this one ;)
http://www.netmeister.org/news/learn2quote.html
It's all about optimization...
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see
) AS Implementation Plan
FROM big_table
WHERE ROWNUM POWER(2, disks)
AND disks 8
/
SPOOL OFF
Should work correctly.
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L
-life examples are
much more complex :)
If you do not mind I would not continue this discussion.
Thank you.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Jacques Kilchoer wrote:
Mr. Begun,
I didn't answer your
Jacques Kilchoer wrote:
Mr. Begun: I'm not convinced that your answer is quite the right one.
I've provided two solutions but I'm still confused :). Jacques, does
that mean that I understand English and the original query was Ok? :)
--
Vladimir Begun
The statements and opinions expressed here
., in your case, 4. As I already said, it was just an example, in real life I
would think
is it Ok or not Ok to use it.
Timing is not everything you can check, consider statisticts. Did you consider
indexing val?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
to see the COLLECTION ITERATOR (PICKLER FETCH)
That's obviously nice :) but I think it's not a reason to use PL/SQL to
solve this task.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE
AND dbms_lob.instr(testcolu, ' ') = 1)
SQL /
ID TESTCOLU
- --
2
4
If the columns updated to ' ' it can not show NULL during select.
--
Vladimir Begun
The statements and opinions expressed here are my own
original table.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Gabriel Aragon wrote:
I have a table with like this:
Usr val
--
GAP 1
GAP 5
GAP 7
JKL 8
JKL 5
I need a query that returns the user (GAP o JKL
specify a condition in the WHERE clause that restricts the
retrieval to one or more partitions of table. Oracle will interpret
the condition and fetch data from only those partitions. (It is not
possible to formulate such a WHERE condition for hash-partitioned data.)
--
Vladimir Begun
The statements
-scribbled mine:
SELECT usr
FROM (
SELECT DISTINCT usr, val, COUNT(DISTINCT val) OVER (PARTITION BY usr) cnt
FROM gab
)
WHERE val IN (1, 5, 7)
AND cnt = 3
GROUP BY
usr
, cnt
HAVING COUNT(*) = cnt
/
HTH,
--
Vladimir Begun
The statements and opinions expressed
issue until I found the problem using LIKE.
Of course it was easy for anybody to figure it out from here.
Check the dates of the posts.
The idea is to add value instead of waiting to have the final words!
Excuse me, but that just not polite.
--
Vladimir Begun
The statements and opinions expressed
the original query you had pofile
functions enabled, when you tried it second time it was disabled.
. query rewrite is used (could be, right?)
Could you please check the second and third items?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent
of such. You can also enable native compilation to see what's going on [if
you familiar with C language].
regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
P.S.: General note: not everything that's undocumented has
SELECT id FROM test_table WHERE LENGTH(testcolu) = 0;
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Seema Singh wrote:
What SQL I have to use.Is there any way can i know what are those
columns were updated
this statement of yours does answer your original question --
bad PL/SQL coding -- bad NC results.
HTH,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Khedr, Waleed wrote:
Below are two dummy procs that are good
parameter is passed by value (a copy of the value is passed
in and out) unless NOCOPY is specified.
Whatsoever, it appears that the call by reference is more expensive than
a call by value.
See above.
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
. details open the C (native) code and see.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City
of the code inside IF THEN, it
starts to speed up.
Less number of inexpensive instructions is everytime better (I'm not talking
about lines of code).
Trace it -- 10046/12 + dump instructions using appropriate event.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
get length of each of those you will see which one you need.
length of #4 should be 0.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Seema Singh wrote:
Hi,
If we have table with clob column and want to findout
that can be
implemented and tested. I'm pretty sure that the approach
is disputable, so please let's avoid long discussions.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Jonathan Gennick wrote:
The recent
:),
but, definitely, knowledge of some basic principles would help -- so start from the
Knuth's books.
regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
Hi!
If I recall correctly, a simple B-tree
MODIFY f1 DEFAULT NULL;
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services
Ross Collado wrote:
Hi,
How do I delete a file named --cart ?
Thanks,
Ross
touch -- --card
ls -al -- --card
rm -- --card
ls -al -- --card
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see
of the key at least up to 128 bytes.
Now due to pipelining my code is very fast and to accomodate a 122 baud feed, I have
insert artificial delays in my code. 8:)
What's the point to pipeline it?
Appreciate your feedback.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
welcome.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
(gv_tcp_conn, CHR(nenctcpchar), NULL);
10 nCharsSent := nCharssent + 1;
11 IF MOD(ncharssent,128) = 0 THEN
12p('Before Flush ...');
13UTL_TCP.FLUSH (gv_tcp_conn);
14p('Connection Flushed at ' || ncharssent);
15 END IF;
16 --
17 END LOOP; -- FOR i IN 1 .. msglen
--
Vladimir Begun
are
not.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Vladimir Begun wrote:
Tanel Poder wrote:
FFS will scan from index header block (note that index segment header and
index root block are different ones) up to segment high water mark using
multiblock reads and ignoring contents of root, branch, bitmap, extent
map,
freelist group blocks. Rows
.
Fast full scan is available only with the CBO. You can specify it with the
initialization parameter OPTIMIZER_FEATURES_ENABLE or the INDEX_FFS hint.
Fast full index scans cannot be performed against bitmap indexes.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
Vladimir Begun wrote:
Full scan
This is available if a predicate references one of the columns in the
index. The predicate does not need to be an index driver. Full scan
is also available when there is no predicate, if all of the columns
in the table referenced in the query are included
:)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Jonathan Gennick wrote:
Fascinating. I've tried:
SYSDATE@ no
[EMAIL PROTECTED] no
SYSDATE@@ no
SYSDATE! no
and [EMAIL PROTECTED] yes
But why?
Best regards,
Jonathan
Mladen Gogala wrote:
Mladen, there is no synonym for @#$%!, be more serious :)
I promise! Scout's honor!
I believe :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
ROWID
, data
, DUMP(data) dump
, LENGTH(data) - LENGTH(TRANSLATE(data, :np, '@')) numer_of_np_chars
, INSTR(TRANSLATE(data, :npc, :np0), CHR(0)) first_position
FROM table_1
WHERE TRANSLATE(data, :np, '@') data
/
It's not for unicode. FBI could be used as well.
--
Vladimir Begun
See notes, 113827.1, 119426.1, 154880.1. Could be done and done, but
not to solve this particular task -- it would be an overkill. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
[EMAIL PROTECTED] wrote
/TO_NUMBER in case it's = 8i -- it would work
faster.
SELECT TO_NUMBER(SUBSTR('0x50AA', -6), 'FM0X') dec
, '0x' || TO_CHAR(170, 'FM0X') hex
FROM dual
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle
to write especially when you need to work with bits, shifts
etc.. I've recently implemented crc32 for some internal project --
works well, obviously faster than SQL, PL/SQL and native comp of
PL/SQL code. Native comp. is also good to consider, if it's 9i.
Sure, it depends...
--
Vladimir Begun
.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
Hi!
This is the problem, that everything else was identical. If you executed
exactly the same query again, it didn't get hard parsed anymore, thus
('0x50AA', -6);
Then you can use BITAND. However, I'm not saying that PL/SQL is better
than perl -- every language has its own purpose.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official
Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Mladen Gogala wrote:
Or, the function can be written to return number. It's not so hard to
do. If there are problems,
please let me know, I'll post the new version of the code, wrapped.
Thank you. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily
;
/
--
Mladen Gogala
Oracle DBA
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services
an example of its usage in SQL. Please create
an FBI using the original function below (as is, no modifications or wrappers).
It would be really intersting how deterministic functionality would work
for a PL/SQL function that returns BOOLEAN datatype. Thank you!
--
Vladimir Begun
The statements and opinions
.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
-Original Message-
Sent: Thursday, September 25, 2003 10:05 PM
To: Multiple recipients of list ORACLE-L
Tanel Poder wrote:
Boolean is a datatype existing
Piet de Visser wrote:
CCCP:
USSR:
:)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City
SELECT DISTINCT testid
, FIRST_VALUE(name) OVER (PARTITION BY testid ORDER BY ROWID) name
, FIRST_VALUE(status) OVER (PARTITION BY testid ORDER BY ROWID) status
FROM testing
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent
...
Connected.
SQL /
PORT_STRING
SVR4-be-8.1.0
SQL SELECT paddr FROM v$session WHERE rownum 2;
PADDR
902B51D8
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle
tricks into the code that make the crackers
life hard (or should I say interesting :)
:) I just think you have/had too much time and nothing serious and important
to do.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation
Tanel Poder wrote:
:) I just think you have/had too much time and nothing serious and
important to do.
That was the case, back at highschool days...
I think you're still there... at least according to your posts. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
Anyway's Peter is right in some sense as I heard that some Russian guy
Those Russians... :) They can do a lot.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
the door (in this
case [EMAIL PROTECTED]) than someone else knocks your door -- feel the
difference (c)]
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
commendable plan... (a touch of irony here)
Probably the ones who already have cracked the algorithm aren't spreading
the knowledge - why should they anyway?!
I suggest you to call Oracle legal and discuss this issue and your
original plan of fixing it. :)
--
Vladimir Begun
The statements
Tell me about it. :)
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
Hi!
The views are small part. There are over 15 objects in whole database,
of which over 22000 are packages
security context. You
can define whatever context you like. Using this approach you can use
one view that covers different user application roles.
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
rahul wrote
about.
sys.source$ -- no way, it must live in system tablespace.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
A Joshi wrote:
Hi,
Unrelated question : If the system tablespace is so big would it not
hurt
...
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
I have found out the reasons. Thanks for your information.
That's good.
P.S.: 27 of Nov is my birthday. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
and the mgrs above them. Like this:
ENAME MGRS
--- --
SMITH SMITH
SMITH FORD
SMITH JONES
SMITH KING
..
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
Vladimir Begun wrote:
SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2,
typo: ^RTRIM
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
', 'DDMM'), 'IW')
, '01', -7
, 0
)
, 'IW'
)
) = wk
AND wk 0
/
HTH[, if I did not make a mistake].
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
is to enable client side network
logging, however there is problem here your mentioned that it's
not a consistent error therefore trace file can be quite huge.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
DENNIS
6 );
COUNT(*)
--
7000
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat
*')
)
) AS l
FROM emp
/
As you can see it's tightly bound to table definition one
has to handle nulls for varchars/chars.
L
-
7000
Check the resources -- I have doubts that this query is a
winner :)
So, the moral of this story:
. never trust Vladimir Begun, check everything what
Jared
[EMAIL PROTECTED] wrote:
. never trust Vladimir Begun, check everything what he's saying :)
Trust?
I don't know you well enough to not trust you.
May be 'trust' is not a right word here :) Sorry.
. never use the sql that looks cool but does not work properly
. never tune a query
Looks like you are a master of telepathy too... :)
Khedr, Waleed wrote:
What about:
select count(count(*))
from emp
group by ename, job
Have fun :)
We do... :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation
, job
FROM emp
)
/
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED
It's not correct, check metalink -- there is a note about that.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
K Gopalakrishnan wrote:
Kirti:
I think the interval is changed to 5 minutes from
3 hours starting
it's schedule interval the two invocations will not run into
each other. Now as discussed, if the job is scheduled to start at 9:00 AM and
runbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15, and it
will creep 5 minutes every time.
Regards,
--
Vladimir Begun
The statements
asnwer, you need 4 jobs. Otherwise in case
of more than 15mins runtime you'll face slipped jobs.
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
Stephane Faroult wrote:
Vladimir (whose formula I am still trying to understand :-))...
TRUNC(SYSDATE) + (CEIL(TO_CHAR(SYSDATE, 'S') / 60 / :interval) / (24
* 60 / :interval));
P.S.: could you please answer my question ('100% CPU utilization,
urgent') thread?
--
Vladimir Begun
and mysteries
are in our minds, a piece of software is either working or
getting glitches.
The rule: never reboot anything (your car is included :) unless
you know the root of the original problem. :)
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily
routines. ;)
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services
dbms_job.submit(
:jobno
, :plsql
, TRUNC(SYSDATE) + (CEIL(TO_CHAR(SYSDATE, 'S') / 900) / 96)
, 'TRUNC(SYSDATE) + (CEIL(TO_CHAR(SYSDATE, ''S'') / 900) / 96)'
);
COMMIT;
END;
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
(*) from facility;
1. FGAC? Connect as sys and check.
2. Could you please show explain plan?
3. What's in the trace file?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http
s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
AND s.sid = a.sid
AND a.object = 'TRG_TEST'
AND a.type = 'TRIGGER'
;
-- dbms_output.put_line('Owner of the trigger is ' || ls_owner);
END;
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily
1997, in Vejle, I had an interesting meeting with Bjørn
Engsig about Sybase-Oracle migration. Denmark... small
Great country. Nice, kind and friendly people who work
diligently in peaceful atmosphere -- I love it.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do
, 'TEST', '01-JAN-03');
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
[EMAIL PROTECTED] wrote:
Ok, try this one. It's a little smarter. :)
create or replace function df1
( date_in varchar2 )
return date
Deshpande, Kirti wrote:
Spasibo balshoye
:)
:) It's an adequate answer. I've a draft somewhere [I need to
find it], very 'roughly' transalted in English, do you want to
read it?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
)
*/
*
FROM dba_types
/
In this case it's better to scan indexes.
I like both your explanations for the size, and
the unusual number of obj$ blocks that needed
CR serving.
;)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those
JFYI, (it's in Russian and PL/SQL :))
http://www.oracle.com/ru/oramag/june2001/index.html?begun.html
Be careful with standard.replace (9i) and recursion in PL/SQL.
Connor McDonald wrote:
From AskTom
...
Kind Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own
analyze ... validate
structure cascade.
I also tested the scenario you describe in your code below. The code
does break with that error, however there are no inline views in my code.
Lisa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED
where name = your package_name)
and line between 1960 and 1980
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET
?
Check related RAC statistics regarding to global cache
and V$CACHE_TRANSFER. Probably it's not an obj$ but
the wait and FTS look suspicious.
To speed up the query you might want to use user_types
or write our own to avoid FTS.
--
Vladimir Begun
The statements and opinions expressed here are my own
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
);
-- However this works well:
SELECT *
FROM tbl
, index_s
WHERE tbl.rowid = index_s.rid
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Koivu, Lisa wrote:
Hello all,
8.1.7, Windows 2000 SP2
Here's
Rachel
DBA_CONS_COLUMNS is a view. DECODE is applied against
attrcol$.name -- which is varchar 4000.
Kind Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Rachel Carmichael wrote:
As part
, it's
in this thread:
http://www.mail-archive.com/oracle-l@fatcity.com/msg61930.html
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
to have indexes... Thread participants have provided some examples
already.
Kind Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
on roles.
The advantage is reusable and manageable code but not just
the problem with roles. Def.rights units have their advantages
too -- the biggest one, IMHO -- no 'context switching'. Stored
Java stuff is also based on inv.right facility.
Kind regards,
--
Vladimir Begun
The statements and opinions
-- In seconds, currently the maximum resolution is in hundreths of
-- a second (e.g., 1.00, 1.01, .99 are all legal and distinct values).
--
Vladimir Begun | Falling in love is a lot like dying. You
http://vbegun.net/ | never get to do it enough to become good at
http
will fill one file and then go onto the next file.
Try this
http://vbegun.net/oramag/extents_allocation/round_robin.sql
Inform me please if it's helpful.
Thanks.
Have a nice weekend.
--
Vladimir Begun | I think $[ is more like a coelacanth than a
http://vbegun.net/ | mastadon
with dbms_support package, but i didnt find this package and I
also didnt find creation script in my rdbms/admin directory (it should be
dbmssupp.sql).
Please help me where I can find it or how to do it.
Ivo Libal
dbms_system.set_ev(sid, serial, event, level, NULL);
--
Vladimir Begun
On Jul 16, 2001 at 07:12:00AM, Vladimir Begun wrote:
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote:
Hello
I would like to start tracing for different session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for different sessions with
different levels
can be empty
because of preallocation or delete activities.
--
Vladimir Begun | echo Congratulations. You aren't running
http://vbegun.net/ | Eunice.
http://vbegun.net/wap/ | -- Larry Wall in Configure from
[EMAIL PROTECTED]| the perl
1 - 100 of 122 matches
Mail list logo