Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
V$SQL_SHARED_MEMORY don't return rows

Pavel
Member Posts: 474
Hello!
* 10.2.0.5*
query to V$SQL_SHARED_MEMORY don't return rows
please explain why ?
Regards,
Paul
Edited by: Paul on 22.02.2012 0:22
Edited by: Paul on 22.02.2012 0:23
* 10.2.0.5*
query to V$SQL_SHARED_MEMORY don't return rows
please explain why ?
Regards,
Paul
Edited by: Paul on 22.02.2012 0:22
Edited by: Paul on 22.02.2012 0:23
Answers
-
Aman.... Database Consultant, Author, Trainer World Wide over the WebMember Posts: 22,919 Gold CrownPaul wrote:On a two node RAC , it does for me,
Hello!
* 10.2.0.5*
query to V$SQL_SHARED_MEMORY don't return rows
please explain why ?SQL> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for Linux: Version 11.1.0.6.0 - Production NLSRTL Version 11.1.0.6.0 - Production SQL> select count(*) from V$sql_shared_memory; COUNT(*) ---------- 41979 SQL>
Aman.... -
Hi Aman !
Is it dependent on statistic lavel ?
Best regards,
Paul -
Aman.... Database Consultant, Author, Trainer World Wide over the WebMember Posts: 22,919 Gold CrownIn my db, the value is set to default (TYPICAL) . Are you having anything else set? I don't think that its based on the parameter but I am not sure.
Aman.... -
Thank You Sir!
Whether there is a sense to check MMON, MMNL or MMAN ?
Or not these processes fill the fixed tables for V$SQL_SHARED_MEMORY ?
Best regards,
Paul -
Hello !!
I see the next picture :
select owner,object_name,object_type,status
from dba_objects
where object_name like upper('G%SQL_SHARED_MEMORY%');
1 SYS GV_$SQL_SHARED_MEMORY VIEW VALID
2 PUBLIC GV$SQL_SHARED_MEMORY SYNONYM VALID
here I'm using definition from query You provid:
select /*+use_nl(h,c)*/ count(*)
from x$kglcursor c, x$ksmhp h where ksmchds = kglobhd6 and kglhdadr != kglhdpar;
COUNT(*)
0
SELECT * FROM
(select /*use_nl(h,c)*/ c.inst_id,kglnaobj,kglfnobj, kglnahsh, kglobt03, kglobhd6, rtrim(substr(ksmchcom, 1, instr(ksmchcom, ':', 1, 1) - 1)), ltrim(substr(ksmchcom, -(length(ksmchcom) - (instr(ksmchcom, ':', 1, 1))), (length(ksmchcom) - (instr(ksmchcom, ':', 1, 1)) 1))), ksmchcom, ksmchptr, ksmchsiz, ksmchcls, ksmchtyp, ksmchpar from x$kglcursor c, x$ksmhp h where ksmchds = kglobhd6 and kglhdadr != kglhdpar)
WHERE ROWNUM < 3;
no rows ... WHY?
Is it Bug 3252000 ? -
[email protected]:~$ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 23 20:36:31 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> select count(*) from V$sql_shared_memory; COUNT(*) ---------- 0
-
Hello !
Thank You Sir,
And at the same time I using 10.2.0.5
Regards,
Paul -
Paul wrote:so what have you learned?
Hello !
Thank You Sir,
And at the same time I using 10.2.0.5
Regards,
Paul -
Sorry, I haven't understood your question, Sir
Regards,
Pual -
Paul wrote:my DB returned no rows & I don't see any problem.
Sorry, I haven't understood your question, Sir
What SQL & error code needs to be resolved for you?
This discussion has been closed.