Naula - Don't worry about it. You've given me something to look for the next
time. I'd rather learn from someone else's problems. :-)
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 03, 2003 5:25 AM
To: Multiple recipients
Prem,
Use DBMS_JOBS to run the analyze:
===
undef username
undef password
grant analyze any to username
/
connect username/password
CREATE or REPLACE PROCEDURE analyze_tables (
v_stat_type IN VARCHAR2 := 'COMPUTE') AS
CURSOR c IS
SELECT
-Original Message-
Sent: Monday, June 02, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Yes, it is fixed in 9.2.0
Hemant
At 04:25 AM 02-06-03 -0800, you wrote:
Hope it's fixed in 9iR2 !
Jp.
2003/06/02 20:54:41, [EMAIL PROTECTED] wrote:
Cannot create lob columns if segment
-Original Message-
Sent: Monday, June 02, 2003 6:50 PM
To: Multiple recipients of list ORACLE-L
Your case against LOB is
That was probably the case against LONG?
--
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
--
Please see the
you only want DBWR_IO_SLAVES or multiple DBWRn if you have datafiles spread over
multiple I/O points correct? We are using 'Network Appliance' hard disk array that Im
not all that familiar with. It looks like we have 3 I/O points and 5 mount points.
my boss told me that striping data files and
Title: RE: SQL Loader
If SQL loader loads a table it takes the first record in the file and stuffs it in the top of the table... like a stack... last in, first out so if you were to read the table like you read the sequential file, it is in there with the bottom record in the file as the
Having multiple tnsnames.ora, and multiple init.ora always create
unanticipated problems.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: cannot allocate new log -- Problem
Title: RE: When will long data type no longer be supported
Also be aware that in some early versions of 901x temporary lobs used to _leak_.
We use CLOBS all ESPN stories, (even) scores are transmitted as CLOBS containing XML data. So, yeah ... use CLOBS, they rock compared to LONGs.
Hi Group,
How do I uninstall apps 11i.
any specific procedures are there to uninstall???
thanks
Senthil.
-Original Message-
Gogala
Sent: Tuesday, June 03, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L
Well, I was talking about cursors, sort areas and hash areas. I probably
That's what I thought. LIFO.
Why does the order matter?
Can you sort the result to suit your needs?
- Kirti
--- Pradeep Kumar G [EMAIL PROTECTED] wrote:
When I queried the table to which SQL Loader loaded data from the .dat
file, the first record in the table was the 5th record and
http://asktom.oracle.com/pls/ask/f?p=4950:8:247354401321242398::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:953229842074,
that will give you a detailed explanation
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/06/03 Tue AM 09:01:28 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Thanx a lot Mark.
Sure , your code has given me a starting point.
let me change accordingly to use DBMS_STATSe and give a try :-)
So,can i conclude that DBMS_STATS is better than ANALYZE ?!
Someone over the list mentioned that DBMS_STATS is slower.
is it so ? What is your opinion regarding this
I nearly alwayshave issues with
blanket statements on performance. That includes the statement that EXISTS
should be used in place of IN.
If the IN performs better in the particular
case, use it. If it doesn't perfom adiquately then, by all means, convert it to
an EXISTS. And do the
Hi All,
I have a mview(Materialized View) that i refresh
ONDEMAND. This Mview takes 15 minutes in refresh as it
involves a complex query and lots of data in master
table. But as soon as the refresh starts old data gets
deleted from the mview and there is no data in mview
untill the refresh is
Perhaps it is late to answer, but you might want to have a table that is
populated with PK and column values, via column level trigger indicating the
changed column and data?
Aleem
-Original Message-
Sent: Wednesday, May 28, 2003 10:21 PM
To: Multiple recipients of list ORACLE-L
Title: RE: OCP Test Order
to tell the truth the networking exam is basically some rote memorization and the questions are straightforward - I prepared while waiting 1/2 hour to take exam at most.
The performance tuning exam is what I have been told to immediately forget by some certifiable
Not sure what you mean by I/O points.
Whether or not multiple DB writer will be of benefit
to you depends on a couple things.
First of all, can you use async IO? I don't see any
mention of what platform you are on. If you're using
Windoze, it is async IO by default.
Async IO is generally a
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Sorry JP, I should have clarified that DBMS_STATS is the way to go, when on
a 9i or above release. One of the simple factors being that ANALYZE is being
deprecated.. There seemed to be a number of bugs/quirks, whatever you want
to call them, in certain 8.1.x versions, which are now fixed within
Title: Database recovery question
I have a hot backup of an Oracle database (all files located on E:), I now want to restore the hot backup location as F:.
Now if this was a cold backup I could recreate the control files :-) But since it is a hot backup I need to do a recover database using
Thanks Mark - That is exactly what I was just getting ready to write!
(B
(BDennis Williams
(BDBA, 80%OCP, 100% DBA
(BLifetouch, Inc.
(B[EMAIL PROTECTED]
(B
(B
(B-Original Message-
(BSent: Tuesday, June 03, 2003 8:02 AM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BPrem,
Thanks, was not sure if you could rename the files before you had done the required
recovery of the database. Since you can rename using the backup controlfile before
recovery then everything should go smoothly as I have done the cold backup restore
process LOTS :-)
Cheers
-Original
My experience with NetApp says that it is easy to clog up your bandwidth to
the device. I would worry more about that issue and finding just how much
throughput you could get to the device. Usually the DBWR tuning is for the
situation where you have lots of devices with separate paths to those
Sai - I think the whole point is to open this up for discussion /
negotiation. My suggestion would be to agree with the business users on a
typical query and the response time they expect. Ideally response time is
measured at the user's terminal. But if necessary just for the database, you
might
My boss has decided to change the name of the Sun OS 2.8 host
of my Oracle 8i databases.
Question: how does this name change affect my Oracle software
installation and my databases?
Has this happened to any of you?
Thanks,
Carmen Rusu
JP,
After you've initially created statistics and set the tables into monitoring
mode this script will create a DBMS_JOB that keeps them up to date each morning:
set serverout on size 10
prompt Connecting to SYS
connect sys@_dbname
grant select on dba_tab_modifications to system;
1. Restore the controlfile backup and all your datafiles to F:
2. Configure the initSID.ora to set the control_files parameter to the
controlfile at F:
3. STARTUP MOUNT
3. Run the ALTER DATABASE RENAME FILE oldfilein E: TO newfile in F:
for each datafile
(including the SYSTEM Tablespace
The UGA contains cursors, session state info, etc. The PGA contains sort
area, hash area, bitmap merge area, read buffers for direct-path, etc.
on 6/3/03 4:39 AM, Mladen Gogala at [EMAIL PROTECTED] wrote:
Well, I was talking about cursors, sort areas and hash areas. I probably
did confuse
Thanks, Mladen.
It was case against LONG, not LOB.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 10:24 AM
-Original Message-
Sent: Monday, June 02, 2003 6:50 PM
To: Multiple recipients of list ORACLE-L
found that gethitratio in v$librarycahce is very
low for indexes. what does it mean ? is there any way to improve this
.
thanks,
-ak
Hi List,
How do I identify a corrupt block in my system tablespace datafile
because I cannot any more access my data dictionary meta-data?
What is the work around for this?
Regards,
Satya Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Satya Prakash
This may be a little over-the-top for your needs, but it works for us.
We have a standard DBA-level user that we create in every instance.
This is a stored procedure within that instance. We schedule it using
DBMS_JOB.
Typically, we don't analyze every schema every time. Usage patterns
vary
I would think that the situation where multiple DB writers would be useful
on a single mount point would become more and more common.
This is due to SAME. If you were to create 5 RAID 10's with 5 physical
disks each, and striped a single volume across them, and you are not
using async IO, you
Ken,
The best to do list will be the one you create yourself.
You can do this by reviewing the migration manual, and determining
which steps are appropriate for your environment.
Jare
KENNETH JANUSZ [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/02/2003 08:49 PM
Please respond to
Manoj,
This is a problem with the full refresh of an MV. The refresh initially
truncates the table and then issues a full refresh. To resolve this problem,
here are some steps:
Create the MV as a table first and then build the MV with ON PREBUILT
TABLE clause.
When created this way the drop
DBMS_STATS is quicker because it can run in parallel mode. Analyze cannot.
(B
(B-Original Message-
(BSent: Tuesday, June 03, 2003 11:25 AM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BSorry JP, I should have clarified that DBMS_STATS is the way to go, when on
(Ba 9i or above
We've juggled names several times here. The tricky part is network connections to the
database. You need to make sure that tnsnames.ora files point to the right server.
Also, if people are using database connections in other programs (e.g. perl, Pro*C,
java, python) they need to make sure they
It should not affect you...
except, of course, in your CONFIG ora files if you are
using HOSTS instead of IP addresses!
JL
--- Carmen Rusu [EMAIL PROTECTED] wrote:
My boss has decided to change the name of the Sun OS
2.8 host of my
Oracle 8i databases.
Question: how does this name
Title: RE: Schedule Analyze using DBMS_STATS ???
(B
(B
(B
(B
(BWe don't analyze schema, we use dbms_stats ...
(B
(B
(BI wrote a package that analyzes everything using dbms_stats and (for my instance) it runs in 10 parallel streams. It splits all the tables in 10 streams so that all of
If your network people are good people who pray to the correct gods, then
all you need to do is allow the update to the DNS servers propagate.
What?! You don't use DNS?!
Oh! Well, that's different. (Emily Littella)
-Original Message-
My boss has decided to change the name of the
Title: RE: Schedule Analyze using DBMS_STATS ???
(B
(B
(B
(B
(BThe sample output looks like ...
(B
(B
(B[EMAIL PROTECTED] sys
(BSQL*Plus: Release 9.2.0.2.0 - Production on Tue Jun 3 11:57:51 2003
(BCopyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
(BConnected.
Carmen - I haven't had this happen, but I think the main issue would be in
your listener.ora and tnsnames.ora files. If you are referencing the host
name in those files, then those will need to be changed. Is the IP address
changing?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
rollback previous post.
For a moment there I was thinking IP address change.
Never mind (Emily Littella)
Now, there is the subject of aliases. I mean, as long as a manager wants to
be ridiculous, you might as well go whole hog.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Senthil:
When you say you want to uninstall, do you want to completely remove the
software from the machine?
What is the OS you have the software configured upon? Are you upgrading to
another release of 11i?
Please be a bit more specific.
Thank You
Stephen P. Karniotis
Product Architect
use dbms_repair package .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 8:54 AM
Hi List,
How do I identify a corrupt block in my system tablespace datafile
because I cannot any more access my data dictionary
With some versions, dbms_stats has issues with partitions. Since we use
partitioning, we wrote a script to simulate the gather stale
functionality. Monitoring is enabled and we do a compute of any table
or partition thereof that has more than x% modified. This is
essentially what the gather
From: DENNIS WILLIAMS
I believe that all the statistics that CBO uses to make a
decision are in
USER_TABLES and USER_INDEXES. You might compare the values
for both tables
to see if there is a difference that might cause the CBO to
make a different
decision.
I'll look into that,
You can use a tool called dbv. It takes two args: blocksize and
datafile.
Regards,
Morten Egan
On Tue, 2003-06-03 at 17:54, Satya Prakash Viswanath wrote:
Hi List,
How do I identify a corrupt block in my system tablespace datafile
because I cannot any more access my data dictionary
Hi List !
My problem with TOAD was fixed.I do not call it great.
Solution Obtained:
1. Reverted back to TOAD 7.2 (IT still did not work even though I was
able to connect thru SQL *PLUS)
2. I took a back-up of my database and ran the catexp.sql script. I got
a few warnings but all my data
Sorry it is the catalog.sql script
-Original Message-
Sent: Tuesday, June 03, 2003 11:30 PM
To: Multiple recipients of list ORACLE-L
Hi List !
My problem with TOAD was fixed.I do not call it great. Solution
Obtained: 1. Reverted back to TOAD 7.2 (IT still did not work even
Ken,
Jared is probably right as far as a checklist for the actual upgrade.
A test run through will probably highlight any problem areas.
After the upgrade there are a number of things that usually need to be
checked/modified/recompiled (of course it depends on how you upgrade).
Here is a list
Jared - You are probably right. I was just making the point that all your
disk interaction is going over a network link which can be a lot more
restrictive than the normal direct attached storage we are used to. When I
see people configuring multiple DB writers I tend to think it will just help
Ben - Thanks, I printed that for my checklists file.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 03, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Ken,
Jared is probably right as far as a checklist for the
or wait till OracleX ? ;)
- Kirti
--- Stephen Lee [EMAIL PROTECTED] wrote:
Well folks, there IS an issue with online index builds in 9.2.0.3. Not only
have we experienced normal SQL getting blocked, but we have seen index
builds hang indefinitely -- while holding the blocking lock
Hi:
I have a perl program which calls lots of subroutines, and plus it calls
sqls through DBI/DBD. I am wondering if there are some utilities or programs
similar to Oracle's dbms_profiler that I could use to identify parts that
are heavy-hitters?
TIA.
Guang
--
Please see the official ORACLE-L
Hello everyone,
I am woundering if anyone on the list has scripts written to create backup reports for all databases registered in an RMAN catalog directly from the RMAN catalog tables.I am looking for advice on the simplest way to report on the status of backups for many, many enterprise
Sai,
To quote part of an excellent article from the 'Goddess' on SLAs: (titled:
Managing User Expectations with Service Level Agreements)
When people talk about availability, the discussion almost always begins
with hardware. Numbers and sizes of servers, disk arrays, communication
lines and, on
The cardinalities are the same, but the costs are different. It looks as if
production has somehow optimizer_index_cost_adj set to 50 or lower or has
db_file_multiblock_read_count set to 8. It's the same instance so that is
not possible unless they are changed at a session level.
To check that,
If you're asking for a profiler of your perl code you can try dprof and
dbiprof.
On Tue, 3 Jun 2003, gmei wrote:
Hi:
I have a perl program which calls lots of subroutines, and plus it calls
sqls through DBI/DBD. I am wondering if there are some utilities or programs
similar to Oracle's
Title: RE: Oracle's use of Indexes
Wolfgang,
I have a similar problem that I am still trying to work on.
Except for
* nls_sort ('binary' = performance is better,
null it is bad)
and
* sort_area_size (8388608 = bad performance,
8688000 = good performance)
all other parameter
Module Benchmark is part of the core perl distribution, you can use that
for simple benchmarking.
The CPAN has several profilers. Devel::SmallProf is a nice per-line
profiler. You would invoke it like so: perl -d:SmallProf myscript.pl and
it will dump profiling information into smallprof.out. Or
Keep reading the same stuff from the indexes in a useless loop. That should
improve it. Or use Connor McDonald's script on oracledba.co.uk to get any
hitrate you like.
Seriously, hitratios don't mean a thing. Long story. Don't worry.
AK wrote:
found that gethitratio in
http://search.cpan.org/search?query=profiler+benchmarkmode=all
gmei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/03/2003 01:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT: Is there a
I have to tell you this, my friends:
Today, a package arrived here in Maaloev on the oak table. It contained
Oracle version 5.1.C and 6.0 on 5.25'' diskettes.
The sender was Chris G. from Nokesville, VA.
This will go right into the Oracle Museum, and I hope to be able to let
you guys one day
I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:
create or replace procedure test_test1 as
procedure test_test2 as
begin
dbms_output.put_line('hello2');
end;
I agree totally... Adding more databases to a server doesn't invalidate a
negotiated SLA. If you can't meet the SLA then someone has a problem.
Perhaps tuning is required, perhaps more hardware is required, perhaps the
SLA is wrong and can be renegotiated. The issue revolves more around
Mogens,
I am very far away from my employer otherwise I could have sent you 5.25
disks for Oracle version 4 under DOS for your museum. That employer is still
using successfully version 5.0.22.1 under Unix. We started that version in
1988.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple
Title: RE: Interesting!
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know
it already.
Procedure can contain other procedures:
hi
here is where the issue is:
perhaps tuning is reqd,perhaps more hardware is
reqd,perhaps SLA is wrong. exactly what i am trying
to find. i do this when i feel that SLA is not
viable ..but it would be great if i get stats on
paper.
how do we renegotiate SLA? or how do we get a new
value for
we use it quite often to make logic looks simple like ..
Procedure create_oe_line
procedure add_order
procedure make_adjustment
procedute create_delivery
Begin
add_order;
make_adjustment;
create_delivery;
End
Title: RE: archiving data
Thanks Dennis for the encouragement.
I really try not to take it out on them. I work for the financial security of my family but I also don't want it to impact (or at least as little as possible) my relationship with my kids. I feel as their mother I need to be as
Title: RE: Good technical documents/references on tuning restores
Also found on monitoring performance of RMAN jobs:
Note:144640.1 on Metalink
-Original Message-
From: Stankus, Paula G
Sent: Tuesday, June 03, 2003 8:36 PM
To: Stankus, Paula G; '[EMAIL PROTECTED]'
Subject: RE: Good
Title: RE: Good technical documents/references on tuning restores
Seems to be taking awfully long to read files from tape and write to disk. I allocate multiple tape channels like I do for the backup which only takes about 45 minutes. Does not seem to be spawning multiple sessions. Do I need
Title: RE: Good technical documents/references on tuning restores
See nwadmin shows parellism = 32. I am not the tape person - that is my sys admin. I don't believe they actually have 32 tapes involved only 4. Can this impact performance by setting this too high? I also notice one backup
Title: RE: Good technical documents/references on tuning restores
Okay - from my reading you don't need to have multiple tape io slaves if you are using asynch. I/O. Again, best document for perf. tuning database restores using RMAN would make mucho difference. Read old note about someone
Title: RE: Good technical documents/references on tuning restores
Did I say that throughout this restore/recovery process my tapes being mounted and unmounted while other database backups and cloning was occurring. Big duh - this has got to be slowing down the process. Any ideas on how to
Title: RE: Good technical documents/references on tuning restores
Strange:
looking at v$backup_async_io found some datafiles where
active bytes per sec long-waits
2154608297
7489829297
How can I start finding the disparity?
-Original Message-
From: Stankus, Paula
Title: RE: Good technical documents/references on tuning restores
This is what I have set on my target database:
--- --- ---
backup_tape_io_slaves boolean FALSE
tape_asynch_io boolean TRUE
Version 8.1.7.4 database and RMAN catalog - 32
Title: RE: Good technical documents/references on tuning restores
SELECT SID, SERIAL#, CONTEXT,
ROUND(SOFAR/TOTALWORK*100,2) % complete,
SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) Time now
FROM V$SESSION_LONGOPS
WHERE OPNAME like '%restore%';
.
showed all 100% complete but msglog from
Title: RE: Good technical documents/references on tuning restores
Found this white paper:
http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf
Anything better?
-Original Message-
From: Stankus, Paula G
Sent: Tuesday, June 03, 2003 8:33 PM
To: Stankus, Paula G;
My first real PL/SQL program used this technique. Of course since it was my
first program I ran into a very annoying variable scope issue. Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.
Title: RE: Good technical documents/references on tuning restores
Okay, almost 4 minutes for a datafile that was 78168 blocks - how do I know if this is reasonable?
Also, seems to write these files out (restore sychron.) why can't it restore different datafiles in parallel? - stupid
Oracle 9i release 2 new feature ( from the admin guide )
Removal of LOB Column Restriction:
You can now create LOB columns in tablespaces that specify automatic
segment-space management.
Before release 2 There were some bugs with Auto Segment Space Mgmt and LOB
type fields
- Original
Title: RE: archiving data
Hmmm. thought I was just mailing that to Dennis.
Sorry,
Now I
do my Pat laugh
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003
9:25 PMTo: Multiple recipients of list ORACLE-LSubject:
RE:
I guess the issue is never that simple, but it seems that in the ideal
world...
1) The company would define the SLA - It's the level of service they
expect and require to operate their business successfully. Note: They
define successfully. For example the SLA might be database recovery
must
Title: RE: Good technical documents/references on tuning restores
Okay,
Database open and I wanted to not restore and not reference certain index
and materia. view datafiles. Now the datafiles show up with weird
MISSING.. names. How do I clean this up?
Thanks,
paula
-Original
Any APPS DBAs out there?
I need to know where to find the argltp log file. (AR to GL transfer
process log file)
Thanks.
=)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Erase with rm if on unix all $APPL_TOP's you have set up and then kill the database.
No formal uninstall is needed.
Allan
-Original Message-
Sent: Tuesday, June 03, 2003 8:02 AM
To: Multiple recipients of list ORACLE-L
Hi Group,
How do I uninstall apps 11i.
any specific procedures
Your tnsnames.ora will probably
need to change. If you are using the Apache instance that comes with the
db then you will need to do some work on those config files as
well.
Allan
-Original
Message-From: Carmen Rusu
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003
Hi People,
Is there any way to find the statistics(like tkprof
gives) of SQL's within storedproc , when storedrpoc is
called.
Basically I want to find culprit SQL within
StoredProc.
Any help is appreciated
Regards
Sam
__
Do you Yahoo!?
Yahoo! Calendar - Free
For a Hybrid Banking Application , following waits are Observed :-
Oracle ver 9.2 (Dedicated Server connections)
Solaris 8
M/c SF15K
Application mostly uses Static Queries (i.e. with Bind variables) ,
though there may be some amount of Literal SQLs too
DB Size = 250 GB
Qs How may the following
Application - Hybrid Banking Application
Oracle ver 9.2 (Dedicated Server connections)
Solaris 8
M/c SF15K
Application mostly uses Static Queries (i.e. with Bind variables) ,
though there may be a small amount of Literal SQLs too
DB Size = 250 GB
Qs How may the following waits be
DBMS_PROFILER
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Hi People,
Is there any way to find the statistics(like
What may be Easier ways of doing the same ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
Hi People,
Is there any way to find the statistics(like tkprof
gives) of SQL's within storedproc , when storedrpoc
is
called.
Basically I want to find culprit SQL within
StoredProc.
Any help is appreciated
Regards
Sam
x$kglrd, x$kglcursor, sys.obj$, x$kgldp and sys.dependency$ ...
I don't
Increase shared pool.
VIVEK_SHARMA wrote:
For a Hybrid Banking Application , following waits are Observed :-
Oracle ver 9.2 (Dedicated Server connections)
Solaris 8
M/c SF15K
Application mostly uses Static Queries (i.e. with Bind variables) ,
though there may be some amount of Literal
Hi stephen,
Thanks.
I'm using Win2K. I want to remove all the oracle products, including my
apps.
I need to prepare a installation doc with the snapshots. So I need to
reinstall all the oracle products.
TIA,
Senthil.
-Original Message-
Stephen
Sent: Tuesday, June 03, 2003 11:10 PM
To:
How about also looking at pinning procedures, or even tables (if small and
you have enough memory) in to the library cache too? Look for the for those
that have a high execute/parse ratio..
Get PctPinPct
Invali-
Namespace Requests Miss
Stop all oracle services.
Remove the whole directory structure under APPL_TOP. remove admin and
java directories and also ORACLE_HOME.
Go to Program Files and remove folder Oracle if it exists.
Open the registry using regedit and remove the following
HKEY_LOCAL_MACHINE - Software - Oracle
Trade SQL Server for Oracle9i Database and get up to 100% license credit
and peace of mind.
Tired of applying patches? Frustrated with managing mulitple database servers?
In the time it takes you to apply all Microsoft's patches to your servers,
you can successfully migrate your database to
1 - 100 of 108 matches
Mail list logo