RE: How to update "maxphys" on Solaris 8 ......

Janardhana,   Check this link.   http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert/23249     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janardhana Babu Donga Sent: Friday, January 16, 2004 12:09 PM To: Multiple recipients of list ORACLE-L Subject: Ho

RE: Change Manager

Nothing is so important. It is just the gentle man below wanted to know how he can keep track of changes on his objects, this is an option open to him. George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit

RE: Change Manager

Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. George __ George

RE: Finding SID of current session

V$mystat, to what would you join this to understand the values/statistics, v$session_event? George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit) Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27

Finding SID of current session

Hi there all. How can I find the sid of the current session, I got a pl/sql procedure that needs to do a select from v$session_event but only want to do it for it's own session so I need to know this for the where clause ? George __ George Le

Development vs. Production DBA

orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE you

Development vs. Production DBA

orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE you

RE: Any German here ? Character set

Title: Any German here ? Character set Correct   The difference between the P1 and P15 is P15 got P1 + euro support.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell

Oracle 9i (9.2.0.4)- RH AS 2.1 HP Itanium

Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573

RE: any script to parse alert log ?!

Hi there Hope this helps. First the ksh file. #!/bin/ksh # # File : check_alertlog.ksh # Created : 01/02/2002 # Modified : 04/02/2002 # : 20/02/2002 Removed the CC for the email # # By: George Leonard ([EMAIL PROTECTED

Re: CASE in PL/SQL

You don't need CASE. try : to_char( date , 'Q') George > Hello ALL, > > I am trying to find quarter number from a given date . Here is the > description > > Our Financial year runs from July thru June. So, Given any date between > these dates I need t

Database components

-8371 Never take life seriously. Nobody gets out alive anyway -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Update Teradata table from 9i

or: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this ma

Date conversion

? Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have

RE: Database tracking

Title: RE: Database tracking Are you willing to share the solution with us ?   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573

RE: Installer does not run on Win 2k Service Pack 3

Hi there If this is being run a P4 have a look on metalink for Pentium 4. There is a workaround you need to follow. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel

RE: email out of oracle

is ready for future machines. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http

email out of oracle

SQL> print NP -- -29540 Package executed with following command: var np number; exec send_mail('[EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'testmsg', :np); Below is the code of the send_mail package, can anyone see the problem or know what t

RE: Statspack Viewer

http://www.geocities.com/alexdabr/ George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: 082 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http

RE: Statspack Viewer

Hi there Been using it on and off for 2 yrs now since the original standard edition. Very good and def worth while, Alexey also normally releases a new/updated version every 1-2 months. There is some great features planed for the future from discussions with him. George

RE: import and rollback segments

e pls forward me the title of the book, someone asked me for it, know if I go to borders will find it just can not remember at the moment, Thx all, have a good weekend. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Re

import and rollback segments

only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+

RE: Oracle & SAN Experiences?

Title: The Sys Hi there   What are the thoughts about the Xiotech - Magnitude.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576

RE: OT ksh day of week yesterday

spelling of 'ListGuru') 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.co

RE: LOCALLY MANAGED TABLESPACE

tablespace and the second user on the LM nd see if you can convince your boss now as the best time, They like to see that it works. If it does then they will sya yes sooner. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg

why is this happening

;Y' Tablespace #3 is temp, 800 MB, 128K extent size locally managed. The user is also set to use temp. If I do a alter session set sort_area_size=20M then it completes. Currently the sort_area_size is set via the init file as 5 mb. Ideas ? George ___

Index Partitioning

will always go this way.   Basically trying to reduce the work for Oracle to get to data. All my queries is already using the best possible index.   Comment, suggestions   thx   George ____ George Leonard Oracle Database Administrator Dime

RE: DB monitoring using SNMP MIBs

_$rollname r, v$rollstat ss, sys.undo$ ud, sys.seg$ sg, sys.ts$ ts where ud.us# = ss.usn (+) and ud.file# = sg.file# and ud.block# = sg.block# and sg.ts# = ts.ts# and ss.usn = r.usn and t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_tim

Siebel + Oracle on Sun ?

Site#1 UK (1st E10K): Users 200+ Site#2 USA (2n E10K): User 800+ Domains #2 and #3 for other db's George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576

RE: LOCALLY MANAGED TABLESPACE

accepting it when you tell them how long something takes.   Then you have the manager that managed Oracle some time ago that remember DMT and have worked with LMT so converting them is difficult.   George George Leonard Oracle Database

RE: LOCALLY MANAGED TABLESPACE

educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd

RE: Rollback segment space usage

Hi Kevin, Fantastic, thx, just what I was looking for, will event tell the oracle support person that could not even assist. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575

Rollback segment space usage

fuel gauge). Any takers. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The

RE: login trigger

Title: ROWID question? Problem solved     You can get the sid from v$mystat, having this we can then query v$session for the rest.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987

login trigger

thx   George ____ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:   http://www.didata.co.za   You Have The Obligati

FW: Siebel NOTE number for approving CBO for EIM

Title: Message Hi guys.   That Siebel note about CBO that was asked for.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E

Cost of joins

Hi there Can someone please give me in order of preference/cost the relevant costs for the different joins. IE: This join is cheap, This is very expensive, This is bad and always avoid. George George Leonard Oracle Database Administrator

RE: logon trigger

Hi there Your' the man, the people here laughed when we saw this working and that was the problem. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11

RE: logon trigger

iate 'Alter session set OPTIMIZER_MODE = choose;';    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;'; end; /   George ____ Geor

RE: logon trigger

Thx, I also found this last night.   I will wait for the developers so arrive so that they can test their process.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel

RE: logon trigger

the user, setting it's session to CBO etc etc. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:

RE: logon trigger

E = 10485760;';    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';   end; /   George George Leonard Oracle Database Ad

logon trigger

query; Alter session set SORT_AREA_SIZE = 10485760; Alter session set OPTIMIZER_MODE = choose; end; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax

RE: Determine process of index build - HOW

v$sqltext s where a.sid =b.sid and b.sql_address = s.address and a.sofar <> a.totalwork order by b.sid, last_update_time /   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: 

Determine process of index build - HOW

Hi there How can I see how far my index build has is. I got a table with 43 mil records. It is taking forever as expected but would like to see how far it is, Any idea. Oracle 8.1.6.3 (32Bit) on Solaris 2.6 on Sun E10K George George Leonard

RE: Staspack Grapher/Viewer ?

http://www.statsviewer.narod.ru fantastic product. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http

Re-creating control files with larger maxdatafile setting

Hi all Does someone maybe have a step by step guide to re-creating the control files. I have found that one the my databases the maxdatafiles has been set to small, would like to increase it now. thx George George Leonard Oracle Database

RE: bind variables

If you want to show anyone the different in seed between using bind variables and not using them Tom Kyte's Expert one on one got a nice example, it is in chap 2 or 3 I think. George George Leonard Oracle Database Administrator Dimension

RE: Oracle 9i and memory required

Hi I got it working with 384MB on redhat 7.2, Dell Optiplex GX1 desktop. (test install). George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail

RE: How to speed up import

Import with indexes=n Then build index creation script with indexfile= incrfile.sql rows=n Then use sqlplus user/password @incrfile.sql George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel

Re: buffer cache

On Tuesday, June 11, 2002, at 09:08 PM, BigP wrote: Hi Guys , IS there any way I can find what is occupying how much of buffer cache . Like .. what table is taking most of space etc . Thanks , Bp // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343

ColdFusion and Oracle

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

Re: EMC Storage Array Issue

). George On Tuesday, April 16, 2002, at 05:38 PM, James A wrote: > One Reply from Oracle > > Dear Customer, > > Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site > to download the patch referenced below. > > Patch: 1685984 - DBWR TERMINATES WITH ORA-27062 AFT

Re: EMC Storage Array Issue

less asynchronous. On Monday, April 15, 2002, at 06:23 PM, Anjo Kolk wrote: > George, > > Those writes are unbuffered (so synchronous) and each thread will write > them > out and will wait for the write to finish and then update the AIO > control > block in the parent threa

Re: EMC Storage Array Issue

