• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

some concepts I don't understand

 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I met some terms during my study of OCA exam and the text book, Introduction to Oracle 9i SQL by Sybex, is not really helpful on explaining them. They are:
1) Index:
What are leading subset columns? How Index is created? how it is accessed? Which dictionary they are stored? Why they work differently on high and low cardinality columns? How they work if appears in Having clause?
2) Physical reads, logical reads? what do they mean?
3) init.ora file.
The only file I can find from my pc is init.ora.8252003155637.
Is this the init.ora file mentioned in the book? But, for example, if I set license_max_sessions = 3 in this file, I still can open more than 3 sessions for one user spontaneously?
Are there anyone has gone through this and want to share your knowledges?
Thanks,
Yingie
 
A wop bop a lu bop a womp bam boom! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!