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: How

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

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 Leonard

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

Development vs. Production DBA

-- 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 yourself from

Development vs. Production DBA

-- 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 yourself from

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 to find 3 quarters(9 months) from it. July -Sep

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

, 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 mailing list

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 this error code means. Thx George

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

import and rollback segments

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: (+27 11

RE: import and rollback segments

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 (Reg

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 0573

RE: OT ksh day of week yesterday

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. (SEC-Lee) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

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

#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 George Leonard

Index Partitioning

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 Dimension Data (Pty) Ltd

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 0573

RE: DB monitoring using SNMP MIBs

# 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_time; George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07

RE: LOCALLY MANAGED TABLESPACE

to 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: 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 Administrator

Rollback segment space usage

a 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

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

login trigger

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 Obligation to Inform

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

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

for 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: http

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:(+27

RE: logon trigger

;'; execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;'; execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;'; end; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07

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) 576

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: logon trigger

session set OPTIMIZER_MODE = choose;'; execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;'; 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

, to_char(a.last_update_time, 'HH24:MI:SS'), a.username, a.time_remaining T Left, a.opname , s.sql_text from v$session_longops a, v$session b, 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

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-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: 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: 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 Data

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: 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: buffer cache

, 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.6422 (e

ColdFusion and Oracle

://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

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 AFTER ONE AIOWAIT TIMEOUT WARNING

Re: EMC Storage Array Issue

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 the problem. The database goes down

Re: EMC Storage Array Issue

, 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, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0 kaio(AIOWRITE

Re: EMC Storage Array Issue

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 thread to indicate that the I/O took

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

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] --- Rusnak, George A. [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 parameters I should

Re: New iMac as dba workstation

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, 2002, at 06:23 AM, Jan

Has Anybody Used Domain-Prefixing on WinNT4/8.0.5 SE

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 access / Mailing Lists

OS authenticated from Outside Domain/Firewall

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] Fat City

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 outside our

- OFF TOPIC - Corporate Data Model

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

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

= 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 96C9 2F5E 56C2

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: 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, at 09:03

Re: Async I/O on Sun Solaris

information (like subscribing). // George Schlossnagle // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: BIG DATABASE second post

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 new services

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

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 probably won't last

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. now is the time to buy

Connection problem

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. INET

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 system. Both are Sun

Convert ACESS to Oracle

://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

Re: EMC Not Releasing Space

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 on-call, daily

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 report for the timed statistics

Re: Shared pool wait for library cache pin

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-call, daily

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 George

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 2 9 4 2

Re: VLDB backup policy

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] Sent: Wednesday, January 02, 2002 11:20 AM

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

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: Wednesday, January 02, 2002 12

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 (for libary cache pin) on our

Re: Shared pool wait for library cache pin

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 adding another

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

x$ksmpp table question

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 monitoring, 24x7

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

weird pga swelling

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 verifications, storage management, performance

Re: retrieving objects usign OCI

. 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 hard. 30 seconds on CPAN led me to: http://www.cpan.org/modules/by-module/Oraperl/TIMB/Oracle- OCI

Re: retrieving objects usign OCI

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. George // George

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

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$latchname ln where sw.p2 = ln.latch#. Best

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: 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$latchname ln

Problem importing objects to different tablespace

commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena

RE: Problem importing objects to different tablespace

All the objects are dropped beforehand. The import is done on a clean slate. I just put in the ignore=y because that's what the docs suggested and I was half hoping it'll drive the space quota exceeded... error away :) George -Original Message- Sent: Tuesday, November 27, 2001 12:30

RE: Problem importing objects to different tablespace

Funny because Oracle has explicitly stated that you can actually import a user's objects to it's new default tablespace as long as you make sure that the user doesn't have any quota or privs on the old tablespace. George -Original Message- Sent: Tuesday, November 27, 2001 1:00 PM

  1   2   >