All posts by rparvu

Carrot Ginger Smoothie

Tried today a new smoothie recipe:2 carrots1 cup pineapple1/2 inch ginger1/2 inch turmeric1 small lemon (or lime)2 cups water

E4 2017 is almost one month away!

E4 2017 is almost one month away!I am looking forward to three days of interesting talks. Register here.

Berry Mushroom Smoothie

4 strawberries2 to 3 mushrooms – make sure you thoroughly clean them½ cup blueberries1 cup water or almond milk1 cup iceDirectionsBlend in your blender until smooth and enjoy!

SQL Developer: Save a Package (thanks Jeff Smith)

Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES. Make sure you select BOTH. Then set your file type. .SQL as requested Now to confirm I’m really getting what I want. Yes, that. SQL Developer will automatically… via ...

Interesting Post by Jonathan Lewis

The opt_estimate hint is one of many that shouldn’t be used in end-user code and isn’t officially documented. Nevertheless – like so many other hints – it’s a hint that is hard to ignore when you see it floating around the code generated by the Oracle software. This note is prompted by a twitter question […] ...

Reset Mail Settings

Here is how to reset Mail for Mac OS at the original settings: ~ radu.parvu$ defaults delete com.apple.mail Enjoy!

Disable Mac OS X Gatekeeper

Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm's MacBook. Here is the short procedure I identified it works for me: in terminal type: sudo spctl --master-disable verify with: spctl --status open the application and quit it in terminal, type: sudo ...

Using @SQLcl (to be updated)

Taking the new command line tool @SQLcl for a first test drive.Plus Points- installation super-easy- a lot of commands interchangeable with SQL Developer- connectivity via TNS is easy to setup. TIP: if you do not have TNS_ADMIN environment variable in place, run show tnsin SQL Developer in order to get the location for the tnsnames.ora ...

Oracle Live SQL Tool

https://livesql.oracle.com/apex/f?p=590:1000:100225800561367

Oracle Extended Statistics

Introduced 11gR1 and based on virtual columns. Allows better selectivity.Condition has the be equality or IN-lists.We should use them when we have issues by an order of magnitude on the cardinality.Types: Column Group: Have to be from same table. Max 32 Expression: CBO does not know how an applied function impacts the cardinality of a ...

%d bloggers like this: