Search results for query: *

Hi.. Yep it's still a problem.... i can direct it to a $PPID.sql file, but how to catch that number to start..... SQL> !echo define a=$PPID >$PPID.sql SQL> @$PPID SP2-0310: unable to open file "$PPID" And yes there is now a file with 12345.sql but now i must start that sql with...

Hi, Dima.... uuuhhhh.. no... every one logs in al the same osuser.... greetz Peter

THX Sem.... SQL> !echo define a=$PPID >1.sql SQL> @1 SQL> prompt &a 41832 It works..... Again Thank you......

Hi Sem... We cannot connect (yet) because we are making a new login procedure with encrypted password program.... after we have a unique number for the sqlplus process, we create an tempory file (with this number) where the connect string is in the (new)(temporarily)sql-script.... for example...

Sorry Sem... For your info i am working on AIX 5.2 ML5... SQL> !echo -e select $PPID' a from dual \n/'>1.sql column a new_value b @1 SQL> SQL> SP2-0734: unknown command beginning "-e select ..." - rest of line ignored. SP2-0103: Nothing in SQL buffer to run.

Hai, Hoinz, But i don't want to connect to the database (yet)... So i can't run your select.... Because i am not connected..... Greetz Peter

Thanks Dima... But PPID reflects on that moment not the OS Process ID from the sqlplus command.... and that is the one i want to have....(this reflects the ProcesID from the OS-shell and not the sqlplus process id) and when i am in sqlplus and than starts the ! or host command the OS-variable...

Hi, I want to fill an sqlplus variable with the output of an external command, but before the connect to a database... So: # sqlplus /nolog sql >!echo $PPID 123456 and now i want to fill (with define?) an variable (let see ospid) with 123456 but how? Greetings Peter

Hi, My problem (or is it realy a problem...) that i get a lot of errors in the daemon.log (AIX 4.3.3) These probems occur every minute # tail -10 daemon.log Nov 12 08:25:32 hostname named[51378]: sysquery: nlookup error on ? Nov 12 08:26:51 hostname last message repeated 11 times Nov 12...

Hi, Yes i know about disk 4&0... There are the rede-log file's from Oracle... so with 1000 users those file's are continue updated... And so spread is no option because another disk will olso be very busy.... Or do you know another solution to spread redo-logs from oracle... The problem with...

Hi Bjverzal, No we see no errors in the errpt... No we are not using Jumbo Frames.. We tried it but with our network cards the network went down if we down/uploaded very big file's... we never discovered why.... No we have still retransmitted packages... # netstat -p tcp tcp...

Hi, I have encountered a lot of network issues on our networkcard. We have a IBM P-series server & AIX 4.3.3 The networkcard is a Gigabit Ethernet-SX PCI Adapter (14100401) When we look at "netstat -p tcp"; and calculate packet retransmitted/data packacts sent it is more than 17% and...

Hi Ali, We want to minimize the swapping computationalpages to pagingspace(disk)... Swapping from filepages to disk is therefore the more wanted situation... Do you know if there is an administration of computational or filepage kept in memory? OR.... We are using NFS (and the most...

Dear Raztaboule, Hereby the output your requested... Ofcourse it wasn't so very busy today on the system.... The proble occured around 2 months ago, befoe that there wasn't swapping (paging to disk) at all. (the normal 1%) But the last weeks we have seen it grow to now 24% And i think because...

Hi, We have a seriuos performance problem with our AIX-P-series server & AIX 4.3.3 The P-series is a S85 server with 8 CPU and 24 GB internal memory (and 6 GB Paging space) We are using a Oracle 8.1.7 database and have around 1000 oracle connections. The last month we are have more and more...