OraFAQ Forum: Community Hangout » What NEW did you learn today in Orafaq

Home » Other » Community Hangout » What NEW did you learn today in Orafaq

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What NEW did you learn today in Orafaq [message #592513]

Fri, 09 August 2013 04:22

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Folks,

I believe, here in Orafaq, everyone posting/reading/participating learns something NEW everyday. Whenever I learn something new about Oracle, it gives me so much pleasure. I feel like I got a new mission to learn and do more experiment on it. Well, it motivates me like anything. I share it with my friends/colleagues and have lots of discussion. And then I realize nothing could have been better for that day.

If anybody feels they got something new to learn in Orafaq, and if you have spare time, then do share it.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #592529 is a reply to message #592513]

Fri, 09 August 2013 08:05

Flyby
Messages: 188
Registered: March 2011
Location: Belgium

Senior Member

Perhaps because the use of shared server (waiting in queue) instead of dedicated server? Found this reference: high virtual circuit waits after upgrade. Mentions MOSC Note 1225943.1 titled High virtual circuit waits after upgrade

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #592539 is a reply to message #592529]

Fri, 09 August 2013 08:34

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Well, If I am not wrong, and if other folks agree with me, not everything can be trusted what Burleson proves. You might end up believing in incorrect ways to achieve the output. Sometimes, even the output is faked out.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #592543 is a reply to message #592539]

Fri, 09 August 2013 08:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Burleson is correct about 50% of the time; the challenge being knowing which 50% is false.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #592701 is a reply to message #592513]

Sun, 11 August 2013 06:22

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I learnt something new about Data Pump parameters default values

Oracle Lifetime Support

[Updated on: Tue, 11 March 2014 13:44] by Moderator

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #593835 is a reply to message #592701]

Wed, 21 August 2013 05:34

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

That there seems to be a mechanism for 32bit OS/Oracle to use more than 4GB for SGA.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #594913 is a reply to message #593835]

Tue, 03 September 2013 22:02

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Only 2 websites I've been being interested to visit, there are TomKyte and Tanel Porder. Smile

Smile

Only 1 forum I've been being interested to visit, there is OraFaq. Smile

Smile

So, I've been being learnt so much from here, the most important thing is "Do not ask till you could not try any more by your self".

But, the worth important thing is "My English is still bad since near 7 years working as an DBA" Very Happy

Very Happy

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #595386 is a reply to message #594913]

Tue, 10 September 2013 14:25

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Error logging in SQL*Plus

Regards
Michel

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #599874 is a reply to message #595386]

Tue, 29 October 2013 12:49

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Resolving issues with making connection of SQL Developer with Oracle DB when the versions are quite old(last century) SQL Developer version 1.2.1 is able to connect to 8.1.7 with limited functionality

Regards,
Lalit

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #601527 is a reply to message #599874]

Thu, 21 November 2013 16:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

you can turn off the listener log file by doing as below

LSNRCTL> SET LOG_STATUS OFF

I am not sure why this should ever be done; since you never know when the log file content might assist in debugging some future problem.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #603145 is a reply to message #601527]

Wed, 11 December 2013 13:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

new view?

SQL> desc V$DIAG_ALERT_EXT
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ADDR                                               RAW(4)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 ADR_PATH_IDX                                       VARCHAR2(445)
 ADR_HOME                                           VARCHAR2(445)
 ORIGINATING_TIMESTAMP                              TIMESTAMP(9) WITH TIME ZONE
 NORMALIZED_TIMESTAMP                               TIMESTAMP(9) WITH TIME ZONE
 ORGANIZATION_ID                                    VARCHAR2(67)
 COMPONENT_ID                                       VARCHAR2(67)
 HOST_ID                                            VARCHAR2(67)
 HOST_ADDRESS                                       VARCHAR2(49)
 MESSAGE_TYPE                                       NUMBER
 MESSAGE_LEVEL                                      NUMBER
 MESSAGE_ID                                         VARCHAR2(67)
 MESSAGE_GROUP                                      VARCHAR2(67)
 CLIENT_ID                                          VARCHAR2(67)
 MODULE_ID                                          VARCHAR2(67)
 PROCESS_ID                                         VARCHAR2(35)
 THREAD_ID                                          VARCHAR2(67)
 USER_ID                                            VARCHAR2(67)
 INSTANCE_ID                                        VARCHAR2(67)
 DETAILED_LOCATION                                  VARCHAR2(163)
 UPSTREAM_COMP_ID                                   VARCHAR2(103)
 DOWNSTREAM_COMP_ID                                 VARCHAR2(103)
 EXECUTION_CONTEXT_ID                               VARCHAR2(103)
 EXECUTION_CONTEXT_SEQUENCE                         NUMBER
 ERROR_INSTANCE_ID                                  NUMBER
 ERROR_INSTANCE_SEQUENCE                            NUMBER
 MESSAGE_TEXT                                       VARCHAR2(2051)
 MESSAGE_ARGUMENTS                                  VARCHAR2(131)
 SUPPLEMENTAL_ATTRIBUTES                            VARCHAR2(131)
 SUPPLEMENTAL_DETAILS                               VARCHAR2(131)
 PARTITION                                          NUMBER
 RECORD_ID                                          NUMBER
 FILENAME                                           VARCHAR2(515)
 PROBLEM_KEY                                        VARCHAR2(67)
 VERSION                                            NUMBER

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #603294 is a reply to message #603145]

Fri, 13 December 2013 02:51

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

BlackSwan wrote on Wed, 11 December 2013 20:16

new view?

SQL> desc V$DIAG_ALERT_EXT

Trying to select from that view seems to generate a ORA-07445: exception encountered: core dump [__intel_new_memcpy()+52] [SIGSEGV] [ADDR:0x0] [PC:0x40CB644] [SI_KERNEL(general_protection)] [] in the alert log for me. Definitely something new that I learned. Laughing

Laughing

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #603565 is a reply to message #603145]

Tue, 17 December 2013 07:13

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You may be interested by Tanel Poder's article: Reading alert log via SQL

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #603567 is a reply to message #603294]

Tue, 17 December 2013 07:19

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Trying to select from that view seems to generate a ORA-07445: exception encountered: core dump [__intel_new_memcpy()+52] [SIGSEGV] [ADDR:0x0] [PC:0x40CB644] [SI_KERNEL(general_protection)] []

Yes there are many bugs in this view (and other V$DIAG ones) which lead to these errors depending on the query but they are fixed from to time along the patchsets (and the errors don't appear when you directly query the underlying x$ tables).
They are undocumented and expected to be queried only by ADRCI tool.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #606135 is a reply to message #603145]

Mon, 20 January 2014 05:05

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

BlackSwan wrote on Thu, 12 December 2013 00:46

new view?

SQL> desc V$DIAG_ALERT_EXT
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

I wonder where the other columns are? If I do desc on V$DIAG_ALERT_EXT :

SQL> desc V$DIAG_ALERT_EXT;
Name                       Type                        Nullable Default Comments 
-------------------------- --------------------------- -------- ------- -------- 
ADDR                       RAW(8)                      Y                         
INDX                       NUMBER                      Y                         
INST_ID                    NUMBER                      Y                         
ADR_PATH_IDX               VARCHAR2(445)               Y                         
ADR_HOME                   VARCHAR2(445)               Y                         
ORIGINATING_TIMESTAMP      TIMESTAMP(9) WITH TIME ZONE Y                         
NORMALIZED_TIMESTAMP       TIMESTAMP(9) WITH TIME ZONE Y                         
ORGANIZATION_ID            VARCHAR2(67)                Y                         
COMPONENT_ID               VARCHAR2(67)                Y                         
HOST_ID                    VARCHAR2(67)                Y                         
HOST_ADDRESS               VARCHAR2(49)                Y                         
MESSAGE_TYPE               NUMBER                      Y                         
MESSAGE_LEVEL              NUMBER                      Y                         
MESSAGE_ID                 VARCHAR2(67)                Y                         
MESSAGE_GROUP              VARCHAR2(67)                Y                         
CLIENT_ID                  VARCHAR2(67)                Y                         
MODULE_ID                  VARCHAR2(67)                Y                         
PROCESS_ID                 VARCHAR2(35)                Y                         
THREAD_ID                  VARCHAR2(67)                Y                         
USER_ID                    VARCHAR2(67)                Y                         
INSTANCE_ID                VARCHAR2(67)                Y                         
DETAILED_LOCATION          VARCHAR2(163)               Y                         
UPSTREAM_COMP_ID           VARCHAR2(103)               Y                         
DOWNSTREAM_COMP_ID         VARCHAR2(103)               Y                         
EXECUTION_CONTEXT_ID       VARCHAR2(103)               Y                         
EXECUTION_CONTEXT_SEQUENCE NUMBER                      Y                         
ERROR_INSTANCE_ID          NUMBER                      Y                         
ERROR_INSTANCE_SEQUENCE    NUMBER                      Y                         
MESSAGE_TEXT               VARCHAR2(2051)              Y                         
MESSAGE_ARGUMENTS          VARCHAR2(131)               Y                         
SUPPLEMENTAL_ATTRIBUTES    VARCHAR2(131)               Y                         
SUPPLEMENTAL_DETAILS       VARCHAR2(131)               Y                         
PARTITION                  NUMBER                      Y                         
RECORD_ID                  NUMBER                      Y                         
FILENAME                   VARCHAR2(515)               Y                         
PROBLEM_KEY                VARCHAR2(67)                Y                         
VERSION                    NUMBER                      Y

If you want to know my DB version :

SQL> select * from v$version;
 
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE	11.2.0.2.0	Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #609145 is a reply to message #606135]

Mon, 03 March 2014 04:20

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Courtesy of Michel, this is something I learned today:

Quote:

It is DBMS in French (Système de Gestion de Base de Données).

SGBD

Smile

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #609146 is a reply to message #609145]

Mon, 03 March 2014 04:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sounds like LBGT /forum/fa/1599/0/

/forum/fa/1599/0/

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #609150 is a reply to message #609146]

Mon, 03 March 2014 04:30

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Laughing

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #610076 is a reply to message #609150]

Mon, 17 March 2014 06:53

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Courtesy of John Watson:

orclz>
orclz> grant sysdba to rashu;
grant sysdba to rashu
                *
ERROR at line 1:
ORA-01917: user or role 'RASHU' does not exist


orclz> grant sysdba to rashu identified by <password>;

Grant succeeded.

orclz>

Edit: Toned down.

[Updated on: Mon, 17 March 2014 06:57]

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #610113 is a reply to message #610076]

Mon, 17 March 2014 13:12

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Oh dear, Gareth, I shouldn't have posted that: it shows my age. That syntax for creating a user dates back to release 5 I think. Before we had proper roles and privileges.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #612225 is a reply to message #610113]

Mon, 14 April 2014 10:47

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Hats off to Solomon and Michel, you guys put up such rich information sometimes that it brings out something new for lot of folks...

Here is my take for today :

http://www.orafaq.com/forum/mv/msg/192388/612223/#msg_612223

I never thought of using the internal data type conversion as a tool to force and override Oracle for a weird requirement. Often saw the internal conversion only in tkprof output. Really learnt something new today.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #640210 is a reply to message #612225]

Thu, 23 July 2015 10:26

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Row_generator using JSON_TABLE in 12c.

Report message to a moderator

Re: What NEW did you learn today in Orafaq [message #648310 is a reply to message #640210]

Sat, 20 February 2016 01:46

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SYS_CONTEXT new standard namespace introduced in 11.2.0.4: SYS_SESSION_ROLES.

Report message to a moderator

Previous Topic:	Naval Medical Center San Diego
Next Topic:	Thanks for the laughs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 06:01:41 CST 2025