Recent content by spenglerr

Hi Roy, sorry for the late answer. Actually if you license the Oracle Internet Application Server, then you will be able to take your FORMS and REPORTS applications 1:1 to the forms/reports runtime in the Application Server and this will give you the desired web-pages with the same look and...

I expect that you intend to secure your SQL*Net Connections. If so you should read in your manual about the Net8: Connection Manager. With this tool you can implement access rules for the SQL*Net and implement connection pooling and multi-threading of the connections.

sorry finubar, I do not understand your question completely. So I will answer two meanings. If you intend to use decoding for assigning numbers, then you can use it in a control file in double quotes. If you have problems with the string length exceeding 256 characters ín free format, you will...

a semi join is : EXISTS an anti join is: NOT IN if you set ALWAYS_SEMI_JOIN = HASH you should have a multi-CPU server that is able to process queries parallel. To use hash you should also set the HASH_AREA_SIZE parameter in your ini-file. Also the CPU_COUNT and PARALLEL_MAX_SERVERS should be...

Hi, actually when I want a low-cost solution I monitor the important system parameters by a shell-script and send it via Email regularily to my client. Additional: NON-FREEWARE to check: BMG Patrol or even better Quest Foglight or (small enterprises: Quest I/Watch)

actually do you have such little expensive things like NOT IN or IN in your 4 where statements? If a list grows very large and you request it using NOT IN you can get exactly these problems with the request only for the user who gets the large excludeing-list.

First for returning a record set and not only one row you will have to use a (so called) cursor variable. You can then compile PL/SQL-procedures that return result sets into arrays instead of calling the procedure n-times which would be quite nasty and performance degrading. So here is the...

for updating keys you will have to write Triggers

The select from sfvb will give you the Primary Key columns. When setting type equal to 'R' (referencing) then you will get the Foreign Key Columns. When type='C' you get the Check Constraints. If you have access to Enterprise Manager it is the easiest to look into the tables to understand all...

actually what is the speed determining step? a) the query itself b) transport via network c) the output on the screen? You can test this by comparing the speed of a script spooling the output to a file with the speed of the query within sql*plus. When working with SQL*PLUS every line is...

Look in the documentation for DISABLE constraints and for NOVERIFY.

Actually I remember that you will also have to keep an eye to the HP kernel parameters when switching to 8.1.7, the number of new kernel parameters increased for Oracle

Actually this is correct. Normally I install the Oracle software together with the other software in the standard path /opt. This has s.th. to do with UNIX organization. Applications are installed in /opt or /usr/local. We prefer to install vendor software in /opt and public domain software...

If your clients have known IP-addresses you can also configure the Oracle connection manager CMAN. By this way you can specify access rules and you can use nice features like connection pooling

No, that's the fortune of a RAID, that you will not have to split your datafiles to physical partitions since the controller will do this for you. Of course you can create logical volumes on your RAID, but this would only make the DBA-tasks concerning datafiles more complex. These Oracle...