RE: Ixora off-line, moved?

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Little competition

Title: Message Don King SQL create table 2 test_table 3 (c1 number) 4 tablespace 5 asm_test 6 pctfree 20 pctused 30; -Original Message-From: Richard Foote [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:39 PMTo: Multiple recipients of list

RE: Finding SID of current session

select sid from v$mystat where rownum2 / Kind Regards Suhen Pather IT Software Specialist Land +27 12 680 3282 Cell +27 82 562 3124 email [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 02, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi there all. How can

RE: RE: when do you use v$statname?

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?

Suhen Pather -Original Message- Sent: Tuesday, November 18, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't

RBO to CBO migration books/ material

Hi Any good books available to convert applications from RBO to CBO. References to Oracle 9i. Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: What is a large database?

Title: RE: What is a large database? I think there are many *poorly skilled* Oracle DBA's in Australia. I had one of my clients sugest increasing the Oracle log_buffer to 10MB. His claim is since the box has sufficient amount of memory why not use a very large log buffer. I do not think

RE: Forms - as sysdba

Title: RE: Forms - as sysdba One thing to bear in mind for forms development is Oracle does not support connecting as / (OPS$). Suhen -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L

RE: Forms - as sysdba

Title: Message Robo You can connect as ifrun60.EXE "C:\...\..\logon2.fmx" Regards Suhen -Original Message-From: Robo [mailto:[EMAIL PROTECTED]Sent: Friday, 22 August 2003 4:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forms - as sysdba I MUST connect as

RE: Oracle to MSSQL conversion?

Title: RE: Oracle to MSSQL conversion? Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Every database functions differently in many respects. Best is not to compare the both and try and learn the

RE: Oracle to MSSQL conversion?

Title: RE: Oracle to MSSQL conversion? What SQL Server calls databases I think of them as schemas in Oracle. Suhen -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 August 2003 4:10 AM To: Multiple recipients of list ORACLE-L

RE: High disk , query values with Global non-prefixed Local ind

Vivek, Probably due to blocks being cached in memory. Those values are not high. Especially when you getting sub second response times. Regards Suhen -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]Sent: Wednesday, 30 July 2003 6:14 PMTo: Multiple recipients

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: ORA-27101 RH linux 9 Oracle 9.2.0.3 Jack, ORA-27101: shared memory realm does not exist Oracle probably been aborted for some reason. Strangehow you can do a select * from v$database. How much memory and swap space you have configured. Regards Suhen -Original

RE: RAC

Title: RE: RAC Kay, Can we get the Metalink note to run a single node RAC on Linux. TIA Suhen -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 22 July 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: RAC Not required.. We

RE: Rollback !

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

Re: how to reduce SQL*Net more data to client wait event

that just be accounted for under SQL*Net message from client events? - Original Message - From: Suhen Pather mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, August 19, 2002 8:08 PM Subject: how to reduce SQL*Net more data

how to reduce SQL*Net more data to client wait event

Hi, I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction of the CPU consumed by the system. I know this is not to be characterized as an idle wait event and can yield better performance if we increase the packet size.

RE: Moving to UK - what are Oracle contracts like?

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

Re: It took more than an hour to update 10,000 records

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: Suhen Pather INET: [EMAIL PROTECTED] Fat City

Re: where should i start to learn to become a DBA?

with Oracle 8.1.6 in Win2000 on my PC. Sometimes...play around with Oracle 8.0.5 on Linux(Which is corporate DB Server, shh...) Thanks for any advices. Have a nice day! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City

Re: Cursor Sharing

as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather

Re: Cursor Sharing

be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Cursor Sharing| Soft Parsing

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

RE: Why DDL is not allowed in PL/SQL

(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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: joining word/ lines in a file

Thanks Steven, Jared for the ideas. Regards Suhen -- Suhen Pather [EMAIL PROTECTED] Hey this is a not a trick question, without buying the books listed below is there a way using the std awk, sed, tr *nix utilities. Perl is going

joining word/ lines in a file

and DATE_RUN = TO_DATE('27MAY2002 00:00:00', 'DDMON HH24:MI:SS') and ON_ORDER = 150; I am trying using sed but cant seem to work it out. Any Ideas? Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network

joining word/ lines in a file

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

RE: joining word/ lines in a file

book dealing with the C programming language. The Good Book is: Brian Kernighan and Dennis Ritchie: The C Programming Language. You should get the King James (ANSII) edition. On 2002.05.28 23:58 Suhen Pather wrote: List, slightly off topic but Unix OS I need to join lines/ words

RE: Miracle Database forum in Sydney - get together Sunday night

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

RE: RedHat

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

DIRECT PATH READ wait events

-- Author: Suhen Pather 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

RE: How to drop a datafile from a tablespace quickly

: 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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services

slow SQL query, diagnosis using 10046 trace event

Tuning Gurus, I am tuning one of our dayend batch jobs using the 10046 wait event (level 8). I see a whole lot of direct path read/ write events (1000's) in the trace file. Also many SQL*NET messages from/ to client waits. Not sure if this is the way PRO*C works, connects fetches

RE: Where does a DBA go from here?

the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather

RE: Where does a DBA go from here?

while we're there, shall we? Mogens Suhen Pather wrote: Sujatha,         Just spoke to Peter Bach, Miracle AS , Australia     The forum dates are not confirmed yet but it will be towards the end of May.     Once he has the dates confirmed he will post

RE: Oracle Licensing - Concurrent users

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

RE: Where does a DBA go from here?

Sujatha,         Just spoke to Peter Bach, Miracle AS, Australia     The forum dates are not confirmed yet but it will be towards the end of May.     Once he has the dates confirmed he will post it on the Miracle website.     You can call

RE: Importing SQL 7.0 tables

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

RE: TABLESPACE PCTINCREASE?

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

formatting in SQLPLUS

List, I am creating a report via sqlplus. I am working with the formatting.  When I run the report it puts the headings for the columns after every 2 rows of the report.  I would like to have the headings at the top of the report only. I could set the heading off but it would

RE: formatting in SQLPLUS

Title: RE: formatting in SQLPLUS Thanks, ššš I set pages 999 and it works fine now. ššš Regards ššš $uhen Or try. set pagesize xxx where xxx is the number of lines per page. -Original Message- From: Dennis M. Heisler [mailto:[EMAIL

sending email via pl/ sql using query

List, I am trying to send email from Oracle when a table is updated. The message must be a dynamic one, so hard coded message will not be allowed. I have created a trigger when the table is updated - that works I am using UTL_SMTP to send emails. -  that works However this

RE: snapshot too old

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

RE: memory resource...

Shuan, The oracle.exe process memory usage is dependant on the size of the SGA. The difference in the memory used for each of the oracle.exe processes is due to the different SGA sizes. Regards $uhen hi, DBAs... i'm using Win2000 Advance Server, with

RE: Oracle Performance monitoring tools.

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

RE: HOW TO MAKE DELETION FAST

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

RE: TEMPORARY TABLES

Peter, When a temporary table is created, a dictionary definition of the table is also created. Space is not actually allocated for the table until it is populated GTT tables are not dropped when a session or transaction ends, the session specific data is only deleted

RE: Oracle Future???

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

RE: exp error

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

RE: free buffer waits DISK I/O

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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: unused blocks BELOW HWM

: Suhen Pather 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 an E

UTL_SMTP to send email

List, I am sending email from the database. I have UTL_SMTP setup which works fine. However in the message field I would like to query a table (using a select) rather than a hardcoded message. Not sure how to do this though. Anyone got any pointers will be greatly appreciated.

RE: ftp tools

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

RE: Tempfile - where to find the max size and the datafile extent

') 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: Suhen Pather INET: [EMAIL

RE: who execute scripts in Win NT like Unix!!

://www.orafaq.com -- Author: Suhen Pather 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: create trigger after insert

    THANKS,     I resolved the issue.     If I use a script like the one below to test the trigger "for each row" and "statement insert"  it is taken as multiple statements.         It works fine now     Regards    

RE: date format in ksh

is in another format other than above then it must exit. Regards Suhen date +%d-%b-%Y man date. You may have to look at the man page on a system with more recent documentation, such as linux. The man page on Solaris is incomplete. JARed Suhen Pather

date format in ksh

List, Sorry to deviate from the topic, but I am writing a korn shell script that would exit if the date format is incorrect. I just need something to compare the date format passed  in with DD-MON-. Eg. I am passing an argument to my ksh script being the date. If the date

equivalent of LPAD in Transact SQL

List, Bit of an inappropriate question to the Oracle List. Does anybody know the SQL Server (Transact SQL) equivalent of the LPAD function. Regards Suhen

book?

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.com -- Author: Suhen

RE: Background jobs inUnix

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

RE: count rows that are being imported

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

RE: Background jobs inUnix

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

RE: Automanagement of extent sizing

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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Tablespace (datafile reducing)

') 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: Suhen Pather INET: [EMAIL

help with deleting duplicate records from very large table

List, I need to delete duplicate records from a very large table (60 millions records +). There would be about 3 million duplicate entries. What is the quickest way to do this? The syntax that I am using is delete from invaudee where rowid not in (select min(rowid) from

current procedure that is executing

List, Is there any way to tell what procedure rather than sql_text that is currently executing? We are trying to develop a knowledge base were we require this information. I tried to check v$sqlarea, v$sqltext but could not find the relevant information in the shared pool. Any

RE: SQL Question

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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

tuning sql query to use index

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

RE: extent management

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

RE: Hi what is CUBE Function

://www.orafaq.com -- Author: Suhen Pather 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: log checkpoint interval

://www.orafaq.com -- Author: Suhen Pather 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

Oracle 817 is the fastest database on IBM's fastest server

, robustness, performance, etc. , seems pretty impressive reviewing the TPC-C results and the above URL. Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: help for rollback segments..

Saurabh, First of all no rollback segment should be in the SYSTEM tablespace except SYSTEM rollback segment. This cause serious performance problems. You would need to drop all the other rollback segments that are in the SYSTEM tablespace and recreate them in a ROLLBACKtablespace. To

async I/O on NT

://www.orafaq.com -- Author: Suhen Pather 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

RE: query using OR operator

(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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

query using OR operator

a full table scan on PRCMSTEE. There is an INDEX on PRD_LVL_CHILD of PRCMSTEE. Is there a way to rewrite the query to reduce the LIO? Thanks and Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network

RE: query using OR operator

of the index, but Oracle favours doing a full table scan on PRCMSTEE. There is an INDEX on PRD_LVL_CHILD of PRCMSTEE. Is there a way to rewrite the query to reduce the LIO? Thanks and Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather

PRO*C problems (sqlcode 2)

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

RE: Virus Warning

Title: Virus Warning me too I received an email from Bunyamin K. Karadeniz in response to an earlier 'Database Down' message that I had sent to the list. The email from him had an attachment to it. I opened it (I know this was not wise) and our virus scan had deleted the file and

RE: NT Scheduled Restart

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

RE: Book

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

RE: Which tables are in buffer cache.?

Mobile Tel : +90 535 3357729 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: X$ tables ??

Bunyamin, You should be able to view these tablesfrom the SYS schema. Regards Suhen I see that there is no X$ tables in my database or I can not view them . My O.S. is NT . How can I view them.?? Thanks Bunyamin K.Karadeniz Database Group / Information Systems

RE: 8.1.6 on NT?

://www.orafaq.com -- Author: Suhen Pather 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: 6 databases/one box/performance issue

: Suhen Pather 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: database links

') 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: Suhen Pather INET: [EMAIL

RE: Recovery from noarchive db corrected

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

RE: Script to reverse engineer all objects in a schema to DDL?

') 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: Suhen Pather INET: [EMAIL

FW: Standard vs Enterprise Edition

Oops !!! forgot to send the attachment. Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. Size of the database is 70GB. The application uses very limited database features. No replication, partitioning, OPS,

RE: Standard vs Enterprise Edition

tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather

RE: changing db_block_size

, 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: Suhen Pather INET: [EMAIL PROTECTED] Fat

RE: 8.1.7 Patches

: Suhen Pather 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 an E

RE: Massive_Thangs !!!!

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

RE: Renaming a Column

, 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: Suhen Pather INET: [EMAIL PROTECTED] Fat City

RE: which one (UTLBSTAT or UTLESTAT) creates STAT$END_...

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

RE: when did that happen ... (really like to know)

: 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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services

RE: sql query

://www.orafaq.com -- Author: Suhen Pather 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: OT NT2K vs Unix.

- only $35 a year! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051