Hello All,
OS: Solaris
DB: Oracle
Can somebody tell me how to know in what version or
patchset level the oracle home is ?
when I go and see in $ORACLE_HOME, I couldn't find
whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some
other.
How to know exactly at which version the $ORACLE_HOME
is?
Hi All,
Is there a way to just flush out a single sql stement
from shared pool.
Alter system flush shared_pool; will flush whole pool.
I want to find out exact time a select statement is
taking for execution.
when i first executed, it is taking 15 seconds, and
the 2nd time, as all of you know
Hi
All
I am
recreating the database from cold backup. But I am facing the following
problem
Oracle
version : 8.1.7
Environment : HP
SVRMGR CREATE CONTROLFILE REUSE SET DATABASE
"HTK443M8" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 8
two
functions versus one maybe
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003
7:34To: Multiple recipients of list ORACLE-LSubject:
Slow queryDear
all, Please find below the 2
queries : select dep_date from
test_date1
Which version of Oracle ?
The second query has to do a trunc() and a to_date()
on every single row. The first only has to do a to_char
on every single row. There is a CPU difference between
the two queries and if you run the execution plan through
v9 with cpu_costing, you will find a
Dear all,
Please find below the 2 queries :
select dep_date from test_date1
where to_char(dep_date,'dd-mon-') =
'12-jan-2002'
select dep_date from test_date1
where TRUNC(dep_date) = to_DATE(
'12-jan-2002','dd-mon-')
The execution plan for both the queries shows a FTS
on test_date1.
From sql : select * from product_component_version;
It can either be shown when logging into sqlplus (check the headers).
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 05,
So the obvious question:
What is the db_block_size and what is the size in bytes of
/oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from
backup?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote:
I am recreating the database from
hello,
Triggers were created in a user where synonyms of tables of other
user s were existing. So i have to change owner of the trigger to
the owner of the tables. Is it possible to change without dropping
the triggers and recreating them.
Thanx,
Sudhakar
--
Please see the official
Hello
all,
I wanted to know
how to write scripts in PL/SQL. i mean how to start it ? directly write htem in
sql SQL prompt itself ?
and any good sites
on PL/SQL to learn ?
Thanks and Regards,
Santosh
select banner
from sys.v_$version;
will give u the version number
santosh
-Original Message-
sreenivasa
Sent: Wednesday, March 05, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Hello All,
OS: Solaris
DB: Oracle
Can somebody tell me how to know in what version or
patchset
Hi
We are not a Unix shop and would like to build a test setup of 9iRAC on
windows at the cheapest price.
I have a document that explains how to do it using SCSI disks but the parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does
You can enter them directly at the SQL prompt or you can store them in
database or keep them in files and run them with the @ command.
The choice is yours :O)
K.
-Original Message-
Sent: 05 March 2003 08:50
To: Multiple recipients of list ORACLE-L
Hello all,
I wanted to know
Title: Geneva application
Hi,
I wish to hear from those that have been administrating Oracle instances of Geneva billing application.
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
Use keyboard!
:-)
Use any text editor like vim or scite (synatax coloring is better) to write
you script and save it to the file.
Then run your script from sqlplus prompt
(sqlplus:@/home/...path and name of your file).
JP
On Wednesday 05 March 2003 09:49, you wrote:
Hello all,
I
Title: RE: 9i OCP Upgrade Exam - Again
That
would let the account see ANY table in the database, wouldn't
it?
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003
6:05 PMTo: Multiple recipients of list ORACLE-LSubject:
i am getting the
following error when i give the select statement..
what could be the
reason ?
SQL select
utl_http.request('http://www.orafaq.net/') from dual;select
utl_http.request('http://www.orafaq.net/') from
dual *ERROR at line 1:ORA-06510:
PL/SQL: unhandled user-defined
A small follow up question:
Why will oracle do a to_date() on second query for each row returned, as the
date mentioned is a literal and doesn't change for the duration of the query.
Won't it be calculated once and used for all the rows with trunc() applied to
each row?
Regards
Naveen
Hi gurus,
Is there any Oracle tools available to use it in
Handheld Computers.(like PDA or IPAQ)
Thks in advance
Title: 8i databases under 9i listener?
RS6000 running AIX 4.3.3. We are experiencing the following issues with
our 8.1.7.4 databases under a 9.2.0.1 listener.
1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when
attempting to open a file.
2) Database links from
Aside from docs at technet.oracle.com, a perfect book for you is Beginning Oracle
Programming, authored by Sean Dillon, Christopher Beck, and Tom Kyte. (ISBN #
1-861006-90-X)
This book sells for around $50.00 in the U.S., but it is one of the most useful books
I ever purchased.
Darrell
Sulatan,
Have a look at xb.com. There is something called PocketDBA.
KG
--- Sultan [EMAIL PROTECTED] wrote:
Hi gurus,
Is there any Oracle tools available to use it in Handheld
Computers.(like PDA or IPAQ)
Thks in advance
=
Have a nice day !!
Checkout Oracle Lite
Babu
Sultan
Jack,
www.tusc.com has a white paper that created a RAC with firewire and
RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and
presented at the SEOUG Conference last month.
Ron
[EMAIL PROTECTED] 03/05/03 06:34AM
Hi
We are not a Unix shop and would like to build a test
Hi.
i need some help. i'm trying to get a stored procedure source code from
the database.
After a lot of reding i found :
select * from user_objects where object_type='PROCEDURE';
and i've got the name and Object_id of that prodedure but i have no
ideea how to get the rest :(
please help,
Hi Sultan,
Yes there is :)
PocketDBA is built exactly for this purpose, and at this time is the only
DBA specific tool that I have seen in the market - apart from the up and
coming EM2GO product, which AFAIK is not generally available yet.
Expand Beyond are the authors of PocketDBA, and have a
We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a
PL/SQL module from Oracle. Our management would like to save the Oracle Support
dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages,
so my options are limited unless we choose
Hello Robert
We are working with advance replication in 8.1.6.3.4.
You need the following in the instances:
global_names = true
unique global name in each database
job_queue_processes = 10 ( at least)
archive enabled
I will send you offline the script that I use to create replication.
It does
Why don't you use the trick for restoring the password?
select 'alter user APPUSER identified by values '''||password||''';'
from sys.dba_users
where username = 'APPUSER';
save the resulting alter user statement
Now, change the password for your third part vendor app, login as the user, grant
Adrian,
Look in USER_SOURCE. The TEXT field will have the source code.
Dick Goulet
Reply Separator
Author: Adrian Ciocildau [EMAIL PROTECTED]
Date: 3/5/2003 5:34 AM
Hi.
i need some help. i'm trying to get a stored procedure source code from
Santosh,
Add to that Oracle Builtin Packages from O'Reilly.
Dick Goulet
Reply Separator
Author: Darrell Landrum [EMAIL PROTECTED]
Date: 3/5/2003 5:19 AM
Aside from docs at technet.oracle.com, a perfect book for you is Beginning
Oracle
Works
for me.
-Original Message-From: Santosh Varma
[mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003
13:05To: Multiple recipients of list ORACLE-LSubject:
Access Internet Web pages from SQL or PL/SQL
i am getting the
following error when i give the select
We had a look at PocketDBA a year ago. Damn nice technology, problem we had was
access to the wireless services at the time. They did not extend very far north
of Boston Ma. Still don't get out to where we really need it, like the back
woods of NH. It's a three tier sort of application. You
Robert, and all of you other RMAN gurus.
scenario 1: repository unavailable, so rman backup was done using
controlfile only. upon later successful connection to repository, the
backup info was pushed from controlfile to repository(YEA).
scenario 2: I have to rebuild the controlfile and have
Try OakTable Network. They have a paper on Windows RAC setup details.
http://www.oaktable.net/userFiles.jsp.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 6:34 AM
Hi
We are not a Unix shop and would like to
SYS.USER_SOURCE
JP
On Wednesday 05 March 2003 14:34, Adrian Ciocildau wrote:
Hi.
i need some help. i'm trying to get a stored procedure source code from
the database.
After a lot of reding i found :
select * from user_objects where object_type='PROCEDURE';
and i've got the name and
Sure, checkout the Oracle Lite from
OTN.
- Original Message -
From:
Sultan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, March 05, 2003 6:49
AM
Subject: Oracle Tools
Hi gurus,
Is there any Oracle tools available to use it in
Handheld
select text
from dba_source --if you don't have access to dba_source try
all_source or user_source
where name = your source name here
/
[EMAIL PROTECTED] 03/05/03 06:34AM
Hi.
i need some help. i'm trying to get a stored procedure source code
from
the database.
After a lot of reding
Title: RE: 9i OCP Upgrade Exam - Again
Pat,
You have twochoices ...
1. either you log in as the schema and grant access to see selected
tables
This isn't possible (or is the last
resort)
2. SELECT ANY
Easy, but as you mention a potential security
risk
When I have limited choices with
Ethan - We just have it in pilot with a single user, so I don't think that
will help you.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 04, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Anyone running Oracle
Check Oracle
MetaLink Note 108723.1. There seems to be a problem when a numeric value is
specified for max_dump_file_size, rather than a K or M at the end. In short,
change max_dump_file_size to 10K from 10240, bounce it and
retry.HTH.Arup Nanda- Original Message - From:
The O'Reilly book Oracle and Open Source says DBPrism is a continuation of /
based on OWSKiller, and is one of the most astonishing success stories of
Java, Oracle, and open source cooperation. (p.299).
They explain how to install it, how to use it, adapters you can get for it,
including Cocoon
Santosh - I went to http://www.google.com http://www.google.com and
searched for the terms PL/SQL tutorial. I received several
interesting-looking sites.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 05, 2003 2:50
Dennis - In reflecting on your question, I have to wonder whether you don't
have a larger problem. Since your email address doesn't end in cia.gov, I
have to ask whether you as a DBA can adequately manage this application. If
I were given this request, I would tell the developer let's go find the
Know what you mean about coverage. I was up at Bretton Woods NH skiing over
the Christmas holidays and couldn't get a cell phone to work until I at all.
Not sure if that was a bad thing though :-).
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
What I meant to say was:
and at this time is the only DBA specific tool that I have seen in the
market for PDA technology
-Original Message-
Sent: 05 March 2003 13:35
To: Multiple recipients of list ORACLE-L
Hi Sultan,
Yes there is :)
PocketDBA is built exactly for this purpose, and
Title: RE: 9i OCP Upgrade Exam - Again
Grant select on all tables is
not what we were looking for exactly because of the reason brought up by Pat.
The following solution provided by Jacques solved the problem
-
Execute Immediate is for Oracle 8.1 and later.
In 7.3.4 you need to use the
Title: Message
We
are also finding difficulties with a mixed Oracle
environment.
We
are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving
to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would
install the software, upgrade our listener,
Hi,
The query is:
SELECT text FROM user_source WHERE name = 'procname';
Regards,
Charu
-Original Message-
Ciocildau
Sent: Wednesday, March 05, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Hi.
i need some help. i'm trying to get a stored procedure source code from
the
SELECT line, text
FROM all_source
WHEREname = 'YOUR_PROC_NAME'
ORDER BY line
HTH
Istifad
-Original Message-
Sent: 05 March 2003 13:35
To: Multiple recipients of list ORACLE-L
Hi.
i need some help. i'm trying to get a stored procedure source code from
the database.
After
iFS 1.X.X and below is alternately with the 8.1.7 database and 9iAS 1.0.2.X
9iFS 9.0.1 is with the Database CD Pack {on a seperate CD}
9iFS 9.0.2 is part of 9iAS 9.0.2 {on a seperate CD}
9iFS 9.0.3 has been renamed as Oracle Files and is part of Oracle
Collaboration Suite.
Check the MetaLink
Look at user_source (or all_source if the procedure is in a different schema).
Then
select text from user_source where name = 'YOURPROCNAME';
[EMAIL PROTECTED] 03/05/03 07:34AM
Hi.
i need some help. i'm trying to get a stored procedure source code from
the database.
After a lot of reding
Sudhakar,
Unfortunately that's the only way to change teh trigger's ownership. But how
does it matter, if you drop and recreate the triggers in another schema?
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 5:19
select text from user_source where name = 'PROCEDURE_NAME' order by line;
you can do the same for functions, packages and types
select text from user_source where name = 'PACKAGE_NAME' and type =
'PACKAGE' order by line;
select text from user_source where name = 'PACKAGE_NAME' and type =
Also have a look at MobileLynX. Can't figure out for the life of me why the
don't advertise this thing. It does most if not all of what PocketDBA does
but is also user extensible. It's actually an XML engine but they provide
scripts for managing Unix and Oracle as part of the package. If you want
Hi,
Take a look at:
user_source
all_source
dba_source
or for actual table where it is stored, log in as sys and have a look a
source$
Regards,
Morten Egan
Adrian Ciocildau wrote:
Hi.
i need some help. i'm trying to get a stored procedure source code
from the database.
After a lot
Hi Guys,
I am trying to setup FGCA for our customers on their reporting system. I have got this working for a single table, however, when a policy needs to be added for multiple tables. It fails returning no rows from the second table.
Oracle documentation is not very helpful this arena. Can
Jack,
Have you had a chat with Tom to see if they have upgraded the current $1000
RAC paper for windows? I think it was mentioned in the paper that they
planned to..
Mark
-Original Message-
Sent: 05 March 2003 14:06
To: Multiple recipients of list ORACLE-L
Jack,
www.tusc.com has a
Title: RE: 9i OCP Upgrade Exam - Again
I am surprised ... which user did you run this as? You mention in your
original email that you don't jave the password for the owner and sys/system
don't have admin rights ...
Can you solve the puzzle? If you don't have privs with grant option, how
Just had a fellow tell me that explain plan in completely unreliable in 9.2
and getting accurate results requires direct SGA access on executing SQL (he
is working in a RAC environment). They are running Precise, a good product,
but this sounds like something a sales person told him. I can only
BTW is 9i lite just a database engine for PDAs, or does it allow you to
administer databases over a network from a PDA?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
u should use dbastudio
-Original Message-
Sent: quarta-feira, 5 de Março de 2003 13:35
To: Multiple recipients of list ORACLE-L
Hi.
i need some help. i'm trying to get a stored procedure source code from
the database.
After a lot of reding i found :
select * from user_objects where
One good book to have is Oracle Built-in Packages from O'Reilly. It does
more than merely show the syntax for the packages, but shows how the
packages are used. There is a chapter on Advanced Replication. I have
found this book to be one of the more useful books that I have bought.
--
Please
Title: RE: How Reliable is Explain Plan in 9.2
Ethan,
I am *shocked* we are running RAC 9202 ...
I haven't seen anomalies ... does your friend have any example?
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed
Robert -
I have studied this issue quite a bit and my opinion (based on reading,
not experience) is that the success in replication is in the organization,
not the technology. The question is whether your organization and
application are ready for replication. It sounds like you have some
Hi,
It is true that the firewire stuff IS linux only. It was written by Wim
Coekaerts (who I used to work together with in Oracle Dev.), who also
wrote (together with his group) the cluster file system for linux. I
haven't personally tried it yet, but an old collegue(sp?) of mine has
tried
MOD_PLSQL is licensed under GPL and its home page
is on http://www.selfsoft.com/progs/mod_plsql
In my opinion Apache with PHP is equally good as mod_plsql.
The main advantage of the modules is that they become a part
of Apache httpd process, so you don't have to go through CGI
and process
Hi,
I need it to check from O/S level. not from database
level.
can somebody give any hints.
Thanks and Regards,
Srinivas
-Original Message-
From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Joe - I'm confused. If you rebuild the controlfile, what good is the backup
information stored in the catalog? Other than maybe deciding to revert to a
time before the rebuild, and you're going to need the catalog for that
anyway.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL
Looks like the web site may be down.
Reply Separator
Author: Chuck Hamilton [EMAIL PROTECTED]
Date: 3/5/2003 8:19 AM
Also have a look at MobileLynX. Can't figure out for the life of me why the
don't advertise this thing. It does most if not all of
You can use LICENSE_MAX_SESSIONS to associate with your license,
although I don't know why you would want to do it if your database is
in-house
[if you are an ASP you might want to restrict the number of sessions
running against the database on *your* server].
SESSIONS has nothing to do with
Ethan,
Seeing as your friend is running Precise I have heard similar
pronouncements from them about the accurracy of explain plan for several
versions of Oracle I'm not suprised. True, they make a very nice product, but
them again explain plan is something they do themselves. Yup, sounds
... can be rather interesting at times, when there's time to check out a
few.
http://metalink.oracle.com/metalink/plsql/showDoc?db=BUGid=2666174
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Joe,
Yes, to my knowledge, the resync is only intended to bring the repository up
to date with control file. I doubt you will ever see the mechanism to
reverse this functionality (e.g. put backup records in the control file
after the fact) since when an entry is made in the control file, a
Title: Message
We had something similar, but only when attempting a
serverSQL+ connection, which I found was
due to someone messing up the ORA_NLS33
setting.
---
As of February 12, 2003 Thomson unified its email addresses on a
Title: RE: Oracle Bug Reports...
Thanks Jared for bringing this to our attention.. So many bugs .. how can we track 'em all?
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any
resync is only one way, unfortunatly. I don't know of any way to update the
control file with backup records from the recovery catalog.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/5/2003 8:19 AM
Robert, and all of you other RMAN gurus.
scenario 1: repository
Consider how important explain plan is, I highly doubt
it's completely unreliable.
-Original Message-
Sent: Wednesday, March 05, 2003 8:35 AM
To: Multiple recipients of list ORACLE-L
Just had a fellow tell me that explain plan in completely unreliable in 9.2
and getting accurate results
Hmm, I'm not having any trouble getting to it.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 1:14 PM
Looks like the web site may be down.
Reply Separator
Author: Chuck Hamilton
Title: RE: PLSQL stored procedure
our go get TOAD freeware... even has a line by line debugger with watches.
-Original Message-
From: Darrell Landrum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 05, 2003 7:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: PLSQL
Title: Re: How Reliable is Explain Plan in 9.2
Yes, explain plan will become increasingly unreliable as the cbo takes more
and more factors and current conditions current into account. Some of the
factors that can change the outcome of a parse from session to session are:
for Oracle 8
-
I've had problems trying to use OEM (9.0.1) to monitor clustered databases.
The problem is that each database is set up in it's own resource group,
therefore each has it's own virtual hostname. Even though I may have several
databases all running on the same physical host, they all have different
Title: Re: How Reliable is Explain Plan in 9.2
Wolfgang ...
Now that explain plan is unreliable and will be even more in10i,
I'll always keep a silver dollar in my pocket. The coin toss is still
right(in almost) 50% of the time.
Jeez ... what's next ... in 11i, SELECT statement *may* return
Since I work in a bank, our security guy will flip if we suggest such an
option.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 5:18 PM
Today I found out that the OWS personnel can use 'Oracle Direct
You would have thought to, but it
doesn't seem to be the case.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
I haven't seen any problems yet.
On the contrary - there are facilities
in the EXPLAIN PLAN which are not
available through v$sql_plan , such
as recursive SQL for subquery
factoring, and a couple of columns
(but I can't remember which ones
at the moment).
Regards
Jonathan Lewis
If you don't plan to have many users, I think you could make do
with the Oracle HTTP Server (Powered by Apache) that comes
bundled with the database from 8.1.6 and onwards. No need
to rewrite any code, as it comes with mod_plsql and the
PL/SQL Web Toolkit.
You could also consider ChangeGroup
the catalog has all of the current backup info, so if i lose the
repository(before taking a backup after rebuilding the controlfile),
I'm SOL. I logged a tar and oracle's response is, no way to push
catalog info back into the controlfile.
joe
Joe - I'm confused. If you rebuild the
That is my thinking but I will take Wolfgang's comments into consideration.
-Original Message-
Sent: Wednesday, March 05, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Ethan,
Seeing as your friend is running Precise I have heard similar
pronouncements from them about the
Title: access to oracle $ tables in 9.2.0
Previously, an account with the DBA role could
directly query oracle's internal tables
(user$, seg$, ts$, etc). Now in 9.2.0.2,
it appears we can't. Does anybody know
what version this changed in or where (or if)
it was documented. A quick search on
9i lite is a light weight database for PDA's. I know that at one point
Oracle was developing a DBA tool for PDA's, but I dont know the status
of this product, or if it has been cancelled since then. But of course
you can wait for EM in 10i which is browser based, so that should be
able to run
I think there's a big emotional difference between
unreliable and won't necessarily give you the plan
under the current circumstances that it gave at the
time of execution - which has been true since the
utility came out. It is true, of course, that the reasons
for the variation have become
Anyone use third party tools for monitoring Oracle (which I like to
think I'm not a complete novice at), *and* MSSQL (um which I am). I have
an unusual opportunity to buy third party software whilst we wait for
the MSSQL training to kick in and I'd like to buy something genuinely
useful for an
No worries. The bug says it's fixed in 10.0. Just upgrade. Anyone can do
it, since 10.0 removes the need for a DBA.
Whoa. Gotta cut back on the black tea here...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International,
did u try the inventory logs ?
Babu
kommareddy
hmmm I remember something about licensing with Oracle HTTP Server. AFAIK
you are NOT allowed to use it for this kind of appl. I think you need to
buy the IAS.
Can anyone remember the specifics around this, or am I way off here?
/morten
Michael Garfield Srensen wrote:
If you don't plan to
Title: Message
As far
as I can tell, the Explain Plan is 100% reliable. It shows how the query would
execute if it was run from that session at that momement in
time.
If you
want to see how a query in the SGA actually ran, query the
Oracle9i v$sql_plan view.
Kevin
-Original
The problem with that idea is that the webserver portion will be installed in a DMZ,
away from the database. Which got me thinking...what if I just installed the http
portion of the database install on the webserver box? I would be using the http
listener that comes with the database, but I
Wait... I thought it was 9i that did away with the need for DBAs...
-Original Message-
Sent: Wednesday, March 05, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
No worries. The bug says it's fixed in 10.0. Just upgrade. Anyone can do
it, since 10.0 removes the need for a
I try to query a report to check user activity but I could
not read date column. Is there a way to reformat the column to be
readable? Date colum calls "time_stamp" as shown below.
SQL desc user_activity_log
Name
Null?
Type
-
1 - 100 of 153 matches
Mail list logo