 | | | Oracle List | | Query DBA_SEGMENTS
Select segment_name segment_type from dba_segments where tablespace_name
'USERS '
George
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-lCore dumps on f90webm 20
Any suggestions on how to troubleshoot other than opening a TAR?
--
http //www.freelists.org/webpage/oracle-l
Jeffrey Beckstrom wrote
>
>Can Discoverer be limited in some way?
>
>
>
The best way is to format the disk drives of all those who dare use it
and install Linux on their PC.
That would
What patch level are you on?
We get those also but they don 't shutdown our DB...This is a DW DB and
the issue is a bug with star transformations....
ksedmp internal or fatal error
ORA-07445Retail Company in the Greater New York City New York Area ( Long Island)
has an opening for
a sharp hands-on Oracle DBA Manager.
Selected candidate will have hands on technical responsibilities Zhu
Perhaps would be useful to have a look at what segments and type of
blocks are involved (P1&P2).
If your create_date column is a monotonically growing timestamp than
chances are that thiNeed 2 Oracle 11i Applications DBAs for contract positions in San Antonio
Texas that are
expected to last at least through the end of the year.
Can be W-2 or 1099.
Required skills are
-ExpeI was recently asked how to setup a SQL script to ensure that it
aborts if accidentally run on the wrong database. The scriptlet below
is what I came up with... it seems to work just fine but got
Would you tell us on which database event you are
spending the majority of the time?
There are many scenarious there that can lead to slow
index build.
One of these is inappropriate level ofChris Stephens wrote
>Wolfgang
>
>Is there another list out there that curious/nosy database type people
>should be aware of? )
>
>
>
No Oak Table is a group of oraclites that are suppI think you are making this bigger deal than it is but at the same time missing some serious pitfalls.
"Not a big deal "
Just days ago I tared up my 9i Oracle Home that contained Software and Databa
I put together a little PL/SQL package which basically duplicates Tom
Kyte 's "runstats " script. I have added session_event and system_event
info however and it can handle up to 5 side by side comWhy do you drop/recreate the GTT every time ? You dont need to do so.
The problem is that the optimizer thinks the GTT has many rows. You
have several options in order of recommendation
- use Hi All
My boss asked me to find out following
What is your experience in distributing a large number of stored procedures functions
etc to a large number of databases?
He is looking forLarge Company in Phoenix Arizona area (Scotsdale) has 2 openings for Oracle
DBAs
with 8i and 9i experience.
Company will consider candidates with outside the area
but No relocation assistance Hello all
back on this list after a few years I 'd like to introduce myself with a tough one
The current job at the site I 'm working at is to forecast whether the current server hardware is capaYou 'll find the patch matrix on metalink in note 301045.1 (Oracle
Critical Patch Update April 2005 Pre-Installation Note for Oracle
Database Server). Please be aware the new patch bundle is not I am receiving "Errror Thrown when IP address of a host cannot be
determined " while trying to install 9204 client on RHEL3. The error always
seems to occur during install portion of the Oracle IDropping the user without deinstalling the binaries can cause confusion
when applying interim patches. The patch sees the product directory and
assumes the product is installed so it wants to makeKean
You can do something like
select decode(count(*)
0 'Unique '
'NON-Unique ')
from mytbl
where id 3D 2
But please don 't try to write your own code for
See inline.
2005/5/18 The Human Fly <sjaffarhussain@(protected) >
> However I am not doing it for any testing or learning purpose. We are
> facing some transactions time-out in our production d
Hi )
Can trigger catch exception error ? If yes how ?
THank
JK
Discover Yahoo!
Find restaurants movies travel and more fun for the weekend. Check it out!
http //discover.yHi all DG gurus
I have run some tests of dataguard and in the it all something has
happened of which I am a little lost.
After a number of configuration errors in the two databases I had the
sOn 5/18/05 Kean Jacinta <jacintakean@(protected) > wrote
> Hi
> 20
> I have been sending bit and pieces of question into
> this forum. I manage to go this far but then i am
> stuck here again.You can also
Select id count(*)
I suggest you read up on 'Exceptions ' in the PL/SQL book.
There are thousands of examples available via google.
http //www.google.com/search?hl en&lr &q exception+site%3Aasktom.oracle.com&btnG SeaOn 5/17/05 Kean Jacinta <jacintakean@(protected) > wrote
>
>
> User accidently deleted id 3 and i want to manully
> create the id 3 again.
>
> insert into myclass (id name) values (3 'BU ') Look for patch 4163362 it 's 10.1.04 for Win32 20
Casper
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Paul Drake
Sent WednHi all
20
What is the need to mirror a log file if it is multiplexed? If
mirroring is to protect against hardware failure and multiplexing is
to protect against software corruption (or accideA Joshi
> > advanced replication DB version 8.1.7.4
> > it possible to propagate schema changes like adding column
Yes (and No).
Is possible using "DBMS_REPCAT.ALTER_MASTER_REPOBJECT " but doesn 't |
|
|
