How to keep root out?

::/home/oracle who am i costos!root pts/1Aug 28 16:45 oracle::/home/oracle --- I'd put this code in the logon trigger. I'm not sure if this will work with internal user... Greetings Diego Cutrone Just for grins, I'll ask this question... Is there any way to keep

RE: How to find the session holding the library cache pin.

to x$kglpn.kglpnuse to get the sid of the session that's holding the pin. HTH Greetings Diego Cutrone Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application

RE: How to find the session holding the library cache pin.

to x$kglpn.kglpnuse to get the sid of the session that's holding the pin. HTH Greetings Diego Cutrone Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application

Re: buffer busy waits and v$filestat

and that wait is computed as a write complete wait and not as BBW. please correct me if I'm wrong. thanks HTH Greetings Diego Cutrone Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy

testing - pls ignore

¡Internet GRATIS es Yahoo! Conexión! Usuario yahoo, contraseña yahoo. Desde Buenos Aires, 4004-1010. Otras ciudades: http://conexion.yahoo.com.ar/avanzados.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Diego=20Cutrone?= INET:

[no subject]

HELP

TEST -- just ignore

TEST -pls ignore

RE: ORA-04031

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Rowid

FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

tst

RE: Who don't I see my posting ?

you post to this mailing list. I think I'll have to unsuscribe and subscribe to see what happens. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 02, 2002 6:18 PM Diego Cutrone[SMTP:[EMAIL PROTECTED]] wrote: ok, I'm sorry Joe

TEST -- pls ignore

Just a test ....

test -- ignore

Who don't I see my posting ?

TEST

TEST

RE: Who don't I see my posting ?

ok, I'm sorry Joe. But I really do not see my own postings. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 02, 2002 4:18 PM its showing up, ur test works. cease and desist. joe Diego Cutrone wrote

Test - pls Ignore

test - pls ignore

v$sqlarea question.

ðø1069627CHOOSE 2002-08-28/16:16:1310 246 0 2The Seq value represents occurrences taken atdifferent moments along a day. Seq 1 was taken at 9 am in the morning, seq 2 at 9:30 , and so on... TIA Greeting Diego Cutrone

RE: MEMORY USAGE

_filesystemio_options='directIO' and you'll be using direct io for the FS datafiles. This will save you memory and will boost your performance. If you're on Raw devices you should use Async I/O (KAIO in solaris to be precise) HTH Greetings Diego Cutrone Any suggestion ...Thanks in advance

RE: Async I/O question

: Async I/O question Could the unknown297 call be for post/wait (postwait driver). As that is what is missing in the trace. Anjo. Diego Cutrone wrote: Hi list.Oracle 7.3.4.5IBM 4.3.3Raw devices based datafilesuse_async_io=TRUEWhile the database was processing some long update

RE: Enqueue and DB File Sequential Read Waits Problem

enqueue waits of type TX. right? So it must be another type of enqueue problem. Find out which type of enqueue problem you have. select * from x$ksqst where ksqstwat != 0 HTH Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: EXPORT FAST?

I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 3:13 PM Hi one of export for 35GB

Re: Oracle Exports and performance

Hi Ron: Comments inline HTH greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 1:18 PM This has probably been discussed before but I would like to know if a full database export could affect

Re: Users reading from rollback segments

, correct me if I'm wrong. Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 12:18 PM Thank you all. I agree now that there is no way to tell if someone will need the rollback segment data, EVEN

Re: Users reading from rollback segments

later in its current run (which started prior to the commit). I think that there's a way you can be sure that noone will need to read some RBS blocks for a cleanout operation. Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

RE: Library Cache wait -- Who is holding this latch

Title: Message you'll have to take a library cache dump and look for the latch number displayed in the P1 Field of your query. HTH Greetings Diego Cutrone - Original Message - From: Gupta, Brijesh To: Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002

RE: used segment space in bytes

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Checkpoint Redo ratio(High)

should enlarge your redo logs. HTH Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 4:25 PM Hi I checked my database and see redo ratio is high. I ran the folling query select (req.value * 5000

RE: USER DUMP HOW?

yes, you can use TOAD or SQL*NAVIGATOR for that. Or you can write your own scripts, I have found this one between my scripts, I have never tested, I prefer to use Import/Export for that kind of job. HTH DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

RE: DBA Experiences with Oracle and RAID 0+1

-in track buffer cache for storing an entire track's worth of data from read request(s). HTH Greeting Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 10:25 PM Jon, It's one of those how many bags will I need

RE: Freeable memory

- HTH Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 7:10 PM All, In trying to solve some Library Cache latch contention issues, I've been stumped on the following issues: 1) Do freeable chunks get

RE: used segment space in bytes

are in the freelists. You can alsouse this query to know how many blocks hold at least one row: (ORACLE 7) SELECT COUNT(DISTINCT SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8)) FROM TABLE. You can easily change it to work in Oracle 8 too by using the dbms_rowid package. HTH Greetings Diego Cutrone

