Profile cover photo
Profile photo
Florin Videa
5 followers
5 followers
About
Florin's posts

Post has attachment
Ura imaginara
Ne-am inchis pe dinauntru-n noi, In noiul cu peretii goi, In noii vechi, Prea vechi, Ca nu ne amintim de eu, De tu, Cei singuri doi. Ne-au inchis afara O haita de cuvinte, Stranse a frig Intr-o tacere-amara, Atat de-amara, Cat ar putea sa-ncapa Intr-o ura i...

Post has attachment
Grant select on all tables and views (except the invalid views) of a schema to another user
begin   for i in (select object_name from user_objects where object_type in ('TABLE','VIEW')) LOOP     begin    execute immediate 'grant select on '||i.object_name||' to        grantee_user';    EXCEPTION    WHEN OTHERS THEN      dbms_output.put_line('err_n...

Post has attachment
Send a file attachment with sql query
I will use the PLSQL to fill up the file with queried data, then a linux script to send the mail. declare    v_file     UTL_FILE.file_type;    v_string   VARCHAR2 (4000); BEGIN    v_file :=       UTL_FILE.fopen ('DUMP2_FLORIN',                       'tt.csv...

Post has attachment
How to free swap in Linux
First, verify with free command how much swap it is used. If you want to free all the swap: >swapoff -a Meanwhile, verify from another command prompt the pace of swap freeing, running the free command on and on. >swapon -a 

Post has attachment
"ora - 02248 : invalid option for ALTER SESSION" when try to connect to database from Forms Builder 9.0.4
If you run the Builder from Windows 7, don't bother to follow any advice from any site on the net, the solution is to change the OS. It's true the problem comes from the combination builder - database, but you can't do anything but what i said above to cope...

Post has attachment
The top 10 first hungriest queries
SELECT Disk_Reads DiskReads, Executions, SQL_ID, SQL_Text SQLText,    SQL_FullText SQLFullText FROM (    SELECT Disk_Reads, Executions, SQL_ID, LTRIM(SQL_Text) SQL_Text,       SQL_FullText, Operation, Options,       Row_Number() OVER          (Partition By ...

Post has attachment
Linux: Display the usage of processors and memory without provisioning values (the real usage)
Procs (two alternatives): top -bn1 | grep "Cpu(s)" | sed "s/., *\([0-9.]\)%* id.*/\1/" | awk '{print 100 - $1"%"}' grep 'cpu ' /proc/stat | awk '{usage=($2+$4)*100/($2+$4+$5)} END {print usage "%"}' Memory:   ps aux | awk '{sum+=$6} END {print sum / 1024}'

Post has attachment
Linux: reclaim your space after deleting some files
The problem is a simple one, but very annoying one: one or some of the deleted file (usually some big one/ones) are still opened by their parent processes. So, look for that processes, kill them, and you'll notice the df command will report propper results.

Post has attachment
How to install Oracle APEX
If there is already installed: cd $ORACLE_HOME/apex $ sqlplus / as sysdba sql> @apxremov_con.sql If the tablespace is not there already: CREATE TABLESPACE APEX DATAFILE '/u02/oradata/snap11g/apex_01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1000M ...

Post has attachment
ORA-39097: Data Pump job encountered unexpected error -12801 while expdp
ORA-39097: Data Pump job encountered unexpected error -12801   ORA-39065: unexpected master process exception in MAIN   ORA-12801: error signaled in parallel query server P..., instance <instance_name>   ORA-01460: unimplemented or unreasonable conversion r...
Wait while more posts are being loaded