t they bypass buffer cache, but I think it's misleading to call those 'synchronous writes', they're asynchronous, unbuffered writes. 14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef | grep dbw | grep -v grep | awk '{print $2}'` kaio(AIOWRITE, 39

Re: EMC Storage Array Issue

lem (basically all IO to the symmetrix blocked, and the asynch io's timed-out. George On Monday, April 15, 2002, at 01:19 PM, Scott Canaan wrote: > Claudio, > I didn't think to mention the process. It is always the ckpt > (checkpoint) > background process that reports

Cold NT backups

://www.orafaq.com -- Author: Rusnak, George A. 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

SQL using UTL_FILE

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

OT: Informix User Group

I have just been given responsibility for two Informix databases. Can anyone give me a link to an Informix user group? TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City

RE: Length of LONG datatype - ANSWER !!!

le says that the LONG datatype will soon be phased out. If you can fit your data into 4000 or fewer characters, use VARCHAR2. If not, go for CLOB/BLOB, which require a little more overhead, but are much more useable than LONG. Paul Baumgartel Adept Computer Associates, Inc. [EMAIL PROTECTED] -

Length of LONG datatype

: Rusnak, George A. 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, send

Re: free buffer waits

Sounds like the write latency on your storage is high or you have an abusive. 'free buffer waits' is the db writer failing to flush it's cache fast enough to disk. George On Thursday, March 7, 2002, at 06:39 PM, Manytrees wrote: Hello all,   Does anybody know what paramet

Re: New iMac as dba workstation

his is all part of a grand experiment, and I have to say that for me it's a marginal success at best. The cut-and-paste between Aqua and XDarwin is poor, which makes Tora only marginally useful for me. I would kill for OCI libs for OSX and a port of Golden. George On Monday, March 4, 20

Has Anybody Used Domain-Prefixing on WinNT4/8.0.5 SE

n share some of your hard-earned tips. Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: OS authenticated from Outside Domain/Firewall: PLS. IGNORE

Please ignore this for now. I think I've found something. George -Original Message- Sent: Wednesday, February 27, 2002 10:15 AM To: LazyDBA.com Discussion We have a jsmith account that is OS authenticated in our TEST database. This account also exists in server X which is outsid

OS authenticated from Outside Domain/Firewall

since the username had an OPS$ account it let it through. Is there some setting that I needed to configure to force Oracle to validate both the Domain and User names? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena INET: [EMAIL PROTECTED]

- OFF TOPIC - Corporate Data Model

ments, articles, PLEASE. Thanks Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- P

Two whitepapers, for interest and comments

(http://www.omniti.com/~george/sizing_wp.pdf) Using Cached QuickIO to Accelerate Oracle on Small Memory Systems (http://www.omniti.com/~george/qio_wp.pdf) Best, George // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // 1024D/1100A5A0  1370 F70A

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

7; AND sw.p1raw = lh.laddr AND ln.latch# = sw.p2 AND se.sid = lh.sid AND se.sql_address = sq.address AND se.sql_hash_value = sq.hash_value // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0  1370 F70A 9365

Re: Async I/O on Sun Solaris

Works like a charm against qio files as well. May work on vxfs (I haven't checked). It may be a metter of definition, but I wouldn't characterize not working on ufs as not working on Solaris. That seems an overly sweeping statement to me. George On Saturday, February 16, 2002

Re: Async I/O on Sun Solaris

ling list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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 inf

Re: BIG DATABASE second post

587109096 bytes per minutes in SQLNet traffic. The website itself does 195Mb/s at peak. We have a gigabit Ethernet drop from a major provider. George // George Schlossnagle // www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN // Smarter than adding another team member, Pythian has ne

RE: Linux taking over at Oracle

>now is the time to buy! it's cheap! True. But it's not going to get any higher either (my own prediction) :) George -Original Message- Sent: Friday, February 01, 2002 10:52 AM To: Multiple recipients of list ORACLE-L "Not selling my Oracle stock... yet."

RE: Re[2]: Linux taking over at Oracle

I hate that psycho up there they call CEO in Oracle. George -Original Message- Sent: Friday, February 01, 2002 6:30 AM To: Multiple recipients of list ORACLE-L I think Larry lives in his own dream world. We're currently using Oracle on inexpensive Linux servers, but that probab

RE: Connection problem

:RE: Connection problem Is tnsnames.ora pointing to the same place on both servers? -Original Message- Sent: Friday, January 11, 2002 1:15 PM To: Multiple recipients of list ORACLE-L "Rusnak, George A." wrote: > > Group, > I have a development and a production s

Connection problem

I have passed this info on to my POC at the remote host. Can anyone either explain this or suggest places to investigate to resolve this issue. TIA Al Rusnak DeCA: 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A.

Re: EMC Not Releasing Space

tably vxfs) have had bugs were the tools 'lied' about allocation information. HTH, George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7

Convert ACESS to Oracle

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

Re: Shared pool wait for library cache pin

> George, > > Just checked again right now.Following is the result that I got: > > SQL> select version_count, count(*) from v$sqlarea group by version_count; > > VERSION_COUNT COUNT(*) > - -- > 1 48241 >

Re: Shared pool wait for library cache pin

, then that is a good workaround. If not, a bounce will clearly take care of it. How fast are your version count/invalidations growing? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 8:40 AM >

Re: Shared pool wait for library cache pin

tions are likely stemming from: http://www.ixora.com.au/scripts/sql/whence_invalidations.sql George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-ca

Re: Shared pool wait for library cache pin

> George/Arun, > > Thanks for your helpful replies. This information may help me > explain the performance problems that peaked yesterday. > > I do have timed_statistics set to true and my version is 8.1.5. and sql_trace? There are some workarounds posted in the bug re

Re: Shared pool wait for library cache pin

ausing you a service problem currently, I would still keep an eye on it, as the version_count for queries rises, the chances of getting severe contention on the library cache latch increases. George // George Schlossnagle // www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN // Smarter than addi

Re: Shared pool wait for library cache pin

Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM > > We are seeing a lot of shared pool waits (fo

Re: VLDB backup policy

One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete backup plan in and of itself. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednes

Re: Determining Striping

index-e-01 index01-01 index-e 019436160 4/0 c3t2d14 ENA 5 columns of 64k stripe size in a single (unmirrored) plex. (HW mirrrored, for those who care). George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has

Re: VLDB backup policy

00+ times) more expensive than tape, gig for gig, and doesn't allow for multiple versions (unless you have a bunch of extra arrays lying around, see caveat 2 regarding $'s) George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> S

Re: x$ksmpp table question

That was how I spotted the bad processes in the first place. Now I want details on what is swelling their pgas. x$ksmpp will give that for my own session, I want the same information for the sessions in question. George On Saturday, December 29, 2001, at 08:10 AM, Deepak Thapliyal wrote

Re: x$ksmpp table question

Ok...  but that doesn't answer my original question either and I also then have to post-process it.  If I could query x$ksmpp for it, then I could get the info online.    'You can't do it' is a fine answer as well     george   - Original Message - From:

Re: x$ksmpp table question

I want access to the fll heap structure though.   My process pga is huge, I want to see what the allocations are.   George   - Original Message - From: Khedr, Waleed To: Multiple recipients of list ORACLE-L Sent: Thursday, December 27, 2001 2:20 PM Subject: RE

x$ksmpp table question

or an arbitrary shadow process (in particular, not the one associated with the ssession running the query).   Thanks,   George   --- http://www.pythian.com --  [EMAIL PROTECTED] --  877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monit

weird pga swelling

ular query. Any thoughts? This seems like a PGA memory leak to me. // George Schlossnagle // www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN // Smarter than adding another team member, Pythian has new services // for supplementing DBAs: get our help with monitoring, 24x7 on-call, // daily v

Re: retrieving objects usign OCI

uld forward some links for it, I'd be appreciative. Best of luck, George > > I'd appreciate any further comments. > > Thanks and regards, > Siddharth. > > --- George Schlossnagle <[EMAIL PROTECTED]> wrote: >> No offense, but you couldn't have looked too h

Re: retrieving objects usign OCI

l examples for you. I would recommend looking at libsqlora http://www.poitschke.de/libsqlora8/ a wrapper library for oci. It will either do what you want (if you want to just use that instead of oci), or looking at it's implementation should give you all you need to know about using oci. Ge

RECOMPILE INVALID OBJECTS

Group, Does anyone have some SQL handy that will re-compile INVALID objects for a given user, that they would be willing to share?? TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL

Re: diagnosing latch free

you wrote: > >> oops, probably only want the events that are latch frees: >> >> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >> ln.latch# and sw.event = 'latch free'; >> >> On Saturday, December 8, 2001, at 04:50 PM, George Schlo

Re: diagnosing latch free

oops, probably only want the events that are latch frees: select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = ln.latch# and sw.event = 'latch free'; On Saturday, December 8, 2001, at 04:50 PM, George Schlossnagle wrote: Try: select ln.name from v$session_wait sw, v$la

Re: diagnosing latch free

Try: select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = ln.latch#. Best, George www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily

RE: Problem importing objects to different tablespace

Good to know that it really works, although I kind of have lost hope in my case here using 8.0.5. Maybe it is 8.0.5. I dunno. But thanks for the input anyway. George -Original Message- Sent: Tuesday, November 27, 2001 4:07 PM To: Multiple recipients of list ORACLE-L George, I&#x

RE: Problem importing objects to different tablespace

I know this. But I just wanted to avoid the hassle of precreating the tables, creating the views and other objects. Note:1012307.6 in Metalink seems to encourage that approach. George -Original Message- Sent: Tuesday, November 27, 2001 3:26 PM To: Multiple recipients of list ORACLE-L

  1   2   >