Hi lists,
I am trying to put my tablespace into read only mode(This is to take the
transport tablespace export). When i typed
alter tablespace xyz read only;
it is just getting hung. Even after an hour the command is not being
executed.
There are no users accessing the objects in that tablespa
One option you could pursue is:
a) set optimizer_mode back to choose (as you've done)
b) create a logon trigger (for everyone) which set
optimizer_GOAL to first rows - so your dictionary runs
as choose (ie rule), but your sessions run as
first_rows (which I presume is your preference).
For those
Title: RE: Alter different session
I was interested in this as well and all I could find was the followng Metalink Note which refers to setting tracing on not altering a different session. It also refers to a package DBMS_SUPPORT which seems to fit the same purpose but appears relatively shor
Title: RE: How to Identify System Tables?
Try a schema compare against the development instance (I assume you have one)
There are plenty of places that are likely to have one
Try http://www.timonions.com/ or http://www.vampired.net/ for starters
John
-Original Message-
From: Rahul
Hi
can anybody tell me
when a sessions status becomes INACTIVE in v$session?
thnx and regards,
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hi lists
Is there a way to see the description of the column,means what value the
column stores
for v$, x$ tables.
eg: desc v$session
we will see the column like...
SADDR
SID
SERIAL#
AUDSID
PADDR
USER#
USERNAME
COMMAND
O
Hi lists,
If a dead lock occurs , will the statements be rolledback by oracle ?
will oracle do anything other than dumping trace?
I tried. But both session never comeout. Just they hung.
Regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Sh
An INACTIVE status means that the process is still connected to Oracle but
not running a query. These are
valid connections and will not be cleaned up.
It is the job of the pmon process to clean up dead connections. It usually
wakes up approximately every 5
minutes.
Rick
-Original Mess
There is some description in Oracle Reference Manual for V$ tables, for X$,
you'll have to learn it from a Guru ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is person
srinvias,
Do you have the Oracle Reference Manual? If you look for the descriptions of
each of the v$ views, they give all the info you are looking for. The x$
ones are not listed though..
HTH
Mark
-Original Message-
Shrinivas (MED, Keane)
Sent: Friday, November 02, 2001 12:00 PM
To: M
When the session is doing nothing or sometimes when it
is executing a plsql. However and regarding
inactivity, you should query v$session_wait for the
event: SQL*Net message from client. And also look in
the column seconds_in_wait, just to know the amount of
time that it has become idle.
Note tha
Look at TORA, for the cost ($0.00) it is a nice tool ... not way too many
features ... but good ones only ...
Look it up at http://www.globecom.net/tora/
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
The names from V$FIXED_TABLE and comments of the
columns from catalog.sql script. More detail from
Oracle Reference manual.
Regards.
--- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote:
> Hi lists
>
> Is there a way to see the description of the
> column,means what value the
> co
Statement is rolled back and not the transaction.
binay
***
Hi lists,
If a dead lock occurs , will the statements be rolledback by oracle ?
will oracle do anything other than dumping trace?
I tried. But both session never comeout. Just they hung.
Regards,
Sr
The v$ are views, not tables. And for the x$, I believe that you have to be
connected as SYS or internal to see them
Dave
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L
Hi lists
Is there a way to see the
Hello all,
When a tablespace is dropped, the datafile is left on the disk. What
exactly is the drop tablespace command doing, and is there a way to get
that datafile and "re-attach" to a new tablespace in some way? For
example, creating a tablespace using that datafile, but without wiping
it, as
Hi,
For V$ views you can find the details in Oracle Xi Reference Manuals.
For X$ tables the information is not documented externally.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Shrinivas (MED, Keane)
Sent: Friday, November 02, 2001 4:00 AM
To:
Hi all,
First a Big Thanks to you all for sharing your knowledge and tips on this
forum. By using some of that wisdom I am making my transition from developer
to a DBA (or as we call it here 'The Dark Side').
First job I have is to monitor table growth, so I created a small table, and
wrote a sc
HI,
yes, you will find a line in the alert.ora that specifies the trace
file
in which you can find information about the deadlock.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 1:00 PM
> Hi lists,
>
> If a dead lock oc
Guy,
The 'drop tablespace' command does a number of items. It purges the data
dictionary of all references to that tablespace, removes the file information
from the control file, closes the datafile(s) and releases them back to the
operating system. All that being said, if you then want to
Hi Doug,
Thanks for the reply. Incidentally, they did use to use re-cycled
parchments, called palimpsests, in ancient times. There was a magazine
article I read recently about some writings of Aristotle (or one of his
students/descendants) being recovered. His manuscripts had been bleached
and re
Ooops, I mean 'Dick', I was looking at the "dg" in your email address!
Sorry about that! :0)
g
-Original Message-
Sent: 02 November 2001 14:05
To: Guy Hammond; Multiple recipients of list ORACLE-L
Guy,
The 'drop tablespace' command does a number of items. It purges the
data
dic
Hi. I've been asked to look into this component for 8i, and I wasn't
aware this even existed. Couldn't you just create views, or am I
being naive?
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Wiegard
INET: [EMAIL PROTECTED]
Fat City Network Ser
Unfortunately, no. I'm working on the application development side;
the "real" DBAs are in another department and the usual turf-protection
attitudes apply.
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> don't suppose you can properly
> normalize the tables through
> materialized views and updat
Oops...no, I meant to say "keep" the one with the latest insert
timestamp and delete all of the others. Everyone seems to have caught
the error; deleting the latest would allow duplicates to remain if
there were more than 2 duplicate rows!
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> t2.ti
Guy,
Not as problem, I've been called a whole lot worse in the past. Also, nice
piece if info on the old monks, and yeah that is one heck of a DB recovery or
more likely a resurrection.
Now to your point, when the datafile/tablespace gets dropped Oracle first
off won't let you simply dr
Hi,
I am putting this question again but we need little more input...
We are currently using database character set WE8ISO8859P1.
As we are storing unicode data using NVARCHAR2 ..and we are having some
problem with ODBC hadling NVARCHAR2...
So we decided to move to character set UTF8 so that
Well, that's certainly productive!
hmmm.so you're a DEVELOPER, eh?
hehhehheh
time for Plan B: make their life
hell until they relent and give you
some breathing room. As a Senior
DBA, you are perfectly placed to do
this!
-Original Message-
Sent: Friday, November 02, 2001 9:55 A
When you're dropping a tablespace it is final. Period!!
If you want to "drop" a tablespace and re-enable it you have to export the
tablespace ie. use "Exportable Tablespace" in the export command for Oracle
RDBMS.
The sort of dirty way is to get a backup of the database WITH the tablespace
and T
Reed,
I've done similar Finapps upgrades for clients in the past. If you want to
minimize the number of steps, try this:
1. Install 8.1.7 on the Sun and create then empty DB.
2. exp/imp the db from the Sequent to the Sun
3. Install 11i on the Sun and run the upgrade.
You don't need 10.7 i
I have a zip file which contain the list of all x$ tables and structure, may
be it's help
-Original Message-
Sent: Friday, November 02, 2001 5:00 AM
To: Multiple recipients of list ORACLE-L
The v$ are views, not tables. And for the x$, I believe that you have to be
connected as SYS or
How about this:
delete from stupid_table s
where timestamp != (select min(timestamp)
from stupid_table
where b = s. b
and c = s.c
and d = s.d
and a = 2)
and a=2;
>
> Given a busines
Dear DBA
Help : how to surpress those msg when running the kshell
Mitchell
Result currently got: spool /usr/oracle/drop_user.sql
cgoqats:system SQL> select 'DROP USER '||USERNAME||' CASCADE ;'
2 fromDBA_USERS
3 where USERNAME not in ('SYSTEM','SYS') ;
DROP USER APPLSYSPUB CASCAD
Naw...Paul is a Major NYC DBA...he
doesn't need *any* coddling whatsoever.
He can parse his way out of any wet
paper bag..
-Original Message-
Sent: Friday, November 02, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Go easy RossI'm a Developer too... ;o)
Be gentle wit
Anyone ever see *this* ? They sure don't apply patches the way they used
to. Why, when *I* was a child, we applied patches with spit and mud and
hay, and they didn't complain about no '=' character neither, by gum...
Bambi.
oradev> /u05/dfinappl/ad/11.5.0/bin/adpatch c1
The first thing adpatch asks for is the log file name, then the database
name, system password, apps password, patch directory, patch driver file
etc. . .
-Original Message-
Sent: Friday, November 02, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Anyone ever see *this* ? They
We are trying to install Oracle Client Tools from the Oracle8i Enterprise
Edition CD on Windows NT 4.0 Workstation with Service Pack 6. We have just
bought new machines and cannot install the client tools on any of our new
machines but can on old machines with the same OS. The problem occurs on
Are there any Unix/Linux/Solaris tools that work like TOAD or SQL Nav?
Venkat Somusetty
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Venkat Somusetty
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Calif
Never saw this one, but I'd guess that there was an error in the driver file
(that I have seen...). Take a look at c1880630.drv and see if you can find
a missing '='. Do you get the error if you run this interactively (without
the driver file name on the command line)?
Gary
Gary Kirsh
Next Ext
You darn skippy, Bambi. We never got specific error messages,
either. Just got something like 'patch failed' with no reference to where
or why. The world's gone soft since the days when 'computer people' all
wore white smocks and carried boxes of punch cards around.
Jim>>> [EMAIL PROTECT
Hi
I saw v$session_wait and found event "SQL*Net message from client" is having
wait_time=0 and second_in_waits value is high.
I checked every ratio looks good and users are not having any problem.What
could be problem?
Thanks
SEEMA
Hi Dick...
Along the lines of your last comments... Instead of waiting for Oracle,
you can implement a home grown solution... First, create a external
procedure that removes a file from the OS... Then, create a procedure
that...
Accepts tablespace name ( and maybe cascade option choice )
De
Hi,
We have just created the database on solaris unix box and we are able ro run
all applications.
But when we reboot the sun box and try to start database we are getting
error ORA-03113.
I tried all the points which are specified in metalink articles..
Following one of the articles i tri
Sharyn,
Are those pentium 4's? I believe this is a known issue. Go to metalink and
do a search for DocID 131299.1. It has all the details
Dave
-Original Message-
Sent: Friday, November 02, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
We are trying to install Oracle Client
Thanks, Ross, for the compliment.
I'm a minor Kentucky DBA now. I work in the development group to give
them the support they're not getting from the "real" DBAs.
PB
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Naw...Paul is a Major NYC DBA...he
> doesn't need *any* coddling whatsoever.
>
>
There is no problem. This event indicates that the server process is
waiting for the client to ask it to do work. seconds_in_wait shows the
elapsed time while the status = WAITING.
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> I saw v$session_wait and found event "SQL*Net message from clien
t2.timestamp < t1.timestamp will delete the latest.
It will actually delete anything greater than the earliest. You will
notice I wrote
Delete where exists ...
which means delete anything where there was a match with an earlier timestamp.
At 06:10 PM 11/1/01 -0800, you wrote:
>t2.timestamp >
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 19:30
> Are there any Unix/Linux/Solaris tools that work like TOAD or SQL Nav?
>
the one that was already mentioned today - TOra
(http://www.globecom.net/tora/ ) has a Li
On Fri, 2 Nov 2001, Seema Singh wrote:
> I saw v$session_wait and found event "SQL*Net message from client"
> is having wait_time=0 and second_in_waits value is high.
> I checked every ratio looks good and users are not having any
> problem.What could be problem?
Lazy users.
This event is just
This still very beta, but looks promising
http://sourceforge.net/project/showfiles.php?group_id=16636
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 6:30 PM
> Are there any Unix/Linux/Solaris tools that work like T
When read only tablespaces first came out, the database had to have no
transactions on it before you could to alter a tablespace to read only...
In recent releases, Oracle has improved this significantly... But, that
does not mean it is clean... If you issue a 'alter tablespace XXX read
only', i
If the character set you are going to is a superset of the old characterset
then you won't have to do anything. If it is not, you will have to export
and import the database to have the new characterset be good for all ot the
data.
HTH,
Ruth
- Original Message -
To: "Multiple recipients
Did u check shared memory and unix parameter?If UNIX parameters are ok then
please try to start with mount options.
-Seema
>From: Harvinder Singh <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: ORA-03113 DURING DATABASE ST
Hi!
Happened to me once. Somehow the init ora file had gotten "corrupted" with
unprintable control characters. Solved the problem by recreating a new init
ora by retyping. If you have ftp'ed the init ora file from another system,
make sure that it was in ASCII format.
pramo chepuri
-Orig
Hi,
We are trying to apply patch 8.1.7.2.0 . During installing patch it gives
following error during linking:
unable to write to file ins_rdbms.mk and i give ignore ..
when later on i try to link it manually as:
make -f ins_rdbms.mk ioracle
i am getting fatal error:
fatal: file /opt/oracle/O
Which trace files can I remove and which ones shouldn't I remove. I used to
remove all trace files two week old or older, but found that even though I removed
them the database still thought it was writing to them. When I went to look at the
trace files specified in the alert log Oracle had not re
I hope it's not bad to post a resume - I've seen people post positions.
Michael E. Cupp, Jr.
7848 Crossover Blvd
Columbus, OH 43235
Phone 614.799.0033
Fax 614.799.8640
E-mail [EMAIL PROTECTED]
Professional Experience
Feb/2001 to Oct/2001CCAi Consulting Cleveland, OH
Sr. As
I used to just drop trace files created before the last restart of the
database.
-Original Message-
Sent: Friday, November 02, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L
Which trace files can I remove and which ones shouldn't I remove. I used to
remove all trace files two wee
Would someone please send me the schedule for 9i features, so i can
prepare for next weeks.
thanks, joe
--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my
fuser should tell you if they are being written to at
the moment. Otherwise you could use the routine
dbms_system.read_ev to see which sessions have 10046
set - if they do, then keep the trace file
hth
connor
--- David Turner <[EMAIL PROTECTED]> wrote: > Which
trace files can I remove and whic
Why not! And good luck.
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
I am evaluating OEM, and occasionally (2-3 hours) I get the following
messages:
VTM-0002: Error displaying User Type Locks Charts
ODB-01007: Error: Oracle FETCH query results failed
ORA-03113: end-of-file on communication channel
ODG-05560: Error: failed calling collection cartridge
ODG-05138: Er
There are a number of common techniques, but the one I prefer is to:
1) create a text file with a set of usernames/passwords - one per line
(e.g one line might be "sys change_on_install")
2) Put the script somewhere secure and make it a hidden file (e.g.
.userpass) Also, chmod it so only th
Yeah.. I know I am late...just catching up.
If you are still looking for some
workaround...*TEMPORARY* workaround is to use
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH (TRUE) and then you
can do DMLs. But bewareall replication triggers
would be disabled when you set it to true. After you
are done set it
64 matches
Mail list logo