I really think that HP needs to do a better job in promoting and making a better brand for Vertica Database.

sonynavi wrote:Sarah, How did you handle the STored Procedures in Oracle to Vertica. Could you please share

Why would you wanna move all you Stored Procs to Vertica ? Are you replacing your transactional db with Vertica ? You know that Vertica is a columnar DB it won't handle good your transactional workload.

Phani wrote:Database started now. It is strange.. I did not changed anything just reboot the servers.

Thanks for your help.

Thanks,
Phani

your server got the Windowzzzzz flu - general solution REBOOT

--Get your compression Ratio see the order by (will get you the last audit record) SELECT cast(database_size_bytes/(SELECT SUM(used_bytes) FROM v_monitor.projection_storage) as numeric(10,3)) as compression_ratio FROM v_catalog.license_audits ORDER BY audit_start_timestamp DESC LIMIT 1; I don't thi...

--run the audit_license_size() SELECT audit_license_size(); --this will populate the license_audits table --it runs in the backgound but you can anticipate it's action --Get your compression Ratio see the order by (will get you the last audit record) SELECT cast(database_size_bytes/(SELECT SUM(used_...

hopewell wrote:Cool, thanks again Jim!

So, is there a separate history file for each user? Is it possible to just have a general one for all users? Just curious.

Each user that can access Vertica locally it will have its own .vsql_history file in his home directory.

Ola,
Sim sou do Rio mesmo ! Voce e Basileiro ?
Que bom que deu certo. Caso precisa de mais ajuda pode me escrever no pm.
Ou aqui no forum msm.