RE: Off Topic: Australian Visa

Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 "Diego Cutrone" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/12/2001 05:10

Off Topic: Australian Visa

Sorry for the off-topic. I'm from Argentina, and I'm finding out what the steps I should follow to get a visa (for working) or may be a sponsor in Australia. (A friend of mine told me that Oracle proffesionals have a good chance of getting a job in this country) I hope that someone can

RE: buffer busy wait latch free ( cache buffer chain )

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL

RE: total tranx ran

of the transactions, since instance started, but not the cumulative. -Original Message- Sent: Friday, November 30, 2001 1:41 PM To: Multiple recipients of list ORACLE-L if you're using Oracle 8 check v$resource_limit.transactions view HTH Diego Cutrone - Original

RE: total tranx ran

if you're using Oracle 8 check v$resource_limit.transactions view HTH Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:05 AM Hi lists, Does anybody have a query to find , how many transactions ran

RE: commit rate

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: no-routine log file sync

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL

x$kglob -- keeping objects

Hi list.My intention is to keep cursors as they are beingused, according to the SHARABLE_MEM they use, theLOADS and PARSE_COUNT.So I checked x$kglob and v$sqlarea too (just to see ifthe information there matched the first one)And my problem is that V$SQLAREA.SHARABLE_MEM (202400bytes) does

RE: CI locks

It's related to Cross Instance Call, For instance, when you drop (truncated) a table Oracle has to flush this table's buffers out from the Buffer Cache, so it issues a cross instance call. These calls are used even if you're not using OPS. HTH Diego Cutrone - Original Message

KEEPING CURSORS -- x$kglob

w can it be possible that every cursor in theinstance has this state? Please tellme what am I doing wrong here? TIA Diego Cutrone

RE: Copy of redo

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: 11 disks to build a DB, suggestions

? Regards Rahul -- From: Diego Cutrone[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 4:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: 11 disks to build a DB, suggestions Hi Rahul, Here's what I think. I would

RE: 11 disks to build a DB, suggestions

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Set transaction use rollback??

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: enqueue waits -- CI (still remains)

selected. Thanks Jeffery Diego Cutrone wrote: Thanks for answering Unal, John. John, you were right about the query. I've corrected it. And I'm not getting T[ and CK anymore,now I get TX and CI. I've also done further investigation and I also know now what p2 and p3 mean

RE: enqueue waits -- CI

total_waits time_waited pipe get910593342266184 Thank you. DC - Original Message - To: Diego Cutrone [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:53 AM Hi Diego, No, those

RE: ....A drop schema script ??

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: DB Link Between Prod and Test?

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: newbie question

://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

enqueue waits

Hi List, I'm trying to identify the possible cause of contention in a database: Oracle 7.3.4.0.0 // HP-UX 10.20 // FINANCIALS As far I can see, event "enqueue" is on top (followed by some buffer busy waits) EVENT TIME_WAITED AVERAGE_WAITenqueue 854176 3746.39 (why is the

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? I agree with that Matthew. But if you still have touse the link make sure you give the user the appropiate provilegesand assign him a "profile" to limit the ammount of resources he can consume with his queries. This way he can't slow down the prod

RE: Buffer busy waits -- p3=1012 and 1016

Steve, thank you very much for your help. - Original Message - To: Diego Cutrone [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 8:32 AM Hi Diego, There is a subtle distinction between reason codes 1012 and 1016

Buffer busy waits -- p3=1012 and 1016

Hi list,I'm analyzing parameter "p3" from trace 10046 level 8 and I've got some doubts about it.What is the difference between p3=1012 and p3=1016?According to some docs I've read, 1012="A modification is happening on a XCUR (or SCUR)buffer and it has not yet completed" (and I think thatthe

RE: dbms_space.free_blocks does not report correctly ?

Thanks Trivedi and Brian, I think that you may be right about chained blocks, I'll check this out. - Original Message - From: Brian MacLean To: '[EMAIL PROTECTED]' ; 'Diego Cutrone' Sent: Friday, April 20, 2001 4:34 PM Subject: RE: dbms_space.free_blocks does

RE: help - spool file name - use variable

Hi, I don't quite understand your question, so here's what I understood: Just enclose the variable name with "{ }" , here's an example /home/oracle export temp_variable=TEST/home/oracle echo "this_is_a_$temp_variable_only"this_is_a_ -- wrong/home/oracle echo

RE: Can you create a database link back to same database?

-- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Event 10351 -- Async I/O on Solaris

Hi, list. Has anyone used "event 10351" ? I'm checking for Async I/O on Solaris 2.6, Oracle 7.3.4 It works just fine over Raw Devices and It does not over FS (as usual). I can see this on a OS trace. But searching on metalink I've found this: "Event 10351 is also used to get information