First of all I'd like to have the full picture of your performance: Log
file sync might be 57% of the wait time, but how much of the response
time is wait time?
Second, Log File Sync means Commit; So if your system is waiting a lot
for commits there are two things you can do: Fewer commits
I want to change TRANSACTIONS_PER_ROLLBACK_SEGMENT default parameters of rbs segments.
but i don't know where this parameter is, how can i deal with it?
Jim
[EMAIL PROTECTED]
2003-01-02
--
Please see the official ORACLE-L FAQ:
Yes, the lessons I took from that presentation were to use a shorter piece
of string and buy larger bottles of gin though I'm willing to admit that I
may have got the wrong end of the stick.
=)
Cheers,
Mike
-Original Message-
Sent: 02 January 2003 09:24
To: Multiple recipients of list
Landing at Ben Gurion Airport... So True!!!
As the plane settled down at Ben Gurion airport, the voice of the
Captain
came on:
Please remain seated with your seatbelt fastened until this plane is at
a complete standstill and the seat belt signs have been turned off.
To those of you standing
what makes you think you have excessive redo being generated? What
does the application do? How many changes are made daily? How
frequently? Just because a tablespaces is locally managed does not mean
there will be no redo generated when a change is made, it just means
that there will be less
A point that Paul Needham could have mentioned -
if an application user can execute the packaged
procedure to set the role, then a malicious user
could log in from SQL*Plus and do exactly the
same. This is just security through obscurity.
I believe a significant driver in the concept of
an
I think it's safe to say that if the free memory is always very large
then you can reinterpret it as 'wasted memory'.
If the free memory is alway very small, I don't think it is possible
to make any decision without know the application. It is possible
that you need to increase the shared pool
Usual caveat:
looking a v$system_event can be very misleading,
you need to examine v$session_event to determine
if anyone is actually noticing a problem.
Usual caveat 2:
A statspack report without a time interval
is almost meaningless. However, in this case,
log file
How are you deciding that you are
generating excessive redo ?
What is excessive for 1,500 concurrent
users in a banking operation ?
Using log miner to examine the problem
sounds like a very painful last resort.
Have you taken snapshots of session stats
to try and pin down any patterns to redo
Obviously you weren't listening attentively enough.
The main thing you should have gleaned from the
presentation was that if you bash an ugly squirrel
with a hammer hard enough, then
... its still an ugly squirrel
:-)
Cheers
Connor
--- Hately, Mike (NESL-IT)
[EMAIL PROTECTED] wrote:
It's a normal init.ora parameter. Why do you want to change it?
Mogens
Jim wrote:
I want to change TRANSACTIONS_PER_ROLLBACK_SEGMENT default parameters of rbs segments. but i don't know where this parameter is, how can i deal with it?
Jim
[EMAIL PROTECTED]
Title: RE: ORA-1410 Silliness
Vladimir,
Thanks for your reply.
I have tested the cursor. It does not include any bind variables.
There are no broken rowids, as all objects passed analyze ... validate structure cascade.
I also tested the scenario you describe in your code below. The code
Title: ORA-1410 Silliness
Hi
Waleed,
No. This is the name of the package.
Thanks
Lisa
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 3:04
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
I see
VIVEK_SHARMA,
Hi, can you try use raw device for those redo log files? or use
directio mode for your redo log volume.This do not need bounce your database and you
can change it on fly.
I ever hit the same problem before, and finally we modified the app to
do much
I was sensible enough to sit in the front row so I was soon distracted.
Cheers
Mike
-Original Message-
Sent: 02 January 2003 12:29
To: Multiple recipients of list ORACLE-L
Obviously you weren't listening attentively enough.
The main thing you should have gleaned from the
presentation
Oracle says this is intended behavior for desc function just more
rigorously enforced in later versions. I am still skeptical as desc works
in 8.1.6
svrmgrl. Perhaps enforced in sqlplus but not svrmgr...too many
inconsistencies.
Thanks
Rick
Title: ORA-1410 Silliness
Lisa,
This is probably nottrue ...
Oracle doesn't, has never been able to pinpoint exact line number (in
cases such as these) especially with pl/sql packages. I believe the problems can
be found by executing following query ...
select line, type, source
from
Dear all,
we use select * from tab to list all objects in a particular user in oracle.
could you tell me the equivalent query in sql server ?
Regards
Jai
That was my understanding, too. Oh, and use bigger hammers, more nails and
Australian beer.
Hately, Mike (NESL-IT) wrote:
Yes, the lessons I took from that presentation were to use a shorter piece
of string and buy larger bottles of gin though I'm willing to admit that I
may have got the
Under what circumstances is a COMMIT done implicitly?
If I call a function or procedure that performs an insert, but does not do
a commit, will a commit be implicitly performed when the function ends?
i.e. is ...
begin
INSERT INTO
... etc.
end;
the same as
Nope...
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Did u do any migration recently .
"Koivu, Lisa" [EMAIL PROTECTED] wrote:
Well, I
Title: ORA-1410 Silliness
Lisa,
I know
someone else may have suggested this, but I am thinking that maybe you do need
to rebuild the index that was being used by the query. It could be you
have a bad index that still has an entry for a record, but the record does not
exist? Sounds
Title: RE: ORA-1410 Silliness
Amount of data, definately. This table grows by ~2.5GB weekly. Have you ever seen data volume begin to cause problems?
Thanks Rachel
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 5:05 PM
To:
In
Query Analyzer select the database if interest and then run
EXEC
SP_HELP (really, this is not a joke) ;o)
It
will list system and user objects within that DB.
Dave
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 8:04
Sorry for being so vague, but sometimes I can't
help it...
It was my understanding in the Oracle7 days that
the name of thestatistic "free memory"was actuallya verb and a
noun (i.e. as in "free Nelson Mandela"or "free Willy"), and the number
shown alongside this statistic was the
Title: RE: Automatic backup on Oracle 9i -- For Jared
As far as we know there is no bandwidth limit on this list and problems can be understood better if you state them in a lucid and clear language. I had to really read twice (sorry haven't had my Great One yet) to understand the
What you are referring to is an initialization parameter that is utilized by
the mechanism of PUBLIC rollback segments. The default type of rollback
segment is PRIVATE and they ignore the parameter. You are most likely
utilizing PRIVATE rollback segments...
Do you know what problem you are
if I recall correctly, implicit commits are done
a) on a clean exit from sqlplus
b) on a clean exit from a stored program
c) if you do a DDL statement after the DML statement
but this is from memory and without checking manuals.
--- John Dunn [EMAIL PROTECTED] wrote:
Under what
Title: RE: functions/procedures and commits
No ...
an implicit commit is performed
1. If you perform any DDL statement
2. If SQLPLUS you exit without issuing an explicit ROLLBACK.
Otherwise, your transaction will remain open awaiting for an explicit commit or rollback.
Raj
Title: ORA-1410 Silliness
Is the
error reproducible if you replace the bulk insert with regular
insert?
Waleed
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003
8:14 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
John,
there is no such thing as an implicit commit within Oracle.
the only implicit commit that I know of is during a sqlplus session when you
exit the program. even this is settable by a sqlplus option.
distributed transactions that are controlled by a transaction coordinator
(like MS DTC)
Title: ORA-1410 Silliness
Lisa
I dont recollect exactly
but I think I have seen this happen when you start getting too close to the
max_open_cursor limit... something like Oracle cant open a cursor as it is at
the max limit and a fetch call might be issued..
Checkyr
max_open_cursor limit
Tom,
Correction, all DDL statements do an implicit commit.
Dick Goulet
Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date: 1/2/2003 7:09 AM
John,
there is no such thing as an implicit commit within Oracle.
the only implicit
I think you are seeing expected behaviour.
Blocks subject to tablescan are loaded in to the LRU
end of the cache, even when using a RECYCLE
cache. However, if there are free blocks in the
cache (state = 0) Oracle uses those rather than
flushing other blocks.
Consequently, when you startup and
well,
you are certainly shooting down all of the best ideas being offered!
:)
I'd
hate to be in your shoes!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003
8:19 AMTo: Multiple
Excuse
the heresy for answering an SS question on this list.
Jai,
you can fight with the INFORMATION_SCHEMA views, or use sp_help to see all the
objects for allusers(not just tables). If you looking for just
tables, and only for a given user, use
select
o.namefrom sysobjects o, sysusers
I have philosophical trouble with it. I dislike the abbreviations. I
will use abbreviations to condense phrases (lol for lots of laughs) but
I really dislike seeing you written as u. It's not that hard to
type the extra two letters.
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
As far as we
Raj - I go through episodes where I get pretty frustrated with the cryptic
language, but then I take a deep breath and remember that for some people
English isn't their first language. Also, I think text messages on cell
phones are changing the way many people deal with English.
I also get
Dear All,
I can CREATE and EXECUTE others procedures however can not execute procedure
with DBMS_SQL. I'm created procedure has parameters to create a view using
DBMS_SQL. Oracle gave me an error insufficent privileges. Can give some
hints how make it works or any example.
TIA
Truong.
SQL
Title: Message
I found this in the Oracle Concepts
manual.
Since your table is partitioned I thought it might be
worth a look.
Queries and
Partition Maintenance Operations
Queries whose execution starts before invocation of a partition
maintenance operation, or before dictionary updates
I hadn't heard the historic explanation before,
so I'll pass on that.
As far as the 16MB is concerned - I believe
the free memory includes any free space
left in the shared_pool_reserved_size.
Since the shared_pool_reserved_size defaults
to 5% of the shared_pool_size (I think) it isn't
Title: Message
did
somebody say free beer?!
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 9:44
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Free Shared pool memory
Sorry for being so vague, but sometimes I
total speculation since I'm not a PL/SQL expert -- could the amount of
data you are manipulating in the stored procedure somehow blow out
available memory?
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Amount of data, definately. This table grows by ~2.5GB weekly. Have
you
ever seen data volume
Title: ORA-1410 Silliness
Hi
Raj,
Thanks
for your reply. I always suspected that the line numbers were wrong but
since I couldn't say decisively why I had to rely upon what the gui's told me
(darn gui...) You proved it. That line is actually pointing to my generic
error logging proc.
I have never known what lol stood for , I appreciated the general meaning
by looking at the context it was used in but
know I actually know.
I knew that if I perservered long enough with this list long enough I would
find something of interest (lol)
John
-Original Message-
Sent: 02
Title: Message
Or if
you set autocommit, in which case a commit is issued every X number of
operations.
John P WeathermanOracle Database
AdministratorReplacements, Ltd.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday,
January 02, 2003
REPLIES TO YOUR QUESTIONS ARE IN CAPITALS BELOW :-
THANKS
-Original Message-
Sent: Thursday, January 02, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Usual caveat:
looking a v$system_event can be very misleading,
you need to examine v$session_event to determine
Tom,
Oracle issues an implicit commit any time DDL is performed or when a
quit/exit is issued (Complete Ref p285) or after a set number of commands by
using a set autocommit # (Complete Ref 283). With the latter is arguably
not truly an implicit commit, as you do set it, DDL most certainly is.
Title: RE: ORA-1410 Silliness
Not at this point. I believe when the pl/sql tables get too big it blows up with ora-4031 or one of the common memory errors, I've seen it happen before. I may have only a stupid windows machine, but I have so much RAM... kudos to the brilliant people who didn't
I thought lol meant laughing out loud?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 02, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
I have philosophical trouble with it. I dislike the abbreviations. I
will use abbreviations to
Excuse the heresy for
answering an SS question on this list.
When I first read that statement I was wondering
why you would be asking a question about the Nazi SS on an Oracle List
. then it dawned on me that you were talking about Microsoft SQL
Server ... at which point it did
Title: ORA-1410 Silliness
Lisa,
The answer is very, very simple...Don't take a
day off! No day off...no error...no failed
loads...
Seriously, it sounds like either an index corruption (temporary) or an oracle
bug. Is there anything in the alert log or in trace files? Try setting a trap on
R I have philosophical trouble with it. I dislike the abbreviations. I
R will use abbreviations to condense phrases (lol for lots of laughs) but
R I really dislike seeing you written as u. It's not that hard to
R type the extra two letters.
And all this time I thought lol was laughing out loud.
Hmm, English really isn't my mother tongue, but I don't like such
cryptic notations in English as well as in Latvian. It makes language
more meagre and poor. Of course I also make mistakes but these are
caused by my lack of knowledge and I can always accept them from another
people.
Gints Plivna
Donate:
Does the owner of the procedure have system privilege granted directly to
them to create a view? Not with a role , but with the system privilege
granted directly to the procedure owner. Remember, roles are disabled
inside a stored procedure.
RWB
Donate Clothes [EMAIL
Title: RE: ORA-1410 Silliness
I am no pl/sql expert either, but me think that would cause a ORA-4031 ... been there ... done that ... before I learned to code in a better way.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
Title: RE: Automatic backup on Oracle 9i -- For Jared
Thanks Dennis,
It isn't my first language either (I started learning English in the 5th grade in India). I have seen this language before, and like Rachel said, it is more of a philosophical trouble.
I used similar language in
Title: RE: create view using DBMS.SQL
Is the create view privilege granted to the procedure owner?
-Original Message-
From: Donate Clothes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject: create view using
Tom,
I must respectfully disagree. Explicit = a COMMIT or ROLLBACK is
explicitly issued by the user/program. Implicit = a COMMIT or ROLLBACK is
performed as the result of an action and not issued by the user/program.
The SQL*Plus options AUTOCOMMIT and COPYCOMMIT do not control
Hello,
How does Direct grant access differs from an access
thru a role? and *WHY*?
Thanks.
OraCop
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ:
Title: RE: ORA-1410 Silliness
Lisa,
try to see if you can (I think you should) use
dbms_session.free_unused_user_memory ... this is very handy for
applications where large pl/sql tables (oops ... arrays) are used
frequently.
Raj
__
Title: RE: Free Shared pool memory
Tim,
I am pretty sure you are aware of Metalink note 100666.1 where it says that the free_memory value is unreliable if shared_pool_reserved_size is a non-zero value. Bug# 370903 ..
BTW This is what it is on 9202 ...
oraclei@elara-NCS1 sys
SQL*Plus:
Well, I understand that writing you is not much
trouble compared to writing U, but understanding
U, should not be much trouble either. Don't U think
so?
OraCop.
--- [EMAIL PROTECTED] wrote:
I have never known what lol stood for , I
appreciated the general meaning
by looking at the context it
Title: RE: create view using DBMS.SQL
ummm directly?
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have
The SHARED_POOL_RESERVED_SIZE is indeed defaulting to
15728640, which is 5% exactly of SHARED_POOL_SIZE...
The reserved area is subtracted from the Shared Pool, so
subtracting that amount from the difference still leaves
765,848 bytes. As a number, that doesn't divide by any of
the powers-of-2
Although I hate to make my first submission to The List in 2003 as
negative one, I would still like to suggest that text messages have no
place in a forum such as this. Quite apart from being needless, such a
message format shows a total lack of respect for the recipient and a
distinct arrogance
Even though i strongly think that there is nothing
wrong in writing U instead of you, respecting your
feelings towards the list, and considering the fact
that we must think above such small matters, I will be
careful in future.
Thanks.
OraCop.
--- Martin Kendall [EMAIL PROTECTED] wrote:
lol = laughing out loud
lots of luck, lots of love, lots of laughs, little old lady.
I will stop here now
:)
Richard Ji
-Original Message-
Sent: Thursday, January 02, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I thought lol meant laughing out loud?
Tom Mercadante
Oracle
Yes,
that's correct. That is what the error message says. Anyone have any
idea why it's trying to use LDAP to resolve the database link? I thought
with my sqlnet.ora file set to use tnsnames.ora I'd be using my local files to
resolve the service name. Any suggestions as to why it's trying
Don't forget a lot of people uses PDA or wireless devices which
has limitations on how many characters can be trasmitted. SMS for instance
allows only 160 characters.
Now why would someone write from such a device to ask an Oracle question
is beyond me. Perhaps all the machines are down? :)
Title: NVL and index usage
Does anyone know off hand if using NVL on an indexed column negate use of an index in CBO? This is 9202 ... and the column will be a varchar2(1).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
List:
We have a Red Hat Linux release 7.1 system with 8.1.7.0 installed. We're encountering the memory leak bug
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin dbms_output.disable; e...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
I need to upgrade to at least 8.1.7.2
Jonathan Lewis,
Hi, lewis,have you ever see any big system with large shared pool
size? This week I saw a mobile telecom system running ops 8163, have 8GB sga, with 3GB
of shared_pool_size and About 5GB of data buffer.(Physical memory is 16GB)
I never configured
Title: RE: create view using DBMS.SQL
Right. Forgot that...
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02,
2003 12:19 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: create view using
DBMS.SQL
ummm directly?
How does this grab you?
FTLP show sga
Total System Global Area 2.2596E+10 bytes
Fixed Size 103396 bytes
Variable Size1120354304 bytes
Database Buffers 2.1475E+10 bytes
Redo Buffers1064960 bytes
Got a bad application? Throw more hardware at
Title: RE: ORA-28030: Server encountered problems accessing LDAP directory service
Yes. This was indeed the case. I was using
"current_user" to create the link. I just dropped and re-created the link
using an named user account and the link works fine now. Thanks for the
quick response!
Maybe it's time to bring back all those Morse code Q abbreviations with
appropriate adaptation to IT industry. Instead of QRO meaning increase
your power, it might mean Here's a nickel kid, get yourself a better
computer.
I don't think you will ever see QRP used (reduce your power).
Title: RE: ORA-1410 Silliness
Thanks
again Raj. I will definately look into it.
Lisa
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02,
2003 11:39 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-1410 Silliness
To ALL,
We'd like to establish a centralized stats pack repository, but OTS is
telling us that it's NOT doable for a couple of reasons. As you can guess I
don't believe them and am looking around to see if anyone else has done this
before I break out the power tools and start building
Dear whateveristhenamebehindyourstrangealias,
I'm not - I really am not - trying to be impolite, but have you looked
this up in the Oracle documentation? I beleive it's all nicely explained
there.
Correct me if I'm wrong (in other words: A more specific question ...)
Best regards,
OraFlop
Title: NVL and index usage
In a quick test on 9013 it changed the index which
it was using and went from Range scan to fast full scan.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 02, 2003 9:48
AM
Title: Message
The
behavior of this may have changed... but I have seen autocommit not work as
advertised. Just my opinion but I think explicit commits are good
practice, if nothing else just for ease of reading code.
Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259
It won't be able to use the index as far as I know. Unless it's a functional
index ;).
Mogens
Jamadagni, Rajendra wrote:
NVL and index usage
Does anyone know off hand if using NVL on an
indexed column negate use of an index in CBO? This is 9202 ... and the column
will be
Title: RE: NVL and index usage
Thanks ... the development is rolling out a new change by adding a new nullable column to a table and adding following to all appropriate queries ...
and nvl(new_column,'A') = nvl(some_value,'A')
I learned of this few minutes ago and luckily they are
Title: RE: Centralized StatsPack Repository
I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db.
Raj
__
Dnt knw wht al the fss is abt.
Why nt just drp al th vwls? V cn al undrstd tht cn't
v? ;-)
mhmd
--- OraCop [EMAIL PROTECTED] wrote:
Well, I understand that writing you is not much
trouble compared to writing U, but understanding
U, should not be much trouble either. Don't U
think
so?
I'm probably telling you guys something you already know, but at least
it gives me a chance to write something on the list...
Notice that the show sga command output doesn't contain a line saying
shared pool size, but instead says variable size. That's because
it's the size of the variable
Lighten up Frances
-Original Message-
Sent: Thursday, January 02, 2003 10:46 AM
To: Multiple recipients of list ORACLE-L
Although I hate to make my first submission to The List in 2003 as
negative one, I would still like to suggest that text messages have no
place in a forum such
So it seems like my problem is the full table scan. Craig Shallahammer mentions
this in his All About Oracle's Touch-Count Data Block Buffer Algoithm paper - The
modified LRU algorithm places full-table scanned blocks read into the buffer cache at
the LRU end of the LRU chain and only
Dan,
I agree with you and I think I said the same thing - though not as lengthy!
:)
As you said, the Sql*Plus AutoCommit option controls issuing a commit upon
exiting the program.
As I said in a prior mail, I did not mention DDL forcing an implicit commit
as the question pertained to INSERT
I can create view in schema. I don't know why it is not allowed me to
create view in DBMS_SQL within procedure. Do I need additional privilege.
Please give me some hints. TIA Trung.
SQL create or replace view mytest
2 as
3 select * from tbl_file_definitions;
View created.
SQL select
I have an opportunity to attend a Hotsos Clinic. It seems I have heard good things
about them on this list, but I thought I might double-check. Is this 3-day class
worthwhile or is it an expensive way to sell their product? Will this class be
beneficial, even if we don't buy their product?
Title: RE: Automatic backup on Oracle 9i -- For Jared
Well if you want an answer from the experts on this list (or anyone, really - I fall into the 'shmo' category) it's best to ask a question in the clearest way possible... otherwise your emails may go directly to the delete folder.
Ur
If you mean
where nvl(col,:x) = :y then yes it will be negated.
If memory serves, I've even had problems in the past
using nvl in a function based index, the workaround
doing the equivalent with decode, but I can't remember
the specifics
hth
connor
--- Jamadagni, Rajendra
[EMAIL PROTECTED]
Lisa
. I've read some messages of this thread -- there is 100% probability :)
that you incorrectly identified the statement which errors 1410.
PL/SQL engine could not point to the line 1970 -- it's in the middle
of the statement -- something is strange there. Do you handle exceptions
in your
Bailey,
I can create a view. I don't know why it not allow me to create view using
DBMS_SQL within Procedure. Can you give me one example system privilege
granted directly to them to create a view? Thanks Truong
SQL create or replace view mytest
2 as
3 select * from
It reminds me the text I have read few years ago, maybe even posted to this
list:
http://www.ahajokes.com/eng011.html
BTW Personally I am on the philosophical side - use common abbreviations
like BTW, ROTFL, etc but don't like the U, 4U, etc.
But who knows what the future brings, especially with
It is often the case that Telecomms companies
end up with a very large SGA. 3Gb does sound
a little suspicious - but it would be silly to judge
it without knowing more background, such as
total number of users, number of applications
embedded within the database, number of CPUs,
nature of work,
Brain was clearly not engaged when I wrote the
last answer - I have a set of results I produced
some time back when calibrating init.ora parameters
with memory usage. (Out of date by now since it
was 8.0).
Simple test:
Double the size of sessions in the init.ora,
various entries in
Title: NVL and index usage
Raj,
the
index will not be used.
think
about it.
for
those records that do not have a value (are null) for the indexed column-
there is not an entry in the index - so they can not be evaluated to return a
row.
secondly, even if all rows were represented in
1 - 100 of 165 matches
Mail list logo