nios II processor interface with memory

Do you want to share the memory between the Nios CPU and a hardware core you design?

In that case you should design a custom SOPC component in VHDL using an Avalon Memory Mapped Master interface to access the ram. The RAM would be automatically shared between your component and the CPU, and your component would be independent from the type of memory it would access.