And if you are running an unavowable OS, you can probably turn your
SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job.
Weaver, Walt wrote:
Cron? At?
-Original Message-
Sent: Monday, January 28, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L
Hello,
Title: LOB Help needed
Hi,
Has anyone any document about implementation of Lobs/BFILES using Oracle Developer 6/6i as front end tool. Manulplating LOBs within the database is not a big problem, but getting them out to display it is what I need. I have found a doc which explains the
Foelz.Frank wrote:
TNX for your answers.
What I need is exactly what Oracle doesn't support. Logging who changed
what in a
special area of our database.
I think triggering the events will be much more specific and more easy to
change.
In case all our applications use the same
Amen!
-Original Message-
Sent: 29 January 2002 06:20
To: Multiple recipients of list ORACLE-L
The problem is that if you always ask the group for help, you never learn
where the information is within the manuals or other reference documentation
and the group also gets cluttered with
When I arrive in the morning to a mailbox containing 150+ messages from this
list, I'm almost certainly guaranteed that 10% of them will be questions
that can easily be found via otn or a manual. That 10% usually comes from
the same person!! No wonder I'm irritated!!!
}:o|
-Original
I was also trying to put some script on Oracle scheduler and successful too.
But on Oracle 8
I failed. It was successful on Oracle 8i (8 doesn't support execute
immediate). Would appreciate,
if someone can give equivalent code for Oracle 8.
Here is the code for Oracle 8i,
create or
because DUDE! see my earlier explanation! I ask colleagues if I can't find
it in the manual...such is the joy of the internet...the pages are
bookmarked and are therein front...on my screenwhere I need them!
It's not rocket science!
-Original Message-
Sent: 29 January 2002 03:55
u can also create batch file
if os is windows
e.g. t.sql as
set serveroutput on;
select * from tab;
exit;
put this in some batch file
eq bb.bat
sqlplus fxsam/s@du @t
and schedule bb.bat
-Original Message-
From: Stephane Faroult [SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 28,
Rajesh Dayal wrote:
I was also trying to put some script on Oracle scheduler and successful too.
But on Oracle 8
I failed. It was successful on Oracle 8i (8 doesn't support execute
immediate). Would appreciate,
if someone can give equivalent code for Oracle 8.
Here is the code for
Bill,
I think u have some hung shared memory segments which need to b cleaned up
before u can start ur instance. Do the following :
At the Unix prompt, type :
$ ipcs -mobs
Then identify the segment id which has Owner = Oracle and Nattch = 0.
Remove that segment using the following command :
I am trying to save a report at runtime in PDF format.
I am getting the error REP-1249 : Column '...' has no pl/sql formula.
I have Report Builder 3.0.5.8.0
Help.
Nilesh P Shah
[EMAIL PROTECTED]
Phone No : 570 44 91
Ext : 6575
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Hear hear ! You tell 'm, Kevin ! I'm with you all the way.
Anybody can ask me a simple question when they are looking for a quick
answer, but you can't do a good job when you're always looking for quick
answers. You have to LEARN. There's a difference between learning and
constantly asking
Hi ,
I copied jay's line for duplication until time exactly into my test script
but recovering errors out in the end.
I looked in the documentation for another example of the until time clause
but no luck. Can anybody explain why this won't work.
(the double single quotes to which it
triggers -- that do an insert into an auditing table. Been there, done
that:
Insert -- add a row to the auditing table of all the new values with
one extra column type =I
Delete add a row to the auditing table with all the old values and
type=D
Update -- add two rows to the auditing table --
Thanks Stephan,
Your suggestion had motivated me and I wrote the code,
after RTFM.
Sameer,
I didn't scheduled the job on OS because this should an Oracle Job,
log switching has nothing to do with OS (you don't trouble a company
GM when the work should be done by a Normal Manager
I have seen something like this with application loop
that open a new cursor for each iteration of the loop.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 11:15 PM
To:
http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-%
20HOWTO.htm
have fun,
Marin
...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to
Hello Ron
I checked our 7.3.4 DB (on NT) and did not find these tables.
I think that they may belong to a product that use these tables and
so everyone who uses this product need them.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Smith, Ron L.
Hi DBAs,
Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client
A list member sent me a pl/sql script for sending mail. It compiles ok when
I run it I get the following error
class oracle/plsql/net/TCPConnection does not exist
Any ideas on how to correct this? I do not know if I have to do
Hello Jack
The RMAN commandrecover database;
is changed to be recover database until time '1999-03-05:11:33:00';
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 29, 2002 12:15
Hi!
We inherited one Informix database, which we must put into our production
Oracle database (new schema). Both databases are on AIX UNIX machines.
We can do this by writing a scripts, but I'm wondering does any of you have
some experiance in this, and could you suggest me some other (simpler)
[EMAIL PROTECTED] wrote:
Hi DBAs,
Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client
A list member sent me a pl/sql script for sending mail. It compiles ok when
I run it I get the following error
class oracle/plsql/net/TCPConnection does not exist
Any ideas on how to correct
Cant' believe that !!!
-Original Message-
Sent: Tuesday, January 29, 2002 4:35 PM
To: Multiple recipients of list ORACLE-L
http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-%
20HOWTO.htm
have fun,
Marin
...what you brought from your past, is
Hi Thomas,
AFAIK this is generated code (by RMAN) based on the command duplicate that
I issued. I sure didn't store any script yet. This is the next step when
all secrets of RMAN are uncovered (than it's time to move to RMAN 9i)
Jack
Mercadante, Thomas F [EMAIL PROTECTED] on 29-01-2002
Roland,
Besides reading the manuals, take a look at www.lazydba.com. They also
host an Oracle email list that might be a more appropriate forum for
your questions. I think they have a higher ratio of new DBAs on their
list, and seldom mind answering the beginner questions.
HTH,
Beth
(was
Sonja,
Start here: http://otn.oracle.com/tech/migration/workbench/content.html
...JIM...
[EMAIL PROTECTED] 1/29/02 7:20:33 AM
Hi!
We inherited one Informix database, which we must put into our
production
Oracle database (new schema). Both databases are on AIX UNIX machines.
We can do this
'dbms_output.put_job '?
What the heck was this about?
Please, check your answers before posting to the list!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 12:50 AM
Well, you
And you shouldn't...
This is just a web trick - I mean it's not a Microsoft's site. You can
see the same page, loaded even faster, if you remove:
www.microsoft.comitem=q209354@
from the url. Just try:
http://hardware.no/nyheter/feb01/Q209354%20-%20HOWTO.htm
You can replace in the url
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Hi DBAs,
Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client
A list member sent me a pl/sql script for sending mail. It compiles ok when
I run it I get the following error
class oracle/plsql/net/TCPConnection does not exist
Any ideas on
Hi Sonja,
I would recommend you look at the oracle migration workbench product.
John
[EMAIL PROTECTED] wrote:
Hi!
We inherited one Informix database, which we must put into our production
Oracle database (new schema). Both databases are on AIX UNIX machines.
We can do this by writing a
Hi, Rick
I'm not 100% sure, but it I think, the problem is Server/JServer
version. The script will be OK on 8.1.7. 8.1.7 JVM is very different
from 8.1.6
HTH
Vadim
-Original Message-
Sent: Tuesday, January 29, 2002 8:15 AM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
Oracle
I'm lost here...
--Walt
-Original Message-
Sent: Monday, January 28, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L
Well, you can check the manual but use the package dbms_output.put_job that
willfix it when you are inoracle but ifyoua re
in unix environment you must use
Kevin, I am sorry, but you didn't sound holier
than thou on that last post. Could you do it
a bit differently next time? ;-)
WWJD? JWRTFM!
-Original Message-
Sent: Tuesday, January 29, 2002 9:10 AM
To: Multiple recipients of list ORACLE-L
Hey I've helped this guy heaps of
There is a tool from DataBee that is used to copy integrated data
from production to test (among other things).
Maybe you can use it to copy ALL the data from one DB to the other.
http://www.databee.com
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From:
beginner should start with RTFM, trying it on test box, and only than, if
he still does not get it, post his question explaining his problems.
Beth, you must not have seen Roland's questions.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
Hello all:
We have an application that is having slow response time against an 8i
database, I would like to improve the response time. This is a web based
application accessing the database with about 2000 users. Most of the
application queries are based on complex joins on 4 big tables with
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote:
Update -- add two rows to the auditing table -- first with old values
and type = O
second with all the new values and type =N
Rachel,
I don't think you need two rows for updates. The old values
will be in the audit table, the new
Nah it is a URL trick you need to discard everything between
HTTP:// and first @ sign. The browser does it too.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Voting him off the island... uh? ;-)
-Original Message-
Sent: Tuesday, January 29, 2002 7:45 AM
To: Multiple recipients of list ORACLE-L
Roland,
Besides reading the manuals, take a look at www.lazydba.com. They also
host an Oracle email list that might be a more appropriate forum
One of the neat tricks how to that is described in Tom Kyte's book in
the chapter about UTL_HTTP.
-Original Message-
Sent: Monday, January 28, 2002 6:55 PM
To: Multiple recipients of list ORACLE-L
Some of you may find this of interest:
http://www.total-knowledge.com/progs/ora_mail/
Walt, don't worry. He's speaking WaReZ speak. You have to
follow the White Rabbit to get out.
For further instructions, see Kimberly. She enjoys questions like these.
-Original Message-
I'm lost here...
--Walt
-Original Message-
Sent: Monday, January 28, 2002 10:50 PM
To:
Tom Kyte's Expert One-on-One Oracle or whatever it's called is the best
book written ever on Oracle. Reviewed by Jonathan Lewis and Steve Adams.
Jonathan says it's the best book on the market, including his own. Very useful
for developer types, too. As to specific Forms/Reports books I have
Hello,
Env: 8.1.6 on Solaris 2.7
Does anyone know which data dictionary table stores the setting
when you issue an ALTER USER user_name DEFAULT ROLE ALL COMMAND?
I know that dba_role_privs has a default_role (YES/NO) field, but
that is specific to each role. Is there another table that stores
Title: RTFM questions (formally RE: PL/SQL)
No offense to
anybody, butI think this is rather arrogant. The list is for anybody
(unless the list owner decides it's just for experienced dba's). I am brand new
to Oracle, having just started learning it this week. I can easily foresee
having
Ross Mohan tried to pull this one on us before.
C'mon Ross 'fess up.
Is this your handywork?
-Original Message-
Sent: Tuesday, January 29, 2002 9:20 AM
To: Multiple recipients of list ORACLE-L
Looks like good old MicroSlop got hacked, again!!
Dick Goulet
PS: I love it!!
Jared,
I just put the old values in the audit table with an additional column which
tells exactly which columns are changed. Ah the wonders of dynamic sql ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
Is there some other reason for saving both in the audit table?
Jared,
You must be right.
But, if for some 'crazy' reason primary key of the record gets modified,
then you need both old and new in audit table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
LOL...where's me soapbox!! I'm having a bad week, and hot-dang if everyone
else ain't gonna suffer to!! ;o)
TFIC!
-Original Message-
Sent: 29 January 2002 14:50
To: Multiple recipients of list ORACLE-L
Kevin, I am sorry, but you didn't sound holier
than thou on that last post. Could
You have done very nicely so far in tuning those joins... but...
More questions to you :
1. Why do you think this is still a database problem?
2. Will partitioning those larger tables help the queries?
3. What have you checked to make sure that the bottleneck is not the
web-server?
4. Are
ALWAYS BACKUP THE ROLLBACK TABLESPACE!
or you will not be able to recover. How else will Oracle
rollback a transaction in the works when the database went
down.
I do not back up TEMP or my INDEX tables spaces. I have
scripts that recreate all of these. (150GB of indices, not
worth the
Has anybody heard of/used/liked/hated NetSaint? One of our
UNIX administrators is pushing this as a cheap alternative to
CA UniCenter, and he wants to start using it to monitor systems
and databases.
Please let me know your opinions, thoughts, and locations of any
resources you are aware of.
Thanks, Connor. Oh, did I enjoy the Master Class this past week. A couple
of situations:
14 people, including Millsap, Steve Adams, Jonathan Lewis, James Morle and
what have you sitting around my oak table one evening when dinner is served.
Most of the guys simply closed their laptops,
Look here:
http://technet.oracle.com/tech/migration/toolkits/content.html
-Original Message-
Sent: Tuesday, January 29, 2002 8:21 AM
To: Multiple recipients of list ORACLE-L
Hi!
We inherited one Informix database, which we must put into our production
Oracle database (new schema).
Has anyone read 'Oracle8i for Dummies' ??
I have checked it out from our local public library
It's not a bad read, I am still in chapter 1, though.. learning some new
interesting analogies to this techie stuff..
- Kirti
-Original Message-
Sent: Tuesday, January 29, 2002 8:55 AM
Log file sync is another name for commit. So have fewer commits or
make them faster is the extremely short answer. But these values are
taking out of context - if the time_waited for log file sync is small
compared to the total response time, then who cares? :).
Mogens
Seema Singh wrote:
Kirti,
Too much time on your hands?
Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA'
sign?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 11:05 AM
Has
Title: RTFM questions (formally RE: PL/SQL)
JoJo...
You're missing the point... Most people have no issue with helping another
list member... But, some members abuse this help and consistent ask
questions that could be found in the manual without even attempting to find
it... The list
Seriously though...
You would of course get as much help as the next person here and I don't
think it's out of place for me to say that newbies are always welcome! But
it starts to get ridiculous when a poster continually posts questions that
can be found on websites similar to your own without
Well.
I've done it several times, ie modify the exutab or exu7tab or whatever
view to do something special like exporting all tables except ... or
export of a tablespace (!), etc. As long as you modify the export views,
run the modified catexp, do the export, then re-run the original catexp
AFAIK, Kimberly does everything. (Except move to Dallas)
-Original Message-
Sent: Tuesday, January 29, 2002 11:41 AM
To: Multiple recipients of list ORACLE-L
Kewl! That means I get to start taking drugs again.
I am a happy boy. I'll whiz over to the OT list and give Kimberly a
So true!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 10:05 AM
Igor Neyman wrote:
'dbms_output.put_job '?
What the heck was this about?
Please, check your
Hi List,
One of our developer using function in his select statment but the problem
is when he is using order by one of the function results column the query is
very slow, Is there any way to use hint for function or some thing to make
quesry faster.
Thanks in advance
Hamid Alavi
Office 818
Title: RTFM questions (formally RE: PL/SQL)
yep,
but a lot of us I am sure do not have time to answer these types of questions
whilst holding down a full time job.
I
think this has gone a bit far anyway and I am sure Roland has been suitably
chastised and even said himself that he went out
And your point caller??
TIC ;o)
-Original Message-
Sent: 29 January 2002 15:41
To: Multiple recipients of list ORACLE-L
No offense to anybody, but I think this is rather arrogant. The list is for
anybody (unless the list owner decides it's just for experienced dba's). I
am brand new
Kewl! That means I get to start taking drugs again.
I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring.
Does she like to climb mountains?
-Original Message-
Sent: Tuesday, January 29, 2002 8:25 AM
To: Multiple recipients of list ORACLE-L
Walt, don't worry. He's
Hamid,
Why not create a function based index on the column that is being and
the data returned will be faster. I do not know if it will help the sort
for the order by but the data returned will be available faster. What
does your sort area look like? Is it to small to handle the sort and
paging
Title: RTFM questions (formally RE: PL/SQL)
JoJo,
There is a difference between 'unable to find the answer' and
'not willing to find the answer through RTFM'.
BTW, I didn't see any 'stupid or RTFM' kind of questions from
you (unlike this other person).
Igor Neyman, OCP DBA[EMAIL PROTECTED]
Hi Ron...
I found some info in the reference guide...
PSTUBTBL
This table contains information on stubs generated by the PSTUB utility so
that an Oracle Forms 3.0 client can call stored procedures in an Oracle
database.
Title: RE: Database Performance Question
Partitions, Materialized views, bit map indexes.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Database Performance Question
We're using NetSaint here. Does the job for us, and it's a bit cheaper than
CA Unicenter...
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Tuesday, January 29, 2002 9:12 AM
To: Multiple recipients of list ORACLE-L
Has anybody heard of/used/liked/hated NetSaint? One of our
We have problem with oracle process ora_snp0 that causes high CPU and core
files on our system. Does someone have idea how to fix it? Please help.
Below is information captured from a trace file:
Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc
Oracle8 Enterprise
Last week I posted the note below about installation problems we were
experiencing. The Oracle installer just failed with no message. We have
solved to problem and thought I would share the solution with the list.
The installer was looking at a file
'/usr/var/opt/oracle/orainst.loc',
This is supposed to be BUG# 1260358 and fixed in 8.1.6.1, but I can't find
any info on that BUG...
You may want to try to execute the $ORACLE_HOME/rdbms/admin/iniplsj.sql
script as user SYS. This is normally called as part of initjvm.sql, but
some releases skipped it. If I remember correctly,
Hi,
As a alternative to TNG we tried that product, as a technitian i like the
product and will again push it ;), but as a manager i wont go for that
product cause of managability and scalability, TNG is very scalable and
netsaint is not that much. just ask him who manages if he leaves (They
Does anyone have any experience with Brio, Cognos, or any other Business
Intelligence Suites? If so,what are some pros and cons of them?
I have looked at Oracle's data mining suite, but it looks like it
requires heavy development to deploy reports and tools(We don't have an
in-house Java
Send them doggies home, KD, it's a done deal.
;-)
-Original Message-
You may turn the trace on or off that way, but how do you interrogate it to
find its event settings?
- Kirti
-Original Message-
Sent: Monday, January 28, 2002 6:42 PM
To: 'Deshpande, Kirti'; [EMAIL
That may indeed help, if you're very lucky. However forcing it to use that index
could also result in an inefficient query path.
Another possibility, also with drawbacks, is to have a materialized view which
contains the function results as a column of the view.
Ian MacGregor
Stanford
Oracle Designer will create journal tables, and the triggers to
populate them. It might be worth capturing your DB design in Designer
and using this feature (of course, I'm sure Designer isn't cheap, so
that's a consideration as well). You'd gain the benefit of having your
design stored in a
Kirti - I haven't read that book, but I haven't seen a bad book in the for
Dummies series yet, so I would imagine it is pretty good, especially for
beginners. Maybe after you have gone through it you can let us know your
opinion, especially whether it is more for beginning Oracle developers or
we use big brother, free and it works. not sure of the others you mentioned. i've
been forced to use ca-unicenter before and its not worth 1% of what they charged.
basically it sux :)
[EMAIL PROTECTED] 01/29/02 11:12AM
Has anybody heard of/used/liked/hated NetSaint? One of our
UNIX
Hi,
On 8.1.7.2 (soon to be .3) on HP/UX 11.0, a developer needs to get the top
parent associated with a lower level row. Expanding on Oracle's EMP
example:
EMP MGR LEVEL
King1
Greenberg King2
Faviet Greenberg
Hello all
We are designing a new application.
This application stores files that were FTP to the clients
and keep then for resubmitting (if the user ask for them).
There are two formats:
1) Standard records whose internal format is known.
These files lets the user ask for a subset of the
Igor,
It's a good night-cap :)
However, I can use a sign like that, considering what we are going through
lately.. Implementing a HUGE system converted to access Oracle RDBMS.
Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4
copy-book routines that are called from
Title: RE: Database Performance Question
Parentitions and
Maternalized Views are supposed to come out in 10i.
(Paternalized
views take longer, they required retrofitting onto the
kernel
command tree.
)
-Original Message-From:
Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Sent:
On Tue, Jan 29, 2002 at 08:12:05AM -0800, Vergara, Michael (TEM) wrote:
Has anybody heard of/used/liked/hated NetSaint? One of our
UNIX administrators is pushing this as a cheap alternative to
CA UniCenter, and he wants to start using it to monitor systems
and databases.
Please let me
make sure you are not using any function like upper lower ... as part of the select
statement. If yes then by creating function based index will improve the performance
dramatically.
[EMAIL PROTECTED] 01/29/02 10:35AM
Partitions, Materialized views, bit map indexes.
-Original
Kirti:
Thanks for the insight.
Here are my Answers:
1. I feel database is the problem because when only a subset of the total
data is used the performance is excellent (with one tenth of the total
data). The no. of users are the same. Only amount data that is retrieved
is enormous (almost 10
I guess this is still on topic eh?
LoL.
-Original Message-
And your point caller??
TIC ;o)
-Original Message-
Sent: 29 January 2002 15:41
To: Multiple recipients of list ORACLE-L
No offense to anybody, but I think this is rather arrogant. The list is for
anybody
For Oracle 8i use functiion based index.
Thanks,
Ashoke
[EMAIL PROTECTED] 01/29/02 10:05AM
Hi List,
One of our developer using function in his select statment but the problem
is when he is using order by one of the function results column the query is
very slow, Is there any way to use hint
You may want to look at using materialized views. They are easy to setup
and can be refreshed manualy or automaticaly.
Thanks,
cj
SRAJENDRAN@nlf
Title: RTFM questions (formally RE: PL/SQL)
There
is a good faq website listed at the base of each email sent to this list. Add to
that *every* Oracle manual (authored by Oracle) is hosted in both pdf and (some)
html format on the Oracle Technet site
Title: RTFM questions (formally RE: PL/SQL)
Hi
Ken...
Do they have an internet connection?
http://docs.oracle.com
or
http://tahiti.oracle.com
It
goes a long way... And, as I mentioned in my other email... This person
has been pointed at the exact manual on numerous occasions but
How many rows are you bringing back from a typical query, how good is the
best filter condition and are you filtering that first before joining to the
other tables in the explain plan?
What is the query and explain plan?
Iain Nicoll
-Original Message-
Sent: Tuesday, January 29, 2002
What ring are you going to give to Kimberly? :-)
-Original Message-
Sent: Tuesday, January 29, 2002 11:41 AM
To: Multiple recipients of list ORACLE-L
Kewl! That means I get to start taking drugs again.
I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring.
Does she
Hi Folks!
I'm in the middle of an 11.5.5 upgrade. Now, if you've done that type of
thing before, you know those suckers just run forever, and if you leave it
running overnight, you generally come in the next day to find that things
failed overnight. Well, that's where I was. I left this
FYI,
http://www.theregister.co.uk/content/4/23852.html
They seem to have decided that iFS is not a bad idea, and they will
integrate it into their future OS.
Same strategy as for Novell's NDS and the Windows Active Directory in
Windows2000.
A Netscape equivalent into Windows95.
OS/2 HPFS
What job(s) are you running?
and if you strings core | head -40, what do you get?
Inquiring Minds want to know,
etc.
-Original Message-
Sent: Tuesday, January 29, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
We have problem with oracle process ora_snp0 that causes high
Will do..
- Kirti
-Original Message-
Sent: Tuesday, January 29, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L
Kirti - I haven't read that book, but I haven't seen a bad book in the for
Dummies series yet, so I would imagine it is pretty good, especially for
beginners. Maybe
Okay ...
does anyone know what are Microsoft's own inventions?
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
Here you go...
1) Find the OSPID for the suspected user (other than pmon, smon and their
famiy)
select s.username, p.spid
from v$session s, v$process p
where s.paddr = p.addr;
2) Use oradebug to connect to that spid (here I have 26073, and the session
was tracing event 10046)
SVRMGR
1 - 100 of 188 matches
Mail list logo