Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

    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...
  2. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

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

    Howto to fill a (define) variable in sqlplus with an "host" output

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

    Howto to fill a (define) variable in sqlplus with an "host" output

    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...
  5. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

    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.
  6. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

    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
  7. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

    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...
  8. PTameris

    Howto to fill a (define) variable in sqlplus with an "host" output

    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
  9. PTameris

    named[....]: sysquery: nlookup error on ?

    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...
  10. PTameris

    CPU / Memory Problem

    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...
  11. PTameris

    Network Interrupts & Packet retransmitted

    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...
  12. PTameris

    Network Interrupts & Packet retransmitted

    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...
  13. PTameris

    CPU / Memory Problem

    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...
  14. PTameris

    CPU / Memory Problem

    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...
  15. PTameris

    CPU / Memory Problem

    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...

Part and Inventory Search

Back
Top