international-dba.blogspot.com
Andrew's Oracle Blog: April 2011
http://international-dba.blogspot.com/2011_04_01_archive.html
Friday, April 29, 2011. SQL*Plus on UNIX and ps -ef. I was reminded of the following on page 4 of. Oracle 9i, Performance Tuning, Tips and Techniques. By Richard J. Niemiec:. NB the example shown was tested on an Oracle 10 database running on Solaris.). Imagine you have a UNIX user called smithj. He logs into the system. Database user as follows:. SQL*Plus: Release 10.2.0.3.0 - Production on Tue Apr 26 15:13:23 2011. With the Partitioning, OLAP and Data Mining options. Can use the ps. Can see that smithj.
international-dba.blogspot.com
Andrew's Oracle Blog: February 2012
http://international-dba.blogspot.com/2012_02_01_archive.html
Wednesday, February 29, 2012. You can return from SQL*Plus to the operating system using exit. Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production. With the Partitioning, OLAP and Oracle Data Mining options. JServer Release 9.2.0.7.0 - Production. Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production. With the Partitioning, OLAP and Oracle Data Mining options. JServer Release 9.2.0.7.0 - Production. You can also use disconnect. SQL select sysdate from dual.
international-dba.blogspot.com
Andrew's Oracle Blog: December 2011
http://international-dba.blogspot.com/2011_12_01_archive.html
Friday, December 30, 2011. In an earlier post, I looked at the tracefile identifier. Parameter. This post, tested on an Oracle 9 database, uses it in conjunction with trace files public. First create a trace file without setting the trace files public. 1* alter session set tracefile identifier = before. SQL select value from v$parameter. 2 where name = ' trace files public'. SQL alter session set sql trace = true. SQL select sysdate from dual. SQL alter session set sql trace = false. And repeat the test:.
international-dba.blogspot.com
Andrew's Oracle Blog: May 2006
http://international-dba.blogspot.com/2006_05_01_archive.html
No posts. Show all posts. No posts. Show all posts. Subscribe to: Posts (Atom). Connect to me on LinkedIn. Follow me on Twitter. Selecting Maximum and Minimum Values. DDL Causes Implied Commit. Selecting Data at Random from an Oracle Table. How to Delete Duplicate Rows. Finding Your Trace File. Disclaimers * * PLEASE READ * *. 2008 Defender Clutch Replacement - Part 2 - Fault Diagnosis. Mi Blog sobre Oracle. El Privilegio DROP ANY TABLE es Peligroso. Mon Blog au Sujet d'Oracle. Andrew's C and C Blog.
international-dba.blogspot.com
Andrew's Oracle Blog: October 2011
http://international-dba.blogspot.com/2011_10_01_archive.html
Monday, October 31, 2011. This is a hypothetical example and, contrary to what I say below, I have nothing against French or German cars. I wanted to buy a new car so I made up a shortlist of manufacturers and put them in a table:. SQL create table short list. SQL insert into short list values ('BMW'). SQL insert into short list values ('Renault'). SQL insert into short list values ('Subaru'). SQL create table french. SQL insert into french values ('Citroen'). SQL insert into french values ('Renault').
international-dba.blogspot.com
Andrew's Oracle Blog: January 2012
http://international-dba.blogspot.com/2012_01_01_archive.html
Wednesday, January 25, 2012. I restored a database to a remote site today as part of a test. In the screen shot below, I was logged on to the UNIX server as user oracle. I then tried to connect to the restored database using OS authentication. This failed so I connected as SYS. I investigated the cause in a separate session (not shown here). For some reason, the archive area had incorrect permissions (it was owned by root. Could write to it (this is not shown here either). To login to the database as SYS.
international-dba.blogspot.com
Andrew's Oracle Blog: December 2010
http://international-dba.blogspot.com/2010_12_01_archive.html
Friday, December 24, 2010. Finding Your Trace File. This is an example using the. Parameter, which can make it easier to find your tracefiles. First show the value of this parameter, which will normally be null:. SQL col tracefile identifier format a30. SQL select nvl(value, 'NULL') tracefile identifier. 2 from v$parameter where name = 'tracefile identifier'. Now change this parameter:. SQL alter session set tracefile identifier = 'ANDREW'. Start tracing your session and run some SQL:. F irst you need to...
international-dba.blogspot.com
Andrew's Oracle Blog: November 2010
http://international-dba.blogspot.com/2010_11_01_archive.html
No posts. Show all posts. No posts. Show all posts. Subscribe to: Posts (Atom). Connect to me on LinkedIn. Follow me on Twitter. Selecting Maximum and Minimum Values. DDL Causes Implied Commit. Selecting Data at Random from an Oracle Table. How to Delete Duplicate Rows. Finding Your Trace File. Disclaimers * * PLEASE READ * *. 2008 Defender Clutch Replacement - Part 2 - Fault Diagnosis. Mi Blog sobre Oracle. El Privilegio DROP ANY TABLE es Peligroso. Mon Blog au Sujet d'Oracle. Andrew's C and C Blog.
international-dba.blogspot.com
Andrew's Oracle Blog: August 2011
http://international-dba.blogspot.com/2011_08_01_archive.html
Tuesday, August 30, 2011. Tested on an Oracle 9 database. Imagine you have a function call which returns a value as follows:. SQL select sys.login user from dual;. You can see its source code stored in DBA SOURCE:. SQL desc dba source. 1 select text from dba source. 2 where owner = 'SYS'. 3 and name = 'LOGIN USER'. 4* order by line. Function login user return varchar2 is. Return dbms standard.login user;. The TYPE column shows what type of object the source came from. There are several possibilities:.
international-dba.blogspot.com
Andrew's Oracle Blog: June 2011
http://international-dba.blogspot.com/2011_06_01_archive.html
Saturday, June 25, 2011. CONNECT BY PRIOR and ORDER SIBLINGS BY. Tested on an Oracle 9 database. Connect by prior. Was available in Oracle 8. It allows you to show recursive relationships such as managers and their employees or assemblies and their sub assemblies in a top-down fashion. The order by siblings. SQL col Manager format a15. SQL col Employee format a15. SQL create table emp. 2 (ename varchar2(10),. 3 mgr varchar2(10) ;. SQL insert into emp values('Russell','King');. 4 start with mgr = 'King'.
