 | | | Oracle List | |
Hi
Querying *_TABLES (replace * with ALL DBA or USER) view will list you all tables.
Oracle reference manual lists all the views with description and you may find it very help.
http //downloaHi
I 'm new to Oracle Database. I 'm now using Oracle Database 10g Release 2. Can anyone tell me the command to view all the tables inside a specific oracle database?
Really appreciate for thHi Tony
I have attached a sample script in a separate email. The script creates a plan and consumer groups.
One of the sites I am working on has had limited success with RM.
There have been Hi Ken
Storage Foundation for Oracle RAC (SFRAC) with Global Cluster Option (GCO)
together with storage layer replication (VVR from Symantec SRDF from
EMC...) is sure a valid Disaster Recovery (DR)Hi everyone the oracle I use is 10.2.0.2 on HPUX IA64
Our job ran very slow and from AWR report I can see that a table named
ATTRIBUTE_VALUE
consumes most of the physical IO (Physical read was moreThe open source utility "stby_maint " will do it. You can find it at
http //orautil.sourceforge.net.
At 10 25 AM 10/31/2007 Allen Brandon wrote
>I 'm not a Data Guard expert but I don 't believe tFairlie
That 's not encouraging. I did do some digging on Metalink and Google
but the only bugs I was able to find related to problems with mapping
priorities. Can you give me an idea of the bugs Back in August someone asked how to raise an ORA-600 manually. I don 't
think there were any satisfactory answers. This troubled me some since
there clearly is some way to call the right function Spool Off
Exit
Thanks to everyone. I decided to do something like what I used to do with
my 8i Standby - create and run a shell script every hour using the
following (called from a cron 'd shell script). I know iHmmm....I 'm using a catalog and don 't think I 'd want to do that. I think
(from experience) if you 're using a recovery catalog and run that command
from the standby you 're going to risk deleting logsThis suggestion fixed my problem- the UR A parameter was missing
although I had to make minor changes to the tnsnames and listener.ora
files.
Thanks Luca !!
-----Original Message-----
From Luca Ca
Starting with 9.2 you get a section named "row source operation " for
each sql in a tkprof output. This section gives numbers for consistent
reads disk reads writes and timing for each step in the Ok so I am writing up creating a 10g DataGuard environment here. The docs
generally seem a bit iffy to me - I don 't like location or role based db
names for example what happens when computer centresThanks. I found one bug (*5058318*).
What does kolccst mean? I am assuming that KO is the same for all those.
Kernel Operations? Kernel Optimizer?
On 10/4/07 Yasin Baskan <yasin.baskan@(protected) ?hi there
What is
1) Db File sequential read?
2) Db file scattered read?
how they are impactful in the tuning?
thnks and regards
Aman....
"As our circle of knowledge expands so does the circumFirefox 2.0 works for me also. Just create an SR yesterday.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Amar Kumar Padhi
Sent srvctl talks with the CRS and if your database (and instances) is (are)
registered properly CRS will know which host each instance is on. Hence
from the CRS standpoint it is a no-brainer which oneJohn
We were gathering stats with no "METHOD_OPT " option. And according to
an Oracle SR the calculation for density is *not* 1/NDV but
DENSITY SUM(1..NDV)(nocc^2)/(T^2)
where T is the number oAnyone know where I can find more information about this KOLCCST object? And
other KO objects for that matter?
SQL > select * from (select * from v$sgastat where pool 'streams pool '
order by bytes Hi
What do you mean instance specific spfile is no longer there?
If you go to $ORACLE_HOME/dbs there should a initSID.ora which points to
your spfile
ThanKs
--
LSC
On 10/4/07 hrishy <hrishys@(protected)
a quick look may be to process the trace with tkprof but adding
"sort fchcpu " in the command line. Odds are the d.b.f.s.r. will appear
on first-lines/top of the produced report (in my experience at The simplest way would probably be to define an oracle external table of
just lines of the appropriate length then read the data as lines and
parse each line character by character into the format yoFolks
In a 10046 trace file taken at level 12 is there a way to find out
which index is experiencing most of the sequential reads?
Thanks
Amir
--
http //www.freelists.org/webpage/oracle-l
You *can* get this if you have chosen to register the db with Grid Control
using a central agent. database control is not an option for you in this
case.
On 10/3/07 J. Dex <cemail_219@(protected) > wHi
In a single instance database when i issue the startup
command the oracle software will read a
instance specific init.ora file and bring up a
instance
what happens when there is shared spfile fiI just created an SR using firefox 2.0 no issues.
thanks!
amar kumar padhi
www.amar-padhi.com
pushed from PDA
-----Original Message-----
From "Stefan Knecht " <knecht.stefan@(protected) >
To "oracSimple is good
Import into staging table with all columns varchar2(4000) and do whatever conversions checks and validations you want in pl/sql
P.s. if performance space or pl/sql knowledge is aI 'd say that there are two parts in this task
1) Requirements/logical part.
Understand how to convert these in the first sight at least for me
unclear numbers into dates and write it down in a more oI currently can 't get past the first screen if I use firefox. Only IE6 works
for me.
Has been like this for a while. No answer from oracle yet.
Stefan
On 10/4/07 Ken Naim <kennaim@(protected) > wro |
|
|
