zigzagdna's articles:

Items(102) /11 Next >> Last >|

/oracle file system keeps growing 3 1 (5/16/2013 11:37:06 PM) comp.databases.oracle.server I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 9= 5% full and keeps growing. I am however unable to find which file(s) are ca= using this problem. I use find command: Find .... zigzagdna

NLS_LENGTH_SEMANTICS = CHAR import is too slow 10 8 (5/4/2013 8:38:13 PM) comp.databases.oracle.server I am converting a database from its current character set WE8ISO88591 to AL32UTF8 I am using NLS_LENGTH_SEMANTICS to CHAR so I do not have to increase column lengths. I follow Oracle instructions: 144808.... zigzagdna

Tomcat Multi-Threading 27 9 (1/30/2013 1:59:12 AM) comp.lang.java.programmer I am using Apache Tomcat 6.x on a Windows 2003 Server R2. I can see Apache = Tomcat is a multithreaded applications, no of threads arrange from 50 to 30= 0. Since it is a multithreaded application, I am assum... zigzagdna

Unable to shutdown the database 20 47 (11/2/2012 7:46:21 AM) comp.databases.oracle.server I am on Oracle 11.1.0.7 on HP UNIX 11i. I have been using following procedure to shutdown database for a long time: 1. shutdown abort 2. startup 3. shutdown immediate Today (after Sandy hurricane where... zigzagdna

Who uses active data guard? 4 47 (10/15/2012 3:31:38 AM) comp.databases.oracle.server Oracle has great technology such as Active Data Guard where one can do repo= rting from a standby database which is in synch with production database; b= ut I have not found any application for it. My company... zigzagdna

How to redirect output of kill in a shell script 2 81 (10/4/2012 11:22:33 PM) comp.unix.shell I have written a simple script testimeout.ksh #!/usr/bin/ksh (sleep 10; kill $$) & # $$ is current PID sleeper=$! # $! is the background PID echo "Input? \c" read input echo ${input} kill ${sleeper} ... zigzagdna

In Oracle, can one calculate statistics on non indexed columns 4 29 (6/25/2012 2:37:57 AM) comp.databases.oracle.server 1. I am learning SQL Server 2008. I see that sql server calculates statisti= cs on non indexed columns as well and makes use of such statistics in deter= mining best query plan. I also see something like th... zigzagdna

mysql cluster allows on- line upgrades, is there anything like that in Oracle? 7 35 (6/2/2012 6:13:08 PM) comp.databases.oracle.server My company heavily uses SAP with Oracle as underlying database. They have b= een wanting to install Oracle paces (e.g., upgrade from Oracle 10.2.0.x to = 10.2.0.y) without bringing down Oracle. Oracle runs in... zigzagdna

Subject: Why creation of sql profiles take forever 3 52 (5/4/2012 12:58:59 PM) comp.databases.oracle.server I am on Oracle 10.2.0.4 on HP UNIX 11i. I am creating sql profiles using f= ollowing logic. Sometimes sql profile is generated in 1-2 minutes. Many tim= es , even after an hour, no sql profile is created and ... zigzagdna

Snapshot too old error with LOB Data 3 59 (4/12/2012 1:05:33 AM) comp.databases.oracle.server I am on Oracle 10.2.0.4 on HP UNIX.=20 1. I have a table with CLOB column: desc pr_text_data; Name Null? Type ----------------------------------------- -------- -------... zigzagdna

zigzagdna's replies:

Items(84) /9 Next >> Last >|

/oracle file system keeps growing 3 1 (5/16/2013 11:37:06 PM) comp.databases.oracle.server I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 9= 5% full and keeps growing. I am however unable to find which file(s) are ca= using this problem. I use find command: Find .... zigzagdna (346)

NLS_LENGTH_SEMANTICS = CHAR import is too slow 10 8 (5/4/2013 8:38:13 PM) comp.databases.oracle.server I am converting a database from its current character set WE8ISO88591 to AL32UTF8 I am using NLS_LENGTH_SEMANTICS to CHAR so I do not have to increase column lengths. I follow Oracle instructions: 144808.... zigzagdna (346)

Tomcat Multi-Threading 27 9 (1/30/2013 1:59:12 AM) comp.lang.java.programmer I am using Apache Tomcat 6.x on a Windows 2003 Server R2. I can see Apache = Tomcat is a multithreaded applications, no of threads arrange from 50 to 30= 0. Since it is a multithreaded application, I am assum... zigzagdna (346)

Alternatives to Oracle 1 16 (1/7/2013 1:34:31 AM) comp.databases.oracle.server I don't think I will say anything particularly surprising if I say that Oracle prices are sky high. To make things even worse, the old lore that a commercial feature will be incorporated in the enterprise e... gogala.mladen (1072)

Unable to shutdown the database 20 47 (11/2/2012 7:46:21 AM) comp.databases.oracle.server I am on Oracle 11.1.0.7 on HP UNIX 11i. I have been using following procedure to shutdown database for a long time: 1. shutdown abort 2. startup 3. shutdown immediate Today (after Sandy hurricane where... zigzagdna (346)

Does Oracle encourage developers to use cursors? 7 45 (10/20/2012 2:59:14 PM) comp.databases.oracle.server I've asked this at asp.net forum, but I think we have more gurus here to get more educational, informative information about my confusion. I am new to Oracle, but not new to SQL Server and .NET application d... gnewsgroup (30)

Who uses active data guard? 4 47 (10/15/2012 3:31:38 AM) comp.databases.oracle.server Oracle has great technology such as Active Data Guard where one can do repo= rting from a standby database which is in synch with production database; b= ut I have not found any application for it. My company... zigzagdna (346)

bLOCKRECOVER in 11G? 11 46 (8/17/2012 3:00:02 PM) comp.databases.oracle.server I've had some brief corruption caused by sunspots (actually, it was a proof of concept DR test, the corrupt blocks were caused by NOLOGGING operations) and I decided to repair blocks by using BLOCKRECOVER ... gogala.mladen (1072)

In Oracle, can one calculate statistics on non indexed columns 4 29 (6/25/2012 2:37:57 AM) comp.databases.oracle.server 1. I am learning SQL Server 2008. I see that sql server calculates statisti= cs on non indexed columns as well and makes use of such statistics in deter= mining best query plan. I also see something like th... zigzagdna (346)

Oracle Closed World 24 45 (6/21/2012 6:39:06 PM) comp.databases.oracle.server Everyone should know by now Larry bought a Lanai: http://www.cnn.com/2012/06/20/us/hawaii-ellison-island/index.html Best comment I've seen: "let's be honest, if he rocks a jetpack to work, he's probably ... joel-garry (4516)