tablespace not turning into read only mode

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

RE: Synonyms can be VERY bad for performance

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

RE: How to Identify System Tables?

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:

inactive sessions

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:

column comments for v$ and x$ tables

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

Dead locks

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,

RE: inactive sessions

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

RE: column comments for v$ and x$ tables

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:

Re: inactive sessions

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

RE: Toad vs. SQL Navigator

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

Re: column comments for v$ and x$ tables

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 column

RE:Dead locks

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,

RE: column comments for v$ and x$ tables

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

reattaching datafiles

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

RE: column comments for v$ and x$ tables

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

Tablespace Growth Monitoring

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

Re: Dead locks

HI, yes, you will find a line in the alertSID.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

Re:reattaching datafiles

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

RE: reattaching datafiles

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

Oracle Label Security

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

RE: gnarly delete statement?

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 update the

Re: gnarly delete statement?

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:

Re:RE: reattaching datafiles

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

CHARACTER SET CONVERSION

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

RE: 10.7 on sequent to 11i on sun

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

RE: column comments for v$ and x$ tables

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

RE: gnarly delete statement?

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 business

Re: surpress message.

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

RE: gnarly delete statement?

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

Grumble, grumble

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

RE: Grumble, grumble

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* ?

Install Client Tools on NT Workstation

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

TOAD-like tools for UNIX

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,

RE: Grumble, grumble

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

Re: Grumble, grumble

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 PROTECTED]

performance question

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

RE: RE: reattaching datafiles

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 )

ORA-03113 DURING DATABASE STARTUP

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

RE: Install Client Tools on NT Workstation

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

RE: gnarly delete statement?

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. He can

Re: performance question

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 client is

Re: gnarly delete statement?

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

Re: TOAD-like tools for UNIX

- 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 Linux

Re: performance question

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 a

RE: tablespace not turning into read only mode

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',

Re: CHARACTER SET CONVERSION

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

Re: ORA-03113 DURING DATABASE STARTUP

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 STARTUP

RE: ORA-03113 DURING DATABASE STARTUP

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

ERROR WHILE INSTALLING PATCH 8.1.7.2.0 ON SOLARIS

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

trace file removal

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: trace file removal

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

HELP: my desktop is in for repairs

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

Re: trace file removal

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 which

Re:Available Immediately for Contract or Permanent Position

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

OEM error

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:

Re: Base table of materialized views

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