sqlplsql.wordpress.com
Lczinkoc's Blog | Just another WordPress.com weblogJust another WordPress.com weblog (by Laszlo Czinkoczki - Webvalto KFT Hungary)
http://sqlplsql.wordpress.com/
Just another WordPress.com weblog (by Laszlo Czinkoczki - Webvalto KFT Hungary)
http://sqlplsql.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.2 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
17
SSL
EXTERNAL LINKS
51
SITE IP
192.0.78.12
LOAD TIME
0.219 sec
SCORE
6.2
Lczinkoc's Blog | Just another WordPress.com weblog | sqlplsql.wordpress.com Reviews
https://sqlplsql.wordpress.com
Just another WordPress.com weblog (by Laszlo Czinkoczki - Webvalto KFT Hungary)
sqlplsql.wordpress.com
How to avoid the persistent state of package’s components? | Lczinkoc's Blog
https://sqlplsql.wordpress.com/2014/08/04/how-to-avoid-the-persistent-state-of-packages-components
Just another WordPress.com weblog. Laquo; Temporal validity(history) in Oracle 12c. ACCESSIBLE BY clause versus Function Based Indexes. How to avoid the persistent state of package’s components? Generally the persistent state of package’s component is useful, we don’t want to eliminate it. Persistency means that the lifetime of package components(variables, cursors,exception definitions, etc.). Start with the instatiation of package and finish with the end of session. Let see an example:. Whe want to run...
August | 2012 | Lczinkoc's Blog
https://sqlplsql.wordpress.com/2012/08
Just another WordPress.com weblog. Archive for August, 2012. Iterative UPDATE with SKIP LOCKED option. August 28, 2012. Many times occur that we can not execute an UPDATE or DELETE statement, because a couple of rows are locked by an other session(s). We can generate and handle – exceptions, but this solution sometimes not enough. Using the SKIP LOCKED clause officially introduced in Oracle 11g- we can try to solve the problem incrementally. Let’s see a simple case study:. We have two sessions:. This ses...
August | 2014 | Lczinkoc's Blog
https://sqlplsql.wordpress.com/2014/08
Just another WordPress.com weblog. Archive for August, 2014. How to avoid the persistent state of package’s components? August 4, 2014. Generally the persistent state of package’s component is useful, we don’t want to eliminate it. Persistency means that the lifetime of package components(variables, cursors,exception definitions, etc.). Start with the instatiation of package and finish with the end of session. Let see an example:. Consider the algoritm for the classical “Tower of Hanoi”:. Whe want to run...
January | 2013 | Lczinkoc's Blog
https://sqlplsql.wordpress.com/2013/01
Just another WordPress.com weblog. Archive for January, 2013. Store all consistent states of a table: FLASHBACK ARCHIVE. January 25, 2013. Before Oracle 11g it was great challenge to keep previous consistent states of a table. One of the available method was to store the state (eg. rows of the table) In the UNDO segment. Using the following statements or similar to them:. ALTER SYSTEM SET UNDO RETENTION = 3600; ALTER TABLESPACE UNDOTBS1 RETENTION GUARANTEE ;. Let’s consider the following scenario. ALTER ...
December | 2012 | Lczinkoc's Blog
https://sqlplsql.wordpress.com/2012/12
Just another WordPress.com weblog. Archive for December, 2012. Keep the latest modification’s timestamp for each row. December 19, 2012. It is well known that Oracle stores the latest modification’s timestamp. With SCN (System Change Number) on data block level. Sometimes we want to keep this information on row level. To achieve this feature we can use the ROWDEPENDENCIES clause in the CREATE TABLE statement. With this option Oracle will allocate six bytes for storing the appropriate SCN for each row.
TOTAL PAGES IN THIS WEBSITE
17
magnusjohanssondba.wordpress.com
ORA-02429 running an application upgrade – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/2014/08/22/ora-02429-running-an-application-upgrade
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. ORA-02429 running an application upgrade. I tested an application upgrade (QA) on one off our applications. When we ran the upgrade script, it stopped with the error ORA-02429: cannot drop index used for enforcement of unique/primary key. We checked the index and it was an invisible index created during a tuning session some time ago. Searching for the answer I came across a BUG:. SCOTT@l204 drop index idx tabtes...
magnusjohanssondba.wordpress.com
Files – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/files-2
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. Here I will put scripts, whitepapers and detailed info from blog contents. Information from blog contents:. Detailed output duplicate database 10gr2. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out.
magnusjohanssondba.wordpress.com
Script To Set proxy in Linux – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/2011/01/20/script-to-set-proxy-in-linux
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. Script To Set proxy in Linux. If you are visiting customers that uses a proxy you can create a script and configure it for that customer. When executed it will prompt for user and password. Put the following code in your .bashrc file located in your $HOME catalog. Since the file starts with a . it is not visible. if you do an ls add -a to see it. Edit the file and at the bottom add this:. Enter your comment here.
magnusjohanssondba.wordpress.com
Bulk Collect using LIMIT and %notfound – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/2014/08/07/bulk-collect-using-limit-and-notfound
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. Bulk Collect using LIMIT and %notfound. I have used bulk collect for some time now and it is a great feature that helps. Speeding up processing large amount of data. The LIMIT parameter is useful. Since it reduces memory usage. I have just used the feature deleting 2290266. The delete is really simple, we should delete rows that are older than 3 weeks. The application uses epoch time and my script looks like this.
magnusjohanssondba.wordpress.com
About – magnusjohanssondba
https://magnusjohanssondba.wordpress.com/about
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. My name is Magnus Johansson and I work as a Oracle Database Specialist at Volvo IT, in Gothenburg. I started working for Oracle Support December 2000, I started with general DBA support, moving on to specialized support in Oracle text, tools (exp/imp etc). 2003 to 2005 I worked for Oracle performance tuning support. 2010 to 2012 I worked for an Oracle partner named Kentor. Leave a Reply Cancel reply.
Oracle Business Intelligence: Oracle Junior Professional Program
http://orabusiness.blogspot.com/2009/03/oracle-junior-professional-program.html
Oracle Junior Professional Program. 2009 március 31., kedd by Zoltan Tanczos. Tegnap éjszaka megérkezett a tájékoztató e-mail, miszerint:. Örömmel értesítünk, hogy az előző félévben tett sikeres vizsgád eredményéül feltöltheted adataidat abba az adatbázisba, amelyből partnereink kiválasztják azokat, akiknek munkaszerződést ajánlanak és így részt vehetnek az intenzív nyári képzésen. Végülis, ahhoz képest, hogy legkésőbb január végére ígérték a tájékoztatást, nem is olyan rossz. :). Nem azért írtam, mintha...
Oracle Business Intelligence: március 2009
http://orabusiness.blogspot.com/2009_03_01_archive.html
Oracle Junior Professional Program. 2009 március 31., kedd by Zoltan Tanczos. Tegnap éjszaka megérkezett a tájékoztató e-mail, miszerint:. Örömmel értesítünk, hogy az előző félévben tett sikeres vizsgád eredményéül feltöltheted adataidat abba az adatbázisba, amelyből partnereink kiválasztják azokat, akiknek munkaszerződést ajánlanak és így részt vehetnek az intenzív nyári képzésen. Végülis, ahhoz képest, hogy legkésőbb január végére ígérték a tájékoztatást, nem is olyan rossz. :). Egy fordító általánossá...
Oracle Business Intelligence: Tranzakciókezelés és zárolás SQL Server és Oracle alatt
http://orabusiness.blogspot.com/2009/04/tranzakciokezeles-es-zarolas-sql-server.html
Tranzakciókezelés és zárolás SQL Server és Oracle alatt. 2009 április 23., csütörtök by Zoltan Tanczos. Az SQL Server és az Oracle adatbáziskezelő tranzakció kezelése különbözik egymástól. Arról már írtam egy korábbi bejegyzésben. Hogy egy tranzakció SQL Server alatt (alapértelmezetten) explicit, azaz begin transaction … commit/rollback. Az SQL Server a SELECT. Utasítás hatására egy shared zárat helyez a táblára, míg az Oracle semmilyet se. Gondoljuk végig, hogy ez mit jelent: egy SELECT. Update tran bal...
Oracle Business Intelligence: Oracle 4 prezident :)
http://orabusiness.blogspot.com/2009/04/oracle-4-prezident.html
Oracle 4 prezident :). 2009 április 19., vasárnap by Zoltan Tanczos. Arról számol be, hogy felmerült Füzes Péter, az Oracle Hungary ügyvezető igazgatójának neve lehetséges gazdasági miniszterként. Ennek alátámasztására azt írják, hogy a szakember együtt sportol Bajnai Gordon miniszterelnökkel. :). Feliratkozás: Megjegyzések küldése (Atom). Tranzakciókezelés és zárolás SQL Server és Oracle . Oracle 4 prezident :). Vagyok junior fejlesztő/támogató. A legfrissebb CV-m ezen. A SQL Developer Developer.
Oracle Business Intelligence: április 2009
http://orabusiness.blogspot.com/2009_04_01_archive.html
Tranzakciókezelés és zárolás SQL Server és Oracle alatt. 2009 április 23., csütörtök by Zoltan Tanczos. Az SQL Server és az Oracle adatbáziskezelő tranzakció kezelése különbözik egymástól. Arról már írtam egy korábbi bejegyzésben. Hogy egy tranzakció SQL Server alatt (alapértelmezetten) explicit, azaz begin transaction … commit/rollback. Az SQL Server a SELECT. Utasítás hatására egy shared zárat helyez a táblára, míg az Oracle semmilyet se. Gondoljuk végig, hogy ez mit jelent: egy SELECT. Update tran bal...
TOTAL LINKS TO THIS WEBSITE
51
Domain For Sale
91 988 670 5722. This Domain Is For Sale Only For 199. Contact Seller By E-mail.
SQL Platinum Training - SQL Server Consultants, Support, Trainers & Business Intelligence Specialists
Virtual DBA iPhone / iPad App. Virtual DBA Windows Phone App. More 2012 Events Comming Soon! Microsoft Business Intelligence 2010 Stack. PowerPivot - Excel Reporting and Analysis Essentials. SQL Server Analysis Services Essentials. SQL Server Query Writing Essentials. SQL Server Integration Services Essentials. SQL Server Reporting Services Essentials. SQL Server 2012 First look. SQL Server Administration Essentials. SQL Server Performance Tuning Essentials. SQL Server Clustering Essentials.
Web hosting provider - Justhost.com - domain hosting - PHP Hosting - cheap web hosting - Frontpage Hosting E-Commerce Web Hosting Justhost
Web Hosting from Just Host. Design By Design Fusions.
Lczinkoc's Blog | Just another WordPress.com weblog
Just another WordPress.com weblog. How to avoid the persistent state of package’s components? August 4, 2014. Generally the persistent state of package’s component is useful, we don’t want to eliminate it. Persistency means that the lifetime of package components(variables, cursors,exception definitions, etc.). Start with the instatiation of package and finish with the end of session. Many developers collect, for example, the necessary exception definitions in a particular package and. Let see an example:.
SQL-Plugin (Reporting & Automation Tool)
Keeping Management Update With Business Events. Add more blood to your application. Try SQL-Plugin solution now. SQL-Plugin Services and Features. Dynamic recordset with header footer, allows cell with data modification, row/column totaling, export to file, import from file. The application can also update and insert into database, and may be used to connect multiple database, read from one and write into the other, i.e. data synchronization. Automation - Voucher Printing. Automation - Outstanding Invoice.
sqlplus | *******技术宅男********
技术宅男* * * *. ORACLE实例在启动时，或使用命令ALTER SYSTEM REGISTER ，或每隔一分钟，PMON进程会 [.]. 1、什么是MPM Multi-Processing Module (MPM) implements a hy [.]. 在oracle10g release2之前，不支持异构操作系统上面的oracle oracle版本相同 之间的 [.]. 表格 B-1. 特殊的shell变量 变量 含义 $0 脚本名字 $1 位置参数 #1 $2 – $9 位置参 [.]. 8212;主要的配置文件 AD ip: 10.0.0.0 域名: test.com [root@local [.]. 常用的Linux可插拔认证模块 PAM 应用举例 二. Pam tally.so模块 pam tally.so模块也是在系统中经常使用的一个pam模块。 常用的Linux可插拔认证模块 PAM 应用举例 一. Pam access.so模块 pam access.so模块主要的功能和作用是根据主机名 包括普通主机名或者 [.]. Laquo; Previous Posts.
sqlplus.com
The domain sqlplus.com is for sale. To purchase, call Afternic.com at 1 781-373-6847 or 855-201-2286. Click here for more details.
SRE空间-专业，专注
调试经验 1. 编译包时，如果出现编译错误 PL/SQL developer中包名出现红叉 ，可通过以下语句查看 SELECT name,line, POSITION, text . 1 单个kill mysql show processlist; mysql kill 251; #批量kill 1)查找Lockd语句 mysql -uro. 一 安装node.js 下载地址 https:/ nodejs.org/en/ 安装完成后，cmd执行 npm install -g cordova ，全局安装Cordova。 注意 可能会有点慢，请耐心等待 二 cmd创建Android. 一天一道LeetCode #205. Isomorphic Strings. 一天一道LeetCode 本系列文章已全部上传至我的github，地址 ZeeCoder‘s Github 欢迎大家关注我的新浪微博，我的新浪微博 欢迎转载，转载请注明出处 一 题目 Given two strings s and t, . 置顶] ARMmini2451学习 NAND Flash初始化，块擦除，页读写 2.
www.sqlplus.org - diese Seite empfehlen Karlheinz Salver und Stefan Klug
Wwwsqlplus.org - diese Seite empfehlen Karlheinz Salver und Stefan Klug.
