damir-vadas.blogspot.com
Damir Vadas, Oracle as I learned: Retrieve Oracle password from Toad for Oracle
http://damir-vadas.blogspot.com/2013/06/retrive-oracle-password-from-toad-for.html
Monday, June 3, 2013. Retrieve Oracle password from Toad for Oracle. One of the oldest feature Dell Toad has is saving login passwords. This is accomplish easy with enabling check box "Save passwords" on login screen. The whole connection process is defined through three files located in %USERPROFILE% AppData Roaming Quest Software Toad for Oracle 11.6 User Files. Where "11.6" is Toad version and may vary in your cases:. Connect in Toad as any user for which you DO NOT WANT TO RETRIEVE. For me this is mo...
stelioscharalambides.com
10035 trace NOT 10053 trace – Stelios Charalambides
http://stelioscharalambides.com/10035-trace-not-10053-trace
Oracle SQL Tuning With Oracle SQLTXPLAIN. Oracle SQL Tuning With Oracle SQLTXplain. 10035 trace NOT 10053 trace. How to find where you parse errors are on large systems, If you’re asked for a 10035 trace file, it probably isn’t a mistake. I came across an interesting case last week. Excessive parse time can sometimes be a problem, especially with complex SQL, in which case you may see “Parse CPU to Parse Elapsed” percentages which are quite low. Drop table test;. Select colx from test;. Naturally I’...
baze-podataka.net
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …
http://www.baze-podataka.net/category/ms-sql-server
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …. FROM baze podataka;. Archive for the ‘MS SQL Server’ Category. Zasto je super-kljuc super stvar? Monday, September 9th, 2013. Posted in Best practice. Provjera Oracle db linka. Thursday, July 19th, 2012. Ko je uneo ili promenio podatke – misterija kolona CreatedUser, CreatedDate, UpdatedUser, UpdatedDate. Friday, June 29th, 2012. Uvod Podaci koje cuvamo u bazama podataka su zivi, menjaju se konstantno. Ponekad j...
baze-podataka.net
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …
http://www.baze-podataka.net/category/best-practice
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …. FROM baze podataka;. Archive for the ‘Best practice’ Category. Toad for Oracle – Zaboravljeni pasvordi…. Sunday, October 13th, 2013. Posted in Best practice. Zasto je super-kljuc super stvar? Monday, September 9th, 2013. Posted in Best practice. Logiranje izmjene strukture baze – DDL LOGGER. Thursday, April 11th, 2013. Modeliranje baze podataka često nije jednokratan posao, uvijek se nađe potreba da se naprave izmje...
baze-podataka.net
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …
http://www.baze-podataka.net/category/ms-access
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …. FROM baze podataka;. Archive for the ‘MS Access’ Category. Zasto je super-kljuc super stvar? Monday, September 9th, 2013. Posted in Best practice. Provjera Oracle db linka. Thursday, July 19th, 2012. MS SQL: Da li je razmak punopravan znak? Wednesday, September 9th, 2009. Svi SQL sistemi i programski jezici imaju funkciju za izracunavanje duzine stringa. U MS SQL tu ulogu ima funkcija LEN. Valjda i najveci p...Anket...
baze-podataka.net
» Oracle Tipps & Tricks: Kako rasparčati niz znakova [How to split a string]
http://www.baze-podataka.net/2009/09/15/oracle-split-string-tokenizer
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …. FROM baze podataka;. Oracle Tipps & Tricks: Kako rasparčati niz znakova [How to split a string]. Tuesday, 15.09.2009 –. Ukoliko imate zadatak da rasparčate neki string. Koristiću ovaj uvriježeni naziv umjesto prijevoda “niz znakova”), možete to obaviti na ovaj način. Za tu svrhu moramo kreirati jednu funkciju, kojoj kao ulazni parametar predajemo string. A koja nam vraća array sa parčadima. A rezultat izgleda ovako:.
laurentschneider.com
last partition – Laurent Schneider
http://laurentschneider.com/wordpress/2014/12/last-partition.html
If you really need to quickly find the latest partition per table, I have written this little gem. It doesn’t cover all partitioning type, but it is pretty fast and simple. Oracle Certified Master View all posts by Laurent Schneider. December 24, 2014. December 24, 2014. 4 thoughts on “last partition”. December 29, 2014 at 09:19. Nice query – fast, simple and very useful for me. Too bad that we cannot use functions in the WITH clause in earlier versions. December 29, 2014 at 11:26. July 18, 2016. Permiss...
savvinov.com
Optimizing working environment. Part I, GUI – Oracle Diagnostician
https://savvinov.com/2015/03/06/optimizing-working-environment-part-i-gui
Performance troubleshooting as exact science. Optimizing working environment. Part I, GUI. Currently I’m using SQL Developer 4.1 “early adopter edition” (i.e. essentially beta). Despite it’s beta status, it has proven to be stable, at least for the tasks that I do. Top SQL developer features/customizations for me are:. 8) sqlplus commands and scripts. SQL Developer understands some sqlplus command, and in particular, and it’s possible to run sqlplus scripts from its worksheets — just type...March 6, 2015.
database.com.mk
Monitor I/O performance on Solaris with iopattern DTrace script and Oracle Database 12c with pluggable database
http://database.com.mk/wordpress
Oracle, MS SQL Server, SQL, PL/SQL, T-SQL, Shell, Tuning, Unix, Linux. Sql server 2008 (mkd). You are here: Home. Monitor I/O performance on Solaris with DTrace script and Oracle Database 12c with pluggable database. July 8, 2013. Middot; Leave a Comment. Of course, try to throttle as much CPU and IO possible from my home server running virtual machines. What to do you need? Script written by the genius Brendan Gregg. Which comes along with DTraceToolkit version 0.99. SunOS 5.10 to run the script. Third ...
database.com.mk
NMON – Tool to monitor performance on AIX and Linux
http://database.com.mk/wordpress/category/os/linux
Oracle, MS SQL Server, SQL, PL/SQL, T-SQL, Shell, Tuning, Unix, Linux. Sql server 2008 (mkd). You are here: Home. NMON – Tool to monitor performance on AIX and Linux. April 20, 2010. Middot; Leave a Comment. One of the tools I use to monitor performance on IBM AIX 5.3 and Linux is NMON. I like it because it is simple to use, it has. Nice user interface and most important of all that it can run in two modes:. Online Mode – Which updates the terminal for real-time monitoring. C – Number of refreshes. For i...
SOCIAL ENGAGEMENT