Search results for query: *

Hi to all. I appreciate that you can provide me detailed instructions to perform the following: From home, I use the SafeNet Secure VPN Client to access my work. Once connected, I have to ssh to a box (let's call it 192.168.2.29), and once connected to that box, I have to ssh to another box...

Hi to all, I have a quick question, I was using RMAN to perform my backups and those backuped files were generated on an NFS mounted drive. Now someone remove the NFS mounted drive so my catalog is out of Sync. I'd like to start all over on my RMAN configuration, so my question is: Can I just ...

Hello, I was reading a lot about RMAN but I have some questions about my configuration, I appreciate any help. I'm using 10.2.0.1 on Linux, RAC with 2 nodes. I setup another box to use RMAN. My Flash Recovery Area is in my cluster and is located /u03/flash_recovery_area/OLTP4R/archivelog, there...

HI, I'm trying yo improve the performance of the golowing piece of code. Here I'm archiving Items that are done processing to Archive Tables. I believe that if I use BULK INSERTS/SELECTS/UPDATES this process will move much faster. Can someone suggest me a way to do it? Thanks declare...

Hi, We are running a VB application, all "sql code" is performed at the oracle database using packages and functions. We have a VERY HIGH AMOUNT of waits on the library cache pin. 26 boxes are running the same code. That wait is over a package that contains a procedure with the...

I will have several tables with 6,000,000 rows in my database. As an example, this is one of the tables: TABLE_BIG FIELD1_PK NUMBER(10) FIELD2 NUMBER(10) FIELD3 VARCHAR2(256) CERATEDATE DATE Our queries are going to be over the field FIELD1_PK on the where clause and that number is generated...

Hi to all, I need some suggestions on the storage parameters for the following 2 tables. Our application is an OLTP, with 80 users connected at the same time. Our app. inserts data into 2 tables for 4 hours (400,000 rows for parent table, 1,200,000 for child table), after that, the users start...

Hi, My customer's site is running Oracle 8.1.7.0 on Windows NT 4.0. There are about 150 concurrent users. Transaction are saved very quickly (a loot of inserts per row), but the problem is in some reports or process which scan thru enormous amount of data. When such reports are run, the rest of...

Hi to all, I'm trying to optimize a query. Can someone help me? I have a big table like: DESC big_table ( DOCUMENTID NUMBER(10, 0) NOT NULL , FIELDCODE NUMBER(5, 0) NOT NULL , FORMID NUMBER(10, 0) NOT NULL...

Hi, we are designing a system over NT that has several tables. Our biggest concern is over 2 tables, they are the main tables. Its structure are: create table FLOWDOC ( DOCUMENTID NUMBER(10, 0) NOT NULL , FORMID NUMBER(10, 0) NOT NULL , INUSE...

HI I'm having the following problem. We use Oracle8i over NT, Visual Basic and the developers connect to Oracle using ADO. I installed Oracle 9i and for and unknown reason now they receive error messages when they try to run a stored procedure, function, etc. It fails when doing a...

HI I'm having the following problem. We use Oracle8i over NT, Visual Basic and the developers connect to Oracle using ADO. I installed Oracle 9i and for and unknown reason now they receive error messages when they try to run a stored procedure, function, etc. It fails when doing a...

Hi to all of you. I need some advices about how to improve performance on a table which will receive more than 2 million rows per day and AT THE SAME TIME, a lot of updates from 100 connections simultaneous. The table will be deleted at the end of the date. Also suggestions about a HUGE table...

Does anybody know how to know the size of a type that I can use in my tape backup?<br> <br> Thanks,<br> Diego